OzzyCzech

WordPress database clean up queries

• Orphan rows
  • wp_posts -> wp_posts (parent/child)
  • wp_postmeta -> wp_posts
  • wp_term_taxonomy -> wp_terms
  • wp_term_relationships -> wp_term_taxonomy
  • wp_usermeta -> wp_users
  • wp_posts -> wp_users
• Other
  • wp_postmeta dupes

OzzyCzech

<?php

/**
 * Generates timestamp bounderies for the passed date range name.
 *
 * @param  string $range Date range name.
 *
 * @return array
 */
function get_daterange_timestamps($range)

OzzyCzech

<?php
/**
 * Normalise a file path string so that it can be checked safely.
 *
 * Attempt to avoid invalid encoding bugs by transcoding the path. Then 
 * remove any unnecessary path components including '.', '..' and ''.
 *
 * @param $path string
 *     The path to normalise.
 * @param $encoding string