exit; } if (isset($_GET["table"])) { table(); exit; } if (isset($_GET["rule-id-js"])) { rule_js(); exit; } if (isset($_GET["rule-id"])) { rule_popup(); exit; } if (isset($_GET["group-text"])) { echo rule_group_text($_GET["group-text"]); exit; } if (isset($_GET["search"])) { search(); exit; } if (isset($_POST["ID"])) { rule_save(); exit; } if (isset($_GET["delete-rule-js"])) { delete_rule_js(); exit; } if (isset($_POST["DELETERULE"])) {
function search() { $tpl = new templates(); $MyPage = CurrentPageName(); $q = new mysql_squid_builder(); $sock = new sockets(); $t = $_GET["t"]; $search = '%'; $table = "global_whitelist"; $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) { $sql = "SELECT COUNT(*) as TCOUNT FROM `{$table}` WHERE 1 {$FORCE_FILTER} {$searchstring}"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql)); $total = $ligne["TCOUNT"]; } else { $total = $q->COUNT_ROWS($table); } if (isset($_POST['rp'])) { $rp = $_POST['rp']; } $pageStart = ($page - 1) * $rp; if (is_numeric($rp)) { $limitSql = "LIMIT {$pageStart}, {$rp}"; } $sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}"; $results = $q->QUERY_SQL($sql); $no_rule = $tpl->_ENGINE_parse_body("{no_rule}"); $data = array(); $data['page'] = $page; $data['total'] = $total; $data['rows'] = array(); if (!$q->ok) { json_error_show($q->mysql_error . "<br>{$sql}"); } if (mysql_num_rows($results) == 0) { json_error_show("!!! no data"); } $error_firwall_not_configured = $tpl->javascript_parse_text("{error_firwall_not_configuredisquid}"); $tpl = new templates(); $all = $tpl->javascript_parse_text("{all}"); $edit = $tpl->javascript_parse_text("{group_properties}"); while ($ligne = mysql_fetch_assoc($results)) { $color = "black"; $ID = $ligne["ID"]; $delete = imgsimple("delete-32.png", null, "Loadjs('{$MyPage}?delete-rule-js=yes&ID={$ID}&t={$_GET["t"]}',true)"); $edit_group = null; if ($ligne["groupid"] > 0) { $edit_group = " « <a href=\"javascript:blur();\"\n\t\t\t\tOnClick=\"javascript:Loadjs('squid.acls.groups.php?AddGroup-js=yes&ID={$ligne["groupid"]}&t={$_GET["t"]}');\"\n\t\t\t\tstyle='font-size:16px;font-weight:normal;color:{$color};text-decoration:underline'>{$edit}</a> » "; } $EditJs = "<a href=\"javascript:blur();\"\n\t\t\tOnClick=\"javascript:Loadjs('{$MyPage}?rule-id-js={$ID}&t={$_GET["t"]}');\"\n\t\t\tstyle='font-size:18px;font-weight:normal;color:{$color};text-decoration:underline'>"; $deny_auth = $ligne["deny_auth"]; $groupName = rule_group_text($ligne["groupid"], $edit_group, $EditJs); $deny_global = $ligne["deny_global"]; $deny_cache = $ligne["deny_cache"]; $deny_ufdb = $ligne["deny_ufdb"]; $deny_icap = $ligne["deny_icap"]; $deny_ext = $ligne["deny_ext"]; $deny_global_img = "ok-32.png"; $deny_auth_img = "ok32-grey.png"; $deny_ufdb_img = "ok32-grey.png"; $deny_icap_img = "ok32-grey.png"; $deny_ext_img = "ok32-grey.png"; $enabled_img = "ok-32.png"; $deny_cache_img = "ok32-grey.png"; if ($deny_auth == 1) { $deny_auth_img = "ok-32.png"; } if ($deny_cache == 1) { $deny_cache_img = "32-red.png"; } if ($deny_icap == 1) { $deny_icap_img = "32-red.png"; } if ($deny_ext == 1) { $deny_ext_img = "32-red.png"; } if ($deny_ufdb == 1) { $deny_ufdb_img = "ok-32.png"; } if ($deny_global == 1) { $deny_global_img = "32-red.png"; $deny_auth_img = "ok32-grey.png"; $deny_cache_img = "ok32-grey.png"; $deny_ufdb_img = "ok32-grey.png"; $deny_icap_img = "ok32-grey.png"; } if ($ligne["enabled"] == 0) { $color = "#A0A0A0"; $enabled_img = "32-red.png"; $deny_global_img = "ok32-grey.png"; $deny_auth_img = "ok32-grey.png"; $deny_cache_img = "ok32-grey.png"; $deny_ufdb_img = "ok32-grey.png"; $deny_icap_img = "ok32-grey.png"; } $data['rows'][] = array('id' => $ID, 'cell' => array("<span style='font-size:18px;font-weight:normal;color:{$color}'>{$groupName}</span>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'><img src='img/{$deny_global_img}'></a></center>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'><img src='img/{$deny_cache_img}'></a></center>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'><img src='img/{$deny_auth_img}'></a></center>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'><img src='img/{$deny_ufdb_img}'></a></center>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'><img src='img/{$deny_icap_img}'></a></center>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'><img src='img/{$deny_ext_img}'></a></center>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'><img src='img/{$enabled_img}'></center>", "<center style='margin-top:3px;font-size:30px;font-weight:normal;color:{$color}'>{$delete}</center>")); } echo json_encode($data); }