• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
[TAC] Stop Country Spam

[TAC] Stop Country Spam [Paid] 3.0.7

No permission to buy ($16.00)

tenants

Well-known member
Sorry, haven't been available for a while (unavoidable)

I've just built a new version of this for the latest xenforo, but I want to update the entire TAC plugins and make sure they all work hand in hand
I'll be uploading the latest version of this within the next couple of weeks
 
I just tried to install this plugin and got the following error... any tips on what I'm doing wrong?

Server Error
Mysqli statement execute error : Table 'server_table.sf_stopbotters' doesn't exist

  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Tac/StopCountrySpam/Install.php at line 61
  4. Tac_StopCountrySpam_Install::installCode()
  5. call_user_func() in XenForo/Model/AddOn.php at line 215
  6. XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
  7. XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 188
  8. XenForo_ControllerAdmin_AddOn->actionInstall() in XenForo/FrontController.php at line 351
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  10. XenForo_FrontController->run() in /home/ranger/public_html/admin.php at line 13
 

tenants

Well-known member
It looks like an install error, a missing table, try uninstalling and re-installing again... I'll have a look when I get back
 
I need some help.
Every night I get 10 - 15 sign ups from India that are spammers. I keep trying to stop them but they always seem to get through. I installed this plugin yesterday and checked the "India" box but last night I got 11 sign ups just like usual. I also have the TAC StopHumanSpam installed as well.

Here's an example of one of the sign ups.


Also, I do have the JSON setup.


India is selected




Am I doing something wrong? Thanks for your help.
 

tenants

Well-known member
what does it say in the stop country spam logs, check here:

/admin.php?stopcountryspam/logs

When I checked this url
http://ip2country.sourceforge.net/ip2c.php?format=JSON&ip=182.64.159.93

The response I got was:
This script is being abused and has been disabled. Sorry.

So, I would use a different API
This post mentions a few and how to set them up: https://xenforo.com/community/threads/stopcountryspam-paid.36271/#post-412948
Wipmania is the one I'm using, no issues for years
http://api.wipmania.com/182.64.159.93?k=XXX&t=json

(register free, and they provide you with a key)
 

RDR

Well-known member
@Nathan - had the exact same issue as you for the longest time... no errors logged as well.

Changed the API to the same as suggested by @tenants and haven't had a spammer register since and the addon log is filled with blocked entries :)
 

Rambro

Well-known member
@tenants just got a signup from India, with an Indian IP, despite it being checked in the options. any reason it might have slipped through? nothing in the stopcountryspam log.
 

tenants

Well-known member
make sure your settings are correct, are there any logs at all in he stopcountryspam log, if not this is suggestive that your settings are NOT correct, which api are you using?

see:

This post mentions a few and how to set them up: https://xenforo.com/community/threads/stopcountryspam-paid.36271/#post-412948
Wipmania is the one I'm using, no issues for years
http://api.wipmania.com/182.64.159.93?k=XXX&t=json

(register free, and they provide you with a key)
However, if you are getting logs, the default behaviour if the API is down / has an issue is to not block a user (when using black listing), this is also true if the API is not set up correctly.
You usually don't want to block users just because an API is down, but if you do, then use the white listing options (not advisable)
 
Last edited:

Rambro

Well-known member
make sure your settings are correct, are there any logs at all in he stopcountryspam log, if not this is suggestive that your settings are correct, which api are you using?
no errors logged

spam trigger log produced this after registration
Code:
Action: Rejected - Akismet matched, Spam phrase matched ([url*)
Generated By: Aanchalarora, May 12, 2017, Content: user_signature (823)
Request State
array(4) {
  ["url"] => string(49) "http://www.dressedwell.net/account/signature-save"
  ["referrer"] => string(44) "http://www.dressedwell.net/account/signature"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(7) {
    ["signature_html"] => string(247) "<p>Buy or renew <a href="https://www.bajajallianz.com/Corp/motor-insurance/car-insurance.jsp">Motor insurance</a> policy with Bajaj Allianz. Cashless Claims at over 4000 preferred garages, 24x7 road-side assistance, zero dep cover and more<br></p>"
    ["_xfRelativeResolver"] => string(44) "http://www.dressedwell.net/account/signature"
    ["_xfToken"] => string(8) "********"
    ["save"] => string(12) "Save Changes"
    ["_xfRequestUri"] => string(18) "/account/signature"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
api's all allowed him in:

  1. Stop Forum Spam Allowed User
    Today at 5:48 AM : 116.74.20.56 Aanchalarora zoyakhan10004@gmail.com
  2. Delete...
    FSpamlist Allowed User
    Today at 5:48 AM : 116.74.20.56 Aanchalarora zoyakhan10004@gmail.com
  3. Delete...
    Bot Scout Allowed User
    Today at 5:48 AM : 116.74.20.56 Aanchalarora zoyakhan10004@gmail.com
  4. Delete...
    Spam Busted Allowed User
    Today at 5:48 AM : 116.74.20.56 Aanchalarora zoyakhan10004@gmail.com
  5. Delete...
    Project Honey Pot Http:BL Allowed User
    Today at 5:48 AM : 116.74.20.56 Aanchalarora zoyakhan10004@gmail.com
  6. Delete...
    Block Disposable Email Allowed User
    Today at 5:48 AM : 116.74.20.56 Aanchalarora zoyakhan10004@gmail.com
  7. Delete...
    Tor Setgetgo Allowed User
    Today at 5:48 AM : 116.74.20.56 Aanchalarora zoyakhan10004@gmail.com
I followed the linked post of yours to set these up.
 

tenants

Well-known member
(the above are anyAPI logs and have nothing to so with stop country spam)

If you have no logs here
/admin.php?stopcountryspam/logs

it is suggestive that stopcountryspam has not yet been set up (these are not just errors logs, but logs of activity)
What StopCountrySpam API are you using, and what was the ip and what is the Index Name you have set?

An example of the logs on one of my sites: