help with buddy icon

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

help with buddy icon

Postby bobbydavro » Sun Dec 21, 2008 7:29 pm

Quick info on what I'm trying to do.

Using auto rate...I've categorised various players and now have them flagged under a new rated 'buddy' option (like fish if you like).

However I now want to mark all these players with the buddy icon so that they show up under table tracker. I realise I can go to the general tab sort by my icon and then manually click one by one but I thought it may be easier to go at them via the database using say pgAdmin.

So where would I find looking at the database the tables that contain
player
player icon
player buddy flag

is that all I would need?

Comments? Any problems you can forsee?

I don't actually know postgres but I should be able to work it out I'm just looking for pointers into the DB to save me searching through it all. I realise I need issue some kind of update command
bobbydavro
 
Posts: 42
Joined: Thu Feb 28, 2008 5:14 am

Re: help with buddy icon

Postby kraada » Mon Dec 22, 2008 10:46 am

The problem here is that the buddy list isn't actually stored in the database. At the moment it's stored entirely in the buddies.cfg file which lives in C:\Program Files\PokerTracker 3\Data\Config\.

The format of the file is:
Site number:true:"Screen Name";Site number:true:"Screen Name 2";

and so on for each opponent. So if you played on full tilt the site number is 300. You should be able to create a custom report that displays site number and screen name, then export the report to a CSV file, and edit that file to match the above layout and thus generate your own buddy list that way.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests