Open Side Menu Go to the Top

06-10-2010 , 11:18 AM
is it possible using PT to generate a list of players iv have stolen the big blind off x amount of times?
thanks
Is it possible...
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Is it possible...
06-10-2010 , 12:28 PM
Almost. Add these two filters to a custom report in the Holdem Cash Player Statistics section, and add the Player and Times statistics. With these filters it will show you the number of times that they folded to your steal when they were in the big blind. Click the Times column to sort by that value and you'll see the people who folded most often at the top - you can export this list if you'd like and edit it if you want to narrow it down, but doing so in this custom report makes it a lot more complicated. Don't change anything in the filters, copy them exactly as written:

id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics, player where player.id_player = holdem_hand_player_statistics.id_player and player.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id') and holdem_hand_player_statistics.flg_steal_att and not(holdem_hand_player_statistics.flg_f_saw) and holdem_hand_player_statistics.flg_won_hand and not(holdem_hand_player_statistics.flg_p_face_raise ))

id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics where holdem_hand_player_statistics.position = 8)
06-10-2010 , 02:06 PM
thanks alot for your help, however when i run the report i believe it is showing the amount of times a player has stolen the BB (because i am top by a long way) as opposed to the number of times i have stolen the BB off of someone else?

again thanks for the help though
06-10-2010 , 06:00 PM
Hrm, you're right that won't work - what it's actually showing now is all players whose blinds you have stolen at least once, and all hands that they were in the BB.

I'll have to think harder about how to put this together, it may have to be one bigger query which makes things more complicated.
06-10-2010 , 06:45 PM
dont worry if it dosent work, but thanks for the help
Is it possible...
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
Is it possible...

      
m