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