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