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; }