<?php

//session_start();

include('./fancyurls.config.php');
include('./config.php');

// include libs plugins
//include($DIR_PLUGINS."related/nusoap.php");
//include($DIR_PLUGINS."related/utfconv.php");


$data = explode("/",serverVar('PATH_INFO'));
$blogid = intval($data[1]);
if (count($data) == 5) {
	$year = intval($data[1]);
	$month = intval($data[2]);
	$day = intval($data[3]);
	$title = $data[4];
	// 1. get timestamp and blogid for item
	$query  = 'SELECT iblog, inumber FROM '.sql_table('item').' WHERE iurltitle=\'' . $title . '\' ';
	$query .= "AND (YEAR(itime) = $year AND MONTH(itime) = $month AND DAYOFMONTH(itime) = $day)";
	
	$res = sql_query($query);
	if ($obj = mysql_fetch_object($res)){
	  // article found
  $blogid = $obj->iblog;
  $itemid = $obj->inumber;
	} else {
	  // look for old article syntax
	  $r=serverVar('PATH_INFO');
	  $query=mysql_query('SELECT inumber FROM '.sql_table('plugin_fancierurl').' WHERE iurltitle=\''.$r.'\'');
	  if ($obj = mysql_fetch_object($query)) 
 {
      $itemid = $obj->inumber;
  }
	  else {
      // new article syntax
      $r=substr(serverVar('PATH_INFO'),strrpos(serverVar('PATH_INFO'),'/')+1);
	    $query=mysql_query('SELECT inumber FROM '.sql_table('plugin_fancierurl').' WHERE iurltitle=\''.$r.'\'');
	    if ($obj = mysql_fetch_object($query)){
			 $itemid = $obj->inumber;
			}
    }
  }
} else {
 if (count($data) == 3 ||count($data) == 2) {
	$title = $data[1];
	// 1. get timestamp and blogid for item
	$query  = 'SELECT iblog, inumber FROM '.sql_table('item').' WHERE iurltitle=\'' . $title . '\' ';
	$res = sql_query($query);
	if ($obj = mysql_fetch_object($res)){
	  // article found
	 $blogid = $obj->iblog;
  $itemid = $obj->inumber;

	} else {
	  //look for old article title
	  $r=substr(serverVar('PATH_INFO'),strrpos(serverVar('PATH_INFO'),'/')+1);
	  $query=mysql_query('SELECT inumber FROM '.sql_table('plugin_fancierurl').' WHERE iurltitle=\''.$r.'\'');
	  if ($obj = mysql_fetch_object($query)) 
      $itemid = $obj->inumber;
    else
      $itemid = intval($data[1]);
  }
 }
 else
	  $itemid = intval($data[1]);
}
selector();
?>