<?php

    /* To set this up, add the following to your .htaccess file:
        ErrorDocument 404 /404.php
    */
       
    // My credentials. I block folks from grabbing them.
    @include('cred.inc');
    $targ = strtolower(str_replace('/','',getEnv('SCRIPT_URL')));
    
    // "notfound.php" does whatever you want to do when the search
    //  fails. That's what's building the search link for me.
    //  It's also the failout case if there's a problem with the
    //  database.
    $dbh = new PDO("mysql:host={$db['host']};dbname={$db['db']}",
        $db['user'],
        $db['pass']);
    if (!$dbh)
        include('notfound.php');
    // a bit of cleanup.
    $dbh->exec("delete from {$db['table']} where (expires != 0 AND expires < unix_timestamp(now()))");
    $sth=$dbh->prepare("select url from {$db['table']} where name = ?");
    // batten down the hatches, User Input Ahead!
    $targ = preg_replace("/([%_])/","\\$1",$targ);
    $targ = preg_replace("/[<>]/","",$targ);
    $targ = substr($targ,0,50);
    if (!$sth->execute(Array($targ)) || $sth->rowcount() == 0)
        include('notfound.php');        
    else
    {
        $data = $sth->fetch($result);
        header('Location: '.$data[0],true,302);
        error_log("302: [$targ] referer:".getenv('REFERER'));
    }
    @include("./piwik.inc");
?>