-- armor: 1,2,3,4,5,6,7,8,9,10,11,12,16,18,19,20,27
  -- wpn:  13,14,15,17,21,22,23,24,25,26,28
  -- green armors
  UPDATE item_template SET DisenchantID = 1 WHERE quality = 2 AND ItemLevel >4 AND ItemLevel < 16 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 2 WHERE quality = 2 AND ItemLevel >15 AND ItemLevel < 21 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 3 WHERE quality = 2 AND ItemLevel >20 AND ItemLevel < 26 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 4 WHERE quality = 2 AND ItemLevel >25 AND ItemLevel < 31 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 5 WHERE quality = 2 AND ItemLevel >30 AND ItemLevel < 36 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 6 WHERE quality = 2 AND ItemLevel >35 AND ItemLevel < 41 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 7 WHERE quality = 2 AND ItemLevel >40 AND ItemLevel < 46 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 8 WHERE quality = 2 AND ItemLevel >45 AND ItemLevel < 51 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 9 WHERE quality = 2 AND ItemLevel >50 AND ItemLevel < 56 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 10 WHERE quality = 2 AND ItemLevel >55 AND ItemLevel < 61 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 11 WHERE quality = 2 AND ItemLevel >60 AND ItemLevel < 66 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 12 WHERE quality = 2 AND ItemLevel >65 AND ItemLevel < 81 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 13 WHERE quality = 2 AND ItemLevel >80 AND ItemLevel < 100 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 14 WHERE quality = 2 AND ItemLevel >99  AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 14 WHERE entry in (31777,24662,31439) AND RequiredDisenchantSkill > '-1';
  -- green wpns, quality2 wpn: 20086, lvl52
  UPDATE item_template SET DisenchantID = 21 WHERE quality = 2 AND ItemLevel >10 AND ItemLevel < 26 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 22 WHERE quality = 2 AND ItemLevel >25 AND ItemLevel < 31 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 23 WHERE quality = 2 AND ItemLevel >30 AND ItemLevel < 36 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 24 WHERE quality = 2 AND ItemLevel >35 AND ItemLevel < 41 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 25 WHERE quality = 2 AND ItemLevel >40 AND ItemLevel < 46 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 26 WHERE quality = 2 AND ItemLevel >45 AND ItemLevel < 51 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 27 WHERE quality = 2 AND ItemLevel >50 AND ItemLevel < 56 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 28 WHERE quality = 2 AND ItemLevel >45 AND ItemLevel < 51 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 29 WHERE quality = 2 AND ItemLevel >50 AND ItemLevel < 56 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 30 WHERE quality = 2 AND ItemLevel >55 AND ItemLevel < 61 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 31 WHERE quality = 2 AND ItemLevel >60 AND ItemLevel < 66 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 32 WHERE quality = 2 AND ItemLevel >65 AND ItemLevel < 100 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 33 WHERE quality = 2 AND ItemLevel >99 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template set DisenchantId=29 WHERE entry=52 and RequiredDisenchantSkill>'-1';
  UPDATE item_template set DisenchantId=33 WHERE entry=25126 and RequiredDisenchantSkill>'-1';
  -- rarez
  UPDATE item_template SET DisenchantID = 41 WHERE quality = 3 AND ItemLevel >10 AND ItemLevel < 26 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 42 WHERE quality = 3 AND ItemLevel >25 AND ItemLevel < 31 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 43 WHERE quality = 3 AND ItemLevel >30 AND ItemLevel < 36 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 44 WHERE quality = 3 AND ItemLevel >35 AND ItemLevel < 41 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 45 WHERE quality = 3 AND ItemLevel >40 AND ItemLevel < 46 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 46 WHERE quality = 3 AND ItemLevel >45 AND ItemLevel < 51 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 47 WHERE quality = 3 AND ItemLevel >50 AND ItemLevel < 56 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 48 WHERE quality = 3 AND ItemLevel >55 AND ItemLevel < 66 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 49 WHERE quality = 3 AND ItemLevel >65 AND ItemLevel < 71 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 50 WHERE quality = 3 AND ItemLevel >70 AND ItemLevel < 100 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 52 WHERE quality = 3 AND ItemLevel >99 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template set DisenchantId=51 WHERE entry in (23835,23836,25653,32863,32782) and RequiredDisenchantSkill>'-1';
  UPDATE item_template SET DisenchantID = 52 WHERE RequiredDisenchantSkill > '-1' or entry=31215;
 -- epixor
 UPDATE item_template SET DisenchantID = 61 WHERE quality = 4 AND ItemLevel >39 AND ItemLevel < 46 AND RequiredDisenchantSkill > '-1';
 UPDATE item_template SET DisenchantID = 62 WHERE quality = 4 AND ItemLevel >45 AND ItemLevel < 51 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 63 WHERE quality = 4 AND ItemLevel >50 AND ItemLevel < 56 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 64 WHERE quality = 4 AND ItemLevel >55 AND ItemLevel < 61 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 65 WHERE quality = 4 AND ItemLevel >60 AND ItemLevel < 95 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 66 WHERE quality = 4 AND ItemLevel >94 AND ItemLevel < 101 AND RequiredDisenchantSkill > '-1';
  UPDATE item_template SET DisenchantID = 67 WHERE quality = 4 AND ItemLevel >100 AND RequiredDisenchantSkill > '-1';