<?php
  if (isset($db)) $db->close();
  $db = &new PostgreSQL('localhost','site_manager','site_db','site_manage',$_SERVER['PHP_SELF']);
  if (defined('CNT_SERVER'))
    $server = CNT_SERVER;
  else
    $server = 'R123';
  if (!$db)
    trigger_error ("Unable to open admin database in robots.txt.");
  else
    {
    $updated = false;
    $host_ip = $_SERVER['REMOTE_ADDR'];
    if (!isset($_SERVER['HTTP_USER_AGENT']))
      {
      trigger_error ("No user agent when reading robots.txt, IP = {$_SERVER['REMOTE_ADDR']}, redirected to home page");
      header("Location: ".THIS_HOST."index.php");
      exit;
      }
    $user_agent = $_SERVER['HTTP_USER_AGENT'];
    $sql = "SELECT site_acc_id FROM site_acc WHERE link_type='R' AND user_agent='$user_agent'";
    $rc = $db->query($sql);
    if ($rc->size() > 0)
      {
      $sql = "SELECT site_acc_id FROM site_acc WHERE link_type='R' AND server='$server' AND user_agent='$user_agent'";
      $rc = $db->query($sql);
      if ($rc->size() > 0)
        {
        $dat = $rc->fetch();
        $sql = "UPDATE site_acc SET acc_dt='".time()."', ip_addr='$host_ip', count=count+1 WHERE site_acc_id='{$dat['site_acc_id']}'";
        $rc = $db->query($sql);
        if ($rc->isError())
          trigger_error ("Failed to update site_acc table (R)");
        $updated = true;
        }
      elseif ($rc->isError())
        trigger_error ("Failed to access site_acc table (R)");
      }
    if (!$rc->isError() and !$updated)
      {
      if (isset($_SERVER['HTTP_REFERER']))
        $referer = $_SERVER['HTTP_REFERER'];
      else
        $referer = '';
      if ($referer)
        $sql = "INSERT INTO site_acc (ip_addr, link_type, acc_dt, user_agent, referer, server) VALUES ('$host_ip', 'R', '".time()."', '$user_agent', '$referer','$server')";
      else
        $sql = "INSERT INTO site_acc (ip_addr, link_type, acc_dt, user_agent,server) VALUES ('$host_ip', 'R', '".time()."', '$user_agent','$server')";
      $rc = $db->query($sql);
      if ($rc->isError())
        trigger_error ("Failed to insert into site_acc table (R)");
      }
    }
?>
User-agent: *
<?php
  if ($host_ip == '192.168.6.12')
    print ("Disallow: /emmettseesthebot/\n");
?>
Disallow: /pollywantsacracker2223/
Disallow: /cgi-bin/
Disallow: /mailman/
Disallow: /images/
Disallow: /contact.php
Disallow: /events/
Disallow: /pre-course/
Disallow: /archive/
Disallow: /site/
Disallow: /templates/
Disallow: /member/