Add-On Releases - afterfl0w's Advanced Banlist

afterfl0w's Advanced Banlist! - Version 2.51
updated 13/08/06

Hey all, it's time for another release. This one has been completely re-written and made a lot easier to install! Also, it's vB3.6 and 3.5 compatible!

Onto the buzz:

Features

• Simple, yet advanced display of banned users
• Easy-to-set up! 15 minutes or less install time!
• Import ALL your old bans into this permanent record of banned users!
• Automatic post edit of offending post, to show warning that the user was banned!
• Ban types, length, liftdate, bandate all shown on the list
• Complete support from me, including custom modifications to the banlist
• ADDED IN VERSION 2.51 - admin_banlist.php section for AdminCP! From there, you can clear the banlist, import bans, and selectively remove bans from the list!
• ADDED IN VERSION 2.51 - Template edit for postbit that adds easy [Ban User] link!
• FIXED IN VERSION 2.51 - Fixed Issues with Importing!
• FIXED IN VERSION 2.51 - [Ban User] link no longer sends the linked page to main
• FIXED IN VERSION 2.51 - Fixed compatibility errors with the product and showbans.php for older/newer versions of PHP

Quick install, added what everyone wanted, and made it easy to install! What more could you want!

Installation

Upload the product-aft_banlist.xml to your vB products, and then open the included README_FIRST!!.html file, and cycle through the instructions.

Afterwards, upload the showbans.php to your vB root and you're ready to go!

Importing Old Bans

This was HIGHLY requested in the last version, and I'm a fool for not including it.

Upload the import_bans.php file to your admincp folder, and then navigate to, for example, www.site.com/forums/admincp/import_bans.php.

Follow the instructions, which are as easy as pushing a button , and delete the file afterwards!

Upgrading

If you are upgrading, remove the old banlist table and replace all files!

Troubleshooting/Problems

Any problems or issues with this modification can be either posted in this thread, sent to me in a PM or e-mailed to me at flamethrower_stickattack@hotmail.com

You can also add me to MSN and I'll be able to offer support most of the time.

Install and MOTM Votes

I'm not going to force you to hit the install button, or push it on you, but it'd be greatly appreciated if you do! Also, if you REALLY like this hack, please vote it for MOTM(MOD OF THE MONTH)

[Jesus05uk]

I'm getting this:

Database error in vBulletin 3.6.0 Release Candidate 3:

Invalid SQL:
CREATE TABLE banlist (
         banid int(10) unsigned NOT NULL auto_increment,
         userid smallint(5) NOT NULL DEFAULT '',
		 usergroupid smallint(5) NOT NULL DEFAULT '',
         username varchar(50) NOT NULL DEFAULT '',
         dateline int(10) unsigned NOT NULL DEFAULT '',
         bannedpost varchar(255) NOT NULL DEFAULT '',
         reason varchar(255) NOT NULL DEFAULT '',
         sentbywhom varchar(50) NOT NULL DEFAULT '',
         howlong int(10) unsigned NOT NULL DEFAULT '',
         INDEX (banid, userid)
                );

MySQL Error  : Invalid default value for 'userid'
Error Number : 1067
Date         : Saturday, August 12th 2006 @ 03:49:32 PM
Script       : http://forums.gmodcentral.com/admincp/plugin.php?do=productimport
Referrer     : http://forums.gmodcentral.com/admincp/plugin.php?do=productadd
IP Address   : 82.44.204.98
Username     : Jesus
Classname    : vb_database

[afterfl0w]

Hmm, I only tested on the full release of vB3.6.

Maybe someone else knows the reason for that? There's nothing wrong with the SQL.

[Jesus05uk]

Originally Posted by afterfl0w

Hmm, I only tested on the full release of vB3.6.

Maybe someone else knows the reason for that? There's nothing wrong with the SQL.

Upgrading to Gold now.
Still no luck.

[afterfl0w]

Anyone else having this problem?

EDIT: Jesus, I'm still seeing Powered by vBulletin Version 3.6.0 Release Candidate 3 at the bottom of your forums.

You sure you upgraded?

[Dan]

Nice job

[afterfl0w]

Update coming soon, since the Import feature appears not to work on an empty database.

[iTaLiAnBoY165]

Hey when i try to import bans i get alot of these errors and then no bans imported.

error:
Warning: Cannot use a scalar value as an array in /admincp/import_bans.php on line 127

[afterfl0w]

Read post above yours. It's being worked on.

[Firestar.chkn]

Hi,

I just installed this. I uploaded the files, made the changes to the bannings.php file, and imported the plugin.

I'm not sure though, if there are some instructions missing. I can see the options section, but I cannot see the ban/unban user section in the postbit.

Also, when I try to import the bans, I get an error message saying that I should be an admin to do it, and that I don't have permissions.

Running 3.6 gold.