Profile Enhancements - 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)

[Forum Lover]

Nice idea. Installed.

[habbishfmforum]

nice and lovely idea , installed!

[Fusion]

Great idea.sockwater!

[Hornstar]

perfect. very nice work!

[Hornstar]

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

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.

[sockwater]

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.

[htscpl]

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

[sockwater]

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!

[Julie]

Installed, and working like a charm! Thanks!