logd2/stats.php at develop · BlackScorpGames/logd2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
<?php
// translator ready
// addnews ready
// mail ready
require_once("common.php");
require_once("lib/dhms.php");

Translator::tlschema("stats");

SuAccess::check_su_access(SU_EDIT_CONFIG);

PageParts::page_header("Stats");
require_once("lib/superusernav.php");
SuperUserNavClass::superusernav();
//OutputClass::addnav("Refresh the stats","stats.php");
OutputClass::addnav("Stats Types");
OutputClass::addnav("Totals & Averages","stats.php?op=stats");
OutputClass::addnav("Top Referers","stats.php?op=referers");
OutputClass::addnav("Logon Graph","stats.php?op=graph");

$op = Http::httpget("op");

if ($op=="stats" || $op==""){
	$sql = "SELECT sum(gentimecount) AS c, sum(gentime) AS t, sum(gensize) AS s, count(acctid) AS a FROM " . db_prefix("accounts");
	$result = db_query($sql);
	$row = db_fetch_assoc($result);
	OutputClass::output("`b`%For existing accounts:`b`n");
	OutputClass::output("`@Total Accounts: `^%s`n",number_format($row['a']));
	OutputClass::output("`@Total Hits: `^%s`n",number_format($row['c']));
	OutputClass::output("`@Total Page Gen Time: `^%s`n",dhms($row['t']));
	OutputClass::output("`@Total Page Gen Size: `^%sb`n",number_format($row['s']));
	OutputClass::output("`@Average Page Gen Time: `^%s`n",dhms($row['t']/$row['c'],true));
	OutputClass::output("`@Average Page Gen Size: `^%s`n",number_format($row['s']/$row['c']));
}elseif ($op=="referers"){
	OutputClass::output("`n`%`bTop Referers:`b`0`n");
	OutputClass::rawoutput("<table border='0' cellpadding='2' cellspacing='1' bgcolor='#999999'>");
	$name = Translator::translate_inline("Name");
	$refs = Translator::translate_inline("Referrals");
	OutputClass::rawoutput("<tr class='trhead'><td><b>$name</b></td><td><b>$refs</b></td></tr>");
	$sql = "SELECT count(*) AS c, acct.acctid,acct.name AS referer FROM " . db_prefix("accounts") . " INNER JOIN " . db_prefix("accounts") . " AS acct ON acct.acctid = " . db_prefix("accounts") . ".referer WHERE " . db_prefix("accounts") . ".referer>0 GROUP BY " . db_prefix("accounts") . ".referer DESC ORDER BY c DESC";
	$result = db_query($sql);
	$number=db_num_rows($result);
	for ($i=0;$i<$number;$i++){
		$row = db_fetch_assoc($result);
		OutputClass::rawoutput("<tr class='".($i%2?"trdark":"trlight")."'><td>");
		OutputClass::output_notl("`@{$row['referer']}`0");
		OutputClass::rawoutput("</td><td>");
		OutputClass::output_notl("`^{$row['c']}:`0  ");
		$sql = "SELECT name,refererawarded FROM " . db_prefix("accounts") . " WHERE referer = ${row['acctid']} ORDER BY acctid ASC";
		$res2 = db_query($sql);
		$number2=db_num_rows($res2);
		for ($j = 0; $j < $number2; $j++) {
			$r = db_fetch_assoc($res2);
			OutputClass::output_notl(($r['refererawarded']?"`&":"`$") . $r['name'] . "`0");
			if ($j != $number2-1) OutputClass::output_notl(",");
		}
		OutputClass::rawoutput("</td></tr>");
	}
	OutputClass::rawoutput("</table>");
}elseif($op=="graph"){
	$sql = "SELECT count(acctid) AS c, substring(laston,1,10) AS d FROM " . db_prefix("accounts") . " GROUP BY d DESC ORDER BY d DESC";
	$result = db_query($sql);
	OutputClass::output("`n`%`bDate accounts last logged on:`b");
	OutputClass::rawoutput("<table border='0' cellpadding='0' cellspacing='0'>");
	$class="trlight";
	$odate=date("Y-m-d");
	$j=0;
	$cumul = 0;
	$number=db_num_rows($result);
	for ($i=0;$i<$number;$i++){
		$row = db_fetch_assoc($result);
		$diff = (strtotime($odate)-strtotime($row['d']))/86400;
		for ($x=1;$x<$diff;$x++){
			//if ($j%7==0) $class=($class=="trlight"?"trdark":"trlight");
			//$j++;
			$class=(date("W",strtotime("$odate -$x days"))%2?"trlight":"trdark");
			OutputClass::rawoutput("<tr class='$class'><td>".date("Y-m-d",strtotime("$odate -$x days"))."</td><td>&nbsp;&nbsp;</td><td>0</td><td>&nbsp;&nbsp;</td><td align='right'>$cumul</td></tr>");
		}
	//	if ($j%7==0) $class=($class=="trlight"?"trdark":"trlight");
	//	$j++;
		$class=(date("W",strtotime($row['d']))%2?"trlight":"trdark");
		$cumul+=$row['c'];
		OutputClass::rawoutput("<tr class='$class'><td>{$row['d']}</td><td>&nbsp;&nbsp;</td><td><img src='images/trans.gif' width='{$row['c']}' border='1' height='5'>{$row['c']}</td><td>&nbsp;&nbsp;</td><td align='right'>$cumul</td></tr>");
		$odate = $row['d'];
	}
	OutputClass::rawoutput("</table>");
}
PageParts::page_footer();
?>