Online Spades

Table of contents

First steps:
Configuration of Pokertracker 3 databases.
Configuration of Pokertracker PostgreSQL databases.
Configuration of Pokertracker Access databases.
Configuration of Pokeroffice mySQL databases.
Configuration of Pokermanager Firebird databases.
Configuration of Holdem Manager databases.
The Mainwindow
Deeper look into the Options:
Profiles
How to use CSV files
Remarks:
Pokertracker PostgreSQL installation

New: German guide

Configuration of Pokertracker 3 databases

Open the "Databases"-tab from the options dialog.
- Set "Type" to "PokerTracker 3"
- Set "Host" to "localhost"
- Set "Port" to "5432"
- Set "Database" to "PT3 DB"
- Set "Username" to "postgres"
- Set "Password" to "dbpass"

The above are the default PokerTracker 3 settings.
Maybe you set a different "Database"-name.
Then you need to take a closer look at "database->database management" in PokerTracker 3.
There you can see all your databases.
Important: You need to use the name from the most right column "database info".

Configuration of Pokertracker PostgreSQL databases


  • Open the "Databases"-tab from the options dialog.
  • Select "Pokertracker (PostgreSQL)" from the listbox.
  • Insert "localhost" for "Host".
  • Default port is "5432". So insert "5432" as "Port" unless you installed PostgreSQL on another port.
  • Put the name of the database you wish to add in the field "Database".
    One can get this name by starting Pokertracker and going to "File"->"Maintain Database Names", as shown in the picture:

    Be careful: One have to use the Value from the column "DB File/DB Name/DSN" which is casesensitive!
  • Put your username and password for the database in the fields "Username" and "Password".
  • Now press "Add Database".
  • If everything went right, the Database will be added to the list.
    If a failure occurs a messagebox will show extended information about the error.

    Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    A small video on how to configure a Pokertracker PostgreSQL database with Telescope can be seen here

    Configuration of Pokertracker Access databases


  • Open the "Databases"-tab from the options dialog.
  • Select "Pokertracker (Access)" from the listbox.
  • Put the name and fullpath of the Accessdatabase you wish to add in the field "Database" (for example "C:/Programme/Poker Tracker V2/ptrack.mdb").
  • Now press "Add Database".
  • If everything went right, the Database will be added to the list.
    If a failure occurs a messagebox will show extended information about the error.

    Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    A small video on how to configure a Pokertracker Access database with Telescope can be seen here

    Configuration of PokerOffice mySQL databases


  • Open the "Databases"-tab from the options dialog.
  • Select "PokerOffice (mySQL)" from the listbox.
  • Insert "localhost" for "Host".
  • Put the name of the database you wish to add in the field "Database" ("PokerOffice" in most cases).
  • Put your username and password for the database in the fields "Username" and "Password" (in most cases username:"root" and leave password empty).
  • Now press "Add Database".
  • If everything went right, the Database will be added to the list.
    If a failure occurs a messagebox will show extended information about the error.

    Note :To add other databases than the default database "pokeroffice" is a bit tricky,
    because there is a difference between the real databasename and the name that Pokeroffice displays.
    If the Pokerofficename of your database is for example "Nov2006" then the real databasename is always extended by "_podb".
    So you would have to add a database called "Nov2006_podb" in Telescope.

    Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    Configuration of Pokermanager Firebird databases


  • Open the "Databases"-tab from the options dialog.
  • Select "Pokermanager (Firebird)" from the listbox.
  • Insert "localhost" for "Host".
  • Put the full path to your database file (*.fdb) into the fiel "Database".
    One can get this path by starting Pokermanager and going to "Tools"->"Advanced"->"Database Connection..." as shown in the picture:

    In the examples case we would have to put "C:\Programme\PokerManager\PokerManager.fdb" into "Database".
  • Put your username and password for the database in the fields "Username" and "Password".
    In most cases username is "sysdba" and password is "masterkey".
  • Now press "Add Database".


  • Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    Configuration of Holdem Manager databases

  • Open the "Databases"-tab from the options dialog.
  • Select "Holdem Manager" from the listbox.
  • Insert "localhost" for "Host".
  • Default port is "5432". So insert "5432" as "Port" unless you installed PostgreSQL on another port.
  • Put "HoldemManager" in the field "Database".
  • Put your username and password for the database in the fields "Username" and "Password".
  • Now press "Add Database".

  • Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    The mainwindow



    The Mainwindow is split into 3 parts.
    The upper part is the list of available tables.
    The middle part are the players which are sitting at a selected table from the upper part.
    The lower part is a list of all players at all tables.
    So the lower part gives you an overview of for example:
    - "where are the 'worst' players playing"
    - "how much tables do a player play"
    and so on...

  • Get Table List: Retrieves the list of tables from the currently selected limit in the Pokerclient software.
  • Scan This Table: If a table from the list is selected the playerstatistics are computed from the databases.
  • Scan All Tables: Refreshs the tablelist and computes the playerstatistics.
  • Open: Opens the selected table.
  • Join: Joins the waitinglist of the table, if the table is full, otherwise the table gets opened.
  • Deeper look into the Options: Profiles


    In order to identify "good" and "bad" tables with one look, it is possible to specify his own colorprofiles for VPIP, PFR, AF and number of hands.
    A profile only gets activated if more then the specified value of hands of a player are available from the database.
    This will help to prevent the distortion of the tablestatistics if only very few hands of a player are available.

    How to use CSV files

    You can search your Pokertracker database for buddies and import them via CSV-file into Telescope.
    - Open Pokertracker and go to "File"->"Ring game player statistics".
    - Go to the "Preferences" tab as shown in image 1.

    Image 1: Pokertracker preferences
    - Activate the filter and specify the statistics the buddies should have.
    - Go to the "Summary" tab and press the small "e" for "Export" (image 2).

    Image 2: Pokertracker summary
    - Uncheck all rows except "Player" (image 3).
    Note:This list is scrollable.
    - Select "Comma seperated" as file type.
    - Uncheck "Include Headers".
    - Insert a filename and press "Export".

    Pokertracker PostgreSQL installation

    Please visit the Pokertracker guide here:
    Guide