Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
Abkm wrote:I used the post above:
I made 2 column (id_holecard1_display and id_holecard2_display) and put them into a stat ( if(str_winner = "YOUR_POKERNAME", format (""), lookup_cards(id_holecard1_display, id_holecard2_display, id_holecard3, id_holecard4)) ) .
" id_holecard1_display
SELECT thhs_cnthands.holecard_1 FROM tourney_hand_player_statistics thhs_cnthands WHERE (thhs_cnthands.id_player =id_winner AND thhs_cnthands.id_hand=id_hand )
id_holecard2_display
SELECT thhs_cnthands.holecard_2 FROM tourney_hand_player_statistics thhs_cnthands WHERE (thhs_cnthands.id_player =id_winner AND thhs_cnthands.id_hand=id_hand )
Here is the stat (I did not complete for 3rd and 4th card columns, just continue if need be).
I also included the option to blank out the winner's cards ("YOUR_POKERNAME") if you won the hand. I added this stat at the end of the report .
Hole Cards NO HERO
if(str_winner = "YOUR_POKERNAME", format (""), lookup_cards(id_holecard1_display, id_holecard2_display, id_holecard3, id_holecard4)) "
tourney_hand_player_statistics.date_played between 'yyyy/mm/dd hh:mm:ss' and 'yyyy/mm/dd hh:mm:ss'
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 18 guests