function show_byday2($tmin, $tmax, $link)
{
$result = mysql_query("select distinct u.login as uname, d.id as id, count(d.size) as _count, sum(d.size) as _ssize from detail d, users u where d.u_id=u.id and utime<{$tmax} and utime>{$tmin} group by u_id order by _ssize desc;", $link);
$mod_name = "day stat, daily leve2";
show_head();
show_help();
// echo "select distinct u.login as uname, sum(d.size) as _ssize from detail d, users u where d.u_id=u.id and utime<$tmax and utime>$tmin group by u_id;";
echo "<br>" . strftime("%d %B, %T", (int) $tmin) . "-" . strftime("%d, %B %T", (int) $tmax) . " ";
echo "<HR NOSHADE COLOR=#000000 SIZE=1>\n<BR>\n";
echo "<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>\n <TR><TD BGCOLOR=#93BEE2>\n <TABLE BORDER=0 CELLPADDING=1 CELLSPACING=1>\n <TR VALIGN=TOP ALIGN=CENTER>\n <TD HEIGHT=15>login</TD>\n <TD><B>count</B></TD>\n <TD><B>bytes</B></TD>\n </TR>";
$max = mysql_num_rows($result);
for ($i = 0; $i < $max; $i++) {
$login = @mysql_result($result, $i, "uname");
$uid = @mysql_result($result, $i, "id");
$size = @mysql_result($result, $i, "_ssize");
$count = @mysql_result($result, $i, "_count");
echo "<TR BGCOLOR=#FFF7E5 ALIGN=RIGHT>\n\t<td>{$login}</td>\n\t<td>" . dotize($count) . "</a></td>\n\t<td>" . dotize($size) . "</a></td>\n\t</tr>";
}
}
} elseif ("1" == $status) {
echo "disabled";
} elseif ("3" == $status) {
echo "for remove";
} elseif ($lim == "0") {
echo "Анлим.";
} elseif ($cur > $lim) {
echo "{$web_status_negative}";
}
echo "</TR>";
}
$result = mysql_query("SELECT sum(used) as slim FROM users", $link);
$lim = mysql_result($result, 0, "slim");
$msum = 0;
if (!isset($no_mail)) {
$result = mysql_query("SELECT SUM(size) as ssize FROM mail", $link);
$msum = @mysql_result($result, 0, "ssize");
}
$result = mysql_query("SELECT SUM(quota) as squota, count(quota) as _total FROM users", $link);
$slim = @mysql_result($result, 0, "squota");
$_total = @mysql_result($result, 0, "_total");
$result = mysql_query("SELECT offset FROM sys_trf", $link);
$sys_off = @mysql_result($result, 0, "offset");
// Мужик по фамилии "_Итого:"
echo "<TR BGCOLOR=#FFF7E5><TD><A NAME=\"{$word_total}\">{$web_admin_total} {$i} ({$_total})</A></TD>\n <TD ALIGN=RIGHT><A HREF=\"index.php?type=allsites\">" . dotize($lim) . "</A></TD>\n <TD ALIGN=RIGHT>" . dotize($slim) . "</TD>\n <TD></TD>\n <TD></TD>\n <TD></TD>\n <TD align=right>" . dotize($msum) . "</TD>\n </TR>";
echo "</TABLE></TD>\n</TR>\n</TABLE><br>";
echo "</TABLE></TD>\n</TR>\n</TABLE><br>";
clearstatcache() . ($fsize = filesize($logdir));
echo " {$web_admin_logfree_space} " . (int) (disk_free_space("{$logdir}") / (1024 * 1024)) . " Mb. log offset: {$sys_off} log size: {$fsize} ";
show_tail();
@mysql_close($link);
$result2 = mysql_query("SELECT SUM(size) FROM mail WHERE {$rcpt}", $link);
$msum = @mysql_result($result2, 0);
$msum = dotize($msum);
echo "{$msum}</TD><TD>";
if ($lim > 0) {
if ($cur > $lim) {
echo "Отключен";
}
}
echo "</TR>";
}
$result = mysql_query("SELECT sum(used) as sused, sum(quota) as squota FROM traf", $link);
$slim = @mysql_result($result, 0, "squota");
$lim = @mysql_result($result, 0, "sused");
// опять емайл ;))
$result = mysql_query("SELECT SUM(size) FROM mail", $link);
$msum = @mysql_result($result, 0);
// Мужик по фамилии "_Итого:"
echo "<TR BGCOLOR=#FFF7E5><TD>Итого на {$i} рыл</TD>\n <TD ALIGN=RIGHT>" . dotize($lim) . "</TD>\n <TD ALIGN=RIGHT>" . dotize($slim) . "</TD>\n <TD></TD>\n <TD align=right>" . dotize($msum) . "</TD>\n <TD align=right><FONT COLOR=#00FF00>";
// тот самый предел в месяц.
if ($msum + $lim > $month_limit) {
echo "<FONT COLOR=#FF0000>";
}
echo " " . dotize($msum + $lim) . "</FONT></TD>\n </TR></TABLE></TD></TR></TABLE>";
$sendst = ob_get_clean();
echo $sendst;
//$hostname=shell_exec("hostname");
//mail($admin_mail, "$hostname ".date("Y-M-d")."SAcc v$version", $sendst, "Content-type: text/html");
ob_flush();
echo "OK";
exit;
function show_all_history_stat($link)
{
global $o;
global $detailed;
global $mode;
global $lang;
global $settings;
global $utime;
if ($lang == 0) {
include "../inc/ru.php";
}
if ($lang == 1) {
include "../inc/en.php";
}
$page = (int) $_GET['page'];
// ----------------------------
$pagestep = $settings['pagelen'];
//-----------------------------
$cquery = $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'];
if (0 < strpos($cquery, "&page=")) {
$cquery = substr($cquery, 0, strpos($cquery, "&page="));
}
echo "<br><center><p style=\"font-size: 12\">";
$result = mysql_query("SELECT count(site) as rec FROM site", $link);
$pages = floor(mysql_result($result, 0, "rec") / $pagestep);
if ($page != 0) {
echo "<a href=\"{$cquery}" . "&page=0\"><<</a> ";
}
if ($page > 10) {
echo "<a href=\"{$cquery}&page=" . ($page - 10) . "\"><</a> ";
}
if ($page - 5 > 0) {
for ($i = $page - 5; $i < $page; $i++) {
echo "<a href=\"{$cquery}&page={$i}\">{$i}</a> ";
}
} else {
for ($i = 1; $i < $page; $i++) {
echo "<a href=\"{$cquery}&page={$i}\">{$i}</a> ";
}
}
echo "<b>{$page}</b> ";
if ($page + 5 < $pages) {
for ($i = $page + 1; $i < $page + 6; $i++) {
echo "<a href=\"{$cquery}&page={$i}\">{$i}</a> ";
}
} else {
for ($i = $page + 1; $i < $pages; $i++) {
echo "<a href=\"{$cquery}&page={$i}\">{$i}</a> ";
}
}
if ($page + 10 < $pages) {
echo "<a href=\"{$cquery}&page=" . ($page + 10) . "\">></a> ";
}
if ($page < $pages) {
echo "<a href=\"{$cquery}&page=" . $pages . "\">>></a> ";
}
echo "</p>";
switch ($o) {
case "sizeD":
$orderby = "size DESC";
$o1 = "?o=sizeA";
$o2 = "?o=siteA";
$b1 = "#93BEE2";
$b2 = "#FFFFFF";
$p1 = "<A HREF=\"index.php{$o1}\"><IMG ALT=\"{$web_client_order_desc}\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/desc.gif></A> ";
$p2 = "";
break;
case "sizeA":
$orderby = "size ASC";
$o1 = "?o=sizeD";
$o2 = "?o=siteA";
$b1 = "#93BEE2";
$b2 = "#FFFFFF";
$p1 = "<A HREF=\"index.php{$o1}\"><IMG ALT=\"{$web_client_order_asc}\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/asc.gif></A> ";
$p2 = "";
break;
case "siteD":
$orderby = "site DESC";
$o1 = "?o=sizeA";
$o2 = "?o=siteA";
$b1 = "#FFFFFF";
$b2 = "#93BEE2";
$p1 = "";
$p2 = "<A HREF=\"index.php{$o2}\"><IMG ALT=\"{$web_client_order_desc}\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/desc.gif></A> ";
break;
case "siteA":
$orderby = "site ASC";
$o1 = "?o=sizeA";
$o2 = "?o=siteD";
$b1 = "#FFFFFF";
$b2 = "#93BEE2";
$p1 = "";
$p2 = "<A HREF=\"index.php{$o2}\"><IMG ALT=\"{$web_client_order_asc}\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/asc.gif></A> ";
break;
default:
$orderby = "size DESC";
$o1 = "?o=sizeA";
$o2 = "?o=siteA";
$b1 = "#93BEE2";
$b2 = "#FFFFFF";
$p1 = "<A HREF=\"index.php{$o1}\"><IMG ALT=\"{$web_client_order_asc}\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/asc.gif></A> ";
$p2 = "";
}
echo "<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>";
echo "<TR>";
echo "<TD BGCOLOR=#93BEE2>";
echo "<TABLE BORDER=0 CELLPADDING=1 CELLSPACING=1>";
echo "<TR>";
echo "<TD ALIGN=CENTER BGCOLOR={$b1}>{$p1}<B><A HREF=\"index.php{$o1}&type=allshist&utime={$utime}\" STYLE=\"color:#000000; text-decoration: underline\">{$web_client_downloaded}</A></B></TD>";
echo "<TD ALIGN=CENTER BGCOLOR={$b2}>{$p2}<B><A HREF=\"index.php{$o2}&type=allshist&utime={$utime}\" STYLE=\"color:#000000; text-decoration: underline\">{$web_client_site}</A></B></TD>";
#echo "<TD ALIGN=CENTER BGCOLOR=#bfbfbf><B>$web_client_futime</B></TD>";
#echo "<TD ALIGN=CENTER BGCOLOR=#bfbfbf><B>$web_client_lutime</B></TD>";
echo "</TR>";
#$res = mysql_query("SELECT * FROM site WHERE u_id=$id ORDER BY $orderby", $link);
#$res = mysql_query("SELECT u_id, utime, qtime, ip_addr, code, size, url FROM detail WHERE url like('%".mysql_escape_string($site)."%') ORDER BY $orderby limit ".($page*$pagestep).",$pagestep", $link);
#$res = mysql_query("SELECT * FROM site ORDER BY $orderby LIMIT ".($page*$pagestep).",$pagestep", $link);
$res = mysql_query("SELECT s.site as site, s.size as size FROM uhistory u, shistory s WHERE u.utime={$utime} and u.id=s.uh_id ORDER BY {$orderby} LIMIT " . $page * $pagestep . ",{$pagestep}", $link);
#$res = mysql_query("SELECT s.site as site, s.size as size FROM uhistory u, shistory s WHERE u.utime=$utime and u.id=s.uh_id LIMIT ".($page*$pagestep).",$pagestep", $link);
#$res = mysql_query("SELECT s.site as site, s.size as size FROM uhistory u, shistory s WHERE u.utime=$utime and u.id=s.uh_id", $link);
#$res = mysql_query("SELECT * FROM shistory ORDER BY $orderby LIMIT ".($page*$pagestep).",$pagestep", $link);
if (!$res) {
return 3;
}
for ($i = 0; $i < MYSQL_NUMROWS($res); $i++) {
$site = mysql_result($res, $i, "site");
$size = mysql_result($res, $i, "size");
#$lutime = mysql_result($res,$i,"lutime");
#$futime = mysql_result($res,$i,"futime");
echo "<TR>\n<TD BGCOLOR=#FFF7E5 ALIGN=RIGHT>" . dotize($size) . "</TD>\n<TD BGCOLOR=#FFF7E5>";
if ($detailed == 1) {
if ($mode == "admin") {
//{echo "<a href=\"index.php?id=$id&type=detail&site=$site\">";}
//{echo "<a href=\"index.php?type=alldetail&site=$site\">";}
// else
//{echo "<a href=\"index.php?type=detail&site=$site\">";};
//{echo "<a href=\"index.php?type=alldetail&site=$site\">";};
echo "{$site}";
}
}
if ($detailed == 1) {
echo "</a>";
}
#echo "<TD BGCOLOR=#FFF7E5>".strftime ("%B %d, %T", (int)$futime)."</TD>";
#echo "<TD BGCOLOR=#FFF7E5>".strftime ("%B %d, %T", (int)$lutime)."</TD>";
echo "</TD></TR>";
}
echo "</TABLE></TD>\n</TR>\n</TABLE>\n";
#$res = mysql_query("SELECT SUM(size) FROM site WHERE u_id=$id", $link);
#$res = mysql_query("SELECT SUM(size) FROM site", $link);
#$res = mysql_query("SELECT SUM(size) FROM shistory", $link);
$res = mysql_query("SELECT SUM(s.size) as size FROM uhistory u, shistory s WHERE u.utime={$utime} and u.id=s.uh_id", $link);
$sum = mysql_result($res, 0);
#$res = mysql_query("SELECT count(site) FROM site WHERE u_id=$id", $link);
#$res = mysql_query("SELECT count(site) FROM site", $link);
#$res = mysql_query("SELECT count(site) FROM shistory", $link);
$res = mysql_query("SELECT SUM(s.site) as site FROM uhistory u, shistory s WHERE u.utime={$utime} and u.id=s.uh_id", $link);
$sites = mysql_result($res, 0);
mysql_close();
echo "<BR><SPAN CLASS=\"smalltext\"><B>{$word_total}:</B> " . dotize($sum) . " {$word_byte} {$web_client_downloaded_from} {$sites} {$web_client_sites_wrd}.</SPAN>";
return true;
}
function show_acl($link)
{
global $o, $word_total, $web_admin_description, $web_admin_name;
switch ($o) {
case "nameD":
$orderby = "name DESC";
$o1 = "?o=nameA";
$o2 = "?o=descA";
$b1 = "#93BEE2";
$b2 = "#FFFFFF";
$p1 = "<A HREF=\"index.php" . $o1 . "&type=acl\"><IMG ALT=\"Отсортировано в обратном порядке\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/desc.gif></A> ";
$p2 = "";
break;
case "nameA":
$orderby = "name ASC";
$o1 = "?o=nameD";
$o2 = "?o=descA";
$b1 = "#93BEE2";
$b2 = "#FFFFFF";
$p1 = "<A HREF=\"index.php" . $o1 . "&type=acl\"><IMG ALT=\"Отсортировано в прямом порядке\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/asc.gif></A> ";
$p2 = "";
break;
case "descD":
$orderby = "vname DESC";
$o1 = "?o=nameA";
$o2 = "?o=descA";
$b1 = "#FFFFFF";
$b2 = "#93BEE2";
$p1 = "";
$p2 = "<A HREF=\"index.php" . $o2 . "&type=acl\"><IMG ALT=\"Отсортировано в обратном порядке\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/desc.gif></A> ";
break;
case "descA":
$orderby = "vname ASC";
$o1 = "?o=nameA";
$o2 = "?o=descD";
$b1 = "#FFFFFF";
$b2 = "#93BEE2";
$p1 = "";
$p2 = "<A HREF=\"index.php" . $o2 . "&type=acl\"><IMG ALT=\"Отсортировано в прямом порядке\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/asc.gif></A> ";
break;
default:
$orderby = "id ASC";
$o1 = "?o=nameA";
$o2 = "?o=descD";
$b1 = "#FFFFFF";
$b2 = "#93BEE2";
$p1 = "<A HREF=\"index.php" . $o2 . "&type=acl\"><IMG ALT=\"Отсортировано в прямом порядке\" BORDER=0 HEIGHT=7 WIDTH=7 SRC=../images/asc.gif></A> ";
$p2 = "";
}
echo "<a href=\"index.php?type=acled&id=0\">add new acl</a>\r\n<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0><TR>\n<TD BGCOLOR=#93BEE2><TABLE BORDER=0 CELLPADDING=1 CELLSPACING=1><TR>\r\n</tr>\r\n<tr>\n<TD ALIGN=CENTER BGCOLOR={$b2}>{$p2}<B><A HREF=\"index.php{$o2}\" STYLE=\"color:#000000; text-decoration: underline\">{$web_admin_description}</A></B></TD>\n<TD ALIGN=CENTER BGCOLOR={$b1}>{$p1}<B><A HREF=\"index.php{$o1}\" STYLE=\"color:#000000; text-decoration: underline\">{$web_admin_name}</A></B></TD>";
$res = mysql_query("SELECT sysname, vname, id FROM acl ORDER BY {$orderby}", $link);
if (!$res) {
return 3;
}
for ($i = 0; $i < MYSQL_NUMROWS($res); $i++) {
$descr = mysql_result($res, $i, "vname");
$name = mysql_result($res, $i, "sysname");
$id = mysql_result($res, $i, "id");
echo "<TR>\n<TD BGCOLOR=#FFF7E5 ALIGN=LEFT><a href=\"index.php?type=acled&id={$id}\">" . $descr . "</a></TD>\n<TD BGCOLOR=#FFF7E5 ALIGN=LEFT>" . $name . "</TD>\n</TR>\n";
}
echo "<TD BGCOLOR=#FFF7E5 ALIGN=LEFT>{$word_total}</TD><TD BGCOLOR=#FFF7E5 ALIGN=LEFT>" . dotize($acl_count) . "</TD></TR>";
echo "</TABLE></TD>\n</TR>\n</TABLE>\n";
$res = mysql_query("SELECT count(id) FROM acl", $link);
$acl_count = mysql_result($res, 0);
mysql_close();
//echo "<BR><SPAN CLASS=\"smalltext\"><B>Итого:</B> " . dotize ( $acl_count ) . " правил.</SPAN>";
return 0;
}
