Making progress...
Here is my PHP code:
PHP Code:
<?php
$latestshouts = $DB_site->query("
SELECT s.*, u.username AS absusername
FROM " . TABLE_PREFIX . "shoutbox_posts s
LEFT JOIN " . TABLE_PREFIX . "user u ON (s.userid=u.userid)
WHERE (deleted='0' OR deleted IS NULL)
ORDER BY time DESC LIMIT 5
");
while ($shoutbox_post=$DB_site->fetch_array($latestshouts)) {
$shoutbox_post_user = $shoutbox_post['username'];
$shoutbox_post_text = $shoutbox_post['text'];
$shoutbox_text = parse_bbcode2("$shoutbox_post_text", $vboptions['shoutbox_allowhtml'], $vboptions['shoutbox_allowimage'], $vboptions['shoutbox_allowsmilies'], $vboptions['shoutbox_allowbbcode'], 0, 1);
$shoutbox_post_date = vbdate($vboptions['dateformat'], $shoutbox_post['time'], 1);
$shoutbox_post_time = vbdate($vboptions['timeformat'], $shoutbox_post['time']);
}
eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_portal_shoutbox') . '";');
?>
Here is my new Template Code:
Code:
<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<tr>
<td class="tcat"><span class="smallfont"><b>$vba_options[portal_blockbullet] <a href="$vboptions[bburl]/shoutbox.php?">Shoutbox</a></b></span></td>
</tr>
<if condition="!$bbuserinfo['userid']">
<tr><td class="$getbgrow"><span class="smallfont">Registered Members can use the Shoutbox here.<br /><br /><phrase 1="$vboptions[bburl]">$vbphrase[not_a_member_yet_register_now]</phrase></span></td></tr>
<else />
<tr><td class="alt2"><span class="smallfont">
<u>$shoutbox_post_user</u>:<br />
$shoutbox_text<br />
<i>$shoutbox_post_date @ $shoutbox_post_time</i>
</span></td></tr>
<tr><td class="alt1" align="center">
<form action="$vboptions[bburl]/shoutbox.php?" method="post"><input type="hidden" name="do" value="addshout"><input type="text" class="bginput" name="message" value="" size="17" > <input type="submit" name="submit" value="Go" class="bginput" accesskey="s"></form><br />
<span class="smallfont">
<i>(50 Character Limit)</i>
</span></td></tr>
</if>
</table>
<br />
Now, the problem is it only displays the 5th Latest Shout. I want it to display the Latest 5 Shouts in alternating colors like the Latest Forum Topics Module does (see attachment).