WoW-Info — информационный World of Warcraft портал

DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=36612);
INSERT INTO `creature_ai_scripts` VALUES
( 3661251, 36612, 4, 0, 100, 30, 0, 0, 0, 0, 1, -366121, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar aggro'),
( 3661252, 36612, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 69076, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar CHuma'),
( 3661253, 36612, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 69076, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar Sharkaushii monstr'),
( 3661254, 36612, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 69076, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar Vurdalaki'),
( 3661255, 36612, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 69076, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar Shadow bolt'),
( 3661256, 36612, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 69076, 1, 0, 1, -366122, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar Corrupt Soul'),
( 3661257, 36612, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 69076, 1, 0, 1, -366122, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar Corrupt Soul H'),
( 3661258, 36612, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 69076, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar summon corrupt'),
( 3661259, 36612, 2, 0, 100, 6, 30, 0, 0, 0, 11, 69076, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar cast Soulstorm'),
( 3661260, 36612, 2, 0, 100, 24, 30, 0, 0, 0, 11, 69076, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar cast Soulstorm H'),
( 3661261, 36612, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 69076, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar cast Fear'),
( 3661262, 36612, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 69076, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar cast Fear H'),
( 3661263, 36612, 6, 0, 100, 30, 0, 0, 0, 0, 4, 69076, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lord Marrowgar death'),
( 3661264, 36612, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -366123, 0, 0, 'Lord Marrowgar Kill player');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '36612';
UPDATE `creature_template` set `Scriptname`='' WHERE `entry` = '36612';

DELETE FROM `creature_ai_texts` WHERE `entry` in (-366121, -366122, -366123);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-366121', 'Wellcome to Hell heroes!', '', '', '', '', '', '', '', '', '16941', '1', '0', '0', 'Lord Marrowgar aggro');

DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=36597);
INSERT INTO `creature_ai_scripts` VALUES
( 3659751, 36597, 4, 0, 100, 30, 0, 0, 0, 0, 1, -365971, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King aggro'),
( 3659752, 36597, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 73913, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King CHuma'),
( 3659753, 36597, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 70358, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King Sharkaushii monstr'),
( 3659754, 36597, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 73790, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King Vurdalaki'),
( 3659755, 36597, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 70358, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King Shadow bolt'),
( 3659756, 36597, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 73790, 1, 0, 1, -365972, 0, 0, 0, 0, 0, 0, 'Lich King Corrupt Soul'),
( 3659757, 36597, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 74270, 1, 0, 1, -365972, 0, 0, 0, 0, 0, 0, 'Lich King Corrupt Soul H'),
( 3659758, 36597, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 72762, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King summon corrupt'),
( 3659759, 36597, 2, 0, 100, 6, 30, 0, 0, 0, 11, 68981, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Soulstorm'),
( 3659760, 36597, 2, 0, 100, 24, 30, 0, 0, 0, 11, 72762, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Soulstorm H'),
( 3659761, 36597, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 70372, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Fear'),
( 3659762, 36597, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 70358, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Fear H'),
( 3659763, 36597, 6, 0, 100, 30, 0, 0, 0, 0, 4, 68981, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King death'),
( 3659767, 36597, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -365973, 0, 0, 'Lich King Kill player');

DELETE FROM `creature_ai_texts` WHERE `entry` in (-365971, -365972, -365973);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-365971', 'So..the Lights vaunted justice has finally arrived. Shall I lay down Frostmourne and throw myself at your mercy', '', '', '', '', '', '', '', '', '17349', '1', '0', '0', 'Lich King aggro');
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-365972', 'I'm wait for your souls!', '', '', '', '', '', '', '', '', '16600', '1', '0', '0', 'Lich King corrupt soul');
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-365973', 'Frostmourne hungers...', '', '', '', '', '', '', '', '', '17366', '1', '0', '0', 'Lich King corrupt soul');

DELETE FROM `creature_questrelation` WHERE `quest` = 987654;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 987654;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 987654;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (999199, 987654);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 999199;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 987654;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 987654;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (999199, 987654);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=999199;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (987654, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmourne is not a Legend!', 'Shadowmourne is a mighty Axe, do you want to try to create it?', 'Agree with this master of Axes', '', '', 'Ok, go to the Darion Mogrein into IceCrown Citadel!', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 49908, 0, 0, 0, 30, 0, 0, 0, 1156, 1156, 0, 0, 0, 0, 0, 0, 0, 0, 8388607, 8388607, 0, 0, 0, 0, 0, 0, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=36855);
INSERT INTO `creature_ai_scripts` VALUES
( 3685551, 36855, 4, 0, 100, 30, 0, 0, 0, 0, 1, -368551, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper aggro'),
( 3685552, 36855, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 72905, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper CHuma'),
( 3685553, 36855, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 72502, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper Sharkaushii monstr'),
( 3685554, 36855, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 71254, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper Vurdalaki'),
( 3685555, 36855, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 72905, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper Shadow bolt'),
( 3685556, 36855, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 70842, 1, 0, 1, -368552, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper Corrupt Soul'),
( 3685557, 36855, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 72905, 1, 0, 1, -368552, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper Corrupt Soul H'),
( 3685558, 36855, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 70842, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper summon corrupt'),
( 3685559, 36855, 2, 0, 100, 6, 30, 0, 0, 0, 11, 71001, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper cast Soulstorm'),
( 3685560, 36855, 2, 0, 100, 24, 30, 0, 0, 0, 11, 71254, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper cast Soulstorm H'),
( 3685561, 36855, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 71254, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper cast Fear'),
( 3685562, 36855, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 72905, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper cast Fear H'),
( 3685563, 36855, 6, 0, 100, 30, 0, 0, 0, 0, 4, 71254, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lady Deathwhisper death'),
( 3685564, 36855, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -368553, 0, 0, 'Lady Deathwhisper Kill player');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '36855';
UPDATE `creature_template` set `Scriptname`='' WHERE `entry` = '36855';

DELETE FROM `creature_ai_texts` WHERE `entry` in (-368551, -368552, -368553);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-368551', 'I Feel blood! I will whiper to you about death!', '', '', '', '', '', '', '', '', '', '1', '0', '0', 'Lady Deathwhisper aggro');

DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=36853);
INSERT INTO `creature_ai_scripts` VALUES
( 3685351, 36853, 4, 0, 100, 30, 0, 0, 0, 0, 1, -368531, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King aggro'),
( 3685352, 36853, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 69649, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King CHuma'),
( 3685353, 36853, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 69712, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King Sharkaushii monstr'),
( 3685354, 36853, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 71077, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King Vurdalaki'),
( 3685355, 36853, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 69762, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King Shadow bolt'),
( 3685356, 36853, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 71047, 1, 0, 1, -368532, 0, 0, 0, 0, 0, 0, 'Lich King Corrupt Soul'),
( 3685357, 36853, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 69712, 1, 0, 1, -368532, 0, 0, 0, 0, 0, 0, 'Lich King Corrupt Soul H'),
( 3685358, 36853, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 71077, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King summon corrupt'),
( 3685359, 36853, 2, 0, 100, 6, 30, 0, 0, 0, 11, 69649, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Soulstorm'),
( 3685360, 36853, 2, 0, 100, 24, 30, 0, 0, 0, 11, 69649, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Soulstorm H'),
( 3685361, 36853, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 71077, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Fear'),
( 3685362, 36853, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 69762, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King cast Fear H'),
( 3685363, 36853, 6, 0, 100, 30, 0, 0, 0, 0, 4, 71047, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Lich King death'),
( 3685364, 36853, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -368533, 0, 0, 'Lich King Kill player');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '36853';
UPDATE `creature_template` set `Scriptname`='' WHERE `entry` = '36853';

DELETE FROM `creature_ai_texts` WHERE `entry` in (-368531, -368532, -368533);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-368531', 'Oh, I am waiting for you Heroes! I was revived to kill you!!!', '', '', '', '', '', '', '', '', '', '1', '0', '0', 'Lich King aggro');