victorfa1 Posted October 23, 2012 Group: Members Topic Count: 53 Topics Per Day: 0.01 Content Count: 126 Reputation: 1 Joined: 09/14/12 Last Seen: February 10, 2015 Share Posted October 23, 2012 is there any way that i can check the log of trades of the players of my server? @edit.. bump Quote Link to comment Share on other sites More sharing options...
Bin4ry Posted October 23, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Share Posted October 23, 2012 Enable log in conf/inter.conf Quote Link to comment Share on other sites More sharing options...
victorfa1 Posted October 23, 2012 Group: Members Topic Count: 53 Topics Per Day: 0.01 Content Count: 126 Reputation: 1 Joined: 09/14/12 Last Seen: February 10, 2015 Author Share Posted October 23, 2012 wrong.. there's no "Trade Log" Quote Link to comment Share on other sites More sharing options...
Aleos Posted October 23, 2012 Group: Development Manager Topic Count: 56 Topics Per Day: 0.01 Content Count: 732 Reputation: 525 Joined: 12/13/11 Last Seen: June 13, 2024 Share Posted October 23, 2012 Go to conf/log_athena.conf and look for enable_logs. You will see the list of different values you can set it to. Below that you will find other config changes so that you don't log every possible item, unless you're wanting to. Everything is stored in your logs schema in the picklog table. Quote Link to comment Share on other sites More sharing options...
Bin4ry Posted October 24, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Share Posted October 24, 2012 Thanks Aleos for correcting Quote Link to comment Share on other sites More sharing options...
victorfa1 Posted October 24, 2012 Group: Members Topic Count: 53 Topics Per Day: 0.01 Content Count: 126 Reputation: 1 Joined: 09/14/12 Last Seen: February 10, 2015 Author Share Posted October 24, 2012 this is so much complicaded to check... its VERY mixed is there anyway that i can check.. for example who gaves the x item for whom? Quote Link to comment Share on other sites More sharing options...
Bin4ry Posted October 24, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Share Posted October 24, 2012 (edited) Learn how to query your SQL. Like: SELECT * FROM tradelog WHERE nameid='512' Edit: This would query all trade related to Apple from trade log. Edited October 24, 2012 by darristan 1 Quote Link to comment Share on other sites More sharing options...
Aleos Posted October 24, 2012 Group: Development Manager Topic Count: 56 Topics Per Day: 0.01 Content Count: 732 Reputation: 525 Joined: 12/13/11 Last Seen: June 13, 2024 Share Posted October 24, 2012 (edited) Unfortunately that's all we have. Having the items log stored in one table is not my opinion of being the best solution, but it has been like this for years. You can go about it and modify the source to separate the pick logging into separate tables if you wish though. As for specific searching, you will need to know what exactly you are looking for (ie: player ID, item ID, log type). So if you are looking for an Apple by player 1 who traded it, then make sure you run something like: SELECT * FROM tradelog WHERE `char_id` = '1' AND `type` = 'T' AND `nameid` = '512' AND `amount` = '-1' Giving a negative amount means it was removed from the player, storage, etc. Of course the amount can be anything. So if they had 34 Apples and traded them all it would have been -34. Edited October 24, 2012 by Aleos Quote Link to comment Share on other sites More sharing options...
victorfa1 Posted October 25, 2012 Group: Members Topic Count: 53 Topics Per Day: 0.01 Content Count: 126 Reputation: 1 Joined: 09/14/12 Last Seen: February 10, 2015 Author Share Posted October 25, 2012 acctualy theres a server that allow all players check their log trades... it looks like tables Quote Link to comment Share on other sites More sharing options...
Bin4ry Posted October 25, 2012 Group: Members Topic Count: 30 Topics Per Day: 0.01 Content Count: 782 Reputation: 82 Joined: 01/01/12 Last Seen: September 21, 2015 Share Posted October 25, 2012 MySQL is the server, and it contain the tables. Where were you talking about? Quote Link to comment Share on other sites More sharing options...
victorfa1 Posted October 25, 2012 Group: Members Topic Count: 53 Topics Per Day: 0.01 Content Count: 126 Reputation: 1 Joined: 09/14/12 Last Seen: February 10, 2015 Author Share Posted October 25, 2012 i dont mean THAT mysql tables... and im talking about another server... on CP they show their players their log trades Quote Link to comment Share on other sites More sharing options...
Question
victorfa1
is there any way that i can check the log of trades of the players of my server?
@edit..
bump
Link to comment
Share on other sites
10 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.