Profile Posted September 3, 2017 Group: Members Topic Count: 24 Topics Per Day: 0.01 Content Count: 77 Reputation: 1 Joined: 04/15/17 Last Seen: January 4, 2021 Share Posted September 3, 2017 (edited) 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 Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted September 13, 2017 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: Thursday at 01:08 PM Share Posted September 13, 2017 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 Quote Link to comment Share on other sites More sharing options...
0 Cyro Posted September 3, 2017 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 1137 Reputation: 290 Joined: 04/29/13 Last Seen: January 9, 2023 Share Posted September 3, 2017 All trade, drop logs will be logged in picklog Quote Link to comment Share on other sites More sharing options...
0 Profile Posted September 3, 2017 Group: Members Topic Count: 24 Topics Per Day: 0.01 Content Count: 77 Reputation: 1 Joined: 04/15/17 Last Seen: January 4, 2021 Author Share Posted September 3, 2017 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. Quote Link to comment Share on other sites More sharing options...
0 Cyro Posted September 3, 2017 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 1137 Reputation: 290 Joined: 04/29/13 Last Seen: January 9, 2023 Share Posted September 3, 2017 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 Quote Link to comment Share on other sites More sharing options...
0 Profile Posted September 4, 2017 Group: Members Topic Count: 24 Topics Per Day: 0.01 Content Count: 77 Reputation: 1 Joined: 04/15/17 Last Seen: January 4, 2021 Author Share Posted September 4, 2017 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 Quote Link to comment Share on other sites More sharing options...
0 Profile Posted September 14, 2017 Group: Members Topic Count: 24 Topics Per Day: 0.01 Content Count: 77 Reputation: 1 Joined: 04/15/17 Last Seen: January 4, 2021 Author Share Posted September 14, 2017 Thanks! Quote Link to comment Share on other sites More sharing options...
Question
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 by ProfileLink to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.