Pairings / Results 2017-12-28T22:37:24+00:00

 

Open section. Pairings / Results."; if ($_SERVER['SERVER_NAME']=='localhost') { $lnkPersRes="persres.php?section=1"; $lnkResults="results.php?section=1"; $lnkPlayers="players.php?section=1"; } else { $lnkPersRes="/persres/?section=1"; $lnkResults="/results/?section=1"; $lnkPlayers="/players-list/?section=1"; }; } elseif ($cmbSection==2) { $tblResults="wrbc_results_rapid_women"; $tblPlayers="wrbc_players_rapid_women"; $txtHeader="World Rapid 2017 Championship.
Women section. Pairings / Results."; if ($_SERVER['SERVER_NAME']=='localhost') { $lnkPersRes="persres.php?section=2"; $lnkResults="results.php?section=2"; $lnkPlayers="players.php?section=2"; } else { $lnkPersRes="/persres/?section=2"; $lnkResults="/results/?section=2"; $lnkPlayers="/players-list/?section=2"; }; } elseif ($cmbSection==3) { $tblResults="wrbc_results_blitz_open"; $tblPlayers="wrbc_players_blitz_open"; $txtHeader="World Blitz 2017 Championship.
Open section. Pairings / Results."; if ($_SERVER['SERVER_NAME']=='localhost') { $lnkPersRes="persres.php?section=3"; $lnkResults="results.php?section=3"; $lnkPlayers="players.php?section=3"; } else { $lnkPersRes="/persres/?section=3"; $lnkResults="/results/?section=3"; $lnkPlayers="/players-list/?section=3"; }; } else { $tblResults="wrbc_results_blitz_women"; $tblPlayers="wrbc_players_blitz_women"; $txtHeader="World Blitz 2017 Championship.
Women section. Pairings / Results."; if ($_SERVER['SERVER_NAME']=='localhost') { $lnkPersRes="persres.php?section=4"; $lnkResults="results.php?section=4"; $lnkPlayers="players.php?section=4"; } else { $lnkPersRes="/persres/?section=4"; $lnkResults="/results/?section=4"; $lnkPlayers="/players-list/?section=4"; }; } if (@$instance<=0){$instance="1";} @$strCode=$_GET["id"]; @$strCode=$instance; if ($strCode<=0 or $strCode>40) $strCode=1; @$sLang=''; @$iLang=''; @$ln=$_GET["lang"]; //@$strCat=$_GET["cat"]; if ($ln<>"ru") $ln="en"; //@$sLang="en"; Function IIf($condition,$value1,$value2) { if ($condition) { return $value1;} else { return $value2;} } Function say($value1,$value2) { global $ln; if ($ln=="en") { return $value1;} else { return $value2;} } if ($_SERVER['SERVER_NAME']=='localhost') { $connection = mysqli_connect("localhost", "chessdaily", "gisellism","ratings"); $db = mysqli_select_db($connection, "ratings") or die ("Unable to connect to FIDE ratings database. Try again or contact webmaster admin@fide.com."); } else { $connection = mysqli_connect("localhost", "wrbc_usr", "NU7y7w43hedh","wrbc"); $db = mysqli_select_db($connection, "wrbc") or die ("Unable to connect to FIDE ratings database. Try again or contact webmaster admin@fide.com."); }; $sql = mysqli_query($connection,"SELECT distinct round FROM ".$tblResults." ORDER BY round"); if (mysqli_num_rows($sql)>0) { while ($rstSearch = mysqli_fetch_array($sql)) { if ($rstSearch['round']<16 and $cmbSection==1) { echo '
Rd'.$rstSearch['round'].' 
'; } elseif ($rstSearch['round']>15 and $cmbSection==1) { echo '
TB'.($rstSearch['round']-15).' 
'; } else { echo '
Rd'.$rstSearch['round'].' 
'; } $i=$i+1; } } @$strCode=$_GET["id"]; if ($strCode<=0 or $strCode>40) $strCode=$i; $sql = mysqli_query($connection,"SELECT * FROM ".$tblResults." WHERE color='W' and round='".intval($strCode)."' ORDER BY round, game"); // echo(mysqli_num_rows($sql)); if (mysqli_num_rows($sql)>0) { //$rstSearch=mysql_fetch_array($sql); ?>

    15 and $cmbSection==1) { echo 'Tie-break '.($strCode-15); } else { echo 'Round '.$strCode; }?>

Bo.SNo.  NameRtgPtsRes. Pts NameRating SNo.