| | |
| | | foreach($installed_packages as $ip) { |
| | | |
| | | // Get version number of the latest installed version |
| | | $sql = "SELECT v1, v2, v3, v4 FROM software_update, software_update_inst WHERE software_update.software_update_id = software_update_inst.software_update_id AND server_id = 1 ORDER BY v1 DESC , v2 DESC , v3 DESC , v4 DESC LIMIT 0,1"; |
| | | $sql = "SELECT v1, v2, v3, v4 FROM software_update, software_update_inst WHERE software_update.software_update_id = software_update_inst.software_update_id AND server_id = ".$server_id." ORDER BY v1 DESC , v2 DESC , v3 DESC , v4 DESC LIMIT 0,1"; |
| | | $lu = $app->db->queryOneRecord($sql); |
| | | |
| | | // Get all installable updates |
| | |
| | | |
| | | 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); |
| | | |
| | | } |
| | |
| | | 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; |
| | | |