Calculate the Historial of an user

Add your suggestions for improving Poker Mavens

Calculate the Historial of an user

Postby PokerMavenDeveloper » Wed Mar 28, 2012 9:48 am

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
PokerMavenDeveloper
 
Posts: 62
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Postby Kent Briggs » Wed Mar 28, 2012 10:58 am

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)
Kent Briggs - kbriggs@briggsoft.com
Briggs Softworks - http://www.briggsoft.com
Kent Briggs
Site Admin
 
Posts: 2061
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Postby PokerMavenDeveloper » Wed Mar 28, 2012 11:13 am

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

Re: Calculate the Historial of an user

Postby PokerMavenDeveloper » Wed Mar 28, 2012 11:16 am

ya ya UserPoker -1000 balance 378435 (API), my question in this point, ist posible to send an personalizated msg to the api action
PokerMavenDeveloper
 
Posts: 62
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Postby Kent Briggs » Wed Mar 28, 2012 11:32 am

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=SystemStats&Password=123456&Log=This%20is%20a%20test

Event Log:

2012-03-28 11:30:10|API|SystemStats from 127.0.0.1 (This is a test)
Kent Briggs - kbriggs@briggsoft.com
Briggs Softworks - http://www.briggsoft.com
Kent Briggs
Site Admin
 
Posts: 2061
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Postby Kent Briggs » Wed Mar 28, 2012 12:26 pm

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.
Kent Briggs - kbriggs@briggsoft.com
Briggs Softworks - http://www.briggsoft.com
Kent Briggs
Site Admin
 
Posts: 2061
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Postby PokerMavenDeveloper » Wed Mar 28, 2012 12:28 pm

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

Re: Calculate the Historial of an user

Postby PokerMavenDeveloper » Wed Mar 28, 2012 10:54 pm

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:
PokerMavenDeveloper
 
Posts: 62
Joined: Fri Feb 24, 2012 5:11 pm

Re: Calculate the Historial of an user

Postby Kent Briggs » Wed Mar 28, 2012 11:41 pm

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.
Kent Briggs - kbriggs@briggsoft.com
Briggs Softworks - http://www.briggsoft.com
Kent Briggs
Site Admin
 
Posts: 2061
Joined: Wed Mar 19, 2008 8:47 pm

Re: Calculate the Historial of an user

Postby PokerMavenDeveloper » Thu Mar 29, 2012 10:43 am

That is the result of my process :D :D :D
Image
PokerMavenDeveloper
 
Posts: 62
Joined: Fri Feb 24, 2012 5:11 pm


Return to Wish List

Who is online

Users browsing this forum: No registered users and 1 guest