[BEGINNER GUIDE] Change Starter Area

Etox

Gamer | Noob
Divine
Etox Rep
4
0
0
Rep
4
Etox Vouches
0
0
0
Vouches
0
Posts
198
Likes
166
3 YEARS
3 YEARS OF SERVICE
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';

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);
 
Liked By 4 members :

3,571

1,285

9,621

433

Top