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.
Yearly Archive: 2021
Disable wp-chron.php in WordPress and set as a scheduled task
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
How to access API endpoints from Eve Online’s Eve Swagger Interface requiring authentication using PHP – part II
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
Forcing traffic over SSL to WordPress behind AWS Elastic Load Balancer
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
How to access API endpoints from Eve Online’s Eve Swagger Interface requiring authentication using the DOS command line – part I
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.
Point an Amazon CloudFront distribution to a load balancer origin
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
10 Gigabit Home Networking Hardware
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