Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 25th, 2012  |  syntax: None  |  size: 12.29 KB  |  hits: 11  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. UPDATE  quest_template SET  RequestItemsText='This shard of ice echoes the deep,cracking rumble of invading glaciers.  Its cold turns your thoughts to a lifeless,endless winter.' WHERE Id=11691;
  2.  
  3. UPDATE  creature_template SET  minlevel=76,maxlevel=76 WHERE  entry=25697;
  4.  
  5. UPDATE  creature_template SET  minlevel=75,maxlevel=75 WHERE  entry=25754;
  6.  
  7. UPDATE  creature_template SET  minlevel=20,maxlevel=20 WHERE  entry=25961;
  8.  
  9. DELETE FROM creature_template_addon WHERE entry=25754;
  10.  
  11. INSERT INTO creature_template_addon (entry,path_id,mount,bytes1,bytes2,emote,auras) VALUES (25754,0,0,1,0,0,NULL);
  12.  
  13. DELETE FROM creature WHERE id IN (25755,25756,25757,25740,25697,25961,25754,40446,25745);
  14.  
  15. DELETE FROM gameobject WHERE id=187882;
  16.  
  17. INSERT INTO gameobject(guid,id,map,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES (187965,187882,547,1,1,-73.4977,-155.976,-1.8987,3.23816,0,0,0.998834,-0.0482674,300,0,1);
  18.  
  19. INSERT INTO creature
  20. (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags) VALUES
  21. (null,25697,547,1,1,0,0,-90.5919,-119.585,-2.27612,2.38759,300,0,0,42,0,0,0,0,0),
  22.  
  23. (null,25961,547,1,1,0,0,-109.22,-120.05,-2.982,0,120,0,0,1,0,0,0,0,0),
  24.  
  25. (null,25961,547,1,1,0,0,-92.68,-119.62,-2.27,0,120,0,0,1,0,0,0,0,0),
  26.  
  27. (null,25754,547,1,1,0,0,-110.19,-116.62,-3.255,0,120,0,0,1,0,0,0,0,0),
  28.  
  29. (null,25754,547,1,1,0,0,-112.2,-120.2,-2.657,0,120,0,0,1,0,0,0,0,0),
  30.  
  31. (null,25754,547,1,1,0,0,-93.18,-115.92,-2.692,0,120,0,0,1,0,0,0,0,0),
  32.  
  33. (null,40446,547,1,1,0,0,-77.2636,-151.912,-1.92421,5.44435,300,0,0,164,300,0,0,0,0),
  34.  
  35. (null,25745,547,1,1,0,0,-97.3569,-222.144,-1.278,1.53498,300,0,0,42,0,0,0,0,0);
  36.  
  37. UPDATE  creature_template SET  minlevel=75,maxlevel=80,faction_A=16,faction_H=16,mindmg=400,maxdmg=500,dmg_multiplier=10,AIName= 'SmartAI',Health_mod=13 WHERE  entry=40446;
  38.  
  39. DELETE FROM smart_scripts WHERE entryorguid IN (40446,187882,18788200,25745,25746);
  40.  
  41. 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
  42. (187882,1,0,1,62,0,100,0,11389,1,0,0,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'On Gossip - close Gossip'),
  43.  
  44. (187882,1,1,0,61,0,100,0,0,0,0,0,80,18788200,0,0,0,0,0,1,0,0,0,0,0,0,0,'On Gossip - call Actionlist'),
  45.  
  46. (187882,9,0,0,0,0,100,0,500,500,0,0,9,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'I  ce Stone - activate'),
  47.  
  48. (187882,9,1,0,0,0,100,0,10000,10000,0,0,12,25740,6,500000,0,0,0,8,0,0,0,-97.3569,-222.144,-1.278,1.5495,'Ice Stone - spawn Ahune'),
  49.  
  50. (25745,0,0,0,1,0,100,0,1000,1000,15000,15000,11,45945,1,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - Slippery Floor'),
  51.  
  52. (25746,0,0,0,54,0,100,0,0,0,0,0,11,45939,1,0,0,0,0,1,0,0,0,0,0,0,0,'Ice Chest bunny - summon Ice Chest');
  53.  
  54. DELETE FROM gossip_menu WHERE entry=11389;
  55.  
  56. INSERT INTO gossip_menu VALUES (11389,15864);
  57.  
  58. DELETE FROM gossip_menu_option WHERE menu_id=11389;
  59.  
  60. 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
  61. (11389,1,0,'Disturb the stone and summon Lord Ahune.',1,1,0,0,0,0,NULL);
  62.  
  63. UPDATE  creature_template SET  difficulty_entry_1=0,minlevel=82,maxlevel=82,unit_flags=4,lootid=0 WHERE  entry=25740;
  64.  
  65. DELETE FROM gameobject_questrelation WHERE id=187882 AND quest=25484;
  66.  
  67. INSERT INTO gameobject_questrelation (id,quest) VALUES (187882,25484);
  68.  
  69. DELETE FROM creature_involvedrelation WHERE id=25697 AND quest=25484;
  70.  
  71. INSERT INTO creature_involvedrelation (id,quest) VALUES (25697,25484);
  72.  
  73. DELETE FROM conditions WHERE SourceGroup=11389 AND SourceEntry=1;
  74.  
  75. INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition,ErrorTextId,ScriptName,Comment) VALUES
  76. (15,11389,1,0,0,9,0,25484,0,0,0,0,'',NULL),
  77.  
  78. (15,11389,1,0,1,28,0,25484,0,0,0,0,'',NULL);
  79.  
  80. UPDATE  quest_template SET  Objectives= 'Defeat Ahune in Slave Pens.',Details= 'Activate Ice Stone and summon Ahune.',CompletedText= 'Return to Luma Skymother in Slave Pens.',RequiredNpcOrGo1=25740,RequiredNpcOrGoCount1=1 WHERE  Id=25484;
  81.  
  82. DELETE FROM creature_ai_scripts WHERE creature_id IN (25740,25755,25756);
  83.  
  84. DELETE FROM item_loot_template WHERE entry=54536;
  85.  
  86. INSERT INTO item_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES
  87. (54536,54806,6,1,0,1,1),
  88.  
  89. (54536,53641,3,1,0,1,1),
  90.  
  91. (54536,47241,100,1,0,2,2);
  92.  
  93.  
  94. DELETE FROM spell_linked_spell WHERE spell_trigger=46198;
  95.  
  96. INSERT INTO spell_linked_spell (spell_trigger,spell_effect,type,comment) VALUES
  97. (46198,10689,0,'');
  98. UPDATE  creature_template SET  AIName= 'SmartAI',flags_extra=130 WHERE  entry=25745;
  99.  
  100. UPDATE  creature_template SET  AIName= 'SmartAI',flags_extra=130 WHERE  entry=25746;
  101.  
  102. UPDATE  creature_template SET  difficulty_entry_1=0,minlevel=80,maxlevel=80,mindmg=422,maxdmg=586,attackpower=642,dmg_multiplier=13,Health_mod=18.77 WHERE  entry=25755;
  103.  
  104. UPDATE  creature_template SET  difficulty_entry_1=0,minlevel=80,maxlevel=80,mindmg=422,maxdmg=586,attackpower=642,dmg_multiplier=2,Health_mod=3.6 WHERE  entry=25756;
  105.  
  106. DELETE FROM creature_text WHERE entry=25740;
  107.  
  108. INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
  109. (25740,0,0,'Ahune Retreats! His defenses diminish',41,0,100,0,0,0,'');
  110.  
  111. UPDATE  creature_template SET  difficulty_entry_1=0,minlevel=80,maxlevel=80,mindmg=0,maxdmg=0,dmg_multiplier=0,unit_flags=262148,AIName= 'SmartAI' WHERE  entry=25865;
  112.  
  113. DELETE FROM creature_text WHERE entry=40446;
  114.  
  115. INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
  116. (40446,0,0,'How DARE you! You will not stop the coming of Lord Ahune!',14,0,100,0,0,0,'');
  117.  
  118. 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
  119. (40446,0,0,0,0,0,100,0,5000,5000,15000,15000,11,55909,1,0,0,0,0,2,0,0,0,0,0,0,0,'Skar''this the Summoner - cast Crashing Wave'),
  120.  
  121. (40446,0,1,0,0,0,100,0,10000,10000,20000,20000,11,11831,1,0,0,0,0,2,0,0,0,0,0,0,0,'Skar''this the Summoner - cast Frost Nova'),
  122.  
  123. (40446,0,2,0,0,0,100,0,7000,7000,9000,9000,11,15043,0,0,0,0,0,2,0,0,0,0,0,0,0,'Skar''this the Summoner - cast Frostbolt'),
  124.  
  125. (40446,0,3,0,0,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Skar''this the Summoner - On agro - say');
  126.  
  127. -- Ahunite Hailstone
  128. DELETE FROM smart_scripts WHERE entryorguid=25755;
  129.  
  130. 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
  131. (25755,0,0,0,1,0,100,1,0,0,0,0,46,30,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahunite Hailstone - OOC move forward'),
  132.  
  133. (25755,0,1,0,54,0,100,0,0,0,0,0,75,46542,0,0,0,0,0,1,0,0,0,0,0,0,0,'On Spawn Cast Chilling Aura'),
  134.  
  135. (25755,0,2,0,0,0,100,0,6000,6000,6000,6000,11,2676,1,0,0,0,0,2,0,0,0,0,0,0,0,'Ahunite Hailstone - cast Pulverize');
  136.  
  137. -- Ahunite Coldwave
  138. DELETE FROM smart_scripts WHERE entryorguid=25756;
  139.  
  140. 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
  141.  
  142. (25756,0,0,0,0,0,100,0,0,4000,7000,10000,11,46406,1,0,0,0,0,5,0,0,0,0,0,0,0,'Ahunite Coldwave - cast Bitter Blast'),
  143.  
  144. (25756,0,1,0,1,0,100,1,0,0,0,0,46,10,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahunite Coldwave - OOC move forward');
  145.  
  146. -- Frozen Core
  147. DELETE FROM smart_scripts WHERE entryorguid=25865;
  148.  
  149. 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
  150.  
  151. (25865,0,0,1,0,0,100,0,30000,30000,124000,124000,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Frozen Core - Invisible'),
  152.  
  153. (25865,0,1,0,61,0,100,0,0,0,0,0,28,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Frozen Core - remove all auras'),
  154.  
  155. (25865,0,2,0,0,0,100,0,124000,124000,124000,124000,47,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Frozen Core - visible'),
  156.  
  157. (25865,0,3,0,6,0,100,0,0,0,0,0,51,0,0,0,0,0,0,11,25740,10,0,0,0,0,0,'Frozen Core - Kill Ahune');
  158.  
  159.  
  160. -- Ahune scripts
  161. DELETE FROM smart_scripts WHERE entryorguid=25740;
  162.  
  163. 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
  164.  
  165. (25740,0,0,0,54,0,100,1,0,0,0,0,11,50142,0,0,0,0,0,1,0,0,0,0,0,0,0,'On Summon - Emerge from the ground'),
  166.  
  167. (25740,0,1,0,1,0,100,1,0,0,0,0,75,45954,0,0,0,0,0,1,0,0,0,0,0,0,0,'OOC - add Ahune Shield'),
  168.  
  169. (25740,0,2,0,0,0,100,1,100,100,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - In combat set Phase 1'),
  170.  
  171. (25740,0,3,0,0,1,100,0,1000,1000,1000,1000,11,46198,1,0,0,0,0,18,15,0,0,0,0,0,0,'Ahune - Phase 1 cast Cold Slap'),
  172.  
  173. (25740,0,4,0,0,1,100,1,1000,1000,0,0,12,25755,2,30000,0,0,0,8,0,0,0,-97.3569,-222.144,-1.278,1.5495,'Ahune - phase 1 -summon Ahunite Hailstone'),
  174.  
  175. (25740,0,5,0,0,1,100,0,7000,7000,7000,7000,12,25756,2,30000,0,0,0,8,0,0,0,-85.854,-212.93,-1.5521,1.9433,'Ahune - On phase 1 - summon Ahunite Coldwave'),
  176.  
  177. (25740,0,6,0,0,1,100,0,7000,7000,7000,7000,12,25756,2,30000,0,0,0,8,0,0,0,-109.56,-213.42,-1.3973,0.91844,'Ahune - On phase 1 - summon Ahunite Coldwave'),
  178.  
  179. (25740,0,7,0,0,1,100,1,90000,90000,0,0,22,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - set Phase 2'),
  180.  
  181. (25740,0,8,0,0,2,100,0,0,0,0,0,11,68909,1,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - submerge visual'),
  182.  
  183. (25740,0,9,0,0,2,100,1,4000,4000,0,0,75,37550,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - submerge'),
  184.  
  185. (25740,0,10,11,0,2,100,1,4100,4100,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - announce'),
  186.  
  187. (25740,0,11,12,61,2,100,0,0,0,0,0,12,25865,2,15000,0,0,0,8,0,0,0,-97.3569,-222.144,-1.278,1.5495,'Ahune - phase 2 - summon Frozen Core'),
  188.  
  189. (25740,0,12,13,61,2,100,0,0,0,0,0,18,33816580,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - set unit_flags'),
  190.  
  191. (25740,0,13,0,61,2,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - stop auto attack'),
  192.  
  193. (25740,0,14,15,0,2,100,1,34000,34000,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - set phase 1'),
  194.  
  195. (25740,0,15,16,61,1,100,0,0,0,0,0,28,37550,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - emerge'),
  196.  
  197. (25740,0,16,17,61,1,100,0,0,0,0,0,11,50142,1,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - emerge visual'),
  198.  
  199. (25740,0,17,18,61,1,100,0,0,0,0,0,19,33816576,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - remove unit_flags'),
  200.  
  201. (25740,0,18,0,61,1,100,0,0,0,0,0,20,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 1 - start auto attack'),
  202.  
  203. (25740,0,19,0,0,0,100,1,214100,214100,0,0,18,33816580,0,0,0,0,0,1,0,0,0,0,0,0,0,'Ahune - phase 2 - set unit_flags [2]'),
  204.  
  205. (25740,0,20,21,6,0,100,0,0,0,0,0,12,25746,3,10000,0,0,0,8,0,0,0,-99.4597,-191.873,-1.70578,1.275,'Ahune - On death - Summon Ice Chest bunny'),
  206.  
  207. (25740,0,21,0,61,0,100,0,0,0,0,0,33,25740,0,0,0,0,0,18,200,0,0,0,0,0,0,'Ahune - On death - call killed monster'),
  208.  
  209. (25740,0,22,0,0,0,100,0,4000,4000,4000,4000,11,57454,0,0,0,0,0,5,0,0,0,0,0,0,0,'Ahune - cast Ice Spike');
create a new version of this paste RAW Paste Data