Akismet Spam Protection

[tanshin]

Hi there! I'm having an issue with installation on 2.0 RC2. The issue is with the second step of the view-profile.php file.
FIND

Code Select Expand

FROM {db_prefix}draft_messages AS m' . ($user_info['query_see_board'] == '1=1' ? '' : ' INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})') . ' WHERE m.id_member = {int:current_member} 
ADD AFTER

Code Select Expand

  AND m.spam = 0 

Attached are my mods.

[live627]

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/xxxxx/public_html/forum/Sources/Subs-Post.php on line 1833

// Increase spam count
      $smcFunc['db_query']('', '
         UPDATE {db_prefix}settings
         SET value = value + 1
         WHERE variable = {string:akismetCaughtSpam''}
         array(
            'akismetCaughtSpam' => 'akismetCaughtSpam',

Any ideas Live?

WHERE variable = {string:akismetCaughtSpam''}

needs replaced with

WHERE variable = {string:akismetCaughtSpam}

(The quotes need removed)

[JamesKilton]

So, this mod is completely broken against 1.1.11 (1.2-beta of course, 1.1-fixed is flagged as incompatible):

It installs fine, but I get the empty link, and going to the page directly, there's no text. So I went looking for the text, and ... it doesn't exist. The installer has no idea what any of the admin text is supposed to be.  I think I can make it work as the 1.1-Fixed has all the text keys appropriately, but this is a pretty huge oversight packaging 1.2-beta.

Please fix this asap.

[giveaway365.com]

This mod is now dangereous

[live627]

1.2 beta 2 has been released!

Fixed missing language strings for SMF 1.1.11
Fixed parse errors (one detected, bad query)
More areas where spam posts are hidden
Refined spam alert on topic view; looks nicer
added a show me this post link on said alert

[tanshin]

Hi there! I'm having an issue with installation on 2.0 RC2. The issue is with the second step of the view-profile.php file.
FIND

Code Select Expand

FROM {db_prefix}draft_messages AS m' . ($user_info['query_see_board'] == '1=1' ? '' : ' INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})') . ' WHERE m.id_member = {int:current_member} 
ADD AFTER

Code Select Expand

  AND m.spam = 0 

Attached are my mods.

I'm still having this issue with b2

[live627]

Oh thanks for pointing that out! I've changed that and re-uploaded the package

[tanshin]

Looks like we're good and running!

I guess the only improvement that I can see would be some form of notification to admins that there are spam posts (perhaps an ! after the admin link)

[live627]

That's a great idea! I'll include it in the next release

[giveaway365.com]

is this mod stable for smf 1.1.11?
last time it did not work a bit...

[IdanC]

hi,

it seems like every reply from any ip gets this messeage -

Warning: Your post has been classified as spam, and will not be visible to the public until an administrator or moderator approves it.

and the weird thing is, that the post IS visible to the public, and all can see this msg...

i use smf2 rc2

[Bugo]

Please add russian translation

[harryxyz]

in the displaytemplate.php of my default theme as well as the Underground theme i use I cannot find this line you mentioned:"<a href="', $message['href'], '">', $message['subject'], '</a>
                           </div>';"

There is no such line: Two lines close to this line are:
1"<td width="10%" valign="middle" align="right">
                                <span class="smalltext"><a href="', $message['href'], '">#', $message['counter'], '</a></span>';"

2.<div style="font-weight: bold;" id="subject_', $message['id'], '">
                                    ', $message['subject'], '
                                </div>

Please tell me what to do. Will be really grateful for the great help

[marknekk]

Hmm... I was trying to use this mod, but the "Akismet Configuration" text doesn't appear in the Admin-zone... no matter what language I choose... english, english british, spanish... whatever... tried the 1.2b2 or so... (not the 1.11fixed which doesn't install)

[aliweb]

is this mod stable for smf 1.1.11?
last time it did not work a bit...

Yeah I tried just now and it doesn't work. Any updates on this?

[Pieti]

Hello!

I get this error:

Undefined index: akismetCaughtSpam
Datei: /xxx/Themes/default/Akismet.template.php (main sub template - eval?)
Zeile: 67

Line: 67

Code Select Expand

global $txt, $modSettings, $scripturl, $context;

Any who knows how to solve it?

Nice Greetings

[ehsizzup]

How is this mod with SMF2 RC3?

[tj.baker]

is this mod stable for smf 1.1.11?
last time it did not work a bit...

Yeah I tried just now and it doesn't work. Any updates on this?

No go for me and 1.1.11 either ......

Would really love to get this mod working

[V@no]

Hello.

First of all, thank you for this very needed mod.

I have successfully installed it on SMF v1.1.111, but with some manual modifications.

The install11.php uses updateSettings() function, which doesn't work in SMF 1.1.111, that's why some people see warning messages at Akismet configuration page.
I had to add this:

Code Select Expand

db_query("
REPLACE INTO {$db_prefix}settings
(variable, value)
VALUES (SUBSTRING('akismetCaughtSpam', 1, 255), SUBSTRING('0', 1, 65534)), (SUBSTRING('akismetAPIKey', 1, 255), SUBSTRING('', 1, 65534))", __FILE__, __LINE__);


Then, these two lines work only on MySQL5 and newer:

Code Select Expand

$request = db_query("SHOW COLUMNS FROM {$db_prefix}messages WHERE Field = 'spam'", __FILE__, __LINE__);
$request = db_query("SHOW COLUMNS FROM {$db_prefix}topics WHERE Field = 'spam'", __FILE__, __LINE__);

I had to replace them with these, they work with any mysql version:

Code Select Expand

$request = db_query("SHOW COLUMNS FROM {$db_prefix}messages LIKE 'spam'", __FILE__, __LINE__);
$request = db_query("SHOW COLUMNS FROM {$db_prefix}topics LIKE 'spam'", __FILE__, __LINE__);


Just in case I've attached fixed install11.php



Now, how is the new version coming? any updates on when we will see it? Will it include moderators support?

Thank you.

[giveaway365.com]

Thanks for the code! I hope it will help people who r on 1.1.11
I have shifted to RC3 from April 2010.