--errorpage.php--

include_once("includes/config.php");

//see if the site is setup for transistiong from an old version of the site
//$_SESSION[old_site_url] is set in the config file- this is were the old copy of the site can be accessed
//$_SESSION[enable_old_site_matching] is a boolean var I've set up to see if we're running this site mapping script

if($_SESSION[enable_old_site_matching]==1 && $_SESSION[old_site_url])
{
        $oldsitepath = str_replace("http://".$_SERVER['HTTP_HOST'],$_SESSION[old_site_url],$_SERVER['SCRIPT_URI']);

        //see if this page has been mapped already
        $query = "SELECT * FROM site_old_new_mapping WHERE old_link = '$oldsitepath' ";
        $result = mysql_query($query,$_GET[dbh]) OR die(mysql_error());
        $row=mysql_fetch_assoc($result);

        if($row[sm_id])
        {
                if($row[page_id])
               {
                    //we found an entry, now send them to the previously mapped page
                    header("HTTP/1.1 301 Moved Permanently");
                    header("Location: /goto.php?page_id=$row[page_id]");
               }
        }
        else //if this page hasn't been mapped yet, add it!
        {
                $INquery = "INSERT INTO site_old_new_mapping(old_link) VALUES('$oldsitepath')";
                mysql_query($INquery,$_GET[dbh]) OR die(mysql_error());
                //save this ID for the goto.php, where we will map this person's selection
                $sitemap_id = mysql_insert_id($_GET[dbh]);
        }

        //read the old page, from the old site, into an array
        $phile = @file($oldsitepath);
        if(is_array($phile))
        {
                $page = implode('',$phile);
                $title = pagesTextBetween(":", "",pagesTextBetween("title>", "

        }
        else $nosuchfile = 1;

        if($title)
        {
                //perform search
                $searchwords = str_replace(""",""",$title);
                $query = "SELECT page_title,page_url,page_id FROM page WHERE (MATCH(page_title) AGAINST('$title')) GROUP BY page_id";
                $result = mysql_query($query) OR die(mysql_error());
                $num = mysql_num_rows($result);

 

                if($num < 1)
                {
                        $note = "

There are no items that fit your search. Try using different search words.
";
                }
                else
                {
                        $cnote = 1;
                        $row[page_title] = stripslashes($row[page_title]);
                        $row[page_summary] = stripslashes($row[page_summary]);
                        while($row=mysql_fetch_array($result))
                        {
                                $possibilities[] = "

$row[page_title] ($row[page_url])

";
                        }
                }
        }

}

 

?>

--body of page--

--goto.php page--

//goto.php
//takes a page_id, looks up the url path and sends them on their way

include_once("includes/config.php");
if($_GET[page_id] || $_GET[page])
{
      $page_id = $_GET[page_id];
      if($_GET[anchor]) $extra = "#$_GET[anchor]";
      if($_GET[queri]) $queri = "?" . base64_decode(urldecode($_GET[queri]));

      //get page location
      if($_GET[page_id]) $query = "SELECT page_url, external_url FROM page WHERE page_id = '$page_id' ";
      elseif($_GET[page]) $query = "SELECT page_url, external_url FROM page WHERE page_url LIKE '%$_GET[page]%' ";
      $result = mysql_query($query,$_GET[dbh]) OR die(mysql_error());
      $row=mysql_fetch_assoc($result);
      if(is_array($row))
      {
            if($_SESSION[user_level]<2) $url = "$_GET[url]/$row[page_url]/index.php";
            else $url = "$_GET[url]/$row[page_url]/";

            //check if this is sitemapping link. If so, insert the selection
            if($_GET[updatemapping])
            {
                //update URL in site_old_new_mapping table
                $Uq = "UPDATE site_old_new_mapping SET page_id = $_GET[updatemapping] ";
                mysql_query($Uq,$_GET[dbh]);
                
            }

            if($row[external_url]>'') header("Location: $row[external_url]".$queri.$extra);
            else header("Location: $url".$queri.$extra);
      }
      else header("Location: /index.php?page_id=$page_id".$queri.$extra);
}
?>

--MySQL table `site_old_new_mapping`--

CREATE TABLE `site_old_new_mapping` (
`sm_id` bigint(20) NOT NULL auto_increment,
`old_link` varchar(200) NOT NULL default '',
`page_id` bigint(20) NOT NULL default '0',
`manual_link` varchar(200) NOT NULL default '',
`ignored` tinyint(1) NOT NULL default '0',
`pages_with_old_link` varchar(255) NOT NULL default '',
PRIMARY KEY (`sm_id`),
KEY `old_link` (`old_link`),
KEY `page_id` (`page_id`),
KEY `ignore` (`ignored`),
KEY `pages_with_old_link` (`pages_with_old_link`),
KEY `manual_link` (`manual_link`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='maps 404 pages to existing pages' AUTO_INCREMENT=31415 ;