« What Government and Content Have in Common via WikiLeaksAlex Halderman's DC Council Testimony »
Dec 13

Bulk Deletion of Spam Comments...

system, blogging, hacks, chilling effects, education

Apologies for the silence here... I've been busy and mostly posting short thoughts and such on Twitter.

The comment spammers seem to love a few of my posts... and moderating all the comment spam is a bit of a pain. Frankly, here's what I've been doing lately:

  1. Check my email for comment moderation emails from my blog software, quickly look through them to see if any are seriously humans with something to say. Moderate those as published.

  2. About once a month, issue the following SQL command on the database (through phpMyAdmin... note that your table name is probably different from mine as I made mine up):

    DELETE FROM `b2evo_blog_db`.`evo_comments` WHERE 
`evo_comments`.`comment_status` = "draft";
  3. This drops all the rows in the db where the comment isn't yet moderated (published).

Tags: b2evo, blogging, comments, hacks, spam

No feedback yet

Contact / Help. (cc) 2021 by Joseph Hall. blog software / web hosting.
Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.
Entries RSS Comments RSS Log in
And a few words about the structure of the eye . Everyone " retina ". Especially often we hear it buy clomid online in the phrase " retinal detachment ." So what is the retina ? This - the front edge of the brain, the most distant from the brain part of the visual analyzer. The retina receives light first , processes and transforms light energy into irritation - a signal that encodes all the information about what the eye sees . The retina is very complex and in their structure and function . Its structure resembles the structure of the cerebral cortex. The shell of the retina is very thin - about 0.14 mm.