Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Beta Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Sticky Post Modification Details »»
Sticky Post Modification
Version: 1.00, by Ravenheart Ravenheart is offline
Developer Last Online: Feb 2010 Show Printable Version Email this Page

Version: 3.0.0 Rating:
Released: 04-02-2004 Last Update: Never Installs: 6
Is in Beta Stage  
No support by the author.

Quote:
Originally Posted by Geographic2
just count the queries in the file yo.

Open it, click edit>find>"query",click,click...

2 queries, 1 simple query, and 1 query with a large series of joins in showthread.php

Woot.
Is this done for all posts or do you choose which ones you wish to be stuck?

Show Your Support

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

Comments
  #2  
Old 04-03-2004, 07:57 PM
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sticky Post modification for vBulletin 3.0.0 Gold
-------------------------------------------------

Credits
-------
Author: Souren Abeghyan
Web Page: forum.armkb.com
Contact: <use contact form on web page>
Date: 4 April 2004

Description
-----------
By adding this modification you will be able to stick/unstick first post in each thread.
It is useful when your thread is multipage and you want to have the very first post
on the top when browsing thread pages. This modification will work only for Linear
Display Mode. You can stick/unstick it from Thread Tools - Stick/Unstick First Post.

Modified Parts
--------------
Templates:
postbit
SHOWTHREAD
Files:
functions_showthread.php
postings.php
showthread.php

Database:
added one column in 'thread' table to hold sticky post flag.
Reply With Quote
  #3  
Old 04-03-2004, 08:36 PM
Chris Gwynne's Avatar
Chris Gwynne Chris Gwynne is offline
 
Join Date: Jan 2003
Posts: 316
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm, good idea.
Reply With Quote
  #4  
Old 04-03-2004, 08:42 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How many queries does this add?
Reply With Quote
  #5  
Old 04-03-2004, 10:08 PM
Giveit2u43 Giveit2u43 is offline
 
Join Date: Jun 2003
Location: Liverpool
Posts: 145
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

superb hack.. could come in very handy.
Reply With Quote
  #6  
Old 04-03-2004, 10:14 PM
Geographic2 Geographic2 is offline
 
Join Date: Apr 2003
Location: On the map
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

just count the queries in the file yo.

Open it, click edit>find>"query",click,click...

2 queries, 1 simple query, and 1 query with a large series of joins in showthread.php

Woot.
Reply With Quote
  #7  
Old 04-04-2004, 06:10 PM
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ravenheart
I choose only one post, actually first one for now. So the large query involves only one row.
Reply With Quote
  #8  
Old 04-04-2004, 06:17 PM
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Boofo
How many queries does this add?
As Geographic2 said, 2 queries.
Reply With Quote
  #9  
Old 04-04-2004, 06:19 PM
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Giveit2u43
superb hack.. could come in very handy.
Thanks !
Reply With Quote
  #10  
Old 04-05-2004, 07:47 PM
Ravenheart Ravenheart is offline
 
Join Date: Feb 2004
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by armkbdotcom
Ravenheart
I choose only one post, actually first one for now. So the large query involves only one row.
Whoops I meant all 'threads' sorry
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 01:57 PM.


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.04349 seconds
  • Memory Usage 2,288KB
  • Queries Executed 23 (?)
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
  • (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
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)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