Item logs

[Profile]

Hi, recently some of my players had issues with item loss.

I have tried looking at the database logs in search for the items, but I can't seem to find them.

Here are the tables I have on the logs folder. Isn't there supposed to be a droplog, tradelog and others?

Also, how can I find how many of a specific item there are on the server?

This might be a simple question, but it's something I'm having difficulties with. Thanks!

Edited September 3, 2017 by Profile

[Emistry]

On 04/09/2017 at 10:58 PM, Profile said:

So it's controlled with the "Type" column?

I guess "T" represents TRADE, is there anywhere I can see what each letter represents?

Thank you

sql-files/logs.sql#L142-L167

[Cyro]

All trade, drop logs will be logged in picklog

[Profile]

10 minutes ago, Cyro said:

All trade, drop logs will be logged in picklog

I see, so it is all stored in one place.

How do I find out how this item was obtained? if it was traded (and which who) or picked up etc...

Thanks.

[Cyro]

You can search them.from query SQL or search 

Something like this

SELECT * FROM picklog WHERE `char_id` = '1' AND `type` = 'T' AND `nameid` = '512' AND `amount` = '-1'

 

 

-1 is represents item taken out from player

[Profile]

So it's controlled with the "Type" column?

I guess "T" represents TRADE, is there anywhere I can see what each letter represents?

Thank you

[Profile]

Thanks!