本文整理汇总了PHP中mysql_squid_builder::LIST_TABLES_CATEGORIES方法的典型用法代码示例。如果您正苦于以下问题：PHP mysql_squid_builder::LIST_TABLES_CATEGORIES方法的具体用法？PHP mysql_squid_builder::LIST_TABLES_CATEGORIES怎么用？PHP mysql_squid_builder::LIST_TABLES_CATEGORIES使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类mysql_squid_builder的用法示例。
在下文中一共展示了mysql_squid_builder::LIST_TABLES_CATEGORIES方法的14个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: export_allcategories
function export_allcategories()
{
$q = new mysql_squid_builder();
$tables = $q->LIST_TABLES_CATEGORIES();
while (list($table, $none) = each($tables)) {
export_category($table);
}
}示例2: page
function page()
{
$sock = new sockets();
$EnableRemoteStatisticsAppliance = $sock->GET_INFO("EnableRemoteStatisticsAppliance");
$MalwarePatrolDatabasesCount = $sock->getFrameWork("cmd.php?MalwarePatrolDatabasesCount=yes");
if (GET_CACHED(__FILE__, __FUNCTION__, __FUNCTION__)) {
return;
}
$page = CurrentPageName();
$tpl = new templates();
$q = new mysql_squid_builder();
$users = new usersMenus();
$websitesnums = $q->COUNT_ROWS("visited_sites");
$websitesnums = numberFormat($websitesnums, 0, "", " ");
$sql = "DELETE FROM categorize WHERE LENGTH(pattern)=0";
$q->QUERY_SQL($sql);
$export = $q->COUNT_ROWS("categorize");
$export = numberFormat($export, 0, "", " ");
$categories = $q->COUNT_CATEGORIES();
$categories = numberFormat($categories, 0, "", " ");
$tablescat = $q->LIST_TABLES_CATEGORIES();
$tablescatNUM = numberFormat(count($tablescat), 0, "", " ");
$q = new mysql_squid_builder();
$requests = $q->EVENTS_SUM();
$requests = numberFormat($requests, 0, "", " ");
$PhishingURIS = $q->COUNT_ROWS("uris_phishing");
$PhishingURIS = numberFormat($PhishingURIS, 0, "", " ");
$MalwaresURIS = $q->COUNT_ROWS("uris_malwares");
$MalwaresURIS = numberFormat($MalwaresURIS, 0, "", " ");
$Computers = $q->COUNT_ROWS("webfilters_nodes");
$Computers = numberFormat($Computers, 0, "", " ");
$DAYSNumbers = $q->COUNT_ROWS("tables_day");
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT SUM(totalsize) as tsize FROM tables_day"));
$totalsize = FormatBytes($ligne["tsize"] / 1024);
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT AVG(cache_perfs) as pourc FROM tables_day"));
$pref = round($ligne["pourc"]);
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT COUNT(sitename) as tcount FROM visited_sites WHERE LENGTH(category)=0"));
$websitesnumsNot = numberFormat($ligne["tcount"], 0, "", " ");
$CachePermformance = $q->CachePerfHour();
if ($CachePermformance > -1) {
$color = "#E01313";
if ($CachePermformance > 20) {
$color = "#6DBB6A";
}
$cachePerfText = "\n\t\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b style='color:{$color}'>{$CachePermformance}%</b> {cache_performance} ({now})</td>\n\t\t</tr>\n\t\t";
}
$mouse = "OnMouseOver=\";this.style.cursor='pointer';\" OnMouseOut=\";this.style.cursor='default';\"";
$submenu = "\t\n\t<tr>\n\t\t<td valign='top' style='font-size:14px'><b>{$totalsize}</b> {downloaded_flow}</td>\n\t</tr>\n\t<tr>\n\t\t<td valign='top' style='font-size:14px'><b>{$pref}%</b> {cache_performance}</td>\n\t</tr>\n\t";
$main_table = "\n\t<table style='width:98%' class=form>\n\t<tr><td style='font-size:16px'>{statistics}::{status}</td></tr>\n\t{$cachePerfText}\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;><b>{$DAYSNumbers}</b> {daysOfStatistics}</td>\n\t</tr>\n\t<tr>\n\t\t<td valign='top' style='font-size:14px'><b>{$requests}</b> {requests}</td>\n\t</tr>\n\t<tr>\n\t\t<td valign='top' style='font-size:14px'><b>{$Computers}</b> {computers}</td>\n\t</tr>\t\t\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b>{$websitesnums}</b> {visited_websites}</td>\n\t</tr>\t\n\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b>{$categories}</b> {websites_categorized}</td>\n\t</tr>\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b>{$PhishingURIS}</b> {phishing_uris}</td>\n\t</tr>\t\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b>{$MalwaresURIS}</b> {viruses_uris}</td>\n\t</tr>\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b>{$MalwarePatrolDatabasesCount}</b> Malware Patrol</td>\n\t</tr>\t\t\t\t\t\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b>{$websitesnumsNot}</b> {not_categorized}</td>\n\t</tr>\t\t\t\t\n\t<tr>\n\t\t<td valign='top' style='font-size:14px;'><b>{$tablescatNUM}</b> {categories}</td>\n\t</tr>\n\t</table>\t\n";
$main_table = $tpl->_ENGINE_parse_body($main_table);
SET_CACHED(__FILE__, __FUNCTION__, __FUNCTION__, $main_table);
echo $main_table;
}示例3: subtitle_categories
function subtitle_categories(){
if(CACHE_SESSION_GET(__FUNCTION__, __FILE__,15)){return;}
$tpl=new templates();
$q=new mysql_squid_builder();
$categories=$q->COUNT_CATEGORIES();
$categories=numberFormat($categories,0,""," ");
$tablescat=$q->LIST_TABLES_CATEGORIES();
$tablescatNUM=numberFormat(count($tablescat),0,""," ");
$html="<div style='font-size:16px'><b>$categories</b> {websites_categorized} | <b>$tablescatNUM</b> {categories}</div>";
CACHE_SESSION_SET(__FUNCTION__, __FILE__, $tpl->_ENGINE_parse_body($html));
}示例4: squid_status_stats
function squid_status_stats()
{
$off = "<script>UnlockPage();</script>";
if (!$GLOBALS["AS_ROOT"]) {
$cachefile = "/usr/share/artica-postfix/ressources/logs/web/traffic.statistics.html";
if (is_file($cachefile)) {
$tpl = new templates();
$cacheContent = @file_get_contents($cachefile);
if (strlen($cacheContent) > 20) {
echo $tpl->_ENGINE_parse_body(@file_get_contents($cachefile)) . $off;
return;
}
}
}
if (CACHE_SESSION_GET(__FUNCTION__, __FILE__)) {
return;
}
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " Loading classes<br>\n";
}
$sock = new sockets();
$users = new usersMenus();
$EnableRemoteStatisticsAppliance = $sock->GET_INFO("EnableRemoteStatisticsAppliance");
$SquidActHasReverse = $sock->GET_INFO("SquidActHasReverse");
if (!is_numeric($SquidActHasReverse)) {
$SquidActHasReverse = 0;
}
if ($EnableRemoteStatisticsAppliance == 1) {
return;
}
$DisableArticaProxyStatistics = $sock->GET_INFO("DisableArticaProxyStatistics");
if (!is_numeric($DisableArticaProxyStatistics)) {
$DisableArticaProxyStatistics = 0;
}
$MalwarePatrolDatabasesCount = $sock->getFrameWork("cmd.php?MalwarePatrolDatabasesCount=yes");
$mouse = "OnMouseOver=\";this.style.cursor='pointer';\" OnMouseOut=\";this.style.cursor='default';\"";
$EnableMacAddressFilter = $sock->GET_INFO("EnableMacAddressFilter");
if (!is_numeric($EnableMacAddressFilter)) {
$EnableMacAddressFilter = 1;
}
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " Loading mysql_storelogs()<br>\n";
}
$syslogs = new mysql_storelogs();
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " Count accesslogs<br>\n";
}
$SyslogsFiles = $syslogs->COUNT_ROWS("accesslogs");
$TR_ACCESSLOG = "\n\t<tr>\n\t<td width=1%><img src='img/arrow-right-16.png'></td>\n\t<td valign='top' {$mouse} style='font-size:12px;text-decoration:underline' \n\t\tOnClick=\"javascript:Loadjs('squid.accesses.rotate.php')\"><b><span style='font-size:12px'>{$SyslogsFiles}</span></b><span style='font-size:12px'> {access_logs}</td>\n\t</tr>";
$page = CurrentPageName();
$tpl = new templates();
$q = new mysql_squid_builder();
if ($users->PROXYTINY_APPLIANCE) {
$DisableArticaProxyStatistics = 1;
}
if ($DisableArticaProxyStatistics == 0) {
$websitesnums = $q->COUNT_ROWS("visited_sites");
$websitesnums = numberFormat($websitesnums, 0, "", " ");
$sql = "DELETE FROM categorize WHERE LENGTH(pattern)=0";
$q->QUERY_SQL($sql);
$export = $q->COUNT_ROWS("categorize");
$export = numberFormat($export, 0, "", " ");
}
$catz = new mysql_catz();
$categories = $catz->COUNT_CATEGORIES();
$categories = numberFormat($categories, 0, "", " ");
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " categories= {$categories}<br>\n";
}
$YourItems = $q->COUNT_CATEGORIES();
$YourItems = numberFormat($YourItems, 0, "", " ");
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " LIST_TABLES_CATEGORIES()<br>\n";
}
$tablescat = $q->LIST_TABLES_CATEGORIES();
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " tablescat={$tablescat}<br>\n";
}
$tablescatNUM = numberFormat(count($tablescat), 0, "", " ");
if ($DisableArticaProxyStatistics == 0) {
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " EVENTS_SUM()<br>\n";
}
$requests = $q->EVENTS_SUM();
$requests = numberFormat($requests, 0, "", " ");
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " requests = {$requests}<br>\n";
}
}
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " no_license -> translate<br>\n";
}
$nolicense = $tpl->_ENGINE_parse_body("{no_license}");
$PhishingURIS = $q->COUNT_ROWS("categoryuris_phishing");
$PhishingURIS = numberFormat($PhishingURIS, 0, "", " ");
if ($GLOBALS["VERBOSE"]) {
echo __LINE__ . " >COUNT_ROWS('categoryuris_malware')<br>\n";
}
$MalwaresURIS = $q->COUNT_ROWS("categoryuris_malware");
$MalwaresURIS = numberFormat($MalwaresURIS, 0, "", " ");
//.........这里部分代码省略.........
示例5: rules_toolbox_left
function rules_toolbox_left()
{
if (!isset($_GET["t"])) {
$_GET["t"] = time();
}
$updateutility = null;
$q = new mysql_squid_builder();
$page = CurrentPageName();
$tpl = new templates();
$users = new usersMenus();
$mouse = "OnMouseOver=\";this.style.cursor='pointer';\" OnMouseOut=\";this.style.cursor='default';\"";
$t = $_GET["t"];
if (!is_numeric($t)) {
$t = time();
}
$Computers = $q->COUNT_ROWS("webfilters_nodes");
if (!$q->TABLE_EXISTS("webfilter_certs")) {
$q->CheckTables();
}
if ($q->COUNT_ROWS("webfilter_certs") == 0) {
$q->fill_webfilter_certs();
}
$Computers = numberFormat($Computers, 0, "", " ");
$sock = new sockets();
$EnableUfdbGuard = intval($sock->EnableUfdbGuard());
$tablescat = $q->LIST_TABLES_CATEGORIES();
$CountDeCategories = numberFormat(count($tablescat), 0, "", " ");
$categoryuris_malware = numberFormat($q->COUNT_ROWS("categoryuris_malware"), 0, "", " ");
$disable_service = $tpl->_ENGINE_parse_body("{disable_service}");
$datasUFDB = unserialize(base64_decode($sock->GET_INFO("ufdbguardConfig")));
if (!is_numeric($datasUFDB["DebugAll"])) {
$datasUFDB["DebugAll"] = 0;
}
$update_parameters = $tpl->_ENGINE_parse_body("{update_parameters}");
$EnableWebProxyStatsAppliance = $sock->GET_INFO("EnableWebProxyStatsAppliance");
$SquidDatabasesUtlseEnable = $sock->GET_INFO("SquidDatabasesUtlseEnable");
$UseRemoteUfdbguardService = $sock->GET_INFO("UseRemoteUfdbguardService");
$UFDB = unserialize(base64_decode($sock->GET_INFO("ufdbguardConfig")));
$EnableKerbAuth = $sock->GET_INFO("EnableKerbAuth");
$SquidPerformance = intval($sock->GET_INFO("SquidPerformance"));
if (!is_numeric($UseRemoteUfdbguardService)) {
$UseRemoteUfdbguardService = 0;
}
if (!is_numeric($EnableWebProxyStatsAppliance)) {
$EnableWebProxyStatsAppliance = 0;
}
if (!is_numeric($UseRemoteUfdbguardService)) {
$UseRemoteUfdbguardService = 0;
}
if (!is_numeric($EnableKerbAuth)) {
$EnableKerbAuth = 0;
}
if (!is_numeric($SquidDatabasesUtlseEnable)) {
$SquidDatabasesUtlseEnable = 1;
}
$SquidDatabasesArticaEnable = $sock->GET_INFO("SquidDatabasesArticaEnable");
if (!is_numeric($SquidDatabasesArticaEnable)) {
$SquidDatabasesArticaEnable = 1;
}
if ($EnableWebProxyStatsAppliance == 1) {
$EnableUfdbGuard = 1;
}
if ($UseRemoteUfdbguardService == 0) {
if ($UFDB["UseRemoteUfdbguardService"] == 1) {
$sock->SET_INFO("UseRemoteUfdbguardService", 1);
$UseRemoteUfdbguardService = 1;
}
}
if ($users->WEBSTATS_APPLIANCE) {
$EnableWebProxyStatsAppliance = 1;
}
if (!$users->APP_UFDBGUARD_INSTALLED) {
$EnableUfdbGuard = 0;
}
if ($users->UPDATE_UTILITYV2_INSTALLED) {
$updateutility = "\t<tr>\n\t\t<td valign='middle' width=1%><img src='img/kaspersky-update-32.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t\t<table style='width:100%'>\n\t\t\t<tr>\n\t\t\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t\t\t<td valign='top' {$mouse} style='font-size:13px;text-decoration:underline' \n\t\t\t\tOnClick=\"javascript:Loadjs('ufdbguard.UpdateUtility.php')\" nowrap>UpdateUtility</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</td>\n\t</tr>";
}
$ufdbgverb_icon = "ok24-grey.png";
$ufdbgverb_txt = "OFF";
if ($datasUFDB["DebugAll"] == 1) {
$ufdbgverb_icon = "ok32.png";
$ufdbgverb_txt = "ON";
}
if ($SquidDatabasesUtlseEnable == 1) {
$SquidDatabasesUtlseEnable_P = "<tr>\n\t\t<td valign='middle' width=1%><img src='img/ok32.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t\t<table style='width:100%'>\n\t\t\t<tr>\n\t\t\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t\t\t<td valign='middle' {$mouse} style='font-size:13px;text-decoration:underline' \n\t\t\t\tOnClick=\"javascript:Loadjs('squid.toulouse-university.disable.php')\" nowrap>\n\t\t\t\t<b><span style='font-size:13px;text-decoration:underline'>{toulouse_university} {enabled}</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</td>\n\t\t</tr>\t\t\n\t\t";
} else {
$SquidDatabasesUtlseEnable_P = "<tr>\n\t\t<td valign='middle' width=1%><img src='img/ok32-grey.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t<table style='width:100%'>\n\t\t<tr>\n\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t<td valign='middle' {$mouse} style='font-size:13px;text-decoration:underline'\n\t\tOnClick=\"javascript:Loadjs('squid.toulouse-university.disable.php')\" nowrap>\n\t\t<b><span style='font-size:13px;text-decoration:underline'>{toulouse_university} {disabled}</td>\n\t\t</tr>\n\t\t</table>\n\t\t</td>\n\t\t</tr>\n\t\t";
}
if ($SquidDatabasesArticaEnable == 1) {
$SquidDatabasesArticaEnable_P = "<tr>\n\t\t<td valign='middle' width=1%><img src='img/ok32.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t<table style='width:100%'>\n\t\t<tr>\n\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t<td valign='middle' {$mouse} style='font-size:13px;text-decoration:underline'\n\t\tOnClick=\"javascript:Loadjs('squid.artica-databases.disable.php')\" nowrap>\n\t\t<b><span style='font-size:13px;text-decoration:underline'>{artica_databases} {enabled}</td>\n\t\t</tr>\n\t\t</table>\n\t\t</td>\n\t\t</tr>\n\t\t";
} else {
$SquidDatabasesArticaEnable_P = "<tr>\n\t\t<td valign='middle' width=1%><img src='img/ok32-grey.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t<table style='width:100%'>\n\t\t<tr>\n\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t<td valign='middle' {$mouse} style='font-size:13px;text-decoration:underline'\n\t\tOnClick=\"javascript:Loadjs('squid.artica-databases.disable.php')\" nowrap>\n\t\t<b><span style='font-size:13px;text-decoration:underline'>{artica_databases} {disabled}</td>\n\t\t</tr>\n\t\t</table>\n\t\t</td>\n\t\t</tr>\n\t\t";
}
if (!$users->CORP_LICENSE) {
$SquidDatabasesArticaEnable_P = "<tr>\n\t\t<td valign='middle' width=1%><img src='img/ok32-grey.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t<table style='width:100%'>\n\t\t<tr>\n\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t<td valign='middle' {$mouse} style='font-size:13px;text-decoration:underline'\n\t\tOnClick=\"javascript:blur()\" nowrap>\n\t\t<b><span style='font-size:13px;text-decoration:underline'>{artica_databases} {no_license}</td>\n\t\t</tr>\n\t\t</table>\n\t\t</td>\n\t\t</tr>\n\t\t";
}
if ($EnableUfdbGuard == 1) {
$DisableUfdbGuard = "\n\t\t\t<tr>\n\t\t<td valign='middle' width=1%><img src='img/ok32.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t\t<table style='width:100%'>\n\t\t\t<tr>\n\t\t\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t\t\t<td valign='middle' {$mouse} style='font-size:13px;text-decoration:underline' \n\t\t\t\tOnClick=\"javascript:Loadjs('squid.disableUfdb.php')\" nowrap><b><span style='font-size:13px;text-decoration:underline'>{$disable_service}</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</td>\n\t\t</tr>\n\t\t{$SquidDatabasesArticaEnable_P}\n\t\t{$SquidDatabasesUtlseEnable_P}\t\n\t\t";
}
if ($UseRemoteUfdbguardService == 1) {
//.........这里部分代码省略.........
示例6: PurgeCategoriesDatabase
function PurgeCategoriesDatabase()
{
$q = new mysql_squid_builder();
$categories = $q->LIST_TABLES_CATEGORIES();
$sql = "SELECT category FROM personal_categories";
$results = $q->QUERY_SQL($sql);
while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) {
$tablename = "category_{$ligne["category"]}";
$Perso[$tablename] = true;
}
while (list($table, $ligne) = each($categories)) {
if ($Perso[$table]) {
continue;
}
$q->QUERY_SQL("TRUNCATE TABLE {$table}");
if (!$q->ok) {
echo $q->mysql_error;
}
}
$q = new mysql();
$q->QUERY_SQL("TRUNCATE TABLE updates_categories", "artica_backup");
$sock = new sockets();
$sock->getFrameWork("squid.php?purge-categories=yes");
}示例7: do_export
function do_export()
{
if ($_GET["single-id"] > 0) {
do_export_single_id();
return;
}
$q = new mysql_squid_builder();
$q->BD_CONNECT();
$t = $_GET["t"];
$LIST_TABLES_CATEGORIES = $q->LIST_TABLES_CATEGORIES();
while (list($num, $ligne) = each($LIST_TABLES_CATEGORIES)) {
$squidlogs[$num] = true;
}
$squidlogs["webfilter_rules"] = true;
$squidlogs["webfilter_assoc_groups"] = true;
$squidlogs["webfilter_blks"] = true;
$squidlogs["webfilter_group"] = true;
$squidlogs["webfilter_bannedexts"] = true;
$squidlogs["webfilters_dtimes_blks"] = true;
$squidlogs["webfilter_bannedextsdoms"] = true;
$squidlogs["webfilter_termsg"] = true;
$squidlogs["webfilter_blklnk"] = true;
$squidlogs["webfilter_blkgp"] = true;
$squidlogs["webfilter_blkcnt"] = true;
$artica_backup["personal_categories"] = true;
$dir = dirname(__FILE__) . "/ressources/logs/web/webfiltering.sql";
$final = dirname(__FILE__) . "/ressources/logs/web/webfiltering.export";
$compressed = dirname(__FILE__) . "/ressources/logs/web/webfiltering.gz";
@unlink($dir);
@unlink($final);
@unlink($compressed);
$databases["squidlogs"] = $squidlogs;
$databases["artica_backup"] = $artica_backup;
if (is_file($dir)) {
@unlink($dir);
}
$dump = new phpMyDumper("squidlogs", $q->mysql_connection, "{$dir}", false, $squidlogs);
$dump->doDump();
if (!is_file($dir)) {
$tpl = new templates();
echo $tpl->_ENGINE_parse_body("<div style='font-size:18px;color:#d32d2d;margin-top:15px;margin-bottom:15px'>{failed}</div>");
return;
}
$sock = new sockets();
$DansGuardianDefaultMainRule = $sock->GET_INFO("DansGuardianDefaultMainRule");
$array["SQL"] = @file_get_contents($dir);
$array["DansGuardianDefaultMainRule"] = $DansGuardianDefaultMainRule;
@file_put_contents($final, base64_encode(serialize($array)));
compress($final, $compressed);
$size = @filesize($compressed);
@unlink($dir);
@unlink($final);
echo "\n\t\t<div style='margin-top:15px;margin-bottom:15px;text-align:center'>\t\n\t\t\t<a href=\"ressources/logs/web/webfiltering.gz\" \n\t\t\tstyle='text-decoration:underline;font-size:18px;font-weight:bold'>webfiltering.gz " . FormatBytes($size / 1024) . "</a>\n\t\t</div>\n\t\t\t<script>\n\t\t\tif(document.getElementById('text-{$t}')){\n\t\t\t\tdocument.getElementById('text-{$t}').innerHTML='';\n\t\t\t\n\t\t\t}\n\t\t\t\t\n\t\t\t</script>\n\t\t\t\n\t";
}示例8: dansguardian_status
function dansguardian_status($asroot = false)
{
$page = CurrentPageName();
$users = new usersMenus();
$tpl = new templates();
$q = new mysql_squid_builder();
$categories = $q->LIST_TABLES_CATEGORIES();
$sock = new sockets();
$squid = new squidbee();
$SquidGuardIPWeb = trim($sock->GET_INFO("SquidGuardIPWeb"));
$SquidGuardServerName = $sock->GET_INFO("SquidGuardServerName");
$SquidDisableAllFilters = $sock->GET_INFO("SquidDisableAllFilters");
$SquideCapAVEnabled = $sock->GET_INFO("SquideCapAVEnabled");
$kavicapserverEnabled = $sock->GET_INFO("kavicapserverEnabled");
$EnableSquidRemoteMySQL = $sock->GET_INFO("EnableSquidRemoteMySQL");
if (!is_numeric($EnableSquidRemoteMySQL)) {
$EnableSquidRemoteMySQL = 0;
}
$EnableSplashScreen = $sock->GET_INFO("EnableArticaHotSpot");
$PdnsHotSpot = $sock->GET_INFO("EnableSplashScreen");
$EnableMalwarePatrol = $sock->GET_INFO("EnableMalwarePatrol");
$AsSquidLoadBalancer = $sock->GET_INFO("AsSquidLoadBalancer");
$SquidActHasReverse = $sock->GET_INFO("SquidActHasReverse");
if ($squid->isNGnx()) {
$SquidActHasReverse = 0;
}
$UfdbEnabledCentral = $sock->GET_INFO('UfdbEnabledCentral');
$AntivirusEnabledCentral = $sock->GET_INFO('AntivirusEnabledCentral');
$EnableKerbAuthCentral = $sock->GET_INFO('EnableKerbAuthCentral');
$EnableUfdbGuard = intval($sock->EnableUfdbGuard());
$DnsFilterCentral = $sock->GET_INFO('DnsFilterCentral');
$SquidBubbleMode = $sock->GET_INFO('SquidBubbleMode');
$EnableCNTLM = $sock->GET_INFO("EnableCNTLM");
$EnableRDPProxy = $sock->GET_INFO("EnableRDPProxy");
$EnableLocalDNSMASQ = $sock->GET_INFO("EnableLocalDNSMASQ");
$WizardStatsApplianceDisconnected = intval($sock->GET_INFO("WizardStatsApplianceDisconnected"));
$SquidNoAccessLogs = intval($sock->GET_INFO("SquidNoAccessLogs"));
$EnableFTPProxy = $sock->GET_INFO('EnableFTPProxy');
$MonitConfig = unserialize(base64_decode($sock->GET_INFO("SquidWatchdogMonitConfig")));
$Watchdog = $MonitConfig["watchdog"];
$UnlockWebStats = $sock->GET_INFO("UnlockWebStats");
if (!is_numeric($UnlockWebStats)) {
$UnlockWebStats = 0;
}
if ($UnlockWebStats == 1) {
$EnableRemoteStatisticsAppliance = 0;
}
$EnableHaarp = $sock->GET_INFO("EnableHaarp");
if (!is_numeric($EnableHaarp)) {
$EnableHaarp = 0;
}
// APP_HAARP $EnableHaarp
if (!is_numeric($EnableRDPProxy)) {
$EnableRDPProxy = 0;
}
if (!is_numeric($EnableFTPProxy)) {
$EnableFTPProxy = 0;
}
$PDSNInUfdb = $sock->GET_INFO("PDSNInUfdb");
$EnableKerbAuth = $sock->GET_INFO("EnableKerbAuth");
if (!is_numeric($EnableKerbAuth)) {
$EnableKerbAuth = 0;
}
if (!is_numeric($EnableUfdbGuard)) {
$EnableUfdbGuard = 0;
}
if (!is_numeric($SquideCapAVEnabled)) {
$SquideCapAVEnabled = 0;
}
if (!is_numeric($EnableMalwarePatrol)) {
$EnableMalwarePatrol = 0;
}
if (!is_numeric($SquidDisableAllFilters)) {
$SquidDisableAllFilters = 0;
}
if (!is_numeric($EnableSplashScreen)) {
$EnableSplashScreen = 0;
}
if (!is_numeric($PdnsHotSpot)) {
$PdnsHotSpot = 0;
}
if (!is_numeric($AsSquidLoadBalancer)) {
$AsSquidLoadBalancer = 0;
}
if (!is_numeric($SquidActHasReverse)) {
$SquidActHasReverse = 0;
}
if (!is_numeric($kavicapserverEnabled)) {
$kavicapserverEnabled = 0;
}
if (!is_numeric($SquidBubbleMode)) {
$SquidBubbleMode = 0;
}
if (!is_numeric($EnableCNTLM)) {
$EnableCNTLM = 0;
}
if (!is_numeric($Watchdog)) {
$Watchdog = 1;
}
$t = 1;
//.........这里部分代码省略.........
示例9: Export
function Export($asPid = false)
{
return;
$unix = new unix();
$restartProcess = false;
$nohup = $unix->find_program("nohup");
$php5 = $unix->LOCATE_PHP5_BIN();
$cachetime = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time";
if ($GLOBALS["VERBOSE"]) {
echo "CacheTime: {$cachetime}\n";
}
$restart_cmd = trim("{$nohup} {$php5} " . __FILE__ . " --export >/dev/null 2>&1 &");
$sock = new sockets();
shell_exec(trim("{$nohup} {$php5} " . __FILE__ . " --export-not-categorized >/dev/null 2>&1 &"));
if ($asPid) {
$pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid";
$unix = new unix();
$pid = @file_get_contents($pidfile);
if ($unix->process_exists($pid, basename(__FILE__))) {
WriteMyLogs("Already executed PID:{$pid}, die()", __FUNCTION__, __FILE__, __LINE__);
die;
}
@file_put_contents($pidfile, getmypid());
}
$uuid = $unix->GetUniqueID();
if ($uuid == null) {
if ($GLOBALS["VERBOSE"]) {
echo "No system ID !\n";
}
return;
}
$q = new mysql_squid_builder();
$tables = $q->LIST_TABLES_CATEGORIES();
$c = 0;
while (list($table, $www) = each($tables)) {
$limit = null;
$limitupate = null;
if (!preg_match("#category_(.+?)\$#", $table)) {
continue;
}
if (!$q->TABLE_EXISTS($table)) {
continue;
}
$sql = "SELECT COUNT(zmd5) as tcount FROM {$table} WHERE sended=0 and enabled=1";
$q->CreateCategoryTable(null, $table);
$ligne = mysql_fetch_array($q->QUERY_SQL($sql));
if (!$q->ok) {
writelogs("{$table} {$q->mysql_error}", __FUNCTION__, __FILE__, __LINE__);
return;
}
$prefix = "INSERT IGNORE INTO categorize (zmd5 ,pattern,zDate,uuid,category) VALUES";
if ($ligne["tcount"] > 0) {
writelogs("{$table} {$ligne["tcount"]} items to export", __FUNCTION__, __FILE__, __LINE__);
if ($ligne["tcount"] > 5000) {
$limit = "LIMIT 0,5000";
$limitupate = "LIMIT 5000";
}
$results = $q->QUERY_SQL("SELECT * FROM {$table} WHERE sended=0 AND enabled=1 {$limit}");
while ($ligne2 = mysql_fetch_array($results, MYSQL_ASSOC)) {
$md5 = md5("{$ligne2["category"]}{$ligne2["pattern"]}");
$f[] = "('{$md5}','{$ligne2["pattern"]}','{$ligne2["zDate"]}','{$uuid}','{$ligne2["category"]}')";
$c++;
if (count($f) > 1000) {
$q->QUERY_SQL($prefix . @implode(",", $f));
if (!$q->ok) {
echo $q->mysql_error . "\n";
return;
}
$f = array();
}
}
$q->QUERY_SQL("UPDATE {$table} SET sended=1 WHERE sended=0 {$limitupate}");
}
}
if (count($f) > 0) {
$q->QUERY_SQL($prefix . @implode(",", $f));
$f = array();
}
$ALLCOUNT = $q->COUNT_ROWS("categorize");
if ($GLOBALS["VERBOSE"]) {
echo "Total row in categorize table: {$ALLCOUNT}\n";
}
if ($ALLCOUNT > 2000) {
$restartProcess = true;
}
$sql = "SELECT * FROM categorize ORDER BY zDate DESC LIMIT 0,2000";
if ($GLOBALS["VERBOSE"]) {
echo "Execute query\n";
}
$results = $q->QUERY_SQL($sql, "artica_backup");
if (!$q->ok) {
echo $q->mysql_error . "\n{$sql}\n";
return;
}
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
if ($ligne["category"] == null) {
continue;
}
if ($ligne["pattern"] == null) {
continue;
//.........这里部分代码省略.........
示例10: RepairCategoriesBases
function RepairCategoriesBases()
{
$q = new mysql_squid_builder();
$tables_cats = $q->LIST_TABLES_CATEGORIES();
$unix = new unix();
$pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid";
$timeF = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time";
$pid = @file_get_contents($pidfile);
if ($pid < 100) {
$pid = null;
}
$unix = new unix();
if ($unix->process_exists($pid)) {
ufdbguard_admin_events("Fatal Already executed pid {$pid}", __FUNCTION__, __FILE__, __LINE__, "stats");
echo "Already executed pid {$pid}\n";
return;
}
if ($unix->file_time_min($timeF) < 10) {
$time = $unix->file_time_min($timeF);
ufdbguard_admin_events("Need 10Mn, currently {$time}Mn", __FUNCTION__, __FILE__, __LINE__, "stats");
@unlink($timeF);
@file_put_contents($timeF, time());
return;
}
while (list($num, $tablename) = each($tables_cats)) {
$newcat = $q->tablename_tocat($tablename);
if ($newcat == null) {
continue;
}
if ($tablename == "category_english_malware") {
continue;
}
if ($tablename == "category_spywmare") {
$newcat = "spyware";
}
if ($tablename == "category_forum") {
$newcat = "forums";
}
if ($tablename == "category_housing_reale_state_") {
$newcat = "housing/reale_state_office";
}
if ($tablename == "category_radio") {
$newcat = "webradio";
}
if ($tablename == "category_radiotv") {
$newcat = "webradio";
}
if ($tablename == "category_shopping") {
continue;
}
echo "{$tablename} -> {$newcat}\n";
ufdbguard_admin_events("define {$tablename} to {$newcat} done", __FUNCTION__, __FILE__, __LINE__, "maintenance");
$q->QUERY_SQL("UPDATE `{$tablename}` SET category='{$newcat}' WHERE category='{$ligne["category"]}'");
}
}示例11: myhome2
function myhome2(){
$page=CurrentPageName();
$q=new mysql_squid_builder();
$tpl=new templates();
$categories=$q->COUNT_CATEGORIES();
$categories=numberFormat($categories,0,""," ");
$tablescat=$q->LIST_TABLES_CATEGORIES();
$tablescatNUM=numberFormat(count($tablescat),0,""," ");
$PhishingURIS=$q->COUNT_ROWS("uris_phishing");
$PhishingURIS=numberFormat($PhishingURIS,0,""," ");
$MalwaresURIS=$q->COUNT_ROWS("uris_malwares");
$MalwaresURIS=numberFormat($MalwaresURIS,0,""," ");
$sql="SELECT COUNT(category) as tcount FROM usersisp_catztables WHERE userid='{$_SESSION["uid"]}' AND blck=0";
$ligne=@mysql_fetch_array($q->QUERY_SQL($sql));
$PersonalBlacklists=$ligne["tcount"];
$sql="SELECT COUNT(category) as tcount FROM usersisp_catztables WHERE userid='{$_SESSION["uid"]}' AND blck=1";
$ligne=@mysql_fetch_array($q->QUERY_SQL($sql));
$PersonalWhitelists=$ligne["tcount"];
$html="
<table style='width:99%' class=form>
<tbody>
<tr>
<td width=1% valign='top'><img src='img/webfilter-64.png'></td>
<td width=99% valign='top'>
<table style='width:100%'>
<tbody>
<tr>
<td colspan=2><div style='font-size:16px'>{webfiltering_service}</div></td>
</tr>
<tr>
<td valign='top' $mouse style='font-size:14px;text-decoration:underline' OnClick=\"blur()\"><b>$tablescatNUM</b> {categories}</td>
</tr>
<tr>
<td valign='top' $mouse style='font-size:14px;text-decoration:underline' OnClick=\"blur()\"><b>$categories</b> {websites_categorized}</td>
</tr>
<tr>
<td valign='top' $mouse style='font-size:14px;text-decoration:underline' OnClick=\"blur()\"><b>$PhishingURIS</b> {phishing_uris}</td>
</tr>
<tr>
<td valign='top' $mouse style='font-size:14px;text-decoration:underline' OnClick=\"blur()\"><b>$MalwaresURIS</b> {viruses_uris}</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<br>
<table style='width:99%' class=form>
<tbody>
<tr>
<td width=1% valign='top'><img src='img/web-ssl-64.png'></td>
<td width=99% valign='top'>
<table style='width:100%'>
<tbody>
<tr>
<td colspan=2><div style='font-size:16px'>{your_settings}</div></td>
</tr>
<tr>
<td valign='top' $mouse style='font-size:14px;text-decoration:underline' OnClick=\"javascript:QuickLinkSystems('section_webfiltering_dansguardian')\"><b>$PersonalBlacklists</b> {blacklist_categories}</td>
</tr>
<tr>
<td valign='top' $mouse style='font-size:14px;text-decoration:underline' OnClick=\"javascript:QuickLinkSystems('section_webfiltering_dansguardian')\"><b>$PersonalWhitelists</b> {whitelist_categories}</td>
</tr>
</tbody>
</table>
</td>
</td>
</tr>
</tbody>
</table>
<script>
LoadAjax('myhome3','$page?myhome3=yes');
</script>
";
echo $tpl->_ENGINE_parse_body($html);
}示例12: export_all_tables
function export_all_tables()
{
$q = new mysql_squid_builder();
$tables = $q->LIST_TABLES_CATEGORIES();
while (list($table, $row) = each($tables)) {
export_table($table);
}
}示例13: UFDBGUARD_COMPILE_ALL_CATEGORIES
function UFDBGUARD_COMPILE_ALL_CATEGORIES()
{
$sock = new sockets();
if (system_is_overloaded(basename(__FILE__))) {
squid_admin_mysql(1, "Overloaded system: {$GLOBALS["SYSTEM_INTERNAL_LOAD"]}, aborting recompiling personal categories", null, __FILE__, __LINE__);
die;
}
$EnableRemoteStatisticsAppliance = $sock->GET_INFO("EnableRemoteStatisticsAppliance");
if (!is_numeric($EnableRemoteStatisticsAppliance)) {
$EnableRemoteStatisticsAppliance = 0;
}
$UseRemoteUfdbguardService = $sock->GET_INFO("UseRemoteUfdbguardService");
if (!is_numeric($UseRemoteUfdbguardService)) {
$UseRemoteUfdbguardService = 0;
}
if ($EnableRemoteStatisticsAppliance == 1) {
return;
}
if ($UseRemoteUfdbguardService == 1) {
return;
}
if ($EnableRemoteStatisticsAppliance == 1) {
return;
}
$unix = new unix();
$pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid";
$pid = @file_get_contents($pidfile);
if ($unix->process_exists($pid, basename(__FILE__))) {
return;
}
@file_put_contents($pidfile, getmypid());
$sock = new sockets();
$EnableRemoteStatisticsAppliance = $sock->GET_INFO("EnableRemoteStatisticsAppliance");
if (!is_numeric($EnableRemoteStatisticsAppliance)) {
$EnableRemoteStatisticsAppliance = 0;
}
if ($EnableRemoteStatisticsAppliance == 1) {
UFDBGUARD_DOWNLOAD_ALL_CATEGORIES();
return;
}
$EnableWebProxyStatsAppliance = $sock->GET_INFO("EnableWebProxyStatsAppliance");
if (!is_numeric($EnableWebProxyStatsAppliance)) {
$EnableWebProxyStatsAppliance = 0;
}
$q = new mysql_squid_builder();
$t = time();
$cats = $q->LIST_TABLES_CATEGORIES();
$ufdb = new compile_ufdbguard();
while (list($table, $line) = each($cats)) {
if (preg_match("#categoryuris_#", $table)) {
continue;
}
$category = $q->tablename_tocat($table);
if ($category == null) {
squid_admin_mysql(1, "Compilation failed for table {$table}, unable to determine category", null, __FILE__, __LINE__);
continue;
}
$ufdb->compile_category($category);
}
$ttook = $unix->distanceOfTimeInWords($t, time(), true);
squid_admin_mysql(2, "All personal categories are compiled ({$ttook})", @implode("\n", $cats), __FILE__, __LINE__, "global-compile");
if ($EnableWebProxyStatsAppliance == 1) {
CompressCategories();
return;
}
}示例14: rules_toolbox_left
function rules_toolbox_left()
{
if (!isset($_GET["t"])) {
$_GET["t"] = time();
}
$cachefile = "/usr/share/artica-postfix/ressources/logs/web/ufdb.rules_toolbox_left.html";
if (isset($_GET["RemoveCache"])) {
@unlink($cachefile);
}
/* ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
ini_set('error_prepend_string',"<p class=text-error>");
ini_set('error_append_string',"</p>");
*/
if (!$GLOBALS["AS_ROOT"]) {
if (is_file($cachefile)) {
$tpl = new templates();
echo $tpl->_ENGINE_parse_body(@file_get_contents($cachefile));
return;
}
} else {
include_once dirname(__FILE__) . '/framework/class.unix.inc';
include_once dirname(__FILE__) . '/framework/frame.class.inc';
$unix = new unix();
if ($unix->file_time_min($cachefile) < 5) {
return;
}
}
$updateutility = null;
$q = new mysql_squid_builder();
$page = CurrentPageName();
$tpl = new templates();
$users = new usersMenus();
$mouse = "OnMouseOver=\";this.style.cursor='pointer';\" OnMouseOut=\";this.style.cursor='default';\"";
$t = $_GET["t"];
if (!is_numeric($t)) {
$t = time();
}
$Computers = $q->COUNT_ROWS("webfilters_nodes");
if (!$q->TABLE_EXISTS("webfilter_certs")) {
$q->CheckTables();
}
if ($q->COUNT_ROWS("webfilter_certs") == 0) {
$q->fill_webfilter_certs();
}
$Computers = numberFormat($Computers, 0, "", " ");
$sock = new sockets();
$EnableUfdbGuard = $sock->EnableUfdbGuard();
$tablescat = $q->LIST_TABLES_CATEGORIES();
$CountDeCategories = numberFormat(count($tablescat), 0, "", " ");
$todayblocked = date("Ymd") . "_blocked";
$CountDeBlocked = $sql = $q->COUNT_ROWS($todayblocked);
$CountDeBlocked = numberFormat($CountDeBlocked, 0, "", " ");
$disable_service = $tpl->_ENGINE_parse_body("{disable_service}");
$datasUFDB = unserialize(base64_decode($sock->GET_INFO("ufdbguardConfig")));
if (!is_numeric($datasUFDB["DebugAll"])) {
$datasUFDB["DebugAll"] = 0;
}
$update_parameters = $tpl->_ENGINE_parse_body("{update_parameters}");
$EnableWebProxyStatsAppliance = $sock->GET_INFO("EnableWebProxyStatsAppliance");
$UseRemoteUfdbguardService = $sock->GET_INFO("UseRemoteUfdbguardService");
$UFDB = unserialize(base64_decode($sock->GET_INFO("ufdbguardConfig")));
$EnableKerbAuth = $sock->GET_INFO("EnableKerbAuth");
$SquidPerformance = intval($sock->GET_INFO("SquidPerformance"));
if (!is_numeric($UseRemoteUfdbguardService)) {
$UseRemoteUfdbguardService = 0;
}
if (!is_numeric($EnableWebProxyStatsAppliance)) {
$EnableWebProxyStatsAppliance = 0;
}
if (!is_numeric($UseRemoteUfdbguardService)) {
$UseRemoteUfdbguardService = 0;
}
if (!is_numeric($EnableKerbAuth)) {
$EnableKerbAuth = 0;
}
if ($EnableWebProxyStatsAppliance == 1) {
$EnableUfdbGuard = 1;
}
if ($UseRemoteUfdbguardService == 0) {
if ($UFDB["UseRemoteUfdbguardService"] == 1) {
$sock->SET_INFO("UseRemoteUfdbguardService", 1);
$UseRemoteUfdbguardService = 1;
}
}
if ($users->WEBSTATS_APPLIANCE) {
$EnableWebProxyStatsAppliance = 1;
}
if (!$users->APP_UFDBGUARD_INSTALLED) {
$EnableUfdbGuard = 0;
}
if ($users->UPDATE_UTILITYV2_INSTALLED) {
$updateutility = "\t<tr>\n\t\t<td valign='middle' width=1%><img src='img/kaspersky-update-32.png'></td>\n\t\t<td valign='middle' width=99%>\n\t\t\t<table style='width:100%'>\n\t\t\t<tr>\n\t\t\t\t<td valign='middle' width=1%><img src='img/arrow-right-16.png'></td>\n\t\t\t\t<td valign='top' {$mouse} style='font-size:13px;text-decoration:underline' \n\t\t\t\tOnClick=\"javascript:Loadjs('ufdbguard.UpdateUtility.php')\" nowrap>UpdateUtility</td>\n\t\t\t</tr>\n\t\t\t</table>\n\t\t</td>\n\t</tr>";
}
$ufdbgverb_icon = "ok24-grey.png";
$ufdbgverb_txt = "OFF";
if ($datasUFDB["DebugAll"] == 1) {
$ufdbgverb_icon = "ok32.png";
$ufdbgverb_txt = "ON";
//.........这里部分代码省略.........