Advertisement
bucur35

A Gap in Their Armor

Aug 31st, 2012
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.04 KB | None | 0 0
  1. /**************************
  2.    A Gap in Their Armor
  3. **************************/
  4.  
  5. -- Spawn game objects
  6.  
  7. SET @Object :=xxxxx;
  8.  
  9. DELETE FROM `gameobject` WHERE  `id`=203198 LIMIT 1;
  10. INSERT INTO `gameobject` (`guid`,  `id`,  `map`,  `spawnMask`,  `phaseMask`,  `position_x`,  `position_y`,  `position_z`,  `orientation`,  `spawntimesecs`) VALUES
  11. (@Object+0, 203198, 1, 1, 1, 3620.714600, -2259.360840, 1080.050903, 0, 100),
  12. (@Object+1, 203198, 1, 1, 1, 3603.112793, -2273.824951, 1081.332031, 0, 100),
  13. (@Object+2, 203198, 1, 1, 1, 3638.850830, -2274.411133, 1081.492798, 0, 100),
  14. (@Object+3, 203198, 1, 1, 1, 3643.545410, -2309.063477, 1082.326660, 0, 100),
  15. (@Object+4, 203198, 1, 1, 1, 3635.920654, -2347.427490, 1089.388794, 0, 100),
  16. (@Object+5, 203198, 1, 1, 1, 3601.634766, -2338.467041, 1089.388794, 0, 100),
  17. (@Object+6, 203198, 1, 1, 1, 3937.410400, -2210.487061, 1124.789063, 0, 100),
  18. (@Object+7, 203198, 1, 1, 1, 3974.915771, -2259.339355, 1130.981445, 0, 100);
  19.  
  20. -- Assign
  21.  
  22. UPDATE `gameobject_questrelation` SET `id`=203198, `quest`=25758
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement