$page=CurrentPageName();

$tpl=new templates();

$users=new usersMenus();

$t=time();

$boot=new boostrap_form();

$array["{backuped_logs}"]="$page?backuped-logs=yes";

$array["{parameters}"]="$page?parameters=yes";

$array["{task_events}"]="miniadm.system.syslogstore.php?events-daemon=yes";

echo $boot->build_tab($array);

$tpl=new templates();

$sock=new sockets();

$ini=new Bs_IniHandler();

$ini->loadString(base64_decode($sock->getFrameWork('system.php?syslogdb-status=yes')));

$APP_SQUID_DB=DAEMON_STATUS_ROUND("APP_SYSLOG_DB",$ini,null,1);

echo $tpl->_ENGINE_parse_body($APP_SQUID_DB);

$users=new usersMenus();

$sock=new sockets();

$boot=new boostrap_form();

$boot->set_formtitle("{logs_retention}");

$boot->set_formdescription("{squid_logs_retention_explain}");

$BackupMaxDays=$sock->GET_INFO("BackupMaxDays");

$BackupMaxDaysDir=$sock->GET_INFO("BackupMaxDaysDir");

if($BackupMaxDaysDir==null){$BackupMaxDaysDir="/home/logrotate_backup";}

$BackupSquidLogsUseNas=$sock->GET_INFO("BackupSquidLogsUseNas");

$BackupSquidLogsNASIpaddr=$sock->GET_INFO("BackupSquidLogsNASIpaddr");

$BackupSquidLogsNASFolder=$sock->GET_INFO("BackupSquidLogsNASFolder");

$BackupSquidLogsNASUser=$sock->GET_INFO("BackupSquidLogsNASUser");

$BackupSquidLogsNASPassword=$sock->GET_INFO("BackupSquidLogsNASPassword");

if(!is_numeric($BackupSquidLogsUseNas)){$BackupSquidLogsUseNas=0;}

if(!is_numeric($BackupMaxDays)){$BackupMaxDays=30;}

$MySQLSyslogType=$sock->GET_INFO("MySQLSyslogType");

if(!is_numeric($MySQLSyslogType)){$MySQLSyslogType=1;}

$boot->set_field("BackupMaxDays", "{max_day_in_database}", $BackupMaxDays,array("TOOLTIP"=>"{syslog_max_day_in_database_explain}"));

$boot->set_field("BackupMaxDaysDir", "{backup_folder}", $BackupMaxDaysDir,array("BROWSE"=>true,"TOOLTIP"=>"{syslog_backup_folder_explain}"));

$boot->set_spacertitle("{NAS_storage}");

$boot->set_checkbox("BackupSquidLogsUseNas", "{use_remote_nas}", $BackupSquidLogsUseNas,

array("TOOLTIP"=>"{BackupSquidLogsUseNas_explain}",

"LINK"=>"BackupSquidLogsNASIpaddr,BackupSquidLogsNASFolder,BackupSquidLogsNASUser,BackupSquidLogsNASPassword"

));

$boot->set_field("BackupSquidLogsNASIpaddr", "{hostname}", $BackupSquidLogsNASIpaddr);

$boot->set_field("BackupSquidLogsNASFolder", "{shared_folder}", $BackupSquidLogsNASFolder,array("ENCODE"=>true));

$boot->set_field("BackupSquidLogsNASUser","{username}", $BackupSquidLogsNASUser,array("ENCODE"=>true));

$boot->set_fieldpassword("BackupSquidLogsNASPassword","{password}", $BackupSquidLogsNASPassword,array("ENCODE"=>true));

$boot->set_button("{apply}");

if($MySQLSyslogType<>1){

$boot->set_spacerexplain("{MySQLSyslogTypediff_explain}");

$boot->set_form_locked();

}

if(!$users->AsSquidAdministrator){

$boot->set_form_locked();

}

$t=time();

$page=CurrentPageName();

echo $boot->Compile()."<hr>

<div id='$t'></div>

<script>

LoadAjax('$t','$page?mysql-syslogs-status=yes');

</script>

";

$sock=new sockets();

$tpl=new templates();

$page=CurrentPageName();

$f[]="<H3>{database_status}</H3>";

$TuningParameters=unserialize(base64_decode($sock->GET_INFO("MySQLSyslogParams")));

$MySQLSyslogWorkDir=$sock->GET_INFO("MySQLSyslogWorkDir");

if($MySQLSyslogWorkDir==null){$MySQLSyslogWorkDir="/home/syslogsdb";}

$MySQLSyslogType=$sock->GET_INFO("MySQLSyslogType");

if(!is_numeric($MySQLSyslogType)){$MySQLSyslogType=1;}

if($MySQLSyslogType==1){

$array=unserialize(@file_get_contents("/usr/share/artica-postfix/ressources/logs/web/syslog-db.size.db"));

$SIZE=FormatBytes($array["SIZE"]);

$USED=FormatBytes($array["USED"]);

$DBSIZE=FormatBytes($array["DBSIZE"]);

$AIVA=$array["AIVA"];

$POURC=$array["POURC"];

if(!is_numeric($POURC)){$POURC=0;}

$MOUNTED=$array["MOUNTED"];

$t=time();

$f[]="<table style='width:100%'>";

$f[]="<tr>";

$f[]="<td style='vertical-align:top;width:430px' width=430px><div id='sys$t'></div></td>";

$f[]="<td style='vertical-align:top;'>";

$f[]="<table style='width:100%'>";

$f[]="<tr>";

$f[]="<td class=legend style='font-size:18px'>{connection}:</td>";

$f[]="<td style='font-size:18px;font-weight:bold'>/var/run/syslogdb.sock</td>";

$f[]="</tr>";

$f[]="<tr>";

$f[]="<td class=legend style='font-size:18px'>{directory}:</td>";

$f[]="<td style='font-size:18px;font-weight:bold'>$MySQLSyslogWorkDir</td>";

$f[]="</tr>";

$f[]="<tr>";

$f[]="<td class=legend style='font-size:18px'>{size}:</td>";

$f[]="<td style='font-size:18px;font-weight:bold'>$DBSIZE/$SIZE ({$POURC}%)</td>";

$f[]="</tr>";

$f[]="</table>";

$f[]="</td>";

$f[]="</tr>";

$f[]="</table>";

$f[]="<script>LoadAjax('sys$t','$page?mysql-service-status=yes');</script>";

}

if($MySQLSyslogType==2){

$username=$TuningParameters["username"];

$mysqlserver=$TuningParameters["mysqlserver"];

$RemotePort=$TuningParameters["RemotePort"];

$f[]="<table style='width:100%'>";

$f[]="<tr>";

$f[]="<td class=legend style='font-size:18px'>{connection}:</td>";

$f[]="<td class=legend style='font-size:18px;font-weight:bold'>$mysqlserver:$RemotePort</td>";

$f[]="</tr>";

$f[]="<tr>";

$f[]="<td class=legend style='font-size:18px'>{username}:</td>";

$f[]="<td class=legend style='font-size:18px;font-weight:bold'>$username</td>";

$f[]="</tr>";

$f[]="</table>";

}

echo $tpl->_ENGINE_parse_body(@implode("\n", $f));

if(isset($_POST["BackupSquidLogsNASFolder"])){$_POST["BackupSquidLogsNASFolder"]=url_decode_special_tool($_POST["BackupSquidLogsNASFolder"]);}

if(isset($_POST["BackupSquidLogsNASUser"])){$_POST["BackupSquidLogsNASUser"]=url_decode_special_tool($_POST["BackupSquidLogsNASUser"]);}

if(isset($_POST["BackupSquidLogsNASPassword"])){$_POST["BackupSquidLogsNASPassword"]=url_decode_special_tool($_POST["BackupSquidLogsNASPassword"]);}

$sock=new sockets();

while (list ($key, $value) = each ($_POST) ){

$sock->SET_INFO($key, $value);

}

$sock=new sockets();

$sock->getFrameWork("services.php?rotateclean=yes");

$boot=new boostrap_form();

$q=new mysql_storelogs();

if(!isset($_SESSION["QUERY_SYSLOG_HOST_DAY_FIELDY"])){

$sql="SELECT DATE_FORMAT(filetime,'%Y-%m-%d') as filetime FROM files_info GROUP BY filetime ORDER BY filetime DESC";

$results=$q->QUERY_SQL($sql);

$dayz[null]="{select}";

while ($ligne = mysql_fetch_assoc($results)) {

$time=time_to_date(strtotime($ligne["filetime"]." 00:00:00"));

$dayz[$ligne["filetime"]]=$time;

}

$_SESSION["QUERY_SYSLOG_HOST_DAY_FIELDY"]=serialize($dayz);

}

if(!isset($_SESSION["QUERY_SYSLOG_HOST_FIELDZ"])){

$sql="SELECT hostname FROM files_info GROUP BY hostname ORDER BY hostname ASC";

$results=$q->QUERY_SQL($sql);

$hostz[null]="{select}";

while ($ligne = mysql_fetch_assoc($results)) {

$hostz[$ligne["hostname"]]=$ligne["hostname"];

}

$_SESSION["QUERY_SYSLOG_HOST_FIELDZ"]=serialize($hostz);

}

$LIMITS[50]=50;

$LIMITS[250]=250;

$LIMITS[500]=250;

$LIMITS[1000]=1000;

$LIMITS[2000]=2000;

if(!isset($_SESSION["QUERY_SYSLOG_LIMIT"])){$_SESSION["QUERY_SYSLOG_LIMIT"]=250;}

if(!is_numeric($_GET["xtime"])){

$boot->set_list("QUERY_SYSLOG_DATE", "{date}", unserialize($_SESSION["QUERY_SYSLOG_HOST_DAY_FIELDY"]),$_SESSION["QUERY_SYSLOG_DATE"]);

}

$boot->set_list("QUERY_SYSLOG_HOST", "{hostname}", unserialize($_SESSION["QUERY_SYSLOG_HOST_FIELDZ"]),$_SESSION["QUERY_SYSLOG_HOST"]);

$boot->set_field("QUERY_SYSLOG_FILE", "{filename}", $_SESSION["QUERY_SYSLOG_FILE"]);

$boot->set_list("QUERY_SYSLOG_LIMIT", "{rows}", $LIMITS,$_SESSION["QUERY_SYSLOG_LIMIT"]);

$boot->set_button("{search}");

$boot->set_CloseYahoo("YahooWin2");

$boot->set_formdescription("{advanced_search_explain}");

$boot->set_RefreshSearchs();

echo $boot->Compile();

while (list ($key, $value) = each ($_POST) ){

$_SESSION[$key]=$value;

}

$tpl=new templates();

$users=new usersMenus();

if(!$users->CORP_LICENSE){

echo $tpl->_ENGINE_parse_body("<p class=text-error>{this_feature_is_disabled_corp_license}</p>");

die();

}

$page=CurrentPageName();

$boot=new boostrap_form();

$tpl=new templates();

//$LINKS["LINKS"][]=array("LABEL"=>"{advanced_search}","JS"=>"Loadjs('$page?search-dabatase-js=yes&xtime={$_GET["xtime"]}')");

echo

$tpl->_ENGINE_parse_body("<p>{source_logs_squid_text}</p>").

$boot->SearchFormGen("filename,hostname,filetime","search-database","&xtime={$_GET["xtime"]}",$LINKS);

$page=1;

$MyPage=CurrentPageName();

$users=new usersMenus();

$tpl=new templates();

$sock=new sockets();

$q=new mysql_storelogs();

if(!$q->BD_CONNECT()){senderror($q->mysql_error);}

if($q->start_error<>null){senderror($q->start_error);}

$table="files_info";

$tableOrg=$table;

$database=$q->database;

$t=time();

$delete_alert=$tpl->javascript_parse_text("{delete_this_item}");

$MySQLType=$tpl->_ENGINE_parse_body($q->MYSQLTypeText);

//if(!$q->TABLE_EXISTS($table,$database)==0){senderror("{table_does_not_exists}: <strong>$database/$table</strong> $MySQLType: `$q->SocketName`!");}

if($q->COUNT_ROWS($table,$database)==0){senderror("$table/$database is empty");}

$searchstring=string_to_flexquery("search-database");

$limit="LIMIT 0,250";

if(is_numeric($_GET["xtime"])){

$WHERE1=" (DATE_FORMAT(filetime,'%Y-%m-%d')='".date("Y-m-d")."') AND";

unset($_SESSION["QUERY_SYSLOG_DATE"]);

}

if($_SESSION["QUERY_SYSLOG_LIMIT"]>0){

$limit="LIMIT 0,{$_SESSION["QUERY_SYSLOG_LIMIT"]}";

}

$filters=array();

$filters[]=SearchToSql("DATE_FORMAT(filetime,'%Y-%m-%d')",$_SESSION["QUERY_SYSLOG_DATE"]);

$filters[]=SearchToSql("filename",$_SESSION["QUERY_SYSLOG_FILE"]);

$filters[]=SearchToSql("hostname",$_SESSION["QUERY_SYSLOG_HOST"]);

$table="(SELECT `filename`,`taskid`,`storeid`,`filesize`,`filetime`,`hostname` FROM $table

WHERE $WHERE1 (`filename` LIKE 'auth.log%') OR (filename LIKE 'squid-access%')) as t";

$sql="SELECT * FROM $table WHERE 1 $searchstring ".@implode(" ", $filters)." ORDER BY `filetime` DESC LIMIT 0,250";

writelogs($sql,__FUNCTION__,__FILE__,__LINE__);

$results = $q->QUERY_SQL($sql,$database);

if(!$q->ok){senderror("$q->mysql_error");}

if(mysql_num_rows($results)==0){senderror("Query return empty array");}

$boot=new boostrap_form();

while ($ligne = mysql_fetch_assoc($results)) {

$md5S=md5(serialize($ligne));

$filename=$ligne["filename"];

$hostname=$ligne["hostname"];

$storeid=$ligne["storeid"];

$taskid=$ligne["taskid"];

$filesize=FormatBytes($ligne["filesize"]/1024);

$filetime=$ligne["filetime"];

$delete=imgsimple("delete-32.png",null,"Delete$t('$storeid','$md5S')");

$action="&nbsp;";

if(preg_match("#auth\.log-.*?#", $ligne["filename"])){

$action=imgsimple("32-import.png",null,"Loadjs('squid.restoreSource.php?filename={$ligne["filename"]}&storeid=$storeid')");

}

if(preg_match("#squid-access-(.*?)\.log\.#",$ligne["filename"])){

$action=imgsimple("32-import.png",null,"Loadjs('squid.restoreSource.php?filename={$ligne["filename"]}&storeid=$storeid')");

}

$download="<a href=\"$MyPage?download=$storeid&filename={$ligne["filename"]}&storeid=$storeid\"><img src='img/arrow-down-32.png'></a>";

$js="Loadjs('logrotate.php?log-js=yes&filename=$filename&storeid=$storeid&t=1368560783');";

$trlink=$boot->trswitch($js);

$tr[]="

<tr id='$md5S'>

<td nowrap $trlink>$filetime</td>

<td nowrap $trlink>$filename</td>

<td nowrap $trlink>$hostname</td>

<td nowrap $trlink>$filesize</td>

<td width=1% align=center>$download</td>

<td width=1% align=center>$action</td>

<td width=1% align=center>$delete</td>

</tr>

";

}

echo $tpl->_ENGINE_parse_body("

<table class='table table-bordered table-hover'>

<thead>

<tr>

<th>{date}</th>

<th>{filename}</th>

<th>{hostname}</th>

<th>{size}</th>

<th>&nbsp;</th>

<th>&nbsp;</th>

<th>&nbsp;</th>

</tr>

</thead>

<tbody>

").@implode("", $tr)."</tbody></table>

<script>

var memedb$t='';

var xDelete$t= function (obj) {

var results=obj.responseText;

if(results.length>2){alert(results);return;}

$('#'+memedb$t).remove();

}

function Delete$t(ID,md){

memedb$t=md;

if(confirm('$delete_alert '+ID+' ?')){

var XHR = new XHRConnection();

XHR.appendData('syslog-delete',ID);

XHR.sendAndLoad('$MyPage', 'POST', xDelete$t);

}

}

</script>";