" . $titeltext . "
";
echo "\n";
$i = 0;
$result = sql_query("SELECT p.*, u.uid as user_id, u.uname as user_name FROM ${prefix}_pinwand AS p LEFT JOIN {$user_prefix}_users AS u ON p.uid = u.uid ORDER BY p.datum");
while ($row = sql_fetch_assoc($result)) {
$i++;
$x = mt_rand(0, $maxbreite - 200);
$y = mt_rand(30, $maxhoehe);
if ($checktime && $row['vorlauf'] && $row['vorlauf'] < time()) {
sql_query("DELETE FROM ${prefix}_pinwand WHERE `id` = " . intval($row['id']));
continue;
}
$lefttime = '';
if ($checktime && $showremtime) {
if (time() > $row['vorlauf']) {
$lefttime = _PWTIMELEFT . ': ' . _PWNOTDEFINED;
} else {
$pwdays = floor(($row['vorlauf'] - time()) / (60 * 60 * 24));
$pwhours = floor((($row['vorlauf'] - time()) / (60 * 60)) % 24);
$lefttime = _PWTIMELEFT . ': ' . $pwdays . ' ' . _PMDAYS . ', ' . $pwhours . ' ' . _PMHOURS;
}
}
$username = '';
if ($showlinktoaccount && $row['user_name']) {
$username = mxCreateUserprofileLink($row['user_name'], $row['user_name'], _PWPROFILE);
}
if (!$username && $row['email']) {
$username = '
' . $row['name'] . '';
}
if (!$username) {
$username = $row['name'];
}
$buttons = '';
if (($uid == $row['user_id'] && $postercandelete) || MX_IS_ADMIN) {
$buttons .= '
' . $img_dele . ' ';
}
if (($uid == $row['user_id'] && $darfpostereditieren) || MX_IS_ADMIN) {
$buttons .= '
' . $img_edit . ' ';
}
$datum = mx_strftime(_XDATESTRING, $row['datum']);
$text = nl2br(pinwand_desmile(mxPrepareToDisplay(wordwrap2($row['text'], 24, ' ', true))));
if (MX_IS_ADMIN) {
$ip = ($row['ipnumber']);
}
echo '
'
. '
'
. '
'
. '
' . $username . ',
' . $datum . ''
. '
' . $text . '
'
. '
' . $buttons . $lefttime .'
'
. '
'. $ip .'
'
. '
'
. '
' . "\n";
}
echo "