Administrative and Maintenance Tools - "Smith" Warning System

I no longer support my hacks. Please feel free to update them and release new versions elsewhere as long as I get the credit for the original modification.

/*================================================= =====================*\
|| "Smith" Warning System
||
|| Author : Anton Kanevsky
|| Co-Author(s) : Mr_Devlin (German Translation)
|| Works on : vBulletin 3.5 / 3.6
|| Released : Nov 25, 2006
||
|| Time required to install: 1 minute
|| Difficulty: easy
\*================================================ ======================*/

DESCRIPTION

Have you been running into troublesome users ever since you have began administering your bulletin board? Have you been forced into banning these users because there was no other way to prevent them from wreaking havoc in your community? Look no further. "Smith" Warning System is a professional solution that features a system of warning points as an alternative to an immediate ban. A must-have tool for a serious administrator.

STATISTICS

File Uploads: 1
Template Changes: 5
Products to Install: 1


FEATURES

• Configuration Options
  • Banning Threshold (defines the maximum number of points)
  • Banning Usergroup (defines where to move a user after the user has reached the threshold)
  • Automatically Create Warning Usernote for Warned User (yes / no)
  • Fake Warner (a fake person from whom warnings originate)
  • Forum for Information Threads (can be turned off completely)
  • Enable Conditional Display of "Issue New Warning" Link in Showthread and Showpost (Advanced Option; Takes Extra Queries)
  
  
• Extensive Usergroup Permissions
  • Can Issue Warnings
  • Can Administer Warnings
  • Can Disable Notification
  • Can Be Warned
  • Can Override Warning Settings (Defines whether number of points, duration period, reputation effect and revokation cost may be customized per-warning)
  • Can View Own Warnings
  • Can View Others Warnings
  
  
• Warning Type Manager
  • Title & Description
  • Default number of points (customizable per warning)
  • Default duration period (customizable per warning)
  • Default reputation effect (customizable per warning)
  • Default self-revokation cost (customizable per warning)
  • Each warning type can be deactivated or deleted if desired.
  
  
• Warning History Manager
  • Extensive filter for a quick lookup of warnings that much certain criteria.
  • Ability to permanently revoke unexpired warnings as an alternative to complete deletion. That way they stay in the log, but have no further effect.
  
  
• Smart, Full-Featured Front End
  • Amount of points and duration of a warning.
  • Real and "Verbal" (non-penalty) warnings, both of which are recorded into the warning log.
  • If certain setting (vBulletin Options -> Warning System) of the hack is misconfigured, an error message will be displayed when you attempt to issue a new warning, thus preventing your database from potential corruption.
  • Each post can only be warned once.
  • A person may not issue a self-warning.
  • Verbal warnings are displayed with a "verbal" sign in the log in place of the points.
  • Information about an issued warning is automatically recorded into user's usernotes page. If a warning is deleted, the usernote is deleted too. The feature can be turned off if desired.
  • Information about an issued warning is automatically posted in the form of a new thread in a designated forum. The feature can be turned off if desired.
  • If a post has an attached warning, the brief warning details are displayed at the bottom of the post.
  • If a person a positive warning level, it is displayed in the posts and in the profile of that person.
  • Warned posts are automatically locked from any further modifications by their owners.
  • Warning history, once a user has one or more warnings, is available from the user's profile and from posts.
  • Members who have a permission to issue warning are unable to issue warnings to higher-standing usergroups (such as moderator -> supermoderator or supermoderator -> admin).
  • A sophisticated "who's online" handler that shows exactly what a user is doing in the front-end warning system.
  • Only those links to which the viewer has access are displayed. For example, a moderator will not see an "issue new warning" link on a supermoderor's post, but an administrator will.
  • Reputation Effect: Amount of reputation points that will be subtracted from the user's account until the warning expires or is revoked/deleted.
  • Reputation-Based Self-Revokation Capability: Each warning can be set to allow the end user to buy the warning out in exchange for a certain amount of reputation points.
  
  
• Bonus! The following importer has been included into the package:
  • Inferno Warning System v1.3

VERSION HISTORY

1.3.1
Corrected a postbit_legacy template bug.

1.3.0
The first free release that is officially cross-compatible with both vBulletin 3.5 and 3.6.

1.2.2
[F] Corrected a licensing issue.
[F] Corrected a cron bug, which caused an sql error.
[F] Changed behavior of "Can View ___ Warnings" permission to cover the warning level displayed in posts.

1.2.1
[+] Reputation Points Option was removed from vBulletin Options. Instead, Reputation Effect can now be defined per Warning Type and even per Warning.
[+] Reputation-Based Self-Revokation Capability: Each warning can be set to allow the end user to buy the warning out in exchange for a certain amount of reputation points.
[+] Feature to enable creation of warning information threads in a specific forum.
[+] More detailed and better formatted usernotes and notifications.

1.1.0
[+] Ability to Issue Verbal Warnings
[+] Ability to Define a Fake Warner
[+] Automatic Usernotes Creation
[+] Warned Posts May Not Be Modified by the Author
[+] More sophisticated who's online handler
[+] Warning sign on warned posts

1.0.0
Introductory Release

INTRODUCTION

This hack includes a cron, which you do not need to manually add to your cron manager. The cron is added automatically for you once you install the product XML.
If you wish to import your warning data from another warning system, upload warn_import.php from ./do_not_upload/ to ./admincp/ and run it from your browser.

The installation manual is contained within the attached file.

IF YOU LIKE MY HACK, PLEASE CLICK INSTALL

[akanevsky]

Originally Posted by Junkie

I am sorry if my intelligence level is well below yours. But thanks for the additional help and hopefully this is the last time I need to ask you for any help.

I apologize if the post sounded offensive, but honestly - does it require a great level of intelligence to figure out that a coder in his right mind (and I consider myself one) would most likely not post a hack with a bug as obvious as fourty eight or something <hr>'s that don't make any sense. Would he?

Originally Posted by GoTTi

give him a week.

I am not sure what exactly are you implying here, but if you mean that this hack will soon become commercial, then I'll point out specifically for you the following quote from the FAQ in the second post:

Q: Why did this become a free product?
A: Seeing how there are plenty of alternative solutions that seem to satisfy users despite the fact they are full of bugs as well as the fact that vBulletin 3.6.0 has a warning system of its own, we decided that there is no point in having this hack as a commercial product anymore

Which means that this hack has been commercial and now it is no more.
Now, thank you for being so nice to post in my thread, GoTTi, and have a nice day.

[NFLfbJunkie]

Anthony, I still think this MOD is an awesome hack and would pay a nominal fee should you decide to start charging for it. I was only pointing out something that may have been a bug, and fortunately for this hack, and after I figured something out, was not one. It's the 'master coders' that make this, and all other hacks, possible for us 'members' to download and learn from, so maybe give us the respect that we usually give to you all. I hope I'm not sounding attacking; I'm just being appreciative of the work that you coders do for this community.

[akanevsky]

Anthony, I still think this MOD is an awesome hack and would pay a nominal fee should you decide to start charging for it. I was only pointing out something that may have been a bug, and fortunately for this hack, and after I figured something out, was not one. It's the 'master coders' that make this, and all other hacks, possible for us 'members' to download and learn from, so maybe give us the respect that we usually give to you all. I hope I'm not sounding attacking; I'm just being appreciative of the work that you coders do for this community.

Hmm, thanks for positive feedback. Now I feel bad for being rude in the first place. Have you been able to eliminate the appeareance of incorrect unread messages count? And I'll probably post a fix for the postbit later today.

[NFLfbJunkie]

Still can't figure out the double PM problem. Any help would be greatly appreciated Anthony, but no hurry. Thanks.

[akanevsky]

Originally Posted by Junkie

Still can't figure out the double PM problem. Any help would be greatly appreciated Anthony, but no hurry. Thanks.

What are the steps required to reproduce the problem?

[NFLfbJunkie]

When I (as the admin) issue a warning to a test user, I select the private message option to send a private message to the user receiving the warning. Then I log out as admin, log in as test user, and there are two messages that show as being in the inbox, but when going to the inbox, there is only one. Also, after deleting the one message, one message still shows as being in the inbox. Before running this test, I cleared all messages out of the test users inbox.

[akanevsky]

Please do what I said here:
https://vborg.vbsupport.ru/showpost....5&postcount=45
But do replace "user" with YOUR TABLE PREFIXuser

[NFLfbJunkie]

Have tried

UPDATE user SET pmunread = pmunread - 1 WHERE userid = fantasyf_vbuser

And still get

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'fantasyf_forums.user' doesn't exist

Sorry if I am missing something so basic when it comes to ruuning queries.

My database prefix is fantasy_f and my table prefix is vb.

[akanevsky]

You replaced the wrong thing. It should be:
UPDATE fantasyf_vbuser SET pmunread = pmunread - 1 WHERE userid = INSERT_YOUR_USERID_HERE

[NFLfbJunkie]

Did

UPDATE fantasyf_vbuser SET pmunread = pmunread - 1 WHERE userid = 1

And get

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'fantasyf_forums.fantasyf_vbuser' doesn't exist

Am I still missing something? Sorry for my inexperience.