$title "); print_r($var); echo("

"); */ } function zecho($what) { //echo("

$what

"); } function zdie($what) { //die($what); } function bloginfo($option_name) { $query = sprintf("SELECT option_value FROM wp_options WHERE option_name='%s'", mysql_real_escape_string($option_name)); $result = mysql_query($query) or zdie('Query failed: ' . mysql_error()); dump($result, "mysql bloginfo result"); $num_rows = mysql_num_rows($result); zecho("$num_rows bloginfo found"); if ($num_rows == 1) { $option = mysql_fetch_object($result); echo $option->option_value; } else { return null; } } function get_bloginfo($option_name) { $query = sprintf("SELECT option_value FROM wp_options WHERE option_name='%s'", mysql_real_escape_string($option_name)); $result = mysql_query($query) or zdie('Query failed: ' . mysql_error()); dump($result, "mysql bloginfo result"); $num_rows = mysql_num_rows($result); zecho("$num_rows bloginfo found"); if ($num_rows == 1) { $option = mysql_fetch_object($result); return $option->option_value; } else { return null; } } function get_post_or_page($postname) { $query = sprintf("SELECT * FROM wp_posts WHERE post_name='%s'", mysql_real_escape_string($postname)); $result = mysql_query($query) or zdie('Query failed: ' . mysql_error()); dump($result, "mysql get_post_or_page result"); $num_rows = mysql_num_rows($result); zecho("$num_rows posts found"); if ($num_rows == 1) { $post = mysql_fetch_object($result); return $post; } else { return null; } } function get_main_category_for_post($post) { if ($post->post_type == 'page') { return null; } $query = sprintf("SELECT * FROM wp_categories as cat, wp_post2cat as ptocat WHERE ptocat.post_id=%d and cat.cat_ID=ptocat.category_id", mysql_real_escape_string($post->ID)); $result = mysql_query($query) or zdie('Query failed: ' . mysql_error()); dump($result, "mysql result"); $num_rows = mysql_num_rows($result); zecho("$num_rows categories found"); if ($num_rows > 0) { $category = mysql_fetch_object($result); return $category; } else { return null; } } function get_all_posts() { $query = "select * from wp_posts order by post_date desc"; $result = mysql_query($query) or zdie('Query failed: ' . mysql_error()); dump($result, "mysql result"); $num_rows = mysql_num_rows($result); zecho("$num_rows total posts found"); $posts = array(); while ($row = mysql_fetch_object($result)) { $posts[] = $row; } return $posts; } function get_link_to_post($post) { $link = "/"; $category = get_main_category_for_post($post); if ($category) { $link .= $category->cat_name . "/"; } $link .= $post->post_name . "/"; return $link; } function zheader($what, $replace, $status) { //echo("$what $status"); header($what, $replace, $status); } function main_redirect($raw_request) { zecho("raw_request $raw_request"); if (strlen($raw_request) > 0 && $raw_request != '/') { preg_match('/([^\/]*)\.html$/', $raw_request, $matches); if (count($matches) == 0) { preg_match('/([^\/]*)\/?$/', $raw_request, $matches); } dump($matches, "matches"); $post = get_post_or_page($matches[1]); if ($post) { zheader("Location: " . $post->guid, true, 301); } else { // 404 or index zheader("Location: " . get_bloginfo('siteurl') . $raw_request, true, 301); } } else { // 404 or index zheader("Location: " . get_bloginfo('siteurl') . $raw_request, true, 301); } } main_redirect($_SERVER['REQUEST_URI']); mysql_close($link); ?>