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

[cerebro]

Put the mouse over the EDIT link in the User CP / User Profile Field

and you will see
......action=edit&profilefieldid=5
There you have the ID...5 in this case!

That is the way i use...good luck

[cerebro]

in the Template showbanned

in the line

<table align="center"><tr><td>
$groupbits
<table cellpadding=0 cellspacing=0 border=0 bgcolor="{tablebordercolor}" align="center" width=100%><tr><td>
</td></tr></table>

You forget the " " to the width=100%
and in the other template to!

Correct that, and add a better install.txt

Thanks!

[Capt PPRuNe]

Why does it have to show up on 'Show Groups'? Is there a way to prevent that from happening? I understand why it has to be set to 'Yes' in the control panel.

Also, where do I edit either the templates or sripts so that when a moderator is in their own forum the option to ban shows up in the 'Admin Options' drop down menu?

Is there a way for a moderator to unban someone after they have banned someone? aranoid:

[Jawelin]

Great hack!

Just a question (or extension? ) : How could I avoid banned users be able to modify - accessing the userCP - their own email or password or some other data ? Above all, email...
Some banned user changed email to a non-existing one just to re-subscribe with the old one. Neither he would create another account !!!

Thanks

[Jawelin]

^BUMP^

[datatec]

Hey sounds really brilliant - does it work on 2.2.4 ?!?!?!?

Thanks in advance

[kidney]

If anyone need to add by who the person was banned by let me know I will release it if it's needed by someone else.
Example: http://forum.dishwacker.com/showbanned.php

[Marshalus]

I think that is needed.

[Jawelin]

Originally posted by kidney
If anyone need to add by who the person was banned by let me know I will release it if it's needed by someone else.
Example: http://forum.dishwacker.com/showbanned.php

Here I'm !!!
Besides, I asked also for a general feature: how to avoid a banned user could access to his post (editing and deleting them) and his UserCP to change email or something else... ??

Thanks.
I'll wait for your upgraded version

[kidney]

here it is.....
https://vborg.vbsupport.ru/showthrea...threadid=36819

[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