Loading...   

UPDATE npc_types SET loottable_id = 11971 WHERE name IN ("a_golem_usher", "an_undead_dancer", "an_undead_bridesmaid", "an_undead_musician"); -- unify all floor 5 mobs not associated with wedding sword
UPDATE loottable SET name = "ToFS_Floor_5", mincash = 250000, maxcash = 1500000 WHERE id = 11971; -- 250-3000 pp per kill on Floor 5
UPDATE npc_types SET npc_faction_id = 4804 WHERE name IN ("a_shadow_beast_guard", "an_ice_shade", "an_icy_shade", "#a_shadow_beast_guard", "#an_ice_shade"); -- unify all floor 6 mobs
UPDATE npc_types SET loottable_id = 497 WHERE name IN ("a_shadow_beast_guard", "an_ice_shade", "an_icy_shade", "#a_shadow_beast_guard", "#an_ice_shade"); -- unify all floor 6 mobs
UPDATE loottable SET name = "ToFS_Floor_6", mincash = 350000, maxcash = 1650000 WHERE id = 497; -- 750-5000pp per kill on Floor 6
UPDATE loottable SET mincash = 5000000, maxcash = 50000000 WHERE id = 7514; -- add cash drop to VhalSerra
INSERT INTO loottable (name, mincash, maxcash) VALUES ("ToFS_Floor_7", 450000, 1750000); -- create group for floor 7, 5000-12500 per kill
SET @id = (SELECT id FROM loottable WHERE name = "ToFS_Floor_7"); -- pull id
UPDATE npc_types SET loottable_id = @id WHERE name IN ("a_crystallized_shadow_guard", "a_shrouded_bat", "a_frost_familiar", "a_shaded_torch", "#a_shrouded_bat", "a_blood_familiar", "a_fading_shadow_guard") AND loottable_id = 0; -- set the new ToFS Floor 7 loottable to the npcs on floor 7