<?php
// redirect requests to dynamic to their keyword rich versions
require_once '../include/oodle.inc.php';
// load configuration
// load URL factory
require_once '../include/new_urls/url_factory.inc.php';
require_once '../include/new_urls/ticket_db.php';
include_once '../include/error.php';
require_once '../public_html/DbUtils.new_urls.php';
require_once '../public_html/Utils.php';
// create the object
$feed = new Oodle();
# make mainpage url
# get all categories
# create category urls
# get all events
# create event urls
#
// add sitemap items
# YYYY-MM-DD
$dt = date("Y-m-d");
$event_type_array = array(2, 4);
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db($db_name);
foreach ($event_type_array as $event_type) {
if ($event_type == 2) {
$category = 'Concert Tickets';
} elseif ($event_type == 4) {
$category = 'Theater Tickets';
} else {
<?php
// redirect requests to dynamic to their keyword rich versions
require_once '../include/oodle.inc.php';
// load configuration
// load URL factory
require_once '../include/new_urls/url_factory.inc.php';
require_once '../include/new_urls/ticket_db.php';
include_once '../include/error.php';
require_once '../public_html/DbUtils.new_urls.php';
require_once '../public_html/Utils.php';
// create the object
$feed = new Oodle();
# make mainpage url
# get all categories
# create category urls
# get all events
# create event urls
#
// add sitemap items
# YYYY-MM-DD
$dt = date("Y-m-d");
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db($db_name);
$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']);
// redirect requests to dynamic to their keyword rich versions
require_once '../include/oodle.inc.php';
require_once '../include/oodle.category_map.inc.php';
// load configuration
// load URL factory
require_once '../include/new_urls/url_factory.inc.php';
require_once '../include/new_urls/ticket_db.php';
include_once '../include/error.php';
require_once '../public_html/DbUtils.new_urls.php';
require_once '../public_html/Utils.php';
$fh = fopen("C:\\HostedSitesApache\\MongoTickets_com\\dbmanager\\oodle_feed.log", 'a') or die("can't open file C:\\HostedSitesApache\\MongoTickets_com\\dbmanager\\oodle_feed.log");
$dt = date("Y-m-d");
$logtime = date("r");
fwrite($fh, "\n\n\n {$logtime}" . ": Starting oodle feed creator.\n");
// create the object
$feed = new Oodle();
$logtime = date("r");
fwrite($fh, " {$logtime}" . ": created oodle object.\n");
# make mainpage url
# get all categories
# create category urls
# get all events
# create event urls
#
// add sitemap items
# YYYY-MM-DD
$event_type_array = array(2, 4, 3);
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db($db_name);
foreach ($event_type_array as $event_type) {
if ($event_type == 2) {