From 0e3df6c91773d06145b8d37e3d9d79a3ffa8be99 Mon Sep 17 00:00:00 2001
From: Marius Cramer <m.cramer@pixcept.de>
Date: Sun, 15 Nov 2015 08:42:39 -0500
Subject: [PATCH] - Changed APS to 1.2 - Fixed error in mysql library

---
 interface/lib/classes/aps_guicontroller.inc.php |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/interface/lib/classes/aps_guicontroller.inc.php b/interface/lib/classes/aps_guicontroller.inc.php
index db1c148..3a5084c 100644
--- a/interface/lib/classes/aps_guicontroller.inc.php
+++ b/interface/lib/classes/aps_guicontroller.inc.php
@@ -287,6 +287,7 @@
 		//* Create the mysql database user if not existing
 		$tmp = $app->db->queryOneRecord("SELECT database_user_id FROM web_database_user WHERE database_user = ?", $settings['main_database_login']);
 		if(!$tmp) {
+			$tmppw = $app->db->queryOneRecord("SELECT PASSWORD(?) as `crypted`", $settings['main_database_password']);
 			$insert_data = array("sys_userid" => $websrv['sys_userid'],
 								 "sys_groupid" => $websrv['sys_groupid'],
 								 "sys_perm_user" => 'riud',
@@ -295,7 +296,7 @@
 								 "server_id" => 0,
 								 "database_user" => $settings['main_database_login'],
 								 "database_user_prefix" => $dbuser_prefix,
-								 "database_password" => "PASSWORD('" . $settings['main_database_password'] . "')"
+								 "database_password" => $tmppw['crypted']
 								 );
 			$mysql_db_user_id = $app->db->datalogInsert('web_database_user', $insert_data, 'database_user_id');
 		}

--
Gitblit v1.9.1