Table `items`

All tables · Home

id	name_loc0	quality	item_class	item_subclass	item_level	required_level	inventory_type	bonding	flags	display_id	armor	dmg_min	dmg_max	delay	max_durability	icon_string
17	Martin Fury	6	4	4	5	0	4	0	0	7016	0	0	0	0	0	display:7016
25	Worn Shortsword	1	2	7	2	1	21	0	0	1542	0	1	3	1900	20	display:1542
35	Bent Staff	1	2	10	2	1	17	0	0	472	0	3	5	2900	25	display:472
36	Worn Mace	1	2	4	2	1	21	0	0	5194	0	1	3	1900	20	display:5194
37	Worn Axe	1	2	0	2	1	21	0	0	14029	0	1	3	2000	20	display:14029
38	Recruit's Shirt	1	4	0	1	0	4	0	0	9891	0	0	0	0	0	display:9891
39	Recruit's Pants	0	4	1	1	1	7	0	0	9892	2	0	0	0	25	display:9892
40	Recruit's Boots	1	4	0	1	0	8	0	0	10141	0	0	0	0	0	display:10141
41	OLDRecruit's Belt	1	4	0	1	1	6	0	16	4553	0	0	0	0	0	display:4553
42	OLDSquire's Belt	1	4	0	1	1	6	0	16	4562	0	0	0	0	0	display:4562
43	Squire's Boots	1	4	0	1	0	8	0	0	9938	0	0	0	0	0	display:9938
44	Squire's Pants	0	4	1	1	1	7	0	0	9937	2	0	0	0	25	display:9937
45	Squire's Shirt	1	4	0	1	0	4	0	0	3265	0	0	0	0	0	display:3265
46	OLDFootpad's Belt	1	4	0	1	1	6	0	16	4528	0	0	0	0	0	display:4528
47	Footpad's Shoes	1	4	0	1	0	8	0	0	9915	0	0	0	0	0	display:9915
48	Footpad's Pants	0	4	1	1	1	7	0	0	9913	2	0	0	0	25	display:9913
49	Footpad's Shirt	1	4	0	1	0	4	0	0	9906	0	0	0	0	0	display:9906
50	OLDInitiate's Belt	1	4	0	1	1	6	0	16	4535	0	0	0	0	0	display:4535
51	Neophyte's Boots	1	4	0	1	0	8	0	0	9946	0	0	0	0	0	display:9946
52	Neophyte's Pants	0	4	1	1	1	7	0	0	9945	2	0	0	0	25	display:9945
53	Neophyte's Shirt	1	4	0	1	0	4	0	0	9944	0	0	0	0	0	display:9944
54	OLDNovice's Belt	1	4	0	1	1	6	0	16	4541	0	0	0	0	0	display:4541
55	Apprentice's Boots	1	4	0	1	0	8	0	0	9929	0	0	0	0	0	display:9929
56	Apprentice's Robe	0	4	1	1	1	20	0	0	12647	3	0	0	0	35	display:12647
57	Acolyte's Robe	0	4	1	1	1	20	0	0	12645	3	0	0	0	35	display:12645
58	OLDAcolyte's Belt	1	4	0	1	1	6	0	16	4499	0	0	0	0	0	display:4499
59	Acolyte's Shoes	1	4	0	1	0	8	0	0	3261	0	0	0	0	0	display:3261
60	Layered Tunic	1	4	2	5	0	5	1	0	16891	33	0	0	0	45	display:16891
61	Dwarven Leather Pants	1	4	2	5	0	7	1	0	16953	29	0	0	0	35	display:16953
77	Deprecated Outfitter Cloth Armor	1	4	1	4	0	5	0	16	2645	8	0	0	0	35	display:2645
79	Dwarven Cloth Britches	1	4	1	5	0	7	1	0	16847	9	0	0	0	30	display:16847
80	Soft Fur-lined Shoes	1	4	1	5	0	8	1	0	16854	7	0	0	0	20	display:16854
85	Dirty Leather Vest	1	4	2	5	1	5	0	0	16883	33	0	0	0	45	display:16883
86	Deprecated Old Belt	1	4	0	1	0	6	0	16	4525	0	0	0	0	0	display:4525
87	Deprecated Old Boots	1	4	0	1	0	8	0	16	261	0	0	0	0	0	display:261
88	Deprecated Old Pants	0	4	1	1	1	7	0	16	374	0	0	0	0	0	display:374
89	OLDThick Trapper's Shirt	1	4	0	1	0	4	0	16	7848	0	0	0	0	0	display:7848
90	OLDDwarven Initiate's Belt	1	4	0	1	1	6	0	16	4519	0	0	0	0	0	display:4519
91	OLDDwarven Initiate's Pants	0	4	1	1	1	7	0	16	368	0	0	0	0	0	display:368
92	OLDDwarven Initiate's Boots	1	4	0	1	1	8	0	16	249	0	0	0	0	0	display:249
93	OLDDwarven Initiate's Shirt	1	4	0	1	0	4	0	16	369	0	0	0	0	0	display:369
94	Deprecated Dwarven Novice's Belt	1	4	0	1	1	6	0	16	4522	0	0	0	0	0	display:4522
95	Deprecated Dwarven Novice's Boots	1	4	0	1	1	8	0	16	242	0	0	0	0	0	display:242
97	Deprecated Dwarven Novice's Robe	0	4	1	1	1	20	0	16	12662	3	0	0	0	35	display:12662
98	Deprecated Dwarven Squire's Belt	1	4	0	1	1	6	0	16	4524	0	0	0	0	0	display:4524
99	Deprecated Dwarven Squire's Boots	1	4	0	1	1	8	0	16	257	0	0	0	0	0	display:257
100	Deprecated Dwarven Squire's Pants	0	4	1	1	1	7	0	16	372	2	0	0	0	25	display:372
101	Deprecated Dwarven Squire's Shirt	1	4	0	1	0	4	0	16	373	0	0	0	0	0	display:373
102	Deprecated Dwarven Recruit's Belt	1	4	0	1	1	6	0	16	4523	0	0	0	0	0	display:4523
103	Deprecated Dwarven Recruit's Boots	1	4	0	1	1	8	0	16	5901	0	0	0	0	0	display:5901
104	Deprecated Sturdy Brown Pants	0	4	1	1	1	7	0	16	370	2	0	0	0	25	display:370
105	Deprecated Dwarven Recruit's Shirt	1	4	0	1	0	4	0	16	371	0	0	0	0	0	display:371
113	Deprecated Dwarven Apprentice Pants	0	4	1	1	1	7	0	16	365	2	0	0	0	25	display:365
114	Deprecated Dwarven Apprentice Boots	1	4	0	1	1	8	0	16	245	0	0	0	0	0	display:245
115	Deprecated Dwarven Apprentice Belt	1	4	0	1	1	6	0	16	4517	0	0	0	0	0	display:4517
117	Tough Jerky	1	0	5	5	1	0	0	0	2473	0	0	0	0	0	display:2473
118	Minor Healing Potion	1	0	1	5	1	0	0	0	15710	0	0	0	0	0	display:15710
119	Deprecated Rogue's Vest	1	4	0	1	0	4	0	0	5702	0	0	0	0	0	display:5702
120	Thug Pants	0	4	1	1	1	7	0	0	10006	2	0	0	0	25	display:10006
121	Thug Boots	1	4	0	1	0	8	0	0	10008	0	0	0	0	0	display:10008
122	OLDThug Belt	1	4	0	1	1	6	0	16	4538	0	0	0	0	0	display:4538
123	Deprecated Orc Apprentice Shirt	1	4	0	1	0	4	0	16	383	0	0	0	0	0	display:383
124	Deprecated Orc Apprentice Pants	0	4	1	1	1	7	0	16	3268	2	0	0	0	25	display:3268
125	Deprecated Orc Apprentice Boots	1	4	0	1	1	8	0	16	3269	0	0	0	0	0	display:3269
126	Deprecated Orc Apprentice Belt	1	4	0	1	1	6	0	16	4543	0	0	0	0	0	display:4543
127	Trapper's Shirt	1	4	0	1	0	4	0	0	9996	0	0	0	0	0	display:9996
128	Deprecated Tauren Trapper's Pants	0	4	1	1	1	7	0	16	396	2	0	0	0	25	display:396
129	Rugged Trapper's Boots	1	4	0	1	0	8	0	0	9977	0	0	0	0	0	display:9977
130	Deprecated Tauren Trapper's Belt	1	4	0	1	1	6	0	16	4572	0	0	0	0	0	display:4572
131	Deprecated Orc Acolyte's Belt	1	4	0	1	1	6	0	16	4542	0	0	0	0	0	display:4542
132	Deprecated Orc Acolyte's Boots	1	4	0	1	1	8	0	16	295	0	0	0	0	0	display:295
133	Deprecated Orc Acolyte's Shirt	1	4	0	1	0	4	0	16	7912	0	0	0	0	0	display:7912
134	Deprecated Stiff Leather Shirt	1	4	0	1	0	4	0	16	387	0	0	0	0	0	display:387
135	Deprecated Stiff Leather Pants	0	4	1	1	1	7	0	16	386	2	0	0	0	25	display:386
136	Deprecated Old Leather Boots	1	4	0	1	0	8	0	16	311	0	0	0	0	0	display:311
137	OLDNeophyte's Belt	1	4	0	1	1	6	0	16	4540	0	0	0	0	0	display:4540
138	Deprecated War Harness	1	4	0	1	0	4	0	0	9346	0	0	0	0	0	display:9346
139	Brawler's Pants	0	4	1	1	1	7	0	0	9988	2	0	0	0	25	display:9988
140	Brawler's Boots	1	4	0	1	0	8	0	0	9992	0	0	0	0	0	display:9992
141	OLDBrawler's Belt	1	4	0	1	1	6	0	16	4507	0	0	0	0	0	display:4507
143	Monster - Shield, Stormwind Guard	0	4	6	1	1	14	0	0	2080	0	0	0	0	0	display:2080
146	OLDRugged Trapper's Belt	1	4	0	1	1	6	0	16	4544	0	0	0	0	0	display:4544
147	Rugged Trapper's Pants	0	4	1	1	1	7	0	0	9975	2	0	0	0	25	display:9975
148	Rugged Trapper's Shirt	1	4	0	1	0	4	0	0	9976	0	0	0	0	0	display:9976
149	Deprecated Tauren Apprentice Belt	1	4	0	1	0	6	0	16	4569	0	0	0	0	0	display:4569
150	Deprecated Tauren Apprentice Pants	0	4	1	1	1	7	0	16	392	2	0	0	0	25	display:392
151	Deprecated Tauren Apprentice Shirt	1	4	0	1	0	4	0	16	393	0	0	0	0	0	display:393
152	OLDPrimitive Leather Belt	1	4	0	1	1	6	0	16	4570	0	0	0	0	0	display:4570
153	Primitive Kilt	0	4	2	1	1	7	0	0	10050	14	0	0	0	30	display:10050
154	Primitive Mantle	1	4	0	1	0	4	0	0	10058	0	0	0	0	0	display:10058
155	Deprecated Tauren Recruit's Belt	1	4	0	1	1	6	0	16	4571	0	0	0	0	0	display:4571
156	Deprecated Tauren Recruit's Pants	0	4	1	1	1	7	0	16	394	0	0	0	0	0	display:394
157	Deprecated Tauren Recruit's Shirt	1	4	0	1	0	4	0	16	395	0	0	0	0	0	display:395
159	Refreshing Spring Water	1	0	5	5	1	0	0	0	18084	0	0	0	0	0	display:18084
182	Garrick's Head	1	12	0	1	0	0	4	2048	7038	0	0	0	0	0	display:7038
184	Deprecated Small Brown Pouch	1	1	0	5	0	18	0	16	362	0	0	0	0	0	display:362
192	Martin's Broken Staff	0	2	14	75	0	21	1	0	5279	100	8	17	500	0	display:5279
193	Tattered Cloth Vest	1	4	1	5	1	5	0	0	16579	10	0	0	0	40	display:16579
194	Tattered Cloth Pants	1	4	1	5	1	7	0	0	16580	9	0	0	0	30	display:16580
195	Tattered Cloth Boots	1	4	1	5	1	8	0	0	16582	7	0	0	0	20	display:16582

Table items

Table `items`