Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture

Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture - Version 1.1

Okay, this is my private forum's custom warning/ suspension/ banning system and postbit moderator system. This is a fairly involved hack, so it is crucial that you follow the instructions closely. It would benefit experienced hackers the most. The following instructions are for an unhacked board. If you have hacked your board, or use different moderator usergroups, just make the appropriate changes.


With this hack, your staff and you will be able to:

1) Add/ Substract/ Reset Warning Points for a Member from a Popup Window in Postbit.

2) When the Member has Warning Points that reach a set level (up to you), the Member will be Automatically Banned.

3) Easily View a Member's Warning Points in the Postbit.

4) Have the ability to easily Edit a Member's Avatar/ Profile Pic/ Sig/ Reputation comments from a Popup Window in Postbit.

5) Suspend temporarily or Ban permanently a Member from a Popup Window in Postbit.

6) Have 2 categories of Banned Members -

..... a) Normal Banned members where the posts all remain, and

..... b) Troll Banned members, where all the posts in this usergroup

.......... i) Automatically becomes Invisible from all other members! You no longer have to manually search and delete their posts. They virtually disappear from your forums when they get put in this usergroup. Also, Troll Banned members get

.......... ii) Fake 404 errors and can no longer access your site.


Please be aware that this hack is designed for my private forums. If you want additional features, or customization, you have permission to do this yourself. Please do not expect me to customize this hack for your site.

FWIW, I've had this system running for 2 years now (obviously with different code). Time for me to share...

The installation instructions are in the HTML file in the ZIP file below. The warn.php is also in the ZIP file.


Screenshots:

1. Options available with the dropdown menu for staff.

https://vborg.vbsupport.ru/attachmen...chmentid=15463


2. Popup window from postbit to warn members.

https://vborg.vbsupport.ru/attachmen...chmentid=15466


3. Popup window from postbit to suspend or ban members.

https://vborg.vbsupport.ru/attachmen...chmentid=15465


4. Popup window from postbit to edit signature.

https://vborg.vbsupport.ru/attachmen...chmentid=15468


5. Popup window from postbit to edit avatar.

https://vborg.vbsupport.ru/attachmen...chmentid=15469


NOTE: You can also edit profile pictures, reputation comments, etc. but I can't be bothered making screenshots of all the features.

Enjoy!

With Erwin's Permision I've made an HTL Version of this hack.

HTL version (thanks to Dan) here:

Attached FilesWarning_System_Automatic_Ban_Make_Posts_Invisible_ Edit_Signature_Avatar.htl

Normal version here:

[SnowBot]

aahh that sounds great. Any idea on time scale. I am only asking as i will ununistall this and install the new one when its out.

[HuangA]

I installed this on a 3.0.3 installation; after following all the instructions etc, I was able to get the menu to appear; but when I click warn user, the new window comes out blank! Is this hack compatiable with 3.0.3? Did I do something wrong?

Ok, here's what I found out after some reading...

The code is looking for "warn" template, which I did not add because it was NOT included in the package. Can someone please kindly post the warn/warning template that we're suppose to add?

[Bro_Joey_Gowdy]

clicks install

I have had the excact samt problem. But was a little confused about the post from "Zero Tolerance". Here the hole edited code-section. I hope this can help others:

$getthreadids = $DB_site->query("
SELECT " . iif($sortfield == 'voteavg', $votequery) . " threadid, " . TABLE_PREFIX . "user.usergroupid AS usergroupid
FROM " . TABLE_PREFIX . "thread AS thread
$deljoin LEFT JOIN " . TABLE_PREFIX . "user ON " . TABLE_PREFIX . "user.userid = postuserid
WHERE forumid = $foruminfo[forumid]
AND sticky = 0
AND visible = 1
AND usergroupid<>24
$globalignore
$datecut
$limitothers
$delthreadlimit
ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
LIMIT $limitlower, $perpage
");

Originally Posted by Zero Tolerance

Someone else has had this error, and im getting it too

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:  
        SELECT  threadid, user.usergroupid AS usergroupid 
        FROM vb3_thread AS thread 
          LEFT JOIN vb3_user ON user.userid = postuserid 
        WHERE forumid = 5 
            AND sticky = 0 
            AND visible = 1 
            AND usergroupid<>17 
             
            AND thread.lastpost >= 1075634033 
             
             
        ORDER BY sticky DESC, thread.lastpost DESC 
        LIMIT 0, 20 
    
mysql error: Unknown table 'user' in field list

Ive redone edits for all files, still didn't work, maybe if you could point out the exact edit that fixes this that might help, but i dont see any ive missed and ive gone through them all

Edit:

I fixed it, in the code i changed user. (2 times) to

PHP Code:

" . TABLE_PREFIX . "user. 


Seems those with a prefix may have trouble with this

There are missing som "TABLE_PREFIX" lines ind the file warn.php

Here are my code-section (that works for me)

if ($action == "doadd") {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=$warnfield+1 WHERE userid='$newuser'");
if ($warnings >= $warnpoints) {
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET usergroupid=$banusergroupid, usertitle='Banned' WHERE userid='$newuser'");

}
$error = "<b>Message:</b> You have warned this member!";
	$show['closewindow'] = true;
}
if ($action == "dominus") {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=$warnfield-1 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have warned this member!";
	$show['closewindow'] = true;

}
if ($action == "doreset") {
$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=0 WHERE userid='$newuser'");
$error = "<b>Message:</b> You have warned this member!";
	$show['closewindow'] = true;

[ImportPassion]

for some reason I am getting a 500 error on this now. i think it was the 3.02 upgrade, but not sure when it happened

[Seekers]

This was my first attempt at installing a hack and I apparantly blew it. When I click on a users name I only get the default option instead of the hack options to ban, warn, etc.

Anyone have any idea what I did wrong. I was very careful and deliberate as I went through the instructions but must have missed something.

Thanks,

[Dennis Olson]

Erwin...

1) Does this hack work for vB3.0.3?

2) Did you get your "proper warning" code added?

Thanks!

[Erwin]

Originally Posted by Dennis Olson

Erwin...

1) Does this hack work for vB3.0.3?

2) Did you get your "proper warning" code added?

Thanks!

It works for 3.0.3 - actually, I installed integrated my hack with the other warning hack, and added a whole bunch of stuff including PM user on thread delete/ closure/ move, email user on ban, a whole lot of stuff. This hack is actually redundant. I can't release my current system as I'm using code from the other warning hack.

[SnowBot]

Originally Posted by Erwin

It works for 3.0.3 - actually, I installed integrated my hack with the other warning hack, and added a whole bunch of stuff including PM user on thread delete/ closure/ move, email user on ban, a whole lot of stuff. This hack is actually redundant. I can't release my current system as I'm using code from the other warning hack.

I know you can not release the whole hack as like you said you used some code from it, but anychance you may release add-ons for it So we have the best of both? I love this hack but i was hanging around for the updates.