Purge spam comments in WordPress from the DOS command line
In this post I show how to use the MySQL command line to purge comment spam from a WordPress database.
In this post I show how to use the MySQL command line to purge comment spam from a WordPress database.
From the wp-cron.php file: The short version is that wp-cron is a scheduler function that performs routine tasks such as checking for version updates of WordPress files, themes and plugins as well as maintenance tasks like identifying spam comments. The…
Read more
I have been working on an application that collects market data from Eve Online’s sagger interface and have written a few PHP scripts to automate the steps I established via the DOS command prompt outlined in part I. To recap:…
Read more
These days just about every web site uses SSL to encrypt traffic in transit and AWS has made it that much easier with AWS Certificate Manager. I recently built this page on AWS and it took some fiddling to get…
Read more
There are plenty of code snippets out there on how to access Eve Online’s ESI, and a couple of high-level walkthroughs, but most are for Python and all assume a linux box. Since I was using PHP on Windows box, I had to do a lot of this on my own. I’ve decided to lay out how to perform this in DOS (Part I) and PHP for Windows (Part II) to help the next person searching for this kind of solution.
Recently I decided to add a CloudFront distribution in front of a public facing application load balancer and it turned out to be more complicated than I’d anticipated. I faced two issues: The first was that I was using an…
Read more
I recently swapped out my Infiniband 10g hardware for 10 gigabit over fiber so I snapped a few photos to post this kit on eBay. I thought I’d post them here as well for posterity’s sake. This solution was rock…
Read more
I’ve started working on a stats page for Plague Devastation, my Quake 2 Devastation server, so that I can automate the collection and parsing of the XML log files produced after every match. Right now I have a basic collection…
Read more
There are a few steps involved in getting SNMP functional on ESXi. They go something like this. Set the SNMP community string Enable the SNMP service Add necessary firewall rules Enable the added firewall rule Restart the SNMP daemon SSH…
Read more
Part of building my ESX cluster in my garage was the addition of a 10 gigabit network for the storage layer. This storage layer allows all of the ESX hosts to talk to my FreeNAS iSCSI target which will host…
Read more