Shoutbox LeftSide Module

[DGTLMIK]

I have the Shoutbox Hack found HERE installed and running and I would like to make a LeftSide Module similar to the "Latest Forum Topics" Module but only display the latest 5 shouts with:

- Username
- Shout Message
- Time Stamp

Any help would be appreciated.

[DGTLMIK]

bump...

[DGTLMIK]

My site is almost ready for launch, this is the last hack needed. Can anyone help me out here?

[Tigur]

http://www.vbadvanced.com/forum/show...light=shoutbox

[mawtenbiker]

Originally Posted by Tigur

http://www.vbadvanced.com/forum/show...light=shoutbox

If you are running a new version of VB this is not going to work.

[DGTLMIK]

Any takers? Name your price!

Here is an example of how I would like it to look...

[DGTLMIK]

Ok, making progress...

I have the 'Shout Now' button working correctly, now I just need to know how to display the Last 5 Shouts, here is my Template Code:

PHP 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>
<tr>
<td class="$getbgrow"><span class="smallfont">

<b><u>Username</u></b>
<br />
Shout Text
<br />
<i>Timestamp</i>
<br /><br />

<b><u>Username</u></b>
<br />
Shout Text
<br />
<i>Timestamp</i>
<br /><br />

<b><u>Username</u></b>
<br />
Shout Text
<br />
<i>Timestamp</i>
<br /><br />

<b><u>Username</u></b>
<br />
Shout Text
<br />
<i>Timestamp</i>
<br /><br />

<b><u>Username</u></b>
<br />
Shout Text
<br />
<i>Timestamp</i>
<br /><br />

</span>
<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="25" ><br />
<span class="smallfont">
<i>(50 Character Limit)</i>
</span><br /><br />
<input type="submit" name="submit" value="Shout Now" class="bginput" accesskey="s"></form>
</center>
</td>
</tr>    
</table>
<br /> 


Again, it will need to look like the updated attached image and NOT use iFrames.

[DGTLMIK]

More 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:

<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" >&nbsp;<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).

Brian, please help me out here, I can see the Finish Line ahead.

[DGTLMIK]

Nevermind, 'jugo' helped me out HERE.