Player start place!

[policajac]

Hy all.
How to set starting position of all races and classes in one place.
I made the mall and I am interested in how to put this because I need the server!
Thanks in advance!
I use Mangos!

[Facebook]

This would work for Trinity, but it should work for MaNGOS as well. (Not positive on the DB structure for this table, but it should be the same)

UPDATE playercreateinfo
SET map = MAPID, zone = ZONEID, position_x = POSX, position_y = POSY, position_z = POSZ, orientation = 0
WHERE race > 0;

Obviously replace the all-caps variables with the numbers you would like.
Map, Zone, X, Y, Z coordinates, and orientation (You can change it from 0 if you would like, but the blizz starting locations are all 0)

[Namor]

I'm not too sure about Mangos, but it should be in "playercreateinfo" database table. Or something similar.

Meh. Post above mine is better.

[mastervilaire]

This would work for Trinity, but it should work for MaNGOS as well. (Not positive on the DB structure for this table, but it should be the same)

UPDATE playercreateinfo
SET map = MAPID, zone = ZONEID, position_x = POSX, position_y = POSY, position_z = POSZ, orientation = 0
WHERE race > 0;

Obviously replace the all-caps variables with the numbers you would like.
Map, Zone, X, Y, Z coordinates, and orientation (You can change it from 0 if you would like, but the blizz starting locations are all 0)

Wow, wish I had known about this query before I went ahead and changed everything MANUALLY. Dear god. You're my hero. lool

[Facebook]

I do what I can. <3

[diviee3]

lol i changed everything manually too -___-