Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.7 > vBulletin 3.7 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Personal Sticky Threads Details »»
Personal Sticky Threads
Version: 1.0.3c, by Kaelon Kaelon is offline
Developer Last Online: Jan 2023 Show Printable Version Email this Page

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:


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:Version History
  • 1.0.3c: Updated for vBulletin 3.7.3 (August 28, 2008)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #42  
Old 11-09-2008, 04:04 PM
DPtheGod's Avatar
DPtheGod DPtheGod is offline
 
Join Date: May 2007
Location: Everett, WA
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is definitely an interesting hack. I'm going to give it a shot at home tonight. Thanks!
Reply With Quote
  #43  
Old 11-15-2008, 01:13 PM
BigDog56 BigDog56 is offline
 
Join Date: Jan 2007
Posts: 430
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #44  
Old 11-15-2008, 02:47 PM
iNRoC iNRoC is offline
 
Join Date: Jul 2008
Location: Clifton, New Jersey
Posts: 151
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Amazing. I love it. Installed.
Reply With Quote
  #45  
Old 12-25-2008, 10:04 AM
AA_ AA_ is offline
 
Join Date: Mar 2008
Location: Berlin
Posts: 381
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

bugtraq at securityfocus dot com:

Quote:
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.

If I am denied persmission to:

http://forums.somesite.com/showthread.php?t=7

Toggling personal stickies for the thread to on I am able to view the thread title, author, and pages:

http://forums.somesite.com/misc.php?...tick&thread=47

This does not allow me access to the thread but does display information not intended to be viewed by me
Reply With Quote
  #46  
Old 12-27-2008, 02:46 AM
Rene Kriest Rene Kriest is offline
 
Join Date: Jun 2008
Location: Germany ./. Reality
Posts: 157
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by AA_ View Post
bugtraq at securityfocus dot com:
Uah, scarry. I think I gonna wait with installing the addon until the security issue has been resolved.
Reply With Quote
  #47  
Old 02-18-2009, 07:59 AM
mystikmedia mystikmedia is offline
 
Join Date: Feb 2009
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Does anyone know if this works with 3.8.1?
Reply With Quote
  #48  
Old 02-18-2009, 06:20 PM
Kaelon's Avatar
Kaelon Kaelon is offline
 
Join Date: Jan 2002
Posts: 405
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mystikmedia View Post
Does anyone know if this works with 3.8.1?
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.
Reply With Quote
  #49  
Old 02-18-2009, 07:51 PM
mystikmedia mystikmedia is offline
 
Join Date: Feb 2009
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Kaelon View Post
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!
Reply With Quote
  #50  
Old 04-22-2009, 02:24 PM
dbirosel dbirosel is offline
 
Join Date: Feb 2007
Location: San Diego
Posts: 587
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Awwww that sucks. This was a real good idea too.
Reply With Quote
  #51  
Old 06-24-2009, 11:08 PM
FeatheredFriend FeatheredFriend is offline
 
Join Date: May 2007
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:28 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04800 seconds
  • Memory Usage 2,316KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete