From f4038a2160d55a7f519a3b42be1aa96e29e9a908 Mon Sep 17 00:00:00 2001 From: ftimme <ft@falkotimme.com> Date: Wed, 27 Feb 2013 09:01:40 -0500 Subject: [PATCH] - Fixed "FUNCTION databasename.CONCAT does not exist" error for older MySQL versions. --- interface/web/admin/software_update_list.php | 20 ++++++++++---------- 1 files changed, 10 insertions(+), 10 deletions(-) diff --git a/interface/web/admin/software_update_list.php b/interface/web/admin/software_update_list.php index 734f369..0f09241 100644 --- a/interface/web/admin/software_update_list.php +++ b/interface/web/admin/software_update_list.php @@ -66,13 +66,13 @@ foreach($updates as $u) { $version_array = explode('.',$u['version']); - $v1 = intval($version_array[0]); - $v2 = intval($version_array[1]); - $v3 = intval($version_array[2]); - $v4 = intval($version_array[3]); + $v1 = $app->functions->intval($version_array[0]); + $v2 = $app->functions->intval($version_array[1]); + $v3 = $app->functions->intval($version_array[2]); + $v4 = $app->functions->intval($version_array[3]); $package_name = $app->db->quote($u['package_name']); - $software_repo_id = intval($repo['software_repo_id']); + $software_repo_id = $app->functions->intval($repo['software_repo_id']); $update_url = $app->db->quote($u['url']); $update_md5 = $app->db->quote($u['md5']); $update_dependencies = (isset($u['dependencies']))?$app->db->quote($u['dependencies']):''; @@ -101,8 +101,8 @@ //* Install packages, if GET Request if(isset($_GET['action']) && $_GET['action'] == 'install' && $_GET['package'] != '' && $_GET['server_id'] > 0) { $package_name = $app->db->quote($_GET['package']); - $server_id = intval($_GET['server_id']); - $software_update_id = intval($_GET['id']); + $server_id = $app->functions->intval($_GET['server_id']); + $software_update_id = $app->functions->intval($_GET['id']); $insert_data = "(package_name, server_id, software_update_id, status) VALUES ('$package_name', '$server_id', '$software_update_id','installing')"; // $insert_data = "(package_name, server_id, software_update_id, status) VALUES ('$package_name', '$server_id', '$software_update_id','installed')"; @@ -130,7 +130,7 @@ if(isset($_POST["server_id"]) && $_POST["server_id"] > 0) { - $server_id = intval($_POST["server_id"]); + $server_id = $app->functions->intval($_POST["server_id"]); } else { $server_id = 1; } @@ -175,7 +175,7 @@ foreach($updates as $key => $u) { $version = $u['v1'].'.'.$u['v2'].'.'.$u['v3'].'.'.$u['v4']; - $installed_txt = "<a href=\"#\" onClick=\"loadContent('admin/software_update_list.php?action=install&package=".$u["package_name"]."&id=".$u["software_update_id"]."&server_id=".$server_id."');\">Install Update</a><br />"; + $installed_txt = "<a href=\"#\" onclick=\"loadContent('admin/software_update_list.php?action=install&package=".$u["package_name"]."&id=".$u["software_update_id"]."&server_id=".$server_id."');\">Install Update</a><br />"; $records_out[] = array('version' => $version, 'update_title' => $u["update_title"], 'installed' => $installed_txt); } @@ -199,7 +199,7 @@ if($u['status'] == 'installed' || $u['status'] == 'installing' || $u['status'] == 'deleting') { $installed_txt .= "Installed version $version<br />"; } else { - $installed_txt .= "<a href=\"#\" onClick=\"loadContent('admin/software_update_list.php?action=install&package=".$u["package_name"]."&id=".$u["software_update_id"]."&server_id=".$server_id."');\">Install now</a><br />"; + $installed_txt .= "<a href=\"#\" onclick=\"loadContent('admin/software_update_list.php?action=install&package=".$u["package_name"]."&id=".$u["software_update_id"]."&server_id=".$server_id."');\">Install now</a><br />"; } $updates[$key]['installed'] = $installed_txt; -- Gitblit v1.9.1