End-User Options - Personal Sticky Threads

What are "Personal Sticky Threads"?

Personal Sticky Threads (aka "Personal Stickies") is an Add-on for vBulletin that will allow your users to sticky threads that only they will see as stickied; these "personal stickies" will appear beneath normal sticky threads. This Hack was originally designed by Mephisteus for vBulletin 3.5, and re-released (with his permission) for vBulletin 3.7.x. This hack requires a couple of File Edits, and should be attempted by those who are comfortable editing vBulletin source files. That said, I have included modified detailed instructions that should make installation straight-forward and easy.

Special thanks are owed to Mephisteus, for allowing an updated re-release for vBulletin 3.7, and to john1744 and zendive for improving upon the query alterations. As I typically disclaim with my other Add-ons, I am generally a neophyte at this sort of stuff and I tend to modify hacks and tinker with pre-existing code to get the results that I want. That said, please use this discussion thread as a community-support and mutual learning opportunity.

Finally, if you like this hack and install it, please:

Mark this Add-on as Installed

Requirements

• vBulletin 3.7.x Series

Installation

Installation is straight-forward. Simply download the attached archive, decompress on your local hard drive, and review the Installation.txt file for the specific steps. There are, broadly, four steps:

1. Import product-personalsticky.xml
2. Upload the two images into their respective folders
3. Perform two file edits to forumdisplay.php
4. Perform four template edits to three templates.

Add-Ons

This modification can be further customized:

• Limit to Specific Usergroups (iRO Wiki, imported from 1.0.3b)

Version History

• 1.0.3c: Updated for vBulletin 3.7.3 (August 28, 2008)

[down.low]

In case no one has asked or answered this question- it works on vB 3.8.1 with no problems. Thanks for the hack- works great.

[down.low]

Originally Posted by FeatheredFriend

So i am going to ask what do I do if I don't have anything in the show thread.php folder? I have all the other edits done but this one. Thanks.

Umm, since you said .php- it would only be the forumdisplay.php file on your server that you would have to edit.

Then you have to edit the said templates- which your showthread template would not possibly be empty.

[FeatheredFriend]

Thanks down.low I am going to come up with the thought that the templet i am to edit is in my admin cp.

[Fangs404]

I just installed this on a 3.8.3 install, and it worked without any problems.

[RobbieZ]

Works on a 3.8.4 PL 1 board, but I want it to work on a Vb 4

[inciarco]

Originally Posted by mystikmedia

Darn. I tried it, but got a message about invalid SQL with this change:

===========================================================================
==== Find in forumdisplay.php
		$stickies = $db->query_read_slave("
			SELECT thread.threadid, lastpost, open
			FROM " . TABLE_PREFIX . "thread AS thread
			WHERE forumid = $foruminfo[forumid]
				AND sticky = 1
				$prefix_filter
				$visiblethreads
				$limitothers
				$globalignore
==== Replace with
		$stickies = $db->query_read_slave("
			SELECT thread.threadid, lastpost, open
			FROM " . TABLE_PREFIX . "thread AS thread
			WHERE forumid = $foruminfo[forumid]
				AND (sticky = 1
				OR threadid IN ($personalstickysq))
				$prefix_filter
				$visiblethreads
				$limitothers
				$globalignore
===========================================================================

This is the exact error if you're interested:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT thread.threadid, lastpost, open
FROM thread AS thread
WHERE forumid = 12
AND (sticky = 1
OR threadid IN ())

AND visible IN (0,1,2);

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 '))

AND visible IN (0,1,2)' at line 5
Error Number : 1064
Request Date : Wednesday, February 18th 2009 @ 03:52:55 PM
Error Date : Wednesday, February 18th 2009 @ 03:52:55 PM
Script : http://www.gadgetadvisor.com/hammerf...splay.php?f=12
Referrer :
IP Address : 71.11.83.89
Username : Gadget Advisor
Classname : vB_Database
MySQL Version : 5.0.67-community

Too bad about you not having time to support, but I can certainly understand. Good luck!

The Error is in this Line:

OR threadid IN ($personalstickysq))

It should be:

OR threadid IN ($personalstickysq)

Without the Second ")".

My Best Regards.

[john1744]

Has anyone attempted this with vB 4.0?

[Kaelon]

Originally Posted by john1744

Has anyone attempted this with vB 4.0?

This won't work with vBulletin 4.x, nor do I plan to port this to vB 4.x. This mod is intended only for vB 3.7.x or vB 3.8.x.