Skip to content

Instantly share code, notes, and snippets.

View amikoreh's full-sized avatar

Ami Koreh amikoreh

View GitHub Profile
@amikoreh
amikoreh / wp-cron-commands
Last active September 7, 2017 16:36
WordPress Cron Job Fix Options
PHP:
cd /home/webuser/public_html/wpfolderlocation; php -q wp-cron.php
cd /home/webuser/public_html/wpfolderlocation; php /home/webuser/public_html/wpfolderlocation/wp-cron.php?doing_wp_cron > /dev/null 2>&1
curl:
curl --silent "https://example.com/wp-cron.php?doing_wp_cron" > /dev/null 2>&1
curl --insecure --silent "https://example.com/wp-cron.php?doing_wp_cron&UNIQUECODE" >/dev/null 2>&1
WP-Cli:
cd /home/webuser/public_html/wpfolderlocation; wp cron event run --due-now > /dev/null 2>&1
@amikoreh
amikoreh / gist:ba9f8d0a5a12c559b05cbbc2d3a0c382
Created August 30, 2017 14:38
WordPress User Profiles - Join MySQL query
SELECT
u1.id,
u1.user_login,
u1.user_email,
m1.meta_value AS firstname,
m2.meta_value AS lastname,
from_unixtime(floor(m3.meta_value)) AS lastlogin,
from_unixtime(m4.meta_value) AS whenlastlogin,
m5.meta_value AS logincount
FROM %WPDB%users AS u1