Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- 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...
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement