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

[69-FLy-gUy]

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

[dawl]

same here

[69-FLy-gUy]

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

[dawl]

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.

[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'

[Robert9]

it worked nice, THX!

[Bald Bouncer]

Originally posted by 69-FLy-gUy
i tried editing the showbanned. but it still isn't working. very weird.

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

worked for me!

[dawl]

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.

[Bald Bouncer]

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

[Barret]

Originally posted by 69-FLy-gUy
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.....

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

[irn-bru]

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?

[irn-bru]

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

[69-FLy-gUy]

put it is yes? i will try it

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

You have to put showable on groups as yes

[Whome]

Thank you...very useful

[Barret]

How do you get the id of the new usergroups?