highlight the position where the player is

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

highlight the position where the player is

Postby majonyjony » Fri Aug 27, 2010 12:49 pm

Hello, I'm working to improve my hud
I'm doing a statistics position pop up

Like this:
....................EP MP LP ETC
VPIP...............8..11..14..x
PFR................3..5 ...8...x
ETC
To facilitate the reading of the statistics, I want to highlight the position where the player is.

He made this statistic: (then change the text MP, BB, etc. for this statistic)

columns:

Indicadorposicion_button= sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported and tourney_holdem_hand_player_statistics.position=9, 1, 0])

Indicadorposicion_bb= sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported and tourney_holdem_hand_player_statistics.position=7, 1, 0])

Etc...

Variables:

var_posicion_button = Indicadorposicion_button
var_pos_bb = Indicadorposicion_bb

Etc..

Statistic:

if (var_pos_button = 1, 'BU',
if (var_pos_sb = 1, 'SB',
if (var_pos_bb = 1, 'BB',
if (var_pos_EP = 1, 'EP',
if (var_pos_MP = 1, 'MP',
if (var_pos_Hijack = 1, 'HJ',
if (var_pos_CO = 1, 'CO','_')))))))

Only works well for HJ, CO, BU, and SB.

I do not understand why this happens.

TY
majonyjony
 
Posts: 108
Joined: Wed Oct 08, 2008 4:01 am

Re: highlight the position where the player is

Postby majonyjony » Fri Aug 27, 2010 1:13 pm

column for MP =

sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported and tourney_holdem_hand_player_statistics.position=4 and tourney_holdem_hand_player_statistics.position=3 and tourney_holdem_hand_player_statistics.position=2, 1, 0])

?????
majonyjony
 
Posts: 108
Joined: Wed Oct 08, 2008 4:01 am

Re: highlight the position where the player is

Postby kraada » Fri Aug 27, 2010 1:35 pm

This sort of workaround will no longer function properly due to changes in the PT3 caching mechanism I'm afraid. I've requested that we add position as a live stat, but it may be a little while before it's available.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: highlight the position where the player is

Postby majonyjony » Sun Aug 29, 2010 7:06 am

TY kraada!!

I hope to have it soon
majonyjony
 
Posts: 108
Joined: Wed Oct 08, 2008 4:01 am

Re: highlight the position where the player is

Postby majonyjony » Thu Sep 29, 2011 1:45 pm

Hi!, maibe works fine whith (new?) column "_cache_position_type"?
majonyjony
 
Posts: 108
Joined: Wed Oct 08, 2008 4:01 am

Re: highlight the position where the player is

Postby WhiteRider » Thu Sep 29, 2011 3:10 pm

That will not refer to the current position of the player - the cache is totals over all hands, split by position the hands were played, but it does not reflect the current position. We do not know that because we do not have information about the current hand.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 4 guests

cron
highfalutin