Calculate the Historial of an user
-
- Posts: 66
- Joined: Fri Feb 24, 2012 5:11 pm
Calculate the Historial of an user
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
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: Calculate the Historial of an user
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.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
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)
-
- Posts: 66
- Joined: Fri Feb 24, 2012 5:11 pm
Re: Calculate the Historial of an user
Ok when via api add or substract balance, how this action are registerec into the logs files?. Thanks a lot again
-
- Posts: 66
- Joined: Fri Feb 24, 2012 5:11 pm
Re: Calculate the Historial of an user
ya ya UserPoker -1000 balance 378435 (API), my question in this point, ist posible to send an personalizated msg to the api action
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: Calculate the Historial of an user
Yes, every API command accepts an optional "Log" parameter that you can use to add custom text to the event log entry.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
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)
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: Calculate the Historial of an user
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.
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.
-
- Posts: 66
- Joined: Fri Feb 24, 2012 5:11 pm
Re: Calculate the Historial of an user
excelent Thanks a lot
-
- Posts: 66
- Joined: Fri Feb 24, 2012 5:11 pm
Re: Calculate the Historial of an user
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.
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: Calculate the Historial of an user
Events are posted in chronological order. If you read them into your own database you can assign your own ID.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.
-
- Posts: 66
- Joined: Fri Feb 24, 2012 5:11 pm
Re: Calculate the Historial of an user
That is the result of my process