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)

[Chris583]

Great mod. Can you have options to allow only certain groups access to it?

[Kaelon]

Originally Posted by Chris583

Great mod. Can you have options to allow only certain groups access to it?

Absolutely. This is one of the add-ons listed on the original post and requires tinkering with a plug-in.

[Kaelon]

Originally Posted by Dr. Bantham

The edits to FORUMDISPLAY.PHP appear to be causing the following database error:

Database error in vBulletin 3.7.2:

Invalid SQL:

			SELECT thread.threadid, lastpost, open
			FROM thread AS thread
			WHERE forumid = 271
				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  : Saturday, August 30th 2008 @ 10:23:56 AM
Error Date    : Saturday, August 30th 2008 @ 10:23:56 AM
Script        : http://www.ligotti.net/forumdisplay.php?s=&daysprune=&f=271
Referrer      : 
IP Address    : XXXXXXXXXXXXXXX
Username      : Dr. Bantham
Classname     : vB_Database
MySQL Version : 5.0.51a-community

Apparently, you did not apply the file edits appropriately, or were using an unclean version of forumdisplay.php. Please make sure you're using the forumdisplay.php from vBulletin 3.7.3 and follow the directions exactly.

Thanks again!

[Alfa1]

Can you define usergroup permissions for this function?

[space?]

Very good Idea
User will feel more mighty with that...thanks.

[Kaelon]

Originally Posted by Alfa1

Can you define usergroup permissions for this function?

Yes, absolutely. Look at this posting. You basically edit a couple of lines of code, and you're all set.

[Alfa1]

Thanks! Will install.

[Kaelon]

Originally Posted by Alfa1

Thanks! Will install.

Thanks, Alfa1. Please mark as installed

[Alfa1]

I always do so, right after I install a mod.

[BigDog56]

Very nice! Works like a charm, Thank You!

Edit. One small problem. It is showing up twice, once about the normal stickies and once again below the normal stickies.

Attachment 87008