[Trinity SQL] Start Location

[Synth]

Hello Emudevs,today i'm going to share you a simple SQL for you can add to player a Start Location.

SQL Info:
●You'll need to do is find out your start location.
●Once you find your location write .gps
●It will show something like this:
GPS Image
●Copy that data and fill out the variables of this SQL File.
●Run the Query to your "World" Database.
●Restart your server.
●You're done :happy (2):


SQL:​

SET
/* Alliance Zone */
@ALLYMAP := 'Alliance Map', /* INT */
@ALLYZONE := 'Alliance Zone', /* FLOAT */
@ALLYX := 'Alliance X Position', /* FLOAT */
@ALLYY := 'Alliance Y Position', /* FLOAT */
@ALLYZ := 'Alliance Z Position', /* FLOAT */
@ALLYO := 'Alliance Orientation', /* FLOAT */
@ALLYNUMS := '1, 3, 4, 7, 11', /* UNK */
/* Horde Zone */
@HORDEMAP := 'Horde Map', /* INT */
@HORDEZONE := 'Horde Zone', /* FLOAT */
@HORDEX := 'Horde X Position', /* FLOAT */
@HORDEY := 'Horde Y Position', /* FLOAT */
@HORDEZ := 'Horde Z Position', /* FLOAT */
@HORDEO := 'Horde Orientation', /* FLOAT */
@HORDENUMS := '2, 5, 6, 8, 10'; /* UNK */

/* Update Alliance Starting Zone */
UPDATE playercreateinfo SET map = @ALLYMAP, zone = @ALLYZONE, position_X = @ALLYX, position_Y = @ALLYY, position_Z = @ALLYZ, orientation = @ALLYO WHERE race IN(@ALLYNUMS);

/* Update Horde Starting Zone */
UPDATE playercreateinfo SET map = @HORDEMAP, zone = @HORDEZONE, position_X = @HORDEX, position_Y = @HORDEY, position_Z = @HORDEZ, orientation = @HORDEO WHERE race IN(@HORDENUMS);

If you find any error or you would ask me about something feel free to ask me.

Thank you!
Best regards,
Synth !

 

[Tommy]

Thanks!

 

[Synth]

Thanks!

No problem :smile: