Solvers’ ratings April 1st 2021

‘;
$menu .= ‘‘;
while ($result = mysql_fetch_array($queried)) {
$menu .= ‘‘;
}
$menu .= ‘ ‘;
return $menu;
}

function selected_list($query, $link, $type_of_list) {
$num_of_rows=0;

$queried = mysql_query($query, $link);
if ($type_of_list==0)
{
$tr_style=”

“;

}
else {
if ($type_of_list==1)
{
$tr_style=”

“;
}
else {
$tr_style=”

“;
}
}

while($row = mysql_fetch_array($queried))
{
$num_of_rows++;

echo $tr_style;
echo “

“;
echo $row[‘Rank’];
echo “ “;
echo $row[‘PosChange’];
echo “ “;
echo $row[‘Title’];
echo “ “;
echo $row[‘W’];
echo “ “;
echo $row[‘Name’];
echo “ “;
echo $row[‘Country’];
echo “ “;
echo $row[‘Rating’];
echo “ “;
echo $row[‘RatChange’];
echo “ “;
echo $row[‘RatMax’];
echo “

“;
}

return $num_of_rows;
}

$db = “wfccch_rating_lists”;
$row_counter = 0;
echo “

Solvers’ ratings April 1st 2021

“;

echo “

Calculated tournaments:

“;
echo “

“;

echo ‘

‘;

echo “

“;
echo “

Select country:

“;

echo print_dropdown(“SELECT * FROM Countries_IOC WHERE IOC_code IN (SELECT Country from Rating_1_4_2021 UNION SELECT Country from Halfrating_1_4_2021 UNION SELECT Country from Non_active_solvers_1_4_2021) ORDER BY Country_name”, database_connect($db));

echo “

 “;
echo “

Select category:

“;

echo ‘ ‘;

echo “

 “;
echo “

Sort by:

“;

echo ‘ ‘;

echo “
“;
echo ‘‘;
echo ” Show ratings with decimals “;

echo “

 “;

echo ‘

‘;

echo “

“;

if (isset($_POST[‘submit’]))

{

$show_country=$_POST[“for_country”];

echo “

Selected country: “;
echo $show_country;

$for_category=$_POST[“for_category”];

echo ” | Category: “;
echo $for_category;

$order_by=$_POST[“sort_by”];

echo ” | Sort by: “;
echo $order_by;

if ($_POST[‘decimals’] == ‘1’) {
echo ” | Decimal Ratings

“;

$select_rat = “SELECT Rank, PosChange, Title, W, Name, Country, Format(Rating,2) AS Rating, RatChange, RatMax FROM Rating_1_4_2021 WHERE 1”;
$select_halfrat = “SELECT Rank, PosChange, Title, W, Name, Country, Format(Rating,2) AS Rating FROM Halfrating_1_4_2021 WHERE 1”;
$select_non_active = “SELECT Rank, PosChange, Title, W, Name, Country, Format(Rating,2) AS Rating, RatMax FROM Non_active_solvers_1_4_2021 WHERE 1″;

} else {

echo ” | Rounded Ratings.

“;

$select_rat = “SELECT Rank, PosChange, Title, W, Name, Country, Round(Rating) AS Rating, RatChange, RatMax FROM Rating_1_4_2021 WHERE 1”;
$select_halfrat = “SELECT Rank, PosChange, Title, W, Name, Country, Round(Rating) AS Rating FROM Halfrating_1_4_2021 WHERE 1”;
$select_non_active = “SELECT Rank, PosChange, Title, W, Name, Country, Round(Rating) AS Rating, RatMax FROM Non_active_solvers_1_4_2021 WHERE 1”;

}

echo “

Three different colors are used for Rating, Half-rating, Non active solvers.

“;

echo “

“;
echo “

“;

if ($show_country<>“ALL”) {

$select_rat .= ” AND country LIKE ‘$show_country'”;
$select_halfrat .= ” AND country LIKE ‘$show_country'”;
$select_non_active .= ” AND country LIKE ‘$show_country'”;

}

if ($for_category==”w” or $for_category==”j” or $for_category==”s”) {

$select_rat .= ” AND W LIKE ‘%$for_category%'”;
$select_halfrat .= ” AND W LIKE ‘%$for_category%'”;
$select_non_active .= ” AND W LIKE ‘%$for_category%'”;

}

if ($order_by==”Title”) {

$select_rat .= ” ORDER BY FIELD($order_by, ‘GM’, ‘IM’, ‘FM’, ‘ ‘)”;
$select_halfrat .= ” ORDER BY FIELD($order_by, ‘GM’, ‘IM’, ‘FM’, ‘ ‘)”;
$select_non_active .= ” ORDER BY FIELD($order_by, ‘GM’, ‘IM’, ‘FM’, ‘ ‘)”;

} else {
$select_rat .= ” ORDER BY $order_by”;
$select_halfrat .= ” ORDER BY $order_by”;
$select_non_active .= ” ORDER BY $order_by”;
}

if ($for_category==”Rating”) {
$rows_count_rating = selected_list($select_rat, database_connect($db), 0);
} else if ($for_category==”Halfrating”) {
$rows_count_halfrating = selected_list($select_halfrat, database_connect($db), 1);
} else if ($for_category==”Non_active_solvers”) {
$rows_count_non_active = selected_list($select_non_active, database_connect($db), 2);
} else {

$rows_count_rating = selected_list($select_rat, database_connect($db), 0);

$rows_count_halfrating = selected_list($select_halfrat, database_connect($db), 1);

$rows_count_non_active = selected_list($select_non_active, database_connect($db), 2);
}

echo “

Rank Pos.change Title Name Country Rating Change Max

“;

echo “Rating: “. $rows_count_rating .” | Half-rating: ” . $rows_count_halfrating . “ | Non-active solvers: ” .$rows_count_non_active . ““;

echo ““;

} else

{
echo “

All results

“;

echo “

Three different colors are used for Rating, Half-rating, Non active solvers.

“;

echo “

“;
echo “

“;

$rows_count_rating = selected_list(“SELECT Rank, PosChange, Title, W, Name, Country, Round(Rating) AS Rating, RatChange, RatMax FROM Rating_1_4_2021”, database_connect($db), 0);

$rows_count_halfrating = selected_list(“SELECT Rank, PosChange, Title, W, Name, Country, Round(Rating) AS Rating FROM Halfrating_1_4_2021”, database_connect($db), 1);

$rows_count_non_active = selected_list(“SELECT Rank, PosChange, Title, W, Name, Country, Round(Rating) AS Rating, RatMax FROM Non_active_solvers_1_4_2021”, database_connect($db), 2);

echo “

Rank Pos.change Title Name Country Rating Change Max

“;

echo “Rating: “. $rows_count_rating .” | Half-rating: ” . $rows_count_halfrating . “ | Non-active solvers: ” .$rows_count_non_active . ““;

echo ““;
}

?>

Comments are closed.