Marius Cramer
2015-08-06 37b29231e47a0c4458dc1c15d98588f16f07e1e2
interface/web/dns/ajax_get_json.php
@@ -28,135 +28,32 @@
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
require_once('../../lib/config.inc.php');
require_once('../../lib/app.inc.php');
require_once '../../lib/config.inc.php';
require_once '../../lib/app.inc.php';
//* 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'){
   $result = array();
   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=".intval($_SESSION['s']['user']['client_id']).")");
      $result[] = $app->functions->suggest_ips('IPv4');
   // ipv4
   $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=".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;
   $json = $app->functions->json_encode($result);
}
*/
if($type == 'get_ipv6'){
   $result = array();
   // ipv6
   $result[] = $app->functions->suggest_ips('IPv6');
   $json = $app->functions->json_encode($result);
}
header('Content-type: application/json');
echo $json;
?>
?>