Hellban 0.1

UPDATED!!! AGAIN!

This is a more effective solution than the standard "ban", and is meant to be used for very annoying troublemakers that keeps re-registering once banned. Anyway - once a user is placed under the "Hellban", the following happens:

1. Every 3:d time the user tries to load a page, he is greeted with a fake "500 Internal Server Error" message.

2. Nobody but moderators and the user himself can see his posts. He is, essentially, under a site-wide ignore.

This may not be a 100% fail-safe solution, but a lot of the morons will hopefully get tired and go away.

Here is how it's done:

1. Run the following query on your database:

INSERT INTO usergroup VALUES("666","Hellban","","0","1","1","1","1","0", "1","0","0","0","1","1","1","1","0","0","1","1","1 ","0","0","1","0","0","0","0","0","0","0","0","1") ;
ALTER TABLE post ADD hellban INT UNSIGNED;
ALTER TABLE thread ADD hellban INT UNSIGNED;

2. Add this at the bottom of you global.php

PHP Code:

if ($bbuserinfo[usergroupid] == 666) {
  
  $randnum = mt_rand(1,3);
  if ($randnum == 1) {
    header("HTTP/1.0 500 Internal Server Error");
    exit;
  }   

} 


3. Find this in newreply.php:

PHP Code:

$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes(htmlspecialchars($postusername))."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')"); 


REPLACE it with this:

PHP Code:

if ($bbuserinfo[usergroup] == 666) {
  $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible,hellban) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes(htmlspecialchars($postusername))."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible','$bbuserinfo[userid]')");
} else {
  $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes(htmlspecialchars($postusername))."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')");
} 


4. find this in newthread.php

PHP Code:

$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount')"); 


PHP Code:

if ($bbuserinfo[usergroup] == 666) {
  $DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach,hellban) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount','$bbuserinfo[userid]')");
} else {
  $DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount')"); 
} 


in that file, also find this:

PHP Code:

$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','1')"); 


PHP Code:

if ($bbuserinfo[usergroup] == 666) {
  $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible,hellban) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','1','$bbuserinfo[userid]')");
} else {
  $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($subject))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','1')");
} 


After that, find this:

PHP Code:

if ($visible==1) {
        $DB_site->query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."' WHERE forumid IN ($foruminfo[parentlist])");
} 


and replace with this:

PHP Code:

if ($visible==1 && $bbuserinfo[usergroup] != 666) {
  $DB_site->query("UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='".time()."',lastposter='".addslashes($postusername)."' WHERE forumid IN ($foruminfo[parentlist])");
} 


I showthread.php, find this:

PHP Code:

  $getpostids=$DB_site->query(" 
    SELECT post.postid FROM post
    WHERE post.threadid='$threadid' AND post.visible=1 
    ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage 
  "); 


Replace with this:

PHP Code:

if ($bbuserinfo[usergroupid] == 666 || ismoderator($forumid)) {
  
  $getpostids=$DB_site->query(" 
    SELECT post.postid FROM post
    WHERE post.threadid='$threadid' AND post.visible=1 AND post.hellban = '$bbuserinfo[userid]'
    ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage 
  ");  
  
} else {

$getpostids=$DB_site->query(" 
    SELECT post.postid FROM post
    WHERE post.threadid='$threadid' AND post.visible=1 AND post.hellban = NULL
    ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage 
");

} 


in forumdisplay.php, find this:

PHP Code:

    $getthreadids=$DB_site->query("
    SELECT
    ".iif($sortfield=="voteavg",$votequery,"")."
        thread.threadid
    FROM thread
    WHERE thread.forumid = $foruminfo[forumid]
        AND thread.sticky=0
        AND thread.visible=1
    $datecut
    $limitothers
      ORDER BY sticky DESC, $sortfield $sqlsortorder
      LIMIT ".($sel_limitlower-1).",$perpage"); 


Replace that with this:

PHP Code:

if ($bbuserinfo[usergroup] == 666) {
  $getthreadids=$DB_site->query("
    SELECT
    ".iif($sortfield=="voteavg",$votequery,"")."
        thread.threadid
    FROM thread
    WHERE thread.forumid = $foruminfo[forumid]
        AND thread.sticky=0
        AND thread.visible=1
        AND thread.hellban = NULL
        AND thread.hellban = '$bbuserinfo[userid]'
    $datecut
    $limitothers
      ORDER BY sticky DESC, $sortfield $sqlsortorder
      LIMIT ".($sel_limitlower-1).",$perpage");
      
} else {
  
    $getthreadids=$DB_site->query("
    SELECT
    ".iif($sortfield=="voteavg",$votequery,"")."
        thread.threadid
    FROM thread
    WHERE thread.forumid = $foruminfo[forumid]
        AND thread.sticky=0
        AND thread.visible=1
    $datecut
    $limitothers
      ORDER BY sticky DESC, $sortfield $sqlsortorder
      LIMIT ".($sel_limitlower-1).",$perpage");
  
} 


Now, whenever you want to get rid of a user, simply set him or her to usergroup Hellban.

[chris frolic]

I loved the 505 error bit, so I only took that bit from this hack, and removed the random number generator so that it happens everytime, and the person is effectively locked out of the board for good. (unless they clear their cookies - but most probably won't even know whats going on).

[Demascus]

When i tested this on my forum on my machine, after editing the showthread.php i couldnt see the thread at all. every thread was blacked out. i dunno what the problem is

[Link14716]

Ok, I tried to install this (on 2.2.6), but at the showthread.php part, after I saved the file, no posts where visible....

[Link14716]

BUMP

[DarkReaper]

Major bump

[rishel]

Ultra bump

[Taco John]

Is this thing going to make it to a final? Sounds like an interesting hack.

[remal]

hi

i have this proplem:

Parse error: parse error, unexpected ')' in /home/forumcom/public_html/newthread.php on line 228

here is line 228:

PHP Code:

  $DB_site->query("INSERT INTO thread  (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach,hellban) VALUES (NULL,'".$subject))."','".time()."','$forumid','1','0','".$postusername)."','$bbuserinfo[userid]','".$postusername)."','".time()."','$iconid','$visible','$attachcount','$bbuserinfo[userid]')"); 


[lupinko]

Can this hack be used for vB3.0.3?

[peterska2]

Search for the miserable users modification which is available for version 3.0.x and 3.5.x which does the same thing.