-- This will update the disenchant_loot_table for items that have none assigned. -- This fixes the bug, that some crafted items cannot be disenchanted. -- Also adds adds disenchant_loot_table to new items. by InvisibleUPDATE item_template SET DisenchantID=1 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=1 AND class=4;UPDATE item_template SET DisenchantID=2 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=1 AND class=2;UPDATE item_template SET DisenchantID=41 WHERE Quality=3 AND disenchantid=0 AND RequiredDisenchantSkill=25 AND class=4;UPDATE item_template SET DisenchantID=3 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=25 AND class=4;UPDATE item_template SET DisenchantID=23 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=25 AND class=2;UPDATE item_template SET DisenchantID=4 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=50 AND class=4;UPDATE item_template SET DisenchantID=24 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=50 AND class=2;UPDATE item_template SET DisenchantID=5 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=75 AND class=4;UPDATE item_template SET DisenchantID=43 WHERE Quality=3 AND disenchantid=0 AND RequiredDisenchantSkill=75 AND class=4;UPDATE item_template SET DisenchantID=6 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=100 AND class=4;UPDATE item_template SET DisenchantID=61 WHERE Quality=4 AND disenchantid=0 AND RequiredDisenchantSkill=100 AND class=4;UPDATE item_template SET DisenchantID=45 WHERE Quality=3 AND disenchantid=0 AND RequiredDisenchantSkill=125 AND class=4;UPDATE item_template SET DisenchantID=9 WHERE Quality=2 AND disenchantid=0 AND RequiredDisenchantSkill=175 AND class=4;UPDATE item_template SET DisenchantID=47 WHERE Quality=3 AND disenchantid=0 AND RequiredDisenchantSkill=175 AND class=4;UPDATE item_template SET DisenchantID=52 WHERE Quality=3 AND disenchantid=0 AND RequiredDisenchantSkill=275 AND class=4;UPDATE item_template SET DisenchantID=67 WHERE Quality=4 AND disenchantid=0 AND RequiredDisenchantSkill=300 AND class=4;UPDATE item_template SET DisenchantID=54 WHERE Quality=3 AND disenchantid=0 AND RequiredDisenchantSkill=325 AND class=4;UPDATE item_template SET DisenchantID=54 WHERE Quality=3 AND disenchantid=0 AND RequiredDisenchantSkill=325 AND class=2;UPDATE item_template SET DisenchantID=68 WHERE Quality=4 AND disenchantid=0 AND RequiredDisenchantSkill=375 AND class=4;UPDATE item_template SET DisenchantID=68 WHERE Quality=4 AND disenchantid=0 AND RequiredDisenchantSkill=375 AND class=2;