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
