lookup_isbuddy

[fanatus]

Hello, guys!

I am working on a SQL query to find my current buddy list in pokertracker v3.00. I found out that there should be a function lookup_isbuddy but if a I looked at the tables that were specified in the DB, i could not find it.

My query looks like this:

SELECT lookup_isbuddy(player.player_name, holdem_table_session_summary.id_site) AS Is_This_Player_Buddy,
player.player_name AS This_Player_Is_Called
FROM player, holdem_table_session_summary
WHERE player.id_player = holdem_table_session_summary.id_player;

Could you help me understand how to use this function lookup_isbuddy or am I supposed to write a new function? If so, than how does the function that finds buddy list works? ;)

[kraada]

I'm not sure where you heard about lookup_isbuddy but there is no such lookup table in the database as far as I am aware.

The buddy list is available in the Buddies.cfg file in C:\Program Files\PokerTracker 3\Data\Config\. It's a text file containing the site name, the player name and "true", delimited by colons and semicolons. If you take a look at it, it should be fairly easy to understand.

[fanatus]

That was useful.
Thank You, Buddy