Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Arranging Sticky Topics
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Panhandler
Average Member

USA
783 Posts

Posted - 03 April 2005 :  11:58:28  Show Profile  Visit Panhandler's Homepage
My forum posts are arranged in descending order.
However, my most important "Sticky" topic won't stay at the top when I add a second sticky topic because they are arranged by date.

Is there a way to overcome this and make my most recent "Sticky" topic appear second on the list of sticky topics?


"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums


ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 03 April 2005 :  14:24:50  Show Profile  Send ruirib a Yahoo! Message
There is only one statement retrieving the topics from the database, which means that sticky topics are ordered in the same manner as the non-sticky ones. To order the sticky topics differently, you would need to use to statements to retrieve the topics: one for the sticky ones and the other for the rest.
Though that is not a difficult thing to do, it needs care and it may give a bit of work.

If you want help on doing it, I'll move the topic to the Help: Mod Implementation forum.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Panhandler
Average Member

USA
783 Posts

Posted - 03 April 2005 :  21:45:39  Show Profile  Visit Panhandler's Homepage
Yes, I would need a ton of help.
Presently, my method is to delete the old sticky, then repost it after the new sticky, so that the new sticky sits on top.

Asking me to conduct the modification necessary to make this happen is like asking a man with a sledge hammer to join your orchestra.
Pretty hopeless. . .



"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums


Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 07 April 2005 :  12:00:16  Show Profile
Another way to do it would be to use integers for sticky topics instead of just 0 or 1, i.e. a topic with a T_STICKY value of 2 would always appear above one with a value of 1. There used to be a Top Sticky Mod many moons ago for v3.3.x that did something similar - don't know if it's been updated, though.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Panhandler
Average Member

USA
783 Posts

Posted - 07 April 2005 :  13:52:49  Show Profile  Visit Panhandler's Homepage
A search produced no results. I couldn't find it on Snitzbitz either.
I sounds like you have an idea on how to modify it. . .can you elaborate. . .I think it would be useful.
Thanks. . .


"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums


Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 08 April 2005 :  05:17:40  Show Profile
Off the top of me head?

Change the sticky topic checkbox on post.asp to a select menu with giving each option incrementing values from 0 (for a normal post) to as high as you want. You can have the dropdown itself display anything you want, maybe differing levels of priority.

You'd then need to modify post_info.asp so it picks up the numerical value of the selected option and inserts it into the T_STICKY field.

Finally, you'd need to modify pop_open or pop_lock.asp to allow you to change the priority of a message and chnage the links on forum.asp accordingly.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

Panhandler
Average Member

USA
783 Posts

Posted - 08 April 2005 :  10:09:44  Show Profile  Visit Panhandler's Homepage
Oh.




"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums


Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 08 April 2005 :  11:22:11  Show Profile
Sounds more difficult than it is; give it whirl (backing up before you do, of course ) and if you can't get it, I'll get the exact code changes over to you - don't have time to do them right now.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.52 seconds. Powered By: Snitz Forums 2000 Version 3.4.07