3.3.5a - [TrinityCore] How to change starting zone/area

Hello, just a simple "how to" change starting zone/area on trinitycore or trinity based emus.

To get the current coordinates of where you are standing please use .gps when ingame.

Query for Alliance

SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X Coordinates',
@Y := 'Y Coordinates',
@Z := 'Z Coordinates',
@O := 'Orientation Coordinates';

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

Query for Horde

SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X Coordinates',
@Y := 'Y Coordinates',
@Z := 'Z Coordinates',
@O := 'Orientation Coordinates';

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

Click to expand...

Query for both Alliance & Horde

SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X Coordinates',
@Y := 'Y Coordinates',
@Z := 'Z Coordinates',
@O := 'Orientation Coordinates';

UPDATE playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O

Click to expand...

Liked By 2 members :

splicho

demos1bit

3.3.5a [TrinityCore] How to change starting zone/area 2023-01-30

3.3.5a [LIST] Gossip Colors

3.3.5a [Core Mod] [TrinityCore] Required wins for WSG

3,389

1,271

9,555

428