",true); output("NameReferrals",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"; } // if ($j%7==0) $class=($class=="trlight"?"trdark":"trlight"); // $j++; $class=(date("W",strtotime($row['d']))%2?"trlight":"trdark"); $cumul+=$row['c']; $output.=""; $odate = $row['d']; } $output.="
0$cumul
{$row['d']}{$row['c']}$cumul
"; page_footer(); ?>