Microgaming import problems

[cantonaa]

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.

[kraada]

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.

[cantonaa]

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

[kraada]

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.

[BaKsZiom]

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

[ALL_NI_VIRUS]

Hope this prob. will be fixed VERY soon !!

[cantonaa]

Agree...

[karbes]

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();
      
   }
   
}


[kraada]

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.

[sofian47]

how do you use the Java code?