<?php
include ('../../lib/datenbank.inc.php');
include ('../../lib/functions.lib.php');

$daten_chat = mysqli_fetch_array(db_query("SELECT * FROM ".$db_prefix."_chat_einstellungen"));
?>
<?php
$abfrage = db_query("SELECT nachricht,absender,time FROM ".$db_prefix."_chat ORDER BY id DESC LIMIT ". $daten_chat['anzahl'] ." ");
while($row = mysqli_fetch_array($abfrage)){
	$zeit = niceDate($row['time']);
	$user = mysqli_fetch_array(db_query("SELECT nickname FROM ".$db_prefix."_userdaten WHERE uid = '". mysqli_real_escape_string($sql_open,$row['absender']) ."' "));
    echo '<a href="?content=/nickpage&nick='.$user['nickname'].'">'.$user['nickname'].'</a>: '.$row['nachricht'].'<br /><i><font style="font-size:10px;">'.$zeit.'</i></font><br>';
}
?>