include LOCALE.LOCALESET."user_fields/user_country.php";
echo "
# | Flag | Country name |
Users |
";
$query = dbquery("SELECT DISTINCT user_country, COUNT(*) FROM ".DB_USERS." WHERE user_country IS NOT NULL GROUP BY user_country ORDER BY COUNT(*) DESC ");
$rows = dbrows($query);
$i = 1;
$wynik ="";
if ($rows) {
while ($data = dbarray($query)) {
$num = dbcount("(user_country)", DB_USERS, "user_country='".$data['user_country']."'");
$wynik .= "
".$i++." |
|
".$locale['uf_country_'.strtolower($data['user_country']).'']." |
($num) |
";
}
}
else if ($rows = NULL) {
$wynik ="";
}
echo $wynik;
echo "
";
?>