Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.47 KB | None | 0 0
  1. INSERT INTO `creature` (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES
  2. (100227, 28183, 578, 3, 1, 0, 0, 1242.73267, 1079.592, 439.232849, 6.108652, 120, 0, 0, 1, 0, 0, 0),
  3. (100228, 28183, 578, 3, 1, 0, 0, 1246.566, 1051.25171, 439.232849, 0.5061455, 120, 0, 0, 1, 0, 0, 0),
  4. (100229, 28183, 578, 3, 1, 0, 0, 1265.30212, 1109.22742, 439.232849, 5.18362761, 120, 0, 0, 1, 0, 0, 0),
  5. (100230, 28183, 578, 3, 1, 0, 0, 1277.07471, 1027.78992, 439.232849, 1.37881, 120, 0, 0, 1, 0, 0, 0),
  6. (100231, 28183, 578, 3, 1, 0, 0, 1293.79858, 1113.18054, 439.232849, 4.485496, 120, 0, 0, 1, 0, 0, 0),
  7. (100232, 28183, 578, 3, 1, 0, 0, 1305.63025, 1031.75171, 439.232849, 2.042035, 120, 0, 0, 1, 0, 0, 0),
  8. (100233, 28183, 578, 3, 1, 0, 0, 1324.38538, 1089.79688, 439.232849, 3.59537816, 120, 0, 0, 1, 0, 0, 0),
  9. (100234, 28183, 578, 3, 1, 0, 0, 1328.00171, 1061.15283, 439.232849, 2.8972466, 120, 0, 0, 1, 0, 0, 0);
  10.  
  11.  
  12. SET @GUID := 137731;
  13. DELETE FROM `creature` WHERE `id`=37744;
  14. INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
  15. (@GUID+00,37744,631,15,1,0,0,4135.74658,2781.60156,353.163574,4.729,120,0,0,1,0,0,0,0,0,0),
  16. (@GUID+01,37744,631,15,1,0,0,4156.65100,2781.51831,353.001343,4.729,120,0,0,1,0,0,0,0,0,0),
  17. (@GUID+02,37744,631,15,1,0,0,4159.71300,2735.11279,355.224200,6.248,120,0,0,1,0,0,0,0,0,0),
  18. (@GUID+03,37744,631,15,1,0,0,4159.79900,2804.18848,355.288116,0.017,120,0,0,1,0,0,0,0,0,0),
  19. (@GUID+04,37744,631,15,1,0,0,4160.11200,2788.29419,352.943756,6.260,120,0,0,1,0,0,0,0,0,0),
  20. (@GUID+05,37744,631,15,1,0,0,4183.78467,2751.65723,353.090027,3.124,120,0,0,1,0,0,0,0,0,0),
  21. (@GUID+06,37744,631,15,1,0,0,4192.59700,2733.27954,355.288116,4.712,120,0,0,1,0,0,0,0,0,0),
  22. (@GUID+07,37744,631,15,1,0,0,4193.00700,2829.08423,355.361328,4.694,120,0,0,1,0,0,0,0,0,0),
  23. (@GUID+08,37744,631,15,1,0,0,4201.84900,2750.52612,353.001343,0.017,120,0,0,1,0,0,0,0,0,0),
  24. (@GUID+09,37744,631,15,1,0,0,4224.70557,2804.10864,355.288100,3.140,120,0,0,1,0,0,0,0,0,0),
  25. (@GUID+10,37744,631,15,1,0,0,4224.83500,2735.23600,355.288116,3.140,120,0,0,1,0,0,0,0,0,0),
  26. (@GUID+11,37744,631,15,1,0,0,4225.13800,2788.18848,353.032745,3.141,120,0,0,1,0,0,0,0,0,0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement