Changeset 3662

Timestamp:

01/28/07 05:46:05 (2 years ago)

Author:

diego_iastrubni

Message:

support for sqlite3. WIP.

SUBSTRING is not working for example. great.
The AUTOINCREMENT syntax we use in the newinstall.sql is broken. great
Some other things are broken here and there, I will try and find them all...

Files:

• freepbx/trunk/amp_conf/htdocs/admin/common/db_connect.php (modified) (1 diff)
• freepbx/trunk/amp_conf/htdocs/admin/modules/core/functions.inc.php (modified) (2 diffs)

freepbx/trunk/amp_conf/htdocs/admin/common/db_connect.php

@@ -49 +49 @@
-                $db->connect( $DSN );
-                break;
+
+        case "sqlite3":
+                if (!isset($amp_conf["AMPDBFILE"]))
+                        die("You must setup properly AMPDBFILE in /etc/amportal.conf");
+
+                if (isset($amp_conf["AMPDBFILE"]) == "")
+                        die("AMPDBFILE in /etc/amportal.conf cannot be blank");
+
+                require_once('DB/sqlite3.php');
+                $datasource = "sqlite3:///" . $amp_conf["AMPDBFILE"] . "?mode=0666";
+                $db = DB::connect($datasource);
+                break;
-        
-        default:

freepbx/trunk/amp_conf/htdocs/admin/modules/core/functions.inc.php

@@ -1488 +1488 @@
-        global $amp_conf;
-        
-$amp_conf["AMPDBENGINE"] == "sqlite"
+($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3") 
-        {
-                // TODO: sqlite work arround - diego 
@@ -1757 +1757 @@
-        global $amp_conf;
-        
-$amp_conf["AMPDBENGINE"] == "sqlite"
+($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3") 
-        {
-                // TODO: sqlite work arround - diego