<?php
// Run Ruby Script Variables
$ruby_script_path = "helpdeskhistory.rb";

// Get SQL output Variables
$host = "physics.ucsd.edu";
$username = "xxx";
$password = "xxx";
$database = "helpdesk";

function getSQLResults($sql, &$error) {
        global $host, $username, $password, $database;

        $db = openSQL($error);
        if($db === false)
                return false;

        // Run SQL query
        $res = mysql_query($sql, $db);
        if($res === false) {
                $error = mysql_error($db);
                return false;
        }

        // Build results table
        if(mysql_num_rows($res) == 0)
                return true;
        $ret = array();
        while($row = mysql_fetch_assoc($res)) {
                $ret[] = $row;
        }
        mysql_free_result($res);
        return $ret;
}

function openSQL(&$error) {
        // Prep SQL connection
        $db = mysql_connect($host, $username, $password);     # ERROR HERE
        if($db === false) {
                $error = mysql_error($db);
                return false;
        }
        if(!mysql_select_db($database, $db)) {
                $error = mysql_error($db);
                return false;
        }
        return $db;
}

function updateTicket($id) {
        global $update;

        $db = openSQL($error);
        if($db === false)
                die("Error in step 4 (update ticket): ".$error);

        $thesql = str_replace("%%ID%%", $id, $update);
        $res = mysql_query($thesql);
        if($res === false)
                die("Error in step 4 (update ticket): ".mysql_error());
}
?>