[TAC] Stop Country Spam

[TAC] Stop Country Spam [Paid] 3.1.5

No permission to buy ($19.00)
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
 
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.
e3IJcHg.jpg


Also, I do have the JSON setup.
rxAAYoh.png


India is selected

qu4JGHT.png



Am I doing something wrong? Thanks for your help.
 
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)
 
@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 :)
 
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:
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.
 
(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:

5407f3
 
Top Bottom