--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%';