A few notes:

- You would add this code to update.php
- The import pages would be accessed with update.php?import&div
- You would have to configure the $uploadto path as the temporary path to store the CSV file
- This code does not take seasons into account as it was written before seasons and master teams functionality was implemented
- You'll have to analyze the code to see what order the fields should be in the CSV file

In other words, this is a good framework to start with if you are familiar with PHP, but it might not take into account some of the database structure changes from later releases of the sports standings script.  You should definitely test it on a separate install so that you don't mess up any existing teams until you know that the code is correct.

---------------------------------


case 'import':

if (isset($_POST['import'])) {

// Which division are we importing to
$divid = intval($_POST['divid']);

// Which file we're working with
$uploadto = $_POST['file_location'];

// Which column represents dates]
$date = intval($_POST['date']);
$dates = array();

// Which column represents dates]
$time = intval($_POST['time']);
$times = array();

// Which column represents team 1 (home team)
$team1 = intval($_POST['home']);
$team1s = array();

// Which column represents team 2 (away team)
$team2 = intval($_POST['away']);
$team2s = array();

// Which column represents field
$field = intval($_POST['field']);
$fields = array();

// Make sure a different field has been mapped to each column
$unique_check = array_unique(array($date, $time, $team1, $team2, $field));
if (count($unique_check) != 5) die ("You didn't assign unique columns. Try again.");

// Put the lines from the file into an array
$bigskedarray = file($uploadto);

$i = 0;
$separator = ",";
  while (list($i, $skedrow) = each($bigskedarray)) {
      $skedrow = trim($skedrow);
      $skedcell[$i] = explode("$separator", $skedrow);
      if ($i == 0) {
            $numcols = count($skedcell[0]);
      }
      else {

      // Add to the date array
      $dates[$i-1] = strtotime($skedcell[$i][$date]);

      // Add to the time array (using the date for the exact time)
      $times[$i-1] = strtotime($skedcell[$i][$date] . ' ' . $skedcell[$i][$time]);
     
      // Add to the Team 1 (home team) array
      $team1s[$i-1] = trim($skedcell[$i][$team1]);
     
      // Add to the Team 2 (away team) array
      $team2s[$i-1] = trim($skedcell[$i][$team2]);
     
      // Add to the fields array
      $fields[$i-1] = trim($skedcell[$i][$field]);
      }
      ++$i;
  }

// Merge the team arrays
$teams = array_merge($team1s, $team2s);

// Generate a unique array of teams
$unique_teams = array_values(array_unique($teams));

mysql_connect($sportsdb_host,$sportsdb_user,$sportsdb_pass);
@mysql_select_db($sportsdb_db) or die( "Unable to select database");

// Insert the teams into MySQL
foreach ($unique_teams as $unique_team) {
$query = "INSERT INTO sportsdb_teams (teamname, teamdiv) VALUES ('$unique_team', $divid)";
mysql_query($query) or die ("Error in query: $query");
}

print '<p><strong>' . count($unique_teams) . '</strong> teams imported</p>' . "\n";

// Insert the rows into the schedule
for ($i = 0; $i < count($fields); ++$i) {
$query = "INSERT INTO sportsdb_wins (winner, loser, windate, wintime, field) VALUES ('{$team1s[$i]}', '{$team2s[$i]}', {$dates[$i]}, {$times[$i]}, '{$fields[$i]}')";
mysql_query($query) or die ("Error in query: $query");
}

print '<p><strong>' . count($fields) . '</strong> schedule entries imported</p>' . "\n";

// Replace all teams with numbers
mysql_query("UPDATE sportsdb_wins, sportsdb_teams SET sportsdb_wins.winner = sportsdb_teams.teamid WHERE sportsdb_wins.winner = sportsdb_teams.teamname AND sportsdb_teams.teamdiv = $divid");
mysql_query("UPDATE sportsdb_wins, sportsdb_teams SET sportsdb_wins.loser = sportsdb_teams.teamid WHERE sportsdb_wins.loser = sportsdb_teams.teamname AND sportsdb_teams.teamdiv = $divid");

// Done!

print '<p><a href="' . $_SERVER['PHP_SELF'] . '?action=mainview&div=' . $divid. '">Done</a></p>' . "\n";

print '<h3>Import another division\'s schedule</h3>' . "\n";
}

if (isset($_POST['csv'])) {

// Which division does this apply to
$divid = intval($_POST['divid']);
mysql_connect($sportsdb_host,$sportsdb_user,$sportsdb_pass);
@mysql_select_db($sportsdb_db) or die( "Unable to select database");

$result = mysql_query("SELECT divname FROM sportsdb_divs WHERE divid = $divid");
$divname = mysql_result($result,0,'divname');

print "<p><strong>Import schedule to $divname</strong></p>\n";

// put the file somewhere

$uploadto = "path/to/upload/" . basename($_FILES['schedule']['name']);
move_uploaded_file($_FILES['schedule']['tmp_name'],$uploadto);

// $separator = intval($_POST['separator']);
// switch ($separator) {
// default: $separator = ",";
// }

$separator = ",";

$bigskedarray = file('../schedules/' . $_FILES['schedule']['name']);

$separator = ",";
      $skedrow = trim($bigskedarray[0]);
      $skedcell[0] = explode("$separator", $skedrow);
      $numcols = count($skedcell[0]);

      print "<h2>Header rows</h2>\n";

for ($i = 0; $i < $numcols; ++$i) {
      $skedoptions .= '<option value="' . $i . '">' . $skedcell[0][$i] . "</option>\n";
}

$end_fields = array("date" => "Date", "time" => "Time", "home" => "Home team", "away" => "Away team", "field" => "Field");

print '<form name="matchfields" method="post" action="' . $_SERVER['PHP_SELF'] . '?action=import">' . "\n";

foreach ($end_fields as $end_field => $end_name) {
print "<p>$end_name: <select name=\"$end_field\">";
print $skedoptions;
print "</select></p>\n";
}

print '<input type="hidden" name="file_location" value="' . $uploadto . '" />' . "\n";
print '<input type="hidden" name="divid" value="' . $divid . '" />' . "\n";
print '<input type="submit" name="import" value="Submit" />' . "\n";
print "</form>\n";

}
else {
if (isset($_GET['div'])) print '<h3>Import CSV schedule</h3>' . "\n";
?>
<form enctype="multipart/form-data" name="csv" method="post" action="<?php print $_SERVER['PHP_SELF'] . '?action=import'; ?>">
<p>Division: <select name="divid">
<?php

// get all the divisions to populate the lists
// option value should be the div id

mysql_connect($sportsdb_host,$sportsdb_user,$sportsdb_pass);
@mysql_select_db($sportsdb_db) or die( "Unable to select database");

$result = mysql_query("SELECT divname, divid FROM sportsdb_divs");
$num = mysql_num_rows($result);

$i = 0;

while ($i < $num) {
$divname = mysql_result($result,$i,'divname');
$divid = mysql_result($result,$i,'divid');
print "<option value=\"$divid\">$divname</option>\n";
++$i;
}

?>
</select></p>
<p><input type="file" name="schedule" /></p>
<?php // <p>Separator:
// <select name="separator">
// <option value="1">Comma</option>
// </select>
// </p>
?>
<p><input type="submit" name="csv" value="Import" /></p>
</form>
<?php
print "<p><a href=\"" . $_SERVER['PHP_SELF'] . "\">Cancel</a></p>\n";
}

break;