$from_table = $table . "_temp";
$old_table = $table . "_old";
print_message("RenameEventTable {$table} tables....");
$bsql = "DROP TABLE IF EXISTS {$old_table}";
$query_result = mysql_query($bsql) or die('RenameEventTable: ' . mysql_error());
print_message("Dropped table {$old_table}");
$bsql = "ALTER TABLE {$table} RENAME {$old_table}";
$query_result = mysql_query($bsql) or die('RenameEventTable: ' . mysql_error());
print_message("Renamed {$table} to {$old_table}");
$bsql = "ALTER TABLE {$from_table} RENAME {$table}";
$query_result = mysql_query($bsql) or die('RenameEventTable: ' . mysql_error());
print_message("Renamed {$from_table} to {$table}");
}
# select distinct Events.EventName from Events where Events.EventId not in (SELECT Events_old.EventId from Events_old);
send_an_email('*****@*****.**', 'Event table updates succeeded!!!!', 'Event table updates succeeded!!!!');
sleep(5);
$bsql = "SELECT distinct Events.EventName FROM Events WHERE Events.EventId NOT IN (SELECT Events_old.EventId FROM Events_old)";
$eventName = "";
if ($query_result = mysql_query($bsql)) {
while ($table_row = mysql_fetch_row($query_result)) {
if (strlen($eventName) == 0) {
$eventName = $table_row[0];
} else {
$eventName = "{$eventName}\n" . $table_row[0];
}
}
send_an_email('*****@*****.**', 'New Events!', "Events {$eventName} added!");
} else {
die('RenameEventTable: failed in table diff' . mysql_error());
}
mysql_close($dbh);
handle_error_no_exit("ImportEventsFromWS.php: " . $flt);
echo "SOAP Fault: (faultcode: {" . $flt->faultcode . "}\n" . "faultstring: {" . $flt->faultstring . " })";
}
// kill object
unset($soapclient);
$bsql = "DELETE FROM Events_temp WHERE EventID=1";
$query_result = mysql_query($bsql) or die('DELETE EventID=1 FROM Events_temp query failed: ' . mysql_error());
$eventName_mod_list = array(14255 => 'Ourglass Concert', 8405 => 'Strunz n Farah', 14340 => 'The Jena Six Empowerment Concert', 15874 => 'Revolution Dance', 18251 => 'BamaJam Music n Arts Festival', 19734 => 'Rebel Concert', 24620 => 'Mr Brown and Cora Comedy');
foreach ($eventName_mod_list as $eid => $ename) {
$san_ename = strtolower(_prepare_url_text($ename));
$bsql = "UPDATE Events_temp 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 ($num_events_returned < 1) {
send_an_email('*****@*****.**', 'No result!!!!', 'No result!!!!' . ${$root}['MESSAGE']);
print_message("No events returned, exiting...");
}
print_message("Done.");
print_message("{$num_events_returned} Events returned from Web Services");
print_message("Done.");
print_message("ImportEventsFromWS complete\n");
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}');";
<?php
#
# Copyright (c) 2007, Jassen Moran. All rights reserved.
# Quad tickets Confidential Proprietary.
#
require_once '../include/mail.php';
ini_set("sendmail_from", "*****@*****.**");
send_an_email('*****@*****.**', 'Test !!!!', 'Test ...!!!!');
require_once '../include/new_urls/url_factory.inc.php';
print_message("Creating URL Lookup table....... ");
$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);
$bsql = "DROP TABLE IF EXISTS UrlLookup_temp";
$query_result = mysql_query($bsql) or die('drop table failed: ' . mysql_error());
$bsql = "CREATE TABLE UrlLookup_temp (\n\t\tUrl CHAR(100),\n\t\tTableID INT NOT NULL,\n\t\tID INT NOT NULL,\n\t\tPRIMARY KEY (Url)\n\t) ENGINE MyISAM";
$query_result = mysql_query($bsql) or die('CREATE TABLE UrlLookup_temp failed: ' . mysql_error());
$bsql = "INSERT INTO UrlLookup_temp SELECT SanitizedEventName, 1, EventID FROM Events_temp";
$query_result = mysql_query($bsql);
if (!$query_result) {
send_an_email('*****@*****.**', 'INTO UrlLookup_temp failed!!!!', 'INSERT Events INTO UrlLookup_temp failed' . mysql_error());
die('INSERT Events INTO UrlLookup_temp failed: ' . mysql_error());
}
$bsql = "INSERT INTO UrlLookup_temp SELECT SanitizedVenueName, 2, VenueID FROM Venues_temp";
# $bsql = "INSERT INTO UrlLookup_temp SELECT SanitizedVenueName, 2, VenueID FROM Venues_temp";
$query_result = mysql_query($bsql);
if (!$query_result) {
send_an_email('*****@*****.**', 'INTO UrlLookup_temp failed!!!!', 'INSERT Venues INTO UrlLookup_temp failed: ' . mysql_error());
die('INSERT Venues INTO UrlLookup_temp failed: ' . mysql_error());
}
$bsql = "INSERT INTO UrlLookup_temp SELECT SanitizedCategoryName, 3, CategoryID FROM ModifiedPreorderTreeTraversalCategories";
$query_result = mysql_query($bsql);
if (!$query_result) {
send_an_email('*****@*****.**', 'INTO UrlLookup_temp failed!!!!', 'INSERT ModifiedPreorderTreeTraversalCategories INTO UrlLookup_temp failed: ' . mysql_error());
die('INSERT ModifiedPreorderTreeTraversalCategories INTO UrlLookup_temp failed: ' . mysql_error());
}
print_message("Done.\n");
# send_an_email('*****@*****.**','GetAllEvents succeeded!!!!','GetAllEvents succeeded!!!!');
mysql_close($dbh);
print_message("Creation of UrlLookup table is complete!!\n");
