Jump to content
  • 0

Trade log


victorfa1

Question


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

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


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

Enable log in conf/inter.conf

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

wrong.. there's no "Trade Log"

Link to comment
Share on other sites


  • Group:  Development Manager
  • Topic Count:  56
  • Topics Per Day:  0.01
  • Content Count:  732
  • Reputation:   525
  • Joined:  12/13/11
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

Thanks Aleos for correcting :P

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

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?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

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 by darristan
  • Like 1
Link to comment
Share on other sites


  • Group:  Development Manager
  • Topic Count:  56
  • Topics Per Day:  0.01
  • Content Count:  732
  • Reputation:   525
  • Joined:  12/13/11
  • Last Seen:  

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 by Aleos
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

acctualy theres a server that allow all players check their log trades... it looks like tables

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  

MySQL is the server, and it contain the tables. Where were you talking about?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  53
  • Topics Per Day:  0.01
  • Content Count:  126
  • Reputation:   1
  • Joined:  09/14/12
  • Last Seen:  

i dont mean THAT mysql tables... and im talking about another server... on CP they show their players their log trades

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...