function HyperCacheLogs() { HyperCacheSizeLog("/usr/share/squid3/HyperCacheSizeLog.db"); $q = new mysql_squid_builder(); $unix = new unix(); $files = $unix->DirFiles("/usr/share/squid3", "[0-9]+_HyperCacheSizeLog\\.db"); while (list($num, $filename) = each($files)) { $filepath = "/usr/share/squid3/{$filename}"; if (!is_file($filepath)) { continue; } $time = $q->TIME_FROM_DAY_TABLE($filename); echo "{$filepath} {$time} " . date("Y-m-d") . "\n"; } }
function CONDENSED_perform($sourcetable) { $q = new mysql_squid_builder(); $xtime = $q->TIME_FROM_DAY_TABLE($sourcetable); $zDate = date("Y-m-d", $xtime); echo "{$sourcetable} = {$zDate}\n"; $sql = "SELECT SUM(size) as size,SUM(hits) AS `hits`, familysite FROM {$sourcetable} GROUP BY familysite"; $results = $q->QUERY_SQL($sql); $prefix = "INSERT IGNORE INTO FamilyCondensed (zMD5,zDate,size,hits,familysite) VALUES "; $f = array(); while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $md5 = md5(serialize($ligne) . $zDate); $familysite = mysql_escape_string2($ligne["familysite"]); $size = $ligne["size"]; $hits = $ligne["hits"]; $f[] = "('{$md5}','{$zDate}','{$size}','{$hits}','{$familysite}')"; if (count($f) > 500) { $q->QUERY_SQL($prefix . @implode(",", $f)); if (!$q->ok) { return false; } $f = array(); } } if (count($f) > 0) { $q->QUERY_SQL($prefix . @implode(",", $f)); if (!$q->ok) { return false; } $f = array(); } return true; }
function access_dbmonth() { $q = new mysql_squid_builder(); $array = $q->LIST_TABLES_ACCESSDB_DAY(); $current = date("Ymd") . "_daccess"; while (list($tablename, $none) = each($array)) { if ($tablename == $current) { continue; } $time = $q->TIME_FROM_DAY_TABLE($tablename); $day = date("Y-m-d", $time); $month = date("Ym", $time); echo "{$tablename} -{$day} -{$month}\n"; $monthtable = "{$month}_maccess"; //zDate | familysite | category | hits | size | hour | uid | ipaddr | MAC if (_access_dbmonth($tablename, $monthtable)) { $q->QUERY_SQL("DROP TABLE {$tablename}"); } } }
function section_blocked_form() { $boot = new boostrap_form(); $q = new mysql_squid_builder(); $ARRAYTABLES = $q->LIST_TABLES_BLOCKED(); while (list($tablename, $none) = each($ARRAYTABLES)) { $time = $q->TIME_FROM_DAY_TABLE($tablename); $days[$time] = time_to_date($time); } $BLOCKED_CATEGORY_LIMITS[50] = 50; $BLOCKED_CATEGORY_LIMITS[250] = 250; $BLOCKED_CATEGORY_LIMITS[500] = 250; $BLOCKED_CATEGORY_LIMITS[1000] = 1000; $BLOCKED_CATEGORY_LIMITS[2000] = 2000; krsort($days); $boot->set_list("QUERY_BLOCKED_DATE", "{date}", $days, $_SESSION["QUERY_BLOCKED_DATE"]); $boot->set_field("QUERY_BLOCKED_UID", "{member}", $_SESSION["QUERY_BLOCKED_UID"]); $boot->set_field("QUERY_BLOCKED_CATEGORY", "{category}", $_SESSION["QUERY_BLOCKED_CATEGORY"]); $boot->set_list("BLOCKED_CATEGORY_LIMIT", "{rows}", $BLOCKED_CATEGORY_LIMITS, $_SESSION["BLOCKED_CATEGORY_LIMIT"]); $boot->set_button("{search}"); $boot->set_CloseYahoo("YahooWin2"); $boot->set_formdescription("{advanced_search_explain}"); $boot->set_RefreshSearchs(); echo $boot->Compile(); }
function where_popup() { $page = CurrentPageName(); $tpl = new templates(); $field = $_GET["field"]; $value = $_GET["value"]; $month_table = "quotamonth_" . date("Ym"); $month_text = date("{F}"); $q = new mysql_squid_builder(); if (isset($_GET["table"])) { $xtime = $q->TIME_FROM_DAY_TABLE($_GET["table"]); $month_table = "quotamonth_" . date("Ym", $xtime); $month_text = date("{F}", $xtime); } if ($q->COUNT_ROWS($month_table) == 0) { $month_text = date("{F}", strtotime('first day of previous month')); $month_table = "quotamonth_" . date("Ym", strtotime('first day of previous month')); } $title = $tpl->_ENGINE_parse_body("{where} ? »»{{$field}}::{$value} {$title_add}"); $t = time(); $sitename = $tpl->_ENGINE_parse_body("{sitename}"); $category = $tpl->_ENGINE_parse_body("{category}"); $hits = $tpl->_ENGINE_parse_body("{hits}"); $size = $tpl->_ENGINE_parse_body("{size}"); $sitename = $tpl->_ENGINE_parse_body("{sitename}"); $ipaddr = $tpl->_ENGINE_parse_body("{ipaddr}"); $members = $tpl->_ENGINE_parse_body("{members}"); $hostname = $tpl->_ENGINE_parse_body("{hostname}"); $mac = $tpl->_ENGINE_parse_body("{MAC}"); $week = $tpl->_ENGINE_parse_body("{week}"); $month = $tpl->_ENGINE_parse_body("{month}"); $TB_WIDTH = 550; $t = time(); $buttons = "\n\tbuttons : [\n\t{name: '<b>{$day}</b>', bclass: 'Calendar', onpress : ChangeDay{$t}},\n\t{name: '<b>{$week}</b>', bclass: 'Calendar', onpress : ChangeWeek{$t}},\n\t{name: '<b>{$month}</b>', bclass: 'Calendar', onpress : ChangeMonth{$t}},\n\t\n\t\t],"; $buttons = null; $html = "\n\t<table class='{$t}' style='display: none' id='{$t}' style='width:99%'></table>\n\n<script>\n\n\$(document).ready(function(){\n\$('#{$t}').flexigrid({\n\turl: '{$page}?where-content=yes&field={$field}&value=" . urlencode($value) . "&table={$month_table}',\n\tdataType: 'json',\n\tcolModel : [\n\t\t{display: '{$sitename}', name : 'familysite', width : 181, sortable : true, align: 'left'},\n\t\t{display: '{$size}', name : 'size', width : 109, sortable : true, align: 'left'},\n\n\t\t\n\t\t\n\t],{$buttons}\n\tsearchitems : [\n\t\t{display: '{$sitename}', name : 'familysite'},\n\t\t\n\t\t],\n\tsortname: 'size',\n\tsortorder: 'desc',\n\tusepager: true,\n\ttitle: '{$title}',\n\tuseRp: true,\n\trp: 15,\n\tshowTableToggleBtn: false,\n\twidth: 793,\n\theight: 450,\n\tsingleSelect: true\n\t\n\t});\n});\n</script>"; echo $tpl->_ENGINE_parse_body($html); }