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
pgpIWC269bF0y.pgp
Description: PGP signature
