PokerTracker

Hello!

My skin on Microgaming had an update today, and since I downloaded it PT3 fails to import hands. I get this message:

MicroGaming: Warning: Unrecognized game type: Hold'em (hand #xxxxxxxxxx)


Is there anything I can do about this or do I need to wait for a newer version of PT3?


Thanks.

This is a known issue that is on our list to be fixed. I don't know for certain when it will be fixed but I'd be surprised if it wasn't fixed for the next Beta release.

Are we talking days or weeks until the next Beta release?

Hopefully days, but I can't say how many for certain. A breakthrough was made yesterday though in fixing some of the lag problems which existed in the latest alphas. I think there are a few more things that need fixing/testing but I think we're close, for what it's worth.

Please fix it as fast as possible i can't play without hud.

Hope this prob. will be fixed VERY soon !!

Agree...

Here is a Java code which fixes the microgaming database:

Code: Select all

package primafix;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class PrimaFix {

   /**
    * @param args
    */
   public static void main(String[] args) throws Exception {
      
      PrimaFix fx = new PrimaFix();
      fx.start();
   }
   
   public void start() throws Exception{
      Class.forName("org.sqlite.JDBC");
         Connection conn = DriverManager.getConnection("jdbc:sqlite:C:/MicroGaming/Poker/triobetMPP/gamehistory.dat");
         Statement stat = conn.createStatement();
         PreparedStatement prep = conn.prepareStatement(
             "select * from handhistory where gametype='Hold''em'");
      //"select * from handhistory where xmldump like '%Hold'em%'");

         conn.setAutoCommit(false);

         ResultSet rs = prep.executeQuery();
         PreparedStatement prep2 = conn.prepareStatement("update handhistory set gametype='Hold ''em' where handid=?");
         PreparedStatement prep3 = conn.prepareStatement("update handhistory set XMLDump=? where handid=?");
         int count = 0;
         while (rs.next()) {
            count++;
            long handid = rs.getLong("handid");
            String xmlDump = rs.getString("XMLDump");
             System.out.println(count + ". fixing hand " + handid);
             prep2.setLong(1, handid);
             prep2.executeUpdate();
             String newXml = xmlDump.replaceAll("Hold'em", "Hold 'em");
             prep3.setString(1, newXml);
             prep3.setLong(2, handid);
             prep3.executeUpdate();
         }
         rs.close();
         conn.commit();
         conn.close();
      
   }
   
}


Thanks, though we do have it already fixed natively for the next beta release. Hopefully that will happen within a few days at the outside, but that program does look like it will work in the meantime for those who need it.

how do you use the Java code?