====== WordPress ======

===== fight with spam comments =====

==== delete spam comments ====

<code sql>
DELETE FROM wp_comments WHERE comment_approved = 0;
</code>

list junk entries:
<code sql>
SELECT * FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments)
</code>

Delete junk entries:
<code sql>
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments)
</code>

Disable comments for old blog entires:
<code sql>
UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2019-01-01' AND post_status = 'publish';
</code>

Disable comments in whole Wordpress:
WP-Admin: ''Ustawienia'' -> ''Dyskusja'': ''Zezwól na komentowanie nowych artykułów''

<code sql>
UPDATE wp_options SET option_value = 'closed' WHERE option_name = 'default_comment_status'; 
</code>


==== install plugin ====

  * 
  *