taichino.com

function SBM_popular_recent_entry_list($limit=10, $threshold=5, $val="") {
    global $wpdb;
 
    $pluginurl = get_option('siteurl')."/wp-content/plugins/wp-sbm_popular_entry/";
    $metalist = $wpdb->get_results( SBM_popular_recent_entry_list_sql($limit, $threshold, $val) );
 
    if ( $metalist ) {
        ob_start();
        foreach ($metalist as $metarow) {
            $permalink = get_permalink($metarow->ID);
            $title = $metarow->post_title;
            $meta = get_post_meta($metarow->ID, "SBM_count", 1);
            $popup = "iconImageClickHandler(this, '".$permalink."', event)";
            list($count, $icon, $link, $add) = _template_parm($pluginurl, $permalink, $title, $metarow->meta_value);
 
            if($count['sum'] > 0)
                include('wp-content/plugins/wp-sbm_popular_entry/template_list.php');
        }
        $content = ob_get_contents();
        ob_end_clean();
        echo $content;
    }
 
}
 
function SBM_popular_recent_entry_list_sql($limit, $threshold, $val="") {
    global $wpdb, $tablepost2tag, $tabletags;
 
    $val = mysql_real_escape_string($val);
 
    $sql = "SELECT ID, post_title, meta_value ";
    $sql.= "FROM $wpdb->posts, $wpdb->postmeta WHERE ";
    $sql.= "$wpdb->posts.ID=$wpdb->postmeta.post_id and meta_key = 'SBM_count' and meta_value >= $threshold ".
                 "ORDER BY ID DESC LIMIT ".$limit;
    return $sql;
}

< ?php SBM_popular_recent_entry_list(10, 5) ?>