Пример #1
0
function categories_details()
{
    $tpl = new templates();
    $page = CurrentPageName();
    $date = GetLastUpdateDate();
    $category = $_GET["category-details"];
    $categorys = urlencode($category);
    $md = md5("{$category}");
    $html = "\n\t\n\t\n\t<div id='categories-details-title-{$md}' style='font-size:16px;margin:10px'></div>\n\t<div id='categories-details-{$md}'></div>\n\t\n\t\n\t<script>\n\t\tfunction RefreshCategoryDetails(){\n\t\tLoadAjax('categories-details-{$md}','{$page}?category-details-md={$categorys}');\n\t\t\n\t\t}\n\t\t\n\t\tfunction RefreshCategoryDetailsTitle(){\n\t\tif(!document.getElementById('total-cat')){\n\t\t\tLoadAjax('categories-details-title-{$md}','{$page}?category-details-md-title={$categorys}');\n\t\t\t}\n\t\t\n\t\t}\t\t\n\t\n\tRefreshCategoryDetails();\n\t</script>";
    echo $tpl->_ENGINE_parse_body($html);
}
Пример #2
0
function categories_details(){
	$tpl=new templates();
	$page=CurrentPageName();
	$date=GetLastUpdateDate();
	$category=$_GET["category-details"];
	$categorys=urlencode($category);
	$md=md5("$category");
	$html="
	
	
	<div id='categories-details-title-$md' style='font-size:16px;margin:10px'></div>
	<div id='categories-details-$md'></div>
	
	
	<script>
		function RefreshCategoryDetails(){
		LoadAjax('categories-details-$md','$page?category-details-md=$categorys');
		
		}
		
		function RefreshCategoryDetailsTitle(){
		if(!document.getElementById('total-cat')){
			LoadAjax('categories-details-title-$md','$page?category-details-md-title=$categorys');
			}
		
		}		
	
	RefreshCategoryDetails();
	</script>";
	
	echo $tpl->_ENGINE_parse_body($html);
	
	
	
	
	
}
Пример #3
0
function statusDB_list()
{
    $tpl = new templates();
    $page = CurrentPageName();
    $date = GetLastUpdateDate();
    $q = new mysql_squid_builder();
    $sql = "SELECT * FROM webfilters_updates WHERE updated=0";
    $results = $q->QUERY_SQL($sql);
    $style = "style='font-size:14px;font-weight:bold'";
    if ($_GET["from-ufdbguard"] == "yes") {
        echo $tpl->_ENGINE_parse_body("\n\t\t\t\t<div style='margin:15px;text-align:right'>\n\t\t\t\t" . button("{back_to_webfiltering}", "AnimateDiv('BodyContent');LoadAjax('BodyContent','dansguardian2.mainrules.php')", 18) . "\n\t\t\t\t</div>");
    }
    $html = "\n\t<div style='height:450px;width:100%;overflow:auto'>\n\t<table cellspacing='0' cellpadding='0' border='0' class='tableView' style='width:99%'>\n<thead class='thead'>\n\t<tr>\n\t\t\n\t\t<th width=99%>{category}</th>\n\t\t<th width=1%>{zDate}</th>\n\t</tr>\n</thead>";
    while ($ligne = mysql_fetch_assoc($results)) {
        if ($classtr == "oddRow") {
            $classtr = null;
        } else {
            $classtr = "oddRow";
        }
        $ligne["tablename"] = $q->tablename_tocat($ligne["tablename"]);
        $html = $html . "\n\t\t<tr class={$classtr}>\n\t\t\t<td width=99% align='left' {$style}>{$ligne["tablename"]}</td>\n\t\t\t<td width=1% align='left' {$style} nowrap>{$ligne["zDate"]}</td>\n\t\t</tr>\n\t\t";
    }
    $html = $html . "</table></div>";
    echo $tpl->_ENGINE_parse_body($html);
}
function global_status_artica_db()
{
    $tpl = new templates();
    $page = CurrentPageName();
    $date = GetLastUpdateDate();
    $users = new usersMenus();
    $sock = new sockets();
    $q = new mysql();
    $sql = "SELECT avg(progress) as pourcent FROM updates_categories  WHERE filesize>0";
    $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup"));
    if (!is_numeric($ligne["pourcent"])) {
        $ligne["pourcent"] = 0;
    }
    $pourcent = round($ligne["pourcent"], 2);
    $purc = pourcentage($pourcent);
    $t = $_GET["t"];
    $dateDB = $sock->getFrameWork("squid.php?articadb-version=yes");
    $dateDB_text = $tpl->time_to_date($dateDB);
    $DB_STATUS = unserialize(base64_decode($sock->getFrameWork("ufdbguard.php?databases-percent=yes")));
    $DB_STATUS_TIME = $DB_STATUS["ARTICA"]["LAST_TIME"];
    $DB_STATUS_MAX = $DB_STATUS["ARTICA"]["MAX"];
    $DB_STATUS_COUNT = $DB_STATUS["ARTICA"]["COUNT"];
    $DB_STATUS_PERC = round($DB_STATUS_COUNT / $DB_STATUS_MAX * 100);
    $color = "color:black;";
    $sock = new sockets();
    $scheduledAR = unserialize(base64_decode($sock->getFrameWork("squid.php?schedule-maintenance-exec=yes")));
    $SquidDatabasesArticaEnable = $sock->GET_INFO("SquidDatabasesArticaEnable");
    if (!is_numeric($SquidDatabasesArticaEnable)) {
        $SquidDatabasesArticaEnable = 1;
    }
    if ($SquidDatabasesArticaEnable == 1) {
        $disable_text = "Artica&nbsp;{database}:&nbsp;{enabled}";
    } else {
        $disable_text = "Artica&nbsp;{database}:&nbsp;{disabled}";
        $color = "color:#B6ACAC";
    }
    $CORP_LICENSE = 1;
    if (!$users->CORP_LICENSE) {
        $CORP_LICENSE = 0;
        $SquidDatabasesArticaEnable = 0;
        $disable_text = "Artica&nbsp;{database}:&nbsp;<strong style='color:#BA1010'>{license_inactive}</strong>";
        $color = "color:#B6ACAC";
    }
    $running = "<br><i style='font-size:12px'>{update_task_stopped}</i>";
    if ($scheduledAR["RUNNING"]) {
        $running = "<br><i style='font-size:12px;color:#BA0000'>{update_currently_running_since} {$scheduledAR["TIME"]}Mn</i>";
    }
    $q = new mysql_squid_builder();
    $SQL_ALL_ITEMS = "SELECT SUM( TABLE_ROWS ) AS tcount FROM information_schema.tables WHERE table_schema = 'squidlogs' AND table_name LIKE 'category_%'";
    $ligne = mysql_fetch_array($q->QUERY_SQL($SQL_ALL_ITEMS));
    if (!$q->ok) {
        echo "<H2>{$q->mysql_error}</H2>";
    }
    $itemsPerso = $ligne["tcount"];
    $itemsPerso = numberFormat($itemsPerso, 0, "", " ");
    $catz = new mysql_catz();
    $itemsArtica = numberFormat(intval(@file_get_contents("/usr/share/artica-postfix/ressources/UFDB_ARTICA_COUNT")));
    $q = new mysql_squid_builder();
    $backuped_items = $q->COUNT_ROWS("webfilters_backupeddbs");
    $sql = "SELECT SUM(size) as tszie FROM webfilters_backupeddbs";
    $ligne = mysql_fetch_array($q->QUERY_SQL($sql));
    $backuped_items_size = FormatBytes($ligne["tszie"] / 1024);
    $backuped_items_text = "{$backuped_items} {backup_containers} ({$backuped_items_size})";
    $tableau = "\n\t<div style='width:95%;min-height:254px' class=form>\n\t<table style='width:99%'>\n\t<tbody>\n\t\t<tr>\n\t\t\t<td colspan=2 style='font-size:16px;{$color}'>{artica_databases}{$running}</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td class=legend style='font-size:14px;font-weight:bold'>{youritems}:</td>\n\t\t\t<td style='font-size:14px;font-weight:bold'>{$itemsPerso}</td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td colspan=2 style='font-size:14px' align='right'>\n\t\t\t\t<table style='width:2%'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td width=1%><img src='img/arrow-right-16.png'>\n\t\t\t\t\t\t\t<td nowrap><a href=\"javascript:blur();\" \n\t\t\t\t\t\t\tOnClick=\"javascript:Loadjs('dansguardian2.backuped.databases.php');\" \n\t\t\t\t\t\t\tstyle='font-size:12px;text-decoration:underline'>{$backuped_items_text}</a>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\t\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td width=1%><img src='img/arrow-right-16.png'>\n\t\t\t\t\t\t\t<td nowrap><a href=\"javascript:blur();\" \n\t\t\t\t\t\t\tOnClick=\"javascript:Loadjs('dansguardian2.restore.databases.php');\" \n\t\t\t\t\t\t\tstyle='font-size:12px;text-decoration:underline'>{restore_backup}</a>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td width=1%><img src='img/arrow-right-16.png' id='emptypersonaldbdiv'>\n\t\t\t\t\t\t\t<td nowrap><a href=\"javascript:blur();\" \n\t\t\t\t\t\t\tOnClick=\"javascript:Loadjs('dansguardian2.restore.databases.php?empty-js=yes');\" \n\t\t\t\t\t\t\tstyle='font-size:12px;text-decoration:underline'>{empty_database}</a>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td width=1%><img src='img/arrow-right-16.png'>\n\t\t\t\t\t\t\t<td nowrap><a href=\"javascript:blur();\" OnClick=\"javascript:Loadjs('ufdbguard.databases.php?scripts=compile-schedule');\" style='font-size:12px;text-decoration:underline;{$color}'>{compilation_schedule}</a></td>\n\t\t\t\t\t\t</tr>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t</table>\n\t\t\t</td>\t\t\t\n\t\t<tr>\n\t\t\t<td class=legend style='font-size:14px;font-weight:bold;{$color}'>{articaitems}:</td>\n\t\t\t<td style='font-size:14px;font-weight:bold;{$color}'>{$itemsArtica} v.{$dateDB} <i style='font-size:11px'>{$dateDB_text}</i></td>\n\t\t</tr>\n\t\t<tr>\n\t\t\t<td class=legend style='font-size:12px;font-weight:bold;{$color}'>{update_status}:</td>\n\t\t\t<td>" . pourcentage($DB_STATUS_PERC, 0, "green") . "</td>\n\t\t</tr>\t\t\n\n\t\t\n\n\t\n\t\t<tr>\n\t\t\t<td colspan=2 style='font-size:14px' align='right'>\n\t\t\t<table style='width:2%'>\n\t\t\t<tbody>\n\t\t\t\n\t\t\t\t<tr>\n\t\t\t\t\t<td width=1%><img src='img/arrow-right-16.png'>\n\t\t\t\t\t<td nowrap><a href=\"javascript:blur();\" OnClick=\"javascript:ArticaDBDisable();\" style='font-size:12px;text-decoration:underline;{$color}'>{$disable_text}</a></td>\n\t\t\t\t</tr>\t\t\t\t\t\t\n\t\t\t<tr>\n\t\t\t\t<td width=1%><img src='img/arrow-right-16.png'>\n\t\t\t\t<td nowrap><a href=\"javascript:blur();\" OnClick=\"javascript:ArticaDBUpdateNow();\" style='font-size:12px;text-decoration:underline;{$color}'>{update_now}</a></td>\n\t\t\t</tr>\n\t\n\t\t\t\t\t\t\n\t\t\t</tbody>\n\t\t\t</table>\n\t\t\t\n\t\t</tr>\n\t\t\t\n\t</tbody>\n\t</table>\n\t</div>\n\t<script>\n\tvar x_ArticaDBUpdateNow= function (obj) {\n\t\t\tvar tempvalue=obj.responseText;\n\t\t\tif(tempvalue.length>3){alert(tempvalue)};\n\t    \tRefreshArticaDBStatus();\n\t\t}\t\n\n\t\tfunction ArticaDBUpdateNow(){\n\t\t\tvar CORP_LICENSE={$CORP_LICENSE};\n\t\t\tif(CORP_LICENSE==0){alert('license error');return;}\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('global-artica-status-update','yes');\n\t\t\tXHR.sendAndLoad('{$page}', 'POST',x_ArticaDBUpdateNow);\n\t\t}\n\t\n\t\t\n\tvar xArticaDBDisable= function (obj) {\n\t\t\tvar tempvalue=obj.responseText;\n\t\t\tif(tempvalue.length>3){alert(tempvalue)};\n\t    \tRefreshArticaDBStatus();\n\t\t}\t\n\n\t\t\n\t\tfunction ArticaDBDisable(){\n\t\t\tvar CORP_LICENSE={$CORP_LICENSE};\n\t\t\tif(CORP_LICENSE==0){alert('license error');return;}\n\t\t\tvar XHR = new XHRConnection();\n\t\t\tXHR.appendData('global-artica-enable-update','{$SquidDatabasesArticaEnable}');\n\t\t\tXHR.sendAndLoad('{$page}', 'POST',xArticaDBDisable);\t\t\n\t\t\n\t\t}\t\t\n\t</script>\n\t\n\t\n\t";
    $html = "<table style='width:100%'>\n\t<tbody>\n\t<tr>\n\t\t<td valign='top' width=1%><img src='img/artica5-64.png'></td>\n\t\t<td valign='top' width=99%>{$tableau}</td>\n\t</tr>\n\t<tr>\n\t\t<td colspan=2 align='right'><hr>" . imgtootltip("refresh-24.png", "{refresh}", "LoadAjax('artica-status-databases-{$t}','{$page}?global-artica-status-databases=yes&t={$t}');") . "</td>\n\t</tr>\n\t</tbody>\n\t</table>\n\t<script>\n\t\t\n\t\tLoadAjax('tlse-status-databases-{$t}','{$page}?global-tlse-status-databases=yes&t={$t}');\n\t</script>\n\t\n\t";
    echo $tpl->_ENGINE_parse_body($html);
}
Пример #5
0
function update()
{
    $myDate = GetLastUpdateDate();
    echo "BLACKLISTS: Last update on {$myDate}\n";
    $unix = new unix();
    $curl = new ccurl("http://www.artica.fr/blacklist/update.ini");
    if (!$curl->GetFile("/tmp/update.ini")) {
        ufdbguard_admin_events("Fatal: unable to download blacklist index file {$curl->error}", __FUNCTION__, __FILE__, __LINE__, "update");
        echo "BLACKLISTS: Failed to retreive http://www.artica.fr/blacklist/update.ini ({$curl->error})\n";
        return;
    }
    $ini = new Bs_IniHandler("/tmp/update.ini");
    $date = $ini->_params["settings"]["date"];
    echo "BLACKLISTS: Pattern update {$date}\n";
    if (!$GLOBALS["FORCE"]) {
        if ($date == $myDate) {
            echo "BLACKLISTS: No new updates\n";
            return;
        }
    }
    categorize_delete();
    while (list($category, $array) = each($ini->_params)) {
        echo "Saving {$category}\n";
        while (list($filename, $size) = each($array)) {
            if (!is_numeric($size)) {
                $size = 0;
            }
            echo "Saving {$filename} for {$category}\n";
            if (!INITCategory($category, $date, $filename, $size)) {
                echo "Fatal error {$category} {$date} {$filename} {$size}\n";
                return;
            }
        }
    }
}