|
wildenborch
|
 |
« on: July 20, 2011, 01:53:56 pm » |
|
Hi,
How can enable spam protection for comments?
Wildenborch
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #1 on: July 20, 2011, 01:55:56 pm » |
|
Do you have visual verification enabled?
It should support that or reCaptcha I believe.
|
|
|
|
|
Logged
|
|
|
|
|
wildenborch
|
|
« Reply #2 on: July 20, 2011, 04:04:36 pm » |
|
Yes, I have it enabled but it's not working with the gallery comments.
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #3 on: July 20, 2011, 04:24:59 pm » |
|
Two more things
What SMF version?
And just for guests right?
|
|
|
|
|
Logged
|
|
|
|
|
wildenborch
|
|
« Reply #4 on: July 21, 2011, 12:13:31 am » |
|
It's version 2.0 And indeed just for guests. The website is http://www.rodebaert.nlShall I create an user account for you? |
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #5 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
|
|
|
|
|
Logged
|
|
|
|
|
wildenborch
|
|
« Reply #6 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
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #7 on: July 21, 2011, 11:58:04 am » |
|
Reuploaded try again.
|
|
|
|
|
Logged
|
|
|
|
|
wildenborch
|
|
« Reply #8 on: July 21, 2011, 12:12:27 pm » |
|
YES!!! Installed and spam protection is working for guests!
Thank you very much!
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #9 on: July 21, 2011, 12:19:24 pm » |
|
Glad to help!
|
|
|
|
|
Logged
|
|
|
|
|
wildenborch
|
|
« Reply #10 on: July 21, 2011, 12:30:40 pm » |
|
I need your help once again..... can I only remove approved comments through the database?
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #11 on: July 21, 2011, 12:39:29 pm » |
|
Yeah here you DELETE FROM smf_gallery_comment where approved = 0
|
|
|
|
|
Logged
|
|
|
|
|
wildenborch
|
|
« Reply #12 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?
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
|
|
« Reply #13 on: July 21, 2011, 12:57:31 pm » |
|
Try Update smf_gallery_pic as p SET p.commenttotal = (SELECT count(*) from smf_gallery_comment as c WHERE c.ID_PICTURE = p.ID_PICTURE)
|
|
|
|
|
Logged
|
|
|
|
|
wildenborch
|
|
« Reply #14 on: July 21, 2011, 02:05:02 pm » |
|
That did the trick!
Thanks!
|
|
|
|
|
Logged
|
|
|
|
|
SMFHacks
Members
Total Members: 10071
Stats
Users Online
Author