API tools faq
paste
mferrill

ICC-Boss Templates-Untested

mferrill
Jul 4th, 2012
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 24.20 KB | None | 0 0
raw download clone embed print report
  1. //Untested//
  2.  
  3. -- Lord Marrowgar
  4. -- faction and lootid
  5. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21 WHERE `entry` = 36612;
  6. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `lootid` = 13100 WHERE `entry` = 13100;
  7. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `lootid` = 13101 WHERE `entry` = 13101;
  8. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `lootid` = 13102 WHERE `entry` = 13102;
  9. -- HP 10 and 25 Heroic
  10. UPDATE `creature_template` SET `minhealth` = 10458750, `maxhealth` = 10458750 WHERE `entry` = 13101;
  11. UPDATE `creature_template` SET `minhealth` = 31376250, `maxhealth` = 31376250 WHERE `entry` = 13102;
  12.  
  13. -- Lady Deathwhisper
  14. -- faction, lootid and Rank
  15. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `rank` = 3 WHERE `entry` = 36855;
  16. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `lootid` = 13103, `rank` = 3 WHERE `entry` = 13103;
  17. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `lootid` = 13104, `rank` = 3 WHERE `entry` = 13104;
  18. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `lootid` = 13105, `rank` = 3 WHERE `entry` = 13105;
  19. -- Health and Mana
  20. UPDATE `creature_template` SET `minmana` = 3264800, `maxmana` = 3264800 WHERE `entry` = 36855;
  21. UPDATE `creature_template` SET `minmana` = 11193600, `maxmana` = 11193600 WHERE `entry` = 13103;
  22. UPDATE `creature_template` SET `minhealth` = 6135800, `maxhealth` = 6135800, `minmana` = 3731200, `maxmana` = 3731200 WHERE `entry` = 13104;
  23. UPDATE `creature_template` SET `minhealth` = 26774400, `maxhealth` = 26774400 WHERE `entry` = 13105;
  24.  
  25. -- Deathbringer Saurfang
  26. UPDATE `creature` SET `phaseMask` = 1 WHERE `guid` = 140953;
  27. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21 WHERE `entry` = 37813;
  28. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21 WHERE `entry` = 13106;
  29. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21 WHERE `entry` = 13107;
  30. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21 WHERE `entry` = 13108;
  31. UPDATE `creature_template` SET `minhealth` = 12271600, `maxhealth` = 12271600 WHERE `entry` = 13107;
  32.  
  33. -- Festergut
  34. UPDATE `creature` SET `spawnMask` = 15, `phaseMask` = 1, `spawntimesecs` = 604800 WHERE `guid` = 141846;
  35. UPDATE `creature_template` SET `flags_extra` = 1 WHERE `entry` = 36626;
  36. UPDATE `creature_template` SET `minhealth` = 40440500, `maxhealth` = 40440500, `faction_A` = 21, `faction_H` = 21, `lootid` = 13109, `flags_extra` = 1 WHERE `entry` = 13109;
  37. UPDATE `creature_template` SET `minhealth` = 13666100, `maxhealth` = 13666100, `faction_A` = 21, `faction_H` = 21, `lootid` = 13110, `flags_extra` = 1 WHERE `entry` = 13110;
  38. UPDATE `creature_template` SET `minhealth` = 52154300, `maxhealth` = 52154300, `faction_A` = 21, `faction_H` = 21, `lootid` = 13111, `flags_extra` = 1 WHERE `entry` = 13111;
  39.  
  40.  
  41. -- Rotface
  42. UPDATE `creature` SET `spawnMask` = 15, `phaseMask` = 1, `spawntimesecs` = 604800 WHERE `guid` = 141851;
  43. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `flags_extra` = 1 WHERE `entry` = 36627;
  44. UPDATE `creature_template` SET `lootid` = 13112, `flags_extra` = 1 WHERE `entry` = 13112;
  45. UPDATE `creature_template` SET `minhealth` = 10458750, `maxhealth` = 10458750, `faction_A` = 21, `faction_H` = 21, `lootid` = 13113, `flags_extra` = 1 WHERE `entry` = 13113;
  46. UPDATE `creature_template` SET `minhealth` = 47413000, `maxhealth` = 47413000, `faction_A` = 21, `faction_H` = 21, `lootid` = 13114, `flags_extra` = 1 WHERE `entry` = 13114;
  47.  
  48.  
  49. -- Professor Putricide
  50. UPDATE `creature` SET `spawnMask` = 15, `phaseMask` = 1, `spawntimesecs` = 604800 WHERE `guid` = 141852;
  51. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `rank` = 3, `flags_extra` = 1 WHERE `entry` = 36678;
  52. UPDATE `creature_template` SET `faction_A` = 21, `faction_H` = 21, `lootid` = 13119, `flags_extra` = 1 WHERE `entry` = 13119;
  53. UPDATE `creature_template` SET `minhealth` = 13666100, `maxhealth` = 13666100, `faction_A` = 21, `faction_H` = 21, `lootid` = 13120, `flags_extra` = 1 WHERE `entry` = 13120;
  54. UPDATE `creature_template` SET `minhealth` = 50202000, `maxhealth` = 50202000, `faction_A` = 21, `faction_H` = 21, `lootid` = 13121, `flags_extra` = 1 WHERE `entry` = 13121;
  55.  
  56. -- Prince Valanar
  57. UPDATE `creature` SET `spawnMask` = 15, `phaseMask` = 1, `spawntimesecs` = 604800 WHERE `guid` = 141889;
  58. UPDATE `creature_template` SET `lootid` = 37970 WHERE `entry` = 37970;
  59. UPDATE `creature_template` SET `lootid` = 10035 WHERE `entry` = 10035;
  60. UPDATE `creature_template` SET `minhealth` = 7600025, `maxhealth` = 7600025, `lootid` = 10039 WHERE `entry` = 10039;
  61. UPDATE `creature_template` SET `minhealth` = 30469825, `maxhealth` = 30469825, `lootid` = 10064 WHERE `entry` = 10064;
  62.  
  63. -- Prince Keleseth
  64. UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `guid` = 141887;
  65. UPDATE `creature_template` SET `modelid_3` = 0, `lootid` = 37972 WHERE `entry` = 37972;
  66. UPDATE `creature_template` SET `modelid_3` = 0, `lootid` = 10029 WHERE `entry` = 10029;
  67. UPDATE `creature_template` SET `modelid_3` = 0, `minhealth` = 7600025, `maxhealth` = 7600025, `lootid` = 10030 WHERE `entry` = 10030;
  68. UPDATE `creature_template` SET `modelid_3` = 0, `minhealth` = 30469825, `maxhealth` = 30469825, `lootid` = 10031 WHERE `entry` = 10031;
  69.  
  70. -- Prince Taldaram
  71. UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `guid` = 141888;
  72. UPDATE `creature_template` SET `modelid_3` = 0, `lootid` = 37973 WHERE `entry` = 37973;
  73. UPDATE `creature_template` SET `modelid_3` = 0, `lootid` = 10032 WHERE `entry` = 10032;
  74. UPDATE `creature_template` SET `modelid_3` = 0, `minhealth` = 7600025, `maxhealth` = 7600025, `lootid` = 10033 WHERE `entry` = 10033;
  75. UPDATE `creature_template` SET `modelid_3` = 0, `minhealth` = 30469825, `maxhealth` = 30469825, `lootid` = 10034 WHERE `entry` = 10034;
  76. -- Blood Queen
  77. UPDATE `creature_template` SET `difficulty_entry_1` = 10097, `difficulty_entry_2` = 10098, `difficulty_entry_3` = 10099 WHERE `entry` = 37955;
  78. -- Blood Queen
  79. DELETE FROM `creature` WHERE `id`=37955;
  80. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  81. (37955, 631, 15, 1, 0, 0, 4631.07, 2769.12, 401.748, 3.12196, 604800, 0, 0, 14154175, 425800, 0, 0);
  82. UPDATE `creature_template` SET `modelid_3` = 0, `minlevel` = 83, `maxlevel` = 83, `minhealth` = 14154175, `maxhealth` = 14154175, `minmana` = 425800, `maxmana` = 425800, `armor` = 10521, `faction_A` = 14, `faction_H` = 14, `mindmg` = 468, `maxdmg` = 702, `attackpower` = 176, `unit_class` = 2, `minrangedmg` = 374, `maxrangedmg` = 562, `rangedattackpower` = 140, `lootid` = 37955, `mingold` = 1019748, `maxgold` = 1019748, `mechanic_immune_mask` = 648757247, `flags_extra` = 1 WHERE `entry` = 37955;
  83. -- Blood Queen entry_1
  84. DELETE FROM `creature_template` WHERE (`entry`=10097);
  85. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (10097, 0, 0, 0, 37955, 0, 31165, 0, 0, 0, 'Blood-Queen Lana\'thel', '', '', 0, 83, 83, 59405700, 59405700, 425800, 425800, 10521, 14, 14, 0, 1, 1.14286, 1, 3, 468, 702, 0, 176, 2, 2000, 2000, 2, 0, 0, 0, 0, 0, 0, 0, 374, 562, 140, 6, 108, 10097, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1019748, 1019748, '', 0, 3, 1015, 1, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 648757247, 1, '');
  86. -- Blood Queen entry_2
  87. DELETE FROM `creature_template` WHERE (`entry`=10098);
  88. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (10098, 0, 0, 0, 37955, 0, 31165, 0, 0, 0, 'Blood-Queen Lana\'thel', '', '', 0, 83, 83, 18895475, 18895475, 425800, 425800, 10521, 14, 14, 0, 1, 1.14286, 1, 3, 468, 702, 0, 176, 3, 2000, 2000, 2, 0, 0, 0, 0, 0, 0, 0, 374, 562, 140, 6, 108, 10098, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1019748, 1019748, '', 0, 3, 1015, 1, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 648757247, 1, '');
  89. -- Blood Queen entry_3
  90. DELETE FROM `creature_template` WHERE (`entry`=10099);
  91. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (10099, 0, 0, 0, 37955, 0, 31165, 0, 0, 0, 'Blood-Queen Lana\'thel', '', '', 0, 83, 83, 71258950, 71258950, 425800, 425800, 10521, 14, 14, 0, 1, 1.14286, 1, 3, 468, 702, 0, 176, 4, 2000, 2000, 2, 0, 0, 0, 0, 0, 0, 0, 374, 562, 140, 6, 108, 10099, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1019748, 1019748, '', 0, 3, 1015, 1, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 648757247, 1, '');
  92.  
  93. -- Valithria Dreamwalker
  94. UPDATE `creature_template` SET `difficulty_entry_1` = 10103, `faction_A` = 35, `faction_H` = 35, `mechanic_immune_mask` = 648757247, `flags_extra` = 1 WHERE `entry` = 36789;
  95. -- Valithria Dreamwalker entry_01
  96. DELETE FROM `creature_template` WHERE (`entry`=10103);
  97. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (10103, 0, 0, 0, 36789, 0, 30318, 0, 30318, 0, 'Valithria Dreamwalker', '', '', 0, 83, 83, 36000000, 36000000, 0, 0, 10673, 35, 35, 0, 1, 1.14286, 1, 3, 509, 683, 0, 805, 35, 2000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 371, 535, 0, 2, 67113036, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'EventAI', 0, 3, 860.524, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 648757247, 1, '');
  98.  
  99. -- Sindragosa
  100. -- 10
  101. UPDATE `creature_template` SET `difficulty_entry_1` = 13191, `difficulty_entry_2` = 13192, `difficulty_entry_3` = 13193, `faction_A` = 21, `faction_H` = 21, `lootid` = 36853 WHERE `entry` = 36853;
  102. -- 25
  103. DELETE FROM `creature_template` WHERE (`entry`=13191);
  104. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (13191, 0, 0, 0, 36853, 0, 30362, 0, 0, 0, 'Sindragosa', 'Queen of the Frostbrood', '', 0, 83, 83, 38348750, 38348750, 0, 0, 10627, 21, 21, 0, 1, 1.14286, 1, 3, 468, 702, 0, 175, 47.2, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 374, 562, 140, 6, 108, 13191, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1100740, 1150740, '', 0, 3, 800, 1, 0, 51027, 0, 0, 0, 0, 0, 261, 1, 0, 0, 663437311, 1, '');
  105. -- 10H
  106. DELETE FROM `creature_template` WHERE (`entry`=13192);
  107. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (13192, 0, 0, 0, 36853, 0, 30362, 0, 0, 0, 'Sindragosa', 'Queen of the Frostbrood', '', 0, 83, 83, 13945000, 13945000, 0, 0, 10627, 21, 21, 0, 1, 1.14286, 1, 3, 468, 702, 0, 175, 47.2, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 374, 562, 140, 6, 108, 13192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1100740, 1150740, '', 0, 3, 800, 1, 0, 0, 0, 0, 0, 0, 0, 261, 1, 0, 0, 663437311, 1, '');
  108.  
  109. -- 25H
  110. DELETE FROM `creature_template` WHERE (`entry`=13193);
  111. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (13193, 0, 0, 0, 36853, 0, 30362, 0, 0, 0, 'Sindragosa', 'Queen of the Frostbrood', '', 0, 83, 83, 45948775, 45948775, 0, 0, 10627, 21, 21, 0, 1, 1.14286, 1, 3, 468, 702, 0, 175, 47.2, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 374, 562, 140, 6, 108, 13193, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1100740, 1150740, '', 0, 3, 800, 1, 0, 0, 0, 0, 0, 0, 0, 261, 1, 0, 0, 663437311, 1, '');
  112.  
  113. -- The Lich King
  114. -- 10
  115. UPDATE `creature_template` SET `minlevel` = 83, `maxlevel` = 83, `minhealth` = 17431250, `maxhealth` = 17431250, `armor` = 10627, `faction_A` = 21, `faction_H` = 21, `rank` = 3, `mindmg` = 370, `maxdmg` = 566, `attackpower` = 130, `dmg_multiplier` = 100, `baseattacktime` = 1500, `rangeattacktime` = 1500, `minrangedmg` = 250, `maxrangedmg` = 400, `rangedattackpower` = 100, `lootid` = 36597, `mingold` = 1542857, `maxgold` = 1542857, `unk16` = 1250, `unk17` = 500, `mechanic_immune_mask` = 667631615, `flags_extra` = 1, `difficulty_entry_1` = 10100, `difficulty_entry_2` = 10101, `difficulty_entry_3` = 10102 WHERE `entry` = 36597;
  116. DELETE FROM `creature` WHERE `id`=36597;
  117. INSERT INTO `creature` (`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
  118. (36597, 631, 15, 1, 0, 0, 428.597, -2123.88, 1064.96, 0.120937, 604800, 0, 0, 17431250, 0, 0, 0);
  119. -- 25
  120. DELETE FROM `creature_template` WHERE (`entry`=10100);
  121. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (10100, 0, 0, 0, 36597, 0, 30721, 0, 0, 0, 'The Lich King', '', '', 0, 83, 83, 61009375, 61009375, 0, 0, 10627, 21, 21, 0, 1, 1.14286, 1, 3, 370, 566, 0, 130, 100, 1500, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 250, 400, 100, 6, 268435564, 10100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1542857, 1542857, '', 0, 3, 1250, 500, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 667631615, 1, '');
  122. -- 10H
  123. DELETE FROM `creature_template` WHERE (`entry`=10101);
  124. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (10101, 0, 0, 0, 36597, 0, 30721, 0, 0, 0, 'The Lich King', '', '', 0, 83, 83, 29493675, 29493675, 0, 0, 10627, 21, 21, 0, 1, 1.14286, 1, 3, 370, 566, 0, 130, 100, 1500, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 250, 400, 100, 6, 268435564, 10101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1542857, 1542857, '', 0, 3, 1250, 500, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 667631615, 1, '');
  125. -- 25H
  126. DELETE FROM `creature_template` WHERE (`entry`=10102);
  127. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (10102, 0, 0, 0, 36597, 0, 30721, 0, 0, 0, 'The Lich King', '', '', 0, 83, 83, 103193000, 103193000, 0, 0, 10627, 21, 21, 0, 1, 1.14286, 1, 3, 370, 566, 0, 130, 100, 1500, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 250, 400, 100, 6, 268435564, 10102, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1542857, 1542857, '', 0, 3, 1250, 500, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 667631615, 1, '');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!