wordpress notes

notes_wordpress.md

if wp theme screwed , wanted to set to default via phpmyadmin

• update wp_options set option_value = 'default' where option_name = 'template'
• update wp_options set option_value = 'default' where option_name ='stylesheet'

Remove Admin bar on top

In functions.php > Add at end

add_action('after_setup_theme', 'remove_admin_bar');

function remove_admin_bar() { if (!current_user_can('administrator') && !is_admin()) { show_admin_bar(false); } }

Disable Versioning

In wp-config.php to disable versioning (above abs path)

define('AUTOSAVE_INTERVAL', 300); // seconds define('WP_POST_REVISIONS', false);

Remove Old Versions (Directly in phpmyadmin)

/* delete old revisions from db (images left) no idea, how to remove */ DELETE FROM wp_posts WHERE post_type = "revision";

For stats (queries directly in mysql)

PUBLISHED POSTS COUNT PER MONTH -- START DATE

SELECT DISTINCT extract(month from date(post_date)) AS MonthNumber, count( * ) AS Posts FROM wp_posts where post_type = 'post' AND post_status = 'publish' AND post_date like '%2018-%' GROUP BY MonthNumber

PUBLISHED POSTS COUNT PER WEEK WILD START DATE

SELECT DISTINCT extract(week from date(post_date)) AS WeekNumber, count( * ) AS Posts FROM wp_posts where post_type = 'post' AND post_status = 'publish' AND post_date like '%2018-%' GROUP BY WeekNumber