TrinityCore/TrinityCore — Issue #4683: PvP Items (200-277) DisenchantId/RequireDisenchantSkill
Author: mweinelt
Created: 2012-01-07 00:20:18+00:00
State: open

I noticed none of the WotLK PvP Items were disenchantable, so I tried and find all of them and give them their correct DisenchantId + RequiredDisenchantSkill.

This is completely up for discussion, as I have not gone through all the items to see if they were correct.

Basically I structured it like this:
1 Abyssal Shard from:
- Hateful 200
- Deadly 213
- Furious 232
- Relentless (Non-Set, Low-Level Weapons) 245
- Wrathful (Non-Set, Low-Level Weapons) 264

1-2 Abyssal Shards from:
- Relentless (Set, High-Level Weapons) 251 / 258
- Wrathful (Set, High-Level-Weapons) 270 / 277

The Disenchant-Skill for all of them is 375.

```mysql
-- hateful (200), deadly (213), furious (226-239)
-- disenchants into 1 abyssal shard
UPDATE `item_template`
SET `DisenchantId` = 68
WHERE `entry` IN (
SELECT `entry` FROM (
SELECT `entry`
FROM `item_template`
WHERE `name` LIKE '% Gladiator\'s%'
AND quality > 3
AND ItemLevel >= 200 AND ItemLevel <= 239
) AS `entry`
);

-- relentless offparts (245), low-level weapons (245)
-- also disenchant into 1 abyssal shard
UPDATE `item_template`
SET `DisenchantId` = 68
WHERE `entry` IN (
SELECT `entry` FROM (
SELECT `entry`
FROM `item_template`
WHERE `name` LIKE '% Gladiator\'s%'
AND quality > 3
AND ItemLevel = 245
) AS `entry`
);

-- wrathful off-parts (264)
-- disenchant into 1 abyssal shard
UPDATE `item_template`
SET `DisenchantId` = 68
WHERE `entry` IN (
SELECT `entry` FROM (
SELECT `entry`
FROM `item_template`
WHERE `name` LIKE '% Gladiator\'s%'
AND quality > 3
AND ItemLevel = 264
AND InventoryType NOT IN (1, 3, 5, 7, 10)
) AS `entry`
);

-- relentless set (251), high-end weapons (258), wrathful set (270), wrathful highend-weapons (277)
-- disenchant into 1-2 abyssal shards
UPDATE `item_template`
SET `DisenchantId` = 69
WHERE `entry` IN (
SELECT `entry` FROM (
SELECT `entry`
FROM `item_template`
WHERE `name` LIKE '% Gladiator\'s%'
AND quality > 3
AND ItemLevel IN (251, 258, 270)
) AS `entry`
);
```