[help] Finding the logs useful

[ragezonerocks]

Many players keep breaking their items and tell me details of the item but i dont know how to find out if their telling the truth, i have backups but thats long way of finding out. Is there quick way of finding out if they break their item by upgrading and stuff?

[MentaL]

[Denichu]

SELECT * FROM -logname- WHERE -charactertable-='-charactername-'
example:
SELECT * FROM LOG_ITEM_TBL WHERE m_szName='Ragezonerocks'
use that query and execute it in ur LOG_01_DBF database

and if you want it to be more specific, you could also order it
SELECT * FROM LOG_ITEM_TBL WHERE m_szName='Ragezonerocks' ORDER BY Item_Name

It will put the Item_Name column in alphabetic order.
I hope this helped you :P