require_once "common.php";
isnewday(2);
page_header("Stats");
addnav("G?Zurück zur Grotte","superuser.php");
addnav("W?Zurück zum Weltlichen","village.php");
addnav("Aktualisieren","stats.php");
$sql = "SELECT sum(gentimecount) AS c, sum(gentime) AS t, sum(gensize) AS s, count(*) AS a FROM accounts";
$result = db_query($sql);
$row = db_fetch_assoc($result);
output("`b`%Für existierende Accounts:`b`n");
output("`@Accounts insgesamt: `^".number_format($row['a'])."`n");
output("`@Treffer insgesamt: `^".number_format($row['c'])."`n");
output("`@Seitengenerierungszeit insgesamt: `^".dhms($row['t'])."`n");
output("`@Seitengenerierungsgröße insgesamt: `^".number_format($row['s'])."b`n");
output("`@Durchschnittliche Seitengenerierungszeit: `^".dhms($row['t']/$row['c'],true)."`n");
output("`@Durchschnittliche Seitengröße: `^".number_format($row['s']/$row['c'])."`n");
output("`n`%`bTop Referers:`b`0`n");
output("
",true);
output("| Name | Referrals |
",true);
$sql = "SELECT count(*) AS c, acct.acctid,acct.name AS referer FROM accounts INNER JOIN accounts AS acct ON acct.acctid = accounts.referer WHERE accounts.referer>0 GROUP BY accounts.referer DESC ORDER BY c DESC";
$result = db_query($sql);
for ($i=0;$i",true);
output("`@{$row['referer']}`0 | `^{$row['c']}:`0 ", true);
$sql = "SELECT name,refererawarded from accounts WHERE referer = ${row['acctid']} ORDER BY acctid ASC";
$res2 = db_query($sql);
for ($j = 0; $j < db_num_rows($res2); $j++) {
$r = db_fetch_assoc($res2);
output(($r['refererawarded']?"`&":"`$") . $r['name'] . "`0");
if ($j != db_num_rows($res2)-1) output(",");
}
output(" | ",true);
}
output("
",true);
$sql = "SELECT count(*) AS c, substring(laston,1,10) AS d FROM accounts GROUP BY d DESC ORDER BY d DESC";
$result = db_query($sql);
output("`n`%`bDatum des letzten Logins:`b");
$output.="";
$class="trlight";
$odate=date("Y-m-d");
$j=0;
for ($i=0;$i| ".date("Y-m-d",strtotime("$odate -$x days"))." | 0 | $cumul | ";
}
// if ($j%7==0) $class=($class=="trlight"?"trdark":"trlight");
// $j++;
$class=(date("W",strtotime($row['d']))%2?"trlight":"trdark");
$cumul+=$row['c'];
$output.="| {$row['d']} | {$row['c']} | $cumul |
";
$odate = $row['d'];
}
$output.="
";
page_footer();
?>