vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Howto: have the 10 newest posts on my homepage (https://vborg.vbsupport.ru/showthread.php?t=155220)

jer2eydevil88 08-14-2007 04:02 PM
Howto: have the 10 newest posts on my homepage
 
I would like to have the 10 newest posts titles show up on the homepage for my site, the best idea I can come up with is to use an rss feed reader (although I don't think the forum software supports feeds) or something equivalent to that unless someone has a better idea.

nico_swd 08-14-2007 09:36 PM
Quote:
Originally Posted by jer2eydevil88 (Post 1317436)
(although I don't think the forum software supports feeds)
https://vborg.vbsupport.ru/faq.php?f...ss_syndication

EnIgMa1234 08-14-2007 10:13 PM
Create a new plugin

Product: vBulletin
Hook: forumhome_complete

In the box add:
PHP Code:
$query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread ORDER BY lastpost DESC LIMIT 10");

while ($last = $vbulletin->db->fetch_array($query))
{
$lasttitle = $last['title']<br />;
} 
Now you can use $lasttitle in your forumhome template

amnesia623 09-03-2007 10:36 PM
This only displays one 'latest thread'

Is there a way to fix it?
Thanks!

Opserty 09-04-2007 10:09 AM
He forgot a '.' :p
PHP Code:
$query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread ORDER BY lastpost DESC LIMIT 10");

while ($last = $vbulletin->db->fetch_array($query))
{
// If you want to link to the thread to use $lasttitle .= '<a href="showthread.php?t='. $last['threadid'] .'">'. $last['title'] .'</a><br />';
$lasttitle .= $last['title']<br />;
} 

amnesia623 09-04-2007 03:20 PM
AHH...thank you!

How would you go about coding this to follow forum permissions?

I really appreciate any help!

amnesia623 02-02-2008 04:44 PM
Does this still work in 3.7? I can't seem to get it to work...

mrkhm 04-12-2008 10:30 PM
thank you this works perfectly in vb 3.6.x

quick question for anyone is there anyway to limit it to only show titles from specific forums should i be doing

select * from where something something is = to something

thanks anyway

Opserty 04-13-2008 08:50 AM
Quote:
Originally Posted by mrkhm (Post 1489369)
thank you this works perfectly in vb 3.6.x

quick question for anyone is there anyway to limit it to only show titles from specific forums should i be doing

select * from where something something is = to something

thanks anyway
Change the MySQL query to:
[sql]
SELECT title, threadid FROM ". TABLE_PREFIX ."thread WHERE forumid IN (X, Y, Z) ORDER BY lastpost DESC LIMIT 10"[/sql]

Change [minicode]title, threadid[/minicode] to * if you want to select all fields.

X, Y, Z Being a comma separated list of the ForumID numbers.

mrkhm 06-27-2008 08:45 AM
ahhh! many thanks opserty! that works absolutely absolutely perfectly

callumbush 06-29-2008 04:15 PM
Hi all,

I've created the plugin, but I don't understand the part about putting $lasttitle in my forumhome template.

I tried deleting everything in <!-- main --> in forumhome, and replacing it with '$lasttitle', but it looks like that wasn't correct :P

Please help :)

Callum

p.s. In case its relevant, I'm currently using vBulletin 3.7.0

Opserty 06-29-2008 04:30 PM
Just type $lasttitle into your FORUMHOME template.

BANDiT600 06-29-2008 04:37 PM
And how to put this on non-vBulletin page??? I want to use last 10 posts in forum on a main page of my site.

callumbush 06-29-2008 04:48 PM
Quote:
Originally Posted by Opserty (Post 1562193)
Just type $lasttitle into your FORUMHOME template.
It doesn't appear to do anything to my homepage.

Where should I include it? Here's my FORUMHOME

Code:
$stylevar[htmldoctype]
<html xmlns="http://www.w3.org/1999/xhtml" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
        <!-- no cache headers -->
        <meta http-equiv="Pragma" content="no-cache" />
        <meta http-equiv="Expires" content="-1" />
        <meta http-equiv="Cache-Control" content="no-cache" />
        <!-- end no cache headers -->
        $headinclude
        <title>$vboptions[bbtitle]
</title>
</head>
<body>
$header
$navbar

<if condition="$show['guest']">
<!-- guest welcome message -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
        <td class="tcat"><img src="$stylevar[imgdir_misc]/tcat_tl.gif" alt="" border="0" style="position:relative; top: -7px; left: -7px; float:left;" />
<img src="$stylevar[imgdir_misc]/tcat_tr.gif" alt="" border="0" style="position:relative; top: -7px; left: 7px; float:right;" />
<phrase 1="$vboptions[bbtitle]">$vbphrase[welcome_to_the_x]</phrase></td>
</tr>
<tr>
        <td class="alt1">
                <phrase 1="faq.php$session[sessionurl_q]" 2="register.php$session[sessionurl_q]">$vbphrase[first_visit_message]</phrase>
        </td>
</tr>
</table>
<div class="bcorner"><div class="bcrn-c"><div class="bcrn-l"></div><div class="bcrn-r"></div></div></div>
<!-- / guest welcome message -->
<br />
</if>

<!-- main -->

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
$forumbits
<tbody>
        <tr>
                <td class="tfoot" align="center" colspan="<if condition="$vboptions['showmoderatorcolumn']">6<else />5</if>"><div class="smallfont"><strong>
                        <a href="forumdisplay.php?$session[sessionurl]do=markread" rel="nofollow">$vbphrase[mark_forums_read]</a>
                        <if condition="$vboptions['forumleaders']">&nbsp; &nbsp;
                        <a href="showgroups.php$session[sessionurl_q]">$vbphrase[view_forum_leaders]</a></if>
                </strong></div></td>
        </tr>
</tbody>
</table>
<div class="bcorner"><div class="bcrn-c"><div class="bcrn-l"></div><div class="bcrn-r"></div></div></div>
$forumhome_markread_script
<!-- /main -->

<br />
$ad_location[ad_forumhome_afterforums]
<br />

<!-- what's going on box -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
        <tr>
                <td class="tcat" colspan="2"><img src="$stylevar[imgdir_misc]/tcat_tl.gif" alt="" border="0" style="position:relative; top: -7px; left: -7px; float:left;" />
<img src="$stylevar[imgdir_misc]/tcat_tr.gif" alt="" border="0" style="position:relative; top: -7px; left: 7px; float:right;" />
$vbphrase[whats_going_on]</td>
        </tr>
</thead>
<if condition="$show['loggedinusers']">
<!-- logged-in users -->
<tbody>
        <tr>
                <td class="thead" colspan="2">
                        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_activeusers')"><img id="collapseimg_forumhome_activeusers" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_activeusers].gif" alt="" border="0" /></a>
                        <a href="online.php$session[sessionurl_q]">$vbphrase[currently_active_users]</a>: $totalonline (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)
                </td>
        </tr>
</tbody>
<tbody id="collapseobj_forumhome_activeusers" style="$vbcollapse[collapseobj_forumhome_activeusers]">
        <tr>
                <td class="alt2"><a href="online.php$session[sessionurl_q]"><img src="$stylevar[imgdir_misc]/whos_online.gif" alt="$vbphrase[view_whos_online]" border="0" style="padding: 10px;" /></a></td>
                <td class="alt1" width="100%">
                        <div class="smallfont">
                                <div style="white-space: nowrap"><phrase 1="$recordusers" 2="$recorddate" 3="$recordtime">$vbphrase[most_users_ever_online_was_x_y_at_z]</phrase></div>
                                <div>$activeusers</div>
                        </div>
                </td>
        </tr>
</tbody>
<!-- end logged-in users -->
</if>
<tbody>
        <tr>
                <td class="thead" colspan="2">
                        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_stats')"><img id="collapseimg_forumhome_stats" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_stats].gif" alt="" border="0" /></a>
                        <phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase>
                </td>
        </tr>
</tbody>
<tbody id="collapseobj_forumhome_stats" style="$vbcollapse[collapseobj_forumhome_stats]">
        <tr>
                <td class="alt2"><img src="$stylevar[imgdir_misc]/stats.gif" alt="<phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase>" border="0" style="padding: 10px;" /></td>
                <td class="alt1" width="100%">
                <div class="smallfont">
                        <div>
                                $vbphrase[threads]: $totalthreads,
                                $vbphrase[posts]: $totalposts,
                                $vbphrase[members]: $numbermembers<if condition="$show['activemembers']">,
                                        <span title="<phrase 1="$vboptions[activememberdays]">$vbphrase[within_the_last_x_days]</phrase>">$vbphrase[active_members]: $activemembers</span>
                                </if>
                        </div>
                        <div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
                </div>
                </td>
        </tr>
</tbody>
<if condition="$show['birthdays']">
<!-- today's birthdays -->
<tbody>
        <tr>
                <td class="thead" colspan="2">
                        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_birthdays')"><img id="collapseimg_forumhome_birthdays" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_birthdays].gif" alt="" border="0" /></a>
                        $vbphrase[todays_birthdays]
                </td>
        </tr>
</tbody>
<tbody id="collapseobj_forumhome_birthdays" style="$vbcollapse[collapseobj_forumhome_birthdays]">
        <tr>
                <td class="alt2"><a href="calendar.php?$session[sessionurl]do=getday&amp;day=$today&amp;sb=1"><img src="$stylevar[imgdir_misc]/birthday.gif" alt="$vbphrase[view_birthdays]" border="0" style="padding: 10px;" /></a></td>
                <td class="alt1" width="100%"><div class="smallfont">$birthdays</div></td>
        </tr>
</tbody>
<!-- end today's birthdays -->
</if>
<if condition="$show['upcomingevents']">
<tbody>
        <tr>
                <td class="thead" colspan="2">
                        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_events')"><img id="collapseimg_forumhome_events" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_events].gif" alt="" border="0" /></a>
                        <if condition="$show['todaysevents']">$vbphrase[todays_events]<else /><phrase 1="$vboptions[showevents]">$vbphrase[upcoming_events_for_the_next_x_days]</phrase></if>
                </td>
        </tr>
</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
        <tr>
                <td class="alt2"><a href="calendar.php$session[sessionurl_q]"><img src="$stylevar[imgdir_misc]/calendar.gif" alt="$vbphrase[calendar]" border="0" style="padding: 10px;" /></a></td>
                <td class="alt1" width="100%"><div class="smallfont">$upcomingevents</div></td>
        </tr>
</tbody>
</if>
</table>
<div class="bcorner"><div class="bcrn-c"><div class="bcrn-l"></div><div class="bcrn-r"></div></div></div>
<br />
<!-- end what's going on box -->

<!-- icons and login code -->
<table cellpadding="0" cellspacing="2" border="0" width="100%">
<tr valign="bottom">
        <td>
                <table cellpadding="2" cellspacing="0" border="0">
                <tr>
                        <td><img src="$stylevar[imgdir_statusicon]/forum_new.gif" alt="$vbphrase[contains_new_posts]" border="0" /></td>
                        <td class="smallfont">&nbsp; $vbphrase[forum_contains_new_posts]</td>
                </tr>
                <tr>
                        <td><img src="$stylevar[imgdir_statusicon]/forum_old.gif" alt="$vbphrase[contains_no_new_posts]" border="0" /></td>
                        <td class="smallfont">&nbsp; $vbphrase[forum_contains_no_new_posts]</td>
                </tr>
                <if condition="$vboptions['showlocks']">
                <tr>
                        <td><img src="$stylevar[imgdir_statusicon]/forum_old_lock.gif" alt="$vbphrase[a_closed_forum]" border="0" /></td>
                        <td class="smallfont">&nbsp; $vbphrase[forum_is_closed_for_posting]</td>
                </tr>
                </if>
                </table>
        </td>
        <if condition="!$show['guest']">
                <!-- member logout -->
                <td align="$stylevar[right]"><a href="login.php?$session[sessionurl]do=logout&amp;logouthash=$bbuserinfo[logouthash]"  onclick="return log_out('$vbphrase[sure_you_want_to_log_out]')"><phrase 1="$bbuserinfo[username]">$vbphrase[log_out_x]</phrase></a></td>
                <!-- end member logout -->
        </if>
</tr>
</table>
<!-- / icons and login code -->

$footer
</body>
</html>

And here's the plugin I created (I've checked its active!):

Code:
$query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread ORDER BY lastpost DESC LIMIT 10");

while ($last = $vbulletin->db->fetch_array($query))
{
// If you want to link to the thread to use $lasttitle .= '<a href="showthread.php?t='. $last['threadid'] .'">'. $last['title'] .'</a><br />';
$lasttitle .= $last['title']<br />;
}

mrkhm 06-29-2008 06:01 PM
hi, i remember this happening to me, it may be something simple, (just check it out) --> it could be that where you have installed the actual plug in is incorrect i.e. go into plugin manager, find $lasttitle edit it and ensure that "hook location" is "forum home complete" and that it is number "5" in order of execution.

i have literally 5 instances of lasttitle on my board, i.e. lasttitle1, lasttitle 2, for different forum categories etc and each time when the threads dont show up, it is ALWAYS the hook location that needed fiddling with, just check the hook location and then paste $lasttitle wherever in the page you want it to appear.

callumbush 06-29-2008 06:33 PM
Quote:
Originally Posted by mrkhm (Post 1562256)
hi, i remember this happening to me, it may be something simple, (just check it out) --> it could be that where you have installed the actual plug in is incorrect i.e. go into plugin manager, find $lasttitle edit it and ensure that "hook location" is "forum home complete" and that it is number "5" in order of execution.

i have literally 5 instances of lasttitle on my board, i.e. lasttitle1, lasttitle 2, for different forum categories etc and each time when the threads dont show up, it is ALWAYS the hook location that needed fiddling with, just check the hook location and then paste $lasttitle wherever in the page you want it to appear.
hey, cheers for the help :)

Okay those settings were correct, but I hadn't named the plugin title as "$lasttitle". I have now renamed it but it still doesnt work :S

Opserty 06-29-2008 07:54 PM
I don't see the $lasttitle variable in your FORUMHOME template... The plugin name is irrelevant the only things you need to worry about is the PHP code and the hook location. Both of which have been shown to work...

Are you sure you are editing the correct skin? (the same as which you are viewing)

Else try this: http://www.vbulletin.com/forum/showthread.php?t=158887


All times are GMT. The time now is 10:43 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.01230 seconds
  • Memory Usage 1,825KB
  • 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
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (17)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