| | |
| | | //* Check permissions for module |
| | | $app->auth->check_module_permissions('dns'); |
| | | |
| | | //$app->uses('tform'); |
| | | |
| | | $type = $_GET["type"]; |
| | | |
| | | //if($_SESSION["s"]["user"]["typ"] == 'admin') { |
| | | |
| | | |
| | | if($type == 'get_ipv4'){ |
| | | //$q = $app->db->quote(trim($_GET["q"])); |
| | | //$authsql = " AND ".$app->tform->getAuthSQL('r'); |
| | | //$modules = explode(',', $_SESSION['s']['user']['modules']); |
| | | |
| | | $result = array(); |
| | | |
| | | // ipv4 |
| | | //$result[] = _search('admin', 'server_ip', "AND ip_type = 'IPv4' AND (client_id = 0 OR client_id=".$app->functions->intval($_SESSION['s']['user']['client_id']).")"); |
| | | $result[] = $app->functions->suggest_ips('IPv4'); |
| | | |
| | | $json = $app->functions->json_encode($result); |
| | | } |
| | | |
| | | if($type == 'get_ipv6'){ |
| | | //$q = $app->db->quote(trim($_GET["q"])); |
| | | //$authsql = " AND ".$app->tform->getAuthSQL('r'); |
| | | //$modules = explode(',', $_SESSION['s']['user']['modules']); |
| | | |
| | | $result = array(); |
| | | |
| | | // ipv6 |
| | | //$result[] = _search('admin', 'server_ip', "AND ip_type = 'IPv6' AND (client_id = 0 OR client_id=".$app->functions->intval($_SESSION['s']['user']['client_id']).")"); |
| | | $result[] = $app->functions->suggest_ips('IPv6'); |
| | | |
| | | $json = $app->functions->json_encode($result); |
| | | } |
| | | |
| | | //} |
| | | |
| | | /* |
| | | function _search($module, $section, $additional_sql = '', $unique = false){ |
| | | global $app, $q, $authsql, $modules; |
| | | |
| | | $result_array = array('cheader' => array(), 'cdata' => array()); |
| | | if(in_array($module, $modules) || ($module == 'admin' && $section == 'server_ip')){ |
| | | $search_fields = array(); |
| | | $desc_fields = array(); |
| | | if(is_file('../'.$module.'/form/'.$section.'.tform.php')){ |
| | | include_once('../'.$module.'/form/'.$section.'.tform.php'); |
| | | |
| | | $category_title = $form["title"]; |
| | | $form_file = $form["action"]; |
| | | $db_table = $form["db_table"]; |
| | | $db_table_idx = $form["db_table_idx"]; |
| | | $order_by = $db_table_idx; |
| | | |
| | | if(is_array($form["tabs"]) && !empty($form["tabs"])){ |
| | | foreach($form["tabs"] as $tab){ |
| | | if(is_array($tab['fields']) && !empty($tab['fields'])){ |
| | | foreach($tab['fields'] as $key => $val){ |
| | | if(isset($val['searchable']) && $val['searchable'] > 0){ |
| | | $search_fields[] = $key." LIKE '%".$q."%'"; |
| | | if($val['searchable'] == 1){ |
| | | $order_by = $key; |
| | | $title_key = $key; |
| | | } |
| | | if($val['searchable'] == 2){ |
| | | $desc_fields[] = $key; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | unset($form); |
| | | |
| | | $where_clause = ''; |
| | | if(!empty($search_fields)){ |
| | | $where_clause = implode(' OR ', $search_fields); |
| | | } else { |
| | | // valid SQL query which returns an empty result set |
| | | $where_clause = '1 = 0'; |
| | | } |
| | | if($where_clause != '') $where_clause = '('.$where_clause.')'; |
| | | if($additional_sql != '') $where_clause .= ' '.$additional_sql.' '; |
| | | $order_clause = ''; |
| | | if($order_by != '') $order_clause = ' ORDER BY '.$order_by; |
| | | |
| | | $sql = "SELECT * FROM ".$db_table." WHERE ".$where_clause.$authsql.$order_clause." LIMIT 0,10"; |
| | | $results = $app->db->queryAllRecords($sql); |
| | | |
| | | if(is_array($results) && !empty($results)){ |
| | | $lng_file = '../'.$module.'/lib/lang/'.$_SESSION['s']['language'].'_'.$section.'.lng'; |
| | | if(is_file($lng_file)) include($lng_file); |
| | | $result_array['cheader'] = array('title' => $category_title, |
| | | 'total' => count($results), |
| | | 'limit' => count($results) |
| | | ); |
| | | foreach($results as $result){ |
| | | $description = ''; |
| | | if(!empty($desc_fields)){ |
| | | $desc_items = array(); |
| | | foreach($desc_fields as $desc_field){ |
| | | if($result[$desc_field] != '') $desc_items[] = $wb[$desc_field.'_txt'].': '.$result[$desc_field]; |
| | | } |
| | | if(!empty($desc_items)) $description = implode(' - ', $desc_items); |
| | | } |
| | | |
| | | $result_array['cdata'][] = array( 'title' => $wb[$title_key.'_txt'].': '.$result[$title_key], |
| | | 'description' => $description, |
| | | 'onclick' => '', |
| | | 'fill_text' => $result[$title_key] |
| | | ); |
| | | } |
| | | if($unique === true){ |
| | | $result_array['cdata'] = array_unique($result_array['cdata']); |
| | | $result_array['cheader']['total'] = $result_array['cheader']['limit'] = count($result_array['cdata']); |
| | | } |
| | | } |
| | | } |
| | | return $result_array; |
| | | } |
| | | */ |
| | | |
| | | header('Content-type: application/json'); |
| | | echo $json; |