This is for Beta 9.8.2. If you have Beta 9.9, you already have Akismet installed.

1. You'll need a WordPress API key if you don't already have one. You can get one here... Where is my WordPress.com API key? « WordPress.com
2. Update your utils.php with this (click here) changeset
3. Update your /libs/comment.php with this (click here) changeset
4. Upload the contents of the attached file into your modules folder
5. Enable the Akismet module
6. Access the module by using the 'Spam' link at the top
7. Enter your WordPress API key

If Akismet says a comment is spam, it will not be saved. It just disappears.

If Akismet says a story is spam, it is still submitted, but there will be a link at the top to either confirm or deny that it is spam. Confirming will change the status to discard.

This is a very basic / beta module and more features are coming.

To UPGRADE, just upload the new file, replacing the existing ones.

[albertosanchezm]

Hello all,

i've just upgrade pligg from 0.9.5 to 1.0 RC1 and everything works fine. But when I try to run Askimet for spamming comments, it is displayed the following error and no message is displayed:

Warning: 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 ',,,,,,,,,,,,,,,,,,)' at line 1 in /homepages/31/d260085341/htdocs/libs/db.php on line 236

Any ideas how to solve it?

[cchh]

I fixed this

here is my patch:

Index: akismet_main.php
===================================================================
--- akismet_main.php    (revision 683)
+++ akismet_main.php    (working copy)
@@ -90,7 +90,7 @@
 function akismet_check_submit(&$vars){
        if(phpnum()>=5){
                include akismet_lib_path . 'Akismet.class_5.php';
-               $x = $x['linkres'];
+               $x = $vars['linkres'];

                $user = new User;
                $user->id = $x->author;
@@ -280,7 +279,7 @@
                        }

                        if(count($spam_links) > 0){
-                               $sql = "SELECT " . table_links . ".* FROM " . table_links . " WHERE ";
+                               $sql = "SELECT " . table_links . ".*, " . table_users . ".user_login FROM " . table_links . " LEFT JOIN " . table_users . " ON link_author=user_id WHERE ";
                                $sql .= 'link_id IN ('.implode(',',$spam_links).')';
                                $link_data = $db->get_results($sql);
                                $main_smarty->assign('link_data', object_2_array($link_data));
Index: templates/manageSpam.tpl
===================================================================
--- templates/manageSpam.tpl    (revision 683)
+++ templates/manageSpam.tpl    (working copy)
@@ -9,8 +9,8 @@
                {*<a href = "{$URL_akismet_isSpam}{$link.link_id}">Yes, this is spam</a><br />
                <a href = "{$URL_akismet_isNotSpam}{$link.link_id}">No, this is NOT spam</a><br /><br />*}
                <tr>
-               <td>{$link.link_author}</td>
-               <td>{$link.link_url}</td>
+               <td><a href="{$my_pligg_base}/admin/admin_users.php?mode=view&user={$link.user_login}">{$link.user_login}</a></td>
+               <td><a href="{$link.link_url}" target="_blank">{$link.link_url}</a></td>
                <td>{$link.link_status}</td>
                <td>{$link.link_title}</td>
                <td>{$link.link_content}<br /><br /></td>

also add link to user profile and story url.

Can anyown commit it to svn?

[Yankidank]

I'll take a look and commit it.

[kenboldt]

I tried using the fix above (though I think the fixed code was already in my akismet files), and I am still getting the error:

Warning: 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 '903,924)' at line 1 in /home/kenboldt/public_html/hockeylinks/libs/db.php on line 242

Any ideas? if you need any information, feel free to ask. Any assistance would be appreciated. I only get the error when I click on the 'items to be reviewed' links.

[kenboldt]

Does anyone have any suggestions for this?

[gmfpanda]

How can one tell if it is working for submits and comments?

Any test spam type posts to verify?

[sulong]

Such a function should be increased ：
In the " Akismet Anti-Spam console manage “，Clicking on a link to confirm as "This is spam", they should simultaneously write "local-antispam.txt" 。