public static function displayIcons(GWF_User $user)
{
$back = '';
$db = gdo_db();
$uid = $user->getInt('user_id');
$regats = GWF_TABLE_PREFIX . 'wc_regat';
$query = "SELECT regat_sid, regat_solved FROM {$regats} WHERE regat_uid={$uid}";
if (false === ($result = $db->queryRead($query))) {
return '';
}
$i = 0;
while (false !== ($row = $db->fetchRow($result))) {
if (0.05 > ($solved = floatval($row[1]))) {
continue;
}
if (++$i % 5 === 0) {
$back .= '<br/>' . PHP_EOL;
}
$siteid = (int) $row[0];
$site = WC_Site::getByID($siteid);
$back .= $site->displayLogoUN($user->getVar('user_name'), $solved, 6, 28, true) . PHP_EOL;
}
$db->free($result);
return $back;
}
/**
* Calcs the shared rank. Multiple users can share one rank in theory.
* @param GWF_User $user
* @return int
*/
public static function calcRank(GWF_User $user)
{
$score = $user->getInt('user_level');
return $user->countRows("user_level>{$score} AND user_options&0x10000000=0") + 1;
}
