Tracker Question

How do I check my MGR ?

the # on general info is too low and the # on game notes is too high.

[J_B]

Do you mean in poker tracker?

[_dave_]

One solution here, in this thread, software forum.

dave.

yes

my head is spinning

So I take one of those rb scripts, then what do I do with it?

[_dave_]

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.

thanks dave, you truly are a man among men, i'm gonna try that right now.

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);

[Sniper]

The line that startes with "AS" belongs attached to the previous line (at the end of it).

[_dave_]

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.