Filter my stats against one specific villain

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Filter my stats against one specific villain

Postby Link23 » Sun Jan 06, 2013 12:39 pm

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.
Link23
 
Posts: 7
Joined: Thu May 15, 2008 7:22 pm

Re: Filter my stats against one specific villain

Postby WhiteRider » Sun Jan 06, 2013 6:07 pm

Check out this post which explains how to do that.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Filter my stats against one specific villain

Postby Link23 » Mon Jan 07, 2013 6:12 am

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.
Link23
 
Posts: 7
Joined: Thu May 15, 2008 7:22 pm

Re: Filter my stats against one specific villain

Postby kraada » Mon Jan 07, 2013 11:23 am

Change the two instances of "tourney" to "cash" and it will work for cash games then.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Filter my stats against one specific villain

Postby Link23 » Tue Jan 08, 2013 5:36 am

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.
Link23
 
Posts: 7
Joined: Thu May 15, 2008 7:22 pm

Re: Filter my stats against one specific villain

Postby kraada » Tue Jan 08, 2013 9:43 am

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')
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 20 guests

cron