From 5e57558919a100a5a09c46bc890f943eeb9c54a5 Mon Sep 17 00:00:00 2001
From: mcramer <m.cramer@pixcept.de>
Date: Sat, 16 Jun 2012 07:42:36 -0400
Subject: [PATCH] Changed the way external db connections are configured (added prefix option to db class)

---
 interface/web/tools/dns_import_tupa.php |   21 ++++++++++++---------
 interface/lib/classes/db_mysql.inc.php  |   19 ++++++++++---------
 2 files changed, 22 insertions(+), 18 deletions(-)

diff --git a/interface/lib/classes/db_mysql.inc.php b/interface/lib/classes/db_mysql.inc.php
index 91b0286..c4db48d 100644
--- a/interface/lib/classes/db_mysql.inc.php
+++ b/interface/lib/classes/db_mysql.inc.php
@@ -47,16 +47,17 @@
   public $show_error_messages = true; // false in server, true in interface
 
   // constructor
-  public function __construct() {
+  public function __construct($prefix = '') {
     global $conf;
-    $this->dbHost = $conf['db_host'];
-    $this->dbName = $conf['db_database'];
-    $this->dbUser = $conf['db_user'];
-    $this->dbPass = $conf['db_password'];
-    $this->dbCharset = $conf['db_charset'];
-    $this->dbNewLink = $conf['db_new_link'];
-    $this->dbClientFlags = $conf['db_client_flags'];
-    parent::__construct($conf['db_host'], $conf['db_user'],$conf['db_password'],$conf['db_database']);
+    if($prefix != '') $prefix .= '_';
+    $this->dbHost = $conf[$prefix.'db_host'];
+    $this->dbName = $conf[$prefix.'db_database'];
+    $this->dbUser = $conf[$prefix.'db_user'];
+    $this->dbPass = $conf[$prefix.'db_password'];
+    $this->dbCharset = $conf[$prefix.'db_charset'];
+    $this->dbNewLink = $conf[$prefix.'db_new_link'];
+    $this->dbClientFlags = $conf[$prefix.'db_client_flags'];
+    parent::__construct($conf[$prefix.'db_host'], $conf[$prefix.'db_user'],$conf[$prefix.'db_password'],$conf[$prefix.'db_database']);
     if ($this->connect_error) {
       $this->updateError('DB::__construct');
       return false;
diff --git a/interface/web/tools/dns_import_tupa.php b/interface/web/tools/dns_import_tupa.php
index 2e2cbcb..bbc8ded 100644
--- a/interface/web/tools/dns_import_tupa.php
+++ b/interface/web/tools/dns_import_tupa.php
@@ -56,19 +56,22 @@
 	$msg .= 'Connecting to external database...<br />';
 	
 	//* Backup DB login details
-	$conf_bak['db_host'] = $conf['db_host'];
+	/*$conf_bak['db_host'] = $conf['db_host'];
 	$conf_bak['db_database'] = $conf['db_database'];
 	$conf_bak['db_user'] = $conf['db_user'];
-	$conf_bak['db_password'] = $conf['db_password'];
+	$conf_bak['db_password'] = $conf['db_password'];*/
 	
 	//* Set external Login details
-	$conf['db_host'] = $_POST['dbhost'];
-	$conf['db_database'] = $_POST['dbname'];
-	$conf['db_user'] = $_POST['dbuser'];
-	$conf['db_password'] = $_POST['dbpassword'];
+	$conf['imp_db_host'] = $_POST['dbhost'];
+	$conf['imp_db_database'] = $_POST['dbname'];
+	$conf['imp_db_user'] = $_POST['dbuser'];
+	$conf['imp_db_password'] = $_POST['dbpassword'];
+    $conf['imp_db_charset'] = $conf['db_charset'];
+    $conf['imp_db_new_link'] = $conf['db_new_link'];
+    $conf['imp_db_client_flags'] = $conf['db_client_flags'];
 	
 	//* create new db object
-	$exdb = new db();
+	$exdb = new db('imp');
 	
 	$server_id = 1;
 	$sys_userid = 1;
@@ -138,10 +141,10 @@
 	}
 	
 	//* restore db login details
-	$conf['db_host'] = $conf_bak['db_host'];
+	/*$conf['db_host'] = $conf_bak['db_host'];
 	$conf['db_database'] = $conf_bak['db_database'];
 	$conf['db_user'] = $conf_bak['db_user'];
-	$conf['db_password'] = $conf_bak['db_password'];
+	$conf['db_password'] = $conf_bak['db_password'];*/
 	
 }
 

--
Gitblit v1.9.1