Page 1 of 1
Calculate the Historial of an user
Posted: Wed Mar 28, 2012 9:48 am
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
Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 10:58 am
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)
Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 11:13 am
by PokerMavenDeveloper
Ok when via api add or substract balance, how this action are registerec into the logs files?. Thanks a lot again
Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 11:16 am
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
Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 11:32 am
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)
Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 12:26 pm
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.
Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 12:28 pm
by PokerMavenDeveloper
excelent Thanks a lot
Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 10:54 pm
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.

Re: Calculate the Historial of an user
Posted: Wed Mar 28, 2012 11:41 pm
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.

Events are posted in chronological order. If you read them into your own database you can assign your own ID.
Re: Calculate the Historial of an user
Posted: Thu Mar 29, 2012 10:43 am
by PokerMavenDeveloper