Untitled

--Update DisenchantID's for the items in questions

--Insert an abyss crystal and a golden ticket

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

replace into disenchant_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount,lootcondition,condition_value1,condition_value2) Select

 

entry,34057,100,1,0,1,1,0,0,0 from item_template where `name` LIKE '%deadly glad%';

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

 

--Update uow_craftables with crafted item data

replace into uow_craftables (entry, tradeskill,skilllevel,resource1,quantity1,resource2,quantity2,tier) Select entry,0,0,34057,1,70026,1,1 from world_hardcore.item_template

 

where `name` LIKE '%deadly glad%';