<?
require_once "lib_reg.php";
require_once "lib_ref_admin.php";
require_once "lib_get.php";
$comp_id = _GET_num("comp_id");
$cat_id = _GET_num("cat_id");
if ($comp_id && $cat_id)
{
require_once "db.php";
echo toggleReg($comp_id,$cat_id);
sql_close();
}
?>
}
//
$err = addCom(
$line[$headers["wca id"]],
$line[$headers["name"]],
$birthday,
cased_mysql_result($country,0,"id"),
$line[$headers["gender"]],
true);
if (is_int($err))
{
$nimp++;
//
foreach($line as $x => $value)
if (isset($cats[$x]) && $value=="1")
toggleReg($err,$cats[$x]);
}
else
$errors .= $err."<br>";
}
}
$headersdone = true;
}
fclose($h);
}
//
echo "<html><body onload='opener.location.reload();'>";
echo "<div class=header><b>Importation report</b></div>";
echo "<div class=errors>".($errors?$errors:"no errors!")."</div><p>";
echo "<div class=header>";
echo "<b>$nimp</b> competitors imported<br>";
<?
require_once "lib.php";
require_once "lib_reg.php";
require_once "lib_ref_admin.php";
require_once "lib_get.php";
$_GETid = _GET_num("id");
if ($_GETid)
{
require_once "db.php";
//
if (sql_num_rows(strict_query("SELECT * FROM $timestable WHERE comp_id=?", array($_GETid))))
die("Can't delete a competitor who already has results in the competition");
$competitor = strict_query("SELECT * FROM $compstable WHERE id=?", array($_GETid));
if (!sql_num_rows($competitor))
{
sql_close();
die("Competitor id not found!");
}
$categories = strict_query("SELECT id FROM $eventstable");
while ($rcat=cased_mysql_fetch_array($categories)) {
if (cased_mysql_result($competitor,0,"cat".$rcat["id"])=="X") {
toggleReg($_GETid,$rcat["id"]);
}
}
strict_query ("DELETE FROM $compstable WHERE id=?", array($_GETid));
sql_close();
}
?>
