Фиксы на дроп в санвеле взято с wowjp
Ентропа
Код:
DELETE FROM `creature_loot_template` WHERE (`entry`=25840); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=29434); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 29434, 100, 0, 2, 2, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34233); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34233, 43, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=35283); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 35283, 43, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34430); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34430, 36, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=35284); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 35284, 36, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34429); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34429, 29, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34228); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34228, 29, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34215); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34215, 29, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34231); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34231, 21, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34214); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34214, 21, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=35282); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 35282, 21, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34232); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34232, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34213); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34213, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34230); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34230, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34428); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34428, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34427); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34427, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=32227); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 32227, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34229); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34229, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34240); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34240, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34211); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34211, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34216); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34216, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34234); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34234, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34212); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34212, 7, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25840) AND (`item`=34664); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25840, 34664, 7, 0, 1, 1, 0, 0, 0);
Grand Warlock Alythess
Код:
DELETE FROM `creature_loot_template` WHERE (`entry`=25166); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=29434); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 29434, 93, 0, 2, 2, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34664); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34664, 67, 0, 4, 0, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=35290); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 35290, 38, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=35291); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 35291, 35, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=35292); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 35292, 25, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34196); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34196, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34209); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34209, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34208); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34208, 23, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34210); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34210, 22, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34193); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34193, 22, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34194); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34194, 21, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34202); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34202, 20, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34195); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34195, 20, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34206); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34206, 20, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34198); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34198, 20, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34204); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34204, 18, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34203); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34203, 17, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34192); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34192, 17, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34199); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34199, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34189); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34189, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34205); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34205, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34848); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34848, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34190); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34190, 14, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34857); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34857, 13, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34197); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34197, 13, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34858); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34858, 12, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34852); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34852, 11, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34855); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34855, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34851); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34851, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34853); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34853, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34856); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34856, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=34854); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 34854, 8, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32229); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32229, 4, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32228); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32228, 4, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32231); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32231, 2, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25166) AND (`item`=32227); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25166, 32227, 1.4, 0, 1, 1, 0, 0, 0);
Kil'Jaeden
Код:
DELETE FROM `creature_loot_template` WHERE (`entry`=25315); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=29434); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 29434, 24, 0, 3, 3, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34345); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34345, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34329); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34329, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34241); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34241, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34335); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34335, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34247); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34247, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34341); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34341, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34334); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34334, 15, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34333); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34333, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34245); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34245, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34332); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34332, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34339); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34339, 24, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34340); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34340, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34244); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34244, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34337); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34337, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34331); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34331, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34344); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34344, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34342); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34342, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34243); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34243, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34336); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34336, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34242); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34242, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25315) AND (`item`=34343); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25315, 34343, 19, 0, 1, 1, 0, 0, 0);
Lady Sacrolash
Код:
DELETE FROM `creature_loot_template` WHERE (`entry`=25165); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=29434); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 29434, 100, 0, 2, 2, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=35290); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 35290, 31, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=35292); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 35292, 28, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34190); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34190, 37, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34208); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34208, 22, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34203); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34203, 21, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34851); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34851, 19, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34206); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34206, 18, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34858); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34858, 18, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34197); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34197, 18, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34199); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34199, 16, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34189); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34189, 16, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34192); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34192, 16, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34209); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34209, 16, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34202); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34202, 13, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34205); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34205, 13, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34204); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34204, 12, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34848); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34848, 12, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34196); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34196, 12, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34194); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34194, 12, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34195); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34195, 12, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34193); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34193, 12, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34210); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34210, 10, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34853); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34853, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34855); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34855, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34856); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34856, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34857); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34857, 9, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34854); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34854, 6, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34852); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34852, 6, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34198); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34198, 6, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=34664); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (25165, 34664, 6, 0, 1, 1, 0, 0, 0); DELETE FROM `creature_loot_template` WHERE (`entry`=25165) AND (`item`=32227); INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_val