<?php

      set_magic_quotes_runtime(0);

      function db_connect($db='')
      {
        $email = 'your_name@to.far.out';
        $user = 'username';
	$pass = 'password';
	$host = 'your.boxes.hostname';  /* output from: uname -n */
	if (empty($db))
	  $db = 'your_default_db_name';
	

        if (!@mysql_pconnect(':/tmp/mysql.sock',$user,$pass))
        {
          if (!@mysql_pconnect('127.0.0.1',$user,$pass))
          {
            if (!@mysql_pconnect($host,$user,$pass))
            {
              $message = "The was a problem connection to the DB at $host\n"
                       . "Here is the error: " . mysql_error() . "\n";

              mail($email,'MYSQL ERRER @ '.$host,$message); 
              return 0;
            }
          }
        }
        else
        {
          if (!mysql_select_db($db))
          {
              $message = "The was a problem connection to the $db DB at $host\n"
                       . "Here is the error: " . mysql_error() . "\n";

              mail($email,'MYSQL ERRER @ '.$host,$message); 
              return 0;
          }
        }
        return 1;
      }

      function no_cache_headers() 
      {
        header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
        header("Cache-Control: no-cache, must-revalidate");
        header("Pragma: no-cache");
        header("Expires: 0");
      }

      function my_redir($location)
      {
        header('302');
        header('Location: '.$location);
        exit();
      }

      function my_proto()
      {
        global $HTTP_HOST;

        switch($SERVER_PORT)
        {
          case '443':
            $proto = 'https://';
            break;
          case '80':
          default:
            $proto = 'http://';
            break;
        }
        return $proto;
      }

      /**
      This is the schema for the log table used in the my_logme() function.
      
      CREATE TABLE logs (
        id int(9) unsigned DEFAULT '0' NOT NULL auto_increment,
        request_uri varchar(50) DEFAULT '' NOT NULL,
        host_name varchar(25) DEFAULT '' NOT NULL,
        remote_addr varchar(15) DEFAULT '0.0.0.0' NOT NULL,
        http_referer blob NOT NULL,
        user_agent varchar(75) DEFAULT '' NOT NULL,
        ts int(9) unsigned DEFAULT '0' NOT NULL,
        PRIMARY KEY (id),
        KEY request_uri (request_uri),
        KEY user_agent (user_agent),
        KEY ts (ts)
      );
      **/

      function my_logme()
      {
        global $HTTP_HOST, $REQUEST_URI, $HTTP_REFERER, $HTTP_USER_AGENT, $REMOTE_ADDR;

        /** Don't log if it is us **/
        if ($REMOTE_ADDR == 'xxx.xxx.xxx.xxx' || $REMOTE_ADDR == 'xxx.xxx.xxx.xxx' || ereg('xxx\.xxx\.xxx',$REMOTE_ADDR))
          return TRUE;

        $ts = time();

        $q = "INSERT into logs set request_uri='$REQUEST_URI', host_name='$HTTP_HOST', remote_addr='$REMOTE_ADDR', http_referer='$HTTP_REFERER', user_agent='$HTTP_USER_AGENT', ts=$ts";
        mysql_query($q);
        return TRUE;
      }

      function my_last_modified_format($ts=0)
      {
        if ($ts == 0) 
          $ts = time();
        $string = gmdate('D, j M Y G:m:s ') . 'GMT';
        return $string;
      }

      function parse_session_cookie($required=0)
      {
        global $session_cookie, $SCRIPT_NAME;

        switch($required)
        {
          case 1:
            if (!check_session())
              my_redir('/admin/login.html?rd='.urlencode($SCRIPT_NAME));
            break;

          case 0:
          default:
            break;
        }
        return TRUE;
      }

      function check_login($userID, $password)
      {
        $q = "SELECT count(*) as rows from accounts where userID='$userID' && password='$password'";
        $r = mysql_query($q);
        if ($r)
        {
          $valid = (int)mysql_result($r,0);
          mysql_free_result($r);
          return $valid;
        }
        else
          return FALSE;
      }

      function add_session($userID)
      {
        global $REMOTE_ADDR;
        $sessionID = md5($REMOTE_ADDR.$userID.microtime());
        $q = "REPLACE INTO sessions set userID='$userID', sessionID='$sessionID'";
        mysql_query($q);
        $time = time() + 3600;
        setcookie('session_cookie',urlencode("$userID\t$sessionID"), $time,  '/', '.jeremybrand.com');
      }

      function check_session()
      {
        global $session_cookie;
        $tmp = explode("\t", urldecode($session_cookie));
        $sessionID = $tmp[1];
        $expire = (int)date('YmdHis',time()-3600);
        $q = "SELECT count(*) as rows from sessions where sessionID = '$sessionID' && starttime > $expire";
        $r = mysql_query($q);
        if ($r)
        {
          $valid = (int)mysql_result($r,0);
          mysql_free_result($r);
          return $valid;
        }
        else
          return FALSE;
      }


?>