$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");