WordPress Mobile Edition

I’ve converted my b2 Mobile Edition hack to work on WordPress.
http://www.alexking.org/software/b2/
There are a couple of changes you’ll want to make so your unpublished posts aren’t shown. Make these changes to the next_post() and previous_post() functions in b2template.functions.php.
Find this line in next_post()
$nextpost = @$wpdb->get_row(“SELECT ID,post_title FROM $tableposts WHERE post_date > ‘$current_post_date’ AND post_date < ‘$now’ AND post_category > 0 $sqlcat $sql_exclude_cats ORDER BY post_date ASC LIMIT $limitnext,1”);
and change it to:
$nextpost = @$wpdb->get_row(“SELECT ID,post_title FROM $tableposts WHERE post_date > ‘$current_post_date’ AND post_date < ‘$now’ AND post_category > 0 AND post_status = ‘publish’ $sqlcat $sql_exclude_cats ORDER BY post_date ASC LIMIT $limitnext,1”);
Find this line in previous_post()
$lastpost = @$wpdb->get_row(“SELECT ID, post_title FROM $tableposts WHERE post_date < ‘$current_post_date’ AND post_category > 0 $sqlcat $sql_exclude_cats ORDER BY post_date DESC LIMIT $limitprev, 1”);
and change it to:
$lastpost = @$wpdb->get_row(“SELECT ID, post_title FROM $tableposts WHERE post_date < ‘$current_post_date’ AND post_category > 0 AND post_status = ‘publish’ $sqlcat $sql_exclude_cats ORDER BY post_date DESC LIMIT $limitprev, 1”);