$lng_title › $lng_pilots";
echo "
";
echo " # | | CN | RN | ".$lng_firstname." | ".$lng_lastname." | ".$lng_plane." | ".$lng_country." |
";
$i = 1;
if (mysql_num_rows($result)) {
while ($qry = mysql_fetch_array($result)) {
if ($qry[country] == "sk") { $country = "Slovak Republic"; }
else if ($qry[country] == "cz") { $country = "Czech Republic"; }
else if ($qry[country] == "ar") { $country = "Argentina"; }
else if ($qry[country] == "au") { $country = "Australia"; }
else if ($qry[country] == "at") { $country = "Austria"; }
else if ($qry[country] == "be") { $country = "Belgium"; }
else if ($qry[country] == "br") { $country = "Brazil"; }
else if ($qry[country] == "ca") { $country = "Canada"; }
else if ($qry[country] == "cn") { $country = "China"; }
else if ($qry[country] == "hr") { $country = "Croatia"; }
else if ($qry[country] == "cy") { $country = "Cyprus"; }
else if ($qry[country] == "dk") { $country = "Denmark"; }
else if ($qry[country] == "eg") { $country = "Egypt"; }
else if ($qry[country] == "ee") { $country = "Estonia"; }
else if ($qry[country] == "fi") { $country = "Finland"; }
else if ($qry[country] == "fr") { $country = "France"; }
else if ($qry[country] == "de") { $country = "Germany"; }
else if ($qry[country] == "gr") { $country = "Greece"; }
else if ($qry[country] == "hu") { $country = "Hungary"; }
else if ($qry[country] == "is") { $country = "Iceland"; }
else if ($qry[country] == "ie") { $country = "Ireland"; }
else if ($qry[country] == "il") { $country = "Israel"; }
else if ($qry[country] == "it") { $country = "Italy"; }
else if ($qry[country] == "jp") { $country = "Japan"; }
else if ($qry[country] == "lv") { $country = "Latvia"; }
else if ($qry[country] == "lt") { $country = "Lithuania"; }
else if ($qry[country] == "lu") { $country = "Luxembourg"; }
else if ($qry[country] == "mk") { $country = "Macedonia"; }
else if ($qry[country] == "mt") { $country = "Malta"; }
else if ($qry[country] == "mx") { $country = "Mexico"; }
else if ($qry[country] == "me") { $country = "Montenegro"; }
else if ($qry[country] == "nl") { $country = "Netherlands"; }
else if ($qry[country] == "nz") { $country = "New Zealand"; }
else if ($qry[country] == "no") { $country = "Norway"; }
else if ($qry[country] == "pl") { $country = "Poland"; }
else if ($qry[country] == "pt") { $country = "Portugal"; }
else if ($qry[country] == "ru") { $country = "Russia"; }
else if ($qry[country] == "sr") { $country = "Serbia"; }
else if ($qry[country] == "si") { $country = "Slovenia"; }
else if ($qry[country] == "za") { $country = "South Africa"; }
else if ($qry[country] == "es") { $country = "Spain"; }
else if ($qry[country] == "se") { $country = "Sweden"; }
else if ($qry[country] == "ch") { $country = "Switzerland"; }
else if ($qry[country] == "tu") { $country = "Turkey"; }
else if ($qry[country] == "ua") { $country = "Ukraine"; }
else if ($qry[country] == "uk") { $country = "United Kingdom"; }
else if ($qry[country] == "us") { $country = "United States"; }
else if ($qry[country] <> "1") { $country = "---"; }
if ($i < 10) {$i = "0".$i;}
$name1 = mb_ucwords($qry[name1]);
$name2 = mb_ucwords($qry[name2]);
$rn = strtoupper($qry[rn]);
$cn = strtoupper($qry[username]);
echo "$i | | $cn | $rn | $name1 | $name2 | $qry[plane] | $country |
";
$i = $i + 1;
if ($color=="0") { $c="dark"; $color = "1"; } else { $c="light"; $color = "0"; }
}
}
echo "
";
?>
$asw15,
'Libelle ('.$libelle.')' => $libelle,
);
$color = array(
'#A6CEE3',
'#1F78B4',
);
$chart->setChartAttrs( array(
'type' => 'pie',
'title' => 'Glider types used in contest',
'data' => $data,
'size' => array( 650, 400 ),
'color' => $color
));
$chart = str_replace("&", "&", $chart);
echo $chart;
?>
"1") { $krajinka = "---"; }
$krajinapocet = $qry['COUNT(username)'];
$krajina = $krajinka.' ('.$krajinapocet.')';
$pole[$krajina] = $krajinapocet;
}
$color = array(
'#A6CEE3',
'#1F78B4',
'#B2DF8A',
'#33A02C'
);
$chart2->setChartAttrs( array(
'type' => 'pie',
'title' => 'Countries taking part in contest',
'data' => $pole,
'size' => array( 650, 450 ),
/* 'labelsXY' => true,
'axisRange' => '0,100,25|1,0,25',
'dataRange' => '0,25', */
'color' => $color
));
$chart2 = str_replace("&", "&", $chart2);
echo $chart2;
?>