Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Sticky Post Modification Details »
Sticky Post Modification
Mod Version: 1.00, by Ravenheart (Member) Ravenheart is offline
Developer Last Online: Feb 2010 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.0.0 Rating: (0 vote - 0 average) Installs: 6
Released: 03 Apr 2004 Last Update: Never Downloads: 13
Not Supported Is in Beta Stage  

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?

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 03 Apr 2004, 20:57
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Sticky Post Modification

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.
Attached Files
File Type: txt stickypost.txt (8.4 KB, 112 views)
__________________
http://bigacid.wordpress.com
Reply With Quote
  #3  
Old 03 Apr 2004, 21:36
Chris Gwynne's Avatar
Chris Gwynne Chris Gwynne is offline
 
Join Date: Jan 2003
Hmm, good idea.
Reply With Quote
  #4  
Old 03 Apr 2004, 21:42
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
How many queries does this add?
Reply With Quote
  #5  
Old 03 Apr 2004, 23:08
Giveit2u43 Giveit2u43 is offline
 
Join Date: Jun 2003
superb hack.. could come in very handy.
Reply With Quote
  #6  
Old 03 Apr 2004, 23:14
Geographic2 Geographic2 is offline
 
Join Date: Apr 2003
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 Apr 2004, 19:10
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Ravenheart
I choose only one post, actually first one for now. So the large query involves only one row.
__________________
http://bigacid.wordpress.com
Reply With Quote
  #8  
Old 04 Apr 2004, 19:17
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Originally Posted by Boofo
How many queries does this add?
As Geographic2 said, 2 queries.
__________________
http://bigacid.wordpress.com
Reply With Quote
  #9  
Old 04 Apr 2004, 19:19
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
Originally Posted by Giveit2u43
superb hack.. could come in very handy.
Thanks !
__________________
http://bigacid.wordpress.com
Reply With Quote
  #10  
Old 05 Apr 2004, 20:47
Ravenheart Ravenheart is offline
 
Join Date: Feb 2004
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
  #11  
Old 06 Apr 2004, 10:22
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
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.
__________________
http://bigacid.wordpress.com
Reply With Quote
  #12  
Old 06 Apr 2004, 12:18
Ravenheart Ravenheart is offline
 
Join Date: Feb 2004
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?
Reply With Quote
  #13  
Old 06 Apr 2004, 19:34
armkbdotcom's Avatar
armkbdotcom armkbdotcom is offline
 
Join Date: Apr 2004
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.
__________________
http://bigacid.wordpress.com
Reply With Quote
  #14  
Old 27 Apr 2004, 09:18
Skyline_GT Skyline_GT is offline
 
Join Date: May 2003
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..
__________________
Gamerzplanet.Net - The best place to get the latest cracks, hacks, cheats for all popular online games!!
GzP Upload.NET - Fast and Free Image Hosting!!
Online Flash Games - An online flash game with 10,000+ games!!
Reply With Quote
  #15  
Old 05 May 2004, 22:11
M.C.'s Avatar
M.C. M.C. is offline
 
Join Date: Jan 2002
just be great if stiky threads have it on already... i mean if you sticky thread so first post in it sticky as well
__________________
WBR`s
M.C.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 17:13.

Layout Options | Width: Wide Color: