AllinCalc for PT3 v0.96 (Updated 12/4)

[Seitz333]

Oops had 2 errors, this SQL should work if the Java files are changed.

Code: Select all

SELECT   summary.date_played,
         sites.site_abbrev AS site,
         hhh.id_hand,
         hero_d.holecard_1 AS hero_hc1,
         hero_d.holecard_2 AS hero_hc2,
         hero_d.amt_before AS hero_amt_before,
         hero_d.amt_bet_ttl AS hero_amt_bet_ttl,
         villain_d.holecard_1 AS villain_hc1,
         villain_d.holecard_2 AS villain_hc2,
         villain_d.amt_before AS villain_amt_before,
         villain_d.amt_bet_ttl AS villain_amt_bet_ttl,
         (CASE
            WHEN hero_s.enum_allin = 'N' THEN villain_s.enum_allin
            ELSE hero_s.enum_allin
          END) AS allin_street,
         history,
         card_1 AS flop1,
         card_2 AS flop2,
         card_3 AS flop3,
         card_4 AS turn,
         card_5 AS river,
         amt_pot AS potsize,
         hero_s.flg_won_hand AS hero_won,
         villain_s.flg_won_hand AS villain_won
FROM     player p,
         tourney_holdem_hand_player_detail hero_d,
         tourney_holdem_hand_player_detail villain_d,
         tourney_holdem_hand_player_statistics hero_s,
         tourney_holdem_hand_player_statistics villain_s,
         tourney_holdem_hand_summary summary,
         lookup_sites sites,
         tourney_holdem_hand_histories hhh
WHERE    p.player_name = 'advis0r'
         AND hero_d.id_player = p.id_player
         AND hero_s.id_player = p.id_player
         AND villain_d.id_player != p.id_player
         AND villain_s.id_player != p.id_player
         AND summary.id_site != 0
         AND hhh.id_hand = hero_d.id_hand
         AND hhh.id_hand = hero_s.id_hand
         AND hhh.id_hand = villain_d.id_hand
         AND hhh.id_hand = villain_s.id_hand
         AND hhh.id_hand = summary.id_hand
         AND summary.id_site = sites.id_site
         AND hero_s.flg_showdown = true
         AND villain_s.flg_showdown = true
         AND ((hero_d.amt_bet_p + hero_d.amt_bet_f + hero_d.amt_bet_t = villain_d.amt_before)
               OR (villain_d.amt_bet_p + villain_d.amt_bet_f + villain_d.amt_bet_t = hero_d.amt_before))
         AND ((SELECT COUNT(* )
               FROM   tourney_holdem_hand_player_statistics foo
               WHERE  foo.id_hand = hhh.id_hand
                      AND foo.flg_showdown = true) = 2)
ORDER BY summary.date_played

[advis0r]

remember, it doesnt find multiway allins (which are common in tourneys) since it would require a lot of program logic to figure out who was suppossed to win what amount.

and as i said earlier, expected wins in tournaments chips are worthless to know for your actual winrate

its just not worth creating imo.

[feint06]

remember, it doesnt find multiway allins (which are common in tourneys) since it would require a lot of program logic to figure out who was suppossed to win what amount.

and as i said earlier, expected wins in tournaments chips are worthless to know for your actual winrate

its just not worth creating imo.

True, but its nice to see some objective evidence when you feel you're running bad (so you dont go changing your game too much)

[advis0r]

alonalbert sent me a pm about how to improve the SQL a little bit.

new version 0.95:
http://depositfiles.com/files/wjluox04i

this will find a lot more allins. not sure if the numbers will get screwed by some sort of multiway pots though.

need feedback:
- post your 0.94 and 0.95 results
- set debug_mode 2 and read / check the hand histories in order to find calculation errors
- anyone able to compare this to HEM results?

[Ricardo]

How do I run this in Vista sp1 64 bit on my new PC? I installed Java but get a "Java is not recognized as an external or internal command" error message when running allincalc from my desktop It can't find the path to Java. Thanks

(Useful tip: keep Windows XP at all costs. Don't ever get Vista)

[Ricardo]

Nevermind. I spent an hour trying to get Vista to use Java. Finally had to do some obscure adding of a line of code to some obscure "envoronmental" variable in system....blah blah I'm just a standard home user and I shouldn't have to figure this out. One of several challenges prewsented by this "advanced" OS .Thanks a lot Vista . If it helps anybody else here is the code:
;C:\Program Files (x86)\Java\jre1.6.0_01\bin;
also discovered the the db name was PT3 DB not PT3DB.
But the good news is allincalc ran . Thanks.

[Ricardo]

if this is any help, on the same PT3 data (~45k hands) v.94 found 211 HU allins, v.95 found 304 HU allins

[Ricardo]

possible Ver .95 error:
v.95 (but not v.94) ouput this allin line apparently showing two Aces of spades on the same hand:
2008-11-21 03:36:49 ] [ As As ] [ 4s As ] [ _ 8h Tc 9s 3s 6s ] [ 0.6593 ] [ 68.00$ / 44.83$ / 0.00$ / -44.83$ ]

[advis0r]

possible Ver .95 error:
v.95 (but not v.94) ouput this allin line apparently showing two Aces of spades on the same hand:
2008-11-21 03:36:49 ] [ As As ] [ 4s As ] [ _ 8h Tc 9s 3s 6s ] [ 0.6593 ] [ 68.00$ / 44.83$ / 0.00$ / -44.83$ ]

what site is this from?
can you set debug mode to 2 and show me the HH?

i think its because you didnt see the holecards of the player who supposedly has AsAs.
if im right, i will be fixing this soon.

[Ricardo]

advis0r, I sent you a private message.