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))