vb.org Archive - Mini Mods - Forum Section Ban

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Mini Mods - Forum Section Ban - By Technidev (https://vborg.vbsupport.ru/showthread.php?t=325076)

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.

https://vborg.vbsupport.ru/external/2017/05/2.png

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!

Will this work on all 4.x versions or just 4.2 ?

Quote:

Originally Posted by CAG CheechDogg (Post 2586479)

Will this work on all 4.x versions or just 4.2 ?

It should work on all of them, but since I only tested it on 4.2.* I can't guarantee that it will work properly on all previous versions.

Good stuff my Man thank you !

Nice. And very useful! :up:

Quick question,

"Ban from threads in the forum section. (can still see forumdisplay)"

Does this include the ability to ban/suspend users from viewing a single thread, or all threads?

Quote:

Originally Posted by BrettC Frontier (Post 2586626)

Quick question,

"Ban from threads in the forum section. (can still see forumdisplay)"

Does this include the ability to ban/suspend users from viewing a single thread, or all threads?

That option will ban the user from all threads that belong in the forum section.
However, they can still see forumdisplay, the page that lists all the threads.

This plugin is not used to ban someone from a single thread. You can use this plugin for that: https://vborg.vbsupport.ru/showthread.php?t=259017

Where can I see a list of banned users?

Quote:

Originally Posted by migratoria (Post 2586639)

Where can I see a list of banned users?

Would be nice indeed to have an overview which users are excluded from which forum, yes.
As the others said, nice useful addon :cool:

Quote:

Originally Posted by alcazarx (Post 2586641)

Would be nice indeed to have an overview which users are excluded from which forum, yes.
As the others said, nice useful addon :cool:

I'll work on a new version that has a page in the AdminCP to overview all bans.

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

Quote:

Originally Posted by Pimp of Pimps (Post 2586660)

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?

Quote:

Originally Posted by Dave (Post 2586661)

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

Quote:

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

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

Quote:

Originally Posted by Dave (Post 2586685)

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!

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

Quote:

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

Quote:

Originally Posted by migratoria (Post 2586728)

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.

Quote:

Originally Posted by Dave (Post 2586730)

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

Quote:

Originally Posted by migratoria (Post 2586741)

It does not work yet

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

Quote:

Originally Posted by Dave (Post 2586744)

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> :)

This is a great mod.

It would be great if the mod can have logs with the banned members, the section/sections where they have been banned from and the admin who banned them, date and time, etc.

Good idea, but the execution could be better.

Instead of entirely banning users from viewing forumdisplay or showthread, you should only hide the posting buttons in forumdisplay or showthread.

Sorry but banning them from viewing doesn't seem to makes much sense since they could just log out, you probably want to ban these users from posting instead. So could you update this product good Sir?

Quote:

Originally Posted by X-or (Post 2589947)

If they log out, then they can not post anyway. So Banning them from a specific section so they won't be able to post when they are logged is the whole idea of the mod and it makes perfect sense :)

^the point is why would you block someone from viewing the whole page when your intention is to prevent posting
why force users to log out, it's very unprofessional

there is no way I'm going to use this product as is

Not only that, the fact there's no logs as mentioned earlier, and no easy way to lift bans, makes this product very difficult for both users and administrators.

It's a good idea but it's nowhere near usable in its current state, it still needs a lot of polish.

Thee product is useful and I am using it, it just would be great to have logs for it. I doubt you have installed or tried the mod because you can easily unban the member who has been banned and you have the ability to ban the member from the whole section or from the threads only.

Is it possible that this its not working? Mods reports users can continue posting

Quote:

Originally Posted by tuRiver (Post 2596489)

Is it possible that this its not working? Mods reports users can continue posting

Are you using Tapatalk?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01167 seconds Memory Usage 1,809KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (15)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (28)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: