vb.org Archive
Page 53 of 88 « First 3435152 53 545563 Last »
Show 40 post(s) from this thread on one page

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

Chadi 10-06-2012 01:33 PM
It would be awesome to have a convenient way to submit spam info directly from the vb admin panel to stopforumspam.com

djbaxter 10-06-2012 05:07 PM
Quote:
Originally Posted by Chadi (Post 2371186)
It would be awesome to have a convenient way to submit spam info directly from the vb admin panel to stopforumspam.com
There already is. I've posted this before:

1. You'll need the SFS API key. Replace "1234567890abcd" in last line below with valid API.

2., AdminCP >> Plugins and Products >> Add New Plugin

3. Details for plugin

Product: vBulletin

Hook Location: useradmin_edit_column1 (or useradmin_edit_column2 if you prefer)

Title: Submit to StopForumSpam.com

Execution Order: 5

Plugin PHP Code:

Code:
if (!is_member_of($user['usergroupid'], 6)) // dont ban admin account
        {
            print_table_break('', $INNERTABLEWIDTH);
            print_table_header("Submit to StopForumSpam");
           
                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="1234567890abcd"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()"  type="button" class="button" value="' . $vbphrase['submit'] . '"/>'); 
        }

Robbed 10-08-2012 06:19 PM
Any way to view stats without showing on forum home? besides log files

bzcomputers 10-08-2012 10:40 PM
Quote:
Originally Posted by Robbed (Post 2371606)
Any way to view stats without showing on forum home? besides log files
You can always add this line at the top of plugin "GlowHost - Spam-O-Matic - Stats render":

Code:
if ($vbulletin->userinfo['usergroupid'] == 6)
That will make it only visible to Admins.

postcd 10-09-2012 02:01 PM
Hi, i got error when im adding this Mod to my vbulletin. I select the xml file and click import, it shows:

Code:
Database error in vBulletin 4.1.10:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `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

ForceHSS 10-09-2012 02:23 PM
Quote:
Originally Posted by postcd (Post 2371784)
Hi, i got error when im adding this Mod to my vbulletin. I select the xml file and click import, it shows:

Code:
Database error in vBulletin 4.1.10:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `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
Code:
) TYPE=MyISAM;;
to

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

TheSupportForum 10-09-2012 02:38 PM
for those who are getting any database error just open
product-glowhostspamomatic.xml

and replace all instances of

Code:
) TYPE=MyISAM; ');
with

Code:
) ENGINE=MyISAM; ');
this has been mentioned and ask alot of this thread please ensure you all read it

Robbed 10-10-2012 04:24 PM
I'm using duplicate up report by bop5 ip and threads created with this mod are moderated. The userid and usergroup are on the whitelist.

The logs show

2012-10-10 04:13:41 Unregistered Post put under moderation based on Auto-Moderation URL count

TheSupportForum 10-10-2012 04:28 PM
Quote:
Originally Posted by Robbed (Post 2372080)
I'm using duplicate up report by bop5 ip and threads created with this mod are moderated. The userid and usergroup are on the whitelist.

The logs show

2012-10-10 04:13:41 Unregistered Post put under moderation based on Auto-Moderation URL count
that has nothing to do with this mod, please post support in BOP5 thread
https://vborg.vbsupport.ru/showthread.php?t=282525

Corrine. 10-10-2012 04:54 PM
First, thank you for this add-on. In the 7 months since it was added, Glow-Host Spam-o-Matic has blocked ~1,000 spammers.

What concerns me is that for the past several days, spammers with very high reports at StopForumSpam are being passed to registration -- not all but 50+ have been passed through just the past three days. It isn't an issue with StopForumSpam being unavailable, as each as the indication, "Passed StopForumSpam checks. Sent to vBulletin Registration System."

Two examples from today:
None of them are over the 90-day setting, which we use as recommended. We also use the recommended 30 minute setting for "StopForumSpam: Data Fetching - Cache".

Any suggestions? (Site: Sysnative.com)

TheSupportForum 10-10-2012 05:23 PM
Quote:
Originally Posted by Corrine. (Post 2372091)
First, thank you for this add-on. In the 7 months since it was added, Glow-Host Spam-o-Matic has blocked ~1,000 spammers.

What concerns me is that for the past several days, spammers with very high reports at StopForumSpam are being passed to registration -- not all but 50+ have been passed through just the past three days. It isn't an issue with StopForumSpam being unavailable, as each as the indication, "Passed StopForumSpam checks. Sent to vBulletin Registration System."

Two examples from today:None of them are over the 90-day setting, which we use as recommended. We also use the recommended 30 minute setting for "StopForumSpam: Data Fetching - Cache".

Any suggestions? (Site: Sysnative.com)
ouch, well it seems china it hitting alot of vbulletin forums over the last week
i added an antispam register to my forum found here
https://vborg.vbsupport.ru/showthread.php?t=288742
if you follow it step by step, it stops the registration from spammers, harvesters etc
its somthing i added the other day to the mods

Corrine. 10-10-2012 09:16 PM
Thank you, simonhind. Believe me, China is hitting other forum software just as hard.

Since I posted earlier today, we decided to supplement with NoSpam! Image Enhancement (New version of No Spam! for Custom Image Verification) and will see how that goes.

In the meantime, I'll share information about AbyssGuard with the rest of the Admin Team to consider.

Alibass 10-10-2012 10:01 PM
Quote:
Originally Posted by Corrine. (Post 2372146)
Thank you, simonhind. Believe me, China is hitting other forum software just as hard.

Since I posted earlier today, we decided to supplement with NoSpam! Image Enhancement (New version of No Spam! for Custom Image Verification) and will see how that goes.

In the meantime, I'll share information about AbyssGuard with the rest of the Admin Team to consider.
I have been using this one and it really works well.

https://vborg.vbsupport.ru/showthread.php?t=282704

Bluefin221 10-10-2012 11:03 PM
I installed this three weeks ago after one day coming on and having over 100 pending accounts most of which were spam, in those three weeks it has stopped 6987 Spammers which is an insane number, still though 20/30 are getting through per day but as I have members on approval then we catch them away.

onestorydown 10-11-2012 11:05 PM
Running VB 4.2.0 - and am getting this error message when trying to upload the product-glowhostspamomatic.xml file:

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `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
Request Date : Thursday, October 11th 2012 @ 07:54:55 PM
Error Date : Thursday, October 11th 2012 @ 07:54:56 PM
Script : http://yyyyyyyyyyyyyyy.com/forum/adm...=productimport
Referrer : http://yyyyyyyyyyyyyy.com/forum/admi...?do=productadd
IP Address : 70.139.218.237
Username : HIIIIIIIII
Classname : vB_Database
MySQL Version : 5.5.20-log

Any thoughts or tips, tricks on how to get this fixed?
Thanks!!!!!!!!

bzcomputers 10-11-2012 11:16 PM
Quote:
Originally Posted by onestorydown (Post 2372404)
Any thoughts or tips, tricks on how to get this fixed?
Thanks!!!!!!!!
Just needed to read a few posts back...

You can find the answer to this in posts: 2047, 2049, 2083, 2096, 2097.

onestorydown 10-11-2012 11:44 PM
Quote:
Originally Posted by bzcomputers (Post 2372405)
Just needed to read a few posts back...

You can find the answer to this in posts: 2047, 2049, 2083, 2096, 2097.
Ughhh, I can't believe I missed those. THANK YOU for helping out a fellow Texan. :) I'm multi tasked too thin since I missed all of these...

Works now!:D

jskoh 10-12-2012 09:29 AM
im getting a database error upon importing the product. what is wrong?

Uberguilds 10-13-2012 01:15 AM
Quote:
Originally Posted by ccampo (Post 2160034)
Excellent MOD, I was using the previous version but after installing 2.0 I was getting MySQL errors while trying to add a new usergroup

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'

To fix this I had to remove an old file called :
?/forum/includes/xml/bitfield_glowhostspamomatic.xml
So make sure you remove this file if you are upgrading, this file is not included in the new 2.0 version.
Thanks for this, helped me out huge

killerford 10-13-2012 11:02 AM
I've just read this in the read me file

'' ==
* Please note, for this plugin to work, cURL must be installed on the server
or allow_url_fopen enable in PHP settings '' What does this mean?

Bluefin221 10-13-2012 12:14 PM
Quote:
Originally Posted by killerford (Post 2372695)
I've just read this in the read me file

'' ==
* Please note, for this plugin to work, cURL must be installed on the server
or allow_url_fopen enable in PHP settings '' What does this mean?
Its a server setting, you would need to speak with your hosts or if you run your own server you would need to make sure these settings are available.

killerford 10-13-2012 09:31 PM
Quote:
Originally Posted by Bluefin221 (Post 2372702)
Its a server setting, you would need to speak with your hosts or if you run your own server you would need to make sure these settings are available.
Thanks for the help bluefin.

Cybex 10-14-2012 11:08 AM
First of all I would like to say that this is a fantastic piece of software, thank you very much for sharing this with everybody. I installed it 1 day ago and when I tested it some more I will definitely donate to the author, much deserved!

Question: Is it possible to check the current user database to see if users match the stopforumspam database? I have a forum with over 500,000 users and I'd like to check if there are spammers amongst them.

TheSupportForum 10-14-2012 11:17 AM
Quote:
Originally Posted by Cybex (Post 2372864)
First of all I would like to say that this is a fantastic piece of software, thank you very much for sharing this with everybody. I installed it 1 day ago and when I tested it some more I will definitely donate to the author, much deserved!

Question: Is it possible to check the current user database to see if users match the stopforumspam database? I have a forum with over 500,000 users and I'd like to check if there are spammers amongst them.
this is designed for new user registrations

Cybex 10-14-2012 01:39 PM
Perhaps it would be possible to add the feature I described?

Harpo 10-14-2012 06:39 PM
Its breaks my footer. I'm using pureVBs Gametime theme.

TheSupportForum 10-14-2012 06:44 PM
Quote:
Originally Posted by Harpo (Post 2372992)
Its breaks my footer. I'm using pureVBs Gametime theme.
disable sponsors

Vick98 10-15-2012 08:06 AM
For some reason the spam statistics are not shown at the bottom of the forum. Any suggestions?

TheSupportForum 10-15-2012 08:16 AM
Quote:
Originally Posted by Vick98 (Post 2373107)
For some reason the spam statistics are not shown at the bottom of the forum. Any suggestions?
its not supposed to unless you have spammers try to register

example
http://img210.imageshack.us/img210/6...70b86e05e8.png

JakeSully 10-15-2012 12:12 PM
Hi everyone idk if anyone have already found a fix for this error about TYPE=MyISAM; '); line if not to fix it just open .xml file with notepad++ and remove all the TYPE=MyISAM; '); lines you can find it should look like this

Code:
) TYPE=MyISAM; ');
remove only TYPE=MyISAM; '); leave the ) where it is then save and re-import the .xml and you will see that import will be a success :) just did that on my forum and import went through fine :P

P.S new problem doing that will not get tables created for some strange reason :/


All times are GMT. The time now is 08:48 PM.
Page 53 of 88 « First 3435152 53 545563 Last »
Show 40 post(s) from this thread on one page

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.04199 seconds
  • Memory Usage 1,889KB
  • 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
  • (14)bbcode_code_printable
  • (21)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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