function section_websites_search()
{
$boot = new boostrap_form();
$tpl = new templates();
$q = new mysql_squid_builder();
$page = CurrentPageName();
$table = "visited_sites_tot";
$searchstring = string_to_flexquery("sites-search");
$ORDER = $boot->TableOrder(array("size" => "ASC"));
if ($q->COUNT_ROWS($table) == 0) {
senderrors("no data");
}
$sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,250";
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
senderrors($q->mysql_error . "<br>{$sql}");
}
while ($ligne = mysql_fetch_assoc($results)) {
$md = md5(serialize($ligne));
$ligne["size"] = FormatBytes($ligne["size"] / 1024);
$sitenameenc = urlencode($ligne["familysite"]);
$js = "Loadjs('miniadm.webstats.familysite.all.php?familysite={$sitenameenc}')";
$link = $boot->trswitch($js);
$tr[] = "\n\t\t<tr id='{$md}'>\n\t\t\t<td style='font-size:16px' width=10% nowrap {$link}>{$ligne["familysite"]}</td>\n\t\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["hits"]}</td>\n\t\t\t<td style='font-size:16px' width=1% nowrap {$link}>{$ligne["size"]}</td>\n\t\t</tr>\n\t\t";
}
echo $boot->TableCompile(array("familysite" => "{familysite}", "hits" => "{hits}", "size" => "{size}"), $tr);
}
function section_start()
{
$boot = new boostrap_form();
$tpl = new templates();
$page = CurrentPageName();
echo $boot->SearchFormGen("searchstring", "session-search", null, null);
}
function tabs()
{
$users = new usersMenus();
$Privileges_members_admins = Privileges_members_admins();
$AS_PROXY_SECTION = false;
if ($users->SQUID_INSTALLED) {
$AS_PROXY_SECTION = true;
}
if ($users->APP_FTP_PROXY) {
$AS_PROXY_SECTION = true;
}
if ($users->NGINX_INSTALLED) {
$AS_PROXY_SECTION = true;
}
if (isNetSessions()) {
$array["{network_services}"] = "miniadm.network.php?webstats-middle=yes&title=yes";
}
$array["{tasks}"] = "miniadm.system.schedules.php";
$boot = new boostrap_form();
if ($users->AsSquidAdministrator or $users->AsWebMaster) {
if ($users->NGINX_INSTALLED) {
if ($AS_PROXY_SECTION) {
$array["{certificates_center}"] = "miniadmin.certificates.php?tabs=yes&title=yes";
}
}
}
if ($Privileges_members_admins) {
$array["{users_and_groups}"] = "miniadmin.system.members.php?tabs=yes&title=yes";
}
echo $boot->build_tab($array);
}
function tabs()
{
$page = CurrentPageName();
$array["{tasks}"] = "miniadm.system.schedules-engine.php";
$array["{parameters}"] = "{$page}?parameters=yes";
$boot = new boostrap_form();
echo $boot->build_tab($array);
}
function artica_section()
{
$EXPLAIN = array();
$boot = new boostrap_form();
$tpl = new templates();
//$EXPLAIN["BUTTONS"][]=$tpl->_ENGINE_parse_body(button("{new_website}", "YahooWin5('690','freewebs.HTTrack.php?item-id=0&t=0','WebCopy::{new_website}');"));
echo $boot->SearchFormGen("context,text,process,content", "search", "&context={$_GET["context"]}&category={$_GET["category"]}");
}
function syslog_section()
{
$EXPLAIN = array();
$boot = new boostrap_form();
$tpl = new templates();
//$EXPLAIN["BUTTONS"][]=$tpl->_ENGINE_parse_body(button("{new_website}", "YahooWin5('690','freewebs.HTTrack.php?item-id=0&t=0','WebCopy::{new_website}');"));
echo $boot->SearchFormGen("service", "search", null);
}
function tabs()
{
$page = CurrentPageName();
$tpl = new templates();
$t = time();
$boot = new boostrap_form();
$array["{status}"] = "{$page}?status=yes";
echo $boot->build_tab($array);
}
function tabs()
{
$page = CurrentPageName();
$sock = new sockets();
$mini = new boostrap_form();
$array["{parameters}"] = "squid.main.quicklinks.php?architecture-users=yes";
$array["{IT_charter}"] = "miniadmin.proxy.charter.php?tabs=yes";
echo $mini->build_tab($array);
}
function tabs()
{
$page = CurrentPageName();
$tpl = new templates();
$t = time();
$boot = new boostrap_form();
$array["{localdomains}"] = "miniadm.messaging.domains.php";
$array["{parameters}"] = "domains.manage.org.index.php?org_section=postfix&SwitchOrgTabs={$_SESSION["ou"]}&ou={$_SESSION["ou"]}&mem=yes&dn=&miniadm=yes";
echo $boot->build_tab($array);
}
function generate_graph()
{
include_once 'ressources/class.artica.graphs.inc';
$q = new mysql_squid_builder();
$page = CurrentPageName();
$tpl = new templates();
$t = $_GET["t"];
$ff = time();
$boot = new boostrap_form();
$sql = "SELECT zDate,not_categorized FROM tables_day WHERE not_categorized>0";
$c = 0;
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
echo "<H2>{$q->mysql_error}</H2><center style='font-size:11px'><code>{$sql}</code></center>";
}
if (mysql_num_rows($results) > 0) {
$nb_events = mysql_num_rows($results);
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
$xdata[] = $ligne["zDate"];
$ydata[] = $ligne["not_categorized"];
$c++;
$timeDate = strtotime($ligne["zDate"] . " 00:00:00");
$timeText = time_to_date($timeDate);
$js = $boot->trswitch("Loadjs('squid.visited.php?day={$ligne["zDate"]}&onlyNot=yes')");
$jsrecat = $boot->trswitch("Loadjs('squid.visited.php?recategorize-day-js={$ligne["zDate"]}&href={$page}')");
$BIGTABLE[] = "\n\t\t<tr>\n\t\t\t<td {$js}>{$timeText}</td>\n\t\t\t<td {$js}><strong style='font-size:18px'>{$ligne["not_categorized"]}</strong></td>\n\t\t\t<td {$jsrecat} width=1% nowrap><img src='img/loupe-32.png'></td>\n\t\t</tr>\n\t\t";
}
$Main = array($xdata, $ydata);
$Main = urlencode(base64_encode(serialize($Main)));
$t = time();
echo "<center>\n\t\t\t<div style='font-size:18px;margin-bottom:10px'>" . $tpl->_ENGINE_parse_body("{not_categorized}/{days}") . "</div>\n\t\t\t<div id='{$ff}-graph' style='width:940px;height:450px'><center><img src='img/wait_verybig_mini_red.gif'></center></div>\n\t\t\t</center>";
}
$BIGTABLE_COMPILED = $tpl->_ENGINE_parse_body("\n\t\t<table class='table table-bordered table-hover'>\n\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>{date}</th>\n\t\t\t\t\t<th colspan=2>{websites}</th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t") . @implode("", $BIGTABLE) . "</tbody></table>";
echo "<center>\n\t\t<div style='margin:8px;float-right;width:100%'>" . $tpl->_ENGINE_parse_body(button("{analyze}", "NoCategorizedAnalyze()", 18)) . "</div>\n\t\t</center>\n\t\t{$BIGTABLE_COMPILED}\n\t\n\t\t<script>\n\t\tfunction NoCategorizedAnalyze(){\n\t\t\n\t\t}\n\t\t\n\tvar x_NoCategorizedAnalyze= function (obj) {\n\t\t\tvar tempvalue=obj.responseText;\n\t\t\tif(tempvalue.length>3){alert(tempvalue)};\n\t \twindow.location.href = '{$page}';\n\t\t}\t\n\n\t\tfunction NoCategorizedAnalyze(){\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('NoCategorizedAnalyze','yes');\n\t\t\tXHR.sendAndLoad('{$page}', 'POST',x_NoCategorizedAnalyze);\n\t\t}\n\t\t\n\t\tLoadjs('{$page}?graphjs=yes&container={$ff}-graph&data={$Main}');\n\t\t\n\t</script>";
}
function parameters()
{
$users = new usersMenus();
$sock = new sockets();
$FailOverArtica = $sock->GET_INFO("FailOverArtica");
if (!is_numeric($FailOverArtica)) {
$FailOverArtica = 1;
}
$FailOverArticaParams = unserialize(base64_decode($sock->GET_INFO("FailOverArticaParams")));
if (!is_numeric($FailOverArticaParams["squid-internal-mgr-info"])) {
$FailOverArticaParams["squid-internal-mgr-info"] = 1;
}
if (!is_numeric($FailOverArticaParams["ExternalPageToCheck"])) {
$FailOverArticaParams["ExternalPageToCheck"] = 1;
}
$boot = new boostrap_form();
$boot->set_checkbox("FailOverArtica", "{FailOverArtica}", $FailOverArtica, array("TOOLTIP" => "{FailOverArtica_explain}", "DISABLEALL" => true));
$boot->set_spacertitle("{APP_PROXY}");
$boot->set_checkbox("squid-internal-mgr-info", "{failover_mgrinfo}", $FailOverArticaParams["squid-internal-mgr-info"], array("TOOLTIP" => "{failover_mgrinfo_explain}"));
$boot->set_checkbox("ExternalPageToCheck", "{failover_ExternalPageToCheck}", $FailOverArticaParams["ExternalPageToCheck"], array("TOOLTIP" => "{failover_ExternalPageToCheck_explain}"));
if (!$users->CORP_LICENSE) {
$boot->set_form_locked();
}
echo $boot->Compile();
}
function popup()
{
$tpl = new templates();
$page = CurrentPageName();
$ID = $_GET["ID"];
$title = "{new_page}";
$buttonname = "{add}";
if ($ID > 0) {
$q = new mysql_squid_builder();
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT * FROM reverse_pages_content WHERE ID='{$ID}'"));
$title = $ligne["subject"];
$buttonname = "{apply}";
}
if ($ligne["content"] == null) {
$ligne["content"] = "<html>\n<head>\n<title>It's works</title>\n</head>\n<body>\n\t<H1>It works!</H1>\n</body>\n</html>";
}
$boot = new boostrap_form();
$boot->set_hidden("ID", $ID);
$boot->set_formtitle($title);
if (!is_numeric($ligne["cachemin"])) {
$ligne["cachemin"] = 5;
}
$boot->set_list("cachemin", "{cache}", $ligne["cachemin"], $q->CACHE_AGES);
$boot->set_field("subject", "{subject}", $ligne["subject"]);
$boot->set_textarea("content", "{content}", $ligne["content"], array("ENCODE" => true, "HEIGHT" => 350));
$boot->set_button($buttonname);
$boot->set_RefreshSearchs();
if ($ID == 0) {
$boot->set_CloseYahoo("YahooWin6");
}
echo $boot->Compile();
}
function tabs()
{
$page = CurrentPageName();
$tpl = new templates();
$t = time();
$boot = new boostrap_form();
$mini = new miniadm();
$users = new usersMenus();
$ldap = new clladp();
$tpl = new templates();
if (isset($_GET["title"])) {
$title = $tpl->_ENGINE_parse_body("<H3>{users_and_groups}</H3><p>{users_and_groups_system_explain}</p>");
}
if ($ldap->IsKerbAuth()) {
$array["{activedirectory_members}"] = "miniadm.members.browse.php?section-search-ad=yes";
}
$array["{radius_members}"] = "miniadm.system.members.radius.php";
if ($mini->IFItsProxy()) {
$array["{hostpot_members}"] = "miniadmin.hotspot.php?tabs=yes&title=yes";
}
echo $title . $boot->build_tab($array);
}
function search()
{
if (!CheckRights()) {
senderror("{ERROR_NO_PRIVS}");
}
$boot = new boostrap_form();
$sock = new sockets();
$users = new usersMenus();
$maillog_path = $users->maillog_path;
$tpl = new templates();
$t = time();
$query = base64_encode($_GET["search"]);
if (!is_numeric($_POST["rp"])) {
$_POST["rp"] = 500;
}
$array = unserialize(base64_decode($sock->getFrameWork("postfix.php?query-maillog=yes&filter={$query}&maillog={$maillog_path}&rp={$_POST["rp"]}&zarafa-filter={$_GET["zarafa-filter"]}&mimedefang-filter={$_GET["mimedefang-filter"]}")));
$array = explode("\n", @file_get_contents("/usr/share/artica-postfix/ressources/logs/web/query.mail.log"));
krsort($array);
$zDate = $tpl->_ENGINE_parse_body("{zDate}");
$hostTXT = $tpl->_ENGINE_parse_body("{host}");
$serviceTXT = $tpl->_ENGINE_parse_body("{servicew}");
$eventsTXT = $tpl->_ENGINE_parse_body("{events}");
while (list($index, $line) = each($array)) {
$lineenc = base64_encode($line);
if (preg_match("#^[a-zA-Z]+\\s+[0-9]+\\s+([0-9\\:]+)\\s+(.+?)\\s+(.+?)\\[([0-9]+)\\]:(.+)#", $line, $re)) {
$date = "{$re[1]}";
$host = $re[2];
$service = $re[3];
$pid = $re[4];
$line = $re[5];
}
$class = LineToClass($line);
$img = statusLogs($line);
$loupejs = "ZoomEvents('{$lineenc}')";
$trSwitch = $boot->trswitch("blur()");
$tr[] = "\n\t\t<tr id='{$id}' class={$class} {$trSwitch}>\n\t\t<td style='font-size:12px' {$trSwitch} width=1% nowrap><i class='icon-time'></i> {$date}</td>\n\t\t<td style='font-size:12px' nowrap {$trSwitch} width=1% nowrap><i class='icon-arrow-right'></i> {$host}</td>\n\t\t<td style='font-size:12px' nowrap {$trSwitch} width=1% nowrap>{$service}</td>\n\t\t<td style='text-align:center;font-size:12px' width=1% nowrap>{$pid}</td>\n\t\t<td style='text-align:center;font-size:12px' width=1% nowrap><img src='{$img}'></td>\n\t\t<td style='font-size:12px' nowrap {$trSwitch} width=99% nowrap>{$line}</td>\n\t\t</tr>";
}
echo $tpl->_ENGINE_parse_body("\n\t\n\t\t\t<table class='table table-bordered table-hover'>\n\t\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>{$zDate}</th>\n\t\t\t\t\t<th>{$hostTXT}</th>\n\t\t\t\t\t<th>{$serviceTXT}</th>\n\t\t\t\t\t<th>PID</th>\n\t\t\t\t\t<th colspan=2>{$eventsTXT}</th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t") . @implode("\n", $tr) . " </tbody>\n\t\t\t\t</table>\n\t\t\t\t<script>\n\n\t</script>\n\t";
}
function SearchTask()
{
$boot = new boostrap_form();
$sock = new sockets();
$q = new mysql_squid_builder();
$tpl = new templates();
$CheckRunningTasks = base64_decode(unserialize($sock->getFrameWork("squid.php?CheckRunningTasks=yes")));
$table = "webfilters_schedules";
$searchstring = string_to_flexquery("SearchTask");
$sql = "SELECT * FROM {$table} WHERE TaskType={$_GET["TaskID"]} {$searchstring}";
$results = $q->QUERY_SQL($sql);
$q2 = new mysql();
$MyPage = CurrentPageName();
$schedules = new system_tasks();
while ($ligne = mysql_fetch_assoc($results)) {
$sincerun = null;
$tools = array();
$delete = imgtootltip("delete-24.png", "{delete} {$ligne['ID']}", "SquidTaskDelete('{$ligne['ID']}')");
$disabled = null;
if (isset($CheckRunningTasks[$ligne['ID']])) {
$run_icon = "preloader.gif";
}
//print_r($ligne);
$TimeText = $tpl->_ENGINE_parse_body($schedules->PatternToHuman($ligne["TimeText"]));
$TimeText = str_replace("<br>", "", $TimeText);
if (intval($ligne["enabled"]) == 0) {
$disabled = $tpl->_ENGINE_parse_body("<span class='label label-info'>{disabled}</span> ");
}
if (isset($CheckRunningTasks[$ligne['ID']])) {
$sincerun = "<br><i>{$CheckRunningTasks[$ligne['ID']]}</i>";
}
$tablename = "TaskSq{$ligne['ID']}";
if ($q2->TABLE_EXISTS($tablename, "artica_events")) {
$evs = $q2->COUNT_ROWS($tablename, "artica_events");
if ($evs > 0) {
$tools[] = "<i class='icon-info-sign'></i> {$evs} {events}";
}
}
$js = $boot->trswitch("Loadjs('miniadm.ajax.proxy.schedule.php?ID={$ligne['ID']}');");
$ligne["TimeDescription"] = utf8_encode($ligne["TimeDescription"]);
$delete = "<td {$js} width=1% style='text-align:center'>{$delete}</td>";
$delete = null;
$tr[] = "\n\t\t<tr class='{$class}'>\n\t\t<td {$js} width=1%>{$ligne['ID']}</td>\n\t\t<td {$js} >{$disabled}<strong style='font-size:16px;font-weight:bold'>{$ligne["TimeDescription"]}</strong>{$sincerun}<div>{$TimeText}</div><div style='font-size:11px'>" . $tpl->_ENGINE_parse_body(@implode(" | ", $tools)) . "</div></td>\n\t\t\n\t\t</tr>\n\t\t";
}
$tpl = new templates();
echo $tpl->_ENGINE_parse_body("<table class='table table-bordered table-hover'>\n\t\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th width=1%>{ID}</th>\n\t\t\t\t\t<th width=98%>{task}</th>\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t") . @implode("\n", $tr) . " </tbody>\n\t\t\n\t\t\t</table>\n";
}
function today()
{
$boot = new boostrap_form();
echo $boot->SearchFormGen("uid,ipaddr,sitename,words", "search-today");
}
function webstats_middle_table_items()
{
$t = $_GET["t"];
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_squid_builder();
$users = new usersMenus();
$sock = new sockets();
$xtime = $_GET["xtime"];
$database = "squidlogs";
$tablename_members = date("Ymd", $_GET["xtime"]) . "_members";
if ($_GET["FILTER"] == null) {
$_GET["FILTER"] = which_filter($tablename_members);
}
$subtable = "( SELECT {$_GET["FILTER"]},SUM(size) as size, SUM(hits) as hits FROM `{$tablename_members}` \n\tGROUP BY {$_GET["FILTER"]} HAVING LENGTH({$_GET["FILTER"]})>0) as t";
$search = '%';
$table = $subtable;
$page = 1;
$FORCE_FILTER = null;
$dansguardian_events = date("Ymd", $xtime) . "_hour";
if (!$q->TABLE_EXISTS($tablename_members, $database)) {
json_error_show("{$table} doesn't exists...");
}
if ($q->COUNT_ROWS($tablename_members, $database) == 0) {
json_error_show("No data");
}
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("items");
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$boot = new boostrap_form();
$pageStart = ($page - 1) * $rp;
$limitSql = "LIMIT {$pageStart}, {$rp}";
$sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$FORCE_FILTER} ORDER BY size DESC LIMIT 0,150";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql, $database);
while ($ligne = mysql_fetch_assoc($results)) {
$zmd5 = md5(serialize($ligne));
$color = "black";
//familysite size hits
$colorsize = "black";
$sizeorg = $ligne["size"];
$ligne["hits"] = numberFormat($ligne["hits"], 0, "", " ");
$ligne["size"] = FormatBytes($ligne["size"] / 1024);
if ($sizeorg > 102400000) {
$colorsize = "#4E0000";
}
if ($sizeorg > 512000000) {
$colorsize = "#9A0000";
}
// https://192.168.1.106:9000/
$urljs = "Loadjs('squid.members.zoom.php?table={$dansguardian_events}&field={$_GET["FILTER"]}&value={$ligne["{$_GET["FILTER"]}"]}')";
$link = $boot->trswitch($urljs);
$tr[] = "\n\t<tr id='{$id}'>\n\t<td {$link}><i class='icon-user'></i> {$ligne["name"]}</a>{$ligne["{$_GET["FILTER"]}"]}</td>\n\t<td {$link}><i class='icon-globe'></i> {$ligne["hits"]}</td>\n\t<td {$link}><i class='icon-globe'></i> {$ligne["size"]}</td>\n\t</tr>";
}
echo $tpl->_ENGINE_parse_body("\n\t\t\n\t\t<table class='table table-bordered table-hover'>\n\t\t\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>{{$_GET["FILTER"]}}</th>\n\t\t\t\t\t<th>{hits}</th>\n\t\t\t\t\t<th>{size}</th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t") . @implode("\n", $tr) . " </tbody>\n\t\t</table>";
}
function search()
{
$page = CurrentPageName();
$boot = new boostrap_form();
$tpl = new templates();
$searchstring = string_to_flexquery("search");
$ORDER = $boot->TableOrder(array("subject" => "ASC"));
$limitSql = "LIMIT 0,250";
$sql = "SELECT * FROM reverse_pages_content WHERE 1 {$searchstring} ORDER BY {$ORDER} {$limitSql}";
$q = new mysql_squid_builder();
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error_html();
}
while ($ligne = mysql_fetch_assoc($results)) {
$ID = $ligne["ID"];
$jsselect = null;
$select = null;
$js = $boot->trswitch("Loadjs('miniadmin.crm.pages.php?ID={$ID}')");
if ($_GET["field-id"] != null) {
$select = "Loadjs('{$page}?select-js=yes&ID={$ID}&field-id={$_GET["field-id"]}')";
$jsselect = $boot->trswitch($select);
$select_img = imgsimple("arrow-right-24.png", null, $select);
}
$delete_img = imgsimple("delete-24.png", null, "Loadjs('{$page}?delete-js=yes&ID={$ID}')");
$tr[] = "\n\t<tr id='{$ligne["ID"]}'>\n\t<td width='99%' nowrap {$js}><i class='icon-tags'></i> {$ligne["subject"]}</a></td>\n\t<td width='45px' nowrap style='vertical-align:middle;text-align:center'>{$select_img}</td>\n\t<td width='45px' nowrap style='vertical-align:middle;text-align:center'>{$delete_img}</td>\n\t</tr>";
}
$html = $boot->TableCompile(array("subject" => "{subject}", "ID" => "select", "delete" => "{delete}"), $tr);
echo $tpl->_ENGINE_parse_body($html);
}
function settings()
{
$tpl = new templates();
$page = CurrentPageName();
$q = new mysql_catz();
$users = new usersMenus();
$sock = new sockets();
$SquidDBTuningParameters = unserialize(base64_decode($sock->GET_INFO("MySQLCatzParams")));
$query_cache_size = $SquidDBTuningParameters["query_cache_size"];
$max_allowed_packet = $SquidDBTuningParameters["max_allowed_packet"];
$max_connections = $SquidDBTuningParameters["max_connections"];
$connect_timeout = $SquidDBTuningParameters["connect_timeout"];
$interactive_timeout = $SquidDBTuningParameters["interactive_timeout"];
$key_buffer_size = $SquidDBTuningParameters["key_buffer_size"];
$table_open_cache = $SquidDBTuningParameters["table_open_cache"];
$myisam_sort_buffer_size = $SquidDBTuningParameters["myisam_sort_buffer_size"];
$ListenPort = $SquidDBTuningParameters["ListenPort"];
$tmpdir = $SquidDBTuningParameters["tmpdir"];
if (!isset($SquidDBTuningParameters["net_read_timeout"])) {
$SquidDBTuningParameters["net_read_timeout"] = 120;
}
$serverMem = round(($users->MEM_TOTAL_INSTALLEE - 300) / 1024);
$VARIABLES = $q->SHOW_VARIABLES();
if (is_array($SquidDBTuningParameters)) {
while (list($key, $value) = each($SquidDBTuningParameters)) {
if (isset($SquidDBTuningParameters[$key])) {
if ($GLOBALS["VERBOSE"]) {
echo "VARIABLES[{$key}]={$VARIABLES[$key]} MySQLCatzParams[{$key}]={$SquidDBTuningParameters[$key]}<br>\n";
}
if ($VARIABLES[$key] == null) {
$VARIABLES[$key] = $SquidDBTuningParameters[$key];
}
}
}
}
$read_buffer_size = round($VARIABLES["read_buffer_size"] / 1024 / 1000, 2);
$read_rnd_buffer_size = round($VARIABLES["read_rnd_buffer_size"] / 1024 / 1000, 2);
$sort_buffer_size = round($VARIABLES["sort_buffer_size"] / 1024 / 1000, 2);
$thread_stack = round($VARIABLES["thread_stack"] / 1024 / 1000, 2);
$join_buffer_size = round($VARIABLES["join_buffer_size"] / 1024 / 1000, 2);
$max_tmp_table_size = round($VARIABLES["max_tmp_table_size"] / 1024 / 1000, 2);
$innodb_log_buffer_size = round($VARIABLES["innodb_log_buffer_size"] / 1024 / 1000, 2);
$innodb_additional_mem_pool_size = round($VARIABLES["innodb_additional_mem_pool_size"] / 1024 / 1000, 2);
$innodb_log_buffer_size = round($VARIABLES["innodb_log_buffer_size"] / 1024 / 1000, 2);
$innodb_buffer_pool_size = round($VARIABLES["innodb_buffer_pool_size"] / 1024 / 1000, 2);
$max_connections = $VARIABLES["max_connections"];
$per_thread_buffers = $sort_buffer_size + $read_rnd_buffer_size + $sort_buffer_size + $thread_stack + $join_buffer_size;
$total_per_thread_buffers = $per_thread_buffers * $max_connections;
if ($total_per_thread_buffers > $serverMem) {
$color = "#EB0000";
}
$query_cache_size = round($VARIABLES["query_cache_size"] / 1024 / 1000, 2);
$key_buffer_size = round($VARIABLES["key_buffer_size"] / 1024 / 1000, 2);
if ($tmpdir == null) {
$tmpdir = "/tmp";
}
$server_buffers = $key_buffer_size + $max_tmp_table_size + $innodb_buffer_pool_size + $innodb_additional_mem_pool_size + $innodb_log_buffer_size + $query_cache_size;
if ($server_buffers > $serverMem) {
$color = "#EB0000";
}
$max_used_memory = $server_buffers + $total_per_thread_buffers;
if ($max_used_memory > $serverMem) {
$color = "#EB0000";
}
$UNIT = "M";
if ($max_used_memory > 1000) {
$max_used_memory = round($max_used_memory / 1000, 2);
$UNIT = "G";
}
if (!is_numeric($ListenPort)) {
$ListenPort = 0;
}
$boot = new boostrap_form();
$boot->set_hidden("innodb_buffer_pool_size", $innodb_buffer_pool_size);
$boot->set_hidden("innodb_additional_mem_pool_size", $innodb_additional_mem_pool_size);
$boot->set_hidden("innodb_log_buffer_size", $innodb_log_buffer_size);
$boot->set_spacertitle("{threads}:");
$boot->set_field("read_buffer_size", "{read_buffer_size} (MB)", $read_buffer_size, array("TOOLTIP" => "{read_buffer_size_text}"));
$boot->set_field("read_rnd_buffer_size", "{read_rnd_buffer_size} (MB)", $read_rnd_buffer_size, array("TOOLTIP" => "{read_rnd_buffer_size_text}"));
$boot->set_field("sort_buffer_size", "{sort_buffer_size} (MB)", $sort_buffer_size, array("TOOLTIP" => "{sort_buffer_size_text}"));
$boot->set_field("thread_stack", "Thread Stack", $thread_stack, array("TOOLTIP" => "{thread_stack_text}"));
$boot->set_spacertitle("{server}:");
$boot->set_field("ListenPort", "{listen_port}", $ListenPort);
$boot->set_field("tmpdir", "{working_directory}", $tmpdir, array("BUTTON" => array("LABEL" => "{browse}", "JS" => "Loadjs('SambaBrowse.php?no-shares=yes&field=%f&no-hidden=yes')")));
$boot->set_field("net_read_timeout", "{net_read_timeout} ({seconds})", $SquidDBTuningParameters["net_read_timeout"]);
$boot->set_field("max_connections", "{max_connections}", $max_connections);
$boot->set_field("key_buffer_size", "{key_buffer_size} (MB)", $key_buffer_size);
$boot->set_field("max_tmp_table_size", "MAX TMP Table size (MB)", $max_tmp_table_size);
$boot->set_field("query_cache_size", "{query_cache_size} (MB)", $query_cache_size, array("TOOLTIP" => "{thread_stack_text}"));
$boot->set_button("{apply}");
$boot->set_formdescription("{$server_buffers}M + {$total_per_thread_buffers}M = {$max_used_memory}{$UNIT}");
$html = $boot->Compile();
echo $tpl->_ENGINE_parse_body($html);
}
function proxy_behavior()
{
$boot = new boostrap_form();
$boot->set_formtitle("{proxy_behavior}");
$boot->set_formdescription("{proxy_behavior_explain}");
$sock = new sockets();
$exclusive_internet_proxy = 1;
$exclusive_reverse_proxy = 0;
$mixed_mode = 0;
$SquidActHasReverse = $sock->GET_INFO("SquidActHasReverse");
$SquidActHasReverseOnly = $sock->GET_INFO("SquidActHasReverseOnly");
if (!is_numeric($SquidActHasReverse)) {
$SquidActHasReverse = 0;
}
if (!is_numeric($SquidActHasReverseOnly)) {
$SquidActHasReverseOnly = 0;
}
if ($SquidActHasReverseOnly == 1) {
$exclusive_internet_proxy = 0;
$exclusive_reverse_proxy = 1;
$mixed_mode = 0;
}
if ($SquidActHasReverseOnly == 0) {
if ($SquidActHasReverse == 1) {
$exclusive_internet_proxy = 0;
$exclusive_reverse_proxy = 0;
$mixed_mode = 1;
}
}
$boot->set_checkbox("exclusive_reverse_proxy", "{exclusive_reverse_proxy}", $exclusive_reverse_proxy);
$boot->set_checkbox("exclusive_internet_proxy", "{exclusive_internet_proxy}", $exclusive_internet_proxy);
$boot->set_checkbox("mixed_mode", "{mixed_mode}", $mixed_mode);
$boot->set_button("{apply}");
echo $boot->Compile();
}
function websites_directories_search()
{
$searchstring = string_to_flexquery("directories-search");
$q = new mysql_squid_builder();
$servername = $_GET["servername"];
$servername_enc = urlencode($servername);
$sql = "SELECT * FROM reverse_dirs WHERE servername='{$servername}' {$searchstring} ORDER BY directory LIMIT 0,250";
$results = $q->QUERY_SQL($sql);
$tpl = new templates();
$GLOBALS["CLASS_TPL"] = $tpl;
$boot = new boostrap_form();
$page = CurrentPageName();
$t = time();
while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) {
$icon = "folder-move-64.png";
$arrow = "arrow-right-64.png";
$color = "black";
$md = md5(serialize($ligne));
$delete = imgsimple("delete-48.png", null, "Loadjs('{$page}?delete-folder-id-js={$ligne["folderid"]}');");
$jsEditWW = $boot->trswitch("Loadjs('website-js=yes&servername={$servername_enc}')");
$jsedit = $boot->trswitch("Loadjs('{$page}?website-directory-js=yes&servername={$servername}&folderid={$ligne["folderid"]}')");
$jseditA = $jsedit;
$ligne2 = mysql_fetch_array($q->QUERY_SQL("SELECT servername,ipaddr,port FROM reverse_sources WHERE ID='{$ligne["cache_peer_id"]}'"));
$destination = "{$ligne2["servername"]}:{$ligne2["port"]}";
$jseditS = $boot->trswitch("Loadjs('{$page}?js-source=yes&source-id={$ligne["cache_peer_id"]}')");
$jseditDest = $jsedit;
$DestFont = 16;
$directory = trim(stripslashes($ligne["directory"]));
$hostweb = "<div><i>{$ligne["hostweb"]}</i></div>";
if ($ligne["local"] == 1) {
$destination = $ligne["localdirectory"];
}
if ($ligne["webpageid"] > 0) {
$ligne2 = mysql_fetch_array($q->QUERY_SQL("SELECT subject FROM reverse_pages_content WHERE ID='{$ligne["webpageid"]}'"));
$destination = $ligne2["subject"];
$hostweb = null;
$DestFont = 12;
$jseditDest = $boot->trswitch("Loadjs('miniadmin.crm.pages.php?ID={$ligne["webpageid"]}')");
}
$tr[] = "\n\t\t<tr style='color:{$color}' id='{$md}'>\n\t\t<td width=1% nowrap {$jsedit}><img src='img/{$icon}'></td>\n\t\t<td width=80% {$jsedit}><span style='font-size:16px;font-weight:bold'>http(s)://{$servername}/{$directory}</span></td>\n\t\t<td width=1% nowrap {$jsedit} style='vertical-align:middle'><img src='img/{$arrow}'></td>\n\t\t<td width=1% nowrap {$jseditDest} style='vertical-align:middle'>\n\t\t\t<span style='font-size:{$DestFont}px;font-weight:bold'>{$destination}</span>{$hostweb}\n\t\t</td>\n\t\t\t\n\t\t\t\n\t\t<td width=1% nowrap style='vertical-align:middle'>{$delete}</td>\n\t\t</tr>\n\t\t";
}
$t = time();
$freeweb_compile_background = $tpl->javascript_parse_text("{freeweb_compile_background}");
$reset_admin_password = $tpl->javascript_parse_text("{reset_admin_password}");
$delete_freeweb_text = $tpl->javascript_parse_text("{delete_freeweb_text}");
$delete_freeweb_dnstext = $tpl->javascript_parse_text("{delete_freeweb_dnstext}");
echo $tpl->_ENGINE_parse_body("\n<table class='table table-bordered table-hover'>\n\t<thead>\n\t\t<tr>\n\t\t\t<th colspan=2>{paths}</th>\n\t\t\t<th colspan=2>{destination}</th>\n\t\t\t<th> </th>\n\t\t</tr>\n\t\t</thead>\n<tbody>") . @implode("", $tr) . "</tbody></table>\n<script>\n var FreeWebIDMEM{$t}='';\nvar xDelete{$t}=function (obj) {\n\tvar results=obj.responseText;\n\tif(results.length>10){alert(results);return;}\n\t\$('#'+FreeWebIDMEM{$t}).remove();\n}\n\t\nfunction Delete{$t}(server,md){\n\tFreeWebIDMEM{$t}=md;\n\tif(confirm('{$delete_freeweb_text}')){\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('website-delete',server);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t}\n}\n</script>\n";
}
function webstats_middle()
{
$page = CurrentPageName();
$tpl = new templates();
$users = new usersMenus();
$t = time();
$boot = new boostrap_form();
if (isset($_GET["title"])) {
$buuton0 = button("{save_network_settings}", "Loadjs('{$page}?save-network=yes')");
$buuton1 = button("{compile_network_settings}", "Loadjs('{$page}?apply-network=yes')");
$title = $tpl->_ENGINE_parse_body("<div style='float:right'>{$buuton0} {$buuton1}</div><H3>{network_services}</H3><p>{network_services_text}</p>");
}
if (isNetSessions()) {
$array["{edit_networks}"] = "miniadm.network.interfaces.php";
$array["{routing_tables}"] = "miniadm.network.routes.php";
}
if ($users->AsDnsAdministrator) {
if ($users->POWER_DNS_INSTALLED) {
$array["{dns_service}"] = "miniadm.PowerDNS.php?popup=yes&explain-title=yes";
}
}
if ($_SESSION["ASDCHPAdmin"]) {
if ($users->dhcp_installed) {
$array["{APP_DHCP}"] = "miniadm.dhcp.php?webstats-middle=yes&explain-title=yes";
}
}
if ($_SESSION["AllowChangeDomains"]) {
$array["{manage_internet_domains}"] = "miniadm.smtpdom.php?webstats-middle=yes&title=yes";
}
$array["{etc_hosts}"] = "miniadm.network.etchosts.php";
$array["{computers}"] = "miniadm.computers.browse.php?page=yes";
//$array["{events}"]="$page?events=yes";
echo $title . $boot->build_tab($array);
return;
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
ini_set('error_prepend_string', null);
ini_set('error_append_string', null);
$page = CurrentPageName();
$tpl = new templates();
$tr = array();
$dhcp = Paragraphe("64-dhcp.png", "{APP_DHCP}", "{APP_DHCP_TEXT}", "miniadm.dhcp.php?webstats-middle=yes");
$domains = Paragraphe("domain-main-64.png", "{manage_internet_domains}", "{manage_internet_domains_text}", "miniadm.smtpdom.php");
if (!$_SESSION["ASDCHPAdmin"]) {
$dhcp = Paragraphe("64-dhcp-grey.png", "{APP_DHCP}", "{APP_DHCP_TEXT}");
}
if (!$users->dhcp_installed) {
$dhcp = null;
if ($_SESSION["ASDCHPAdmin"]) {
$dhcp = Paragraphe("64-dhcp-grey.png", "{APP_DHCP}", "{APP_DHCP_TEXT}");
}
}
if (!$_SESSION["AsOrgDNSAdmin"]) {
$pdns = Paragraphe("dns-64-grey.png", "{manage_DNS_database}", "{APP_PDNS_TEXT}");
}
if (!$_SESSION["AllowChangeDomains"]) {
$domains = Paragraphe("domain-main-64-grey.png", "{manage_internet_domains}", "{manage_internet_domains_text}");
}
if (!$users->POWER_DNS_INSTALLED) {
$pdns = null;
}
$tr[] = $dhcp;
$tr[] = $domains;
echo $title . $tpl->_ENGINE_parse_body(CompileTr3($tr));
}
function charters_search()
{
$boot = new boostrap_form();
$tpl = new templates();
$page = CurrentPageName();
$searchstring = string_to_flexquery("itcharters-search");
$q = new mysql_squid_builder();
$ORDER = $boot->TableOrder(array("title" => "ASC"));
$table = "itcharters";
$t = time();
$sql = "SELECT ID,title,TextIntro,TextButton FROM {$table} WHERE 1 {$searchstring} ORDER BY {$ORDER} LIMIT 0,150";
writelogs($sql, __FUNCTION__, __FILE__, __LINE__);
$results = $q->QUERY_SQL($sql);
if (!$q->ok) {
echo "<p class=text-error>{$q->mysql_error}<hr><code>{$sql}</code></p>";
}
while ($ligne = mysql_fetch_assoc($results)) {
$md = md5(serialize($ligne));
$link = $boot->trswitch("Loadjs('{$page}?charter-js=yes&ID={$ligne["ID"]}')");
$delete = imgtootltip("delete-24.png", null, "Delete{$t}({$ligne["ID"]},'{$md}')");
$tr[] = "\n\t<tr id='{$md}'>\n\t<td {$link}><i class='icon-globe'></i> {$ligne["title"]}</td>\n\t<td width=1% nowrap>{$delete}</td>\n\t</tr>";
}
$delete_text = $tpl->javascript_parse_text("{delete_this_itchart}");
echo $boot->TableCompile(array("title" => "{it_charters}", "delete" => null), $tr) . "\n<script>\nvar mem{$t}='';\nvar xDelete{$t}=function(obj){\n\tvar tempvalue=obj.responseText;\n\tif(tempvalue.length>3){alert(tempvalue);return;}\n\t\$('#'+mem{$t}).remove();\n}\nfunction Delete{$t}(ID,mem){\n\tmem{$t}=mem;\n\tif(confirm('{$delete_text} '+ID+'?')){\n\t\tmem{$t}=mem;\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('itcharters-delete',ID);\n\t\tXHR.sendAndLoad('{$page}', 'POST',xDelete{$t});\n\t\t}\n\t}\n</script>\t\t\t\t\t\n";
}
function tab()
{
$page = CurrentPageName();
$tpl = new templates();
$t = $_GET["t"];
$ff = time();
$boot = new boostrap_form();
$year = $_GET["year"];
$month = $_GET["month"];
$time = strtotime("{$year}-{$month}-01 00:00:00");
$title = date("{F} Y", $time);
$suffix = suffix();
$array["{flow}"] = "{$page}?flow=yes{$suffix}";
$array["{top_users}"] = "{$page}?topuser=yes{$suffix}";
$array["{members}"] = "{$page}?topmembers-table-section=yes{$suffix}";
echo $tpl->_ENGINE_parse_body("<div style='margin-top:20px'><H3>{$_GET["uid"]} {$title}</H3></div>") . $boot->build_tab($array);
}
function items_search()
{
$page = CurrentPageName();
$boot = new boostrap_form();
$tpl = new templates();
$searchstring = string_to_flexquery("items-search");
$ORDER = $boot->TableOrder(array("token" => "ASC"));
$limitSql = "LIMIT 0,150";
$sql = "SELECT * FROM nginx_exploits_items WHERE groupid={$_GET["groupid"]} {$searchstring} ORDER BY {$ORDER} {$limitSql}";
$q = new mysql_squid_builder();
$results = $q->QUERY_SQL($sql);
$sock = new sockets();
$not = $tpl->_ENGINE_parse_body("{is_not}");
if (!$q->ok) {
echo $q->mysql_error_html();
}
while ($ligne = mysql_fetch_assoc($results)) {
$reverse = null;
if ($ligne["reverse"] == 1) {
$reverse = "<strong>{$not}</strong> ";
}
$linkipaddr = $boot->trswitch("Loadjs('{$page}?js-item=yes&ID={$ligne["ID"]}&groupid={$ligne["groupid"]}&servername={$_GET["servername"]}')");
$ligne["token"] = $tpl->_ENGINE_parse_body("{{$ligne["token"]}}");
$delete = imgsimple("delete-24.png", null, "Loadjs('{$page}?delete-item-js={$ligne["ID"]}&ID={$ligne["ID"]}')");
$tr[] = "\n\t<tr id='{$ligne["ID"]}'>\n\t<td {$linkipaddr} width='30%' nowrap><i class='icon-list-alt'></i> {$ligne["token"]}</a></td>\n\t<td {$linkipaddr} width='70%' nowrap><i class='icon-list-alt'></i> {$reverse}{$ligne["pattern"]}</a></td>\n\t<td style='text-align:center' width='24px' nowrap>{$delete}</td>\n\t</tr>";
}
$html = $boot->TableCompile(array("token" => "{token}", "pattern" => "{pattern}", "delete" => "{delete}"), $tr);
echo $tpl->_ENGINE_parse_body($html);
}
function table_sites_search()
{
$t = $_GET["t"];
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_squid_builder();
$users = new usersMenus();
$sock = new sockets();
$boot = new boostrap_form();
$database = "squidlogs";
$search = '%';
$table = "generic_categories";
$rp = 250;
$page = 1;
$FORCE_FILTER = null;
$ORDER = "ORDER BY size DESC";
if (!$q->TABLE_EXISTS($table, $database)) {
senderror("{$table} doesn't exists...");
}
if ($q->COUNT_ROWS($table, $database) == 0) {
senderror("No data");
}
if (isset($_POST["sortname"])) {
if ($_POST["sortname"] != null) {
$ORDER = "ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";
}
}
if (isset($_POST['page'])) {
$page = $_POST['page'];
}
$search = string_to_flexquery("category-search");
if (isset($_POST['rp'])) {
$rp = $_POST['rp'];
}
$category = mysql_escape_string2($_GET["category"]);
$sql = "SELECT SUM( size ) AS size,SUM(hits) as hits, zDate, category FROM generic_categories GROUP BY category,zDate\n\tHAVING category='{$_GET["category"]}' ORDER BY zDate";
$results = $q->QUERY_SQL($sql);
$results = $q->QUERY_SQL($sql, $database);
if (!$q->ok) {
senderror($q->mysql_error . "<br>{$sql}");
}
while ($ligne = mysql_fetch_assoc($results)) {
$color = "black";
$ligne["hits"] = numberFormat($ligne["hits"], 0, "", " ");
$ligne["size"] = FormatBytes($ligne["size"] / 1024);
$xtime = strtotime($ligne["zDate"] . " 00:00:00");
$dateText = time_to_date($xtime);
$catz = urlencode($_GET["category"]);
$jsSitename = $boot->trswitch("Loadjs('miniadm.webstats.websites.ByDayByCategory.php?category={$catz}&xtime={$xtime}')");
$tr[] = "\n\t\t\t\t<tr {$jsSitename}>\n\t\t\t\t\t<td><i class='icon-time'></i> {$dateText}</a></td>\n\t\t\t\t\t<td><i class='icon-info-sign'></i> {$ligne["size"]}</td>\n\t\t\t\t\t<td><i class='icon-info-sign'></i> {$ligne["hits"]}</td>\n\t\t\t\t</tr>";
}
echo $tpl->_ENGINE_parse_body("\n\t\n\t\t<table class='table table-bordered table-hover'>\n\t\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>{day}</th>\n\t\t\t\t\t<th>{size}</th>\n\t\t\t\t\t<th>{hits}</th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t\t") . @implode("", $tr) . "</tbody></table>";
}
function section_webrules_search()
{
$q = new mysql_squid_builder();
$database = "squidlogs";
$sock = new sockets();
$tpl = new templates();
$search = '%';
$table = "websites_caches_params";
$searchstring = string_to_flexquery("search-webrules");
$sql = "SELECT * FROM `{$table}` WHERE 1 {$searchstring} ORDER BY sitename";
$results = $q->QUERY_SQL($sql, $database);
if (!$q->ok) {
senderror($q->mysql_error);
}
$boot = new boostrap_form();
$t = time();
while ($ligne = mysql_fetch_assoc($results)) {
$ID = md5($ligne["sitename"]);
$delete = imgtootltip("delete-24.png", "{delete}", "DeleteWebsiteCached{$t}('{$ligne["sitename"]}','{$ID}')");
$select = "Loadjs('squid.miniwebsite.tasks.php?cache-params-js=yes&sitename={$ligne["sitename"]}&table-t={$_GET["t"]}');";
$ligne["MIN_AGE"] = $ligne["MIN_AGE"];
$ligne["MIN_AGE"] = $tpl->javascript_parse_text(distanceOfTimeInWords(time(), mktime() + $ligne["MIN_AGE"] * 60, true));
$ligne["MAX_AGE"] = $ligne["MAX_AGE"];
$ligne["MAX_AGE"] = $tpl->javascript_parse_text(distanceOfTimeInWords(time(), mktime() + $ligne["MAX_AGE"] * 60, true));
if (trim($ligne["sitename"]) == '.') {
$ligne["sitename"] = $tpl->_ENGINE_parse_body("{all}");
}
$link = $boot->trswitch($select);
$tr[] = "\n\t\t<tr id='{$ID}'>\n\t\t<td {$link}><i class='icon-globe'></i> {$ligne["sitename"]}</td>\n\t\t<td {$link} width=1% nowrap>{$ligne["MIN_AGE"]}</td>\n\t\t<td {$link} width=1% nowrap>{$ligne["PERCENT"]}%</td>\n\t\t<td {$link} width=1% nowrap>{$ligne["MAX_AGE"]}</td>\n\t\t<td width=1% nowrap>{$delete}</td>\n\t\t</tr>";
}
echo $tpl->_ENGINE_parse_body("\n\t\t\t<table class='table table-bordered table-hover'>\n\t\n\t\t\t<thead>\n\t\t\t<tr>\n\t\t\t<th>{website}</th>\n\t\t\t<th>{expire_time}</th>\n\t\t\t<th>%</th>\n\t\t\t<th>{limit}</th>\n\t\t\t<th> </th>\n\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t<tbody>\n\t\t\t") . @implode("", $tr) . "</tbody></table>\n<script>\nvar websiteMem{$t}='';\n\t\tvar x_DeleteWebsiteCached{$t}= function (obj) {\n\t\t\tvar results=obj.responseText;\n\t\t\tif(results.length>0){alert(results);return;}\n\t\t\t\$('#'+websiteMem{$t}).remove();\t\t\t\n\t\t\t\t\n\t\t}\t\n\n\t\tfunction DeleteWebsiteCached{$t}(domain,id){\n\t\t\twebsiteMem{$t}=id;\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('DELETE',domain);\n\t\t\tXHR.sendAndLoad('squid.caches32.caches-www.php', 'POST',x_DeleteWebsiteCached{$t});\n\t\t}\n</script>\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n";
}
function table_blocked()
{
$tpl = new templates();
$MyPage = CurrentPageName();
$q = new mysql_squid_builder();
$dt = strtotime("{$_GET["zday"]} 00:00:00");
if (isset($_SESSION["QUERY_BLOCKED_DATE"])) {
$dt = $_SESSION["QUERY_BLOCKED_DATE"];
}
$zday = date('Ymd', $dt);
$title_date = time_to_date($dt);
$MAIN_QUERY = $_GET["query-blocked"];
$search = '%';
$table = $zday . "_blocked";
if (!$q->TABLE_EXISTS($table)) {
senderrors("{no_such_table}:{$table}");
}
$main_query = $_GET["query-blocked"];
$QUERY_BLOCKED_UID = $_SESSION["QUERY_BLOCKED_UID"];
$QUERY_BLOCKED_CATEGORY = $_SESSION["QUERY_BLOCKED_CATEGORY"];
$BLOCKED_CATEGORY_LIMIT = $_SESSION["BLOCKED_CATEGORY_LIMIT"];
if (!is_numeric($BLOCKED_CATEGORY_LIMIT)) {
$BLOCKED_CATEGORY_LIMIT = 250;
}
if ($QUERY_BLOCKED_UID != null) {
$title_members = " {and} {member}:{$QUERY_BLOCKED_UID}";
$QUERY_BLOCKED_UID_OP = " = ";
if (preg_match("#not.*?:(.+)#i", $QUERY_BLOCKED_UID, $re)) {
$neg = true;
$QUERY_BLOCKED_UID = trim($re[1]);
}
if ($neg) {
$QUERY_BLOCKED_UID_OP = " != ";
}
$QUERY_BLOCKED_UID = str_replace("*", "%", $QUERY_BLOCKED_UID);
if (strpos(" {$QUERY_BLOCKED_UID}", "%") > 0) {
$QUERY_BLOCKED_UID_OP = " LIKE ";
if ($neg) {
$QUERY_BLOCKED_UID_OP = " NOT LIKE ";
}
}
$QUERY_BLOCKED_UID_SQL = " AND (\n\t\t\t(`client` {$QUERY_BLOCKED_UID_OP}'{$QUERY_BLOCKED_UID}') \n\t\t\tOR (`hostname` {$QUERY_BLOCKED_UID_OP}'{$QUERY_BLOCKED_UID}')\n\t\t\tOR (`uid` {$QUERY_BLOCKED_UID_OP}'{$QUERY_BLOCKED_UID}')\n\t\t\t)\n\t\t";
}
$neg = false;
if ($QUERY_BLOCKED_CATEGORY != null) {
$title_cat = " {and} {category}:{$QUERY_BLOCKED_CATEGORY}";
if (preg_match("#not.*?:(.+)#i", $QUERY_BLOCKED_CATEGORY, $re)) {
$neg = true;
$QUERY_BLOCKED_CATEGORY = trim($re[1]);
}
$QUERY_BLOCKED_CATEGORY = str_replace("*", "%", $QUERY_BLOCKED_CATEGORY);
$QUERY_BLOCKED_CATEGORY_OP = " = ";
if ($neg) {
$QUERY_BLOCKED_CATEGORY_OP = " != ";
}
if (strpos(" {$QUERY_BLOCKED_CATEGORY}", "%") > 0) {
$QUERY_BLOCKED_CATEGORY_OP = " LIKE ";
if ($neg) {
$QUERY_BLOCKED_CATEGORY_OP = " NOT LIKE ";
}
}
$QUERY_BLOCKED_CATEGORY_SQL = " AND `category`{$QUERY_BLOCKED_CATEGORY_OP}'{$QUERY_BLOCKED_CATEGORY}'";
}
$neg = false;
if ($MAIN_QUERY != null) {
$title_cat = " {and} {website}:{$MAIN_QUERY}";
if (preg_match("#not.*?:(.+)#i", $MAIN_QUERY, $re)) {
$neg = true;
$MAIN_QUERY = trim($re[1]);
}
$MAIN_QUERY = str_replace("*", "%", $MAIN_QUERY);
$MAIN_QUERY_OP = " = ";
if ($neg) {
$MAIN_QUERY_OP = " != ";
}
if (strpos(" {$MAIN_QUERY}", "%") > 0) {
$MAIN_QUERY_OP = " LIKE ";
if ($neg) {
$MAIN_QUERY_OP = " NOT LIKE ";
}
}
$MAIN_QUERY_SQL = " AND `website`{$MAIN_QUERY_OP}'{$MAIN_QUERY}'";
}
$sql = "SELECT * FROM `{$table}` WHERE 1 {$MAIN_QUERY_SQL}{$QUERY_BLOCKED_UID_SQL}{$QUERY_BLOCKED_CATEGORY_SQL} ORDER BY zDate LIMIT 0,{$BLOCKED_CATEGORY_LIMIT}";
$results = $q->QUERY_SQL($sql, 'artica_events');
$boot = new boostrap_form();
$UnBlockWebSiteExplain = $tpl->javascript_parse_text("{UnBlockWebSiteExplain}");
$today = date('Y-m-d');
if (!$q->ok) {
sendserrors($q->mysql_error . "<br>{$sql}");
}
$t = time();
$q2 = new mysql();
while ($ligne = mysql_fetch_assoc($results)) {
$member = $ligne["client"];
if ($ligne["hostname"] != null) {
$member = $ligne["hostname"];
}
if ($ligne["uid"] != null) {
$member = $ligne["uid"];
}
$js = "Loadjs('squid.categories.php?category={$ligne["category"]}&website={$ligne["website"]}',true)";
$link = $boot->trswitch($js);
$unblock = imgsimple("whitelist-24.png", null, "UnBlockWebSite{$t}('{$ligne["website"]}')");
$ligne3 = mysql_fetch_array($q2->QUERY_SQL("SELECT items FROM urlrewriteaccessdeny WHERE items='{$ligne["website"]}'", "artica_backup"));
if (!$q->ok) {
$unblock = "<img src='img/icon_err.gif'><br>{$q->mysql_error}";
} else {
if ($ligne3["items"] != null) {
$unblock = imgsimple("20-check.png", null, null);
}
}
if ($ligne["blocktype"] != null) {
$blocktype = "<div><i style='font-size:10px'>{$ligne["blocktype"]}</i></div>";
}
$tr[] = "\n\t\t<tr>\n\t\t<td nowrap><i class='icon-time'></i> {$ligne["zDate"]}</td>\n\t\t<td {$link}><i class='icon-user'></i> {$member}</td>\n\t\t<td {$link}><i class='icon-globe'></i> {$ligne["website"]}{$blocktype}</td>\n\t\t<td {$link}><i class='icon-info'></i> {$ligne["category"]}</td>\n\t\t<td {$link}><i class='icon-info'></i> {$ligne["rulename"]}</td>\n\t\t<td>{$unblock}</td>\n\t\t</tr>";
}
echo $tpl->_ENGINE_parse_body("\n\t\t\t\n\t\t<p>{search}:{$title_date}{$title_members}{$title_cat}</p>\n\t\t<table class='table table-bordered table-hover'>\n\t\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>{zDate} </th>\n\t\t\t\t\t<th>{member}</th>\n\t\t\t\t\t<th>{website}</th>\n\t\t\t\t\t<th>{category}</th>\n\t\t\t\t\t<th>{rule}</th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t") . @implode("\n", $tr) . " </tbody>\n\t\t</table>\n\t\t<script>\n\tvar x_UnBlockWebSite{$t}=function(obj){\n\t var tempvalue=obj.responseText;\n\t if(tempvalue.length>3){alert(tempvalue);}\n\t \n\t}\t\n\nfunction UnBlockWebSite{$t}(domain){\n\tif(confirm('{$UnBlockWebSiteExplain}:'+domain+' ?')){\n\t\tvar XHR = new XHRConnection();\n\t\tXHR.appendData('unlock',domain);\n\t\tXHR.sendAndLoad('squid.blocked.events.php', 'POST',x_UnBlockWebSite{$t});\n\t}\n\n}\n</script>\t\t\t\t\t\n";
}
function table_all_videos_search()
{
$page = CurrentPageName();
$tpl = new templates();
$users = new usersMenus();
$TB_HEIGHT = 500;
$TB_WIDTH = 910;
$uid = $_GET["uid"];
$t = time();
$new_entry = $tpl->javascript_parse_text("{new_backup_rule}");
$imapserv = $tpl->_ENGINE_parse_body("{imap_server}");
$account = $tpl->_ENGINE_parse_body("{account}");
// $title=$tpl->_ENGINE_parse_body("$attachments_storage {items}: «$size»");
$filessize = $tpl->_ENGINE_parse_body("{filesize}");
$action_delete_rule = $tpl->javascript_parse_text("{action_delete_rule}");
$enable = $tpl->_ENGINE_parse_body("{enable}");
$compile_rules = $tpl->_ENGINE_parse_body("{compile_rules}");
$online_help = $tpl->_ENGINE_parse_body("{online_help}");
$enabled = $tpl->_ENGINE_parse_body("{enabled}");
$items = $tpl->_ENGINE_parse_body("{items}");
$error_want_operation = $tpl->javascript_parse_text("{error_want_operation}");
$events = $tpl->javascript_parse_text("{events}");
$category = $tpl->javascript_parse_text("{category}");
$title = $tpl->javascript_parse_text("{video_title}");
$created = $tpl->javascript_parse_text("{created}");
$duration = $tpl->javascript_parse_text("{duration}");
$hits = $tpl->javascript_parse_text("{hits}");
$categories = $tpl->javascript_parse_text("{categories}");
if (!isset($_SESSION["QUERY_YOUTUBE_LIMIT"])) {
$_SESSION["QUERY_YOUTUBE_LIMIT"] = 250;
}
$q = new mysql_squid_builder();
$search = string_to_flexquery("videos-search");
$filters = array();
$filters[] = SearchToSql("category", $_SESSION["QUERY_YOUTUBE_CATE"]);
$sql = "SELECT * FROM youtube_objects WHERE 1 {$search} " . @implode($filters, " ") . " ORDER BY uploaded DESC LIMIT 0,{$_SESSION["QUERY_YOUTUBE_LIMIT"]}";
$results = $q->QUERY_SQL($sql);
$boot = new boostrap_form();
if (!$q->ok) {
die("<p class=text-error>{$q->mysql_error}</p>");
}
$seconds = $tpl->_ENGINE_parse_body("{seconds}");
$minutes = $tpl->_ENGINE_parse_body("{minutes}");
$hours = $tpl->_ENGINE_parse_body("{hours}");
while ($ligne = mysql_fetch_assoc($results)) {
$youtubeid = $ligne["youtubeid"];
$color = "black";
$unit = $seconds;
$ligne["duration"] = format_time($ligne["duration"]);
$urljsSIT = "Loadjs('miniadm.webstats.youtubeid.php?youtubeid={$youtubeid}')";
$link = $boot->trswitch($urljsSIT);
$jsvideo = $boot->trswitch("Loadjs('miniadm.webstats.youtubeid.php?youtubeid={$youtubeid}');");
$tr[] = "\n\t\t<tr id='{$id}'>\n\t\t<td {$jsvideo}><img src='{$page}?thumbnail={$youtubeid}' class=img-polaroid></td>\n\t\t<td {$link} nowrap><i class='icon-time'></i> {$ligne["uploaded"]}</td>\n\t\t<td {$link}><i class='icon-info-sign'></i> {$ligne["title"]}</td>\n\t\t<td {$link} nowrap><i class='icon-info-sign'></i> {$ligne["category"]}</td>\n\t\t<td {$link} nowrap><i class='icon-info-sign'></i> {$ligne["duration"]}</td>\n\t\t<td {$link} nowrap><i class='icon-info-sign'></i> {$ligne["hits"]}</td>\n\t\t</tr>";
}
echo $tpl->_ENGINE_parse_body("\n\t<table class='table table-bordered table-hover'>\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>{$created}</th>\n\t\t\t\t\t<th>{$title}</th>\n\t\t\t\t\t<th>{$category} {$_SESSION["QUERY_YOUTUBE_CATE"]}</th>\n\t\t\t\t\t<th>{$duration}</th>\n\t\t\t\t\t<th>{$hits}</th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t") . @implode("", $tr) . "</tbody></table>";
}
function www_top_table()
{
$q = new mysql_squid_builder();
$tpl = new templates();
$boot = new boostrap_form();
$tablename = "www_" . $q->uid_to_tablename($_GET["uid"]);
$member = urlencode($_GET["uid"]);
$q = new mysql_squid_builder();
if (!$q->TABLE_EXISTS($tablename)) {
echo "<p class=text-error>No table «{$tablename}» for {$_GET["uid"]}</p>";
return;
}
$sql = "SELECT SUM(hits) as hits,SUM(size) as size,familysite FROM `{$tablename}` GROUP BY\n\tcategory,familysite HAVING category='{$_GET["category"]}' ORDER BY size DESC,hits DESC LIMIT 0,100";
if ($_GET["category"] == null) {
$sql = "SELECT SUM(hits) as hits,SUM(size) as size,familysite FROM `{$tablename}` GROUP BY\n\tcategory,familysite HAVING category IS NULL ORDER BY size DESC,hits DESC LIMIT 0,100";
}
$results = $q->QUERY_SQL($sql);
$_GET["uid"] = urlencode($_GET["uid"]);
if (!$q->ok) {
echo "<p class=text-error>{$q->mysql_error}<br>{$sql}</p>";
return;
}
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
$size = FormatBytes($ligne["size"] / 1024);
$hits = FormatNumber($ligne["hits"]);
$familysite = $ligne["familysite"];
$fsite = urlencode($familysite);
$jslink = "Loadjs('miniadm.webstats.ByMember.website.php?familysite={$fsite}&member-value={$member}&by=uid')";
$link = $boot->trswitch($jslink);
$tr[] = "\n\t<tr>\n\t<td {$link}><i class='icon-globe'></i> {$familysite}</a></td>\n\t<td {$link}><i class='icon-info-sign'></i> {$size}</td>\n\t<td {$link}><i class='icon-info-sign'></i> {$hits}</td>\n\t</tr>";
}
echo $tpl->_ENGINE_parse_body("\n\t\n\t\t\t<table class='table table-bordered table-hover'>\n\t\n\t\t\t<thead>\n\t\t\t\t<tr>\n\t\t\t\t\t<th>{websites}</th>\n\t\t\t\t\t<th>{size}</th>\n\t\t\t\t\t<th>{hits}</th>\n\t\t\t\t</tr>\n\t\t\t</thead>\n\t\t\t <tbody>\n\t\t\t") . @implode("", $tr) . "</tbody></table>";
}
