Akismet on Xtras comments

[Thijs Alkemade]

On Sun, Apr 28, 2013 at 03:00:48PM +0200, Jeroen van Meerendonk wrote:
> Hi there,
> 
> I'm looking for implementing Akismet in the comments system of Adium Xtras. It should be easy but I have a few questions.
> 
> The way Akismet works it's easy. You send the data and they tells you if it's spam (or it looks like) or it's a legit comment. The thing is that sometimes a comment can be market as spam by mistake. Does the database has a field for not show the comment untill approved manually? So you can keep storing the comments and check if some of them are marked as spam by mistake.
> 
> The other option is to just don't insert the comments marked as spam. It's your call :)
> 
> And the other thing is that I've never worked with Mercurial. I'm a git guy but I thinks there's no git repo of the Xtras website. If somebody can help me with that it should be easy and fast.
> 
> 
> And thanks for your work!
> 

Hi Jeroen,

Thanks for showing interest in this! Spam on adiumxtras has been really 
annoying.

I myself have only worked on that site briefly to add reCAPTCHA support 
(which did help, but some spam still comes through). While the site itself 
is open-source, I found out the schema of the database is not included 
anywhere in its repository.

You can find the output of "mysqldump --no-data" on our current database 
here:

https://gist.github.com/xnyhps/0c22479f51b392314777

As you can see, no field to flag a comment for review currently exists.  
However, I'm also quite sure there would be no objections to adding one.

Just one observation I want to mention about the spam: in many cases, it 
seems the bots copy one of the existing, non-spam comments and add a URL to 
it. From your description, this sounds like something Akismet would not be 
able to handle this well, or will it?

Hope this helps,
Thijs
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 938 bytes
Desc: not available
URL: <http://adium.im/pipermail/devel_adium.im/attachments/20130507/ced7f16c/attachment.sig>