spam protection for comments

[wildenborch]

Hi,

How can enable spam protection for comments?

Wildenborch

[SMFHacks]

Do you have visual verification enabled?
It should support that or reCaptcha I believe.

[wildenborch]

Yes, I have it enabled but it's not working with the gallery comments.

[SMFHacks]

Two more things
What SMF version?

And just for guests right?

[wildenborch]

It's version 2.0 
And indeed just for guests.

The website is http://www.rodebaert.nl
Shall I create an user account for you?

[SMFHacks]

Posted a new update that should help added code for visual verification

3.0.25
!Fixed not showing thumbnail in SMF 2.0 with RSS Feeds
+Added visual verification on add comment page and quickreply for guests to help with spam issues.
!Fixed undefined redirect variable in SMF 2.0

[wildenborch]

When I try to update I get this error:

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 'PRIMARY KEY (ID_PICTURE))' at line 5
File: galleryinstall2.0.x.php Line: 1114

[SMFHacks]

Reuploaded try again.

[wildenborch]

YES!!! Installed and spam protection is working for guests!

Thank you very much!

[SMFHacks]

Glad to help!

[wildenborch]

I need your help once again..... can I only remove approved comments through the database?

[SMFHacks]

Yeah here you

Code: [Select]

DELETE FROM smf_gallery_comment where approved = 0


[wildenborch]

And after removing the (aproved) comments from the database  how do I recalculate the number of comments?

[SMFHacks]

Try

Code: [Select]

Update smf_gallery_pic as p SET p.commenttotal = (SELECT count(*) from smf_gallery_comment as  c WHERE c.ID_PICTURE = p.ID_PICTURE)


[wildenborch]

That did the trick!

Thanks!