COLD CALL AND FACES 3B, THEN FOLD

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

COLD CALL AND FACES 3B, THEN FOLD

Postby marvin » Mon Jan 11, 2010 6:41 pm

action: A PFR, B cold call, C 3bet, A... doenst matter, B fold. (B is HERO)

cnt_p_3bet_def_action_fold_when_coldcall:
um(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.flg_p_ccall, 1, 0])

cnt_p_3bet_def_opp_when_coldcall:
sum(if[holdem_hand_player_statistics.enum_p_3bet_action='F' and holdem_hand_player_statistics.flg_p_ccall, 1, 0])

STAT:
(cnt_p_3bet_def_action_fold_when_coldcall / cnt_p_3bet_def_opp_when_coldcall) * 100
FORMAT:
/%.2f

but on hud i see onnly: ()

why?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: COLD CALL AND FACES 3B, THEN FOLD

Postby kraada » Mon Jan 11, 2010 6:58 pm

Did you update your cache after creating the stat?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: COLD CALL AND FACES 3B, THEN FOLD

Postby marvin » Mon Jan 11, 2010 8:16 pm

im doing now, tomorrow ill let you know if it will appear
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: COLD CALL AND FACES 3B, THEN FOLD

Postby marvin » Tue Jan 12, 2010 4:53 am

cache updated, but the problem is not fixed
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: COLD CALL AND FACES 3B, THEN FOLD

Postby WhiteRider » Tue Jan 12, 2010 5:40 am

If you have more than one database you should rebuild the cache on any DBs used by the HUD.

If you still haven't got it working please export and attach your stat to a Support ticket.
Tutorial: Submitting a Bug Report
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: COLD CALL AND FACES 3B, THEN FOLD

Postby marvin » Tue Jan 12, 2010 6:43 am

fixed. the name of stat was different of the last version built. so it didnt found the stat (it was there but was deleted after a remake)
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests