Page 1 of 1
Filter my stats against one specific villain
Posted:
Sun Jan 06, 2013 12:39 pm
by Link23
Hey,
I play Heads Up cashgame. I want to show my stats vs one specific villain over a period of time/hands. How can I do that?
Best regards,
Link.
Re: Filter my stats against one specific villain
Posted:
Sun Jan 06, 2013 6:07 pm
by WhiteRider
Check out
this post which explains how to do that.
Re: Filter my stats against one specific villain
Posted:
Mon Jan 07, 2013 6:12 am
by Link23
Thank you for your reply but I play Cashgames and not tourneys. If I change "Villain" to my preferred villain I want to filter, I can´t see any hands displayed.
Re: Filter my stats against one specific villain
Posted:
Mon Jan 07, 2013 11:23 am
by kraada
Change the two instances of "tourney" to "cash" and it will work for cash games then.
Re: Filter my stats against one specific villain
Posted:
Tue Jan 08, 2013 5:36 am
by Link23
I´ve done that. I still don´t get a report.
( 0 < (SELECT count(hhps2.id_hand) FROM cash_hand_player_statistics hhps2 WHERE hhps2.id_hand = cash_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT p.id_player FROM player p WHERE player_name='villain')) )
I changed the bolt part into villains ID.
Re: Filter my stats against one specific villain
Posted:
Tue Jan 08, 2013 9:43 am
by kraada
Try this instead:
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p WHERE chps.id_player = p.id_player and p.player_name='villain')