Beispiel #1
0
     echo "<td class='formTitle'><span onmouseover=\"showToolTip('Days Since Last Login')\" onmouseout='hideToolTip()' style='cursor: help'>DSL:</span></td>";
 }
 echo "\n\t\t\t<td class='formTitle'>Status:</td>\n\t\t</tr>\n\t";
 $sqlRanks = "('" . implode("','", $arrRanks) . "')";
 $sqlHideInactive = "";
 if ($websiteInfo['hideinactive'] == 1) {
     $sqlHideInactive = " AND " . $dbprefix . "members.onia = '0'";
 }
 $query = "SELECT " . $dbprefix . "members.member_id FROM " . $dbprefix . "members INNER JOIN " . $dbprefix . "ranks ON " . $dbprefix . "members.rank_id=" . $dbprefix . "ranks.rank_id WHERE " . $dbprefix . "members.rank_id IN " . $sqlRanks . " AND " . $dbprefix . "members.disabled = '0' AND " . $dbprefix . "ranks.hiderank = '0'" . $sqlHideInactive . " ORDER BY " . $dbprefix . "ranks.ordernum DESC";
 $result2 = $mysqli->query($query);
 $arrMemberCountCat[$row['rankcategory_id']] = $result2->num_rows;
 while ($arrMembers = $result2->fetch_assoc()) {
     $member->select($arrMembers['member_id']);
     $memberListInfo = $member->get_info_filtered();
     $rankObj->select($memberListInfo['rank_id']);
     $rankObj->refreshImageSize();
     $rankListInfo = $rankObj->get_info_filtered();
     $dispMainGame = "Not Set";
     if ($gameObj->select($memberListInfo['maingame_id'])) {
         $gameObj->refreshImageSize();
         $gameInfo = $gameObj->get_info_filtered();
         $arrGameCount[] = $gameInfo['gamesplayed_id'];
         $dispMainGame = "<div class='memberPageImage'><img src='" . $gameInfo['imageurl'] . "' width='" . $gameInfo['imagewidth'] . "' height='" . $gameInfo['imageheight'] . "' onmouseover=\"showToolTip('" . $gameInfo['name'] . "')\" onmouseout='hideToolTip()'></div>";
     } else {
         $arrGameCount[] = "NotSet";
     }
     $arrGamesPlayed = array_merge($arrGamesPlayed, $member->gamesPlayed());
     $dispDSL = floor((time() - $memberListInfo['lastlogin']) / 86400);
     if ($memberListInfo['onia'] == 1) {
         $dispDSL = "IA";
     }