Get T1 to T6 item IDs

Get T1 to T6 item IDs 2022-12-23

Get T1 to T6 item IDs
See spoiler below:

SQL:
SQL:
--[[ SQL Made by CyberMist2]]--
 
-- Get Tier : 1
SELECT * FROM item_template WHERE itemset IN
(/*druid=*/205,/*hunter =*/206,/*mage=*/201,/*paladin=*/208,/*priest=*/202,/*rogue=*/204,/*shaman=*/207,/*warlock=*/203,/*warrior=*/209);
 
-- Get Tier : 2
SELECT * FROM item_template WHERE itemset IN
(/*druid=*/214,/*hunter=*/215,/*mage=*/210,/*paladin=*/217,/*priest=*/211,/*rogue=*/213,/*shaman=*/216,/*warlock=*/212,/*warrior=*/218);
 
-- Get Tier : 3
SELECT * FROM item_template WHERE itemset IN
(/*druid=*/521,/*hunter=*/530,/*mage=*/526,/*paladin=*/528,/*priest=*/525,/*rogue=*/524,/*shaman=*/527,/*warlock=*/529,/*warrior=*/523);
 
-- Get Tier : 4
SELECT * FROM item_template WHERE itemset IN
(/*druid=*/638, 639, 640,/*hunter=*/651,/*mage=*/648,/*paladin=*/624, 625, 626,/*priest=*/663, 664,/*rogue=*/621,/*shaman=*/631, 632, 633,/*warlock=*/645,/*warrior=*/654, 655);
 
-- Get Tier : 5
SELECT * FROM item_template WHERE itemset IN
(/*druid=*/641, 642, 643,/*hunter=*/652,/*mage=*/649,/*paladin=*/627, 628, 629,/*priest=*/665, 666,/*rogue=*/622,/*shaman=*/634, 635, 636,/*warlock=*/646,/*warrior=*/656, 657);
 
-- Get Tier : 6
SELECT * FROM item_template WHERE itemset IN
(/*druid=*/676, 677, 678,/*hunter=*/669,/*mage=*/671,/*paladin=*/679, 680, 681,/*priest=*/674, 675,/*rogue=*/668,/*shaman=*/682, 683, 684,/*warlock=*/670,/*warrior=*/672, 673);
Register & Get access to index
CyberMist
Author CyberMist Romania
Mythical

Posts

253

Likes

273

Resources

25

Version 2022-12-23
Downloads 4
Views 600
Last Update
0.00 star(s) 0 ratings
None

3,382

1,252

9,526

410

Top