$title .= " Tickets";
$eventDate = $table_row['event_date'];
$eventTimeRss = $table_row['event_time_rss'];
$eventDateTimeTitle = $table_row['event_date_title'];
if ($table_row['event_date_time_title'] != '11:59 PM') {
$eventDateTimeTitle .= ' ' . $table_row['event_time_title'];
}
$categoryID = $table_row['CategoryID'];
$venueName = $table_row['VenueName'];
$price = $table_row['MinCost'];
if (substr_count($price, '.') == 0) {
$price .= '.00';
}
$url = make_production_url($eventName, $prodID, $city, $event_type);
if (strlen($city) > 0) {
$feed->addItem($url, $category, $prodID, $title, $eventDate, $eventTimeRss, $venueName, $city, $regionCode, $postalCode, $price);
}
# else skip production
}
} else {
echo "Database error when getting Events!";
}
}
mysql_close($dbh);
} else {
handle_error_no_exit('main.code: I cannot connect to the database because: ' . mysql_error());
}
$feed->getOodle();
?>
$bsql = "SELECT MinCost, ProductionID, PostalCode, RegionCode, City, EventName, DATE_FORMAT(EventDate, '%Y-%m-%e') as event_date, DATE_FORMAT(EventDate, '%Y-%m-%eT%T-07:00') as event_time, DATE_FORMAT(EventDate, '%m/%e/%Y %r') as event_date_time_title, CategoryID, VenueName FROM Productions INNER JOIN Events ON (Events.EventID=Productions.EventID) INNER JOIN Venues ON (Venues.VenueID=Productions.VenueID) WHERE EventTypeID=2";
if ($query_result = mysql_query($bsql)) {
while ($table_row = mysql_fetch_array($query_result)) {
$prodID = $table_row['ProductionID'];
$postalCode = $table_row['PostalCode'];
$regionCode = $table_row['RegionCode'];
$city = utf8_decode($table_row['City']);
$eventName = $table_row['EventName'];
$eventDate = $table_row['event_date'];
$eventTime = $table_row['event_time'];
$eventDateTimeTitle = $table_row['event_date_time_title'];
$categoryID = $table_row['CategoryID'];
$venueName = $table_row['VenueName'];
$price = $table_row['MinCost'];
$url = make_production_url($eventName, $prodID, $city, 2);
if (strlen($city) > 0) {
$feed->addItem($url, 'Concert Tickets', $prodID, "{$eventName} {$eventDateTimeTitle} \${$price}", $eventDate, $eventTime, $venueName, $city, $regionCode, $postalCode, $price);
}
# else skip production
}
} else {
echo "Database error when getting Events!";
}
mysql_close($dbh);
} else {
handle_error_no_exit('main.code: I cannot connect to the database because: ' . mysql_error());
}
$feed->getOodle();
?>
if (substr_count($price, '.') > 0) {
list($whole_dollar_price, $dont_care) = split('\\.', $price);
} else {
$whole_dollar_price = $price;
}
$price2 = $whole_dollar_price + 6;
$price2 = $price2 . '.00';
$price3 = $price2 + 2;
$price3 = $price3 . '.00';
$price4 = $price3 + 11;
$price4 = $price4 . '.00';
if (substr_count($price, '.') == 0) {
$price .= '.00';
}
if (strlen($city) > 0) {
$feed->addItem(make_production_url($eventName, $prodID, $city, $event_type), $category, $prodID, $title, $eventDate, $eventTimeRss, $venueName, $city, $regionCode, $postalCode, $price, array('team' => $team));
$feed->addItem(make_production_url($eventName, $prodID, $city, $event_type), $category, $prodID, $title, $eventDate, $eventTimeRss, $venueName, $city, $regionCode, $postalCode, $price2, array('team' => $team));
$feed->addItem(make_production_url($eventName, $prodID, $city, $event_type), $category, $prodID, $title, $eventDate, $eventTimeRss, $venueName, $city, $regionCode, $postalCode, $price3, array('team' => $team));
$feed->addItem(make_production_url($eventName, $prodID, $city, $event_type), $category, $prodID, $title, $eventDate, $eventTimeRss, $venueName, $city, $regionCode, $postalCode, $price4, array('team' => $team));
}
# else skip production
}
} else {
$logtime = date("r");
fwrite($fh, " {$logtime}" . ": Database error when getting Events!");
echo "Database error when getting Events!";
}
}
mysql_close($dbh);
} else {
$logtime = date("r");
