Posted on: 08/31/18 03:52pm
By: Anonymous (dbsmall)
I've neglected my Geeklog site for a while, during which time the Spammers overtook the comments.
Assuming I'm going to upgrade and maintain it, going forward...
I'll want to do some bulk deletion of comments, based on a date range. (I'm not worried about losing some valid comments duiring that same period.)
I'll go dig into the structure, this weekend. But if someone can suggest an easy 'oh, look in the following tables and delete records which match on X', or a simple SQL query to execute, boy, that would be helpful.
Thanks.
Re: bulk comments delete
Posted on: 08/31/18 03:57pm
By: Anonymous (dbsmall)
Ummm... https://www.geeklog.net/forum/viewtopic.php?showtopic=81330&highlight=delete%20comments#81330
Will look into the bulk comments delete, and whether it can be done on a per-date basis.
(Identifying strings that are used by the spammers might....take a lot longer.)
Re: bulk comments delete
Posted on: 08/31/18 06:16pm
By: Laugh
Geeklog does come with an admin tool for comments now. So if you upgrade to the latest version (v2.2.0) you will be able to sort comments by the date and then multi select to delete them.
You can check out the feature on the Demo site. Log in as the admin and then look for the Comments under Admins Only Block.
https://www.softaculous.com/softaculous/demos/Geeklog[*1]
If you are worried about comment spam in the future you can turn on comment submissions which means the admin will have to approve the comment before it goes live.
Tom