Wordpress

Wordpress items

  • WordPress: get all posts with no audio files attached

    WordPress: get all posts with no audio files attached

    Useful SQL query for wordpress: SELECT p.post_title, p.guid FROM wp_posts p WHERE p.post_type = ‘post’ AND NOT EXISTS (SELECT * FROM wp_posts a WHERE p.ID = a.post_parent AND a.post_mime_type LIKE ‘%audio%’);

    Read more »
  • Generating thumbnails on the fly with WordPress

    Generating thumbnails on the fly with WordPress

    One advantage of Drupal’s resizing images over WordPress – WordPress’s resized images are generated at upload time only, whereas Drupal’s will be generated automatically on page load if the thumbnail doesn’t already exist. You could put this function into your WP template – given an image url $image_url, it checks for the address of its […]

    Read more »
  • Migrating static HTML sites into a WordPress multisite

    Migrating static HTML sites into a WordPress multisite

    1. Create a multisite account for the site you are about to import We set up our multisite using subdomains – this is useful for us as some of our sites there really are subdomains of the main site. If you use subfolders, some of the steps below might be different – unfortunately we havent […]

    Read more »
  • Separating a wordpress multisite into individual installations

    Separating a wordpress multisite into individual installations

    We had 2 large sites on the same WordPress multisite, but then we decided to split it up for the following reasons: From a sysadmin point of view, its always better to keep large sites in their own account Easier from a debugging point of view – the simpler the setup, the easier it is […]

    Read more »