1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
|
echo "<ul class=\"smallFont\" style=\"list-style:none; padding:0px; margin:3px;\">";
$sql = "SELECT COUNT(languageID) as anz,languageCode,userID,languageID FROM wcf1_user left join wcf1_language using (languageID) group by languageID order by anz DESC";
$result = WCF::getDB ()->sendQuery ( $sql, 20 );
while ( $row = WCF::getDB ()->fetchArray ( $result ) ) {
$get_land = WCF::getDB ()->getFirstRow ( "SELECT userOption74 FROM wcf" . WCF_N . "_user_option_value where userID = " . $row ['userID'] . "" );
$search_link = "<a href=\"./index.php?form=MembersSearch&values[userOption74]=".$get_land ['userOption74']."\"><img src=\"./wcf/icon/styleOptionsS.png\" alt=\"search\" name=\"search\" /></a>";
echo "<li class=\"container-2\"><img src=\"wcf/icon/language" . ucfirst ( $row ['languageCode'] ) . "S.png\" /> " . $get_land ['userOption74'] . " " . $row ['anz'] . " user".$search_link."<br /></li>";
}
echo "</ul>";
?> |