Naxxramas 80 Update SQL script

[moltn]

Yep sorry guys i got the SQL syntax wrong but i have just fixed it, try again now

Works.
+Rep!

Btw Iksf, I went ahead and posted this on Ac-Web. I gave you all the credit! Here is the link if you went proof ofc, http://www.ac-web.org/forum/releases...tml#post371720 .

[keazain]

+Rep x 2 from me nice work

[westside92]

nice workd

[Iksf]

Works.
+Rep!

Btw Iksf, I want ahead and posted this on MM-Owned. I gave you all the credit! Here is the link if you went proof ofc, Naxxramas Updated (80 Script) - AC Web .

On AC-Web you mean? xD

[Mitron]

Nice is there comin a release on drops and stuff to ?? or maybe a fix of the WotLk naxx ??

[moltn]

On AC-Web you mean? xD

>.<;

Common error - that proves that I AM Human.. ..I think.. I hope.. OH NOES!

Wtb, Loot update?

[youngbuck]

Good job man +rep for you. keep it up.

[extreme5]

Well done +rep!

[Teld]

I know this is an old topic but I have used this code and it worked fine, but im curious if anyone has scripted the boss fights in the 10 and 25 man versions of this raid yet so that they would be very close if not an exact match to the retail version and if so where I might be able to find them, and if not would anyone be willing to take on the job with a downpayment of an agree'd upon ammount with the remaining ballance due upon completion and successful testing of all scripts?

[karlan91]

very nice just need the 80 loot now ^^

[mistahellfire]

I dont know about you but when i ran the loot SQL it had a NULL error so i fixed it and changed it to 0's..for arcemu..enjoy

DELETE FROM `loot_creatures` WHERE `entryid`=15956;
DELETE FROM `loot_creatures` WHERE `entryid`=15953;
DELETE FROM `loot_creatures` WHERE `entryid`=15952;
DELETE FROM `loot_creatures` WHERE `entryid`=15954;
DELETE FROM `loot_creatures` WHERE `entryid`=15936;
DELETE FROM `loot_creatures` WHERE `entryid`=16011;
DELETE FROM `loot_creatures` WHERE `entryid`=16028;
DELETE FROM `loot_creatures` WHERE `entryid`=16060;
DELETE FROM `loot_creatures` WHERE `entryid`=15931;
DELETE FROM `loot_creatures` WHERE `entryid`=15932;
DELETE FROM `loot_creatures` WHERE `entryid`=15928;
DELETE FROM `loot_creatures` WHERE `entryid`=16061;
DELETE FROM `loot_creatures` WHERE `entryid`=16061;
DELETE FROM `loot_creatures` WHERE `entryid`=15989;
DELETE FROM `loot_creatures` WHERE `entryid`=15990;
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39716', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39714', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39712', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39717', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39704', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39721', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39720', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39706', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39722', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39719', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39718', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39701', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39702', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '39703', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40074', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40108', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40071', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40080', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40075', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40069', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40107', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40064', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15956', '40065', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39723', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39725', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39727', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39756', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39731', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39757', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39735', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39728', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39732', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39730', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39733', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39729', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '39734', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40065', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40074', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40080', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40075', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40107', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40071', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40064', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15953', '40069', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40063', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39768', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40061', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39766', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39763', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39758', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39767', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40062', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40060', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39764', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39760', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39765', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39762', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39759', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '39761', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40250', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40258', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40255', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40256', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40254', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40253', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40257', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40252', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15952', '40251', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40193', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40198', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40191', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40197', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40185', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40200', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40184', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40602', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40189', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40196', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40187', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40192', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40186', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40188', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40190', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40065', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40071', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40074', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40108', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40069', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40107', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15954', '40264', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40235', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40237', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40207', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40236', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40210', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40238', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40233', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40206', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40205', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40208', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40234', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40204', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40209', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40203', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40201', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40250', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40256', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40254', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40258', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40253', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40251', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40255', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40252', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15936', '40257', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40639', '75', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40638', '60', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40637', '55', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40249', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40245', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40244', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40239', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40247', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40242', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40243', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40241', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40240', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16011', '40246', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40247', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40272', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40269', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40263', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40266', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40271', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40265', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40261', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40262', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40264', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40259', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40270', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40273', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40260', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40268', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40075', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40108', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40074', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40065', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40071', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40107', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40069', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40080', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '16028', '40064', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40289', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40278', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40281', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40288', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40283', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40287', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40285', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40282', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40279', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40284', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40280', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40277', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40274', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40258', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40253', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40250', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40256', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40251', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40254', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40252', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40255', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('0', '15931', '40257', '10', '0', '1', '1', '0');

[resinate]

edited out for reasons

[lollardo]

awesome ^^

[zimonken]

nice with the loots!

[SupernovaHH]

i have a problem. I try to execute this into the database and i get Error 1065 - Query was empty

UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038574,`maxhealth`=13038576,`attacktime`=1799,`mindamage`=17001,`maxdamage`=18004 WHERE `entry`=16028;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9596000,`maxhealth`=9596000,`mana`=120000,`mindamage`=14000,`maxdamage`=14001,`respawntime`=0 WHERE `entry`=15931;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=11432000,`maxhealth`=11432000,`mana`=12000,`mindamage`=12000,`maxdamage`=12500,`respawntime`=0 WHERE `entry`=15932;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=30400000,`maxhealth`=30400000,`mindamage`=13500,`maxdamage`=15200,`respawntime`=0 WHERE `entry`=15928;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6763000,`maxhealth`=6763000,`mindamage`=9000,`maxdamage`=14000,`respawntime`=0 WHERE `entry`=15956;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=6600 WHERE `entry`=16573;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mana`=0,`mindamage`=5000,`maxdamage`=7900 WHERE `entry`=15976;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=46000,`maxhealth`=46000,`mana`=0,`mindamage`=3000,`maxdamage`=4000 WHERE `entry`=15974;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=234000,`maxhealth`=234000,`mana`=0,`maxdamage`=3000 WHERE `entry`=15975;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`maxdamage`=2200 WHERE `entry`=15977;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=586500,`maxhealth`=586500,`mindamage`=4000,`maxdamage`=7000 WHERE `entry`=15978;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=160000,`maxhealth`=160000,`maxdamage`=6900 WHERE `entry`=16453;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=3000,`maxdamage`=3500 WHERE `entry`=15980;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=2000,`maxdamage`=3000 WHERE `entry`=15981;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6760000,`maxhealth`=6760000,`mindamage`=11000,`maxdamage`=13000,`respawntime`=0 WHERE `entry`=15953;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=4400 WHERE `entry`=16505;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=40000,`maxhealth`=40000,`mindamage`=5500,`maxdamage`=6600 WHERE `entry`=16449;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=120000,`maxhealth`=120000,`mindamage`=7800,`maxdamage`=8000 WHERE `entry`=16368;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=7600000,`maxhealth`=7600000,`mindamage`=15900,`maxdamage`=16000 WHERE `entry`=15952;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=456000,`maxhealth`=456000,`mindamage`=8000,`maxdamage`=12000 WHERE `entry`=15979;;
UPDATE `creature_proto` SET `minhealth`=143000,`maxhealth`=143000,`mindamage`=11000,`maxdamage`=22000 WHERE `entry`=16017;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81 WHERE `entry`=16017;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=176000,`maxhealth`=176000,`mindamage`=9020,`maxdamage`=11015 WHERE `entry`=16018;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=252000,`maxhealth`=252000,`mindamage`=7090,`maxdamage`=1101,`walk_speed`=1.5,`run_speed`=4 WHERE `entry`=16375;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=51000,`maxhealth`=51000,`mindamage`=8000,`maxdamage`=10900,`walk_speed`=1,`run_speed`=4 WHERE `entry`=16024;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=7086,`maxdamage`=9010 WHERE `entry`=16020;;
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=188000,`maxhealth`=188000,`mindamage`=10000,`maxdamage`=12000 WHERE `entry`=16021;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=88000,`maxhealth`=88000,`mindamage`=5200,`maxdamage`=6400 WHERE `entry`=16022;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=539000,`maxhealth`=539000,`mindamage`=14000,`maxdamage`=17000 WHERE `entry`=16025;;
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=134000,`maxhealth`=134000,`mindamage`=11000,`maxdamage`=11000 WHERE `entry`=16029;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=12000,`maxdamage`=18000 WHERE `entry`=15930;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=16000,`maxdamage`=20000 WHERE `entry`=15929;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9700,`maxdamage`=11000 WHERE `entry`=16156;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=98000,`maxhealth`=98000,`mindamage`=6000,`maxdamage`=9000 WHERE `entry`=16158;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=342000,`maxhealth`=342000,`mindamage`=11000,`maxdamage`=14000 WHERE `entry`=16146;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mindamage`=15700,`maxdamage`=17600 WHERE `entry`=16145;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=8900,`maxdamage`=11000 WHERE `entry`=16167;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=50000,`maxhealth`=50000 WHERE `entry`=16157;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=404000,`maxhealth`=404000,`mindamage`=12000,`maxdamage`=14000,`armor`=38000 WHERE `entry`=16803;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=10100000,`maxhealth`=10100000,`mindamage`=50000,`maxdamage`=60000,`respawntime`=0 WHERE `entry`=16061;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=390990,`maxhealth`=390990,`mindamage`=12000,`maxdamage`=14000 WHERE `entry`=16163;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=187668,`maxhealth`=187668,`mindamage`=11000,`maxdamage`=19000 WHERE `entry`=16165;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=14000,`maxdamage`=22000 WHERE `entry`=16448;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2510000,`maxhealth`=2510000,`mana`=4500000,`mindamage`=12000,`maxdamage`=15000,`respawntime`=0 WHERE `entry`=16060;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=7000,`respawntime`=0 WHERE `entry`=16064;;
UPDATE `creature_proto` SET `entry`=30549,`minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=3300,`maxdamage`=7700,`respawntime`=0 WHERE `entry`=16062;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`respawntime`=0 WHERE `entry`=16063;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=8000 WHERE `entry`=16067;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038000,`maxhealth`=13038000,`mindamage`=12000,`maxdamage`=18000,`respawntime`=0 WHERE `entry`=15989;;
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`attacktype`,`mindamage`,`maxdamage`,`can_ranged`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`respawntime`,`armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`,`spell1`,`spell2`,`spell3`,`spell4`,`spell_flags`,`modImmunities`) VALUES (113491,81,81,21,207000,207000,0,1,0,2000,0,11000,22000,0,0,0,0,360000,5000,0,0,0,0,0,0,1,1,'',0,1450,0,0,1,4,8,0,0,0,0,0,0,0);;
UPDATE `creature_proto` SET `minhealth`=2370000,`maxhealth`=2370000 WHERE `entry`=16065;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2200000,`maxhealth`=2200000,`mindamage`=8200,`maxdamage`=12000,`respawntime`=0 WHERE `entry`=16011;;
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=10879,`maxhealth`=10879,`mindamage`=900,`maxdamage`=1200 WHERE `entry`=16057;;
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=140000,`maxhealth`=140000,`mindamage`=1100,`maxdamage`=1200 WHERE `entry`=16056;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9270000,`maxhealth`=9270000,`mindamage`=10000,`maxdamage`=11000 WHERE `entry`=15936;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=8440000,`maxhealth`=8440000,`mindamage`=11000,`maxdamage`=16000 WHERE `entry`=15954;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=563260,`maxhealth`=563260,`mindamage`=6600,`maxdamage`=7800 WHERE `entry`=16034;;
UPDATE `creature_proto` SET `minhealth`=195000,`maxhealth`=195000 WHERE `entry`=16034;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=5000,`maxdamage`=7000 WHERE `entry`=16036;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=6000,`maxdamage`=7000 WHERE `entry`=16037;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=877400,`maxhealth`=877400,`mindamage`=11000,`maxdamage`=12000 WHERE `entry`=16168;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9000,`maxdamage`=11000 WHERE `entry`=16244;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=8000,`maxdamage`=11000 WHERE `entry`=16243;;