Terry's Show Banned Users List Hack

Well, this is my first major hack, and my first php script to boot. It's not my original idea since there were several versions of this hack that existed for previous versions of vB, but I don't believe that one has been made for vB3 yet.


Anyhow, enough talk. This is a list that shows the past 30 banned users on your forums. When I update the hack I will make this number configurable, but in the meantime it works great like it is.

When you ban a user you can fill in a reason and if applicable, a URL to the offending post. When the user is banned their name goes into a list that displays all of this information and more. All users except guests have permission to view this list.


I could keep talking, but it's pretty self explanatory and the screenshots should explain anything I haven't said. Like I said, I am pretty new to PHP, so if anyone has any suggestions or feedback, please let me know. I hope I didn't forget anything.


Also, don't forget to click install and enjoy!

[Oblivion Knight]

This looks like a nice hack..

[alkatraz]

looks cool, thx!

this hack have some bugs: fiest, you put the table_prefix at the wrong place.. lol..:

[sql]SELECT " . TABLE_PREFIX . "userid, username, dateline, bannedpost, reason, sentbywhom, howlong FROM banlist ORDER BY banid DESC LIMIT 30[/sql]have to be:[sql]SELECT * FROM " . TABLE_PREFIX . "banlist ORDER BY banid DESC LIMIT 30[/sql]etc...

[wrongful]

Originally Posted by nexialys

this hack have some bugs: fiest, you put the table_prefix at the wrong place.. lol..:

[sql]SELECT " . TABLE_PREFIX . "userid, username, dateline, bannedpost, reason, sentbywhom, howlong FROM banlist ORDER BY banid DESC LIMIT 30[/sql]have to be:[sql]SELECT * FROM " . TABLE_PREFIX . "banlist ORDER BY banid DESC LIMIT 30[/sql]etc...

I have fixed this, and one other error that I noticed. If you have installed this hack up to this point it wouldn't hurt to redownload and replace showbans.php.

[platnum]

Damnnnnnnnnn... I've been wanting something like this for my site!!!! w00t w00t.. Loving it!.. I'll install it in a few

[platnum]

Installed .. Works like a charm.. I love it

[integra99]

I wish the banlist was drawn from current bans by usergroup, and not having to make another table in the database to store bans. Any chances of having the same templates and setup, just pulling the usernames and id's, reasons, etc from the current ban list instead?

Also be nice to show the usergroup that the user is banned to, because some of us have more than one ban usergroup

i prefer that version than the Reason for Banning hack that was released long time ago, so it's not using the usernotes and is not bloating the script structure...

btw, without adding the username, we can LEFT JOIN the SELECT to have the username of each banned person, so the username is not hardcoded in the table, and you also then filter the usergroups as integra99 wants...

[xug]

Yeah, make this work with the banned list we had before the point of installing this hack!
Further I love it so my members can see who,what,why instead of the team only, cool job, but please make it work with the original banned list.