Site Statistics
Here you can see the OPSC website statistics. Information shown here is updated every day 23:00:00 GMT.
";
echo "" . $row['class_description'] . "
";
echo "";
$class_code = $row['class_code'];
$sql = "select distinct category_code, category_description, graph_flag, graph_type from stat_metric where class_code = '$class_code' order by sort_order";
$category_result = mysqli_query($link, $sql );
while ($category_row = mysqli_fetch_assoc($category_result)) {
echo "| " . $category_row['category_description'] . " |
|---|
";
$category_code = $category_row['category_code'];
$sql = "select * from stat_value where category_code = '$category_code' order by sort_order" ;
$value_result = mysqli_query($link, $sql );
$array_index = 0;
if ( $category_row['graph_flag'] == 'Y' ):
$graph_type = $category_row['graph_type'];
while ($value_row = mysqli_fetch_assoc($value_result)) {
$name_array[$array_index] = $value_row['measure_name'];
$value_array[$array_index] = $value_row['measure_value'];
$color_array[$array_index] = rand(100000,999999);
if ( $value_row['measure_name'] == "Female" ): $color_array[$array_index] = "e03974"; endif;
if ( $value_row['measure_name'] == "Male" ): $color_array[$array_index] = "4169e2"; endif;
if ( $value_row['measure_name'] == "Unspecified" ): $color_array[$array_index] = "696969"; endif;
if ( $value_row['measure_name'] == "Fighter" ): $color_array[$array_index] = "a5191a"; endif;
if ( $value_row['measure_name'] == "Strider" ): $color_array[$array_index] = "e2b02b"; endif;
if ( $value_row['measure_name'] == "Mage" ): $color_array[$array_index] = "247aab"; endif;
if ( $value_row['measure_name'] == "Warrior" ): $color_array[$array_index] = "a5191a"; endif;
if ( $value_row['measure_name'] == "Ranger" ): $color_array[$array_index] = "e2b02b"; endif;
if ( $value_row['measure_name'] == "Sorcerer" ): $color_array[$array_index] = "247aab"; endif;
$array_index = $array_index + 1;
}
if ( $graph_type == 'Line' ):
echo "";
echo " |
";
echo "
" . stripslashes($value_row['measure_name']) . " | " . $value_row['measure_value'] . " | ";
}
endif;
}
echo "
";
echo "
";
}
?>