Advertisement
Erictemponi

Playercreateinfo

Dec 26th, 2015
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.77 KB | None | 0 0
  1. Horde:
  2. SET
  3. @map := '1',
  4. @zone := '1637',
  5. @x := '1433.125122',
  6. @y := '-4396.173340',
  7. @z := '25.462812',
  8. @o := '0.125611';
  9. 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);
  10.  
  11.  
  12. Alliance:
  13. SET
  14. @map := '0',
  15. @zone := '1519',
  16. @x := '-8925.174805',
  17. @y := '544.074707',
  18. @z := '94.262558',
  19. @o := '3.837013';
  20. 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);
  21.  
  22.  
  23. ALL:
  24. SET
  25. @map := 'Map ID',
  26. @zone := 'Zone ID',
  27. @x := 'x-Coord',
  28. @y := 'y-Coord',
  29. @z := 'z-Coord',
  30. @o := 'Orientation';
  31. UPDATE playercreateinfo SET map=@map, zone=@zone, position_x=@x, position_y=@y, position_z=@z, orientation=@o;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement