Fexy
11.05.2011, 12:48
Hi all.
here is my question
In the mangos characters DB there is a table called item_instance and one of the fields (the "data") is a logtext filed.
For one of the characters it looks like this:
514 1073741824 3 2650 1065353216 0 19 0 19 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 25 0 0
Is there a quick way to extract the 4th element from this log? or maybe more just in case needed, but the 4th one is the most important cuz it's the item's ID.
I want to save all the owner_guid and itemID values in a different DB.
pls help.
Thanks
here is my question
In the mangos characters DB there is a table called item_instance and one of the fields (the "data") is a logtext filed.
For one of the characters it looks like this:
514 1073741824 3 2650 1065353216 0 19 0 19 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 25 0 0
Is there a quick way to extract the 4th element from this log? or maybe more just in case needed, but the 4th one is the most important cuz it's the item's ID.
I want to save all the owner_guid and itemID values in a different DB.
pls help.
Thanks