Ok guys first off Open the SQL that your using and open
Playercreateinfo
it should pop up with a few columms don't touch anything until MapID
[ A list of what race number they are
1. Human
2. Orc
3. Dwarf
4. Night Elf
5. Undead
6. Tauren
7.Gnome
8.Troll
(9 is no one dunno why it isnt anything so yeah)
10. Draenei
11. Bloodelf (note they won't be in a particular order)
Ok now u know which ones you want to change
Login to your server and go to the area you want everyone to spawn.
Ill use alliance and i want them to spawn out side ironforge.
MapID:
Kalimador - 1
Eastern Kingdoms - 0
Outland - It's 530.
And for BGs,
WSG - 489
AB - 529
AV - 30
EoTS - 566
Go to The area (ironforge for me) and use the command .gps
And write down the X: Y: and Z: co-ords
Now go to
Playercreateinfo in MYSQL
and change the Alliance which is the number race i put up before to the .gps you put down
in my case
MapID = 0
X: -5109.31
Y: -822.422
Z: 497.56
Do that for everyone race/faction you want to spawn in that area
Remember make sure you check the race number!
If you need a specific class i don't know the full list atm will update
Thats all hope it helped may take awhile.