vb.org Archive - Sticky Post Modification

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)

- - Sticky Post Modification (https://vborg.vbsupport.ru/showthread.php?t=63413)

Ravenheart

04-02-2004 10:00 PM

Sticky Post Modification

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?

armkbdotcom

04-03-2004 07:57 PM

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.

Chris Gwynne

04-03-2004 08:36 PM

Hmm, good idea. :)

Boofo

04-03-2004 08:42 PM

How many queries does this add?

Giveit2u43

04-03-2004 10:08 PM

superb hack.. could come in very handy.

Geographic2

04-03-2004 10:14 PM

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.

armkbdotcom

04-04-2004 06:10 PM

Ravenheart
I choose only one post, actually first one for now. So the large query involves only one row.

armkbdotcom

04-04-2004 06:17 PM

Quote:

Originally Posted by Boofo

How many queries does this add?

As Geographic2 said, 2 queries.

armkbdotcom

04-04-2004 06:19 PM

Quote:

Originally Posted by Giveit2u43

superb hack.. could come in very handy.

Thanks !

Ravenheart

04-05-2004 07:47 PM

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

All times are GMT. The time now is 02:28 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00971 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: