Miscellaneous Hacks - Banned Users List

NOTE: This mod is marked "unsupported", but I'll try my best (as time permits) to help those who have marked as installed.


What is this!?
This modification will allow you show a page containing all of your banned users. I suppose you could think of this as a public "Wall of Shame", per say.


Check the screenshots to see exactly what is displayed.


Current Version
1.1.6


Features flagged for future version(s):

• Looking for suggestions

Will this work on x.x.x ??
Unless otherwise stated, this will work on all 4.0 versions. If you would like to use the vB 3.x version, you can find it here.


Sounds cool. How do I install?

1. Upload everything inside the "upload" directory of the zip file to your forums.
   
   • banned.php => To your FORUM ROOT directory
   • functions_bannedusers_list.php => To your FORUM_ROOT/includes directory
2. Login to your Admin Control Panel and go to "Plugins & Products" -> "Manage products"
   
   • Click on "Add/Import product"
   • Browse for "product-bannedusers.xml" (included in the zip file), and click "Import"
   • If upgrading from an older version, then set "Allow Overwrite" to "Yes".
3. In your admin control panel go to vBulletin Options => Banned Users List
   
   • Edit the Usergroups that you do not want to show the banned members list to.
4. Optional: Only if the auto template injection does not work, as the template hooks were not found.
   
   • In the "navbar" template, find:
     

     • {vb:raw template_hook.navbar_quick_links_menu_pos3}

   • Below it, add:
     

     • <vb:if condition="$vboptions['bannedusers_enabled'] AND $vboptions['bannedusers_hidefrom'] AND !is_member_of($bbuserinfo, $vbptions['bannedusers_hidefrom'])"><li><a href="./banned.php{vb:raw session.sessionurl}">{vb:rawphrase bannedusers_text}</a></li></vb:if>

Upgrade

1. Login to your Admin Control Panel
2. Go to "Plugins & Products" -> "Manage products"
3. Click on "Add/Import product"
4. Browse for "product-bannedusers.xml" (included in the zip file)
5. Set "Allow Overwrite" to "Yes", and click "Import"
6. Upload and overwrite 'banned.php' and '/includes/functions_bannedusers_list.php'

Changelog
v1.1.6 - October 20th, 2013
-- Removed unnecessary text from template.

v1.1.5 - June 23rd, 2011
-- Added 'bannedusers_navbar' to the cache, it was previously uncached (props to Delphiprogrammi).
-- Added suggestion by Clamshells: allow the columns to be sorted ascending or descending.
-- Updated template HTML/CSS to hopefully fix the pagination display issue.
-- Updated to be compatible with vB 4.1.x, should be compatible back to 4.0.5

v1.1.4 - August 20th, 2010
-- Made changes to how the scripts checks which usergroups has access to the banned list
-- Corrected a pagination bug that added the wrong sort by value

v1.1.3 - August 11th, 2010
-- Updated template HTML for vB 4.0.5
-- Updates to style/css to use stylevar for border colors, improved link css for sorting
-- Some minor updates to banned.php

v1.1.2 - June 26th, 2010
-- Fixed sort links (props to Konkere for pointing out the bug)
-- Should now use stylevars from current style, instead of default colors.
-- Two templates were not being cached, should now be fixed.

v1.1.1 - November 20th, 2009
-- When querying for banned usergroups, added a check in banned.php to make sure we had groups to query with.
-- Should never happen, but added check to see if usergroupcache is empty, and rebuild if it is.
-- Added ability to sort by username, banned by, banned on, ban lift date (table columns are links)

v1.1.0 - November 17th, 2009
-- Update to be compatible with vB4.0

v1.0.1 - August 5th, 2009
-- Added: AdminCP option of usergroups that are not allowed to view the banned members list.
-- Added: Template edits can now be done automatically if enabled.

v1.0.0 - April 12th, 2009
-- Initial Release


NOTE: This mod is marked "unsupported", but I'll try my best (as time permits) to help those who have marked as installed.

[Eric]

reserved.

[taffy056]

This looks so cool, I saw something like this on the big boards list sometime ago, tag it for future use

[Eric]

One thing about this, is that it uses tables - which is fine I suppose - but I based the css / table off of how vB 4 does the memberlist. It looks good, imho, but I'm just not a big fan of tables.

If you have any suggestions feel free to let me know

[abdobasha2004]

nice
reserved

[woffie]

It would be nice if there were a link in the banlist to "all IP's used by this member".

[Marv]

Good job, but I´ll add 2 suggestions:
- what about an option to sort them by date instead of their usernames ? Guess that offers a better benefit for the admins out there.
- what about a searchbox for the banlist ?

[garretbyrne]

Hi thanks for modding this.. I ran into a problem though while installing it...

----------------------
Database error in vBulletin 4.0.0 Beta 3:

Invalid SQL:

SELECT
userban.userid, adminid, bandate, liftdate, reason,
user.username as username,
admin.username as adminname, admin.displaygroupid as admindisplaygroupid, admin.usergroupid as adminusergroupid
FROM userban as userban
LEFT JOIN user as user ON(user.userid = userban.userid)
LEFT JOIN user as admin ON(admin.userid = userban.adminid)
WHERE user.usergroupid IN ()
ORDER BY bandate DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY bandate DESC' at line 8
Error Number : 1064
Request Date : Thursday, November 19th 2009 @ 01:59:38 AM
Error Date : Thursday, November 19th 2009 @ 01:59:38 AM
Script : http://forum.**************.org/banlist.php
Referrer :
IP Address : **.**.**.**
Username : Garret
Classname : vB_Database
MySQL Version : 5.0.81-community
--------------------------

Any help you can provide would be really appreciated..

Regards
Garret

[fta2k]

Installed and working fine.

Note to anyone like myself that didn't completely read the setting description:

If you put a 0 or leave blank on users who cannot see it, it will NOT work.

[Eric]

Originally Posted by woffie

It would be nice if there were a link in the banlist to "all IP's used by this member".

Originally Posted by Marv

Good job, but I?ll add 2 suggestions:
- what about an option to sort them by date instead of their usernames ? Guess that offers a better benefit for the admins out there.
- what about a searchbox for the banlist ?

I'll look into adding these

Originally Posted by garretbyrne

Hi thanks for modding this.. I ran into a problem though while installing it...

----------------------
Database error in vBulletin 4.0.0 Beta 3:

Invalid SQL:

SELECT
userban.userid, adminid, bandate, liftdate, reason,
user.username as username,
admin.username as adminname, admin.displaygroupid as admindisplaygroupid, admin.usergroupid as adminusergroupid
FROM userban as userban
LEFT JOIN user as user ON(user.userid = userban.userid)
LEFT JOIN user as admin ON(admin.userid = userban.adminid)
WHERE user.usergroupid IN ()
ORDER BY bandate DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY bandate DESC' at line 8
Error Number : 1064
Request Date : Thursday, November 19th 2009 @ 01:59:38 AM
Error Date : Thursday, November 19th 2009 @ 01:59:38 AM
Script : http://forum.**************.org/banlist.php
Referrer :
IP Address : **.**.**.**
Username : Garret
Classname : vB_Database
MySQL Version : 5.0.81-community
--------------------------

Any help you can provide would be really appreciated..

Regards
Garret

Originally Posted by fta2k

Installed and working fine.

Note to anyone like myself that didn't completely read the setting description:

If you put a 0 or leave blank on users who cannot see it, it will NOT work.

garretbyrne, you need to edit the mod's settings and include who can not see that list - which by default should be banned members themselves. I'll look into change how this works in the next version.