Unbenannt

/* Creature Template */
UPDATE `creature_template` SET armor=5700, mindmg=633, maxdmg=912, attackpower=2739, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, type=0 ,mingold=961900, maxgold=1000000 WHERE entry=23420;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23420);
INSERT INTO `creature_loot_template` VALUES
(23420, 32754, 10.6, 0, 1, 1, 1),
(23420, 32744, 0.6, 0, 1, 1, 1),
(23420, 32750, 0.6, 0, 1, 1, 1),
(23420, 32745, 0.6, 0, 1, 1, 1),
(23420, 32738, 4, 0, 1, 1, 1),
(23420, 32737, 0.6, 0, 1, 1, 1),
(23420, 32346, 13, 0, 1, 1, 1),
(23420, 32354, 11, 0, 1, 1, 1),
(23420, 32345, 9, 0, 1, 1, 1),
(23420, 32351, 6, 0, 1, 1, 1),
(23420, 32353, 15, 0, 1, 1, 1),
(23420, 32347, 27, 0, 1, 1, 1),
(23420, 32363, 11, 0, 1, 1, 1),
(23420, 32352, 6, 0, 1, 1, 1),
(23420, 32751, 5, 0, 1, 1, 1),
(23420, 32755, 4, 0, 1, 1, 1),
(23420, 32752, 11, 0, 1, 1, 1),
(23420, 32362, 1.2, 0, 1, 1, 1),
(23420, 32739, 0.6, 0, 1, 1, 1),
(23420, 32517, 25, 0, 1, 1, 1),
(23420, 32332, 20, 0, 1, 1, 1),
(23420, 32350, 19, 0, 1, 1, 1),
(23420, 32349, 12, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, mindmg=633, maxdmg=912, attackpower=2739, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, type=0 ,mingold=961900, maxgold=1000000 WHERE entry=23419;

/* Creature Template */
UPDATE `creature_template` SET armor=5700, mindmg=633, maxdmg=912, attackpower=2739, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, type=0 ,mingold=961900, maxgold=1000000 WHERE entry=23418;

/* Creature Template */
UPDATE `creature_template` SET subname='Illidari Council', minhealth=2300000, maxhealth=2300000, armor=5700, mindmg=653, maxdmg=912, attackpower=2739, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=310000, maxgold=350000, MovementType=1, InhabitType=1 WHERE entry=22949;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22949);
INSERT INTO `creature_loot_template` VALUES
/*(22949, 31098, 42, 0, 1, 1, 1),
(22949, 31099, 37, 0, 1, 1, 1),
(22949, 31100, 23, 0, 1, 1, 1)*/;

/* Creature Equipment */
REPLACE INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES (22949 , 43531, 0, 0, 218235906, 0, 0, 273, 0, 768);

/* Creature Template */
UPDATE `creature_template` SET minhealth=5600000, maxhealth=5600000, armor=5700, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=961900, maxgold=1000000, MovementType=1, InhabitType=1 WHERE entry=22948;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22948);
INSERT INTO `creature_loot_template` VALUES
(22948, 32754, 1.5, 0, 1, 1, 1),
(22948, 32744, 0.4, 0, 1, 1, 1),
(22948, 32750, 0.4, 0, 1, 1, 1),
(22948, 32745, 0.4, 0, 1, 1, 1),
(22948, 32747, 0.7, 0, 1, 1, 1),
(22948, 32339, 21, 0, 1, 1, 1),
(22948, 32338, 16, 0, 1, 1, 1),
(22948, 32340, 16, 0, 1, 1, 1),
(22948, 32342, 11, 0, 1, 1, 1),
(22948, 32333, 16, 0, 1, 1, 1),
(22948, 32341, 11, 0, 1, 1, 1),
(22948, 32269, 15, 0, 1, 1, 1),
(22948, 32751, 1.5, 0, 1, 1, 1),
(22948, 32749, 2, 0, 1, 1, 1),
(22948, 32752, 1.5, 0, 1, 1, 1),
(22948, 32739, 1.1, 0, 1, 1, 1),
(22948, 32737, 4, 0, 1, 1, 1),
(22948, 32501, 19, 0, 1, 1, 1),
(22948, 32337, 12, 0, 1, 1, 1),
(22948, 32344, 14, 0, 1, 1, 1),
(22948, 32335, 17, 0, 1, 1, 1),
(22948, 32334, 12, 0, 1, 1, 1),
(22948, 32343, 15, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET subname='Illidari Council', armor=5700, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=310000, maxgold=350000, MovementType=1, InhabitType=1 WHERE entry=22950;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22950);
INSERT INTO `creature_loot_template` VALUES
(22950, 32519, 11, 0, 1, 1, 1),
(22950, 32331, 20, 0, 1, 1, 1),
(22950, 32376, 6.9, 0, 1, 1, 1),
(22950, 32373, 16, 0, 1, 1, 1),
(22950, 32505, 32, 0, 1, 1, 1),
(22950, 32518, 17, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, mingold=961900, maxgold=1000000 WHERE entry=22887;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22887);
INSERT INTO `creature_loot_template` VALUES
(22887, 32232, 17, 0, 1, 1, 1),
(22887, 32234, 19, 0, 1, 1, 1),
(22887, 32236, 13, 0, 1, 1, 1),
(22887, 32237, 18, 0, 1, 1, 1),
(22887, 32238, 13, 0, 1, 1, 1),
(22887, 32239, 20, 0, 1, 1, 1),
(22887, 32240, 16, 0, 1, 1, 1),
(22887, 32241, 11, 0, 1, 1, 1),
(22887, 32242, 3, 0, 1, 1, 1),
(22887, 32243, 14, 0, 1, 1, 1),
(22887, 32245, 4, 0, 1, 1, 1),
(22887, 32247, 16, 0, 1, 1, 1),
(22887, 32248, 15, 0, 1, 1, 1),
(22887, 32377, 17, 0, 1, 1, 1),
(22887, 32736, 3, 0, 1, 1, 1),
(22887, 32737, 0.3, 0, 1, 1, 1),
(22887, 32739, 0.3, 0, 1, 1, 1),
(22887, 32744, 2, 0, 1, 1, 1),
(22887, 32745, 1, 0, 1, 1, 1),
(22887, 32748, 0.3, 0, 1, 1, 1),
(22887, 32749, 1, 0, 1, 1, 1),
(22887, 32750, 2, 0, 1, 1, 1),
(22887, 32751, 0.8, 0, 1, 1, 1),
(22887, 32752, 1.3, 0, 1, 1, 1),
(22887, 32753, 4, 0, 1, 1, 1),
(22887, 32754, 5, 0, 1, 1, 1),
(22887, 32755, 2, 0, 1, 1, 1);

/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (22917, 21135, 21135, 'Illidan Stormrage', 'The Betrayer', 74, 74, 6100000, 6100000, 6774, 6774, 5700, 14, 14, 0, 1, 3, 250, 2250, 0, 8750, 1000, 1500, 0, 0, 0, 0, 0, 0, 0, 8000, 12000, 200, 7, 0, 138936390, 22917, 0, 0, 0, 0, 0, 0, 0, 0, 22733, 0, 0, 0, 1160000, 1170000, '', 0, 3, 0, 1, 22917,'boss_illidan');

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22917);
INSERT INTO `creature_loot_template` VALUES
(22917, 32746, 0.6, 0, 1, 1, 1),
/*(22917, 31089, 22, 0, 1, 1, 1),
(22917, 31090, 65, 0, 1, 1, 1),
(22917, 31091, 39, 0, 1, 1, 1),*/
(22917, 32235, 3, 0, 1, 1, 1),
(22917, 32336, 27, 0, 1, 1, 1),
(22917, 32374, 15, 0, 1, 1, 1),
(22917, 32375, 16, 0, 1, 1, 1),
(22917, 32471, 21, 0, 1, 1, 1),
(22917, 32483, 25, 0, 1, 1, 1),
(22917, 32496, 11, 0, 1, 1, 1),
(22917, 32497, 21, 0, 1, 1, 1),
(22917, 32500, 23, 0, 1, 1, 1),
(22917, 32521, 2, 0, 1, 1, 1),
(22917, 32524, 17, 0, 1, 1, 1),
(22917, 32525, 7, 0, 1, 1, 1),
(22917, 32739, 0.6, 0, 1, 1, 1),
(22917, 32744, 1.1, 0, 1, 1, 1),
(22917, 32748, 2, 0, 1, 1, 1),
(22917, 32749, 0.6, 0, 1, 1, 1),
(22917, 32751, 1.1, 0, 1, 1, 1),
(22917, 32752, 3, 0, 1, 1, 1),
(22917, 32753, 0.6, 0, 1, 1, 1),
(22917, 32754, 4, 0, 1, 1, 1),
(22917, 32837, 4, 0, 1, 1, 1),
(22917, 32838, 1.7, 0, 1, 1, 1);

/* Creatyre Equipment */
REPLACE INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES (22917 , 45479, 45481, 0, 218169346, 218169346, 0, 2, 2, 0);

/* Creature Template */
UPDATE `creature_template` SET subname='Illidari Council', minhealth=16000, maxhealth=16000, armor=5700, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=310000, maxgold=350000, MovementType=1, InhabitType=1 WHERE entry=22951;

#EDIT: The T6 Tokens have been "commented out" till someone can post the proper lootgroup.

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22951);
INSERT INTO `creature_loot_template` VALUES
(22951, 32230, 10, 0, 1, 1, 1),
(22951, 32227, 16, 0, 1, 1, 1),
(22951, 32228, 18, 0, 1, 1, 1),
/*(22951, 31098, 6, 0, 1, 1, 1),*/
(22951, 32229, 22, 0, 1, 1, 1),
(22951, 32231, 10, 0, 1, 1, 1),
(22951, 32249, 16, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=3100000, maxhealth=3100000, armor=5700, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=961900, maxgold=1000000, MovementType=1, InhabitType=1 WHERE entry=22947;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22947);
INSERT INTO `creature_loot_template` VALUES
/*(22947, 31101, 46, 0, 1, 1, 1),
(22947, 31102, 47, 0, 1, 1, 1),
(22947, 31103, 52, 0, 1, 1, 1),*/
(22947, 32365, 10, 0, 1, 1, 1),
(22947, 32366, 10, 0, 1, 1, 1),
(22947, 32367, 20, 0, 1, 1, 1),
(22947, 32368, 20, 0, 1, 1, 1),
(22947, 32369, 18, 0, 1, 1, 1),
(22947, 32370, 14, 0, 1, 1, 1),
(22947, 32737, 1.5, 0, 1, 1, 1),
(22947, 32738, 0.5, 0, 1, 1, 1),
(22947, 32744, 0.5, 0, 1, 1, 1),
(22947, 32745, 0.5, 0, 1, 1, 1),
(22947, 32748, 3, 0, 1, 1, 1),
(22947, 32749, 2, 0, 1, 1, 1),
(22947, 32750, 1, 0, 1, 1, 1),
(22947, 32752, 1, 0, 1, 1, 1),
(22947, 32755, 5, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, mingold=961900, maxgold=1000000 WHERE entry=22841;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22841);
INSERT INTO `creature_loot_template` VALUES
(22841, 32748, 0.2, 0, 1, 1, 1),
(22841, 32754, 0.7, 0, 1, 1, 1),
(22841, 32745, 0.5, 0, 1, 1, 1),
(22841, 32753, 0.5, 0, 1, 1, 1),
(22841, 32747, 0.2, 0, 1, 1, 1),
(22841, 32737, 0.2, 0, 1, 1, 1),
(22841, 32273, 19, 0, 1, 1, 1),
(22841, 32361, 15, 0, 1, 1, 1),
(22841, 32276, 8, 0, 1, 1, 1),
(22841, 32270, 10, 0, 1, 1, 1),
(22841, 32278, 15, 0, 1, 1, 1),
(22841, 32271, 15, 0, 1, 1, 1),
(22841, 32268, 12, 0, 1, 1, 1),
(22841, 32751, 1, 0, 1, 1, 1),
(22841, 32755, 0.2, 0, 1, 1, 1),
(22841, 32749, 2, 0, 1, 1, 1),
(22841, 32752, 0.7, 0, 1, 1, 1),
(22841, 32746, 1.5, 0, 1, 1, 1),
(22841, 32738, 1.7, 0, 1, 1, 1),
(22841, 32739, 2, 0, 1, 1, 1),
(22841, 32736, 1, 0, 1, 1, 1),
(22841, 32263, 18, 0, 1, 1, 1),
(22841, 32266, 12, 0, 1, 1, 1),
(22841, 32265, 16, 0, 1, 1, 1),
(22841, 32264, 20, 0, 1, 1, 1),
(22841, 32275, 7, 0, 1, 1, 1),
(22841, 32279, 7, 0, 1, 1, 1),
(22841, 32513, 14, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=4500000, maxhealth=4500000, armor=5700, baseattacktime=350, rangeattacktime=200, mingold=961900, maxgold=1000000, MovementType=1, InhabitType=1 WHERE entry=22898;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22898);
INSERT INTO `creature_loot_template` VALUES
(22898, 32755, 3, 0, 1, 1, 1),
(22898, 32754, 0.9, 0, 1, 1, 1),
(22898, 32753, 0.6, 0, 1, 1, 1),
(22898, 32751, 1.4, 0, 1, 1, 1),
(22898, 32750, 1.7, 0, 1, 1, 1),
(22898, 32749, 1.7, 0, 1, 1, 1),
(22898, 32747, 0.9, 0, 1, 1, 1),
(22898, 32745, 2, 0, 1, 1, 1),
(22898, 32744, 0.3, 0, 1, 1, 1),
(22898, 32738, 0.6, 0, 1, 1, 1),
(22898, 32739, 0.6, 0, 1, 1, 1),
(22898, 32736, 1.1, 0, 1, 1, 1),
(22898, 32262, 14, 0, 1, 1, 1),
(22898, 32261, 16, 0, 1, 1, 1),
(22898, 32260, 15, 0, 1, 1, 1),
(22898, 32259, 5, 0, 1, 1, 1),
(22898, 32258, 12, 0, 1, 1, 1),
(22898, 32257, 13, 0, 1, 1, 1),
(22898, 32256, 19, 0, 1, 1, 1),
(22898, 32255, 17, 0, 1, 1, 1),
(22898, 32254, 13, 0, 1, 1, 1),
(22898, 32253, 16, 0, 1, 1, 1),
(22898, 32252, 13, 0, 1, 1, 1),
(22898, 32251, 20, 0, 1, 1, 1),
(22898, 32250, 20, 0, 1, 1, 1);

/* Creature Template */
DELETE FROM `creature_template` WHERE entry=21867;
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (22871, 21262, 21262, 'Teron Gorefiend', '', 73, 73, 5000000, 5000000, 1693500, 1693500, 5700, 14, 14, 0, 1, 3, 258, 513, 0, 2697, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 6, 0, 0, 22871, 0, 0, 0, 0, 0, 0, 0, 0, 32232, 0, 0, 0, 961900, 100000, '', 1, 1, 0, 1, 22871,'');

/* Creature Location */
DELETE FROM `creature` WHERE `id`=22871;
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(86131,22871,564,21262,22871,'601.25','402.168','187.09','3.12063',0,0,0,'601.25','402.168','187.09','3.12063',5000000,163500,0,1,'');

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22871);
INSERT INTO `creature_loot_template` VALUES
(22871, 32512, 24, 0, 1, 1, 1),
(22871, 32325, 19, 0, 1, 1, 1),
(22871, 32744, 0.4, 0, 1, 1, 1),
(22871, 32749, 1.5, 0, 1, 1, 1),
(22871, 32752, 1.1, 0, 1, 1, 1),
(22871, 32737, 4, 0, 1, 1, 1),
(22871, 32328, 18, 0, 1, 1, 1),
(22871, 32329, 14, 0, 1, 1, 1),
(22871, 32280, 15, 0, 1, 1, 1),
(22871, 32324, 16, 0, 1, 1, 1),
(22871, 32754, 1.5, 0, 1, 1, 1),
(22871, 32750, 1.5, 0, 1, 1, 1),
(22871, 32751, 1.5, 0, 1, 1, 1),
(22871, 32755, 1.8, 0, 1, 1, 1),
(22871, 32745, 0.4, 0, 1, 1, 1),
(22871, 32753, 0.4, 0, 1, 1, 1),
(22871, 32746, 1.1, 0, 1, 1, 1),
(22871, 32747, 4, 0, 1, 1, 1),
(22871, 32738, 1.8, 0, 1, 1, 1),
(22871, 32739, 0.7, 0, 1, 1, 1),
(22871, 32736, 1.8, 0, 1, 1, 1),
(22871, 32327, 14, 0, 1, 1, 1),
(22871, 32323, 15, 0, 1, 1, 1),
(22871, 32510, 7, 0, 1, 1, 1),
(22871, 32348, 18, 0, 1, 1, 1),
(22871, 32330, 11, 0, 1, 1, 1),
(22871, 32326, 7, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET subname='Illidari Council', minhealth=50000, maxhealth=50000, armor=5700, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=310000, maxgold=350000, MovementType=1, InhabitType=1 WHERE entry=22952;

EDIT: The T6 Tokens have been "commented out" till someone can post the proper lootgroup.

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22952);
INSERT INTO `creature_loot_template` VALUES
/*(22952, 31100, 40, 0, 1, 1, 1),
(22952, 31099, 32, 0, 1, 1, 1),
(22952, 31098, 31, 0, 1, 1, 1)*/;

/* Creature Template */
UPDATE `creature_template` SET minlevel=1, maxlevel=1, minhealth=1, maxhealth=1, minmana=0, maxmana=0, mindmg=0, maxdmg=1, attackpower=0, minrangedmg=0, maxrangedmg=0, InhabitType=1 WHERE entry=23086;

/* Creature Template */
UPDATE `creature_template` SET minhealth=440000, maxhealth=440000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22878;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22878);
INSERT INTO `creature_loot_template` VALUES
(22878, 32526, 0.3, 0, 1, 1, 1),
(22878, 32592, 1.1, 0, 1, 1, 1),
(22878, 32591, 0.6, 0, 1, 1, 1),
(22878, 32227, 3, 0, 1, 1, 1),
(22878, 32228, 2, 0, 1, 1, 1),
(22878, 32589, 0.3, 0, 1, 1, 1),
(22878, 32229, 2, 0, 1, 1, 1),
(22878, 32608, 1.1, 0, 1, 1, 1),
(22878, 32231, 3, 0, 1, 1, 1),
(22878, 32249, 1.4, 0, 1, 1, 1),
(22878, 32230, 0.8, 0, 1, 1, 1),
(22878, 32593, 3, 0, 1, 1, 1),
(22878, 29549, 0.3, 0, 1, 1, 1),
(22878, 31837, 0.3, 0, 1, 1, 1),
(22878, 25057, 0.6, 0, 1, 1, 1),
(22878, 24679, 0.3, 0, 1, 1, 1),
(22878, 23077, 0.3, 0, 1, 1, 1),
(22878, 24805, 0.3, 0, 1, 1, 1),
(22878, 24798, 0.3, 0, 1, 1, 1),
(22878, 24688, 0.3, 0, 1, 1, 1),
(22878, 24689, 0.3, 0, 1, 1, 1),
(22878, 7080, 1.1, 0, 1, 1, 1),
(22878, 25295, 0.3, 0, 1, 1, 1),
(22878, 32897, 8, 0, 1, 1, 1),
(22878, 23107, 0.3, 0, 1, 1, 1),
(22878, 24904, 0.3, 0, 1, 1, 1),
(22878, 24903, 0.3, 0, 1, 1, 1),
(22878, 24909, 0.3, 0, 1, 1, 1),
(22878, 25027, 0.3, 0, 1, 1, 1),
(22878, 25029, 0.3, 0, 1, 1, 1),
(22878, 22578, 26, 0, 1, 4, 1),
(22878, 25406, 0.3, 0, 1, 1, 1),
(22878, 25374, 0.3, 0, 1, 1, 1),
(22878, 25357, 0.3, 0, 1, 1, 1),
(22878, 25362, 0.3, 0, 1, 1, 1),
(22878, 25364, 0.6, 0, 1, 1, 1),
(22878, 25404, 0.3, 0, 1, 1, 1),
(22878, 25399, 0.3, 0, 1, 1, 1),
(22878, 25390, 0.3, 0, 1, 1, 1),
(22878, 25391, 0.3, 0, 1, 1, 1),
(22878, 25393, 0.6, 0, 1, 1, 1),
(22878, 25344, 0.3, 0, 1, 1, 1),
(22878, 24508, 66, 0, 1, 4, 1),
(22878, 24511, 20, 0, 1, 4, 1),
(22878, 25405, 0.6, 0, 1, 1, 1),
(22878, 25403, 0.3, 0, 1, 1, 1),
(22878, 25402, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minlevel=70, maxlevel=72, minhealth=62000, maxhealth=67000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22883;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22883);
INSERT INTO `creature_loot_template` VALUES
(22883, 24508, 77, 0, 1, 1, 1),
(22883, 22578, 28, 0, 1, 4, 1),
(22883, 24511, 16, 0, 1, 1, 1),
(22883, 32897, 9, 0, 1, 1, 1),
(22883, 7080, 3, 0, 1, 1, 1),
(22883, 25403, 0.9, 0, 1, 1, 1),
(22883, 25362, 0.7, 0, 1, 1, 1),
(22883, 25401, 0.5, 0, 1, 1, 1),
(22883, 25344, 0.5, 0, 1, 1, 1),
(22883, 31877, 0.4, 0, 1, 1, 1),
(22883, 25055, 0.4, 0, 1, 1, 1),
(22883, 25373, 0.4, 0, 1, 1, 1),
(22883, 25389, 0.4, 0, 1, 1, 1),
(22883, 25392, 0.4, 0, 1, 1, 1),
(22883, 31952, 0.3, 0, 1, 1, 1),
(22883, 24898, 0.3, 0, 1, 1, 1),
(22883, 24905, 0.3, 0, 1, 1, 1),
(22883, 25374, 0.3, 0, 1, 1, 1),
(22883, 25377, 0.3, 0, 1, 1, 1),
(22883, 25358, 0.3, 0, 1, 1, 1),
(22883, 24683, 0.2, 0, 1, 1, 1),
(22883, 23077, 0.2, 0, 1, 1, 1),
(22883, 24669, 0.2, 0, 1, 1, 1),
(22883, 25068, 0.2, 0, 1, 1, 1),
(22883, 25292, 0.2, 0, 1, 1, 1),
(22883, 25306, 0.2, 0, 1, 1, 1),
(22883, 24662, 0.2, 0, 1, 1, 1),
(22883, 24664, 0.2, 0, 1, 1, 1),
(22883, 25375, 0.2, 0, 1, 1, 1),
(22883, 25376, 0.2, 0, 1, 1, 1),
(22883, 25378, 0.2, 0, 1, 1, 1),
(22883, 25399, 0.2, 0, 1, 1, 1),
(22883, 25390, 0.2, 0, 1, 1, 1),
(22883, 25393, 0.2, 0, 1, 1, 1),
(22883, 25394, 0.2, 0, 1, 1, 1),
(22883, 25341, 0.2, 0, 1, 1, 1),
(22883, 25348, 0.2, 0, 1, 1, 1),
(22883, 25398, 0.2, 0, 1, 1, 1),
(22883, 25400, 0.2, 0, 1, 1, 1),
(22883, 25402, 0.2, 0, 1, 1, 1),
(22883, 31837, 0.1, 0, 1, 1, 1),
(22883, 24165, 0.1, 0, 1, 1, 1),
(22883, 24680, 0.1, 0, 1, 1, 1),
(22883, 24679, 0.1, 0, 1, 1, 1),
(22883, 25208, 0.1, 0, 1, 1, 1),
(22883, 25005, 0.1, 0, 1, 1, 1),
(22883, 25196, 0.1, 0, 1, 1, 1),
(22883, 24780, 0.1, 0, 1, 1, 1),
(22883, 25008, 0.1, 0, 1, 1, 1),
(22883, 25012, 0.1, 0, 1, 1, 1),
(22883, 25007, 0.1, 0, 1, 1, 1),
(22883, 25010, 0.1, 0, 1, 1, 1),
(22883, 25011, 0.1, 0, 1, 1, 1),
(22883, 25195, 0.1, 0, 1, 1, 1),
(22883, 25210, 0.1, 0, 1, 1, 1),
(22883, 25294, 0.1, 0, 1, 1, 1),
(22883, 24676, 0.1, 0, 1, 1, 1),
(22883, 24671, 0.1, 0, 1, 1, 1),
(22883, 24791, 0.1, 0, 1, 1, 1),
(22883, 24790, 0.1, 0, 1, 1, 1),
(22883, 24795, 0.1, 0, 1, 1, 1),
(22883, 25322, 0.1, 0, 1, 1, 1),
(22883, 24781, 0.1, 0, 1, 1, 1),
(22883, 24783, 0.1, 0, 1, 1, 1),
(22883, 22913, 0.1, 0, 1, 1, 1),
(22883, 25125, 0.1, 0, 1, 1, 1),
(22883, 25168, 0.1, 0, 1, 1, 1),
(22883, 24665, 0.1, 0, 1, 1, 1),
(22883, 23107, 0.1, 0, 1, 1, 1),
(22883, 25016, 0.1, 0, 1, 1, 1),
(22883, 25018, 0.1, 0, 1, 1, 1),
(22883, 25019, 0.1, 0, 1, 1, 1),
(22883, 24886, 0.1, 0, 1, 1, 1),
(22883, 24893, 0.1, 0, 1, 1, 1),
(22883, 24890, 0.1, 0, 1, 1, 1),
(22883, 24895, 0.1, 0, 1, 1, 1),
(22883, 24903, 0.1, 0, 1, 1, 1),
(22883, 25181, 0.1, 0, 1, 1, 1),
(22883, 24901, 0.1, 0, 1, 1, 1),
(22883, 25406, 0.1, 0, 1, 1, 1),
(22883, 25380, 0.1, 0, 1, 1, 1),
(22883, 25357, 0.1, 0, 1, 1, 1),
(22883, 25364, 0.1, 0, 1, 1, 1),
(22883, 25404, 0.1, 0, 1, 1, 1),
(22883, 25342, 0.1, 0, 1, 1, 1),
(22883, 25343, 0.1, 0, 1, 1, 1),
(22883, 25345, 0.1, 0, 1, 1, 1),
(22883, 25346, 0.1, 0, 1, 1, 1),
(22883, 25397, 0.1, 0, 1, 1, 1),
(22883, 25405, 0.1, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, mingold=10000, maxgold=11000 WHERE entry=22881;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22881);
INSERT INTO `creature_loot_template` VALUES
(22881, 24508, 23, 0, 3, 3, 1),
(22881, 32897, 11, 0, 1, 1, 1),
(22881, 25398, 6, 0, 1, 1, 1),
(22881, 7080, 6, 0, 1, 1, 1),
(22881, 32227, 3, 0, 1, 1, 1),
(22881, 32608, 3, 0, 1, 1, 1),
(22881, 25405, 1.5, 0, 1, 1, 1),
(22881, 25375, 1.5, 0, 1, 1, 1),
(22881, 25380, 1.5, 0, 1, 1, 1),
(22881, 24909, 1.5, 0, 1, 1, 1),
(22881, 24671, 1.5, 0, 1, 1, 1),
(22881, 24675, 1.5, 0, 1, 1, 1),
(22881, 31952, 1.5, 0, 1, 1, 1),
(22881, 24679, 1.5, 0, 1, 1, 1),
(22881, 32249, 1.5, 0, 1, 1, 1),
(22881, 32590, 1.5, 0, 1, 1, 1),
(22881, 32231, 1.5, 0, 1, 1, 1),
(22881, 23077, 1.5, 0, 1, 1, 1),
(22881, 24895, 1.5, 0, 1, 1, 1),
(22881, 25391, 1.5, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=330000, maxhealth=330000, armor=5700, faction_A=1820, faction_H=1820, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, pickpocketloot=22844, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22844;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22844);
INSERT INTO `creature_loot_template` VALUES
(22844, 21877, 35, 0, 2, 3, 1),
(22844, 32428, 13, 0, 1, 1, 1),
(22844, 32897, 6, 0, 1, 1, 1),
(22844, 32230, 3, 0, 1, 1, 1),
(22844, 32227, 3, 0, 1, 1, 1),
(22844, 32231, 3, 0, 1, 1, 1),
(22844, 32229, 2, 0, 1, 1, 1),
(22844, 32228, 1.6, 0, 1, 1, 1),
(22844, 32249, 1.6, 0, 1, 1, 1),
(22844, 32526, 1.3, 0, 1, 1, 1),
(22844, 32589, 0.9, 0, 1, 1, 1),
(22844, 32527, 0.9, 0, 1, 1, 1),
(22844, 32591, 0.7, 0, 1, 1, 1),
(22844, 32606, 0.7, 0, 1, 1, 1),
(22844, 32528, 0.5, 0, 1, 1, 1),
(22844, 32755, 0.5, 0, 1, 1, 1),
(22844, 34012, 0.5, 0, 1, 1, 1),
(22844, 24801, 0.5, 0, 1, 1, 1),
(22844, 25380, 0.5, 0, 1, 1, 1),
(22844, 25399, 0.5, 0, 1, 1, 1),
(22844, 25392, 0.5, 0, 1, 1, 1),
(22844, 25400, 0.5, 0, 1, 1, 1),
(22844, 32592, 0.4, 0, 1, 1, 1),
(22844, 32590, 0.4, 0, 1, 1, 1),
(22844, 32752, 0.4, 0, 1, 1, 1),
(22844, 32738, 0.4, 0, 1, 1, 1),
(22844, 32737, 0.4, 0, 1, 1, 1),
(22844, 24677, 0.4, 0, 1, 1, 1),
(22844, 24679, 0.4, 0, 1, 1, 1),
(22844, 25070, 0.4, 0, 1, 1, 1),
(22844, 24803, 0.4, 0, 1, 1, 1),
(22844, 24689, 0.4, 0, 1, 1, 1),
(22844, 25322, 0.4, 0, 1, 1, 1),
(22844, 24910, 0.4, 0, 1, 1, 1),
(22844, 24916, 0.4, 0, 1, 1, 1),
(22844, 24904, 0.4, 0, 1, 1, 1),
(22844, 25071, 0.4, 0, 1, 1, 1),
(22844, 25308, 0.4, 0, 1, 1, 1),
(22844, 25023, 0.4, 0, 1, 1, 1),
(22844, 25406, 0.4, 0, 1, 1, 1),
(22844, 25401, 0.4, 0, 1, 1, 1),
(22844, 25403, 0.4, 0, 1, 1, 1),
(22844, 25398, 0.4, 0, 1, 1, 1),
(22844, 32750, 0.2, 0, 1, 1, 1),
(22844, 32753, 0.2, 0, 1, 1, 1),
(22844, 32608, 0.2, 0, 1, 1, 1),
(22844, 31334, 0.2, 0, 1, 1, 1),
(22844, 32593, 0.2, 0, 1, 1, 1),
(22844, 24169, 0.2, 0, 1, 1, 1),
(22844, 31298, 0.2, 0, 1, 1, 1),
(22844, 31299, 0.2, 0, 1, 1, 1),
(22844, 25056, 0.2, 0, 1, 1, 1),
(22844, 25323, 0.2, 0, 1, 1, 1),
(22844, 23077, 0.2, 0, 1, 1, 1),
(22844, 24802, 0.2, 0, 1, 1, 1),
(22844, 25085, 0.2, 0, 1, 1, 1),
(22844, 24686, 0.2, 0, 1, 1, 1),
(22844, 24688, 0.2, 0, 1, 1, 1),
(22844, 24691, 0.2, 0, 1, 1, 1),
(22844, 24791, 0.2, 0, 1, 1, 1),
(22844, 24794, 0.2, 0, 1, 1, 1),
(22844, 24792, 0.2, 0, 1, 1, 1),
(22844, 25127, 0.2, 0, 1, 1, 1),
(22844, 23107, 0.2, 0, 1, 1, 1),
(22844, 25016, 0.2, 0, 1, 1, 1),
(22844, 25017, 0.2, 0, 1, 1, 1),
(22844, 25337, 0.2, 0, 1, 1, 1),
(22844, 25025, 0.2, 0, 1, 1, 1),
(22844, 25253, 0.2, 0, 1, 1, 1),
(22844, 25374, 0.2, 0, 1, 1, 1),
(22844, 25376, 0.2, 0, 1, 1, 1),
(22844, 25378, 0.2, 0, 1, 1, 1),
(22844, 25360, 0.2, 0, 1, 1, 1),
(22844, 25362, 0.2, 0, 1, 1, 1),
(22844, 25363, 0.2, 0, 1, 1, 1),
(22844, 25404, 0.2, 0, 1, 1, 1),
(22844, 25393, 0.2, 0, 1, 1, 1),
(22844, 25394, 0.2, 0, 1, 1, 1),
(22844, 25342, 0.2, 0, 1, 1, 1),
(22844, 25347, 0.2, 0, 1, 1, 1),
(22844, 25402, 0.2, 0, 1, 1, 1);

/* Pickpocket Loot */
DELETE FROM `pickpocketing_loot_template` WHERE (`entry`=22844);
INSERT INTO `pickpocketing_loot_template` VALUES
(22844, 29569, 33, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=170000, maxhealth=170000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22845;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22845);
INSERT INTO `creature_loot_template` VALUES
(22845, 21877, 37, 0, 2, 3, 1),
(22845, 32428, 14, 0, 1, 1, 1),
(22845, 32897, 11, 0, 1, 1, 1),
(22845, 32228, 2, 0, 1, 1, 1),
(22845, 32231, 2, 0, 1, 1, 1),
(22845, 32227, 2, 0, 1, 1, 1),
(22845, 32229, 1.7, 0, 1, 1, 1),
(22845, 32249, 1.5, 0, 1, 1, 1),
(22845, 32230, 1.5, 0, 1, 1, 1),
(22845, 25345, 1.5, 0, 1, 1, 1),
(22845, 32528, 1.1, 0, 1, 1, 1),
(22845, 32943, 1.1, 0, 1, 1, 1),
(22845, 32526, 0.9, 0, 1, 1, 1),
(22845, 24903, 0.9, 0, 1, 1, 1),
(22845, 32606, 0.6, 0, 1, 1, 1),
(22845, 32590, 0.6, 0, 1, 1, 1),
(22845, 32539, 0.6, 0, 1, 1, 1),
(22845, 25361, 0.6, 0, 1, 1, 1),
(22845, 32589, 0.4, 0, 1, 1, 1),
(22845, 32744, 0.4, 0, 1, 1, 1),
(22845, 32608, 0.4, 0, 1, 1, 1),
(22845, 32527, 0.4, 0, 1, 1, 1),
(22845, 31915, 0.4, 0, 1, 1, 1),
(22845, 25007, 0.4, 0, 1, 1, 1),
(22845, 24790, 0.4, 0, 1, 1, 1),
(22845, 24784, 0.4, 0, 1, 1, 1),
(22845, 25027, 0.4, 0, 1, 1, 1),
(22845, 25377, 0.4, 0, 1, 1, 1),
(22845, 25403, 0.4, 0, 1, 1, 1),
(22845, 25398, 0.4, 0, 1, 1, 1),
(22845, 32609, 0.2, 0, 1, 1, 1),
(22845, 32751, 0.2, 0, 1, 1, 1),
(22845, 32752, 0.2, 0, 1, 1, 1),
(22845, 25097, 0.2, 0, 1, 1, 1),
(22845, 25012, 0.2, 0, 1, 1, 1),
(22845, 25010, 0.2, 0, 1, 1, 1),
(22845, 25070, 0.2, 0, 1, 1, 1),
(22845, 24802, 0.2, 0, 1, 1, 1),
(22845, 24676, 0.2, 0, 1, 1, 1),
(22845, 24688, 0.2, 0, 1, 1, 1),
(22845, 24792, 0.2, 0, 1, 1, 1),
(22845, 25112, 0.2, 0, 1, 1, 1),
(22845, 25280, 0.2, 0, 1, 1, 1),
(22845, 25111, 0.2, 0, 1, 1, 1),
(22845, 25042, 0.2, 0, 1, 1, 1),
(22845, 24914, 0.2, 0, 1, 1, 1),
(22845, 25020, 0.2, 0, 1, 1, 1),
(22845, 25018, 0.2, 0, 1, 1, 1),
(22845, 25224, 0.2, 0, 1, 1, 1),
(22845, 24901, 0.2, 0, 1, 1, 1),
(22845, 25406, 0.2, 0, 1, 1, 1),
(22845, 25401, 0.2, 0, 1, 1, 1),
(22845, 25373, 0.2, 0, 1, 1, 1),
(22845, 25358, 0.2, 0, 1, 1, 1),
(22845, 25399, 0.2, 0, 1, 1, 1),
(22845, 25390, 0.2, 0, 1, 1, 1),
(22845, 25392, 0.2, 0, 1, 1, 1),
(22845, 25395, 0.2, 0, 1, 1, 1),
(22845, 25341, 0.2, 0, 1, 1, 1),
(22845, 25344, 0.2, 0, 1, 1, 1),
(22845, 25397, 0.2, 0, 1, 1, 1),
(22845, 25400, 0.2, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22846;


/* Creature Template */
UPDATE `creature_template` SET armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22847;

/* Creature Template */
UPDATE `creature_template` SET minhealth=170000, maxhealth=170000, minmana=32310, maxmana=32310, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23028;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23028);
INSERT INTO `creature_loot_template` VALUES
(23028, 21877, 32, 0, 1, 3, 1),
(23028, 32897, 11, 0, 1, 1, 1),
(23028, 32428, 11, 0, 1, 1, 1),
(23028, 32231, 3, 0, 1, 1, 1),
(23028, 32528, 3, 0, 1, 1, 1),
(23028, 32229, 3, 0, 1, 1, 1),
(23028, 32227, 3, 0, 1, 1, 1),
(23028, 32589, 2, 0, 1, 1, 1),
(23028, 32230, 2, 0, 1, 1, 1),
(23028, 32609, 1.1, 0, 1, 1, 1),
(23028, 32228, 1.1, 0, 1, 1, 1),
(23028, 32749, 1.1, 0, 1, 1, 1),
(23028, 32592, 0.6, 0, 1, 1, 1),
(23028, 32527, 0.6, 0, 1, 1, 1),
(23028, 32943, 0.6, 0, 1, 1, 1),
(23028, 31912, 0.6, 0, 1, 1, 1),
(23028, 25069, 0.6, 0, 1, 1, 1),
(23028, 25401, 0.6, 0, 1, 1, 1),
(23028, 25375, 0.6, 0, 1, 1, 1),
(23028, 25399, 0.6, 0, 1, 1, 1),
(23028, 25343, 0.6, 0, 1, 1, 1),
(23028, 25405, 0.6, 0, 1, 1, 1),
(23028, 25403, 0.6, 0, 1, 1, 1),
(23028, 32591, 0.3, 0, 1, 1, 1),
(23028, 32590, 0.3, 0, 1, 1, 1),
(23028, 32745, 0.3, 0, 1, 1, 1),
(23028, 32752, 0.3, 0, 1, 1, 1),
(23028, 32739, 0.3, 0, 1, 1, 1),
(23028, 32249, 0.3, 0, 1, 1, 1),
(23028, 32593, 0.3, 0, 1, 1, 1),
(23028, 29549, 0.3, 0, 1, 1, 1),
(23028, 24296, 0.3, 0, 1, 1, 1),
(23028, 25056, 0.3, 0, 1, 1, 1),
(23028, 25009, 0.3, 0, 1, 1, 1),
(23028, 25011, 0.3, 0, 1, 1, 1),
(23028, 24798, 0.3, 0, 1, 1, 1),
(23028, 24799, 0.3, 0, 1, 1, 1),
(23028, 24686, 0.3, 0, 1, 1, 1),
(23028, 24688, 0.3, 0, 1, 1, 1),
(23028, 24790, 0.3, 0, 1, 1, 1),
(23028, 24794, 0.3, 0, 1, 1, 1),
(23028, 24796, 0.3, 0, 1, 1, 1),
(23028, 25111, 0.3, 0, 1, 1, 1),
(23028, 24789, 0.3, 0, 1, 1, 1),
(23028, 24786, 0.3, 0, 1, 1, 1),
(23028, 24913, 0.3, 0, 1, 1, 1),
(23028, 24916, 0.3, 0, 1, 1, 1),
(23028, 25125, 0.3, 0, 1, 1, 1),
(23028, 25020, 0.3, 0, 1, 1, 1),
(23028, 25017, 0.3, 0, 1, 1, 1),
(23028, 25022, 0.3, 0, 1, 1, 1),
(23028, 25357, 0.3, 0, 1, 1, 1),
(23028, 25361, 0.3, 0, 1, 1, 1),
(23028, 25364, 0.3, 0, 1, 1, 1),
(23028, 25389, 0.3, 0, 1, 1, 1),
(23028, 25391, 0.3, 0, 1, 1, 1),
(23028, 25392, 0.3, 0, 1, 1, 1),
(23028, 25394, 0.3, 0, 1, 1, 1),
(23028, 25395, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=53000, maxhealth=53000, minmana=31550, maxmana=31550, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22963;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22963);
INSERT INTO `creature_loot_template` VALUES
(22963, 21877, 38, 0, 1, 3, 1),
(22963, 32897, 11, 0, 1, 1, 1),
(22963, 32428, 6, 0, 1, 1, 1),
(22963, 31952, 1.2, 0, 1, 1, 1),
(22963, 32249, 1.1, 0, 1, 1, 1),
(22963, 32593, 0.7, 0, 1, 1, 1),
(22963, 25363, 0.7, 0, 1, 1, 1),
(22963, 25400, 0.7, 0, 1, 1, 1),
(22963, 32228, 0.7, 0, 1, 1, 1),
(22963, 32229, 0.7, 0, 1, 1, 1),
(22963, 32230, 0.6, 0, 1, 1, 1),
(22963, 32527, 0.5, 0, 1, 1, 1),
(22963, 24668, 0.5, 0, 1, 1, 1),
(22963, 24665, 0.5, 0, 1, 1, 1),
(22963, 25374, 0.5, 0, 1, 1, 1),
(22963, 25341, 0.5, 0, 1, 1, 1),
(22963, 32528, 0.4, 0, 1, 1, 1),
(22963, 24797, 0.4, 0, 1, 1, 1),
(22963, 25322, 0.4, 0, 1, 1, 1),
(22963, 25301, 0.4, 0, 1, 1, 1),
(22963, 24906, 0.4, 0, 1, 1, 1),
(22963, 24905, 0.4, 0, 1, 1, 1),
(22963, 25376, 0.4, 0, 1, 1, 1),
(22963, 25377, 0.4, 0, 1, 1, 1),
(22963, 25358, 0.4, 0, 1, 1, 1),
(22963, 25390, 0.4, 0, 1, 1, 1),
(22963, 25398, 0.4, 0, 1, 1, 1),
(22963, 25402, 0.4, 0, 1, 1, 1),
(22963, 32227, 0.2, 0, 1, 1, 1),
(22963, 32589, 0.2, 0, 1, 1, 1),
(22963, 32590, 0.2, 0, 1, 1, 1),
(22963, 31331, 0.2, 0, 1, 1, 1),
(22963, 31501, 0.2, 0, 1, 1, 1),
(22963, 25056, 0.2, 0, 1, 1, 1),
(22963, 23077, 0.2, 0, 1, 1, 1),
(22963, 25070, 0.2, 0, 1, 1, 1),
(22963, 25152, 0.2, 0, 1, 1, 1),
(22963, 24783, 0.2, 0, 1, 1, 1),
(22963, 24784, 0.2, 0, 1, 1, 1),
(22963, 24897, 0.2, 0, 1, 1, 1),
(22963, 25379, 0.2, 0, 1, 1, 1),
(22963, 25359, 0.2, 0, 1, 1, 1),
(22963, 25404, 0.2, 0, 1, 1, 1),
(22963, 25391, 0.2, 0, 1, 1, 1),
(22963, 25396, 0.2, 0, 1, 1, 1),
(22963, 25344, 0.2, 0, 1, 1, 1),
(22963, 25346, 0.2, 0, 1, 1, 1),
(22963, 25405, 0.2, 0, 1, 1, 1),
(22963, 25403, 0.2, 0, 1, 1, 1),
(22963, 32526, 0.1, 0, 1, 1, 1),
(22963, 32592, 0.1, 0, 1, 1, 1),
(22963, 32591, 0.1, 0, 1, 1, 1),
(22963, 32606, 0.1, 0, 1, 1, 1),
(22963, 31305, 0.1, 0, 1, 1, 1),
(22963, 31837, 0.1, 0, 1, 1, 1),
(22963, 31293, 0.1, 0, 1, 1, 1),
(22963, 25041, 0.1, 0, 1, 1, 1),
(22963, 24680, 0.1, 0, 1, 1, 1),
(22963, 24683, 0.1, 0, 1, 1, 1),
(22963, 25208, 0.1, 0, 1, 1, 1),
(22963, 25001, 0.1, 0, 1, 1, 1),
(22963, 24999, 0.1, 0, 1, 1, 1),
(22963, 25005, 0.1, 0, 1, 1, 1),
(22963, 24774, 0.1, 0, 1, 1, 1),
(22963, 24775, 0.1, 0, 1, 1, 1),
(22963, 24779, 0.1, 0, 1, 1, 1),
(22963, 25009, 0.1, 0, 1, 1, 1),
(22963, 25006, 0.1, 0, 1, 1, 1),
(22963, 25182, 0.1, 0, 1, 1, 1),
(22963, 24670, 0.1, 0, 1, 1, 1),
(22963, 24676, 0.1, 0, 1, 1, 1),
(22963, 24673, 0.1, 0, 1, 1, 1),
(22963, 25069, 0.1, 0, 1, 1, 1),
(22963, 24794, 0.1, 0, 1, 1, 1),
(22963, 25112, 0.1, 0, 1, 1, 1),
(22963, 23112, 0.1, 0, 1, 1, 1),
(22963, 25238, 0.1, 0, 1, 1, 1),
(22963, 25068, 0.1, 0, 1, 1, 1),
(22963, 24789, 0.1, 0, 1, 1, 1),
(22963, 24785, 0.1, 0, 1, 1, 1),
(22963, 25042, 0.1, 0, 1, 1, 1),
(22963, 25167, 0.1, 0, 1, 1, 1),
(22963, 25306, 0.1, 0, 1, 1, 1),
(22963, 25168, 0.1, 0, 1, 1, 1),
(22963, 24667, 0.1, 0, 1, 1, 1),
(22963, 25014, 0.1, 0, 1, 1, 1),
(22963, 25018, 0.1, 0, 1, 1, 1),
(22963, 24887, 0.1, 0, 1, 1, 1),
(22963, 24889, 0.1, 0, 1, 1, 1),
(22963, 25083, 0.1, 0, 1, 1, 1),
(22963, 25054, 0.1, 0, 1, 1, 1),
(22963, 24901, 0.1, 0, 1, 1, 1),
(22963, 25098, 0.1, 0, 1, 1, 1),
(22963, 25266, 0.1, 0, 1, 1, 1),
(22963, 25084, 0.1, 0, 1, 1, 1),
(22963, 25375, 0.1, 0, 1, 1, 1),
(22963, 25378, 0.1, 0, 1, 1, 1),
(22963, 25360, 0.1, 0, 1, 1, 1),
(22963, 25399, 0.1, 0, 1, 1, 1),
(22963, 25389, 0.1, 0, 1, 1, 1),
(22963, 25394, 0.1, 0, 1, 1, 1),
(22963, 25345, 0.1, 0, 1, 1, 1),
(22963, 25348, 0.1, 0, 1, 1, 1),
(22963, 25397, 0.1, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=290000, maxhealth=290000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22873;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22873);
INSERT INTO `creature_loot_template` VALUES
(22873, 17058, 28, 0, 1, 1, 1),
(22873, 17057, 24, 0, 1, 1, 1),
(22873, 32227, 4, 0, 1, 1, 1),
(22873, 32897, 4, 0, 1, 1, 1),
(22873, 32590, 2, 0, 1, 1, 1),
(22873, 32528, 1.8, 0, 1, 1, 1),
(22873, 32229, 1.8, 0, 1, 1, 1),
(22873, 32231, 1.8, 0, 1, 1, 1),
(22873, 25341, 1.8, 0, 1, 1, 1),
(22873, 25400, 1.8, 0, 1, 1, 1),
(22873, 32591, 1.3, 0, 1, 1, 1),
(22873, 32228, 1.3, 0, 1, 1, 1),
(22873, 32606, 1.3, 0, 1, 1, 1),
(22873, 32249, 1.3, 0, 1, 1, 1),
(22873, 32230, 1.3, 0, 1, 1, 1),
(22873, 27860, 0.9, 0, 1, 1, 1),
(22873, 27858, 0.9, 0, 1, 1, 1),
(22873, 25406, 0.9, 0, 1, 1, 1),
(22873, 25380, 0.9, 0, 1, 1, 1),
(22873, 25342, 0.9, 0, 1, 1, 1),
(22873, 25397, 0.9, 0, 1, 1, 1),
(22873, 32609, 0.4, 0, 1, 1, 1),
(22873, 24680, 0.4, 0, 1, 1, 1),
(22873, 25321, 0.4, 0, 1, 1, 1),
(22873, 24676, 0.4, 0, 1, 1, 1),
(22873, 24672, 0.4, 0, 1, 1, 1),
(22873, 24688, 0.4, 0, 1, 1, 1),
(22873, 25295, 0.4, 0, 1, 1, 1),
(22873, 24784, 0.4, 0, 1, 1, 1),
(22873, 24787, 0.4, 0, 1, 1, 1),
(22873, 27499, 0.4, 0, 1, 1, 1),
(22873, 25363, 0.4, 0, 1, 1, 1),
(22873, 25344, 0.4, 0, 1, 1, 1),
(22873, 25403, 0.4, 0, 1, 1, 1),
(22873, 25398, 0.4, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=170000, maxhealth=170000, minmana=129240, maxmana=129240, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22874;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22874);
INSERT INTO `creature_loot_template` VALUES
(22874, 17058, 31, 0, 1, 1, 1),
(22874, 17057, 25, 0, 1, 1, 1),
(22874, 32592, 6, 0, 1, 1, 1),
(22874, 32526, 4, 0, 1, 1, 1),
(22874, 32591, 4, 0, 1, 1, 1),
(22874, 32589, 4, 0, 1, 1, 1),
(22874, 32249, 4, 0, 1, 1, 1),
(22874, 32230, 4, 0, 1, 1, 1),
(22874, 32231, 3, 0, 1, 1, 1),
(22874, 32527, 3, 0, 1, 1, 1),
(22874, 32897, 3, 0, 1, 1, 1),
(22874, 32227, 1.3, 0, 1, 1, 1),
(22874, 32606, 1.3, 0, 1, 1, 1),
(22874, 32229, 1.3, 0, 1, 1, 1),
(22874, 32608, 1.3, 0, 1, 1, 1),
(22874, 25010, 1.3, 0, 1, 1, 1),
(22874, 25380, 1.3, 0, 1, 1, 1),
(22874, 25362, 1.3, 0, 1, 1, 1),
(22874, 25402, 1.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=170000, maxhealth=170000, minmana=129240, maxmana=129240, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22875;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22875);
INSERT INTO `creature_loot_template` VALUES
(22875, 17058, 29, 0, 1, 1, 1),
(22875, 17057, 28, 0, 1, 1, 1),
(22875, 32897, 9, 0, 1, 1, 1),
(22875, 32228, 4, 0, 1, 1, 1),
(22875, 32229, 4, 0, 1, 1, 1),
(22875, 32231, 2, 0, 1, 1, 1),
(22875, 27858, 2, 0, 1, 1, 1),
(22875, 32249, 1.6, 0, 1, 1, 1),
(22875, 24215, 1.3, 0, 1, 1, 1),
(22875, 27860, 1.3, 0, 1, 1, 1),
(22875, 32230, 1, 0, 1, 1, 1),
(22875, 24801, 1, 0, 1, 1, 1),
(22875, 25376, 1, 0, 1, 1, 1),
(22875, 25364, 1, 0, 1, 1, 1),
(22875, 32592, 0.8, 0, 1, 1, 1),
(22875, 32227, 0.8, 0, 1, 1, 1),
(22875, 32606, 0.8, 0, 1, 1, 1),
(22875, 32590, 0.8, 0, 1, 1, 1),
(22875, 32608, 0.8, 0, 1, 1, 1),
(22875, 24903, 0.8, 0, 1, 1, 1),
(22875, 25389, 0.8, 0, 1, 1, 1),
(22875, 25027, 0.5, 0, 1, 1, 1),
(22875, 25391, 0.5, 0, 1, 1, 1),
(22875, 25392, 0.5, 0, 1, 1, 1),
(22875, 25405, 0.5, 0, 1, 1, 1),
(22875, 32526, 0.3, 0, 1, 1, 1),
(22875, 32591, 0.3, 0, 1, 1, 1),
(22875, 32589, 0.3, 0, 1, 1, 1),
(22875, 31328, 0.3, 0, 1, 1, 1),
(22875, 32527, 0.3, 0, 1, 1, 1),
(22875, 32943, 0.3, 0, 1, 1, 1),
(22875, 25055, 0.3, 0, 1, 1, 1),
(22875, 25057, 0.3, 0, 1, 1, 1),
(22875, 24683, 0.3, 0, 1, 1, 1),
(22875, 24679, 0.3, 0, 1, 1, 1),
(22875, 25323, 0.3, 0, 1, 1, 1),
(22875, 23077, 0.3, 0, 1, 1, 1),
(22875, 25321, 0.3, 0, 1, 1, 1),
(22875, 25294, 0.3, 0, 1, 1, 1),
(22875, 24669, 0.3, 0, 1, 1, 1),
(22875, 24671, 0.3, 0, 1, 1, 1),
(22875, 25335, 0.3, 0, 1, 1, 1),
(22875, 24784, 0.3, 0, 1, 1, 1),
(22875, 24915, 0.3, 0, 1, 1, 1),
(22875, 25084, 0.3, 0, 1, 1, 1),
(22875, 25406, 0.3, 0, 1, 1, 1),
(22875, 25401, 0.3, 0, 1, 1, 1),
(22875, 25377, 0.3, 0, 1, 1, 1),
(22875, 25378, 0.3, 0, 1, 1, 1),
(22875, 25380, 0.3, 0, 1, 1, 1),
(22875, 25360, 0.3, 0, 1, 1, 1),
(22875, 25404, 0.3, 0, 1, 1, 1),
(22875, 25396, 0.3, 0, 1, 1, 1),
(22875, 25342, 0.3, 0, 1, 1, 1),
(22875, 25348, 0.3, 0, 1, 1, 1),
(22875, 25397, 0.3, 0, 1, 1, 1),
(22875, 25400, 0.3, 0, 1, 1, 1),
(22875, 25402, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=170000, maxhealth=170000, minmana=32310, maxmana=32310, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22877;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22877);
INSERT INTO `creature_loot_template` VALUES
(22877, 17058, 29, 0, 1, 1, 1),
(22877, 17057, 28, 0, 1, 1, 1),
(22877, 32897, 9, 0, 1, 1, 1),
(22877, 32228, 4, 0, 1, 1, 1),
(22877, 32229, 4, 0, 1, 1, 1),
(22877, 32231, 2, 0, 1, 1, 1),
(22877, 27858, 2, 0, 1, 1, 1),
(22877, 32249, 1.6, 0, 1, 1, 1),
(22877, 24215, 1.3, 0, 1, 1, 1),
(22877, 27860, 1.3, 0, 1, 1, 1),
(22877, 32230, 1, 0, 1, 1, 1),
(22877, 24801, 1, 0, 1, 1, 1),
(22877, 25376, 1, 0, 1, 1, 1),
(22877, 25364, 1, 0, 1, 1, 1),
(22877, 32592, 0.8, 0, 1, 1, 1),
(22877, 32227, 0.8, 0, 1, 1, 1),
(22877, 32606, 0.8, 0, 1, 1, 1),
(22877, 32590, 0.8, 0, 1, 1, 1),
(22877, 32608, 0.8, 0, 1, 1, 1),
(22877, 24903, 0.8, 0, 1, 1, 1),
(22877, 25389, 0.8, 0, 1, 1, 1),
(22877, 25027, 0.5, 0, 1, 1, 1),
(22877, 25391, 0.5, 0, 1, 1, 1),
(22877, 25392, 0.5, 0, 1, 1, 1),
(22877, 25405, 0.5, 0, 1, 1, 1),
(22877, 32526, 0.3, 0, 1, 1, 1),
(22877, 32591, 0.3, 0, 1, 1, 1),
(22877, 32589, 0.3, 0, 1, 1, 1),
(22877, 31328, 0.3, 0, 1, 1, 1),
(22877, 32527, 0.3, 0, 1, 1, 1),
(22877, 32943, 0.3, 0, 1, 1, 1),
(22877, 25055, 0.3, 0, 1, 1, 1),
(22877, 25057, 0.3, 0, 1, 1, 1),
(22877, 24683, 0.3, 0, 1, 1, 1),
(22877, 24679, 0.3, 0, 1, 1, 1),
(22877, 25323, 0.3, 0, 1, 1, 1),
(22877, 23077, 0.3, 0, 1, 1, 1),
(22877, 25321, 0.3, 0, 1, 1, 1),
(22877, 25294, 0.3, 0, 1, 1, 1),
(22877, 24669, 0.3, 0, 1, 1, 1),
(22877, 24671, 0.3, 0, 1, 1, 1),
(22877, 25335, 0.3, 0, 1, 1, 1),
(22877, 24784, 0.3, 0, 1, 1, 1),
(22877, 24915, 0.3, 0, 1, 1, 1),
(22877, 25084, 0.3, 0, 1, 1, 1),
(22877, 25406, 0.3, 0, 1, 1, 1),
(22877, 25401, 0.3, 0, 1, 1, 1),
(22877, 25377, 0.3, 0, 1, 1, 1),
(22877, 25378, 0.3, 0, 1, 1, 1),
(22877, 25380, 0.3, 0, 1, 1, 1),
(22877, 25360, 0.3, 0, 1, 1, 1),
(22877, 25404, 0.3, 0, 1, 1, 1),
(22877, 25396, 0.3, 0, 1, 1, 1),
(22877, 25342, 0.3, 0, 1, 1, 1),
(22877, 25348, 0.3, 0, 1, 1, 1),
(22877, 25397, 0.3, 0, 1, 1, 1),
(22877, 25400, 0.3, 0, 1, 1, 1),
(22877, 25402, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=100000, maxhealth=100000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, skinloot=22885, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22885;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22885);
INSERT INTO `creature_loot_template` VALUES
(22885, 17057, 28, 0, 1, 1, 1),
(22885, 17058, 25, 0, 1, 1, 1),
(22885, 32897, 12, 0, 1, 1, 1),
(22885, 32527, 5, 0, 1, 1, 1),
(22885, 32228, 3, 0, 1, 1, 1),
(22885, 32229, 3, 0, 1, 1, 1),
(22885, 32608, 3, 0, 1, 1, 1),
(22885, 32231, 3, 0, 1, 1, 1),
(22885, 32249, 3, 0, 1, 1, 1),
(22885, 32943, 3, 0, 1, 1, 1),
(22885, 24894, 3, 0, 1, 1, 1),
(22885, 25406, 3, 0, 1, 1, 1),
(22885, 32592, 1.7, 0, 1, 1, 1),
(22885, 32227, 1.7, 0, 1, 1, 1),
(22885, 32606, 1.7, 0, 1, 1, 1),
(22885, 34012, 1.7, 0, 1, 1, 1),
(22885, 31952, 1.7, 0, 1, 1, 1),
(22885, 24665, 1.7, 0, 1, 1, 1),
(22885, 24892, 1.7, 0, 1, 1, 1),
(22885, 24907, 1.7, 0, 1, 1, 1),
(22885, 27860, 1.7, 0, 1, 1, 1),
(22885, 25360, 1.7, 0, 1, 1, 1),
(22885, 25404, 1.7, 0, 1, 1, 1),
(22885, 25391, 1.7, 0, 1, 1, 1),
(22885, 25393, 1.7, 0, 1, 1, 1),
(22885, 25348, 1.7, 0, 1, 1, 1);

/* Skinning Loot */
DELETE FROM `skinning_loot_template` WHERE (`entry`=22885);
INSERT INTO `skinning_loot_template` VALUES
(22885, 21887, 25, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=200000, maxhealth=200000, minmana=32310, maxmana=32310, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23030;

/* Creature loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23030);
INSERT INTO `creature_loot_template` VALUES
(23030, 21877, 32, 0, 1, 3, 1),
(23030, 32428, 14, 0, 1, 1, 1),
(23030, 32897, 10, 0, 1, 1, 1),
(23030, 32249, 4, 0, 1, 1, 1),
(23030, 32591, 3, 0, 1, 1, 1),
(23030, 32230, 2, 0, 1, 1, 1),
(23030, 32228, 2, 0, 1, 1, 1),
(23030, 32227, 1.9, 0, 1, 1, 1),
(23030, 32231, 1.4, 0, 1, 1, 1),
(23030, 32606, 1.1, 0, 1, 1, 1),
(23030, 32229, 1.1, 0, 1, 1, 1),
(23030, 32608, 1.1, 0, 1, 1, 1),
(23030, 32593, 1.1, 0, 1, 1, 1),
(23030, 25006, 0.8, 0, 1, 1, 1),
(23030, 32609, 0.5, 0, 1, 1, 1),
(23030, 32590, 0.5, 0, 1, 1, 1),
(23030, 32749, 0.5, 0, 1, 1, 1),
(23030, 32738, 0.5, 0, 1, 1, 1),
(23030, 24675, 0.5, 0, 1, 1, 1),
(23030, 24916, 0.5, 0, 1, 1, 1),
(23030, 25395, 0.5, 0, 1, 1, 1),
(23030, 32589, 0.3, 0, 1, 1, 1),
(23030, 32753, 0.3, 0, 1, 1, 1),
(23030, 32752, 0.3, 0, 1, 1, 1),
(23030, 32747, 0.3, 0, 1, 1, 1),
(23030, 32527, 0.3, 0, 1, 1, 1),
(23030, 24680, 0.3, 0, 1, 1, 1),
(23030, 24681, 0.3, 0, 1, 1, 1),
(23030, 25265, 0.3, 0, 1, 1, 1),
(23030, 25010, 0.3, 0, 1, 1, 1),
(23030, 24670, 0.3, 0, 1, 1, 1),
(23030, 24672, 0.3, 0, 1, 1, 1),
(23030, 24691, 0.3, 0, 1, 1, 1),
(23030, 23112, 0.3, 0, 1, 1, 1),
(23030, 24783, 0.3, 0, 1, 1, 1),
(23030, 25267, 0.3, 0, 1, 1, 1),
(23030, 25307, 0.3, 0, 1, 1, 1),
(23030, 25014, 0.3, 0, 1, 1, 1),
(23030, 25017, 0.3, 0, 1, 1, 1),
(23030, 25018, 0.3, 0, 1, 1, 1),
(23030, 24900, 0.3, 0, 1, 1, 1),
(23030, 24904, 0.3, 0, 1, 1, 1),
(23030, 24906, 0.3, 0, 1, 1, 1),
(23030, 24907, 0.3, 0, 1, 1, 1),
(23030, 24901, 0.3, 0, 1, 1, 1),
(23030, 25375, 0.3, 0, 1, 1, 1),
(23030, 25376, 0.3, 0, 1, 1, 1),
(23030, 25357, 0.3, 0, 1, 1, 1),
(23030, 25358, 0.3, 0, 1, 1, 1),
(23030, 25360, 0.3, 0, 1, 1, 1),
(23030, 25392, 0.3, 0, 1, 1, 1),
(23030, 25342, 0.3, 0, 1, 1, 1),
(23030, 25345, 0.3, 0, 1, 1, 1),
(23030, 25348, 0.3, 0, 1, 1, 1),
(23030, 25400, 0.3, 0, 1, 1, 1),
(23030, 25402, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=200000, maxhealth=200000, minmana=48465, maxmana=48465, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23330;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23330);
INSERT INTO `creature_loot_template` VALUES
(23330, 21877, 35, 0, 1, 3, 1),
(23330, 32428, 15, 0, 1, 1, 1),
(23330, 32897, 12, 0, 1, 1, 1),
(23330, 32231, 4, 0, 1, 1, 1),
(23330, 32228, 3, 0, 1, 1, 1),
(23330, 32227, 2, 0, 1, 1, 1),
(23330, 32229, 1.9, 0, 1, 1, 1),
(23330, 32249, 1.7, 0, 1, 1, 1),
(23330, 32528, 1.4, 0, 1, 1, 1),
(23330, 32608, 1.4, 0, 1, 1, 1),
(23330, 25360, 1.4, 0, 1, 1, 1),
(23330, 32752, 1.2, 0, 1, 1, 1),
(23330, 32230, 1.2, 0, 1, 1, 1),
(23330, 32526, 0.7, 0, 1, 1, 1),
(23330, 32747, 0.7, 0, 1, 1, 1),
(23330, 25401, 0.7, 0, 1, 1, 1),
(23330, 25363, 0.7, 0, 1, 1, 1),
(23330, 25364, 0.7, 0, 1, 1, 1),
(23330, 25344, 0.7, 0, 1, 1, 1),
(23330, 32609, 0.5, 0, 1, 1, 1),
(23330, 32527, 0.5, 0, 1, 1, 1),
(23330, 32593, 0.5, 0, 1, 1, 1),
(23330, 25126, 0.5, 0, 1, 1, 1),
(23330, 25154, 0.5, 0, 1, 1, 1),
(23330, 25196, 0.5, 0, 1, 1, 1),
(23330, 24669, 0.5, 0, 1, 1, 1),
(23330, 24791, 0.5, 0, 1, 1, 1),
(23330, 25197, 0.5, 0, 1, 1, 1),
(23330, 24902, 0.5, 0, 1, 1, 1),
(23330, 25024, 0.5, 0, 1, 1, 1),
(23330, 25404, 0.5, 0, 1, 1, 1),
(23330, 25399, 0.5, 0, 1, 1, 1),
(23330, 25405, 0.5, 0, 1, 1, 1),
(23330, 25403, 0.5, 0, 1, 1, 1),
(23330, 32592, 0.2, 0, 1, 1, 1),
(23330, 32589, 0.2, 0, 1, 1, 1),
(23330, 32754, 0.2, 0, 1, 1, 1),
(23330, 32750, 0.2, 0, 1, 1, 1),
(23330, 32745, 0.2, 0, 1, 1, 1),
(23330, 32943, 0.2, 0, 1, 1, 1),
(23330, 31884, 0.2, 0, 1, 1, 1),
(23330, 31912, 0.2, 0, 1, 1, 1),
(23330, 31898, 0.2, 0, 1, 1, 1),
(23330, 25057, 0.2, 0, 1, 1, 1),
(23330, 24678, 0.2, 0, 1, 1, 1),
(23330, 25011, 0.2, 0, 1, 1, 1),
(23330, 24804, 0.2, 0, 1, 1, 1),
(23330, 24800, 0.2, 0, 1, 1, 1),
(23330, 24676, 0.2, 0, 1, 1, 1),
(23330, 24674, 0.2, 0, 1, 1, 1),
(23330, 24685, 0.2, 0, 1, 1, 1),
(23330, 24692, 0.2, 0, 1, 1, 1),
(23330, 24687, 0.2, 0, 1, 1, 1),
(23330, 24789, 0.2, 0, 1, 1, 1),
(23330, 24787, 0.2, 0, 1, 1, 1),
(23330, 24788, 0.2, 0, 1, 1, 1),
(23330, 24913, 0.2, 0, 1, 1, 1),
(23330, 25336, 0.2, 0, 1, 1, 1),
(23330, 24897, 0.2, 0, 1, 1, 1),
(23330, 24907, 0.2, 0, 1, 1, 1),
(23330, 25406, 0.2, 0, 1, 1, 1),
(23330, 25374, 0.2, 0, 1, 1, 1),
(23330, 25375, 0.2, 0, 1, 1, 1),
(23330, 25376, 0.2, 0, 1, 1, 1),
(23330, 25389, 0.2, 0, 1, 1, 1),
(23330, 25392, 0.2, 0, 1, 1, 1),
(23330, 25341, 0.2, 0, 1, 1, 1),
(23330, 25345, 0.2, 0, 1, 1, 1),
(23330, 25397, 0.2, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=200000, maxhealth=200000, minmana=32310, maxmana=32310, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, pickpocketloot=22960, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22960;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22960);
INSERT INTO `creature_loot_template` VALUES
(22960, 21877, 47, 0, 1, 3, 1),
(22960, 25406, 1, 0, 1, 1, 1),
(22960, 31898, 0.5, 0, 1, 1, 1),
(22960, 25009, 0.5, 0, 1, 1, 1),
(22960, 24685, 0.5, 0, 1, 1, 1),
(22960, 24783, 0.5, 0, 1, 1, 1),
(22960, 25307, 0.5, 0, 1, 1, 1),
(22960, 24898, 0.5, 0, 1, 1, 1),
(22960, 24894, 0.5, 0, 1, 1, 1),
(22960, 24902, 0.5, 0, 1, 1, 1),
(22960, 25364, 0.5, 0, 1, 1, 1),
(22960, 25395, 0.5, 0, 1, 1, 1),
(22960, 25405, 0.5, 0, 1, 1, 1),
(22960, 25403, 0.5, 0, 1, 1, 1),
(22960, 32528, 0.2, 0, 1, 1, 1),
(22960, 32428, 0.2, 0, 1, 1, 1),
(22960, 29550, 0.2, 0, 1, 1, 1),
(22960, 25055, 0.2, 0, 1, 1, 1),
(22960, 25057, 0.2, 0, 1, 1, 1),
(22960, 25043, 0.2, 0, 1, 1, 1),
(22960, 24684, 0.2, 0, 1, 1, 1),
(22960, 25012, 0.2, 0, 1, 1, 1),
(22960, 25182, 0.2, 0, 1, 1, 1),
(22960, 25293, 0.2, 0, 1, 1, 1),
(22960, 25294, 0.2, 0, 1, 1, 1),
(22960, 24676, 0.2, 0, 1, 1, 1),
(22960, 24671, 0.2, 0, 1, 1, 1),
(22960, 24686, 0.2, 0, 1, 1, 1),
(22960, 24690, 0.2, 0, 1, 1, 1),
(22960, 24691, 0.2, 0, 1, 1, 1),
(22960, 24790, 0.2, 0, 1, 1, 1),
(22960, 25335, 0.2, 0, 1, 1, 1),
(22960, 25280, 0.2, 0, 1, 1, 1),
(22960, 25322, 0.2, 0, 1, 1, 1),
(22960, 24785, 0.2, 0, 1, 1, 1),
(22960, 25020, 0.2, 0, 1, 1, 1),
(22960, 24897, 0.2, 0, 1, 1, 1),
(22960, 24907, 0.2, 0, 1, 1, 1),
(22960, 25308, 0.2, 0, 1, 1, 1),
(22960, 25026, 0.2, 0, 1, 1, 1),
(22960, 25374, 0.2, 0, 1, 1, 1),
(22960, 25378, 0.2, 0, 1, 1, 1),
(22960, 25359, 0.2, 0, 1, 1, 1),
(22960, 25360, 0.2, 0, 1, 1, 1),
(22960, 25361, 0.2, 0, 1, 1, 1),
(22960, 25362, 0.2, 0, 1, 1, 1),
(22960, 25404, 0.2, 0, 1, 1, 1),
(22960, 25399, 0.2, 0, 1, 1, 1),
(22960, 25396, 0.2, 0, 1, 1, 1),
(22960, 25342, 0.2, 0, 1, 1, 1),
(22960, 25346, 0.2, 0, 1, 1, 1),
(22960, 25397, 0.2, 0, 1, 1, 1),
(22960, 25398, 0.2, 0, 1, 1, 1);

/* Pickpocket Loot */
DELETE FROM `pickpocketing_loot_template` WHERE (`entry`=22960);
INSERT INTO `pickpocketing_loot_template` VALUES
(22960, 29570, 5, 0, 1, 1, 1),
(22960, 22829, 10, 0, 1, 1, 1),
(22960, 29569, 10, 0, 1, 1, 1),
(22960, 27855, 5, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=260000, maxhealth=260000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, pickpocketloot=23172, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23172;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23172);
INSERT INTO `creature_loot_template` VALUES
(23172, 21877, 37, 0, 1, 3, 1),
(23172, 32428, 13, 0, 1, 1, 1),
(23172, 32897, 10, 0, 1, 1, 1),
(23172, 32231, 3, 0, 1, 1, 1),
(23172, 32228, 2, 0, 1, 1, 1),
(23172, 32227, 2, 0, 1, 1, 1),
(23172, 32229, 2, 0, 1, 1, 1),
(23172, 32249, 2, 0, 1, 1, 1),
(23172, 32528, 1.5, 0, 1, 1, 1),
(23172, 32608, 1.4, 0, 1, 1, 1),
(23172, 25360, 1.4, 0, 1, 1, 1),
(23172, 32752, 1.2, 0, 1, 1, 1),
(23172, 32230, 1.2, 0, 1, 1, 1),
(23172, 32526, 0.7, 0, 1, 1, 1),
(23172, 32747, 0.7, 0, 1, 1, 1),
(23172, 25401, 0.7, 0, 1, 1, 1),
(23172, 25363, 0.7, 0, 1, 1, 1),
(23172, 25364, 0.7, 0, 1, 1, 1),
(23172, 25344, 0.7, 0, 1, 1, 1),
(23172, 32609, 0.5, 0, 1, 1, 1),
(23172, 32527, 0.5, 0, 1, 1, 1),
(23172, 32593, 0.5, 0, 1, 1, 1),
(23172, 25126, 0.5, 0, 1, 1, 1),
(23172, 25154, 0.5, 0, 1, 1, 1),
(23172, 25196, 0.5, 0, 1, 1, 1),
(23172, 24669, 0.5, 0, 1, 1, 1),
(23172, 24791, 0.5, 0, 1, 1, 1),
(23172, 25197, 0.5, 0, 1, 1, 1),
(23172, 24902, 0.5, 0, 1, 1, 1),
(23172, 25024, 0.5, 0, 1, 1, 1),
(23172, 25404, 0.5, 0, 1, 1, 1),
(23172, 25399, 0.5, 0, 1, 1, 1),
(23172, 25405, 0.5, 0, 1, 1, 1),
(23172, 25403, 0.5, 0, 1, 1, 1),
(23172, 32592, 0.2, 0, 1, 1, 1),
(23172, 32589, 0.2, 0, 1, 1, 1),
(23172, 32754, 0.2, 0, 1, 1, 1),
(23172, 32750, 0.2, 0, 1, 1, 1),
(23172, 32745, 0.2, 0, 1, 1, 1),
(23172, 32943, 0.2, 0, 1, 1, 1),
(23172, 31884, 0.2, 0, 1, 1, 1),
(23172, 31912, 0.2, 0, 1, 1, 1),
(23172, 31898, 0.2, 0, 1, 1, 1),
(23172, 25057, 0.2, 0, 1, 1, 1),
(23172, 24678, 0.2, 0, 1, 1, 1),
(23172, 25011, 0.2, 0, 1, 1, 1),
(23172, 24804, 0.2, 0, 1, 1, 1),
(23172, 24800, 0.2, 0, 1, 1, 1),
(23172, 24676, 0.2, 0, 1, 1, 1),
(23172, 24674, 0.2, 0, 1, 1, 1),
(23172, 24685, 0.2, 0, 1, 1, 1),
(23172, 24692, 0.2, 0, 1, 1, 1),
(23172, 24687, 0.2, 0, 1, 1, 1),
(23172, 24789, 0.2, 0, 1, 1, 1),
(23172, 24787, 0.2, 0, 1, 1, 1),
(23172, 24788, 0.2, 0, 1, 1, 1),
(23172, 24913, 0.2, 0, 1, 1, 1),
(23172, 25336, 0.2, 0, 1, 1, 1),
(23172, 24897, 0.2, 0, 1, 1, 1),
(23172, 24907, 0.2, 0, 1, 1, 1),
(23172, 25406, 0.2, 0, 1, 1, 1),
(23172, 25374, 0.2, 0, 1, 1, 1);

/* Creature Pickpocket Loot */
DELETE FROM `pickpocketing_loot_template` WHERE (`entry`=23172);
INSERT INTO `pickpocketing_loot_template` VALUES
(23172, 22829, 14, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22869;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22869);
INSERT INTO `creature_loot_template` VALUES
(22869, 21877, 38, 0, 1, 3, 1),
(22869, 32428, 9, 0, 1, 1, 1),
(22869, 32897, 8, 0, 1, 1, 1),
(22869, 32231, 4, 0, 1, 1, 1),
(22869, 32228, 2, 0, 1, 1, 1),
(22869, 32227, 2, 0, 1, 1, 1),
(22869, 32229, 1.8, 0, 1, 1, 1),
(22869, 32249, 1.5, 0, 1, 1, 1),
(22869, 32528, 1.5, 0, 1, 1, 1),
(22869, 32608, 1.5, 0, 1, 1, 1),
(22869, 25360, 1.4, 0, 1, 1, 1),
(22869, 32752, 1.2, 0, 1, 1, 1),
(22869, 32230, 1.2, 0, 1, 1, 1),
(22869, 32526, 0.7, 0, 1, 1, 1),
(22869, 32747, 0.7, 0, 1, 1, 1),
(22869, 25401, 0.7, 0, 1, 1, 1),
(22869, 25363, 0.7, 0, 1, 1, 1),
(22869, 25364, 0.7, 0, 1, 1, 1),
(22869, 25344, 0.7, 0, 1, 1, 1),
(22869, 32609, 0.5, 0, 1, 1, 1),
(22869, 32527, 0.5, 0, 1, 1, 1),
(22869, 32593, 0.5, 0, 1, 1, 1),
(22869, 25126, 0.5, 0, 1, 1, 1),
(22869, 25154, 0.5, 0, 1, 1, 1),
(22869, 25196, 0.5, 0, 1, 1, 1),
(22869, 24669, 0.5, 0, 1, 1, 1),
(22869, 24791, 0.5, 0, 1, 1, 1),
(22869, 25197, 0.5, 0, 1, 1, 1),
(22869, 24902, 0.5, 0, 1, 1, 1),
(22869, 25024, 0.5, 0, 1, 1, 1),
(22869, 25404, 0.5, 0, 1, 1, 1),
(22869, 25399, 0.5, 0, 1, 1, 1),
(22869, 25405, 0.5, 0, 1, 1, 1),
(22869, 25403, 0.5, 0, 1, 1, 1),
(22869, 32592, 0.2, 0, 1, 1, 1),
(22869, 32589, 0.2, 0, 1, 1, 1),
(22869, 32754, 0.2, 0, 1, 1, 1),
(22869, 32750, 0.2, 0, 1, 1, 1),
(22869, 32745, 0.2, 0, 1, 1, 1),
(22869, 32943, 0.2, 0, 1, 1, 1),
(22869, 31884, 0.2, 0, 1, 1, 1),
(22869, 31912, 0.2, 0, 1, 1, 1),
(22869, 31898, 0.2, 0, 1, 1, 1),
(22869, 25057, 0.2, 0, 1, 1, 1),
(22869, 24678, 0.2, 0, 1, 1, 1),
(22869, 25011, 0.2, 0, 1, 1, 1),
(22869, 24804, 0.2, 0, 1, 1, 1),
(22869, 24800, 0.2, 0, 1, 1, 1),
(22869, 24676, 0.2, 0, 1, 1, 1),
(22869, 24674, 0.2, 0, 1, 1, 1),
(22869, 24685, 0.2, 0, 1, 1, 1),
(22869, 24692, 0.2, 0, 1, 1, 1),
(22869, 24687, 0.2, 0, 1, 1, 1),
(22869, 24789, 0.2, 0, 1, 1, 1),
(22869, 24787, 0.2, 0, 1, 1, 1),
(22869, 24788, 0.2, 0, 1, 1, 1),
(22869, 24913, 0.2, 0, 1, 1, 1),
(22869, 25336, 0.2, 0, 1, 1, 1),
(22869, 24897, 0.2, 0, 1, 1, 1),
(22869, 24907, 0.2, 0, 1, 1, 1),
(22869, 25406, 0.2, 0, 1, 1, 1),
(22869, 25374, 0.2, 0, 1, 1, 1),
(22869, 25375, 0.2, 0, 1, 1, 1),
(22869, 25376, 0.2, 0, 1, 1, 1),
(22869, 25389, 0.2, 0, 1, 1, 1),
(22869, 25392, 0.2, 0, 1, 1, 1),
(22869, 25341, 0.2, 0, 1, 1, 1),
(22869, 25345, 0.2, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, minhealth=290000, maxhealth=290000, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23337;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23337);
INSERT INTO `creature_loot_template` VALUES
(23337, 21877, 35, 0, 2, 3, 1),
(23337, 32428, 12, 0, 1, 1, 1),
(23337, 32897, 9, 0, 1, 1, 1),
(23337, 32249, 4, 0, 1, 1, 1),
(23337, 32229, 3, 0, 1, 1, 1),
(23337, 32231, 2, 0, 1, 1, 1),
(23337, 32230, 2, 0, 1, 1, 1),
(23337, 32589, 2, 0, 1, 1, 1),
(23337, 32228, 1.6, 0, 1, 1, 1),
(23337, 32227, 1.3, 0, 1, 1, 1),
(23337, 25401, 1.3, 0, 1, 1, 1),
(23337, 32591, 1.1, 0, 1, 1, 1),
(23337, 32750, 1.1, 0, 1, 1, 1),
(23337, 32593, 1.1, 0, 1, 1, 1),
(23337, 25155, 1.1, 0, 1, 1, 1),
(23337, 25402, 1.1, 0, 1, 1, 1),
(23337, 32528, 0.8, 0, 1, 1, 1),
(23337, 32590, 0.8, 0, 1, 1, 1),
(23337, 24790, 0.8, 0, 1, 1, 1),
(23337, 25309, 0.8, 0, 1, 1, 1),
(23337, 32747, 0.5, 0, 1, 1, 1),
(23337, 32608, 0.5, 0, 1, 1, 1),
(23337, 31308, 0.5, 0, 1, 1, 1),
(23337, 24684, 0.5, 0, 1, 1, 1),
(23337, 24679, 0.5, 0, 1, 1, 1),
(23337, 24908, 0.5, 0, 1, 1, 1),
(23337, 24390, 0.5, 0, 1, 1, 1),
(23337, 24395, 0.5, 0, 1, 1, 1),
(23337, 32526, 0.3, 0, 1, 1, 1),
(23337, 32606, 0.3, 0, 1, 1, 1),
(23337, 32748, 0.3, 0, 1, 1, 1),
(23337, 32754, 0.3, 0, 1, 1, 1),
(23337, 32745, 0.3, 0, 1, 1, 1),
(23337, 32746, 0.3, 0, 1, 1, 1),
(23337, 32737, 0.3, 0, 1, 1, 1),
(23337, 32527, 0.3, 0, 1, 1, 1),
(23337, 25056, 0.3, 0, 1, 1, 1),
(23337, 24682, 0.3, 0, 1, 1, 1),
(23337, 25140, 0.3, 0, 1, 1, 1),
(23337, 25322, 0.3, 0, 1, 1, 1),
(23337, 25020, 0.3, 0, 1, 1, 1),
(23337, 25025, 0.3, 0, 1, 1, 1),
(23337, 25375, 0.3, 0, 1, 1, 1),
(23337, 25360, 0.3, 0, 1, 1, 1),
(23337, 25364, 0.3, 0, 1, 1, 1),
(23337, 25399, 0.3, 0, 1, 1, 1),
(23337, 25346, 0.3, 0, 1, 1, 1),
(23337, 25397, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, minmana=32310, maxmana=32310, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22853;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22853);
INSERT INTO `creature_loot_template` VALUES
(22853, 21877, 35, 0, 2, 3, 1),
(22853, 32428, 12, 0, 1, 1, 1),
(22853, 32897, 9, 0, 1, 1, 1),
(22853, 32249, 4, 0, 1, 1, 1),
(22853, 32229, 3, 0, 1, 1, 1),
(22853, 32231, 2, 0, 1, 1, 1),
(22853, 32230, 2, 0, 1, 1, 1),
(22853, 32589, 2, 0, 1, 1, 1),
(22853, 32228, 1.6, 0, 1, 1, 1),
(22853, 32227, 1.3, 0, 1, 1, 1),
(22853, 25401, 1.3, 0, 1, 1, 1),
(22853, 32591, 1.1, 0, 1, 1, 1),
(22853, 32750, 1.1, 0, 1, 1, 1),
(22853, 32593, 1.1, 0, 1, 1, 1),
(22853, 25155, 1.1, 0, 1, 1, 1),
(22853, 25402, 1.1, 0, 1, 1, 1),
(22853, 32528, 0.8, 0, 1, 1, 1),
(22853, 32590, 0.8, 0, 1, 1, 1),
(22853, 24790, 0.8, 0, 1, 1, 1),
(22853, 25309, 0.8, 0, 1, 1, 1),
(22853, 32747, 0.5, 0, 1, 1, 1),
(22853, 32608, 0.5, 0, 1, 1, 1),
(22853, 31308, 0.5, 0, 1, 1, 1),
(22853, 24684, 0.5, 0, 1, 1, 1),
(22853, 24679, 0.5, 0, 1, 1, 1),
(22853, 24908, 0.5, 0, 1, 1, 1),
(22853, 24390, 0.5, 0, 1, 1, 1),
(22853, 24395, 0.5, 0, 1, 1, 1),
(22853, 32526, 0.3, 0, 1, 1, 1),
(22853, 32606, 0.3, 0, 1, 1, 1),
(22853, 32748, 0.3, 0, 1, 1, 1),
(22853, 32754, 0.3, 0, 1, 1, 1),
(22853, 32745, 0.3, 0, 1, 1, 1),
(22853, 32746, 0.3, 0, 1, 1, 1),
(22853, 32737, 0.3, 0, 1, 1, 1),
(22853, 32527, 0.3, 0, 1, 1, 1),
(22853, 25056, 0.3, 0, 1, 1, 1),
(22853, 24682, 0.3, 0, 1, 1, 1),
(22853, 25140, 0.3, 0, 1, 1, 1),
(22853, 25322, 0.3, 0, 1, 1, 1),
(22853, 25020, 0.3, 0, 1, 1, 1),
(22853, 25025, 0.3, 0, 1, 1, 1),
(22853, 25375, 0.3, 0, 1, 1, 1),
(22853, 25360, 0.3, 0, 1, 1, 1),
(22853, 25364, 0.3, 0, 1, 1, 1),
(22853, 25399, 0.3, 0, 1, 1, 1),
(22853, 25346, 0.3, 0, 1, 1, 1),
(22853, 25397, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=550000, maxhealth=550000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22954;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22954);
INSERT INTO `creature_loot_template` VALUES
(22954, 21877, 35, 0, 2, 3, 1),
(22954, 32428, 12, 0, 1, 1, 1),
(22954, 32897, 9, 0, 1, 1, 1),
(22954, 32249, 4, 0, 1, 1, 1),
(22954, 32229, 3, 0, 1, 1, 1),
(22954, 32231, 2, 0, 1, 1, 1),
(22954, 32230, 2, 0, 1, 1, 1),
(22954, 32589, 2, 0, 1, 1, 1),
(22954, 32228, 1.6, 0, 1, 1, 1),
(22954, 32227, 1.3, 0, 1, 1, 1),
(22954, 25401, 1.3, 0, 1, 1, 1),
(22954, 32591, 1.1, 0, 1, 1, 1),
(22954, 32750, 1.1, 0, 1, 1, 1),
(22954, 32593, 1.1, 0, 1, 1, 1),
(22954, 25155, 1.1, 0, 1, 1, 1),
(22954, 25402, 1.1, 0, 1, 1, 1),
(22954, 32528, 0.8, 0, 1, 1, 1),
(22954, 32590, 0.8, 0, 1, 1, 1),
(22954, 24790, 0.8, 0, 1, 1, 1),
(22954, 25309, 0.8, 0, 1, 1, 1),
(22954, 32747, 0.5, 0, 1, 1, 1),
(22954, 32608, 0.5, 0, 1, 1, 1),
(22954, 31308, 0.5, 0, 1, 1, 1),
(22954, 24684, 0.5, 0, 1, 1, 1),
(22954, 24679, 0.5, 0, 1, 1, 1),
(22954, 24908, 0.5, 0, 1, 1, 1),
(22954, 24390, 0.5, 0, 1, 1, 1),
(22954, 24395, 0.5, 0, 1, 1, 1),
(22954, 32526, 0.3, 0, 1, 1, 1),
(22954, 32606, 0.3, 0, 1, 1, 1),
(22954, 32748, 0.3, 0, 1, 1, 1),
(22954, 32754, 0.3, 0, 1, 1, 1),
(22954, 32745, 0.3, 0, 1, 1, 1),
(22954, 32746, 0.3, 0, 1, 1, 1),
(22954, 32737, 0.3, 0, 1, 1, 1),
(22954, 32527, 0.3, 0, 1, 1, 1),
(22954, 25056, 0.3, 0, 1, 1, 1),
(22954, 24682, 0.3, 0, 1, 1, 1),
(22954, 25140, 0.3, 0, 1, 1, 1),
(22954, 25322, 0.3, 0, 1, 1, 1),
(22954, 25020, 0.3, 0, 1, 1, 1),
(22954, 25025, 0.3, 0, 1, 1, 1),
(22954, 25375, 0.3, 0, 1, 1, 1),
(22954, 25360, 0.3, 0, 1, 1, 1),
(22954, 25364, 0.3, 0, 1, 1, 1),
(22954, 25399, 0.3, 0, 1, 1, 1),
(22954, 25346, 0.3, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=210000, maxhealth=210000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23339;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23339);
INSERT INTO `creature_loot_template` VALUES
(23339, 21877, 35, 0, 2, 3, 1),
(23339, 32428, 12, 0, 1, 1, 1),
(23339, 32897, 9, 0, 1, 1, 1),
(23339, 32249, 4, 0, 1, 1, 1),
(23339, 32229, 3, 0, 1, 1, 1),
(23339, 32231, 2, 0, 1, 1, 1),
(23339, 32230, 2, 0, 1, 1, 1),
(23339, 32589, 2, 0, 1, 1, 1),
(23339, 32228, 1.6, 0, 1, 1, 1),
(23339, 32227, 1.3, 0, 1, 1, 1),
(23339, 25401, 1.3, 0, 1, 1, 1),
(23339, 32591, 1.1, 0, 1, 1, 1),
(23339, 32750, 1.1, 0, 1, 1, 1),
(23339, 32593, 1.1, 0, 1, 1, 1),
(23339, 25155, 1.1, 0, 1, 1, 1),
(23339, 25402, 1.1, 0, 1, 1, 1),
(23339, 32528, 0.8, 0, 1, 1, 1),
(23339, 32590, 0.8, 0, 1, 1, 1),
(23339, 24790, 0.8, 0, 1, 1, 1),
(23339, 25309, 0.8, 0, 1, 1, 1),
(23339, 32747, 0.5, 0, 1, 1, 1),
(23339, 32608, 0.5, 0, 1, 1, 1),
(23339, 31308, 0.5, 0, 1, 1, 1),
(23339, 24684, 0.5, 0, 1, 1, 1),
(23339, 24679, 0.5, 0, 1, 1, 1),
(23339, 24908, 0.5, 0, 1, 1, 1),
(23339, 24390, 0.5, 0, 1, 1, 1),
(23339, 24395, 0.5, 0, 1, 1, 1),
(23339, 32526, 0.3, 0, 1, 1, 1),
(23339, 32606, 0.3, 0, 1, 1, 1),
(23339, 32748, 0.3, 0, 1, 1, 1),
(23339, 32754, 0.3, 0, 1, 1, 1),
(23339, 32745, 0.3, 0, 1, 1, 1),
(23339, 32746, 0.3, 0, 1, 1, 1),
(23339, 32737, 0.3, 0, 1, 1, 1),
(23339, 32527, 0.3, 0, 1, 1, 1),
(23339, 25056, 0.3, 0, 1, 1, 1),
(23339, 24682, 0.3, 0, 1, 1, 1),
(23339, 25140, 0.3, 0, 1, 1, 1),
(23339, 25322, 0.3, 0, 1, 1, 1),
(23339, 25020, 0.3, 0, 1, 1, 1),
(23339, 25025, 0.3, 0, 1, 1, 1),
(23339, 25375, 0.3, 0, 1, 1, 1),
(23339, 25360, 0.3, 0, 1, 1, 1),
(23339, 25364, 0.3, 0, 1, 1, 1),
(23339, 25399, 0.3, 0, 1, 1, 1),
(23339, 25346, 0.3, 0, 1, 1, 1),
(23339, 25406, 0.2, 0, 1, 1, 1),
(23339, 25374, 0.2, 0, 1, 1, 1),
(23339, 24907, 0.2, 0, 1, 1, 1),
(23339, 25376, 0.2, 0, 1, 1, 1),
(23339, 25389, 0.2, 0, 1, 1, 1),
(23339, 25392, 0.2, 0, 1, 1, 1),
(23339, 25341, 0.2, 0, 1, 1, 1),
(23339, 25345, 0.2, 0, 1, 1, 1),
(23339, 25397, 0.2, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22855;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22855);
INSERT INTO `creature_loot_template` VALUES
(22855, 21877, 37, 0, 2, 3, 1),
(22855, 32428, 19, 0, 1, 1, 1),
(22855, 32897, 10, 0, 1, 1, 1),
(22855, 32590, 6, 0, 1, 1, 1),
(22855, 32229, 5, 0, 1, 1, 1),
(22855, 32528, 3, 0, 1, 1, 1),
(22855, 32750, 3, 0, 1, 1, 1),
(22855, 25391, 3, 0, 1, 1, 1),
(22855, 32589, 1.9, 0, 1, 1, 1),
(22855, 32249, 1.9, 0, 1, 1, 1),
(22855, 32526, 0.9, 0, 1, 1, 1),
(22855, 32227, 0.9, 0, 1, 1, 1),
(22855, 32230, 0.9, 0, 1, 1, 1),
(22855, 24677, 0.9, 0, 1, 1, 1),
(22855, 24684, 0.9, 0, 1, 1, 1),
(22855, 24803, 0.9, 0, 1, 1, 1),
(22855, 24690, 0.9, 0, 1, 1, 1),
(22855, 25169, 0.9, 0, 1, 1, 1),
(22855, 25020, 0.9, 0, 1, 1, 1),
(22855, 25018, 0.9, 0, 1, 1, 1),
(22855, 25029, 0.9, 0, 1, 1, 1),
(22855, 25401, 0.9, 0, 1, 1, 1),
(22855, 25358, 0.9, 0, 1, 1, 1),
(22855, 25404, 0.9, 0, 1, 1, 1),
(22855, 25342, 0.9, 0, 1, 1, 1),
(22855, 25405, 0.9, 0, 1, 1, 1),
(22855, 25403, 0.9, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=550000, maxhealth=550000, armor=5700, baseattacktime=1400, rangeattacktime=1900, skinloot=22884, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22884;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22884);
INSERT INTO `creature_loot_template` VALUES
(22884, 17058, 26, 0, 1, 1, 1),
(22884, 17057, 19, 0, 1, 1, 1),
(22884, 32897, 9, 0, 1, 1, 1),
(22884, 32228, 4, 0, 1, 1, 1),
(22884, 32229, 3, 0, 1, 1, 1),
(22884, 32231, 3, 0, 1, 1, 1),
(22884, 27858, 2, 0, 1, 1, 1),
(22884, 32249, 1.8, 0, 1, 1, 1),
(22884, 24215, 1.3, 0, 1, 1, 1),
(22884, 27860, 1.3, 0, 1, 1, 1),
(22884, 32230, 1, 0, 1, 1, 1),
(22884, 24801, 1, 0, 1, 1, 1),
(22884, 25376, 1, 0, 1, 1, 1),
(22884, 25364, 1, 0, 1, 1, 1),
(22884, 32592, 0.8, 0, 1, 1, 1),
(22884, 32227, 0.8, 0, 1, 1, 1),
(22884, 32606, 0.8, 0, 1, 1, 1),
(22884, 32590, 0.8, 0, 1, 1, 1),
(22884, 32608, 0.8, 0, 1, 1, 1),
(22884, 24903, 0.8, 0, 1, 1, 1),
(22884, 25389, 0.8, 0, 1, 1, 1),
(22884, 25027, 0.5, 0, 1, 1, 1),
(22884, 25391, 0.5, 0, 1, 1, 1),
(22884, 25392, 0.5, 0, 1, 1, 1),
(22884, 25405, 0.5, 0, 1, 1, 1),
(22884, 32526, 0.3, 0, 1, 1, 1),
(22884, 32591, 0.3, 0, 1, 1, 1),
(22884, 32589, 0.3, 0, 1, 1, 1),
(22884, 31328, 0.3, 0, 1, 1, 1),
(22884, 32527, 0.3, 0, 1, 1, 1),
(22884, 32943, 0.3, 0, 1, 1, 1),
(22884, 25055, 0.3, 0, 1, 1, 1),
(22884, 25057, 0.3, 0, 1, 1, 1),
(22884, 24683, 0.3, 0, 1, 1, 1),
(22884, 24679, 0.3, 0, 1, 1, 1),
(22884, 25323, 0.3, 0, 1, 1, 1),
(22884, 23077, 0.3, 0, 1, 1, 1),
(22884, 25321, 0.3, 0, 1, 1, 1),
(22884, 25294, 0.3, 0, 1, 1, 1),
(22884, 24669, 0.3, 0, 1, 1, 1),
(22884, 24671, 0.3, 0, 1, 1, 1),
(22884, 25335, 0.3, 0, 1, 1, 1),
(22884, 24784, 0.3, 0, 1, 1, 1),
(22884, 24915, 0.3, 0, 1, 1, 1);

/* Skinning Loot */
DELETE FROM `skinning_loot_template` WHERE (`entry`=22884);
INSERT INTO `skinning_loot_template` VALUES
(22884, 21887, 56, 0, 1, 2, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=140000, maxhealth=140000, minmana=33090, maxmana=33090, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22945;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22945);
INSERT INTO `creature_loot_template` VALUES
(22945, 21877, 35, 0, 2, 3, 1),
(22945, 32428, 15, 0, 1, 1, 1),
(22945, 32897, 8, 0, 1, 1, 1),
(22945, 32249, 3, 0, 1, 1, 1),
(22945, 32228, 3, 0, 1, 1, 1),
(22945, 32232, 2, 0, 1, 1, 1),
(22945, 32229, 2, 0, 1, 1, 1),
(22945, 32230, 2, 0, 1, 1, 1),
(22945, 32227, 1.7, 0, 1, 1, 1),
(22945, 32592, 1.5, 0, 1, 1, 1),
(22945, 32608, 1.2, 0, 1, 1, 1),
(22945, 32528, 1, 0, 1, 1, 1),
(22945, 32593, 0.8, 0, 1, 1, 1),
(22945, 32526, 0.7, 0, 1, 1, 1),
(22945, 32589, 0.7, 0, 1, 1, 1),
(22945, 32527, 0.7, 0, 1, 1, 1),
(22945, 24686, 0.6, 0, 1, 1, 1),
(22945, 25405, 0.6, 0, 1, 1, 1),
(22945, 32590, 0.5, 0, 1, 1, 1),
(22945, 32943, 0.5, 0, 1, 1, 1),
(22945, 24687, 0.5, 0, 1, 1, 1),
(22945, 24914, 0.5, 0, 1, 1, 1),
(22945, 25024, 0.5, 0, 1, 1, 1),
(22945, 32591, 0.3, 0, 1, 1, 1),
(22945, 24805, 0.3, 0, 1, 1, 1),
(22945, 25016, 0.3, 0, 1, 1, 1),
(22945, 25406, 0.3, 0, 1, 1, 1),
(22945, 25376, 0.3, 0, 1, 1, 1),
(22945, 25364, 0.3, 0, 1, 1, 1),
(22945, 25400, 0.3, 0, 1, 1, 1),
(22945, 25402, 0.3, 0, 1, 1, 1),
(22945, 32750, 0.2, 0, 1, 1, 1),
(22945, 24683, 0.2, 0, 1, 1, 1),
(22945, 24679, 0.2, 0, 1, 1, 1),
(22945, 25099, 0.2, 0, 1, 1, 1),
(22945, 24790, 0.2, 0, 1, 1, 1),
(22945, 25295, 0.2, 0, 1, 1, 1),
(22945, 25337, 0.2, 0, 1, 1, 1),
(22945, 24902, 0.2, 0, 1, 1, 1),
(22945, 25401, 0.2, 0, 1, 1, 1),
(22945, 25377, 0.2, 0, 1, 1, 1),
(22945, 25399, 0.2, 0, 1, 1, 1),
(22945, 25389, 0.2, 0, 1, 1, 1),
(22945, 25341, 0.2, 0, 1, 1, 1),
(22945, 25343, 0.2, 0, 1, 1, 1),
(22945, 25344, 0.2, 0, 1, 1, 1),
(22945, 32606, 0.1, 0, 1, 1, 1),
(22945, 32744, 0.1, 0, 1, 1, 1),
(22945, 32751, 0.1, 0, 1, 1, 1),
(22945, 32755, 0.1, 0, 1, 1, 1),
(22945, 32745, 0.1, 0, 1, 1, 1),
(22945, 32753, 0.1, 0, 1, 1, 1),
(22945, 32752, 0.1, 0, 1, 1, 1),
(22945, 32746, 0.1, 0, 1, 1, 1),
(22945, 32747, 0.1, 0, 1, 1, 1),
(22945, 31837, 0.1, 0, 1, 1, 1),
(22945, 31304, 0.1, 0, 1, 1, 1),
(22945, 25056, 0.1, 0, 1, 1, 1),
(22945, 25057, 0.1, 0, 1, 1, 1),
(22945, 24684, 0.1, 0, 1, 1, 1),
(22945, 24681, 0.1, 0, 1, 1, 1),
(22945, 25196, 0.1, 0, 1, 1, 1),
(22945, 24803, 0.1, 0, 1, 1, 1),
(22945, 24688, 0.1, 0, 1, 1, 1),
(22945, 24791, 0.1, 0, 1, 1, 1),
(22945, 24917, 0.1, 0, 1, 1, 1),
(22945, 25168, 0.1, 0, 1, 1, 1),
(22945, 25020, 0.1, 0, 1, 1, 1),
(22945, 25017, 0.1, 0, 1, 1, 1),
(22945, 25336, 0.1, 0, 1, 1, 1),
(22945, 24909, 0.1, 0, 1, 1, 1),
(22945, 24908, 0.1, 0, 1, 1, 1),
(22945, 25308, 0.1, 0, 1, 1, 1),
(22945, 25026, 0.1, 0, 1, 1, 1),
(22945, 25029, 0.1, 0, 1, 1, 1),
(22945, 25309, 0.1, 0, 1, 1, 1),
(22945, 25379, 0.1, 0, 1, 1, 1),
(22945, 25361, 0.1, 0, 1, 1, 1),
(22945, 25362, 0.1, 0, 1, 1, 1),
(22945, 25404, 0.1, 0, 1, 1, 1),
(22945, 25391, 0.1, 0, 1, 1, 1),
(22945, 25392, 0.1, 0, 1, 1, 1),
(22945, 25395, 0.1, 0, 1, 1, 1),
(22945, 25396, 0.1, 0, 1, 1, 1),
(22945, 25342, 0.1, 0, 1, 1, 1),
(22945, 25345, 0.1, 0, 1, 1, 1),
(22945, 25348, 0.1, 0, 1, 1, 1),
(22945, 25397, 0.1, 0, 1, 1, 1),
(22945, 25403, 0.1, 0, 1, 1, 1),
(22945, 25398, 0.1, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=330000, maxhealth=330000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22880;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22880);
INSERT INTO `creature_loot_template` VALUES
(22880, 21877, 34, 0, 2, 3, 1),
(22880, 32428, 15, 0, 1, 1, 1),
(22880, 32897, 11, 0, 1, 1, 1),
(22880, 32249, 3, 0, 1, 1, 1),
(22880, 32228, 3, 0, 1, 1, 1),
(22880, 32232, 2, 0, 1, 1, 1),
(22880, 32229, 1.8, 0, 1, 1, 1),
(22880, 32230, 1.8, 0, 1, 1, 1),
(22880, 32227, 1.8, 0, 1, 1, 1),
(22880, 32592, 1.5, 0, 1, 1, 1),
(22880, 32608, 1.2, 0, 1, 1, 1),
(22880, 32528, 1, 0, 1, 1, 1),
(22880, 32593, 0.8, 0, 1, 1, 1),
(22880, 32526, 0.7, 0, 1, 1, 1),
(22880, 32589, 0.7, 0, 1, 1, 1),
(22880, 32527, 0.7, 0, 1, 1, 1),
(22880, 24686, 0.6, 0, 1, 1, 1),
(22880, 25405, 0.6, 0, 1, 1, 1),
(22880, 32590, 0.5, 0, 1, 1, 1),
(22880, 32943, 0.5, 0, 1, 1, 1),
(22880, 24687, 0.5, 0, 1, 1, 1),
(22880, 24914, 0.5, 0, 1, 1, 1),
(22880, 25024, 0.5, 0, 1, 1, 1),
(22880, 32591, 0.3, 0, 1, 1, 1),
(22880, 24805, 0.3, 0, 1, 1, 1),
(22880, 25016, 0.3, 0, 1, 1, 1),
(22880, 25406, 0.3, 0, 1, 1, 1),
(22880, 25376, 0.3, 0, 1, 1, 1),
(22880, 25364, 0.3, 0, 1, 1, 1),
(22880, 25400, 0.3, 0, 1, 1, 1),
(22880, 25402, 0.3, 0, 1, 1, 1),
(22880, 32750, 0.2, 0, 1, 1, 1),
(22880, 24683, 0.2, 0, 1, 1, 1),
(22880, 24679, 0.2, 0, 1, 1, 1),
(22880, 25099, 0.2, 0, 1, 1, 1),
(22880, 24790, 0.2, 0, 1, 1, 1),
(22880, 25295, 0.2, 0, 1, 1, 1),
(22880, 25337, 0.2, 0, 1, 1, 1),
(22880, 24902, 0.2, 0, 1, 1, 1),
(22880, 25401, 0.2, 0, 1, 1, 1),
(22880, 25377, 0.2, 0, 1, 1, 1),
(22880, 25399, 0.2, 0, 1, 1, 1),
(22880, 25389, 0.2, 0, 1, 1, 1),
(22880, 25341, 0.2, 0, 1, 1, 1),
(22880, 25343, 0.2, 0, 1, 1, 1),
(22880, 25344, 0.2, 0, 1, 1, 1),
(22880, 32606, 0.1, 0, 1, 1, 1),
(22880, 32744, 0.1, 0, 1, 1, 1),
(22880, 32751, 0.1, 0, 1, 1, 1),
(22880, 32755, 0.1, 0, 1, 1, 1),
(22880, 32745, 0.1, 0, 1, 1, 1),
(22880, 32753, 0.1, 0, 1, 1, 1),
(22880, 32752, 0.1, 0, 1, 1, 1),
(22880, 32746, 0.1, 0, 1, 1, 1),
(22880, 32747, 0.1, 0, 1, 1, 1),
(22880, 31837, 0.1, 0, 1, 1, 1),
(22880, 31304, 0.1, 0, 1, 1, 1),
(22880, 25056, 0.1, 0, 1, 1, 1),
(22880, 25057, 0.1, 0, 1, 1, 1),
(22880, 24684, 0.1, 0, 1, 1, 1),
(22880, 24681, 0.1, 0, 1, 1, 1),
(22880, 25196, 0.1, 0, 1, 1, 1),
(22880, 24803, 0.1, 0, 1, 1, 1),
(22880, 24688, 0.1, 0, 1, 1, 1),
(22880, 24791, 0.1, 0, 1, 1, 1),
(22880, 24917, 0.1, 0, 1, 1, 1),
(22880, 25168, 0.1, 0, 1, 1, 1),
(22880, 25020, 0.1, 0, 1, 1, 1),
(22880, 25017, 0.1, 0, 1, 1, 1),
(22880, 25336, 0.1, 0, 1, 1, 1),
(22880, 24909, 0.1, 0, 1, 1, 1),
(22880, 24908, 0.1, 0, 1, 1, 1),
(22880, 25308, 0.1, 0, 1, 1, 1),
(22880, 25026, 0.1, 0, 1, 1, 1),
(22880, 25029, 0.1, 0, 1, 1, 1),
(22880, 25309, 0.1, 0, 1, 1, 1),
(22880, 25379, 0.1, 0, 1, 1, 1),
(22880, 25361, 0.1, 0, 1, 1, 1),
(22880, 25362, 0.1, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=180000, maxhealth=180000, minmana=33090, maxmana=33090, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22882;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22882);
INSERT INTO `creature_loot_template` VALUES
(22882, 21877, 36, 0, 2, 3, 1),
(22882, 32428, 11, 0, 1, 1, 1),
(22882, 32897, 9, 0, 1, 1, 1),
(22882, 32249, 3, 0, 1, 1, 1),
(22882, 32228, 2, 0, 1, 1, 1),
(22882, 32232, 2, 0, 1, 1, 1),
(22882, 32229, 2, 0, 1, 1, 1),
(22882, 32230, 1.9, 0, 1, 1, 1),
(22882, 32227, 1.9, 0, 1, 1, 1),
(22882, 32592, 1, 0, 1, 1, 1),
(22882, 32608, 0.9, 0, 1, 1, 1),
(22882, 32528, 0.9, 0, 1, 1, 1),
(22882, 32593, 0.8, 0, 1, 1, 1),
(22882, 32526, 0.7, 0, 1, 1, 1),
(22882, 32589, 0.7, 0, 1, 1, 1),
(22882, 32527, 0.7, 0, 1, 1, 1),
(22882, 24686, 0.6, 0, 1, 1, 1),
(22882, 25405, 0.6, 0, 1, 1, 1),
(22882, 32590, 0.5, 0, 1, 1, 1),
(22882, 32943, 0.5, 0, 1, 1, 1),
(22882, 24687, 0.5, 0, 1, 1, 1),
(22882, 24914, 0.5, 0, 1, 1, 1),
(22882, 25024, 0.5, 0, 1, 1, 1),
(22882, 32591, 0.3, 0, 1, 1, 1),
(22882, 24805, 0.3, 0, 1, 1, 1),
(22882, 25016, 0.3, 0, 1, 1, 1),
(22882, 25406, 0.3, 0, 1, 1, 1),
(22882, 25376, 0.3, 0, 1, 1, 1),
(22882, 25364, 0.3, 0, 1, 1, 1),
(22882, 25400, 0.3, 0, 1, 1, 1),
(22882, 25402, 0.3, 0, 1, 1, 1),
(22882, 32750, 0.2, 0, 1, 1, 1),
(22882, 24683, 0.2, 0, 1, 1, 1),
(22882, 24679, 0.2, 0, 1, 1, 1),
(22882, 25099, 0.2, 0, 1, 1, 1),
(22882, 24790, 0.2, 0, 1, 1, 1),
(22882, 25295, 0.2, 0, 1, 1, 1),
(22882, 25337, 0.2, 0, 1, 1, 1),
(22882, 24902, 0.2, 0, 1, 1, 1),
(22882, 25401, 0.2, 0, 1, 1, 1),
(22882, 25377, 0.2, 0, 1, 1, 1),
(22882, 25399, 0.2, 0, 1, 1, 1),
(22882, 25389, 0.2, 0, 1, 1, 1),
(22882, 25341, 0.2, 0, 1, 1, 1),
(22882, 25343, 0.2, 0, 1, 1, 1),
(22882, 25344, 0.2, 0, 1, 1, 1),
(22882, 32606, 0.1, 0, 1, 1, 1),
(22882, 32744, 0.1, 0, 1, 1, 1),
(22882, 32751, 0.1, 0, 1, 1, 1),
(22882, 32755, 0.1, 0, 1, 1, 1),
(22882, 32745, 0.1, 0, 1, 1, 1),
(22882, 32753, 0.1, 0, 1, 1, 1),
(22882, 32752, 0.1, 0, 1, 1, 1),
(22882, 32746, 0.1, 0, 1, 1, 1),
(22882, 32747, 0.1, 0, 1, 1, 1),
(22882, 31837, 0.1, 0, 1, 1, 1),
(22882, 31304, 0.1, 0, 1, 1, 1),
(22882, 25056, 0.1, 0, 1, 1, 1),
(22882, 25057, 0.1, 0, 1, 1, 1),
(22882, 24684, 0.1, 0, 1, 1, 1),
(22882, 24681, 0.1, 0, 1, 1, 1),
(22882, 25196, 0.1, 0, 1, 1, 1),
(22882, 24803, 0.1, 0, 1, 1, 1),
(22882, 24688, 0.1, 0, 1, 1, 1),
(22882, 24791, 0.1, 0, 1, 1, 1),
(22882, 24917, 0.1, 0, 1, 1, 1),
(22882, 25168, 0.1, 0, 1, 1, 1),
(22882, 25020, 0.1, 0, 1, 1, 1),
(22882, 25017, 0.1, 0, 1, 1, 1),
(22882, 25336, 0.1, 0, 1, 1, 1),
(22882, 24909, 0.1, 0, 1, 1, 1),
(22882, 24908, 0.1, 0, 1, 1, 1),
(22882, 25308, 0.1, 0, 1, 1, 1),
(22882, 25026, 0.1, 0, 1, 1, 1),
(22882, 25029, 0.1, 0, 1, 1, 1),
(22882, 25309, 0.1, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=32000, maxhealth=32000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, pickpocketloot=23147, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23147;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23147);
INSERT INTO `creature_loot_template` VALUES
(23147, 32746, 0.3, 0, 1, 1, 1),
(23147, 32593, 0.2, 0, 1, 1, 1),
(23147, 25403, 0.2, 0, 1, 1, 1),
(23147, 32754, 0.2, 0, 1, 1, 1),
(23147, 32750, 0.2, 0, 1, 1, 1),
(23147, 25043, 0.2, 0, 1, 1, 1),
(23147, 25323, 0.2, 0, 1, 1, 1),
(23147, 24801, 0.2, 0, 1, 1, 1),
(23147, 24689, 0.2, 0, 1, 1, 1),
(23147, 25020, 0.2, 0, 1, 1, 1),
(23147, 25028, 0.2, 0, 1, 1, 1),
(23147, 25378, 0.2, 0, 1, 1, 1),
(23147, 25398, 0.2, 0, 1, 1, 1),
(23147, 32747, 0.1, 0, 1, 1, 1),
(23147, 32739, 0.1, 0, 1, 1, 1),
(23147, 32737, 0.1, 0, 1, 1, 1),
(23147, 31308, 0.1, 0, 1, 1, 1),
(23147, 29550, 0.1, 0, 1, 1, 1),
(23147, 24681, 0.1, 0, 1, 1, 1),
(23147, 23077, 0.1, 0, 1, 1, 1),
(23147, 25297, 0.1, 0, 1, 1, 1),
(23147, 24795, 0.1, 0, 1, 1, 1),
(23147, 23112, 0.1, 0, 1, 1, 1),
(23147, 24910, 0.1, 0, 1, 1, 1),
(23147, 24911, 0.1, 0, 1, 1, 1),
(23147, 24915, 0.1, 0, 1, 1, 1),
(23147, 25337, 0.1, 0, 1, 1, 1),
(23147, 24907, 0.1, 0, 1, 1, 1),
(23147, 25183, 0.1, 0, 1, 1, 1),
(23147, 25026, 0.1, 0, 1, 1, 1),
(23147, 25023, 0.1, 0, 1, 1, 1),
(23147, 25360, 0.1, 0, 1, 1, 1),
(23147, 25363, 0.1, 0, 1, 1, 1),
(23147, 25391, 0.1, 0, 1, 1, 1),
(23147, 25393, 0.1, 0, 1, 1, 1),
(23147, 25341, 0.1, 0, 1, 1, 1),
(23147, 25400, 0.1, 0, 1, 1, 1),
(23147, 25056, 0.1, 0, 1, 1, 1),
(23147, 25057, 0.2, 0, 1, 1, 1),
(23147, 24677, 0.1, 0, 1, 1, 1),
(23147, 24680, 0.2, 0, 1, 1, 1),
(23147, 24683, 0.1, 0, 1, 1, 1),
(23147, 24682, 0.2, 0, 1, 1, 1),
(23147, 24679, 0.1, 0, 1, 1, 1),
(23147, 32526, 0.2, 0, 1, 1, 1),
(23147, 32528, 0.2, 0, 1, 1, 1),
(23147, 25196, 0.2, 0, 1, 1, 1),
(23147, 32609, 0.2, 0, 1, 1, 1),
(23147, 25406, 0.7, 0, 1, 1, 1),
(23147, 32592, 0.6, 0, 1, 1, 1),
(23147, 32591, 0.5, 0, 1, 1, 1),
(23147, 25070, 0.2, 0, 1, 1, 1),
(23147, 25401, 0.4, 0, 1, 1, 1),
(23147, 25373, 0.1, 0, 1, 1, 1),
(23147, 25374, 0.4, 0, 1, 1, 1),
(23147, 25379, 0.3, 0, 1, 1, 1),
(23147, 25380, 0.3, 0, 1, 1, 1),
(23147, 32227, 1.6, 0, 1, 1, 1),
(23147, 25357, 0.2, 0, 1, 1, 1),
(23147, 25358, 0.2, 0, 1, 1, 1),
(23147, 25359, 0.1, 0, 1, 1, 1),
(23147, 25361, 0.2, 0, 1, 1, 1),
(23147, 25362, 0.2, 0, 1, 1, 1),
(23147, 25404, 0.2, 0, 1, 1, 1),
(23147, 25399, 0.3, 0, 1, 1, 1),
(23147, 25392, 0.2, 0, 1, 1, 1),
(23147, 25395, 0.2, 0, 1, 1, 1),
(23147, 25343, 0.1, 0, 1, 1, 1),
(23147, 25345, 0.3, 0, 1, 1, 1),
(23147, 25346, 0.1, 0, 1, 1, 1),
(23147, 25347, 0.2, 0, 1, 1, 1),
(23147, 25348, 0.3, 0, 1, 1, 1),
(23147, 24805, 0.1, 0, 1, 1, 1),
(23147, 24799, 0.2, 0, 1, 1, 1),
(23147, 24685, 0.1, 0, 1, 1, 1),
(23147, 24692, 0.1, 0, 1, 1, 1),
(23147, 24688, 0.1, 0, 1, 1, 1),
(23147, 24690, 0.2, 0, 1, 1, 1),
(23147, 24691, 0.2, 0, 1, 1, 1),
(23147, 24687, 0.2, 0, 1, 1, 1),
(23147, 32228, 1.5, 0, 1, 1, 1),
(23147, 25397, 0.2, 0, 1, 1, 1),
(23147, 24797, 0.1, 0, 1, 1, 1),
(23147, 24793, 0.2, 0, 1, 1, 1),
(23147, 24794, 0.1, 0, 1, 1, 1),
(23147, 25295, 0.2, 0, 1, 1, 1),
(23147, 32606, 1.1, 0, 1, 1, 1),
(23147, 32428, 14, 0, 1, 1, 1),
(23147, 32589, 0.2, 0, 1, 1, 1),
(23147, 25155, 0.1, 0, 1, 1, 1),
(23147, 25127, 0.2, 0, 1, 1, 1),
(23147, 25239, 0.2, 0, 1, 1, 1),
(23147, 31306, 0.1, 0, 1, 1, 1),
(23147, 32229, 3, 0, 1, 1, 1),
(23147, 32897, 9, 0, 1, 1, 1),
(23147, 24912, 0.1, 0, 1, 1, 1),
(23147, 24913, 0.2, 0, 1, 1, 1),
(23147, 24914, 0.1, 0, 1, 1, 1),
(23147, 32590, 0.2, 0, 1, 1, 1),
(23147, 21877, 38, 0, 2, 3, 1),
(23147, 32748, 0.1, 0, 1, 1, 1),
(23147, 32744, 0.2, 0, 1, 1, 1),
(23147, 32751, 0.1, 0, 1, 1, 1),
(23147, 32755, 0.1, 0, 1, 1, 1),
(23147, 32752, 0.1, 0, 1, 1, 1),
(23147, 32608, 0.2, 0, 1, 1, 1),
(23147, 32738, 0.1, 0, 1, 1, 1),
(23147, 32736, 0.2, 0, 1, 1, 1),
(23147, 32231, 1.9, 0, 1, 1, 1),
(23147, 32527, 0.7, 0, 1, 1, 1),
(23147, 32249, 3, 0, 1, 1, 1),
(23147, 32230, 1.6, 0, 1, 1, 1),
(23147, 25014, 0.2, 0, 1, 1, 1),
(23147, 25016, 0.2, 0, 1, 1, 1),
(23147, 25018, 0.2, 0, 1, 1, 1),
(23147, 25015, 0.2, 0, 1, 1, 1),
(23147, 31906, 0.1, 0, 1, 1, 1),
(23147, 31916, 0.1, 0, 1, 1, 1),
(23147, 32943, 0.3, 0, 1, 1, 1),
(23147, 24906, 0.1, 0, 1, 1, 1),
(23147, 24903, 0.2, 0, 1, 1, 1),
(23147, 24909, 0.2, 0, 1, 1, 1),
(23147, 24908, 0.2, 0, 1, 1, 1),
(23147, 24902, 0.2, 0, 1, 1, 1),
(23147, 25402, 0.5, 0, 1, 1, 1),
(23147, 31303, 0.2, 0, 1, 1, 1),
(23147, 25084, 0.1, 0, 1, 1, 1);

/* Creature Pickpocket Loot */
DELETE FROM `pickpocketing_loot_template` WHERE (`entry`=23147);
INSERT INTO `pickpocketing_loot_template` VALUES
(23147, 22829, 14, 0, 1, 1, 1),
(23147, 29569, 14, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=14000, maxhealth=14000, minmana=3155, maxmana=3155, armor=5700, baseattacktime=1400, faction_A=1820, faction_H=1820, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=23411;

/* Creature Template */
UPDATE `creature_template` SET minhealth=100000, maxhealth=100000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22848;

/* Remove creature from Black Temple, since this is a Beta character and never made it to final */

DELETE FROM `creature` WHERE `id`=23151;

/* Creature Template */
UPDATE `creature_template` SET minhealth=360000, maxhealth=360000, armor=5700, baseattacktime=1400, rangeattacktime=1900, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22953;

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22953);
INSERT INTO `creature_loot_template` VALUES
(22953, 21877, 32, 0, 2, 3, 1),
(22953, 32897, 14, 0, 1, 1, 1),
(22953, 32428, 10, 0, 1, 1, 1),
(22953, 32228, 3, 0, 1, 1, 1),
(22953, 32249, 3, 0, 1, 1, 1),
(22953, 32229, 2, 0, 1, 1, 1),
(22953, 32231, 2, 0, 1, 1, 1),
(22953, 32589, 1.1, 0, 1, 1, 1),
(22953, 32608, 1.1, 0, 1, 1, 1),
(22953, 32230, 1.1, 0, 1, 1, 1),
(22953, 25390, 1.1, 0, 1, 1, 1),
(22953, 25391, 1.1, 0, 1, 1, 1),
(22953, 25400, 1.1, 0, 1, 1, 1),
(22953, 32750, 0.5, 0, 1, 1, 1),
(22953, 32752, 0.5, 0, 1, 1, 1),
(22953, 32527, 0.5, 0, 1, 1, 1),
(22953, 32943, 0.5, 0, 1, 1, 1),
(22953, 24684, 0.5, 0, 1, 1, 1),
(22953, 25154, 0.5, 0, 1, 1, 1),
(22953, 25012, 0.5, 0, 1, 1, 1),
(22953, 24669, 0.5, 0, 1, 1, 1),
(22953, 24686, 0.5, 0, 1, 1, 1),
(22953, 25169, 0.5, 0, 1, 1, 1),
(22953, 25295, 0.5, 0, 1, 1, 1),
(22953, 24785, 0.5, 0, 1, 1, 1),
(22953, 25307, 0.5, 0, 1, 1, 1),
(22953, 23107, 0.5, 0, 1, 1, 1),
(22953, 24905, 0.5, 0, 1, 1, 1),
(22953, 25025, 0.5, 0, 1, 1, 1),
(22953, 25401, 0.5, 0, 1, 1, 1),
(22953, 25375, 0.5, 0, 1, 1, 1),
(22953, 25361, 0.5, 0, 1, 1, 1),
(22953, 25394, 0.5, 0, 1, 1, 1),
(22953, 25341, 0.5, 0, 1, 1, 1),
(22953, 25347, 0.5, 0, 1, 1, 1);

/* Creature Template */
UPDATE `creature_template` SET minhealth=25000, maxhealth=25000, minmana=31550, maxmana=31550, armor=5700, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22955;

/* Creature Location */
DELETE FROM `creature` WHERE `id`=22955;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(22955,564,0,0,'790.804','412.83','192.802','3.72221',3600,0,0,'790.804','412.83','192.802','3.72221',100000,100,0,0,''),
(22955,564,0,0,'799.104','403.445','192.802','3.87144',3600,0,0,'799.104','403.445','192.802','3.87144',100000,100,0,0,''),
(22955,564,0,0,'795.086','557.585','166.064','0.775515',3600,0,0,'795.086','557.585','166.064','0.775515',100000,100,0,0,''),
(22955,564,0,0,'886.479','339.653','111.826','1.23623',3600,0,0,'886.479','339.653','111.826',0,25000,31550,0,1,''),
(22955,564,0,0,'922.927','333.661','112.768','5.94076',3600,0,0,'922.927','333.661','112.768',0,25000,31550,0,1,''),
(22955,564,0,0,'910.944','332.645','112.768','4.37782',3600,0,0,'910.944','332.645','112.768',0,25000,31550,0,1,''),
(22955,564,0,0,'953.319','343.898','111.826','3.18795',3600,0,0,'953.319','343.898','111.826',0,25000,31550,0,1,''),
(22955,564,0,0,'960.716','381.151','112.768','0.0816952',3600,0,0,'960.716','381.151','112.768',0,25000,31550,0,1,''),
(22955,564,0,0,'959.266','403.293','112.768','3.22722',3600,0,0,'959.266','403.293','112.768',0,25000,31550,0,1,''),
(22955,564,0,196683,'950.038','433.191','111.825','3.08584',3600,0,0,'950.038','433.191','111.825',0,25000,31550,0,1,''),
(22955,564,0,196686,'941.84','442.198','111.825','4.92368',3600,0,0,'941.84','442.198','111.825',0,25000,31550,0,1,''),
(22955,564,0,196686,'879.931','441.274','111.826','0.0266995',3600,0,0,'879.931','441.274','111.826',0,25000,31550,0,1,''),
(22955,564,0,196686,'909.682','395.892','118.241','3.27431',3600,0,0,'909.682','395.892','118.241',0,25000,31550,0,1,''),
(22955,564,0,196686,'930.44','527.75','139.305','0.0777225',3600,0,0,'930.44','527.75','139.305',0,25000,31550,0,1,''),
(22955,564,0,196686,'929.998','555.199','139.304','3.78873',3600,0,0,'929.998','555.199','139.304',0,25000,31550,0,1,''),
(22955,564,0,196686,'900.132','556.269','139.304','2.80305',3600,0,0,'900.132','556.269','139.304',0,25000,31550,0,1,''),
(22955,564,0,196686,'919.553','537.001','139.304','2.26898',3600,0,0,'919.553','537.001','139.304',0,25000,31550,0,1,''),
(22955,564,0,196686,'910.276','537.36','139.304','0.874898',3600,0,0,'910.276','537.36','139.304',0,25000,31550,0,1,''),
(22955,564,0,196686,'835.505','560.853','165.76','5.48519',3600,0,0,'835.505','560.853','165.76',0,25000,31550,0,1,''),
(22955,564,0,160,'839.761','524.988','165.777','3.47458',3600,0,0,'839.761','524.988','165.777',0,25000,31550,0,1,''),
(22955,564,0,51,'796.014','524.255','166.002','1.48359',3600,0,0,'796.014','524.255','166.002',0,25000,31550,0,1,''),
(22955,564,0,8,'805.821','434.259','192.802','5.84649',3600,0,0,'805.821','434.259','192.802',0,25000,31550,0,1,''),
(22955,564,0,137,'814.377','418.915','192.802','1.66817',3600,0,0,'814.377','418.915','192.802',0,25000,31550,0,1,''),
(22955,564,0,112,'820.813','435.897','192.802','4.31104',3600,0,0,'820.813','435.897','192.802',0,25000,31550,0,1,''),
(22955,564,0,144,'831.997','412.851','192.802','0.792457',3600,0,0,'831.997','412.851','192.802',0,25000,31550,0,1,''),
(22955,564,0,15,'850.297','414.148','192.802','2.49285',3600,0,0,'850.297','414.148','192.802',0,25000,31550,0,1,'');


/* Creature Template */
UPDATE `creature_template` SET minhealth=30000, maxhealth=30000, armor=5700, baseattacktime=350, rangeattacktime=200, minrangedmg=2500, maxrangedmg=2700, rangedattackpower=200, mingold=10000, maxgold=11000, MovementType=1, InhabitType=1 WHERE entry=22939;

/* Creature Location */
DELETE FROM `creature` WHERE `id`=22939;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(22939,564,0,0,'800.953','401.379','192.802','3.87144',3600,0,0,'800.953','401.379','192.802','3.87144',100000,100,0,0,''),
(22939,564,0,0,'796.657','559.673','166.013','4.12131',3600,0,0,'796.657','559.673','166.013','4.12131',100000,100,0,0,''),
(22939,564,0,0,'883.769','342.839','111.826','0.603987',3600,0,0,'883.769','342.839','111.826',0,30000,100,0,1,''),
(2939,564,0,0,'907.141','341.821','112.768','2.26903',3600,0,0,'907.141','341.821','112.768',0,30000,100,0,1,''),
(22939,564,0,0,'945.505','339.107','111.826','1.24802',3600,0,0,'945.505','339.107','111.826',0,30000,100,0,1,''),
(22939,564,0,0,'962.877','392.395','112.768','3.11726',3600,0,0,'962.877','392.395','112.768',0,30000,100,0,1,''),
(22939,564,0,196674,'953.237','445.646','113.866','4.00083',3600,0,0,'953.237','445.646','113.866',0,30000,100,0,1,''),
(22939,564,0,196686,'886.201','447.155','111.826','4.82155',3600,0,0,'886.201','447.155','111.826',0,30000,100,0,1,''),
(22939,564,0,196686,'909.63','388.507','118.241','3.13294',3600,0,0,'909.63','388.507','118.241',0,30000,100,0,1,''),
(22939,564,0,196686,'872.049','379.073','112.768','0.996646',3600,0,0,'872.049','379.073','112.768',0,30000,100,0,1,''),
(22939,564,0,196686,'933.261','538.569','139.305','3.77695',3600,0,0,'933.261','538.569','139.305',0,30000,100,0,1,''),
(22939,564,0,196686,'916.841','559.846','139.304','4.99431',3600,0,0,'916.841','559.846','139.304',0,30000,100,0,1,''),
(22939,564,0,196686,'898.712','527.054','139.304','0.843476',3600,0,0,'898.712','527.054','139.304',0,30000,100,0,1,''),
(22939,564,0,196686,'915.001','547.531','139.304','4.5859',3600,0,0,'915.001','547.531','139.304',0,30000,100,0,1,''),
(22939,564,0,196696,'838.693','557.665','165.765','2.39465',3600,0,0,'838.693','557.665','165.765',0,30000,100,0,1,''),
(22939,564,0,123,'837.127','522.206','165.773','0.965232',3600,0,0,'837.127','522.206','165.773',0,30000,100,0,1,''),
(22939,564,0,123,'795.342','529.118','166.077','5.06894',3600,0,0,'795.342','529.118','166.077',0,30000,100,0,1,''),
(22939,564,0,53,'805.54','420.626','192.802','0.851355',3600,0,0,'805.54','420.626','192.802',0,30000,100,0,1,''),
(22939,564,0,144,'822.731','432.666','192.802','3.27039',3600,0,0,'822.731','432.666','192.802',0,30000,100,0,1,''),
(22939,564,0,144,'840.054','410.608','192.802','1.51895',3600,0,0,'840.054','410.608','192.802',0,30000,100,0,1,''),
(22939,564,0,122,'849.223','423.591','192.802','3.64738',3600,0,0,'849.223','423.591','192.802',0,30000,100,0,1,'');


/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (22964, 4162, 4162, 'Sister of Pleasure', '', 72, 72, 290000, 290000, 33090, 33090, 5700, 14, 14, 0, '1.2', 1, 575, 803, 0, 2411, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 3, 0, 0, 22964, 22964, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 11000, '', 1, 1, 0, 1, 22964,'');

/* Creature Location */
DELETE FROM `creature` WHERE `id`=22964;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(22964,564,0,0,'883.242','348.71','111.826','5.6973',3600,0,0,'883.242','348.71','111.826',0,290000,33090,0,1,''),
(22964,564,0,0,'952.495','338.6','111.826','2.25725',3600,0,0,'952.495','338.6','111.826',0,290000,33090,0,1,''),
(22964,564,0,196614,'957.311','388.479','112.768','3.14082',3600,0,0,'957.311','388.479','112.768',0,290000,33090,0,1,''),
(22964,564,0,196686,'880.69','435.056','111.826','0.568639',3600,0,0,'880.69','435.056','111.826',0,290000,33090,0,1,''),
(22964,564,0,196686,'917.476','381.936','118.241','3.10152',3600,0,0,'917.476','381.936','118.241',0,290000,33090,0,1,''),
(22964,564,0,196686,'926.625','467.431','112.768','3.86335',3600,0,0,'926.625','467.431','112.768',0,290000,33090,0,1,''),
(22964,564,0,196686,'910.585','546.957','139.304','5.25349',3600,0,0,'910.585','546.957','139.304',0,290000,33090,0,1,''),
(22964,564,0,196686,'864.092','552.734','154.767','5.92501',3600,0,0,'864.092','552.734','154.767',0,290000,33090,0,1,''),
(22964,564,0,0,'804.373','539.084','166.376','0.120931',3600,0,0,'804.373','539.084','166.376',0,290000,33090,0,1,''),
(22964,564,0,14,'820.31','513.483','166.107','1.99411',3600,0,0,'820.31','513.483','166.107',0,290000,33090,0,1,''),
(22964,564,0,105,'820.341','476.958','192.705','2.03731',3600,0,0,'820.341','476.958','192.705',0,290000,33090,0,1,''),
(22964,564,0,14,'790.303','433.357','192.802','5.91325',3600,0,0,'790.303','433.357','192.802',0,290000,33090,0,1,''),
(22964,564,0,120,'822.604','391.685','192.802','1.9195',3600,0,0,'822.604','391.685','192.802',0,290000,33090,0,1,''),
(22964,564,0,155,'838.377','428.51','192.802','4.71945',3600,0,0,'838.377','428.51','192.802',0,290000,33090,0,1,'');


/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (22956, 4162, 4162, 'Sister of Pain', '', 72, 72, 290000, 290000, 33090, 33090, 5700, 14, 14, 0, '1.2', 1, 575, 803, 0, 2411, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 3, 0, 0, 22956, 22956, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 11000, '', 1, 1, 0, 1, 22956,'');

/* Creature Location */
DELETE FROM `creature` WHERE `id`=22956;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(22956,564,0,0,'891.474','340.461','111.826','2.43004',3600,0,0,'891.474','340.461','111.826',0,290000,33090,0,1,''),
(22956,564,0,0,'952.773','348.166','111.826','3.87517',3600,0,0,'952.773','348.166','111.826',0,290000,33090,0,1,''),
(22956,564,0,196641,'957.229','395.773','112.768','3.2979',3600,0,0,'957.229','395.773','112.768',0,290000,33090,0,1,''),
(22956,564,0,196686,'880.952','446.086','111.826','5.41847',3600,0,0,'880.952','446.086','111.826',0,290000,33090,0,1,''),
(22956,564,0,196686,'917.343','402.99','118.241','3.16043',3600,0,0,'917.343','402.99','118.241',0,290000,33090,0,1,''),
(22956,564,0,196686,'908.054','489.633','127.401','5.06108',3600,0,0,'908.054','489.633','127.401',0,290000,33090,0,1,''),
(22956,564,0,196686,'919.065','545.71','139.304','4.00079',3600,0,0,'919.065','545.71','139.304',0,290000,33090,0,1,''),
(22956,564,0,196686,'885.978','537.366','139.28','0.364389',3600,0,0,'885.978','537.366','139.28',0,290000,33090,0,1,''),
(22956,564,0,196686,'847.785','537.044','165.871','0.819923',3600,0,0,'847.785','537.044','165.871',0,290000,33090,0,1,''),
(22956,564,0,9,'813.535','555.669','166.32','5.16712',3600,0,0,'813.535','555.669','166.32',0,290000,33090,0,1,''),
(22956,564,0,196645,'803.669','496.149','178.413','1.01236',3600,0,0,'803.669','496.149','178.413',0,290000,33090,0,1,''),
(22956,564,0,196651,'793.519','437.677','192.802','5.68941',3600,0,0,'793.519','437.677','192.802',0,290000,33090,0,1,''),
(22956,564,0,60,'827.471','393.767','192.802','2.20224',3600,0,0,'827.471','393.767','192.802',0,290000,33090,0,1,''),
(22956,564,0,9,'843.885','428.153','192.802','4.69197',3600,0,0,'843.885','428.153','192.802',0,290000,33090,0,1,'');


/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (22957, 8500, 8500, 'Priestess of Dementia', '', 72, 72, 530000, 530000, 3309, 3309, 5700, 14, 14, 0, '1.2', 1, 575, 803, 0, 2411, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 3, 0, 0, 22957, 22957, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 11000, '', 1, 1, 0, 1, 22957,'');

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22957);
INSERT INTO `creature_loot_template` VALUES
(22957, 21877, 34, 0, 1, 1, 1),
(22957, 32428, 17, 0, 1, 1, 1),
(22957, 32897, 9, 0, 1, 1, 1),
(22957, 32230, 3, 0, 1, 1, 1),
(22957, 32249, 3, 0, 1, 1, 1),
(22957, 32229, 2, 0, 1, 1, 1),
(22957, 25401, 1.6, 0, 1, 1, 1),
(22957, 24790, 1.6, 0, 1, 1, 1),
(22957, 32231, 1.6, 0, 1, 1, 1),
(22957, 32606, 1.6, 0, 1, 1, 1),
(22957, 32228, 1.6, 0, 1, 1, 1),
(22957, 32526, 1.2, 0, 1, 1, 1),
(22957, 25379, 0.8, 0, 1, 1, 1),
(22957, 25375, 0.8, 0, 1, 1, 1),
(22957, 25027, 0.8, 0, 1, 1, 1),
(22957, 24902, 0.8, 0, 1, 1, 1),
(22957, 24911, 0.8, 0, 1, 1, 1),
(22957, 24687, 0.8, 0, 1, 1, 1),
(22957, 25225, 0.8, 0, 1, 1, 1),
(22957, 32527, 0.8, 0, 1, 1, 1),
(22957, 32608, 0.8, 0, 1, 1, 1),
(22957, 32609, 0.8, 0, 1, 1, 1),
(22957, 25403, 0.4, 0, 1, 1, 1),
(22957, 25341, 0.4, 0, 1, 1, 1),
(22957, 25391, 0.4, 0, 1, 1, 1),
(22957, 25363, 0.4, 0, 1, 1, 1),
(22957, 25362, 0.4, 0, 1, 1, 1),
(22957, 25358, 0.4, 0, 1, 1, 1),
(22957, 25029, 0.4, 0, 1, 1, 1),
(22957, 24903, 0.4, 0, 1, 1, 1),
(22957, 25019, 0.4, 0, 1, 1, 1),
(22957, 24913, 0.4, 0, 1, 1, 1),
(22957, 24792, 0.4, 0, 1, 1, 1),
(22957, 24690, 0.4, 0, 1, 1, 1),
(22957, 24801, 0.4, 0, 1, 1, 1),
(22957, 24683, 0.4, 0, 1, 1, 1),
(22957, 24681, 0.4, 0, 1, 1, 1),
(22957, 24684, 0.4, 0, 1, 1, 1),
(22957, 25056, 0.4, 0, 1, 1, 1),
(22957, 32593, 0.4, 0, 1, 1, 1),
(22957, 32736, 0.4, 0, 1, 1, 1),
(22957, 32227, 0.4, 0, 1, 1, 1),
(22957, 32591, 0.4, 0, 1, 1, 1),
(22957, 32592, 0.4, 0, 1, 1, 1);

/* Creature Location */
DELETE FROM `creature` WHERE `id`=22957;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(22957,564,8500,22957,'931.189','236.933','192.836','1.4106',3600,0,0,'931.189','236.933','192.836','1.4106',530000,100,1,0,'');


/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (22962, 5500, 5500, 'Priestess od Delight', '', 72, 72, 660000, 660000, 3309, 3309, 5700, 14, 14, 0, '1.2', 1, 575, 803, 0, 2411, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 3, 0, 0, 22962, 22962, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 11000, '', 1, 1, 0, 1, 22962,'');

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=22962);
INSERT INTO `creature_loot_template` VALUES
(22962, 21877, 35, 0, 2, 3, 1),
(22962, 32428, 15, 0, 1, 1, 1),
(22962, 32897, 7, 0, 1, 1, 1),
(22962, 32249, 4, 0, 1, 1, 1),
(22962, 32231, 4, 0, 1, 1, 1),
(22962, 32228, 3, 0, 1, 1, 1),
(22962, 32227, 2, 0, 1, 1, 1),
(22962, 32736, 1.8, 0, 1, 1, 1),
(22962, 32230, 1.5, 0, 1, 1, 1),
(22962, 32593, 1.1, 0, 1, 1, 1),
(22962, 24904, 1.1, 0, 1, 1, 1),
(22962, 32609, 0.7, 0, 1, 1, 1),
(22962, 32229, 0.7, 0, 1, 1, 1),
(22962, 32590, 0.7, 0, 1, 1, 1),
(22962, 32943, 0.7, 0, 1, 1, 1),
(22962, 25057, 0.7, 0, 1, 1, 1),
(22962, 24677, 0.7, 0, 1, 1, 1),
(22962, 25281, 0.7, 0, 1, 1, 1),
(22962, 24795, 0.7, 0, 1, 1, 1),
(22962, 24909, 0.7, 0, 1, 1, 1),
(22962, 25360, 0.7, 0, 1, 1, 1),
(22962, 25361, 0.7, 0, 1, 1, 1),
(22962, 25404, 0.7, 0, 1, 1, 1),
(22962, 25389, 0.7, 0, 1, 1, 1),
(22962, 25390, 0.7, 0, 1, 1, 1),
(22962, 25342, 0.7, 0, 1, 1, 1),
(22962, 32528, 0.4, 0, 1, 1, 1),
(22962, 32606, 0.4, 0, 1, 1, 1),
(22962, 32748, 0.4, 0, 1, 1, 1),
(22962, 32744, 0.4, 0, 1, 1, 1),
(22962, 32527, 0.4, 0, 1, 1, 1),
(22962, 24682, 0.4, 0, 1, 1, 1),
(22962, 24678, 0.4, 0, 1, 1, 1),
(22962, 24803, 0.4, 0, 1, 1, 1),
(22962, 24691, 0.4, 0, 1, 1, 1),
(22962, 24687, 0.4, 0, 1, 1, 1),
(22962, 24796, 0.4, 0, 1, 1, 1),
(22962, 25042, 0.4, 0, 1, 1, 1),
(22962, 24910, 0.4, 0, 1, 1, 1),
(22962, 25113, 0.4, 0, 1, 1, 1),
(22962, 25026, 0.4, 0, 1, 1, 1),
(22962, 25309, 0.4, 0, 1, 1, 1),
(22962, 25406, 0.4, 0, 1, 1, 1),
(22962, 25401, 0.4, 0, 1, 1, 1),
(22962, 25379, 0.4, 0, 1, 1, 1),
(22962, 25392, 0.4, 0, 1, 1, 1),
(22962, 25346, 0.4, 0, 1, 1, 1),
(22962, 25397, 0.4, 0, 1, 1, 1),
(22962, 25403, 0.4, 0, 1, 1, 1),
(22962, 25398, 0.4, 0, 1, 1, 1),
(22962, 25400, 0.4, 0, 1, 1, 1);

/* Creature Location */
DELETE FROM `creature` WHERE `id`=22962;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(22962,564,5500,22962,'960.842','235.0105','192.836','2.086',3600,0,0,'960.842','235.0105','192.836','2.086',660000,100,1,0,'');


/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (23394, 18238, 18238, 'Promenade Sentinel', '', 72, 72, 660000, 660000, 0, 0, 5700, 14, 14, 0, '1.2', 1, 312, 512, 0, 2184, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 9, 0, 0, 23394, 23394, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 11000, '', 1, 1, 0, 1, 23394,'');

/* Creature Loot */
DELETE FROM `creature_loot_template` WHERE (`entry`=23394);
INSERT INTO `creature_loot_template` VALUES
(23394, 25403, 0.5, 0, 1, 1, 1),
(23394, 25405, 0.5, 0, 1, 1, 1),
(23394, 25397, 0.5, 0, 1, 1, 1),
(23394, 25379, 0.5, 0, 1, 1, 1),
(23394, 25376, 0.5, 0, 1, 1, 1),
(23394, 25025, 0.5, 0, 1, 1, 1),
(23394, 25308, 0.5, 0, 1, 1, 1),
(23394, 25071, 0.5, 0, 1, 1, 1),
(23394, 24907, 0.5, 0, 1, 1, 1),
(23394, 25015, 0.5, 0, 1, 1, 1),
(23394, 24689, 0.5, 0, 1, 1, 1),
(23394, 24688, 0.5, 0, 1, 1, 1),
(23394, 24682, 0.5, 0, 1, 1, 1),
(23394, 24681, 0.5, 0, 1, 1, 1),
(23394, 24684, 0.5, 0, 1, 1, 1),
(23394, 32527, 0.5, 0, 1, 1, 1),
(23394, 32752, 0.5, 0, 1, 1, 1),
(23394, 32749, 0.5, 0, 1, 1, 1),
(23394, 32589, 0.5, 0, 1, 1, 1),
(23394, 32591, 0.5, 0, 1, 1, 1),
(23394, 32592, 0.5, 0, 1, 1, 1),
(23394, 25400, 1.1, 0, 1, 1, 1),
(23394, 25344, 1.1, 0, 1, 1, 1),
(23394, 25391, 1.1, 0, 1, 1, 1),
(23394, 24917, 1.1, 0, 1, 1, 1),
(23394, 32606, 1.1, 0, 1, 1, 1),
(23394, 32609, 1.1, 0, 1, 1, 1),
(23394, 32249, 1.6, 0, 1, 1, 1),
(23394, 32229, 1.6, 0, 1, 1, 1),
(23394, 32230, 3, 0, 1, 1, 1),
(23394, 32228, 3, 0, 1, 1, 1),
(23394, 32227, 3, 0, 1, 1, 1),
(23394, 25404, 3, 0, 1, 1, 1),
(23394, 32608, 3, 0, 1, 1, 1),
(23394, 32231, 5, 0, 1, 1, 1),
(23394, 32897, 15, 0, 1, 1, 1);

/* Creature Location */
DELETE FROM `creature` WHERE `id`=23394;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(23394,564,0,0,'800.524','137.186','204.768','0.153956',3600,0,0,'800.524','137.186','204.768',0,660000,0,0,1,''),
(23394,564,0,0,'799.501','162.102','204.768','6.28006',3600,0,0,'799.501','162.102','204.768',0,660000,0,0,1,''),
(23394,564,0,17,'813.207','178.607','204.768','4.7996',3600,0,0,'813.207','178.607','204.768',0,660000,0,0,1,''),
(23394,564,0,0,'812.215','119.785','204.768','1.59517',3600,0,0,'812.215','119.785','204.768',0,660000,0,0,1,''),
(23394,564,0,124,'748.16','133.216','218.446','6.15834',3600,0,0,'748.16','133.216','218.446',0,660000,0,0,1,''),
(23394,564,0,10,'748.588','164.387','218.421','0.000819206',3600,0,0,'748.588','164.387','218.421',0,660000,0,0,1,''),
(23394,564,0,112,'774.124','161.915','218.544','3.14241',3600,0,0,'774.124','161.915','218.544',0,660000,0,0,1,''),
(23394,564,0,32,'774.333','137.555','218.576','3.0089',3600,0,0,'774.333','137.555','218.576',0,660000,0,0,1,''),
(23394,564,0,0,'718.302','136.956','231.972','3.04031',3600,0,0,'718.302','136.956','231.972',0,660000,0,0,1,''),
(23394,564,0,0,'720.336','161.809','231.973','3.27593',3600,0,0,'720.336','161.809','231.973',0,660000,0,0,1,''),
(23394,564,0,120,'690.489','137.866','232.077','0.00867176',3600,0,0,'690.489','137.866','232.077',0,660000,0,0,1,''),
(23394,564,0,0,'690.179','163.462','232.077','0.0675778',3600,0,0,'690.179','163.462','232.077',0,660000,0,0,1,''),
(23394,564,0,10,'665.237','162.817','245.858','3.24058',3600,0,0,'665.237','162.817','245.858',0,660000,0,0,1,''),
(23394,564,0,0,'664.54','137.82','245.829','3.26415',3600,0,0,'664.54','137.82','245.829',0,660000,0,0,1,''),
(23394,564,0,0,'637.923','135.503','245.022','0.110769',3600,0,0,'637.923','135.503','245.022',0,660000,0,0,1,''),
(23394,564,0,6284724,'638.825','165.485','245.024','6.27536',3600,0,0,'638.825','165.485','245.024',0,660000,0,0,1,''),
(23394,564,0,0,'611.162','138.831','258.872','3.14397',3600,0,0,'611.162','138.831','258.872',0,660000,0,0,1,''),
(23394,564,0,0,'611.653','162.249','258.882','3.17067',3600,0,0,'611.653','162.249','258.882',0,660000,0,0,1,''),
(23394,564,0,196635,'533.71','195.005','258.723','4.75717',3600,0,0,'533.71','195.005','258.723',0,660000,0,0,1,''),
(23394,564,0,196686,'563.926','194.392','258.722','4.69042',3600,0,0,'563.926','194.392','258.722',0,660000,0,0,1,''),
(23394,564,0,196686,'538.221','224.173','271.917','1.69019',3600,0,0,'538.221','224.173','271.917',0,660000,0,0,1,''),
(23394,564,0,196686,'558.964','223.657','271.917','1.67449',3600,0,0,'558.964','223.657','271.917',0,660000,0,0,1,''),
(23394,564,0,196686,'566.968','291.301','271.975','3.46284',3600,0,0,'566.968','291.301','271.975',0,660000,0,0,1,''),
(23394,564,0,196686,'565.667','318.218','271.946','3.54374',3600,0,0,'565.667','318.218','271.946',0,660000,0,0,1,'');


/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (23401, 14366, 14366, 'Hungering Soul Fragment', '', 72, 72, 45000, 45000, 100, 100, 5700, 14, 14, 0, '1.2', 1, 312, 575, 0, 2184, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 6, 0, 0, 23401, 23401, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 11000, '', 1, 1, 0, 1, 23401,'');

/* Creature Location */
DELETE FROM `creature` WHERE `id`=23401;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(23401,564,14366,0,'635.304','72.4929','113.297','2.88479',3600,0,0,'635.304','72.4929','113.297',0,45000,100,0,1,''),
(23401,564,14366,0,'628.321','66.0334','113.336','4.27887',3600,0,0,'628.321','66.0334','113.336',0,45000,100,0,1,''),
(23401,564,14366,0,'628.434','44.0541','112.751','2.55492',3600,0,0,'628.434','44.0541','112.751',0,45000,100,0,1,''),
(23401,564,14366,0,'641.013','26.2933','112.711','2.64917',3600,0,0,'641.013','26.2933','112.711',0,45000,100,0,1,''),
(23401,564,14366,0,'605.673','29.9504','112.726','1.62737',3600,0,0,'605.673','29.9504','112.726',0,45000,100,0,1,''),
(23401,564,14366,0,'604.191','56.1234','111.373','0.794846',3600,0,0,'604.191','56.1234','111.373',0,45000,100,0,1,''),
(23401,564,14366,0,'597.982','96.5181','112.335','3.75501',3600,0,0,'597.982','96.5181','112.335',0,45000,100,0,1,''),
(23401,564,14366,0,'572.282','72.1338','112.064','2.9382',3600,0,0,'572.282','72.1338','112.064',0,45000,100,0,1,''),
(23401,564,14366,0,'550.206','92.9154','112.618','4.08488',3600,0,0,'550.206','92.9154','112.618',0,45000,100,0,1,''),
(23401,564,14366,0,'542.209','58.4614','112.839','3.18638',3600,0,0,'542.209','58.4614','112.839',0,45000,100,0,1,''),
(23401,564,14366,0,'557.56','24.3636','112.671','2.30281',3600,0,0,'557.56','24.3636','112.671',0,45000,100,0,1,''),
(23401,564,14366,0,'517.482','32.1759','113.505','1.85513',3600,0,0,'517.482','32.1759','113.505',0,45000,100,0,1,''),
(23401,564,14366,0,'491.685','53.9431','112.603','6.11121',3600,0,0,'491.685','53.9431','112.603',0,45000,100,0,1,''),
(23401,564,14366,0,'631.909','96.7793','113.206','3.9121',3600,0,0,'631.909','96.7793','113.206',0,45000,100,0,1,''),
(23401,564,14366,0,'592.407','80.9853','111.142','6.22509',3600,0,0,'592.407','80.9853','111.142',0,45000,100,0,1,''),
(23401,564,0,269,'512.712','73.4392','112.244','2.35777',3600,0,0,'512.712','73.4392','112.244',0,45000,100,0,1,''),
(23401,564,0,196650,'568.328','99.2462','112.467','5.27553',3600,0,0,'568.328','99.2462','112.467',0,45000,100,0,1,'');

/* Creature Template */
REPLACE INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `ScriptName`) VALUES (23399, 146, 146, 'Suffering Soul Fragment', '', 72, 72, 70000, 70000, 66180, 66180, 5700, 14, 14, 0, '1.2', 1, 312, 575, 0, 2184, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 6, 0, 0, 23399, 23399, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 11000, '', 1, 1, 0, 1, 23399,'');

/* Creature Location */
DELETE FROM `creature` WHERE `id`=23399;
INSERT INTO `creature` (`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
(23399,564,146,0,'576.984','53.2451','111.931','1.37918',3600,0,0,'576.984','53.2451','111.931',0,70000,66180,0,1,''),
(23399,564,146,0,'611.519','55.4132','111.542','5.65567',3600,0,0,'611.519','55.4132','111.542',0,70000,66180,0,1,''),
(23399,564,146,0,'619.654','24.9759','112.729','1.79937',3600,0,0,'619.654','24.9759','112.729',0,70000,66180,0,1,''),
(23399,564,146,0,'587.608','34.0442','112.756','3.594',3600,0,0,'587.608','34.0442','112.756',0,70000,66180,0,1,''),
(23399,564,146,0,'593.388','72.0717','111.587','0.330673',3600,0,0,'593.388','72.0717','111.587',0,70000,66180,0,1,''),
(23399,564,146,0,'641.427','86.3397','112.755','3.777',3600,0,0,'641.427','86.3397','112.755',0,70000,66180,0,1,''),
(23399,564,146,0,'615.81','105.769','112.747','4.5137',3600,0,0,'615.81','105.769','112.747',0,70000,66180,0,1,''),
(23399,564,146,0,'573.559','100.092','113.27','5.58106',3600,0,0,'573.559','100.092','113.27',0,70000,66180,0,1,''),
(23399,564,146,0,'538.676','88.2457','112.353','5.87165',3600,0,0,'538.676','88.2457','112.353',0,70000,66180,0,1,''),
(23399,564,146,0,'545.263','55.3675','112.805','0.51602',3600,0,0,'545.263','55.3675','112.805',0,70000,66180,0,1,''),
(23399,564,146,0,'523.411','22.3472','113.227','1.16397',3600,0,0,'523.411','22.3472','113.227',0,70000,66180,0,1,''),
(23399,564,146,0,'471.986','67.7856','111.905','0.543508',3600,0,0,'471.986','67.7856','111.905',0,70000,66180,0,1,''),
(23399,564,146,0,'520.919','74.5779','112.892','0.107609',3600,0,0,'520.919','74.5779','112.892',0,70000,66180,0,1,''),
(23399,564,146,0,'513.478','62.4716','113.01','5.36978',3600,0,0,'513.478','62.4716','113.01',0,70000,66180,0,1,'');

/* Update */
UPDATE `creature_template` SET InhabitType=1 WHERE entry IN (22964, 23420, 23419,

23418, 22949, 22948, 22950, 22951, 22947, 22841, 22898, 22871, 22952, 23086, 22878, 22883,

22881, 22844, 22845, 22846, 22847, 23028, 22963, 22873, 22874, 22875, 22877, 22885, 23030,

23330, 22960, 23172, 22869, 23337, 22853, 22954, 23339, 22855, 22884, 22945, 22880, 22882,

23147, 23411, 22848, 22953, 22955, 22939, 22964, 22956, 22957, 22962, 23394, 23401, 23399);


/* This will update the spawntimesecs from 25s to 3600s */

UPDATE `creature` SET spawntimesecs=3600 WHERE id in (22955, 22939, 22964, 22956, 23394, 23401, 23399);

/* This will correct two mobs name */

UPDATE `creature_template` SET name='Hungering Soul Fragment' WHERE entry=23401;
UPDATE `creature_template` SET name='Suffering Soul Fragment' WHERE entry=23399;

/* This will correct the current gold drop rate */

UPDATE `creature_template` SET mingold=10000, maxgold=11000 WHERE entry in (22878, 22883, 22844, 22845, 22847, 22846, 23028, 22963, 22873, 22874, 22875, 22877, 22885, 23030, 23330, 22960, 23172, 22869, 23337, 22853, 22954, 23339, 22855, 22884, 22945, 22880, 22882, 23147, 23411, 22848, 22953, 22955, 22962, 22957, 23394, 22956, 22964, 17814, 22939, 23401, 23399);
UPDATE `creature_template` SET mingold=1160000, maxgold=1170000 WHERE entry in (22917);
UPDATE `creature_template` SET mingold=961900, maxgold=1000000 WHERE entry in (23420, 23419, 23418, 22948, 22887, 22947, 22841, 22898, 22871);
UPDATE `creature_template` SET mingold=310000, maxgold=350000 WHERE entry in (22949, 22950, 22951, 22952);

/* This will set the armor to 5700 on all BT mobs */

UPDATE `creature_template` SET armor=5700 WHERE entry in (22878, 22883, 22844, 22845, 22847, 22846, 23028, 22963, 22873, 22874, 22875, 22877, 22885, 23030, 23330, 22960, 23172, 22869, 23337, 22853, 22954, 23339, 22855, 22884, 22945, 22880, 22882, 23147, 23411, 22848, 22953, 22955, 22962, 22957, 23394, 22956, 22964, 17814, 22939, 23401, 23399, 22917, 23420, 23419, 23418, 22948, 22887, 22947, 22841, 22898, 22871, 22949, 22950, 22951, 22952);

/* This will remove the World Boar Trainer in BT */

DELETE FROM `creature` where entry=5002;