Is there a simple way to add multiple proxies to be banned?

[Revontuli]

Hi, we have an abusive troll at our forum that keeps using multiple proxies to attempt and disrupt things.

We inquired for a solution on the private inquiries end as to not bring this problem out in public. We got zero responses which tells me there is no solution.

At any rate, we are aware this has been brought up before and no solutions have been presented except use your .htaccess file.

That's simply not doable.

Our .htaccess file is so big it will not function and returns a 403 error. We're talking 100,000 proxies here. Do we really have to enter them one by one on the mybb admin banned ip section?

If someone here has a workaround, ie entering the IP's directly into the database please let us know step by step how to do it.

Mybb is a good strong piece of software, we love everything about it except for this one glaring weakness. If your forum gets to big, and you have a computer savvy troll, this becomes the elephant in the living room; and quite frankly, we can't ignore it.

This is one of the most frustrating things we've ever dealt with, and so far there are no answers.

There is a plugin called no proxies please, that does not work as it bans everyone from the forum, so that is not an option either.

Thanks in advance.

[JayRodney]

*crickets*
Sorry, unless someone more knowledgeable than myself comes along you're stuck entering one by one. You are correct, this IS the elephant in the living room.
Not addressing an issue does not make it go away. Yeah, use your .htaccess with100,000 proxies. Good luck. small file there eh?

[godgifted]

Well if you want to ban any range of proxy addresses you can do that from your ACP -> Banning
But if you want your forum to be spam free I will suggest you to read the following post and install the security plugins in your forum. Within it you will get a fantastic plugin which will check the user ip with stopforumspam ip database so that no one can spam again. Also it has many more fantastic plugins.

http://community.mybb.com/thread-110224.html

Read This !!!

[Revontuli]

Hey godgifted, thanks for replying. We have a bunch of those plugins and bots/spam is not an issue at our forum. We have a real live troll person who has made it his mission in life to "take us down" and scours the internet for working proxies. We need to be able to keep a massive list of banned proxies that can be updated regularly, the question is how and where? We desperately need a database head to chime in and guide us here.

[godgifted]

See the attachment. I hope this will help you to stop those ip addresses manually. You can give the ip addresss range like 192.168.1.1 or say 192.168.*.* or say 192.*.*.* like this. Hope this will help you.

[pavemen]

why not just create a .sql or .csv file of the required contents and import that into your database?

[crazy4cs]

This user has been denied support.

There is a plugin by Yaldaram, No Proxy Please or something along that name. Try it.

[Revontuli]

See the attachment. I hope this will help you to stop those ip addresses manually. You can give the ip addresss range like 192.168.1.1 or say 192.168.*.* or say 192.*.*.* like this. Hope this will help you.

Thanks, we have banned loads of ranges. Problem is that when you ban enough ranges we end up banning a lot of members as well and that's not very cool.

There is a plugin by Yaldaram, No Proxy Please or something along that name. Try it.

Thanks! We tried that one. Banned everyone including ourselves!

why not just create a .sql or .csv file of the required contents and import that into your database?

Thanks, this is something we need to try. But how exactly do you go about such a task? Could you elaborate or point us in the right direction please? We're going to need some instructions to hook this all together.

[pavemen]

Thanks, this is something we need to try. But how exactly do you go about such a task? Could you elaborate or point us in the right direction please? We're going to need some instructions to hook this all together.

create a text file named banimport.sql and fill it with:

INSERT INTO `forum_banfilters` (`filter`, `type`, `lastuse`, `dateline`) VALUES
('xxx.xxx.xxx.xxx', 1, 0, unix_timestamp(now())),
('xxx.xxx.xxx.xxx', 1, 0, unix_timestamp(now())),
('xxx.xxx.xxx.xxx', 1, 0, unix_timestamp(now())),
('xxx.xxx.xxx.xxx', 1, 0, unix_timestamp(now())),
('xxx.xxx.xxx.xxx', 1, 0, unix_timestamp(now()));

just replace xxx.xxx.xxx.xxx as needed. take care to notice the commas at the end of every row except the last, which is a semi-colon.

[Revontuli]

Awesome!!! That's what we've been looking for! Excellent!

Thanks a million!