Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 05-26-2005, 04:29 PM
DGTLMIK DGTLMIK is offline
 
Join Date: Feb 2005
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default ShoutBox - vBa CMPS Module

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!
Attached Images
File Type: gif ShoutBlock.gif (3.6 KB, 0 views)
Reply With Quote
  #2  
Old 06-03-2005, 01:36 PM
DGTLMIK DGTLMIK is offline
 
Join Date: Feb 2005
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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'], 01);
            
$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).
Attached Images
File Type: gif alt_colors.gif (4.6 KB, 0 views)
Reply With Quote
  #3  
Old 06-03-2005, 02:21 PM
jugo jugo is offline
 
Join Date: Feb 2004
Location: Reading your emails.
Posts: 573
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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'], 01);
            
$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.
Reply With Quote
  #4  
Old 06-03-2005, 02:33 PM
DGTLMIK DGTLMIK is offline
 
Join Date: Feb 2005
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

jugo, you rock! That did the trick, thank you very much! :up:
Reply With Quote
  #5  
Old 06-08-2005, 12:31 PM
Chris Croft Chris Croft is offline
 
Join Date: Mar 2005
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

WHats the SQL Query that I can run for the database?
Reply With Quote
  #6  
Old 06-09-2005, 06:32 PM
xfaethorx's Avatar
xfaethorx xfaethorx is offline
 
Join Date: May 2004
Posts: 138
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:09 AM.


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.03662 seconds
  • Memory Usage 2,285KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_html
  • (3)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (2)postbit_attachment
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete