API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 49.75 KB | None | 0 0
raw download clone embed print report
  1. -- Quest: A Special Surprise change Race & NEXT&PREVID
  2. -- Taure
  3. UPDATE `quest_template` SET `RequiredRaces`=32, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12739;
  4. -- Bloodelf
  5. UPDATE `quest_template` SET `RequiredRaces`=512, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12747;
  6. -- Orc
  7. UPDATE `quest_template` SET `RequiredRaces`=2, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12748;
  8. -- Troll
  9. UPDATE `quest_template` SET `RequiredRaces`=128, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12749;
  10. -- Undead
  11. UPDATE `quest_template` SET `RequiredRaces`=16, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12750;
  12. -- Goblin Not Test
  13. UPDATE `quest_template` SET `RequiredRaces`=2, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=28650;
  14. -- Human
  15. UPDATE `quest_template` SET `RequiredRaces`=1, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12742;
  16. -- Nightelf
  17. UPDATE `quest_template` SET `RequiredRaces`=8, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12743;
  18. -- Gnom
  19. UPDATE `quest_template` SET `RequiredRaces`=64, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12745;
  20. -- Draenei
  21. UPDATE `quest_template` SET `RequiredRaces`=1024, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12746;
  22. -- Dwarf
  23. UPDATE `quest_template` SET `RequiredRaces`=4, `PrevQuestId`=12738, `NextQuestId`=12751, `NextQuestInChain`=12751 WHERE `entry`=12744;
  24. -- Quest: Death's Challenge
  25. UPDATE `quest_template` SET `RequiredRaces`=0, `PrevQuestId`=12670, `NextQuestId`=12697, `ExclusiveGroup`=-12733 WHERE `entry`=12733;
  26. -- Quest: The Lich King's Command
  27. UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=12800;
  28. -- Quest: A Sort Of Homecoming
  29. UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=12751;
  30. -- Quest: The Light of Dawn
  31. UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=12801;
  32. -- Quest: If Chaos Drives, Let Suffering Hold The Reins
  33. UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=12678;
  34. -- Quest: The Gift That Keeps On Giving
  35. UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=12698;
  36. -- Quest: Gothik the Harvester
  37. UPDATE `quest_template` SET `RequiredRaces`=0 WHERE `entry`=12697;
  38. -- Quest: Death Comes From On High
  39. UPDATE `quest_template` SET `QuestFlags`=136, `ReqSpellCast1`=51858 WHERE `entry`=12641;
  40.  
  41. -- more PrevQuestId
  42. UPDATE `quest_template` SET `PrevQuestId`=12727 WHERE `entry`=12738;
  43. UPDATE `quest_template` SET `PrevQuestId`=12725, `NextQuestInChain`=12738 WHERE `entry`=12727;
  44. UPDATE `quest_template` SET `PrevQuestId`=12723, `NextQuestInChain`=12727 WHERE `entry`=12725;
  45. UPDATE `quest_template` SET `PrevQuestId`=12720, `NextQuestInChain`=12724 WHERE `entry`=12723;
  46. UPDATE `quest_template` SET `PrevQuestId`=12719 WHERE `entry`=12720;
  47. UPDATE `quest_template` SET `PrevQuestId`=12715, `NextQuestInChain`=12720 WHERE `entry`=12719;
  48. UPDATE `quest_template` SET `PrevQuestId`=12714, `NextQuestInChain`=12719 WHERE `entry`=12715;
  49. UPDATE `quest_template` SET `PrevQuestId`=12706, `NextQuestInChain`=12715 WHERE `entry`=12714;
  50. UPDATE `quest_template` SET `PrevQuestId`=12701, `NextQuestInChain`=12714 WHERE `entry`=12706;
  51. UPDATE `quest_template` SET `PrevQuestId`=12700, `NextQuestInChain`=12706 WHERE `entry`=12701;
  52. UPDATE `quest_template` SET `PrevQuestId`=12698, `NextQuestInChain`=12701 WHERE `entry`=12700;
  53. UPDATE `quest_template` SET `PrevQuestId`=12697, `NextQuestInChain`=12700 WHERE `entry`=12698;
  54. UPDATE `quest_template` SET `PrevQuestId`=12678, `NextQuestInChain`=12698 WHERE `entry`=12697;
  55. UPDATE `quest_template` SET `PrevQuestId`=12670 WHERE `entry`=12678;
  56. UPDATE `quest_template` SET `PrevQuestId`=12850, `NextQuestInChain`=12678 WHERE `entry`=12670;
  57. UPDATE `quest_template` SET `PrevQuestId`=12657, `NextQuestInChain`=12670 WHERE `entry`=12850;
  58. UPDATE `quest_template` SET `PrevQuestId`=12641, `NextQuestInChain`=12850 WHERE `entry`=12657;
  59. UPDATE `quest_template` SET `PrevQuestId`=12636, `NextQuestInChain`=12657 WHERE `entry`=12641;
  60. UPDATE `quest_template` SET `PrevQuestId`=12848, `NextQuestInChain`=12641 WHERE `entry`=12636;
  61. UPDATE `quest_template` SET `PrevQuestId`=12842, `NextQuestInChain`=12636 WHERE `entry`=12848;
  62. UPDATE `quest_template` SET `PrevQuestId`=12619, `NextQuestInChain`=12848 WHERE `entry`=12842;
  63. UPDATE `quest_template` SET `PrevQuestId`=12593, `NextQuestInChain`=12842 WHERE `entry`=12619;
  64. UPDATE `quest_template` SET `PrevQuestId`=0, `NextQuestInChain`=12619 WHERE `entry`=12593;
  65. UPDATE `quest_template` SET `PrevQuestId`=12670 WHERE `entry`=12680;
  66.  
  67. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28422, 0, 0, 0, 0, 0, 25407, 25408, 0, 0, 'DK (Gnome Female)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  68. DELETE FROM `creature_model_info` WHERE (`modelid`=25407);
  69. REPLACE INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25407, 0, 0, 1, 0);
  70.  
  71. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28421, 0, 0, 0, 0, 0, 25405, 25406, 0, 0, 'DK (Dwarf Female)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  72. DELETE FROM `creature_model_info` WHERE (`modelid`=25405);
  73. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25405, 0, 0, 1, 0);
  74.  
  75. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28425, 0, 0, 0, 0, 0, 25413, 25414, 0, 0, 'DK (Dwarf Male)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  76. DELETE FROM `creature_model_info` WHERE (`modelid`=25413);
  77. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25413, 0, 0, 0, 0);
  78.  
  79. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28430, 0, 0, 0, 0, 0, 25423, 25424, 0, 0, 'DK (Orc Male)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  80. DELETE FROM `creature_model_info` WHERE (`modelid`=25423);
  81. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25423, 0.372, 1.5, 0, 0);
  82.  
  83. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28429, 0, 0, 0, 0, 0, 25421, 25422, 0, 0, 'DK (Blood Elf Male)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  84. DELETE FROM `creature_model_info` WHERE (`modelid`=25421);
  85. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25421, 0, 0, 0, 0);
  86.  
  87. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28437, 0, 0, 0, 0, 0, 25437, 25438, 0, 0, 'DK (Forsaken Female)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  88. DELETE FROM `creature_model_info` WHERE (`modelid`=25437);
  89. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25437, 0, 0, 1, 0);
  90.  
  91. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28429, 0, 0, 0, 0, 0, 25421, 25422, 0, 0, 'DK (Blood Elf Male)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  92. DELETE FROM `creature_model_info` WHERE (`modelid`=25421);
  93. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25421, 0, 0, 0, 0);
  94.  
  95. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28395, 0, 0, 0, 0, 0, 25374, 25375, 0, 0, 'DK (Human Male)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  96. DELETE FROM `creature_model_info` WHERE (`modelid`=25374);
  97. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25374, 0, 0, 0, 0);
  98.  
  99. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28436, 0, 0, 0, 0, 0, 25435, 25436, 0, 0, 'DK (Orc Female)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  100. DELETE FROM `creature_model_info` WHERE (`modelid`=25435);
  101. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25435, 0.236, 1.5, 1, 0);
  102.  
  103. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28433, 0, 0, 0, 0, 0, 25429, 25430, 0, 0, 'DK (Tauren Male)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  104. DELETE FROM `creature_model_info` WHERE (`modelid`=25429);
  105. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25429, 0.9747, 4.05, 0, 0);
  106.  
  107. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28431, 0, 0, 0, 0, 0, 25425, 25426, 0, 0, 'DK (Forsaken Male)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  108. DELETE FROM `creature_model_info` WHERE (`modelid`=25425);
  109. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25425, 0, 0, 0, 0);
  110.  
  111. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (28435, 0, 0, 0, 0, 0, 25433, 25434, 0, 0, 'DK (Troll Female)', '', '', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 0, 2, 2, 0, 24, 1, 2000, 0, 1, 0, 8, 0, 0, 0, 0, 0, 1, 1, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 8388624, 0, '', 12340);
  112. DELETE FROM `creature_model_info` WHERE (`modelid`=25433);
  113. INSERT INTO `creature_model_info` (`modelid`, `bounding_radius`, `combat_reach`, `gender`, `modelid_other_gender`) VALUES (25433, 0, 0, 1, 0);
  114.  
  115. -- THE SCARLET ENCLAVE
  116. REPLACE INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES
  117.    (29519,-1609000,'You have made a grave error, fiend!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_1'),
  118.    (29519,-1609001,'I was a soldier of the Light once... Look at what I have become... ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_2'),
  119.    (29519,-1609002,'You are hopelessly outmatched\, $R.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_3'),
  120.    (29519,-1609003,'They brand me unworthy? I will show them unmorthy!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_4'),
  121.    (29519,-1609004,'You will allow me a weapon and armor, yes?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_5'),
  122.    (29519,-1609005,'I will win my freedom and leave this cursed place!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_6'),
  123.    (29519,-1609006,'I will dismantle this festering hellhole!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_7'),
  124.    (29519,-1609007,'There can be only one survivor!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_START_8'),
  125.    (29519,-1609008,'To battle!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_1'),
  126.    (29519,-1609009,'Let your fears consume you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_2'),
  127.    (29519,-1609010,'HAH! You can barely hold a blade! Yours will be a quick death.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_3'),
  128.    (29519,-1609011,'And now you die',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_4'),
  129.    (29519,-1609012,'To battle!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_5'),
  130.    (29519,-1609013,'There is no hope for our future...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_6'),
  131.    (29519,-1609014,'Sate your hunger on cold steel\, $R',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_7'),
  132.    (29519,-1609015,'It ends here!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_8'),
  133.    (29519,-1609016,'Death is the only cure!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'unworthy_initiate SAY_EVENT_ATTACK_9'),
  134.    (29032,-1609025,'Come to finish the job, have you?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_START_1'),
  135.    (29032,-1609026,'Come to finish the job, have ye?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_START_2'),
  136.    (29032,-1609027,'Come ta finish da job, mon?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_START_3'),
  137.    (29032,-1609028,'You''ll look me in the eyes when...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'special_surprise SAY_EXEC_PROG_1'),
  138.    (29032,-1609029,'Well this son o'' Ironforge would like...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'special_surprise SAY_EXEC_PROG_2'),
  139.    (29032,-1609030,'Ironic, isn''t it? To be killed...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'special_surprise SAY_EXEC_PROG_3'),
  140.    (29032,-1609031,'If you''d allow me just one...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'special_surprise SAY_EXEC_PROG_4'),
  141.    (29032,-1609032,'I''d like to stand for...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'special_surprise SAY_EXEC_PROG_5'),
  142.    (29032,-1609033,'I want to die like an orc...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'special_surprise SAY_EXEC_PROG_6'),
  143.    (29032,-1609034,'Dis troll gonna stand for da...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,25,'special_surprise SAY_EXEC_PROG_7'),
  144.    (29032,-1609035,'$N?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NAME_1'),
  145.    (29032,-1609036,'$N? Mon?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NAME_2'),
  146.    (29032,-1609037,'$N, I''d recognize that face anywhere... What... What have they done to you, $N?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_RECOG_1'),
  147.    (29032,-1609038,'$N, I''d recognize those face tentacles anywhere... What... What have they done to you, $N?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_RECOG_2'),
  148.    (29032,-1609039,'$N, I''d recognize that face anywhere... What... What have they done to ye, $Glad:lass;?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_RECOG_3'),
  149.    (29032,-1609040,'$N, I''d recognize that decay anywhere... What... What have they done to you, $N?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_RECOG_4'),
  150.    (29032,-1609041,'$N, I''d recognize those horns anywhere... What have they done to you, $N?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_RECOG_5'),
  151.    (29032,-1609042,'$N, I''d recognize dem tusks anywhere... What... What have dey done ta you, mon?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_RECOG_6'),
  152.    (29032,-1609043,'You don''t remember me, do you? Blasted Scourge... They''ve tried to drain you of everything that made you a righteous force of reckoning. Every last ounce of good... Everything that made you a draenei!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_1'),
  153.    (29032,-1609044,'Ye don''t remember me, do ye? Blasted Scourge... They''ve tried to drain ye o'' everything that made ye a righteous force o'' reckoning. Every last ounce o'' good... Everything that made you a $Gson:daughter; of Ironforge!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_2'),
  154.    (29032,-1609045,'You don''t remember me, do you? We were humans once - long, long ago - until Lordaeron fell to the Scourge. Your transformation to a Scourge zombie came shortly after my own. Not long after that, our minds were freed by the Dark Lady.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_3'),
  155.    (29032,-1609046,'You don''t remember me, do you? Blasted Scourge... They''ve tried to drain you of everything that made you a pint-sized force of reckoning. Every last ounce of good... Everything that made you a gnome!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_4'),
  156.    (29032,-1609047,'You don''t remember me, do you? Blasted Scourge...They''ve tried to drain of everything that made you a righteous force of reckoning. Every last ounce of good...Everything that made you a human!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_5'),
  157.    (29032,-1609048,'You don''t remember me? When you were a child your mother would leave you in my care while she served at the Temple of the Moon. I held you in my arms and fed you with honey and sheep''s milk to calm you until she would return. You were my little angel. Blasted Scourge... What have they done to you, $N?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_6'),
  158.    (29032,-1609049,'You don''t recognize me, do you? Blasted Scourge... They''ve tried to drain you of everything that made you a righteous force of reckoning. Every last ounce of good... Everything that made you an orc!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_7'),
  159.    (29032,-1609050,'You don''t remember me, do you? Blasted Scourge... They''ve tried to drain you of everything that made you a righteous force of reckoning. Every last ounce of good... Everything that made you a tauren!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_8'),
  160.    (29032,-1609051,'You don''t remember me, mon? Damn da Scourge! Dey gone ta drain you of everytin dat made ya a mojo masta. Every last ounce of good... Everytin'' dat made ya a troll hero, mon!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_NOREM_9'),
  161.    (29032,-1609052,'A pact was made, $Gbrother:sister;! We vowed vengeance against the Lich King! For what he had done to us! We battled the Scourge as Forsaken, pushing them back into the plaguelands and freeing Tirisfal! You and I were champions of the Forsaken!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_THINK_1'),
  162.    (29032,-1609053,'You must remember the splendor of life, $Gbrother:sister;. You were a champion of the Kaldorei once! This isn''t you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_THINK_2'),
  163.    (29032,-1609054,'Think, $N. Think back. Try and remember the majestic halls of Silvermoon City, where you were born. Remember the splendor of life, $Gbrother:sister;. You were a champion of the sin''dorei once! This isn''t you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_3'),
  164.    (29032,-1609055,'Think, $N. Think back. Try and remember the proud mountains of Argus, where you were born. Remember the splendor of life, $Gbrother:sister;. You were a champion of the draenei once! This isn''t you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_4'),
  165.    (29032,-1609056,'Think, $N. Think back. Try and remember the snow capped mountains o'' Dun Morogh! Ye were born there, $Glad:lass;. Remember the splendor o'' life, $N! Ye were a champion o'' the dwarves once! This isn''t ye!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_5'),
  166.    (29032,-1609057,'Think, $N. Think back. Try and remember Gnomeregan before those damned troggs! Remember the feel of an [arclight spanner] $Gbrother:sister;. You were a champion of gnome-kind once! This isn''t you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_6'),
  167.    (29032,-1609058,'Think, $N. Think back. Try and remember the hills and valleys of Elwynn, where you were born. Remember the splendor of life, $Gbrother:sister;. You were a champion of the Alliance once! This isn''t you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_7'),
  168.    (29032,-1609059,'Think, $N. Think back. Try and remember Durotar, $Gbrother:sister;! Remember the sacrifices our heroes made so that we could be free of the blood curse. Harken back to the Valley of Trials, where we were reborn into a world without demonic influence. We found the splendor of life, $N. Together! This isn''t you. You were a champion of the Horde once!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_8'),
  169.    (29032,-1609060,'Think, $N. Think back. Try and remember the rolling plains of Mulgore, where you were born. Remember the splendor of life, $Gbrother:sister;. You were a champion of the tauren once! This isn''t you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_9'),
  170.    (29032,-1609061,'TINK $N. Tink back, mon! We be Darkspear, mon! Bruddas and sistas! Remember when we fought the Zalazane and done took he head and freed da Echo Isles? MON! TINK! You was a champion of da Darkspear trolls!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,6,'special_surprise SAY_EXEC_THINK_10'),
  171.    (29032,-1609062,'Listen to me, $N. You must fight against the Lich King''s control. He is a monster that wants to see this world - our world - in ruin. Don''t let him use you to accomplish his goals. You were once a hero and you can be again. Fight, damn you! Fight his control!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,5,'special_surprise SAY_EXEC_LISTEN_1'),
  172.    (29032,-1609063,'Listen to me, $N Ye must fight against the Lich King''s control. He''s a monster that wants to see this world - our world - in ruin. Don''t let him use ye to accomplish his goals. Ye were once a hero and ye can be again. Fight, damn ye! Fight his control!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,5,'special_surprise SAY_EXEC_LISTEN_2'),
  173.    (29032,-1609064,'Listen to me, $N. You must fight against the Lich King''s control. He is a monster that wants to see this world - our world - in ruin. Don''t let him use you to accomplish his goals AGAIN. You were once a hero and you can be again. Fight, damn you! Fight his control!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,5,'special_surprise SAY_EXEC_LISTEN_3'),
  174.    (29032,-1609065,'Listen ta me, $Gbrudda:sista;. You must fight against da Lich King''s control. He be a monstar dat want ta see dis world - our world - be ruined. Don''t let he use you ta accomplish he goals. You be a hero once and you be a hero again! Fight it, mon! Fight he control!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,5,'special_surprise SAY_EXEC_LISTEN_4'),
  175.    (29032,-1609066,'What''s going on in there? What''s taking so long, $N?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'special_surprise SAY_PLAGUEFIST'),
  176.    (29032,-1609067,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both. $N... Remember Silvermoon. This world is worth saving!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_1'),
  177.    (29032,-1609068,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both. $N... Remember Argus. Don''t let that happen to this world.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_2'),
  178.    (29032,-1609069,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both $N... For KHAAAAAAAAZZZ MODAAAAAANNNNNN!!!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_3'),
  179.    (29032,-1609070,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both. $N... Remember Tirisfal! This world is worth saving!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_4'),
  180.    (29032,-1609071,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both. $N... Remember Gnomeregan! This world is worth saving.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_5'),
  181.    (29032,-1609072,'There... There''s no more time for me. I''m done for. FInish me off, $N. Do it or they''ll kill us both. $N...Remember Elwynn. This world is worth saving.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_6'),
  182.    (29032,-1609073,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both. $N... Remember Teldrassil, our beloved home. This world is worth saving.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_7'),
  183.    (29032,-1609074,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both. $N... For the Horde! This world is worth saving.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_8'),
  184.    (29032,-1609075,'There... There''s no more time for me. I''m done for. Finish me off, $N. Do it or they''ll kill us both. $N... Remember Mulgore. This world is worth saving.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_9'),
  185.    (29032,-1609076,'Der... Der''s no more time for me. I be done for. Finish me off $N. Do it or they''ll kill us both. $N... Remember Sen''jin Village, mon! Dis world be worth saving!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,18,'special_surprise SAY_EXEC_TIME_10'),
  186.    (29032,-1609077,'Do it, $N! Put me out of my misery!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,1,'special_surprise SAY_EXEC_WAITING'),
  187.    (29032,-1609078,'%s dies from his wounds.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'special_surprise EMOTE_DIES'),
  188.    (28406,-1609080,'No potions!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_A'),
  189.    (28406,-1609081,'Remember this day, $n, for it is the day that you will be thoroughly owned.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_B'),
  190.    (28406,-1609082,'I''m going to tear your heart out, cupcake!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_C'),
  191.    (28406,-1609083,'Don''t make me laugh.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_D'),
  192.    (28406,-1609084,'Here come the tears...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_E'),
  193.    (28406,-1609085,'You have challenged death itself!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_F'),
  194.    (28406,-1609086,'The Lich King will see his true champion on this day!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_G'),
  195.    (28406,-1609087,'You''re going down!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_H'),
  196.    (28406,-1609088,'You don''t stand a chance, $n',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'dk_initiate SAY_DUEL_I'),
  197.    (0,-1609089,'I''ll need to get my runeblade and armor... Just need a little more time.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,399,'koltira SAY_BREAKOUT1'),
  198.    (0,-1609090,'I''m still weak, but I think I can get an anti-magic barrier up. Stay inside it or you''ll be destroyed by their spells.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'koltira SAY_BREAKOUT2'),
  199.    (0,-1609091,'Maintaining this barrier will require all of my concentration. Kill them all!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,16,'koltira SAY_BREAKOUT3'),
  200.    (0,-1609092,'There are more coming. Defend yourself! Don''t fall out of the anti-magic field! They''ll tear you apart without its protection!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'koltira SAY_BREAKOUT4'),
  201.    (0,-1609093,'I can''t keep barrier up much longer... Where is that coward?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'koltira SAY_BREAKOUT5'),
  202.    (0,-1609094,'The High Inquisitor comes! Be ready, death knight! Do not let him draw you out of the protective bounds of my anti-magic field! Kill him and take his head!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'koltira SAY_BREAKOUT6'),
  203.    (0,-1609095,'Stay in the anti-magic field! Make them come to you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'koltira SAY_BREAKOUT7'),
  204.    (0,-1609096,'The death of the High Inquisitor of New Avalon will not go unnoticed. You need to get out of here at once! Go, before more of them show up. I''ll be fine on my own.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'koltira SAY_BREAKOUT8'),
  205.    (0,-1609097,'I''ll draw their fire, you make your escape behind me.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'koltira SAY_BREAKOUT9'),
  206.    (0,-1609098,'Your High Inquisitor is nothing more than a pile of meat, Crusaders! There are none beyond the grasp of the Scourge!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'koltira SAY_BREAKOUT10');
  207.    
  208. REPLACE INTO `waypoints` VALUES ('21182', '1', '-1156.97', '2109.63', '83.51', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 1');
  209. REPLACE INTO `waypoints` VALUES ('21182', '2', '-1152.3', '2112.1', '90.6765', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 2');
  210. REPLACE INTO `waypoints` VALUES ('21182', '3', '-1150.82', '2103.74', '89.8157', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 3');
  211. REPLACE INTO `waypoints` VALUES ('21182', '4', '-1153.96', '2107.03', '97.0656', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 4');
  212. REPLACE INTO `waypoints` VALUES ('21182', '5', '-1156.1', '2107.42', '93.0656', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 5');
  213. REPLACE INTO `waypoints` VALUES ('21182', '6', '-1152.17', '2107.41', '83.1767', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 6');
  214. REPLACE INTO `waypoints` VALUES ('21182', '7', '-1150.15', '2102.39', '75.2368', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 7');
  215. REPLACE INTO `waypoints` VALUES ('21182', '8', '-1158.78', '2102.99', '76.9823', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 8');
  216. REPLACE INTO `waypoints` VALUES ('21182', '9', '-1158.34', '2112.02', '79.2045', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 9');
  217. REPLACE INTO `waypoints` VALUES ('21182', '10', '-1148.17', '2113.34', '77.0103', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 10');
  218. REPLACE INTO `waypoints` VALUES ('21182', '11', '-1148.9', '2102.62', '69.6769', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 11');
  219. REPLACE INTO `waypoints` VALUES ('21182', '12', '-1157.05', '2104.98', '82.9548', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower South WP 12');
  220. REPLACE INTO `waypoints` VALUES ('22401', '1', '-821.992', '2034.88', '55.0184', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower North WP 1');
  221. REPLACE INTO `waypoints` VALUES ('22401', '2', '-820.977', '2027.59', '63.6837', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower North WP 2');
  222. REPLACE INTO `waypoints` VALUES ('22401', '3', '-825.219', '2034.11', '65.8631', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower North WP 3');
  223. REPLACE INTO `waypoints` VALUES ('22401', '4', '-816.849', '2028.66', '49.752', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower North WP 4');
  224. REPLACE INTO `waypoints` VALUES ('22401', '5', '-825.249', '2026.35', '46.5842', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower North WP 5');
  225. REPLACE INTO `waypoints` VALUES ('22402', '1', '-897.1', '1917.56', '93.7374', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Forge WP 1');
  226. REPLACE INTO `waypoints` VALUES ('22402', '2', '-903.386', '1919.14', '76.0997', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Forge WP 2');
  227. REPLACE INTO `waypoints` VALUES ('22402', '3', '-898.182', '1920.16', '82.6782', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Forge WP 3');
  228. REPLACE INTO `waypoints` VALUES ('22402', '4', '-901.284', '1920.17', '92.5727', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Forge WP 4');
  229. REPLACE INTO `waypoints` VALUES ('22402', '5', '-894.948', '1924.78', '75.4894', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Forge WP 5');
  230. REPLACE INTO `waypoints` VALUES ('22402', '6', '-894.47', '1919.87', '93.7102', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Forge WP 6');
  231. REPLACE INTO `waypoints` VALUES ('22403', '1', '-978.371', '1883.56', '104.317', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Foothill WP 1');
  232. REPLACE INTO `waypoints` VALUES ('22403', '2', '-974.304', '1878.93', '109.678', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Foothill WP 2');
  233. REPLACE INTO `waypoints` VALUES ('22403', '3', '-974.146', '1874.82', '121.94', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Foothill WP 3');
  234. REPLACE INTO `waypoints` VALUES ('22403', '4', '-982.44', '1875.44', '100.412', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Foothill WP 4');
  235. REPLACE INTO `waypoints` VALUES ('22403', '5', '-975.126', '1882.18', '118.035', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Foothill WP 5');
  236. REPLACE INTO `waypoints` VALUES ('22403', '6', '-979.369', '1876.67', '121.587', 'Zeth\'Gor Quest Credit Marker, They Must Burn, Tower Foothill WP 6');
  237. REPLACE INTO `waypoints` VALUES ('28864', '1', '2191.45', '-6131.88', '48.4288', null);
  238. REPLACE INTO `waypoints` VALUES ('28864', '2', '2220.66', '-6030.99', '70.0122', null);
  239. REPLACE INTO `waypoints` VALUES ('28864', '3', '2281.5', '-5955.75', '131.79', null);
  240. REPLACE INTO `waypoints` VALUES ('28864', '4', '2306.98', '-5872.8', '177.651', null);
  241. REPLACE INTO `waypoints` VALUES ('28864', '5', '2347.98', '-5736.88', '167.929', null);
  242. REPLACE INTO `waypoints` VALUES ('28864', '6', '2360.93', '-5710.75', '155.401', 'Despawn');
  243.  
  244. -- Acherus Gameobject Fixx
  245. UPDATE gameobject SET position_z = 449.772 WHERE id = 191539;
  246. UPDATE gameobject SET position_z = 406.093 WHERE id = 191538;
  247. UPDATE gameobject_template SET Data0 = 46617 WHERE entry = 191539;
  248. UPDATE gameobject_template SET Data0 = 46618 WHERE entry = 191538;
  249. UPDATE gameobject_template SET type = 22 WHERE entry in (191538, 191539);
  250. UPDATE gameobject_template SET flags = 0 WHERE entry in (191539, 191538);
  251. UPDATE gameobject_template SET faction = 0 WHERE entry in (191539, 191538);
  252. UPDATE gameobject_template SET Data5 = 0 WHERe entry in (191539, 191538);
  253. UPDATE gameobject SET state = 1 WHERE id in (191539, 191538);
  254. REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES ('46617', '609', '2398.43', '-5635.16', '377.04', '0.590552');
  255. REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES ('46618', '609', '2397.41', '-5635.88', '420.73', '0.59448');
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!