We Need Some php + SQL Code Written

[Opus]

Nah, not too late at all. Just shutdown/remove the shit you don't need and find a cheap box to dedicate for admin tasks..

You're doing fine buddy.

[Chip (OP)]

i'm too worried about removing stuff and i don't have access to another virtual server unless i pay.

thanks for the encouragement.

i'll leave it be for now but thanks for the solid advice.

[somnambule]

I'm late to this thread, and maybe you have it sorted already, but....  You looking for PHP/MySQL help particularly for blocking ip ranges, right?  Cuz'. if you have root access (and aren't on a cheap virtual host or something), why not do thissimply through IP tables. 

Something like this to block a whole subnet:

Code: [Select]

iptables -A INPUT -s 192.168.100.0/24 -j DROP
I just stumbled onto this site which creates country specific IP ranges for blocking.  It seems really spot on, even generates P tables rules.

If you can't use iptables, you can always do something similar using .htaccess.  This way you don't need to add much of anything to the box.

[Chip (OP)]

we have our own server.

your suggestion is valid but the SMF software also supports ranges too.

I'm going to sit on this one and cross that bridge when I come to it.

my current problem is that I have made so many mods to the software that removing them is now near impossible unless I rebuild it.

so I have opted for a freeze on mods as they are also starting to conflict.

I was aiming for as close as possible functionality with Opiophile so users could move between the two systems with relative ease.

[_Enduser]

I'm late to this thread, and maybe you have it sorted already, but....  You looking for PHP/MySQL help particularly for blocking ip ranges, right?

Uh oh, what did I do wrong?

 

[Chip (OP)]

Nothing at all, silly.

I wanted to weed out any non-administrative duplicate members in the future and perhaps restrict any banned members from sneaking back in.

just for the future ... everybody is cool so far.

[newphone]

I'm not volunteering to do anything, but you should really use some sort of configuration management tools like puppet or chef to configure the server. That way you can tear it down and rebuild easily. I am a software developer, a systems developer with a background in web development too, but I do enough of that stuff at my day job.

[Chip (OP)]

if I had to rebuild it then putting on the near 100 mods. is the main issue - i run a mirror of the forum at home and update it frequently plus I have copies of all the settings of CentOS /etc libs etc.

Right now, we image the server weekly and at worst it can be simply restored from it. A rebuild is something that will have to be done when the disk space fills up.