global $txt, $scripturl, $user_info; global $context, $modSettings, $ID_MEMBER; global $board_info, $settings, $db_prefix; $groupnumber = 37; $loaded_ids = array(); $user_profile=array(); $memberContext=array(); $profile=array(); $context['TPortal']['team']=array(); $select_columns = " IFNULL(lo.logTime, 0) AS isOnline, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, a.attachmentType, mem.personalText, mem.avatar, mem.ID_MEMBER, mem.memberName, mem.realName,mem.lastLogin, mem.websiteTitle, mem.websiteUrl, mem.location, mem.posts, them.value AS teamtext"; $select_tables = " LEFT JOIN {$db_prefix}log_online AS lo ON (lo.ID_MEMBER = mem.ID_MEMBER) LEFT JOIN {$db_prefix}attachments AS a ON (a.ID_MEMBER = mem.ID_MEMBER) LEFT JOIN {$db_prefix}themes AS them ON (mem.ID_MEMBER = them.ID_MEMBER AND them.variable = 'teamtext' AND them.ID_THEME=1)"; // Load the member's data. $request = db_query(" SELECT$select_columns FROM {$db_prefix}members AS mem$select_tables WHERE mem.ID_GROUP = $groupnumber OR mem.ID_GROUP = 1 ORDER BY mem.memberName ASC", __FILE__, __LINE__); $new_loaded_ids = array(); while ($row = mysql_fetch_assoc($request)) { $avatar_width = ''; $avatar_height = ''; $context['TPortal']['team'][] = array( 'username' => $row['memberName'], 'name' => $row['realName'], 'posts' => $row['posts'], 'location' => $row['location'], 'href' => $scripturl . '?action=profile;u=' . $row['ID_MEMBER'], 'link' => '' . $row['realName'] . '', 'blurb' => $row['personalText'], 'avatar' => array( 'name' => $row['avatar'], 'image' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? '' : '') : (stristr($row['avatar'], 'http://') ? '' : ''), 'href' => $row['avatar'] == '' ? ($row['ID_ATTACH'] > 0 ? (empty($row['attachmentType']) ? $scripturl . '?action=dlattach;attach=' . $row['ID_ATTACH'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row['filename']) : '') : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']), 'url' => $row['avatar'] == '' ? '' : (stristr($row['avatar'], 'http://') ? $row['avatar'] : $modSettings['avatar_url'] . '/' . $row['avatar']) ), 'last_login' => empty($row['lastLogin']) ? $txt['never'] : timeformat($row['lastLogin']), 'last_login_timestamp' => empty($row['lastLogin']) ? 0 : forum_time(0, $row['lastLogin']), 'website' => array( 'title' => $row['websiteTitle'], 'url' => $row['websiteUrl']), 'online' => array( 'is_online' => $row['isOnline'], 'text' => &$txt[$row['isOnline'] ? 'online2' : 'online3'], 'image_href' => $settings['images_url'] . '/' . ($row['isOnline'] ? 'useron' : 'useroff') . '.gif', ), 'teamtext' => $row['teamtext'], ); } mysql_free_result($request); echo ''; $newrow=0; foreach($context['TPortal']['team'] as $team) { echo ' '; $newrow++; if($newrow>1){ $newrow=0; echo ''; } } echo '

Black-Chapter Operatives

New-Bloods :: SCL 10A :: Entry-Level Members


'.$team['avatar']['image'].'

'.$team['link'].'

Last seen: '.$team['last_login'].'
Posts: '.$team['posts'].'
' , !empty($team['location']) ? 'Location: '.$team['location'].'
' : '' , ' ' , !empty($team['website']['title']) ? 'Website: '.$team['website']['title'].'
' : '' , ' ' , $team['online']['is_online'] ? ' '.$team['online']['text'].'
' : $team['online']['text'].'
' , ' ' , !empty($team['blurb']) ? '- '.$team['blurb'].'
' : '' , ' ' , !empty($team['teamtext']) ? $team['teamtext'].'
' : '' , '


';