function make_production_at_venue_url($eventName, $city)
{
$sanitizedEventName = strtolower(_prepare_url_text($eventName));
$sanitizedCity = strtolower(_prepare_url_text($city));
$url = SITE_DOMAIN . "/{$sanitizedEventName}-tickets-{$sanitizedCity}/";
return $url;
}
function InsertIntoEvents_temp($eid, $ename, $raw_ename, $etypeid, $cid, $eventRank)
{
$san_ename = strtolower(_prepare_url_text($ename));
# $san_ename = str_replace( '-at-', '-' , $san_ename);
$san_raw_ename = strtolower(_prepare_url_text($raw_ename));
if (strlen($san_raw_ename) < 1 || strlen($raw_ename) < 1 || $raw_ename == '!!!') {
#skip
} else {
$bsql = "INSERT INTO Events_temp " . "(EventID,EventName,EventTypeID,SanitizedEventName,CategoryID,EventRank) " . "VALUES ('{$eid}', '{$ename}', '{$etypeid}', '{$san_ename}', '{$cid}', '{$eventRank}');";
$insert_result = mysql_query($bsql) or die('InsertIntoEvents_temp: query failed: ' . mysql_error() . '\\n' . "{$eid}, {$ename}, {$etypeid}, {$cid}, {$eventRank}");
}
}
$venueName = $table_row[1];
$eventDate = preg_replace('/11:59 PM$/', 'TBD', $table_row[2]);
$city = utf8_decode($table_row[3]);
$regionCode = $table_row[4];
$venueID = $table_row[5];
$eventName = $table_row[6];
$categoryID = $table_row[7];
$eventTypeID = $table_row[8];
$oppEventName = $table_row[9];
$shortNote = $table_row[10];
$shortDate = $table_row[11];
$sanitizedVenueName = $table_row[12];
$secondaryEventID = $table_row[13];
}
}
$sanitizedCity = strtolower(_prepare_url_text($city));
$city_check_result = 1;
if (strlen($givenSanitizedCity) > 0 && $sanitizedCity != $givenSanitizedCity) {
$city_check_result = 0;
}
if (!($num_rows > 0 && ($eventID == $inEventID || $secondaryEventID == $inEventID) && $city_check_result == 1)) {
# echo '<br/>' . "in event id = $inEventID, opp ev id = $secondaryEventID ev id = $eventID";
handle_error_no_exit('tickets.new_urls.php: EventID=' . $eventID . ' and prodid = ' . $id . ' lookup returned 0 results: attempting to find appropriate redirect, uri= ' . $_SERVER['REQUEST_URI'] . ' ');
if ($query_result = mysql_query('SELECT EventName FROM Events WHERE EventID = ' . $inEventID)) {
$url = '';
while ($table_row = mysql_fetch_array($query_result)) {
$redirEventName = $table_row['EventName'];
}
if (strlen($redirEventName) < 0) {
handle_error_no_exit('tickets.new_urls.php: redirecting production id=' . $id . ' eventid=' . $_REQUEST['event_id'] . ' from uri= ' . $_SERVER['REQUEST_URI'] . ' to home, returning 301');
redir_301();
<?php
#
# Copyright (c) 2007, Jassen Moran. All rights reserved.
# MongoTickets.com Confidential Proprietary.
#
require_once '../include/new_urls/ticket_db.php';
include '../include/error.php';
include '../include/new_urls/url_factory.inc.php';
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db("mongo_tickets2");
$query = "SELECT CategoryName,CategoryID FROM AdjacencyListCategories WHERE 1";
if ($query_result = mysql_query($query)) {
$adjCats = array();
while ($table_row = mysql_fetch_row($query_result)) {
$catName = $table_row[0];
$catID = $table_row[1];
$adjCats[$catID] = strtolower(_prepare_url_text($catName));
print ".";
}
foreach ($adjCats as $id => $sanCatName) {
$bsql = "UPDATE AdjacencyListCategories SET SanitizedCategoryName= '" . $sanCatName . "' WHERE CategoryID=" . $id;
$query_result = mysql_query($bsql) or print ': ' . mysql_error();
}
}
mysql_close($dbh);
} else {
handle_error_no_exit('sanitize_AdjacencyListCategories.php: I cannot connect to the database because: ' . mysql_error());
}
# end if no data
}
}
} else {
print_message("No result");
}
}
}
# } # end while
// kill object
unset($soapclient);
# 'Unknown Venue'
mysql_query("DELETE FROM Venues_temp WHERE VenueName LIKE '%Unknown Venue%'");
$venueID_url_mod_list = array(262, 784, 1623, 1625, 329, 410, 621, 1457, 147, 180, 716, 928, 3986, 4194, 4344, 2890, 3970, 3287, 4714, 4158, 2786, 4759, 5159, 5207, 5580, 5479, 5670, 5522, 5885, 1070, 4056, 5473, 6468, 6544, 8542, 8879, 8921, 1754, 3915, 4382);
foreach ($venueID_url_mod_list as $vid) {
$bsql = "UPDATE Venues_temp SET SanitizedVenueName=(SELECT Concat(SanitizedVenueName,'-event') from (select * from Venues_temp) as x WHERE VenueID={$vid}) WHERE VenueID={$vid}";
$query_result = mysql_query($bsql) or die('UPDATE Venues_temp SET SanitizedVenueName failed: ' . mysql_error());
}
$venueName_reName_list = array(1967 => 'Wisconsin State Fairgrounds', 1547 => 'Bank of America Theatre', 1596 => 'Saint Paul Rodeo', 6162 => 'Monterey Jazz Festival CA', 5145 => 'Chicago City Limits Venue', 5273 => 'The Station Venue', 5806 => 'Oregon Jamboree Venue', 6216 => 'High Fidelity Venue', 6687 => 'The Graduate Venue', 7113 => 'Tribeca Film Festival NY', 7272 => 'Circus Flora - St. Louis', 7275 => 'ComedySportz - Chicago');
foreach ($venueName_reName_list as $vid => $new_vname) {
$san_vname = strtolower(_prepare_url_text($new_vname));
$bsql = "UPDATE Venues_temp SET VenueName='{$new_vname}',SanitizedVenueName='{$san_vname}' WHERE VenueID={$vid}";
$query_result = mysql_query($bsql) or die('UPDATE Venues_temp SET VenueName renme failed: ' . mysql_error());
}
mysql_close($dbh);
if ($num_venues_returned < 1) {
print_message("No venues returned, exiting...");
die;
}
print_message("Done.");
print_message("Finished Importing Venues.\n\n\n");
# Preconditions:
# 1) AdjacencyListCategories_temp created
# 2) ModifiedPreorderTreeTraversalCategories_temp not created
require_once '../include/ticket_db.php';
require_once 'err.php';
require_once '../include/url_factory.inc.php';
print_message("Creating Additional Categories.......");
$dbh = mysql_connect($host_name, $db_username, $db_password) or die('CreateAdditionalCategories: I cannot connect to the database because: ' . mysql_error());
mysql_select_db($db_name);
$inputFile = "AdditionalCategories.csv";
$categoryRank = 2000;
print_message("Processing {$inputFile}.......");
$fh = fopen($inputFile, "r") or die('CreateAdditionalCategories: Cannot open ' . $inputFile . "\n");
# data format is:
# CategoryName CategoryID ParentCategoryID
# (0 (1) (2)
# skip over first line
$data = fgetcsv($fh, 1000, ",");
while (($data = fgetcsv($fh, 1000, ",")) !== FALSE) {
$cat_name = mysql_escape_string($data[0]);
$cat_id = $data[1];
$parent_cat_id = $data[2];
$bsql = "INSERT INTO AdjacencyListCategories_temp (CategoryID, CategoryName, SanitizedCategoryName, ParentCategoryID, CategoryRank)" . "VALUES (" . $cat_id . ",'" . $cat_name . "','" . strtolower(_prepare_url_text($cat_name)) . "','" . $parent_cat_id . "','" . $categoryRank . "');";
$query_result = mysql_query($bsql) or print 'CreateAdditionalCategories: ' . mysql_error();
}
fclose($fh);
mysql_close($dbh);
print_message("CreateAdditionalCategories: Done.");
?>
<?php
#
# Copyright (c) 2007, Jassen Moran. All rights reserved.
# Quad tickets Confidential Proprietary.
#
// include the SOAP classes
require_once '../lib/nusoap.php';
require_once '../include/new_urls/ticket_db.php';
require_once '../include/EventInventoryWebServices.inc.php';
require_once 'err.php';
require_once '../include/mail.php';
require_once '../include/new_urls/url_factory.inc.php';
print_message("Preparing database for Event import....... ");
$dbh = mysql_connect($host_name, $db_username, $db_password) or die('I cannot connect to the database because: ' . mysql_error());
mysql_select_db($db_name);
$eventName_mod_list = array(14255 => 'Ourglass Concert', 8405 => 'Strunz n Farah', 14340 => 'The Jena Six Empowerment Concert');
foreach ($eventName_mod_list as $eid => $ename) {
$san_ename = strtolower(_prepare_url_text($ename));
$bsql = "UPDATE Events SET EventName='{$ename}',SanitizedEventName='{$san_ename}' WHERE EventID={$eid}";
$query_result = mysql_query($bsql) or die('UPDATE Events_temp SET EventName failed: ' . mysql_error());
}
mysql_close($dbh);
if ($result) {
if (isset($result['faultstring'])) {
print_message("Error:" . $result['faultstring']);
mysql_close($dbh);
die;
} else {
$categoryRank = 2000;
$root = $result['ROOT'];
if (isset($root['MESSAGE'])) {
print_message($root['MESSAGE']);
} else {
$num_categories_returned++;
$data = $root['DATA'];
$row = $data['row'];
for ($i = 0; $i < count($row); $i++) {
$bsql = "INSERT INTO AdjacencyListCategories_temp (CategoryID, CategoryName, SanitizedCategoryName, ParentCategoryID, CategoryRank)" . "VALUES (" . $row[$i]['!CategoryID'] . ",'" . $row[$i]['!CategoryName'] . "','" . strtolower(_prepare_url_text($row[$i]['!CategoryName'])) . "','" . $row[$i]['!ParentCategoryID'] . "','" . $categoryRank . "');";
$query_result = mysql_query($bsql) or die('INSERT INTO AdjacencyListCategories_temp query failed: ' . mysql_error());
}
}
}
} else {
print_message("No result");
mysql_close($dbh);
die;
}
}
}
// kill object
unset($soapclient);
print_message("Done.");
print_message("Deleting unused Categories....");
<?php
#
# Copyright (c) 2007, Jassen Moran. All rights reserved.
# MongoTickets.com Confidential Proprietary.
#
require_once '../../include/ticket_db.php';
require_once '../../include/host_info.inc.php';
include '../../include/error.php';
include '../../include/url_factory.inc.php';
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db("mongo_tickets2");
echo 'here';
$query = "SELECT EventName,EventID FROM Events WHERE EventID=107";
if ($query_result = mysql_query($query)) {
while ($table_row = mysql_fetch_row($query_result)) {
$eventName = $table_row[0];
$eventID = $table_row[1];
$sanitized_eventName = _prepare_url_text(mysql_escape_string($eventName));
$bsql = "UPDATE Events SET SanitizedEventName= " . $sanitized_eventName . " WHERE EventID=" . $eventID;
$query_result = mysql_query($bsql) or print 'sanitize_events_categories.php: ' . mysql_error();
# $url = make_event_url($eventName, $id);
}
}
mysql_close($dbh);
} else {
}
function make_venues_url($venueName, $venueID)
{
$urlVenueName = _prepare_url_text($venueName);
$url = SITE_DOMAIN . "/venues/{$urlVenueName}-Tickets-V{$venueID}.html";
return $url;
}
# {
$num_venues++;
$vid = $data['ID'];
$vname = mysql_escape_string($data['Name']);
$addr1 = mysql_escape_string($data['Street1']);
$addr2 = mysql_escape_string($data['Street2']);
$city = mysql_escape_string($data['City']);
$maid = 1;
$rcode = mysql_escape_string($data['ZipCode']);
$ccode = mysql_escape_string($data['Country']);
$pcode = mysql_escape_string($data['ZipCode']);
$phone = mysql_escape_string($data['BoxOfficePhone']);
$san_vname = strtolower(_prepare_url_text($vname));
# $san_vname = str_replace( '-at-', '-' , $san_vname );
$san_rc = strtolower(_prepare_url_text(utf8_decode($rcode)));
$san_city = strtolower(_prepare_url_text(utf8_decode($city)));
$bsql = "INSERT INTO TNDVenues_temp" . "(VenueID, VenueName, SanitizedVenueName, Address1, Address2, City, SanitizedCity, MarketAreaID, RegionCode, SanitizedRegionCode, CountryCode, PostalCode, Phone) " . "VALUES ('{$vid}', '{$vname}', '{$san_vname}', '{$addr1}', '{$addr2}', '{$city}', '{$san_city}', '{$maid}', '{$rcode}', '{$san_rc}', '{$ccode}', '{$pcode}', '{$phone}');";
$insert_result = mysql_query($bsql) or die('query failed: ' . mysql_error() . '\\n' . "{$vid}, {$vname}, {$san_vname}, {$addr1}, {$addr2}, {$city}, {$san_city}, {$maid}, {$rcode}, {$san_rc}, {$ccode}, {$pcode}, {$phone}");
#
# } # end for
}
# end if no data
}
} else {
echo "No result";
}
}
}
# } # end while
// kill object
unset($soapclient);
