vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Anti-Spam Options - [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam (https://vborg.vbsupport.ru/showthread.php?t=248042)

Alibass 09-29-2012 05:49 PM

Quote:

Originally Posted by BGN64 (Post 2368711)
Is there any way to report a spammer to StopForumSpam if they never post? Just recently spammers have been registering by the dozens (per day) but they don't post. They were after the blog feature but I have the blog spam under control, I just want to report them.

Thanks.

It's not a good idea to report someone as a spammer unless they have actually spammed your site. This can cause problems for other users who may share that IP from registering at other sites.

Derek765 10-04-2012 09:19 AM

Database error in vBulletin 4.2.0:
I uploaded all files to their right directorys then went to Import product-glowhostspamomatic.xml and got this following error.

Anyone know what this means?

Code:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `MY DATABASE NAME_glowhostspamomatic_log`(
                                                                `date` DATETIME NOT NULL,
                                                                `ip` VARCHAR(15) NOT NULL,
                                                                `email` VARCHAR(255) NOT NULL,
                                                                `username` VARCHAR(255) NOT NULL,
                                                                `message` VARCHAR(255) NOT NULL,
                                                                `is_blocked` TINYINT NOT NULL DEFAULT "0",
                                                                `user_hash` VARCHAR(50) NOT NULL,
                                                                `user_id` INT NOT NULL
                                                        ) TYPE=MyISAM;;

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 'TYPE=MyISAM' at line 10
Error Number  : 1064


TheSupportForum 10-04-2012 11:01 AM

Quote:

Originally Posted by Derek765 (Post 2370684)
Database error in vBulletin 4.2.0:
I uploaded all files to their right directorys then went to Import product-glowhostspamomatic.xml and got this following error.

Anyone know what this means?

Code:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `MY DATABASE NAME_glowhostspamomatic_log`(
                                    `date` DATETIME NOT NULL,
                                    `ip` VARCHAR(15) NOT NULL,
                                    `email` VARCHAR(255) NOT NULL,
                                    `username` VARCHAR(255) NOT NULL,
                                    `message` VARCHAR(255) NOT NULL,
                                    `is_blocked` TINYINT NOT NULL DEFAULT "0",
                                    `user_hash` VARCHAR(50) NOT NULL,
                                    `user_id` INT NOT NULL
                                ) TYPE=MyISAM;;

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 'TYPE=MyISAM' at line 10
Error Number  : 1064


change all instances of

Code:

) TYPE=MyISAM;;
to

Code:

) ENGINE=MyISAM; ');
in product-glowhostspamomatic.xml

Derek765 10-04-2012 12:55 PM

1 Attachment(s)
Alright got it installed fine and setup but now its not displaying any information in the block, a image is provided below.

Any idea?

https://vborg.vbsupport.ru/attachmen...1&d=1349358896

TheSupportForum 10-04-2012 01:02 PM

Quote:

Originally Posted by Derek765 (Post 2370717)
Alright got it installed fine and setup but now its not displaying any information in the block, a image is provided below.

Any idea?

https://vborg.vbsupport.ru/attachmen...1&d=1349358896

This means no spammers have tried to register yet

Derek765 10-04-2012 01:14 PM

Oh alright, didn't know if it would still show information with 0 spammers and ect or not.

Harpo 10-04-2012 01:31 PM

Very happy with this. saved me a lot of work.

Thanks!

joeychgo 10-04-2012 01:48 PM

Quote:

Originally Posted by oddmud (Post 2368285)
I see request after request after request of a whitelist option. Any news on that front? No one has a solution. I have to stop using the plugin (even though it's AWESOME) because I'm getting far to many normal people that can't register due to being listed as spammers, and they aren't.

Yes, it would be very nice if this could work. ESPECIALLY if there was a way to whitelist for a period of time only. (ie 7 days)

Quote:

Originally Posted by BGN64 (Post 2368711)
Is there any way to report a spammer to StopForumSpam if they never post? Just recently spammers have been registering by the dozens (per day) but they don't post. They were after the blog feature but I have the blog spam under control, I just want to report them.

Thanks.

I catch spammers who register alot - before they post. They arent listed in the database. Its cumbersome to go to stopforumspam and add the entry as wel as manually deleting the user. It would be great if this could be a one click deal like on posts.

Also, it would be nice if we could block by country. I have no use of China members for example - and would just like to block them outright.

TheSupportForum 10-04-2012 02:07 PM

Quote:

Originally Posted by joeychgo (Post 2370727)
Yes, it would be very nice if this could work. ESPECIALLY if there was a way to whitelist for a period of time only. (ie 7 days)



I catch spammers who register alot - before they post. They arent listed in the database. Its cumbersome to go to stopforumspam and add the entry as wel as manually deleting the user. It would be great if this could be a one click deal like on posts.

Also, it would be nice if we could block by country. I have no use of China members for example - and would just like to block them outright.

add this if you haven't already
add this plugin

Product: vBulletin
Hook Location: useradmin_edit_column1
Title: Submit to StopForumSpam.com
Execution Order: 5
Plugin PHP Code:

Code:


if (!is_member_of($user['usergroupid'], 6)) // we dont want to ban our admin account now do we
        {
            print_table_break('', $INNERTABLEWIDTH);
            print_table_header("Submit to StopForumSpam");
            if ($vbulletin->options['glowhostspamomatic_apikey'])
                print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username"  size="30" value="'.
$user['username'] . '"></td></tr><tr><td>Email:</td><td><input type="text" name="email"  size="30" value="' . $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td><td><input type="text" name="ip_addr"  value="' .$user['ipaddress'] . '"></td></tr></table><input name="api_key" type="hidden" value="' . $vbulletin->options['glowhostspamomatic_apikey'] .    '"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()"  type="button" class="button" value="' . $vbphrase['submit'] . '"/>');

            else
                print_label_row('You need an API key from www.stopforumspam.com before you can submit to the database' ,'');   
        }

http://img441.imageshack.us/img441/1...6289223c1e.png



this will allow you to submit them from admincp when viewing users details in admincp

Syxguns 10-05-2012 07:07 AM

Quote:

Originally Posted by joeychgo (Post 2370727)
it would be nice if we could block by country. I have no use of China members for example - and would just like to block them outright.

Here is a good website to use. Add the rules to your .htaccess file to block from countries you do not want on your site.

Of course another way to do this is within vB. Settings > Options > User Banning Options
You have the option to use "*" as a wildcard so it will take a little time to do, which is why using the .htaccess is better.

http://www.ip2location.com/blockvisitorsbycountry.aspx


All times are GMT. The time now is 04:05 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04306 seconds
  • Memory Usage 1,766KB
  • 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
  • (5)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)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