Changeset 416

Timestamp:

Jul 3, 2013 1:00:48 PM (11 years ago)

Author:

anonymous

Message:

Added reconnect method to DB, and testing current connection status using mysql_ping.

File:

• trunk/lib/DB.inc.php (modified) (3 diffs)

trunk/lib/DB.inc.php

@@ -161 +161 @@
             }
 
-            // Die if db_die_on_failure = true, or just continue without connection
+            // Die if db_die_on_failure = true, or just continue without connection.
             return $this->_fail();
         }
@@ -190 +190 @@
             return false;
         }
-
+        $this->_connected = false;
         return mysql_close($this->dbh);
+    }
+    
+    /*
+    * 
+    *
+    * @access   public
+    * @param    
+    * @return   
+    * @author   Quinn Comendant <quinn@strangecode.com>
+    * @version  1.0
+    * @since    03 Jul 2013 14:50:23
+    */
+    function reconnect()
+    {
+        $this->close();
+        $this->connect();
     }
     
@@ -284 +300 @@
             echo "<!-- ----------------- Query $this->_query_count ---------------------\n$debugqry\n-->\n";
         }
+        
+        sleep(30);
+        
+        // Ensure we have an active connection.
+        if (!mysql_ping($this->dbh)) {
+            $app->logMsg('MySQL ping failed; reconnecting
', LOG_NOTICE, __FILE__, __LINE__);
+            $this->reconnect();
+        }
 
         // Execute!