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