function rules_search() { //ini_set('html_errors',0);ini_set('display_errors', 1);ini_set('error_reporting', E_ALL);ini_set('error_prepend_string','');ini_set('error_append_string',''); $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql(); $servicename = trim($_GET["servicename"]); $table_type = $_GET["table"]; $sock = new sockets(); $EnableL7Filter = intval($sock->GET_INFO("EnableL7Filter")); $EnableQOS = intval($sock->GET_INFO("EnableQOS")); $t = $_GET["t"]; $FORCE_FILTER = null; $search = '%'; $table = "haproxy_acls_rules"; $table = "(SELECT * FROM haproxy_acls_rules WHERE servicename='{$servicename}' ORDER BY zorder ) as t"; $page = 1; if ($q->COUNT_ROWS("haproxy_acls_rules", "artica_backup") == 0) { json_error_show("No datas - COUNT_ROWS", 1); } if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } $searchstring = string_to_flexquery(); if ($searchstring != null) { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER} {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup")); $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup")); $total = $ligne["TCOUNT"]; } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $pageStart = ($page - 1) * $rp; $limitSql = "LIMIT {$pageStart}, {$rp}"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}"; $results = $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { json_error_show($q->mysql_error . "\n{$sql}", 1); } $data = array(); $data['page'] = $page; $data['total'] = $total; $data['rows'] = array(); if (mysql_num_rows($results) == 0) { json_error_show($q->mysql_error, 1); } $rules = $tpl->_ENGINE_parse_body("{rules}"); $log_all_events = $tpl->_ENGINE_parse_body("{log_all_events}"); $c = 0; while ($ligne = mysql_fetch_assoc($results)) { $val = 0; $color = "black"; $time = null; $mkey = md5(serialize($ligne)); $delete = imgsimple("delete-32.png", null, "Loadjs('{$MyPage}?rule-delete-js=yes&ID={$ligne["ID"]}')"); $up = imgsimple("arrow-up-32.png", "", "RuleHaproxyAclsGroupUpDown('{$ligne["ID"]}',0)"); $down = imgsimple("arrow-down-32.png", "", "RuleHaproxyAclsGroupUpDown('{$ligne["ID"]}',1)"); $rulename = trim($ligne["rulename"]); $EXPLAIN = EXPLAIN_THIS_RULE($ligne["ID"]); if ($rulename == null) { $rulename = $tpl->_ENGINE_parse_body("{rule} {$ligne["ID"]}"); } if ($ligne["rule_action"] == 0) { $color = "#8a8a8a"; } $js = "Loadjs('{$MyPage}?rule-js=yes&ruleid={$ligne["ID"]}',true);"; $JSRULE = "<a href=\"javascript:blur();\" OnClick=\"javascript:{$js}\"\n\t\t\tstyle='font-size:22px;font-weight:bold;text-decoration:underline;color:{$color}'>"; if ($c == 0) { $up = null; } $data['rows'][] = array('id' => "{$mkey}", 'cell' => array("{$JSRULE}{$rulename}</a><br><span style='font-size:16px;color:{$color}'>{$EXPLAIN}</span>", "<center style=\"margin-top:5px\">{$up}</center>", "<center style=\"margin-top:5px\">{$down}</center>", "<center style=\"margin-top:4px\">{$delete}</center>")); $c++; } echo json_encode($data); }
function rules() { //ini_set('html_errors',0);ini_set('display_errors', 1);ini_set('error_reporting', E_ALL);ini_set('error_prepend_string','');ini_set('error_append_string',''); $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql(); $eth = trim($_GET["eth"]); $table_type = $_GET["table"]; $sock = new sockets(); $EnableL7Filter = intval($sock->GET_INFO("EnableL7Filter")); $EnableQOS = intval($sock->GET_INFO("EnableQOS")); $t = $_GET["t"]; $FORCE_FILTER = null; $search = '%'; $table = "iptables_main"; if ($eth != null) { $table = "(SELECT iptables_main.* FROM iptables_main WHERE iptables_main.eth='{$eth}' AND iptables_main.MOD='{$table_type}'\n\t\tORDER BY zOrder ) as t"; } $page = 1; if ($q->COUNT_ROWS("iptables_main", "artica_backup") == 0) { json_error_show("No datas - COUNT_ROWS", 1); } if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } $searchstring = string_to_flexquery(); if ($searchstring != null) { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER} {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup")); $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM {$table} WHERE 1 {$FORCE_FILTER}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup")); $total = $ligne["TCOUNT"]; } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $pageStart = ($page - 1) * $rp; $limitSql = "LIMIT {$pageStart}, {$rp}"; $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}"; $results = $q->QUERY_SQL($sql, "artica_backup"); if (!$q->ok) { json_error_show($q->mysql_error . "\n{$sql}", 1); } $data = array(); $data['page'] = $page; $data['total'] = $total; $data['rows'] = array(); if (mysql_num_rows($results) == 0) { json_error_show($q->mysql_error, 1); } $rules = $tpl->_ENGINE_parse_body("{rules}"); $log_all_events = $tpl->_ENGINE_parse_body("{log_all_events}"); while ($ligne = mysql_fetch_assoc($results)) { $val = 0; $color = "black"; $time = null; $mkey = md5(serialize($ligne)); $delete = imgsimple("delete-32.png", null, "DeleteRule{$t}('{$ligne["ID"]}')"); $enabled = Field_checkbox("enabled-{$ligne["ID"]}", 1, $ligne["enabled"], "ChangEnabled{$_GET["t"]}('{$ligne["ID"]}')"); $up = imgsimple("arrow-up-32.png", "", "RuleGroupUpDown{$_GET["t"]}('{$ligne["ID"]}',0)"); $down = imgsimple("arrow-down-32.png", "", "RuleGroupUpDown{$_GET["t"]}('{$ligne["ID"]}',1)"); $L7Mark = $ligne["L7Mark"]; $FORWARD_TEXT = null; if ($EnableL7Filter == 0) { $L7Mark = 0; } $rulename = trim(utf8_encode($ligne["rulename"])); $eth_text = $ligne["eth"]; if (!preg_match("#(.+?)2(.+?)#", $eth_text)) { $eth_text = "<a href=\"javascript:blud();\" OnClick=\"javascript:GoToNicFirewallConfiguration('{$eth_text}');\"\n\t\t\tstyle='text-decoration:underline;font-weight:bold'>{$eth_text}</a>"; } $EXPLAIN = EXPLAIN_THIS_RULE($ligne); if ($ligne["jlog"] == 1) { $explain = $explain . "<br><span style='font-size:12px'>{$log_all_events}</span>"; } if ($rulename == null) { $rulename = $tpl->_ENGINE_parse_body("{rule} {$ligne["ID"]}"); } if ($ligne["enabled"] == 0) { $color = "#8a8a8a"; } $js = "Loadjs('{$MyPage}?ruleid={$ligne["ID"]}ð={$eth}&t={$_GET["t"]}&table={$table_type}',true);"; $ACTION = "cloud-goto-32.png"; if ($ligne["enabled"] == 0) { $ACTION = "cloud-goto-32-grey.png"; } if ($ligne["accepttype"] == "DROP") { $ACTION = "cloud-deny-32.png"; if ($ligne["enabled"] == 0) { $ACTION = "cloud-deny-32-grey.png"; } } if ($ligne["accepttype"] == "RETURN") { $ACTION = "arrow-right-32.png"; } if ($ligne["accepttype"] == "LOG") { $ACTION = "log-32.png"; } $JSRULE = "<a href=\"javascript:blur();\" OnClick=\"javascript:{$js}\"\n\t\tstyle='font-size:22px;font-weight:bold;text-decoration:underline;color:{$color}'>"; if ($ligne["zOrder"] == 1) { $up = null; } if ($ligne["zOrder"] == 0) { $up = null; } $data['rows'][] = array('id' => "{$mkey}", 'cell' => array("<span style='font-size:18px;font-weight:bold;color:{$color}'>{$ligne["zOrder"]}</span>", "{$JSRULE}{$rulename}</a> {$EXPLAIN}{$FORWARD_TEXT}{$time}", "<center style='font-size:18px;font-weight:bold;color:{$color}'>{$eth_text}</center>", "<div style=\"margin-top:5px\">{$enabled}</div>", "<center style='font-size:14px;font-weight:bold;color:{$color}'><img src='img/{$ACTION}'></span>", "<center style=\"margin-top:5px\">{$up}</center>", "<center style=\"margin-top:5px\">{$down}</center>", "<center style=\"margin-top:4px\">{$delete}</center>")); } echo json_encode($data); }
function search() { $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql(); $database = "artica_backup"; $t = $_GET["t"]; $search = '%'; $table = "routing_rules"; $page = 1; $FORCE_FILTER = null; $total = 0; if (isset($_POST["sortname"])) { if ($_POST["sortname"] != null) { $ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}"; } } if (isset($_POST['page'])) { $page = $_POST['page']; } $searchstring = string_to_flexquery(); if ($searchstring != null) { $search = $_POST["query"]; $sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE 1 {$FORCE_FILTER} {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database)); $total = $ligne["TCOUNT"]; } else { $sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE 1 {$FORCE_FILTER}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, $database)); $total = $ligne["TCOUNT"]; } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $pageStart = ($page - 1) * $rp; if (!is_numeric($rp)) { $rp = 50; } $limitSql = "LIMIT {$pageStart}, {$rp}"; $sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}"; $results = $q->QUERY_SQL($sql, $database); $data = array(); $data['page'] = $page; $data['total'] = $total; $data['rows'] = array(); if (!$q->ok) { json_error_show($q->mysql_error, 1); } if (mysql_num_rows($results) == 0) { $array = routes_default(); echo json_encode($array[1]); return; } $fontsize = 22; $types[1] = $tpl->_ENGINE_parse_body("{network_nic}"); $types[2] = $tpl->_ENGINE_parse_body("{host}"); while ($ligne = mysql_fetch_assoc($results)) { $color = "black"; $RouteName = $ligne["RouteName"]; if ($ligne["enabled"] == 0) { $color = "#8a8a8a"; } $style = "style='font-size:{$fontsize}px;color:{$color};'"; $delete = imgsimple("delete-32.png", null, "Loadjs('{$MyPage}?route-delete-js=yes&ID={$ligne["ID"]}&t={$t}');"); $js = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('{$MyPage}?route-js=yes&ID={$ligne["ID"]}&t={$t}');\"\n\t\tstyle='font-size:{$fontsize}px;color:{$color};text-decoration:underline'>"; $down = imgsimple("arrow-down-32.png", null, "Loadjs('{$MyPage}?route-move-js=yes&ID={$ligne["ID"]}&t={$t}&dir=down');"); $up = imgsimple("arrow-up-32.png", null, "Loadjs('{$MyPage}?route-move-js=yes&ID={$ligne["ID"]}&t={$t}&dir=up');"); if ($ligne["gateway"] == null) { $ligne["gateway"] = $ligne["nic"]; } $EXPLAIN_THIS_RULE = EXPLAIN_THIS_RULE($ligne["ID"], $ligne["nic"]); $data['rows'][] = array('id' => $ligne['ID'], 'cell' => array("<span {$style}>{$js}{$ligne["nic"]}</a></span>", "<span {$style}>{$js}{$RouteName}</a></span>", "<span style='font-size:16px;color:{$color};'>{$EXPLAIN_THIS_RULE}</span>", "<center {$style}>{$delete}</center>")); } echo json_encode($data); }