# News holen
$result = @mysql_db_query ("lbr","SELECT * FROM lbr_News ORDER BY Date DESC LIMIT 5")
or die ("Could not select news");
# News fetchen und ausgeben
while ($row = @mysql_fetch_array ($result))
{
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo ''."\n";
echo '| '.strftime ("%d. %B %Y %H:%M", $row["Date"]).' | '."\n";
echo ' '.$row["Subject"].' | '."\n";
echo ' '.$row["Nickname"].' | '."\n";
echo ' '."\n";
echo ' '."\n";
echo ''."\n";
echo ''.$row["Text"].'
| '."\n";
echo ' '."\n";
echo ' | '."\n";
echo ' '."\n";
}
?>
|
Status:
# Anzahl der letzten Partys holen
$DateOffset = 7 * 24 * 60 * 60;
$result = @mysql_db_query ("lbr","SELECT COUNT(*) FROM lbr_Partys WHERE Date > (UNIX_TIMESTAMP() - $DateOffset)")
or die ("Could not select partycount");
# Anzahl fetchen und ausgeben
$row = @mysql_fetch_array ($result);
echo ''."\n";
echo $row[0].' neue Party';if ($row[0] <> 1) echo 's';
echo ' '."\n";
# Geburtstage holen
$result = mysql_db_query ("lbr","SELECT Name, FROM_UNIXTIME(Birthday,'%e.%c') as Birthday FROM lbr_Members WHERE (MONTH(FROM_UNIXTIME(Birthday)) = MONTH(NOW()) AND DAYOFMONTH(FROM_UNIXTIME(Birthday)) >= DAYOFMONTH(NOW())) OR (MONTH(FROM_UNIXTIME(Birthday)) = MONTH(DATE_ADD(NOW(), INTERVAL 1 MONTH)))");
//or die ("Could not select birthdays");
# Geburtstage fetchen und ausgeben
echo '
Geburtstage:
';
if (mysql_num_rows($result) == 0)
echo 'keine';
else
while ($row = @mysql_fetch_array ($result))
{
echo $row["Name"].' am '.$row["Birthday"];
echo ' '."\n";
}
?>
|
|
|