#1
|
|||
|
|||
Tracker Question
How do I check my MGR ?
the # on general info is too low and the # on game notes is too high. |
#2
|
|||
|
|||
Re: Tracker Question
Do you mean in poker tracker?
|
#3
|
|||
|
|||
Re: Tracker Question
|
#4
|
|||
|
|||
Re: Tracker Question
yes
|
#5
|
|||
|
|||
Re: Tracker Question
my head is spinning
So I take one of those rb scripts, then what do I do with it? |
#6
|
|||
|
|||
Re: Tracker Question
Ack, new forum software really annoying - I just typed out a very detailed instruction list to use these scripts - New forum software timed me out, and lost all I had typed in to the box [img]/images/graemlins/frown.gif[/img]
In short, then: You need to be using Access database with PT, this is the default. Make a new text file in "C:\Program Files\Poker Tracker V2". Rename to "mgr.js". Open with notepad. Copy & Paste the "Code" section from my post here Change the settings as appropriate - your screen_name, suitable dates, ptrack database name (just 'ptrack' is the default, I used the 8th database, ptrack8 in my example). Change bonuscleared as required - set to 0 if no bonus have been deducted. Save the file after you have made changes. Make a shortcut to mgr.js on your desktop. Import your hands in to Poker Tracker, if not done already. Double click shortcut to get your MGR / RB numbers [img]/images/graemlins/smile.gif[/img] Post back if you have trouble, I will explain more if need be. After losing 10 minutes of typing, I'm off to send an email about "anomalies" with the new software to the forum-master. Enjoy! dave. |
#7
|
|||
|
|||
Re: Tracker Question
thanks dave, you truly are a man among men, i'm gonna try that right now.
|
#8
|
|||
|
|||
Re: Tracker Question
I get an error
"Unterminated string constant" "line 37" "char 60" this is what i copy pasted ///// change settings here ///// var screen_name = '_dave_'; var rakebackdeal = 0.25; var ptdb = 'ptrack8'; var start_date = '01-Sep-2005'; var end_date = '14-Sep-2005'; var bonuscleared = 100; //////////////////////////////// ///// Globals ///////// var db = new ActiveXObject("ADODB.Recordset"); var cstring = "Driver={Microsoft Access Driver(*.mdb)};DBQ="+ptdb+".mdb"; var totalhands = 0; var sql = ''; var echoout = ''; ////////////////////// sql = "SELECT Count(game_players.game_id) AS Hands," + " Sum(game.rake/ game.number_of_players)-"+bonuscleared+" AS MGR," + " MGR*"+rakebackdeal+" AS rakeback" + " FROM players INNER JOIN (game INNER JOIN game_players ON game.game_id =" + " game_players.game_id) ON players.player_id = game_players.player_id" + " WHERE (((game_players.hole_card_1) Is Not Null)" + " AND game.date_played >= #"+start_date+"#" + " AND game.date_played <= #"+end_date+"#" + " AND ((players.screen_name)='"+screen_name+"'));"; db.Open(sql, cstring, 1, 3); echoout = "Hands:\t\t" + db(0) + "\nMGR:\t\t" + db(1) + "\nRakeback:\t" + db(2); db.Close(); WScript.Echo(echoout); |
#9
|
|||
|
|||
Re: Tracker Question
The line that startes with "AS" belongs attached to the previous line (at the end of it).
|
#10
|
|||
|
|||
Re: Tracker Question
Well spotted sniper, thank you.
I'm not sure how that happened, it seems to have word-wrapped when it shouldn;y have. To re-state the problem, where it reads: <font class="small">Code:</font><hr /><pre>sql = "SELECT Count(game_players.game_id) AS Hands," <font color="red">+ " Sum(game.rake/ game.number_of_players)-"+bonuscleared+" AS MGR,"</font> + " MGR*"+rakebackdeal+" AS rakeback"</pre><hr /> should be: <font class="small">Code:</font><hr /><pre>sql = "SELECT Count(game_players.game_id) AS Hands," <font color="blue">+ " Sum(game.rake/ game.number_of_players)-"+bonuscleared+" AS MGR,"</font> + " MGR*"+rakebackdeal+" AS rakeback"</pre><hr /> Sorry about that, dave. |
|
|