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

[GOD-Dblade]

bleh i feel like a n00b well...this is what i got
Database error in vBulletin Mod Control Panel 2.2.5:

Invalid SQL: UPDATE user SET usergroupid=8 WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Sunday 12th of May 2002 09:07:20 PM
Script: http://www.gods-network.com/forums/forums/mod/user.php
Referer: http://www.gods-network.com/forums/m...an&userid=2476

in my config file i have
//set fieldid's of banreason field and banuser field
$banreasonfieldid=8;
$banuntilfieldid=9;

and i also changed in showbanned.php to try to fix it this
$banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect
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

to

$banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect
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 = 8

[GOD-Dblade]

i guess no suport for this hack?

[Slynderdale]

message me on aim ill help

[Dalius]

Can I make it so the banned users only show up on the Banned list, not the Forum Leaders list (showgroups.php)

[Slynderdale]

Originally posted by Dalius
Can I make it so the banned users only show up on the Banned list, not the Forum Leaders list (showgroups.php)

i explained how in previouse posts

[Matt87]

I got it to work... nevermind...lol

[vBHackz]

I dont understand, I make 1 user group for the banned user, and another one to show why he/she has been banned?

[vBHackz]

Im very lost, and super confused, someone help lol

[vBHackz]

...............................

[inetd]

Originally posted by vBHackz
I dont understand, I make 1 user group for the banned user, and another one to show why he/she has been banned?

Make Banned group. Or rename Banned by Moderators to Banned.