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

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');

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');

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');

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');

473215-Horde Teleporter.sql

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');

473216-Assassin.sql

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');

473220-Ship Commander.sql

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');

999199-George Shadowfall.sql

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, '');

GunShip Muradin Script.sql

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');

GunShip Saurfang Script.sql

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 Script.sql

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';

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);

В тыл врага! На разрушитель небес(Квест).txt

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);

В тыл Молота Огрима(Квест).txt

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);

Квест-Телепорт на Молот Огрима.txt

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);

Квест-телепорт на Разрушитель небес.txt

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);

Подъём Смертоносного Орда (Квест).txt

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);

Поъём Смертоносного Ксевт Альянс.txt

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);

Расстановка телепортеров.txt

REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (9207478, 371922, 631, 1, 1, 0, 0, -443.018, 2465.33, 190.56, 4.53987, 25, 0, 0, 100000000, 1000000000, 0, 0);

REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (9208160, 373216, 631, 1, 1, 0, 0, -90.682, 2599.43, 451.485, 3.03582, 25, 0, 0, 100000, 100000, 0, 0);

REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (9207702, 473215, 631, 1, 1, 0, 0, -439.124, 1942.73, 214.203, 1.57769, 25, 0, 0, 1000000, 100000, 0, 0);

REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (9208382, 473216, 631, 1, 1, 0, 0, -150.741, 2665.09, 449.202, 0.13577, 25, 0, 0, 100000, 100000, 0, 0);