Sticky Post Modification

[Ravenheart]

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]

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]

Hmm, good idea. :)

[Boofo]

How many queries does this add?

[Giveit2u43]

superb hack.. could come in very handy.

[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.

[armkbdotcom]

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

[armkbdotcom]

How many queries does this add?
As Geographic2 said, 2 queries.

[armkbdotcom]

superb hack.. could come in very handy.
Thanks !

[Ravenheart]

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

[armkbdotcom]

Whoops I meant all 'threads' sorry
You choose the thread you want to be stuck. It's per thread option located in Thread Tools.

[Ravenheart]

You choose the thread you want to be stuck. It's per thread option located in Thread Tools.
Any way to make it do it for all threads then?

[armkbdotcom]

Any way to make it do it for all threads then?

I think it's not worth to make modifications in order to stick/unstuck all threads. So very quick solution is to run this in "Execute Query" of your Admin CP to stick all threads

UPDATE thread SET stickypost = 1;

and this to unstuck all threads

UPDATE thread SET stickypost = -1;

If you wish default option to be "sticky post" you may modify your database with the following
query in "Execute Query" in case you've already installed this hack:

ALTER TABLE thread MODIFY stickypost INTEGER(10) NOT NULL DEFAULT 1;

and this in case you haven't installed this hack yet:

ALTER TABLE thread ADD stickypost INTEGER(10) NOT NULL DEFAULT 1;

Hope this helps.

[Skyline_GT]

hm.. I have a small problem..
I wonder why I get a blank screen after I set it to sticky the frist post? I don't see a redirect mesage..
but I checked and I ddi add the phase..

[M.C.]

just be great if stiky threads have it on already... i mean if you sticky thread so first post in it sticky as well ;)

[M.C.]

same problem as Skyline_GT.... anyone support that hack???!!! :(