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 :)

Great!!!

Nice hack, great job!

Will this seperate onto multiple pages or will it continue all on one page (if yes to one page, could you make it to where after 10-20 members, it would split to multiple pages?).

SaintDog

Nice hack, well done.

Way cool :) fnx :)

Good job!

may be some screenshots?

I got a feature Request, it's probably easy

can you add the Ban Thingy from the Mod CP to the Admin CP?

as of now there unfortunately isn't any page seperation.. not sure if wired (who released it) will add this or not..

excerr: view www.somethingleet.com/forum/showbanned.php for the demo.

dalius: all you would do in the admin cp (a bit different from the mod cp) is change the user status to Banned in the User editor, and then go down to the bottom to the added Custom Profile fields and fill in the "Banned for" and "Banned until" fields, and then click submit. :)

Ah, thanks supreem

I get an empty page even though I have 2 members in the "Banned" group...any ideas ?

same here...

open up showbanned.php and find

change 15 to your banned usergroup ;)

Red= i don't understand, can somebody post an example code, because i don't know, how to make 2 new fields!
Green= Question by me
thx in adnace

DoDgE

in your admin CP... go to add under User Profile Fields..

then once the two profiles are created... look at the ID's of each one.. then edit it as requested for the config.php file.....

i tried editing the showbanned. but it still isn't working. very weird.

same here

dawl.. if you get it workin, let me know=)

sure will - i'm chalking it up to being sick, i'm obviously missing something simple...the fever has the brain garbled LOL I'll keep tinkering and let you know.

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'

it worked nice, THX!

have you done what I said?? get the usergroup number and place it at that part in showbanned.php??

worked for me! ;)

sure did, i'm clueless here, i've looked over showbanned.php a dozen times and can find nothing wrong, the usergroup is set to what it should be, I verified I had the right group # about 10 times LOL I still get a blank page...strange, very strange.

LMK were your forum is and I'll take a look if you want

Looks like neat hack but I can`t get the ids. :(

I get a blank page on showbanned.php.
I have made the changes to the showbanned.php
usergroupid to reflect the banned user group, number 10.

I also checked the profile fields on the db and they
match up with what I put in the config.php , so np there.

But blank page?

ah ha heres a tip :)

Viewable on Show Group=YES

In the install txt its written "(most likely you would set them all to 'No'"

This might be the problem, if anyone is still haveing them try this :)

Kewl hack...

edit: any help in getting banned users off the forum leaders
page . thanx

put it is yes? i will try it

EDIT-> Yup it works.... i tested it..

You have to put showable on groups as yes

Thank you...very useful :)

How do you get the id of the new usergroups?

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

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!

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? :paranoid:

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

^BUMP^

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

Thanks in advance

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

I think that is needed.

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

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