Find specific hand in database

[redcow]

Hi,


Yeah the subject title sounds very strange, as it was quite hard to explain what I meant , is it possible through a sql query or somehow to find a specific hand in a mining database ? Therefore I have a hand in a format as it gets posted online(www.pokerhand.org) or on boards. I know exactly the action and the board texture, but no Player names and no Table ID, is it possible if this hand is somewhere in my mining database to find it?

greets

[WhiteRider]

You could create a Custom Report (Reports tab) and set a filter to identify the hole cards and board cards.

You will need to create a report in the Holdem Cash Hand section, and add Stats like Hand #, Hole1, Hole2, Flop1, etc, and any others you like.
On the Filters window, uncheck 'filter on active player', and filter on columns like:
id_holecard=1
id_flop1=13
..would find hole cards = AA, and flop card 1 = Ac.

Have a look at this post about card IDs.
viewtopic.php?f=18&t=11876#p55492

[WhiteRider]

To check for board cards if you don't know the suit, you can use this kind of filter:
id_flop1 % 13 = 0
..which is the MOD function, and will find any aces (any time the ID divided by 13 leaves a remainder of 0, i.e. 13, 26, 39, 52).

Note: if you search for aces as above it will also count when ID=0 which it is if there is no flop, so you need to check this:
id_flop1 % 13 = 0 AND id_flop1 > 0