Add-On Releases - Feature Threads [Archive]

View Full Version : Add-On Releases - Feature Threads

Adrian.

10-08-2006, 10:00 PM

Feature Threads
By Adrian at Dreamit.co.uk
Tested on 3.6.1.

Note: This modification is v0.10, It seems to be working fine.
To see why it's not V1, scroll down to the Q&A.

About:
Feature Threads allows you to "Feature a thread", and that thread will then appear on the forumhome.

It's a very useful mod' to get those important, special threads noticed.

Installation:

Download Feature_threads.zip.

Upload feature.php and unfeature.php to your forums root folder.
Import product_feature.xml.

Template Edits:
Open Forumhome Templates > FORUMHOME
Find:



Add after:

$feature_threads

Save.

Open Showthread Templates > SHOWTHREAD
Find:

<tr>
<td class="thead">$vbphrase[thread_tools]<a name="goto_threadtools"></a></td>
</tr>

Add after:

<tr>
<td class="vbmenu_option"><img class="inlineimg" src="$stylevar[imgdir_button]/subscribe.gif"

alt="Feature Thread" /> $feature_status
<input type="hidden" value="$threadinfo[threadid]" name="tid"></td>
</tr>

Save.

Done.

Easy to install. :)

Q&A
1. Why is it V0.10?
Well, when i started this mod', i had some good ideas with it, and i started to loose intrest after a while.

I got the "base" made, so i thought, "why not release it?"
So, i have. :) If i get enough installs, or a positive response to the mod', i will glady spend more time, adding the features i wanted. :)

2. Oooh...What new features?
Not too many features...things such as...

Featured Thread ordering

Order by thread date
Order by by date featured
Order by amount of replies
Custom ordering

The ability to show the featured threads on the forumhome, or on everypage.

Ability to show what information is displayed in the features thread box.

Yeh, these are pritty easy to do, i just don't have the dedication i need to make them, like i said, if i get a good response, expect to see them soon. :)

3. How many usergroups...?
The option, that allows you to choose certain usergroups to access this mod', is limited to 12 different usergroups.

Not because i'm being mean, i just did the usergroup permission, in my code useing explode and arrays.

Don't ask why, i just did. : /
That will be improved when/if V1 is released.

Changelog
0.10 - Release.

0.11 - Set default value on "Show x" option to 4, to stop confusion with mysql_errors

0.12 - Edited Enable/Disable option from Radio buttons, to a simple Yes / No boolean to avoid errors.

---

If you installed this modification, please click install (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=128644). :)

Thanks.

Adrian

smsmasters

10-09-2006, 02:18 PM

Wow, nice, I will try it now!

Allan

10-09-2006, 02:24 PM

Good idea ;)

smsmasters

10-09-2006, 02:24 PM

Works great with 3.6.2 :D

Check it out here: http://www.smsmasters.co.uk/forum/

smsmasters

10-09-2006, 02:26 PM

Just wondering, where are the featured thread descriptions stored and how do I edit the templates for this hack? I want to align the text in the box.

Snake

10-09-2006, 02:56 PM

Sounds interesting. I'll check it out soon...

Adrian.

10-09-2006, 03:46 PM

Just wondering, where are the featured thread descriptions stored and how do I edit the templates for this hack? I want to align the text in the box.

Where are they sorted? Do you mean stored?

The featured descriptions are saved in a row called "ftdescriptions" in the "thread" table. :)

To edit the templates for the box, the HTML is in the plugin, called "Feature."
If you are going to edit the template via the Plugin code, remember not to add a " in your HTML, ' are fine. :)

Adrian

kushal

10-09-2006, 05:19 PM

How does this compare to favourite mod. Even though it being good mod, it confuses me More...which one to use. :(

smsmasters

10-09-2006, 08:33 PM

Where are they sorted? Do you mean stored?

The featured descriptions are saved in a row called "ftdescriptions" in the "thread" table. :)

To edit the templates for the box, the HTML is in the plugin, called "Feature."
If you are going to edit the template via the Plugin code, remember not to add a " in your HTML, ' are fine. :)

Adrian

Thank you very much! :)

Adrian.

10-10-2006, 08:08 AM

How does this compare to favourite mod. Even though it being good mod, it confuses me More...which one to use. :(

Well, they are two different sort of modifications.

vB Favorites will let you "favorite" the thread, and will show up in your User CP to you...

Feature threads lets you, feature a thread, which then gets displayed on the forumhome page, for everyone to see...it's just to make important threads stand out. :)

Adrian

thenetbox

10-10-2006, 10:25 AM

Thank you so much! I've been looking for something like this since months :)

spazz191

10-10-2006, 12:07 PM

I get the following error when installed on 3.6.2:

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 '' at line 1
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /index.php(63) : eval()'d code on line 6

any idea what that is from?
It goes away when I disable the product.

Adrian.

10-10-2006, 12:25 PM

dutchbb

10-10-2006, 01:59 PM

I have a question: when I select to show a max of 10 threads, and I have featured 11, will that first oldest one automatically be removed?

If not, is it possible to make it that way, someting like "the latest featured threads" so you don't have to delete the oldest one to add a new.

This is a great hack, I'm doing this work manually now and it's something I have been looking for.

spazz191

10-10-2006, 02:12 PM

Go to vBulletin Options > Feature Thread.
Where it says, "Show x Threads", enter a number.

It should work fine, if not, post here. :)

Adrian

Worked like a charm, thanks.

Wonderful Hack, BTW!! :)

ymy

10-10-2006, 02:32 PM

Good idea for admin propaganda threads !

Thnaks , click install

nymyth

10-10-2006, 02:34 PM

very wierd,

after installing this product, at times my time stamps when a new post was made would show up much later than the current date, causing forumdisplay to be all outta whack. Any ideas man?

Thanks.

UPDATE: No matter, it was a conincidence that my host did an upgrade at the same time and didnt set the time/date correctly.

spazz191

10-10-2006, 06:10 PM

Just an idea for the next update..(if you decide to do one) ;) Option to make the thread bold. If that is possible

memorex

10-11-2006, 11:50 AM

Awesome hack!! Thanks!

Gizmo5h1t3

10-11-2006, 02:12 PM

slight issue, in my admin cp, under the first bit, i see no selection box for the on / off..

instead, i see this....

Set this option to Enable to enable Feature Threads. radio: piped 1|Enable 2|Disable

Adrian.

10-11-2006, 02:22 PM

slight issue, in my admin cp, under the first bit, i see no selection box for the on / off..

instead, i see this....

Ooh, sorry about that, very odd.

Anyway, if you download the attachment, and re-import the .xml file, overwriting the existing mod', it should be fixed.

I changed the option to a simple yes/no boolean. :)

Adrian

Gizmo5h1t3

10-11-2006, 02:26 PM

yep, that worked fine..
might be an idea to advise ppl to UNINSTALL the previous version, instead of just over writing the product, as it gave me a DB error.

thxs for sortin it so quickly m8

perfphysio

10-11-2006, 03:01 PM

Great, easy to use thread and I would love you to extent the simple features you mention in your initial post. One question though: All my featured threads are appearing at the bottom of my list of forums on the homepage. How can I make it appear at the top? see http://www.physiochat.com

unitedpunjab

10-11-2006, 04:06 PM

Can't We add a small thumbnail or something like that to make it look more attractive or appealing.

like unique thumbnail for every featured thread.

Adrian.

10-11-2006, 04:36 PM

Can't We add a small thumbnail or something like that to make it look more attractive or appealing.

like unique thumbnail for every featured thread.

Not a bad idea.

I will consider this if/when i release V2. :)

perfphysio

10-14-2006, 10:06 AM

For some reason my post here has vanished. My forum 3.6.2 is displaying the featured threads fine. However it is showing them at the bottom of my homepage rather than the top as in your screen shots.

Can someone advise how I rectify this issue?

Thanks, http://www.physiobob.com/forum/index.php

Adrian.

10-14-2006, 10:16 AM

perfphysio

10-14-2006, 10:37 AM

thanks, I put it under the close of the  section by mistake. Now all is great :)

unitedpunjab

10-18-2006, 08:06 AM

Not a bad idea.

I will consider this if/when i release V2. :)

Ok. Watin for V2

category

10-18-2006, 07:30 PM

nvm found it its in the plug in but you should put it in feature because i want to make rounded edges and each time i do something in the plug in my website doesnt respond

boatdesign

10-19-2006, 04:45 AM

What would it take to use this to show the featured threads on a non-vBulletin page of the site?

farooqaaa

10-20-2006, 06:19 AM

installed, what about if people can only see thier featured threads?

Gizmo5h1t3

10-20-2006, 11:49 AM

installed on 3.5...working fine

Invalid ID

10-20-2006, 01:36 PM

Better than the previous one, installed and happy :)

unitedpunjab

10-20-2006, 07:08 PM

Getting this error-

Database error in vBulletin 3.6.2:

Invalid SQL:
ALTER TABLE thread ADD
(featured text not null, ftdescription text not null
);

MySQL Error : Duplicate column name 'ftdescription'
Error Number : 1060
Date : Friday, October 20th 2006 @ 09:07:36 PM
Script : http://www.unitedpunjab.co.uk/admincp/plugin.php?do=productimport
Referrer : http://www.unitedpunjab.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username :
Classname : vb_database

Adrian.

10-20-2006, 08:15 PM

unitedpunjab

10-20-2006, 08:31 PM

Have you previously installed this mod'? or attempted.
Or installed another mod' which creates the table "ftdescription"

Adrian

yes,installed & unistalled once.
i have checked the database but cant see table 'ftdescription'

farooqaaa

10-21-2006, 04:32 AM

Dear Adrian,

is this possible to show feature threads to ur self. And no one can see ur threads. I mean every user will have his own featured thereds :rolleyes:

SF3D_Tech

10-25-2006, 07:30 PM

Quick question - is there a way to use this for thumbnails as well instead of just text? If so I'll definitely be doing an install asap!

Thanks and keep up the good work.

Cedric_FP

10-26-2006, 03:44 AM

Nice mod. Perhaps another addition to contemplate would be to allow the use of categories within the featured thread box.

sportsoutlaw

10-26-2006, 06:12 PM

Great modification. Another admin on one of my sites was asking about making a box to put important threads in so they didn't get lost and I remembered seeing this. Works Great!

Looking forward to being able to use it on forumdisplay and showthread.

dutchbb

11-03-2006, 06:33 PM

hello Adrian

Can you reply to my question in PM about paying for customisations?

You have disabled PM so I can't reach you that way.

Thanks!

thenetbox

11-06-2006, 10:54 AM

Hello :)

Do you know how I can add this to a VbAdvanced CMPS block? Thanks

criscokid

11-06-2006, 01:16 PM

Trying to add this to my vB3.5 forum I get the following error message:

Database error in vBulletin 3.5.3:
Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Feature', 'forumhome_start', '$rows = $vbulletin->options[\'featurethreads_showx\'];\r\n$query=\"select * from \" . TABLE_PREFIX . \"thread WHERE `featured` = \'featured\' limit $rows \";\r\n $merge=mysql_query($query);\r\n echo mysql_error();\r\n\r\n while($row=mysql_fetch_array($merge)){\r\n\r\n$dis play .= \"\r\n\r\n<img src=\'images/statusicon/subforum_old.gif\' border=\'0\'> <a href=\'showthread.php?t=$row[threadid]\'>$row[title]</a> - <span class=\'smallfont\'>$row[ftdescription] - \r\nBy $row[postusername]</span><br />\";\r\n\r\n}\r\n\r\nif($vbulletin->options[\'featurethreads_enabled\'] == 1) {\r\n\r\n $feature_threads = \"\r\n\r\n<table class=\'tborder\' cellpadding=\'$stylevar[cellpadding]\' cellspacing=\'$stylevar[cellspacing]\' border=\'0\' width=\'100%\' \r\n\r\nalign=\'center\'>\r\n<tr>\r\n<td align=\'center\' class=\'tcat\'>Featured Threads</td>\r\n</tr>\r\n<tr>\r\n<td class=\'alt1\'>$display</td>\r\n</tr>\r\n</table>\r\n<br>\r\n\r\n\";\r\n\r\n}', 'featured');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054

criscokid

11-06-2006, 05:56 PM

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Fixed this by adding the necessary column by hand.

thenetbox

11-06-2006, 10:09 PM

It seems as if the mod creator doesn't have access to this thread because his VB license expired.

Has any one else gotten this to work with VBadvanced CMPS? Thanks

Smoothie

11-11-2006, 12:35 AM

Work w/3.6.3?

perfphysio

11-11-2006, 07:51 AM

Work w/3.6.3?Yes this works fine in 3.6.3 :)

criscokid

11-11-2006, 10:22 AM

Has anyone tried using this in a vbPortal block? I've tried but can't get it to work - see this thread (http://www.phpportals.com/forums/showthread.php?t=17930).

I suggest that the developer of this mod take a look at that thread as it includes some information on suggested improvements to his code.

Malibu

11-17-2006, 05:44 AM

awesome hack...thanks for this...works great.

Smoothie

11-23-2006, 04:02 AM

Is anyone available to take over this mod and bring some new features onboard? It would be great to be able to show last post by, time, replies, views, etc.

MetalAges

11-23-2006, 03:28 PM

This is a great idea. I was searching for a hack to show multiple announcements but this is even better. I for one would love to see the other features added (especially the adding to every page).

Smoothie

11-23-2006, 04:13 PM

anyone else able to get this to work w 3.6.4? It does not work for me, nothing shows. All edits done, files uploaded and product imported.

Smoothie

11-23-2006, 04:48 PM

nevermind, I'm a dummy, forgot to enable it. :P

Smoothie

11-23-2006, 11:59 PM

There must be a way to show date posted of the featured threads. Can someone with a bit more knowledge in this area help?

xopek

11-26-2006, 02:36 AM

I've installed the hack but all I'm getting on a main forum page is "No database selected".

I traced it back and that's a part of 'Feature' hack when tries to do

$merge=mysql_query($query);

I guess it's doesn't have a database selected at this point, huh? Weird but that's what says. Any suggestions?

On a separate note, I've slighly enhanced the integration on 'feature thread' item into the menu. I suggest changing the second step of template editing to:

Open Showthread Templates > SHOWTHREAD
Find:

<tr>
<td class="thead">$vbphrase[thread_tools]<a name="goto_threadtools"></a></td>
</tr>

Add after:

<if condition="$show['adminoptions']">
<tr>
<td class="vbmenu_option"><img class="inlineimg" src="$stylevar[imgdir_button]/subscribe.gif" alt="Feature thread" /> $feature_status <input type="hidden" value="$threadinfo[threadid]" name="tid"></td>
</tr>
</if>

This was it does not come up with empty line in the menu for users who don't have right to feature threads.

Denis

perfphysio

11-26-2006, 06:47 AM

anyone else able to get this to work w 3.6.4? It does not work for me, nothing shows. All edits done, files uploaded and product imported.
Yeah it works for me fine in 3.6.4 but I installed it when I was on 3.6.3.

carphead

11-26-2006, 08:29 AM

When I install this hack on our board as soon as I put the code into forumhome it stops the page from loading. If I disable it the forumhome loads fine. I've tried it on four different skins (including the VB Default) and it fails.

Any ideas? I really want to install it.

Thanks.

Smoothie

11-26-2006, 01:15 PM

One of the draw backs to this is when you feature a thread and the limit for featured threads is already reached, you get no error page, it just says the thread is now featured, but it's not. It doesn't bumb off the oldest thread, it does not show an error, nothing.

leo1977

11-26-2006, 07:58 PM

Great modification. Thanks

category

12-05-2006, 03:12 AM

quesiton: what template i can make the border edits ?

SaN-DeeP

12-05-2006, 03:54 AM

Feature Request: How about giving featured threads its own new page ?
Some functionality which shall auto-pull highest rated, replied, viewed threads from last week, month, 3 months, year, till day etc. ?

criscokid

12-05-2006, 09:32 AM

Some functionality which shall auto-pull highest rated, replied, viewed threads from last week, month, 3 months, year, till day etc. ?
A great idea!

heynurse

12-05-2006, 04:19 PM

First of all, to the author great hack!

Feature Request: How about giving featured threads its own new page ?
Some functionality which shall auto-pull highest rated, replied, viewed threads from last week, month, 3 months, year, till day etc. ?
Yes, I agree, great idea, I'd love to see something like this done. It would give a great indication as to what topics are truly "hot" at a quick glance, not just the threads that certain people want to feature. But I suppose this could be a totally separate hack :)

ccmoon

12-06-2006, 12:24 AM

Great! installed.

nathanrich

12-17-2006, 05:43 AM

I'm liking this mod. Only problem is it shows featured threads even if a user doesn't have permission to view the thread. Here's the query that selects the featured threads:

$query="select * from " . TABLE_PREFIX . "thread WHERE `featured` = 'featured' limit $rows ";

What would we need to change here to make it so it only selects threads the user has permission to view?

GrendelKhan{TSU

12-20-2006, 04:28 PM

didn't find it in thread, but I'd love to see a vbadvanced featured thread module for this!! :D :)

any hopes on that? :)

dprundle

12-20-2006, 04:41 PM

thx m8, will definately click install on this one.

Hornstar

12-21-2006, 06:08 AM

I have a big request, that I really hope you may mind doing.

I would like to display the featured threads on a non vb page, but the non vb page is my homepage which has globals and all the rest on it so it is integrated with vbulletin a bit.

Basically im trying to make the homepage look more active, and this would be perfect.

Thanks.

farooqaaa

12-21-2006, 10:30 AM

This is what i am looking for....

*UN-INSTALLING.......sorry..... INSTALLING :D

MMORPGHell

12-26-2006, 09:41 PM

Where is FORUMHOME?

Edit: Sorry, I found it.

MMORPGHell

12-26-2006, 09:53 PM

I keep getting "No input file specified" when I try to feature a thread.

Magz

01-02-2007, 05:07 PM

I tried installing this a few days ago, couldnt get it to work. But, after uninstalling it, and re-adding it, its working like a charm. Just the thing i needed.

Thank you for releasing it.

Smoothie

01-02-2007, 11:28 PM

Too bad the author has gone awol. This mod could use some fine tuning.

blogtorank

02-06-2007, 05:54 PM

Great hack first off and installed!

Second, I would suggest an AJAX way of moving threads up and down in the order you would want them in... Doable?

Otherwise this is still an outstanding add to the forums!

perfphysio

02-06-2007, 05:59 PM

I totally agree, being able to order them and also assign the smiley to each individually would be great :eek:

blogtorank

02-06-2007, 06:41 PM

I'll PM the author for permission to have one of my guys edit the code per what I think would be good and share here once he gives me permission.

Smoothie

02-06-2007, 06:42 PM

I'll PM the author for permission to have one of my guys edit the code per what I think would be good and share here once he gives me permission.
Good idea because yo-adrian hasn't posted in this thread in ages.

dutchbb

02-06-2007, 10:56 PM

This what I suggest:

1. The featured threads ordered by date of first post (thread creation date). New threads on top.

2. When a maximum of 10 threads is set, new threads should be added to the top of the list, and older ones make place for them (so the oldest in the list is removed when a new thread is added).

3. The thread creation date added above every thread like this:
http://img168.imageshack.us/img168/1774/dateabovethreadbs5.gif

4. I want to display these 10 latest featured threads on the right side of my board (this is a separate custom template) , you can see what I mean on the right side of my board here just under the thumbnails: http://forum.dutchbodybuilding.com/ So a possibility to place the variable in that template.

5. The latest featured thread (only one) showed like this on forumhome:
http://img167.imageshack.us/img167/7532/topicvandeweekge7.gif

romanticyao

02-26-2007, 09:31 AM

can someone make a vbadvanced mod for this please? would be great to feature threads on cms pages.

zhabbo

02-26-2007, 05:45 PM

installed thanks

Chadi

03-02-2007, 05:40 PM

Anyone know how I can accomplish this?

- alternating row colors for more than 1 featured thread
- two columns (for cleaner layout). left = thread title | right = description

macahs

03-04-2007, 05:58 AM

For some reason this hack made my site run extremely slow. The forum was hanging up non-stop, then I uninstalled and it's back to it's normal 'fast' self again. :(

cdexs

03-18-2007, 10:11 AM

great, but can work well with 3.6.4?

Smoothie

03-18-2007, 08:36 PM

:up:great, but can work well with 3.6.4?

verrin

03-26-2007, 01:19 AM

How do you prevent registered users and guest from viewing the featured threads?

ThreeD

04-09-2007, 08:39 AM

is the current version 0.10 or 0.12? Up top it says 0.12, but the file we can download is still 0.10 ;(

Great hack though!!!

Rick

04-13-2007, 01:26 AM

nymyth

05-15-2007, 02:38 PM

3.6.6 anyone?

Peace

TheBlackPoet

06-03-2007, 12:13 PM

i cant uninstall it.... it dont work for 3.67PL1

i've tried everything i could...

i got it!!

geez!!

MaestroX

07-02-2007, 11:11 AM

May I ask how you fixed it? I'm having problems with it too

Thanks