query

/*
This SQL Was Made BY JadaDev & Rochet2 !! This will Make FOR you a complete Instance.
So first step is Open your MySQL AND run this file after config it with NotePad++
1- Remove all Loots from Instance. " 576 is the Maps "go ingame AND TYPE .gps "
*/
DELETE FROM `creature_loot_template` WHERE entry IN (SELECT DISTINCT id FROM creature WHERE map = 409);
/*
Step 2 we gonna change all Mobs HP, dmg etc.. you can also change the DMG :) in that Instance alwyes use the Maps as .gps
*/
UPDATE creature_template SET HealthModifier = 500, minlevel = 255, maxlevel = 255, DamageModifier = 1, dmgschool = 2, ManaModifier = 500
WHERE entry IN (SELECT DISTINCT id FROM creature WHERE map = 409);
/*
Now Find the Mobs in WoWHead.com AND GET the bosses ID's and Update this :
*/
SET
@BOSS1 =11982,
@BOSS2 =11988,
@BOSS3 =12057,
@BOSS4 =12056;
UPDATE creature_template SET HealthModifier = 1500, DamageModifier = 4 WHERE entry = @BOSS1;
UPDATE creature_template SET HealthModifier = 1750, DamageModifier = 6 WHERE entry = @BOSS2;
UPDATE creature_template SET HealthModifier = 2000, DamageModifier = 8 WHERE entry = @BOSS3;
UPDATE creature_template SET HealthModifier = 2500, DamageModifier = 10 WHERE entry = @BOSS4;
/*
Now you need to Add loots -- This one is for only 1 Item ( specified like tokens or so
*/
SET
@item = 101001,
@Chance = 90,
@BOSS1 =11982,
@BOSS2 =11988,
@BOSS3 =12057,
@BOSS4 =12056;
INSERT INTO world.creature_loot_template
VALUES
(@BOSS1, @item, 0, @Chance, 1, 1, 0, 1, 5, NULL),
(@BOSS2, @item, 0, @Chance, 1, 1, 0, 1, 5, NULL),
(@BOSS3, @item, 0, @Chance, 1, 1, 0, 1, 5, NULL),
(@BOSS4, @item, 0, @Chance, 1, 1, 0, 1, 5, NULL);
/*
This is Where the SETS and Off-Sets for BOSS1  & 2 & 3 But Rings and trinket and weapons for BOSS 4 -- Be sure to change the custom items itemlevel as exp : Tier1 = ItemLevel = 4000 And Tier2 = ItemLevel = 4500 or so etc...
*/