Etox
Gamer | NoobDivine
LEVEL 5
70 XP
Hello, heres a beginners guide on how to change start (spawn) area for all your races.
So what you want to do is go into your server, write ".gps" without the quotes, get the coords, then type the cords into the SQL and run them in your world database.
HORDE
SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X-Cordinate',
@Y := 'Y-Cordinate',
@Z := 'Z-Cordinate',
@O := 'Orientation';
ALLIANCE
SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X-Cordinate',
@Y := 'Y-Cordinate',
@Z := 'Z-Cordinate',
@O := 'Orientation';
So what you want to do is go into your server, write ".gps" without the quotes, get the coords, then type the cords into the SQL and run them in your world database.
HORDE
SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X-Cordinate',
@Y := 'Y-Cordinate',
@Z := 'Z-Cordinate',
@O := 'Orientation';
UPDATE playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O WHERE race IN(2, 5, 6, 8, 10);
ALLIANCE
SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X-Cordinate',
@Y := 'Y-Cordinate',
@Z := 'Z-Cordinate',
@O := 'Orientation';
UPDATE playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O WHERE race IN(1, 3, 4, 7, 11);