That line casts to an unsigned int should raise the max allowed value to 2147483647*2

Try replacing instances of
with
but you will need to change the database coloum type from unsigned to signed.

Makes the $ip a string with a max value of 2147483647*2. Then when PHP needs to do arithmetic on the string it implicitly casts it to a float if it is larger then 2147483647 (for 32-bit systems) otherwise an int. On 64-bit systems PHP expands integers to 2^64.

Right, I had already figured out the problem. I removed the sprintf and allowed the AND to be done with the integers then printed it as an unsigned int in the query.

Your solution works perfectly.

I didn't realize that php would automatically convert back till I consulted the documentation following your issue the fix for 32 bit systems will be in the next release.

When i try to import md5_sums_ipbans.xml I get the following error

XML Error: Invalid document end at Line 16

using vb 4.0.3 Patch Level 1

Thats in the uploads folder for a reason :P upload it don't import it, it stops vbulletin from seeing the mods files as being 'not a part of vbulletin' in the diagnostic tools, it also makes sure that the files that come with this mod have not become currupt.

Tanks got the right file now :) Good mod :up:

Would it be too much to ask for specific instructions for setting permissions to make this feature available for a user account, or for the administrators group?

In order to make this avaliable for a user, they must be an administrator. Then you need to edit their admin permissions and give them the can admin ipbans permission.

I can't fix the problem manually. so waiting for next release.

Does this work for vb 3.8.5?
Does this modification allow us to prevent blocking collective proxy IPs like AOL has? (blocking one AOL IP will block a mass of different AOL IPs)