vb.org Archive - Profile Enhancements - Hide Expired and Reversed Infractions from the Infracted User

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Profile Enhancements - Hide Expired and Reversed Infractions from the Infracted User (https://vborg.vbsupport.ru/showthread.php?t=187397)

Hide Expired and Reversed Infractions from the Infracted User

This modification does just what it says. After an infraction has expired or has been reversed, it will no longer be shown to the user in their profile. It will still be shown if a moderator or administrator views the list. This helps users not feel like they have a permanent rap sheet hanging over their heads.

Installation: Import the XML file. [s]There are no settings or options[/s]. To disable the modification, disable or uninstall the product. Expired and reversed infractions are not deleted, they are only hidden from the end user.

Update: Version 1.2 addresses two problems. In addition to the profile, it now hides infractions in the User CP, and you can choose to hide only reversed infractions, only expired infractions, or both. There is now an option in the User Infraction Options group for this.

Enjoy!

Suggested here.

Changes
v1.1 - Fixed database error when a user has no infractions and there are other products adding tabs to the user profile. (Thanks hornstar1337)
v1.2 - Now works in the User CP and lets you choose which infractions to hide (expired, reversed, or both)

Nice idea. Installed.

nice and lovely idea , installed!

Great idea.sockwater!

perfect. very nice work!

Thought it was working well til I went to my profile:

Code:

Database error in vBulletin 3.7.2:



Invalid SQL:



                SELECT blogid, attach

                FROM vb3_blog AS blog

                WHERE blog.state IN('visible')

    AND blog.dateline <= 1218097598

    AND blog.pending = 0

    AND blog.userid = 1 AND infraction.action = 0

                ORDER BY blog.dateline DESC

                LIMIT 5;



MySQL Error   : Unknown column 'infraction.action' in 'where clause'

Error Number  : 1054

Request Date  : Thursday, August 7th 2008 @ 04:26:38 AM

Error Date    : Thursday, August 7th 2008 @ 04:26:38 AM

Script        : http://www.gamerzneeds.net/forums/member.php?action=getinfo&u=1

Referrer      : http://www.gamerzneeds.net/forums/index.php



Classname     : vB_Database

MySQL Version : 5.0.45-community

Disabled until it works.

For the moment I'm tempted to say this mod simply isn't compatible with the Blogs addon. But there might be a way to work around this. Could you check and see if the Blog product uses any hooks that start with member_infraction* You can check by looking at the list of plugins.

Nice idea, but I am going to hold off until you track down the Blog incapatiblity... still good work! :D

I think I've isolated the problem and fixed it in v1.1. The conditions that caused the database error are if the user has no infractions and there is another product adding a tab to the profile page.

Now I just need someone who has the Blog installed to test and make sure it's working correctly. :)

Thanks hornstar1337 for finding & reporting this bug!

Installed, and working like a charm! Thanks! :)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01173 seconds Memory Usage 1,729KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: