afterfl0w's Advanced Banlist

[afterfl0w]

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

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 link!
[b]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 (mailto: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) :D

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

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

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

[Firestar.chkn]

Sorry, only saw the post now. Thanks :D

[iTaLiAnBoY165]

Sorry didnt refresh before i posted

[Tork64]

lol real cool thx

[Jesus05uk]

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

Yes - I'm not using the phrase, I just put plain text there.
(Which i'll update now)

[Robbed]

Kinda off topic, Is there a way to add a field in the postbit to show how many bans an admin has.

Maybe have an option to turn it on and off.

[afterfl0w]

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.

Uh oh, forgot that template edit.

UPDATE COMING SOON!

[Skaterscafe.com]

Installed and tested, did a 10 min ban and it worked. I tried to run the import and got this:

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

Also have nothing in postbit, great hack!

[afterfl0w]

This is being updated, new version should be out within the next hour!

[afterfl0w]

New version released! Check first post for new additions and updated zip download!

[EasyTarget]

nice hack.

[JWalker05]

Ive been waiting for something like this. Awesome mod. *Installed and voted*

[Firestar.chkn]

Hi, is there any way to allow another usergroup besides Admin to see the banlist page?

I created a Core Admin Group on my forums, and they cannot see the page.

Regards
Firestar

[Firestar.chkn]

No matter, I found the way to do it. For those of you who wants to do the same, open the admincp/admin_banlist.php and find the following line of code on line 101:

if(!is_member_of($vbulletin->userinfo, 6)){

Replace this with:

if(!is_member_of($vbulletin->userinfo, 6) and !is_member_of($vbulletin->userinfo, 29)){

And just change the 26 into the usergroup that you want to give permission to. Obviously, you can add as many groups as possible, by just adding the code into that line, as I've done above.

[cavyspirit]

Any chance this could be made to work on other restricted user group statuses?

Now that we have the infraction system, I REALLY need a way to see my other restricted user groups as well.

[afterfl0w]

What do you mean?

[cavyspirit]

For example, we have two user groups that place posts on moderation. One allows for PMs, the other doesn't. We need to keep track of those just as much or more so than banned members.

It would be very, very nice if this reporting tied in with the new infraction system. Currently, nothing reports or lists infracted members and their user group status.

We're still forced to keep track manually in our mod forum of a summary of who is in the different groups.

[redlabour]

Excuse me - but what does this Hack do ? I think it is absolutely useless with the new Warning System in 3.6. There is allready a Timebased Banmodus at the Warning Features.

[MThornback]

Did the import bans script get pulled out of the zip? Cause its not in mine :(

[b6gm6n]

Hi dudes... looks and works well... but i wondered... i don't like seeing [ Ban User ] next to mods or admins names...is there a way i can disable that for certain user groups?...please advise, cheers

-b6

[afterfl0w]

Excuse me - but what does this Hack do ? I think it is absolutely useless with the new Warning System in 3.6. There is allready a Timebased Banmodus at the Warning Features.

This is a permanent list of all banned users. No idea what you're comparing it to.

Did the import bans script get pulled out of the zip? Cause its not in mine

It is now in the admin_banlist.php file. Upload it and surf to it and click on Import Bans :)

[SportsZone]

I have banned 2 members after in stalling the hack and they don't show in the banlist
http://www.sportszonefanatics.com/showbans.php

edit: I figured it out.

Is there any chance this hack could be coded so the last banned member shows up on the forum home page, please?

Also, when you edit the postbit template for the ban link, is it possible to somehow have the ban link appear in the profile drop downlink.

Great hack :)

[b6gm6n]

I like this mod... but i believe showing a [ ban user ] link for everyone shouldnt be the case... i think a drop down from a users profile upon clicking thier username would be much better and would tidy the postbits up a bit

-b6

[EasyTarget]

great mod/idea. I added it to the dropdown by editting the postbit and postbit legacy templates after the <if condition="$post['userid'] AND $show['member']">
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
</if> I added: <!-- afterflows banlist -->
<if condition="$bbusergroup[usergroupid]==6 OR can_moderate($forum[forumid], '', $bbuserinfo[userid])">
<if condition="$post[usergroupid]!=8">

<tr><td class="vbmenu_option"><a href="javascript:void(0);" onClick="window.open('modcp/banning.php?do=banuser&userid=$post[userid]&bannedpost=showthread.php?p=$post[postid]&postid=$post[postid]','ban','width=500,height=375,scrollbars=yes')">Ban User</a></td></tr>

</if>
<if condition="$post[usergroupid]==8">

<tr><td class="vbmenu_option"><a href="javascript:void(0);" onClick="window.open('modcp/banning.php?do=liftban&userid=$post[userid]','liftban','width=500,height=375,scrollbars=yes')">Unban User</a></td></tr>

</if>
</if>
<!-- /end afterflows banlist -->I'm guessing usergroup id 20 is a custom banned usergroup for afterflow?

I love how you can select which bans to have shown on the page but this bug occurred for me:
I was trying to remove a ban from the ban list in the admincp. I ticked the box for the most recent ban and then clicked delete bans. It then removed the oldest ban instead of the ban I was trying to remove.. each time I repeated it would do the same thing.

also, possible bug, but maybe its supposed to behave like this. I banned a user to test the banlist, it showed up find and the post was edited fine, however when I unbanned the user by clicking unban then the user still showed up on the banlist and the bantime was empty, just had ().

Suggestion:
make it so you can administer the bans from the showbans.php itself if you're in the appropriate usergroups.
make the admin pages match the admincp style.
add a section where you can edit the bans reason + link.
I like how you let us decide whether to edit the post or not, maybe as well you can let us choose the text/format which is added to the post.

[SportsZone]

EasyTarget: Awesome stuff! Thanks :)

Is there any chance this hack could be coded so the last banned member shows up on the forum home page, please?

[b6gm6n]

Nice one ET!

-b6

[EasyTarget]

I found there were a few bugs in that code still and I think this will fix it[html]
<!-- afterflows banlist -->
<if condition="$bbusergroup[usergroupid]==6 OR can_moderate($forum[forumid], '', $bbuserinfo[userid])">
<if condition="$post[usergroupid]!=8">

<tr><td class="vbmenu_option"><a href="javascript:void(0);" onClick="window.open('modcp/banning.php?do=banuser&userid=$post[userid]&bannedpost=showthread.php?p=$post[postid]&postid=$post[postid]','ban','width=500,height=375,scrollbars=yes')">Ban User</a></td></tr>

</if>
<if condition="$post[usergroupid]==8">

<tr><td class="vbmenu_option"><a href="javascript:void(0);" onClick="window.open('modcp/banning.php?do=liftban&userid=$post[userid]','liftban','width=500,height=375,scrollbars=yes')">Unban User</a></td></tr>

</if>
</if>
<!-- /end afterflows banlist -->Now when you ban a user and you click on their name in the postbit you'll see the unban option but not the ban one anymore.

[SportsZone]

So I am presuming we just remove the previous code you wrote and add this new code instead?

[EasyTarget]

yeah, I edited my previous post as well.

[SportsZone]

Awesome, thanks :)

[EasyTarget]

haha sorry guys, that code I posted still let everyone see the ban user option (of course they couldn't really ban a user, but they could still see the option). Got some help and this is verified to work.

This is the new code.. you only see ban/unban if you're an admin and you only see ban when a user isn't banned yet and only unban if they're already banned.


<!-- afterflows banlist -->
<if condition="$bbusergroup[usergroupid]==6 OR can_moderate($forum[forumid], '', $bbuserinfo[userid])">

<if condition="$post[usergroupid]!=8">

<tr><td class="vbmenu_option"><a href="javascript:void(0);" onClick="window.open('modcp/banning.php?do=banuser&userid=$post[userid]&bannedpost=showthread.php?p=$post[postid]&postid=$post[postid]','ban','width=500,height=375,scrollbars=yes')">Ban User</a></td></tr>

</if>

<if condition="$post[usergroupid]==8">

<tr><td class="vbmenu_option"><a href="javascript:void(0);" onClick="window.open('modcp/banning.php?do=liftban&userid=$post[userid]','liftban','width=500,height=375,scrollbars=yes')">Unban User</a></td></tr>

</if>

</if>
<!-- /end afterflows banlist -->

[SportsZone]

Haha thanks! :)

[tekstylez]

It doesnt seem anything is working for me. I used the updated, conditioned postbit entry, but no ban panel opens up when clicking [ban user]

Also, it doesnt seem the ban cp is working properly, I dont see anything different from the default one. I did all the file edits.

[SportsZone]

Another bug, when I cliked on Ban User in the postbit dropdown link, the user didn't go into the banlist. I had to import it manually, but the above seems to be working for me...

[tekstylez]

cant get this to work, and it doesnt seem any support is provided

UNINSTALLED

[WreckRman2]

two thumbs down from me to... install is full of problems.

[Snake]

Thanks. I'll check this out soon!

[Origen]

Sorry. I'm a bit of a newb at vBulletin. Where's the postbit? I can't find it.

[EasyTarget]

hmm this seems to have stopped working for me in 3.6.1

[jian]

Hm it seems the ban list doesn't take off the expired bans.

[M_Portiss]

AWESOME HACK!! Thanks!

[oldfan]

/me clicks install

How do you remove the user from the banlist once the bnan has been removed?

[jian]

The ban list seemed to have broke on the 3.6.2 update.

[cyvok]

Just installed it, love it already!

Thank you
-CYVOK-

[cyvok]

Just installed it, love it already!

Thank you
-CYVOK-

Having the same issue as others, cannot remove members from the list?

-CYVOK-

[Robbed]

How are you guys removing the bans? Automatic or changing the usergroup?

[cOuNtErFiET]

i had to clear out the table then reimport

on to my issue, i have 2 users that are not in my banned list showing up in this list how do i fix this? are they banned in my SQL if so how can i remove them if you have time to tell me ty

[john1744]

The extra bit about allowing a link to ban someone in the postbit isn't really working for me. It shows 2 white areas above the drop down and a ban user link that has to be highlighted to be seen.

[farooqaaa]

Good MOD.

But its showing the [BAN USER] button for everyone :(. it show the BAN USER button even for ADMINS :(

[Terminatoronly]

lol u r a lucky ban user :P nice mod ;)

[Papajohn56]

Good MOD.

But its showing the [BAN USER] button for everyone :(. it show the BAN USER button even for ADMINS :(

Could it be editable by usergroup?

[Alfa1]

With this hack you can show for which post a member was banned, but what about members which where banned for PM's?

[Mr. Christopher]

Does anybody know why the space between the parenthesis is blank?

http://users.marshall.edu/~haynes21/bantest.gif

Your guess would be as good as mine so I'll take any advice I can get. :)

[StrifeX]

Apparently doesn't work past 3.6.0 at all.

How does an update sound?

[Xeder]

Thanks but is there a way to add a user IP column please?

[Extirpate]

needs update for 3.6.x

[ZomgStuff]

It was working up until the 3.6.8 pl 1 patch.

[SuperTaz]

Will this mod work with version 3.6.8?

[ZomgStuff]

Will this mod work with version 3.6.8?

It did for me up until the first level patch. I'll try to figure out why it's not working.

[afterfl0w]

Sorry, this won't be updated, nor supported anymore. I'll be releasing a newer version of the hack shortly for you soon.

[Saviour]

Sorry, this won't be updated, nor supported anymore. I'll be releasing a newer version of the hack shortly for you soon.

Then you might want to change the Mod Settings for this mod to note the above...

Otherwise, you're still going to have people installing this mod and looking for answers.

[zippokid]

Is there a timeframe available? Are you planning a rewrite or just an update for the new code?

*waits in anticipation*

[Mrdby]

?????

[Blind Guardian]

Then you might want to change the Mod Settings for this mod to note the above...

Otherwise, you're still going to have people installing this mod and looking for answers.

Bingo, I was just about to field a problem I was having and now upon hitting page 5 this damn thing isn't supported anymore. :mad:

In case anyone else can help, upon trying to import my old bans, it doesn't correctly import the usergroup or userid. Rather it sets the userid to 32767 for every user and I'm unsure what the usergroup it's pulling is, I just know it's not one of my banned groups.

EDIT: Actually, it's putting the userid as 32767 on newly banned users too.

EDIT2: Yeah, uninstalling this until there's news of a new supported release.

[DarthCoder]

ooh nice mod

[meissenation]

I've tried removing people from the banlist and it says removed but it doesn't actually do it. I had to go into phpmyadmin to remove them.

[Hasann]

Heyy People If yOu want I can write a better meet our banlist :D modification from scratch I am crazy ;)

[Alfa1]

That would be welcome, but please be so kind to fix the security token error in your Invitation System first.

[DPtheGod]

We have been looking for something like this for our forum -- so thank you very much for this hack! I will download and install it tonight when I get home. :)