[GlowHost] Spam-O-Matic - Spam Firewall stops forum spam

[Syxguns]

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

BadgerDog,
There is a way to do it, but I would not suggest it. You would be giving the moderator a little too much access to the administrator panel, where damage could be done. You don't even want SuperMods to have that kind of access.

[BadgerDog]

BadgerDog,
There is a way to do it, but I would not suggest it. You would be giving the moderator a little too much access to the administrator panel, where damage could be done. You don't even want SuperMods to have that kind of access.

Thanks.. appreciate the feedback .. :)

I wonder if there's a way of getting the code to output a text file so the mods can download and check it that way?

Regards,
Doug

[HondaATC]

I keep getting a user reporting that they are blocked from registration because they are spam...Is their user agent or something causing it? Any ideas?

[Syxguns]

I keep getting a user reporting that they are blocked from registration because they are spam...Is their user agent or something causing it? Any ideas?

First make sure that you are not blocking username in the AdminCP. A lot of us learned that with that feature on, many legitimate submissions were being blocked. Also check the log file to see if it tells you why they are being blocked. If it is an IP conflict, then the only thing you can do is register for them, unless you want to turn off SOM temporarily.

[HondaATC]

That was enabled. Turned it off and I'll send him an email to try it again. Hopefully that fixes it :)

[ForceHSS]

as it blocked his name in the first place it will have that name in glowhostspamomatic_remotecache table you will need to remove his name from that table if he still cant register

[Skyrider]

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
Thanks! However:

You need an API key from www.stopforumspam.com before you can submit to the database

In the users (bot) AdminCP profile menu. While my spam-O-matic "StopForumSpam: API Key" options has already a key filled in.

[Gripi]

hi..

i found that the auto-ban user just wont work in here..

Easy Cleanup: Enable
Easy Cleanup: User Action - Ban User
Easy Cleanup: Banned UserGroup ID - 14 <- 14 is the usergroup ID that i already created

The post / thread is moderated, i saw the soft / hard delete also works.. but the Ban wont work, the user still not banned.

could someone help?

thanks

[TheSupportForum]

Database error in vBulletin 4.1.12:

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 : Sunday, May 20th 2012 @ 03:13:05 AM
Error Date : Sunday, May 20th 2012 @ 03:13:05 AM
Script : admincp/plugin.php?do=productimport
Referrer : admincp/plugin.php?do=productadd
IP Address : --.---.--.--.
Username : -
Classname : vB_Database
MySQL Version : 5.5.21-55

[Syxguns]

Database error in vBulletin 4.1.12:

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 : Sunday, May 20th 2012 @ 03:13:05 AM
Error Date : Sunday, May 20th 2012 @ 03:13:05 AM
Script : admincp/plugin.php?do=productimport
Referrer : admincp/plugin.php?do=productadd
IP Address : --.---.--.--.
Username : -
Classname : vB_Database
MySQL Version : 5.5.21-55

It was back a number of pages when I had this error. Here is a link to the thread #1639

https://vborg.vbsupport.ru/showpost.php?p=2312347&postcount=1639

[Syxguns]

hi..

i found that the auto-ban user just wont work in here..

Easy Cleanup: Enable
Easy Cleanup: User Action - Ban User
Easy Cleanup: Banned UserGroup ID - 14 <- 14 is the usergroup ID that i already created

The post / thread is moderated, i saw the soft / hard delete also works.. but the Ban wont work, the user still not banned.

could someone help?

thanks

First let me say that you do not need to create a banned usergroup, vB default banned usergroup ID: 8

There are a couple of things that you need to check.
1) Create a new group for newly registered members, you can set the number of post they have to have before using pictures, URL's, etc. Read about it here: New Members Create Link (http://forums.glowhost.com/programming-talk/spam-o-matic-newbies-manager-2382.html?q=forums/programming-talk/spam-o-matic-newbies-manager-2382.html)

2) Make sure you have your API keys.
3) Don't check User Names, just IP and E-Mail
4) Create a longer list of bad words you can find a bunch here: Bad Words list to copy and paste (http://forums.glowhost.com/programming-talk/glowhost-spam-o-matic-bad-words-list-2372.html)

That might fix your problem, if not give us a little more detail on why they are not being banned. Have you checked the IP's at http://stopforumspam.com/ ?

[mrt12345]

Thanks it seemed to install ok after the changes thanks for your help big time. ill let you know if anyproblems come up :up:


It was back a number of pages when I had this error. Here is a link to the thread #1639

https://vborg.vbsupport.ru/showpost.php?p=2312347&postcount=1639

[Chadi]

Tried to install on vb 4.2.0

Getting error

Warning: file_get_contents([path]/includes/database_error_message.html) [function.file-get-contents]: failed to open stream: No such file or directory in [path]/includes/class_core.php on line 1149

Warning: file_get_contents([path]/includes/database_error_page.html) [function.file-get-contents]: failed to open stream: No such file or directory in [path]/includes/class_core.php on line 1256

[Syxguns]

Tried to install on vb 4.2.0

Getting error

Did you temporarily disable the Mod before the upgrade? It is working on my 4.2.0. Maybe try to remove SOM and install it again.

[Chadi]

I never had it installed previously, what should I do from here?

[Syxguns]

What version of MySQL are you running? If it is the newer version 5.1 or up then you need to first remove a line of code in the XML file for it to function. Read this: https://vborg.vbsupport.ru/showpost.php?p=2312347&postcount=1639 and give it a try. Maybe that will fix the problem. If not then let me know and we will try something else.

[Chadi]

That link says file not found?

[Syxguns]

Let's try again. If it doesn't work it is post #1639 four pages or more back.

https://vborg.vbsupport.ru/showpost.php?p=2312347&postcount=1639

[MattGarner]

Is there a way to show the logs to users who are moderators / have access to the MODCP or maybe get those to be posted in a thread automatically at all?

[dilbert]

Is this 4.2 compatible?
Thanks

[Syxguns]

Is this 4.2 compatible?
Thanks

Yes it is, just be sure to read at least the last couple of pages for basic instructions.

[GameOverViper]

This mod has been very helpful for my forum since I've launched my site.

Stats So Far
5162 Spammers Denied Registration
224 Spammy Posts Automatically Moderated

However, lately I've been getting lots of spam bots signing up and getting by the mod and posting blog posts on my board.

What can I do to combat this? Have these bots found a way past the mod? Any plans to update the mod?

[Syxguns]

This mod has been very helpful for my forum since I've launched my site.

Stats So Far
5162 Spammers Denied Registration
224 Spammy Posts Automatically Moderated

However, lately I've been getting lots of spam bots signing up and getting by the mod and posting blog posts on my board.

What can I do to combat this? Have these bots found a way past the mod? Any plans to update the mod?

It has been mentioned several times in this thread, however, there are a lot of pages to read so I'll go ahead and say it again. vB has usergroup permissions. If you are using S-O-M and have created a new members group for moderation, then just change the permissions for blogs. Only allow registered members to post blogs. Don't give permission to newly registered members, make them go through the auto moderation before they can post on a blog. Also remove the ability for them to post links, and pics, signatures, etc. You get the idea! Just use forum permissions for these settings. For the most part this mod will probably never be updated, but with a few of the tweaks that we have posted, there is really no need for it!

[molieman]

Just tried to update to the latest version of Spam-O-Matic on vB 4.2 and get a Database error when importing the xml.

This is what I get:

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `vbglowhostspamomatic_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 : Sunday, May 27th 2012 @ 12:14:14 PM
Error Date : Sunday, May 27th 2012 @ 12:14:14 PM
Script : http://mycockpit.org/forums/admincp/plugin.php?do=productimport
Referrer : http://mycockpit.org/forums/admincp/plugin.php?do=productadd
IP Address : xx.55.21.xxx
Username : xxxxxx
Classname : vB_Database
MySQL Version : 5.5.22-cll

Any help appreciated, please. I love this product :) :) :)

[Syxguns]

molieman, a couple of things I noticed:


) TYPE=MyISAM;;

MySQL Version : 5.5.22-cll

As I have mentioned before for those that don't like to read!! A couple of corrections have been made throughout this thread. and I'm going to repeat them here.

1) Make sure that you DISABLE check username, let me reapeat, do not engage check username!! There are many reasons to do this but for example if a spammer decides to use my username, then I would be blocked from registering on your site.

2) Make sure to get your API keys and use them.

3) increase the amount of words on your Bad Words list. I could give you a link to GlowHost that has a list, but I will just present it to you here to copy and paste:


acne
adipex
alprazolam
ambien
antidotes
ariset
baccarrat
blackjack
botox
buspar
butalbital
carisoprodol
casino
casinos
celexa
cell
cialis
cialis
ciallis
citibank
cyberturf
didrex
dosage
drugs
dvd
ejactulation
ejaculation
fioricet
foreclosure
forex
gambling
gold
holdem
homeloan
horny
insurance
ipod
keno
meds
mobile
mortgage
motorola
nasonex
nfsautoloan
nike
nokia
penis
pharmaceutical
pharmacy
phentermine
phone
poker
porn
prozac
refinance
ringtone
ringtones
rip
ripper
rolex
sex
slots
softtabs
sperm
strapon
tramadol
ultram
vaigra
viaagra
viagra
viccodin
xanax
xannax

4) If you are running a newer version of MySQL it has a much more strict usage and this mod as well as a few others are not allowed to make tables in the database. This is primarily because the newer versions of MySQL is enabled with strict_mode ON.

There are two ways to make this work, however, option one you may have to contact your provider to do unless you have direct access to the "my.ini" inside the MySQL installation directory. Turn Off MySQL Strict Mode (http://forum.mambo-foundation.org/showthread.php?t=5254)

Another way to do it is withing the XML file of GlowHost S-O-M. I placed this post back a number of pages and a number of members found it useful. I will repost it again here.

{Quote from post #1639 in this thread}

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.

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

[COLOR]
$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:
) ; ');

There may be a couple of other changes that I can not think of off the top of my head, but this should get it working for you. Yes it works in vB 4.2.0!:D

[Syxguns]

A few more items to remember to do for your forums using GlowHost S-O-M.

Some of these are decisions based on each individual Admin, but these are the basics that I follow.

Remember: Bold is the title in S-O-M, also I'm not going in order for a reason that will be listed last.

Q: StopForumSpam: Query Connection Errors
A: Allow Registration

Why you may ask. If for some reason the StopForumSpam site is down, I do not want to block the registration of the user. As I will explain in just a little bit, they will be placed in auto-moderation anyway.

Q: Auto-Moderation: Enable
A: Yes
This is where your list of Bad Words, and New Member Group come in to play. It will be explained.

Q: Auto-Moderation: Post Action
A: Moderate Post
With this utility you have the option to ban the user, and remove the post before anyone other than Mods, and Admin can see it. It is located in the Moderation Tools under the Post called of course Spam-O-Matic!

Q: Auto-Moderation: Apply Auto-Moderation To Newbies only?
A: Yes
As stated earlier this will be explained and you MUST follow through for it to be effective.

Q: Auto-Moderation: Minimum Post Count
A: This depends on the Admin. I personally think that withing the first 3 posts that I will know if the member is a spammer or not. I set mine to 3, and for good reason that you will see here shortly.

Q: Auto-Moderation: Bad Words
A: Listed in my post above, just copy and paste

Q: Auto-Moderation: URL Count
A: You may set this to any number you desire. Remember that this only applies to your new user group that we have not mentioned yet. You may not want them to post any URL's so you may set it to 0.

Q: Easy Cleanup: Banned UserGroup ID
A: By default the Banned User ID in vB is 8.
I mention this only because a user created a new banned user group for this mod which is not necessary. Just use the default Banned User ID. If you want to double check you may select AdminCP > Usergroups > Manage Usergroups and you will see the ID next to Banned Users.

The rest of the questions are pretty much self explanatory, however, if you have a question feel free to ask. Now we are going to talk about creating a new usergroup. Instead of giving you a URL, I will just post the information here.

Q: Newbies Manager: Put New User Into Newbies Group?
A: Yes

Note: as you create a new usergroup remember that the next question is:
Q: Newbies Manager: Newbies Group ID
A: Only the creator of the group will know the ID.


The Newbies Manager in GlowHost's Spam-O-Matic Spam Firewall for vBulletin forums is built into Spam-O-Matic so that new users who register on your forum are automatically placed into a usergroup that has less permissions than your regular "Registered Users" group.

You will need to create this usergroup on your own, and then supply Spam-O-Matc with the numerical ID of this usergroup so that Spam-O-Matic knows what group to put new users into.

Once these users have proven their trustworthiness on your forums, Spam-O-Matic can automatically promote them to the "Registered Users" group or any other group of your choice based on simple post-count rules. If you want a more advanced promotion system, you can use the one built into vBulletin and disable the simple promotion system built into Spam-O-Matic.

You are free to disable automatic promotions from Spam-O-Matic and vBulletin completely, and then move the users manually if you like.

CAUTION: When you make your "Newbies" Group, make sure to do the following:

A) Go to your vBulletin Admincp > Forums and Moderators > Forum Permissions and make sure to give your Newbies a lower set of permissions that your Registered Users. (For example, turn off signatures and image uploads)

B) Go to vBulletin Admincp > > Usergroups > Usergoup Manager and permission the usegroup with a lower set of permissions than your Registered Users.

If you fail to perform the above steps it is possible that you have allowed your Newbies to view your private forums or other privileged areas.

It is strongly suggested that you permission your Newbies group before enabling Newbies Manager in Spam-O-Matic.

If you have questions regarding the functionality of the Newbies Manager, please post in this thread.

After creating the usergroup take note of the ID and place it in S-O-M as stated above.

Feel free to ask question if you have any. Also remember that these are the types of settings that I use. Each person is going to have different perspectives. Only use this as a guide when getting your feet wet for the first time.:)

[Melody of Rain]

I cannot begin to tell you how much I love this mod. 305 Spammers Denied Registration in 6 weeks and a huge headache removed for me.

[The Rocketeer]

This mod has been very helpful for my forum since I've launched my site.

Stats So Far
5162 Spammers Denied Registration
224 Spammy Posts Automatically Moderated

However, lately I've been getting lots of spam bots signing up and getting by the mod and posting blog posts on my board.

What can I do to combat this? Have these bots found a way past the mod? Any plans to update the mod?


try this :D - https://vborg.vbsupport.ru/showthread.php?t=283722
Minimum Post Count Required To Post Blog Entries

For various reasons we uninstalled this Glowhost mod after using it for almost 2 years. The new version is bad, has less features and blocked a lot of real human registrations and posts, the author also hasn't updated it in a long time. Now we use vB Q&A as the Human Verification system.

[rrewerts]

No workie....

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, May 31st 2012 @ 06:58:19 PM
Error Date : Thursday, May 31st 2012 @ 06:58:19 PM

[ForceHSS]

No workie....

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, May 31st 2012 @ 06:58:19 PM
Error Date : Thursday, May 31st 2012 @ 06:58:19 PM

Check post 1775 for fix

[leclownos]

Thanks !!!!

[abieteh.com]

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;;


If you get error for TYPE=MyISAM you must

Find TYPE=MyISAM in XML and replace it with ENGINE=MyISAM

[Skyrider]

For some reason, bots register on the site regardless. I've checked the logs:

2012-06-02 09:46:55

199.167.146.114
loans_Canada12 isaacroberts270@yahoo.co.uk Passed StopForumSpam checks.

Sent to vBulletin Registration System.

While clearly a lot of bots on that IP are on StopForumSpam database..

Any idea what might be up?

[Syxguns]

For some reason, bots register on the site regardless. I've checked the logs:

2012-06-02 09:46:55

199.167.146.114
loans_Canada12 isaacroberts270@yahoo.co.uk Passed StopForumSpam checks.

Sent to vBulletin Registration System.

While clearly a lot of bots on that IP are on StopForumSpam database..

Any idea what might be up?

It should be stopping them, but for some reason if it is not able to you still have the new usergroup that you created, so they will be banned anyway before a post is ever seen.

The other thing that you can do as Admin is go into Settings > Options > User Banning Options. There you may ban the IP address and the e-mail address.

[Skyrider]

That's the thing Syxguns. The IP & E-Mail is selected. Just not the usernames. Though I recently have been given a hint to decrease the database date check from 60 to 30 days.

[Syxguns]

That's the thing Syxguns. The IP & E-Mail is selected. Just not the usernames.

The setting you changed should help, but what I was talking about was the User Banning Options within vB settings. The reason I use this option if I need to is because I have mine set to allow registration if StopForumSpam is down, or not able to retrieve the information. The member is allowed to register, but then are placed in the New Member category that I created.

New Member: Not able to post URL's, can not use signature, can not post pictures, have access to see blogs, but can not leave comments. I have this set to 2 on post count before they become a registered member. S-O-M should automatically moderate the post for me, but if for some reason it doesn't then I have the logs and can ban the e-mail, and or IP address in vB if I have to. So far I've only had a couple of spammers get through on my test site.

[PBRiot]

Hi there, I've got Auto-Moderation: Enable set to "Disabled" and yet I am still getting new users who post links in their posts moved to auto-moderation. I would like to avoid that from happening - any assistance? Thanks!

[Syxguns]

Hi there, I've got Auto-Moderation: Enable set to "Disabled" and yet I am still getting new users who post links in their posts moved to auto-moderation. I would like to avoid that from happening - any assistance? Thanks!

Well, I don't have full information on your settings to be able to really help you out.

1) Did you create a new members group and if you did do you allow for URL's and pics? Those are part of the permissions that need to be adjusted. However, if you are not placing anyone in a new member group then make sure that Newbies Manager: Put New User Into Newbies Group? is set to NO.

2) I haven't ever tried it but maybe set Newbies Manager: Promotion From Post Count
to 0 and have them moved directly into the registered member area.

To be hones you may not want to use this modification. You would probably like vBStopForumSpam. It does not have built in auto moderation, it is just for registration. It is reported to work with vB 4.

https://vborg.vbsupport.ru/showthread.php?t=230921&highlight=stop+forum+spam

[GameOverViper]

I uploaded everything onto a new forum of mine, then went to install and it gives me this error.

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 : Saturday, June 9th 2012 @ 10:02:54 AM
Error Date : Saturday, June 9th 2012 @ 10:02:54 AM
Script : http://playstation3clans.net/admincp/plugin.php?do=productimport
Referrer : http://playstation3clans.net/admincp/plugin.php?do=productadd
IP Address : **.***.*.**
Username : P3C VIPER
Classname : vB_Database
MySQL Version : 5.5.23-55

[ForceHSS]

I uploaded everything onto a new forum of mine, then went to install and it gives me this error.

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 : Saturday, June 9th 2012 @ 10:02:54 AM
Error Date : Saturday, June 9th 2012 @ 10:02:54 AM
Script : http://playstation3clans.net/admincp/plugin.php?do=productimport
Referrer : http://playstation3clans.net/admincp/plugin.php?do=productadd
IP Address : **.***.*.**
Username : P3C VIPER
Classname : vB_Database
MySQL Version : 5.5.23-55

run this

[tommac3]

Any chance we can get a blog spamming feature? I have spamomatic installed but just got 3900 spammy blog posts over the past day.

[ForceHSS]

Any chance we can get a blog spamming feature? I have spamomatic installed but just got 3900 spammy blog posts over the past day.

Make a new user group that has access to blog posting and don't let normal users post to the blog then you can set it that after x amount of posts they get auto moved to the new group you can also make it that the first post is modded this way it will stop all spammers. On another note if spammers are registering then I would look at your Spam O Matic settings and see why.

[oshrizak]

run this

Ok call I did this and still get Database error as above

[ForceHSS]

Ok call I did this and still get Database error as above

MySQL Version : 5.5.23-55 I would say this is your problem needs to be downgraded

[oshrizak]

Ok thanks for the answer unfortunately that isn't gonna happen so I will wait till there is an upgrade to support 5.5.23-55 but I will keep this is mind

[Alibass]

Mate I have MySQL Version : 5.5.23-55 and I have no problem running this mod.

[ForceHSS]

Mate I have MySQL Version : 5.5.23-55 and I have no problem running this mod.

as you dont have all the same things he has or the same hosting does not mean it will work even if you do have the same mysql version

[Vcize]

I'm having a weird problem with this mod.

When I have it enabled, any time I try to save anything on the admin site (not just within this mod, but anywhere) it will time out. As soon as I disable this mod, the problem goes away.

Here is what my host said about the issue. Again this seems to go away when I disable this mod...

Most likely, the code within the forum is allowing Keep-Alive connections, but it looks like they do not get closed efficiently and they stay open. This bogs down Apache, as it only has a certain number of connections allowed to be open at once. Have you had a developer take a look at the code and optimize the way it handles keep-alive connections? I would start there, and if there are any server-side configurations that the developer would need in order to optimize the site code, just open a ticket and we'll get it set to whatever they need.

[Sadikb]

Ok call I did this and still get Database error as above

Your problem is not MySQL but the code.

Change all occurence of

TYPE=MyISAM

to

ENGINE=MyISAM

in the XML and that will solve the DB Errors.

[oshrizak]

Thanks for that it fixed it had to change it in the product xml

[Alibass]

as you dont have all the same things he has or the same hosting does not mean it will work even if you do have the same mysql version
Mate I disagree with your statement BUT it looks like he has the issue fixed.

[ForceHSS]

Your problem is not MySQL but the code.

Change all occurence of

TYPE=MyISAM

to

ENGINE=MyISAM

in the XML and that will solve the DB Errors.

had this fix a few posts back on post 1790

[PBRiot]

Well, I don't have full information on your settings to be able to really help you out.

1) Did you create a new members group and if you did do you allow for URL's and pics? Those are part of the permissions that need to be adjusted. However, if you are not placing anyone in a new member group then make sure that Newbies Manager: Put New User Into Newbies Group? is set to NO.

2) I haven't ever tried it but maybe set Newbies Manager: Promotion From Post Count
to 0 and have them moved directly into the registered member area.

To be hones you may not want to use this modification. You would probably like vBStopForumSpam. It does not have built in auto moderation, it is just for registration. It is reported to work with vB 4.

https://vborg.vbsupport.ru/showthread.php?t=230921&highlight=stop+forum+spam

1 - No, I did not.
2 - N/A, as I'm not using the newbies usergroup, right?

I've been using this mod for some time, and it's been extremely effective, so I'd like to continue supporting it before just jumping ship to something else.

Anyone else have some insight?

[Alibass]

@PBRiot

In vB admincp under usergroups/forum permissions/group do you have Post/Thread Permissions/Follow Forum Moderation Rules accidentally ticked to no? If you do that will put posts for anyone in that group into the moderation queue.

When you have auto-moderation disabled in SOM that should shut off any moderation of posts unless posts are being monitored elsewhere.

[exportforce]

Does that baby still fully work with VB4.2 ?

[Vcize]

I'm having a weird problem with this mod.

When I have it enabled, any time I try to save anything on the admin site (not just within this mod, but anywhere) it will time out. As soon as I disable this mod, the problem goes away.

Here is what my host said about the issue. Again this seems to go away when I disable this mod...

Most likely, the code within the forum is allowing Keep-Alive connections, but it looks like they do not get closed efficiently and they stay open. This bogs down Apache, as it only has a certain number of connections allowed to be open at once. Have you had a developer take a look at the code and optimize the way it handles keep-alive connections? I would start there, and if there are any server-side configurations that the developer would need in order to optimize the site code, just open a ticket and we'll get it set to whatever they need.

Just trying to see if anyone has any ideas on this.

I only notice the problem on my largest forums. I'm guessing that there are some keep-alive connections being left open somewhere in the mod, and that doesn't effect small/medium sized forums as it takes a long time for those to add up high enough to do any harm.

[rigox2002]

Hello,

Complete noobie here wondering if i could get some help I have SOM installed on my forum i am running the latest version of vB 4.2.0. I am having a issue with SOM marking some of my valid users as spammers when they try to register on my forum. These users that have tried to register have used the following email address's @live.com (hotmail) @yahoo.com and @gmail.com.

I have disabled the native spam ware on vb and am running SOM as the only spam ware on my forum.

Is there something i need to change around? how would i fix this? Is there a place to manually approve registrations?

[Alibass]

Turn off names during the SOM check. Only allow IP and email check.

[blh654]

Is there a way to add users to an 'exclusion' list or something? Some users have said they are rejected from registering and after looking at the logs it was because their usernames were common names that had been added to the spam database as spam usernames - is there a way to manually override this?

[Alibass]

Not that I am aware of. An IP and Email check are more than enough. This mod or any other mod is not 100% full proof against spammers. Checking a database against names is a little ridiculous in my book. There are just to many common domoninators.

[blh654]

D'oh, stupid me. I completely forgot to check the settings and I realized all the tests were set to 'on' - my bad, sorry about that!

[Disco_Stu]

Just added this to 4.2.PL2

Let's see what this puppy can do!

[Chadi]

How do I manually revert a rejected registration and allow the user to proceed?

I got this:

Spam-O-Matic Tagged username - Sneakers - Spammer Found and rejected.

How do I know the detailed reasons why it was rejected?

[ForceHSS]

How do I manually revert a rejected registration and allow the user to proceed?

I got this:

Spam-O-Matic Tagged username - Sneakers - Spammer Found and rejected.

How do I know the detailed reasons why it was rejected?
run this query
UPDATE `glowhostspamomatic_remotecache` SET `is_spambot`='0' WHERE (`field`='username') AND (`is_spambot`='1') AND (`data`='Sneakers')

and disable username in your settings so this wont happen again

make sure you make yourself superadmin from the config then go to AdminCP > Statistics & Logs > Glowhost Spam-O-Matic Logs
if it was his name first check on the spam o matic forums make sure he is not a spammer check his ip and email as well and only run the query if he is found to be a real person

[Syxguns]

How do I manually revert a rejected registration and allow the user to proceed?

I got this:

Spam-O-Matic Tagged username - Sneakers - Spammer Found and rejected.

How do I know the detailed reasons why it was rejected?

AdminCP > Statistics & Logs > Glowhost Spam-O-Matic Logs

In the log you can see the reason why they were not allowed to register. 95% of the time it is the user name that is rejected, that is why we suggest you turn that feature off. Occasionally an IP address may be the culprit. You can double check this information if you like, but sometimes legitimate users may be using RIPE Networks, which I would say 99% are spammers. If this is the case, then you will have to manually register them. The log gives you their IP, e-mail, and username. that's enough for you to get started, then when you send them an e-mail include the link to their profile and ask them to complete the information.

[Chadi]

How do I run a check and pull the reason for block? No reasons are given in my logs except below

Spam-O-Matic Tagged email - [email address] - Spammer Found and rejected.

That doesn't specify the reason though

I have disabled username check in the meantime, thanks for that tip.

[ForceHSS]

How do I run a check and pull the reason for block? No reasons are given in my logs except below

Spam-O-Matic Tagged email - [email address] - Spammer Found and rejected.

That doesn't specify the reason though

I have disabled username check in the meantime, thanks for that tip.

The reason is given in your log plane as day

[Okuma Steve]

This mod is freaking awesome! I have always been skeptical of spam mods for some reason but I had no choice but to try it out yesterday. My site has been getting hammered by spammers in the last week.

Installed it on 4.2.0 PL 2 without any hiccups and set it to check IP and email address, and it has blocked 29 spammers in about 20 hours, while letting 17 actual accounts through with no problems.

Thank you for this mod!

[Gecuba]

Great mod!
The only one feature I miss is - menu Submit Data to StopForumSpam in adminCP options or user's profile. Sometimes "fresh" spammer registrations are passing through stopforumspam check.

[Okuma Steve]

Great mod!
The only one feature I miss is - menu Submit Data to StopForumSpam in adminCP options or user's profile. Sometimes "fresh" spammer registrations are passing through stopforumspam check.

This! I catch a lot of spammers who never post so I have no why of reporting there info.

[djbaxter]

Great mod!
The only one feature I miss is - menu Submit Data to StopForumSpam in adminCP options or user's profile. Sometimes "fresh" spammer registrations are passing through stopforumspam check.

This! I catch a lot of spammers who never post so I have no why of reporting there info.

I think I responded to this previously. I'm using the plugin from the older vBSTopForumSpam add-on in combination with the Glowhost add-on:


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


Added: see https://vborg.vbsupport.ru/showpost.php?p=2344884&postcount=1826 below

[Okuma Steve]

I think I responded to this previously. I'm using the plugin from the older vBSTopForumSpam add-on in combination with the Glowhost add-on:


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


Do I need to manually add the stopforumspam api key into the plugin?

[djbaxter]

You could. The Glowhost version already has a place to input the key in the settings so you could try it without any changes.

In case it doesn't work that way, what I did was leave the old product, which also provided a place to add the key, installed but disabled. Never bothered uninstalling it on the grounds of "if it ain't broke don't fix it" but not sure if it's actually required or not.

[CharlieDelta]

Thanks for that djbaxter. I changed the code a bit and added the API key directly.
Works great.

[DocZaius]

Thanks for that djbaxter. I changed the code a bit and added the API key directly.
Works great.

Where exactly do I put the API key? I'm trying to get this to work, too.

[CharlieDelta]

Here is the code with my changes. Make sure to add your API Key below.

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");

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="YOUR API KEY"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}
Cheers.

[djbaxter]

Here is the code with my changes. Make sure to add your API Key below.

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");

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="YOUR API KEY"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()" type="button" class="button" value="' . $vbphrase['submit'] . '"/>');
}
Cheers.



Good job! Thank you. :) :up:

[DocZaius]

Thank you so much!

[XtremeCrash]

I have installed but not showing that stats on home page.Everything is turned on in the admin part an on the home it just says Spam-O-Matic Statistics an thats it.

[valedumi]

Is it possible that the Spam-O-Matic Statistics to be visible only by the forum admin?
thanks.
---------------------------
I fix the issue. Solution:
In the Plugins & Products->Plugin Manager-> Product : GlowHost - Spam-O-Matic there is a plugin called "Stats render" edit this and a the beginning put this php code

if (is_member_of($vbulletin->userinfo, 6))
{

where number 6 is the Administrator group ID.
at the very end add the

}

this worked for me.

[BoardWizard]

Why doesn't the Spam-O-Matic log not show under my Statistics and Log in the AdminCP? I've seen it on a screenshot for someone else's. Is there another way to look at the statistics?

[valedumi]

I have the same issue, I can see the "Spam-O-Matic Statistics " in the "What's Going On?" vut no statistics.
I have the latest build vBulletin 4.2.0 Patch Level 2.
Thanks

[Syxguns]

Why doesn't the Spam-O-Matic log not show under my Statistics and Log in the AdminCP? I've seen it on a screenshot for someone else's. Is there another way to look at the statistics?

Go to AdminCP > Settings > Options > GlowHost - Spam-O-Matic

Set all of these to YES:

Statistics: Display Number of Denied Registrations?

Statistics: Display Number Of Banned Spammers?

Statistics: Display Number Of User Details submitted to StopForumSpam?

Statistics: Display Number Of Post Details submitted to Akismet?

Statistics: Display Number Of Automoderated Posts?

Statistics: Display Number Of Removed Posts?

I have the same issue, I can see the "Spam-O-Matic Statistics " in the "What's Going On?" vut no statistics.
I have the latest build vBulletin 4.2.0 Patch Level 2.
Thanks

The statistics will show in the WGO. Just follow the above instructions.

If you have a busy forum, you should do two things. First add a question in the "Contact Us" about registration problems. Second you should check the logs every so often to see if a user was not permitted access to the forum that should have been. This also helps you decide if certain settings should be turned off in the SOM settings.

Hope that information helps!

[rhody401]

Maybe it didnt have any activity yet?

[BoardWizard]

Go to AdminCP > Settings > Options > GlowHost - Spam-O-Matic

Set all of these to YES:

Statistics: Display Number of Denied Registrations?

Statistics: Display Number Of Banned Spammers?

Statistics: Display Number Of User Details submitted to StopForumSpam?

Statistics: Display Number Of Post Details submitted to Akismet?

Statistics: Display Number Of Automoderated Posts?

Statistics: Display Number Of Removed Posts?



The statistics will show in the WGO. Just follow the above instructions.

If you have a busy forum, you should do two things. First add a question in the "Contact Us" about registration problems. Second you should check the logs every so often to see if a user was not permitted access to the forum that should have been. This also helps you decide if certain settings should be turned off in the SOM settings.

Hope that information helps!

Those options were all set to YES and my statistics appear in WGO but just not in the Statistics & Logs in the admin CP. I don't know why.

[everydayforums]

Mine didn't show instant, had to wait for activity..

[Syxguns]

Those options were all set to YES and my statistics appear in WGO but just not in the Statistics & Logs in the admin CP. I don't know why.

Create a new user, you should not be blocked by SOM. Then after the user is created check your stats in the AdminCP. It should then list the new user and say, passed.... sent to registration. Let me know if that works for you. The log should look similar to this:

[BoardWizard]

I've had the Spam-O-Matic for about a week now. Theres 28 posts banned and 1 user registration that was denied

[Syxguns]

I've had the Spam-O-Matic for about a week now. Theres 28 posts banned and 1 user registration that was denied

Interesting! Open your PhpMyAdmin and check the database to make sure you have the following tables:

glowhostspamomatic_log
glowhostspamomatic_remotecache
glowhostspamomatic_stats

There may have been an error in the upload of the mod.

[imported_dfmafia]

uninstalled.

over 3,000 blocked over past week - only 3 people were able to register.

many of my friends could not register due to being flagged as a spammer.

only stats that showed were blocked registrations.

vB 4.2.0 PL 2

went with a different product to cure my spammer block requirements

[Syxguns]

uninstalled.

over 3,000 blocked over past week - only 3 people were able to register.

many of my friends could not register due to being flagged as a spammer.

only stats that showed were blocked registrations.

vB 4.2.0 PL 2


went with a different product to cure my spammer block requirements

Did you have check user name enabled? What system did you switch to?

[imported_dfmafia]

random questions and advanced registration system - works for keeping bots at bay

yes, check username was enabled

[Syxguns]

yes, check username was enabled

That was what was causing the issue. When I disabled that and only had IP Address and e-mail address enabled it worked perfect.

I have the VSA Advanced Registration mod and I love it. It does work for keeping bots at bay, but it doesn't work for blocking IP addresses, and e-mails.

[imported_dfmafia]

I'll give it another go.
site still in work but taking registrations now as i clean up styles.

thnx for the assist. uername is disabled but ip and email are enabled.

are there still issues with KeyCAPTCHA? full stats never showed on the WGO for me at anytime. just Spammers Denied Registration.

[Syxguns]

are there still issues with KeyCAPTCHA? full stats never showed on the WGO for me at anytime. just Spammers Denied Registration.

I'm not sure about the keyCAPTCA, as I don't use it. However, the stats for GlowHost only shows, "Spammers Denied Registration" and "Number of spam posts moderated" if that feature is turned on.

You may not have everything set up correctly. There are a lot of little things to do as in making a new usergroup for new members, setting the amount of posts that are moderated, etc. I set the moderated post to 2 because it moderates everything. In other words the first two posts are moderated even if they are legitimate posts. Kind of a pain, and I may set it to just the first post. Normally the first post is all you need to know if they are a spammer or not. You of course have to turn off links, signatures, etc on the new member, but this gives you the opportunity to look at the user profile or have the mods look at the profile for you. Setting up e-mails about new registrations to the mods takes care of this for you.

[AndrewRich]

To make this work with the existing StopForumSpam API key from Spam-O-Matic, I changed the following in your code:

if ($vbulletin->options["vbstopforumspam_apikey"])
...
<input name="api_key" type="hidden" value="' . $vbulletin->options['vbstopforumspam_apikey'] . '">

To:

if ($vbulletin->options["glowhostspamomatic_apikey"])
...
<input name="api_key" type="hidden" value="' . $vbulletin->options['glowhostspamomatic_apikey'] . '">

Just replacing vbstopforumspam_apikey with glowhostspamomatic_apikey. That seems to work.

Thanks! This helps out my moderators quite a lot.

[XtremeCrash]

Still dosnt work for me.Ive has it installed for the past week an still no stats in WGO box.

[BoardWizard]

Interesting! Open your PhpMyAdmin and check the database to make sure you have the following tables:

glowhostspamomatic_log
glowhostspamomatic_remotecache
glowhostspamomatic_stats

There may have been an error in the upload of the mod.

Checked the databases and there wasn't any of those tables. How do I get them?

[BoardWizard]

nevermind i found them in the databases but they are still not in the adminCP

[Syxguns]

nevermind i found them in the databases but they are still not in the adminCP

That is really strange. I haven't run across that before. Maybe someone with a little more knowledge can help you out on that.

You say that they are not showing in the AdminCP. You mean in the log files are not showing, or the information is not showing on the WGO area?

[ForceHSS]

Make yourself superadmin from the config so you can see all

[BoardWizard]

under statistics & logs where spam-o-matic log is supposed to be, there is only Statistics, Control Panel Log, Moderator Log, Scheduled Task Log, Log Manager, Transaction Log and Transaction Stats
i made myself a superadmin and it was still not there

[Syxguns]

under statistics & logs where spam-o-matic log is supposed to be, there is only Statistics, Control Panel Log, Moderator Log, Scheduled Task Log, Log Manager, Transaction Log and Transaction Stats
i made myself a superadmin and it was still not there

In the cofig.php make sure you have the following permissions set for your User ID #:

USERS WITH ADMIN LOG VIEWING PERMISSIONS

SUPER ADMINISTRATORS

There are a couple of others you may want to check as well. If you have the Log Viewing Permissions set, then you should be able to see it. Refresh system cache if you need to.

[ForceHSS]

under statistics & logs where spam-o-matic log is supposed to be, there is only Statistics, Control Panel Log, Moderator Log, Scheduled Task Log, Log Manager, Transaction Log and Transaction Stats
i made myself a superadmin and it was still not there

add your id to all of them that will let you see everything

[BoardWizard]

i really have no idea why this isn't working. i've done everything you guys have suggested

[selfsufficient]

I installed Spam-o-matic on my new forum and started getting "white screen" when hitting the "go advanced" button when posting.

I worked out (after about an hour) that when disabling Akismet in the CP the white screen problem was resolved. I followed the install instructions - have I done something wrong?

Also, I have two links side-by-side "Web hosting Web Hosting" in my footer link bar, why two?

Cheers :)

[ForceHSS]

You can remove the web hosting links see settings for the plugin near the bottom of it you will see

[selfsufficient]

Right got it - thanks!

Just to update on my "white screen" issue, it seems the problem might be more than Akismet and likely my own misunderstanding of my host server. I'm waiting on a relpy from my host to see if in fact I need to "apply" for allow_url_fopen - I know they have it but I'm now not sure if it's enabled.
If allow_url_fopen is not enabled by default, that could be the real cause of my white screen on posting.

[MediaHound]

There is a setting for "Auto-Moderation: URL Count".
Does this check URLs posted in the vb blogs also?
Seems spammers are still able to post links in blogs.
The blog spam that vb attracts is just horrible and makes the admins waste so much time dealing with it. We need better tools to stop blog spam.

[imported_dfmafia]

i set my newbies usergroup to not access blog

newbies with 10 posts will be moved to registered usergroup and now have access to blog.

this stopped my spam

[ForceHSS]

There is a setting for "Auto-Moderation: URL Count".
Does this check URLs posted in the vb blogs also?
Seems spammers are still able to post links in blogs.
The blog spam that vb attracts is just horrible and makes the admins waste so much time dealing with it. We need better tools to stop blog spam.

Blogs are not checked with this plugin it does need updated as you cant even send the spammer info to spam o matic forums

[FNG]

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

Script : /forum/admincp/plugin.php?do=productimport
Referrer : /forum/admincp/plugin.php?do=productadd
Classname : vB_Database
MySQL Version : 5.5.24-cll

This is what I see when I try to import the product.

[AFQ]

I've integrated my WP with vB. A thread is made in vB for every post in make in WordPress. If I add the usergroup which automatically makes threads in vB as an exception in Spam-O-Matic, will it allow them to make threads or no?

[OsideRida06]

This is really awesome. I love this mod.

[tonym]

Best mod I ever used....was getting 50 spambot signups a day....now 0 for last 4 months now

Thanks

[Froberg]

Hi,

I love the mod, it's an absolute Godsend in keeping malicious users out of my site.

I'm running a board in Danish, and it doesn't exactly look good that Spam-O-Matic is the only thing not translated.
I've been up and down the phrase variables, will I really have to modify the xml directly? A casual perusal seems to indicate that if I change the following:

<!-- Stats -->

<plugin active="1" product="glowhostspamomatic" executionorder="50">
<title>Stats render</title>
<hookname>forumhome_complete</hookname>
<phpcode><![CDATA[

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

$stats = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "glowhostspamomatic_stats");

//echo '<pre>';
//print_r($vbulletin->stylevars['imgdir_misc']);
//echo '</pre>';

$template_hook[forumhome_wgo_pos2] .= '

<div class="wgo_subblock section">
<h3 class="blocksubhead"><img src="'.$vbulletin->stylevars['imgdir_misc']['imagedir'].'/forum_stats.png" alt="Spam-O-Matic Statistics" />';

if ($vbulletin->options['glowhostspamomatic_stat_show_link'] == 1) {
$template_hook[forumhome_wgo_pos2] .= '<a href="https://vborg.vbsupport.ru/showthread.php?t=248042" target="_blank">Spam-O-Matic Statistics</a>';
} else {
$template_hook[forumhome_wgo_pos2] .= 'Spam-O-Matic Statistics';
}


$template_hook[forumhome_wgo_pos2] .= ' </h3>
<div>';

if (($vbulletin->options['glowhostspamomatic_stat_show_denied'] == 1) && ($stats['denied'] > 0)) {
$template_hook[forumhome_wgo_pos2] .= '<p>'.$stats['denied'].' Spammer'.(($stats['denied'] > 1)?'s':'').' Denied Registration</p>';
}

if (($vbulletin->options['glowhostspamomatic_stat_show_banned'] == 1) && ($stats['banned'] > 0)) {
$template_hook[forumhome_wgo_pos2] .= '<p>'.$stats['banned'].' Spammer'.(($stats['banned'] > 1)?'s':'').' Permanently Banned</p>';
}

if (($vbulletin->options['glowhostspamomatic_stat_show_s_sfs'] == 1) && ($stats['s_sfs'] > 0)) {
$template_hook[forumhome_wgo_pos2] .= '<p>'.$stats['s_sfs'].' Spammer'.(($stats['s_sfs'] > 1)?'s':'').' submitted to StopForumSpam</p>';
}

if (($vbulletin->options['glowhostspamomatic_stat_show_s_akismet'] == 1) && ($stats['s_akismet'] > 0)) {
$template_hook[forumhome_wgo_pos2] .= '<p>'.$stats['s_akismet'].' Spammer'.(($stats['s_akismet'] > 1)?'s':'').' submitted to Akismet</p>';
}

if (($vbulletin->options['glowhostspamomatic_stat_show_mod'] == 1) && ($stats['moderated'] > 0)) {
$template_hook[forumhome_wgo_pos2] .= '<p>'.$stats['moderated'].' Spammy Post'.(($stats['moderated'] > 1)?'s':'').' Automatically Moderated</p>';
}

if (($vbulletin->options['glowhostspamomatic_stat_show_removed'] == 1) && ($stats['removed'] > 0)) {
$template_hook[forumhome_wgo_pos2] .= '<p>'.$stats['removed'].' Spammy Post'.(($stats['removed'] > 1)?'s':'').' Removed</p>';
}

$template_hook[forumhome_wgo_pos2] .= ' </div>
</div>
';

}

]]></phpcode>
</plugin>

<!-- Stats END -->

That ought to do the trick? It just seems weird that a lot of the phrases are in the phrase manager, but not these crucial bits?

Cheers!

[sandboa]

I have been getting database error reports since I installed this mod. Here is a recent example of the error:

Database error in vBulletin 4.2.0:

Invalid SQL:
INSERT HIGH_PRIORITY IGNORE INTO VB_glowhostspamomatic_remotecache(`date`, `data`, `is_spambot`, `field`) VALUES (now(), "Lauren_22", "0", "username");;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 27th 2012 @ 03:19:02 PM
Error Date : Friday, July 27th 2012 @ 03:19:15 PM
Script : http://www.sandboakeepers.com/register.php?do=addmember
Referrer : http://www.sandboakeepers.com/register.php
IP Address : 98.170.224.173
Username : Lauren_22
Classname : vB_Database
MySQL Version :

There is a different username and IP address for each error. Other than this, the mod seems to be working correctly.

[ForceHSS]

I have been getting database error reports since I installed this mod. Here is a recent example of the error:

Database error in vBulletin 4.2.0:

Invalid SQL:
INSERT HIGH_PRIORITY IGNORE INTO VB_glowhostspamomatic_remotecache(`date`, `data`, `is_spambot`, `field`) VALUES (now(), "Lauren_22", "0", "username");;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, July 27th 2012 @ 03:19:02 PM
Error Date : Friday, July 27th 2012 @ 03:19:15 PM
Script : http://www.sandboakeepers.com/register.php?do=addmember
Referrer : http://www.sandboakeepers.com/register.php
IP Address : 98.170.224.173
Username : Lauren_22
Classname : vB_Database
MySQL Version :

There is a different username and IP address for each error. Other than this, the mod seems to be working correctly.
Server has gone away thing u need to talk to ur host about this

[yamahapaul]

I would like to change the

Spam-O-Matic

in the whats going on box to something like spam statistics but can't see how to do it in phrases can anyone point me in the right place please?

[yamahapaul]

apologies if it is in here somewhere but I just haven't the patience to go through the 125 pages on this thread to see if anyone has asked before..

[Froberg]

You should really scroll up just five inches..

[yamahapaul]

You should really scroll up just five inches..

Thanks, I did see that but didn't realise mucking about with that would do the trick :o

[Froberg]

So it worked? :D

[yamahapaul]

So it worked? :D

Yes thanks, I just wanted to change it to 'Spam statistics'


:)

[Froberg]

Great, then I can muck about with it myself. I was too worried about doing it on my live board, and setting up a test just for that seemed slightly.. excessive.

I really think this should be added to the phrase manager though, now it'll just be in Danish on my site, whereas it's always been multi-lingual previously.

[yamahapaul]

Great, then I can muck about with it myself. I was too worried about doing it on my live board, and setting up a test just for that seemed slightly.. excessive.


I thought you had done it! all I did was change the second instance of Spam-O-Matic Statistics
I did change the first but that didn't work, so then moved down to the next one (the one that worked was in single commas not double ones) and hey presto :)

[Froberg]

All is well in wonderland in the end then. ;-)

[yamahapaul]

All is well in wonderland in the end then. ;-)

So far...


:D

[tonymacx86]

Has anyone figured out a way to limit Spam-O-Matic Statistics to Moderators / Administrators only?

As a forum administrator I'm interested in these statistics and they not really relavant for my forum users to know.

[vb50kgpoo]

Hi
I installed Spam-o-Matic some time ago and I think it is mostly great (I only get a few real people complaining they were blocked from registration).

BUT I want all successful (those that pass Spam-o-Matic's criteria) registrations to come to me for moderation, as still some spammers get through (though they are easy to spot - so, I just need to approve them first). I do not want to turn Spam-o-Matic off and moderate every registration, as Spam-o-Matic does a great job of blocking 99% of spammers.

Is there a way?

[djbaxter]

I want all successful (those that pass Spam-o-Matic's criteria) registrations to come to me for moderation, as still some spammers get through (though they are easy to spot - so, I just need to approve them first). I do not want to turn Spam-o-Matic off and moderate every registration, as Spam-o-Matic does a great job of blocking 99% of spammers.

Is there a way?

Certainly - that's the way I have it set up.

AdminCP >> Settings >> Options >> Registration Options

Moderate New Members
Allows you to validate new members before they are classified as registered members and are allowed to post.

Set to Yes.

[vb50kgpoo]

Certainly - that's the way I have it set up.

AdminCP >> Settings >> Options >> Registration Options

Moderate New Members
Allows you to validate new members before they are classified as registered members and are allowed to post.

Set to Yes.

Eh, thanks, but no.
This is the way I have it set up too, but new registrations are not sent for moderation. I posted about this on the forums, and ended up raising a ticket on vb.com support. They said GlowHost was the problem; they confirmed I had my vb admincp settings correct for moderating new registrations, but that GlowHost Spam-o-Matic was preventing this from happening.

[yamahapaul]

Hi
BUT I want all successful (those that pass Spam-o-Matic's criteria) registrations to come to me for moderation, as still some spammers get through (though they are easy to spot - so, I just need to approve them first). I do not want to turn Spam-o-Matic off and moderate every registration, as Spam-o-Matic does a great job of blocking 99% of spammers.


Certainly - that's the way I have it set up.

AdminCP >> Settings >> Options >> Registration Options

Moderate New Members
Allows you to validate new members before they are classified as registered members and are allowed to post.

Set to Yes.

Eh, thanks, but no.
This is the way I have it set up too, but new registrations are not sent for moderation. I posted about this on the forums, and ended up raising a ticket on vb.com support. They said GlowHost was the problem; they confirmed I had my vb admincp settings correct for moderating new registrations, but that GlowHost Spam-o-Matic was preventing this from happening.

The way I see it at the moment you have two possible options

1 set up spam-o-matic to moderate the first post/ posts of new users using keywords (the downside is you will still have to approve some posts or get a moderator to)

2 use it in conjunction with this mod-

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

then if new users do make any spam posts they can be dealt with in one click

[djbaxter]

Eh, thanks, but no.
This is the way I have it set up too, but new registrations are not sent for moderation. I posted about this on the forums, and ended up raising a ticket on vb.com support. They said GlowHost was the problem; they confirmed I had my vb admincp settings correct for moderating new registrations, but that GlowHost Spam-o-Matic was preventing this from happening.

Well it works for me. But I only have GlowHost blocking registrations - I don't use it for moderating posts because I found that feature to be unreliable. That's probably why it isn't working for you.

[vb50kgpoo]

Well it works for me. But I only have GlowHost blocking registrations - I don't use it for moderating posts because I found that feature to be unreliable. That's probably why it isn't working for you.

I am not using it to moderate posts.

[vb50kgpoo]

The way I see it at the moment you have two possible options

1 set up spam-o-matic to moderate the first post/ posts of new users using keywords (the downside is you will still have to approve some posts or get a moderator to)

2 use it in conjunction with this mod-

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

then if new users do make any spam posts they can be dealt with in one click

Thanks, but that is not what I want. And adding yet another spam killer I do not think is going to alleviate a moderation issue on spam-o-matic.

[djbaxter]

What are your GlowHost settings? As I said, it's working perfectly for me.

[vb50kgpoo]

What are your GlowHost settings? As I said, it's working perfectly for me.

There are a lot of settings, which ones specifically?

If you read the intro, it appears as this is default (that there is no moderation queue ability);
"If a spammer is able to sneak past the first line of defense, and manages to post, then there are secondary, tertiary, and, uh...4th level protections too!"

So it seems GlowHost assumes that anyone that passes their filters, is ready to post.

[Syxguns]

So it seems GlowHost assumes that anyone that passes their filters, is ready to post.

It sounds to me like you did not follow instructions completely. I know that there are several steps to take and a lot of settings, but you can create a new usergroup with limited permissions, and set how many posts that you want to be moderated by SOM. There are a few things that the utility doesn't do, but for the most part I find it to be a great defense against spam.

[vb50kgpoo]

It sounds to me like you did not follow instructions completely. I know that there are several steps to take and a lot of settings, but you can create a new usergroup with limited permissions, and set how many posts that you want to be moderated by SOM. There are a few things that the utility doesn't do, but for the most part I find it to be a great defense against spam.

Again, thank you, but you as others miss what I want.
I do not want to have post moderation. I want registration moderation.

[fly]

Again, thank you, but you as others miss what I want.
I do not want to have post moderation. I want registration moderation.

If they can't post, what's the difference?

[djbaxter]

Can you post a screen shot of your settings? Also one of the names of any other add-ons you have installed?

[Syxguns]

Again, thank you, but you as others miss what I want.
I do not want to have post moderation. I want registration moderation.

I don't understand what you are trying to say. SOM does prevent known spam from registering. You do not have to moderate the first post if you do not want to primarily because it doesn't work perfectly, but it does work. Every post is moderated and has to be approved before it is posted. The problem is that you and the mods have to pay attention to all new registrations. That is an easy fix, just have new registrations sent to the mods, and yourself if you wish.

For some reason you have to pay attention to the threads in question because moderated threads do not show up in the way they should. Having a new post mod resolves this issue, unless they register and never post! I only moderate the 1st post because of a couple of problems with SOM.

1) you do not have the option to submit new spam IP's and e-mails to stopforumspam. In order to do this you have to manually go to SFS and enter the information.

2) Do not check user names! This is a big drawback, but if you check user names you will have a lot of people blocked for the site even though they are not spammers.

3) Many people have issues with the database, and there are so many times that it's mentioned how to fix it in the thread, but with over 120 pages of posts it is difficult to find. They end up not using it because they do not know how to fix the error.

4) If you just want to cover registration, there are many other options to use. I use a mod created by BOP5 that is great. Here is the link: No Spam Image Enhancement Link (https://vborg.vbsupport.ru/showthread.php?t=265845)

That mod stops bot registration pretty well because you can use multiple images that you find and set up.

As djbaxter mentioned a screen shot of your settings may help us out with your current situation.

[ForceHSS]

Again, thank you, but you as others miss what I want.
I do not want to have post moderation. I want registration moderation.

If you don't want post mod then turn it off I had it turned off when I had forums just go to the settings and disable the option

[vb50kgpoo]

If they can't post, what's the difference?

I love people that say "Do it my way". The reason is because some registrations stand out as being spam, and I want to stop them from posting anything. Some spammers are clever and will post a few "real" messages and then insert some spam signature. Please do not tell me to get this add-on and that add-on. I simply want all registrations to be sent to me for approval AFTER spam-o-matic has blocked the obvious ones.

[vb50kgpoo]

I don't understand what you are trying to say. SOM does prevent known spam from registering. You do not have to moderate the first post if you do not want to primarily because it doesn't work perfectly, but it does work. Every post is moderated and has to be approved before it is posted. The problem is that you and the mods have to pay attention to all new registrations. That is an easy fix, just have new registrations sent to the mods, and yourself if you wish.

For some reason you have to pay attention to the threads in question because moderated threads do not show up in the way they should. Having a new post mod resolves this issue, unless they register and never post! I only moderate the 1st post because of a couple of problems with SOM.

1) you do not have the option to submit new spam IP's and e-mails to stopforumspam. In order to do this you have to manually go to SFS and enter the information.

2) Do not check user names! This is a big drawback, but if you check user names you will have a lot of people blocked for the site even though they are not spammers.

3) Many people have issues with the database, and there are so many times that it's mentioned how to fix it in the thread, but with over 120 pages of posts it is difficult to find. They end up not using it because they do not know how to fix the error.

4) If you just want to cover registration, there are many other options to use. I use a mod created by BOP5 that is great. Here is the link: No Spam Image Enhancement Link (https://vborg.vbsupport.ru/showthread.php?t=265845)

That mod stops bot registration pretty well because you can use multiple images that you find and set up.

As djbaxter mentioned a screen shot of your settings may help us out with your current situation.

Again, thanks, but you are missing the point.
I do not want this.
What I want is for new registrations that clear Spam-o-Matic to come to me for final approval.

[vb50kgpoo]

If you don't want post mod then turn it off I had it turned off when I had forums just go to the settings and disable the option

Great, superb. How does that give me what I want? I never posted about wanting or not post mod. You and others have suggested it. I have kept saying I do not want it, and then you tell me to turn something off I never had turned on in the first place!

[vb50kgpoo]

Can you post a screen shot of your settings? Also one of the names of any other add-ons you have installed?

Thanks, but I think this is a bit too much for me to put up on this forum. I will ask the developer. But, truly, thanks for trying.

[djbaxter]

a couple of problems with SOM.

1) you do not have the option to submit new spam IP's and e-mails to stopforumspam. In order to do this you have to manually go to SFS and enter the information.

You can add the option to submit a spammer to the database by creating a small plugin to add the feature to the user profile in your AdminCP:

See https://vborg.vbsupport.ru/showpost.php?p=2344079&postcount=1821 and https://vborg.vbsupport.ru/showpost.php?p=2344884&postcount=1826 in this thread.

[ForceHSS]

Great, superb. How does that give me what I want? I never posted about wanting or not post mod. You and others have suggested it. I have kept saying I do not want it, and then you tell me to turn something off I never had turned on in the first place!

Have you even took the time to look at the settings and not just the settings of this mod

[fly]

I love people that say "Do it my way". The reason is because some registrations stand out as being spam, and I want to stop them from posting anything. Some spammers are clever and will post a few "real" messages and then insert some spam signature. Please do not tell me to get this add-on and that add-on. I simply want all registrations to be sent to me for approval AFTER spam-o-matic has blocked the obvious ones.

Your smarmy comments are sure to inspire all of us to come to your aid...

That said, at no point did I mention any additional addons.

[Syxguns]

Antique Swords,
Turn off the moderation option in SOM.
Go to User Registration Options and find a line that says, "Email Address to Notify About New Members" and place your e-mail in there.

[vb50kgpoo]

Your smarmy comments are sure to inspire all of us to come to your aid...

That said, at no point did I mention any additional addons.

You did not come to my aid. You made a curt response. And you inspired me to respond as I did.

[vb50kgpoo]

Antique Swords,
Turn off the moderation option in SOM.
Go to User Registration Options and find a line that says, "Email Address to Notify About New Members" and place your e-mail in there.

Hi
Thanks. But isn't this only turning off post moderation functions? I have looked and it seems so. I presume you mean Auto-Moderation: Enable? If so, all of the things it turns off are to do with posting, not registration.

I also emailed the developer, and it appears (I think, from what he said), that it is not possible to do what I want. So I guess I must moderate the posts of Newbies, which is not what I want to do.

But thanks to those that tried to help.

[vb50kgpoo]

Have you even took the time to look at the settings and not just the settings of this mod

Yes, thank you. I have been through this on the forums on vb.org and filed a help ticket with vb.com. So I have done everything. It simply is not possible to have Spam-o-Matic moderate registrations to remove the known spam and then have the remainder come to me for final approval.

Because I have set up various mandatory questions (spammers always answer off topic or badly), country flags (spammers tend to select no fag / the default flag), etc., I easily see the spammers that get past Spam-o-Matic. I MUCH prefer this.

[fly]

Yes, thank you. I have been through this on the forums on vb.org and filed a help ticket with vb.com. So I have done everything. It simply is not possible to have Spam-o-Matic moderate registrations to remove the known spam and then have the remainder come to me for final approval.

Because I have set up various mandatory questions (spammers always answer off topic or badly), country flags (spammers tend to select no fag / the default flag), etc., I easily see the spammers that get past Spam-o-Matic. I MUCH prefer this.

Good. Then it's settled. SOM won't do what you want. Let's all move past this now.

[Alibass]

Antique Swords,
Turn off the moderation option in SOM.
Go to User Registration Options and find a line that says, "Email Address to Notify About New Members" and place your e-mail in there.
@Antique-Swords

I agree with Syxguns, BUT you also need to tick 'yes' to Moderate New Members and tick 'no' to Verify Email address in User Registration Options.

You will receive an email for new registrations and you can validate the new registration from the ACP and send a manual approval or denial letter to new registered member awaiting approval.
Also go into usergroups/Users Awaiting Moderation and setup the group to allow user his/her permissions until approved by you.

I've used this setup before with SOM and it works fine. SOM would have to be recoded in order to do what you want it to do, so this is the best work around fix for what you are wanting to do.

Good luck...

[vb50kgpoo]

Good. Then it's settled. SOM won't do what you want. Let's all move past this now.

Thanks for all your "help"

[fly]

Thanks for all your "help"

I'm always glad to help. Have a great week!

[Froberg]

Can you not just place approved members to the "awaiting moderation" group instead?

[salar007]

I get this error when I try to install :

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

Using VB 4.2 MySQL Version : 5.5.24-cll

Any suggestions ?

[ForceHSS]

I get this error when I try to install :

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

Using VB 4.2 MySQL Version : 5.5.24-cll

Any suggestions ?

Change all occurence of

TYPE=MyISAM

to

ENGINE=MyISAM

in the XML and that will solve the DB Errors.

[pbforum]

Database error in vBulletin 4.2.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `glowhostspamomatic_remotecache`(
`date` DATETIME NOT NULL,
`field` VARCHAR(20) NOT NULL,
`is_spambot` INT NOT NULL,
`data` VARCHAR(255) 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 6
Error Number : 1064
Request Date : Wednesday, August 8th 2012 @ 03:02:34 PM
Error Date : Wednesday, August 8th 2012 @ 03:02:34 PM

IP Address : 94.59.232.82
Username : pendu
Classname : vB_Database
MySQL Version : 5.5.24-cll

i have same problem ,, i change this code to xml file

but same problem

[ForceHSS]

You have missed some

[pbforum]

missed from where .. that xml file .

[pbforum]

can u tell me how to get stopforumspam key ..

[ForceHSS]

U will find a link in the settings near where u input the key

[Syxguns]

missed from where .. that xml file .

Another member said that you can change the "TYPE=MyISAM", to "ENGINE=MyISAM" but I just removed the items. It shows up 3 times. If you want to see the link where I first made the correction it is located here: https://vborg.vbsupport.ru/showpost.php?p=2312347&postcount=1639

It's really clear as I have highlighted in RED the 3 places to make changes.

[ForceHSS]

Would rather not remove better to just change them. Don't understand why some are having this problem in the first place

[Syxguns]

Would rather not remove better to just change them. Don't understand why some are having this problem in the first place

When I first had the problem I did a little research to find that the newer versions of MySQL had tighter security and did not support some of the older commands.


MyISAM is the default storage engine. It is based on the older (and no longer available) ISAM storage engine but has many useful extensions.

To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option.

Normally, it is unnecessary to use ENGINE to specify the MyISAM storage engine. MyISAM is the default engine

By reading this information again, I guess I could have changed it to ENGINE instead of TYPE, but I didn't. The mod works so that is all I need! The problem is many people do not understand how to track down the errors they receive in the database. But regardless of that we still have some people that just don't bother to read! There are a lot of little steps in setting this mod up and people just want to install and it run 100% without even looking in the AdminCP!

[ForceHSS]

Some of the info you posted I already knew. I have never had a problem as I have always installed the right version needed and I know some forum admins are just to lazy to try and find there own fixes I am sure you see many posts of members asking for help (not just on these forums) but are to lazy to search for the answer. One of the reasons I don't answer a post right away gives them time to search. Another reason why I said what I did above as it makes others want to ask questions and search either here or google :)

[Chadi]

Is there a way to approve an initially rejected registration marked as spam? I do not see any such options.

All I see is this for the particular account in question:

2012-08-12 05:09:45 72.53.xxx.xxx wendydavis423 xxxxxx@aol.com Spam-O-Matic Tagged ip - 72.53.xxx.xxx - Spammer Found and rejected.

[ForceHSS]

Is there a way to approve an initially rejected registration marked as spam? I do not see any such options.

All I see is this for the particular account in question:

2012-08-12 05:09:45 72.53.xxx.xxx wendydavis423 xxxxxx@aol.com Spam-O-Matic Tagged ip - 72.53.xxx.xxx - Spammer Found and rejected.


UPDATE `glowhostspamomatic_remotecache` SET `is_spambot`='0' WHERE (`field`='ip') AND (`is_spambot`='1') AND (`data`='72.53.xxx.xxx') LIMIT 1

run this query just update the ip first

[ForceHSS]

Could be two things
1. You have vb3.8 and are using a plugin for vb4.x.x
2. Revert header template as you could have some php messed up in it
Or 3. Both 1 and 2

[Elenna]

Q. Does this mod work in vBulletin 3.x?
A. probably not. It might but its not recommended as we have not tested it and it was not built for vB3. There is an older version that works on vB3 here. https://vborg.vbsupport.ru/showthread.php?t=248470

Marka,

You might want to try downloading and installing the one linked above. If this one was written for vB 4.x, there are likely code references which are not valid for vB 3.x boards. If you install it "on top of itself" (i.e. don't uninstall previous version, but upload files and import XML in "overwrite" mode), hopefully it will keep your settings and stats.

[ForceHSS]

I realize that I am using a plugin for vb4.x. Indications in the beginning of this thread show that it works, however.

Regarding #2, are you saying to revert to the default header template for vB?

Thank you for your assistance. For the record, I am not all that versed with vB, and for the past years have had assistance running the forums. The person who ran my forums has gone on to greener pastures, so I am left to a crash course.
as to your header as you never pointed out it was default vb skin then the problem is because you are using a plugin for vb4 that will not work for vb3 as alot has changed in the php

[ForceHSS]

you can delete the post yourself

[djbaxter]

Or we could just hang him in the public town square and stone him. I'd vote for that option just for the entertainment. Seriously, television is total crap these days.

[MaXimus]

I am trying to install it on vBulletin 4.2 but I get this error, what gives?

https://vborg.vbsupport.ru/ (http://imageshack.us/photo/my-images/502/capturelwb.png/)

[snowlion]

berryracer read this post: #1912 (https://vborg.vbsupport.ru/showpost.php?p=2355559&postcount=1912)

[angeljs]

I can't thank you enough for this mod, and can't believe I've never used it before! For some reason, for the past few days, I've had an influx of spammers joining, even though I have captcha, security questions and all the rest of it. It was beginning to take up so much of my time.

However, since I've installed this awesome mod just a few hours ago, it's already stopped 12 spammers from joining!

Once again, thank you! :)

[mathforum]

I can't thank you enough for this mod, and can't believe I've never used it before! For some reason, for the past few days, I've had an influx of spammers joining, even though I have captcha, security questions and all the rest of it. It was beginning to take up so much of my time.

However, since I've installed this awesome mod just a few hours ago, it's already stopped 12 spammers from joining!

Once again, thank you! :)

My site just went from PR2 to PR3 but still the flood of spammers this weekend has been so strange. I keep checking the logs because I feel like legit new registrations are being banned. Every time though it checks out and is a spammer. I'm just using email as a criteria as well. Something like 80-85 this one weekend.

[dilbert]

Thank you so much for this mod. I installed it a while ago and wasn't automatically blocking new registrations because I only got 1 or 2 bad ones a day, starting last week I have been getting about 20 - 30 bad ones a day. I turned on blocking registrations that were in the StopForumSpam database and it has made my life so much easier.

Thank you, thank you, thank you!

[qiman]

Seems to be working ok. Just installed it on 2 forums.

Is there a solution to the blog spammers?

[maozaorox]

Nevermind, my bad.

[kiki0]

I'm having an issue with VBulletin 4.2 PL2 -

When this mod is installed it throws an http 500 error when a user tries to post a reply.

No matter what I turn off within the configuration, it continues to happen.

Any ideas?

[shaun2222]

I am trying to install it on vBulletin 4.2 but I get this error, what gives?

http://img502.imageshack.us/img502/8879/capturelwb.png (http://imageshack.us/photo/my-images/502/capturelwb.png/)

Figured out the problem, you need to edit the product-glowhostspamomatic.xml file and change all the lines that say TYPE=MyISAM to ENGINE=MyISAM

[dougdirac]

I like to have the Spam-O-Matic option when selecting threads, not just when selecting posts.

[Rik Brown]

Thank you to Glowhost.com for this amazing mod! Love it.

With 130 pages in this thread, it was hard to search for info. This has probably already been requested, but just in case....

I would like the mod to write to the user profile Banning area viewable in the admincp where it shows the "Ban Reason" so I will know that it was banned by SOM after the user has spammed. As of now, the reason is blank. Perhaps a definable message such as "User posted url/spam" etc. would work.

Anyway, no need for a reply (unless I missed such a capability).

Thanks again. -- Rik

[KProjects]

This is a great addon .. good work!

[ForceHSS]

Thank you to Glowhost.com for this amazing mod! Love it.

With 130 pages in this thread, it was hard to search for info. This has probably already been requested, but just in case....

I would like the mod to write to the user profile Banning area viewable in the admincp where it shows the "Ban Reason" so I will know that it was banned by SOM after the user has spammed. As of now, the reason is blank. Perhaps a definable message such as "User posted url/spam" etc. would work.

Anyway, no need for a reply (unless I missed such a capability).

Thanks again. -- Rik

Option not there from what I remember. It would need coded

[Glockie]

Hi guys,

Looking for a little advice here,
A few genuine users have been blocked recently, and the only way I can allow them to register is by disabling the product and then asking the new user to re-register..

The problem is, I can't seem to find the logs OR see the options to allow the new user or deny them access.

Is there an area that I've missed that will show the denied users and where I can allow or deny them registration?

It's bound to be there somewhere, but I just don't know where to look for the logs and to allow users etc..

If it's not in there, or there are no options for this, then that's a major flaw...

Been using this product for a while now and it's superb gotta say! Thanks for this...

I hope someone can point me in the right direction here.
Many thanks

[fly]

You have turned off the username blocking, correct?

[rjerina]

Hi guys,

Looking for a little advice here,
A few genuine users have been blocked recently, and the only way I can allow them to register is by disabling the product and then asking the new user to re-register..

The problem is, I can't seem to find the logs OR see the options to allow the new user or deny them access.

Is there an area that I've missed that will show the denied users and where I can allow or deny them registration?

It's bound to be there somewhere, but I just don't know where to look for the logs and to allow users etc..

If it's not in there, or there are no options for this, then that's a major flaw...

Been using this product for a while now and it's superb gotta say! Thanks for this...

I hope someone can point me in the right direction here.
Many thanks

Statistics & Logs>GlowHost - Spam-O-Matic Logs should show you the blocks and allows. Not sure about allowing specific users though that have been blocked.

[ForceHSS]

Hi guys,

Looking for a little advice here,
A few genuine users have been blocked recently, and the only way I can allow them to register is by disabling the product and then asking the new user to re-register..

The problem is, I can't seem to find the logs OR see the options to allow the new user or deny them access.

Is there an area that I've missed that will show the denied users and where I can allow or deny them registration?

It's bound to be there somewhere, but I just don't know where to look for the logs and to allow users etc..

If it's not in there, or there are no options for this, then that's a major flaw...

Been using this product for a while now and it's superb gotta say! Thanks for this...

I hope someone can point me in the right direction here.
Many thanks

As fly said above you should of had username from being blocked but as it has just blocked them people it is now stored in the db as being blocked. Now if it says in the logs it blocked them because of there user name first check the spam o matic db to make sure 100% it is not them by checking there ip and email if they are not in the spam db then you will need to run a query to remove them as a bot. PM me that name I can write u that

[Glockie]

Thanks for your feedback all!

Yes, he shows in the logs but I have no option to allow/deny etc..

He's in now as I shut the software down and then asked him to re-register.
As this has happened once or twice, I realised that there must be something I am failing to do or sort here..
I was hoping there would be an option to allow on username specific criteria.

The message is "Spam-O-Matic Tagged username - **** - Spammer Found and rejected."
So naturally I was hoping there would be a way to 'allow' him through.

Is it best to switch off username checks then?

Many thanks

Glock.

[rhody401]

Yes it is best to turn USERNAME checking off, as many people share common names. It will catch innocent people if you have this on. Checking the email and IP should still be left on, however.

Most of the problems reported here are because people have left username checking on. Perhaps that one should be off by default, for new installs/future release :)

Rhody

[Glockie]

Ok will do.

I installed it quite some time ago and go through things regularly, but in all honesty?
1: I didn't know it would cause a problem like this
and
2: it's only recently triggered by blocking someone I know of, I've since checked and although a few more HAVE been blocked they successfully registered with slightly altered names etc...

Will knock it off now.

Thanks for the help!

[Lee Roberts]

Just installed and went a ok for me on 4.2 PL2.

[ForceHSS]

Ok will do.

I installed it quite some time ago and go through things regularly, but in all honesty?
1: I didn't know it would cause a problem like this
and
2: it's only recently triggered by blocking someone I know of, I've since checked and although a few more HAVE been blocked they successfully registered with slightly altered names etc...

Will knock it off now.

Thanks for the help!

If you run that query I sent u in a pm that will allow him to register with that name

[flussmitteldj]

I need a german translation for this product :(

or can someone tell me the most necessary settings?

[ForceHSS]

Translate all files and XML before you upload the files

[Killabee]

Im having the same issue. . . vBulletin? Version 4.2.0 PL2

Cant Reply or quick reply to anything. when posting with quick reply i get a pop up saying
https://vborg.vbsupport.ru/external/2012/08/1.jpg

I also attempted to edit the xml file with the ENGINE=MyISAM as posted above with no luck.

[Syxguns]

Im having the same issue. . . vBulletin? Version 4.2.0 PL2


I also attempted to edit the xml file with the ENGINE=MyISAM as posted above with no luck.

I do not think this has anything to do with S-O-M. Go to AdminCP >> Plugins & Products > Manage Products

Temporarily disable S-O-M and see if you are still having the issue. It is hard to say, but you may have a different issue to deal with. In fact disable all mods temporarily and see if the issue is still there. If it is not then turn the mods on one at a time while you refresh the page and try again.

[Killabee]

ive already disabled S-O-M which fixes my problem. Boards are pretty much brand new and i only have 3 products installed.

[rhody401]

This is the best add-on, period. No forum should be running without it, IMO.

GREAT job! I hope it is updated, when 5.x comes along.

[Syxguns]

ive already disabled S-O-M which fixes my problem. Boards are pretty much brand new and i only have 3 products installed.

It still may be something different. I'm thinking in the board setup. According to the screenshot it looks like the board is not directing properly. I may need a little closer inspection of the forum. Could you PM me a temp user name password and link to your board.

Also is this only happening in the quick reply editor?

I also noticed that you are using IE, have you tried other browsers? IE has a lot of issues, but there is a setting in the AdminCP to make an adjustment. I just can't remember where exactly, I'm on my phone.

[sub_ubi]

Im having the same issue. . . vBulletin? Version 4.2.0 PL2

Cant Reply or quick reply to anything. when posting with quick reply i get a pop up saying
https://vborg.vbsupport.ru/external/2012/08/1.jpg

I also attempted to edit the xml file with the ENGINE=MyISAM as posted above with no luck.

That's a problem with vBulletin, not this addon.

Find this in the headinclude template:

forum : "{vb:raw vboptions.vbforum_url}",

Change it to

forum : "<vb:if condition="$vboptions[vbforum_url]">{vb:raw vboptions.vbforum_url}<vb:else />{vb:raw vboptions.bburl}</vb:if>",

[fly]

That's a problem with vBulletin, not this addon.

Find this in the headinclude template:

forum : "{vb:raw vboptions.vbforum_url}",

Change it to

forum : "<vb:if condition="$vboptions[vbforum_url]">{vb:raw vboptions.vbforum_url}<vb:else />{vb:raw vboptions.bburl}</vb:if>",

Wouldn't it be easier to just set vbforum_url? Am I missing something obvious?

[Killabee]

That's a problem with vBulletin, not this addon.

Find this in the headinclude template:

forum : "{vb:raw vboptions.vbforum_url}",

Change it to

forum : "<vb:if condition="$vboptions[vbforum_url]">{vb:raw vboptions.vbforum_url}<vb:else />{vb:raw vboptions.bburl}</vb:if>",


this did not work.

[sub_ubi]

this did not work.

More solutions here,

https://www.vbulletin.com/forum/showthread.php/382656-Quick-Reply-Asks-whether-user-wants-to-leave-or-stay-on-every-quick-reply-made

[mikeinjersey]

can't believe this plugin hasn't been updated for 18 months, yet it still seems to be working generally ok ..

wondering if there's anything that could be done about recent spam posts that seem to be in other languages (besides English) ? Some of them have weird lookin characters as well, not even sure if it's a language or not.

but we should be able to prevent those somehow... no ?

[Syxguns]

can't believe this plugin hasn't been updated for 18 months, yet it still seems to be working generally ok ..

wondering if there's anything that could be done about recent spam posts that seem to be in other languages (besides English) ? Some of them have weird lookin characters as well, not even sure if it's a language or not.

but we should be able to prevent those somehow... no ?

Yes for the most part you are going to have to set up a new user group for new members, limiting permissions and setting up auto moderation in S-O-M. The are instructions on the creators site. Very few get through the block, but selecting the post and using the mod tools you can ban, remove all posts, and submit info to stopformspam at the same time.

[Killabee]

I have nothing negative to say about this mod. I admit its probably my skin causing some sort of issues I used this mod in the past and it worked fairly well. as of now i went to Keycaptcha and its working very well.

[Syxguns]

I have nothing negative to say about this mod. I admit its probably my skin causing some sort of issues I used this mod in the past and it worked fairly well. as of now i went to Keycaptcha and its working very well.

To each his own however I hate key captcha. My registration is simple using a picture mod by BOP5. This mod blocks 99% of spam. However you do have to set it up correctly, as has been explained in this thread many times. Most with problems using this mod do not take the time to set it up correctly. It does take a little time to set up and test!

[brycea]

<a href="http://healthcommunity.co/forum.php" target="_blank">HealthCommunity.co</a>

Earlier today, I saw on my forum that 208 people were online with my IP address. What kind of problem is this and what can I do about it.

I use SPAM-O-MATIC and have a subscriptiion to Akismet, and whatever was going on didn't effect my forum with spam.

On 8/29/12, I had 1,172 people online, of which I know was impossible, being that we are a new forum, although, no problems with spam then.

According to your product, there have been 4 spammers denied registration.

Thanks, Bryce

[mikeinjersey]

Yes for the most part you are going to have to set up a new user group for new members, limiting permissions and setting up auto moderation in S-O-M. The are instructions on the creators site. Very few get through the block, but selecting the post and using the mod tools you can ban, remove all posts, and submit info to stopformspam at the same time.

I already have that usergroup for new members.

Still would be great if they could update the plugin, to give us an option to block all posts from other languages. These are practically the only posts that still make it through the filter on our forums.

example : Block all posts not in "English". (drop-down menu to select appropriate language)

not sure how difficult it would be to setup on the developer end though..

[Syxguns]

HealthCommunity.co (http://healthcommunity.co/forum.php)

Earlier today, I saw on my forum that 208 people were online with my IP address. What kind of problem is this and what can I do about it.

I use SPAM-O-MATIC and have a subscriptiion to Akismet, and whatever was going on didn't effect my forum with spam.

On 8/29/12, I had 1,172 people online, of which I know was impossible, being that we are a new forum, although, no problems with spam then.

According to your product, there have been 4 spammers denied registration.

Thanks, Bryce

Bruce, just for grins disable S-O-M to see if you still have the same problem. I don't think that this mod is the problem, but the only way to know for sure is to test it.

Being a new forum I see that many visitors as almost crazy but if you are using forum runner then it is possible. I did a quick Google search but your forum wasn't on the first page. As far as multiple users having the same IP that I see quite a bit, so how many are you talking about?

[Syxguns]

I already have that usergroup for new members.

Still would be great if they could update the plugin, to give us an option to block all posts from other languages. These are practically the only posts that still make it through the filter on our forums.

example : Block all posts not in "English". (drop-down menu to select appropriate language)

not sure how difficult it would be to setup on the developer end though..

I'm sure that if you had a mod check for language it would take time for each post to be scanned before it was submitted to the forum, this would really slow things down. That does not include things like "CUL8r"!

The important thing is to submit these spam messages when they happen. This mod is great for doing that for you. I even get a few from time to time, but not enough for me to break a sweat. The other option that you have is to ban the e-mail and IP in vB. That may help because I believe what you are seeing is Russian.

[brycea]

You wrote, "As far as multiple users having the same IP that I see quite a bit, so how many are you talking about?"

I don't know how to answer this question. I read at the bottom of my forum that there were 208 users online, I clicked on the highlighted in red, 208 users online, and was directed to the page that reflects the IP address for each user. All were my IP address.

Also, I could see that each forum had a number of people reading posts.

You say to turn off s-o-m, to see what happens, what would I then do to protect myself from spammers on my site at that time.

[Syxguns]

You wrote, "As far as multiple users having the same IP that I see quite a bit, so how many are you talking about?"

I don't know how to answer this question. I read at the bottom of my forum that there were 208 users online, I clicked on the highlighted in red, 208 users online, and was directed to the page that reflects the IP address for each user. All were my IP address.

Also, I could see that each forum had a number of people reading posts.
What
You say to turn off s-o-m, to see what happens, what would I then do to protect myself from spammers on my site at that time.

In plugging and products disable. You are only testing, so you can enable it again. Now select "who's online" and see if they all show the same IP. They shouldn't all be the same, although you may see a few with the same.

What mod did you use to view last time? I'm on a cell phone so I can't view the actual forum. I turned that feature off. I also do not use taptalk or forum runner. Mods do not work with them.

Edit: got online and saw the forum. I see what you are saying you clicked that was in red. That should take you to the "who's online" area. Right now you have nobody viewing the forum, so wait until you have 5 to 20 people viewing the site.

[brycea]

I see now what you are talking about. I will disable the s-o-m and see what happens.

[cloferba]

how can I disable the Spam-O-Matic Statistics box above the "Current Total Users Online"?

[ndut]

tagged, thanks

[cloferba]

got it.

[vivachina]

Hello

Automoderation is set to some usergroup when users are moved afte email check. Automoderations is set to prevent post and we have a lont list of bad words.

However anybody can bypass the automoderations by writing any words.

This plugin was working fine until suddenyl stopped one week ago just after set some new parameters.

But it's strange that blocking spammers registration is working smoothly.

[katco224]

Mine seems to have suddenly quit working, I had a huge amount of spammers get by last night including plastering my board with spam posts. Has something changed recently?

[inigo]

Mine seems to have suddenly quit working, I had a huge amount of spammers get by last night including plastering my board with spam posts. Has something changed recently?
Same here, yesterday a lot of spammers grant access to register in my forum. SOM log showed: "Unabe to connect to SOM server,... " in each registration. "Passed to vbulletin,..."

Any problem with the server? Anything we have to change?

Thanks!

[Syxguns]

Same here, yesterday a lot of spammers grant access to register in my forum. SOM log showed: "Unabe to connect to SOM server,... " in each registration. "Passed to vbulletin,..."

Any problem with the server? Anything we have to change?

Thanks!

I believe this is not an issue. If I'm correct in my assumption, this has to do it the StopForumSpam database is down for maintenance.

StopForumSpam: Query Connection Errors
What should happen if the remote connection times out when querying the new registration?

* Note: Only applies if set to block listed registrations in the above setting

If this is set to Allow Registration then you could get some spammers. I wouldn't suggest that you deny the registration, simply because it should be temporary.


10:40 a.m. yesterday
I went to the board first thing this morning and thought WTF, it had been unusually inundated with spammer?s registrations and spam posts, in which took me quite awhile to clear them off from the board. I then went to here to add the ones that spammed to my spammers list and found the site was offline, due to maintenance. Oh, I thought, so that is the reason for the unusual inundation of spammers. - When the cats away the mice will play. smile

REPLY

The forum that I help moderate, also got slammed last night. I also found that SFS was down. I certainly am glad it is back up.

Some of our spammers are finding ways around the Spam-O-Matic software that our Admin installed last week, by coming up with usernames, edresses, and IP addresses that are not in SFS's databanks. I am duly entering them.... cool

Information found in forum at SFS forum (http://www.stopforumspam.com/forum/viewtopic.php?id=4633)


I don?t know what I would do without SFS. Thanks.

[dougdirac]

In the settings, there's an option about what to do when the StopForumSpam server is unavailable. I think the default is to allow registration since usually there is another layer of protection by new users being placed in a moderated group, and you don't risk blocking legit users. You can change that if you wish.


StopForumSpam: Query Connection Errors
What should happen if the remote connection times out when querying the new registration?

* Note: Only applies if set to block listed registrations in the above setting

[dougdirac]

D'oh.. beat me too it.

[naomi.rosenberg]

Hi,

In the course of de-spamming, when you get to /inlinemod.php, it says "Spam-o-matic has performed the following actions" and displays a bunch of links to user profiles.

These links point to /user.php, which does not exist.

Is this a know issue?

Thanks

N

[Syxguns]

Hi,

In the course of de-spamming, when you get to /inlinemod.php, it says "Spam-o-matic has performed the following actions" and displays a bunch of links to user profiles.

These links point to /user.php, which does not exist.

Is this a know issue?

Thanks

N

That list is new registrations, that have not ever made a post. New registrations have to post before they are considered moderated, even if you do not use the S-O-M or vB moderation of posts.

Many people register and read but never post. I have done that on a number of forums. I'm not a spammer, I just don't have any information to post.

[naomi.rosenberg]

The problem is that the links are broken. The names of those users are clickable links. The links point to a non-existent page called /user.php.

Is this a known issue or should I file a bug report?

Thanks.


That list is new registrations, that have not ever made a post. New registrations have to post before they are considered moderated, even if you do not use the S-O-M or vB moderation of posts.

Many people register and read but never post. I have done that on a number of forums. I'm not a spammer, I just don't have any information to post.

[Syxguns]

The problem is that the links are broken. The names of those users are clickable links. The links point to a non-existent page called /user.php.

Is this a known issue or should I file a bug report?

Thanks.

I'm not sure about that. I though the link should point to usercp.php but that doesn't seem to be correct.

I've personally never worried about that as it has to do with users that share the same IP and so forth. Maybe someone else is a little more familiar with this and could give you more detail. I don't know that submitting the issue would be something that would get fixed. There hasn't been an update on this mod in quite a while.

I just look at the list, but for the most part the information that is given may be accessed through the AdminCP if you need to do anything, but I have never messed with it. Basically the information looks like this:


Spam-O-Matic has performed the following actions:
Selected users were banned
User details were submitted to Akismet
1 thread was removed permanently
Users who have used the same IP address:
IPs used to register:
Arrigonig - Registered Users
Banotisord - Registered Users
Provop - Registered Users
Tenyri - Registered Users
ciobertga - Registered Users
tothfelty - Registered Users
anenoidonna - Registered Users
Lisyshise - Registered Users
Andvop - Registered Users
Jouggauck - Registered Users
PeciaProXX - Registered Users
_DISSERTATIONZ_ - Registered Users
Zemtreale - Registered Users
sPasqualc - Registered Users
windmetpo - Registered Users
chiphelpirl - Registered Users
sclarkalexanderd - Registered Users
JoseGuzman - Registered Users
MaxwellGalloway - Registered Users
Mutunusyswece - Registered Users
obinsirar - Registered Users
fseondenningtonm - Registered Users
tenracantec - Registered Users
cannevisound - Registered Users
unopgranap - Registered Users
Dave234 - New Member
mansonklan - Musician
Blackstone - New Member
Nighthawk - Registered Users
StephJones - New Member
sabrinaH971 - Users Awaiting Email Confirmation
prorennatrial - Users Awaiting Moderation
Inherssnant - Users Awaiting Moderation
WaiseeGiptpen - Users Awaiting Moderation
heewmedleft - Users Awaiting Email Confirmation
lsquirrelmanq - Users Awaiting Email Confirmation
AddenlyAcurce - Users Awaiting Email Confirmation
ntacibif - Users Awaiting Moderation
RRichard - Users Awaiting Moderation
gefefoela - Users Awaiting Moderation
KrevedkoMen - Users Awaiting Moderation
omivejelo - Users Awaiting Moderation
RootaJernanot - Users Awaiting Moderation
AttaftArelt - Users Awaiting Email Confirmation
chadluvv - Users Awaiting Moderation
LayevyMag - Users Awaiting Moderation
LadySovereign - Users Awaiting Moderation
PneurryinjenO - Users Awaiting Moderation
floadoanilusa - Users Awaiting Moderation
MrSmithXse - Users Awaiting Moderation
gileaxola - Users Awaiting Moderation
unernero - Users Awaiting Moderation
Fooxjize - Users Awaiting Moderation
Siglaulge - Users Awaiting Moderation
singsopesputs - Users Awaiting Moderation
cabwtobq - Users Awaiting Email Confirmation
FabiaEdric - Users Awaiting Moderation
wredgidge - Users Awaiting Moderation
Futupsems - Users Awaiting Moderation
EntsafterTest - Users Awaiting Email Confirmation
battcoaky - Users Awaiting Moderation
JosiahxSchroeder - Users Awaiting Moderation
xakep - Users Awaiting Email Confirmation
Mectexculge - Users Awaiting Moderation
capfleedema - Users Awaiting Moderation
stathebra - Users Awaiting Moderation
losimkus - Users Awaiting Email Confirmation
Owetty - Users Awaiting Moderation
narrowhead - Users Awaiting Moderation
Gaynelljenniez - Users Awaiting Moderation
aHuicaicanw - Users Awaiting Email Confirmation
JanisAvz - Users Awaiting Email Confirmation
undurnBip - Users Awaiting Moderation
jefeniniOxics - Users Awaiting Moderation
Daccusaduh - Users Awaiting Moderation
xxZUMAxx - Users Awaiting Email Confirmation
moozycoen - Users Awaiting Moderation
stecpyzbmb - Users Awaiting Email Confirmation
utedrigue - Users Awaiting Moderation

IPs used to post:
Syxguns - Administrators
Statement- - Registered Users
Singer - Registered Users
hmands - Registered Users
Nighthawk - Registered Users
Strings - Administrators
Madness! - Musician
drivecrazy - Registered Users
geekhappy - Registered Users
failtroll - Registered Users
leetoctopus - Registered Users
monkey - Registered Users
Distraction - Registered Users
The Thrill - Registered Users
Enraged - Registered Users
Be Afraid - Registered Users
psychotic_noise - Registered Users
kevin11russet - Registered Users
Azinko - Registered Users
erobbereagoli - Banned Users
Ufamu - Registered Users
Dark Mystery - Registered Users
undurnBip - Users Awaiting Moderation
Snake - Registered Users
Wallflower - Registered Users
Marsya - Registered Users
exotic - Registered Users
evergreen - Registered Users
Silver Wing - Registered Users
Golden Chair - Registered Users
mojo - Registered Users
Al Cat Raz - Registered Users
teadlyadvamma - Banned Users

The information is pretty much standard info that you should already know as an Admin of the site. This of course also depends on which modifications that you use, but I personally don't have a problem with it. Maybe someone else could help you out here.:)

[killerford]

I'm getting sick of the spammers on my forum and I've been directed here.. I'm hoping to use this and to stop the spammers on my forum. I've just downloaded the file and reading through the read me information and came across this at the bottom.

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

I don't know where or how to change or do any of those. Do I need to change one of these for this mod to work? If so could someone tell me how?

[kh99]

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

I don't know where or how to change or do any of those. Do I need to change one of these for this mod to work? If so could someone tell me how?


You can change allow_url_fopen in the php.ini file. I think cURL is a package that has to be installed. In either case, unless you do your own server admin that would be something to ask your host about.

If you're not sure if about those settings, you can go to "View PHP Info" under Maintenance in the admincp. Under the section header "core" it should show the value for allow_url_fopen. I believe if cURL is installed it will have it's own section showing the settings for that module.

Edit: yeah, I should probably have put that second paragraph first, and started out by saying that you may not have to change anything.

[rhody401]

I suggest trying it first, to see if it's broken. Most likely those are already enabled, and it'll work fine. :)

I also suggest turning off the nickname check against the stopforumspam.com database. You'll get false positives from legitimate people with this option on. (default)

[fsSnowboard]

I got the following error when trying to install v2.0.2 on a fresh upgrade of vBulletin 4.2.0 PL2.

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

Any ideas?

[Syxguns]

I got the following error when trying to install v2.0.2 on a fresh upgrade of vBulletin 4.2.0 PL2.



Any ideas?

Yes, replace TYPE=MyISAM with ENGINE=MyISAM There should be 3 instances of this in the XML file. You will need Notpad++ to view and make the changes you may download it here: Notpad++ download (http://notepad-plus-plus.org/)

[fsSnowboard]

that got it, thanks

[Syxguns]

that got it, thanks

Make sure to NOT select the check user name option. Only check e-mail and IP address.

[ishtarsgate]

I just installed my Spam-o-Matic last night, and was absolutely thrilled with it until I noticed a few spammers getting on. Took me a while to realise that happened. Stop Forum Spam is down... Drat and darn it!

One of the Glow Host options is: What should happen if the remote connection times out when querying the new registration? And it was set to Allow Registration.

I realised that the remote connection must be timing out and so I tried to get on to Stop Forum Span in another tab, and that's when I found out it was down.

I didn't think there was any point in setting it to Block Registration because that way, a lot of innocent people could get caught by it.

So I've had to stop user registrations totally for a while, while SFS get it sorted out.

I'm wondering though how often SFS gets brought it down, since so many of us are reliant on them?

[Alibass]

Occasionally but not often. Everyone has maintenance to do from time to time.

I keep my registration blocked. If they are legit users they will comeback later and register. Rather loose a few than have a ton of spammers mucking up my site.

-A

[ishtarsgate]

Hi Alibass, that's good to know that SFS are not down that often.

Yes, I think that keeping registration turned off is a much better option than having spammers all over the site.

[islaremota]

Check this post (https://vborg.vbsupport.ru/showpost.php?p=2202090&postcount=1034)

thx my friend :D

[slherzog]

they changed their api address to api.stopforumspam.org to hopefully avoid future problems like they are having today. Anybody know a quick way to update this in Spam-O-Matic?

[Chris27]

they changed their api address to api.stopforumspam.org to hopefully avoid future problems like they are having today. Anybody know a quick way to update this in Spam-O-Matic?

I would love to know as well.

[slherzog]

Well, after searching the db and plugin files, I realized that there's a file uploaded to includes/ that would surely have the stopforumspam URL and it does! :D

Open includes/functions_ghsom.php and find/replace every instance of www.stopforumspam.com with api.stopforumspam.org

Tested and works. :cool:

[Chris27]

Well, after searching the db and plugin files, I realized that there's a file uploaded to includes/ that would surely have the stopforumspam URL and it does! :D

Open includes/functions_ghsom.php and find/replace every instance of www.stopforumspam.com with api.stopforumspam.org

Tested and works. :cool:

Wonderful!