$Countries[$Row['country_code']] = $Row['country_name'];
}
$total_columns = 3;
$sql = "select accept_lang as culture, count(*) as total from tp_stats group by accept_lang order by accept_lang";
$r = mysql_query($sql);
while ($Row = mysql_fetch_array($r)) {
$LangStat[] = $Row;
}
$total_lang = sizeof($LangStat);
$rows_per_column = ceil($total_lang / $total_columns);
echo "\r\n\r\r\n<table cellpadding=\"0\" cellspacing=\"0\" width=\"700\" border=\"1\" align=\"left\" bordercolor=\"#7AA0B8\" bordercolorlight=\"black\" bordercolordark=\"white\">\r\r\n\t<tr>\r\r\n\t\t";
$i = 0;
for (; $i < $total_columns; ++$i) {
echo "\r\n\t\t<td valign=\"top\" width=\"";
echo floor(100 / $total_columns);
echo "%\">\r\r\n\t\t\t<table cellpadding=\"0\" cellspacing=\"0\" width=\"200\" border=\"1\" align=\"center\" bordercolor=\"#7AA0B8\" bordercolorlight=\"black\" bordercolordark=\"white\">\r\r\n\t\t\t\t<tr>\r\r\n\t\t\t\t\t<td align=\"center\" class=\"pagetitle\" bgcolor=\"#103056\" colspan=\"3\"><b>Statistics on languages</b></td>\r\r\n\t\t\t\t</tr>\r\r\n\t\t\t\t";
$j = $rows_per_column * $i;
for (; $j < $rows_per_column * ($i + 1) && isset($LangStat[$j]); ++$j) {
echo "\r\n\t\t\t\t<tr>\r\r\n\t\t\t\t\t<td align=\"left\" class=\"pagetitle\" nowrap> <b>";
echo culturetolangname($LangStat[$j]['culture'], $Languages);
echo " [";
echo $LangStat[$j]['culture'];
echo "]</b> </td>\r\r\n\t\t\t\t\t<td align=\"center\"><img src=\"flags/";
echo culturetocountrycode($LangStat[$j]['culture'], $LangCountries);
echo ".gif\" border=\"0\" /></td>\r\r\n\t\t\t\t\t<td align=\"center\" class=\"pagetitle2\" bgcolor=\"#7AA0B8\"><input type=\"text\" size=\"5\" class=\"inputbox2\" disabled=\"disabled\" value=\"";
echo $LangStat[$j]['total'];
echo "\"></td>\r\r\n\t\t\t\t</tr>\r\r\n\t\t\t\t";
}
echo "\r\n\t\t\t</table>\r\r\n\t\t</td>\r\r\n\t\t";
}
echo "\r\n\t</tr>\r\r\n</table>\r</td></tr><tr><td align=\"center\" class=\"pagetitle\" bgcolor=\"#000000\"><a href=\"http://munir.skilledsoft.com\"><font color=\"snow\">Recoded By by <b>Alienwithin</b> || Original Coder's(ICQ 92777755)</a></font></td></tr></table></body></html>\r\r\n";
function culturetocountryname($culture, $LangCountries, $Countries)
{
$country_code = culturetocountrycode($culture, $LangCountries);
return $Countries[$country_code];
}
