FS#2408 - Virtual Servers > Add new Record: MySQL error
| | |
| | | $tmp = $app->db->queryOneRecord('SELECT server_id FROM server WHERE vserver_server = 1 AND mirror_server_id = 0 ORDER BY server_name LIMIT 0,1'); |
| | | $vm_server_id = $tmp['server_id']; |
| | | } |
| | | $sql = "SELECT ip_address FROM openvz_ip WHERE reserved = 'n' AND (vm_id = 0 or vm_id = '".$this->id."') AND server_id = ".$vm_server_id." ORDER BY ip_address"; |
| | | $sql = "SELECT ip_address FROM openvz_ip WHERE reserved = 'n' AND (vm_id = 0 or vm_id = '".$this->id."') AND server_id = ".intval($vm_server_id)." ORDER BY ip_address"; |
| | | $ips = $app->db->queryAllRecords($sql); |
| | | $ip_select = ""; |
| | | if(is_array($ips)) { |