function QuotaGroup($ID)
{
$q = new mysql();
$tpl = new templates();
$sql = "SELECT * FROM ext_time_quota_acl_rules WHERE ruleid='{$ID}' AND enabled=1";
$results = $q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
return $q->mysql_error;
}
$acl = new squid_acls_groups();
$t = $_GET["t"];
$tOrg = $_GET["tOrg"];
$tt = $_GET["tt"];
$budgets["s"] = "{seconds}";
$budgets["m"] = "{minutes}";
$budgets["h"] = "{hours}";
$budgets["d"] = "{days}";
$budgets["w"] = "{weeks}";
$f = array();
while ($ligne = mysql_fetch_assoc($results)) {
$ligne['rulename'] = utf8_encode($ligne['rulename']);
if (preg_match("#([0-9]+)([a-z]+)#", $ligne["budget"], $re)) {
$budget = $re[1];
$budget2 = $re[2];
}
if (preg_match("#([0-9]+)([a-z]+)#", $ligne["period"], $re)) {
$period = $re[1];
$period2 = $re[2];
}
$GetGroupsList = GetGroupsList($ligne["ID"]);
$url = "<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('squid.ext_time_quota_acl_rules.php?session-rule-js=yes&ID={$ligne['ID']}&t={$t}&tOrg={$tOrg}&mainrule={$ID}&tt={$tt}');\" style=\"font-size:11px;text-decoration:underline;color:{$color}\">";
$period = $tpl->javascript_parse_text("{$period} {$budgets[$period2]}");
$budget = $tpl->javascript_parse_text("{$budget} {$budgets[$budget2]}");
$f[] = "<div style='font-size:11px'>«<strong>{$url}{$ligne['rulename']}</strong></a>» {$budget}/{$period}{$GetGroupsList}</div>";
}
return @implode("", $f);
}
function rules_list()
{
//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();
$database = "artica_backup";
$t = $_GET["t"];
$tt = $_GET["tt"];
$tOrg = $_GET["tOrg"];
$mainrule = $_GET["mainrule"];
$search = '%';
$table = "ext_time_quota_acl_rules";
$page = 1;
$data = array();
$data['rows'] = array();
$FORCE_FILTER = "AND ruleid='{$mainrule}'";
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, $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;
$limitSql = "LIMIT {$pageStart}, {$rp}";
if ($OnlyEnabled) {
$limitSql = null;
}
$sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} {$FORCE_FILTER} {$ORDER} {$limitSql}";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql, $database);
if (!$q->ok) {
json_error_show("{$q->mysql_error}");
}
$data['page'] = $page;
$data['total'] = $total;
$budgets["s"] = "{seconds}";
$budgets["m"] = "{minutes}";
$budgets["h"] = "{hours}";
$budgets["d"] = "{days}";
$budgets["w"] = "{weeks}";
while ($ligne = mysql_fetch_assoc($results)) {
$val = 0;
$color = "black";
$disable = Field_checkbox("sessionid_{$ligne['ID']}", 1, $ligne["enabled"], "EnableDisableSessionRule{$tt}('{$ligne['ID']}')");
$ligne['rulename'] = utf8_encode($ligne['rulename']);
$delete = imgsimple("delete-24.png", null, "DeleteSessionRule{$tt}('{$ligne['ID']}')");
if ($ligne["enabled"] == 0) {
$color = "#8a8a8a";
}
//$explain=$tpl->_ENGINE_parse_body($acls->ACL_MULTIPLE_EXPLAIN($ligne['ID'],$ligne["enabled"]));
if (preg_match("#([0-9]+)([a-z]+)#", $ligne["budget"], $re)) {
$budget = $re[1];
$budget2 = $re[2];
}
if (preg_match("#([0-9]+)([a-z]+)#", $ligne["period"], $re)) {
$period = $re[1];
$period2 = $re[2];
}
$period = $tpl->javascript_parse_text("{$period} {$budgets[$period2]}");
$budget = $tpl->javascript_parse_text("{$budget} {$budgets[$budget2]}");
$gplist = GetGroupsList($ligne['ID']);
$data['rows'][] = array('id' => "acl{$ligne['ID']}", 'cell' => array("<a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('{$MyPage}?session-rule-js=yes&ID={$ligne['ID']}&t={$t}&tOrg={$tOrg}&mainrule={$mainrule}&tt={$tt}');\" style=\"font-size:16px;text-decoration:underline;color:{$color}\">{$ligne['rulename']}</a>{$gplist}", "<span style=\"font-size:14px;color:{$color}\">{$budget}</span>", "<span style=\"font-size:14px;color:{$color}\">{$period}</span>", $disable, $delete));
}
echo json_encode($data);
}
