Scrolling center block

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4658

Having discussed this at length in the 'blocks' forum, with Raven providing an excellent file for use - it might be a nice option to switch off certain forum categories in the collapsable, scrolling forum block too.

I cannot think of anything else it doesnt do except make a nice cup of coffee.

montego · Posted: Sat Aug 20, 2005 6:45 pm

Ah... so you are the same Guardian afterall... Groovy

I agree, that would be a nice add!

Raven · Posted: Sat Aug 20, 2005 7:24 pm

Try this and let me know if it works. In the collapsing forum block, find

Code:

error_reporting(0);

and add this line after

Code:

$hideTheseForums = ''; // add forumid's as in '1,4,17'

Then find

Code:

$result = $db->sql_query( "SELECT topic_id, forum_id, topic_last_post_id, topic_title, topic_poster, topic_views, topic_replies, topic_moved_id, topic_status FROM ".$user_prefix."_bbtopics ORDER BY topic_last_post_id DESC");

and change it to

Code:

$result = $db->sql_query( "SELECT topic_id, forum_id, topic_last_post_id, topic_title, topic_poster, topic_views, topic_replies, topic_moved_id, topic_status FROM ".$user_prefix."_bbtopics WHERE forum_id NOT IN($hideTheseForums) ORDER BY topic_last_post_id DESC");

Let me know ASAP.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4658

No that didnt work.
Everything within the block is set to its default values i.e. as it was when it was downloaded.
Added / changed the additional code setting $hideTheseForums to '46,47,48' which are the forums I would want to hide.

No forums at all are showing in the block but when selecting 'show' I see 'undefined' listed twice in forum topic.

Raven · Posted: Sun Aug 21, 2005 6:24 am

- Recopy it and try it.

Raven · Posted: Sun Aug 21, 2005 8:08 am

Coming in 2.1.0 [so far]

Code:

# Version 2.1.0 #
# 08/21/2005 : Added routine to allow manual hiding of selected forums#
# Renamed a few variables for standardization purposes. #
# 08/20/2005 : Added routine to adjust displayed post time by profile #
# 08/13/2005 : Added border="0" to xmlicon - Thanks CurtisH #
# Added manual routines to recognise admins and mods in #
# order to hilite their roles when mousing over their #
# icons in the Top 10 posters. This could be automated, #
# but until that happens, this will suffice. #

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4658

Yep, it was the ") at the end.
Oustanding!!!!!!!!!
Another donation coming your way as soon as I have something in PayPal.

Works perfectly!

Raven · Posted: Sun Aug 21, 2005 8:12 am

Actually the ORDER BY clause had to be moved AFTER the WHERE clause. It was late and I'm on drugs .....