Coder’s Blogs

Just a few brief notes on the basics. It is assumed you are familier with Linux, PHP, WordPress, etc, and just want some additional information.

SQL to extract order report

SELECT pm.meta_value AS city,p.ID as order_id,p.post_excerpt as customer_note,p.post_date as order_date,pm2.meta_value as suburb,pm3.meta_value as customer_id, pm4.meta_value as sender_email, pm5.meta_value as sender_firstname, pm6.meta_value as sender_lastname FROM wp_posts p LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id LEFT JOIN wp_postmeta pm2 ON p.ID = pm2.post_id LEFT JOIN wp_postmeta pm3 ON p.ID = pm3.post_id LEFT JOIN wp_postmeta pm4 ON…

Read More SQL to extract order report

WP REST with JWT

Using the WordPress REST API with JWT authentication Step 1. Install this plugin => https://wordpress.org/plugins/advanced-access-manager/. The free version will suffice. This goes on the site you will be xtracting data from. The REST API must be enabled in the WordPress settings. Step 2. Configure the plugin and on it’s Settings tab add the Secret as…

Read More WP REST with JWT

WordPress Security

This applies to self-managed Apache2 servers. Shared servers require different permissions, for example wp-config : set that file’s permissions to 440 or 400. Site Lockdown File permissions to lock down website, from the websites home folder. Do this from the root directory for example and you will break your server. chown root:root -R * find…

Read More WordPress Security

SSL Localhost

To enable ssl on a localhost website, and stop Chrome from showing is as “unsafe” …. Pertains to Ubuntu 18.04 Bionic, and running Apache 2.4.29 Create localhost.cnf HOME = . RANDFILE = $ENV::HOME/.rnd oid_section = new_oids [ new_oids ] tsa_policy1 = 1.2.3.4.1 tsa_policy2 = 1.2.3.4.5.6 tsa_policy3 = 1.2.3.4.5.7 [ ca ] default_ca = CA_default #…

Read More SSL Localhost

WordPress Basic Plugin

Below is a very simple working example of a plugin. Create a directory in your plugins directory, create a php file and copy the below into it. Then from the wordpress plugins menu simply activate it. Just know that this plugin does absolutely nothing other than to show the basic setup, including public and protected…

Read More WordPress Basic Plugin

Ubuntu Must Have Apps

As Open Office is part of the standard Ubuntu install, like other software installed as default, I have not listed it. There are a number of must have applications needed to get the most out of Uubuntu 18.04, but first thing to do is change the deskop. Ubuntu’s standard is way too slow and reminds…

Read More Ubuntu Must Have Apps

Linux miscellaneous

Pertains mostly to Ubuntu 18.04.4 and Apache 2.4.29 Get Ubuntu version lsb_release -a Get Apache version apache2 -v Get MySql version mysql –version Find Files and hide all permission denied messages find /start_directory -name filename 2>/dev/null Copy file with ssh from server to localhost scp user@server:/directory_from/filename.txt /local_directory/ Copy file from localhost to server with ssh…

Read More Linux miscellaneous

Exporting/Importing Woocommerce Orders with SQL 2020

Covers WordPress version 5.3.2 No matter how you use the SQL, be it on the command line, PhpMyAdmin or PHP, These are just the SQL commands needed. There are 4 tables invlovled not counting the variable product data. I’ll be adding that as soon as a get a free moment. wp_postswp_postmetawp_woocommerce_order_itemswp_woocommerce_order_itemmeta wp_posts are where the…

Read More Exporting/Importing Woocommerce Orders with SQL 2020

Setting up Inkscape for use with a Vinyl Cutter using Inkcut

Step 1 Download and install the InkCut Extension from the InkCut sourceforge page. Step 2 Install the following linux libraries : sudo apt-get install python-gtk2-dev sudo apt-get install python-cups sudo apt-get install python-serial Using InkCut to perform the cut Step 1 Select the objects you wish to cut Step 2 Ungroup the selected objects Step…

Read More Setting up Inkscape for use with a Vinyl Cutter using Inkcut

Raspberry PI Setup

use GParted to format SD to win32. sudo dd bs=4M status=progress if=~/Downloads/2018-06-27-raspbian-stretch.img of=/dev/sdc; sync NB note /dev/sdc, not /dev/sdb1. i.e. Must point to physical device, not partition. Edit config.txt on the SD to set hdmi hot plug support. put sd in the pi, plug in kb and monitor and boot. after install and upgrade process…

Read More Raspberry PI Setup