API tools faq
paste
casucristy

qwe

casucristy
Jul 18th, 2012
67
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 4.95 KB | None | 0 0
raw download clone embed print report
  1. -- fix quest Making Things Crystal Clear (no object spawn in db)
  2.  
  3. SET @GUID:=700000; --last guid
  4.  
  5. DELETE FROM `gameobject` WHERE `id` = 204296;
  6.  
  7. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  8. (@GUID+0,'204296','646','1','1','1177.85','1375.78','31.7974','0.503228','0','0','0.248967','0.968512','300','0','1'),
  9. (@GUID+1,'204296','646','1','1','1225.03','1356.82','33.9942','5.88713','0','0','0.196734','-0.980457','300','0','1'),
  10. (@GUID+2,'204296','646','1','1','1270.89','1363.13','33.0032','0.279388','0','0','0.13924','0.990259','300','0','1'),
  11. (@GUID+3,'204296','646','1','1','1334.88','1380.08','31.6228','0.212629','0','0','0.106114','0.994354','300','0','1'),
  12. (@GUID+4,'204296','646','1','1','1304.43','1464.65','25.3706','2.75339','0','0','0.981221','0.192885','300','0','1'),
  13. (@GUID+5,'204296','646','1','1','1414.6','1416.61','33.6578','0.0162745','0','0','0.00813714','0.999967','300','0','1'),
  14. (@GUID+6,'204296','646','1','1','1502.56','1365.89','32.9555','5.85571','0','0','0.212113','-0.977245','300','0','1'),
  15. (@GUID+7,'204296','646','1','1','1515.21','1287.7','33.3258','4.85434','0','0','0.655182','-0.755471','300','0','1'),
  16. (@GUID+8,'204296','646','1','1','1530.52','1182.16','43.1788','4.62265','0','0','0.738113','-0.674677','300','0','1'),
  17. (@GUID+9,'204296','646','1','1','1660.85','1208.49','34.9869','1.06086','0','0','0.505906','0.862589','300','0','1'),
  18. (@GUID+10,'204296','646','1','1','1624.41','1235.26','27.6842','3.08641','0','0','0.999619','0.0275898','300','0','1'),
  19. (@GUID+11,'204296','646','1','1','1598.6','1276.78','30.1888','2.78795','0','0','0.984408','0.175899','300','0','1'),
  20. (@GUID+12,'204296','646','1','1','1572.53','1274.72','30.8663','0.577058','0','0','0.284542','0.958664','300','0','1'),
  21. (@GUID+13,'204296','646','1','1','1569.75','1289.07','30.6767','0.0115709','0','0','0.00578543','0.999983','300','0','1'),
  22. (@GUID+14,'204296','646','1','1','1585.1','1298.53','30.3098','0.0115709','0','0','0.00578543','0.999983','300','0','1'),
  23. (@GUID+15,'204296','646','1','1','1544.74','1311.07','28.5031','2.7369','0','0','0.979598','0.200967','300','0','1'),
  24. (@GUID+16,'204296','646','1','1','1434.95','1410.21','31.8025','2.50128','0','0','0.949187','0.314713','300','0','1'),
  25. (@GUID+17,'204296','646','1','1','1411.17','1454.63','30.4','0.522079','0','0','0.258085','0.966122','300','0','1'),
  26. (@GUID+18,'204296','646','1','1','1275.49','1487.71','33.4643','2.39997','0','0','0.932033','0.362373','300','0','1'),
  27. (@GUID+19,'204296','646','1','1','1213.84','1329.08','38.5868','4.81899','0','0','0.668431','-0.743774','300','0','1'),
  28. (@GUID+20,'204296','646','1','1','1205.33','1306.79','40.3885','0.397977','0','0','0.197678','0.980267','300','0','1'),
  29. (@GUID+21,'204296','646','1','1','1218.47','1302.3','39.6577','1.27841','0','0','0.596557','0.802571','300','0','1'),
  30. (@GUID+22,'204296','646','1','1','1156.79','1237.55','53.295','3.66603','0','0','0.965818','-0.259222','300','0','1'),
  31. (@GUID+23,'204296','646','1','1','1158.04','1225.6','55.1271','3.66603','0','0','0.965818','-0.259222','300','0','1'),
  32. (@GUID+24,'204296','646','1','1','1144.79','1208.66','56.4317','2.33478','0','0','0.919728','0.392556','300','0','1'),
  33. (@GUID+25,'204296','646','1','1','1116.71','1215.02','53.3548','0.90535','0','0','0.437373','0.89928','300','0','1'),
  34. (@GUID+26,'204296','646','1','1','1071.79','1376.8','38.3862','2.04025','0','0','0.852174','0.523259','300','0','1'),
  35. (@GUID+27,'204296','646','1','1','1081.19','1386.56','40.2547','2.35127','0','0','0.922934','0.384958','300','0','1'),
  36. (@GUID+28,'204296','646','1','1','1067.6','1419.16','36.4481','4.72238','0','0','0.703565','-0.710631','300','0','1'),
  37. (@GUID+29,'204296','646','1','1','965.689','1405.54','31.4211','4.42472','0','0','0.801162','-0.598448','300','0','1'),
  38. (@GUID+30,'204296','646','1','1','977.787','1367.08','37.6752','5.05539','0','0','0.576056','-0.81741','300','0','1'),
  39. (@GUID+31,'204296','646','1','1','956.519','1305.37','40.7824','5.63581','0','0','0.318064','-0.948069','300','0','1'),
  40. (@GUID+32,'204296','646','1','1','1062.65','1241.6','46.5907','0.0398488','0','0','0.0199231','0.999802','300','0','1'),
  41. (@GUID+33,'204296','646','1','1','1120.94','1243.55','50.7842','6.16596','0','0','0.0585811','-0.998283','300','0','1'),
  42. (@GUID+34,'204296','646','1','1','1205.94','1443.08','38.2838','2.06461','0','0','0.858483','0.512843','300','0','1'),
  43. (@GUID+35,'204296','646','1','1','1224.16','1455.22','36.9793','3.44691','0','0','0.98837','-0.152066','300','0','1'),
  44. (@GUID+36,'204296','646','1','1','1279.6','1514.9','31.7352','3.21129','0','0','0.999393','-0.0348408','300','0','1'),
  45. (@GUID+37,'204296','646','1','1','1329.32','1559.56','27.0039','1.03181','0','0','0.493321','0.869847','300','0','1'),
  46. (@GUID+38,'204296','646','1','1','1349.28','1400.83','30.1175','5.15438','0','0','0.534911','-0.844909','300','0','1');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!