Thread: [ANY] VPN Block
View Single Post
djded
Member
Join Date: Jul 2019
Location: Czech Republic
Old 11-10-2019 , 02:52   Re: [ANY] VPN Block
Reply With Quote #49

Quote:
Originally Posted by Bara View Post
I would add a cache function for IPs (recheck cached ip after a week), more efficient for communities with large player base. Why? Be checking every IP on every join, you'll reach your limit pretty fast.

proxycheck hasn't this function, because as example the Wordpress Plugin "Proxy & VPN Blocker" has a builtin function: "Includes caching to save you queries and make repeat checks instant".

If you (or anyone else) want that function, let me know I'll add it.
Quote:
Originally Posted by LionKing View Post
I am unable to get this to work.

I have tried using djed's solution, but this still had no effect.
The only error it throws me are error logs from SQL connections.
Code:
L 11/02/2019 - 00:27:32: [SM] Exception reported: Invalid database Handle 0 (error: 4)
L 11/02/2019 - 00:27:32: [SM] Blaming: VPNBlock.smx
L 11/02/2019 - 00:27:32: [SM] Call stack trace:
L 11/02/2019 - 00:27:32: [SM]   [0] SQL_Query
L 11/02/2019 - 00:27:32: [SM]   [1] Line 72, VPNBlock.sp::OnClientAuthorized
L 11/02/2019 - 00:27:32: [SM] Exception reported: Databases don't work
L 11/02/2019 - 00:27:32: [SM] Blaming: VPNBlock.smx
L 11/02/2019 - 00:27:32: [SM] Call stack trace:
L 11/02/2019 - 00:27:32: [SM]   [0] SetFailState
L 11/02/2019 - 00:27:32: [SM]   [1] Line 44, VPNBlock.sp::OnSqlConnect
But OP said it is optional to connect to a database.
Hello. Change your reply about my solution. After I'm help you to setup a config file, it's working for you. It will help to another users.
djded is offline