Hi,
in order to get familiar with the new PT3 database structure i updated my program for use with PT3 databases. it shows all allin pots, your equity and if u got (un)lucky.
1) be sure you have a java runtime installation ( version 6 recommended, get it at http://www.java.com )
2) extract zip into a new directory
3) edit settings.txt with your database info
4) run "run_allin_calc.bat"
Download: http://rapidshare.com/files/148842512/A ... 4.zip.html
Sample Output:
- Code: Select all
[ 2006-12-20 23:01:35 ] [ Kc As ] [ 8s 9s ] [ Ts Ah 2s _ 3s 4h ] [ 0,6687 ] [ 11,20$ / 7,49$ / 0,00$ / -7,49$ ] [ FTP ] [ $0.50 NL (6 max) ]
...
[ 2008-01-04 16:31:47 ] [ Jd Jh ] [ Ks 8s ] [ 8h 4d Td _ 2h 8d ] [ 0,8141 ] [ 158,06$ / 128,68$ / 0,00$ / -128,68$ ] [ PTY ] [ $1 NL ]
found 501 headsup allin situations
won: 305 lost: 180 tied: 16
average potsize: 81,27$
average ev: 0,6214
money won: 25618,89$
money expected (based on allin equity): 26247,88$
money difference: -628,99$
max money diff: 2007-04-07 23:24:39 at +246,93$
min money diff: 2008-01-04 16:31:47 at -690,90$
i used the following query:
- Code: Select all
SELECT summary.date_played,
sites.site_abbrev AS site,
limits.limit_name AS limit,
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 - amt_rake) AS potsize,
hero_s.flg_won_hand AS hero_won,
villain_s.flg_won_hand AS villain_won
FROM player p,
holdem_hand_player_detail hero_d,
holdem_hand_player_detail villain_d,
holdem_hand_player_statistics hero_s,
holdem_hand_player_statistics villain_s,
holdem_hand_summary summary,
holdem_limit limits,
lookup_sites sites,
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_limit = limits.id_limit
AND summary.id_site = sites.id_site
AND limits.flg_nlpl = true
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 holdem_hand_player_statistics foo
WHERE foo.id_hand = hhh.id_hand
AND foo.flg_showdown = true) = 2)
ORDER BY summary.date_played
what do others who know SQL think about it?
