| | |
| | | $app->tpl->setVar("server_id","<option value='$client[default_webserver]'>$tmp[server_name]</option>"); |
| | | unset($tmp); |
| | | |
| | | // Fill the IP select field with the IP addresses that are allowed for this client |
| | | $sql = "SELECT ip_address FROM server_ip WHERE server_id = ".$client['default_webserver']." AND client_id=0 OR client_id=".$_SESSION['s']['user']['client_id']; |
| | | //* Fill the IPv4 select field with the IP addresses that are allowed for this client |
| | | $sql = "SELECT ip_address FROM server_ip WHERE server_id = ".$client['default_webserver']." AND ip_type = 'IPv4' AND (client_id = 0 OR client_id=".$_SESSION['s']['user']['client_id'].")"; |
| | | $ips = $app->db->queryAllRecords($sql); |
| | | $ip_select = "<option value='*'>*</option>"; |
| | | //$ip_select = ""; |
| | |
| | | } |
| | | } |
| | | $app->tpl->setVar("ip_address",$ip_select); |
| | | unset($tmp); |
| | | unset($ips); |
| | | |
| | | //* Fill the IPv6 select field with the IP addresses that are allowed for this client |
| | | $sql = "SELECT ip_address FROM server_ip WHERE server_id = ".$client['default_webserver']." AND ip_type = 'IPv6' AND (client_id = 0 OR client_id=".$_SESSION['s']['user']['client_id'].")"; |
| | | $ips = $app->db->queryAllRecords($sql); |
| | | $ip_select = "<option value=''></option>"; |
| | | //$ip_select = ""; |
| | | if(is_array($ips)) { |
| | | foreach( $ips as $ip) { |
| | | $selected = ($ip["ip_address"] == $this->dataRecord["ipv6_address"])?'SELECTED':''; |
| | | $ip_select .= "<option value='$ip[ip_address]' $selected>$ip[ip_address]</option>\r\n"; |
| | | } |
| | | } |
| | | $app->tpl->setVar("ipv6_address",$ip_select); |
| | | unset($tmp); |
| | | unset($ips); |
| | | |
| | |
| | | } |
| | | $app->tpl->setVar("client_group_id",$client_select); |
| | | |
| | | // Fill the IP select field with the IP addresses that are allowed for this client |
| | | $sql = "SELECT ip_address FROM server_ip WHERE server_id = ".$client['default_webserver']." AND client_id=0 OR client_id=".$_SESSION['s']['user']['client_id']; |
| | | //* Fill the IPv4 select field with the IP addresses that are allowed for this client |
| | | $sql = "SELECT ip_address FROM server_ip WHERE server_id = ".$client['default_webserver']." AND ip_type = 'IPv4' AND (client_id = 0 OR client_id=".$_SESSION['s']['user']['client_id'].")"; |
| | | $ips = $app->db->queryAllRecords($sql); |
| | | $ip_select = "<option value='*'>*</option>"; |
| | | //$ip_select = ""; |
| | |
| | | } |
| | | } |
| | | $app->tpl->setVar("ip_address",$ip_select); |
| | | unset($tmp); |
| | | unset($ips); |
| | | |
| | | //* Fill the IPv6 select field with the IP addresses that are allowed for this client |
| | | $sql = "SELECT ip_address FROM server_ip WHERE server_id = ".$client['default_webserver']." AND ip_type = 'IPv6' AND (client_id = 0 OR client_id=".$_SESSION['s']['user']['client_id'].")"; |
| | | $ips = $app->db->queryAllRecords($sql); |
| | | $ip_select = "<option value=''></option>"; |
| | | //$ip_select = ""; |
| | | if(is_array($ips)) { |
| | | foreach( $ips as $ip) { |
| | | $selected = ($ip["ip_address"] == $this->dataRecord["ipv6_address"])?'SELECTED':''; |
| | | $ip_select .= "<option value='$ip[ip_address]' $selected>$ip[ip_address]</option>\r\n"; |
| | | } |
| | | } |
| | | $app->tpl->setVar("ipv6_address",$ip_select); |
| | | unset($tmp); |
| | | unset($ips); |
| | | |
| | |
| | | $tmp = $app->db->queryOneRecord("SELECT server_id FROM server WHERE web_server = 1 ORDER BY server_name LIMIT 0,1"); |
| | | $server_id = $tmp['server_id']; |
| | | } |
| | | |
| | | $sql = "SELECT ip_address FROM server_ip WHERE server_id = $server_id"; |
| | | |
| | | //* Fill the IPv4 select field |
| | | $sql = "SELECT ip_address FROM server_ip WHERE ip_type = 'IPv4' AND server_id = $server_id"; |
| | | $ips = $app->db->queryAllRecords($sql); |
| | | $ip_select = "<option value='*'>*</option>"; |
| | | //$ip_select = ""; |
| | |
| | | $app->tpl->setVar("ip_address",$ip_select); |
| | | unset($tmp); |
| | | unset($ips); |
| | | |
| | | //* Fill the IPv6 select field |
| | | $sql = "SELECT ip_address FROM server_ip WHERE ip_type = 'IPv6' AND server_id = $server_id"; |
| | | $ips = $app->db->queryAllRecords($sql); |
| | | $ip_select = "<option value=''></option>"; |
| | | //$ip_select = ""; |
| | | if(is_array($ips)) { |
| | | foreach( $ips as $ip) { |
| | | $selected = ($ip["ip_address"] == $this->dataRecord["ipv6_address"])?'SELECTED':''; |
| | | $ip_select .= "<option value='$ip[ip_address]' $selected>$ip[ip_address]</option>\r\n"; |
| | | } |
| | | } |
| | | $app->tpl->setVar("ipv6_address",$ip_select); |
| | | unset($tmp); |
| | | unset($ips); |
| | | |
| | | // Fill the client select field |
| | | $sql = "SELECT groupid, name FROM sys_group WHERE client_id > 0 ORDER BY name"; |