vBulletin Mods

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

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.


All times are GMT. The time now is 05:08.

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.