<? include_once('./includes/config.inc.php'); include_once('./includes/functions.inc.php'); my_connect(); ///Mitglieder $result = @mysql_query("SELECT count(*) FROM bb".$n."_users WHERE activation='1'"); $row = @mysql_fetch_array($result); $members = "Mitglieder: ".$row[0]; //Neustes Mitglied $result = @mysql_query("SELECT s.*, u.username FROM bb".$n."_stats s LEFT JOIN bb".$n."_users u ON(u.userid=s.lastuserid)"); $stats = @mysql_fetch_array($result); $newestmember = "Neustes Mitglied: ".htmlconverter($stats['username']); ///Beiträge $result = @mysql_query("SELECT count(*) FROM bb".$n."_posts"); $row = @mysql_fetch_array($result); $posts = "Beiträge: ".$row[0]; ///Themen $result = @mysql_query("SELECT count(*) FROM bb".$n."_threads"); $row = @mysql_fetch_array($result); $threads = "Themen: ".$row[0]; ///Onlinetimeout $result = @mysql_query("SELECT value FROM bb".$n."_options WHERE varname = 'useronlinetimeout'"); $row = @mysql_fetch_array($result); $useronlinetimeout = $row['value']; ///Online User $result = @mysql_query("SELECT count(*) FROM bb".$n."_sessions WHERE lastactivity >= ".(time() - 60 * $useronlinetimeout)); $row = @mysql_fetch_array($result); $online = "Online: ".$row[0]; ///Installdate $result = mysql_query("SELECT value FROM bb".$n."_options WHERE varname = 'installdate'"); $row = mysql_fetch_array($result); $installdate = $row['value']; $installdays = (time() - $installdate) / 86400; if ($installdays < 1) $postperday = $stats['postcount']; else $postperday = $stats['postcount'] / $installdays; $postperday = number_format($postperday, 2, ',', '.'); $postsperday = "Beiträge pro Tag: ".$postperday; echo "$members<br>"; echo "$online<br>"; echo "$posts<br>"; echo "$threads<br>"; echo "$postsperday<br>"; echo $newestmember; my_close(); ?> |