[TrinityCore]How to change starting area

[Etox]

Hello, got some small SQL's here to change your start location.

So what you want to do is go into your server, write ".gps" without the quotes, get the coords, then type in the cords into the SQL and run them in your world database.

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);

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);

Hope this helped, let me know what you think c:

 

[ExO]

Thanks for sharing!

 

[Cors1978]

Thanks

 

[kncould]

great

 

[sa3ed]

Very Nice

 

[thyrox]

thank you!!

 

[quallitysk]

Thank !

 

[ceres66]

Thanks!

 

[Eplixsqt]

Great it worked for me!

 

[mrhdaya]

tyy

 

[RileyN]

Thanks, this worked

 

[wowbug]

Thank you.

 

[Primed]

Thanks for sharing!

 

[nzbk92]

Thank you !

 

[olegan1988]

I knew it, but thanks anyway, for someone it will be useful..

 

[Giuseppe360]

thanks