<? 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(); } ?>