";
//echo "Time is: ".$curTime."
";
//check if entry already exists
$connection = mysql_connect($db_hostname, $db_username, $db_password);
if (!$connection) die("Unable to connect to MYSQL: " . mysql_error());
mysql_select_db($db_database)
or die("Unable to select database: " . mysql_error());
$query= "SELECT * FROM OM_titlesusage WHERE titleid='".$titleID."' and mediaid='".$mediaID."' and datestamp='".$curDate."'";
//echo $query;
$result = mysql_query($query);
$rowsnum = mysql_num_rows($result);
$query = "";
if ($rowsnum == 0) //0 means insert
{
$query = "INSERT INTO OM_titlesusage (titleid, mediaid,";
if ($curTime <= 1600) //before 4pm (1600 military time)
$query = $query." timeperiod1,";
elseif ($curTime <= 1900) //after 4pm and before 7pm (1900 military time)
$query = $query." timeperiod2,";
else //(current time > 7:00pm)
$query = $query." timeperiod3,";
$query = $query." datestamp) VALUES ('".$titleID."', '".$mediaID."', '1', '".$curDate."')";
}
else //type == 1
{
$query = "UPDATE OM_titlesusage SET";
if ($curTime <= 1600)
$query = $query." timeperiod1 = timeperiod1 + 1";
elseif ($curTime <= 1900)
$query = $query." timeperiod2 = timeperiod2 + 1";
else //(current time > 7:00pm)
$query = $query." timeperiod3 = timeperiod3 + 1";
$query = $query." WHERE titleid='".$titleID."' and mediaid='".$mediaID."' and datestamp='".$curDate."'";
}
//$result = mysql_query($query);
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
//echo "
query is: ".$query;
//echo "
result is: ".$result;
//echo "time ID: ".$timeID." title ID: ".$titleID." media ID: ".$mediaID." query: ".$query."result is: ".$result;
?>
