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

[Slynderdale]

ok, if you still want the banned list without having the users show in thw show groups remove usergroup.showgroup = 1 so it looks like this. remember to change 9 to your banned usergroup

PHP Code:

// get banned users**********************************************************
$users = $DB_site->query("
    SELECT
        $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.usergroupid = 9
    "); 


[Webdude?]

Originally posted by fonzerelli_79
i get this dtatbase error

Database error in vBulletin 2.2.0:

Invalid SQL:
SELECT
userfield.field10, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field11
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 = 10

mysql error: Unknown column 'userfield.field10' in 'field list'

Anyone have an answer to this? I get the same thing.

[streamzone]

have a question on this i have installed it but the thing is, the page shows up but it doesnt list any person i have added too the banned group on the showbanned page any ideas what i might be?

[Slynderdale]

Originally posted by Webdude?


Anyone have an answer to this? I get the same thing.

When you made the new profile fields did you put them in numerical order from the last profile field, so if the original ones were 1 2 3 4 and you added a new one and names it 10 youll get the error so give it the value after the last one so if the original ones were 1 2 3 4 names the new ones 5 6 and change it in the config file, i had the same problem and this fixed it

[Slynderdale]

Originally posted by streamzone
have a question on this i have installed it but the thing is, the page shows up but it doesnt list any person i have added too the banned group on the showbanned page any ideas what i might be?

ok try this, find where you added this

PHP Code:

// get banned users**********************************************************
$users = $DB_site->query("
    SELECT
        $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 usergroup.usergroupid = [EDIT ME]

    "); 


remove usergroup.showgroup = 1 so it looks like this

PHP Code:

// get banned users**********************************************************
$users = $DB_site->query("
    SELECT
        $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.usergroupid = [EDIT ME]
    "); 


now the banned usergrop can be hidden from the forum leader section and still show up in the banned usergroup, see where it says [EDIT ME] change that to the banned usergroup number

[Slynderdale]

If you wanna show who banned them, in the showbanned.php first install the hack then after you installed it follow the text in the next post, the screen shot is below

[Slynderdale]

Heres the instructions

[inetd]

What for it is necessary to create new group Banned if is Banned by Moderators?

[inetd]

When Administrator or Super Moderator ban users, in showbanned.php don't show By Who.
Help me please!
And: add unban to mod CP - good suggestion. Please make this

[Slynderdale]

Originally posted by inetd
When Administrator or Super Moderator ban users, in showbanned.php don't show By Who.
Help me please!
And: add unban to mod CP - good suggestion. Please make this

ill make unban too, but if you use the admin cp, yoiu muest put in your name and when manualy in the account, if you use the mod cp, it adds your account to why you ban them manually, and i have it so if a mod banns some one it sets there user title to banned by moderator, it doesnt matter what the usergroup has