Винсент
29.11.2014, 22:05
Подъём Смертоносного (Квест для Альянса)
Подъём Смертоносного (Квест для Орды)
Квест-телепорт на Разрушитель небес
Квест-Телепорт на Молот Огрима
В тыл Молота Огрима (Квест)
В тыл врага! На разрушитель небес(Квест)
Ogrim's Hammer
Gunship Script
GunShip Saurfang Script
GunShip Muradin Script
999199-George Shadowfall
473220-Ship Commander
473216-Assassin
473215-Horde Teleporter
373221-Ship Commander
373216-Assassin
371922-Aliance Teleporter
36838-Alliance Gunship Cannon
Подъём Смертоносного (Квест для Альянса)
DELETE FROM `creature_questrelation` WHERE `quest` = 1746953;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 1746953;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 1746953;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (373221, 1746953);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 373221;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 1746953;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 1746953;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (373221, 1746953);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=373221;
DELETE FROM `quest_end_scripts` WHERE `id`=1746953;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(1746953, 0, 6, 631, 0, '', -561.696533, 2209.324707, 539.285706, 6.279839);
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 (1746953, 2, 0, 0, 80, 0, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang must die!', 'Kill The Saurfang, captain of Ogrim\'s Hammer!', 'Kill The Saurfang, captain of Ogrim\'s Hammer!', 'Kill The Saurfang, captain of Ogrim\'s Hammer!', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 37187, 0, 0, 0, 1, 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, 10000, 0, 1000, 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, 1746953);
Подъём Смертоносного (Квест для Орды)
DELETE FROM `creature_questrelation` WHERE `quest` = 70056892;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 70056892;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 70056892;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (473220, 70056892);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 473220;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 70056892;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 70056892;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (473220, 70056892);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=473220;
DELETE FROM `quest_end_scripts` WHERE `id`=70056892;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(70056891, 0, 6, 631, 0, '', -561.696533, 2209.324707, 539.285706, 6.279839);
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 (70056892, 2, 0, 0, 0, 0, 0, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Bronzebard must Die!', 'Kill Muradin! He is very dangerous for our operation!', 'Kill Muradin! He is very dangerous for our operation!', 'Kill Muradin! He is very dangerous for our operation!', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 37200, 0, 0, 0, 1, 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, 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, 70056892);
Квест-телепорт на Разрушитель небес
DELETE FROM `creature_questrelation` WHERE `quest` = 7000521;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000521;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000521;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (371922, 7000521);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 371922;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000521;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000521;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (371922, 7000521);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=371922;
DELETE FROM `quest_end_scripts` WHERE `id`=7000521;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000521, 0, 6, 631, 0, '0', -110.863, 2603.7, 451.962, 3.27929);
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 (7000521, 2, 0, 0, 80, 0, 0, 1357, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Teleport to TheSkybreaker', 'Teleport to TheSkybreaker', 'Teleport to TheSkybreaker', 'Are you really prepared?', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000521);
Квест-Телепорт на Молот Огрима
DELETE FROM `creature_questrelation` WHERE `quest` = 7000522;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000522;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000522;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (473215, 7000522);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 473215;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000522;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000522;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (473215, 7000522);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=473215;
DELETE FROM `quest_end_scripts` WHERE `id`=7000522;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000522, 0, 6, 631, 0, '', -142.677460, 2666.246582, 448.687500, 4.167574);
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 (7000522, 2, 0, 0, 80, 0, 0, 946, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Teleport to Ogrim\'s Hammer', 'Teleport to Ogrim\'s Hammer', 'Teleport to Ogrim\'s Hammer', 'Loc-tar! For the Horde!', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000522);
В тыл Молота Огрима (Квест)
DELETE FROM `creature_questrelation` WHERE `quest` = 7000523;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000523;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000523;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (373216, 7000523);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 373216;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000523;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000523;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (373216, 7000523);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=373216;
DELETE FROM `quest_end_scripts` WHERE `id`=7000523;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000523, 0, 6, 631, 0, '', -92.495811, 2702.653564, 448.926514, 3.423816);
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 (7000523, 2, 0, 0, 80, 0, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Asassin\'s attack to Ogrim\'s Hammer', 'I will teleport to to the outside of Ogrim\'s Hammer!', 'I will teleport to to the outside of Ogrim\'s Hammer!', 'Kill Them!', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000523);
В тыл врага! На разрушитель небес(Квест)
DELETE FROM `creature_questrelation` WHERE `quest` = 7000524;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000524;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000524;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (473216, 7000524);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 473216;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000524;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000524;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (473216, 7000524);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=473216;
DELETE FROM `quest_end_scripts` WHERE `id`=7000524;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000524, 0, 6, 631, 0, '0', -56.504810, 2624.102783, 471.199066, 3.42816);
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 (7000524, 2, 0, 0, 80, 0, 0, 946, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Asassin\'s attack to The Skybreaker!', 'I Will teleport yu to the outside of The Skybreaker!', 'I Will teleport yu to the outside of The Skybreaker!', 'Loc-Tar!', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000524);
Ogrim's Hammer
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (201581, 14, 9151, 'Orgrim\'s Hammer', '', '', '', 0, 40, 1, 0, 0, 0, 0, 0, 0, 1816, 20, 10, 0, 0, 61, 673, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
REPLACE INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (1723163, 201581, 631, 1, 1, -139.797, 2669.11, 414.265, 3.59057, 0, 0, 0.974908, -0.222609, 25, 0, 1);
Gunship Script
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37144);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714451', '37144', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714452', '37144', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714453', '37144', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714454', '37144', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714455', '37144', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714456', '37144', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714457', '37144', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37144';
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37148);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714851', '37148', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714852', '37148', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714853', '37148', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714854', '37148', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714855', '37148', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714856', '37148', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714857', '37148', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37148';
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37149);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714951', '37149', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714952', '37149', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714953', '37149', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714954', '37149', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714955', '37149', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714956', '37149', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714957', '37149', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37149';
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37146);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714651', '37146', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714652', '37146', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714653', '37146', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714654', '37146', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714655', '37146', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714656', '37146', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714657', '37146', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37146';
GunShip Saurfang Script
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37187);
INSERT INTO `creature_ai_scripts` VALUES
( 3718751, 37187, 4, 0, 100, 30, 0, 0, 0, 0, 1, -371871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang aggro'),
( 3718752, 37187, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang CHuma'),
( 3718753, 37187, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang Sharkaushii monstr'),
( 3718754, 37187, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang Vurdalaki'),
( 3718755, 37187, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang Shadow bolt'),
( 3718756, 37187, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -371872, 0, 0, 0, 0, 0, 0, 'Saurfang Corrupt Soul'),
( 3718757, 37187, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -371872, 0, 0, 0, 0, 0, 0, 'Saurfang Corrupt Soul H'),
( 3718758, 37187, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 70309, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang summon corrupt'),
( 3718759, 37187, 2, 0, 100, 6, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Soulstorm'),
( 3718760, 37187, 2, 0, 100, 24, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Soulstorm H'),
( 3718761, 37187, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Fear'),
( 3718762, 37187, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Fear H'),
( 3718763, 37187, 6, 0, 100, 30, 0, 0, 0, 0, 4, 70309, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang death'),
( 3718764, 37187, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -371873, 0, 0, 'Saurfang Kill player');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37187';
UPDATE `creature_template` set `Scriptname`='' WHERE `entry` = '37187';
DELETE FROM `creature_ai_texts` WHERE `entry` in (-371871, -371872, -371873);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-371871', 'The Aliance try to defeat me?! It's a big mistake for you!!!', '', '', '', '', '', '', '', '', '', '1', '0', '0', 'Saurfang aggro');
GunShip Muradin Script
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37200);
INSERT INTO `creature_ai_scripts` VALUES
( 3720051, 37200, 4, 0, 100, 30, 0, 0, 0, 0, 1, -372001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin aggro'),
( 3720052, 37200, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin CHuma'),
( 3720053, 37200, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Sharkaushii monstr'),
( 3720054, 37200, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Vurdalaki'),
( 3720055, 37200, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Shadow bolt'),
( 3720056, 37200, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -372002, 0, 0, 0, 0, 0, 0, 'Muradin Corrupt Soul'),
( 3720057, 37200, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -372002, 0, 0, 0, 0, 0, 0, 'Muradin Corrupt Soul H'),
( 3720058, 37200, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 70309, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin summon corrupt'),
( 3720059, 37200, 2, 0, 100, 6, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Soulstorm'),
( 3720060, 37200, 2, 0, 100, 24, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Soulstorm H'),
( 3720061, 37200, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Fear'),
( 3720062, 37200, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Fear H'),
( 3720063, 37200, 6, 0, 100, 30, 0, 0, 0, 0, 4, 70309, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin death'),
( 3720064, 37200, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -372003, 0, 0, 'Muradin Kill player');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37200';
UPDATE `creature_template` set `Scriptname`='' WHERE `entry` = '37200';
DELETE FROM `creature_ai_texts` WHERE `entry` in (-372001, -372002, -372003);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-372001', 'The Horde try to defeat me?! It's a big mistake for you!!!', '', '', '', '', '', '', '', '', '', '1', '0', '0', 'Muradin aggro');
999199-George Shadowfall
REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (999199, 0, 0, 0, 0, 0, 26308, 26308, 26308, 26308, 'George Shadowfall', '', '', 0, 100, 105, 1000000, 1000000000, 110000000001, 0, 0, 7, 7, 65539, 8, 1, 4, 0, 0, 0, 0, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
473220-Ship Commander
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('473220', ' 27738', ' 27738', ' 27738', ' 27738', "Ship Commander", "'Ogrim's Hammer'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
473216-Assassin
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('473216', ' 27771', ' 27771', ' 27771', ' 27771', "Assassin", "'Ogrim's Hammer'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
473215-Horde Teleporter
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('473215', ' 27771', ' 27771', ' 27771', ' 27771', "General Engeneer", "'Ogrim's Hammer'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
373221-Ship Commander
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('373221', ' 27825', ' 27825', ' 27825', ' 27825', "Ship Commander", "'TheSkybreaker'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
373216-Assassin
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('373216', ' 27672', ' 27672', ' 27672', ' 27672', "Assassin", "'TheSkybreaker'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
371922-Aliance Teleporter
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('371922', ' 27828', ' 27828', ' 27828', ' 27828', "General ingeneer", "'The Skybreaker'", '80', '82', '1000000', '100000000', '1000000000', '1000000000', '10000', '7', '7', '0', '8.00', '1', '1', '1000', '10000', '100', '0', '7', '0', '0', '0', '0', '0', '0', '10000000', '10000000');
36838-Alliance Gunship Cannon
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('36838', '29488', '0', '29488', '0', "Alliance Gunship Cannon", "", '80', '80', '350000', '350000', '', '', '0', '1802', '1802', '0', '1.00', '1', '1', '500', '1000', '2000', '0', '9', '0', '0', '0', '0', '0', '0', '0', '0');
Подъём Смертоносного (Квест для Орды)
Квест-телепорт на Разрушитель небес
Квест-Телепорт на Молот Огрима
В тыл Молота Огрима (Квест)
В тыл врага! На разрушитель небес(Квест)
Ogrim's Hammer
Gunship Script
GunShip Saurfang Script
GunShip Muradin Script
999199-George Shadowfall
473220-Ship Commander
473216-Assassin
473215-Horde Teleporter
373221-Ship Commander
373216-Assassin
371922-Aliance Teleporter
36838-Alliance Gunship Cannon
Подъём Смертоносного (Квест для Альянса)
DELETE FROM `creature_questrelation` WHERE `quest` = 1746953;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 1746953;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 1746953;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (373221, 1746953);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 373221;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 1746953;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 1746953;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (373221, 1746953);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=373221;
DELETE FROM `quest_end_scripts` WHERE `id`=1746953;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(1746953, 0, 6, 631, 0, '', -561.696533, 2209.324707, 539.285706, 6.279839);
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 (1746953, 2, 0, 0, 80, 0, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang must die!', 'Kill The Saurfang, captain of Ogrim\'s Hammer!', 'Kill The Saurfang, captain of Ogrim\'s Hammer!', 'Kill The Saurfang, captain of Ogrim\'s Hammer!', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 37187, 0, 0, 0, 1, 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, 10000, 0, 1000, 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, 1746953);
Подъём Смертоносного (Квест для Орды)
DELETE FROM `creature_questrelation` WHERE `quest` = 70056892;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 70056892;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 70056892;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (473220, 70056892);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 473220;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 70056892;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 70056892;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (473220, 70056892);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=473220;
DELETE FROM `quest_end_scripts` WHERE `id`=70056892;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(70056891, 0, 6, 631, 0, '', -561.696533, 2209.324707, 539.285706, 6.279839);
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 (70056892, 2, 0, 0, 0, 0, 0, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Bronzebard must Die!', 'Kill Muradin! He is very dangerous for our operation!', 'Kill Muradin! He is very dangerous for our operation!', 'Kill Muradin! He is very dangerous for our operation!', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 37200, 0, 0, 0, 1, 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, 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, 70056892);
Квест-телепорт на Разрушитель небес
DELETE FROM `creature_questrelation` WHERE `quest` = 7000521;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000521;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000521;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (371922, 7000521);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 371922;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000521;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000521;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (371922, 7000521);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=371922;
DELETE FROM `quest_end_scripts` WHERE `id`=7000521;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000521, 0, 6, 631, 0, '0', -110.863, 2603.7, 451.962, 3.27929);
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 (7000521, 2, 0, 0, 80, 0, 0, 1357, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Teleport to TheSkybreaker', 'Teleport to TheSkybreaker', 'Teleport to TheSkybreaker', 'Are you really prepared?', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000521);
Квест-Телепорт на Молот Огрима
DELETE FROM `creature_questrelation` WHERE `quest` = 7000522;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000522;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000522;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (473215, 7000522);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 473215;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000522;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000522;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (473215, 7000522);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=473215;
DELETE FROM `quest_end_scripts` WHERE `id`=7000522;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000522, 0, 6, 631, 0, '', -142.677460, 2666.246582, 448.687500, 4.167574);
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 (7000522, 2, 0, 0, 80, 0, 0, 946, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Teleport to Ogrim\'s Hammer', 'Teleport to Ogrim\'s Hammer', 'Teleport to Ogrim\'s Hammer', 'Loc-tar! For the Horde!', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000522);
В тыл Молота Огрима (Квест)
DELETE FROM `creature_questrelation` WHERE `quest` = 7000523;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000523;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000523;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (373216, 7000523);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 373216;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000523;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000523;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (373216, 7000523);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=373216;
DELETE FROM `quest_end_scripts` WHERE `id`=7000523;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000523, 0, 6, 631, 0, '', -92.495811, 2702.653564, 448.926514, 3.423816);
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 (7000523, 2, 0, 0, 80, 0, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Asassin\'s attack to Ogrim\'s Hammer', 'I will teleport to to the outside of Ogrim\'s Hammer!', 'I will teleport to to the outside of Ogrim\'s Hammer!', 'Kill Them!', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000523);
В тыл врага! На разрушитель небес(Квест)
DELETE FROM `creature_questrelation` WHERE `quest` = 7000524;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 7000524;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 7000524;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (473216, 7000524);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 473216;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 7000524;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 7000524;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (473216, 7000524);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=473216;
DELETE FROM `quest_end_scripts` WHERE `id`=7000524;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(7000524, 0, 6, 631, 0, '0', -56.504810, 2624.102783, 471.199066, 3.42816);
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 (7000524, 2, 0, 0, 80, 0, 0, 946, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Asassin\'s attack to The Skybreaker!', 'I Will teleport yu to the outside of The Skybreaker!', 'I Will teleport yu to the outside of The Skybreaker!', 'Loc-Tar!', '', '', '', '', '', '', '', 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000524);
Ogrim's Hammer
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (201581, 14, 9151, 'Orgrim\'s Hammer', '', '', '', 0, 40, 1, 0, 0, 0, 0, 0, 0, 1816, 20, 10, 0, 0, 61, 673, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
REPLACE INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (1723163, 201581, 631, 1, 1, -139.797, 2669.11, 414.265, 3.59057, 0, 0, 0.974908, -0.222609, 25, 0, 1);
Gunship Script
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37144);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714451', '37144', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714452', '37144', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714453', '37144', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714454', '37144', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714455', '37144', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714456', '37144', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714457', '37144', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37144';
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37148);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714851', '37148', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714852', '37148', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714853', '37148', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714854', '37148', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714855', '37148', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714856', '37148', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714857', '37148', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37148';
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37149);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714951', '37149', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714952', '37149', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714953', '37149', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714954', '37149', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714955', '37149', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714956', '37149', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714957', '37149', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37149';
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37146);
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714651', '37146', '0', '0', '100', '7', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714652', '37146', '0', '0', '100', '25', '5000', '7000', '10000', '15000', '11', '42842', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Darin Life H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714653', '37146', '0', '0', '100', '31', '1000', '3000', '70000', '100000', '11', '43039', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Raise Dead');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714654', '37146', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '49576', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714655', '37146', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '45524', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow bolt H.');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714656', '37146', '0', '0', '100', '7', '7000', '7000', '8000', '10000', '11', '42650', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend');
INSERT IGNORE INTO `creature_ai_scripts` VALUES ('3714657', '37146', '0', '0', '100', '25', '7000', '7000', '8000', '10000', '11', '42842', '0', '34', '0', '0', '0', '0', '0', '0', '0', '0', 'Soulguard Adept Shadow Mend H.');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37146';
GunShip Saurfang Script
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37187);
INSERT INTO `creature_ai_scripts` VALUES
( 3718751, 37187, 4, 0, 100, 30, 0, 0, 0, 0, 1, -371871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang aggro'),
( 3718752, 37187, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang CHuma'),
( 3718753, 37187, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang Sharkaushii monstr'),
( 3718754, 37187, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang Vurdalaki'),
( 3718755, 37187, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang Shadow bolt'),
( 3718756, 37187, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -371872, 0, 0, 0, 0, 0, 0, 'Saurfang Corrupt Soul'),
( 3718757, 37187, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -371872, 0, 0, 0, 0, 0, 0, 'Saurfang Corrupt Soul H'),
( 3718758, 37187, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 70309, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang summon corrupt'),
( 3718759, 37187, 2, 0, 100, 6, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Soulstorm'),
( 3718760, 37187, 2, 0, 100, 24, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Soulstorm H'),
( 3718761, 37187, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Fear'),
( 3718762, 37187, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang cast Fear H'),
( 3718763, 37187, 6, 0, 100, 30, 0, 0, 0, 0, 4, 70309, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saurfang death'),
( 3718764, 37187, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -371873, 0, 0, 'Saurfang Kill player');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37187';
UPDATE `creature_template` set `Scriptname`='' WHERE `entry` = '37187';
DELETE FROM `creature_ai_texts` WHERE `entry` in (-371871, -371872, -371873);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-371871', 'The Aliance try to defeat me?! It's a big mistake for you!!!', '', '', '', '', '', '', '', '', '', '1', '0', '0', 'Saurfang aggro');
GunShip Muradin Script
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=37200);
INSERT INTO `creature_ai_scripts` VALUES
( 3720051, 37200, 4, 0, 100, 30, 0, 0, 0, 0, 1, -372001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin aggro'),
( 3720052, 37200, 0, 0, 100, 7, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin CHuma'),
( 3720053, 37200, 0, 0, 100, 25, 10000, 15000, 15000, 20000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Sharkaushii monstr'),
( 3720054, 37200, 0, 0, 100, 25, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Vurdalaki'),
( 3720055, 37200, 0, 0, 100, 7, 2000, 4000, 6000, 10000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin Shadow bolt'),
( 3720056, 37200, 0, 0, 100, 7, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -372002, 0, 0, 0, 0, 0, 0, 'Muradin Corrupt Soul'),
( 3720057, 37200, 0, 0, 100, 25, 15000, 20000, 20000, 30000, 11, 70309, 1, 0, 1, -372002, 0, 0, 0, 0, 0, 0, 'Muradin Corrupt Soul H'),
( 3720058, 37200, 0, 0, 100, 31, 15000, 20000, 20000, 30000, 12, 70309, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin summon corrupt'),
( 3720059, 37200, 2, 0, 100, 6, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Soulstorm'),
( 3720060, 37200, 2, 0, 100, 24, 30, 0, 0, 0, 11, 70309, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Soulstorm H'),
( 3720061, 37200, 2, 0, 100, 7, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Fear'),
( 3720062, 37200, 2, 0, 100, 25, 100, 30, 10000, 15000, 11, 70309, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin cast Fear H'),
( 3720063, 37200, 6, 0, 100, 30, 0, 0, 0, 0, 4, 70309, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Muradin death'),
( 3720064, 37200, 5, 0, 100, 7, 5000, 6000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, -372003, 0, 0, 'Muradin Kill player');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '37200';
UPDATE `creature_template` set `Scriptname`='' WHERE `entry` = '37200';
DELETE FROM `creature_ai_texts` WHERE `entry` in (-372001, -372002, -372003);
INSERT IGNORE INTO `creature_ai_texts` VALUES ('-372001', 'The Horde try to defeat me?! It's a big mistake for you!!!', '', '', '', '', '', '', '', '', '', '1', '0', '0', 'Muradin aggro');
999199-George Shadowfall
REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (999199, 0, 0, 0, 0, 0, 26308, 26308, 26308, 26308, 'George Shadowfall', '', '', 0, 100, 105, 1000000, 1000000000, 110000000001, 0, 0, 7, 7, 65539, 8, 1, 4, 0, 0, 0, 0, 1, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
473220-Ship Commander
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('473220', ' 27738', ' 27738', ' 27738', ' 27738', "Ship Commander", "'Ogrim's Hammer'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
473216-Assassin
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('473216', ' 27771', ' 27771', ' 27771', ' 27771', "Assassin", "'Ogrim's Hammer'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
473215-Horde Teleporter
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('473215', ' 27771', ' 27771', ' 27771', ' 27771', "General Engeneer", "'Ogrim's Hammer'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
373221-Ship Commander
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('373221', ' 27825', ' 27825', ' 27825', ' 27825', "Ship Commander", "'TheSkybreaker'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
373216-Assassin
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('373216', ' 27672', ' 27672', ' 27672', ' 27672', "Assassin", "'TheSkybreaker'", '81', '83', '1000000', '100000', '100000', '100000', '10000', '7', '7', '0', '8.00', '1', '1', '0', '0', '100', '4', '7', '0', '0', '0', '0', '0', '0', '100000000', '100000000');
371922-Aliance Teleporter
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('371922', ' 27828', ' 27828', ' 27828', ' 27828', "General ingeneer", "'The Skybreaker'", '80', '82', '1000000', '100000000', '1000000000', '1000000000', '10000', '7', '7', '0', '8.00', '1', '1', '1000', '10000', '100', '0', '7', '0', '0', '0', '0', '0', '0', '10000000', '10000000');
36838-Alliance Gunship Cannon
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('36838', '29488', '0', '29488', '0', "Alliance Gunship Cannon", "", '80', '80', '350000', '350000', '', '', '0', '1802', '1802', '0', '1.00', '1', '1', '500', '1000', '2000', '0', '9', '0', '0', '0', '0', '0', '0', '0', '0');