-- Ключ Куэрго
DELETE FROM `creature_loot_template` WHERE (`entry`=7902) AND (`item`=9275);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7902, 9275, 28, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7899) AND (`item`=9275);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7899, 9275, 28, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7901) AND (`item`=9275);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7901, 9275, 25, 0, 1, 1, 0, 0, 0);

-- Шляпа пирата Южных морей
DELETE FROM `creature_loot_template` WHERE (`entry`=7855) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7855, 20519, -25, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7856) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7856, 20519, -24, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7858) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7858, 20519, -21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7857) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7857, 20519, -21, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=7883) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7883, 20519, -20, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=8203) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (8203, 20519, -16, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=15685) AND (`item`=20519);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (15685, 20519, -10, 0, 1, 1, 0, 0, 0);

-- Бурдюк с водой Скитальцев Пустыни
DELETE FROM `creature_loot_template` WHERE (`entry`=7805) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (7805, 8483, -39, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5615) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5615, 8483, -38, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5623) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5623, 8483, -38, 0, 1, 1, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5616) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5616, 8483, -38, 0, 1, 3, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5617) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5617, 8483, -38, 0, 1, 3, 0, 0, 0);
DELETE FROM `creature_loot_template` WHERE (`entry`=5618) AND (`item`=8483);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (5618, 8483, -38, 0, 1, 1, 0, 0, 0);

-- Оргриммар
-- Харрук (офф)
UPDATE creature SET position_x = '273.168976', position_y = '-4713.710449', position_z = '11.627667', orientation = '1.101132' WHERE guid = '37927';
-- Джо'ма (офф)
UPDATE creature SET position_x = '1839.458496', position_y = '-4466.385254', position_z = '47.416718', orientation = '3.335550' WHERE guid = '154663';
-- Белгром Каменная Булава (офф)
UPDATE creature SET position_x = '1953.493042', position_y = '-4735.413086', position_z = '48.314331', orientation = '1.046110' WHERE guid = '40495';
-- Ордынский Вестник Войны (офф)
UPDATE creature SET position_x = '1988.952515', position_y = '-4799.268066', position_z = '55.818367', orientation = '2.320023' WHERE guid = '40522';
-- Зеггон Трестокун (офф)
UPDATE creature SET position_x = '1987.763184', position_y = '-4813.386719', position_z = '56.765160', orientation = '1.770240' WHERE guid = '85513';
-- Андрисса (офф)
UPDATE creature SET position_x = '2002.502075', position_y = '-4791.190430', position_z = '56.764801', orientation = '3.179264' WHERE guid = '284937';
-- Атурк Наковальня (офф)
UPDATE creature SET position_x = '2054.506104', position_y = '-4817.099121', position_z = '22.786383', orientation = '0.578818' WHERE guid = '102514';
-- Орокк Омош (офф)
UPDATE creature SET position_x = '2062.265137', position_y = '-4792.109863', position_z = '22.981644', orientation = '5.888895' WHERE guid = '40597';
-- Шанкис (офф)
UPDATE creature SET position_x = '1995.290771', position_y = '-4662.221680', position_z = '26.819860', orientation = '1.229912' WHERE guid = '40526';
-- Зас'тиш (офф)
UPDATE creature SET position_x = '1991.060181', position_y = '-4652.371582', position_z = '27.069012', orientation = '6.272167' WHERE guid = '284933';
-- Мурчаль (офф)
DELETE FROM creature WHERE guid = '4456716';
INSERT INTO creature VALUES (4456716,15186,1,1,1,0,3915,1991.73,-4651.38,27.0136,6.11115,25,0,0,42,0,0,0);
-- Гурчаль (офф)
DELETE FROM creature WHERE guid = '4456718';
INSERT INTO creature VALUES (4456718,16069,1,1,1,0,3915,1989.66,-4657.17,27.346,0.607085,25,0,0,42,0,0,0);
-- Ксон'ча (офф)
UPDATE creature SET position_x = '2140.487061', position_y = '-4651.901367', position_z = '50.234417', orientation = '1.927016' WHERE guid = '40676';
-- Огунаро Волкопас (офф)
UPDATE creature SET position_x = '2160.095947', position_y = '-4654.399414', position_z = '49.623714', orientation = '2.857707' WHERE guid = '40698';
-- Волки (офф)
DELETE FROM creature WHERE guid = '40692';
DELETE FROM creature_addon WHERE guid = '40692';
DELETE FROM creature_movement WHERE id = '40692';
DELETE FROM game_event_creature WHERE guid = '40692';
DELETE FROM game_event_model_equip WHERE guid = '40692';
DELETE FROM creature WHERE guid = '40706';
DELETE FROM creature_addon WHERE guid = '40706';
DELETE FROM creature_movement WHERE id = '40706';
DELETE FROM game_event_creature WHERE guid = '40706';
DELETE FROM game_event_model_equip WHERE guid = '40706';
DELETE FROM creature WHERE guid = '40704';
DELETE FROM creature_addon WHERE guid = '40704';
DELETE FROM creature_movement WHERE id = '40704';
DELETE FROM game_event_creature WHERE guid = '40704';
DELETE FROM game_event_model_equip WHERE guid = '40704';
DELETE FROM creature WHERE guid = '40693';
DELETE FROM creature_addon WHERE guid = '40693';
DELETE FROM creature_movement WHERE id = '40693';
DELETE FROM game_event_creature WHERE guid = '40693';
DELETE FROM game_event_model_equip WHERE guid = '40693';
UPDATE creature SET position_x = '2155.091309', position_y = '-4649.602539', position_z = '49.996510', orientation = '5.108641' WHERE guid = '40695';
-- Казул (офф)
UPDATE creature SET position_x = '1838.718994', position_y = '-4341.520020', position_z = '-15.475355', orientation = '3.528423' WHERE guid = '40393';
-- Кургул (офф)
UPDATE creature SET position_x = '1836.726196', position_y = '-4346.905273', position_z = '-14.854283', orientation = '3.654094' WHERE guid = '40397';
-- Кор'хус (офф)
UPDATE creature SET position_x = '1767.226440', position_y = '-4367.143066', position_z = '-16.019903', orientation = '5.530743' WHERE guid = '40310';
-- Кор'гхан (офф)
UPDATE creature SET position_x = '1805.453491', position_y = '-4285.564453', position_z = '6.843641', orientation = '3.251528' WHERE guid = '40319';
-- Гест (офф)
UPDATE creature SET position_x = '1792.051636', position_y = '-4278.662598', position_z = '7.283041', orientation = '4.763422' WHERE guid = '40356';
-- Кардрис Сновидец (офф)
UPDATE creature SET position_x = '1933.414307', position_y = '-4224.869629', position_z = '42.095337', orientation = '0.164915' WHERE guid = '40482';
-- Шиан'цу (офф)
UPDATE creature SET position_x = '1933.002808', position_y = '-4211.210449', position_z = '42.095711', orientation = '0.003906' WHERE guid = '40487';
-- Огнир Хранитель Огня (офф)
UPDATE creature SET position_x = '1921.294189', position_y = '-4212.276855', position_z = '42.095711', orientation = '5.354819' WHERE guid = '40455';
-- Кор'кронский гвардеец (офф)
UPDATE creature SET position_x = '1912.393188', position_y = '-4124.594727', position_z = '43.031418', orientation = '5.068145' WHERE guid = '40453';
-- Посол Певица Рассвета (офф)
UPDATE creature SET position_x = '1914.924438', position_y = '-4124.106445', position_z = '42.991863', orientation = '5.068148' WHERE guid = '55704';
-- Наставник Огненор (офф)
UPDATE creature SET position_x = '1939.075684', position_y = '-4133.517090', position_z = '40.917095', orientation = '4.039293' WHERE guid = '283828';
-- Отважный страж-рыцарь крови (офф)
DELETE FROM creature WHERE guid = '4456719';
INSERT INTO creature VALUES (4456719,23131,1,1,1,0,491,1938.63,-4131.95,40.9132,4.13746,25,0,0,4400,3155,0,0);
UPDATE creature SET position_x = '1940.688110', position_y = '-4133.651855', position_z = '40.920368', orientation = '4.039280' WHERE guid = '284655';
-- Вол'джин (офф)
UPDATE creature SET position_x = '1934.175049', position_y = '-4162.474121', position_z = '40.912605', orientation = '2.503833' WHERE guid = '40480';
-- Эйтригг (офф)
UPDATE creature SET position_x = '1906.457397', position_y = '-4161.517090', position_z = '40.919971', orientation = '0.858423' WHERE guid = '40484';
-- Моквар (офф)
UPDATE creature SET position_x = '1916.160400', position_y = '-4171.102539', position_z = '40.923264', orientation = '0.840355' WHERE guid = '51370';
-- Магениус (офф)
UPDATE creature SET position_x = '1890.352661', position_y = '-4321.363281', position_z = '23.169222', orientation = '4.508174' WHERE guid = '40441';
-- Энио (офф)
UPDATE creature SET position_x = '1472.646484', position_y = '-4224.073242', position_z = '42.959274', orientation = '2.067924' WHERE guid = '40050';
-- Продавец пива (офф)
DELETE FROM creature WHERE guid = '153999';
DELETE FROM creature_addon WHERE guid = '153999';
DELETE FROM creature_movement WHERE id = '153999';
DELETE FROM game_event_creature WHERE guid = '153999';
DELETE FROM game_event_model_equip WHERE guid = '153999';
-- Арнок (офф)
UPDATE creature SET position_x = '1482.352661', position_y = '-4159.618652', position_z = '43.793873', orientation = '0.704466' WHERE guid = '40065';

UPDATE `quest_template` SET `ExclusiveGroup` = 11335 WHERE `entry` IN (11335, 11336, 11337, 11338);
UPDATE `quest_template` SET `ExclusiveGroup` = 11339 WHERE `entry` IN (11339, 11340, 11341, 11342);

UPDATE `creature_template` SET minhealth = 4120, maxhealth = 4120, speed = 0.0, scale = 0, rank = 0, mindmg = 0, maxdmg = 0, minrangedmg = 0, maxrangedmg = 0, rangedattackpower = 0 WHERE entry = 6491;  
UPDATE `creature` SET curhealth = 4120 WHERE id = 6491;

UPDATE `creature_template` SET `mindmg` = 275, `maxdmg` = 295, `attackpower` = 1150, `minrangedmg` = 0, `maxrangedmg` = 0, `spell1` = 54400, `ScriptName` = 'generic_creature' WHERE `entry` = 16570;

INSERT INTO gameobject VALUES (802854, 1734, 0, 1, 1, -3534.04, -2400.71, 67.4701, 2.99661, 0, 0, 0.997374, 0.0724284, 1800, 100, 1);   
INSERT INTO gameobject VALUES (802855, 1734, 0, 1, 1, -3423.74, -2121.62, 97.3274, 3.62807, 0, 0, 0.970563, -0.240847, 1800, 100, 1);

DELETE FROM gameobject WHERE guid = '5496';   
INSERT INTO gameobject VALUES (5496, 1734, 0, 1, 1, -2844.08, -2992.33, 59.213, 5.76043, 0, 0, 0.258414, -0.966034, 1800, 100, 1);

INSERT INTO gameobject VALUES (802857, 1734, 0, 1, 1, -11043.2, -51.3462, 17.7003, 3.09248, 0, 0, 0.999698, 0.0245547, 1800, 100, 1);   
INSERT INTO gameobject VALUES (802858, 1734, 0, 1, 1, -10567.1, -725.964, 70.1982, 1.20045, 0, 0, 0.564829, 0.825208, 1800, 100, 1);   
INSERT INTO gameobject VALUES (802861, 1734, 0, 1, 1, -11098.1, -1155.18, 42.4798, 0.102462, 0, 0, 0.0512087, 0.998688, 1800, 100, 1);   
INSERT INTO gameobject VALUES (802862, 1734, 0, 1, 1, -11158.6, -1167.57, 42.3274, 3.01472, 0, 0, 0.997989, 0.0633952, 1800, 100, 1);

DELETE FROM gameobject WHERE guid = '3385';   
INSERT INTO gameobject VALUES (3385, 1734, 0, 1, 1, -10661.6, -891.615, 57.5265, 2.23757, 0, 0, 0.89957, 0.436777, 1800, 100, 1);   
DELETE FROM gameobject WHERE guid = '14516';   
INSERT INTO gameobject VALUES (14516, 1734, 0, 1, 1, -11009, -990.563, 67.6881, 2.97859, 0, 0, 0.996681, 0.0814115, 1800, 100, 1);

#-- Alterac Valley  
#Wintergrasp   
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32616, 7);  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32617, 7);  
#Dalaran  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29669;  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29674;  
#поменял местами были попутаны  
UPDATE `creature` SET `id`=29669 WHERE `guid` = 137926;  
UPDATE `creature` SET `id`=29674 WHERE `guid` = 113465;  

#-- Strand of the Ancients  
#Wintergrasp  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32622, 9);  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32623, 9);  
#Dalaran  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29671;  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29676;  
#орды и альянса стояли в одной точке спауна, перенес на свое место орды  
DELETE FROM `creature` WHERE `id`=29676;  
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES  
(113664, 29676, 571, 1, 1, 0, 0, 5974.76, 544.652, 661.779, 1.97222, 300, 0, 0, 5342, 0, 0, 0);   

#-- Eye of the Storm  
#Wintergrasp  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32620, 1);  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32621, 1);  
#Dalaran  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29670;  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29675;  

#-- Arathi Basin  
#Wintergrasp  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32618, 3);  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32619, 3);  
#Dalaran  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29668;  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29673;  

#-- Strand of the Ancients  
#Wintergrasp  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32624, 2);  
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES  
(32625, 2);  
#Dalaran  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29667;  
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29672;  

#-- расстановка флагов (так как gossip_ом туго поставил все-таки 1048576)  
#чтобы отключить ставим `npcflag` = 1048577 будет просто приветствовать  
UPDATE `creature_template` SET `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2  WHERE `entry` in (29667, 29668, 29670, 29671,29672, 29673, 29675, 29676, 32616, 32617,32618,32619,32620,32621,32622,32623,32624,32625);

#-- Wintergrasp   
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91, `mindmg` = 315, `maxdmg` = 548, `spell1` = 43543, `ScriptName` = 'generic_creature' WHERE `entry` = 30849;  
UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `minhealth` = 25200, `maxhealth` = 25200, `minmana` = 3994, `maxmana` = 3994, `armor` = 7600, `faction_A` = 91, `faction_H` = 91, `mindmg` = 370, `maxdmg` = 816 WHERE `entry` = 30876;  
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30873;  
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30846;  
UPDATE `creature_template` SET `faction_A` = 1802, `faction_H` = 1802, `modelid_H2` = 27941, `mindmg` = 217, `maxdmg` = 509, `attackpower` = 1088 WHERE `entry` = 30499;  
UPDATE `creature_template` SET `modelid_H2` = 27937 WHERE `entry` = 30400;  
UPDATE `creature_template` SET `modelid_H2` = 24468, `faction_A` = 168, `faction_H` = 168 WHERE `entry` = 30845;  
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30847;  
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30872;  
UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80, `minhealth` = 25200, `maxhealth` = 25200, `armor` = 14500, `faction_A` = 91, `faction_H` = 91, `mindmg` = 355, `maxdmg` = 814, `spell1` = 56620, `ScriptName` = 'generic_creature' WHERE `entry` = 30875;  
UPDATE `creature_template` SET `modelid_H2` = 25951, `faction_A` = 1891, `faction_H` = 1891, `spell1` = 42648, `spell2` = 11976, `ScriptName` = 'generic_creature' WHERE `entry` = 30740;  
UPDATE `creature_template` SET `modelid_H2` = 25951, `minlevel` = 80, `maxlevel` = 80, `minhealth` = 63000, `maxhealth` = 63000, `minmana` = 11982, `maxmana` = 11982, `armor` = 7600, `faction_A` = 1891, `faction_H` = 1891, `mindmg` = 370, `maxdmg` = 816, `spell1` = 11976, `ScriptName` = 'generic_creature' WHERE `entry` = 32308;  
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30842;  
UPDATE `creature_template` SET `faction_A` = 1978, `faction_H` = 1978, `spell1` = 42648, `spell2` = 11976, mingold = 3340, maxgold = 3346, `ScriptName` = 'generic_creature' WHERE `entry` = 30739;  
UPDATE `creature_template` SET `modelid_H2` = 24076, `minlevel` = 80, `maxlevel` = 80, `minhealth` = 63000, `maxhealth` = 63000, `armor` = 14500, `faction_A` = 1978, `faction_H` = 1978, `mindmg` = 355, `maxdmg` = 814, `spell1` = 11976, `ScriptName` = 'generic_creature' WHERE `entry` = 32307;  
UPDATE `creature_template` SET `faction_A` = 91, `faction_H` = 91 WHERE `entry` = 30877;  
UPDATE `creature_template` SET `type_flags` = 32, `RacialLeader` = 1 WHERE `entry` = 27850;  
UPDATE `creature_template` SET `IconName` = 'vehichleCursor' WHERE `entry` = 27881;  
UPDATE `creature_template` SET `modelid_A` = 27137, `modelid_H` = 27137, `IconName` = 'Interact' WHERE `entry` = 27852;  
UPDATE `creature_template` SET `minhealth` = 50000, `maxhealth` = 50000, `modelid_A` = 27658, `modelid_H` = 27658, `IconName` = 'vehichleCursor' WHERE `entry` = 28094;  
UPDATE `creature_template` SET `modelid_A` = 25292, `modelid_H` = 25292, `IconName` = 'vehichleCursor', `minhealth` = 75000, `maxhealth` = 75000 WHERE `entry` = 28312;  
UPDATE `creature_template` SET `IconName` = 'vehichleCursor', `minlevel` = 80, `maxlevel` = 80, `minhealth` = 75000, `maxhealth` = 75000, `armor` = 14500, `faction_A` = 714, `faction_H` = 714, `mindmg` = 355, `maxdmg` = 814 WHERE `entry` = 32627;  
UPDATE `creature_template` SET `IconName` = 'Gunner', `minhealth` = 50000, `maxhealth` = 50000 WHERE `entry` = 28319;  
UPDATE `creature_template` SET `IconName` = 'Gunner', `minlevel` = 80, `maxlevel` = 80, `minhealth` = 50000, `maxhealth` = 50000, `armor` = 14500, `faction_A` = 714, `faction_H` = 714, `mindmg` = 355, `maxdmg` = 814 WHERE `entry` = 32629;