GameTime+ 1.4.4 available, supports PostgreSQL

Kevin · **Joined:** Tue Nov 23, 2004 3:50 pm **Posts:** 426

http://prdownloads.sourceforge.net/game ... e?download

Adds support for PostgreSQL databases. Of course you must have the PostgreSQL version of PokerTracker to utilize this.

In this version, it will remember your database login/password for as long as GT+ is running, but it doesn't save it anywhere. So everytime you restart GT+, you'll have to enter the login info again. This might change in a future version.

Also, for postflop aggression factor, previosuly it would show 0.0 if your opponent was very passive (never bet or raised), and also 0.0 if they were infinitely aggressive (always bets/raises, never just calls). Now it will show the infinity symbol for those cases when they are infinitely aggressive, and 0.0 for the infinitely passive.

-- Kevin

APerfect10 · **Joined:** Sun Feb 27, 2005 7:04 pm **Posts:** 12

Excellent work!

You'd think that the commercial counterpart would be able to do these types of updates faster but that is not the case...

Congrats...

Bly · **Joined:** Wed Jun 01, 2005 5:56 pm **Posts:** 2

I'm running a remote Postgre database and I'm getting errors when I try to connect.

It's the same error that you'd get if you turned off your local Postgre service and tried to load a table.

Poker tracker see the remote DB perfectly...

Error code displayed:

Error Number: 80040e4d
Unexpected protocol character during authentication;
Errorw while reading from the socket.

Second error diplayed:

Error
Code = 80040e4d
Code Meaning = IDispatch error #3419
Source = Microsoft OLE DB provider for ODBC drivers
Description = Unexpected protocol character during authentication; Error reading from the socket.

gg_1 · **Joined:** Sat Mar 26, 2005 8:54 am **Posts:** 11

v1.4.5 has never worked for me with PSQL databases. Like the the other poster I am getting a database error:
A database error has ocurred Error number:80040e4d Authentication failed. Is GameTime+ ever going to work PSQL...is there a fix I need to make ?? Seems like a recurring problem for a quite a few players which hasnt been addressed or I missed the post ?

triplef · **Joined:** Tue Apr 03, 2007 12:43 pm **Posts:** 1

actually its hard coded as access .. if it doesnt finda reg entry for a dll

the part to change is in trackermgr.cpp

Code:

if( strDriver.find( "psqlodbc.dll" ) != string::npos )
         _type = PostgreSQL;
      else
         _type = PostgreSQL;
         //         _type = Access;

i overwrote the csource.. it reads pgsql fine now.. but errors on some undeclared variable i...

this code is really messed when converted to vs 2005.

not sure what do do at this point..

bad code is in trackermgr.cpp

Code:

char *pszX = strtok( (char *)strPts.c_str(), " " );
   for( int i = 0; i < 11; i++ )
   {
      char *pszY = strtok( NULL, " " );

      if( !pszX || !pszY )
         break;

      pts[i].x = atoi( pszX );
      pts[i].y = atoi( pszY );

      if( pts[i].x < -500 || pts[i].x > 2000 )
         pts[i].x = 100;
      if( pts[i].y < -500 || pts[i].y > 2000 )
         pts[i].y = 100;

      pszX = strtok( NULL, " " );
   }
 

   for( int i = 0; i < 11; i++ )
   {
      pts[i].x = pts[i].y = 100;
      strRegValue += " 285 173";
   }

   reg[ strReg ] = strRegValue;
   reg.save();

especially

Code:

for( int i = 0; i < 11; i++ )
   {
      pts[i].x = pts[i].y = 100;
      strRegValue += " 285 173";
   }

Akin1 · **Joined:** Sun Jul 01, 2007 5:40 pm **Posts:** 1

I changed in to postgreSQL with PT. I read instructions to get GT+ work with it here: http://www.pokertracker.com/forum/viewtopic.php?t=20419.

I changed to run as administrator and typed admin password. Password is presumably correct, because if I type other password it says so. I click OK, but when I come back to check it is changed back as "current user" and I got again message: A database error has occurred. Error number: 80040e4d Authentication failed.

Has anyone suggestions? I would be appreciated. Thanks in advance.

alon.albert · **Joined:** Sun Jul 22, 2007 6:55 am **Posts:** 2

I got the source code and fixed the problem. At least it works on my system. Here's a CVS patch:

Code:

Index: TrackerMgr.cpp
===================================================================
RCS file: /cvsroot/gametimeplus/GameTimePlus/TrackerMgr.cpp,v
retrieving revision 1.7
diff -u -r1.7 TrackerMgr.cpp
--- TrackerMgr.cpp   5 Sep 2005 01:24:04 -0000   1.7
+++ TrackerMgr.cpp   22 Jul 2007 14:52:56 -0000
@@ -129,7 +129,7 @@
    {
       RegTable reg( HKEY_LOCAL_MACHINE, ( "Software\\ODBC\\ODBC.INI\\" + strDSN ).c_str() );
       string strDriver = reg[ "Driver" ];
-      if( strDriver.find( "psqlodbc.dll" ) != string::npos )
+      if( strDriver.find( "psqlodbc" ) != string::npos )
          _type = PostgreSQL;
       else
          _type = Access;
@@ -231,7 +231,13 @@
 pair<string, string> TrackerMgr::_getPassword( const string & strDSN, HWND hwndParent )
 {
    RegTable reg( HKEY_LOCAL_MACHINE, "Software\\PTrack" );
-   return pair< string, string > ( (string) reg[ "PSQLUID" ], (string) reg[ "PSQLPWD" ] );
+   string settings = (string) reg["PSQL_SETTINGS"];
+   size_t p1 = settings.find('\t');
+   size_t p2 = settings.find('\t', p1 + 1);
+   string username = settings.substr(0, p1);
+   string password = settings.substr(p1 + 1, p2 - p1 -1);
+
+   return pair< string, string > ( username, password );
 #if 0
    if( _userpassCache.find( strDSN ) == _userpassCache.end() )
    {

frrrrits · **Joined:** Mon Jul 16, 2007 2:49 am **Posts:** 3

Very strange happend, i converted to
a postresq database a time ago and used the patches when i got the 800404ed errors. Everything was working fine the past few months and now all of a sudden i get on stats displayed. I haven't changed any settings in PT or Gametime. If i start gametime i get no errors but he doesn't automaticly displays my stats anymore nor manualy because the table names are nowhere to be found in the GT + database list.

Has anyone encountered the same problem? I have reinstalled GT + several times but that doesn't seem to work as well.

By the way i'm using XP no Vista

smaug · **Joined:** Thu Dec 13, 2007 8:19 am **Posts:** 3

It still doesn't work with PostgreSQL...
Asked around a bit on a pokerforum I frequent and everybody gets these errormessages.

Is this gonna get fixed in the near future?

Kevin · **Joined:** Tue Nov 23, 2004 3:50 pm **Posts:** 426

Have you tried the new testing version mentioned in the announcements in this forum? It fixes the problem with PGSQL mentioned above.

If that doesn't fix the problem, can you give me more info on the exact problem you're having?

Thanks!
-- Kevin

smaug · **Joined:** Thu Dec 13, 2007 8:19 am **Posts:** 3

that did the trick! thanks

TheDino · **Joined:** Sat Dec 22, 2007 1:57 pm **Posts:** 3

doesn't work for me:

Error number: 80004005
ERROR: date/time field value out of range: "24:00:00"

Kevin · **Joined:** Tue Nov 23, 2004 3:50 pm **Posts:** 426

TheDino wrote:

doesn't work for me:

Error number: 80004005
ERROR: date/time field value out of range: "24:00:00"

Hmm, that's weird. Haven't seen that one before. When does this error happen?

TheDino · **Joined:** Sat Dec 22, 2007 1:57 pm **Posts:** 3

always when i want to switch from "my first poker tracker database" to "my first poker tracker database (postgresql)"

with 1.4.4 i got another error, then i installed the new testing version and with that version i get the error i mentioned

Kevin · **Joined:** Tue Nov 23, 2004 3:50 pm **Posts:** 426

TheDino wrote:

always when i want to switch from "my first poker tracker database" to "my first poker tracker database (postgresql)"

with 1.4.4 i got another error, then i installed the new testing version and with that version i get the error i mentioned

I have both Access and PGSQL databases, and I can switch back and forth between them without any problem. What version of PGSQL are you using?

The Poker Dominion

GameTime+ 1.4.4 available, supports PostgreSQL

Who is online