30.10.2010, 00:50
PHP-Code:
<?php
$message = '<table border="0" cellspacing="1" cellpadding="3" class="tborder"><tr>';
$first = $db->query("SELECT * FROM `".TABLE_PREFIX."gallery_pic` ORDER BY `ID_PICTURE` DESC LIMIT 3");
while($list = $db->fetch_array($first)) {
$thumb = $list['thumbfilename'];
$picid = $list['ID_PICTURE'];
$message .= '<td rowspan="2" class="trow1" align="center" width="120"><a href="http://warriors.pytalhost.de/forum/ezgallery.php?action=view&id='.$picid.'"><img src="http://warriors.pytalhost.de/forum/gallery/'.$thumb.'" /></a></td>
<td class="trow2"><span class="smalltext">'. my_date($mybb->settings['dateformat'],$list['date']) .'</span></td>';
}
$message .= "</tr><tr>";
$first = $db->query("SELECT * FROM `".TABLE_PREFIX."gallery_pic` ORDER BY `ID_PICTURE` DESC LIMIT 3");
while($list = $db->fetch_array($first)) {
$id = $list['ID_MEMBER'];
$user = get_user($id);
$username = format_name($user['username'],$user['usergroup'],$user['displaygroup']);
$message .= '<td class="trow1"><span class="smalltext">Von <a href="http://warriors.pytalhost.de/forum/member.php?action=profile&uid='.$id.'">'.$username.'</a></span></td>';
}
$message .= "</tr></table>";
?>
Gruß (: