<?php

$old_uri = parse_url($_GET['q'], PHP_URL_PATH);

$query = "SELECT guid FROM wp_posts LEFT JOIN wp_postmeta ".
    "ON (wp_posts.ID = wp_postmeta.post_id) WHERE ".
    "wp_postmeta.meta_key='blogger_permalink' AND ".
    "wp_postmeta.meta_value='$old_uri'";

$db = mysql_connect('localhost', 'pinehurstwp', '*ZZrFY%TZ%SB');
if (!$db) {
    print "no connection to db\n";
    exit(1);
}
$res = mysql_select_db('pinehurstwp', $db);
if (!$res) {
    print "failed to select db\n";
    exit(1);
}
$res = mysql_query($query, $db);

if (!$res) {
    print "not found\n";
} else {
    while ($row = mysql_fetch_assoc($res)) {
	$new_url = $row['guid'];
	header('HTTP/1.1 301 Moved Permanently');
	header("Location: $new_url");
	exit();
    }
}

?>