REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (147852, 1499, 0, 1499, 0, 'Scount  Anetotalaor', 'Defender', '', 81, 81, 25000, 25000, 0, 0, 16000, 35, 35, 2, 1, 1, 1, 1000, 2000, 0, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, '');
DELETE FROM `creature_questrelation` WHERE `quest` = 147852;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 147852;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 147852;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (147852, 147852);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 147852;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 147852;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 147852;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (147852, 147852);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=147852;
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`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `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`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (147852, 2, 0, 0, 80, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Legion Attack Shattrat City', 'About thank God you has survived. Help us on us the legion has attacked!!!! $BThey have attacked us when we prepared for an attack on them, but they have outstripped us. $BThese creatures have crept away on all Terrace of Light (centre Shattrath City)', 'Kill 30 legionaries, we will be very grateful to you. $BThe award it will be obligatory!', 'This event has made GrEM fM Team.', 'Come back when you will kill 30 legionaries.', 'Good luck!', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 123321, 0, 0, 0, 30, 0, 0, 0, 0, 0, 0, 0, 23162, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 21215, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
REPLACE INTO `creature_template` 
(`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `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`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (123321, 5231, 0, 5231, 0, 'Legioner', 'Legion the attacker', '', 81, 81, 15000, 15000, 0, 0, 10000, 14, 14, 0, 1, 1, 0, 1000, 2600, 0, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 10000, '', 0, 3, 0, 1, 0, 0, 0, '');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `castBarCaption`, `faction`, `flags`, `size`, `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 (191013, 22, 7146, 'Portal to Shattrath', '', 0, 0, 1, 33728, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
REPLACE INTO `gameobject` VALUES ('784890', '191013', '0', '1', '1', '-8987.36', '495.888', '96.5049', '3.80482', '0', '0', '0.945519', '-0.325567', '25', '0', '1');
REPLACE INTO `gameobject` VALUES ('784891', '191013', '1', '1', '1', '1528.88', '-4413.28', '12.9977', '3.19614', '0', '0', '0.999628', '-0.0272726', '25', '0', '1');
REPLACE INTO `gameobject` VALUES ('784892', '191013', '1', '1', '1', '-1277.71', '119.821', '131.183', '5.28871', '0', '0', '0.477', '-0.878903', '25', '0', '1');
REPLACE INTO `gameobject` VALUES ('784893', '191013', '0', '1', '1', '1804.87', '247.557', '60.587', '0.0268662', '0', '0', '0.0134327', '0.99991', '25', '0', '1');
REPLACE INTO `gameobject` VALUES ('784894', '191013', '530', '1', '1', '9502.29', '-7296.7', '14.0802', '6.16511', '0', '0', '0.0590033', '-0.998258', '25', '0', '1');
REPLACE INTO `gameobject` VALUES ('784895', '191013', '1', '1', '1', '9952.24', '2292.66', '1341.39', '1.56446', '0', '0', '0.704862', '0.709344', '25', '0', '1');
REPLACE INTO `gameobject` VALUES ('784896', '191013', '530', '1', '1', '-4003.39', '-11874.8', '-0.765862', '4.13906', '0', '0', '0.87819', '-0.478312', '25', '0', '1');
REPLACE INTO `gameobject` VALUES ('784897', '191013', '0', '1', '1', '-4979.75', '-884.672', '501.646', '5.39676', '0', '0', '0.428842', '-0.90338', '25', '0', '1');
REPLACE INTO `game_event` VALUES ('101', '2009-03-26 07:00:00', '2019-02-25 23:50:00', '4600', '180', '0', 'Legion Attack Shattrat City');
REPLACE INTO `game_event_gameobject` VALUES ('784890', '101');
REPLACE INTO `game_event_gameobject` VALUES ('784891', '101');
REPLACE INTO `game_event_gameobject` VALUES ('784892', '101');
REPLACE INTO `game_event_gameobject` VALUES ('784893', '101');
REPLACE INTO `game_event_gameobject` VALUES ('784894', '101');
REPLACE INTO `game_event_gameobject` VALUES ('784895', '101');
REPLACE INTO `game_event_gameobject` VALUES ('784896', '101');
REPLACE INTO `game_event_gameobject` VALUES ('784897', '101');
REPLACE INTO `game_event_creature_quest` VALUES ('147852', '147852', '101');
REPLACE INTO `creature` VALUES ('4456071', '147852', '530', '1', '1', '0', '0', '-1818.48', '5415.42', '-12.4274', '2.8477', '25', '0', '0', '25000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456072', '123321', '530', '1', '1', '0', '0', '-1837.11', '5434.27', '-12.4279', '5.97908', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456073', '123321', '530', '1', '1', '0', '0', '-1844.05', '5448.26', '-12.4281', '0.0972285', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456074', '123321', '530', '1', '1', '0', '0', '-1838.55', '5442.12', '-12.4281', '0.145133', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456075', '123321', '530', '1', '1', '0', '0', '-1837.69', '5425.77', '-12.4281', '5.8701', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456076', '123321', '530', '1', '1', '0', '0', '-1843.77', '5415.44', '-12.4281', '5.62105', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456077', '123321', '530', '1', '1', '0', '0', '-1857.53', '5407.44', '-12.4281', '5.16937', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456078', '123321', '530', '1', '1', '0', '0', '-1873.69', '5409.51', '-12.4279', '4.39713', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456079', '123321', '530', '1', '1', '0', '0', '-1882.02', '5417.84', '-12.4279', '3.52298', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456080', '123321', '530', '1', '1', '0', '0', '-1886', '5431.77', '-12.4279', '3.13853', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456081', '123321', '530', '1', '1', '0', '0', '-1879.57', '5444.11', '-12.4279', '2.49613', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456082', '123321', '530', '1', '1', '0', '0', '-1870.93', '5450.06', '-12.4279', '2.30689', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456083', '123321', '530', '1', '1', '0', '0', '-1858.99', '5454.19', '-12.4279', '1.37934', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456084', '123321', '530', '1', '1', '0', '0', '-1865.31', '5420.17', '-10.4635', '4.57904', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456085', '123321', '530', '1', '1', '0', '0', '-1872.37', '5434.62', '-10.4635', '2.76226', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456086', '123321', '530', '1', '1', '0', '0', '-1862.21', '5440.86', '-10.4635', '1.4357', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456087', '123321', '530', '1', '1', '0', '0', '-1853.12', '5428.8', '-10.465', '5.96195', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456089', '123321', '530', '1', '1', '0', '0', '-1832.85', '5367.45', '-12.4279', '2.01271', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456090', '123321', '530', '1', '1', '0', '0', '-1881.65', '5377.25', '-12.4278', '1.2325', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456091', '123321', '530', '1', '1', '0', '0', '-1925.47', '5399.78', '-12.4269', '0.445534', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456092', '123321', '530', '1', '1', '0', '0', '-1918.07', '5448.88', '-12.4277', '5.97709', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456093', '123321', '530', '1', '1', '0', '0', '-1891.06', '5484.28', '-12.4269', '5.13684', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456094', '123321', '530', '1', '1', '0', '0', '-1844.84', '5486.86', '-12.4282', '4.42527', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456095', '123321', '530', '1', '1', '0', '0', '-1809.69', '5458.05', '-12.4283', '3.63203', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456096', '123321', '530', '1', '1', '0', '0', '-1813.89', '5436.43', '-12.4279', '3.27939', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456097', '123321', '530', '1', '1', '0', '0', '-1831.6', '5391.66', '-12.4279', '2.35026', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456098', '123321', '530', '1', '1', '0', '0', '-1853.34', '5381.21', '-12.4279', '1.69131', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456099', '123321', '530', '1', '1', '0', '0', '-1896.37', '5392.58', '-12.4282', '0.859573', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456100', '123321', '530', '1', '1', '0', '0', '-1912.65', '5422.91', '-12.4274', '0.197482', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456101', '123321', '530', '1', '1', '0', '0', '-1902.64', '5463.61', '-12.4279', '5.58453', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456102', '123321', '530', '1', '1', '0', '0', '-1871.74', '5480.14', '-12.4276', '4.8117', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `creature` VALUES ('4456103', '123321', '530', '1', '1', '0', '0', '-1830.19', '5467.15', '-12.428', '3.97761', '25', '0', '0', '15000', '0', '0', '0');
REPLACE INTO `game_event_creature` VALUES ('4456071', '101');
REPLACE INTO `game_event_creature` VALUES ('4456072', '101');
REPLACE INTO `game_event_creature` VALUES ('4456073', '101');
REPLACE INTO `game_event_creature` VALUES ('4456074', '101');
REPLACE INTO `game_event_creature` VALUES ('4456075', '101');
REPLACE INTO `game_event_creature` VALUES ('4456076', '101');
REPLACE INTO `game_event_creature` VALUES ('4456077', '101');
REPLACE INTO `game_event_creature` VALUES ('4456078', '101');
REPLACE INTO `game_event_creature` VALUES ('4456079', '101');
REPLACE INTO `game_event_creature` VALUES ('4456080', '101');
REPLACE INTO `game_event_creature` VALUES ('4456081', '101');
REPLACE INTO `game_event_creature` VALUES ('4456082', '101');
REPLACE INTO `game_event_creature` VALUES ('4456083', '101');
REPLACE INTO `game_event_creature` VALUES ('4456084', '101');
REPLACE INTO `game_event_creature` VALUES ('4456085', '101');
REPLACE INTO `game_event_creature` VALUES ('4456086', '101');
REPLACE INTO `game_event_creature` VALUES ('4456087', '101');
REPLACE INTO `game_event_creature` VALUES ('4456088', '101');
REPLACE INTO `game_event_creature` VALUES ('4456089', '101');
REPLACE INTO `game_event_creature` VALUES ('4456090', '101');
REPLACE INTO `game_event_creature` VALUES ('4456091', '101');
REPLACE INTO `game_event_creature` VALUES ('4456092', '101');
REPLACE INTO `game_event_creature` VALUES ('4456093', '101');
REPLACE INTO `game_event_creature` VALUES ('4456094', '101');
REPLACE INTO `game_event_creature` VALUES ('4456095', '101');
REPLACE INTO `game_event_creature` VALUES ('4456096', '101');
REPLACE INTO `game_event_creature` VALUES ('4456097', '101');
REPLACE INTO `game_event_creature` VALUES ('4456098', '101');
REPLACE INTO `game_event_creature` VALUES ('4456099', '101');
REPLACE INTO `game_event_creature` VALUES ('4456100', '101');
REPLACE INTO `game_event_creature` VALUES ('4456101', '101');
REPLACE INTO `game_event_creature` VALUES ('4456102', '101');
REPLACE INTO `game_event_creature` VALUES ('4456103', '101');