Latest XX Threads on Forumhome Page

This hack will add your latest xx threads to your forum home page.
The good part is that you can do all this with only 1 query.

The following options are available:
- number of threads displayed
- alternating background color (same like the showthread view)
- thread's title (with link)
- thread's title lenght (just in case you use it in a small table)
- thread's icon
- thread's date and time
- thread's starter (with link)
- thread's no. of views
- thread's no. of replies

[high]The hack uses each forum's permissions.[/high]
In other words, if you have a private forum, your private threads will not show unless you have permissions to view them.

ESTIMATED INSTALL TIME: 5 minutes
REQUESTED BY: Nobody
TESTED IN VERSION: 2.2.7

To download the latest version of this hack, click below:

[Kathy]

Okay, can I just allow for the last XX threads from two forums I select?

We have many many forums but I have been using includes from way way long ago to include the last 4 posts from one forum, another last four posts from anothe forum...

Way way too many queries.

Any ideas? thanks!

[Floris]

Hi there TECK,

In your first post I read:

The hack uses each forum's permissions.
In other words, if you have a private forum, your private threads will not show unless you have permissions to view them.

But after installing the hack on 2.2.9 I shows as (see screenshot) with a thread from the moderators board.

The moderators board is not viewable by the guest, it will not appear on the forumhome - but it looks like the thread does.

What might I have overlooked?

btw - i clicked installed.

Two other things;

Would it be possible to have the forums from where the thread come from listed on the third row?
Like: <smalltext> Views: xxx - Replies: yyy - From forum: zzz </smalltext>

And,
If we would only like 5 threads from only 1 specific forum, what should I do? I didn't quite understand that array story. Let's say the forumid is 666 - could you advice where to change what on index.php

[TECK]

Ya the script doesnt use the access masks, since they add several queries. So you will need to set that forum the normal way, with permissions, instead of using access masks.

[Floris]

Originally posted by TECK
Ya the script doesnt use the access masks, since they add several queries. So you will need to set that forum the normal way, with permissions, instead of using access masks.

I thought the normal way was just by editing the forum and set it to private, so it won't appear for the rest but the usergroups who have permission?

Posting Options
Private forum
(Invisible to all except moderators and admins; user access masks must be on!)
Yes

I wouldn't like to go and change the way it is run now. But if we can give it to only view a given forum, then I wouldn't have to change it.

Thank you for your quick reply though. (I updated my previous post, you were too quick for me hehe)

[TECK]

That's what I ment. This way, you use access masks and you add 2 extra queries to all your pages. The wise way is to set the permissions for that forum, for each usergroup. It should take you 1minute. And you will save 2 queries.

[Floris]

Originally posted by TECK
That's what I ment. This way, you use access masks and you add 2 extra queries to all your pages. The wise way is to set the permissions for that forum, for each usergroup. It should take you 1minute. And you will save 2 queries.

But that is how it is done now ; forums > modify > edit mod forum > private: yes.
That is why I pasted it.
uhm,
could be that they do not have to option for 'use access masks' set to on?

[TECK]

Yes they do. Is in vBulletin options. But I don't recommend to anyone to use it, since it ads queries. That's no good, IMO.
The best way to make a forum private is this (I use it on my board):

Make sure your access masks are OFF:
vBulletin Options > User and registration options > Enable Access Masks? > No

Also, make sure you forum is not set as "private" (for mods and admins):
Forums & Moderators > Modify > Your Private Forum [edit]
Private forum
(Invisible to all except moderators and admins; user access masks must be on!)
Set it to NO.

Once done, do this:
Forums & Moderators > Permissions > Your Private Forum
(COPPA) Users Awaiting Moderation [edit] > Click on [edit]
Select "Use custom settings" > Set to "No" all options > Save Settings

Repeat this step for every group you don't want them to have access to your forum.

Your board will run alot faster and your threads will be hidden.
Let me know if you got any other questions.

[Floris]

Originally posted by xiphoid
Two other things;

Would it be possible to have the forums from where the thread come from listed on the third row?
Like: <smalltext> Views: xxx - Replies: yyy - From forum: zzz </smalltext>

And,
If we would only like 5 threads from only 1 specific forum, what should I do? I didn't quite understand that array story. Let's say the forumid is 666 - could you advice where to change what on index.php

^------- I still have those 2 questions I hope you have some time.

[TECK]

1. You can't add the forum title, unless you do a query on the loop. You will end up with 40-50 queries... or you write a function for this...
2. Find:

$threads=$DB_site->query("SELECT * FROM thread WHERE open='1' AND open<>10 $iforumperms

Replace with:

$threads=$DB_site->query("SELECT * FROM thread WHERE open='1' AND open<>10 AND forumid=xx

where xx is your unique forum you want to grab the threads from.

[GTGT]

Do I understand correcly that I can use this to draw the latest theeads tyo any other page on the site?

I want my vbulletin threads also come up on my start site

xxxx.com/index.html

Can I use this for that?

And is it fast?

Thanmks for any help!