Need ethreal stuff's IDs

Use a MSSQL SELECT query, include Arcadia.dbo.ItemResource and Arcadia.dbo.StringResource, then ORDER BY whateveryouwant.

1. Sorted by CODE (shows the weapons etc. from rank 1-7 etc.):

Code:

SELECT item.id, item.name_id, item.rank, item.use_min_level, string.value 
FROM Arcadia.dbo.ItemResource item, Arcadia.dbo.StringResource string
WHERE item.name_id = string.code
ORDER BY id ASC

2. Sorted by VALUE (shows all dura items in a row):

Code:

SELECT item.id, item.name_id, item.rank, item.use_min_level, string.value 
FROM Arcadia.dbo.ItemResource item, Arcadia.dbo.StringResource string
WHERE item.name_id = string.code
ORDER BY value ASC

If you are looking for the MC weapons, you should use query 1, then scroll down until you find a row with the value "?????? ????".
This row should be behind the t1/t2/t3 weapons of that type (2H mace and so on).

With query 2, the dura items are sorted by their name (alphabetical).

Greez,

Ciel