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; }