| | |
|---|
| | | |
|---|
| | | if ($app->dbmaster == $app->db) { |
|---|
| | | //* Check which virtual machines have to be deactivated |
|---|
| | | $sql = "SELECT * FROM openvz_vm WHERE active = 'y' AND active_until_date != '0000-00-00' AND active_until_date < CURDATE()"; |
|---|
| | | $sql = "SELECT * FROM openvz_vm WHERE active = 'y' AND active_until_date IS NOT NULL AND active_until_date < CURDATE()"; |
|---|
| | | $records = $app->db->queryAllRecords($sql); |
|---|
| | | if(is_array($records)) { |
|---|
| | | foreach($records as $rec) { |
|---|
| | | $app->dbmaster->datalogUpdate('openvz_vm', "active = 'n'", 'vm_id', $rec['vm_id']); |
|---|
| | | $app->dbmaster->datalogUpdate('openvz_vm', array("active" => 'n'), 'vm_id', $rec['vm_id']); |
|---|
| | | $app->log('Virtual machine active date expired. Disabling VM '.$rec['veid'], LOGLEVEL_DEBUG); |
|---|
| | | } |
|---|
| | | } |
|---|
