| | |
|---|
| | | $software_update_id = 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')"; |
|---|
| | | $app->db->datalogInsert('software_update_inst', $insert_data, 'software_update_inst_id'); |
|---|
| | | |
|---|
| | | } |
|---|
| | |
|---|
| | | 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 |
|---|
