Sticky Post Modification

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]

Originally Posted by Ravenheart

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]

Originally Posted by armkbdotcom

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]

Originally Posted by Ravenheart

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???!!!