Version: 1.0.3c, by Kaelon
Developer Last Online: Jan 2023
Category: End-User Options -
Version: 3.7.2
Rating:
Released: 08-28-2008
Last Update: 08-28-2008
Installs: 86
DB Changes Uses Plugins Template Edits
Code Changes Additional Files
No support by the author.
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:
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:
Import product-personalsticky.xml
Upload the two images into their respective folders
If the thread drops a page, the sticky does not show up, unless you go to that page. It is also showing up twice on that page. Once above the regular stickies and the again below the stickies.
Personal Sticky Threads is an addon for vbulletin that allows users to create personal stickies. There appears to be a small problem when toggling the personal sticky on a thread you do not have persmission to access.
This does. However, be advised, that I discovered a minor security flaw in this code that would enable any user to gain unauthorized access to the name/title of threads in private forums (but not their content). Since I did not originally code this, and merely ported it, I believe there are a series of missing checks in the plugins themselves. However, I am not actively supporting this mod due to time constraints.
This does. However, be advised, that I discovered a minor security flaw in this code that would enable any user to gain unauthorized access to the name/title of threads in private forums (but not their content). Since I did not originally code this, and merely ported it, I believe there are a series of missing checks in the plugins themselves. However, I am not actively supporting this mod due to time constraints.
Darn. I tried it, but got a message about invalid SQL with this change:
Code:
===========================================================================
==== 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!
Personal Sticky Threads Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
11-15-2008, 01:13 PM
