How do i make Everyone spawn at the same place?!?!

[evanmur12]

I really need to know how to make everyone spawn in the same place, like all alliance spawn at Stormwind, or all horde spawn at orgrimmar
Spawn as in, each races starting location, so when people make a char they start where i want them to start
Does anyone know how to do this? PLEASE help me

Thanks in advance :wave:

[Mr.Ice.Cold]

In your playercreateinfo table modify mapid, zoneid, PosX, PosY, PozZ to where you want them all to spawn.

[namelessgnome]

To make all players spawn in the same place you need to execute this SQL Query on your world database

UPDATE `playercreateinfo` set mapid=[fillin],zoneid=[fillin], PosX=[fillin], PosY=[fillin], PosZ=[fillin];

In wow type .gps and you should get the coords, replace [filin] with each of the data from the .gps command

[evanmur12]

wow thank you +Rep

[evanmur12]

i did that and it works but the Horde also spawn in the same place, how do i make it so the alliance start in one place and the horde start in another?

[namelessgnome]

ah damn

Alliance

UPDATE `playercreateinfo` set mapid=[fillin],zoneid=[fillin], PosX=[fillin], PosY=[fillin], PosZ=[fillin] WHERE race=1 or race=3 or race=4 or race=7 or race=11;

Horde

UPDATE `playercreateinfo` set mapid=[fillin],zoneid=[fillin], PosX=[fillin], PosY=[fillin], PosZ=[fillin] WHERE race=2 or race=5 or race=6 or race=8 or race=10;

[evanmur12]

Thank you!

[namelessgnome]

Glad to help mate

[evanmur12]

woot my 10th post now i can send messages xD