Raised This Month: $32 Target: $400
 8% 

[ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc


Post New Thread Reply   
 
Thread Tools Display Modes
Wolfseye
Senior Member
Join Date: Apr 2014
Location: Germany
Old 01-03-2018 , 11:44   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #21

Do I need to add both, the Datacenter SQL and the country SQL ?
Wolfseye is offline
Send a message via Skype™ to Wolfseye
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: Fish Tank
Old 01-03-2018 , 22:20   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #22

Quote:
Originally Posted by Wolfseye View Post
Do I need to add both, the Datacenter SQL and the country SQL ?
That's entirely up to you how you are going to filter players; I merely provided the Datacenters.sql and the ability to generate country.sql from a list to help people get started.
__________________
RumbleFrog is offline
Wolfseye
Senior Member
Join Date: Apr 2014
Location: Germany
Old 01-04-2018 , 07:48   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #23

UPDATE:

Seems to work. But it sometimes takes a while before it does. Not everyone is blocked from the start, sometimes it takes minutes before those are kicked.

Last edited by Wolfseye; 01-04-2018 at 10:20.
Wolfseye is offline
Send a message via Skype™ to Wolfseye
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: Fish Tank
Old 01-04-2018 , 10:55   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #24

Quote:
Originally Posted by Wolfseye View Post
UPDATE:

Seems to work. But it sometimes takes a while before it does. Not everyone is blocked from the start, sometimes it takes minutes before those are kicked.
The performance is reliant on your MySQL server. If indexed correctly, it should be mere instant depending on the latency.
__________________
RumbleFrog is offline
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: Fish Tank
Old 01-04-2018 , 11:05   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #25

v1.1.4
  • Column `cidr` is now indexed by default to speed up query #6
__________________

Last edited by RumbleFrog; 01-17-2018 at 18:38.
RumbleFrog is offline
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: Fish Tank
Old 01-17-2018 , 18:38   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #26

January 2018 CIDR List Update
  • Hosting Telesystems is now added
  • Kievhosting is now added
  • Removed some old invalid CIDR entries
__________________
RumbleFrog is offline
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: Fish Tank
Old 01-26-2018 , 07:55   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #27

If you wish to get the latest datacenter import without relying on me to update it, feel free to use the parser tool which pulls and parse and the latest data from the source: https://github.com/CIDR-Blocker/CIDR.../master/parser
__________________
RumbleFrog is offline
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: Fish Tank
Old 07-24-2018 , 02:26   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #28


Datacenters July Update
  • Added "A Small Orange"
  • Added Servage
  • Added "Reg.ru"
  • Added Selectel
  • Updated Velia
  • Added "Genesys Informatica"
  • Added Zomro
  • Added Natro
  • Added "Yourserver"
  • Added "Tencent Cloud"
  • Added Locaweb
  • Added "The Durance International Group Inc"
  • Added Avguro
__________________
RumbleFrog is offline
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: Fish Tank
Old 08-24-2018 , 00:38   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #29


Datacenters August Update
  • Added more "DigitalOcean" ranges
  • Added more "OVH" ranges
  • Added more "Tencent Cloud" ranges
  • Added "AltusHost"
  • Added "H88"
  • Updated "Loopia"
  • Added "Netcup"
  • Added "ColoCrossing"
  • Added "net4"
  • Added "Contabo GmbH"
  • Added "ActiveCloud"
  • Added "Realcomm"
  • Added "NETIO"
  • Added "Offshore Servers"
  • Added "Hostinger"
__________________
RumbleFrog is offline
island55
Senior Member
Join Date: Aug 2010
Location: charleston
Old 09-01-2018 , 23:52   Re: [ANY] CIDR Blocker MySQL - Block VPNs, Countries and etc
Reply With Quote #30

looking to get a little assistance with this however your discord link is invalid

edit: the discord link in the op is the one that works however the one here https://forums.alliedmods.net/showpo...4&postcount=15 and https://cidr-blocker.github.io/#/Doc...roubleshooting are not valid

Last edited by island55; 09-01-2018 at 23:55.
island55 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:11.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode