PDA

View Full Version : Starting Area SQL - MaNGOS/Trinity/SkyFire



Wise
21-02-12, 12:48 PM
SkyFire



UPDATE `playercreateinfo` SET `map`='MAP A', `zone`='ZONE A', `position_x`='X A', `position_y`='Y A', `position_z`='Z A', `orientation`='O A' WHERE `race` IN (1,3,4,7,11,22);
UPDATE `playercreateinfo` SET `map`='MAP H', `zone`='ZONE H', `position_x`='X H', `position_y`='Y H', `position_z`='Z H', `orientation`='O H' WHERE `race` IN (2,5,6,8,9,10);


MaNGOS/Trinity 3.3.5


UPDATE `playercreateinfo` SET `map`='MAP A', `zone`='ZONE A', `position_x`='X A', `position_y`='Y A', `position_z`='Z A', `orientation`='O A' WHERE `race` IN (1,3,4,7,11);
UPDATE `playercreateinfo` SET `map`='MAP H', `zone`='ZONE H', `position_x`='X H', `position_y`='Y H', `position_z`='Z H', `orientation`='O H' WHERE `race` IN (2,5,6,8,10);

Mallbora
21-02-12, 01:02 PM
lol thanks ;)