API tools faq
paste
Advertisement
irhas

Deepholm_quests_AMPM(complete)

irhas
May 24th, 2013
399
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 194.19 KB | None | 0 0
raw download clone embed print report
  1. --// DEEPHOLM QUESTS (http://www.wowwiki.com/Deepholm_quests)
  2. -- COMPLETE PROGRESS = 100% (Upper chain 99%,Middle chain 100%, Bottom chain 100%,Master gate chain 100%,Therazane daily 100%)
  3.  
  4. -- CHANGELOG 6/24/2013 23:55
  5. -- Here and there fix.
  6. -- Adding index : @upper, @middle, @bottom, @master, @therazane, @spawn
  7.  
  8.  
  9. ------------------------------------------------------------------------------------------------------
  10. -- @upper
  11. -- // UPPER WORLD PILLAR FRAGMENT CHAIN QUESTS // (http://www.wowhead.com/achievement=4871#comments:id=1628069)
  12. DELETE FROM creature_questrelation WHERE quest IN (27123,26245,26247,26244,27136,26249,26427,26248,26251,26250,26254,26255,26258,26256,26261,26260,27010,27061,26766,26768,26771,26857,26861,26876,28866,26259,28815,28814,27101);
  13. DELETE FROM creature_involvedrelation WHERE quest IN (27123,26245,26246,26247,26244,27136,26247,26249,26427,26248,26251,26250,26254,26255,26258,26256,26261,27007,27010,27061,26766,26768,26771,26857,26861,26876,28866,26259,28815,28814,27100,27102);
  14. INSERT INTO creature_questrelation VALUES
  15. (45042,27123),
  16. (43065,26245),
  17. (43065,26247),
  18. (43397,26244),
  19. (43397,27136),
  20. (42684,26249),
  21. (43082,26427),
  22. (42684,26248),
  23. (42684,26251),
  24. (42684,26250),
  25. (42684,26254),
  26. (42684,26255),
  27. (43065,26258),
  28. (43397,26259),
  29. (43065,26256),
  30. (43065,26261),
  31. (43065,26260),
  32. (43065,27010),
  33. (43065,27061),
  34. (44010,26766),
  35. (44010,26768),
  36. (44010,26771),
  37. (44010,26857),
  38. (44222,26861),
  39. (44010,26876),
  40. (44010,28866),
  41. (50048,28815),
  42. (50048,28814),
  43. (43397,27101);
  44. INSERT INTO creature_involvedrelation VALUES
  45. (43065,27123),
  46. (43065,26245),
  47. (43065,26246),
  48. (42684,26247),
  49. (43397,26244),
  50. (43397,27136),
  51. (43082,26249),
  52. (43082,26427),
  53. (42684,26248),
  54. (42684,26251),
  55. (42684,26250),
  56. (42684,26254),
  57. (43065,26255),
  58. (43065,26258),
  59. (43397,26259),
  60. (43065,26256),
  61. (43065,26261),
  62. (43065,27007),
  63. (43065,27010),
  64. (44010,27061),
  65. (44010,26766),
  66. (44010,26768),
  67. (44010,26771),
  68. (44010,26857),
  69. (44222,26861),
  70. (43065,26876),
  71. (50048,28866),
  72. (50048,28815),
  73. (50048,28814),
  74. (43397,27100),
  75. (43397,27102);
  76. -- No more autoaccept quest in Upper chain quests (kalo di abandon, ga bisa ambil questnya lagi, seems buggy)
  77. UPDATE quest_template SET Flags=128 WHERE id IN (26256,26261,28814,27102);
  78. UPDATE quest_template SET Flags=132 WHERE id=27010;
  79. UPDATE quest_template SET Flags=262272 WHERE id IN (27061,27101,27007);
  80.  
  81. -- The Maelstrom (http://www.wowhead.com/quest=27203)
  82. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27123,ExclusiveGroup=0,NextQuestIdChain=27123 WHERE id=27203;
  83. DELETE FROM spell_target_position WHERE id=84464; -- portal to Maelstrom
  84. INSERT INTO spell_target_position VALUES (84464,730,851.31,1067.76,-10.02,4.50);
  85. UPDATE creature_template SET Health_mod=8485.018336,AIName='SmartAI' WHERE entry=45042;
  86. DELETE FROM creature_template_addon WHERE entry=45042;
  87. INSERT INTO creature_template_addon VALUES (45042,0,0,0,4097,468,NULL); -- casting state.
  88.  
  89. -- Deepholm, Realm of Earth (http://www.wowhead.com/quest=27123)
  90. UPDATE quest_template SET PrevQuestId=27203,NextQuestId=26245,ExclusiveGroup=0,NextQuestIdChain=26245 WHERE id=27123;
  91. DELETE FROM smart_scripts WHERE entryorguid=45042;
  92. insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values(45042,0,0,0,19,0,100,0,27123,0,0,0,11,84515,2,0,0,0,0,7,0,0,0,0,0,0,0,'Thrall - On Quest Accept - Teleport player into Deepholm');
  93. DELETE FROM creature WHERE phaseMask=65535 AND id=45042; --ngehapus spawn double thrall.
  94. UPDATE creature SET modelid=0 WHERE id=45042;
  95.  
  96. -- Gunship Down (http://www.wowhead.com/quest=26245)
  97. UPDATE quest_template SET PrevQuestId=27123,NextQuestId=26247,ExclusiveGroup=-26245,NextQuestIdChain=26247,RequiredNpcOrGo1=43027,RequiredNpcOrGo2=43028,RequiredNpcOrGo3=43029,RequiredNpcOrGoCount1=1,RequiredNpcOrGoCount2=1,RequiredNpcOrGoCount3=1 WHERE id=26245;
  98. UPDATE creature_template SET npcflag=1,AIName='SmartAI' WHERE entry IN (43048,43032,43044);
  99. DELETE FROM smart_scripts WHERE entryorguid IN (43048,43032,43044);
  100. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  101. ('43048','0','0','1','64','0','100','0','0','0','0','0','33','43027','0','0','0','0','0','7','0','0','0','0','0','0','0','Captain Skullshatter - On Gossip Hello - Complete First Clue'),
  102. ('43048','0','1','2','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Captain Skullshatter - On Close gossip - Boss Emote'),
  103. ('43048','0','2','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Captain Skullshatter - On Gossip Hello - Close Gossip'),
  104. ('43032','0','0','1','64','0','100','0','0','0','0','0','33','43028','0','0','0','0','0','7','0','0','0','0','0','0','0','Slain Cannoneer - On Gossip Hello - Complete Second Clue'),
  105. ('43032','0','1','2','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Slain Cannoneer - On Close gossip - Boss Emote'),
  106. ('43032','0','2','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Slain Cannoneer - On Gossip Hello - Close Gossip'),
  107. ('43044','0','0','1','64','0','100','0','0','0','0','0','33','43029','0','0','0','0','0','7','0','0','0','0','0','0','0','Unexploded Artillery Shell - On Gossip Hello - Complete Third Clue'),
  108. ('43044','0','1','2','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Unexploded Artillery Shell - On Close gossip - Boss Emote'),
  109. ('43044','0','2','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Unexploded Artillery Shell - On Gossip Hello - Close Gossip');
  110. DELETE FROM `creature_text` WHERE `entry` IN (43048,43032,43044);
  111. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  112. (43048,0,0,"The Captain's Log lies nearby.",41,0,100,0,0,0,"Captain Skullshatter"),
  113. (43032,0,0,"The cannoneer's hands are black with gunpowder.",41,0,100,0,0,0,"Slain Cannoneer"),
  114. (43044,0,0,'The shell\'s markings read: "STORMWIND ROYAL INDUSTRIES"',41,0,100,0,0,0,"Unexploded Artillery Shell");
  115.  
  116. -- Captain's Log (http://www.wowhead.com/quest=26246)
  117. UPDATE quest_template SET PrevQuestId=27123,NextQuestId=26247,ExclusiveGroup=-26245,NextQuestIdChain=0 WHERE id=26246;
  118. UPDATE gameobject_template SET flags=0 WHERE entry=204274;
  119.  
  120. -- The Earth Claims All (http://www.wowhead.com/quest=26244)
  121. UPDATE quest_template SET PrevQuestId=27123,NextQuestId=26247,ExclusiveGroup=-26245,NextQuestIdChain=0 WHERE id=26244;
  122.  
  123. -- Elemental Energy (http://www.wowhead.com/quest=27136)
  124. UPDATE quest_template SET PrevQuestId=27123,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0,RequiredNpcOrGo1=45091,RequiredNpcOrGoCount1=8 WHERE id=27136;
  125. UPDATE creature_template SET AIName='SmartAI' WHERE entry IN (43254,43258);
  126. UPDATE creature_template SET minlevel=82,maxlevel=83,AIName='SmartAI' WHERE entry=45088;
  127. DELETE FROM smart_scripts WHERE entryorguid IN (43254,43258,45088);
  128. INSERT INTO smart_scripts VALUES
  129. (43254,0,0,0,6,0,100,0,0,0,0,0,33,45091,0,0,0,0,0,7,0,0,0,0,0,0,0,'Elemental Geode - On Death - Give Kill Credit'),
  130. (43258,0,0,0,6,0,100,0,0,0,0,0,33,45091,0,0,0,0,0,7,0,0,0,0,0,0,0,'Lodestone Elemental - On Death - Give Kill Credit'),
  131. (45088,0,0,0,54,0,100,0,0,0,0,0,41,30000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Depleted Totem - On Just Summoned - Despawn after 30 sec'),
  132. (45088,0,1,0,6,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Depleted Totem - On Death - Despawn instantly');
  133. DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry IN (43254,43258);
  134. DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=84169;
  135. INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,COMMENT) VALUES
  136. (22,1,43254,29,0,45088,5,'Kill credit can only be given if Depleted Totem within 5 yd.'),
  137. (22,1,43258,29,0,45088,5,'Kill credit can only be given if Depleted Totem within 5 yd.'),
  138. (17,0,84169,23,0,5291,0,'Depleted Totem can only be casted within Jagged Wastes.');
  139.  
  140. -- Diplomacy First (http://www.wowhead.com/quest=26247)
  141. UPDATE quest_template SET PrevQuestId=0,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26247;
  142.  
  143. -- The Admiral's Cabin (http://www.wowhead.com/quest=26249)
  144. UPDATE quest_template SET PrevQuestId=26247,NextQuestId=26427,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26249;
  145.  
  146. -- Without a Captain or Crew (http://www.wowhead.com/quest=26427)
  147. UPDATE quest_template SET PrevQuestId=26249,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0,Flags=65672,RequiredItemid1=0,RequiredItemid2=0 WHERE id=26427;
  148. DELETE FROM creature WHERE id=43082; -- remove unused NPC spawns.
  149.  
  150. -- All Our Friends Are Dead (http://www.wowhead.com/quest=26248)
  151. UPDATE quest_template SET PrevQuestId=26247,NextQuestId=26251,ExclusiveGroup=0,NextQuestIdChain=26251 WHERE id=26248;
  152. UPDATE creature_template SET AIName='SmartAI',npcflag=1 WHERE entry IN (42682,42681);
  153. UPDATE creature_template SET AIName='SmartAI' WHERE entry IN (42747,42757);
  154. DELETE FROM smart_scripts WHERE entryorguid in (42682,42681,42757,42747);
  155. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  156. ('42682','0','0','1','64','0','100','0','0','0','0','0','33','42758','0','0','0','0','0','7','0','0','0','0','0','0','0','Slain Crew Member - On Gossip Hello - Complete Objective'),
  157. ('42682','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Slain Crew Member - On Gossip Hello - Close Gossip'),
  158. ('42682','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Slain Crew Member - On Close gossip - Set Npcflag None'),
  159. (42682,0,3,0,61,0,100,0,0,0,0,0,12,42757,1,60000,0,0,0,1,0,0,0,0,0,0,0,'Slain Crew Member Spirit spawn'),
  160. (42757,0,4,0,54,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Slain Crew Member Spirit- On Just Summoned- Say text"),
  161. ('42681','0','0','1','64','0','100','0','0','0','0','0','33','42758','0','0','0','0','0','7','0','0','0','0','0','0','0','Slain Crew Member - On Gossip Hello - Complete Objective'),
  162. ('42681','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Slain Crew Member - On Gossip Hello - Close Gossip'),
  163. ('42681','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Slain Crew Member - On Close gossip - Set Npcflag None'),
  164. (42681,0,3,0,61,0,100,0,0,0,0,0,12,42747,1,60000,0,0,0,1,0,0,0,0,0,0,0,'Slain Crew Member Spirit spawn'),
  165. (42747,0,4,0,54,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Slain Crew Member Spirit- On Just Summoned- Say text");
  166. DELETE FROM `creature_text` WHERE `entry` IN (42757,42747);
  167. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  168. (42757,1,1,"I heard them praying to their dark gods as everything went black... the Twilight\'s Hammer did this!",12,0,25,0,0,0,"Slain Crew Member Spirit"),
  169. (42757,1,2,"Everyone started dropping like flies.. everyone who ate the rations.",12,0,25,0,0,0,"Slain Crew Member Spirit"),
  170. (42757,1,3,'They tricked us into ambushing the Horde gunship.. but why?',12,0,25,0,0,0,"Slain Crew Member Spirit"),
  171. (42757,1,4,'They poisoned our supplies... we had cultists onboard all along...',12,0,25,0,0,0,"Slain Crew Member Spirit"),
  172. (42747,1,1,"I heard them praying to their dark gods as everything went black... the Twilight\'s Hammer did this!",12,0,25,0,0,0,"Slain Crew Member Spirit"),
  173. (42747,1,2,"Everyone started dropping like flies.. everyone who ate the rations.",12,0,25,0,0,0,"Slain Crew Member Spirit"),
  174. (42747,1,3,'They tricked us into ambushing the Horde gunship.. but why?',12,0,25,0,0,0,"Slain Crew Member Spirit"),
  175. (42747,1,4,'They poisoned our supplies... we had cultists onboard all along...',12,0,25,0,0,0,"Slain Crew Member Spirit");
  176. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (42682,42681);
  177. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  178. (22,1,42682,0,0,9,0,26248,0,0,0,0,'','Slain Crew Member SAI can only be used if player has quest 26248'),
  179. (22,1,42681,0,0,9,0,26248,0,0,0,0,'','Slain Crew Member SAI can only be used if player has quest 26248');
  180.  
  181. -- Take No Prisoners (http://www.wowhead.com/quest=26251)
  182. UPDATE quest_template SET PrevQuestId=26248,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26251;
  183.  
  184. -- On Second Thought, Take One Prisoner (http://www.wowhead.com/quest=26250)
  185. UPDATE quest_template SET PrevQuestId=26248,NextQuestId=26254,ExclusiveGroup=0,NextQuestIdChain=26254 WHERE id=26250;
  186.  
  187. -- Some Spraining to Do (http://www.wowhead.com/quest=26254)
  188. UPDATE quest_template SET PrevQuestId=26250,NextQuestId=26255,ExclusiveGroup=0,NextQuestIdChain=26255,flags=136,RequiredNpcOrGo1=0,RequiredNpcOrGoCount1=0,ObjectiveText1='' WHERE id=26254;
  189.  
  190. -- Return to the Temple of Earth (http://www.wowhead.com/quest=26255)
  191. UPDATE quest_template SET PrevQuestId=26254,NextQuestId=26258,ExclusiveGroup=0,NextQuestIdChain=26258 WHERE id=26255;
  192.  
  193. -- Deathwing's Fall (http://www.wowhead.com/quest=26258)
  194. UPDATE quest_template SET PrevQuestId=26255,NextQuestId=26256,ExclusiveGroup=0,NextQuestIdChain=26256,Flags=132,SpecialFlags=2,RequiredNpcOrGo1=0,RequiredNpcOrGoCount1=0,EndText='Deathwing\'s Fall reached',ObjectiveText1='Deathwing\'s Fall reached' WHERE id=26258;
  195. DELETE FROM areatrigger_involvedrelation WHERE id=6126;
  196. INSERT INTO areatrigger_involvedrelation VALUES (6126,26258);
  197.  
  198. -- Bleed the Bloodshaper (http://www.wowhead.com/quest=26256)
  199. UPDATE quest_template SET PrevQuestId=26258,NextQuestId=26261,ExclusiveGroup=0,NextQuestIdChain=26261 WHERE id=26256;
  200.  
  201. -- Question the Slaves (http://www.wowhead.com/quest=26261)
  202. UPDATE quest_template SET PrevQuestId=26256,NextQuestId=26260,ExclusiveGroup=0,NextQuestIdChain=26260,RequiredNpcOrGo1=-205098,RequiredNpcOrGoCount1=6 WHERE id=26261;
  203. UPDATE gameobject_template SET data3=3000,data5=1 WHERE entry=205098;
  204.  
  205. -- The Forgemaster's Log (http://www.wowhead.com/quest=26260)
  206. UPDATE quest_template SET PrevQuestId=26261,NextQuestId=27007,ExclusiveGroup=0,NextQuestIdChain=27007 WHERE id=26260;
  207. DELETE FROM gameobject_involvedrelation WHERE quest=26260;
  208. DELETE FROM gameobject_questrelation WHERE quest=27007;
  209. INSERT INTO gameobject_involvedrelation VALUES (205134,26260);
  210. INSERT INTO gameobject_questrelation VALUES (205134,27007);
  211.  
  212. -- Silvermarsh Rendezvous (http://www.wowhead.com/quest=27007)
  213. UPDATE quest_template SET PrevQuestId=26260,NextQuestId=27010,ExclusiveGroup=0,NextQuestIdChain=27010,SpecialFlags=2,RequiredNpcOrGo1=0,RequiredNpcOrGoCount1=0,EndText='',ObjectiveText1='Upper Silvermarsh reached' WHERE id=27007;
  214. DELETE FROM areatrigger_involvedrelation WHERE id=6221;
  215. INSERT INTO areatrigger_involvedrelation VALUES (6221,27007);
  216.  
  217. -- Quicksilver Submersion (http://www.wowhead.com/quest=27010)
  218. UPDATE quest_template SET PrevQuestId=27007,NextQuestId=27061,ExclusiveGroup=0,NextQuestIdChain=27061,RequiredNpcOrGo1=44938,RequiredNpcOrGoCount1=1 WHERE id=27010;
  219. DELETE FROM smart_scripts WHERE entryorguid=6220 AND source_type=2;
  220. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  221. ('6220','2','0','0','46','0','100','0','6220','0','0','0','33','44938','0','0','0','0','0','18','20','0','0','0','0','0','0','Trogg Crate - On Near Areatrigger 6220 - give kill credit');
  222. DELETE FROM areatrigger_scripts WHERE entry=6220 AND ScriptName='SmartTrigger';
  223. INSERT INTO areatrigger_scripts VALUES (6220,'SmartTrigger');
  224. DELETE FROM areatrigger_involvedrelation WHERE id=6220; -- unused
  225. DELETE FROM gameobject_loot_template WHERE entry=32451 AND item=60809; -- entry nya dari gameobject_template value data1
  226. INSERT INTO gameobject_loot_template VALUES (32451,60809,-100,1,0,1,1);
  227. DELETE FROM `conditions` WHERE SourceId=2 AND `SourceEntry`=6220;
  228. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  229. (22,1,6220,2,0,1,0,83699,0,0,0,0,'','Areatrigger 6220 SAI on quest 27010 limitation');
  230.  
  231. -- http://www.wowhead.com/npc=44875/millhouse-manastorm
  232. -- http://www.wowhead.com/npc=44881/high priestess azil
  233.  
  234. -- The Twilight Overlook (http://www.wowhead.com/quest=27061)
  235. UPDATE quest_template SET PrevQuestId=27010,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=27061;
  236.  
  237. -- Big Game, Big Bait (http://www.wowhead.com/quest=26766)
  238. UPDATE quest_template SET PrevQuestId=27061,NextQuestId=26771,ExclusiveGroup=-26766,NextQuestIdChain=26771 WHERE id=26766;
  239. DELETE FROM conditions WHERE SourceEntry=82563;
  240. INSERT INTO conditions (SourceTypeOrReferenceId,SourceEntry,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,NegativeCondition,COMMENT) VALUES
  241. (17,82563,31,1,3,43981,0,'Knife can only be casted to Jadecrest Basilisk'),
  242. (17,82563,36,1,0,0,1,'Knife can only be casted on dead state creature');
  243. DELETE FROM smart_scripts WHERE entryorguid=43981;
  244. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  245. ('43981','0','0','0','8','0','100','0','82563','0','0','0','56','60297','1','0','0','0','0','7','0','0','0','0','0','0','0','Jadecrest Basilisk - On Event Spellhit - additem Side of basilisk meat'),
  246. ('43981','0','1','0','8','0','100','0','82563','0','0','0','41','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Jadecrest Basilisk - On Event Spellhit - force despawn'),
  247. ('43981','0','2','0','8','0','100','0','82563','0','0','0','12','44138','3','10000','0','0','0','1','0','0','0','0','0','0','0','Jadecrest Basilisk - On Event Spellhit - summon 44138');
  248. UPDATE creature_template SET minlevel=81,maxlevel=82,faction_A=16,faction_H=16,unit_flags=768,dynamicflags=32 WHERE entry=44138;
  249. UPDATE creature_template SET AIName='SmartAI' WHERE entry=43981;
  250.  
  251. -- To Catch a Dragon (http://www.wowhead.com/quest=26768)
  252. UPDATE quest_template SET PrevQuestId=27061,NextQuestId=26771,ExclusiveGroup=-26766,NextQuestIdChain=26771 WHERE id=26768;
  253.  
  254. -- Testing the Trap (http://www.wowhead.com/quest=26771)
  255. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26857,ExclusiveGroup=0,NextQuestIdChain=26857 WHERE id=26771;
  256.  
  257. -- Abyssion's Minions (http://www.wowhead.com/quest=26857)
  258. UPDATE quest_template SET PrevQuestId=26771,NextQuestId=26876,ExclusiveGroup=-26857,NextQuestIdChain=26876 WHERE id=26857;
  259.  
  260. -- Block the Gates (http://www.wowhead.com/quest=26861)
  261. UPDATE quest_template SET PrevQuestId=26771,NextQuestId=26876,ExclusiveGroup=-26857,NextQuestIdChain=0 WHERE id=26861;
  262. UPDATE creature_template SET modelid1=33593,faction_A=16,faction_H=16,unit_flags=0 WHERE entry IN (44930,44931);
  263.  
  264. -- The World Pillar Fragment (http://www.wowhead.com/quest=26876) pillarnya masih ngebug, bisa di klik kalo player nya terbang (GM/cheater)
  265. UPDATE quest_template SET PrevQuestId=26857,NextQuestId=26326,ExclusiveGroup=-27938,NextQuestIdChain=0 WHERE id=26876;
  266. UPDATE creature_template SET unit_flags=0,AIName='SmartAI' WHERE entry=44289;
  267. UPDATE creature SET spawntimesecs=120 WHERE id=44289;
  268. --UPDATE gameobject_template SET AIName='SmartGameObjectAI' WHERE entry=204967;
  269. DELETE FROM smart_scripts WHERE entryorguid=44289;
  270. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  271. --('44289','0','1','2','6','0','100','0','0','0','0','0','50','204967','60','0','0','0','0','1','0','0','0','0','0','0','0','Abyssion - On Death - Summon Upper world pillar object'),
  272. ('44289','0','0','0','6','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Abyssion - On Death - Boss emote');
  273. --('44289','0','3','4','61','0','100','0','0','0','0','0','41','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Abyssion - On Death - Force despawn'),
  274. --('44289','0','4','0','61','0','100','0','0','0','0','0','80','204967','0','0','0','0','0','1','0','0','0','0','0','0','0','Abyssion - On Death - event link'),
  275. --('204967','1','0','0','54','0','100','0','0','0','0','0','99','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Pillar - On just summoned - set loot state');
  276. DELETE FROM `creature_text` WHERE `entry`=44289; -- after death text
  277. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  278. (44289,0,0,"The First World Pillar Fragment drops from Abyssion\'s lifeless corpse!",41,0,100,0,0,0,"Abyssion");
  279. --DELETE FROM gameobject_loot_template WHERE entry=31490; -- masih kosong isinya, entry nya diambil dari sniff.
  280. --insert into `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('31490','60574','-100','1','0','1','1');
  281.  
  282. -- Into the Stonecore (http://www.wowhead.com/quest=28866)
  283. UPDATE quest_template SET PrevQuestId=27061,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=28866;
  284.  
  285. -- Twilight Research (http://www.wowhead.com/quest=27100)
  286. UPDATE quest_template SET PrevQuestId=26255,NextQuestId=27101,ExclusiveGroup=0,NextQuestIdChain=27101,flags=0 WHERE id=27100;
  287.  
  288. -- Maziel's Revelation (http://www.wowhead.com/quest=27101)
  289. UPDATE quest_template SET PrevQuestId=27100,NextQuestId=27102,ExclusiveGroup=0,NextQuestIdChain=27102 WHERE id=27101;
  290. UPDATE gameobject_template SET flags=0 WHERE entry=205207;
  291.  
  292. -- Maziel's Ascendancy (http://www.wowhead.com/quest=27102)
  293. UPDATE quest_template SET PrevQuestId=27101,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=27102;
  294.  
  295. ------------------------------------------------------------------------------------------------------
  296. -- @middle
  297. -- // MIDDLE WORLD PILLAR FRAGMENT CHAIN QUESTS // (http://www.wowhead.com/achievement=4871#comments:id=1628070)
  298. DELETE FROM creature_questrelation WHERE quest IN (26409,27135,26410,26411,26413,26484,27931,27933,27932,27934,27935,27936,26500,26502,26499,26501,26564,26591,26537,26625,27126,26632,26755,26770,26762,26834,26791,26792,26835,26836,27937,27938);
  299. DELETE FROM creature_involvedrelation WHERE quest IN (26409,27135,26410,26411,26413,26484,27931,27933,27932,27934,27935,27936,26500,26502,26499,26501,26564,26591,26537,26625,27126,26632,26755,26770,26762,26834,26791,26792,26835,26836,27937,27938);
  300. INSERT INTO creature_questrelation VALUES
  301. (42573,26409),
  302. (42574,27135),
  303. (42574,26410),
  304. (42574,26411),
  305. (42574,26413),
  306. (42573,26484),
  307. (43071,27931),
  308. (47195,27933),
  309. (47195,27932),
  310. (47195,27934),
  311. (47195,27935),
  312. (47195,27936),
  313. (43160,26500),
  314. (43160,26502),
  315. (43071,26499),
  316. (43071,26501),
  317. (43169,26564),
  318. (43319,26591),
  319. (43168,26537),
  320. (43168,26625),
  321. (43169,27126),
  322. (45043,26632),
  323. (43897,26755),
  324. (43898,26770),
  325. (43897,26762),
  326. (43897,26834),
  327. (44143,26791),
  328. (44143,26792),
  329. (44143,26835),
  330. (43897,26836),
  331. (43897,27937),
  332. (44204,27938);
  333. INSERT INTO creature_involvedrelation VALUES
  334. (42574,26409),
  335. (42574,27135),
  336. (42574,26410),
  337. (42574,26411),
  338. (42573,26413),
  339. (43071,26484),
  340. (47195,27931),
  341. (47195,27933),
  342. (47195,27932),
  343. (47195,27934),
  344. (43071,27935),
  345. (43071,27936),
  346. (43160,26500),
  347. (43169,26502),
  348. (43071,26499),
  349. (43168,26501),
  350. (43169,26564),
  351. (43319,26591),
  352. (43168,26537),
  353. (43168,26625),
  354. (45043,27126),
  355. (43897,26632),
  356. (43897,26755),
  357. (43898,26770),
  358. (43897,26762),
  359. (44143,26834),
  360. (44143,26791),
  361. (44143,26792),
  362. (43897,26835),
  363. (43897,26836),
  364. (44204,27937),
  365. (42573,27938);
  366.  
  367. -- Where's Goldmine? (http://www.wowhead.com/quest=26409)
  368. UPDATE quest_template SET PrevQuestId=0,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26409;
  369.  
  370. -- Something that Burns (http://www.wowhead.com/quest=27135)
  371. UPDATE quest_template SET PrevQuestId=26409,NextQuestId=26411,ExclusiveGroup=-27135,NextQuestIdChain=0 WHERE id=27135;
  372.  
  373. -- Explosive Bonding Compound (http://www.wowhead.com/quest=26410)
  374. UPDATE quest_template SET PrevQuestId=26409,NextQuestId=26411,ExclusiveGroup=-27135,NextQuestIdChain=0 WHERE id=26410;
  375.  
  376. -- Apply and Flash Dry (http://www.wowhead.com/quest=26411)
  377. UPDATE quest_template SET PrevQuestId=26410,NextQuestId=26413,ExclusiveGroup=0,NextQuestIdChain=26413,RequiredSpellCast1=80413 WHERE id=26411;
  378. UPDATE creature_template SET unit_flags2=2049 WHERE entry=43036;
  379.  
  380. -- Take Him to the Earthcaller (http://www.wowhead.com/quest=26413)
  381. UPDATE quest_template SET PrevQuestId=26411,NextQuestId=26484,ExclusiveGroup=0,NextQuestIdChain=26484,SpecialFlags=0,RequiredNpcOrGo1=44207,RequiredNpcOrGoCount1=1 WHERE id=26413;
  382. DELETE FROM areatrigger_involvedrelation WHERE id=6217; --unused
  383. DELETE FROM smart_scripts WHERE entryorguid IN (42574,43047);
  384. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  385. (42574,0,0,0,19,0,100,0,26413,0,0,0,85,80441,0,0,0,0,0,7,0,0,0,0,0,0,0,'Initiate Goldmine - On Quest Accept - Summon Flint Oremantle'), -- Initiate Goldmine
  386. (43047,0,0,1,54,0,100,0,0,0,0,0,29,0,0,44207,0,0,0,7,0,0,0,0,0,0,0,"Flint Oremantle - On Just Summoned - Follow player"), -- Flint Oremantle
  387. (43047,0,1,0,61,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Flint Oremantle - On Link 1 - Say text"),
  388. (43047,0,2,3,65,0,100,0,0,0,0,0,33,44207,0,0,0,0,0,18,10,0,0,0,0,0,0,"Flint Oremantle - On Follow Complete - Escort Kill Credit"),
  389. (43047,0,3,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Flint Oremantle - On Link 2 - Force Despawn");
  390. UPDATE creature_template SET minlevel=83,maxlevel=83,AIName='SmartAI' WHERE entry=43047;
  391. UPDATE creature_template SET AIName='SmartAI' WHERE entry=42574;
  392. DELETE FROM `creature_text` WHERE `entry`=43047;
  393. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  394. (43047,0,0,"I am ready to meet with your so-called Earthcaller.",12,0,100,0,0,0,"Flint Oremantle");
  395.  
  396. -- To Stonehearth's Aid (http://www.wowhead.com/quest=26484)
  397. UPDATE quest_template SET PrevQuestId=26413,NextQuestId=27931,ExclusiveGroup=0,NextQuestIdChain=27931 WHERE id=26484;
  398.  
  399. -- The Quaking Fields (http://www.wowhead.com/quest=27931)
  400. UPDATE quest_template SET PrevQuestId=26484,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=27931;
  401.  
  402. -- Elemental Ore (http://www.wowhead.com/quest=27933)
  403. UPDATE quest_template SET PrevQuestId=27931,NextQuestId=27934,ExclusiveGroup=-27933,NextQuestIdChain=0 WHERE id=27933;
  404.  
  405. -- The Axe of Earthly Sundering (http://www.wowhead.com/quest=27932)
  406. UPDATE quest_template SET PrevQuestId=27931,NextQuestId=27934,ExclusiveGroup=-27933,NextQuestIdChain=0 WHERE id=27932;
  407.  
  408. -- One With the Ground (http://www.wowhead.com/quest=27934)
  409. UPDATE quest_template SET PrevQuestId=0,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=27936 WHERE id=27934;
  410.  
  411. -- Bring Down the Avalanche (http://www.wowhead.com/quest=27936&27935)
  412. UPDATE quest_template SET PrevQuestId=27934,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=27936;
  413. UPDATE quest_template SET PrevQuestId=27934,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0,Flags=136 WHERE id=27935;
  414.  
  415. -- We're Surrounded (http://www.wowhead.com/quest=26500)
  416. UPDATE quest_template SET PrevQuestId=27936,NextQuestId=26502,ExclusiveGroup=0,NextQuestIdChain=26502 WHERE id=26500;
  417.  
  418. -- Thunder Stones (http://www.wowhead.com/quest=26502)
  419. UPDATE quest_template SET PrevQuestId=26500,NextQuestId=26591,ExclusiveGroup=-26501,NextQuestIdChain=26564 WHERE id=26502;
  420.  
  421. -- Stonefather's Boon (http://www.wowhead.com/quest=26499)
  422. UPDATE quest_template SET PrevQuestId=27936,NextQuestId=26501,ExclusiveGroup=0,NextQuestIdChain=26501,RequiredSpellCast1=80670 WHERE id=26499;
  423.  
  424. -- Sealing the Way (http://www.wowhead.com/quest=26501)
  425. UPDATE quest_template SET PrevQuestId=26499,NextQuestId=26591,ExclusiveGroup=-26501,NextQuestIdChain=26537 WHERE id=26501;
  426. UPDATE creature_template SET npcflag=1,AIName='SmartAI',modelid1=26091 WHERE entry IN (43164,43165,43166,43167);
  427. DELETE FROM smart_scripts WHERE entryorguid IN (43164,43165,43166,43167);
  428. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  429. ('43164','0','0','1','64','0','100','0','0','0','0','0','33','43164','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 01 Kill Credit - On Gossip Hello - Complete Objective 1'),
  430. ('43164','0','1','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 01 Kill Credit - On Gossip Hello - Close Gossip'),
  431. ('43165','0','0','1','64','0','100','0','0','0','0','0','33','43165','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 02 Kill Credit - On Gossip Hello - Complete Objective 2'),
  432. ('43165','0','1','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 02 Kill Credit - On Gossip Hello - Close Gossip'),
  433. ('43166','0','0','1','64','0','100','0','0','0','0','0','33','43166','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 03 Kill Credit - On Gossip Hello - Complete Objective 3'),
  434. ('43166','0','1','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 03 Kill Credit - On Gossip Hello - Close Gossip'),
  435. ('43167','0','0','1','64','0','100','0','0','0','0','0','33','43167','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 04 Kill Credit - On Gossip Hello - Complete Objective 4'),
  436. ('43167','0','1','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Sealing the Way 04 Kill Credit - On Gossip Hello - Close Gossip');
  437.  
  438. -- Fixer Upper (http://www.wowhead.com/quest=26564)
  439. UPDATE quest_template SET PrevQuestId=26502,NextQuestId=26625,ExclusiveGroup=-26537,NextQuestIdChain=0,RequiredNpcOrGo1=0,RequiredNpcOrGoCount1=0 WHERE id=26564;
  440. UPDATE gameobject_template SET questItem1=58944,data0=43,data1=30897 WHERE name='Catapult Part';
  441.  
  442. -- Battlefront Triage (http://www.wowhead.com/quest=26591)
  443. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26625,ExclusiveGroup=-26537,NextQuestIdChain=0,RequiredSpellCast1=0 WHERE id=26591;
  444. DELETE FROM conditions WHERE SourceEntry=80987;
  445. INSERT INTO conditions (SourceTypeOrReferenceId,SourceEntry,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,COMMENT) VALUES (17,80987,31,1,3,43229,'Battlefront Triage Item Quest can only be used for Injured Earthen'); -- Biar ga bisa di abuse item questnya untuk digunakan ke sendiri/player/npc lain.
  446. DELETE FROM smart_scripts WHERE entryorguid=43229;
  447. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  448. ('43229','0','0','1','8','0','100','0','80987','0','0','0','33','43229','0','0','0','0','0','7','0','0','0','0','0','0','0','Battlefront Triage Item Quest - On Event Spellhit - Complete Objective');
  449.  
  450. -- Shatter Them! (http://www.wowhead.com/quest=26537)
  451. UPDATE quest_template SET PrevQuestId=26501,NextQuestId=26625,ExclusiveGroup=-26537,NextQuestIdChain=26625 WHERE id=26537;
  452. UPDATE creature_template SET unit_flags=0, unit_flags2=0, dynamicflags=0 WHERE entry IN (43250,43234,43228); -- Npcnya ga bisa di hit (awalnya).
  453.  
  454. -- Troggzor the Earthinator (http://www.wowhead.com/quest=26625)
  455. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27126,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26625;
  456.  
  457. -- Rush Delivery (http://www.wowhead.com/quest=27126)
  458. UPDATE quest_template SET PrevQuestId=26625,NextQuestId=26632,ExclusiveGroup=0,NextQuestIdChain=26632 WHERE id=27126;
  459.  
  460. -- Close Escort (http://www.wowhead.com/quest=26632)
  461. UPDATE quest_template SET PrevQuestId=27126,NextQuestId=26755,ExclusiveGroup=0,NextQuestIdChain=26755,Flags=138,RequiredNpcOrGo1=43649,RequiredNpcOrGoCount1=1 WHERE id=26632;
  462. UPDATE creature_template SET AIName='SmartAI' WHERE entry=45043;
  463. UPDATE creature_template SET minlevel=83,maxlevel=83,speed_walk=1.5,speed_run=1.6,unit_flags=768,AIName='SmartAI',Health_mod=36.84573 WHERE entry=43509;
  464. UPDATE creature_template SET modelid1=34436,faction_A=16,faction_H=16 WHERE entry=43649;
  465. DELETE FROM creature WHERE phaseMask=65534 AND id=45043; -- remove double spawn
  466. UPDATE creature SET spawntimesecs=10 WHERE id=45043;
  467. DELETE FROM `gossip_menu` WHERE `entry`=11916; -- uda ada di database, di bagian creature_template*gossip_menu_id
  468. INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES(11916,11093);
  469. DELETE FROM `gossip_menu_option` WHERE `menu_id`=11916;
  470. INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
  471. (11916,0,0,"Peak, I\'m ready to escort the catapult.",1,3,0,0,0,0,'');
  472. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=11916;
  473. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  474. (15,11916,0,0,0,9,0,26632,0,0,0,0,'','Peak Grindstone show gossip option if player has quest 26632');
  475. -- Smart_scripts untuk Peak Grindstone & Earthen Catapult
  476. DELETE FROM smart_scripts WHERE entryorguid IN (45043,43509,43649);
  477. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  478. (45043,0,0,0,19,0,100,0,26632,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Peak Grindstone - On Quest Accept - Talk'), -- Peak Grindstone
  479. (45043,0,1,2,62,0,100,0,11916,0,0,0,12,43509,1,600000,0,0,0,7,0,0,0,0,0,0,0,'Peak Grindstone - On gossip option select - Summon Earthen Catapult'),
  480. (45043,0,2,3,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Peak Grindstone - On gossip option select - Close gossip'),
  481. ('45043','0','3','4','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Peak Grindstone - On Close gossip - Set Npcflag None'),
  482. ('45043','0','4','0','61','0','100','0','0','0','0','0','41','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Peak Grindstone - On Close gossip - Force Despawn'),
  483. (43509,0,0,0,54,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Catapult - On Just Summoned - Yell"), -- Earthen Catapult
  484. (43509,0,1,0,54,0,100,0,0,0,0,0,53,0,43509,0,0,0,0,1,0,0,0,0,0,0,0,"Earthen Catapult - On Just Summoned - Start Waypoint"),
  485. (43509,0,2,0,40,0,100,0,11,43509,0,0,12,43649,1,60000,0,0,0,1,0,0,0,0,0,0,0,"Earthen Catapult - On Waypoint Reached - Summon Close Escort Kill Credit"),
  486. (43509,'0','3','0','40','0','100','0','11','43509','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Earthen Catapult - On Waypoin Reached - Forced Despawn');
  487. DELETE FROM `creature_text` WHERE `entry` IN (45043,43509);
  488. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  489. (45043,0,0,"Let me know when you\'re ready, $N.",12,0,100,0,0,0,"Peak Grindstone"),
  490. (43509,0,0,"Alright, here we go.",14,0,100,0,0,0,"Earthen Catapult");
  491. -- Earthen Catapult Waypoints
  492. DELETE FROM `waypoints` WHERE `entry`=43509;
  493. INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
  494. (43509,1,738.054810,1994.103394,326.939545 ,"Earthen Catapult"),
  495. (43509,2,756.481140,1997.414551,326.696533 ,"Earthen Catapult"),
  496. (43509,3,774.880859,2019.713135,327.213104 ,"Earthen Catapult"),
  497. (43509,4,842.303833,2018.458862,325.034668 ,"Earthen Catapult"),
  498. (43509,5,861.996338,2036.319946,324.422302 ,"Earthen Catapult"),
  499. (43509,6,896.121216,2038.277344,321.153076 ,"Earthen Catapult"),
  500. (43509,7,903.593628,2032.470947,321.003510 ,"Earthen Catapult"),
  501. (43509,8,934.223877,2039.825439,316.985260 ,"Earthen Catapult"),
  502. (43509,9,975.127625,2016.379639,313.679443 ,"Earthen Catapult"),
  503. (43509,10,1016.480774,1967.756714,307.619537 ,"Earthen Catapult"),
  504. (43509,11,1019.795044,1946.168945,306.373352 ,"Earthen Catapult");
  505.  
  506. -- Keep Them off the Front (http://www.wowhead.com/quest=26755)
  507. UPDATE quest_template SET PrevQuestId=26632,NextQuestId=26762,ExclusiveGroup=0,NextQuestIdChain=26762,RequiredNpcOrGo1=43960,RequiredNpcOrGoCount1=30 WHERE id=26755;
  508. UPDATE creature_template SET KillCredit1=43960 WHERE entry=43954;
  509.  
  510. -- Mystic Masters (http://www.wowhead.com/quest=26770)
  511. UPDATE quest_template SET PrevQuestId=26755,NextQuestId=26834,ExclusiveGroup=-26762,NextQuestIdChain=0 WHERE id=26770;
  512. UPDATE creature_template SET unit_flags=0, unit_flags2=0, dynamicflags=0 WHERE entry=43995; -- Npcnya ga bisa di hit (awalnya).
  513.  
  514. -- Reactivate the Constructs (http://www.wowhead.com/quest=26762)
  515. UPDATE quest_template SET PrevQuestId=26755,NextQuestId=26834,ExclusiveGroup=-26762,NextQuestIdChain=26834 WHERE id=26762;
  516. UPDATE creature_template SET npcflag=1,AIName='SmartAI' WHERE entry=43984;
  517. DELETE FROM smart_scripts WHERE entryorguid=43984; -- Smart_scripts untuk Deactivated War Construct
  518. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  519. ('43984','0','0','1','64','0','100','0','0','0','0','0','33','43984','0','0','0','0','0','7','0','0','0','0','0','0','0','Deactivated War Construct - On Gossip Hello - Complete Objective'),
  520. ('43984','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Deactivated War Construct - On Gossip Hello - Close Gossip'),
  521. ('43984','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Deactivated War Construct - On Gossip Hello - Set Npcflag None'),
  522. ('43984','0','3','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Deactivated War Construct - On Gossip Hello - Forced Despawn');
  523.  
  524. -- Down Into the Chasm (http://www.wowhead.com/quest=26834)
  525. UPDATE quest_template SET PrevQuestId=0,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26834;
  526.  
  527. -- Sprout No More (http://www.wowhead.com/quest=26791)
  528. UPDATE quest_template SET PrevQuestId=26834,NextQuestId=26835,ExclusiveGroup=-26791,NextQuestIdChain=26835 WHERE id=26791;
  529. UPDATE creature_template SET npcflag=1,AIName='SmartAI' WHERE entry IN (44126,44049);
  530. DELETE FROM smart_scripts WHERE entryorguid IN (44126,44049); -- Smart_scripts untuk War Guardian & Giant Mushroom
  531. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  532. ('44126','0','0','1','64','0','100','0','0','0','0','0','33','44126','0','0','0','0','0','7','0','0','0','0','0','0','0','War Guardian - On Gossip Hello - Complete Objective'),
  533. ('44049','0','0','1','64','0','100','0','0','0','0','0','33','44049','0','0','0','0','0','7','0','0','0','0','0','0','0','Giant Mushroom - On Gossip Hello - Complete Objective'),
  534. ('44049','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Giant Mushroom - On Gossip Hello - Close Gossip'),
  535. ('44049','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Giant Mushroom - On Gossip Hello - Set Npcflag None'),
  536. ('44049','0','3','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Giant Mushroom - On Gossip Hello - Forced Despawn');
  537.  
  538. -- Fungal Monstrosities (http://www.wowhead.com/quest=26792)
  539. UPDATE quest_template SET PrevQuestId=26834,NextQuestId=26835,ExclusiveGroup=-26791,NextQuestIdChain=26835 WHERE id=26792;
  540.  
  541. -- A Slight Problem (http://www.wowhead.com/quest=26835)
  542. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26836,ExclusiveGroup=0,NextQuestIdChain=26836 WHERE id=26835;
  543.  
  544. -- Rescue the Stonefather... and Flint (http://www.wowhead.com/quest=26836)
  545. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27937,ExclusiveGroup=0,NextQuestIdChain=27937 WHERE id=26836;
  546.  
  547. -- The Hero Returns (http://www.wowhead.com/quest=27937)
  548. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27938,ExclusiveGroup=0,NextQuestIdChain=27938 WHERE id=27937;
  549.  
  550. -- The Middle Fragment (http://www.wowhead.com/quest=27938)
  551. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26326,ExclusiveGroup=-27938,NextQuestIdChain=0 WHERE id=27938;
  552.  
  553. ------------------------------------------------------------------------------------------------------
  554. -- @bottom
  555. -- // BOTTOM WORLD PILLAR FRAGMENT CHAIN QUESTS //(http://www.wowhead.com/achievement=4871#comments:id=1628071)
  556. DELETE FROM creature_questrelation WHERE quest IN (26326,26312,26314,26313,26315,26328,26377,26375,26376,26426,26869,26871,28824,26436,26438,26437,26439,28869,26440,26441,26575,26507,26576,26656,26657,26658,26577,26579,26578,26580,26581,26582,26583,26659,26584,26585,26750,26752,26827,26828,26829,26832,26831,26833,26875,26971,26709);
  557. DELETE FROM creature_involvedrelation WHERE quest IN (26326,26312,26314,26313,26315,26328,26377,26375,26376,26426,26869,26871,28824,26436,26438,26437,26439,28869,26440,26441,26575,26507,26576,26656,26657,26658,26577,26579,26578,26580,26581,26582,26583,26659,26584,26585,26750,26752,26827,26828,26829,26832,26831,26833,26875,26971,26709);
  558. INSERT INTO creature_questrelation VALUES
  559. (43065,26326),
  560. (42730,26312),
  561. (42730,26314),
  562. (42731,26313),
  563. (42731,26315),
  564. (42731,26328),
  565. (42467,26377),
  566. (42899,26375),
  567. (42467,26376),
  568. (42467,26426),
  569. (42467,26869),
  570. (42465,28824),
  571. (43792,28824),
  572. (42467,26436),
  573. (42469,26438),
  574. (42469,26437),
  575. (43344,26439),
  576. (42469,28869),
  577. (43116,26440),
  578. (43116,26441),
  579. (42469,26575),
  580. (42469,26507),
  581. (42469,26576),
  582. (42466,26656),
  583. (42466,26657),
  584. (42466,26658),
  585. (42469,26577),
  586. (42472,26579),
  587. (42472,26578),
  588. (42472,26580),
  589. (43395,26581),
  590. (43395,26582),
  591. (43442,26583),
  592. (42466,26659),
  593. (42472,26584),
  594. (42472,26585),
  595. (42466,26750),
  596. (42472,26750),
  597. (42465,26752),
  598. (43809,26827),
  599. (43065,26828),
  600. (44025,26829),
  601. (44025,26832),
  602. (44080,26831),
  603. (44025,26833),
  604. (43818,26875),
  605. (43835,26971),
  606. (43792,26709);
  607. INSERT INTO creature_involvedrelation VALUES
  608. (42730,26326),
  609. (42730,26312),
  610. (42730,26314),
  611. (42731,26313),
  612. (42731,26315),
  613. (42467,26328),
  614. (42467,26377),
  615. (42899,26375),
  616. (42467,26376),
  617. (42467,26426),
  618. (42467,26871),
  619. (42465,28824),
  620. (43792,28824),
  621. (44025,28824),
  622. (42469,26436),
  623. (42469,26438),
  624. (42469,26437),
  625. (43344,26439),
  626. (43116,28869),
  627. (43116,26440),
  628. (42469,26441),
  629. (42469,26575),
  630. (43116,26507),
  631. (42466,26576),
  632. (42466,26656),
  633. (42466,26657),
  634. (42466,26658),
  635. (42472,26577),
  636. (42472,26579),
  637. (42472,26578),
  638. (43395,26580),
  639. (43395,26581),
  640. (42472,26582),
  641. (43442,26583),
  642. (42466,26659),
  643. (42472,26584),
  644. (42472,26585),
  645. (42465,26750),
  646. (43809,26752),
  647. (43065,26827),
  648. (44025,26828),
  649. (44025,26829),
  650. (44025,26832),
  651. (42614,26831),
  652. (44080,26831),
  653. (43818,26833),
  654. (43835,26875),
  655. (43835,26971),
  656. (42465,26709);
  657.  
  658. -- No more autoaccept quest in bottom chain quests (kalo di abandon, ga bisa ambil questnya lagi, seems buggy)
  659. UPDATE quest_template SET Flags=128 WHERE id IN (26971,26869);
  660.  
  661. -- The Very Earth Beneath Our Feet (http://www.wowhead.com/quest=26326)
  662. UPDATE quest_template SET PrevQuestId=0,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26326;
  663.  
  664. -- Crumbling Defenses (http://www.wowhead.com/quest=26312)
  665. UPDATE quest_template SET PrevQuestId=26326,NextQuestId=0,ExclusiveGroup=-26313,NextQuestIdChain=0 WHERE id=26312;
  666. UPDATE creature SET `position_x`='1345.63',`position_y`='624.843',`position_z`='-65.2345',`orientation`='5.74496' WHERE id=42788; -- benerin posisi Hargoth Dimblaze
  667. UPDATE creature SET `position_x`='1392.76',`position_y`='785.956',`position_z`='-59.8331',`orientation`='0.745196' WHERE id=44352; -- Tawn Winterbluff
  668. UPDATE creature SET `position_x`='1311.72',`position_y`='792.638',`position_z`='-66.9506',`orientation`='4.27235' WHERE id=44353; -- Stormcaller Mylra
  669. UPDATE creature_template SET npcflag=1,unit_flags=32772,VehicleId=0,AIName='SmartAI' WHERE entry IN (42788,44352,44353);
  670. DELETE FROM smart_scripts WHERE entryorguid IN (42788,44352,44353);
  671. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  672. ('42788','0','0','0','0','0','100','0','0','0','0','0','75','92307','0','0','0','0','0','1','0','0','0','0','0','0','0','Hargoth Dimblaze - on IC - mark'), -- Hargoth
  673. ('42788','0','1','0','1','0','100','0','0','0','0','0','28','92307','0','0','0','0','0','1','0','0','0','0','0','0','0','Hargoth Dimblaze - on OOC - unaura mark'),
  674. ('42788','0','2','3','64','0','100','0','0','0','0','0','33','42788','0','0','0','0','0','7','0','0','0','0','0','0','0','Hargoth Dimblaze - On Gossip Hello - Complete Objective'),
  675. ('42788','0','3','4','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Hargoth Dimblaze - On Gossip Hello - Close Gossip'),
  676. ('42788','0','4','2','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Hargoth Dimblaze - on OOC - say text'),
  677. ('44352','0','0','0','0','0','100','0','0','0','0','0','75','92307','0','0','0','0','0','1','0','0','0','0','0','0','0','Tawn Winterbluff - on IC - mark'), -- Tawn
  678. ('44352','0','1','0','1','0','100','0','0','0','0','0','28','92307','0','0','0','0','0','1','0','0','0','0','0','0','0','Tawn Winterbluff - on OOC - unaura mark'),
  679. ('44352','0','2','3','64','0','100','0','0','0','0','0','33','44352','0','0','0','0','0','7','0','0','0','0','0','0','0','Tawn Winterbluff - On Gossip Hello - Complete Objective'),
  680. ('44352','0','3','4','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Tawn Winterbluff - On Gossip Hello - Close Gossip'),
  681. ('44352','0','4','2','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Tawn Winterbluff - on OOC - say text'),
  682. ('44353','0','0','0','1','0','100','0','0','0','0','0','75','92307','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Mylra - on IC - mark'), -- Mylra
  683. ('44353','0','1','0','1','0','100','0','0','0','0','0','28','92307','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Mylra - on OOC - unaura mark'),
  684. ('44353','0','2','3','64','0','100','0','0','0','0','0','33','44353','0','0','0','0','0','7','0','0','0','0','0','0','0','Stormcaller Mylra - On Gossip Hello - Complete Objective'),
  685. ('44353','0','3','4','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Stormcaller Mylra - On Gossip Hello - Close Gossip'),
  686. ('44353','0','4','2','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Mylra - on OOC - say text');
  687. DELETE FROM creature_text WHERE entry IN (42788,44352,44353);
  688. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES  
  689. (42788,0,0,'Don\'t stay out here too long, there will be more on top of you any second.',12,0,100,0,0,0,'Hargoth Dimblaze'),
  690. (44352,0,0,'By the elements... that one... just wouldn\'t die...',12,0,100,0,0,0,'Tawn Winterbluff'),
  691. (44353,0,0,"Careful out here, they don\'t stop coming.",12,0,100,0,0,0,'Stormcaller Mylra');
  692. DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry IN (42788,44352,44353);
  693. INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,NegativeCondition,COMMENT) VALUES
  694. (22,1,42788,9,0,26326,0,0,'SAI for quest 26326'),
  695. (22,1,44352,9,0,26326,0,0,'SAI for quest 26326'),
  696. (22,1,44353,9,0,26326,0,0,'SAI for quest 26326');
  697.  
  698. -- On Even Ground (http://www.wowhead.com/quest=26314)
  699. UPDATE quest_template SET PrevQuestId=26326,NextQuestId=0,ExclusiveGroup=-26313,NextQuestIdChain=0 WHERE id=26314;
  700. DELETE FROM smart_scripts WHERE entryorguid=44131;
  701. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  702. ('44131','0','0','1','8','0','100','0','79688','0','0','0','11','79764','2','0','0','0','0','1','0','0','0','0','0','0','0','44131 - On Spell Hit - cast 79764 to self'),
  703. ('44131','0','1','2','61','0','100','0','0','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','44131 - On Spell Hit - say text'),
  704. ('44131','0','2','0','61','0','100','0','0','0','0','0','85','84008','2','0','0','0','0','7','0','0','0','0','0','0','0','44131 - On Spell Hit - cast 84008 on player'),
  705. ('44131','0','3','0','6','0','100','0','0','0','0','0','28','79688','0','0','0','0','0','7','0','0','0','0','0','0','0','44131 - On Spell Hit - remove aura 79688 on player');
  706. DELETE FROM creature_text WHERE entry=44131;
  707. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES  (44131,0,0,'The line is secured to his ankle. Pull away to trip him!',41,0,100,0,0,0,'Servant of Therzane 44131');
  708. UPDATE creature_template SET Health_mod=92.426,AIName='SmartAI' WHERE entry=44131;
  709. DELETE FROM conditions WHERE SourceTypeOrReferenceId=17 AND SourceEntry=79688;
  710. INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,NegativeCondition,COMMENT) VALUES
  711. (17,0,79688,31,1,3,44131,0,'Elementium Grapple Line can only be casted to Servant of Therazane.'),
  712. (17,0,79688,1,1,79764,0,1,'Elementium Grapple Line can only be casted while aura 79764 is not active.');
  713.  
  714. -- Core of Our Troubles (http://www.wowhead.com/quest=26313)
  715. UPDATE quest_template SET PrevQuestId=26326,NextQuestId=26315,ExclusiveGroup=-26313,NextQuestIdChain=0 WHERE id=26313;
  716. DELETE FROM smart_scripts WHERE entryorguid=42731;
  717. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  718. ('42731','0','0','0','20','0','100','0','26313','0','0','0','1','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Earthmender Norsala - On Reward Quest - Say text');
  719. DELETE FROM creature_text WHERE entry=42731;
  720. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES (42731,0,0,'Only an elemental lord could bind so many elementals so quickly. It seems we are at war with da Stonemother herself...',12,0,100,0,0,0,'Earthmender Norsala');
  721. UPDATE creature_template SET AIName='SmartAI' WHERE entry=42731;
  722.  
  723. -- Imposing Confrontation (http://www.wowhead.com/quest=26315)
  724. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26328,ExclusiveGroup=0,NextQuestIdChain=26328 WHERE id=26315;
  725. UPDATE creature_template SET npcflag=0,AIName='SmartAI' WHERE entry=42471;
  726. UPDATE creature SET spawndist=0,MovementType=0 WHERE id=42471;
  727. DELETE FROM smart_scripts WHERE entryorguid=42471;
  728. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  729. ('42471','0','0','0','10','0','100','0','0','10','10000','10000','84','0','0','0','0','0','0','21','20','0','0','0','0','0','0','Boden the Imposing - On OOC - player Say text'),
  730. ('42471','0','1','0','10','0','100','0','0','10','10000','20000','1','1','10000','0','0','0','0','7','0','0','0','0','0','0','0','Boden the Imposing - On OOC - boden Say text 1'),
  731. ('42471','0','2','0','52','0','100','0','1','42471','0','0','1','2','8000','0','0','0','0','7','0','0','0','0','0','0','0','Boden the Imposing - On Text 1 over - boden Say text 2'),
  732. ('42471','0','3','0','52','0','100','0','1','42471','0','0','11','79843','0','0','0','0','0','7','0','0','0','0','0','0','0','Boden the Imposing - On Text 2 over - cast spell credit'),
  733. ('42471','0','4','0','31','0','100','0','79843','0','0','0','33','42731','0','0','0','0','0','21','5','0','0','0','0','0','0','Boden the Imposing - On Spell hit player - give spell credit');
  734. DELETE FROM creature_text WHERE entry=42471;
  735. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  736. (42471,0,0,"Boden the Imposing. I come on behalf of the Earthen Ring. We wish your kind no harm. We seek to repair the rift between our worlds. Why do you attack us?",12,0,100,0,8000,0,"Boden the Imposing"),
  737. (42471,1,0,"Hah! Did you mistake me for Diamant, $r? Or perhaps some other whimpering, compliant stone trogg who cares?",14,0,100,0,8000,21743,"Boden the Imposing"),
  738. (42471,2,0,"If you seek peace, relinquish the World Pillar and leave Deepholm. This is our realm. Your only welcome here shall be found underneath my stone foot.",14,0,100,0,10000,21744,"Boden the Imposing");
  739. DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=42471;
  740. INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,NegativeCondition,COMMENT) VALUES
  741. (22,1,42471,9,0,26315,0,0,'SAI for quest 26315');
  742.  
  743. -- Rocky Relations (http://www.wowhead.com/quest=26328)
  744. UPDATE quest_template SET PrevQuestId=26315,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26328;
  745.  
  746. -- Unsolid Ground (http://www.wowhead.com/quest=26377)
  747. UPDATE quest_template SET PrevQuestId=26328,NextQuestId=26426,ExclusiveGroup=-26377,NextQuestIdChain=26426 WHERE id=26377;
  748.  
  749. -- Loose Stones (http://www.wowhead.com/quest=26375)
  750. UPDATE quest_template SET PrevQuestId=26328,NextQuestId=26426,ExclusiveGroup=-26377,NextQuestIdChain=0 WHERE id=26375;
  751. UPDATE creature SET spawndist=0,MovementType=0 WHERE id=42900;
  752. UPDATE creature_template SET npcflag=1,AIName='SmartAI' WHERE entry=42900;
  753. DELETE FROM smart_scripts WHERE entryorguid=42900;
  754. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  755. ('42900','0','0','1','64','0','100','0','0','0','0','0','33','42900','0','0','0','0','0','7','0','0','0','0','0','0','0','Quartz Rockling - On Gossip Hello - Complete Objective'),
  756. ('42900','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Quartz Rockling - On Gossip Hello - Close Gossip'),
  757. ('42900','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Quartz Rockling - On Close gossip - Set Npcflag None'),
  758. ('42900','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Quartz Rockling - on Close gossip - say text'),
  759. ('42900','0','4','5','61','0','100','0','0','0','0','0','59','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Quartz Rockling - on Close gossip - Run'),
  760. ('42900','0','5','6','61','0','100','0','0','0','0','0','46','10','0','0','0','0','0','1','0','0','0','0','0','0','0','Quartz Rockling - on Close gossip - Move forward'),
  761. ('42900','0','6','0','61','0','100','0','0','0','0','0','41','1500','0','0','0','0','0','1','0','0','0','0','0','0','0','Quartz Rockling - on Flee - Force Despawn');
  762. DELETE FROM creature_text WHERE entry=42900;
  763. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  764. (42900,1,1,"The rockling offers great gravely sigh of appretiation.",16,0,33.33,0,0,0,"Quartz Rockling"),
  765. (42900,1,2,"The rockling rumbles in appretiation.",16,0,33.33,0,0,0,"Quartz Rockling"),
  766. (42900,1,3,"The rockling scampers into the distance, excited by it's newfound freedom.",16,0,33.33,0,0,0,"Quartz Rockling");
  767.  
  768. -- Hatred Runs Deep (http://www.wowhead.com/quest=26376)
  769. UPDATE quest_template SET PrevQuestId=26328,NextQuestId=26426,ExclusiveGroup=-26377,NextQuestIdChain=26426 WHERE id=26376;
  770.  
  771. -- Violent Gale (http://www.wowhead.com/quest=26426)
  772. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26869,ExclusiveGroup=0,NextQuestIdChain=26869 WHERE id=26426;
  773. UPDATE quest_template SET Flags=132,SpecialFlags=0 WHERE id=26426;
  774. DELETE FROM smart_scripts WHERE entryorguid IN (6182,6183) AND source_type=2;
  775. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  776. ('6182','2','0','0','46','0','100','0','6182','0','0','0','33','44281','0','0','0','0','0','18','20','0','0','0','0','0','0','Areatrigger 6182 - On Reached by player - give kill credit'),
  777. ('6183','2','0','0','46','0','100','0','6183','0','0','0','33','44282','0','0','0','0','0','18','20','0','0','0','0','0','0','Areatrigger 6183 - On Reached by player - give kill credit');
  778. DELETE FROM areatrigger_scripts WHERE entry IN (6182,6183);
  779. INSERT INTO areatrigger_scripts VALUES (6182,'SmartTrigger'),(6183,'SmartTrigger');
  780.  
  781. -- Depth of the Depths (http://www.wowhead.com/quest=26869)
  782. UPDATE quest_template SET PrevQuestId=26426,NextQuestId=26871,ExclusiveGroup=0,NextQuestIdChain=26871 WHERE id=26869;
  783. UPDATE gameobject_template SET Flags=32 WHERE entry=204959;
  784.  
  785. -- A Rock Amongst Many (http://www.wowhead.com/quest=26871)
  786. UPDATE quest_template SET PrevQuestId=26869,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26871;
  787.  
  788. -- Wayward Child (http://www.wowhead.com/quest=28824)
  789. UPDATE quest_template SET PrevQuestId=26871,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=28824;
  790.  
  791. -- Entrenched (http://www.wowhead.com/quest=26436)
  792. UPDATE quest_template SET PrevQuestId=26871,NextQuestId=26439,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26436;
  793.  
  794. -- Intervention (http://www.wowhead.com/quest=26438)
  795. UPDATE quest_template SET PrevQuestId=26436,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26438;
  796.  
  797. -- Making Things Crystal Clear (http://www.wowhead.com/quest=26437)
  798. UPDATE quest_template SET PrevQuestId=26436,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26437;
  799.  
  800. -- Putting the Pieces Together (http://www.wowhead.com/quest=26439)
  801. UPDATE quest_template SET PrevQuestId=26436,NextQuestId=28869,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26439;
  802. UPDATE creature_template SET npcflag=1,unit_flags=537133824,unit_flags2=2048,AIName='SmartAI' WHERE entry=43115;
  803. UPDATE creature SET spawndist=0,MovementType=0 WHERE id=43115;
  804. DELETE FROM smart_scripts WHERE entryorguid=43115; -- Smart_scripts untuk Dormant Stonebound Elemental
  805. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  806. ('43115','0','0','1','64','0','100','0','0','0','0','0','33','43115','0','0','0','0','0','7','0','0','0','0','0','0','0','Dormant Stonebound Elemental - On Gossip Hello - Complete Objective'),
  807. ('43115','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Dormant Stonebound Elemental - On Gossip Hello - Close Gossip'),
  808. ('43115','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Dormant Stonebound Elemental - On Gossip Hello - Set Npcflag None'),
  809. ('43115','0','3','4','61','0','100','0','0','0','0','0','19','537133824','0','0','0','0','0','1','0','0','0','0','0','0','0','Dormant Stonebound Elemental - On Gossip Hello - Set unitflags'),
  810. ('43115','0','4','5','61','0','100','0','0','0','0','0','94','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Dormant Stonebound Elemental - On Gossip Hello - Set dynamicflags'),
  811. ('43115','0','5','0','61','0','100','0','0','0','0','0','41','20000','0','0','0','0','0','1','0','0','0','0','0','0','0','Dormant Stonebound Elemental - On Gossip Hello - Force Despawn');
  812.  
  813. -- Pebble (http://www.wowhead.com/quest=28869)
  814. UPDATE quest_template SET PrevQuestId=26439,NextQuestId=26440,ExclusiveGroup=0,NextQuestIdChain=26440 WHERE id=28869;
  815. DELETE FROM smart_scripts WHERE entryorguid IN (42469,43116);
  816. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  817. ('42469','0','0','0','19','0','100','0','28869','0','0','0','85','80608','2','0','0','0','0','7','0','0','0','0','0','0','0','Kor the Immovable - On Quest Accept - cast Summon Pebble'),
  818. ('42469','0','1','2','62','0','100','0','42469','0','0','0','85','80608','2','0','0','0','0','7','0','0','0','0','0','0','0','Kor the Immovable - On Gossip select - cast Summon Pebble'), -- to prevent lost of pebble (in case of DC/log out)
  819. ('42469','0','2','0','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Kor the Immovable - On Gossip Hello - Close Gossip'),
  820. (43116,0,0,0,54,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Pebble - On Just Summoned- Say text");
  821. DELETE FROM `gossip_menu` WHERE `entry`=42469;
  822. INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES(42469,1);
  823. DELETE FROM `gossip_menu_option` WHERE `menu_id`=42469;
  824. INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
  825. (42469,0,0,"I lost my Pebble, Kor.",1,3,0,0,0,0,'');
  826. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=42469;
  827. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  828. (15,42469,0,0,0,8,0,28869,0,0,0,0,'','Kor show gossip option if player completed quest 28869');
  829. UPDATE creature_template SET gossip_menu_id=42469,AIName='SmartAI' WHERE entry=42469;
  830. UPDATE creature_template SET unit_flags=768,speed_walk=3,speed_run=3,AIName='SmartAI' WHERE entry=43116;
  831. DELETE FROM creature_text WHERE entry=43116;
  832. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  833. (43116,0,0,"You hear the sound of shuffling stones behind you.",16,0,100,0,0,0,"Pebble"),
  834. (43116,1,0,"Pebble sees the crystals ahead and excitedly rushes towards them!",16,0,100,0,0,0,"Pebble");
  835.  
  836. -- Clingy (http://www.wowhead.com/quest=26440)
  837. UPDATE quest_template SET PrevQuestId=28869,NextQuestId=26441,ExclusiveGroup=0,NextQuestIdChain=26441 WHERE id=26440;
  838. DELETE FROM smart_scripts WHERE entryorguid IN (6029,6030,6031,6032) AND source_type=2;
  839. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  840. ('6029','2','0','0','46','0','100','0','6029','0','0','0','33','43172','0','0','0','0','0','18','20','0','0','0','0','0','0','Areatrigger 6029 - On Reached by player - give kill credit'),
  841. ('6030','2','1','0','46','0','100','0','6030','0','0','0','33','43172','0','0','0','0','0','18','20','0','0','0','0','0','0','Areatrigger 6030 - On Reached by player - give kill credit'),
  842. ('6031','2','2','0','46','0','100','0','6031','0','0','0','33','43172','0','0','0','0','0','18','20','0','0','0','0','0','0','Areatrigger 6031 - On Reached by player - give kill credit'),
  843. ('6032','2','3','0','46','0','100','0','6032','0','0','0','33','43172','0','0','0','0','0','18','20','0','0','0','0','0','0','Areatrigger 6032 - On Reached by player - give kill credit');
  844. DELETE FROM areatrigger_scripts WHERE entry IN (6029,6030,6031,6032);
  845. INSERT INTO areatrigger_scripts VALUES (6029,'SmartTrigger'),(6030,'SmartTrigger'),(6031,'SmartTrigger'),(6032,'SmartTrigger');
  846. DELETE FROM `conditions` WHERE SourceId=2 AND `SourceEntry` IN (6029,6030,6031,6032);
  847. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  848. (22,2,6029,2,0,29,0,43116,20,0,0,0,'','Areatrigger 6029 SAI on quest 26440 limitation'),
  849. (22,2,6030,2,0,29,0,43116,20,0,0,0,'','Areatrigger 6030 SAI on quest 26440 limitation'),
  850. (22,2,6031,2,0,29,0,43116,20,0,0,0,'','Areatrigger 6031 SAI on quest 26440 limitation'),
  851. (22,2,6032,2,0,29,0,43116,20,0,0,0,'','Areatrigger 6032 SAI on quest 26440 limitation');
  852.  
  853. -- So Big, So Round... (http://www.wowhead.com/quest=26441)
  854. UPDATE quest_template SET PrevQuestId=26440,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26441;
  855.  
  856. -- Rock Bottom (http://www.wowhead.com/quest=26575)
  857. UPDATE quest_template SET PrevQuestId=26441,NextQuestId=0,ExclusiveGroup=-26575,NextQuestIdChain=0 WHERE id=26575;
  858.  
  859. -- Petrified Delicacies (http://www.wowhead.com/quest=26507)
  860. UPDATE quest_template SET PrevQuestId=26441,NextQuestId=0,ExclusiveGroup=-26575,NextQuestIdChain=0,RewardSpellCast=0 WHERE id=26507; -- RewardSpellcast awalnya 84513, bikin Not Responding worldserver.exe nya pas turn quest, jadi di set 0.
  861. UPDATE creature_template SET npcflag=1,scale=5,AIName='SmartAI' WHERE entry=43182;
  862. DELETE FROM smart_scripts WHERE entryorguid=43182;
  863. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  864. ('43182','0','0','1','64','0','100','0','0','0','0','0','56','58959','1','0','0','0','0','7','0','0','0','0','0','0','0','Petrified Stone Bat - On Gossip Hello - Additem 58959'),
  865. ('43182','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Petrified Stone Bat - On Gossip Hello - Close Gossip'),
  866. ('43182','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Petrified Stone Bat - On Gossip Hello - Set Npcflag None'),
  867. ('43182','0','3','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Petrified Stone Bat  - On Gossip Hello - Forced Despawn');
  868.  
  869. -- Steady Hand (http://www.wowhead.com/quest=26576)
  870. UPDATE creature_template SET npcflag=3,unit_flags=768,Health_mod=192.474,AIName='SmartAI',VehicleId=0 WHERE entry=42466; -- Terrath the Steady
  871. UPDATE creature_template SET mindmg=500,maxdmg=700,attackpower=800,spell1=81632,Health_mod=92.426 WHERE entry=43586; -- Opal Stonethrower
  872. DELETE FROM creature WHERE id=42466 AND phaseMask=65534; -- remove double spawn.
  873. UPDATE creature SET `position_x`='2136.71',`position_y`='1015.06',`position_z`='133.305',`orientation`='0.04584' WHERE id=42466;
  874. UPDATE quest_template SET PrevQuestId=26575,NextQuestId=26656,ExclusiveGroup=0,NextQuestIdChain=26656 WHERE id=26576;
  875.  
  876. -- Don't. Stop. Moving. (http://www.wowhead.com/quest=26656)
  877. UPDATE quest_template SET PrevQuestId=26576,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26656;
  878. UPDATE creature_template SET minlevel=83,maxlevel=83,unit_flags=768,speed_walk=5,speed_run=5,AIName='SmartAI' WHERE entry=43591;
  879. DELETE FROM `gossip_menu` WHERE `entry`=11689;
  880. INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES(11689,16366); -- valuenya uda ada di database.
  881. UPDATE gossip_menu_option SET option_id=1,npc_option_npcflag=3 WHERE menu_id=11689;
  882. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=11689;
  883. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  884. (15,11689,0,0,0,9,0,26656,0,0,0,0,'','Terra show gossip option if player has quest 26656');
  885. -- Smart_scripts untuk Terra the Steady & Opalescent Guardian
  886. DELETE FROM smart_scripts WHERE entryorguid IN (42466,43591);
  887. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  888. (42466,0,0,0,19,0,100,0,26656,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Terra the Steady - On Quest Accept - Talk'), -- Terra the Steady
  889. (42466,0,1,2,62,0,100,0,11689,0,0,0,85,81535,2,0,0,0,0,7,0,0,0,0,0,0,0,'Terra the Steady - On gossip option select - Cast 81535.1'),
  890. (42466,0,2,3,61,0,100,0,0,0,0,0,85,81535,2,0,0,0,0,7,0,0,0,0,0,0,0,'Terra the Steady - On gossip option select - Cast 81535.2'),
  891. (42466,0,3,4,61,0,100,0,0,0,0,0,85,81535,2,0,0,0,0,7,0,0,0,0,0,0,0,'Terra the Steady - On gossip option select - Cast 81535.3'),
  892. (42466,0,4,5,61,0,100,0,0,0,0,0,85,81535,2,0,0,0,0,7,0,0,0,0,0,0,0,'Terra the Steady - On gossip option select - Cast 81535.4'),
  893. (42466,0,5,6,61,0,100,0,0,0,0,0,85,81535,2,0,0,0,0,7,0,0,0,0,0,0,0,'Terra the Steady - On gossip option select - Cast 81535.5'),
  894. (42466,0,6,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Terra the Steady - On gossip option select - Close gossip'),
  895. (43591,0,0,0,54,0,100,0,0,0,0,0,29,0,0,43597,0,0,0,7,0,0,0,0,0,0,0,"Opalescent Guardian - On Just Summoned - Follow player"), -- Opalescent Guardian
  896. (43591,0,1,2,65,0,100,0,0,0,0,0,33,43597,0,0,0,0,0,7,0,0,0,0,0,0,0,"Opalescent Guardian - On Follow Complete - Escort Kill Credit"),
  897. (43591,0,2,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Opalescent Guardian - On Link 1 - Force Despawn");
  898. DELETE FROM `creature_text` WHERE `entry`=42466;
  899. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  900. (42466,0,0,"Speak with Terrath the Steady when you are ready to begin.",41,0,100,0,0,0,"Terra the Steady");
  901. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=81535;
  902. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  903. (17,0,81535,0,0,29,0,43591,5,0,1,0,'','Spell 81535 cannot be spammed by player');
  904.  
  905. -- Hard Falls (http://www.wowhead.com/quest=26657)
  906. UPDATE quest_template SET PrevQuestId=26656,NextQuestId=26659,ExclusiveGroup=-26657,NextQuestIdChain=26659 WHERE id=26657;
  907.  
  908. -- Fragile Values (http://www.wowhead.com/quest=26658)
  909. UPDATE quest_template SET PrevQuestId=26656,NextQuestId=26659,ExclusiveGroup=-26657,NextQuestIdChain=26659 WHERE id=26658;
  910.  
  911. -- Rocky Upheaval (http://www.wowhead.com/quest=26577)
  912. UPDATE quest_template SET PrevQuestId=26575,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26577;
  913.  
  914. -- Gone Soft (http://www.wowhead.com/quest=26579)
  915. UPDATE quest_template SET PrevQuestId=26577,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26579;
  916.  
  917. -- Doomshrooms (http://www.wowhead.com/quest=26578)
  918. UPDATE quest_template SET PrevQuestId=26577,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26578;
  919. UPDATE creature SET MovementType=0,spawndist=0 WHERE id=43388;
  920.  
  921. -- Familiar Intruders (http://www.wowhead.com/quest=26580)
  922. UPDATE quest_template SET PrevQuestId=26577,NextQuestId=26581,ExclusiveGroup=0,NextQuestIdChain=26581 WHERE id=26580;
  923.  
  924. -- A Head Full of Wind (http://www.wowhead.com/quest=26581)
  925. UPDATE quest_template SET PrevQuestId=26580,NextQuestId=26582,ExclusiveGroup=0,NextQuestIdChain=26582 WHERE id=26581;
  926. DELETE FROM creature_template_addon WHERE entry=43437;
  927. INSERT INTO creature_template_addon VALUES (43437,0,0,0,257,474,81222); -- Lorvarius' Whirly-wind Clean aura
  928. UPDATE creature_template SET unit_flags=768,speed_walk=5,speed_run=5,AIName='SmartAI',InhabitType=1 WHERE entry=43437;
  929. UPDATE creature_template SET AIName='SmartAI' WHERE entry=43395;
  930. DELETE FROM smart_scripts WHERE entryorguid IN (43395,43437);
  931. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  932. (43395,0,0,0,19,0,100,0,26581,0,0,0,85,81225,2,0,0,0,0,7,0,0,0,0,0,0,0,'Windspeaker Lorvarius- On Quest Accept - Summon Wind-devil'),
  933. (43437,0,0,0,54,0,100,0,0,0,0,0,29,0,0,43370,0,0,0,7,0,0,0,0,0,0,0,"Wind-devil - On Just Summoned - Follow player"), -- Wind-devil
  934. (43437,0,1,2,65,0,100,0,0,0,0,0,33,43370,0,0,0,0,0,7,0,0,0,0,0,0,0,"Wind-devil - On Follow Complete - Escort Kill Credit"),
  935. (43437,0,2,3,61,0,100,0,0,0,0,0,75,81096,0,0,0,0,0,7,0,0,0,0,0,0,0,"Wind-devil - On Link 1 - Add aura Red Mist to player"),
  936. (43437,0,3,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Wind-devil - On Link 2 - Force Despawn");
  937.  
  938. -- Unnatural Causes (http://www.wowhead.com/quest=26582)
  939. UPDATE quest_template SET PrevQuestId=26581,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26582;
  940.  
  941. -- Wrath of the Fungalmancer (http://www.wowhead.com/quest=26583)
  942. UPDATE quest_template SET PrevQuestId=26582,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26583;
  943. UPDATE creature SET phaseMask=1,modelid=33329 WHERE id=43442;
  944. UPDATE creature_template SET unit_flags=33600,AIName='SmartAI',Health_mod=19.247 WHERE entry=43503; -- Earthmender Norsala
  945. UPDATE creature SET spawntimesecs=60 WHERE id IN (43503,43372);
  946. UPDATE creature_template SET AIName='SmartAI' WHERE entry=43372; -- Fungalmancer Glop
  947. DELETE FROM `gossip_menu` WHERE `entry`=11739;
  948. INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES(11739,1); -- valuenya uda ada di database.
  949. UPDATE gossip_menu_option SET option_id=1,npc_option_npcflag=3 WHERE menu_id=11739;
  950. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=11739;
  951. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  952. (15,11739,0,0,0,9,0,26583,0,0,0,0,'','Norsala show gossip option if player has quest 26583');
  953. -- Smart_scripts untuk Earthmender Norsala (43503) & Fungalmancer Glop (43372)
  954. DELETE FROM smart_scripts WHERE entryorguid IN (43503,43372);
  955. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  956. (43503,0,0,1,62,0,100,0,11739,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Earthmender Norsala - On gossip select - Say text 0'),
  957. (43503,0,1,2,61,0,100,0,0,0,0,0,33,43503,0,0,0,0,0,7,0,0,0,0,0,0,0,'Earthmender Norsala - On Link 0 - Give kill credit'),
  958. (43503,0,2,3,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Earthmender Norsala - On Link 1 - Close gossip'),
  959. (43503,'0','3','4','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Earthmender Norsala - On Link 2 - Set Npcflag None'),
  960. (43503,0,4,0,61,0,100,0,0,0,0,0,53,1,43503,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On Link 3 - Start Waypoint"),
  961. (43503,0,5,6,40,0,100,0,3,43503,0,0,54,7000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On WP 3 - Pause Waypoint"),
  962. (43503,0,6,7,61,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On Link 5 - Say text 1"),
  963. (43503,0,7,0,61,0,100,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On Link 6 - Resume Waypoint"),
  964. (43503,0,8,9,40,0,100,0,24,43503,0,0,54,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On WP 24 - Pause Waypoint"),
  965. (43503,0,9,10,61,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On Link 8 - Say text 1"),
  966. (43503,0,10,0,61,0,100,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On Link 10 - Resume Waypoint"),
  967. (43503,0,11,0,40,0,100,0,25,43503,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthmender Norsala - On Reach WP 25 - Forced Despawn"),
  968. (43372,0,0,0,4,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fungalmancer Glop - On Aggro - Say text 0'),
  969. (43372,0,1,0,2,0,100,1,50,75,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fungalmancer Glop - On 75%HP - Say text 1'),
  970. (43372,0,2,0,2,0,100,1,1,25,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fungalmancer Glop - On 25%HP - Say text 2'),
  971. (43372,0,3,0,6,0,100,1,0,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fungalmancer Glop - On Death - Say text 3');
  972. DELETE FROM `creature_text` WHERE `entry` IN (43503,43372);
  973. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  974. (43503,0,0,"Let's finish this quickly.",12,0,100,0,0,21030,"Earthmender Norsala"),
  975. (43503,1,0,"You've caused enough damage, Glop. The earth welcomes you no longer.",14,0,100,0,0,21031,"Earthmender Norsala"),
  976. (43503,2,0,"After him, quickly!",14,0,100,0,0,21032,"Earthmender Norsala"),
  977. (43372,0,0,"Mushroom grow big and strong. Too big to stomp on! So strong they stomp back!",14,0,100,0,0,21770,"Fungalmancer Glop"),
  978. (43372,1,0,"Why you must come here? My cave! My cave! Me never hurt your cave!",14,0,100,0,0,21771,"Fungalmancer Glop 75%"),
  979. (43372,2,0,"Stay back! Back!",14,0,100,0,0,21772,"Fungalmancer Glop 25%"),
  980. (43372,3,0,"Mean.. rock fiends..",14,0,100,0,0,21773,"Fungalmancer Glop 0%");
  981. DELETE FROM `waypoints` WHERE `entry`=43503;
  982. INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
  983. (43503,1,1686.077271,-503.633484,156.493240,'Earthmender Norsala WP'),
  984. (43503,2,1668.796143,-498.944244,150.506866,'Earthmender Norsala WP'),
  985. (43503,3,1659.198975,-495.932129,147.611374,'Earthmender Norsala WP'),
  986. -- stop say line
  987. (43503,4,1635.872314,-489.890503,144.591095,'Earthmender Norsala WP'),
  988. (43503,5,1595.841064,-480.663422,162.219254,'Earthmender Norsala WP'),
  989. (43503,6,1584.461914,-478.712036,165.974945,'Earthmender Norsala WP'),
  990. (43503,7,1574.033081,-454.034790,168.910736,'Earthmender Norsala WP'),
  991. (43503,8,1571.947632,-447.449738,169.713043,'Earthmender Norsala WP'),
  992. (43503,9,1571.232544,-445.844788,169.892303,'Earthmender Norsala WP'),
  993. (43503,10,1568.793091,-441.172272,170.333862,'Earthmender Norsala WP'),
  994. (43503,11,1565.918579,-439.605194,170.666672,'Earthmender Norsala WP'),
  995. (43503,12,1555.211304,-433.116394,170.011902,'Earthmender Norsala WP'),
  996. (43503,13,1551.400391,-433.710999,170.072235,'Earthmender Norsala WP'),
  997. (43503,14,1510.815430,-440.043213,169.941528,'Earthmender Norsala WP'),
  998. (43503,15,1510.379883,-440.217072,169.993393,'Earthmender Norsala WP'),
  999. (43503,16,1509.319580,-441.267487,169.913208,'Earthmender Norsala WP'),
  1000. (43503,17,1495.732422,-454.655731,169.785294,'Earthmender Norsala WP'),
  1001. (43503,18,1495.382080,-455.644135,169.819046,'Earthmender Norsala WP'),
  1002. (43503,19,1482.266235,-498.799042,168.824081,'Earthmender Norsala WP'),
  1003. (43503,20,1482.155396,-500.149506,168.838959,'Earthmender Norsala WP'),
  1004. (43503,21,1487.064209,-511.532196,168.243469,'Earthmender Norsala WP'),
  1005. (43503,22,1487.911255,-512.152405,168.128098,'Earthmender Norsala WP'),
  1006. (43503,23,1491.479004,-513.559143,168.318756,'Earthmender Norsala WP'),
  1007. (43503,24,1498.287964,-514.487671,168.570541,'Earthmender Norsala WP'),
  1008. -- stop say line
  1009. (43503,25,1513.208984,-513.563354,170.039597,'Earthmender Norsala WP');
  1010.  
  1011. -- Resonating Blow (http://www.wowhead.com/quest=26659)
  1012. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26750,ExclusiveGroup=-26659,NextQuestIdChain=26750 WHERE id=26659;
  1013. UPDATE creature SET position_z=226.297012,spawndist=10,MovementType=1 WHERE id=43641;
  1014. UPDATE creature_template SET InhabitType=4 WHERE entry=43641;
  1015.  
  1016. -- Shaken and Stirred (http://www.wowhead.com/quest=26584)
  1017. UPDATE quest_template SET PrevQuestId=26582,NextQuestId=26750,ExclusiveGroup=-26659,NextQuestIdChain=26750 WHERE id=26584;
  1018.  
  1019. -- Corruption Destruction (http://www.wowhead.com/quest=26585)
  1020. UPDATE quest_template SET PrevQuestId=26582,NextQuestId=26750,ExclusiveGroup=-26659,NextQuestIdChain=0 WHERE id=26585;
  1021. DELETE FROM creature_loot_template WHERE item=59123; -- remove wrong loot
  1022.  
  1023. -- At the Stonemother's Call (http://www.wowhead.com/quest=26750)
  1024. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26752,ExclusiveGroup=0,NextQuestIdChain=26752 WHERE id=26750;
  1025. DELETE FROM creature WHERE id=44025 AND phaseMask=65534; -- remove unused double spawn.
  1026. DELETE FROM creature WHERE guid>=10000000 AND id=44025; -- remove unused wrong spawn.
  1027.  
  1028. -- Audience with the Stonemother (http://www.wowhead.com/quest=26752)
  1029. UPDATE quest_template SET PrevQuestId=26750,NextQuestId=26827,ExclusiveGroup=0,NextQuestIdChain=26827 WHERE id=26752;
  1030. UPDATE creature_template SET npcflag=3,AIName='SmartAI' WHERE entry IN (42465,43809);
  1031. UPDATE creature SET spawntimesecs=30 WHERE id=43809;
  1032. DELETE FROM smart_scripts WHERE entryorguid IN (42465,43809);
  1033. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  1034. (42465,0,0,1,62,0,100,0,12009,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Therazane - On gossip select - Close gossip'),
  1035. (42465,0,1,2,61,0,100,0,0,0,0,0,1,0,6000,0,0,0,0,1,0,0,0,0,0,0,0,'Therazane - On Link 0 - say text 0'),
  1036. (42465,0,2,0,61,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Therazane - On Link 1 - set npcflag none'),
  1037. ('42465','0','3','0','52','0','100','0','0','42465','0','0','1','1','10000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 0 over - Say text 1'),
  1038. ('42465','0','4','0','52','0','100','0','1','42465','0','0','1','2','4000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 1 over - Say text 2'),
  1039. ('42465','0','5','0','52','0','100','0','2','42465','0','0','1','3','20000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 2 over - Say text 3'),
  1040. ('42465','0','6','0','52','0','100','0','3','42465','0','0','1','4','13000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 2 over - Say text 4'),
  1041. ('42465','0','7','0','52','0','100','0','4','42465','0','0','1','5','5000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 2 over - Say text 5'),
  1042. ('42465','0','8','0','52','0','100','0','5','42465','0','0','1','6','16000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 2 over - Say text 6'),
  1043. ('42465','0','9','0','52','0','100','0','6','42465','0','0','1','7','7000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 2 over - Say text 7'),
  1044. ('42465','0','10','0','52','0','100','0','7','42465','0','0','1','8','11000','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 2 over - Say text 8'),
  1045. ('42465','0','11','12','52','0','100','0','8','42465','0','0','1','9','0','0','0','0','0','7','0','0','0','0','0','0','0','Therazane - On Text 2 over - Say text 8'),
  1046. (42465,0,12,0,61,0,100,0,0,0,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0,'Therazane - On Link 11 - set npcflag'),
  1047. ('43809','0','0','1','10','0','100','0','1','300','120','240','53','0','43809','0','0','0','0','18','300','0','0','0','0','0','0','Earthcaller Toruncar - On player accept quest - Start WP'),
  1048. (43809,0,1,0,61,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On Link 0 - Set npcflag none"),
  1049. (43809,0,2,3,40,0,100,0,3,43809,0,0,54,20000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On WP 3 - Pause Waypoint"),
  1050. (43809,0,3,0,61,0,100,0,0,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On Link 2 - Resume Waypoint"),
  1051. (43809,0,4,5,40,0,100,0,4,43809,0,0,54,74000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On WP 4 - Pause Waypoint"),
  1052. (43809,0,5,0,61,0,100,0,0,0,0,0,1,0,18000,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On Link 4 - Say text 0"),
  1053. (43809,0,6,0,52,0,100,0,0,43809,0,0,1,1,38000,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On text 0 over - Say text 1"),
  1054. (43809,0,7,0,52,0,100,0,1,43809,0,0,1,2,16000,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On text 1 over - Say text 2"),
  1055. (43809,0,8,9,56,0,100,0,4,43809,0,0,33,44051,0,0,0,0,0,7,0,0,0,0,0,0,0,"Earthcaller Toruncar - On resume WP 4 - Give kill credit"),
  1056. (43809,0,9,10,61,0,100,0,0,0,0,0,81,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On Link 8 - Set npcflag"),
  1057. (43809,0,10,0,61,0,100,0,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On Link 9 - Set Run"),
  1058. (43809,0,11,0,58,0,100,0,5,43809,0,0,41,30000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Earthcaller Toruncar - On WP End - Force despawn");
  1059. DELETE FROM `creature_text` WHERE `entry` IN (42465,43809);
  1060. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  1061. (42465,0,0,"So this is the one you were telling me about, Diamant?",12,0,100,0,0,21092,"Therazane"),
  1062. (42465,1,0,"So small. So soft. It's a wonder you've even lasted this long down here, fleshling.",12,0,100,0,0,21094,"Therazane"),
  1063. (42465,2,0,"Or perhaps a testament to your abilities.",12,0,100,0,0,21095,"Therazane"),
  1064. (42465,3,0,"All of this for a piece of the World Pillar? What exactly do you shaman intend to do with it?",12,0,100,0,0,21096,"Therazane"),
  1065. (42465,4,0,"And what then? Will you leave Deepholm to its denizens?",12,0,100,0,0,21097,"Therazane"),
  1066. (42465,5,0,"I'm glad you're at least that perceptive.",12,0,100,0,0,21098,"Therazane"),
  1067. (42465,6,0,"I propose this: We will march on the Twilight cult and extinguish any utterings of Deathwing's name from this realm. You Earthen Ring will march with us.",12,0,100,0,0,21099,"Therazane"),
  1068. (42465,7,0,"You do this, and I will send Gorsik to the temple with our piece of the World Pillar.",12,0,100,0,0,21100,"Therazane"),
  1069. (42465,8,0,"Seal the rift and leave this place.",12,0,100,0,0,21101,"Therazane"),
  1070. (42465,9,0,"Save your thanks. We march upon the Twilight Precipice as soon as our forces are gathered. I expect to see you on the battlefield.",12,0,100,0,0,21102,"Therazane"),
  1071. (43809,0,0,"We came here to be sealin' da rift Deathwing tore into Azeroth. We be needin' the World Pillar to restore da hole on dis side.",12,0,100,0,0,21117,"Earthcaller Torunscar"),
  1072. (43809,1,0,"We'll leave. We've no desire to be stayin' where we're not welcome.",12,0,100,0,0,21118,"Earthcaller Torunscar"),
  1073. (43809,2,0,"We'll be doin' exactly that, then. Ya have our tanks, Stonemother.",12,0,100,0,0,21119,"Earthcaller Torunscar");
  1074. DELETE FROM `gossip_menu_option` WHERE `menu_id`=12009;
  1075. INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
  1076. (12009,0,0,"I've come at your call, Stonemother.",1,3,0,0,0,0,'');
  1077. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12009;
  1078. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  1079. (15,12009,0,0,0,9,0,26752,0,0,0,0,'','Stonemother show gossip option if player has quest 26752');
  1080. DELETE FROM `waypoints` WHERE `entry`=43809;
  1081. INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
  1082. (43809,1,2340.571777,194.160400,179.906601,"Earthcaller Torunscar"),
  1083. (43809,2,2346.447998,182.581131,180.122040,"Earthcaller Torunscar"),
  1084. (43809,3,2358.958984,181.427490,181.229813,"Earthcaller Torunscar"),
  1085. (43809,4,2358.968984,181.427490,181.229813,"Earthcaller Torunscar"),
  1086. (43809,5,2339.98,195.193,179.936,"Earthcaller Torunscar"); -- reset position
  1087. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=43809;
  1088. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  1089. (22,1,43809,0,0,9,0,26752,0,0,0,0,'','Earthcaller Torunscar SAI if player has quest 26752');
  1090.  
  1091. -- Rallying the Earthen Ring (http://www.wowhead.com/quest=26827)
  1092. UPDATE quest_template SET PrevQuestId=26752,NextQuestId=26828,ExclusiveGroup=0,NextQuestIdChain=26828 WHERE id=26827;
  1093. UPDATE creature_template SET minlevel=83,maxlevel=83,npcflag=1,unit_flags=33280,AIName='SmartAI' WHERE entry IN (44634,44646,44631,45034,43836,44647,44633,44642,44644);
  1094. UPDATE creature_template SET gossip_menu_id=11872 WHERE entry IN (44634,45034,44647,44633,44642,44644);
  1095. DELETE FROM creature_template_addon WHERE entry IN (44647,44642,44644);
  1096. INSERT INTO creature_template_addon VALUES
  1097. (44647,0,0,1,4097,0,NULL), -- sit
  1098. (44642,0,0,3,4097,0,NULL), -- sleep
  1099. (44644,0,0,3,4097,0,NULL);
  1100. DELETE FROM creature WHERE id=44676; -- remove unused wrong spawn.
  1101. DELETE FROM gossip_menu WHERE entry IN (11872,11873);
  1102. INSERT INTO gossip_menu VALUES (11872,1),(11873,1);
  1103. UPDATE gossip_menu_option SET option_id=1,npc_option_npcflag=1 WHERE menu_id IN (11872,11873);
  1104. DELETE FROM smart_scripts WHERE entryorguid IN (44634,44646,44631,45034,43836,44647,44633,44642,44644);
  1105. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  1106. ('44634','0','0','1','62','0','100','0','11872','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Tawn Winterbluff - On select gossip - Complete Objective'),
  1107. ('44634','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Tawn Winterbluff - On link 0 - Close Gossip'),
  1108. ('44634','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Tawn Winterbluff - On link 1 - Set Npcflag None'),
  1109. ('44634','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Tawn Winterbluff - On link 2 - Say text'),
  1110. ('44634','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Tawn Winterbluff - On link 3 - Forced Despawn'),
  1111. ('44646','0','0','1','62','0','100','0','11872','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Earthcaller Yevaa - On select gossip - Complete Objective'),
  1112. ('44646','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Earthcaller Yevaa - On link 0 - Close Gossip'),
  1113. ('44646','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Earthcaller Yevaa - On link 1 - Set Npcflag None'),
  1114. ('44646','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Earthcaller Yevaa - On link 2 - Say text'),
  1115. ('44646','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Earthcaller Yevaa - On link 3 - Forced Despawn'),
  1116. ('44631','0','0','1','62','0','100','0','11873','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Tharm Wildfire - On select gossip - Complete Objective'),
  1117. ('44631','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Tharm Wildfire - On link 0 - Close Gossip'),
  1118. ('44631','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Tharm Wildfire - On link 1 - Set Npcflag None'),
  1119. ('44631','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Tharm Wildfire - On link 2 - Say text'),
  1120. ('44631','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Tharm Wildfire - On link 3 - Forced Despawn'),
  1121. ('45034','0','0','1','62','0','100','0','11872','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Yuldris Smolderfury - On select gossip - Complete Objective'),
  1122. ('45034','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Yuldris Smolderfury - On link 0 - Close Gossip'),
  1123. ('45034','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Yuldris Smolderfury - On link 1 - Set Npcflag None'),
  1124. ('45034','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Yuldris Smolderfury - On link 2 - Say text'),
  1125. ('45034','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Yuldris Smolderfury - On link 3 - Forced Despawn'),
  1126. ('43836','0','0','1','62','0','100','0','11873','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Windspeaker Lorvarius - On select gossip - Complete Objective'),
  1127. ('43836','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Windspeaker Lorvarius - On link 0 - Close Gossip'),
  1128. ('43836','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Windspeaker Lorvarius - On link 1 - Set Npcflag None'),
  1129. ('43836','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Windspeaker Lorvarius - On link 2 - Say text'),
  1130. ('43836','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Windspeaker Lorvarius - On link 3 - Forced Despawn'),
  1131. ('44647','0','0','1','62','0','100','0','11872','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Mariahn the Soulcleanser - On select gossip - Complete Objective'),
  1132. ('44647','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Mariahn the Soulcleanser - On link 0 - Close Gossip'),
  1133. ('44647','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Mariahn the Soulcleanser - On link 1 - Set Npcflag None'),
  1134. ('44647','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Mariahn the Soulcleanser - On link 2 - Say text'),
  1135. ('44647','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Mariahn the Soulcleanser - On link 3 - Forced Despawn'),
  1136. ('44633','0','0','1','62','0','100','0','11872','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Stormcaller Jalara - On select gossip - Complete Objective'),
  1137. ('44633','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Stormcaller Jalara - On link 0 - Close Gossip'),
  1138. ('44633','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Jalara - On link 1 - Set Npcflag None'),
  1139. ('44633','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Jalara - On link 2 - Say text'),
  1140. ('44633','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Jalara - On link 3 - Forced Despawn'),
  1141. ('44642','0','0','1','62','0','100','0','11872','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Stormcaller Mylra - On select gossip - Complete Objective'),
  1142. ('44642','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Stormcaller Mylra - On link 0 - Close Gossip'),
  1143. ('44642','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Mylra - On link 1 - Set Npcflag None'),
  1144. ('44642','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Mylra - On link 2 - Say text'),
  1145. ('44642','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Stormcaller Mylra - On link 3 - Forced Despawn'),
  1146. ('44644','0','0','1','62','0','100','0','11872','0','0','0','33','44133','0','0','0','0','0','7','0','0','0','0','0','0','0','Hargoth Dimblaze - On select gossip - Complete Objective'),
  1147. ('44644','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Hargoth Dimblaze - On link 0 - Close Gossip'),
  1148. ('44644','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Hargoth Dimblaze - On link 1 - Set Npcflag None'),
  1149. ('44644','0','3','4','61','0','100','0','0','0','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Hargoth Dimblaze - On link 2 - Say text'),
  1150. ('44644','0','4','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Hargoth Dimblaze - On link 3 - Forced Despawn');
  1151. DELETE FROM creature_text WHERE entry IN (44634,44646,44631,45034,43836,44647,44633,44642,44644);
  1152. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  1153. (44634,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1154. (44634,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1155. (44634,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1156. (44634,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1157. (44634,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1158. (44634,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1159. (44634,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1160. (44634,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Tawn Winterbluff"),
  1161. (44646,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1162. (44646,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1163. (44646,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1164. (44646,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1165. (44646,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1166. (44646,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1167. (44646,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1168. (44646,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Earthcaller Yevaa"),
  1169. (44631,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1170. (44631,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1171. (44631,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1172. (44631,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1173. (44631,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1174. (44631,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1175. (44631,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1176. (44631,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Tharm Wildfire"),
  1177. (45034,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1178. (45034,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1179. (45034,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1180. (45034,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1181. (45034,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1182. (45034,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1183. (45034,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1184. (45034,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Yuldris Smolderfury"),
  1185. (43836,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1186. (43836,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1187. (43836,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1188. (43836,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1189. (43836,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1190. (43836,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1191. (43836,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1192. (43836,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Windspeaker Lorvarius"),
  1193. (44647,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1194. (44647,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1195. (44647,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1196. (44647,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1197. (44647,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1198. (44647,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1199. (44647,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1200. (44647,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Mariahn the Soulcleanser"),
  1201. (44633,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1202. (44633,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1203. (44633,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1204. (44633,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1205. (44633,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1206. (44633,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1207. (44633,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1208. (44633,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Stormcaller Jalara"),
  1209. (44642,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1210. (44642,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1211. (44642,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1212. (44642,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1213. (44642,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1214. (44642,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1215. (44642,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1216. (44642,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Stormcaller Mylra"),
  1217. (44644,1,1,"Elements be with us.",12,0,12.5,0,0,0,"Hargoth Dimblaze"),
  1218. (44644,1,2,"Exactly what I wanted to hear. Let's go.",12,0,12.5,0,0,0,"Hargoth Dimblaze"),
  1219. (44644,1,3,"Got it. I'll head there right away.",12,0,12.5,0,0,0,"Hargoth Dimblaze"),
  1220. (44644,1,4,"I'm glad to hear we're fighting along side the Stonemother herself this time.",12,0,12.5,0,0,0,"Hargoth Dimblaze"),
  1221. (44644,1,5,"I'm on my way.",12,0,12.5,0,0,0,"Hargoth Dimblaze"),
  1222. (44644,1,6,"Some action. Glad to hear it.",12,0,12.5,0,0,0,"Hargoth Dimblaze"),
  1223. (44644,1,7,"That encampment has been begging for our attention. Let's get this done.",12,0,12.5,0,0,0,"Hargoth Dimblaze"),
  1224. (44644,1,8,"Understood. I'll head there right away.",12,0,12.5,0,0,0,"Hargoth Dimblaze");
  1225. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (11872,11873);
  1226. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  1227. (15,11872,0,0,0,9,0,26827,0,0,0,0,'','show gossip option if player has quest 26827'),
  1228. (15,11873,0,0,0,9,0,26827,0,0,0,0,'','show gossip option if player has quest 26827');
  1229.  
  1230. -- Our Part of the Bargain (http://www.wowhead.com/quest=26828)
  1231. UPDATE quest_template SET PrevQuestId=26827,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26828;
  1232.  
  1233. -- The Stone March (http://www.wowhead.com/quest=26829)
  1234. UPDATE quest_template SET PrevQuestId=26828,NextQuestId=26833,ExclusiveGroup=-26829,NextQuestIdChain=26833 WHERE id=26829;
  1235.  
  1236. -- Therazane's Mercy (http://www.wowhead.com/quest=26832)
  1237. UPDATE quest_template SET PrevQuestId=26828,NextQuestId=26833,ExclusiveGroup=-26829,NextQuestIdChain=26833 WHERE id=26832;
  1238. UPDATE creature_template SET Health_mod=3 WHERE entry=42914;
  1239. UPDATE creature_template SET Health_mod=2.5 WHERE entry=42923;
  1240.  
  1241. -- The Twilight Flight (http://www.wowhead.com/quest=26831)
  1242. UPDATE quest_template SET PrevQuestId=26828,NextQuestId=26833,ExclusiveGroup=-26829,NextQuestIdChain=0 WHERE id=26831;
  1243. UPDATE creature_template SET Health_mod=17.323 WHERE entry=44135;
  1244.  
  1245. -- Word In Stone (http://www.wowhead.com/quest=26833)
  1246. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26875,ExclusiveGroup=0,NextQuestIdChain=26875 WHERE id=26833;
  1247. DELETE FROM creature_template_addon WHERE entry=43818;
  1248. INSERT INTO creature_template_addon VALUES
  1249. (43818,0,0,0,4097,469,'45537'); -- casting state.
  1250.  
  1251. -- Undying Twilight (http://www.wowhead.com/quest=26875)
  1252. UPDATE quest_template SET PrevQuestId=26833,NextQuestId=26971,ExclusiveGroup=0,NextQuestIdChain=26971 WHERE id=26875;
  1253. DELETE FROM creature_template_addon WHERE entry=43835;
  1254. INSERT INTO creature_template_addon VALUES
  1255. (43835,0,0,0,4097,469,'45537'); -- casting state.
  1256.  
  1257. -- The Binding (http://www.wowhead.com/quest=26971)
  1258. UPDATE quest_template SET PrevQuestId=26875,NextQuestId=26709,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26971;
  1259. DELETE FROM creature WHERE id=43837; -- should not spawned (triggered).
  1260. UPDATE creature_template SET faction_A=14,faction_H=14,Health_mod=38.495,AIName='SmartAI' WHERE entry=43837;
  1261. UPDATE creature_template SET AIName='SmartAI' WHERE entry=43835;
  1262. DELETE FROM smart_scripts WHERE entryorguid IN (43835,43837);
  1263. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  1264. (43835,0,0,1,19,0,100,0,26971,0,0,0,12,43837,1,600000,0,0,0,7,0,0,0,0,0,0,0,'Earthcaller Torunscar - On Queat Accept - Summon High Priestess Lorthuna'),
  1265. (43835,0,1,0,61,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Earthcaller Torunscar - On Link 0 - Say text'),
  1266. (43837,0,0,0,54,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'High Priestess Lorthuna - On Just Summoned - Say text'),
  1267. (43837,0,1,0,2,0,100,1,50,75,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'High Priestess Lorthuna - On 75%HP - Say text 1'),
  1268. (43837,0,2,3,6,0,100,0,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'High Priestess Lorthuna - On Death - Say text 2'),
  1269. (43837,0,3,0,61,0,100,0,0,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,'High Priestess Lorthuna - On Death - Forced despawn');
  1270. DELETE FROM creature_text WHERE entry IN (43835,43837);
  1271. INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
  1272. (43835,0,0,"Stop her! We can still complete da binding!",14,0,100,0,0,21115,"Earthcaller Torunscar"),
  1273. (43837,0,0,"Your tale ends here, shaman.",12,0,100,0,0,20938,"High Priestess Lorthuna"),
  1274. (43837,1,0,"Deathwing shall bring destruction upon your entire order. And this day, I shall be his blade!",12,0,100,0,0,20939,"High Priestess Lorthuna"),
  1275. (43837,2,0,"Hah...",12,0,100,0,0,20940,"High Priestess Lorthuna");
  1276.  
  1277. -- The Stone Throne (http://www.wowhead.com/quest=26709)
  1278. UPDATE quest_template SET PrevQuestId=0,NextQuestId=26971,ExclusiveGroup=0,NextQuestIdChain=0 WHERE id=26709;
  1279.  
  1280. ------------------------------------------------------------------------------------------------------
  1281. -- @master
  1282. -- // MASTER'S GATE CHAIN QUESTS // (http://www.wowhead.com/achievement=4871#comments:id=1628111) (100% COMPLETE)
  1283. -- Horde Side
  1284. UPDATE quest_template SET RequiredRaces=946 WHERE id IN (27953,27005,27008,27043,27041,27059,28293,28296);
  1285. DELETE FROM creature_questrelation WHERE quest IN (27953,27005,27008,27043,27041,27059,28293,28296);
  1286. DELETE FROM creature_involvedrelation WHERE quest IN (27953,27005,27008,27043,27041,27059,28293,28296);
  1287. INSERT INTO creature_questrelation VALUES
  1288. (42573,27953),
  1289. (44823,27005),
  1290. (44818,27008),
  1291. (44818,27043),
  1292. (44823,27041),
  1293. (44823,27059),
  1294. (44823,28293),
  1295. (47571,28296);
  1296. INSERT INTO creature_involvedrelation VALUES
  1297. (44823,27953),
  1298. (44823,27005),
  1299. (44818,27008),
  1300. (44818,27043),
  1301. (44823,27041),
  1302. (44823,27059),
  1303. (47571,28293),
  1304. (44833,28296);
  1305.  
  1306. -- The Reliquary (http://www.wowhead.com/quest=27953)
  1307. UPDATE quest_template SET PrevQuestId=0,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=27005 WHERE id=27953;
  1308. UPDATE creature SET `position_x`='1090.32',`position_y`='435.084',`position_z`='-45.9434',`orientation`='2.57958' WHERE id=44818; -- benerin posisi Examiner Rowe
  1309. UPDATE creature SET `position_x`='1086.38',`position_y`='433.6',`position_z`='-45.7251',`orientation`='2.52563' WHERE id=44823; -- benerin posisi Reliquary Jes'ca Darksun
  1310.  
  1311. -- The Twilight Plot (http://www.wowhead.com/quest=27005)
  1312. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27041,ExclusiveGroup=-27005,NextQuestIdChain=27041 WHERE id=27005;
  1313.  
  1314. -- Fly Over (http://www.wowhead.com/quest=27008)
  1315. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27043,ExclusiveGroup=-27005,NextQuestIdChain=27043,Flags=8388744,SpecialFlags=0,RequiredNpcOrGo1=44839,RequiredNpcOrGoCount1=1 WHERE id=27008;
  1316. DELETE FROM smart_scripts WHERE entryorguid=6216;
  1317. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  1318. ('6216','2','0','0','46','0','100','0','6216','0','0','0','33','44839','0','0','0','0','0','18','20','0','0','0','0','0','0','Areatrigger 6216 - On Reached by player - give kill credit');
  1319. DELETE FROM areatrigger_scripts WHERE entry=6216;
  1320. INSERT INTO areatrigger_scripts VALUES (6216,'SmartTrigger');
  1321. DELETE FROM areatrigger_involvedrelation WHERE id=6216; --unused
  1322.  
  1323. -- Fight Fire and Water and Air with... (http://www.wowhead.com/quest=27043)
  1324. UPDATE quest_template SET PrevQuestId=27008,NextQuestId=0,ExclusiveGroup=0,RequiredNpcOrGo1=44889,RequiredNpcOrGo2=44888,RequiredNpcOrGo3=44890,RequiredNpcOrGoCount1=1,RequiredNpcOrGoCount2=1,RequiredNpcOrGoCount3=1 WHERE id=27043;
  1325. DELETE FROM creature_template_addon WHERE entry IN (44889,44888,44890); 098
  1326. INSERT INTO creature_template_addon VALUES
  1327. (44889,0,0,0,257,474,83740),
  1328. (44888,0,0,0,257,474,83741),
  1329. (44890,0,0,0,257,474,83742); -- Cosmetic - Lightning Beam State Base
  1330. UPDATE creature_template SET Health_mod=1,AIName='SmartAI' WHERE entry IN (44887,44885,44886);
  1331. UPDATE creature_template SET modelid1=15880,modelid2=0 WHERE entry IN (44889,44888,44890);
  1332. UPDATE creature_template SET AIName='SmartAI' WHERE entry=44835;
  1333. DELETE FROM smart_scripts WHERE entryorguid IN (44887,44885,44886,44835);
  1334. insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values
  1335. ('44886','0','0','0','6','0','100','0','0','0','0','0','85','83745','0','0','0','0','0','7','0','0','0','0','0','0','0','Cast on Death - Water Ward'),
  1336. ('44885','0','0','0','6','0','100','0','0','0','0','0','85','83746','0','0','0','0','0','7','0','0','0','0','0','0','0','Cast on Death - Air Ward'),
  1337. ('44887','0','0','0','6','0','100','0','0','0','0','0','85','83744','0','0','0','0','0','7','0','0','0','0','0','0','0','Cast on Death - Fire Ward'),
  1338. ('44835','0','1','0','4','0','100','1','0','0','0','0','11','18266','0','0','0','0','0','2','0','0','0','0','0','0','0','Haethen Kaul - On Aggro - cast Curse of Agony'),
  1339. ('44835','0','2','0','9','0','100','0','0','40','3400','4800','11','83799','0','0','0','0','0','2','0','0','0','0','0','0','0','Haethen Kaul - On IC - cast Earth Bolt');
  1340.  
  1341. -- Decryption Made Easy (http://www.wowhead.com/quest=27041)
  1342. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27059,ExclusiveGroup=0,NextQuestIdChain=27059 WHERE id=27041;
  1343.  
  1344. -- The Wrong Sequence (http://www.wowhead.com/quest=27059)
  1345. UPDATE quest_template SET PrevQuestId=27041,NextQuestId=28293,ExclusiveGroup=0,NextQuestIdChain=28293 WHERE id=27059;
  1346.  
  1347. -- That's No Pyramid! (http://www.wowhead.com/quest=28293)
  1348. UPDATE quest_template SET PrevQuestId=27059,NextQuestId=28296,ExclusiveGroup=0,NextQuestIdChain=28296 WHERE id=28293;
  1349.  
  1350. -- Meetup with the Caravan (http://www.wowhead.com/quest=28296)
  1351. UPDATE quest_template SET PrevQuestId=28293,NextQuestId=27003,ExclusiveGroup=0,NextQuestIdChain=27003 WHERE id=28296;
  1352.  
  1353. -- Alliance Side
  1354. UPDATE quest_template SET RequiredRaces=2098253 WHERE id IN (27952,27004,27006,27042,27040,27058,28292,28295);
  1355. DELETE FROM creature_questrelation WHERE quest IN (27952,27004,27006,27042,27040,27058,28292,28295);
  1356. DELETE FROM creature_involvedrelation WHERE quest IN (27952,27004,27006,27042,27040,27058,28292,28295);
  1357. INSERT INTO creature_questrelation VALUES
  1358. (42573,27952),
  1359. (44799,27004),
  1360. (44802,27006),
  1361. (44802,27042),
  1362. (44799,27040),
  1363. (44799,27058),
  1364. (44799,28292),
  1365. (44238,28295);
  1366. INSERT INTO creature_involvedrelation VALUES
  1367. (44799,27952),
  1368. (44799,27004),
  1369. (44802,27006),
  1370. (44802,27042),
  1371. (44799,27040),
  1372. (44799,27058),
  1373. (44238,28292),
  1374. (44833,28295);
  1375.  
  1376. -- The Explorers (http://www.wowhead.com/quest=27952)
  1377. UPDATE quest_template SET PrevQuestId=0,NextQuestId=0,ExclusiveGroup=0,NextQuestIdChain=27004,NextQuestIdChain=27004 WHERE id=27952;
  1378. UPDATE creature SET `position_x`='1048.76',`position_y`='636.686',`position_z`='-45.9636',`orientation`='4.41274' WHERE id=44799; -- benerin posisi Explorer Mowi
  1379. UPDATE creature SET `position_x`='1042.92',`position_y`='637.827',`position_z`='-45.7371',`orientation`='4.66112' WHERE id=44802; -- benerin posisi Prospector Brewer
  1380.  
  1381. -- The Twilight Plot (http://www.wowhead.com/quest=27004)
  1382. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27040,ExclusiveGroup=-27004,NextQuestIdChain=27040 WHERE id=27004;
  1383.  
  1384. -- Fly Over (http://www.wowhead.com/quest=27006)
  1385. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27042,ExclusiveGroup=-27004,NextQuestIdChain=27042,Flags=8388744,SpecialFlags=0,RequiredNpcOrGo1=44839,RequiredNpcOrGoCount1=1 WHERE id=27006;
  1386.  
  1387. -- Fight Fire and Water and Air with... (http://www.wowhead.com/quest=27042)
  1388. UPDATE quest_template SET PrevQuestId=27006,NextQuestId=0,ExclusiveGroup=0,RequiredNpcOrGo1=44889,RequiredNpcOrGo2=44888,RequiredNpcOrGo3=44890,RequiredNpcOrGoCount1=1,RequiredNpcOrGoCount2=1,RequiredNpcOrGoCount3=1 WHERE id=27042;
  1389.  
  1390. -- Decryption Made Easy (http://www.wowhead.com/quest=27040)
  1391. UPDATE quest_template SET PrevQuestId=0,NextQuestId=27058,ExclusiveGroup=0,NextQuestIdChain=27058 WHERE id=27040;
  1392.  
  1393. -- The Wrong Sequence (http://www.wowhead.com/quest=27058)
  1394. UPDATE quest_template SET PrevQuestId=27040,NextQuestId=28292,ExclusiveGroup=0,NextQuestIdChain=28292 WHERE id=27058;
  1395.  
  1396. -- That's No Pyramid! (http://www.wowhead.com/quest=28292)
  1397. UPDATE quest_template SET PrevQuestId=27058,NextQuestId=28295,ExclusiveGroup=0,NextQuestIdChain=28295 WHERE id=28292;
  1398.  
  1399. -- Meetup with the Caravan (http://www.wowhead.com/quest=28295)
  1400. UPDATE quest_template SET PrevQuestId=28292,NextQuestId=27003,ExclusiveGroup=0,NextQuestIdChain=27003 WHERE id=28295;
  1401.  
  1402. ------------------------------------------------------------------------------------------------------
  1403. -- @therazane
  1404. -- // THERAZANE DAILY QUESTS // (http://www.wowhead.com/achievement=4871#comments:id=1628071)
  1405. UPDATE quest_template SET PrevQuestId=26709 WHERE id IN (27047,27049,27046,27051,27050,28488,27048,26710,28390,28391); -- Must complete all the chain quests first.
  1406. UPDATE creature_template SET unit_flags=0 WHERE entry IN (44257,42766);
  1407. UPDATE creature_template SET Health_mod=4.62 WHERE entry=44259;
  1408. --DELETE FROM achievement_criteria_data WHERE criteria_id=15644;
  1409. --INSERT INTO achievement_criteria_data VALUES (15644,8,5,0,''); //not working
  1410. DELETE FROM achievement_reward WHERE entry=5449;
  1411. INSERT INTO achievement_reward (entry,item,sender,subject,text) VALUES (5449,60869,34337,'Recovered Item','We recovered a lost item in the twisting and noted that it was yours.$B$BPlease find said object enclosed.');
  1412.  
  1413. -- Beneath the Surface (http://www.wowhead.com/quest=28488)
  1414. DELETE FROM creature WHERE id=48533; -- Enormous spawn should be triggered (not spawned).
  1415. UPDATE creature SET spawndist=0,MovementType=0 WHERE id=48639;
  1416. UPDATE creature_template SET npcflag=1,AIName='SmartAI' WHERE entry=48639;
  1417. UPDATE creature_template SET modelid2=0,AIName='SmartAI' WHERE entry=48533;
  1418. DELETE FROM smart_scripts WHERE entryorguid IN (48639,48533);
  1419. insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values
  1420. ('48639','0','0','1','64','0','100','0','0','0','0','0','12','48533','2','600000','0','1','0','7','0','0','0','0','0','0','0','Ruby Gemstone Cluster - On Gossip Hello - Summon Enormous Gyreworm'),
  1421. ('48639','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Ruby Gemstone Cluster - On Gossip Hello - Close Gossip'),
  1422. ('48639','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Ruby Gemstone Cluster - On Close gossip - Set Npcflag None'),
  1423. ('48639','0','3','0','61','0','100','0','0','0','0','0','41','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Ruby Gemstone Cluster - On Close gossip - Force despawn'),
  1424. ('48533','0','0','0','6','0','100','0','0','0','0','0','56','64404','1','0','0','0','0','16','0','0','0','0','0','0','0','Enormous Gyreworm - On Death  - give item 64404'),
  1425. ('48533','0','1','0','4','0','100','1','0','0','0','0','11','90625','0','0','0','0','0','2','0','0','0','0','0','0','0','Enormous Gyreworm - On Aggro - cast Earth Spike'),
  1426. ('48533','0','2','0','9','0','100','0','0','40','3400','4800','11','90625','0','0','0','0','0','2','0','0','0','0','0','0','0','Enormous Gyreworm - On IC - cast Earth Spike');
  1427.  
  1428. -- Underground Economy (http://www.wowhead.com/quest=27048)
  1429.  -- taken from https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/blob/master/old/updates_03/023_wdb_templates_updates.sql & https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/blob/master/old/updates_02/043_gameobject_template.sql
  1430. DELETE FROM gameobject_template WHERE entry IN (207383,207381,207384,207382);
  1431. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `unkInt32`, `WDBVerified`) VALUES
  1432. (207383, 3, 10279, 'Deep Amethyst Crystal Chunk', '', 'Retrieving', '', 1691, 36114, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23645, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 65508, 0, 0, 0, 0, 0, 0, 13623),
  1433. (207381, 3, 10277, 'Deep Alabaster Crystal Chunk', '', 'Retrieving', '', 1691, 36112, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23645, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 65504, 0, 0, 0, 0, 0, 0, 13623),
  1434. (207384, 3, 9731, 'Deep Garnet Crystal Chunk', '', 'Retrieving', '', 1691, 36115, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23645, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 65510, 0, 0, 0, 0, 0, 0, 13623),
  1435. (207382, 3, 10278, 'Deep Celestite Crystal Chunk', '', 'Retrieving', '', 1691, 36113, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23645, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 65507, 0, 0, 0, 0, 0, 0, 15595);
  1436.  
  1437. -- Lost In The Deeps (http://www.wowhead.com/quest=26710)
  1438. UPDATE creature_template SET npcflag=1,AIName='SmartAI' WHERE entry=49956;
  1439. UPDATE creature SET position_x='2091.11',position_y='-162.923',position_z='-160.371',orientation='3.4102',spawndist=0,MovementType=0 WHERE id=49956;
  1440. UPDATE creature_template SET unit_flags=768,AIName='SmartAI' WHERE entry=49706;
  1441. UPDATE gossip_menu_option SET option_id=1,npc_option_npcflag=1 WHERE menu_id=12541;
  1442. DELETE FROM smart_scripts WHERE entryorguid IN (49956,49706);
  1443. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  1444. (49956,0,0,1,62,0,100,0,12541,0,0,0,85,92939,2,0,0,0,0,7,0,0,0,0,0,0,0,'Pebble - On gossip select - cast 92939 on player'),
  1445. (49956,0,1,2,61,0,100,0,12541,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Pebble - On Link 0 - Close gossip'),
  1446. (49956,0,2,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Pebble  - On Link 1 - Force Despawn"),
  1447. (49706,0,0,0,54,0,100,0,0,0,0,0,29,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Pebble - On Just Summoned - Follow player"); -- Pebble
  1448. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12541;
  1449. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  1450. (15,12541,0,0,0,9,0,26710,0,0,0,0,'','show gossip option if player has quest 26710');
  1451. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  1452. ('6183','2','1','0','46','0','100','0','6183','0','0','0','33','49956','0','0','0','0','0','18','10','0','0','0','0','0','0','Areatrigger 6183 - On Reached by player - give kill credit');
  1453. DELETE FROM `conditions` WHERE SourceId=2 AND `SourceEntry`=6183;
  1454. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  1455. (22,2,6183,2,0,29,0,49706,20,0,0,0,'','Areatrigger 6183 SAI on quest 26710 limitation');
  1456.  
  1457. -- Glop, Son of Glop (http://www.wowhead.com/quest=28390) -- must be revered
  1458. -- The Restless Brood (http://www.wowhead.com/quest=28391) -- must be revered
  1459. UPDATE quest_template SET RequiredFactionId1=1171,RequiredFactionValue1=21000,RequiredMinRepFaction=0,RequiredMinRepValue=0 WHERE id IN (28390,28391);
  1460.  
  1461.  
  1462. ------------------------------------------------------------------------------------------------------
  1463. --@spawn
  1464. -- NPCs & GOBs spawns
  1465. -- Quest Fly Over (http://www.wowhead.com/quest=27006) nya ga perlu pake dummy lagi. Uda fix menggunakan smart_scripts (no more hacky version)
  1466. DELETE FROM creature_template WHERE entry=90000;
  1467. DELETE FROM creature WHERE id=90000;
  1468.  
  1469. -- Fight Fire and Water and Air with... dummy untuk Light cosmetic
  1470. DELETE FROM creature WHERE id IN (44889,44888,44890);
  1471. insert into `creature` (`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
  1472. ('44888','646','1','65535','0','0','542.092','970.241','78.7719','5.53324','300','0','0','42','0','0','0','0','0'),
  1473. ('44889','646','1','65535','0','0','504.302','1215.22','55.4104','1.31959','300','0','0','42','0','0','0','0','0'),
  1474. ('44890','646','1','65535','0','0','335.053','985.348','62.5023','3.7757','300','0','0','42','0','0','0','0','0');
  1475.  
  1476. -- Quest Decryption Made Easy (http://www.wowhead.com/quest=27041), object nya blm di spawnin.
  1477. DELETE FROM gameobject WHERE id=205145;
  1478. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1479. ('205145','646','1','1','344.771','936.848','57.3042','2.59408','0','0','0.962762','0.27035','300','0','1'),
  1480. ('205145','646','1','1','267.043','970.501','60.1525','5.53933','0','0','0.363414','-0.931628','300','0','1'),
  1481. ('205145','646','1','1','233.57','915.383','58.2853','5.82991','0','0','0.224702','-0.974428','300','0','1'),
  1482. ('205145','646','1','1','298.419','896.211','55.1881','2.53227','0','0','0.953949','0.299968','300','0','1'),
  1483. ('205145','646','1','1','328.031','1029.48','57.1009','1.75473','0','0','0.769058','0.639179','300','0','1'),
  1484. ('205145','646','1','1','277.334','1037.59','55.6051','0.674788','0','0','0.331029','0.943621','300','0','1'),
  1485. ('205145','646','1','1','268.524','925.544','57.542','3.46686','0','0','0.986804','-0.161917','300','0','1');
  1486.  
  1487. -- Quest The Wrong Sequence (http://www.wowhead.com/quest=27058) objectnya blm di spawnin juga.
  1488. DELETE FROM gameobject WHERE id=205161;
  1489. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('205161','646','1','1','285.34','1056.76','56.5006','5.63291','0','0','0.319442','-0.947606','300','0','1');
  1490.  
  1491. -- Add kill credit npc untuk quest Take Him to the Earthcaller
  1492. DELETE FROM creature WHERE id=44207;
  1493. insert into `creature` (`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('44207','646','1','65535','0','0','974.612','522.597','-49.3348','0.232802','300','0','0','42','0','0','0','0','0');
  1494.  
  1495. -- Sealing the Way (http://www.wowhead.com/quest=26501) menggunakan dummy kill kredit (43164,43165,43166,43167) yang uda ada di database, di spawnin di tempat2 quest yg seharusnya. Lalu menggunakan smart_scripts untuk menyelesaikan quest dengan men-klik dummy2 ini. Menggunakan cara hack karena spell di item quest nya blm jalan dan membuat FE.
  1496. DELETE FROM creature WHERE id IN (43164,43165,43166,43167);
  1497. insert into `creature` (`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('43164','646','1','1','0','0','499.578','1652.64','349.901','2.30699','300','0','0','42','0','0','0','0','0'),
  1498. ('43165','646','1','1','0','0','454.459','1741.82','350.456','4.74723','300','0','0','42','0','0','0','0','0'),
  1499. ('43166','646','1','1','0','0','412.28','1727.07','351.012','5.80114','300','0','0','42','0','0','0','0','0'),
  1500. ('43167','646','1','1','0','0','405.264','1652.49','349.956','0.702802','300','0','0','42','0','0','0','0','0');
  1501.  
  1502. -- War Guardian belum di spawnin.
  1503. DELETE FROM creature WHERE id=44126;
  1504. insert into `creature` (`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('44126','646','1','1','0','0','1268.94','1650.99','175.78','5.7277','300','0','0','278900','0','0','0','0','0');
  1505.  
  1506. -- Quest http://www.wowhead.com/quest=26502, object quest nya blm spawn.
  1507. DELETE FROM gameobject WHERE id=204348;
  1508. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1509. ('204348','646','1','1','442.983','1648.65','348.762','6.24235','0','0','0.0204171','-0.999792','300','0','1'),
  1510. ('204348','646','1','1','444.677','1648.92','348.613','0.557663','0','0','0.275232','0.961378','300','0','1'),
  1511. ('204348','646','1','1','504.528','1662.62','350.316','4.40845','0','0','0.806004','-0.59191','300','0','1'),
  1512. ('204348','646','1','1','502.328','1664.63','349.367','3.9647','0','0','0.916501','-0.400032','300','0','1'),
  1513. ('204348','646','1','1','503.865','1663.71','349.873','3.9215','0','0','0.924927','-0.380145','300','0','1'),
  1514. ('204348','646','1','1','524.681','1712.75','346.575','4.56552','0','0','0.75708','-0.653323','300','0','1'),
  1515. ('204348','646','1','1','524.511','1711.61','346.464','4.56552','0','0','0.75708','-0.653323','300','0','1'),
  1516. ('204348','646','1','1','460.561','1713.91','347.821','3.02614','0','0','0.998334','0.0576931','300','0','1'),
  1517. ('204348','646','1','1','462.68','1713.77','347.278','0.198708','0','0','0.0991908','0.995068','300','0','1'),
  1518. ('204348','646','1','1','441.062','1742.09','351.57','5.02499','0','0','0.588417','-0.808558','300','0','1'),
  1519. ('204348','646','1','1','440.531','1743.73','351.962','5.02499','0','0','0.588417','-0.808558','300','0','1'),
  1520. ('204348','646','1','1','440.114','1745.02','352.269','5.02499','0','0','0.588417','-0.808558','300','0','1'),
  1521. ('204348','646','1','1','412.353','1680.92','348.018','0.885954','0','0','0.428631','0.90348','300','0','1'),
  1522. ('204348','646','1','1','411.176','1679.48','348.654','0.885954','0','0','0.428631','0.90348','300','0','1'),
  1523. ('204348','646','1','1','410.52','1678.67','349.009','0.885954','0','0','0.428631','0.90348','300','0','1'),
  1524. ('204348','646','1','1','441.604','1695.49','350.03','1.24331','0','0','0.582381','0.812916','300','0','1'),
  1525. ('204348','646','1','1','500.172','1729.92','345.58','0.882033','0','0','0.426859','0.904318','300','0','1');
  1526.  
  1527. -- Quest Fixer Upper (http://www.wowhead.com/quest=26564), objectnya blm di spawnin.
  1528. DELETE FROM gameobject WHERE id IN (204374,204375,204377,204376,204378);
  1529. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1530. ('204374','646','1','1','710.191','1848.09','327.106','0.288979','0','0','0.143987','0.989579','300','0','1'),
  1531. ('204375','646','1','1','676.728','1856.09','332.182','0.294353','0','0','0.146646','0.989189','300','0','1'),
  1532. ('204376','646','1','1','755.054','1815.47','326.363','5.72393','0','0','0.275999','-0.961158','300','0','1'),
  1533. ('204377','646','1','1','713.11','1769.33','337.845','4.9951','0','0','0.600435','-0.799674','300','0','1'),
  1534. ('204374','646','1','1','764.337','1899.73','328.38','1.06811','0','0','0.509028','0.86075','300','0','1'),
  1535. ('204375','646','1','1','787.66','1880.72','328.096','5.85903','0','0','0.21049','-0.977596','300','0','1'),
  1536. ('204376','646','1','1','801.985','1953.06','330.963','2.1441','0','0','0.878183','0.478325','300','0','1'),
  1537. ('204377','646','1','1','710.389','1989.05','328.592','1.43331','0','0','0.656866','0.754007','300','0','1'),
  1538. ('204374','646','1','1','764.417','2003.76','326.127','0.459416','0','0','0.227693','0.973733','300','0','1'),
  1539. ('204375','646','1','1','858.471','1996.91','322.945','0.314115','0','0','0.156413','0.987692','300','0','1'),
  1540. ('204376','646','1','1','811.284','2026.84','324.633','2.27919','0','0','0.908465','0.417962','300','0','1'),
  1541. ('204378','646','1','1','839.479','1884.41','316.468','4.80032','0','0','0.675347','-0.7375','300','0','1'),
  1542. ('204378','646','1','1','907.308','1782.81','318.524','4.52413','0','0','0.770437','-0.637516','300','0','1'),
  1543. ('204375','646','1','1','842.573','1769.39','324.264','3.617','0','0','0.971881','-0.235471','300','0','1'),
  1544. ('204378','646','1','1','984.106','1861.52','316.922','1.0998','0','0','0.522601','0.852577','300','0','1'),
  1545. ('204376','646','1','1','905.064','1904.93','320.358','2.10502','0','0','0.86867','0.495392','300','0','1');
  1546.  
  1547. -- Quest Battlefront Triage (http://www.wowhead.com/quest=26591) tempat spawnnya dibenerin.
  1548. DELETE FROM creature WHERE id=43229;
  1549. insert into `creature` (`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
  1550. ('43229','646','1','1','0','1','698.392','1833.53','330.232','6.17138','300','1','0','94367','0','1','0','0','0'),
  1551. ('43229','646','1','1','0','1','707.661','1844.27','327.418','5.68051','300','1','0','94367','0','1','0','0','0'),
  1552. ('43229','646','1','1','0','1','737.84','1848.46','327.101','0.977701','300','1','0','94367','0','1','0','0','0'),
  1553. ('43229','646','1','1','0','1','737.41','1888.19','331.782','1.59645','300','1','0','94367','0','1','0','0','0'),
  1554. ('43229','646','1','1','0','1','775.091','1862.37','326.63','5.70164','300','1','0','94367','0','1','0','0','0'),
  1555. ('43229','646','1','1','0','1','758.3','1766.86','324.043','0.92539','300','1','0','94367','0','1','0','0','0'),
  1556. ('43229','646','1','1','0','1','793.988','1792.68','329.542','1.42412','300','1','0','94367','0','1','0','0','0'),
  1557. ('43229','646','1','1','0','1','811.297','1890.23','323.455','1.0432','300','1','0','94367','0','1','0','0','0'),
  1558. ('43229','646','1','1','0','1','867.119','1835.28','317.99','5.17035','300','1','0','94367','0','1','0','0','0'),
  1559. ('43229','646','1','1','0','1','759.637','1964.39','327.427','1.04719','300','1','0','94367','0','1','0','0','0'),
  1560. ('43229','646','1','1','0','1','700.734','1890.2','335.334','1.3974','300','1','0','94367','0','1','0','0','0');
  1561.  
  1562. -- Missing gameobject The Stonefather's Safe
  1563. DELETE FROM gameobject WHERE id=206562;
  1564. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('206562','646','1','1','459.949','1621.69','356.332','1.73179','0','0','0.761677','0.647957','300','0','1');
  1565.  
  1566. -- Quest giver http://www.wowhead.com/quest=26770 belum spawn.
  1567. DELETE FROM creature WHERE id=43898;
  1568. insert into `creature` ( `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('43898','646','1','1','0','0','1030.11','1889.53','307.917','0.104737','300','0','0','41835','0','0','0','0','0');
  1569.  
  1570. -- Quest Captain's Log object nya belum spawn.
  1571. DELETE FROM gameobject WHERE id=204274;
  1572. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('204274','646','1','1','284.259','313.002','58.0858','3.31369','0','0','0.9963','-0.0859432','300','0','1');
  1573.  
  1574. -- Quest Gunship Down NPCnya belum di spawn.
  1575. DELETE FROM creature WHERE id IN (43032,43044);
  1576. insert into `creature` (`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
  1577. ('43032','646','1','1','0','0','276.245','192.564','44.9747','0.418199','300','0','0','5342','0','0','0','0','0'),
  1578. ('43044','646','1','1','0','0','194.031','159.124','42.1731','1.96392','300','0','0','42','0','0','0','0','0');
  1579.  
  1580. -- object untuk Question the Slaves (http://www.wowhead.com/quest=26261) belum di spawnin. (coffer & ball and chain)
  1581. DELETE FROM gameobject WHERE id IN (205097,205098);
  1582. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1583. ('205097','646','1','1','773.966','-150.984','-40.9897','3.41762','0','0','0.990491','-0.137576','300','0','1'),
  1584. ('205098','646','1','1','485.756','-208.436','-13.2801','1.74559','0','0','0.76613','0.642686','300','0','1'),
  1585. ('205098','646','1','1','489.162','-226.782','-13.103','2.86479','0','0','0.990438','0.137959','300','0','1'),
  1586. ('205098','646','1','1','493.635','-239.892','-13.1018','4.0429','0','0','0.900163','-0.435553','300','0','1'),
  1587. ('205098','646','1','1','507.172','-246.145','-13.1039','1.44715','0','0','0.662069','0.749443','300','0','1'),
  1588. ('205098','646','1','1','511.635','-256.241','-13.1038','3.61878','0','0','0.971672','-0.236335','300','0','1'),
  1589. ('205098','646','1','1','521.042','-264.771','-11.5215','4.76154','0','0','0.689519','-0.724268','300','0','1'),
  1590. ('205098','646','1','1','530.258','-266.618','-12.2619','3.06901','0','0','0.999341','0.0362854','300','0','1'),
  1591. ('205098','646','1','1','539.737','-281.551','-6.12734','4.9493','0','0','0.618586','-0.785717','300','0','1'),
  1592. ('205098','646','1','1','538.829','-275.896','-8.76241','1.1951','0','0','0.562619','0.826716','300','0','1'),
  1593. ('205098','646','1','1','489.672','-218.898','-13.1028','2.04726','0','0','0.854002','0.52027','300','0','1'),
  1594. ('205098','646','1','1','480.087','-166.734','-13.1308','1.03017','0','0','0.492607','0.870252','300','0','1'),
  1595. ('205098','646','1','1','489.556','-153.132','-13.3658','1.89803','0','0','0.812843','0.582483','300','0','1'),
  1596. ('205098','646','1','1','487.226','-142.607','-13.3574','2.78946','0','0','0.98454','0.175158','300','0','1'),
  1597. ('205098','646','1','1','476.159','-132.954','-12.7763','3.64554','0','0','0.968422','-0.249318','300','0','1'),
  1598. ('205098','646','1','1','580.58','-271.454','-15.1273','3.41381','0','0','0.990752','-0.135687','300','0','1'),
  1599. ('205098','646','1','1','577.68','-282.669','-10.7791','3.68831','0','0','0.962869','-0.269968','300','0','1'),
  1600. ('205098','646','1','1','584.942','-308.566','-12.9909','3.31171','0','0','0.996385','-0.0849566','300','0','1'),
  1601. ('205098','646','1','1','580.142','-322.247','-12.7948','1.37963','0','0','0.636394','0.771364','300','0','1'),
  1602. ('205098','646','1','1','579.716','-328.198','-12.7884','4.20314','0','0','0.862416','-0.506201','300','0','1'),
  1603. ('205098','646','1','1','591.851','-332.539','-12.7853','2.37316','0','0','0.927092','0.374833','300','0','1'),
  1604. ('205098','646','1','1','650.726','-329.554','-19.7907','4.56856','0','0','0.756085','-0.654473','300','0','1'),
  1605. ('205098','646','1','1','638.924','-331.423','-17.2567','3.25344','0','0','0.998437','-0.0558936','300','0','1'),
  1606. ('205098','646','1','1','631.494','-339.291','-17.2771','5.18394','0','0','0.522366','-0.852721','300','0','1'),
  1607. ('205098','646','1','1','626.23','-345.772','-16.2482','4.08438','0','0','0.890936','-0.454129','300','0','1'),
  1608. ('205098','646','1','1','618.672','-348.304','-14.6379','5.87116','0','0','0.204561','-0.978854','300','0','1'),
  1609. ('205098','646','1','1','610.721','-351.119','-12.8893','4.15506','0','0','0.874335','-0.485324','300','0','1'),
  1610. ('205098','646','1','1','857.088','-242.082','-8.76556','4.21979','0','0','0.858172','-0.513363','300','0','1'),
  1611. ('205098','646','1','1','797.435','-278.6','-21.217','4.56929','0','0','0.755849','-0.654746','300','0','1'),
  1612. ('205098','646','1','1','784.896','-283.291','-20.5442','0.0298514','0','0','0.0149252','0.999889','300','0','1'),
  1613. ('205098','646','1','1','761.602','-283.855','-21.246','5.16735','0','0','0.529421','-0.848359','300','0','1'),
  1614. ('205098','646','1','1','755.673','-286.363','-21.4585','4.86497','0','0','0.651157','-0.758943','300','0','1'),
  1615. ('205098','646','1','1','747.324','-289.781','-21.4383','4.04919','0','0','0.898788','-0.438384','300','0','1'),
  1616. ('205098','646','1','1','742.417','-304.641','-21.9824','5.29405','0','0','0.474653','-0.880173','300','0','1'),
  1617. ('205098','646','1','1','741.101','-311.345','-21.7923','2.32481','0','0','0.917761','0.397134','300','0','1'),
  1618. ('205098','646','1','1','742.108','-319.632','-20.4041','3.42829','0','0','0.989743','-0.142857','300','0','1'),
  1619. ('205098','646','1','1','687.699','-274.997','-24.1473','3.34582','0','0','0.994791','-0.101937','300','0','1'),
  1620. ('205098','646','1','1','681.788','-285.97','-23.9744','3.15733','0','0','0.999969','-0.00786694','300','0','1'),
  1621. ('205098','646','1','1','669.427','-288.303','-21.7986','1.09958','0','0','0.522509','0.852634','300','0','1');
  1622.  
  1623. -- Forgemaster's Log belum spawn object nya + di database blm ada ((diambil dari https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/blob/master/old/updates_03/023_wdb_templates_updates.sql))
  1624. DELETE FROM gameobject_template WHERE entry=205134;
  1625. DELETE FROM gameobject WHERE id=205134;
  1626. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `unkInt32`, `WDBVerified`) VALUES (205134, 2, 6891, 'Forgemaster''s Log', '', 'Reading', '', 43, 15601, 0, 0, 0, 0, 24589, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 13623);
  1627. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('205134','646','1','1','912.067','-198.868','10.0947','4.05898','0','0','0.896631','-0.442778','300','0','1');
  1628.  
  1629. -- quest Block the gates di spawnin npc kill credit dari database yg uda ada.
  1630. DELETE FROM creature WHERE id IN (44930,44931);
  1631. insert into `creature` (`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
  1632. ('44930','646','1','1','0','0','246.272','-449.198','178.984','3.74706','60','0','0','5647','0','0','0','0','0'),
  1633. ('44931','646','1','1','0','0','247.348','-582.488','174.792','3.17012','60','0','0','5647','0','0','0','0','0');
  1634.  
  1635. -- Object untuk quest Quicksilver Submersion belum ada dan belum di spawnin.
  1636. DELETE FROM gameobject_template WHERE entry=205197;
  1637. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `unkInt32`, `WDBVerified`) VALUES
  1638. (205197, 3, 9855, 'Trogg Crate', '', '', '', 43, 32451, 0, 0, 0, 0, 26208, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 60809, 0, 0, 0, 0, 0, 0, 13623);
  1639. DELETE FROM gameobject WHERE id=205197;
  1640. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('205197','646','1','1','610.39','-608.137','148.395','4.22091','0','0','0.857885','-0.513842','300','0','1');
  1641.  
  1642. -- Object untuk quest The world Pillar fragment & The First Fragment of the World Pillar belum ada di DB. (diambil dari https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/blob/master/old/updates_03/023_wdb_templates_updates.sql)
  1643. DELETE FROM gameobject_template WHERE entry=204967;
  1644. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `unkInt32`, `WDBVerified`) VALUES
  1645. (204967, 3, 9779, 'The First Fragment of the World Pillar', '', 'Retrieving', '', 1852, 31490, 30, 0, 0, 0, 0, 204968, 0, 0, 0, 0, 0, 0, 23645, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.3, 60574, 0, 0, 0, 0, 0, 0, 13623);
  1646.  
  1647. -- Maziel's journal belum di spawnin.
  1648. DELETE FROM gameobject WHERE id=205207;
  1649. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('205207','646','1','1','408.773','-373.879','42.5711','4.88169','0','0','0.644788','-0.764361','300','0','1');
  1650.  
  1651. -- Twilight journal belum di spawnin.
  1652. DELETE FROM gameobject WHERE id=207415;
  1653. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('207415','725','1','1','1104.86','862.873','287.872','0.342428','0','0','0.170379','0.985379','300','0','1');
  1654.  
  1655. -- Servant of Therazane (npc=44131) blm di spawnin + nambah npc 42527.
  1656. DELETE FROM creature WHERE id IN (44131,42527);
  1657. insert into `creature` (`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
  1658. ('44131','646','1','1','0','0','1517.6','699.724','-52.3827','2.69524','120','5','0','536810','0','1','0','0','0'),
  1659. ('44131','646','1','1','0','0','1508.29','750.546','-47.0196','4.42311','120','5','0','536810','0','1','0','0','0'),
  1660. ('44131','646','1','1','0','0','1424.72','776.723','-69.0664','4.27012','120','5','0','536810','0','1','0','0','0'),
  1661. ('44131','646','1','1','0','0','1265.95','658.418','-70.533','2.34197','120','5','0','536810','0','1','0','0','0'),
  1662. ('44131','646','1','1','0','0','1281.66','612.356','-67.7748','0.563044','120','5','0','536810','0','1','0','0','0'),
  1663. ('44131','646','1','1','0','0','1377.12','625.133','-67.6938','0.403947','120','5','0','536810','0','1','0','0','0'),
  1664. ('44131','646','1','1','0','0','1467.65','665.302','-59.492','0.451074','120','5','0','536810','0','1','0','0','0'),
  1665. ('44131','646','1','1','0','0','1430.81','904.19','-44.1082','3.67089','120','5','0','536810','0','1','0','0','0'),
  1666. ('44131','646','1','1','0','0','1371.59','796.645','-59.401','3.40778','120','5','0','536810','0','1','0','0','0'),
  1667. ('42527','646','1','1','0','0','1318.17','796.55','-66.6176','3.59305','120','5','0','69725','0','1','0','0','0'),
  1668. ('42527','646','1','1','0','0','1310.03','795.374','-66.8357','5.86668','120','5','0','69725','0','1','0','0','0'),
  1669. ('42527','646','1','1','0','0','1314.64','789.844','-67.5533','2.50174','120','5','0','69725','0','1','0','0','0'),
  1670. ('42527','646','1','1','0','0','1348.93','623.91','-65.7507','3.71358','120','5','0','69725','0','1','0','0','0'),
  1671. ('44131','646','1','1','0','0','1391.74','783.11','-60.1088','1.52232','120','5','0','536810','0','1','0','0','0'),
  1672. ('44131','646','1','1','0','0','1341.42','623.948','-65.9816','6.23078','120','5','0','536810','0','1','0','0','0');
  1673.  
  1674. -- Object Jade Crystal Cluster untuk quest Unsolid Ground belum di spawnin.
  1675. DELETE FROM gameobject WHERE id=204253;
  1676. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1677. ('204253','646','1','1','1375.07','43.9304','-86.804','4.0124','0','0','0.9067','-0.421777','300','0','1'),
  1678. ('204253','646','1','1','1376.98','-15.1952','-88.1964','5.34956','0','0','0.450043','-0.893007','300','0','1'),
  1679. ('204253','646','1','1','1372.03','-38.3497','-88.4397','0.201259','0','0','0.10046','0.994941','300','0','1'),
  1680. ('204253','646','1','1','1367.56','-54.6821','-87.7086','2.42238','0','0','0.936036','0.351904','300','0','1'),
  1681. ('204253','646','1','1','1359.21','-61.9402','-88.248','2.7813','0','0','0.983817','0.179174','300','0','1'),
  1682. ('204253','646','1','1','1342.54','-54.7637','-89.873','4.50524','0','0','0.776425','-0.630209','300','0','1'),
  1683. ('204253','646','1','1','1455.77','37.7829','-85.1783','5.82874','0','0','0.225272','-0.974296','300','0','1'),
  1684. ('204253','646','1','1','1454.96','-24.7088','-81.4395','0.385931','0','0','0.19177','0.98144','300','0','1'),
  1685. ('204253','646','1','1','1464.57','-11.9729','-81.3723','5.02372','0','0','0.588928','-0.808185','300','0','1'),
  1686. ('204253','646','1','1','1407.01','-47.4291','-79.9226','3.75488','0','0','0.953353','-0.301859','300','0','1'),
  1687. ('204253','646','1','1','1359.88','43.7822','-85.4161','2.70635','0','0','0.976414','0.215908','300','0','1'),
  1688. ('204253','646','1','1','1325.83','-7.12315','-85.7792','3.21777','0','0','0.999275','-0.0380805','300','0','1'),
  1689. ('204253','646','1','1','1329.03','2.83018','-86.4211','5.55586','0','0','0.355699','-0.934601','300','0','1'),
  1690. ('204253','646','1','1','1306.86','-40.1938','-86.7596','3.91712','0','0','0.925756','-0.378121','300','0','1'),
  1691. ('204253','646','1','1','1283.1','8.35137','-88.3623','3.62041','0','0','0.971478','-0.237129','300','0','1');
  1692.  
  1693. -- Object untuk quest Depth of the Depths belum di spawnin.
  1694. DELETE FROM gameobject WHERE id=204959;
  1695. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('204959','646','1','1','2088.26','-338.69','-160.019','0.322741','0','0','0.160671','0.987008','300','0','1');
  1696.  
  1697. -- Chalky Crystal Formation belum di spawnin.
  1698. DELETE FROM gameobject WHERE id=204296;
  1699. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1700. ('204296','646','1','1','1335.26','1400.72','28.4012','3.48375','0','0','0.985402','-0.170243','90','0','1'),
  1701. ('204296','646','1','1','1290.7','1466.19','25.9289','0.389276','0','0','0.193411','0.981118','90','0','1'),
  1702. ('204296','646','1','1','1286.9','1297.94','43.5642','3.78613','0','0','0.94852','-0.316718','90','0','1'),
  1703. ('204296','646','1','1','1390.61','1472.08','26.2077','4.44237','0','0','0.795847','-0.605498','90','0','1'),
  1704. ('204296','646','1','1','1030.39','1351.73','38.6092','4.26304','0','0','0.84687','-0.531799','90','0','1'),
  1705. ('204296','646','1','1','976.404','1444.12','28.3743','2.05607','0','0','0.856286','0.516502','90','0','1'),
  1706. ('204296','646','1','1','1152.51','1250.9','50.1513','3.3127','0','0','0.996342','-0.0854517','90','0','1'),
  1707. ('204296','646','1','1','1334.46','1560.49','26.8374','1.45599','0','0','0.665372','0.746512','90','0','1'),
  1708. ('204296','646','1','1','1221.29','1433.93','31.966','1.36196','0','0','0.629556','0.776955','90','0','1'),
  1709. ('204296','646','1','1','1228.94','1330.18','39.0957','5.42639','0','0','0.415416','-0.909632','90','0','1'),
  1710. ('204296','646','1','1','1124.48','1467.07','32.4933','0.367236','0','0','0.182588','0.98319','90','0','1');
  1711.  
  1712. -- Opal Stonethrower (http://www.wowhead.com/npc=43586)
  1713. DELETE FROM creature WHERE id=43586;
  1714. insert into `creature` ( `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
  1715. ('43586','646','1','1','0','0','2145.86','993.693','133.156','5.51718','300','0','0','536810','0','0','0','0','0'),
  1716. ('43586','646','1','1','0','0','2306.56','486.901','163.473','1.65329','300','0','0','536810','0','0','0','0','0'),
  1717. ('43586','646','1','1','0','0','2297.21','522.286','155.002','1.44908','300','0','0','536810','0','0','0','0','0'),
  1718. ('43586','646','1','1','0','0','2363.41','501.597','164.769','1.92426','300','0','0','536810','0','0','0','0','0'),
  1719. ('43586','646','1','1','0','0','2148.7','1049.58','134.229','5.69024','300','0','0','536810','0','0','0','0','0');
  1720.  
  1721. -- Rockcandy Credit untuk quest Don't Stop Moving
  1722. DELETE FROM creature WHERE id=43597;
  1723. insert into `creature` ( `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('43597','646','1','1','0','0','2317.02','511.822','158.971','1.44253','300','0','0','42','0','0','0','0','0');
  1724.  
  1725. -- Pale Resonating Crystal belum di spawnin.
  1726. DELETE FROM gameobject WHERE id=204837;
  1727. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values('204837','646','1','1','1952.63','1397.09','181.917','5.64684','0','0','0.312831','-0.949809','300','0','1');
  1728.  
  1729. -- Verlok Miracle-Grow belum di spawnin.
  1730. DELETE FROM gameobject WHERE id=204410;
  1731. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1732. ('204410','646','1','1','1937.1','-442.784','174.525','4.66746','0','0','0.722813','-0.691043','90','0','1'),
  1733. ('204410','646','1','1','1955.58','-433.58','173.979','0.479993','0','0','0.237699','0.971339','90','0','1'),
  1734. ('204410','646','1','1','1957.19','-488.589','172.778','4.29311','0','0','0.83878','-0.54447','90','0','1'),
  1735. ('204410','646','1','1','1956.07','-487.595','172.876','2.32975','0','0','0.918739','0.394866','90','0','1'),
  1736. ('204410','646','1','1','1946.2','-491.489','173.039','4.32954','0','0','0.828725','-0.559657','90','0','1'),
  1737. ('204410','646','1','1','1975.08','-518.58','172.899','2.6802','0','0','0.973507','0.228656','90','0','1'),
  1738. ('204410','646','1','1','1975.97','-506.977','172.857','3.37528','0','0','0.993182','-0.116576','90','0','1'),
  1739. ('204410','646','1','1','1979.28','-509.1','172.865','5.5544','0','0','0.356381','-0.934341','90','0','1'),
  1740. ('204410','646','1','1','1980.08','-522.758','173.121','0.909376','0','0','0.439182','0.898398','90','0','1'),
  1741. ('204410','646','1','1','1961.41','-534.483','175.799','5.9045','0','0','0.188212','-0.982129','90','0','1'),
  1742. ('204410','646','1','1','1952.42','-491.96','172.848','1.0804','0','0','0.514309','0.857605','90','0','1'),
  1743. ('204410','646','1','1','1945.24','-458.851','175.118','1.63684','0','0','0.730066','0.683376','90','0','1'),
  1744. ('204410','646','1','1','1964.21','-453.854','171.919','1.39628','0','0','0.642795','0.766038','90','0','1'),
  1745. ('204410','646','1','1','1963.43','-456.228','171.934','0.886657','0','0','0.428949','0.903329','90','0','1'),
  1746. ('204410','646','1','1','1960.72','-409.647','173.561','2.30037','0','0','0.91284','0.408317','90','0','1'),
  1747. ('204410','646','1','1','1961.78','-410.825','173.484','2.30037','0','0','0.91284','0.408317','90','0','1'),
  1748. ('204410','646','1','1','1952.25','-423.525','176.238','3.3676','0','0','0.993622','-0.112764','90','0','1'),
  1749. ('204410','646','1','1','1938.85','-442.452','174.974','0.289932','0','0','0.144459','0.989511','90','0','1'),
  1750. ('204410','646','1','1','1923.9','-443.04','173.299','0.835785','0','0','0.405835','0.913946','90','0','1');
  1751.  
  1752. -- Npc kill credit untuk quest A Head Full of Wind
  1753. DELETE FROM creature WHERE id=43370;
  1754. insert into `creature` (`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
  1755. ('43370','646','1','1','0','0','1516.52','-841.081','276.444','0.365491','300','0','0','5808','0','0','0','0','0'),
  1756. ('43370','646','1','1','0','0','1510.06','-845.597','277.312','3.56785','300','0','0','5808','0','0','0','0','0'),
  1757. ('43370','646','1','1','0','0','1500.95','-845.009','277.268','3.17185','300','0','0','5808','0','0','0','0','0'),
  1758. ('43370','646','1','1','0','0','1492.3','-839.839','276.52','2.51822','300','0','0','5808','0','0','0','0','0'),
  1759. ('43370','646','1','1','0','0','1485.21','-838.65','276.823','3.02785','300','0','0','5808','0','0','0','0','0'),
  1760. ('43370','646','1','1','0','0','1477.34','-840.753','276.719','3.31135','300','0','0','5808','0','0','0','0','0'),
  1761. ('43370','646','1','1','0','0','1469.34','-842.755','276.45','3.64885','300','0','0','5808','0','0','0','0','0'),
  1762. ('43370','646','1','1','0','0','1461.55','-848.233','277.108','3.81647','300','0','0','5808','0','0','0','0','0'),
  1763. ('43370','646','1','1','0','0','1453.55','-852.411','276.916','3.36422','300','0','0','5808','0','0','0','0','0'),
  1764. ('43370','646','1','1','0','0','1441.25','-851.562','277.024','3.0301','300','0','0','5808','0','0','0','0','0'),
  1765. ('43370','646','1','1','0','0','1431.73','-849.032','277.328','2.7466','300','0','0','5808','0','0','0','0','0'),
  1766. ('43370','646','1','1','0','0','1425.74','-844.019','277.336','2.23697','300','0','0','5808','0','0','0','0','0'),
  1767. ('43370','646','1','1','0','0','1420.46','-837.305','277.473','2.23697','300','0','0','5808','0','0','0','0','0'),
  1768. ('43370','646','1','1','0','0','1412.99','-829.117','279.534','2.4091','300','0','0','5808','0','0','0','0','0'),
  1769. ('43370','646','1','1','0','0','1507.59','-845.55','277.68','0.0719466','300','0','0','5808','0','0','0','0','0'),
  1770. ('43370','646','1','1','0','0','1516','-840.394','276.617','0.689572','300','0','0','5808','0','0','0','0','0'),
  1771. ('43370','646','1','1','0','0','1524.15','-835.809','277.149','0.348697','300','0','0','5808','0','0','0','0','0'),
  1772. ('43370','646','1','1','0','0','1555.85','-831.841','279.274','0.554143','300','0','0','5808','0','0','0','0','0'),
  1773. ('43370','646','1','1','0','0','1564.1','-823.513','277.938','0.605194','300','0','0','5808','0','0','0','0','0'),
  1774. ('43370','646','1','1','0','0','1574.68','-821.044','277.949','0.00436425','300','0','0','5808','0','0','0','0','0'),
  1775. ('43370','646','1','1','0','0','1585.91','-819.892','277.485','0.00436425','300','0','0','5808','0','0','0','0','0'),
  1776. ('43370','646','1','1','0','0','1598.07','-819.839','278.325','0.00436425','300','0','0','5808','0','0','0','0','0'),
  1777. ('43370','646','1','1','0','0','1610.53','-814.607','279.51','0.453239','300','0','0','5808','0','0','0','0','0'),
  1778. ('43370','646','1','1','0','0','1620.6','-806.034','282.148','1.07086','300','0','0','5808','0','0','0','0','0'),
  1779. ('43370','646','1','1','0','0','1617.22','-794.945','277.528','1.68961','300','0','0','5808','0','0','0','0','0'),
  1780. ('43370','646','1','1','0','0','1619.25','-778.946','277.031','0.688231','300','0','0','5808','0','0','0','0','0'),
  1781. ('43370','646','1','1','0','0','1634.23','-772.979','277.558','0.124606','300','0','0','5808','0','0','0','0','0'),
  1782. ('43370','646','1','1','0','0','1646.39','-765.801','278.24','0.512731','300','0','0','5808','0','0','0','0','0');
  1783.  
  1784. -- Npc Therazane (42465) belum di spawnin.
  1785. DELETE FROM creature WHERE id=42465;
  1786. insert into `creature` (`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('42465','646','1','1','0','0','2386.37','179.27','182.328','2.93875','300','0','0','11736200','0','0','0','0','0');
  1787.  
  1788. -- Npc untuk quest Rallying the Earthen Ring belum di spawnin.
  1789. DELETE FROM creature WHERE id IN (44634,44646,44631,45034,43836,44647,44633,44642,44644);
  1790. insert into `creature` (`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
  1791. ('43836','646','1','1','0','0','970.269','605.548','-36.4349','0.362032','90','0','0','139450','0','0','0','0','0'),
  1792. ('44631','646','1','1','0','0','1090.67','579.21','-44.9881','2.2075','90','0','0','322086','0','0','0','0','0'),
  1793. ('44633','646','1','1','0','0','1077.97','430.098','-45.185','2.33044','90','5','0','322086','0','1','0','0','0'),
  1794. ('44634','646','1','1','0','0','1058.86','632.703','-45.3642','1.52495','90','0','0','322086','0','0','0','0','0'),
  1795. ('44642','646','1','1','0','0','1104.28','506.158','-44.9227','4.95849','90','0','0','322086','0','0','0','0','0'),
  1796. ('44644','646','1','1','0','0','1116.07','501.397','-45.3803','4.17889','90','0','0','322086','0','0','0','0','0'),
  1797. ('44646','646','1','1','0','0','1058.69','637.723','-45.7417','4.50278','90','0','0','41835','0','0','0','0','0'),
  1798. ('44646','646','1','1','0','0','1098.36','442.28','-45.5076','2.88808','90','0','0','41835','0','0','0','0','0'),
  1799. ('44647','646','1','1','0','0','1043.98','414.537','-41.5979','0.692891','90','0','0','4646','0','0','0','0','0'),
  1800. ('45034','646','1','1','0','0','1069.48','575.069','-44.4893','0.690805','90','0','0','34848','0','0','0','0','0');
  1801.  
  1802. -- NPC 43818 belum di spawnin.
  1803. DELETE FROM creature WHERE id=43818;
  1804. insert into creature (`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
  1805. ('43818','646','1','1','0','0','1022.78','538.414','-49.3337','4.08647','300','0','0','850215','0','0','0','0','0');
  1806.  
  1807. -- Nambah spawn NPC 48639
  1808. DELETE FROM creature WHERE id=48639;
  1809. insert into creature (`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
  1810. ('48639','646','1','1','0','0','1961.15','-362.723','-156.995','5.13908','120','0','0','223120','0','0','0','0','0'),
  1811. ('48639','646','1','1','0','0','2066.35','-424','-143.01','1.26305','120','0','0','223120','0','0','0','0','0');
  1812.  
  1813. -- Object Sprouting Crimson Mushroom belum di spawnin.
  1814. DELETE FROM gameobject WHERE id IN (205152,205147,205146,205151);
  1815. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1816. ('205152','646','1','1','1313.28','-925.955','278.891','5.86093','0','0','0.209562','-0.977795','300','0','1'),
  1817. ('205152','646','1','1','1343.8','-854.552','278.912','0.5752','0','0','0.283652','0.958927','300','0','1'),
  1818. ('205152','646','1','1','1201.54','-925.05','284.304','5.18942','0','0','0.520025','-0.854151','300','0','1'),
  1819. ('205152','646','1','1','1341.47','-895.283','278.763','3.61863','0','0','0.971689','-0.236265','300','0','1'),
  1820. ('205152','646','1','1','1366.95','-812.029','279.031','1.66073','0','0','0.738176','0.674608','300','0','1'),
  1821. ('205152','646','1','1','1417.53','-825.644','279.726','0.741812','0','0','0.36246','0.931999','300','0','1'),
  1822. ('205152','646','1','1','1463.12','-844.723','277.702','2.42912','0','0','0.937217','0.348747','300','0','1'),
  1823. ('205152','646','1','1','1150.71','-906.718','286.449','5.88761','0','0','0.196499','-0.980504','300','0','1'),
  1824. ('205152','646','1','1','1384.72','-744.885','279.695','0.877966','0','0','0.425019','0.905184','300','0','1'),
  1825. ('205152','646','1','1','1360.36','-704.921','279.647','2.64904','0','0','0.969827','0.243794','300','0','1'),
  1826. ('205152','646','1','1','1330.47','-625.815','279.788','3.04175','0','0','0.998754','0.049903','300','0','1'),
  1827. ('205152','646','1','1','1371.61','-596.974','279.715','6.2776','0','0','0.0027906','-0.999996','300','0','1'),
  1828. ('205152','646','1','1','1382.64','-658.885','279.8','4.86187','0','0','0.652331','-0.757934','300','0','1'),
  1829. ('205152','646','1','1','1406.26','-725.987','280.289','5.08178','0','0','0.56522','-0.82494','300','0','1'),
  1830. ('205152','646','1','1','1421.44','-767.486','279.444','0.919174','0','0','0.443578','0.896236','300','0','1'),
  1831. ('205152','646','1','1','1389.64','-561.398','278.818','1.67708','0','0','0.743669','0.668548','300','0','1'),
  1832. ('205152','646','1','1','1384.18','-520.258','276.611','1.70457','0','0','0.752788','0.658263','300','0','1'),
  1833. ('205152','646','1','1','1377.1','-482.243','273.272','1.51608','0','0','0.687499','0.726186','300','0','1'),
  1834. ('205152','646','1','1','1311.38','-497.808','272.674','3.35825','0','0','0.994138','-0.108117','300','0','1'),
  1835. ('205152','646','1','1','1250.64','-523.266','271.117','2.49039','0','0','0.947458','0.319881','300','0','1'),
  1836. ('205152','646','1','1','1192.41','-526.55','272.031','2.356','0','0','0.923842','0.382774','300','0','1'),
  1837. ('205152','646','1','1','1115.87','-542.022','276.091','5.37874','0','0','0.436965','-0.899478','300','0','1'),
  1838. ('205152','646','1','1','1143.69','-539.27','275.43','4.64832','0','0','0.729393','-0.684095','300','0','1'),
  1839. ('205152','646','1','1','1706.33','-717.32','278.614','5.77536','0','0','0.251193','-0.967937','300','0','1'),
  1840. ('205152','646','1','1','1671.17','-747.064','278.805','0.332553','0','0','0.165511','0.986208','300','0','1'),
  1841. ('205152','646','1','1','1612.16','-803.037','280.543','0.674204','0','0','0.330754','0.943717','300','0','1'),
  1842. ('205152','646','1','1','1348.37','-657.271','281.36','3.28834','0','0','0.99731','-0.0733056','300','0','1'),
  1843. ('205151','646','1','1','1274.14','-704.718','299.215','4.21246','0','0','0.860048','-0.510214','300','0','1'),
  1844. ('205151','646','1','1','1288.9','-701.088','295.13','4.44808','0','0','0.794117','-0.607764','300','0','1'),
  1845. ('205151','646','1','1','1294.62','-745.303','297.338','4.07108','0','0','0.893937','-0.448193','300','0','1'),
  1846. ('205151','646','1','1','1286.73','-771.398','295.738','4.23506','0','0','0.854228','-0.519898','300','0','1'),
  1847. ('205151','646','1','1','1268.1','-788.673','297.774','3.25331','0','0','0.99844','-0.0558297','300','0','1'),
  1848. ('205151','646','1','1','1289.04','-796.145','290.684','3.56747','0','0','0.977414','-0.211334','300','0','1'),
  1849. ('205151','646','1','1','1304.58','-816.114','286.73','3.9749','0','0','0.914448','-0.404704','300','0','1'),
  1850. ('205151','646','1','1','1276.84','-827.008','291.144','2.06495','0','0','0.85857','0.512697','300','0','1'),
  1851. ('205151','646','1','1','1254.02','-835.618','293.165','2.54358','0','0','0.95563','0.294571','300','0','1'),
  1852. ('205151','646','1','1','1211.67','-859.311','294.831','1.76211','0','0','0.771409','0.636339','300','0','1'),
  1853. ('205151','646','1','1','1189.41','-861.7','294.711','2.26869','0','0','0.906257','0.422727','300','0','1'),
  1854. ('205151','646','1','1','1160.75','-855.027','298.229','1.65176','0','0','0.735143','0.677912','300','0','1'),
  1855. ('205151','646','1','1','1134.81','-847.218','297.842','1.56929','0','0','0.706574','0.70764','300','0','1'),
  1856. ('205151','646','1','1','1112.74','-828.308','298.28','0.532562','0','0','0.263145','0.964756','300','0','1'),
  1857. ('205151','646','1','1','1079.35','-817.84','292.918','6.21897','0','0','0.0321006','-0.999485','300','0','1'),
  1858. ('205151','646','1','1','1094.22','-791.157','299.279','0.0221808','0','0','0.0110902','0.999938','300','0','1'),
  1859. ('205151','646','1','1','1120.64','-754.551','315.142','4.78563','0','0','0.680745','-0.73252','300','0','1'),
  1860. ('205151','646','1','1','1209.13','-657.622','299.082','5.24144','0','0','0.497637','-0.867385','300','0','1'),
  1861. ('205151','646','1','1','1445.07','-613.965','290.967','0.116736','0','0','0.0583349','0.998297','300','0','1'),
  1862. ('205151','646','1','1','1437.75','-577.485','289.065','0.803963','0','0','0.391243','0.920288','300','0','1'),
  1863. ('205151','646','1','1','1465.66','-531.828','288.215','0.84716','0','0','0.411027','0.911623','300','0','1'),
  1864. ('205151','646','1','1','1523.01','-501.029','287.267','6.13289','0','0','0.0750766','-0.997178','300','0','1'),
  1865. ('205151','646','1','1','1594.21','-491.461','284.307','5.04119','0','0','0.581846','-0.813299','300','0','1'),
  1866. ('205151','646','1','1','1632.39','-550.351','294.479','4.47178','0','0','0.786858','-0.617135','300','0','1'),
  1867. ('205151','646','1','1','1659.84','-587.247','290.637','4.60138','0','0','0.745245','-0.66679','300','0','1'),
  1868. ('205151','646','1','1','1643.47','-678.579','286.828','4.38932','0','0','0.811627','-0.584176','300','0','1'),
  1869. ('205151','646','1','1','1615.14','-709.084','285.996','2.91277','0','0','0.993462','0.11416','300','0','1'),
  1870. ('205151','646','1','1','1574.38','-699.881','292.508','2.3787','0','0','0.928128','0.372262','300','0','1'),
  1871. ('205151','646','1','1','1522.49','-716.336','290.687','2.04098','0','0','0.852365','0.522947','300','0','1'),
  1872. ('205151','646','1','1','1471.1','-685.308','293.713','1.32234','0','0','0.614042','0.789274','300','0','1'),
  1873. ('205151','646','1','1','1450.83','-647.409','296.278','6.00332','0','0','0.139477','-0.990225','300','0','1'),
  1874. ('205146','646','1','1','1347.75','-584.58','280.668','4.32649','0','0','0.829575','-0.558395','300','0','1'),
  1875. ('205146','646','1','1','1347.11','-563.754','282.608','1.65613','0','0','0.736622','0.676304','300','0','1'),
  1876. ('205146','646','1','1','1290.03','-562.845','276.306','3.75707','0','0','0.953022','-0.302902','300','0','1'),
  1877. ('205146','646','1','1','1258.67','-523.852','271.731','2.17841','0','0','0.88626','0.463188','300','0','1'),
  1878. ('205146','646','1','1','1183.1','-492.815','273.602','5.24933','0','0','0.494213','-0.869341','300','0','1'),
  1879. ('205146','646','1','1','1136.78','-501.595','277','3.27798','0','0','0.997676','-0.0681393','300','0','1'),
  1880. ('205146','646','1','1','1096.05','-596.374','279.918','2.44938','0','0','0.940701','0.339237','300','0','1'),
  1881. ('205146','646','1','1','1060.72','-587.275','276.216','3.34866','0','0','0.994645','-0.10335','300','0','1'),
  1882. ('205146','646','1','1','1060.85','-681.974','285.544','4.51105','0','0','0.77459','-0.632464','300','0','1'),
  1883. ('205146','646','1','1','1045.07','-677.603','285.12','2.8168','0','0','0.986843','0.161682','300','0','1'),
  1884. ('205146','646','1','1','1014.62','-769.718','282.559','3.64682','0','0','0.968262','-0.249937','300','0','1'),
  1885. ('205146','646','1','1','1069.01','-785.867','290.553','6.21507','0','0','0.0340521','-0.99942','300','0','1'),
  1886. ('205146','646','1','1','1067.41','-862.191','286.022','5.56712','0','0','0.350434','-0.936587','300','0','1'),
  1887. ('205146','646','1','1','1110.42','-863.484','291.869','5.5357','0','0','0.365101','-0.930968','300','0','1'),
  1888. ('205146','646','1','1','1147.29','-899.374','286.838','4.74638','0','0','0.694989','-0.71902','300','0','1'),
  1889. ('205146','646','1','1','1180.93','-892.292','291.072','4.93981','0','0','0.622308','-0.782772','300','0','1'),
  1890. ('205146','646','1','1','1268.03','-859.632','284.614','0.106113','0','0','0.0530315','0.998593','300','0','1'),
  1891. ('205146','646','1','1','1275.6','-878.004','282.747','4.72896','0','0','0.701223','-0.712942','300','0','1'),
  1892. ('205146','646','1','1','1308.28','-832.822','283.117','2.69477','0','0','0.975148','0.221555','300','0','1'),
  1893. ('205146','646','1','1','1439.53','-823.223','279.399','5.49865','0','0','0.382285','-0.924044','300','0','1'),
  1894. ('205146','646','1','1','1472','-805.094','277.258','4.37553','0','0','0.815636','-0.578565','300','0','1'),
  1895. ('205146','646','1','1','1539.71','-788.557','277.637','0.434116','0','0','0.215358','0.976535','300','0','1'),
  1896. ('205146','646','1','1','1587.68','-767.254','280.225','0.347722','0','0','0.172987','0.984924','300','0','1'),
  1897. ('205146','646','1','1','1650.35','-721.584','281.537','0.80718','0','0','0.392722','0.919657','300','0','1'),
  1898. ('205146','646','1','1','1678.57','-746.947','278.567','2.59456','0','0','0.962827','0.270119','300','0','1'),
  1899. ('205146','646','1','1','1704.24','-697.626','278.186','3.6195','0','0','0.971586','-0.236688','300','0','1'),
  1900. ('205146','646','1','1','1706.03','-653.176','279.088','1.29472','0','0','0.603085','0.797677','300','0','1'),
  1901. ('205146','646','1','1','1741.36','-572.401','271.716','3.69805','0','0','0.961544','-0.274651','300','0','1'),
  1902. ('205146','646','1','1','1716.68','-516.298','276.367','2.19008','0','0','0.888947','0.45801','300','0','1'),
  1903. ('205146','646','1','1','1668.81','-479.748','277.409','0.352252','0','0','0.175217','0.98453','300','0','1'),
  1904. ('205146','646','1','1','1642.3','-495.962','281.291','1.23017','0','0','0.577027','0.816725','300','0','1'),
  1905. ('205146','646','1','1','1596.24','-463.167','279.183','3.54766','0','0','0.97946','-0.201641','300','0','1'),
  1906. ('205146','646','1','1','1555.6','-436.654','277.75','2.52664','0','0','0.9531','0.302654','300','0','1'),
  1907. ('205146','646','1','1','1469.26','-493.491','279.765','2.83686','0','0','0.988415','0.151775','300','0','1'),
  1908. ('205146','646','1','1','1435.19','-443.868','268.581','3.61834','0','0','0.971724','-0.236121','300','0','1'),
  1909. ('205146','646','1','1','1383.92','-452.945','273.873','1.05008','0','0','0.501249','0.865303','300','0','1'),
  1910. ('205146','646','1','1','1435.28','-533.095','279.741','6.00435','0','0','0.138966','-0.990297','300','0','1'),
  1911. ('205146','646','1','1','1651.59','-436.22','273.972','3.59319','0','0','0.974615','-0.223886','300','0','1'),
  1912. ('205147','646','1','1','1714.54','-542.584','276.774','5.6745','0','0','0.299664','-0.954045','300','0','1'),
  1913. ('205147','646','1','1','1677.97','-578.577','279.833','3.78562','0','0','0.9486','-0.316478','300','0','1'),
  1914. ('205147','646','1','1','1716.87','-606.316','274.769','5.76306','0','0','0.25714','-0.966374','300','0','1'),
  1915. ('205147','646','1','1','1676.99','-625.953','287.501','4.35721','0','0','0.820901','-0.57107','300','0','1'),
  1916. ('205147','646','1','1','1640.86','-647.687','288.883','3.66213','0','0','0.96632','-0.257342','300','0','1'),
  1917. ('205147','646','1','1','1669.03','-648.464','284.222','5.19367','0','0','0.518212','-0.855252','300','0','1'),
  1918. ('205147','646','1','1','1705.69','-677.137','276.865','5.22116','0','0','0.506408','-0.862294','300','0','1'),
  1919. ('205147','646','1','1','1715.67','-704.385','277.446','1.32165','0','0','0.613769','0.789485','300','0','1'),
  1920. ('205147','646','1','1','1613.04','-744.398','281.115','3.21839','0','0','0.999263','-0.0383892','300','0','1'),
  1921. ('205147','646','1','1','1545.12','-816.531','279.338','3.98023','0','0','0.913366','-0.40714','300','0','1'),
  1922. ('205147','646','1','1','1498.33','-790.997','278.825','2.77857','0','0','0.983572','0.180514','300','0','1'),
  1923. ('205147','646','1','1','1455.75','-778.845','282.432','2.36624','0','0','0.92579','0.378039','300','0','1'),
  1924. ('205147','646','1','1','1427.34','-751.834','279.298','3.05739','0','0','0.999114','0.0420895','300','0','1'),
  1925. ('205147','646','1','1','1419.25','-689.836','284.771','1.83217','0','0','0.793223','0.608931','300','0','1'),
  1926. ('205147','646','1','1','1408.74','-668.727','283.041','5.39002','0','0','0.431885','-0.901929','300','0','1'),
  1927. ('205147','646','1','1','1396.03','-612.241','286.701','2.79777','0','0','0.985259','0.171068','300','0','1'),
  1928. ('205147','646','1','1','1412.96','-552.327','281.345','1.43117','0','0','0.65606','0.754709','300','0','1'),
  1929. ('205147','646','1','1','1352.68','-561.113','282.876','2.97055','0','0','0.996345','0.0854164','300','0','1'),
  1930. ('205147','646','1','1','1349.55','-523.648','275.717','1.29838','0','0','0.604541','0.796574','300','0','1'),
  1931. ('205147','646','1','1','1391.91','-490.707','275.604','0.0181799','0','0','0.00908982','0.999959','300','0','1'),
  1932. ('205147','646','1','1','1445.26','-513.113','284.509','3.43075','0','0','0.989567','-0.144074','300','0','1'),
  1933. ('205147','646','1','1','1041.31','-671.143','285.461','5.88119','0','0','0.199645','-0.979868','300','0','1'),
  1934. ('205147','646','1','1','1027.76','-720.63','283.397','5.93617','0','0','0.172639','-0.984985','300','0','1'),
  1935. ('205147','646','1','1','1045.87','-780.431','289.674','5.26465','0','0','0.487539','-0.873101','300','0','1'),
  1936. ('205147','646','1','1','1011.71','-798.298','282.903','4.95546','0','0','0.616164','-0.787618','300','0','1'),
  1937. ('205147','646','1','1','1116.09','-881.209','293.388','5.78798','0','0','0.245081','-0.969503','300','0','1'),
  1938. ('205147','646','1','1','1189.15','-903.766','291.202','5.76835','0','0','0.254586','-0.96705','300','0','1'),
  1939. ('205147','646','1','1','1238.99','-880.877','286.56','0.0781311','0','0','0.0390556','0.999237','300','0','1'),
  1940. ('205147','646','1','1','1316.89','-870.197','282.524','1.63322','0','0','0.728829','0.684696','300','0','1'),
  1941. ('205147','646','1','1','1360.94','-771.914','279.568','3.97763','0','0','0.913895','-0.405951','300','0','1'),
  1942. ('205147','646','1','1','1330.54','-661.626','282.884','0.290181','0','0','0.144582','0.989493','300','0','1'),
  1943. ('205147','646','1','1','1287.15','-628.74','283.83','2.36756','0','0','0.926039','0.377427','300','0','1'),
  1944. ('205147','646','1','1','1197.51','-617.9','288.42','2.882','0','0','0.991588','0.129434','300','0','1'),
  1945. ('205147','646','1','1','1179.42','-593.511','284.992','3.00373','0','0','0.997625','0.0688753','300','0','1'),
  1946. ('205147','646','1','1','1117.62','-591.574','279.898','2.6935','0','0','0.975007','0.222176','300','0','1'),
  1947. ('205147','646','1','1','1269.29','-524.606','272.57','0.498307','0','0','0.246584','0.969122','300','0','1'),
  1948. ('205147','646','1','1','1504.84','-434.573','276.052','3.11368','0','0','0.999903','0.0139555','300','0','1'),
  1949. ('205147','646','1','1','1571.1','-443.336','279.765','0.961677','0','0','0.462523','0.886607','300','0','1'),
  1950. ('205147','646','1','1','1606.13','-442.53','277.995','3.47889','0','0','0.985812','-0.16785','300','0','1'),
  1951. ('205147','646','1','1','1693.41','-484.695','276.247','2.55212','0','0','0.956879','0.290486','300','0','1'),
  1952. ('205147','646','1','1','1687.44','-526.191','279.417','2.55212','0','0','0.956878','0.290488','300','0','1'),
  1953. ('205147','646','1','1','1527.22','-757.842','283.728','3.2801','0','0','0.997603','-0.0691974','300','0','1'),
  1954. ('205147','646','1','1','1419.99','-575.798','285.901','5.54203','0','0','0.362152','-0.932119','300','0','1');
  1955.  
  1956. -- Object Painite Shard untuk quest Motes blm di spawn.
  1957. DELETE FROM gameobject WHERE id=205195;
  1958. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  1959. ('205195','646','1','1','1880.51','-53.2542','-175.757','2.69819','0','0','0.975524','0.219892','300','0','1'),
  1960. ('205195','646','1','1','1901.2','-105.093','-174.126','3.7608','0','0','0.952455','-0.30468','300','0','1'),
  1961. ('205195','646','1','1','1853.06','-132.008','-171.522','4.11175','0','0','0.884638','-0.466278','300','0','1'),
  1962. ('205195','646','1','1','1848.86','-309.116','-167.357','0.789948','0','0','0.384784','0.923007','300','0','1'),
  1963. ('205195','646','1','1','1949.04','-178.737','-174.766','1.24548','0','0','0.583261','0.812285','300','0','1'),
  1964. ('205195','646','1','1','2012.6','-146.127','-174.695','1.16169','0','0','0.548729','0.836','300','0','1'),
  1965. ('205195','646','1','1','2048.06','-146.612','-173.953','1.24198','0','0','0.581841','0.813303','300','0','1'),
  1966. ('205195','646','1','1','2080.94','-158.48','-174.846','0.774662','0','0','0.377719','0.92592','300','0','1'),
  1967. ('205195','646','1','1','2064.78','-187.204','-175.729','0.523331','0','0','0.25869','0.965961','300','0','1'),
  1968. ('205195','646','1','1','2080.04','-216.029','-172.346','5.01581','0','0','0.592119','-0.80585','300','0','1'),
  1969. ('205195','646','1','1','2023.94','-224.267','-172.765','4.84359','0','0','0.659232','-0.75194','300','0','1'),
  1970. ('205195','646','1','1','2076.55','-247.339','-169.622','2.84083','0','0','0.988714','0.149815','300','0','1'),
  1971. ('205195','646','1','1','2139.24','-258.461','-165.449','2.45599','0','0','0.941816','0.336128','300','0','1'),
  1972. ('205195','646','1','1','2016.69','-354.699','-156.42','2.93116','0','0','0.99447','0.105022','300','0','1'),
  1973. ('205195','646','1','1','1981.59','-281.371','-157.458','2.92723','0','0','0.994262','0.106974','300','0','1'),
  1974. ('205195','646','1','1','1979.54','-280.68','-156.818','2.45207','0','0','0.941156','0.337973','300','0','1'),
  1975. ('205195','646','1','1','2002.84','-263.946','-158.137','0.653506','0','0','0.32097','0.947089','300','0','1'),
  1976. ('205195','646','1','1','1987.64','-239.587','-157.347','2.58951','0','0','0.962142','0.272548','300','0','1'),
  1977. ('205195','646','1','1','1988.74','-236.197','-158.855','3.0616','0','0','0.9992','0.0399847','300','0','1'),
  1978. ('205195','646','1','1','1994.79','-232.157','-160.052','2.0131','0','0','0.844991','0.534781','300','0','1'),
  1979. ('205195','646','1','1','1999.69','-237.848','-158.964','1.95812','0','0','0.829974','0.557802','300','0','1'),
  1980. ('205195','646','1','1','1975.8','-114.461','-176.404','1.24733','0','0','0.584016','0.811742','300','0','1'),
  1981. ('205195','646','1','1','1991.35','-74.6858','-182.136','1.24112','0','0','0.581491','0.813553','300','0','1'),
  1982. ('205195','646','1','1','2015.78','-68.6209','-184.739','1.22892','0','0','0.576516','0.817086','300','0','1'),
  1983. ('205195','646','1','1','2017.51','-63.7603','-185.232','1.22892','0','0','0.576516','0.817086','300','0','1'),
  1984. ('205195','646','1','1','1989.33','-10.8054','-183.342','2.39916','0','0','0.931888','0.362747','300','0','1'),
  1985. ('205195','646','1','1','2070.78','-89.2106','-188.107','5.31299','0','0','0.466294','-0.88463','300','0','1'),
  1986. ('205195','646','1','1','2114','-120.935','-189.093','4.64148','0','0','0.731728','-0.681597','300','0','1'),
  1987. ('205195','646','1','1','2121.31','-78.006','-190.09','2.21139','0','0','0.893776','0.448514','300','0','1'),
  1988. ('205195','646','1','1','2171.68','-119.459','-188.355','4.21203','0','0','0.860158','-0.510027','300','0','1'),
  1989. ('205195','646','1','1','2176.03','-92.125','-188.596','2.08815','0','0','0.864461','0.502701','300','0','1'),
  1990. ('205195','646','1','1','2207.69','-104.998','-182.668','5.95869','0','0','0.161537','-0.986867','300','0','1'),
  1991. ('205195','646','1','1','2244.47','-168.94','-175.559','4.5015','0','0','0.777602','-0.628757','300','0','1'),
  1992. ('205195','646','1','1','2280.14','-215.037','-171.215','5.67019','0','0','0.30172','-0.953396','300','0','1'),
  1993. ('205195','646','1','1','2177.26','-215.561','-164.488','2.21204','0','0','0.893922','0.448223','300','0','1'),
  1994. ('205195','646','1','1','2094.91','-331.285','-160.081','3.1938','0','0','0.999659','-0.0260997','300','0','1'),
  1995. ('205195','646','1','1','2094.95','-347.431','-159.814','3.99284','0','0','0.910781','-0.412889','300','0','1'),
  1996. ('205195','646','1','1','2095.37','-340.031','-160.02','2.90845','0','0','0.993213','0.116306','300','0','1'),
  1997. ('205195','646','1','1','2108.64','-395.787','-146.784','0.742957','0','0','0.362994','0.931792','300','0','1'),
  1998. ('205195','646','1','1','2103.51','-403.656','-146.823','0.884329','0','0','0.427897','0.903828','300','0','1'),
  1999. ('205195','646','1','1','2093.17','-170.7','-158.775','5.27413','0','0','0.483393','-0.875403','300','0','1'),
  2000. ('205195','646','1','1','2084.97','-161.732','-160.573','6.03695','0','0','0.122808','-0.992431','300','0','1'),
  2001. ('205195','646','1','1','2130.73','-191.182','-162.425','4.95124','0','0','0.617823','-0.786317','300','0','1');
  2002.  
  2003. -- Crystal chunk untuk quest Underground Economy.
  2004. DELETE FROM gameobject WHERE id IN (207384,207381,207382,207383);
  2005. insert into `gameobject` (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) values
  2006. ('207381','646','1','1','1949.2','-182.334','-175.013','1.26976','0','0','0.59308','0.805143','300','0','1'),
  2007. ('207381','646','1','1','1953.1','-185.929','-175.897','1.77241','0','0','0.774679','0.632355','300','0','1'),
  2008. ('207381','646','1','1','2021.09','-154.154','-175.979','0.968909','0','0','0.465726','0.884929','300','0','1'),
  2009. ('207381','646','1','1','2033.22','-149.337','-175.938','2.23439','0','0','0.898875','0.438206','300','0','1'),
  2010. ('207381','646','1','1','2055.96','-181.688','-176.06','0.488806','0','0','0.241977','0.970282','300','0','1'),
  2011. ('207381','646','1','1','2051.93','-177.157','-176.301','0.0411286','0','0','0.0205628','0.999789','300','0','1'),
  2012. ('207381','646','1','1','2029.44','-204.699','-175.463','3.94631','0','0','0.920139','-0.391591','300','0','1'),
  2013. ('207381','646','1','1','2030.13','-230.077','-171.721','4.35472','0','0','0.821613','-0.570046','300','0','1'),
  2014. ('207383','646','1','1','2133.13','-223.081','-166.387','3.93036','0','0','0.923233','-0.38424','300','0','1'),
  2015. ('207383','646','1','1','2149.73','-269.644','-164.22','2.90935','0','0','0.993265','0.115861','300','0','1'),
  2016. ('207383','646','1','1','2137.83','-260.858','-164.725','5.20707','0','0','0.512468','-0.858706','300','0','1'),
  2017. ('207383','646','1','1','2173.11','-257.036','-166.426','6.06738','0','0','0.107692','-0.994184','300','0','1'),
  2018. ('207383','646','1','1','2176.95','-248.782','-166.223','3.98609','0','0','0.912171','-0.409811','300','0','1'),
  2019. ('207383','646','1','1','2170.05','-218.096','-166.452','5.19707','0','0','0.516755','-0.856133','300','0','1'),
  2020. ('207383','646','1','1','2167.5','-213.238','-166.366','5.19707','0','0','0.516755','-0.856133','300','0','1'),
  2021. ('207382','646','1','1','2162.95','-118.115','-190.749','5.18889','0','0','0.520254','-0.854012','300','0','1'),
  2022. ('207382','646','1','1','2142.24','-130.356','-189.664','3.47672','0','0','0.985994','-0.16678','300','0','1'),
  2023. ('207382','646','1','1','2126.41','-121.444','-190.605','3.52777','0','0','0.981416','-0.191891','300','0','1'),
  2024. ('207382','646','1','1','2116.06','-89.1255','-190.216','1.81475','0','0','0.787888','0.615818','300','0','1'),
  2025. ('207382','646','1','1','2148.68','-76.7039','-190.642','0.448152','0','0','0.222206','0.975','300','0','1'),
  2026. ('207382','646','1','1','2167.11','-91.8009','-190.849','1.39063','0','0','0.640628','0.767852','300','0','1'),
  2027. ('207384','646','1','1','2078.73','-360.611','-159.053','3.62901','0','0','0.97045','-0.241303','300','0','1'),
  2028. ('207384','646','1','1','2074.36','-359.43','-159.133','0.22695','0','0','0.113232','0.993569','300','0','1'),
  2029. ('207384','646','1','1','2070.99','-360.209','-159.069','0.22695','0','0','0.113232','0.993569','300','0','1'),
  2030. ('207384','646','1','1','2073.62','-322.387','-159.352','0.65113','0','0','0.319844','0.94747','300','0','1'),
  2031. ('207384','646','1','1','2080.08','-322.107','-159.624','4.07226','0','0','0.893673','-0.448719','300','0','1'),
  2032. ('207384','646','1','1','2096.51','-310.429','-158.862','2.52462','0','0','0.952794','0.303618','300','0','1');
  2033.  
  2034. -- END OF LINE --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!