Changeset 986

Timestamp:

08/27/08 08:27:40 (3 months ago)

Author:

areski

Message:

change from mysql to mysqli and enable autocommit

Files:

• trunk/common/lib/admin.defines.php (modified) (2 diffs)
• trunk/common/lib/agent.defines.php (modified) (1 diff)
• trunk/common/lib/Class.A2Billing.php (modified) (1 diff)
• trunk/common/lib/customer.defines.php (modified) (1 diff)

trunk/common/lib/admin.defines.php

@@ -158 +158 @@
-        /*      $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;  */
-        
-
+ 
-                $datasource = 'pgsql://'.USER.':'.PASS.'@'.HOST.'/'.DBNAME;
-        }else{
@@ -166 +166 @@
-        $DBHandle = NewADOConnection($datasource);
-        if (!$DBHandle) die("Connection failed");
+        
+        if (DB_TYPE == "mysqli") {
+                $DBHandle -> Execute('SET AUTOCOMMIT=1');
+        }
-        
-        return $DBHandle;

trunk/common/lib/agent.defines.php

@@ -169 +169 @@
-        if (!$DBHandle) die("Connection failed");
-        
+        if (DB_TYPE == "mysqli") {
+                $DBHandle -> Execute('SET AUTOCOMMIT=1');
+        }
+        
-        return $DBHandle;
-}

trunk/common/lib/Class.A2Billing.php

@@ -2560 +2560 @@
-                $this->DBHandle = NewADOConnection($datasource);
-                if (!$this->DBHandle) die("Connection failed");
-
+
+
+
+
+
-                return true;
-        }

trunk/common/lib/customer.defines.php

@@ -170 +170 @@
-        if (!$DBHandle) die("Connection failed");
-        
+        if (DB_TYPE == "mysqli") {
+                $DBHandle -> Execute('SET AUTOCOMMIT=1');
+        }
+        
-        return $DBHandle;
-}