<?

  //error_reporting(E_ALL);
  //ini_set('display_errors', '1');

  require_once('../wp-config.php');

  // This is a script to redirect from an cake-url to the new url
  // Example url is http://www.autojunk.nl/pix/view/937 (zie ook http://www.autoblog.nl/pivot/entry.php?id=3710 )
  // Example url is http://www.autojunk.nl/pix/show/151442/1

  function path_get_last_arg($path){
    $path = str_replace('\\', '/', $path); 
    $path = preg_replace('/\/+$/', '', $path);
    $path = explode('/', $path);
    $l = count($path)-1;
    return isset($path[$l]) ? $path[$l] : '';
  }

  global $wpdb;

  $aj_seq = "";
  $cur_url = $_SERVER['REQUEST_URI'];
  // Remove optional parameters:
  $text_bits = explode("?",$cur_url);
  $cur_url = $text_bits[0];
  // Check the address:
  $pos_pix_show = stristr($cur_url, "pix/show");
  $pos_pix_view = stristr($cur_url, "pix/view");
  // get the last argument (ID)
  $aj_id = path_get_last_arg($cur_url);
  if ($pos_pix_show === false) { 
    // No "pix/show" string found... we are in pix/view
    //echo "<!-- 1 : " . $aj_id . " -->";
  } else {
    // We are in pix/show... get the sequence number:
    if (strlen($aj_id)==1) {
      $aj_seq = $aj_id;
      $cur_url = substr("$cur_url", 0, -2);
    } elseif (strlen($aj_id)==2) {
      $aj_seq = $aj_id;
      $cur_url = substr("$cur_url", 0, -3);
    } else {
      // sequence is too long?
    }
    $aj_id = path_get_last_arg($cur_url);
    //echo "<!-- 2 : " . $aj_id . " : " . $aj_seq . " -->";
  }

  $results = $wpdb->get_results("SELECT * FROM wp_6_postmeta m, wp_6_posts p WHERE p.ID = m.post_id AND m.meta_key='aj_id' AND m.meta_value='" . $aj_id . "'");

  if (count($results)==0) {

    //echo "No Entry found for ID " . $aj_id;
    header("Location: /404/" . $aj_id );

  } else {

    foreach ($results as $result) {

	if ($pos_pix_show === false) { 

		$perm = get_permalink($result->post_id);

	} else {

		$perm = "/fotos/".$result->post_name."/".$result->post_id."/".$aj_seq;
	}

	// Redirect browser
	header("Location: " . $perm );
    }

  }

?>