PDA

View Full Version : Anti-Spam Options - [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam


Pages : 1 2 3 4 5 6 [7] 8 9 10 11 12 13 14

HappyFeet
01-03-2012, 01:04 AM
Found it... to turn link off in WGO box.


135428

To remove it completely turn off all Statistics: settings

exportforce
01-04-2012, 10:26 AM
Database error in vBulletin 4.1.7:

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 : Wednesday, January 4th 2012 @ 12:23:51 PM
Error Date : Wednesday, January 4th 2012 @ 12:23:51 PM
Script : http://***/admincp/plugin.php?do=productimport
Referrer : http://***/admincp/plugin.php?do=productadd
IP Address : ***
Username : ***
Classname : vB_Database
MySQL Version : 5.5.17

Thats what we get at our board on installation.
On my private board it works like a charm, so I have no idea what the problem could be.

ForceHSS
01-04-2012, 07:59 PM
try to manually add the table

djjeffa
01-05-2012, 12:37 AM
I have the same problem
im runnin3.84 and using IE Browser
I get this error when I try to delete a post as spam and ban the bot:


Fatal error: Using $this when not in object context in /home/website/public_html/includes/functions_vbghsfs.php on line 459

Even after I disabled and then uninstalled the plugin this error still exists.

ForceHSS
01-05-2012, 12:45 AM
functions_vbghsfs.php is not part of this hack

djjeffa
01-05-2012, 01:05 AM
functions_vbghsfs.php is not part of this hack

but it didnt start till I installed this hack and when I googled the error it came to this thread where another user who installed this hack got the same error.

ForceHSS
01-05-2012, 06:02 AM
you need to look at your other plugins you have removed in the passed to see what one uses that php file as it is not from the plugin

Hostboard
01-05-2012, 02:29 PM
functions_vbghsfs.php is not part of this hack

It was at one point.
https://vborg.vbsupport.ru/showpost.php?p=2094984&postcount=185

I would suggest re-downloading the latest version and re-installing.

eitai2001
01-05-2012, 04:15 PM
Hi There.

Awesome mod, thanks.
Just a small issue ... when I click the link in statistics: http://www.XXXXXX.com/forum/admin/glowhostspamomatic.php ... it just says page not found. How can I fix this?

Also, where do I go to see spam registrations logged?

Thanks

Regards

Itai

Hostboard
01-05-2012, 05:28 PM
Hi There.

Awesome mod, thanks.
Just a small issue ... when I click the link in statistics: http://www.XXXXXX.com/forum/admin/glowhostspamomatic.php ... it just says page not found. How can I fix this?

Also, where do I go to see spam registrations logged?

Thanks

Regards

Itai

Make sure the file exists in your admin folder then make sure you have the URL correct.

dog-tag
01-05-2012, 07:27 PM
Just did this on the newest version of vb 4.1.9

It works wonders and I clicked installed :)

Fantastic work Sir! It's guys like you who make running forums possible.

djjeffa
01-06-2012, 12:08 AM
functions_vbghsfs.php is not part of this hack
im not saying it was but im not the first to have this problem after installing the hack

you need to look at your other plugins you have removed in the passed to see what one uses that php file as it is not from the plugin
it has somthing to do with this one becaues when i disable this hack i dont have this problem

It was at one point.
https://vborg.vbsupport.ru/showpost.php?p=2094984&postcount=185

I would suggest re-downloading the latest version and re-installing.
thank you , i did but it still dose it unless i disable the hack also i am running 3.8 ans i used the newest version for 3.8 but i posted here because this was the post that showed that error

spencerp
01-06-2012, 10:13 AM
Getting...

Fatal error: Cannot redeclare clean_options_list() (previously declared in /home/feetfoto/public_html/misc.php(89) : eval()'d code:59) in /home/public_html/includes/functions_ghsom.php on line 354

when trying to use the One Touch Ban/ Delete plugin.. Disabling this for now until there's a fix.. I'm currently using the latest plugin version of this..

TheSupportForum
01-06-2012, 11:47 AM
Developer : PLEASE READ

please be aware that the
Optional Affiliate System

is not optional and got annoyed when installing it after to see that
the affiliate link is shown in the footer on first install, i'd suggest you update this mod
so that all affiliate programs are disabled

+ why does this MOD has an affialiate program option its not even related to the MOD in anyway other than to make yourself money which is wrong

this is not allowed in mods
i completly removed the affiliate plugin

ForceHSS
01-06-2012, 03:52 PM
The coder will never answer he never logins in any more

djjeffa
01-06-2012, 04:59 PM
The coder will never answer he never logins in any more
Thats a shame i hate to remove this hack but its not worth keeping if i cant use it properly. Anybody have any ideal on why im having the problem?

ForceHSS
01-06-2012, 05:01 PM
if you need help I could have a look for you pm me if you do

djjeffa
01-07-2012, 01:00 PM
are there any other good supported spam hacks? this one seems to be cutting down on bots registering but the ones that get through are posting links and stuff and i have it set to stop them end i cant delet posta as spam and ban user because of the error so i have to do them seperate so its not submitting the bots. mind you im running 3.8

ForceHSS
01-07-2012, 01:47 PM
are you using the 3.8 version are you sure you have all the settings right if they are right no spammers should get through

djjeffa
01-08-2012, 01:27 PM
well i was getting about 8 bots a day joining with it on now its off and i have 36 already and we are only 9 hrs into the day. but when i had it on it was letting them put links into there sigs even tho I had it set not to let them.

ForceHSS
01-08-2012, 04:16 PM
as i said above if settings are not set up right then bots will register

wayne.richards@
01-08-2012, 11:06 PM
Since I installed this i get in "Who's Online"....

Guest - yogurt.glowhost.com viewing Admin Control Panel

ForceHSS
01-08-2012, 11:56 PM
Since I installed this i get in "Who's Online"....

Guest - yogurt.glowhost.com viewing Admin Control Panel

add that bot in your robots.txt if you want to not allow it to that location

Alfa1
01-09-2012, 03:49 PM
Does it follow robots.txt ?

I have added "glowhost" to Bad behavior blacklist, so its really blocked from accessing my site. What on earth is this bot for?

ForceHSS
01-09-2012, 04:16 PM
never had the bot before so not sure

Addlonfire
01-10-2012, 08:10 AM
This addon is awesome. Solved all my spam account problems. Thank you!

(over 1500 Spam cases blocked - 0 new spam accounts)

Webbstre
01-13-2012, 11:40 PM
I've had a problem where one user, who has way more than the required amount to be exempt from registration, and is in two usergroups that are exempt, STILL keeps ending up in the moderation queue when he posts. I came here to report it or get some help, but the first comments on this page disappoint me as it sounds like the author isn't here anymore. In the two months that I've had this installed, it's stopped all my spam problems though. Kinda mixed feelings on this one.

TheSupportForum
01-14-2012, 12:18 AM
I've had a problem where one user, who has way more than the required amount to be exempt from registration, and is in two usergroups that are exempt, STILL keeps ending up in the moderation queue when he posts. I came here to report it or get some help, but the first comments on this page disappoint me as it sounds like the author isn't here anymore. In the two months that I've had this installed, it's stopped all my spam problems though. Kinda mixed feelings on this one.

the easy way around this is to create a new usergroup and set all to no
i have trapped many who attempted to bypass it and can't coz their not put into default group and placed into a custom usergroup with no permissions

also ensure you have put your API keys in and review the logs dailt to submit their details to stopforumspam

Webbstre
01-14-2012, 12:23 AM
I think maybe I made my post confusingly... one of my users is being moderated when he shouldn't be, and it's really annoying to have to keep approving his posts when looking at my settings he should be exempt 3 ways already.

tony
01-14-2012, 01:35 AM
Does this take care of spam already posted? Or only as it comes in? And the same question for banning spammers.

Thanks

ElfenLied1337
01-14-2012, 02:22 AM
Anyone else getting a huge influx of bots, even with this enabled?

They mostly just fill out their profiles with advertisement links, never actually post, so we can't report them to the database.

MikeTrin
01-14-2012, 03:04 AM
Anyone else getting a huge influx of bots, even with this enabled?

They mostly just fill out their profiles with advertisement links, never actually post, so we can't report them to the database.

India mainly, one after another. If that country didn't have so many IP ranges I'd ban the whole place. The mod Stop the Registration Bots works better than glowhost spam-o-matic for these guys.

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

Be sure to hide the member list from non registered users and disable the homepage field.

TheSupportForum
01-14-2012, 07:38 AM
I think maybe I made my post confusingly... one of my users is being moderated when he shouldn't be, and it's really annoying to have to keep approving his posts when looking at my settings he should be exempt 3 ways already.

you can put an ignore on the user, just place the userid of the person you want it to ignore

lloyd_mcse
01-16-2012, 09:49 PM
Hi guys,
I just installed vb 4.1.10, and was editing the video attachment settings, hit save and got this error...

Database error in vBulletin 4.1.10:

Invalid SQL:
UPDATE vb3usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12317183',
`genericpermissions` = '1579685575',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`signaturepermissions` = '498943',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '500000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`sigmaxvideos` = '1',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '247671',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`akvbghsfs_akismet_permissions` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number : 1054
Request Date : Monday, January 16th 2012 @ 10:28:16 PM
Error Date : Monday, January 16th 2012 @ 10:28:16 PM
Script : http://www.my-domain.com/forum/admincp/usergroup.php?do=update
Referrer : http://www.my-domain.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : *.*.*.*
Username : me
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.8

does anyone know what this is about?
TIA

Bluemax712
01-16-2012, 10:09 PM
Anyone else getting a huge influx of bots, even with this enabled?

They mostly just fill out their profiles with advertisement links, never actually post, so we can't report them to the database.

I've been using Glowhost combined with this mod which works well to
prevent new users (bots or real ones) from creating links in their profiles or anywhere

(Extra Spam Protection) Prevent Posting Of Links On User Group Per User Group Basis
https://vborg.vbsupport.ru/showthread.php?t=243925

RavenSteve
01-17-2012, 01:51 AM
For those of you who can't pull up their logs, I had renamed my admincp folder. Make sure the file glowhostspamomatic.php goes in that folder.

jdeveaux
01-17-2012, 03:08 PM
Looks Great thus far. One change I made was in the Give thanks. The default text of "Web Hosting" is a bit generic. Now reads "Spam-O-Matic provided by GlowHost.com" on our site.

Any plans for a paid version? Sorry I have not read through the hundreds of posts :-)

Dialsoft
01-17-2012, 09:28 PM
we installed this mod on our forum which is 4.1.10 suite when I activate it locks all users from posting including me. is there something I am not setting correctly?

ForceHSS
01-17-2012, 10:29 PM
show screenshot of settings

Dialsoft
01-18-2012, 01:22 AM
image0 (http://http://www.t4cbible.com/infoimages/vbghost.png)
image1 (http://http://www.t4cbible.com/infoimages/vbghost1.png)
image2 (http://http://www.t4cbible.com/infoimages/vbghost2.png)
image3 (http://http://www.t4cbible.com/infoimages/vbghost3.png)

ForceHSS
01-18-2012, 08:25 AM
Spam-O-Matic: Protect Users = use ids not names
Akismet: Enable = yes
Akismet: Post Count = 0
Akismet: API Key = get key from http://akismet.com
Akismet: Auto-submit from Easy Cleanup = yes
StopForumSpam = Username Check: Disable
StopForumSpam = API Key get key from http://www.stopforumspam.com
StopForumSpam: Auto-submit from Easy Cleanup = yes
Newbies Manager: Newbies Group ID = 4 this is normally 4 you have it at 17 do check that
Newbies Manager: Auto-promote Users From Newbies To Trusted/Registered Users? = no
Auto-Moderation: Minimum Post Count = 1
Easy Cleanup: Enable = Enabled
Affiliate System: Enable = Disable turn this off as you dont have a Affiliate ID
Affiliate System: Link text = leave blank
Credits: Give Thanks = no

TheSupportForum
01-18-2012, 08:37 AM
image0 (http://http://www.t4cbible.com/infoimages/vbghost.png)
image1 (http://http://www.t4cbible.com/infoimages/vbghost1.png)
image2 (http://http://www.t4cbible.com/infoimages/vbghost2.png)
image3 (http://http://www.t4cbible.com/infoimages/vbghost3.png)

screenshot 1 is wrong put iserid's not usernames

ForceHSS
01-18-2012, 10:06 AM
screenshot 1 is wrong put iserid's not usernames

if you check my above post you will see I already said that

Dialsoft
01-18-2012, 05:19 PM
i made all changes that you recommended when you try to post it still does not function.

ForceHSS
01-18-2012, 06:32 PM
have you checked user group permissions

Dialsoft
01-19-2012, 01:59 AM
permissions are all checked on admin group and we still cannot post

ForceHSS
01-19-2012, 10:48 AM
pm me with the site url and a admin login will have a look for you also make me a normal test account as well

BUDIMAN
01-23-2012, 02:33 AM
can you show me the best setting on this plugin ??

cruspeed
01-23-2012, 03:52 AM
I am getting the "spam-o-matic" showing up in the what's going on box, but there are no stats showing.

All the Statistics: in the admin cp are set to "yes"

cruspeed
01-23-2012, 03:54 AM
Nevermind, no one has been blocked yet......

Ski4People
01-27-2012, 01:49 PM
Great mod, but...
I activated just the stopforumspam to prevent spammers registration, ip check , email check and username check all enabled and spam-o-matic blocked some regular registration because a user set the username, for example, "John" and it is included into the stopforumspam database, but not the chosen email or ip, so why isn't there a combined check (ip AND email AND username = SPAMMER)?
Now I have just to disable ip check and username check and keep just the email check.

ForceHSS
01-27-2012, 01:53 PM
turn off the username part of it only I find it does block normal user as well

djbaxter
01-27-2012, 02:03 PM
Great mod, but...
I activated just the stopforumspam to prevent spammers registration, ip check , email check and username check all enabled and spam-o-matic blocked some regular registration because a user set the username, for example, "John" and it is included into the stopforumspam database, but not the chosen email or ip, so why isn't there a combined check (ip AND email AND username = SPAMMER)?
Now I have just to disable ip check and username check and keep just the email check.

turn off the username part of it only I find it does block normal user as well

I agree. Leave the email and IP checks enabled.

Ski4People
01-27-2012, 02:04 PM
turn off the username part of it only I find it does block normal user as well

As i wrote above, now I keep just the email check, 'cause also regular IP are banned...

Alfa1
01-27-2012, 05:30 PM
As i wrote above, now I keep just the email check, 'cause also regular IP are banned...
IPs have to be used by spammers to get into the SFS database. If a user gets a spammer IP address from their provider, they should contact their provider to get a new IP address.

Ski4People
01-27-2012, 06:11 PM
Here in Italy (and I guess for other countries) most of internet connection get a dynamic ip address, so it could be easy to get a banned IP, but IMHO this mod could be improved by a multi check IP/email/username, I also own a phpBB forum and use this little mod (http://support.prophpbb.com/topic2572.html) to prevent spammers, and it perform this multi check that works very well.

Alfa1
01-28-2012, 12:16 PM
Yes, thats a good point. I think its also important to take into the equation how many times an IP address has been used by spammers.

cbiweb
01-31-2012, 11:48 PM
I installed this and tested it by registering with a fastmail.fm email address, and was blocked as a spammer. But of course I am not spammer, but it seems this mod thinks fastmail addresses are automatically spam? There may be many legitimate people with a fastmail address, who won't be able to register at my site because of this mod. How do I work around this?

edit: Okay, maybe it wasn't the email address. I tried it with a different one and still couldn't register. It seems my username was blocked??? It was a common first name: Warren. And yet I could not register with it. That doesn't seem workable.

Ski4People
02-01-2012, 03:41 AM
I installed this and tested it by registering with a fastmail.fm email address, and was blocked as a spammer. But of course I am not spammer, but it seems this mod thinks fastmail addresses are automatically spam? There may be many legitimate people with a fastmail address, who won't be able to register at my site because of this mod. How do I work around this?

edit: Okay, maybe it wasn't the email address. I tried it with a different one and still couldn't register. It seems my username was blocked??? It was a common first name: Warren. And yet I could not register with it. That doesn't seem workable.
It works well if you use just the email check

jkcerda
02-01-2012, 05:21 AM
is there a way to make it work with the blogs? I dont see an option to kill the spammers that are blogging.

Syxguns
02-01-2012, 08:19 AM
is there a way to make it work with the blogs? I dont see an option to kill the spammers that are blogging.

That permissions can be set within vB. using permissions. You can set Unregistered users to not be able to leave a post, but they can still view the blog.

jkcerda
02-01-2012, 03:45 PM
That permissions can be set within vB. using permissions. You can set Unregistered users to not be able to leave a post, but they can still view the blog.

let me rephrase, I have spammers STILL joining & blogging instead of posting, ALL spammers seem to go to the blog section, there have been no spam post, just spam blogs.
I see no way to turn in the spam bloggers

ForceHSS
02-01-2012, 05:01 PM
then set it so members cant post to the blog and make a new group that can

gezuvor
02-01-2012, 06:06 PM
LOVE THIS MOD!!! HAS SAVED MY FORUM!!

But, I have a problem. I read through a ton of these pages and don't seem to see a clear response. All of my new registrants are put into a "newbie" usergroup and get moved to the Registered usergroup once they hit a certain post count.

The problem is that all of the newbie posts are going into the moderation queue, which is a giant pain in the backend for myself and the moderators. I have restricted this group to disable URLs, signatures, etc. but they are not restricted from posting topics or replies.

Help!

ForceHSS
02-01-2012, 06:41 PM
LOVE THIS MOD!!! HAS SAVED MY FORUM!!

But, I have a problem. I read through a ton of these pages and don't seem to see a clear response. All of my new registrants are put into a "newbie" usergroup and get moved to the Registered usergroup once they hit a certain post count.

The problem is that all of the newbie posts are going into the moderation queue, which is a giant pain in the backend for myself and the moderators. I have restricted this group to disable URLs, signatures, etc. but they are not restricted from posting topics or replies.

Help!
if you check the settings of this program you will see where to turn that off

gezuvor
02-01-2012, 07:41 PM
I have it disabled already. I just enabled it and will disable it again in a bit to see if that corrects the issue. Tempted to uninstall and reinstall...

Alfa1
02-02-2012, 04:48 AM
Check the settings, to turn the moderation for the newbie group off.

gezuvor
02-02-2012, 05:59 PM
In the GlowHost settings or Usergroup settings? It is off on the GlowHost page.

ForceHSS
02-02-2012, 06:51 PM
glowhost settings

gezuvor
02-02-2012, 09:00 PM
I am pretty sure I have it disabled in the GlowHost settings. Here is a screen capture showing that entire page...

https://vborg.vbsupport.ru/external/2012/02/50.jpg

Would love to get this thing working...

Alfa1
02-02-2012, 09:53 PM
Set this to NO
http://s3.amazonaws.com/awesome_screenshot/1375181?AWSAccessKeyId=0R7FMW7AXRVCYMAPTPR2&Expires=1328223440&Signature=CwVwfwKI27erxjCz1p%2BpWPA0xNE%3Dhttp://awesomescreenshot.com/000th3hc0

Do not put new users in the newbies group. Your settings should not cause many posts to be moderated. IF it does send many posts to the moderation queue, then turn this off. You can use vbulletin promotions, to send users to a newbie usergroup. Configure usergroup permissions for newbie usergroup to apply restrictive permissions. Then add another promotion, to promote newbies to another usergroup if they receive more than X reputation points.

gezuvor
02-03-2012, 12:08 AM
I'll try that, thank you Alfa1!

alaska_av8r
02-03-2012, 03:23 AM
I am new to this mod and noticed today that it had placed 4 spammy posts in moderation cue. So I went to the vb ACP moderation panel. I only see one post and it is by a legitimate user with nothing to indicate spam, so I selected validate on the bottom left, then clicked save. The screen well went sort of blank, it did not show anything so I had to click the menu to the left to moderate post again and it was still there. So I did this again. Same result.

The post the user had made was a comment on an article in the CMS, so I finally disabled the mod, found the post in the vbcms comment section of the forum. Then I moderated it there and selected approve posts, still no luck, but then I cleared the CMS cache and had to rebuild the tables to get the post to show.

If I auto-moderate post, what is the proper procedure to approve them and get them to show if this happens again?

thanks

AbvAvg
02-06-2012, 12:08 PM
I tried to import this file in Product Manager and get the message "Invalid File Specified".
It is vB 4.1.10

Am I doing something wrong?

Update: Sorry. Was trying wrong file. My bad.

matt27
02-06-2012, 09:02 PM
A fantastic mod, thanks very much.

cool_recep
02-07-2012, 08:00 PM
Can you add the option to remove visitor messages of the spammer please?

Alibass
02-07-2012, 08:32 PM
Can you add the option to remove visitor messages of the spammer please?
Turn it off in the user group.

RobertoMuggli
02-08-2012, 03:54 PM
Working very well on 4.1.5 PL1, thank you!

squidsk
02-08-2012, 03:54 PM
I'm pretty sure he means that if you ban a user as a spammer you can currently remove posts, and the request is add the ability to remove visitor messages as well. If visitor messages are being added removing social group messages would be nice too.

marianoblesa
02-09-2012, 10:50 PM
Not Work on 4.1.10, please update, help

I.G.O.T.A.
02-10-2012, 12:55 AM
Not working on vB 4.1.10. :(

Papa Bear
02-10-2012, 01:25 AM
yes it does.i run it on 4.1.10 works fine..

I.G.O.T.A.
02-10-2012, 01:44 AM
Strange. I will have to reload it.

I.G.O.T.A.
02-10-2012, 01:53 AM
I took it out and reloaded it. I don't have these setting below a user.

GlowHost - Spam-O-Matic
You can ban or remove the user along with removing all the posts and submitting profile details to StopForumSpam.com:
Ban user
Remove user
Remove All Posts
Submit to StopForumSpam.com

ForceHSS
02-10-2012, 05:20 AM
I took it out and reloaded it. I don't have these setting below a user.


GlowHost - Spam-O-Matic
You can ban or remove the user along with removing all the posts and submitting profile details to StopForumSpam.com:
Ban user
Remove user
Remove All Posts
Submit to StopForumSpam.com

Moderation Tools then you will see Spam O Matic normally last on list

Luffy-9
02-12-2012, 01:07 PM
I've notice that the mod prevent some real user from registration and deal with them as spammers. !!!

Any suggestions I can keep the spammers away but I can't lose users too :S

Ddiablo
02-12-2012, 01:13 PM
work fine in my 4.1.10 tanks a lot

http://inforsat.org

ForceHSS
02-12-2012, 01:44 PM
I've notice that the mod prevent some real user from registration and deal with them as spammers. !!!

Any suggestions I can keep the spammers away but I can't lose users too :S

StopForumSpam: Username Check = Disabled

squidsk
02-12-2012, 04:08 PM
On our site we only have email address used for blocking spammers, and its cut down spam tremendously.

cbiweb
02-13-2012, 02:11 PM
Username check is disabled on my forum, but there is a new member whose posts keep getting sent to moderation. He is a lawyer, his registration email address uses the domain of his website, and his posts don't have links in them. Any idea what I need to check to prevent this from happening to him and to other legitimate new members?

ForceHSS
02-14-2012, 08:24 AM
Username check is disabled on my forum, but there is a new member whose posts keep getting sent to moderation. He is a lawyer, his registration email address uses the domain of his website, and his posts don't have links in them. Any idea what I need to check to prevent this from happening to him and to other legitimate new members?

you would need to go into the sql table and remove his info as his ip, name or email has been flagged already

KProjects
02-14-2012, 01:31 PM
This mod mentions "Easy Cleanup" in its settings page - I've had some spammers that i've banned and they're not being sent to the stopforumspam database.. what exactly is 'Easy Cleanup'?

Here's how i'd normally ban someone:
Find their spam post that's in moderation.. select it and 'delete post as spam' in the dropdown.
I'll select 'delete other posts by this person' and 'ban this person' from the next page..

When I check on stopforumspam.com's database, it's showing that I haven't submitted anyone yet. I do have an API key set up w/ them and have it enabled/entered in my glowhost spam settings.

Thanks,
Rob

Alfa1
02-14-2012, 02:32 PM
Username check is disabled on my forum, but there is a new member whose posts keep getting sent to moderation. He is a lawyer, his registration email address uses the domain of his website, and his posts don't have links in them. Any idea what I need to check to prevent this from happening to him and to other legitimate new members?
Check his IP on stopforumspam.com
If the IP was used by spammers, tell him that he should complain to his ISP.

ForceHSS
02-14-2012, 03:34 PM
This mod mentions "Easy Cleanup" in its settings page - I've had some spammers that i've banned and they're not being sent to the stopforumspam database.. what exactly is 'Easy Cleanup'?

Here's how i'd normally ban someone:
Find their spam post that's in moderation.. select it and 'delete post as spam' in the dropdown.
I'll select 'delete other posts by this person' and 'ban this person' from the next page..

When I check on stopforumspam.com's database, it's showing that I haven't submitted anyone yet. I do have an API key set up w/ them and have it enabled/entered in my glowhost spam settings.

Thanks,
Rob
in Moderation Tools pick Spam-O-Matic option you will see this at the bottom of the last post

KProjects
02-14-2012, 03:53 PM
Ugg.. i'm dumb. I've never seen that.. heh. Been using it for probably close to a year :)

Thanks,
Rob

Cloudrunner
02-14-2012, 10:41 PM
I have had to uninstall this particular addon much to my chagrin mainly because while it's running, my users are getting an issue of not being able to post. They are receiving an error of "Your post is too short" when they try to post anything, like their post is being emptied after this mod scans the post.

Anyone have any thoughts on this as I noticed by going through posts that this has happened with a couple of folks and it goes unanswered.

cbiweb
02-14-2012, 10:52 PM
Username check is disabled on my forum, but there is a new member whose posts keep getting sent to moderation. He is a lawyer, his registration email address uses the domain of his website, and his posts don't have links in them. Any idea what I need to check to prevent this from happening to him and to other legitimate new members?

you would need to go into the sql table and remove his info as his ip, name or email has been flagged already
What do you mean by remove his info? Delete him altogether?? I looked at three places in phpMyAdmin (glowhostspamomatic_log, glowhostspamomatic_remotecahe and glowhostspamomatic_stats), and see the info, but what do I delete or edit without nuking his account?

edit: I've discovered this note in the database regarding the member's posts: "Post put under moderation based on Akismet result". So it seems the Akismet feature is causing the problem. How do I resolve that?


Check his IP on stopforumspam.com
If the IP was used by spammers, tell him that he should complain to his ISP.
Good suggestion, thanks, but nothing turned up there.

Alfa1
02-14-2012, 11:24 PM
Then check the log and see why he was rejected.

ForceHSS
02-15-2012, 03:16 AM
What do you mean by remove his info? Delete him altogether?? I looked at three places in phpMyAdmin (glowhostspamomatic_log, glowhostspamomatic_remotecahe and glowhostspamomatic_stats), and see the info, but what do I delete or edit without nuking his account?

edit: I've discovered this note in the database regarding the member's posts: "Post put under moderation based on Akismet result". So it seems the Akismet feature is causing the problem. How do I resolve that?



Good suggestion, thanks, but nothing turned up there.

if he has already registered then this does not apply

marcshaw
02-16-2012, 06:27 PM
hello all, im new to this site and new to VB, i have installed this mod on our forum and so far its fantastic. but i do have a question, we have had spammers banned pretty much as soon as they enter the forum either by the system or other mods. if we have a banned member with no posts, can we "one touch ban" them? it would be really nice (for newbies like me) to have a "ban and clean" button on each members profile page. or have i just missed something?

thanks for reading, and keep up the good work,

Marc

SteveLV702
02-17-2012, 03:15 PM
Unable to install I get this error:

Database error in vBulletin 4.1.10:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `Moviesglowhostspamomatic_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 : Friday, February 17th 2012 @ 10:13:42 AM
Error Date : Friday, February 17th 2012 @ 10:13:42 AM
Script : http://www.themotionpicturereview.com/UnderworldRulez/plugin.php?do=productimport
Referrer : http://www.themotionpicturereview.com/UnderworldRulez/plugin.php?do=productadd
IP Address : ***.***.***.***
Username : *******
Classname : vB_Database
MySQL Version : 5.5.20-55-log

GavoTrav
02-17-2012, 04:42 PM
It might be just me but my MYSQL server goes crazy with it on and it lags

Dwarden
02-17-2012, 09:15 PM
this modification together with BadBehaviour2 module https://vborg.vbsupport.ru/showthread.php?t=261498
turned out as quite effective against spammers

my thanks to author

baronstaniford
02-19-2012, 12:08 PM
My site has been plagued by spammers, with 50+ spam registrations a day. Since installing this mod we've been spam free. So far it's caught every one of them without stopping genuine members from registering.

48030-JayEss
02-19-2012, 08:49 PM
I've been using this mod on my forum for about a month now. So far 5 out of 1,076 spammers got through and 3 were automatically moderated. This is a great mod and I sincerely thank you for it :D

Spada_FMC
02-22-2012, 04:14 PM
We enabled Facebook login and have seen some issues.

We have a user that tried to log in by using the FB connet link.
They failed that and it was counted as spam (due to the email that was passed by FB).

Here is the entry. I removed the last four digits and replaced them with X's to protect anything that might be sensitive.
Spam-O-Matic Tagged email - app+6dcsihi7.2quci25km3.d66d191d410df363d41495c2c9 07XXXX@proxymail.facebook.com - Spammer Found and rejected.

Is there a way to whitelist an email domain?

rekha
02-22-2012, 05:20 PM
Installed

rinkrat
02-22-2012, 10:09 PM
I am suddenly getting a lot people denying they are spammers that are being banned. It started happening with my latest VB upgrade.

Anyone else have this happening?

ForceHSS
02-23-2012, 02:46 AM
disable name check

Rockboy
02-23-2012, 04:12 AM
Exact thing happened to me. IP and email checks are pretty dead on, but name check is the highest risk for false positives.

Nirjonadda
02-24-2012, 08:47 PM
Database error on 4.1.10

Alibass
02-24-2012, 08:54 PM
Database error on 4.1.10
We all get database errors at times...

Post your error message maybe someone can help you.

BoneDust
02-24-2012, 09:07 PM
Anyone able to get this to work with 4.1.10.

I had a heck of a time getting vbulletin setup and this was the culprit.

Papa Bear
02-25-2012, 12:45 AM
Anyone able to get this to work with 4.1.10.

I had a heck of a time getting vbulletin setup and this was the culprit.


Yep..works fine with 4.1.10

handruin
02-25-2012, 06:06 AM
Disregard. Solved my issue...

tommyxv
02-25-2012, 07:32 AM
3 times now, I had a user signup (not a spammer) and something in the registration system is causing it to double and triple create accounts with the exact username. The user ids are consecutive though. EX: JohnW (id34) & JohnW (id35) & JohnW (id36)

This is the only mod I have that is for Registrations. Anyone else experiencing this? I wonder if the user is clicking on the register button multiple times while waiting for the Spam Check to come back.

ForceHSS
02-25-2012, 09:35 AM
then add his info in the spam o matic forums manually

tommyxv
02-25-2012, 03:48 PM
then add his info in the spam o matic forums manually

Why would I do that...I said he wasn't a spammer? :confused: I think this mod may be fouling up the registrations by taking too long to complete them. The person signing up is probably pressing the Complete Registration button more that once. Sort of like when a double post happens.

Alfa1
02-26-2012, 05:21 PM
Is this addon still supported?
Will there be another release?

weave
03-01-2012, 06:01 PM
Just enabled this on a new forum and have had several users, who have made prior posts, all of a sudden end up being moderated...is there some setting I missed?

This is on 4.1.10

Please give me some direction in which to look for my answer/issue

squidsk
03-02-2012, 05:22 PM
They probably have fewer posts than the minimum to not be moderated.

coloradoz
03-02-2012, 08:20 PM
Works great for me on 4.1.11 ! Thanks!

Antec_HiveMail
03-08-2012, 01:58 PM
I tried going back to v1.2.8 after a complete uninstall and I started getting a DB error while trying to import xml file. So I re-installed v2.0.1 and looks like my issue is a mod conflict with KeyCAPTCHA here (https://vborg.vbsupport.ru/showthread.php?t=257294).
I disabled KeyCAPTCHA mod and now SOM is displaying stats on forum home page and in the logs in admincp. It would be nice if I could get both mods to work together like I did when I had v1.2.8 installed.

I have disabled and even uninstalled Keycaptcha, but the stats are still not showing on my home page. All it shows is the "Spam-O-Matic Statistics" and nothing underneath.

Jay A Kelley
03-08-2012, 06:38 PM
I have a clean install with 3 members. Using Darkvision skins.. I am getting the following errors when trying to enter articles in CMS

Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/class_dm_threadpost.php(1771) : eval()'d code on line 16

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php') in /home/compa37/public_html/infotech/forum/includes/class_dm_threadpost.php(1771) : eval()'d code on line 16

Then.. This is the error I get when people try to register...

Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/register.php(338) : eval()'d code on line 10

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php') in /home/compa37/public_html/infotech/forum/register.php(338) : eval()'d code on line 10

All of these errors go away when I turn Spam-0-matic so I am guessing that's the cause.

Any fixes? I'd love to use this, but can't with all these errors

ForceHSS
03-08-2012, 06:50 PM
you dont have the file uploaded to the right folder or not uploaded at all

big dan
03-08-2012, 10:31 PM
Hello,

I'm trying to install on a freshly upgraded 4.1.11 board and am getting the following error when importing the product:

Database error in vBulletin 4.1.11:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `xxxxx_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, March 8th 2012 @ 03:30:24 PM
Error Date : Thursday, March 8th 2012 @ 03:30:24 PM
Script : http://www.XXXXX.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.XXXXX.com/forums/admincp/plugin.php?do=productadd
IP Address : 24.161.16.84
Username : admin
Classname : vB_Database
MySQL Version : 5.5.20Any help would be appreciated. Thanks.

ForceHSS
03-08-2012, 11:11 PM
Hello,

I'm trying to install on a freshly upgraded 4.1.11 board and am getting the following error when importing the product:

Database error in vBulletin 4.1.11:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `xxxxx_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, March 8th 2012 @ 03:30:24 PM
Error Date : Thursday, March 8th 2012 @ 03:30:24 PM
Script : http://www.XXXXX.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.XXXXX.com/forums/admincp/plugin.php?do=productadd
IP Address : 24.161.16.84
Username : admin
Classname : vB_Database
MySQL Version : 5.5.20Any help would be appreciated. Thanks.

Run this sql
DROP TABLE IF EXISTS `glowhostspamomatic_log`;
CREATE TABLE `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(4) NOT NULL default '0',
`user_hash` varchar(50) NOT NULL,
`user_id` int(11) NOT NULL,
KEY `user_id` (`user_id`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

XtremeCrash
03-09-2012, 02:46 PM
I have the same issue.I ran that sql an its not showing in the admin panel.theres a few other mods that are doing this also.

Jay A Kelley
03-09-2012, 11:12 PM
you dont have the file uploaded to the right folder or not uploaded at all

Thank you this was a HUGE help.. It seems to be working, but I am not getting any statics on what Spam-0-Matic has blocked.. But I KNOW it's working. Any ideas?

Jay

ForceHSS
03-10-2012, 12:37 PM
it will only show that up when it blocks someone do make sure you have it to show in the settings also it is this table that holds that info glowhostspamomatic_stats

I.G.O.T.A.
03-20-2012, 12:13 PM
Moderation Tools then you will see Spam O Matic normally last on list

Where is this at?

ForceHSS
03-20-2012, 02:15 PM
the bottom of each post

Knight0319
03-20-2012, 05:57 PM
Well, I'd like to say this mod has done its job well on my forum. Can't recall if I've had many spammers get through since installing this (Though I've had some issues where it wouldnt let a real person register). About a years worth of using this resulted in this: "13904 Spammers Denied Registration". Sounds like its doing good to me.

Sure been a while since this has been updated.

shadowbreed
03-21-2012, 09:51 PM
Run this sql
DROP TABLE IF EXISTS `glowhostspamomatic_log`;
CREATE TABLE `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(4) NOT NULL default '0',
`user_hash` varchar(50) NOT NULL,
`user_id` int(11) NOT NULL,
KEY `user_id` (`user_id`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I'm having the same issue, and running that SQL gets me a second error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'CREATE TABLE `glowhostspamomatic_log` (
`date` datetime NOT NULL,
`ip` varchar' at line 2

ForceHSS
03-21-2012, 11:49 PM
I'm having the same issue, and running that SQL gets me a second error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'CREATE TABLE `glowhostspamomatic_log` (
`date` datetime NOT NULL,
`ip` varchar' at line 2

ok run this from your admin panel and it will work
sql uploaded just in case you need it

CREATE TABLE `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(4) NOT NULL default '0',
`user_hash` varchar(50) NOT NULL,
`user_id` int(11) NOT NULL,
KEY `user_id` (`user_id`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

shadowbreed
03-22-2012, 01:37 PM
That does work indeed, however if I import the mod after that, I still get the same error :S

ForceHSS
03-22-2012, 04:04 PM
strange you should not be getting it with the table there now have you tried removing and installing the xml and making sure you have all the files in the right folders

AusPhotography
03-22-2012, 11:01 PM
MySQL gone away errors - cause found...
Refer: https://vborg.vbsupport.ru/showthread.php?p=2312277#post2312277

Kym

Syxguns
03-23-2012, 02:40 AM
shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the “Type=MyIsam:” . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.



Edit: #2
For anyone that has a Database error that looks like the following example this is how I corrected it.


Error Code..

Database error in vBulletin 4.1.7:

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


$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'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; ');


$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(

`date` DATETIME NOT NULL,
`field` VARCHAR(20) NOT NULL,
`is_spambot` INT NOT NULL,
`data` VARCHAR(255) NOT NULL
) TYPE=MyISAM; ');



$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_stats`(

`denied` INT NOT NULL DEFAULT "0",
`banned` INT NOT NULL DEFAULT "0",
`moderated` INT NOT NULL DEFAULT "0",
`s_sfs` INT NOT NULL DEFAULT "0",
`s_akismet` INT NOT NULL DEFAULT "0",
`removed` INT NOT NULL DEFAULT "0"
) TYPE=MyISAM; ');


Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:

) ; ');

That may get it working for you. It worked for me when I made the change. Good Luck!

ForceHSS
03-23-2012, 02:44 AM
The version of mysql would not make a diffence

Syxguns
03-23-2012, 02:53 AM
The version of mysql would not make a diffence

Why would that be? After I made the change it worked. However, I need to remove that post because looking back I see that his issue is different than what I originally thought!

ForceHSS
03-23-2012, 02:56 AM
Why would that be? After I made the change it worked. However, I need to remove that post because looking back I see that his issue is different than what I originally thought!

to his problem I mean, your problem I know nothing off

shadowbreed
03-23-2012, 04:14 PM
shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the “Type=MyIsam:” . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.




Actually it was the same issue ;)

That worked thanks! :D

Syxguns
03-23-2012, 06:58 PM
Actually it was the same issue

That worked thanks!

Great I'm glad to hear that!

ForceHSS
03-24-2012, 12:14 AM
So what mysql version did you have

scca
03-24-2012, 07:12 PM
So I was running 1.2.7, on 4.1.2 I believe, I upgraded.to 4.1.11 and started getting error 500s on replying orc reating a new topic or post.
After troubleshooting for a couple of days, found out that disabling Spam-O-Matic made the error go away.

So I removed 1.2.7 and installed latest version from here, 2.0.2, and the same error 500s are showing up when replying or new topics.

again, disabling it, fixes the problem.

I have tried running just Spam-O-Matic with no other mods and still the same issue
Any ideas?
dont feel right running nakid right now

-bb

ForceHSS
03-24-2012, 09:25 PM
bad upgrade maybe put in a support ticket let them have a look at it first

scca
03-25-2012, 05:57 PM
support ticket with who?
vbulletin or SOM?

thanks
-

ForceHSS
03-25-2012, 06:02 PM
show the error

Syxguns
03-25-2012, 06:28 PM
GlowHost Forum: http://forums.glowhost.com/general-support/

Submit tickets to: https://glowhost.com/helpdesk/index.php?cmd=newticket

They should have all the information on a fix for it.

shadowbreed
03-25-2012, 10:40 PM
So what mysql version did you have

5.5.21-cll

ForceHSS
03-26-2012, 12:37 AM
5.5.21-cll

you should not have a problem with that version with this program
so this is what you had before so what do you have now

BryanLong
04-02-2012, 09:52 PM
Question about Akismet:
Seems to be that Users which are found with too much URL-Count automatically gets posted to Akismet. Seems that I have to find a suitable URL-Count.

In this testing time: Will there be any possibility to report "false-positives", so that the User will not be blocked by Akismet again?

Best regards,
Bryan

hqlman
04-02-2012, 11:54 PM
shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the ?Type=MyIsam:? . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.



Edit: #2
For anyone that has a Database error that looks like the following example this is how I corrected it.


Error Code..

Database error in vBulletin 4.1.7:

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


$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'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; ');


$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(

`date` DATETIME NOT NULL,
`field` VARCHAR(20) NOT NULL,
`is_spambot` INT NOT NULL,
`data` VARCHAR(255) NOT NULL
) TYPE=MyISAM; ');



$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_stats`(

`denied` INT NOT NULL DEFAULT "0",
`banned` INT NOT NULL DEFAULT "0",
`moderated` INT NOT NULL DEFAULT "0",
`s_sfs` INT NOT NULL DEFAULT "0",
`s_akismet` INT NOT NULL DEFAULT "0",
`removed` INT NOT NULL DEFAULT "0"
) TYPE=MyISAM; ');


Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:

) ; ');

That may get it working for you. It worked for me when I made the change. Good Luck!


Works perfectly, thanks a lot :)

Dave234
04-03-2012, 02:26 AM
Can someone please help me to install this on my vbulletin 4 site?

I am stuck on steps 2.2 and 2.3

These are the instructions:

/************************** 2. INSTALLATION ****************************/

2.1 IF UPGRADING FROM SPAM-O-MATIC VERSION 1:
Make sure to remove the following file before installing version 2
/forum/includes/xml/bitfield_glowhostspamomatic.xml

2.2. Upload content of the upload folder into you forum root folder

*

2.3. Import product-glowhostspamomatic.xml into products (Located
at
AdminCP -> Plugin System -> Manage Products -> Add/Import Product)

/************************** 3. SETTINGS ********************************/

3.1. You can edit plug-in options at: AdminCP -> Settings -> Options ->

GlowHost - Spam-O-Matic

3.2. You can edit plug-in messages at: AdminCP -> Languages & Phrases ->

Phrase Manager -> Search Variable Name for 'glowhostspamomatic'

/************************** 4. ACTIONS *********************************/

4.1.
A) Located @ Edit user profile
B) If you have you API keys (set in settings) -
you will be able
to submit user details to StopForumSpam.com and Akismet databases simply
Delete a post as spam and ban the user to submit them if you have these
options enabled.

4.2. Get API key for Akismet
and enter it in settings. After this edit
your usergroups and you will
see the option to "Filter posts with Akismet".
Only check groups with
untrusted users (i.e. Unregistered / Not Logged In,
Registered Users).

Syxguns
04-03-2012, 02:47 AM
@Dave234,
You have already removed the previous XML file? The next step requires FTP access to your server. Just change the name of your upload folder to the name of your forums folder. Drop the upload folder after the name is changed into the primary folder that holds your forums folder.

Primary Directory - drop it here
Forum folder

Someone else should not be granted access to your server!

Dave234
04-03-2012, 03:00 AM
I never downloaded the first Spam-O-Matic, so I doubt it's in there. Unless it came with vbulletin?

I have FTP access.

What is the name of my forums folder? I have so many folders. Is it the "Includes" folder? That has a folder in it called "XML" which has other items in it.

However my "install" folder also has a folder called "includes". But that one does not have an "XML" folder in it.

This stuff is so confusing.

And I'm worried about trying anything because I don't want to ruin my vbulletin.

I know I should back it up, but vbulletin apparently got rid of the "Backup Database" button in the admincp. I have no idea how to back up the vbulletin. Can you explain it to me, as if you were explaining it to a 2-year-old? Because that's really my level of understanding with this.

Stryker412
04-03-2012, 03:11 AM
Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?

Syxguns
04-03-2012, 03:50 AM
@Dave234,

The folders you are naming are withing the primary forum directory. Your structure should look similar to this one that I kind of made up!! I figured a picture might help. Notice the following:

1) The top folder is the primary folder that holds the forums and or other items that you may have like shopping carts and so forth.

2) The second folder is the vB folder for your forums. It may not be called forum, mine is not, but that folder is where all of vB resides.

3) All the folders under the second folder are vB folders for the forum. You may have some mods on your forum and they will show up as well.

So by telling you to rename the Upload folder to the name of your forum folder you would be looking at the second one in the picture. However, you will drop the folder onto the 1st folder. The first folder is the ROOT of the forum.

Hope that helps.

Backups of the Database are generally done through PHPMyAdmin: https://www.vbulletin.com/docs/html/main/maintenance_phpmyadmin_backup

Syxguns
04-03-2012, 03:59 AM
Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?

Styker412,
This is handled through permissions. Do not allow guest to post, and do not allow new members to post on blogs until they reach a desired number of posts on the forum. Or you can set it so that all new members posts are moderated before they are displayed.

Now Spam-O-Matic will remove a lot of stuff for you, but you have to make other preventative measures against problems like that. I don't allow guest to post, leave guest messages, leave messages on blogs, and new members I have set to have a minimum of 5 moderated posts before they become a registered user. Then they have a lot more freedom.

Dave234
04-03-2012, 04:18 AM
I really, really appreciate you laying it all out simply like that. This stuff is very complicated for me.

In my FTP program, however, I can only see the Forum folder (actually mine is labled "/") and then the folders beneath that (admincp, etc). I cannot see the primary folder (the one you labeled "My Primary Directory")

By the way, I can put a shopping cart in that folder, too? Like if I want to have an online store? I guess I can get back to that question later.

Do I really need to backup my files and everything? My webhost says they do that every 24 hours. Is there any reason to also do it through vbulletin?

To backup my vbulletin, do I need to download phpMyAdmin? http://www.phpmyadmin.net/home_page/index.php

My God, this stuff is confusing.

Syxguns
04-03-2012, 04:37 AM
I may be able to offer you a little more assistance. I suggest having PHPMyAdmin because it gives you a direct link to the database. However, that is another totally different tool to learn how to use, and without a full understanding of database and the structure of a database, I would not mess with it for now.

So you did not point your forum to a primary folder? That is okay there is another way to do everything, just ignore what I told you in the threads above. It takes a little longer to transfer, because you transfer items individually.

As far as shopping carts, yes you can add them however, most of them are not great. I'm speaking with a designer and trying to get a nice cart integrated into vB4. That's another topic. I tell you what send me a PM. The rest of this I can help you with away from the thread.

ForceHSS
04-03-2012, 12:20 PM
Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?
change permissions of the normal reg user group so they cant post at all in the blog then make a new user group and set it to transfer them to the new group after so many posts

DannyITR
04-03-2012, 12:43 PM
There are always some posts that cannot be approved. It's soooooo annoying. 1 every few days.

tony
04-06-2012, 04:47 PM
Is anyone else finding that spam-o-matic isn't stopping a spammer based on their email address?

I check the settings for StopForumSpam: Email Check is enable. But the description for this option says "Test the email address against the ban list" Does this mean it's only checking the ban list and not on stop forum spam?

ForceHSS
04-06-2012, 06:14 PM
make sure check settings

tony
04-06-2012, 07:01 PM
make sure check settings

Well, there is only one setting for the mail and it's enable.

Syxguns
04-06-2012, 09:09 PM
@tony
I just tried to register with an email address posted on stopforumspam and it did not allow me to register. I don't see the error you are talking about.

ForceHSS
04-06-2012, 09:41 PM
Well, there is only one setting for the mail and it's enable.

do u have both API Keys filled in

monday3
04-07-2012, 11:17 PM
I'm on step 2.3 of the install - trying to import the product and I'm getting a database error.

Would you please let me know how I can get this script installed.


Database error in vBulletin 4.1.11:

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 : Saturday, April 7th 2012 @ 07:15:16 PM
Error Date : Saturday, April 7th 2012 @ 07:15:17 PM
Script : http://iskcon.me/admincp/plugin.php?do=productimport
Referrer : http://iskcon.me/admincp/plugin.php?do=productadd
IP Address : 70.113.90.117
Username : admin
Classname : vB_Database
MySQL Version : 5.5.19-55

monday3
04-07-2012, 11:33 PM
I found the answer in this thread. Removed TYPE=MyISAM from script.

djbaxter
04-07-2012, 11:50 PM
Is there an easy way to restrict the Easy Cleanup Functions to Admins only, rather than including moderators?

Lover1
04-08-2012, 05:30 AM
Strange things goin' on with vB 4.1.11 Patch Level 1

Menu entry:
https://vborg.vbsupport.ru/ (http://imup.me/display-i16b5ziys.html)]


Menu with empty entries:
https://vborg.vbsupport.ru/ (http://imup.me/display-i17bjwtpj.html)

ForceHSS
04-08-2012, 12:17 PM
Strange things goin' on with vB 4.1.11 Patch Level 1

Menu entry:
https://vborg.vbsupport.ru/ (http://imup.me/display-i16b5ziys.html)]


Menu with empty entries:
https://vborg.vbsupport.ru/ (http://imup.me/display-i17bjwtpj.html)

screenshots way to small to see

tony
04-08-2012, 01:00 PM
I have both api keys setup.

One of my moderators pointed out a couple that got by spam-o-matic.

Check this one out, invesiple stoonswimmilt@gmail.com 212.94.104.4 signed on April1. SFS list stoonswimmilt@gmail.com 788 times starting back February 19. However none of those entries list IP 212.94.104.4. While a spammers IP may change they have to confirm with the e-mail addresses.

Another one; feariammaby j.u.l.o.ngj.u.long@gmail.com 121.11.64.13 joined April 1. Listed 1000 times on SFS starting March 14. Again I do not see the IP in the list.

FannBlade
04-08-2012, 02:55 PM
Strange things goin' on with vB 4.1.11 Patch Level 1

I'm sure 4.1.12 will fix it or maybe 4.1.13 when it's released 2 weeks later or maybe 4.1.....
is it just me or does each version upgrade just seem to make things worse. I spend more time fixing and updating than working on content. Now I understand why alot of big boards are still running 3.8.
Sorry for the rant but I can see why developers stop updating these mods we've all grown to love and depend on.

Maybe 4.5 CMS will be a viable product.

Syxguns
04-08-2012, 05:52 PM
screenshots way to small to see

ForceHSS,
Right click the pic and select open in new tab. The photo's are hosted, and not uploaded here.

Syxguns
04-08-2012, 06:01 PM
I have both api keys setup.

One of my moderators pointed out a couple that got by spam-o-matic.

tony,
This may be in how you have the system configured. Do you allow registration if there is a hang up in the system? You have to go through the settings and pay close attention to small things like that. You also have to let your moderators be aware of the fact that not everyone will be caught, if you allow registration anyway.

My suggestion is to allow registration, but still moderate at least the first two posts. Make sure the new members do not write access to blogs, or comments, etc. etc.

ForceHSS
04-08-2012, 06:36 PM
Strange things goin' on with vB 4.1.11 Patch Level 1

Menu entry:
http://imup.me/uploads/2012/04/thumb/i16b5ziys.png (http://imup.me/display-i16b5ziys.html)]


Menu with empty entries:
http://imup.me/uploads/2012/04/thumb/i17bjwtpj.png (http://imup.me/display-i17bjwtpj.html)

you have not uploaded all files this is why you are getting that

xtragic
04-09-2012, 02:44 AM
I've encountered a few members being moderated automatically because they posted a few links in one thread/post. Why is this? How do I stop it?

Post put under moderation based on Auto-Moderation URL count

I'm running 4.1.10

Syxguns
04-09-2012, 02:55 AM
I've encountered a few members being moderated automatically because they posted a few links in one thread/post. Why is this? How do I stop it?

I'm running 4.1.10

Change the amount of links that may be posted in the AdminCP It's called Auto-Moderation URL count: Also you may move new members to regular members quicker in the settings if you like.

tony
04-09-2012, 01:10 PM
These are my settings. After looking them over a few times it appears to me everything is set right. I must be over looking something.

Thank you

Spam-O-Matic: Protect Groups - 5,6,7,10
Spam-O-Matic: Protect Users -
Akismet: Enable - Enable
Akismet: Post Count - 10
Akismet: API Key - set
Akismet: Auto-submit from Easy Cleanup - yes
StopForumSpam: IP Check - enable
StopForumSpam: Username Check- disable
StopForumSpam: Email Check- enable
StopForumSpam: Desired Action - log and block registration
StopForumSpam: Query Connection Errors- allow registration
StopForumSpam: Remote Expiry - 90
StopForumSpam: Data Fetching - Cache -30
StopForumSpam: API Key- set
StopForumSpam: Auto-submit from Easy Cleanup- yes
Newbies Manager: Put New User Into Newbies Group?- no
Newbies Manager: Newbies Group ID- 2
Newbies Manager: Auto-promote Users From Newbies To Trusted/Registered Users?- yes
Newbies Manager: Trusted/Registered Users Group ID - 10
Newbies Manager: Promotion From Post Count - 15
Auto-Moderation: Enable- enable
Auto-Moderation: Post Action- moderate post
Auto-Moderation: Apply Auto-Moderation To Newbies only?- no
Auto-Moderation: Minimum Post Count- 6
Auto-Moderation: URL Count - 0
Easy Cleanup: Enable- enable
Easy Cleanup: User Action- remove user
Easy Cleanup: Banned UserGroup ID- 8
The following six easy clean up setting are set to yes

Syxguns
04-09-2012, 05:13 PM
These are my settings. After looking them over a few times it appears to me everything is set right. I must be over looking something.

Auto-Moderation: URL Count - 0



Change that setting to the allowed number of URL's they can post.

tony
04-10-2012, 12:14 AM
Change that setting to the allowed number of URL's they can post.

I changed this to one. I had this set to zero only because we didn't want any new users posting links.

Syxguns
04-10-2012, 12:24 AM
I changed this to one. I had this set to zero only because we didn't want any new users posting links.

tony,
Try reducing this: Auto-Moderation: Minimum Post Count- 6 Maybe set it to a 2. Then after they make two post they can post links. That will at least give you the opportunity to see if they are posting good or bad information. If that is the case and the number of post to be moderated is 2, then they will be moved into the Registered Members area and be able to post links. If that is the case and what you want to do, then change the number of links back to 0.

Just remember that not bots, but people that are posting information will make a good post at least once. You have to watch out for signatures, so turn them off for newbies.

MaXimus
04-10-2012, 02:19 AM
so turn them off for newbies.

How to turn them off for newbies below 20 posts? :confused:

Syxguns
04-10-2012, 02:43 AM
How to turn them off for newbies below 20 posts? :confused:

berryracer,
SOM allows you to create a new user group for your newbies before they are part of the forum. Read about it here: Link to GlowHost (http://forums.glowhost.com/programming-talk/spam-o-matic-newbies-manager-2382.html?q=forums/programming-talk/spam-o-matic-newbies-manager-2382.html)

They tell you step by step how to create the new user group that the new members are placed in for SOM to moderate. After the moderation of SOM they are moved to the next usergroup where vB takes over.

I hope that gives you a little better understanding.

Liquid Shock Ga
04-10-2012, 03:33 PM
works great, already stopped several spammers from signing up.

xmachine
04-10-2012, 10:10 PM
Stops my forum getting 50 spam bots a day (from China). Couldn't work without it!

robert garrett
04-11-2012, 04:13 AM
I'm really liking this one

Glockie
04-11-2012, 04:16 PM
Been using this for a while now and I must say, it's very impressive. I'm getting regular emails and it works a peach.

I do however, have a problem; the Spam-O-Matic statistics no longer update, so I am concerned if anything is wrong.

Any ideas as to what I can do about this?
These are the stats that display on forum home page.

Thanks in advance.

=======

Oh, I think I realise what's happened here, I also have 'Stop the Registration Bots' and I think the two are clashing.
I've since disabled it and will see how it goes!

=======

edie
04-12-2012, 01:36 AM
Hello. I was told to ask you guys "what to do" from Wayne Luke over at VB Tech support.
OK. New users are not showing up as "Users to be modified" any longer.

The same six "users that need to be modified" are always there.
The newest users show up in the "user" section, but don't show up in the Control panel to alert me. Wayne told me it was Glowhost issue. He could not find any other problems.

So.
I have the latest mod, 2.0.2, and so that can't be it...
do you have any ideas?

Truly appreciate your help.
- Edith Williams

ForceHSS
04-12-2012, 01:37 AM
post all settings

killslick1
04-12-2012, 07:05 PM
This breaks all posting for me when we installed this on newest (vBulletin 4.1.12) install

cool_recep
04-14-2012, 10:06 PM
How about spam Blog Entries? Ican't moderate them with SoM.

Webbstre
04-14-2012, 11:48 PM
How about spam Blog Entries? Ican't moderate them with SoM.

Unfortunately, I think the only thing you can do to stop that is to use the Newbie Group feature and remove blog posting permissions from it. It drives me nuts as well.

cool_recep
04-15-2012, 07:54 PM
Unfortunately, I think the only thing you can do to stop that is to use the Newbie Group feature and remove blog posting permissions from it. It drives me nuts as well.

I can donate if he is going to add that feautre :)

rjerina
04-16-2012, 09:37 PM
I haven't seen any settings for this, and no replies about it either (that I could find via search).

Is there a way to send detailed reports to the board admin e-mail every time a user is blocked from doing something? Thanks.

Silver_2000_)!
04-16-2012, 10:06 PM
I haven't seen any settings for this, and no replies about it either (that I could find via search).

Is there a way to send detailed reports to the board admin e-mail every time a user is blocked from doing something? Thanks.
you wont want that - even sites that arent busy can log hundreds of attempts a day some days

just look in the logs on admincp

rjerina
04-16-2012, 10:58 PM
you wont want that - even sites that arent busy can log hundreds of attempts a day some days

just look in the logs on admincp

Considering I posted about it, I am fully aware how many e-mails it could generate. I want what I want, please don't tell me what I don't want :)

225
04-16-2012, 11:14 PM
db error

ForceHSS
04-17-2012, 12:10 AM
db error
let me get my mind reading cap on

HHelp1
04-17-2012, 11:57 AM
I cant get API key :(

Fleiding
04-17-2012, 02:25 PM
How do I change these sentences?

Spam-O-Matic Statistics
x Spammers Denied Registration
x Spammers Permanently Banned
x Spammers submitted to StopForumSpam
x Spammers submitted to Akismet
x Spammy Posts Automatically Moderated

ForceHSS
04-17-2012, 02:46 PM
I cant get API key :(

you need to go to the correct forums and sign up to get it
http://www.stopforumspam.com/forum/register.php
https://akismet.com/signup/#free

Dwarden
04-17-2012, 05:05 PM
since update to 4.1.11 patch level 1 we have problem with this plugin , the moderator's option to which shall delete all users posts seems not work properly

it mark the user, claims report it to stopforumspam etc.

the user gets banned but (banned group seems weird)
yet associated posts aren't removed etc.

when i use manual moderator ban then put's the users into correct usergroup

the number setting of banned usergroup ID is correct in SOM's settings

HHelp1
04-17-2012, 06:30 PM
Well when i click Post and i got this happen http://screensnapr.com/e/fR3BLQ.jpg any help pleasE? Thanks!

ForceHSS
04-17-2012, 11:11 PM
disable all plugins and then turn each one on testing new reply to see what one is causing the error

tnedator
04-20-2012, 04:11 PM
Before I install this, can someone confirm it works on 4.1.12?

ForceHSS
04-20-2012, 06:16 PM
Before I install this, can someone confirm it works on 4.1.12?

it does

John Lester
04-22-2012, 10:41 PM
Before I install this, can someone confirm it works on 4.1.12?

Works on my 4.1.12 forums :cool:

leitel
04-23-2012, 03:24 PM
Thanks, I went ahead and installed it as well. I had an issue with having to hack the xml to fix mysql table create error. I read the solution elsewhere in this thread. It works great and I am looking forward to using it.

faisaly.com
04-23-2012, 05:26 PM
This blocks human registration badly.... using vb4.1.11 not sure why...

ForceHSS
04-23-2012, 08:43 PM
This blocks human registration badly.... using vb4.1.11 not sure why...

that would depend what settings you have

StopForumSpam: Username Check = Disabled

HHelp1
04-24-2012, 09:30 PM
Got database errors

Syxguns
04-24-2012, 10:06 PM
Got database errors

Thanks for all that valuable information that you just shared with us!! If we do not know what the error is then we can not help you fix it. Did you read the thread? There are a number of places where we have helped people with errors.

lazytown
04-27-2012, 08:33 PM
you know, it's mods that do sneaky things like this that give authors a bad name.. I disabled or minimized all the settings for 'credits' in the options.. Yet, unknown to anyone setting those visible options, when a moderator actually uses this mod, a HUGE advertisement with a graphic and coupon code and referral link is presented to them to start their own vbulletin board/forum using your hosting... Shameless....

Crotan
04-27-2012, 10:12 PM
you know, it's mods that do sneaky things like this that give authors a bad name.. I disabled or minimized all the settings for 'credits' in the options.. Yet, unknown to anyone setting those visible options, when a moderator actually uses this mod, a HUGE advertisement with a graphic and coupon code and referral link is presented to them to start their own vbulletin board/forum using your hosting... Shameless....

I'm on the fence about this, it's an internal message that only moderators will see. This is a free mod, that boy does help when fighting spam, and is almost necessary.

Giving you the optional ability to remove credits in the footer is something other authors don't do.

So I wasn't hurt by it, what ticks me off are straight out advertisements stuck in my footer by authors, that kinda stuff is nuts (which this mod doesn't do)

fly
04-27-2012, 10:20 PM
You're always welcome to make your own. If you don't want to put your advertising it, let me know when you post it.

ForceHSS
04-28-2012, 12:58 AM
you know, it's mods that do sneaky things like this that give authors a bad name.. I disabled or minimized all the settings for 'credits' in the options.. Yet, unknown to anyone setting those visible options, when a moderator actually uses this mod, a HUGE advertisement with a graphic and coupon code and referral link is presented to them to start their own vbulletin board/forum using your hosting... Shameless....

I removed all that crap long ago

BrightStar
04-29-2012, 02:59 PM
Does anyone know how do I remove homepage statistics like these

Spam-O-Matic Statistics
22 Spammers Denied Registration
12 Spammy Posts Automatically Moderated

Thanks

ForceHSS
04-29-2012, 07:01 PM
Does anyone know how do I remove homepage statistics like these

Spam-O-Matic Statistics
22 Spammers Denied Registration
12 Spammy Posts Automatically Moderated

Thanks

check options you will find it there

lazytown
04-30-2012, 03:52 PM
The problem i have is the huge graphic advertisement (with coupon and referral code) were not disclosed. I don't like surprises when I ad something to a forum. I was made to think the options in the admincp turned those off.. it doesn't mention that even if you turn it off, there's another giant ad. Also, every single post you get rid of will have an ad in the deletion comment as well (visible only to mods).

ForceHSS
04-30-2012, 04:21 PM
The problem i have is the huge graphic advertisement (with coupon and referral code) were not disclosed. I don't like surprises when I ad something to a forum. I was made to think the options in the admincp turned those off.. it doesn't mention that even if you turn it off, there's another giant ad. Also, every single post you get rid of will have an ad in the deletion comment as well (visible only to mods).

why dont you remove it then from the files

Alfa1
05-02-2012, 12:00 AM
Its in the XML.

I do agree with vissa. As this hides from the admin, this secret advertisement of hosting to moderators is plain spam. It seems intended for moderators to start a competing forum, which would be simply malicious.

I find this very ironic for an addon that is supposed to fight spam. This should be clearly stated in the description of this addon.

weave
05-02-2012, 05:20 PM
Upgraded my test board to 4.1.12 and so far this mod seems to work 100% with no issues yet found!

Cynicz
05-03-2012, 06:07 AM
Is there any particular reason why all moderators seem to have full access to spam-o-matic's permissions?

I cannot for the life of me find a way to stop certain mods from being able to use this. Even the lowest-tier mod with 1-2 permissions in one subforum can use Spam-O-Matic to hard delete posts from existence.

Even if this is only on "new" users I'm seriously concerned about the idea.

KittyWireless
05-03-2012, 02:06 PM
since update to 4.1.11 patch level 1 we have problem with this plugin , the moderator's option to which shall delete all users posts seems not work properly

it mark the user, claims report it to stopforumspam etc.

the user gets banned but (banned group seems weird)
yet associated posts aren't removed etc.

when i use manual moderator ban then put's the users into correct usergroup

the number setting of banned usergroup ID is correct in SOM's settings

We are on 4.1.12 and are having the same problem, plus when we click on a thread, and go under Moderator Options, the "Spam-O-Matic" option is not longer listed.....

Sage Knight
05-04-2012, 10:59 AM
Well it's pretty natural for that to happen since this plugin, like the other StopforumSpam one hasn't been updated in more than a year, and well things have changed and are changing in vB.

SteveLV702
05-04-2012, 04:01 PM
We are on 4.1.12 and are having the same problem, plus when we click on a thread, and go under Moderator Options, the "Spam-O-Matic" option is not longer listed.....

lucky you I can't even get installed when I attempt to upload/install the xml file I get a mysql error :'(

weave
05-04-2012, 04:31 PM
plus when we click on a thread, and go under Moderator Options, the "Spam-O-Matic" option is not longer listed.....

I am not having that issue, but am doing some testing to see if I have the first issue you listed.

Nope, all works like I think it should.

Spam-O-Matic has performed the following actions:
Selected users were removed
33 posts were removed permanently
5 PMs were removed

I confirmed in the logs and in the fourm that what I asked it to do, was in fact done.

ForceHSS
05-04-2012, 07:00 PM
lucky you I can't even get installed when I attempt to upload/install the xml file I get a mysql error :'(

post error

Syxguns
05-04-2012, 07:28 PM
SteveLV702.
Try this, it was posted a few pages back.

shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the ?Type=MyIsam:? . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.



Edit: #2
For anyone that has a Database error that looks like the following example this is how I corrected it.


Error Code..

Database error in vBulletin 4.1.7:

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


$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'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; ');


$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(

`date` DATETIME NOT NULL,
`field` VARCHAR(20) NOT NULL,
`is_spambot` INT NOT NULL,
`data` VARCHAR(255) NOT NULL
) TYPE=MyISAM; ');



$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_stats`(

`denied` INT NOT NULL DEFAULT "0",
`banned` INT NOT NULL DEFAULT "0",
`moderated` INT NOT NULL DEFAULT "0",
`s_sfs` INT NOT NULL DEFAULT "0",
`s_akismet` INT NOT NULL DEFAULT "0",
`removed` INT NOT NULL DEFAULT "0"
) TYPE=MyISAM; ');


Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:

) ; ');

That may get it working for you. It worked for me when I made the change. Good Luck!

WDS
05-06-2012, 11:18 AM
Hello, I'm trying to register a friend from my pc and i get this message:

Registration denied, this forum runs an active policy of not allowing spammers. Please contact us via the "Contact Us" page link if you believe this is in error

to that is?

ForceHSS
05-06-2012, 03:51 PM
Hello, I'm trying to register a friend from my pc and i get this message:

Registration denied, this forum runs an active policy of not allowing spammers. Please contact us via the "Contact Us" page link if you believe this is in error

to that is?
disable username

Gripi
05-08-2012, 06:40 AM
hi..

is it possible to make the Statistic only show to admin / moderator only?

i'm sure that i only need to put an if condition in the plugin manager -> Stats render, and before this:

if (($vbulletin->options['glowhostspamomatic_stat_show_denied'] == 1) || ($vbulletin->options['glowhostspamomatic_stat_show_banned'] == 1))

could someone please help

thanks

The Rocketeer
05-09-2012, 01:01 AM
any better alternate to this mod? i uninstalled it but getting tons of blog spam. anyway to perhaps use both human verification question and captcha?

ForceHSS
05-09-2012, 01:29 AM
any better alternate to this mod? i uninstalled it but getting tons of blog spam. anyway to perhaps use both human verification question and captcha?
why not disable blog for normal users

Skyrider
05-10-2012, 05:01 AM
Is there anyway I can submit users through their profile if they haven't post anything?

Crotan
05-10-2012, 05:03 AM
Is there anyway I can submit users through their profile if they haven't post anything?

Don't think so, the whole point of submitting a spammer, is that there is a submitted spam post/evidence with their user info.

djbaxter
05-10-2012, 11:29 AM
Is there anyway I can submit users through their profile if they haven't post anything?

Don't think so, the whole point of submitting a spammer, is that there is a submitted spam post/evidence with their user info.

Exactly. If someone hasn't spammed, why would you submit them to a spam database? If people start doing that, the spam database becomes useless.

CharlieDelta
05-10-2012, 01:26 PM
Exactly. If someone hasn't spammed, why would you submit them to a spam database? If people start doing that, the spam database becomes useless.
90% of the spammers that I get don't get the chance to post because they don't seem to get past the advanced forum rules check that I have. This is site wide and no one can post until they accepted these rules.

This option would be userful to me, but I have not pushed for it because I can see how it could be abused.

djbaxter
05-10-2012, 02:01 PM
90% of the spammers that I get don't get the chance to post because they don't seem to get past the advanced forum rules check that I have. This is site wide and no one can post until they accepted these rules.

This option would be userful to me, but I have not pushed for it because I can see how it could be abused.

If they post spam but the post is moderated, then submit them to the database. If they don't get a chance to post at all, they're not spammers (yet) and should not be submitted.

Skyrider
05-11-2012, 04:36 PM
Don't think so, the whole point of submitting a spammer, is that there is a submitted spam post/evidence with their user info.

If they post spam but the post is moderated, then submit them to the database. If they don't get a chance to post at all, they're not spammers (yet) and should not be submitted.
I personally disagree. And I think this states the obvious:

xxx.xxx.xxx.xx - Used by 17 users.
Users: loans_online_bc07, payday_UK0420, same_day_loanb07, credit_check_ loansA30, payday_loans_bb07, Instant_AA24, cash_loansCAS23, online_insurance419, payday_loans0419, payday_UK_AA30, cash_loansAA03, cash_loansAA24, Bad-credit-loans23, advance_onlineAA03, instant_onlineAA03, loans_online0420, cash_loansBB24
And I have over 100 more accounts like these. Plus their profile information (URL, etc) are showing all kinds of advertisement links.

With other anti-spam methods I installed, they can't even post. But that doesn't stop them in registering. Spam-O-Matic, or in this case stopforumspam isn't 100% bot-stop-proof and I'd like to submit them to stopforumspam (the easy way) but I can't because they haven't posted.

Gripi
05-11-2012, 05:55 PM
hi..

i think it will be great if "when submit post to spam o matic", it have an option to give the Infraction point, not permanent ban.

Skyrider
05-11-2012, 06:12 PM
hi..

i think it will be great if "when submit post to spam o matic", it have an option to give the Infraction point, not permanent ban.
I hope you do realize that the Spam-O-matic is meant to perm ban bots. Why would you want to Infract those AI? (Artificial Intelligence). Bots are not real humans, they are programmed to spam (usually advertisements) on other people's forums. There is no point in Infracting bot users.. They are meant to be banned and or removed entirely.

djbaxter
05-11-2012, 10:33 PM
I do agree that sometimes the email address or member name is a giveaway that might warrant submitting to the database.

Try this...

1. Admin CP >> Plugins & Products >> Add New Plugin

2. Product = vBulletin

Hook Location = useradmin_edit_column1

Title = Submit to StopForumSpam.com

Execution Order = 5

Plugin PHP 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["vbstopforumspam_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['vbstopforumspam_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' ,'');
}

Plugin is active = Yes

3. Save

rolfw1
05-13-2012, 09:17 AM
Thanks for that, will give it a try, I have 30+ spam registrations a week, below is a typical selection. Everyone of those is a bot of some sort and whilst the majority don't post, they are still spam.

It would be really nice to have a form for new users like the one shown in the image, but with tick boxes on the right for banning and submitting to the database.

BadgerDog
05-13-2012, 09:49 AM
I've done some searches in this post, but so far I can't find the answer ...

I'd like our moderators to be able to see the Spam-o-Matic logs so they can check if they get an email from someone claiming they were rejected at registration as being a spammer.

Currently, they don't see those logs, so is there a way of turning on an option so they can?

Thanks for any feedback ... :)

Regards,
Doug

djbaxter
05-13-2012, 02:12 PM
Thanks for that, will give it a try, I have 30+ spam registrations a week, below is a typical selection. Everyone of those is a bot of some sort and whilst the majority don't post, they are still spam.

It would be really nice to have a form for new users like the one shown in the image, but with tick boxes on the right for banning and submitting to the database.

For spambots, I identify the IP address and block them as IP ranges at the server level: xxx.xxx.xxx.0/24 - otherwise, it's way too much work trying to keep up with them.