[CAG CheechDogg]

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

[Dave]

Originally Posted by CAG CheechDogg

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.

[CAG CheechDogg]

Good stuff my Man thank you !

[Alan_SP]

Nice. And very useful!

[BrettC Frontier]

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?

[Dave]

Originally Posted by BrettC Frontier

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://www.vbulletin.org/forum/showthread.php?t=259017

[migratoria]

Where can I see a list of banned users?

[alcazarx]

Originally Posted by migratoria

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

[Dave]

Originally Posted by alcazarx

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

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

[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!