Moderators Functions - Show User History On Infraction Form And Postbits

This product will allow those with the ability to issue warnings/infractions to see a user's user notes and infraction history on the infraction form for easy reference. A new data block is displayed below the "User Infraction" block containg the user's relevant history.

On the forum I help administrate, we have devised a system where if a user breaks a forum rule for the first time, we simply send a friendly PM advisory of the rule rather than going to the infraction system. Many users, especially new users, are taken aback to receive a formal warning or infraction for breaking a rule they likely didn't realize is in place. Let's face it, the vast majority of users just don't read the rules.

So, when we see that a user has broken a rule, we need to check to see if a PM advisory has previously been sent, and we record this information in the usernotes. Then if we find that an advisory has been sent, we have to check that user's infraction history to see if they have been formally warned or given an infraction so that we know the most appropriate action to take for this new violation.

With this product, you can simply click the "Add Infraction" button on the postbit, and have all the needed history available on the generated form so that you can decide what action is most appropriate. If you find that no relevant usernote data exists, there is a button below the data block element that will take you to that user's usernote page.

I wish to extend a special thanks to BrettC Frontier for many great suggestions and error reporting that has really helped make this add-on much better.

Update: version 1.1

• Option to display user history in postbits.
• Option to set which usergroups will have their history displayed in postbits. Both data include links to the relevant pages.
• Option to set which usergroups will see the user history in postbits.

Update: version 2.0

• Shortened product title so it won't be truncated in AdminCP ► Plugins & Products ► Manage Products.
• Fixed text color on usergroup checkbox elements in product settings to be dark.
• If usernote title is empty, displays "N/A" within user history block on infraction form.
• Fixed infraction reason to either use chosen or custom reason, whichever applies.
• Infractions show date/time of expiry.
• Infractions show link to post that caused warning/infraction to be issued, using thread title.
• Infractions are shown in descending order, sorted by time issued.
• Background color of user history block fixed to white.
• If no "Administrative Note" is given for an infraction, then "N/A" is displayed.
• Execution order of postbit plugin increased to help ensure it gets run.
• Usernames of usernote authors and infraction issuers link to user profiles.

Update: version 2.1

• Fixed bug regarding infraction not being associated with a post and causing and SQL
  error.
• Changed usergroup selection from checkboxes to select elements.

Update: version 2.2

• Added the display of active infraction points on infraction form.
• Added the ability to customize the color of the active points based on value.

Update: version 2.3

• Added the display of active infraction points on user postbits, where the number is colored as defined.

Update: version 2.4

• Corrected typo preventing templates from being cached.

Installation:

Download and extract the attached .zip file.

Follow:

AdminCP ► Plugins & Products ► Manage Products ► Add/Import Product.

Click on "Choose File" and browse to the product xml file that was packaged in the .zip file.

Click "Import"

You MUST set your settings to enable the product.

Support for this product can be found here:

• MHB - Show User History On Infraction Form And Postbits
• TAZ - Show User History On Infraction Form And Postbits

[killah360z]

Fatal error: Call to a member function fetch_array() on a non-object in /usr/www/sghosting/public/forums/includes/class_postbit.php(345) : eval()'d code on line 296

[MarkFL]

Originally Posted by killah360z

Fatal error: Call to a member function fetch_array() on a non-object in /usr/www/sghosting/public/forums/includes/class_postbit.php(345) : eval()'d code on line 296

Strange...I'm not getting that error on either of my dev sites.

Try the following:

1.) Open the plugin titled "Usernote Information In Postbits"

2.) Locate the line:

PHP Code:

    $markfl_infraction_activepoints = 0; 


3.) Directly below it, add:

PHP Code:

    global $db; 


4.) Let me know if that works.

[BrettC Frontier]

I'm a bit confused why it's not showing up on postbits for me (namely postbit_legacy).

I can see it is hooked to postbit_display_complete, and it additionally has a hook set for postbit_userinfo_right_after_posts. However nothing appears to be showing, even after configuration settings were applied and enabled.

The only other plugin running is https://vborg.vbsupport.ru/showthread.php?t=227946 which has the same hook, with an exec order of 5 rather the setting that yours has of 20.

[killah360z]

when giving an infraction

Database error in vBulletin 4.2.3:

Invalid SQL:

			SELECT thread.*
			FROM thread AS thread
			WHERE threadid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number  : 1064
Request Date  : Wednesday, August 19th 2015 @ 11:56:36 PM
Error Date    : Wednesday, August 19th 2015 @ 11:56:36 PM
Script        : http://silentgamerz.com/forums/infraction.php?do=report&p=456
Referrer      : http://silentgamerz.com/forums/threads/185-asd-tripped-AE-detector
IP Address    : 124.195.207.82
Username      : KillaHinstinct
Classname     : vB_Database
MySQL Version : 5.6.22

happens on v2.2 & 2.3

--------------------------------------------

nvm looks like it magically got fixed on its own ;d

--------------------------------------------

its back again

[MarkFL]

Originally Posted by BrettC Frontier

I'm a bit confused why it's not showing up on postbits for me (namely postbit_legacy).

I can see it is hooked to postbit_display_complete, and it additionally has a hook set for postbit_userinfo_right_after_posts. However nothing appears to be showing, even after configuration settings were applied and enabled.

The only other plugin running is https://vborg.vbsupport.ru/showthread.php?t=227946 which has the same hook, with an exec order of 5 rather the setting that yours has of 20.

I gave it a higher execution order so it would display the data below other postbit data that might be hooked there. I have a dozen or so add-ons hooked there, and no issues whatsoever on either of my 2 test sites.

[killah360z]

Originally Posted by MarkFL

I gave it a higher execution order so it would display the data below other postbit data that might be hooked there. I have a dozen or so add-ons hooked there, and no issues whatsoever on either of my 2 test sites.

uh wait i was wrong it is back again weird ( happens randomly )

[MarkFL]

Originally Posted by killah360z

uh wait i was wrong it is back again weird ( happens randomly )

I just gave 4 infractions in a row on my dev site...everything works perfectly. 2 were profile infractions and 2 were on posts.

Exactly how are you giving the infractions?

[killah360z]

Originally Posted by MarkFL

I just gave 4 infractions in a row on my dev site...everything works perfectly. 2 were profile infractions and 2 were on posts.

Exactly how are you giving the infractions?

by clicking the icon~

[MarkFL]

And when do you get the error? I get no errors on my end, so I need to have detailed information about what is happening on your end if I am to be able to figure out what changes I have to make to accommodate your site/settings.

[killah360z]

as i said the database error comes when i press the button like i'd be lead to
/infraction.php?do=report&p=456
also it is really weird how i am getting this error from just 1 user ( its my test account ) any posts made by the account gives off the db error every other post is fine o_O