Licensed under the GPL Version: 2.0 Author: Kates Gasis Author URI: http://katesgasis.com */ /****** EDIT THIS FIRST *********/ $cat_to_hide = 1; /********************************/ function sideblog_where($query) { global $cat_to_hide; $now = current_time('mysql'); if(is_home()){ return $query . ' AND category_id <> ' . $cat_to_hide . ' '; } return $query; } add_filter('posts_where','sideblog_where',10); function sideblog_join($query) { global $wpdb; if(is_home()){ $newquery = $query . " LEFT JOIN $wpdb->post2cat ON ($wpdb->posts.ID = $wpdb->post2cat.post_id) "; return $newquery; } return $query; } add_filter('posts_join','sideblog_join',10); function sideblog($params="title=no&permalinks=no&limit=1") { global $wpdb, $cat_to_hide; $cat_to_show = $cat_to_hide; $title = ""; $permalinks = ""; $limit = "1"; $side_blog_queries = explode("&", $params); foreach($side_blog_queries as $side_blog_query){ $attributes = explode("=", $side_blog_query); $name = strtolower($attributes[0]); $value = strtolower($attributes[1]); switch($name){ case "title": $title = $value; break; case "permalinks": $permalinks = $value; break; case "limit": $value=(int) $value; if($value <> 0 && !empty($value) && !is_null($value)){ $limit=$value; } break; } } $now = current_time('mysql'); $side_blog_contents = $wpdb->get_results("SELECT $wpdb->posts.ID, $wpdb->posts.post_title, $wpdb->posts.post_content FROM $wpdb->posts, $wpdb->post2cat WHERE $wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id=" . $cat_to_show . " AND $wpdb->posts.post_status='publish' AND $wpdb->posts.post_password='' AND $wpdb->posts.post_date < '" . $now . "' ORDER BY $wpdb->posts.post_date DESC LIMIT " . $limit); foreach($side_blog_contents as $side_blog_content) { $side_blog_output = "
  • "; if($title == "true"){ $side_blog_output .= "
    $side_blog_content->post_title
    \n";} $side_blog_output .= "
    $side_blog_content->post_content\n"; if($permalinks == "true"){ $side_blog_output = "$side_blog_output - ID) . "\" title=\"Permalink to $side_blog_content->post_title\">#\n";} $side_blog_output .= "
  • \n"; echo $side_blog_output; } } ?> Ravedigital | DJ, Turntables, Raves, EDM, Reviews

    Blog

    Breakdance Festival in UK

    April 30th, 2007

    Awesome turntablism.

    December 18th, 2006

    DJ TryXX Mix: Quantum Beatz

    November 19th, 2006

    True Mobile iPod DJing

    November 10th, 2006

    The Turntable PC

    November 10th, 2006

    Buffett busted for ecstasy?

    October 7th, 2006