Winner's Hole Cards

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Winner's Hole Cards

Postby tonixart » Mon Jul 29, 2013 6:46 pm

Hello!
I had custom stat in PT3 showing hole cards of player, who win the hand.
It worked very well, but after i imported report with that stat in PT4 it says that SQL expression is not valid.
Is there way to fix it?
The expression is that (for the first card):

SELECT thhs_cnthands.holecard_1 FROM tourney_hand_player_detail thhs_cnthands WHERE (thhs_cnthands.id_player =id_winner AND thhs_cnthands.id_hand=id_hand )

Thank You!
tonixart
 
Posts: 46
Joined: Fri Sep 11, 2009 10:04 am

Re: Winner's Hole Cards

Postby WhiteRider » Tue Jul 30, 2013 4:21 am

The "_details" table was merged with the "_statistics" table in PT4 so you probably just need to replace "tourney_hand_player_detail" with "tourney_hand_player_statistics".
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Winner's Hole Cards

Postby tonixart » Tue Jul 30, 2013 12:23 pm

Thank You! Now it works!
tonixart
 
Posts: 46
Joined: Fri Sep 11, 2009 10:04 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 2 guests