That was because I loaded ip-addresses with userid=-1.
And in admin panel I can see only addresses loaded by myself.
So it's OK now.

ipbans made by a userid not found in the user table will not be shown, this was by design.

I have found a nicer fix for the -ve values returned by long2ip; it will be appended to the first post shortly

just updated but still having the same issue. when i add an ip to ban it gets written to the DB but does not dispaly when I click "list IP bans"

What userid is listed alongside the ban?

I have installed this plugin on a vbulletin 3.8.3 forum, but I'm having a bit of trouble. The install went fine, and I can add new IPs to the ban list, but I cannot list current bans.

Whenever I click on "List IP Bans", I am met with an empty table and this error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/admincp/ipbans.php on line 36

Any ideas?

That suggests a mysql error in the preceeding query.

What version of mysql are you using?

5.0.51a

For those who cannot see added bans, check if mysqli is running.
I was playing around with it a few days ago and left it enabled, yesterday
i saw that all saved ipbans were gone (not showing in list).

it took me quiet some time to find out that

config.php
caused it..

.. and everything is fine

that fixed the vanishing IPs and the "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/diaf/ipbans.php on line 36" error.

Its a pity because mysqli is the preferred and more efficient way to call in php 5x

For those running mySQLi - here's the fix

in ipbans.php

find
replace
.. thanks for the pointer, gmerin

I should probably change that to use $db->fetch_array() will fix in the next version. (probably the vb4 compatible version)

My board has a very long list of banned ip's and we are interested in banning ranges of ip's.

I don't understand how CIDR improves upon just using the * wild card in a banned ip. e.g. 221.222.* or 221.222.0.0/16 look the same to me. Am I missing something?

We would like to be able to ban something like 221.222.131-255.* or even 221.222.131-155.*. I don't see any notation that supports this.

Currently I keep the bans in a spreadsheet so I can sort and annotate them. I then just copy the ip column into the ban list in AdminCp.

Maybe if I get used to the notation, I can figure out how to take out a large range and add back in the pieces that are OK to get to the examples above.

I wonder if there is a calculator somewhere that converts the kind of range I listed above to a set of CIDR's.

I will def install if you can add an option to ban from within posts and profiles. Cause searching for a user and then finding their IP is a pain in the butt.

When looking at your home page... replace index.php with online.php and you can see the ip addresses quite quick that way.

My request is this...if possible.

I have some super mods that I would like to give the ability to. I want to avoid making them admins but ip banning is a feature they need. Is there someway to allow this?

I have tried to give them minimal admin permissions as a secondary group and turned on Can Administer Ipbans to yes but still nothing on their admin cp

Feature Requests:
Allow banned IPs to see how long they are banned for.
Add an option to ban from within posts and profiles. Cause searching for a user and then finding their IP is a pain in the butt.

yes. You don't have to use just /16 /24 /8 and /32 you could for example use /28 which would ban a range of 16 ips
CIDRs aren't perfect, but the following ban 221.222.131.0/19 hits 221.222.128.0 - 221.222.159.255 You could leave it at that or add an exempt for 221.222.128.0/23 and 221.222.130.0/24 to protect the lower end and an exempt for 221.222.156.0/22 to protect the upper end.

The latest (vb 4 version) of this mod includes a calculator that goes from CIDR notation to range notation; in theory, if you upload the contents of the uploads folder to your 3.8 install, it should provide the extra features. (Don't import the vb4 product thou, as the mod will cease to work) I'll see how hard it would be to write a calculator to go the other way.

This might be possible by just editing the phrase... I'll look into it.

Its already on the planned feature list to allow banning from the delete as spam page; I see no reason not to include this; however the ip's will probably not be very efficiently banned. (eg it'll have to add a /32 ban for each and every ip the user uses. Trying to automatically work out a range would be VERY error prone.)

Sorry if I'm dense, but can this mod simply ban the IP address by clicking the IP address icon in the user postbit and making a selection from their? Seems like low-hanging fruit to add this feature from the beginning.

Thanks!

i'm afraid that isn't possible, but you are right, it is a fairly low hanging fruit. It'll probably be added along with the other front end integrations that i've got planned; however development time is currently going into the vb4 version of this mod; so I don't know how long it'll be until the new features i've added to that get into this version.

I've added several IPs but just noticed that in the IP ban manager page the list of IPs is all 0s

Is there a fix for this?
If you could email an answer as I'll find it hard to keep an eye on this; hallamwarriors(at)gmail.com
thanks

i have banned someone`s ip but i didnt ban him on the forum so he ca still come and post

what settings did you use for the ban?

this mod dosn't ban user accounts associated with a ban; only blocks that ip from accessing the site. If its the only ip the user uses, then they won't be able to post, if they have several ips then yes, they will still be able to post.

A handy little mod, had to tweak ipbans.php for mySWLi but besides that a pretty smooth install.

One issue I am having though is enabling the registration option doesn't work, the registration field in the IP ban list stays at "No" and still functions as a blanket ban for anyone in the specified IP range.

I can manually issue a SQL query to set the "registration" value to 1 which causes the Reg ban to function and sets "No" to "Yes" in the ipban list although I'd prefer avoiding that extra step every time I ban a range of spambots.

(vBulletin 3.8.4 Patch Level 2)

I really need this mod but for some reason it doesn't work for me or maybe it does but I don't understand it.

If I add the IP address:184.11.244.2

It bans the IP address: 126.255.255.255

Why is that?

(I altered those IP addresses just a little)

Thanks for this wonderful add-on.

A quickquestion if I may - what does a person from a blocked IP see? do they just get a "cannot display this page" type error or do they actually see the "Reason" if one is entered in admincp ?

Also, one suggestion for future versions - a feature enabling banning of a whole country using a two letter code (e.g PK)

I use a firewall (CSF) on our cpanel server which includes this feature, although it applies to all sites across the server which often isn't desireable.

Last but not least, I find this site really useful for finding CIDR ranges - http://software77.net/geo-ip/ (I am not associated with the site in any way, I just use it).

Same problem here. Can you tell me the sql query you use to change it?

never mind i figured it out
update ipban set registration = 1