Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Sub Forums Order
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Sub Forums Order

 Post Reply Post Reply
Author
slog View Drop Down
Groupie
Groupie


Joined: 11 September 2009
Status: Offline
Points: 59
Post Options Post Options   Thanks (0) Thanks(0)   Quote slog Quote  Post ReplyReply Direct Link To This Post Topic: Sub Forums Order
    Posted: 06 January 2010 at 1:45pm
Hi, some of my users are asking me to change my sob forums order. They suggested me to use number of post or last post to order my subforums. I know that you define the order at the control panel, but i wonder if there is a way to make it work as the topics, in last post order...
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 January 2010 at 1:50pm
There is not. I would image such a scheme of reordering forums in this way would be quite confusing.
Back to Top
slog View Drop Down
Groupie
Groupie


Joined: 11 September 2009
Status: Offline
Points: 59
Post Options Post Options   Thanks (0) Thanks(0)   Quote slog Quote  Post ReplyReply Direct Link To This Post Posted: 06 January 2010 at 2:19pm
Thanks Bruce, I will try to make a better order by hand in the control panel.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 06 January 2010 at 3:12pm
Another thing you could try is edit in a text editor the file forum_topics.asp and change thye order by clause for sub forums in the SQL to be order by the last topic date instead.

It would be line 608 changed from:-

"ORDER BY " & strDbTable & "Forum.Forum_Order, " & strDbTable & "Permissions.Forum_ID;"

To:-

"ORDER BY " & strDbTable & "Forum.Last_post_date ASC;"
Back to Top
slog View Drop Down
Groupie
Groupie


Joined: 11 September 2009
Status: Offline
Points: 59
Post Options Post Options   Thanks (0) Thanks(0)   Quote slog Quote  Post ReplyReply Direct Link To This Post Posted: 06 January 2010 at 8:39pm
Many Thanks Bruce...

I did this change, except for the order, I used DESC instead of ASC, I want the recent ones on the top. ;-)

Worked just fine, I am glad it is a minor change.

Thanks a lot.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.