patch Tag Archive

$ diff -u twitpress.php.org twitpress.php
--- twitpress.php.org   2008-10-26 10:29:45.000000000 +0900
+++ twitpress.php       2008-10-26 10:13:21.000000000 +0900
@@ -246,7 +246,8 @@
        $proto = get_option( 'twitpress_message' );
        $post = get_post( $postID );
        $proto = str_replace( "[title]", $post->post_title, $proto );
-       $proto = str_replace( "[permalink]", $post->guid, $proto );
+       //$proto = str_replace( "[permalink]", $post->guid, $proto );
+       $proto = str_replace( "[permalink]", get_permalink($postID), $proto );
        $proto = str_replace( "[link]", get_option( 'home' )."?p=".$postID, $proto );
        return $proto;
 }

//Runs when a post record is inserted into the database
function twitpress_run( $postID ) {
	//get the post
	$post = get_post( $postID );

	//get the post type(page or post)
	$post_type = get_post_type( $postID );

	//we only want to do anything if the post was not previously twittered
	if ( !twitpress_was_twittered( $postID ) && ( $post_type === "post") ){
		//Update the post to reflect it's current status
		twitpress_db_update_post( $postID, $post->post_status );
	}
	//process the posts, including twittering newly published posts
	if ( $post_type === "post" ){
		twitpress_process_posts();
	}
}

WordPress database error Table '***.wp_post2cat' doesn't ex
ist for query SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id)  AND ( category_id
 = 13) WHERE wp_posts.post_date <= '2008-01-18 12:33:51' AND ( wp_posts.post_status = 'publish' ) AND wp_posts.post_password 
= '' GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10

$ diff -u customizable-post-listings.php.org customizable-post-listings.php
--- customizable-post-listings.php.org  2004-09-27 13:50:33.000000000 +0900
+++ customizable-post-listings.php      2008-01-18 13:32:27.000000000 +0900
@@ -39,10 +39,13 @@
        $authors = '',                  // space separated list of author IDs -- leave empty to get all
        $include_passworded_posts = false) 
 {
-       global $wpdb, $tablecomments, $tableposts, $tablepost2cat;
+       global $wpdb, $tablecomments, $tableposts, $tableterm_relationships, $tableterm_taxonomy;
        if ($add_recent_comment_to_sql && !isset($tablecomments)) $tablecomments = $wpdb->comments;
-       if (!isset($tablepost2cat)) $tablepost2cat = $wpdb->post2cat;
+       if ($add_recent_comment_to_sql && !isset($tablecomments)) $tablecomments = $wpdb->comments;
+       if (!isset($tableterm_relationships)) $tableterm_relationships = $wpdb->term_relationships;
+       if (!isset($tableterm_taxonomy)) $tableterm_taxonomy = $wpdb->term_taxonomy;
        if (!isset($tableposts)) $tableposts = $wpdb->posts;
+
        if ($order != 'ASC') $order = 'DESC';
        if ('max_comment_date' == $orderby) { $add_recent_comment_to_sql = 1; }
        else {
@@ -55,7 +58,7 @@
        if ($add_recent_comment_to_sql) $sql = "SELECT $tableposts.*, MAX(comment_date) AS max_comment_date FROM $tablecomments, $tableposts ";
        else $sql = "SELECT DISTINCT * FROM $tableposts ";
        if ($categories) {
-               $sql .= "LEFT JOIN $tablepost2cat ON ($tableposts.ID = $tablepost2cat.post_id) ";
+               $sql .= "LEFT JOIN $tableterm_relationships ON ($tableposts.ID = $tableterm_relationships.object_id) LEFT JOIN $tableterm_taxonomy ON ($tableterm_relationships.term_taxonomy_id = $tableterm_taxonomy.term_taxonomy_id)";
                $cats = explode(' ', $categories);
        }
        $sql .= "WHERE $tableposts.post_date <= '$now' AND ( $tableposts.post_status = 'publish' ";
@@ -69,7 +72,7 @@
                foreach ($cats as $cat) {
                        if ($first) $first = 0;
                        else $sql .= "OR ";
-                       $sql .= "$tablepost2cat.category_id = '$cat' ";
+                       $sql .= "$tableterm_relationships.term_taxonomy_id = '$cat' ";
                }
                $sql .= ") ";
        }