Calculate the Historial of an user

Add your suggestions for improving Poker Mavens
Post Reply
PokerMavenDeveloper
Posts: 66
Joined: Fri Feb 24, 2012 5:11 pm

Calculate the Historial of an user

Post by PokerMavenDeveloper »

Hi, the log files provide an excelent information about the actionts taken in the poker server, i need to calculate the debit and credit per user, the log file register the balance and any api action but its very dificult to use this information, what do you recommend Thanks
Kent Briggs
Site Admin
Posts: 5880
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Post by Kent Briggs »

PokerMavenDeveloper wrote:Hi, the log files provide an excelent information about the actionts taken in the poker server, i need to calculate the debit and credit per user, the log file register the balance and any api action but its very dificult to use this information, what do you recommend Thanks
The event log does record every debit and credit transaction. It shows the date and time, the account name, how many chips were added (+) or subtracted (-), the current balance, and where it occurred (table name, etc.). You should be able to parse through the logs and easily pull this info out and then import it into your own database. Then produce your own reports from there via SQL queries.

Examples:

2012-03-27 17:01:58|Account|pm2 +20 balance 10175 (Tournament #1)
2012-03-27 17:02:57|Account|pm1 -5 balance 8301 (Tournament #5)
2012-03-28 10:46:58|Account|pm1 -100 balance 8305 (Transfer)
2012-03-28 10:46:58|Account|pm2 +100 balance 10168 (Transfer)
PokerMavenDeveloper
Posts: 66
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Post by PokerMavenDeveloper »

Ok when via api add or substract balance, how this action are registerec into the logs files?. Thanks a lot again
PokerMavenDeveloper
Posts: 66
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Post by PokerMavenDeveloper »

ya ya UserPoker -1000 balance 378435 (API), my question in this point, ist posible to send an personalizated msg to the api action
Kent Briggs
Site Admin
Posts: 5880
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Post by Kent Briggs »

PokerMavenDeveloper wrote:ya ya UserPoker -1000 balance 378435 (API), my question in this point, ist posible to send an personalizated msg to the api action
Yes, every API command accepts an optional "Log" parameter that you can use to add custom text to the event log entry.

Example:

http://127.0.0.1:8087/api?Command=Syste ... 20a%20test

Event Log:

2012-03-28 11:30:10|API|SystemStats from 127.0.0.1 (This is a test)
Kent Briggs
Site Admin
Posts: 5880
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Post by Kent Briggs »

Also, there is a standalone API command that performs no function except to add an entry to the event log. From the help file:

LogsAddEvent - adds a line to the Event Log without performing any other command. Use the Log parameter to append custom text to the entry. Note that this Log parameter is an option with all of the other API commands, also.
PokerMavenDeveloper
Posts: 66
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Post by PokerMavenDeveloper »

excelent Thanks a lot
PokerMavenDeveloper
Posts: 66
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Post by PokerMavenDeveloper »

I build a process to calculate debit and credit per user, but i had a little problem, the process can be dupliccated the info, its possible to add an Id to each line in the log file? like a consecutive number. :roll:
Kent Briggs
Site Admin
Posts: 5880
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Post by Kent Briggs »

PokerMavenDeveloper wrote:I build a process to calculate debit and credit per user, but i had a little problem, the process can be dupliccated the info, its possible to add an Id to each line in the log file? like a consecutive number. :roll:
Events are posted in chronological order. If you read them into your own database you can assign your own ID.
PokerMavenDeveloper
Posts: 66
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Post by PokerMavenDeveloper »

That is the result of my process :D :D :D
Image
Post Reply