<? require_once "lib_ref_admin.php"; require_once "lib.php"; require_once "lib_get.php"; $cat_id = _GET_num("cat_id"); $round = _GET_num("round"); if ($cat_id && $round) { require_once "db.php"; // $event = strict_query("SELECT * FROM $eventstable WHERE id=?", array($cat_id)); if (sql_num_rows($event) && cased_mysql_result($event,0,"r".$round) && !cased_mysql_result($event,0,"r".$round."_open")) { if ($round==1) { $comp_in = strict_query("SELECT id FROM $compstable WHERE cat?!='' ORDER BY id LIMIT " .cased_mysql_result($event,0,"r".$round."_groupsize"), array($cat_id)); $registered = sql_num_rows($comp_in); if (!$registered) die("Cannot open this round: no one registered"); for ($x=0;$x<$registered;$x++) { strict_query("INSERT INTO $regstable VALUES (?,?," .cased_mysql_result($comp_in,$x,"id").")", array($cat_id,$round)); strict_query("UPDATE $compstable SET cat?='X' WHERE id=".cased_mysql_result($comp_in,$x,"id"), array($cat_id)); } } else { $timetype = cased_mysql_result(strict_query("SELECT timetype FROM categories WHERE id=?", array($cat_id)),0,"timetype"); $format = strict_query("SELECT * FROM formats WHERE id=".cased_mysql_result($event,0,"r".($round-1)."_format")); $avgtype = cased_mysql_result($format,0,"avgtype");
//========================================================================================================================= if (!array_key_exists("cid", $_GET)) { header("Location: http://".DOMAIN."\r\n"); } else { if(!isset($_SESSION)) session_start(); $test = preg_match("~^test\\.~i",$_SERVER["HTTP_HOST"]); $cid = _GET_num("cid"); $comp_id = _GET_num("compid"); $schedule = _GET_num("schedule"); $_GETcat = _GET_num("cat"); $_GETrnd = _GET_num("rnd"); $_GETsm = _GET_num("sm"); $showmode = ($_GETcat && $_GETrnd && !$comp_id ? $_GETsm : false); $html_sch = DIR_UPLOADS.($test?"test_":"")."sch_$cid.html"; if (!file_exists($html_sch)) $html_sch = ""; $txt_sch = DIR_UPLOADS.($test?"test_":"")."sch_$cid.txt"; if (!file_exists($txt_sch)) { $txt_sch = ""; if (!$html_sch) $schedule = false; } elseif (!$_GETcat && !$comp_id && !$schedule) $schedule = true; if ($test) {
<? require_once "lib.php"; require_once "lib_ref_admin.php"; require_once "lib_get.php"; $_GETid = _GET_num("id"); if ($_GETid) { require_once "db.php"; // $result = strict_query("SELECT * FROM $eventstable WHERE id=?", array($_GETid)); if (sql_num_rows($result)==1) { $event = cased_mysql_fetch_array($result); $round = 0; do { $round += 1; } while($round < 4 && $event["r".$round]); $rnd = "r".$round; if (!$event[$rnd]) { $prnd = "r".($round-1); if ($event[$prnd."_open"]) $gs = sql_num_rows(strict_query("SELECT round FROM $regstable WHERE cat_id=? AND round=?", array($_GETid,$round-1))); else $gs = $event[$prnd."_groupsize"]; $gs = floor($gs*.75); if ($gs >= 2) { strict_query("UPDATE $eventstable SET ". $rnd."=1, ". $rnd."_format=". $prnd."_format, " .$rnd."_groupsize=". $gs.", " .$rnd."_open=0 WHERE id=?", array($_GETid));
// $this->TextCL($dx+15,$dy+55,50,10,"results",true); $this->TextCL($dx+67,$dy+55,28,10,"judge",true); // for ($y=1;$y<=$ntimes;$y++) $this->BoxesLine ($y, $dx,$dy); $this->BoxesLine ($y+0.5, $dx,$dy); // $this->column = !$this->column; if (!$this->column) $this->row = !$this->row; } } $sebastien = 55; // Auroux $cat_id = _GET_num("cat_id"); $round = _GET_num("round"); $comp_id = _GET_num("comp_id"); if (($cat_id && $round) || $comp_id) { if ($comp_id) $result = strict_query("SELECT $regstable.comp_id AS compid, $regstable.cat_id AS catid, $regstable.round AS round, categories.name AS catname, $compstable.name AS compname FROM $regstable JOIN categories ON $regstable.cat_id=categories.id JOIN $compstable ON $regstable.comp_id=$compstable.id WHERE $regstable.comp_id=? AND $regstable.round=1 ORDER BY categories.id", array($comp_id)); else { $query = "SELECT $regstable.comp_id AS compid, categories.name AS catname, $compstable.name AS compname FROM $regstable JOIN categories ON $regstable.cat_id=categories.id JOIN $compstable ON $regstable.comp_id=$compstable.id"; if ($round>1) { $query .= " JOIN $timestable ON $timestable.cat_id=$regstable.cat_id AND $timestable.round=? AND $timestable.comp_id=$regstable.comp_id"; $array = array($round-1,$cat_id,$round); } else $array = array($cat_id,$round); $query .= " WHERE $regstable.cat_id=? AND $regstable.round=?";
if ($_GETid && $_GETfld && isset($_GET["value"])) { require_once "db.php"; // if ($_GETfld=="timelimit") { $value = _GET_key("value"); // still secure because of the following lines if ($value && !preg_match("/^([0-9]{1,2}\072[0-5][0-9]\056[0-9]{2}|[0-5]?[0-9]\056[0-9]{2}|[0-9]{1,2}\072[0-5][0-9])$/",$value)) $value = ""; if ($value) { $value = formatTimelimit00($value); if (!timelimitNum00($value)) $value = ""; } } else $value = _GET_num("value"); // strict_query("UPDATE $eventstable SET $_GETfld=? WHERE id=?", array($value,$_GETid)); // if ($_GETfld=="timelimit") if ($value) $value = "cutoff $value"; else $value = "no cutoff"; echo $value; // sql_close(); } ?>
<? 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(); } ?>