vb.org Archive - View Single Post - Idea for the Ignore Hack (for vb 2.0 that is)

#4 11-03-2000, 05:02 PM

I hacked it a bit to show an announcement type-thing (called it ignored bit instead of announcement bit and changed the icon to a little X

) at the top saying "There are X hidden posts on this thread due to your ignore list. Click here to temporarily bypass your settings."

In order to remove all the posts I just had it skip over them if it was in your ignore list and increment a counter for the "ignored bit", however that is probably not the most efficient way to do that... I was thinking maybe another relation ignored_user which has 2 IDs in it:
userid, ignoreduserid

Then you could just join the SELECT statement on that.

Something like

Code:

SELECT whatever
FROM post p, ignored_user iu
WHERE iu.userid = $bbuserid 
AND p.userid != iu.ignoreduserid
AND whatever else is in there;

If the thread had a lot of ignored posts then the join might save some processor time (saving time because you don't need any conditional logic on EACH post to see if it is banned, but then you need to join on another table, which is always costly). Otherwise it would probably be overkill. I guess it might be beneficial to see how many people use it, and how many userIDs are hidden.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01103 seconds Memory Usage 1,758KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: