Banned Users List (with reason/date)

here it is, the Banned Users List hack, originally done by my host wired @ www.xirgo.com but he gave me rights to release it here..

basically this hack lists all banned users along with a reason for each user being banned, as well as the date they should be unbanned. this is VERY convenient for my mods over at my forum, as there was always talk of wondering who was banned and why, and with this hack this talk shall cease to exist. this is also great just to get your bannings organized and see how many users are banned in the first place.

a live demo of this hack is viewable on my forum: www.somethingleet.com/forum/showbanned.php ..

also when a mod bans someone from the mod cp, the reason and date is asked. the date doesn't have to be in a date format, it can be just 'forever' or something.

this hack has only been completely tested on vb2.2.2.. as of tomorrow it will be tested on vb2.2.4 when i upgrade my forum.

let me know what you guys think

[SinisterX]

looks good, wish i could get the day the person was banned tho.

[Gutspiller]

I get this error when I try and view showbanned.php

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin: Invalid SQL:
SELECT
userfield.field21, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field22
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 15

mysql error: Unknown column 'usergroup.showgroup' in 'where clause'
mysql error number: 1054
Date: Friday 04th of July 2003 06:47:56 PM
Script: /forumz/showbanned.php
Referer:

Any ideas?

[Shiekron]

Warning: mysql_pconnect(): Access denied for user: 'dorksnet@cp4.myhostdns.org' (Using password: YES) in /home/dorksnet/public_html/talk/admin/db_mysql.php on line 38

Anyone have an idea?

[Darkwaltz4]

shiekron, that means your config file is messed up, and the password to your database does not match.

also, i installed this hack just yesterday without reading this thread whatsoever, and i edited it greatly, creating my own 'banned by' and even (although i didnt know this was requested) a 'banned when'. i also ordered it alphabetically.
i also incorporated 2 drop down menus for the 'reason' and 'time' fields because my mods were not filling out the fields, so now they only have to select what they want it to be when they ban someone.

so, if youd like to see what im talking about,
http://forums.ffgon.com/showbanned.php

and like i said i made all the edits myself, i didnt even use the mod posted above for who banned, i havent even seen the inside of the attachment. if youd like to know what to do im me on something. note: since this hack is new on my board and weve had previous banned members, it still shows them up. i however defaulted them to have a 0 timestamp, and Unknown reasons and banners. for an actual person banned under the new edits, look at the user 'Inuyasha'

[lifesourcerec]

Will this be available for vB3?

[influence]

vb3 version of this coming out anytime soon?

[sully02]

Originally Posted by influence

vb3 version of this coming out anytime soon?

I would also love a vB3 version of this.

[fridayweb]

Putting in my vote for vb3 version as well. I had used this hack previously, but now with the upgrade, I just have one page with a banned showgroup all in a list. Looks pretty ugly.

[integra99]

vb3 for sure.

[Slynderdale]

Working on a vB 3 version of this.