Advertisement
bucur35

Untitled

Jan 22nd, 2013
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.26 KB | None | 0 0
  1. -- "The Firelord"
  2.  
  3. UPDATE `creature_template` SET `minlevel`=88, `maxlevel`=88, `faction_A`=16, `faction_H`=16, `npcflag`=0, `mindmg`=7500, `maxdmg`=7800 WHERE  `entry`=40793;
  4. UPDATE `creature_template` SET `dmg_multiplier`=7.5 WHERE  `entry`=40793;
  5.      
  6. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=41631;
  7. UPDATE `creature_template` SET `gossip_menu_id`=41631 WHERE  `entry`=41631;
  8. UPDATE `creature_template` SET `npcflag`=1 WHERE  `entry`=41631;
  9.      
  10. DELETE FROM `npc_text` WHERE `ID`=41631;
  11. INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `WDBVerified`) VALUES
  12. (41631, 'Be wary, allies. There are bound to be traps to protect the Firelord from our incusion.', NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 1);
  13.      
  14. DELETE FROM `gossip_menu_option` WHERE `menu_id`=41631;
  15. 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
  16. (41631, 0, 0, 'Im ready to begin the battle against Ragnaros.', 1, 1, 0, 0, 0, 0, NULL);
  17.      
  18. DELETE FROM `gossip_menu` WHERE `entry`=41631;
  19. INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
  20. (41631, 41631);
  21.      
  22. DELETE FROM `waypoints` WHERE  `entry`=41631;
  23. INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
  24. (41631, 1, 3964.78, -2858.74, 613.974 , 'Cenarius WP 1'),
  25. (41631, 2, 3974.37, -2885.12, 608.155, 'Cenarius WP 2'),
  26. (41631, 3, 3987.47, -2906.50, 600.667, 'Cenarius WP 3'),
  27. (41631, 4, 3994.63, -2939.68, 591.134, 'Cenarius WP 4'),
  28. (41631, 5, 4008.08, -2975.31, 577.5808, 'Cenarius WP 5'),
  29. (41631, 6, 4013.83, -3016.06, 575.3902, 'Cenarius WP 6');
  30.      
  31. UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=40793;
  32. DELETE FROM `smart_scripts` WHERE  `entryorguid`=41631;
  33. DELETE FROM `smart_scripts` WHERE  `entryorguid`=40793;
  34. 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
  35. (41631, 0, 0, 1, 62, 0, 100, 0, 41631, 0, 0, 0, 53, 1, 41631, 0, 25551, 300000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 'On Gossip - Start WP'),
  36. (41631, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 'On Link - Close Gossip'),
  37. (41631, 0, 2, 3, 62, 0, 100, 0, 41631, 0, 0, 0, 83, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Remove flag'),
  38. (41631, 0, 3, 4, 40, 0, 100, 0, 6, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 9, 40793, 10, 20, 0, 0, 0, 0, 'On WP Reach - Attack'),
  39. (41631, 0, 4, 0, 61, 0, 100, 1, 0, 0, 0, 0, 11, 76395, 2, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 'On Link - Cast aura'),
  40. (41631, 0, 5, 0, 36, 0, 100, 0, 0, 0, 0, 0, 82, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Gossip - Add flag'),
  41. (40793, 0, 0, 0, 0, 0, 100, 0, 2000, 3000, 3000, 4000, 11, 76246, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 'IC - Cast Searing Flame'),
  42. (40793, 0, 1, 0, 0, 0, 100, 0, 4000, 5000, 5000, 5000, 11, 84402, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 'IC - Cast Wrath of Ragnaros'),
  43. (40793, 0, 2, 3, 6, 0, 100, 0, 0, 0, 0, 0, 28, 76395, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 'On Ragnaros Death - Remove aura'),
  44. (40793, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 33, 40793, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 'On Ragnaros Death - Give Credit');
  45.      
  46. DELETE FROM `conditions` WHERE `SourceGroup`=41631;
  47. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
  48. (15, 41631, 0, 0, 0, 9, 0, 25551, 0, 0, 0, 0, '', 'show gossip if player has quest');
  49.      
  50. UPDATE `creature_template` SET `faction_A`=35, `faction_H`=35 WHERE `entry`=41631;
  51. UPDATE `creature_template` SET `speed_walk`=0.1, `speed_run`=0.1 WHERE  `entry`=40793;
  52. UPDATE `creature_template` SET `exp`=2, `Health_mod`=1534.5 WHERE  `entry`=41631;
  53. UPDATE `creature_template` SET `exp`=2, `Health_mod`=2230 WHERE  `entry`=40793;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement