function toggleReg($comp_id,$cat_id)
{
global $eventstable, $compstable, $regstable;
$comp_id = (int)$comp_id;
$cat_id = (int)$cat_id;
$competitor = strict_query("SELECT cat? AS cat FROM $compstable WHERE id=?", array($cat_id,$comp_id));
if(!sql_num_rows($competitor)) return "";
$_X = "X"; // Do not change!
$_w = "-"; // "
$event = strict_query("SELECT r1_open, r2_open, r1_groupsize FROM $eventstable WHERE id=?", array($cat_id));
$groupsize = cased_mysql_result($event,0,"r1_groupsize");
if (sql_num_rows($event) && !cased_mysql_result($event,0,"r2_open"))
{
if (cased_mysql_result($event,0,"r1_open"))
{
$regs = strict_query("SELECT COUNT(*) as count FROM $regstable WHERE cat_id=? AND round=1", array($cat_id));
$nregs = cased_mysql_result($regs,0,"count");
}
else
$nregs = $groupsize;
$hl = NULL;
if (!cased_mysql_result($competitor,0,"cat"))
{
if ($nregs < $groupsize)
{
$newValue = $_X;
strict_query("INSERT INTO $regstable VALUES (?,1,?)", array($cat_id,$comp_id));
}
else
$newValue = $_w;
}
elseif (compHasTimesR1($comp_id,$cat_id))
return $_X;
else
{
$newValue = "";
if (cased_mysql_result($event,0,"r1_open") && cased_mysql_result($competitor,0,"cat")==$_X)
{
$waiting = strict_query("SELECT id FROM $compstable WHERE cat?='$_w' ORDER BY id LIMIT 1", array($cat_id));
if (!sql_num_rows($waiting))
strict_query("DELETE FROM $regstable WHERE cat_id=? AND round=1 AND comp_id=?", array($cat_id,$comp_id));
else
{
strict_query("UPDATE $compstable SET cat?='$_X' WHERE id=".cased_mysql_result($waiting,0,"id"), array($cat_id));
strict_query("UPDATE $regstable SET comp_id='" .cased_mysql_result($waiting,0,"id"). "' WHERE cat_id=? AND round=1 AND comp_id=?", array($cat_id,$comp_id));
$hl = "td".cased_mysql_result($waiting,0,"id")."_".$cat_id;
}
}
}
strict_query("UPDATE $compstable SET cat?='$newValue' WHERE id=?", array($cat_id,$comp_id));
if ($hl) $newValue .= "/".$hl;
return $newValue;
}
}
function addEve($eve_id)
{
$eve_id = (int)$eve_id;
global $eventstable, $compstable;
//
$result = strict_query("SELECT id FROM $eventstable WHERE id=?", array($eve_id));
if (sql_num_rows($result)) return;
$result = strict_query("SELECT * FROM categories WHERE id=?", array($eve_id));
if (sql_num_rows($result))
{
strict_query("INSERT INTO $eventstable SET id=?, r1=1, r1_format=" . substr(cased_mysql_result($result,0,"possible_formats"),0,1) . ", r1_groupsize=999", array($eve_id));
strict_query("ALTER TABLE $compstable ADD cat? VARCHAR( 1 ) NOT NULL", array($eve_id));
}
}
function print_txt_sch($fn)
{
global $competition, $eventstable;
//
$r = strict_query("SELECT name, abbr FROM categories");
while ($row=cased_mysql_fetch_array($r))
$categories[$row["abbr"]] = $row["name"];
$r = strict_query("SELECT * FROM $eventstable JOIN categories ON $eventstable.id=categories.id");
while ($row=cased_mysql_fetch_array($r))
{
$events[_RX][$row["abbr"]] = 0;
$events[_ID][$row["abbr"]] = $row["id"];
$x = 1;
while ($x <= 4 && $row["r$x"."_open"]) $x++;
$events[_RTOP][$row["abbr"]] = $x-1;
}
//
$fh = fopen($fn,'r');
$ver = trim(fgets($fh));
if ($ver != "00")
{
print_txt01_sch($fh,$categories,$events);
return;
}
//
echo "<h2>".cased_mysql_result($competition,0,"name")." Schedule</h2><p>";
$timezone = fgets($fh);
$line = fgets($fh);
while ($line)
{
echo date("l - F jS, Y",strtotime($line))."<p>";
echo "<table border=0 cellpadding=0 cellspacing=0 class=SCH><tr><th height=17 width=50>Start</th><th width=200>Event</th><th width=100>Round</th><th width=80>Format</th></tr>";
$line = fgets($fh);
while ($line && !strtotime($line))
{
$time = fetch($line);
$abbr = fetch($line);
echo "<tr".($categories[$abbr]?"":" class=rest").">";
echo "<td height=17 align=right>$time</td>";
if ($categories[$abbr])
{
echo "<td>".$categories[$abbr]."</td>";
echo "<td>";
if (isset($events[_RX][$abbr]))
{
$events[_RX][$abbr] = $events[_RX][$abbr] + 1;
if ($events[_RX][$abbr] <= $events[_RTOP][$abbr])
echo "<a href='live.php?cid=" .$_GET["cid"]. "&cat=" .$events[_ID][$abbr]. "&rnd=" .$events[_RX][$abbr]. "'>" .fetch($line). "</a>";
else
echo fetch($line);
}
else
echo fetch($line);
echo "</td>";
echo "<td>".fetch($line)."</td>";
}
else
echo "<td colspan=3 align=center>$abbr</td>";
echo "<tr>";
//
$line = fgets($fh);
}
echo "</table><p><br>";
}
fclose($fh);
//
echo "All times are $timezone";
}
function createSheetEvtRnd($sheet,$cat_id,$round,$lround,$timelimit)
{
global
$ssC,$ssB,$ssR,$ssTs,$ssTm,$ssBC,$ssBR,$ssBG1,$ssBG2,
$compstable, $regstable, $timestable,
$events,$evt,
$f_header,$f_headerc,$f_time;
//
$category = strict_query("SELECT * FROM categories WHERE id=".$cat_id);
$timetype = cased_mysql_result($category,0,"timetype");
$inseconds = cased_mysql_result($category,0,"inseconds");
$format = strict_query("SELECT * FROM formats WHERE id=".cased_mysql_result($events,$evt,"r".$round."_format"));
$times = cased_mysql_result($format,0,"times");
$avgtype = cased_mysql_result($format,0,"avgtype");
$query =
"SELECT $regstable.*, $compstable.name, $compstable.WCAid, $timestable.t1, $timestable.t2, $timestable.t3, $timestable.t4, $timestable.t5, $timestable.average, $timestable.best, countries.name AS country FROM $regstable ".
"JOIN $timestable ON ($regstable.cat_id=$timestable.cat_id AND $regstable.round=$timestable.round AND $regstable.comp_id=$timestable.comp_id) ".
"JOIN $compstable ON ($regstable.comp_id=$compstable.id) ".
"JOIN countries ON ($compstable.country_id=countries.id) ".
"WHERE $regstable.cat_id=" .$cat_id. " AND $regstable.round=" .$round." ORDER BY $timestable.t1 IS NULL, $timestable.average=\"\", $timestable.average, $timestable.best, $regstable.comp_id";
$result = strict_query($query);
if (!sql_num_rows($result)) // trick to generate 32 empty lines with formulas
$result = strict_query("SELECT NULL as name, NULL as country, NULL as WCAid, NULL as t1, NULL as t2, NULL as t3, NULL as t4, NULL as t5 FROM countries LIMIT 32");
//
$sheet
->setTitle(cased_mysql_result($category,0,"abbr")."-".$round);
$sheet
//->setCellValue("A1", cased_mysql_result($category,0,"name")." - round $round")
->setCellValue("A1", cased_mysql_result($category,0,"name")." - ".roundString($round,$lround,$timelimit))
->setCellValue("A2", "Format: ".cased_mysql_result($format,0,"name"))
->setCellValue("A3", ($timetype==2?"number of moves":($inseconds?"time in seconds (ss.hh)":"time in minutes (m:ss.hh)")))
->setCellValue("A4", "Position")
->setCellValue("B4", "Name")
->setCellValue("C4", "Country")
->setCellValue("D4", "WCA id");
$sheet
->setSharedStyle($ssB, "A1:A3")
->setSharedStyle($ssB, "A4:D4");
if ($timetype!=3)
{
if ($times==1)
{
$sheet->setCellValue("E4", "Result");
$letterLT = "E";
$letterBest = "E";
}
else
{
for ($x=1;$x<=$times;$x++)
$sheet->setCellValue(chr(68+$x)."4", $x);
$letterLT = chr(67+$x);
$letterBest = chr(68+$x);
}
$sheet
->setSharedStyle($ssBC, "E4:".chr(68+$times)."4")
->setSharedStyle($ssBR, chr(69+$times)."4:Z4");
$x = 69+$times;
}
else
{
for ($x=1;$x<=$times;$x++)
$sheet
->setCellValue(chr(69+($x-1)*4)."4", "tried")
->setCellValue(chr(69+($x-1)*4+1)."4", "solved")
->setCellValue(chr(69+($x-1)*4+2)."4", "seconds")
->setCellValue(chr(69+($x-1)*4+3)."4", "score $x");
$sheet
->setSharedStyle($ssBR, "E4:Z4");
$x = 69+($x-1)*4;
}
if ($times>1) $sheet->setCellValue(chr($x++)."4", "Best");
$sheet->setCellValue(chr($x++)."4", "WR");
if ($avgtype==0)
{
$letterAvg = chr($x+1);
$sheet
->setCellValue(chr($x++)."4", "Worst")
->setCellValue(chr($x++)."4", "Average")
->setCellValue(chr($x++)."4", "WR");
}
elseif ($avgtype==1)
{
$letterAvg = chr($x);
$sheet
->setCellValue(chr($x++)."4", "Mean")
->setCellValue(chr($x++)."4", "WR");
}
$line = 5;
$lineb = 4;
while ($row=cased_mysql_fetch_array($result))
{
$sheet
->setCellValue("B$line", $row["name"])
->setCellValue("C$line", $row["country"])
->setCellValue("D$line", $row["WCAid"]);
if ($timetype!=3)
{
for ($x=1;$x<=$times;$x++)
$sheet->setCellValue(chr(68+$x).$line, formatTime($row["t$x"],$timetype,$inseconds));
$x = 69+$times;
if ($times>1)
$sheet
->setCellValue(chr($x++).$line, "=IF(MIN(E$line:$letterLT$line)>0,MIN(E$line:$letterLT$line),IF(COUNTBLANK(E$line:$letterLT$line)=$times,\"\",\"DNF\"))");
if ($avgtype==0)
{
$x++;
$sheet
->setCellValue(chr($x++).$line, "=IF(COUNTBLANK(E$line:I$line)>0,\"\",IF(COUNTIF(E$line:I$line,\"DNF\")+COUNTIF(E$line:I$line,\"DNS\")>0,\"DNF\",MAX(E$line:I$line)))")
->setCellValue(chr($x++).$line, "=IF(COUNTBLANK(E$line:I$line)>0,\"\",IF(COUNTIF(E$line:I$line,\"DNF\")+COUNTIF(E$line:I$line,\"DNS\")>1,\"DNF\",IF(COUNTIF(E$line:I$line,\"DNF\")+COUNTIF(E$line:I$line,\"DNS\")>0,(SUM(E$line:I$line)-J$line)/".($times-2).",(SUM(E$line:I$line)-J$line-L$line)/".($times-2).")))");
}
elseif ($avgtype==1)
{
$x++;
$sheet
->setCellValue(chr($x++).$line, "=IF(COUNTBLANK(E$line:G$line)>0,\"\",IF(COUNTIF(E$line:G$line,\"DNF\")+COUNTIF(E$line:G$line,\"DNS\")>0,\"DNF\",AVERAGE(E$line:G$line)))");
}
if (isset($letterAvg))
$sheet
->setCellValue("A$line", "=IF(AND($letterAvg$lineb=$letterAvg$line,$letterBest$lineb=$letterBest$line),A$lineb,ROW()-4)");
else
$sheet
->setCellValue("A$line", "=IF($letterBest$lineb=$letterBest$line,A$lineb,ROW()-4)");
if ($timetype==2)
$sheet->setSharedStyle($ssR, "E$line:Z$line");
elseif ($inseconds)
$sheet->setSharedStyle($ssTs, "E$line:Z$line");
else
$sheet->setSharedStyle($ssTm, "E$line:Z$line");
}
else
{
$formula = "";
$formula_b = "";
for ($x=1;$x<=$times;$x++)
{
if (!$row["t$x"] || $row["t$x"]=="DNF" || $row["t$x"]=="DNS")
$sheet->setCellValue(chr(69+($x-1)*4).$line, $row["t$x"]);
else
$sheet
->setCellValue(chr(69+($x-1)*4).$line, (int)substr($row["t$x"],2,2))
->setCellValue(chr(69+($x-1)*4+1).$line, (int)substr($row["t$x"],0,2))
->setCellValue(chr(69+($x-1)*4+2).$line, round(formatTime(substr($row["t$x"],4,9),1,true))); // Disagree with that "round"
$lE = chr(69+($x-1)*4);
$lF = chr(69+($x-1)*4+1);
$lG = chr(69+($x-1)*4+2);
$lH = chr(69+($x-1)*4+3);
$sheet
->setCellValue(chr(69+($x-1)*4+3).$line, "=IF($lE$line=\"DNS\",-2,IF($lE$line=\"DNF\",-1,(99-$lF$line+$lE$line-$lF$line)*10000000+$lG$line*100+$lE$line-$lF$line))") // Changed formula to suit my records (DNFs were discarded before)
->setSharedStyle($ssBG1, chr(69+($x-1)*4+3).$line)
->getColumnDimension(chr(69+($x-1)*4+3))->setWidth(10);
if ($formula) $formula .= ",";
$formula .= "IF($lH$line<0,1000000000,$lH$line)";
if ($formula_b) $formula_b .= ",";
$formula_b .= "$lH$line<0";
}
if ($times==1)
{
$sheet
->setCellValue("A$line", "=IF(H$lineb=H$line,A$lineb,ROW()-4)");
}
else
{
$letterBest = chr(69+($x-1)*4);
$sheet
->setCellValue($letterBest.$line, "=IF(AND($formula_b),-1,MIN($formula))")
->setCellValue("A$line", "=IF($letterBest$lineb=$letterBest$line,A$lineb,ROW()-4)")
->setSharedStyle($ssBG2, $letterBest.$line)
->getColumnDimension(chr(69+($x-1)*4))->setWidth(10);
}
}
$line++;
$lineb++;
}
$sheet->getColumnDimension('B')->setWidth(20);
$sheet->getColumnDimension('C')->setWidth(10);
$sheet->getColumnDimension('D')->setWidth(15);
}
{
if (!$comp_id)
{
$t = strict_query("SELECT times FROM $eventstable JOIN formats ON $eventstable.r?_format=formats.id WHERE $eventstable.id=?", array($round,$cat_id));
$t = cased_mysql_result($t,0,"times");
}
//
$ts = new TS();
$ts->AddFont('DejaVu','','DejaVuSans.ttf',true);
$count = 0;
while ($row=cased_mysql_fetch_array($result))
{
if ($comp_id)
{
$t = strict_query("SELECT times FROM $eventstable JOIN formats ON $eventstable.r1_format=formats.id WHERE $eventstable.id=".$row["catid"]);
$t = cased_mysql_result($t,0,"times");
}
$compname = preg_replace("/\(.*\)/","",$row["compname"]);
if (!$comp_id) $count++;
$ts->Timesheet($row["compid"], $compname, $row["catname"], ($comp_id?$row["round"]:$round.""), $t, $count);
}
$ts->SetDisplayMode("fullpage","single");
$ts->Output(preg_replace("/\W/","",$_SESSION["c_name"])." - Scorecards.pdf", "I");
}
elseif ($comp_id)
die("This competitor is not registered to any event or these events are not yet open");
}
elseif (array_key_exists("aofr",$_GET))
{
$ts = new TS();
$ts->AddFont('DejaVu','','DejaVuSans.ttf',true);
<?
require_once "lib.php";
require_once "lib_ref_admin.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") && ($round==4 || !cased_mysql_result($event,0,"r".($round+1)) || !cased_mysql_result($event,0,"r".($round+1)."_open")))
{
if (sql_num_rows(strict_query("SELECT * FROM $timestable WHERE cat_id=? AND round=? LIMIT 1", array($cat_id,$round))))
die("Can't clear this round: it has times");
else
{
strict_query("DELETE FROM $regstable WHERE cat_id=? AND round=?", array($cat_id,$round));
if ($round==1) strict_query("UPDATE $compstable SET cat?=\"-\" WHERE cat?=\"X\"", array($cat_id,$cat_id));
strict_query("UPDATE $eventstable SET r?_open=0 WHERE id=?", array($round,$cat_id));
}
}
//
sql_close();
}
?>
$errors .= "Country name \"".$line[$headers["country"]]."\" not found in database<br>";
else
{
$birthday = $line[$headers["birth date"]];
$l = strlen($birthday);
if ($l < 10 && $l > 7)
{
if (strpos($birthday,'-',5)==6) $birthday = substr_replace($birthday,"0",5,0);
if (strlen($birthday)<10) $birthday = substr_replace($birthday,"0",8,0);
}
//
$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;
// format
if ($round <= $last_rwt)
echo "-<span onclick='alert(\"Change not allowed: this round already has results\");'> " .$fmts[(int)$event[$rnd."_format"]-1]. " </span>";
else
{
echo "-<span id=" . $rnd."_".$event["id"] . "_2 style='cursor:pointer;' onclick='switchDataEvents(\"" . $rnd."_".$event["id"] . "_2\",\"" . $event["id"] . "\",\"" . $rnd . "_format\");' title='click to switch'> " . $fmts[(int)$event[$rnd."_format"]-1] . " </span>";
}
// groupsize
if ($event[$rnd."_open"])
{
$in = cased_mysql_result(strict_query("SELECT COUNT(*) AS count FROM $regstable WHERE cat_id=".$event["id"]." AND round=".$round),0,"count");
if ($round==1) $r1in = $in;
if ($round>1 || $event[$rnd."_groupsize"] > $in)
$out = 0;
else
$out = cased_mysql_result(strict_query("SELECT COUNT(*) AS count FROM $compstable WHERE cat".$event["id"]."=\"-\""),0,"count");
$out = ($out?", $out out":"");
echo "- $in people in$out ";
}
else
{
if ($round==1) $r1in = $event[$rnd."_groupsize"];
if ($round < 4 && $event[$nextrnd])
echo "-<span onclick='alert(\"Change not allowed: round is not the last one. \\nTry removing rounds.\");'> for ".$event[$rnd."_groupsize"]." people </span>";
else
{
if ($round>1 && $event[$prevrnd."_open"])
$maxgs = floor($in*.75);
else
$maxgs = $round==1 ? 999 : floor($event[$prevrnd."_groupsize"]*.75);
$mings = 2;
<?
require_once "lib.php";
require_once "lib_ref.php";
require_once "lib_get.php";
$comp_id = _GET_num("comp_id");
$cat_id = _GET_num("cat_id");
$round = _GET_num("round");
if ($comp_id && $cat_id && $round)
{
require_once "db.php";
//
$qualified = sql_num_rows(strict_query("SELECT round FROM $regstable WHERE cat_id=? AND round=? AND comp_id=?", array($cat_id,$round,$comp_id)));
if ($qualified)
{
$alreadyhastimes = sql_num_rows(strict_query("SELECT round FROM $timestable WHERE cat_id=? AND round=? AND comp_id=?", array($cat_id,$round,$comp_id)));
$competitor = strict_query("SELECT name FROM $compstable WHERE id=?", array($comp_id));
echo ($alreadyhastimes?"1":"0").cased_mysql_result($competitor,0,"name");
}
//
sql_close();
}
?>
function createEvtRnd($cat_id,$round,$lround,$timelimit)
{
global
$compstable, $regstable, $timestable,
$events, $evt,
$fname;
//
$formats = array(1=>"a",2=>"m",3=>"3",4=>"2",5=>"1");
//
$category = strict_mysql_query("SELECT * FROM categories WHERE id=".$cat_id);
$timetype = cased_mysql_result($category,0,"timetype");
$inseconds = cased_mysql_result($category,0,"inseconds");
$format = strict_mysql_query("SELECT * FROM formats WHERE id=".cased_mysql_result($events,$evt,"r".$round."_format"));
$times = cased_mysql_result($format,0,"times");
$avgtype = cased_mysql_result($format,0,"avgtype");
$formatId = $formats[cased_mysql_result($format,0,"id")];
$query =
"SELECT $regstable.*, $compstable.name, $compstable.WCAid, $timestable.t1, $timestable.t2, $timestable.t3, $timestable.t4, $timestable.t5, $timestable.average, $timestable.best, countries.name AS country FROM $regstable ".
// people seem not to like this - "LEFT OUTER ".
"JOIN $timestable ON ($regstable.cat_id=$timestable.cat_id AND $regstable.round=$timestable.round AND $regstable.comp_id=$timestable.comp_id) ".
"JOIN $compstable ON ($regstable.comp_id=$compstable.id) ".
"JOIN countries ON ($compstable.country_id=countries.id) ".
"WHERE $regstable.cat_id=" .$cat_id. " AND $regstable.round=" .$round." ORDER BY $timestable.t1 IS NULL, $timestable.average=\"\", $timestable.average, $timestable.best, $regstable.comp_id";
$result = strict_mysql_query($query);
//
echo "-- ".cased_mysql_result($category,0,"name")." - ".roundString($round,$lround,$timelimit, $rId)."\r\n";
$lastA = "***";
$lastB = "***";
$count = 0;
while ($row=cased_mysql_fetch_array($result))
{
$count++;
echo "insert into Results (pos, personName, personId, countryId, competitionId, eventId, roundId, formatId, value1, value2, value3, value4, value5, best, average, regionalSingleRecord, regionalAverageRecord) values (";
if ($row["average"]!=$lastA || $row["best"]!=$lastB)
{
$position = $count;
$lastA = $row["average"];
$lastB = $row["best"];
}
echo "$position,";
echo "\"".$row["name"]."\",";
echo "\"".$row["WCAid"]."\",";
echo "\"".$row["country"]."\",";
echo "\"$fname\",";
echo "\"".cased_mysql_result($category,0,"abbr")."\",";
echo "\"$rId\",";
echo "\"$formatId\",";
for ($x=1;$x<=5;$x++)
if ($x<=$times)
echo formatTime($row["t$x"],$timetype).",";
else
echo "0,";
echo formatTime($row["best"],$timetype).",";
if ($formatId>"3")
echo formatTime($row["average"],$timetype).",";
else
echo "0,";
echo "\"\",\"\");\r\n";
}
echo "\r\n\n";
}
)<br>
<br>
<input type=button value=close onclick='window.close();'>
</div>
</BODY>
</HTML>
<?
die();
}
$color = "#4b5b51";
$light_color = "#b0c7b4";
$dark_color = "#0a1414";
$result = strict_query("SELECT admin_pw FROM competitions WHERE id=".$_SESSION["c_id"]);
if (cased_mysql_result($result,0,"admin_pw")!=$_POST["pw"])
{
?>
<!DOCTYPE HTML>
<HTML>
<HEAD>
<TITLE>Erroneous password</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<style type="text/css">
body {font-family:verdana,sans-serif;font-size:11px;margin:10px 10px;background-color:<?php
echo $color;
?>
;color:#FFFFCC;}
.header {font-weight:bold;background-color:<?php
echo $dark_color;
?>
//
$event = strict_query("SELECT * FROM $eventstable WHERE id=?", array($_GETcat_id));
if (!sql_num_rows($event) || !cased_mysql_result($event,0,"r".$_GETround."_open")) die("Round not open!");
$qualified = strict_query("SELECT round FROM $regstable WHERE cat_id=? AND round=? AND comp_id=?", array($_GETcat_id,$_GETround,$_GETcomp_id));
if (sql_num_rows($qualified))
{
$category = strict_query("SELECT * FROM categories WHERE id=?", array($_GETcat_id));
$timetype = cased_mysql_result($category,0,"timetype");
$format = strict_query("SELECT * FROM formats WHERE id=".cased_mysql_result($event,0,"r".$_GETround."_format"));
$times = cased_mysql_result($format,0,"times");
$avgtype = cased_mysql_result($format,0,"avgtype");
$alreadyhastimes = sql_num_rows(strict_query("SELECT round FROM $timestable WHERE cat_id=? AND round=? AND comp_id=?", array($_GETcat_id,$_GETround,$_GETcomp_id)));
//
if (cased_mysql_result($category,0,"canhavetimelimit") && $_GETround==1)
{
$timelimit = cased_mysql_result($event,0,"timelimit");
if($timelimit)
{
$timelimit = substr("000:00.00",0,9-strlen($timelimit)).$timelimit;
if (!timeNum($timelimit,1)) $timelimit = "";
}
}
else
$timelimit = "";
if($timelimit)
{
if ($times==5 || $_GETcat_id==16)
$tries = 2;
else
$tries = 1;
}
if (!$_POSTpw) _error("Blank password");
$result = strict_query("SELECT * FROM competitions WHERE id=?",array($_POSTid));
if (!$result || sql_num_rows($result) != 1) _error("Competition not available");
if (cased_mysql_result($result,0,"admin_pw")==$_POSTpw)
{
$_SESSION["c_id"] = $_POSTid;
$_SESSION["c_admin"] = true;
$_SESSION["c_country"] = cased_mysql_result($result,0,"country");
$_SESSION["c_name"] = cased_mysql_result($result,0,"name");
}
elseif (cased_mysql_result($result,0,"intro_pw")==$_POSTpw)
{
$_SESSION["c_id"] = $_POSTid;
unset($_SESSION["c_admin"]);
$_SESSION["c_country"] = cased_mysql_result($result,0,"country");
$_SESSION["c_name"] = cased_mysql_result($result,0,"name");
}
else
_error("Erroneous password");
$eventstable = "events".$_SESSION["c_id"];
$compstable = "competitors".$_SESSION["c_id"];
$regstable = "registrations".$_SESSION["c_id"];
$timestable = "times".$_SESSION["c_id"];
require_once "inc_initdb.php";
sql_close();
if (@$_SESSION["c_admin"])
header("Location: events.php\r\n");
else
$formatid = cased_mysql_result($format,0,"id");
$times = cased_mysql_result($format,0,"times");
$avgtype = cased_mysql_result($format,0,"avgtype");
$i = 5;
while ($sheet->getCell("B$i")->getValue())
{
$name = $sheet->getCell("B$i")->getValue();
$country = $sheet->getCell("C$i")->getValue();
if (!isset($countries[$country])) error ("Unknown country ('$country') at cell C$i");
$countryid = $countries[$country];
$wcaid = $sheet->getCell("D$i")->getValue();
if (!$wcaid) $wcaid = "";
$competitor = strict_query("SELECT id FROM $compstable WHERE name=? AND country_id=? AND WCAid=?", array($name,$countryid,$wcaid));
if (sql_num_rows($competitor)!=1) error ("Unregistered competitor at line $i - ('$name' - '$countryid' - '$wcaid')");
$competitorid = cased_mysql_result($competitor,0,"id");
if ($round==1) strict_query("UPDATE $compstable SET cat?='X' WHERE id=?", array($evtid,$competitorid));
strict_query("INSERT INTO $regstable SET cat_id=?, round=?, comp_id=?", array($evtid,$round,$competitorid));
if ($sheet->getCell("E$i")->getValue())
{
$scores = array();
if ($timetype!=3)
{
$t = 1;
while ($t<=$times && $sheet->getCell(chr(68+$t).$i)->getValue())
{
$value = $sheet->getCell(chr(68+$t).$i)->getValue();
if ($value=="DNF")
$value = -1;
<?
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();
}
?>
$maxrounds = 1;
elseif ($gsr1 <= 15)
$maxrounds = 2;
elseif ($gsr1 <= 99)
$maxrounds = 3;
else
$maxrounds = 4;
for ($x=$round+1;$x<=4;$x++)
{
$registered = floor($registered*.75);
if ($x>$maxrounds || $registered<2)
{
//if (cased_mysql_result($event,0,"r$round"))
if (cased_mysql_result($event,0,"r$x"))
$set .= ", r$x=0, r" .$x. "_format=0, r" .$x. "_groupsize=0, r" .$x. "_open=0";
else
break;
}
else
{
if (cased_mysql_result($event,0,"r".$x."_groupsize")>$registered)
$set .= ", r".$x."_groupsize=$registered";
}
}
strict_query("UPDATE $eventstable SET $set WHERE id=?", array($cat_id));
}
//
sql_close();
}
?>
require_once "lib_get.php";
$_GETid = _GET_num("id");
$_GETfld = _GET_fld("fld");
if ($_GETid && $_GETfld)
{
require_once "db.php";
//
$result = strict_query("SELECT * FROM $eventstable WHERE id=?", array($_GETid));
if (sql_num_rows($result)==1)
{
$fld = substr($_GETfld,strpos($_GETfld,"_"));
switch ($fld)
{
case "_format":
$formats = strict_query("SELECT * FROM formats ORDER BY id");
while($row=cased_mysql_fetch_array($formats)) $fmts[] = $row["name"];
$category = strict_query("SELECT possible_formats FROM categories WHERE id=".cased_mysql_result($result,0,"id"));
$possible_formats = cased_mysql_result($category,0,"possible_formats");
$value = cased_mysql_result($result,0,$_GETfld);
$newValue = (int)substr ($possible_formats, (strpos($possible_formats,"".$value)+1) % strlen($possible_formats), 1);
strict_query("UPDATE $eventstable SET $_GETfld=$newValue WHERE id=?", array($_GETid));
echo $fmts[$newValue-1];
break;
}
}
sql_close();
}
?>
$pdf->SetFont("","B",12);
$pdf->Write(5,"Oldest solver");
$pdf->Ln();
$pdf->SetFontSize(10);
$pdf->Write(5,romance(cased_mysql_result($result,0,"name"))." - ".cased_mysql_result($result,0,"country")." - ".cased_mysql_result($result,0,"birthday"));
$pdf->Ln(10);
}
$result = strict_query("SELECT $compstable.name, countries.name AS country, $timestable.best FROM $timestable JOIN $compstable ON $compstable.id=$timestable.comp_id JOIN countries ON $compstable.country_id=countries.id WHERE $timestable.cat_id=1 ORDER BY $timestable.best LIMIT 1");
if (sql_num_rows($result))
{
$pdf->SetFont("","B",12);
$pdf->Write(5,"Fastest solve");
$pdf->Ln();
$pdf->SetFontSize(10);
$pdf->Write(5,romance(cased_mysql_result($result,0,"name"))." - ".cased_mysql_result($result,0,"country")." - ".formatTime(cased_mysql_result($result,0,"best"),1));
$pdf->Ln(10);
}
$result = strict_query("SELECT $compstable.name, average, countries.name AS country FROM $compstable ".
"JOIN (SELECT comp_id, MIN(average) AS average FROM $timestable WHERE cat_id=1 GROUP BY comp_id) avg ON avg.comp_id=$compstable.id ".
"JOIN countries ON $compstable.country_id=countries.id ".
"WHERE gender=\"f\" AND average!=\"\" ORDER BY average LIMIT 3");
if (sql_num_rows($result))
{
$pdf->SetFont("","B",12);
$pdf->Write(5,"Fastest females");
$pdf->Ln();
$pdf->SetFontSize(10);
$count = 0;
while ($row=cased_mysql_fetch_array($result))
