vb.org Archive - Administrative and Maintenance Tools

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Administrative and Maintenance Tools - vbStopForumSpam (https://vborg.vbsupport.ru/showthread.php?t=222536)

Just an update. Since installing Ive only had a few spammers. This really cut out most of the junk... Thanks again...

Quote:

Originally Posted by cnredd (Post 2156466)

Been 5 days...tryin' again...

Make sure you uploaded all files. Also check your permissions. Ill bet its one of those. Im using it without any problems.

Just yesterday I realized my database error email was set incorrectly in my config.php so as any good admin would do I fixed it right away. Now I'm kind of wishing I hadn't.

Im getting database error about every 5 minutes or so since then. All the errors are about the same as to whats wrong but the user id and ip are all different. I figured it was the limit at SFS of 1000 calls a day but SFS is not listing these IP's or user ID's as spam so now it looks like a hack.

Heres an example of the latest.

HTML Code:

Database error in vBulletin 3.8.4:



Invalid SQL:

SELECT DATEDIFF(NOW(), '2011-02-08 07:20:59') AS DAYS;;



MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(NOW(), '2011-02-08 07:20:59') AS DAYS' at line 1

Error Number : 1064

Request Date : Tuesday, February 8th 2011 @ 12:34:55 PM

Error Date : Tuesday, February 8th 2011 @ 12:34:58 PM

Script : http://www.scalemotorcars.com/forum/register.php?do=addmember

Referrer : http://www.scalemotorcars.com/forum/register.php

IP Address : 84.108.193.156

Username : QopCorinas

Classname : vB_Database

MySQL Version :

Anyone have an ideal how to fix it or how to suppress the error if it is just a timeout?

Thanks....

I may have found the solution myself. I hope its just my antiquated mySQL 4.0. messing it up. https://vborg.vbsupport.ru/showpost....&postcount=353

So whats it cost to have a site moved to another (newer) server anyway? ;)

Every VB board needs this hack. Nominated for MOTH.

Thanks again!!!!

I installed this mod on my vB and I can say this...

Spam registration has gone down to 0.

This is the most useful thing EVER created for vBulletin. Mod of the Year! This should be default in vBulletin. This is the endgame scenario for spammers!

Here is my update on this product. I've had it installed for roughly 3 months, and it has now filtered out 16,538 entrees, however my registration numbers are much lower, and I'm receiving many, many emails that legit people are being blocked. I'm not really sure what to do. Even if 10% of the filtered accounts were real, I think I am ahead by being over cautious, as opposed to letting the spam in. Currently looking for a new way to up the accuracy of removing spam bots.

Quote:

Originally Posted by clarkstoncracke (Post 2175774)

I have received emails like that too. I let someone through and the first thing that user did was post spam.

Some spam accounts are made by real people who are paid to manually make accounts to beat bot protection.

Do not be fooled.

Spammers are getting past this for the last week. Not all but enough to be a pain in the butt. Is there a problem with the api?

^ Yes, the site's been down for a while now.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_html_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01142 seconds Memory Usage 1,742KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_html_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: