API tools faq
paste
casucristy

sqas

casucristy
Jul 19th, 2012
60
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 7.15 KB | None | 0 0
raw download clone embed print report
  1. -- script fix for red mist clouds - Support quest A Head Full of Wind
  2. UPDATE `creature_template` SET `InhabitType` = 4, `ScriptName` = "npc_red_mist" WHERE `entry` = 43370;
  3.  
  4. -- quest flags
  5.  
  6. UPDATE `quest_template` SET `QuestFlags` = 0 WHERE `entry` = 26581;
  7.  
  8. -- spawn Mist Clouds --
  9.  
  10. SET @GUID:= 500000; -- last guid
  11.  
  12. DELETE FROM `creature` WHERE `id` = 43370;
  13.  
  14. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
  15.  (@GUID+0,'43370','646','1','1','0','0','1370.55','-724.406','279.196','3.23403','300','0','0','42','0','0','0','0','0'),
  16.  (@GUID+1,'43370','646','1','1','0','0','1373.55','-727.223','279.255','2.73451','300','0','0','42','0','0','0','0','0'),
  17.  (@GUID+2,'43370','646','1','1','0','0','1370.85','-729.338','279.902','1.92241','300','0','0','42','0','0','0','0','0'),
  18.  (@GUID+3,'43370','646','1','1','0','0','1373.37','-733.289','280.444','2.39655','300','0','0','42','0','0','0','0','0'),
  19.  (@GUID+4,'43370','646','1','1','0','0','1444.51','-850.367','281.349','3.23062','300','0','0','42','0','0','0','0','0'),
  20.  (@GUID+5,'43370','646','1','1','0','0','1431.53','-846.22','281.033','2.63371','300','0','0','42','0','0','0','0','0'),
  21.  (@GUID+6,'43370','646','1','1','0','0','1425.26','-839.879','280.736','2.38239','300','0','0','42','0','0','0','0','0'),
  22.  (@GUID+7,'43370','646','1','1','0','0','1414.47','-829.814','280.862','2.38239','300','0','0','42','0','0','0','0','0'),
  23.  (@GUID+8,'43370','646','1','1','0','0','1410.12','-812.528','282.283','1.92293','300','0','0','42','0','0','0','0','0'),
  24.  (@GUID+9,'43370','646','1','1','0','0','1409.22','-798.883','281.744','1.57342','300','0','0','42','0','0','0','0','0'),
  25.  (@GUID+10,'43370','646','1','1','0','0','1413.72','-783.128','282.779','1.2357','300','0','0','42','0','0','0','0','0'),
  26.  (@GUID+11,'43370','646','1','1','0','0','1408.05','-761.692','281.618','1.85223','300','0','0','42','0','0','0','0','0'),
  27.  (@GUID+12,'43370','646','1','1','0','0','1408','-744.402','281.915','1.64803','300','0','0','42','0','0','0','0','0'),
  28.  (@GUID+13,'43370','646','1','1','0','0','1403.92','-732.175','282.214','1.8758','300','0','0','42','0','0','0','0','0'),
  29.  (@GUID+14,'43370','646','1','1','0','0','1408.13','-720.065','281.781','1.42026','300','0','0','42','0','0','0','0','0'),
  30.  (@GUID+15,'43370','646','1','1','0','0','1406.73','-712.12','282.235','2.11141','300','0','0','42','0','0','0','0','0'),
  31.  (@GUID+16,'43370','646','1','1','0','0','1402.99','-703.059','280.862','2.13655','300','0','0','42','0','0','0','0','0'),
  32.  (@GUID+17,'43370','646','1','1','0','0','1394.4','-695.494','280.233','2.55909','300','0','0','42','0','0','0','0','0'),
  33.  (@GUID+18,'43370','646','1','1','0','0','1387.98','-686.956','281.45','2.2253','300','0','0','42','0','0','0','0','0'),
  34.  (@GUID+19,'43370','646','1','1','0','0','1384','-676.822','280.764','1.92292','300','0','0','42','0','0','0','0','0'),
  35.  (@GUID+20,'43370','646','1','1','0','0','1380.77','-665.848','280.189','1.80118','300','0','0','42','0','0','0','0','0'),
  36.  (@GUID+21,'43370','646','1','1','0','0','1379.52','-660.13','281.088','1.80118','300','0','0','42','0','0','0','0','0'),
  37.  (@GUID+22,'43370','646','1','1','0','0','1378.43','-647.239','281.632','1.63625','300','0','0','42','0','0','0','0','0'),
  38.  (@GUID+23,'43370','646','1','1','0','0','1377.32','-637.683','282.299','1.80118','300','0','0','42','0','0','0','0','0'),
  39.  (@GUID+24,'43370','646','1','1','0','0','1372.39','-625.356','280.084','1.97397','300','0','0','42','0','0','0','0','0'),
  40.  (@GUID+25,'43370','646','1','1','0','0','1369.33','-615.647','280.065','1.82867','300','0','0','42','0','0','0','0','0'),
  41.  (@GUID+26,'43370','646','1','1','0','0','1360.49','-586.524','279.058','3.38769','300','0','0','42','0','0','0','0','0'),
  42.  (@GUID+27,'43370','646','1','1','0','0','1351.67','-591.167','280.633','3.67436','300','0','0','42','0','0','0','0','0'),
  43.  (@GUID+28,'43370','646','1','1','0','0','1343.77','-595.679','281.71','3.61545','300','0','0','42','0','0','0','0','0'),
  44.  (@GUID+29,'43370','646','1','1','0','0','1334.49','-601.167','280.846','3.81966','300','0','0','42','0','0','0','0','0'),
  45.  (@GUID+30,'43370','646','1','1','0','0','1334.89','-609.708','279.321','4.8768','300','0','0','42','0','0','0','0','0'),
  46.  (@GUID+31,'43370','646','1','1','0','0','1337.52','-617.882','279.807','5.10063','300','0','0','42','0','0','0','0','0'),
  47.  (@GUID+32,'43370','646','1','1','0','0','1341.75','-624.576','279.906','5.29306','300','0','0','42','0','0','0','0','0'),
  48.  (@GUID+33,'43370','646','1','1','0','0','1346.73','-632.25','280.208','5.16739','300','0','0','42','0','0','0','0','0'),
  49.  (@GUID+34,'43370','646','1','1','0','0','1350.36','-641.383','280.403','4.93963','300','0','0','42','0','0','0','0','0'),
  50.  (@GUID+35,'43370','646','1','1','0','0','1352.34','-651.732','280.232','4.88073','300','0','0','42','0','0','0','0','0'),
  51.  (@GUID+36,'43370','646','1','1','0','0','1352.96','-660.893','280.858','4.78648','300','0','0','42','0','0','0','0','0'),
  52.  (@GUID+37,'43370','646','1','1','0','0','1355.67','-676.997','279.717','4.92393','300','0','0','42','0','0','0','0','0'),
  53.  (@GUID+38,'43370','646','1','1','0','0','1354.01','-689.212','283.166','4.57835','300','0','0','42','0','0','0','0','0'),
  54.  (@GUID+39,'43370','646','1','1','0','0','1364.25','-702.476','279.845','5.45014','300','0','0','42','0','0','0','0','0'),
  55.  (@GUID+40,'43370','646','1','1','0','0','1368.58','-709.533','280.194','5.17525','300','0','0','42','0','0','0','0','0'),
  56.  (@GUID+41,'43370','646','1','1','0','0','1370.5','-718.996','280.078','4.78648','300','0','0','42','0','0','0','0','0'),
  57.  (@GUID+42,'43370','646','1','1','0','0','1373.79','-726.439','279.714','5.24593','300','0','0','42','0','0','0','0','0'),
  58.  (@GUID+43,'43370','646','1','1','0','0','1381.18','-733.919','280.692','5.51689','300','0','0','42','0','0','0','0','0'),
  59.  (@GUID+44,'43370','646','1','1','0','0','1385.43','-741.318','281.359','4.59799','300','0','0','42','0','0','0','0','0'),
  60.  (@GUID+45,'43370','646','1','1','0','0','1380.85','-754.694','281.266','4.2642','300','0','0','42','0','0','0','0','0'),
  61.  (@GUID+46,'43370','646','1','1','0','0','1374.4','-764.398','280.912','4.13854','300','0','0','42','0','0','0','0','0'),
  62.  (@GUID+47,'43370','646','1','1','0','0','1370.49','-778.87','280.576','4.51553','300','0','0','42','0','0','0','0','0'),
  63.  (@GUID+48,'43370','646','1','1','0','0','1371','-789.749','280.08','4.81005','300','0','0','42','0','0','0','0','0'),
  64.  (@GUID+49,'43370','646','1','1','0','0','1373.83','-799.753','279.67','4.99854','300','0','0','42','0','0','0','0','0'),
  65.  (@GUID+50,'43370','646','1','1','0','0','1370.54','-811.365','280.074','4.39772','300','0','0','42','0','0','0','0','0'),
  66.  (@GUID+51,'43370','646','1','1','0','0','1364.59','-815.58','279.833','3.2157','300','0','0','42','0','0','0','0','0'),
  67.  (@GUID+52,'43370','646','1','1','0','0','1350.96','-817.254','279.272','3.78825','300','0','0','42','0','0','0','0','0'),
  68.  (@GUID+53,'43370','646','1','1','0','0','1341.93','-824.818','279.157','4.35217','300','0','0','42','0','0','0','0','0');
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!