SMFHacks.com

SMF Gallery Pro => Support => Topic started by: wildenborch on July 20, 2011, 01:53:56 pm

Title: spam protection for comments
Post by: wildenborch on July 20, 2011, 01:53:56 pm

Hi,

How can enable spam protection for comments?

Wildenborch

Title: Re: spam protection for comments
Post by: SMFHacks on July 20, 2011, 01:55:56 pm

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

Title: Re: spam protection for comments
Post by: wildenborch on July 20, 2011, 04:04:36 pm

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

Title: Re: spam protection for comments
Post by: SMFHacks on July 20, 2011, 04:24:59 pm

Two more things
What SMF version?

And just for guests right?

Title: Re: spam protection for comments
Post by: wildenborch on July 21, 2011, 12:13:31 am

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?

Title: Re: spam protection for comments
Post by: SMFHacks on July 21, 2011, 10:34:13 am

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

Title: Re: spam protection for comments
Post by: wildenborch on July 21, 2011, 11:52:00 am

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

Title: Re: spam protection for comments
Post by: SMFHacks on July 21, 2011, 11:58:04 am

Reuploaded try again.

Title: Re: spam protection for comments
Post by: wildenborch on July 21, 2011, 12:12:27 pm

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

Thank you very much!

Title: Re: spam protection for comments
Post by: SMFHacks on July 21, 2011, 12:19:24 pm

Glad to help!

Title: Re: spam protection for comments
Post by: wildenborch on July 21, 2011, 12:30:40 pm

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

Title: Re: spam protection for comments
Post by: SMFHacks on July 21, 2011, 12:39:29 pm

Yeah here you

Code: [Select]

DELETE FROM smf_gallery_comment where approved = 0


Title: Re: spam protection for comments
Post by: wildenborch on July 21, 2011, 12:52:52 pm

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

Title: Re: spam protection for comments
Post by: SMFHacks on July 21, 2011, 12:57:31 pm

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)


Title: Re: spam protection for comments
Post by: wildenborch on July 21, 2011, 02:05:02 pm

That did the trick!

Thanks!