Printable View
Guys, i have a quick question because my brain has decided to take a leave of absense.
I want to modify the starting area for each race (doesnt matter what class). I know how to modify the playercreateinfo table manually, but I cant for the life of me remember how to create the batch statements so I can push it via a single .sql file
could someone shoot me the syntax? Thanks!
(fyi - alliance will start at Southshore, horde at tarren mill - least, thats the idea to start with.)
TIA!
nevermind.. i figured it out. thanks anyway ...
Code:
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-823.018982, positionY=-538.124023, positionZ=15.155654 WHERE race=1;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-823.018982, positionY=-538.124023, positionZ=15.155654 WHERE race=3;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-823.018982, positionY=-538.124023, positionZ=15.155654 WHERE race=4;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-823.018982, positionY=-538.124023, positionZ=15.155654 WHERE race=7;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-823.018982, positionY=-538.124023, positionZ=15.155654 WHERE race=11;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-32.505852, positionY=-930.218323, positionZ=54.393311 WHERE race=2;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-32.505852, positionY=-930.218323, positionZ=54.393311 WHERE race=5;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-32.505852, positionY=-930.218323, positionZ=54.393311 WHERE race=6;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-32.505852, positionY=-930.218323, positionZ=54.393311 WHERE race=8;
UPDATE playercreateinfo SET mapID=0, zoneID=267, positionX=-32.505852, positionY=-930.218323, positionZ=54.393311 WHERE race=10;