User Thread Banning (Includes Time Banning Feature)

User Thread Banning (Includes Time Banning Feature)
By Shaolyen
email: John@eovie.com
msn: John@eovie.com

Brief intro:
------------------------
This hack enables mods, supermods and administrators to ban
users from viewing OR just replying to specific threads. It also
allows users to be banned from threads for specified amount of
time. After this time has expired, they will gain access/be able
to post again.

It adds a small link underneath the "Posts: #" in the postbit
template. Providing the user who posted did not start the thread,
a "[Thread Ban This User]" link will appear. (Only to mods, super
mods and admins.) For users who are already banned from a thread,
an "[Unban This User]" link will appear.

Forum leaders cannot be banned from threads. (The link will not
appear in their posts.)

When a forum leader clicks on the "[Thread Ban This User]" link,
they are taken to another page where they can:

a) choose whether the user can read the thread, or just not reply to it.
b) choose the length of the user's ban (in days).
c) type in a reason for the user's thread ban. This is displayed
when the user tried to access or reply to the thread.

When a user tries to access a thread or reply to one when banned,
the error message will provide a link to send a PM to the
moderator who banned them. This is something that some people
might not like - but if they're too scared to own up and explain
why they banned the user from the thread in the first place,
maybe they shouldn't be moderating! (If it really bothers some
people, I can provide them with the lines of code they need to
find and delete.)

A new page in the AdminCP will allow the admin to check all of
the current bans, as well as view archived ones. The reason for
the ban will be displayed in the Admin CP when the cursor passes
over the "Reason" link.

Enjoy.

[ForKmaN]

Me too, this hack is great.

[VampireMan]

Ah-hah this will do me nicely :-)

Im installing now

[Anarchnophobia]

i?m getting a blank page in admincp too... vb 2.2.9

the rest works fine, thank you

[LeeCHeSSS]

Ok, how to hide the quick reply box when a user is reply-banned:

In showthread.php find:

if (($bbuserinfo['userid']!=$thread['postuserid']) and (!$getperms['canviewothers'] or !$getperms['canreplyothers'])) {

Right BEFORE that, INSERT:

$threadban=$DB_site->query_first("SELECT COUNT(DISTINCT banid) AS activeban
                                  FROM bans
                                  WHERE userid=$bbuserinfo[userid] AND threadid=$threadid AND active=1
                                 ");

Next, find:

} else {
        $textareacols = gettextareawidth();
        eval("\$replybox = \"".gettemplate('showthread_replybox')."\";");
}

and right BEFORE that, INSERT:

} elseif ($threadban[activeban]!=0) {
        $replybox='';

That's it. And for the query freaks: yes it DOES add a query.

[Boofo]

So, use this code instead of what is in post #16 above? What about the editpost?

[LeeCHeSSS]

This merely hides the quick reply box, smart users could still reply if you do not use the code in post 16.

[Anarchnophobia]

any idea about the blank admin page meanwhile?

[Capt PPRuNe]

Installed the hack but now getting serious problem. The following code added in showthread.php:

PHP Code:

thread.postuserid AS puserid,bans.active AS active, 


and

PHP Code:

LEFT JOIN thread ON thread.threadid=post.threadid
LEFT JOIN bans ON bans.userid = post.userid AND bans.threadid=post.threadid AND active=1 


is causing an SQL error whenever trying to read a thread.

This is the error:

PHP Code:

Database error in vBulletin 2.3.0:

Invalid SQL: 
SELECT
thread.postuserid AS puserid,bans.active AS active,post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter

FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid

LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,810719,812243,812549,812889,837671)
ORDER BY dateline 

mysql error: Unknown table 'thread' in field list

mysql error number: 1109

Date: Saturday 19th of April 2003 07:56:44 PM
Script: [url]http://www.pprune.org/forums/forums/showthread.php?s=&threadid=85068[/url] 


I have removed the code for the moment and users can read the forums. Now the 'Thread Ban this user' link is still there and it is possible to ban users using the link. What doesn't happen is the link changing to 'Unban' which means mods who don't have access to the CP can't unban a banned user.

Any suggestions would be helpful.

I did have a problem running the SQL Query. It was generating an error so I ran the query without line breaks and it ran successfully.
:disappointed:

[Capt PPRuNe]

No experts out there that might be able to explain why

PHP Code:

thread.postuserid AS puserid,bans.active AS active, 


should cause the sql error

PHP Code:

Unknown table 'thread' in field list 


?

I've checked the structure of the tables and they are all ok.

Help! Please, anyone!

[Capt PPRuNe]

Problem fixed. I don't have avatars enabled on my forums and the sql code you wrote assumes that everyone has avatars enabled. No one else has reported this problem because I assume they all have avatars enabled.

If anyone needs the solution make a request on here.