prepare("SELECT * FROM b_page WHERE page_area='default' and page_issystem =0"); $sth -> execute(); $pages = $sth -> fetchAll(PDO::FETCH_OBJ); /* Get all page tagging info */ $sth = $dbh -> prepare('SELECT * FROM b_tagging WHERE 1'); $sth -> execute(); $tagging_raw = $sth -> fetchAll(PDO::FETCH_OBJ); $page_tag = array(); $tag = array(); foreach($tagging_raw as $tag_raw) { if(!isset($page_tag[$tag_raw -> tag_page_id])) { $page_tag[$tag_raw -> tag_page_id] = array(); } $page_tag[$tag_raw -> tag_page_id][] = $tag_raw -> tag_label; $tag[$tag_raw -> tag_label] = $tag_raw -> tag_label; } ?> http://mike.bitrevision.com/blog/ Sat, 1 March 2014 20:32:22 +1000 http://wordpress.org/?v=MU en 1.0 http://mike.bitrevision.com/ http://mike.bitrevision.com/blog $t\n"; } ?> \n"; echo "\t\t\n"; echo "\t\t\n"; echo "\t\thttp://mike.bitrevision.com/blog/" . $page -> page_short . "\n"; echo "\t\thttp://mike.bitrevision.com/blog/" . $page -> page_short . "\n"; echo "\t\t\n"; echo "\t\t page_body . "]]>\n"; echo "\t\t" . $page -> page_id . "\n"; echo "\t\t" . $page -> page_date_created . "\n"; echo "\t\t" . $page -> page_date_created . "\n"; echo "\t\tclosed\n"; echo "\t\tclosed\n"; echo "\t\t" . ($page -> page_ispublished == 0 ? 'draft' : 'publish') . "\n"; echo "\t\t". ( $page -> page_isfeed == 1 ? 'post' : 'page' ) ."\n"; echo "\t\t" . $page -> page_short . ""; echo "\t\t0\n"; if(isset($page_tag[$page -> page_id])) { foreach($page_tag[$page -> page_id] as $t) { echo "\t\t\n"; echo "\t\t\n"; } } echo "\t\n"; } ?>