{"id":201,"date":"2011-04-28T12:11:29","date_gmt":"2011-04-28T12:11:29","guid":{"rendered":"http:\/\/faq.graven-ict.nl\/wordpress\/?p=201"},"modified":"2018-02-26T13:10:29","modified_gmt":"2018-02-26T13:10:29","slug":"delete-spam-commentaar-in-gallery2","status":"publish","type":"post","link":"https:\/\/wiki.graven-ict.nl\/wordpress\/delete-spam-commentaar-in-gallery2\/","title":{"rendered":"Delete spam commentaar in gallery2"},"content":{"rendered":"<p>Bij een Gallery2 installatie, werd in het commentaar veel spam geplaatst. Na wat onderzoek bleek de dat Captcha voor commentaar uit stond. allereerst deze maar aan gezet.<\/p>\n<p><code>site-admin -> Captcha <\/code><\/p><div id=\"grave-2011064572\" class=\"grave-content grave-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1970734611769428\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:728px;height:90px;\" \ndata-ad-client=\"ca-pub-1970734611769428\" \ndata-ad-slot=\"1820224830\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n<p>Nu kunnen we al het spam commentaar 1 voor 1 via de webinterface deleten, maar dit is een tijd rovende bezigheid. na even zoeken op internet kwam ik de volgende oplossing tegen. Voor je begint maak voor de zekerheid een backup van je database. login in mysql<\/p>\n<p> mysql> use fotoalbum_g2<br \/>\n Reading table information for completion of table and column names<br \/>\n You can turn off this feature to get a quicker startup with -A<\/p>\n<p> Database changed<\/p>\n<p> <code>mysql> CREATE TEMPORARY TABLE tmptable<br \/>\n     SELECT g_id<br \/>\n     FROM `g2_Comment` gc<br \/>\n     WHERE<br \/>\n     g_subject like '%url%' or<br \/>\n     g_subject like '%http%' or<br \/>\n     g_subject like '%personals%' or<br \/>\n     g_subject like '%poker%' or<br \/>\n     g_subject like '%blackjack%' or<br \/>\n     g_subject like '%gambling%' or<br \/>\n     g_subject like '%viagra%' or<br \/>\n     g_subject like '%phentermine%' or<br \/>\n     g_subject like '%casino%' or<br \/>\n     g_subject like '100%' or<br \/>\n     g_subject like '%slots%' or<br \/>\n     g_subject like '%Cialis%' or<br \/>\n     g_subject like '%url%' or<br \/>\n     g_comment like '%http%' or<br \/>\n     g_comment like '%personals%' or<br \/>\n     g_comment like '%poker%' or<br \/>\n     g_comment like '%blackjack%' or<br \/>\n     g_comment like '%gambling%' or<br \/>\n     g_comment like '%viagra%' or<br \/>\n     g_comment like '%phentermine%' or<br \/>\n     g_comment like '%casino%' or<br \/>\n     g_comment like '100%' or<br \/>\n     g_comment like '%slots%' or<br \/>\n     g_comment like '%Cialis%' or<br \/>\n     g_comment like '%url%';<br \/>\n Query OK, 2565 rows affected (0.02 sec)<br \/>\n Records: 2565  Duplicates: 0  Warnings: 0<\/p>\n<p> mysql> DELETE g2_Entity<br \/>\n     FROM g2_Entity<br \/>\n     INNER JOIN tmptable ON g2_Entity.g_id = tmptable.g_id;<br \/>\n Query OK, 2565 rows affected (0.14 sec)<\/p>\n<p> mysql> DELETE g2_ChildEntity<br \/>\n     FROM g2_ChildEntity<br \/>\n     INNER JOIN tmptable ON g2_ChildEntity.g_id = tmptable.g_id;<br \/>\n Query OK, 2565 rows affected (0.03 sec)<\/p>\n<p> mysql> DELETE g2_Comment<br \/>\n     FROM g2_Comment<br \/>\n     INNER JOIN tmptable ON g2_Comment.g_id = tmptable.g_id;<br \/>\n Query OK, 2565 rows affected (0.07 sec)<\/p>\n<p> mysql> DROP TEMPORARY TABLE tmptable;<br \/>\n Query OK, 0 rows affected (0.00 sec)<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bij een Gallery2 installatie, werd in het commentaar veel spam geplaatst. Na wat onderzoek bleek de dat Captcha voor commentaar uit stond. allereerst deze maar aan gezet. site-admin -> Captcha Nu kunnen we al het spam commentaar 1 voor 1 via de webinterface deleten, maar dit is een tijd rovende bezigheid. na even zoeken op ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/wiki.graven-ict.nl\/wordpress\/delete-spam-commentaar-in-gallery2\/\" title=\"Meer lezen...\">Lees meer<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[52],"tags":[],"class_list":["post-201","post","type-post","status-publish","format-standard","hentry","category-gallery2"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/comments?post=201"}],"version-history":[{"count":1,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":202,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/posts\/201\/revisions\/202"}],"wp:attachment":[{"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/categories?post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki.graven-ict.nl\/wordpress\/wp-json\/wp\/v2\/tags?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}