Example #1
0
    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 = "&nbsp;&nbsp;&nbsp;&nbsp;&laquo;&nbsp;<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>&nbsp;&raquo;&nbsp;";
        }
        $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);
}