function _uploadgames($ssifname)
{
# ------------------------
# v02 BH 2005/10/5 for WDV Data
# -----------------------
$row = 0;
$lastGameID = 0;
$fp = fopen($ssifname, "r");
echo setPageTitle('Log Output from Game Loader');
opentable();
while ($data = fgetcsv($fp, 1000, "\t")) {
$row++;
if ($lastGameID != $data[5]) {
$gDate = $data[2];
$gDesc = $data[3] . $data[4];
$lsgid = $data[5];
$winPID = $data[7];
} else {
$losPID = $data[7];
if ($winPID > 0) {
echo "<tr><td>Game entry: {$data['5']}</td><td>Winner: {$winPID}</td><td>Loser: {$losPID}</td><td>{$gDate} {$gDesc}</td>";
# OK Go for the upload ...
if (_checkLSGameID($lsgid) == 0) {
echo "<td>" . _saveresult($gDate, $winPID, $losPID, $gDesc, $lsgid) . "</td></tr>";
} else {
echo "<td>League Game exists - no upload</td>";
}
}
# reset
$gDate = "";
$gDesc = "";
$winPID = "";
$losPID = "";
}
#// arrays are zero based 2=date 3+4 = desc 5=gameID 7=PlayerID
#// _saveresult($date,$IDWinner,$IDLoser,$Description);
$lastGameID = $data[5];
}
fclose($fp);
CloseTable();
}
}
$vlocname = strip_tags($vlocname);
$vloccity = strip_tags($vloccity);
$vlocplz = strip_tags($vlocplz);
$vlocaddress = strip_tags($vlocaddress);
$vlocphone = strip_tags($vlocphone);
$vlocemail = strip_tags($vlocemail);
$vlcoordinates = strip_tags($vlcoordinates);
if (!ereg("([0-1]{1})", $vlocactive)) {
$vlocactive = 1;
}
if ($vlocid > 0) {
$qry = "update tbllocation set lname=\"{$vlocname}\", lcity=\"{$vloccity}\", lplz=\"{$vlocplz}\", laddress=\"{$vlocaddress}\", lphone=\"{$vlocphone}\",lactive={$vlocactive}, lrealm_id={$vlocrealm},lemail=\"{$vlocemail}\",lcoordinates=\"{$vlcoordinates}\" where id={$vlocid}";
} else {
$qry = "insert into tbllocation(id,lname,lcity,lplz,laddress,lphone,lactive,lrealm_id,lemail,lcoordinates) values(0,\"{$vlocname}\",\"{$vloccity}\",\"{$vlocplz}\",\"{$vlocaddress}\",\"{$vlocphone}\",{$vlocactive},{$vlocrealm},\"{$vlocemail}\",\"{$vlcoordinates}\")";
}
$dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
$presult = sql_query("insert into tdsolog values(0,1,'fsaveLocation','{$vfcre_info}','EX: {$qry}')", $dbi);
echo $qry;
$presult = sql_query($qry, $dbi);
//sleep(1);
echo $presult;
}
switch ($_GET['opcode']) {
default:
_whistle();
break;
case "save":
_saveresult($_POST['vlocid'], $_POST['vlocactive'], $_POST['vlocname'], $_POST['vloccity'], $_POST['vlocplz'], $_POST['vlocaddress'], $_POST['vlocphone'], $_POST['vlocemail'], $_POST['vlocrealm'], $_POST['vloccoordinates']);
break;
}
