HU Reports for Hero vs Specific Villains

[jdell408]

I'm sure its been asked and I'm sure its a simple step I'm not seeing, but I can't figure out how to run a report to show my stats vs a specific player OR specific player vs me. I don't see any type of filter for this. This is for HU analysis only.

[WhiteRider]

Are you using PT3 or PT4?

[jdell408]

Are you using PT3 or PT4?

Sorry. PT4

[WhiteRider]

You can do that with a custom report filter.
Go to My Reports and create a new Player report.
Click the blue Filters link and select 'expression filters' and paste this in:

( 0 < (SELECT count(hhps.id_hand) FROM tourney_hand_player_statistics hhps WHERE hhps.id_hand = tourney_hand_player_statistics.id_hand AND hhps.id_player = (SELECT p.id_player FROM player p WHERE player_name='VillainName')) )

..and replace 'VillainName' with the name of the player you're interested in. This will show your stats (specifically, the stats of the active player - the one selected in the player list) in hands where this villain was dealt in.
This is a tournament filter - if you play cash replace tourney_ with cash_.

[mousebreaker]

This works excellent. But when you want to look at your stats vs a player who has a name that is used on multible sites, then it doesnt work. It could easily be different players that has those names.

How can I solve that problem?

If the same player is playing multible sites with same screen name, then I could create an alias. But it will not work either unless I can change the alias name to something unique. How do I do that?

[kraada]

You can narrow it down to a specific site by adding p.id_site = X where X is the site identifier. So for example:

( 0 < (SELECT count(hhps.id_hand) FROM tourney_hand_player_statistics hhps WHERE hhps.id_hand = tourney_hand_player_statistics.id_hand AND hhps.id_player = (SELECT p.id_player FROM player p WHERE p.id_site = 100 and p.player_name='VillainName')) )

would restrict it to PokerStars only.

[mousebreaker]

So if I understand this correctly p.id_site = 100 is pokerstars
Where can I find id numbers for the different poker sites?

[kraada]

Code: Select all

100;"PokerStars"
200;"Party"
300;"Full Tilt"
400;"iPoker"
500;"Everest"
600;"OnGame"
700;"Boss Media"
800;"Cereus Network"
900;"Pacific Poker"
1000;"Entraction"
1100;"MicroGaming"
1200;"Cake"
1300;"Bodog"
1400;"Betfair"
1500;"Cryptologic Network"
1600;"Ultimate Bet (pre-Cereus)"
1700;"Absolute Poker (pre-Cereus)"
1900;"Tribeca Tables Network"
2100;"Merge"
2200;"Winamax"
2300;"Everleaf"
2400;"Yatahay Network"
2500;"Enet Network"
2600;"Barriere"

[rourkem]

Just a quick one please. How often do these codes get updated?

[WhiteRider]

They are not changed - they're only added to if a new site is added to PokerTracker.