PokerStars Chinese Collusion Ring Detector

[t3hnu7z]

Not in a single report, you could make each of those as a single report but they can't currently be combined.

I don't expect you to write these reports, but can you give me a hint on which section to start? Player Statistics, Tournament, or Tournaments?

[kraada]

You want to be in Tournaments. You'll want to add a custom filter that reads:
tourney_holdem_results.id_tourney in (SELECT tourney_holdem_results.id_tourney from tourney_holdem_results, player where player.id_player = tourney_holdem_results.id_player and player.player_name = 'Player A')

Adding that filter to a custom report will filter to all and only tournaments that Player A played in. If you then add yourself and Player B and show the ITM stat for both of you, you'll see your ITM % (and Player B's ITM %) in tournaments that included Player A.

To filter to tournaments without Player A change it to:

tourney_holdem_results.id_tourney not in (SELECT tourney_holdem_results.id_tourney from tourney_holdem_results, player where player.id_player = tourney_holdem_results.id_player and player.player_name = 'Player A')

If you want Player A or Player B:

tourney_holdem_results.id_tourney in (SELECT tourney_holdem_results.id_tourney from tourney_holdem_results, player where player.id_player = tourney_holdem_results.id_player and (player.player_name = 'Player A' OR player.player_name = 'Player B'))

Note also that you need those single quotes and the player's name needs to match their name exactly - case does matter here.

[t3hnu7z]

Thanks for those statements. I used them as a base to create a filter for a kind of cool report that shows who wins the most when I lose. This is the filter if anyone else wants to use it:

tourney_omaha_results.id_tourney in (SELECT tourney_omaha_results.id_tourney from tourney_omaha_results, player where player.id_player = tourney_omaha_results.id_player and player.player_name = 'T3H NU7Z' and tourney_omaha_results.amt_won = 0)

Obviously replace 'T3H NU7Z' with whatever your screenname is, and replace omaha with holdem as necessary.

The major downside to using the filters you provided, kraada, is that they require me to input specific names in them. I'm looking to run a more basic report that will go across the entire database of names. I've done this with my report, but I can't really do that with the filters you shared (unless I'm missing something).

[kraada]

Yes, that is one downside to this method. I'm not sure exactly what you mean by "the entire database of names" though - could you elaborate on what you are trying to do a bit more?

[t3hnu7z]

Yes, that is one downside to this method. I'm not sure exactly what you mean by "the entire database of names" though - could you elaborate on what you are trying to do a bit more?

Ok, here's what I would like the report to do. I'd like it to be able to compare everyone with... everyone else. For instance, say we only had a database of 4 players: Joe, Bob, Dave, and Jerry. I'd like the report to generate this:

Joe Bob (stats filtered on tournaments involving both Joe & Bob)
Joe Dave (stats filtered on tournaments involving both Joe & Dave)
Joe Jerry (stats filtered on tournaments involving both Joe & Jerry)
Bob Dave (stats filtered on tournaments involving both Bob & Dave)
Bob Jerry (stats filtered on tournaments involving both Bob & Jerry)
Dave Jerry (stats filtered on tournaments involving both Dave & Jerry)

Of each combination be able to give stats on both participants, such that in the "Bob Jerry" combo, I can see ITM% for each player when they play together, also how often they play together vs. apart, etc.

It's actually quite complicated, so I'm not sure if it can even be done. Essentially it's like changing the filter over and over and over within the same report.

[WhiteRider]

Kraada isn't working today but I'm sure he'll get back to you tomorrow.

[kraada]

I see what you are saying though I can't think of a way to do that at this point in time.

Though one thing comes to mind: even if you could build it, you'd want to have a certain amount of tournaments together for the data to actually mean anything. So what you might want to do is just check to see how many tournaments various people have played in your database then run reports for together/apart for those combinations for the people who are most common in your database.

[t3hnu7z]

Yeah, it's asking a bit much I guess. Just looking for the easiest way to flag possible colluders. What I'll do is run my new "Winners When I Lose" report and take the strongest winners and compare them with each other. Thanks for your help.

[kraada]

Good luck.