Info:
Let members on your forums have their own 'personal' sticky thread. People sticking a thread using this function will have the thread only appear 'stuck' to them (and if its a 'real' sticky thread). See screenshots for the obvious
Tested on:
3.5.0 - OK
3.5.1 - OK
3.5.2 - OK
3.5.3 - OK
3.5.4 - OK
Features
- Neat icons!
MAKE A BACKUP
I will not be held responsible for any damage this hack causes to your forum.
This hack is NOT supported. If you get support, consider yourself lucky.
I reserve the right to REMOVE the hack at any time without prior notice.
Please keep any bug reports in this thread.
History 1.0.3b (to upgrade reimport product xml IMPORTANT)
Bugfix
- Fixed a bug that would give SQL errors if someone didnt have personal stickys. 1.0.3 (to upgrade reimport product xml and apply file edits)
Bugfix
- Fixed "The stickied thread will be stickied to the top of its own page, not the first page per see.". It will now be stickied to the first page (I have NOT tested this on different settings due to lack of time). 1.0.2 (to upgrade reimport product xml)
Feature
- Redirect on stick/unstick selection 1.0.1 (to upgrade reimport product xml)
Bugfix
- Fixed an error that would appear in UserCP and in the subscriptions area if you had subscribed threads. 1.0.0
Initial release
Quick question, is this mod supposed to show your personal stickies in every forum/subforum you visit or is it simply supposed to sticky those threads in the forum they reside?
Currently the personal stickies are following me around everywhere i go on my forums, lol. Is there a way to make them simply be stickied in the forum they were created in???
I really hope i simply have some code wrong somewhere, lol.
Try out these directions and report back. As far as I remember this is what I did to get it working. (Basically following others ideas and putting them together.)
Try out these directions and report back. As far as I remember this is what I did to get it working. (Basically following others ideas and putting them together.)
It works, but there is a slight problem within the document. It says:
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
$visiblethreads
==== 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)
$visiblethreads
The replacement is missing a closing paranthesis - it needs a double )) after $personalstickysq
It should look like this for the replacement
Code:
==== 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))
$visiblethreads
AND there was a step left out that was part of the original installation.
Working on 3.6.8 PL2 - Complete Update Installation Revision is attached!
Personal Stickys Details »»
About Developer
DB Changes 
No support by the author.
04-29-2007, 02:39 AM
