itemid list?

[wootpeng]

Does anyone have a full list with item names + itemid's?

[stoneharry]

SELECT entry,name FROM item_template ORDER BY entry ASC;

[wootpeng]

SELECT entry,name FROM item_template ORDER BY entry ASC;

I actually don't have an emu server I was hoping that you guys might have a list since I have hit a dead end everywhere else.

[stoneharry]

I actually don't have an emu server I was hoping that you guys might have a list since I have hit a dead end everywhere else.

For what patch? 3.3.5a we have the full item list but for more recent patches you will have to have a bot crawl WoWHead.

[wootpeng]

Alright, thanks for your help.