Working on Limit Play - PokerTracker - Merging Hole Cards

[Expunge]

I think i figured it out... Playing with the db i have here. Of course you should have a backup copy of your db incase you blow something up.

Each person would have to create a make table query. call the new table HoleCards

select the follow tables to base this query on
game_players
game
players

remove the link between game.player_id and players.player_id (if you don't do this the results will only include the hands you have won with)

They would include the following fields...

from the game_players table...
hole_card_1
hole_card_2
suited
hole_cards
card_order1
card_order2
card_order3
connector_hand
pair_hand

from the game table...
game_number

from the players table...
screen_name (set the criteria to your base screen name, the one you use in tracker.)

also include the following for filtering purposes (uncheck the show option)
from the game table the date_played field and set the criteria to >#1/14/2005# And <#1/15/2005# (obviously correct the date to the date that we played)

Click the view button to verify that you get the same number of rows as hands that you played during that day.

If that looks right click the design button and then click the run query button (!)

That should make the table for you. You would then export this table and send it to a specific person. That person merge all of these tables together and send them back out.

Each person would import this table into their database

Now create an update query.

Select the following tables, HoleCards, game_players, game, players
again remove the link between game.player_id and players.player_id

You want to update the fields of the game_players table
hole_card_1
hole_card_2
suited
hole_cards
card_order1
card_order2
card_order3
connector_hand
pair_hand

the update to should be
[HoleCards]![hole_card_1]
[HoleCards]![hole_card_2]
etc.

Click the view button to verify that you get the same number of rows as there are in the HoleCards table that you imported.

If that looks right click the design button and then click the run query button (!)

And that should be it.

If someone would be so kind as to try to do the first part (the make table) and send that to me i can try the second part on a more than made up data basis. If that works i can try to post a few screen shots that can help you along the way.

[MNBridge]

I'll do it tonight.

I would suggest starting a separate db for the AO games. That's what I intend to do.

[Expunge]

Of course with a few tweaks to the codes this would work for tournaments too.


Anyways, if we go through the hastle of this, the opponents hole card may not show up in the playback window. I'm thinking that the playback window actually goes back and digs up the original hh file still stored on your hd somewhere i believe and pulls its info from there. However when in the ring game window of tracker the stats should reflect the added information.

So if this is the case there is lesser benefit to doing this process.

One alternative that might work is to open your hand history and insert another players hole cards into the text, and then import the file. Havn't tried this to see if it works, see the example below, i added the bolded line. (i'm not sure gators real cards in this hand, i used made up cards). If this works then i'm sure we could figure out a macro or a program that does the grunt work for us.

***** Hand History for Game 2202573271 *****
$0.5/$1 Hold'em - Monday, June 13, 20:01:33 EDT 2005
Table MNbridge's pvt table 1 (Real Money)
Seat 7 is the button
Total number of players : 9
Seat 4: MNbridge ( $29.5 )
Seat 9: Castle7 ( $24.25 )
Seat 2: gator8373 ( $23.25 )
Seat 6: Lippman ( $45.25 )
Seat 7: DwtnToronto ( $25.25 )
Seat 8: Akula711 ( $23 )
Seat 1: MattyKGB2004 ( $24.25 )
Seat 5: knowles97 ( $23 )
Seat 10: HangerAngler ( $42.75 )
Akula711 posts small blind [$0.25].
Castle7 posts big blind [$0.5].
** Dealing down cards **
Dealt to MNbridge [ Td Qd ]
Dealt to gator8373 [ 2h, 3s ]
Lippman: Im playing to beat MNB, my normal game
DwtnToronto: table change - u guys are rocks
HangerAngler folds.
MattyKGB2004 calls [$0.5].
DwtnToronto:
gator8373 folds.
MNbridge calls [$0.5].
knowles97 folds.
Lippman folds.
DwtnToronto folds.
Akula711 calls [$0.25].
Castle7 checks.
** Dealing Flop ** [ 7c, 4c, 6h ]
Akula711 checks.
Castle7 bets [$0.5].
MattyKGB2004 folds.
MNbridge raises [$1].
Akula711 folds.
Castle7 calls [$0.5].
** Dealing Turn ** [ 7d ]
Castle7 checks.
MNbridge checks.
** DealingRiver ** [ Jd ]
Castle7 bets [$1].
MNbridge folds.
Castle7 shows [ 5h, Ts ] a pair of sevens.
Castle7 wins $5 from the main pot with a pair of sevens.

[MNBridge]

Originally Posted by Expunge

***** Hand History for Game 2202573271 *****
$0.5/$1 Hold'em - Monday, June 13, 20:01:33 EDT 2005
Table MNbridge's pvt table 1 (Real Money)
Seat 7 is the button
Total number of players : 9
Seat 4: MNbridge ( $29.5 )
Seat 9: Castle7 ( $24.25 )
Seat 2: gator8373 ( $23.25 )
Seat 6: Lippman ( $45.25 )
Seat 7: DwtnToronto ( $25.25 )
Seat 8: Akula711 ( $23 )
Seat 1: MattyKGB2004 ( $24.25 )
Seat 5: knowles97 ( $23 )
Seat 10: HangerAngler ( $42.75 )
Akula711 posts small blind [$0.25].
Castle7 posts big blind [$0.5].
** Dealing down cards **
Dealt to MNbridge [ Td Qd ]
Dealt to gator8373 [ 2h, 3s ]

This is EXACTLY what I was thinking in my post in the other thread.

[DblDownTrent]

You guys should try it out here,

http://teamfu.freeshell.org/replayer.html#

[MNBridge]

OK the following Hand history shows Everyones hand on the flop and everywhere else - for example if I look at gators individual hands this one shows up.:

***** Hand History for Game 2237599207 *****
$0.5/$1 Hold'em - Monday, June 20, 20:06:11 EDT 2005
Table MNbridge's pvt table 1 (Real Money)
Seat 5 is the button
Total number of players : 5
Seat 4: MNbridge ( $25 )
Seat 2: DwtnToronto ( $25 )
Seat 5: Castle7 ( $25 )
Seat 1: gator8373 ( $25 )
Seat 8: lawfive ( $25 )
lawfive posts small blind [$0.25].
MNbridge posts big blind [$0.5].
** Dealing down cards **
Dealt to gator8373 [ 7h 7s ]
Dealt to lawfive [ Ah Tc ]
Dealt to MNbridge [ Kh 8c ]
Dealt to DwtnToronto [ Ac 2d ]
Dealt to Castle7 [ 3h 6h ]
gator8373 folds.
DwtnToronto folds.
Castle7 raises [$1].
lawfive calls [$0.75].
MNbridge calls [$0.5].
** Dealing Flop ** [ 7c, 4c, 5h ]
lawfive bets [$0.5].
DwtnToronto: just sent messages to freeman & spike
MNbridge calls [$0.5].
Castle7 calls [$0.5].
** Dealing Turn ** [ Kc ]
lawfive bets [$1].
MNbridge raises [$2].
Castle7 folds.
lawfive calls [$1].
** Dealing River ** [ Jc ]
lawfive bets [$1].
MNbridge calls [$1].
lawfive shows [ Th, Ac ] a flush, ace high.
MNbridge doesn't show [ Kh, 8c ] a flush, king high.
lawfive wins $10 from the main pot with a flush, ace high with ace kicker.
Game #<do not remove this line!> starts.

ORIGINAL FILE
***** Hand History for Game 2237599206 *****
$0.5/$1 Hold'em - Monday, June 20, 20:06:11 EDT 2005
Table MNbridge's pvt table 1 (Real Money)
Seat 5 is the button
Total number of players : 5
Seat 4: MNbridge ( $25 )
Seat 2: DwtnToronto ( $25 )
Seat 5: Castle7 ( $25 )
Seat 1: gator8373 ( $25 )
Seat 8: lawfive ( $25 )
lawfive posts small blind [$0.25].
MNbridge posts big blind [$0.5].
** Dealing down cards **
Dealt to MNbridge [ Kh 8c ]
Castle7 raises [$1].
lawfive calls [$0.75].
MNbridge calls [$0.5].
** Dealing Flop ** [ 7c, 4c, 5h ]
lawfive bets [$0.5].
DwtnToronto: just sent messages to freeman & spike
MNbridge calls [$0.5].
Castle7 calls [$0.5].
** Dealing Turn ** [ Kc ]
lawfive bets [$1].
MNbridge raises [$2].
Castle7 folds.
lawfive calls [$1].
** Dealing River ** [ Jc ]
lawfive bets [$1].
MNbridge calls [$1].
lawfive shows [ Th, Ac ] a flush, ace high.
MNbridge doesn't show [ Kh, 8c ] a flush, king high.
lawfive wins $10 from the main pot with a flush, ace high with ace kicker.
Game #<do not remove this line!> starts.


Here's what I did.

Manually entered in the info in bold

Then Purged those files from Poker Tracker. In this case it was only 1 hand

And then I used the manual file download to pull in the text file above.

(I would suggest trying it) - make sure to pull out the "[ b]" stuff.


Seems to work GREAT! Now it's a matter of writing a macro that can create the above HH from 9 text files. Then I think we are there.

I think I'll try to give full instruction AFTER we figure this out, might be easier. If anyone has questions though let me know.

** Not sure if the Dealt to xxxx has to be in the correct order or not. I would guess the xxxx Folds does.

Originally Posted by MNBridge

OK the following Hand history shows Everyones hand on the flop and everywhere else - for example if I look at gators individual hands this one shows up.:

***** Hand History for Game 2237599207 *****
$0.5/$1 Hold'em - Monday, June 20, 20:06:11 EDT 2005
Table MNbridge's pvt table 1 (Real Money)
Seat 5 is the button
Total number of players : 5
Seat 4: MNbridge ( $25 )
Seat 2: DwtnToronto ( $25 )
Seat 5: Castle7 ( $25 )
Seat 1: gator8373 ( $25 )
Seat 8: lawfive ( $25 )
lawfive posts small blind [$0.25].
MNbridge posts big blind [$0.5].
** Dealing down cards **
Dealt to gator8373 [ 7h 7s ]
Dealt to lawfive [ Ah Tc ]
Dealt to MNbridge [ Kh 8c ]
Dealt to DwtnToronto [ Ac 2d ]
Dealt to Castle7 [ 3h 6h ]
gator8373 folds.
DwtnToronto folds.
Castle7 raises [$1].
lawfive calls [$0.75].
MNbridge calls [$0.5].
** Dealing Flop ** [ 7c, 4c, 5h ]
lawfive bets [$0.5].
DwtnToronto: just sent messages to freeman & spike
MNbridge calls [$0.5].
Castle7 calls [$0.5].
** Dealing Turn ** [ Kc ]
lawfive bets [$1].
MNbridge raises [$2].
Castle7 folds.
lawfive calls [$1].
** Dealing River ** [ Jc ]
lawfive bets [$1].
MNbridge calls [$1].
lawfive shows [ Th, Ac ] a flush, ace high.
MNbridge doesn't show [ Kh, 8c ] a flush, king high.
lawfive wins $10 from the main pot with a flush, ace high with ace kicker.
Game #<do not remove this line!> starts.

ORIGINAL FILE
***** Hand History for Game 2237599206 *****
$0.5/$1 Hold'em - Monday, June 20, 20:06:11 EDT 2005
Table MNbridge's pvt table 1 (Real Money)
Seat 5 is the button
Total number of players : 5
Seat 4: MNbridge ( $25 )
Seat 2: DwtnToronto ( $25 )
Seat 5: Castle7 ( $25 )
Seat 1: gator8373 ( $25 )
Seat 8: lawfive ( $25 )
lawfive posts small blind [$0.25].
MNbridge posts big blind [$0.5].
** Dealing down cards **
Dealt to MNbridge [ Kh 8c ]
Castle7 raises [$1].
lawfive calls [$0.75].
MNbridge calls [$0.5].
** Dealing Flop ** [ 7c, 4c, 5h ]
lawfive bets [$0.5].
DwtnToronto: just sent messages to freeman & spike
MNbridge calls [$0.5].
Castle7 calls [$0.5].
** Dealing Turn ** [ Kc ]
lawfive bets [$1].
MNbridge raises [$2].
Castle7 folds.
lawfive calls [$1].
** Dealing River ** [ Jc ]
lawfive bets [$1].
MNbridge calls [$1].
lawfive shows [ Th, Ac ] a flush, ace high.
MNbridge doesn't show [ Kh, 8c ] a flush, king high.
lawfive wins $10 from the main pot with a flush, ace high with ace kicker.
Game #<do not remove this line!> starts.


Here's what I did.

Manually entered in the info in bold

Then Purged those files from Poker Tracker. In this case it was only 1 hand

And then I used the manual file download to pull in the text file above.

(I would suggest trying it) - make sure to pull out the "[ b]" stuff.


Seems to work GREAT! Now it's a matter of writing a macro that can create the above HH from 9 text files. Then I think we are there.

I think I'll try to give full instruction AFTER we figure this out, might be easier. If anyone has questions though let me know.

** Not sure if the Dealt to xxxx has to be in the correct order or not. I would guess the xxxx Folds does.

Just one sticky point:
Dealt to lawfive [ Ah Tc ]
lawfive shows [ Th, Ac ] a flush, ace high

Only cause I really thought that was a fishy play on my part, and without the Ac, I had to do a double take, "wtf were you thinking law?"

[MNBridge]

Originally Posted by lawfi5h

Just one sticky point:
Dealt to lawfive [ Ah Tc ]
lawfive shows [ Th, Ac ] a flush, ace high

Only cause I really thought that was a fishy play on my part, and without the Ac, I had to do a double take, "wtf were you thinking law?"

Yeah look at the other hands as well -- someone mucked a set and Castle made a GREAT forecasting laydown.

I wasn't worried about accuracy - just wanted to see if it worked.

Though I didn't try to do it incorrect either.

Originally Posted by MNBridge

Yeah look at the other hands as well -- someone mucked a set and Castle made a GREAT forecasting laydown.

I wasn't worried about accuracy - just wanted to see if it worked.

Though I didn't try to do it incorrect either.

Oh. Gotcha.

[Expunge]

Anyone have tracker use right now?
If so can you try to load the following?
It just mixes up the order of the hole cards
I edited the game number and date/time so you can find it easily to remove from the db later.

***** Hand History for Game 2999999999 *****
$0.5/$1 Hold'em - Wednesday, June 22, 12:00:00 EDT 2005
Table MNbridge's pvt table 1 (Real Money)
Seat 5 is the button
Total number of players : 5
Seat 4: MNbridge ( $25 )
Seat 2: DwtnToronto ( $25 )
Seat 5: Castle7 ( $25 )
Seat 1: gator8373 ( $25 )
Seat 8: lawfive ( $25 )
lawfive posts small blind [$0.25].
MNbridge posts big blind [$0.5].
** Dealing down cards **
Dealt to DwtnToronto [ Ac 2d ]
Dealt to Castle7 [ 3h 6h ]
Dealt to gator8373 [ 7h 7s ]
Dealt to lawfive [ Ah Tc ]
Dealt to MNbridge [ Kh 8c ]
gator8373 folds.
DwtnToronto folds.
Castle7 raises [$1].
lawfive calls [$0.75].
MNbridge calls [$0.5].
** Dealing Flop ** [ 7c, 4c, 5h ]
lawfive bets [$0.5].
DwtnToronto: just sent messages to freeman & spike
MNbridge calls [$0.5].
Castle7 calls [$0.5].
** Dealing Turn ** [ Kc ]
lawfive bets [$1].
MNbridge raises [$2].
Castle7 folds.
lawfive calls [$1].
** Dealing River ** [ Jc ]
lawfive bets [$1].
MNbridge calls [$1].
lawfive shows [ Th, Ac ] a flush, ace high.
MNbridge doesn't show [ Kh, 8c ] a flush, king high.
lawfive wins $10 from the main pot with a flush, ace high with ace kicker.
Game #<do not remove this line!> starts.