Untitled

--Update DisenchantID's for the items in questions

--Remove all Disenchnat Loot Item Entries from disenchant_loot_template

--Insert an abyss crystal and a golden ticket

 

Update item_template set DisenchantID = entry where name like 'Deadly Gladiat%';

Delete from disenchant_loot_template where entry =(select entry from item_template where name like 'Deadly Gladiat%');

insert into disenchant_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount,lootcondition,condition_value1,condition_value2) Select entry,34057,100,1,1,1,1,0,0,0 from item_template where `name` LIKE '%deadly glad%';

insert into disenchant_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount,lootcondition,condition_value1,condition_value2) Select entry,70026,100,1,1,1,1,0,0,0 from item_template where `name` LIKE '%deadly glad%';