Forum Display Enhancements - e-steki Featured threads 1.0.1

What does this do?
This hack lets mods/admins to choose some threads as featured, enter a description (if no description entered the first post will be used) and they will be displayed at forumdisplay, in the position that the admin selected. Refer to the Features section below for more information.

Features

Admin Features

1. Absolutely NO template modifications and you even get to control where the table will be placed in Forumdisplay with a simple setting!
2. Fully phrased.
3. Ability to set a cutoff limit, so that if the featured threads are more than X, the rest will not show.
4. Ability to specify whether the featured threads will be ordered by the date they were featured, their last post date or their creation date.
5. Ability to specify whether html, bbcode, [img] tags or smilies will be shown in the description (or the first post if no description has been entered).
6. When featuring/un-featuring a thread, the action is logged in the moderator log.
7. A nice, usable and extensive manual instead of an ugly readme.txt ;-)

End user / moderator Features

1. Moderators can enter a fully formatted description with bbcodes and everything (if allowed by the admin)
2. The table is collapsible, and if it has nothing to display it doesn't show.
3. Thread elements that are displayed: Thread icon, Title, Link to the thread, creation date and time, number of replies (clickable), thread poster.

Don't forget to Mark as Installed!
Support will be provided only for a few days after each release.
Installation instructions and a FAQ are in the manual.

[Lea Verou]

First post reserved.

[MaestroX]

Hi Michelle,

Just wanted to say a great release. I was considering conding one myself a short while ago but didn't have the time on my hands.

Anychance of vbadvanced support?

[Lea Verou]

Originally Posted by MaestroX

Hi Michelle,

Just wanted to say a great release. I was considering conding one myself a short while ago but didn't have the time on my hands.

Anychance of vbadvanced support?

Thanks
What do you mean as vbadvanced support?

[bobster65]

Originally Posted by Michelle

Thanks
What do you mean as vbadvanced support?

Im guessing that a vba module for this would be what is wanted... that would be a nice addition to this..

[simunaqv]

He probably means a vbadvanced module for showing featured threads.

[Lea Verou]

But if he wants to show ALL featured threads in one module, he can do it already with the news module I think, he will just have to re-select them for it.
This was designed to be forum-specific, so I can't really understand the use of a vba module.

[Kaleem]

Installed good work

[Lea Verou]

Thanks
How did the installation go?

[Kalina]

Hi Michelle, this seems to be a great plugin but it gave me a database error, I installed it, set the options and when I went to view one of my forums I got a database error. I am running vbulletin 3.6.8.

Here's the error:

Warning: Invalid argument supplied for foreach() in /forumdisplay.php(987) : eval()'d code on line 87

Warning: implode() [function.implode]: Bad arguments. in /forumdisplay.php(987) : eval()'d code on line 95

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
thread.threadid,
thread.title,
thread.postuserid as posterid,
thread.postusername as poster,
thread.dateline,
thread.replycount,
thread.isfeatured,
thread.fdesc,
thread.iconid,
post.pagetext
FROM thread as thread
LEFT JOIN post as post ON(post.postid = thread.firstpostid)
WHERE
thread.isfeatured = 1
AND thread.forumid IN ()
ORDER BY fdate DESC
LIMIT 3;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY fdate DESC
LIMIT 3' at line 16
Error Number : 1064
Date : Wednesday, August 15th 2007 @ 10:28:29 AM
Script : http://www.webtalkforums.com/forumdisplay.php?f=53
Referrer : http://www.webtalkforums.com/
IP Address : xx.xxx.xxx.xxx
Username : Colleen
Classname : vb_database