Akismet Anti-Spam

-----------------
- Brought To You By:
-
- MediaFlavor.com
-
- Custom VB Mods, Extensions, and Plugins
-----------------

This extension will automatically check new posts against the Akismet spam rulesets and identify spam if it is posted on your site. All spam is set to moderated status until an admin/moderator approves/deletes it.

This setting can be set on a usergroup basis so only certain usergroups are scanned.

I have no affiliation with Akismet, I just know that it catches about 99% of all spam I get on my blogs.

You will need an API key to use this product, but they are free and you can get one immediately at wordpress.com when you sign up.

Installs easily, just upload the included files, and install the product file. NO TEMPLATE EDITS!

You should probably use a promotion strategy outlined here:

https://vborg.vbsupport.ru/showpost....3&postcount=18

This will reduce your Akismet usage and not filter your regular users who you are pretty confident will not post SPAM.

A good mod that works with this hack is the "Moderation Queue on FORUMHOME" hack here:

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

The only other thing you need to do is:

CLICK INSTALL

This modification is FREE of charge, but if you wish to reward me for my work, and encourage future modifications by me, please donate below - :

[Jafo232]

Yes, it works with the latest version of Vbulletin.

[goddess_dix]

Originally Posted by Jafo232

Most likely, that users IP and/or Uname combo has been blacklisted. Here is what I do on my forums:

Create a group called Registered Users Promoted.

Copy the same settings as you have for the Registered Users group EXCEPT set the option "Filter Posts With Akismet" to no.

ok, i'm looking at this, since akismet works wonders for my blog. no spam at all! but i'm not sure exactly how it behaves on vb. my understanding with other posts is that it should work on vb 3.67 and 3.68. if that's not right, please let me know.

you mentioned most likely in this example above, the username/ip has been blacklisted. does akismet blacklist it in a table in the vb database or what? and that blacklisted info is not transferred the the vb area for blocked ips and emails, right? so if i ever removed akisment, i'd best get that info out first, i'm thinking?

and how might this work with infractions?

i'm wanting to automate our spam-whacking. so i figured, set up spammer auto-ban in infractions. akismet will pop potential spam into moderation que where the mod can decide if it's a spammer to whack or just release it in the unlikely event it's harmless.

currently, my mods will ban both ip and email of spammers, in addition to username. it looks like the autoban from infractions system only hits the username, but i'm not sure about that, either...and i'm not entirely sure that the ip and email banning is even all that helpful done globally like it is now.

and would this work to leave my registered group the same, but set up a new usergroup that's basically probationary, under 10 posts or whatever, that's the default upon signing up?

input appreciated.

[Jafo232]

However akismet decides positives is unknown to me. VB never gets that info. It just asks akismet "Do you think this is spam?" and they answer yes or no. The plugin does not do anything to the user other than put the said post into moderation. It would then be up to you to do what you will with said user.

[frostyIntrepid]

I am working on 3.6.8 and when I tried to submit spam, it brings me to a page with invalid page specified. Is there a way to customize the message rather than just showing the invalid link error?

[turk1701]

I'm getting this error when trying to uninstall this plugin:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Banned Users',
`description` = '',
`usertitle` = 'Banned',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`arcadepermissions` = '0',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0',
`forumpermissions` = '131072',
`attachlimit` = '0',
`pmquota` = '0',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '32',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '0',
`genericoptions` = '0',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '139263',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`akspam_permissions` = '0',
`vbimghost` = '0',
`vbimghost_upslots` = '3',
`vbimghost_files` = '50'
WHERE usergroupid=8;

MySQL Error : Unknown column 'akspam_permissions' in 'field list'
Error Number : 1054
Date : Thursday, November 22nd 2007 @ 07:29:00 AM
Script : http://www.hotelblues.com/vb/admincp....php?do=update
Referrer : http://www.hotelblues.com/vb/admincp...&usergroupid=8
IP Address : 71.86.228.150
Username : Turk
Classname : vb_database

How do I get rid of this plugin without getting this error?

[Jafo232]

You should reinstall the plugin, overwrite, then uninstall.. Not sure what you did here but the table is missing..

[turk1701]

Thanks Jafo. Not sure what I did either. Working good again.

[goddess_dix]

Originally Posted by Jafo232

You should reinstall the plugin, overwrite, then uninstall.. Not sure what you did here but the table is missing..

i've having a similar problem trying to completely uninstall this; i cannot edit usergroups after an uninstall.

if i reinstall and disable as the other poster was directed, i can edit usergroups without issue, but it retains the akismet permissions radio button at the bottom of the usergroup edit page. if i completely uninstall it, at the bottom of the usergroup option page, the radio buttons remain with _no text_ describing what it is, and the query always has this error...

 
Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE vb_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
 `title` = 'Moderators',
 `description` = '',
 `usertitle` = 'Moderator',
 ..... snip........
 `fcpermissions` = '4',
 `akspam_permissions` = '0'
WHERE usergroupid=7;
MySQL Error  : Unknown column 'akspam_permissions' in 'field list'
Error Number : 1054

i looked at the unistall code, and it looks like it did as directed, remvoing the plugins columns from the usergroup and user tables. is there some way i can manually get rid of this plugin completely, please?

[Jafo232]

Did you remove the bitfield_ak_spam.xml file from the xml directory?

[goddess_dix]

Originally Posted by Jafo232

Did you remove the bitfield_ak_spam.xml file from the xml directory?

well, now i have. that took care of the issue for me. thank you very much!