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]

Are you sure that fantasyf_vb is the correct prefix used in your database? Double check config.php.

[NFLfbJunkie]

Actually, it is fantasyf_forums. So i then change it and run

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

And get

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

Boy I'm lost.

[akanevsky]

Try this:
UPDATE fantasyf_forumsuser SET pmunread = pmunread - 1 WHERE userid = 1

There is no '_' between prefix and actual table name. So, your table names for queries are written like this:
PREFIXNAME_OF_TABLE

If table name is user, and prefix is helloworld, then in a query, you would write:
helloworlduser

[NFLfbJunkie]

Now get

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

I don't want to waste your time with this, but is this something you're still trying to figure out on your end?

[NFLfbJunkie]

Also tried

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

And get an error.

[akanevsky]

No, I am not trying to figure this out because I cannot without seeing the contents of your config.php file.

[mikeylikesitz]

Fatal error: Call to undefined function: fetch_ws_level() in /usr/local/apache/htdocs/forum/warn.php on line 195

when i try to issue a warning for a user, any ideas?

and also the warn_import.php file still links to your site asking for a license key and doesnt allow continue.

[o0Hubba0o]

That's cool that you released for free based on other mods like this and vB's included feature.

Now I just wish I could get that battle system for my graphics site.

[akanevsky]

Originally Posted by mikeylikesitz

Fatal error: Call to undefined function: fetch_ws_level() in /usr/local/apache/htdocs/forum/warn.php on line 195

when i try to issue a warning for a user, any ideas?

and also the warn_import.php file still links to your site asking for a license key and doesnt allow continue.

Yeah, I forgot to remove the licensing code from it. File re-uloaded. As for the error... make sure you imported the product XML and that plugins are enabled.

[mikeylikesitz]

it is imported and plugins are enabled.

thanks for the new import file.