Pacemaker
03-11-2012
, 08:32 AM
Pacemaker
I made this little tool, which helps to keep track of how many hands you play daily and should motivate you to "keep pace".
It's a "Windows Gadget", a little scripted app that sits on your desktop.
I hereby release it to the public (MIT License) so that all of you grinders can profit.
The big needle shows how many hands you are ahead or behind your goal - zero is "right on track". The small pointer shows how many hands you played today. The dot shows your setting for "daily hands". The scale adapts up to 20k hands per day (sickos who play more than that are not supported). The gadget has a transparent background. It can display black or white text so it looks good on any wallpaper.
You can adapt it to your needs. Changing the graphics is quite easy. I even included the original Photoshop and Illustrator files I used to create the graphics. To change the scripts you just need a texteditor but you need to know what you are doing.
Requirements
Windows Vista or newer (only Windows 7 is tested)
An SQL-database which stores your played hands (you have this if you use PT, HEM or similar tools)
Warning: If you use anything other than PT, you will have to edit a script to make it work (you need to know your database structure)
Installation
Sadly, this is NOT easy and I won't support you personally.
If you can't make it work, following the instructions here, just post in this thread and maybe some other 2+2er will help you.
First, have a look at this link:
Microsoft introduction to the Gadget Platform
Scroll down to "Debugging" and set the mentioned registry key to 1 (click Start -> Run... -> enter regedit)
Download Pacemaker
http://dl.dropbox.com/u/1518253/Poke...ker.gadget.zip
Unzip it and copy the folder to this location:
%localappdata%\Microsoft\Windows Sidebar\Gadgets
(copy/paste this address into an explorer window address-bar)
Install ODBC-driver
In the Pacemaker.gadget folder open the folder support.
If you use PT and 64-bit Windows, install "setup_psqlODBC_x64_8.3.4.0" ODBC-driver.
If you use PT and 32-bit Windows, get the driver here.
If you use something else than PT, you're on your own. Possibly you already have a driver. Check what flavour of SQL your application uses and if the driver is installed (the file above is for PostgreSQL, 64-bit). To see what drivers are installed, run "ODBC Datasources Administrator" (enter ODBC in Start -> search).
Find your player ID (only for PT users)
Open "pgAdmin III" from Applications -> PostgreSQL
In the Object Browser doubleclick "PostgreSQL DB Server", navigate to Databases -> your currently used PT-database
Click the SQL-icon
In the top left part of the window enter this query:
Put your screenname in, for example player_name = 'grinder';
Click the play-icon to execute the query.
You should get a result in the output pane. Write down your player ID.
Close the query window and pgAdmin.
Adjust settings
In the Pacemaker.gadget folder, edit pacemaker.js in a texteditor (rightclick -> Edit)
Enter your player ID in the top section. (ignore if you don't use PT)
Edit the line DB_CONNECTION to match your database (name, password etc.). To get the exact name of your ODBC driver, run "ODBC Datasources Administrator" (enter ODBC in Start -> search). On the tab "Drivers" use the value under name.
If you don't use PT, scroll down to the function "Update()". You need to change the query to extract the number of hands you played since a certain date.
The important part is in the following two lines:
Save pacemaker.js
Use Pacemaker
Rightclick on your desktop -> Gadgets.
Drag Pacemaker to the desktop.
If you get a script error, find out what went wrong and fix it (re-check all the steps above).
If there is no error, congratulations!
To adjust the settings, move your mousepointer over the gadget until you see the settings icon. Click the wrench.
Help others
If you got this to work with something else than PT or know how to solve an issue not mentioned above, please post how you did it, so other users can do it too.
I made this little tool, which helps to keep track of how many hands you play daily and should motivate you to "keep pace".
It's a "Windows Gadget", a little scripted app that sits on your desktop.
I hereby release it to the public (MIT License) so that all of you grinders can profit.
The big needle shows how many hands you are ahead or behind your goal - zero is "right on track". The small pointer shows how many hands you played today. The dot shows your setting for "daily hands". The scale adapts up to 20k hands per day (sickos who play more than that are not supported). The gadget has a transparent background. It can display black or white text so it looks good on any wallpaper.
You can adapt it to your needs. Changing the graphics is quite easy. I even included the original Photoshop and Illustrator files I used to create the graphics. To change the scripts you just need a texteditor but you need to know what you are doing.
Requirements
Windows Vista or newer (only Windows 7 is tested)
An SQL-database which stores your played hands (you have this if you use PT, HEM or similar tools)
Warning: If you use anything other than PT, you will have to edit a script to make it work (you need to know your database structure)
Installation
Sadly, this is NOT easy and I won't support you personally.
If you can't make it work, following the instructions here, just post in this thread and maybe some other 2+2er will help you.
First, have a look at this link:
Microsoft introduction to the Gadget Platform
Scroll down to "Debugging" and set the mentioned registry key to 1 (click Start -> Run... -> enter regedit)
Download Pacemaker
http://dl.dropbox.com/u/1518253/Poke...ker.gadget.zip
Unzip it and copy the folder to this location:
%localappdata%\Microsoft\Windows Sidebar\Gadgets
(copy/paste this address into an explorer window address-bar)
Install ODBC-driver
In the Pacemaker.gadget folder open the folder support.
If you use PT and 64-bit Windows, install "setup_psqlODBC_x64_8.3.4.0" ODBC-driver.
If you use PT and 32-bit Windows, get the driver here.
If you use something else than PT, you're on your own. Possibly you already have a driver. Check what flavour of SQL your application uses and if the driver is installed (the file above is for PostgreSQL, 64-bit). To see what drivers are installed, run "ODBC Datasources Administrator" (enter ODBC in Start -> search).
Find your player ID (only for PT users)
Open "pgAdmin III" from Applications -> PostgreSQL
In the Object Browser doubleclick "PostgreSQL DB Server", navigate to Databases -> your currently used PT-database
Click the SQL-icon
In the top left part of the window enter this query:
Code:
SELECT player_name, id_player FROM player WHERE player_name = 'Your Name';
Click the play-icon to execute the query.
You should get a result in the output pane. Write down your player ID.
Close the query window and pgAdmin.
Adjust settings
In the Pacemaker.gadget folder, edit pacemaker.js in a texteditor (rightclick -> Edit)
Enter your player ID in the top section. (ignore if you don't use PT)
Edit the line DB_CONNECTION to match your database (name, password etc.). To get the exact name of your ODBC driver, run "ODBC Datasources Administrator" (enter ODBC in Start -> search). On the tab "Drivers" use the value under name.
If you don't use PT, scroll down to the function "Update()". You need to change the query to extract the number of hands you played since a certain date.
The important part is in the following two lines:
Code:
rs = conn.Execute("SELECT COUNT(*) FROM holdem_hand_player_statistics WHERE date_played > '" + queryDate + "' AND id_player = " + PLAYER_ID + ";");
rs = conn.Execute("SELECT COUNT(*) FROM holdem_hand_player_statistics WHERE date_played > '" + playDay + "' AND id_player = " + PLAYER_ID + ";");
Use Pacemaker
Rightclick on your desktop -> Gadgets.
Drag Pacemaker to the desktop.
If you get a script error, find out what went wrong and fix it (re-check all the steps above).
If there is no error, congratulations!
To adjust the settings, move your mousepointer over the gadget until you see the settings icon. Click the wrench.
Help others
If you got this to work with something else than PT or know how to solve an issue not mentioned above, please post how you did it, so other users can do it too.
Last edited by Fingerswinger; 03-11-2012 at 08:51 AM.
05-20-2012
, 11:34 AM
05-24-2012
, 02:47 PM