Coder Forum

PHP Quellcode

<?php
//Datenbankverbindung
$dbUser = "---"; //Datenbank UserName
$dbPW = "---"; //Datenbank Passwort
$dbName = "---"; //Name der Datenbank
$forumPath = "/forum/"; //Relativer Pfad zum Forum
mysql_connect("localhost", $dbUser, $dbPW);
mysql_select_db($dbName);
 
//Queries
$sql_users = "SELECT COUNT(*) AS users FROM wcf1_user";
$sql_threads = "SELECT COUNT(*) AS threads FROM wbb1_1_thread";
$sql_posts = "SELECT COUNT(*) AS posts FROM wbb1_1_post";
$sql_newUser = "SELECT userID, username FROM wcf1_user ORDER  BY registrationDate DESC LIMIT 1";
$sql_installDate = "SELECT optionValue FROM wcf1_option WHERE optionName = 'install_date'";
 
//mysql Datenbank Abfragen senden
 
//Anzahl User
$users = mysql_fetch_assoc(mysql_query($sql_users)) or die (mysql_error());
//Anzahl Themen
$threads = mysql_fetch_assoc(mysql_query($sql_threads)) or die (mysql_error());
//Anzahl Beiträge
$posts = mysql_fetch_assoc(mysql_query($sql_posts)) or die (mysql_error());
//Neustes Mitglied
$newUser = mysql_fetch_assoc(mysql_query($sql_newUser)) or die (mysql_error());
//Installationsdatum 
$installDate = mysql_fetch_assoc(mysql_query($sql_installDate)) or die (mysql_error());
 
//Alter in Tagen ermitteln
$age = (time() - $installDate['optionValue']) / (3600*24);
//Beiträge pro Tag
$postsPerDay = round($posts['posts'] / $age, 2);
 
//Ausgabe
echo '<b>Registrierte Benutzer: </b>'.$users['users'].'<br />';
echo '<b>Themen: </b>'.$threads['threads'].'<br />';
echo '<b>Beitr&auml;ge: </b>'.$posts['posts'].' ('.$postsPerDay.'/ Tag)<br />';
echo '<b>Neuester User: </b><a href="'.$forumPath.'index.php?page=User&amp;userID='.$newUser['userID'].'">'.$newUser['username'].'</a><br />';
?>