vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=248042

225 17 Apr 2012 01:14

db error

ForceHSS 17 Apr 2012 02:10

Quote:

Originally Posted by 225 (Post 2320746)
db error

let me get my mind reading cap on

HHelp1 17 Apr 2012 13:57

I cant get API key :(

Fleiding 17 Apr 2012 16:25

How do I change these sentences?

Quote:

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

ForceHSS 17 Apr 2012 16:46

Quote:

Originally Posted by HHelp1 (Post 2320868)
I cant get API key :(

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

Dwarden 17 Apr 2012 19:05

since update to 4.1.11 patch level 1 we have problem with this plugin , the moderator's option to which shall delete all users posts seems not work properly

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

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

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

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

HHelp1 17 Apr 2012 20:30

Well when i click Post and i got this happen http://screensnapr.com/e/fR3BLQ.jpg any help pleasE? Thanks!

ForceHSS 18 Apr 2012 01:11

disable all plugins and then turn each one on testing new reply to see what one is causing the error

tnedator 20 Apr 2012 18:11

Before I install this, can someone confirm it works on 4.1.12?

ForceHSS 20 Apr 2012 20:16

Quote:

Originally Posted by tnedator (Post 2321948)
Before I install this, can someone confirm it works on 4.1.12?

it does

John Lester 23 Apr 2012 00:41

Quote:

Originally Posted by tnedator (Post 2321948)
Before I install this, can someone confirm it works on 4.1.12?

Works on my 4.1.12 forums :cool:

leitel 23 Apr 2012 17:24

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

faisaly.com 23 Apr 2012 19:26

This blocks human registration badly.... using vb4.1.11 not sure why...

ForceHSS 23 Apr 2012 22:43

Quote:

Originally Posted by faisaly.com (Post 2322835)
This blocks human registration badly.... using vb4.1.11 not sure why...

that would depend what settings you have

StopForumSpam: Username Check = Disabled

HHelp1 24 Apr 2012 23:30

Got database errors

Syxguns 25 Apr 2012 00:06

Quote:

Originally Posted by HHelp1 (Post 2323207)
Got database errors

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

lazytown 27 Apr 2012 22:33

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

Crotan 28 Apr 2012 00:12

Quote:

Originally Posted by vissa (Post 2324129)
you know, it's mods that do sneaky things like this that give authors a bad name.. I disabled or minimized all the settings for 'credits' in the options.. Yet, unknown to anyone setting those visible options, when a moderator actually uses this mod, a HUGE advertisement with a graphic and coupon code and referral link is presented to them to start their own vbulletin board/forum using your hosting... Shameless....

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

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

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

fly 28 Apr 2012 00:20

You're always welcome to make your own. If you don't want to put your advertising it, let me know when you post it.

ForceHSS 28 Apr 2012 02:58

Quote:

Originally Posted by vissa (Post 2324129)
you know, it's mods that do sneaky things like this that give authors a bad name.. I disabled or minimized all the settings for 'credits' in the options.. Yet, unknown to anyone setting those visible options, when a moderator actually uses this mod, a HUGE advertisement with a graphic and coupon code and referral link is presented to them to start their own vbulletin board/forum using your hosting... Shameless....

I removed all that crap long ago

BrightStar 29 Apr 2012 16:59

Does anyone know how do I remove homepage statistics like these

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

Thanks

ForceHSS 29 Apr 2012 21:01

Quote:

Originally Posted by BrightStar (Post 2324632)
Does anyone know how do I remove homepage statistics like these

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

Thanks

check options you will find it there

lazytown 30 Apr 2012 17:52

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

ForceHSS 30 Apr 2012 18:21

Quote:

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

why dont you remove it then from the files

Alfa1 02 May 2012 02:00

Its in the XML.

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

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

weave 02 May 2012 19:20

Upgraded my test board to 4.1.12 and so far this mod seems to work 100% with no issues yet found!

Cynicz 03 May 2012 08:07

Is there any particular reason why all moderators seem to have full access to spam-o-matic's permissions?

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

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

KittyWireless 03 May 2012 16:06

Quote:

Originally Posted by Dwarden (Post 2320959)
since update to 4.1.11 patch level 1 we have problem with this plugin , the moderator's option to which shall delete all users posts seems not work properly

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

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

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

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

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

Sage Knight 04 May 2012 12:59

Well it's pretty natural for that to happen since this plugin, like the other StopforumSpam one hasn't been updated in more than a year, and well things have changed and are changing in vB.

SteveLV702 04 May 2012 18:01

Quote:

Originally Posted by KittyWireless (Post 2325831)
We are on 4.1.12 and are having the same problem, plus when we click on a thread, and go under Moderator Options, the "Spam-O-Matic" option is not longer listed.....

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

weave 04 May 2012 18:31

Quote:

Originally Posted by KittyWireless (Post 2325831)
plus when we click on a thread, and go under Moderator Options, the "Spam-O-Matic" option is not longer listed.....

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

Nope, all works like I think it should.

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

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

ForceHSS 04 May 2012 21:00

Quote:

Originally Posted by SteveLV702 (Post 2326225)
lucky you I can't even get installed when I attempt to upload/install the xml file I get a mysql error :'(

post error

Syxguns 04 May 2012 21:28

SteveLV702.
Try this, it was posted a few pages back.

Quote:

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

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



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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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


WDS 06 May 2012 13:18

Hello, I'm trying to register a friend from my pc and i get this message:

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

to that is?

ForceHSS 06 May 2012 17:51

Quote:

Originally Posted by WDS (Post 2326695)
Hello, I'm trying to register a friend from my pc and i get this message:

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

to that is?

disable username

Gripi 08 May 2012 08:40

hi..

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

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

could someone please help

thanks

The Rocketeer 09 May 2012 03:01

any better alternate to this mod? i uninstalled it but getting tons of blog spam. anyway to perhaps use both human verification question and captcha?

ForceHSS 09 May 2012 03:29

Quote:

Originally Posted by The Rocketeer (Post 2327502)
any better alternate to this mod? i uninstalled it but getting tons of blog spam. anyway to perhaps use both human verification question and captcha?

why not disable blog for normal users

Skyrider 10 May 2012 07:01

Is there anyway I can submit users through their profile if they haven't post anything?

Crotan 10 May 2012 07:03

Quote:

Originally Posted by FF|Skyrider (Post 2327896)
Is there anyway I can submit users through their profile if they haven't post anything?

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

djbaxter 10 May 2012 13:29

Quote:

Originally Posted by FF|Skyrider (Post 2327896)
Is there anyway I can submit users through their profile if they haven't post anything?

Quote:

Originally Posted by Crotan (Post 2327897)
Don't think so, the whole point of submitting a spammer, is that there is a submitted spam post/evidence with their user info.

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

CharlieDelta 10 May 2012 15:26

Quote:

Originally Posted by djbaxter (Post 2327982)
Exactly. If someone hasn't spammed, why would you submit them to a spam database? If people start doing that, the spam database becomes useless.

90% of the spammers that I get don't get the chance to post because they don't seem to get past the advanced forum rules check that I have. This is site wide and no one can post until they accepted these rules.

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

djbaxter 10 May 2012 16:01

Quote:

Originally Posted by CharlieDelta (Post 2328018)
90% of the spammers that I get don't get the chance to post because they don't seem to get past the advanced forum rules check that I have. This is site wide and no one can post until they accepted these rules.

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

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

Skyrider 11 May 2012 18:36

Quote:

Originally Posted by Crotan (Post 2327897)
Don't think so, the whole point of submitting a spammer, is that there is a submitted spam post/evidence with their user info.

Quote:

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

Quote:

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

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

Gripi 11 May 2012 19:55

hi..

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

Skyrider 11 May 2012 20:12

Quote:

Originally Posted by Gripi (Post 2328495)
hi..

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

I hope you do realize that the Spam-O-matic is meant to perm ban bots. Why would you want to Infract those AI? (Artificial Intelligence). Bots are not real humans, they are programmed to spam (usually advertisements) on other people's forums. There is no point in Infracting bot users.. They are meant to be banned and or removed entirely.

djbaxter 12 May 2012 00:33

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Plugin is active = Yes

3. Save

rolfw1 13 May 2012 11:17

1 Attachment(s)
Thanks for that, will give it a try, I have 30+ spam registrations a week, below is a typical selection. Everyone of those is a bot of some sort and whilst the majority don't post, they are still spam.

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

BadgerDog 13 May 2012 11:49

I've done some searches in this post, but so far I can't find the answer ...

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

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

Thanks for any feedback ... :)

Regards,
Doug

djbaxter 13 May 2012 16:12

Quote:

Originally Posted by rolfw1 (Post 2328941)
Thanks for that, will give it a try, I have 30+ spam registrations a week, below is a typical selection. Everyone of those is a bot of some sort and whilst the majority don't post, they are still spam.

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

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

Syxguns 14 May 2012 03:13

Quote:

Originally Posted by BadgerDog (Post 2328945)
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 14 May 2012 11:34

Quote:

Originally Posted by Syxguns (Post 2329160)
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 15 May 2012 03:01

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 15 May 2012 05:01

Quote:

Originally Posted by HondaATC (Post 2329445)
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 15 May 2012 16:05

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

ForceHSS 15 May 2012 23:18

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 17 May 2012 16:50

Quote:

Originally Posted by djbaxter (Post 2328568)
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Plugin is active = Yes

3. Save

Thanks! However:

Quote:

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 18 May 2012 05:54

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

Database error 4.1.12
by TheSupportForum
20 May 2012 09:15

Database error in vBulletin 4.1.12:

Invalid SQL:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Syxguns 20 May 2012 09:50

Quote:

Originally Posted by simonhind (Post 2330893)
Database error in vBulletin 4.1.12:

Invalid SQL:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

http://www.vbulletin.org/forum/showp...postcount=1639

Syxguns 20 May 2012 10:10

Quote:

Originally Posted by Gripi (Post 2330333)
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

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

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 20 May 2012 20:33

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


Quote:

Originally Posted by Syxguns (Post 2330897)
It was back a number of pages when I had this error. Here is a link to the thread #1639

http://www.vbulletin.org/forum/showp...postcount=1639


Chadi 24 May 2012 23:26

Tried to install on vb 4.2.0

Getting error

Quote:

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 24 May 2012 23:51

Quote:

Originally Posted by Chadi (Post 2332505)
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 25 May 2012 00:12

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

Syxguns 25 May 2012 00:38

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: http://www.vbulletin.org/forum/showp...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 25 May 2012 17:50

That link says file not found?

Syxguns 25 May 2012 18:21

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

http://www.vbulletin.org/forum/showp...postcount=1639

MattGarner 25 May 2012 19:14

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 25 May 2012 19:54

Is this 4.2 compatible?
Thanks

Syxguns 25 May 2012 22:23

Quote:

Originally Posted by dilbert (Post 2332778)
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 26 May 2012 18:41

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 26 May 2012 19:14

Quote:

Originally Posted by Americanbang (Post 2333166)
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!

Database errors after updating
by molieman
27 May 2012 17:59

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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

Syxguns 27 May 2012 20:39

molieman, a couple of things I noticed:

Quote:

) 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:

Quote:

Originally Posted by GlowHost
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

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.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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 27 May 2012 21:20

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.

Quote:

Originally Posted by GlowHost
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 29 May 2012 20:28

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 31 May 2012 05:27

Quote:

Originally Posted by Americanbang (Post 2333166)
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 - http://www.vbulletin.org/forum/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 01 Jun 2012 01:00

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 01 Jun 2012 08:36

Quote:

Originally Posted by rrewerts (Post 2335238)
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 01 Jun 2012 15:28

Thanks !!!!

abieteh.com 02 Jun 2012 07:06

Quote:

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 02 Jun 2012 10:15

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 [email protected] 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 02 Jun 2012 16:38

Quote:

Originally Posted by FF|Skyrider (Post 2335734)
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 [email protected] 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 03 Jun 2012 10:05

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 03 Jun 2012 22:15

Quote:

Originally Posted by FF|Skyrider (Post 2336055)
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 08 Jun 2012 16:38

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 09 Jun 2012 02:54

Quote:

Originally Posted by PBRiot (Post 2337758)
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.

http://www.vbulletin.org/forum/showt...top+forum+spam

GameOverViper 09 Jun 2012 16:04

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


ForceHSS 09 Jun 2012 16:29

1 Attachment(s)
Quote:

Originally Posted by Americanbang (Post 2338113)
I uploaded everything onto a new forum of mine, then went to install and it gives me this error.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

run this

tommac3 10 Jun 2012 15:09

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 10 Jun 2012 18:13

Quote:

Originally Posted by tommac3 (Post 2338435)
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 10 Jun 2012 19:58

Quote:

Originally Posted by ForceHSS (Post 2338124)
run this

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

ForceHSS 10 Jun 2012 20:17

Quote:

Originally Posted by oshrizak (Post 2338518)
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 11 Jun 2012 02:56

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 11 Jun 2012 03:58

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

ForceHSS 11 Jun 2012 05:33

Quote:

Originally Posted by Alibass (Post 2338620)
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 11 Jun 2012 07:05

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

Quote:

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 11 Jun 2012 12:41

Quote:

Originally Posted by oshrizak (Post 2338518)
Ok call I did this and still get Database error as above

Your problem is not MySQL but the code.

Change all occurence of


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

in the XML and that will solve the DB Errors.

oshrizak 11 Jun 2012 15:07

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


All times are GMT. The time now is 19:24.

Powered by vBulletin® Version 3.8.14
Copyright © 2022, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.