[Guide] Alterac Valley

[Zerger1]

Well, I've recently learned that, although AV is not working on Ascent (no mobs) it makes an AWESOME mall or custom starting location. This is a guide show you how to get in AV and how to make character spawn there when they start. (Sorry if this is a repost but I've searched multiple times.)

Step 1:
Go into Navicat or SQLyog. Go to your database tables and open up the table called "worldmap_info".

Step 2:
Inside this table you will find a list of places. Find the row with an entry # of 30. This is Alterac Valley. Now, edit maxplayers to "0". Edit minlevel to "1". And at the end, edit flags to "3".

Step 3:
Now, type in the command:

.worldport 30 650 -35 61

I would put on fly mode before you do this, just to be safe. Congrats! You're now in Alterac Valley!

Step 4:
This is for making characters start here only. If you do not want to do this, you are finished.

Go to the location you would like players to start from. Type in the command:

.gps

This tells you your x, y, and z location.

Step 5:
Go into Navicat or SQLyog again. Open up your tables and find a table called "playercreateinfo". Open this table and edit the "mapID" in the colums you want to change to this spawn point to "30". Now, edit "postitionX", "positionY", and "positionZ" to what the gps command gave to you.

Step 6:
Restart your server and now all players you create will start at that point!

Some helpful definitions in playercreateinfo. This allows you to choose what race and classes start where.

Races:
1 = Human 
2 = Orc 
3 = Dwarf 
4 = Night Elf 
5 = Undead 
6 = Tauren 
7 = Gnome 
8 = Troll 
10 = Blood Elf 
11 = Draenei 

Classes:
1=Warrior
2=Paladin
3=Hunter
4=Rogue
5=Priest
7=Shaman
8=Mage
9=Warlock
11=Druid

[runiker]

very nice i dont need it but it was a nice guide +rep

[dcarz]

Hay i know all that but one thing, are all races i mean aliacnce and horde are friendly ?
if someone answers
+rep, sorry for the noob question.

lol

[Zerger1]

as in alliance vs horde? then no, you are still hostile....dunno about being flagged or not. If making malls or start points I suggest creating guards for each side.

[Hellgawd]

Nice guide, +3rep. =]
I need some help though, before I give the reputation, if you can help.
I recently emptied out AV (On my server it was fully spawned ) And was planning on making it a starting zone.
When making the player creation starting zone in AV, when players made characters they ended up in Shattrath with an error message saying "Instance not Available".
I did all of the above, except, The flags of the area I set to 1.
Any help ? Thanks,
Hell.

[jokerjokes]

Um i think you need to open it up or something try adding this quary. Not sure lol.

REPLACE INTO `worldmap_info` VALUES ('30', '30', '2', '80', '1', '628.53', '-207.67', '39.0523', '0', 'Alterac Valley', '3', '0', '0', '0', '0', '0', '0', '80', '0');

[dcarz]

Well if creating guards of each side in the same mall, i think it would be a mess, lol... and you still not answered to my question,

Can horde and alliance be friends in only one instance?
If they can what should i do, if i have a shopping mall in azeroth, (for horde) in
The Tainted Scar... How to make that they could be there neutral...?

For the answer +2rep...

And need the answer quickly an good that would help...

[dcarz]

PLZ need an answer wery quickly....

Very quickly!!!

Because im going to a holiday and theres no Internet...

Srry for spammyng but need to post , post and post!..

lol

[Zerger1]

Well if creating guards of each side in the same mall, i think it would be a mess, lol... and you still not answered to my question,

Can horde and alliance be friends in only one instance?
If they can what should i do, if i have a shopping mall in azeroth, (for horde) in
The Tainted Scar... How to make that they could be there neutral...?

For the answer +2rep...

And need the answer quickly an good that would help...

Not sure I'm clear what you're asking, but to my knowledge there in no was to make it a non-hostile zone for both factions. If there is a way, you might want to pick apart the code for Shattrath City and see what keeps that neutral.

Nice guide, +3rep. =]
I need some help though, before I give the reputation, if you can help.
I recently emptied out AV (On my server it was fully spawned ) And was planning on making it a starting zone.
When making the player creation starting zone in AV, when players made characters they ended up in Shattrath with an error message saying "Instance not Available".
I did all of the above, except, The flags of the area I set to 1.
Any help ? Thanks,
Hell.

Set your flags to "3". This makes AV an accessable instance to players aswell.

[Zerger1]

If you need any further help just post here or send me a PM.

[colincancer]

when i do the port it says Aborted instance not found plz help

[Autumnbearbravehunter]

Yeah, I actually custom spawned each mob into AV, Along with setting the scripts, such as taking over a point.. took a while to do all that though.
+Rep anyways for helping others.

[Zerger1]

when i do the port it says Aborted instance not found plz help

Did you edit your "flags" in the "worldmap_info" table? This value should be set to 3.

[colincancer]

yeah i changed the flags, but it still dont work?!?!?! lol

[Lilltimmy]

Before it didnt work, When i tried teh SQL:
REPLACE INTO `worldmap_info` VALUES ('30', '30', '2', '80', '1', '628.53', '-207.67', '39.0523', '0', 'Alterac Valley', '3', '0', '0', '0', '0', '0', '0', '80', '0');
It Worked fine ^-^ Thanks Jokerjokes Keep Jokin' Joker!