vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   ShoutBox - vBa CMPS Module (https://vborg.vbsupport.ru/showthread.php?t=82076)

DGTLMIK 05-26-2005 04:29 PM
ShoutBox - vBa CMPS Module
 
1 Attachment(s)
I have the Shoutbox Hack found HERE installed and running and I would like to make a vBadvanced CMPS Module similar to the "Latest Forum Topics" Module but only display the latest 5 Shouts (see attached).

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 so far:
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 /> 
I prefer NOT to use iFrames if at all possible.

Thanks in advance!

DGTLMIK 06-03-2005 01:36 PM
1 Attachment(s)
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" >&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).

jugo 06-03-2005 02:21 PM
I think your code has to look something like this:

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('$shoutboxbits .= "' . fetch_template('adv_portal_shoutboxbits') . '";');
}

eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_portal_shoutbox') . '";');

?>

adv_portal_shoutbob

HTML 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 />

$shoutboxbits

<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 />

adv_portal_shoutboxbits

HTML Code:
<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>
I think....someone please correct me if I'm wrong.

As for the alternating colors, I can't remember the code for that off the top of my head, but if you look through the latest posts block it should be in there.

DGTLMIK 06-03-2005 02:33 PM
jugo, you rock! That did the trick, thank you very much! :up:

Chris Croft 06-08-2005 12:31 PM
WHats the SQL Query that I can run for the database?

xfaethorx 06-09-2005 06:32 PM
this is great but i'd like to get this to refresh in an iframe just the same way the main shoutbox works. What would i have to add to do that?


All times are GMT. The time now is 03:50 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01924 seconds
  • Memory Usage 1,792KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_html_printable
  • (3)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete