Mini Mods - Forum Section Ban - By Technidev

Mark as installed = get support!

Information
Sometimes there are users who keep ignoring warnings or keep trolling in a specific forum section, maybe it's not worth a forum ban so you want to give them a ban from that specific forum section only.

This plugin will make it possible to ban specific users from specific forum sections. By default, vBulletin only makes it possible for administrators to block a users access to specific forum sections through access masks.

The following settings are present in this plugin:

• Select which specific usergroups can ban users in all forum sections.
• Enable whether regular moderators who have powers in specific forum sections can ban people from these forum section.
• Choose whether:
  • Ban only from forumdisplay. (can still see thread contents in forum section)
  • Ban from forum section and threads in the forum section.
  • Ban from threads in the forum section. (can still see forumdisplay)

So how do I ban someone from a forum section?
In a thread, simply click on the username in the postbit of the user you want to ban and click on the issue ban button.
Anyone who has permission to ban people from forum sections can not be banned by others from the forum section.

You can unban someone from a forum section the same way.



Installation
1. Upload files in UPLOAD folder to root of your forum.
2. Import the XML file in the IMPORT folder.
3. Go to AdminCP > Settings > Options > Forum Section Ban - Technidev > configure to your needs.

Upgrade
If you want to upgrade from a previous version then all you have to do is re-upload the files in the UPLOAD folder.

Version History
1.0: Initial release.
1.1: Fixed bug of table name not existing when you use a table prefix.

Extra
Mark as installed = get support!

[Pimp of Pimps]

When I put up the .xml it makes it so we get a database error whenever we enter a thread. Any ideas?

[Dave]

Originally Posted by Pimp of Pimps

When I put up the .xml it makes it so we get a database error whenever we enter a thread. Any ideas?

Could you paste the database error (hide any sensitive information such as the IP, database name, etc.) here?

[Pimp of Pimps]

Originally Posted by Dave

Could you paste the database error (hide any sensitive information such as the IP, database name, etc.) here?

Database error in vBulletin 4.2.3:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,

editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid

, td_sectionban.id AS issectionbanned
FROM vb4_post AS post
LEFT JOIN vb4_user AS user ON(user.userid = post.userid)
LEFT JOIN vb4_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN vb4_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN vb4_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN vb4_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb4_customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN vb4_spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN vb4_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN vb4_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN vb4_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 55 AND postparsed.languageid = 1)
LEFT JOIN vb4_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 55 AND sigparsed.languageid = 1)
LEFT JOIN vb4_sigpic AS sigpic ON(sigpic.userid = post.userid)

LEFT JOIN vb4_td_sectionban ON (post.userid = td_sectionban.userid AND 5 = td_sectionban.forumid)
WHERE post.postid IN (01601609,1601610,1601611,1601623,1601637)
ORDER BY post.dateline;

MySQL Error : Unknown column 'td_sectionban.id' in 'field list'
Error Number : 1054
Request Date : Friday, May 19th 2017 @ 03:20:55 PM
Error Date : Friday, May 19th 2017 @ 03:20:55 PM
Script : http://www.millenniumforums.com/show...ello&p=1601637
Referrer : http://www.millenniumforums.com/forum.php
IP Address : 173.66.155.203
Username : Pimp of Pimps
Classname : vB_Database_MySQLi
MySQL Version : 5.6.35

Here you go

[Dave]

Thanks. I uploaded a new version (1.1) that should fix that bug.
Let me know if it fixes it.

[Pimp of Pimps]

Originally Posted by Dave

Thanks. I uploaded a new version (1.1) that should fix that bug.
Let me know if it fixes it.

Yes, it's working great now. Thanks!

[migratoria]

In the 1.1 version when you import the xml file, this error is generated:

Database error in vBulletin 4.2.4:

Invalid SQL:
ALTER TABLE `td_sectionban` ADD PRIMARY KEY (`id`), ADD KEY `userid` (`userid`), ADD KEY `forumid` (`forumid`);

MySQL Error : Multiple primary key defined
Error Number : 1068
Request Date : Saturday, May 20th 2017 @ 05:01:07 PM
Error Date : Saturday, May 20th 2017 @ 05:01:08 PM
Script : http://www.mysite.it/forum/admincpan...=productimport
Referrer : http://www.mysite.it.it/forum/adminc...?do=productadd
IP Address : xx.xx.xxx.xx
Username : xxxx
Classname : vB_Database_MySQLi
MySQL Version : 5.5.54-0+deb7u2

[Dave]

Originally Posted by migratoria

In the 1.1 version when you import the xml file, this error is generated:

If you already have it installed, you only have to re-upload the files in the UPLOAD folder.
I'll add it to my post.

[migratoria]

Originally Posted by Dave

If you already have it installed, you only have to re-upload the files in the UPLOAD folder.
I'll add it to my post.

It does not work yet

[Dave]

Originally Posted by migratoria

It does not work yet

Hmm I guess in your case you have to uninstall it first, then install it again.

[migratoria]

Originally Posted by Dave

Hmm I guess in your case you have to uninstall it first, then install it again.

Uninstalled and Reinstalled.
Now Works!

In td_sectionban.xml 1.1 Edit: <version>1.0</version>