Ranking in HUD

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

Ranking in HUD

Postby cheetah_83 » Mon Oct 19, 2009 2:31 am

is it possible to get the current ranking in the HUD, so i can see who is chipleader and what is my ranking at the moment?
cheetah_83
 
Posts: 6
Joined: Mon Sep 07, 2009 8:51 am

Re: Ranking in HUD

Postby WhiteRider » Mon Oct 19, 2009 4:19 am

No - that information is not available as information from a player's previous hands which were imported to the database.
HUD stats are all based on all of a player's hands in your database, and this sort of information isn't in the hand history files.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Ranking in HUD

Postby cheetah_83 » Mon Oct 19, 2009 4:34 am

but with sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported, tourney_holdem_hand_player_detail.amt_before + tourney_holdem_hand_player_statistics.amt_won, 0]) i get the current chipcount. the problem would be to compare the chipcount of the different players
cheetah_83
 
Posts: 6
Joined: Mon Sep 07, 2009 8:51 am

Re: Ranking in HUD

Postby WhiteRider » Mon Oct 19, 2009 5:32 am

That is based on the last hand of that player, not all players. You can't access the stack sizes of all players that way.
You could find out how many players there were in the last hand (tourney_holdem_hand_summary.cnt_players) but not much more detail, I don't think.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Ranking in HUD

Postby kraada » Mon Oct 19, 2009 8:44 am

Unless, of course, you're playing a single table SnG - but at that point, you can equally well just look at everyone's chip stack . . .
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Ranking in HUD

Postby cheetah_83 » Mon Oct 19, 2009 12:31 pm

yes its for single table sng's
first of all i'm interested in the how-to, if this would be possible. then i could use this for further calculations like ICM for example
cheetah_83
 
Posts: 6
Joined: Mon Sep 07, 2009 8:51 am

Re: Ranking in HUD

Postby kraada » Mon Oct 19, 2009 2:24 pm

I've been trying to think of a way to make this work but I don't think it can be done yet - though I do think it might become possible at some point in the future. The problem is that even though different parts of PT3 could know each individual player's stack size, there's no way to build a stat that will display on the HUD which will know everyone's stack size. Without that you can't order the stack sizes, and thus can't tell who is first, second, etc. And certainly you can't do ICM calculations, sorry.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Ranking in HUD

Postby cheetah_83 » Mon Oct 19, 2009 2:33 pm

ok
but thanks for the answer
cheetah_83
 
Posts: 6
Joined: Mon Sep 07, 2009 8:51 am


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

Who is online

Users browsing this forum: No registered users and 5 guests

cron
highfalutin