Create("churchil_demo");
/* List out the tables to update */
$tables[] = "Auctions";
$tables[] = "Locations";
$tables[] = "Auctioneers";
$tables[] = "Catagories";
$tables[] = "CatagoryList";
$tables[] = "Auction_Catagory_Xref";
$tables[] = "States";
/* Loop over each table, first deleteing all of the
* rows and then loading in the data stored off in
* the data file.
*/
echo("Clearing Tables:\n\n");
do {
$table = current($tables);
/* Delete everything from the table */
$sql->Delete("delete from $table");
echo("- Cleared: $table\n");
} while (next($tables));
echo("
\n");
/* Load new information in */
echo("Loading Data...
\n");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (1,23)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (1,26)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (1,21)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (1,22)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (1,20)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (2,10)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (2,9)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (2,8)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (2,7)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (2,11)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (2,12)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (3,1)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (3,4)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (3,3)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (3,13)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (3,24)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (4,1)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (4,4)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (4,5)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (4,3)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (4,29)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (4,13)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (4,16)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (5,1)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (5,5)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (5,3)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (5,13)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (5,16)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (5,7)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (5,8)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (6,1)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (6,5)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (6,31)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (6,16)");
$sql->Insert("INSERT INTO Auction_Catagory_Xref VALUES (6,9)");
$sql->Insert("INSERT INTO Auctioneers VALUES (1,'Howlin\' Hank','12 Lakeview Terrace','','','Waterbury','VT','05677','802-244-5555','','802-244-5556','','','','Expert on farm equipment.','1998-07-21')");
$sql->Insert("INSERT INTO Auctioneers VALUES (2,'Bob Lamier','87 West Hill','','','Norwich','UT','94858','333-444-5555','','333-444-5556','','blamier@msn.com','http://www.msn.com/~bob','','1998-07-21')");
$sql->Insert("INSERT INTO Auctions VALUES (1,'Beanie Baby Bonanza','1998-08-22 09:30:00','1998-08-22 10:00:00','3%','',2,3)");
$sql->Insert("INSERT INTO Auctions VALUES (2,'Estate Sale - East Hill Farm','1998-07-28 09:30:00','1998-07-28 10:30:00','4%','',1,2)");
$sql->Insert("INSERT INTO Auctions VALUES (3,'Lion\'s Club Benefit','1998-09-07 18:30:00','1998-09-07 18:00:00','0%','$15.00',1,7)");
$sql->Insert("INSERT INTO Auctions VALUES (4,'Antique Auction','1998-08-12 09:30:00','1998-08-12 10:30:00','4%','$4.00',2,8)");
$sql->Insert("INSERT INTO Auctions VALUES (5,'Estate Sale','1998-07-30 09:30:00','1998-07-30 10:30:00','4.5%','',1,5)");
$sql->Insert("INSERT INTO Auctions VALUES (6,'East Hill Farm Estate Sale','1998-09-10 07:30:00','1998-09-10 09:00:00','3%','',1,5)");
$sql->Insert("INSERT INTO Catagories VALUES (1,'Antiques',0,0)");
$sql->Insert("INSERT INTO Catagories VALUES (13,'Silver',1,1)");
$sql->Insert("INSERT INTO Catagories VALUES (3,'Rugs',1,1)");
$sql->Insert("INSERT INTO Catagories VALUES (4,'Glass',1,1)");
$sql->Insert("INSERT INTO Catagories VALUES (5,'Depression',2,4)");
$sql->Insert("INSERT INTO Catagories VALUES (31,'Flatware',1,13)");
$sql->Insert("INSERT INTO Catagories VALUES (7,'Farm Equipment',0,0)");
$sql->Insert("INSERT INTO Catagories VALUES (8,'Livestock',0,0)");
$sql->Insert("INSERT INTO Catagories VALUES (9,'Cattle',1,8)");
$sql->Insert("INSERT INTO Catagories VALUES (10,'Meat',2,9)");
$sql->Insert("INSERT INTO Catagories VALUES (11,'Milk',3,10)");
$sql->Insert("INSERT INTO Catagories VALUES (12,'Horses',1,8)");
$sql->Insert("INSERT INTO Catagories VALUES (16,'Platters',2,13)");
$sql->Insert("INSERT INTO Catagories VALUES (24,'Cards',1,20)");
$sql->Insert("INSERT INTO Catagories VALUES (23,'Lunch Boxes',1,20)");
$sql->Insert("INSERT INTO Catagories VALUES (22,'Barbie Dolls',1,20)");
$sql->Insert("INSERT INTO Catagories VALUES (29,'Persian',1,3)");
$sql->Insert("INSERT INTO Catagories VALUES (20,'Collectables',0,0)");
$sql->Insert("INSERT INTO Catagories VALUES (21,'Beanie Babies',1,20)");
$sql->Insert("INSERT INTO Catagories VALUES (25,'Magic',1,24)");
$sql->Insert("INSERT INTO Catagories VALUES (26,'Baseball',1,24)");
$sql->Insert("INSERT INTO Catagories VALUES (27,'Misc',1,24)");
$sql->Insert("INSERT INTO Catagories VALUES (30,'Tupperware',1,13)");
$sql->Insert("INSERT INTO CatagoryList VALUES (1,'Antiques',4)");
$sql->Insert("INSERT INTO CatagoryList VALUES (13,'Antiques:Silver',3)");
$sql->Insert("INSERT INTO CatagoryList VALUES (3,'Antiques:Rugs',3)");
$sql->Insert("INSERT INTO CatagoryList VALUES (4,'Antiques:Glass',2)");
$sql->Insert("INSERT INTO CatagoryList VALUES (5,'Antiques:Glass:Depression',3)");
$sql->Insert("INSERT INTO CatagoryList VALUES (31,'Antiques:Silver:Flatware',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (7,'Farm Equipment',2)");
$sql->Insert("INSERT INTO CatagoryList VALUES (8,'Livestock',2)");
$sql->Insert("INSERT INTO CatagoryList VALUES (9,'Livestock:Cattle',2)");
$sql->Insert("INSERT INTO CatagoryList VALUES (10,'Livestock:Cattle:Meat',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (11,'Livestock:Cattle:Meat:Milk',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (12,'Livestock:Horses',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (16,'Antiques:Silver:Platters',3)");
$sql->Insert("INSERT INTO CatagoryList VALUES (21,'Collectables:Beanie Babies',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (20,'Collectables',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (29,'Antiques:Rugs:Persian',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (22,'Collectables:Barbie Dolls',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (23,'Collectables:Lunch Boxes',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (24,'Collectables:Cards',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (25,'Collectables:Cards:Magic',0)");
$sql->Insert("INSERT INTO CatagoryList VALUES (26,'Collectables:Cards:Baseball',1)");
$sql->Insert("INSERT INTO CatagoryList VALUES (27,'Collectables:Cards:Misc',0)");
$sql->Insert("INSERT INTO CatagoryList VALUES (30,'Antiques:Silver:Tupperware',0)");
$sql->Insert("INSERT INTO Locations VALUES (3,'Andy\'s Auction Arena','888 Moutain View','','','Springfield','LA','70462','111-222-3333','111-222-3334','ATM, PA system, lots of parking, loading ramp','Exit 3 off of Rt 23, 2.7 miles north,\r\nturn right onto Mountain View. Arena\r\nis 1.3 miles on the left.','1998-07-21')");
$sql->Insert("INSERT INTO Locations VALUES (2,'Northfield Fairgrounds','234 Pucker St.','','','Northfield','VT','05663','802-444-5555','802-444-5556','Food vendors available most weekends. ATM\r\nonsite for impulse purchases. PA system\r\nupgraded last year.','Take exit 5 off of Rt 89, head into\r\nNorthfield. Fairground is 1.7 miles, on\r\nthe right.\r\n','1998-07-21')");
$sql->Insert("INSERT INTO Locations VALUES (4,'Fairfax Grange Hall','45 Main Street','','','Crossville','TN','38555','999-888-7777','999-888-7776','','','1998-07-21')");
$sql->Insert("INSERT INTO Locations VALUES (5,'Flagstaff Fairgrounds','4478 South St','','','Flagstaff','AZ','86004','602-345-9885','','Parking for 600 vehicles. Loading dock.\r\nSecure warehousing.','','1998-07-23')");
$sql->Insert("INSERT INTO Locations VALUES (6,'Auction Barn','445 North Prosepect St.','','','Burlington','VT','05401','802-654-3345','','Limited Parking.','Exit 14 off Rt 89. Take Main Street west\r\n0.8 miles. Turn right onto North Prospect.\r\n','1998-07-23')");
$sql->Insert("INSERT INTO Locations VALUES (7,'Skwentna Auction Place','101 East St.','','','Skwenta','AK','99667','123-345-8876','','It\'s cold up here!','Go west young man. North too.','1998-07-23')");
$sql->Insert("INSERT INTO Locations VALUES (8,'Bargain Basement','89 Light Lane','','','Chicago','IL','60603','345-222-3333','','','North of the windy city.','1998-07-23')");
$sql->Insert("INSERT INTO States VALUES ('AL','Alabama',0)");
$sql->Insert("INSERT INTO States VALUES ('AK','Alaska',1)");
$sql->Insert("INSERT INTO States VALUES ('AZ','Arizona',2)");
$sql->Insert("INSERT INTO States VALUES ('AR','Arkansas',0)");
$sql->Insert("INSERT INTO States VALUES ('CA','California',0)");
$sql->Insert("INSERT INTO States VALUES ('CO','Colorado',0)");
$sql->Insert("INSERT INTO States VALUES ('CT','Connecticut',0)");
$sql->Insert("INSERT INTO States VALUES ('DE','Deleware',0)");
$sql->Insert("INSERT INTO States VALUES ('FL','Florida',0)");
$sql->Insert("INSERT INTO States VALUES ('GA','Geogia',0)");
$sql->Insert("INSERT INTO States VALUES ('HI','Hawaii',0)");
$sql->Insert("INSERT INTO States VALUES ('ID','Idaho',0)");
$sql->Insert("INSERT INTO States VALUES ('IL','Illinois',1)");
$sql->Insert("INSERT INTO States VALUES ('IN','Indiana',0)");
$sql->Insert("INSERT INTO States VALUES ('IA','Iowa',0)");
$sql->Insert("INSERT INTO States VALUES ('KS','Kansas',0)");
$sql->Insert("INSERT INTO States VALUES ('KY','Kentucky',0)");
$sql->Insert("INSERT INTO States VALUES ('LA','Louisiana',1)");
$sql->Insert("INSERT INTO States VALUES ('ME','Maine',0)");
$sql->Insert("INSERT INTO States VALUES ('MD','Maryland',0)");
$sql->Insert("INSERT INTO States VALUES ('MA','Massachusetts',0)");
$sql->Insert("INSERT INTO States VALUES ('MI','Michigan',0)");
$sql->Insert("INSERT INTO States VALUES ('MN','Minnesota',0)");
$sql->Insert("INSERT INTO States VALUES ('MS','Mississippi',0)");
$sql->Insert("INSERT INTO States VALUES ('MO','Missouri',0)");
$sql->Insert("INSERT INTO States VALUES ('MT','Montana',0)");
$sql->Insert("INSERT INTO States VALUES ('NE','Nebraska',0)");
$sql->Insert("INSERT INTO States VALUES ('NV','Nevada',0)");
$sql->Insert("INSERT INTO States VALUES ('NH','New Hampshire',0)");
$sql->Insert("INSERT INTO States VALUES ('NJ','New Jersey',0)");
$sql->Insert("INSERT INTO States VALUES ('NM','New Mexico',0)");
$sql->Insert("INSERT INTO States VALUES ('NY','New York',0)");
$sql->Insert("INSERT INTO States VALUES ('NC','North Carolina',0)");
$sql->Insert("INSERT INTO States VALUES ('ND','North Dakota',0)");
$sql->Insert("INSERT INTO States VALUES ('OH','Ohio',0)");
$sql->Insert("INSERT INTO States VALUES ('OK','Oklahoma',0)");
$sql->Insert("INSERT INTO States VALUES ('OR','Oregon',0)");
$sql->Insert("INSERT INTO States VALUES ('PA','Pennsylvania',0)");
$sql->Insert("INSERT INTO States VALUES ('RI','Rhode Island',0)");
$sql->Insert("INSERT INTO States VALUES ('SC','South Carolina',0)");
$sql->Insert("INSERT INTO States VALUES ('SD','South Dakota',0)");
$sql->Insert("INSERT INTO States VALUES ('TN','Tennessee',0)");
$sql->Insert("INSERT INTO States VALUES ('TX','Texas',0)");
$sql->Insert("INSERT INTO States VALUES ('UT','Utah',0)");
$sql->Insert("INSERT INTO States VALUES ('VT','Vermont',1)");
$sql->Insert("INSERT INTO States VALUES ('VA','Virginia',0)");
$sql->Insert("INSERT INTO States VALUES ('WA','Washington',0)");
$sql->Insert("INSERT INTO States VALUES ('WV','West Virginia',0)");
$sql->Insert("INSERT INTO States VALUES ('WI','Wisconsin',0)");
$sql->Insert("INSERT INTO States VALUES ('WY','Wyoming',0)");
echo("Data restored.
\n");
/* Loop through all of the dates in the Auctions table and
* add 60 days to any which are earlier than today.
*/
$sql2 = new MySQL_class;
$sql2->Create("churchil_demo");
echo("Checking Dates...
\n");
$now = time();
$date = date("Y-m-d H:i",$now);
$sql->Query("select ID, StartTime, ViewTime from Auctions where StartTime < '$date'");
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$id = $sql->data[ID];
$stime = $sql->data[StartTime];
$vtime = $sql->data[ViewTime];
$tmp = MkUnixTime($stime);
while ($tmp < $now) {
$tmp += 5184000; /* 60 days in seconds */
}
$stime = date("Y-m-d H:i",$tmp);
$tmp = MkUnixTime($vtime);
while ($tmp < $now) {
$tmp += 5184000; /* 60 days in seconds */
}
$vtime = date("Y-m-d H:i",$tmp);
$sql2->Update("update Auctions set StartTime = \"$stime\", ViewTime = \"$vtime\" where ID = $id");
}
echo("Done.
\n");
echo("
The database has been restored to it's original state. Feel free to \n");
echo("modify it any way you wish.\n");
include("footer.php3");
?>