Stars Buddy List AHK Script

[wildzer0]

Hey, didn't see your post for a few days, Reef. I'm a little confused - did you run the script before you made your buddy list? 2 possible explanations are that the script didn't find any buddies online (would happen if your buddies.txt file was empty when you ran the script or none of them were on and result in the file not being written) or your c:\ drive is named something different? You can edit the script to put the file anywhere you would like, so check the path and make sure it's ok.

[Reef]

made the buddy list with about 100 names. Ran the script afterwards. I'll try it again and check the path. thx

[wildzer0]

I was just messing around with my PT database this morning and came up with this query to generate a buddy list automatically. Here it is if anyone wants to use it - works on postgres. You can change the values in the HAVING clause - the first line is number of hands, then, VP%IP, then WTSD

[ QUOTE ]

select players.screen_name as screenName
FROM (game INNER JOIN game_players ON game.game_id = game_players.game_id
INNER JOIN players ON game_players.real_player_id = players.player_id)
GROUP BY players.screen_name
HAVING (COUNT(game_players.game_id) > 100)
AND (AVG(game_players.vol_put_money_in_pot) > .5)
and (SUM (game_players.went_to_showdown_n) * 100 / SUM (game_players.saw_flop_n) > 33)
ORDER BY (AVG(game_players.vol_put_money_in_pot));



[/ QUOTE ]

[PLOlover]

How do u run a query on PT database?

[wildzer0]

http://www.pokertracker.com/forum/viewforum.php?f=11

[NoahSD]

God, it would be amazing if this were slightly more sophisticated... i.e., showed which tables the fish were at, maybe even gave you a screen to open them.

[wildzer0]

[ QUOTE ]
God, it would be amazing if this were slightly more sophisticated... i.e., showed which tables the fish were at, maybe even gave you a screen to open them.

[/ QUOTE ]

It would be, but unfortunately there is no way to read the "found player" box in autohotkey as far as I know. So I believe we're stuck with this pretty much the way it is.

[TheMetetron]

[ QUOTE ]
How do u run a query on PT database?

[/ QUOTE ]

That link to the PT forum was useless. Anyone want to cliff notes this for me?