if (!empty($srtGrp)) { foreach (array_reverse($srtGrp) as $grpName => $grpList) { ?> <table id="supportTable" class="table table-striped"> <?php if ($writeHeader) { $writeHeader = false; ?> <tr class="yellow"> <th width="30%">Group</th> <th width="40%">Name</th> <th width="30%">Status</th> </tr> <?php } foreach ($grpList as $char) { if ($char['name'] != $config['website_char']) { echo '<tr>'; echo "<td width='30%'>" . $grpName . "</td>"; echo '<td width="40%"><a href="characterprofile.php?name=' . $char['name'] . '">' . $char['name'] . '</a></td>'; echo "<td width='30%'>" . online_id_to_name($char['online']) . "</td>"; echo '</tr>'; } } ?> </table> <?php } } echo '</table>'; include 'layout/overall/footer.php';
function user_character_list($account_id) { //$count = user_character_list_count($account_id); $account_id = (int) $account_id; if (config('TFSVersion') == 'TFS_10') { $characters = mysql_select_multi("SELECT `id`, `name`, `level`, `vocation`, `town_id`, `lastlogin` FROM `players` WHERE `account_id`='{$account_id}' ORDER BY `level` DESC"); if ($characters !== false) { $onlineArray = mysql_select_multi("SELECT `player_id` FROM `players_online`;"); $onlineIds = array(); if ($onlineArray !== false) { foreach ($onlineArray as $row) { $onlineIds[] = $row['player_id']; } } for ($i = 0; $i < count($characters); $i++) { $online = in_array($characters[$i]['id'], $onlineIds); if ($online) { $characters[$i]['online'] = 1; } else { $characters[$i]['online'] = 0; } unset($characters[$i]['id']); } } } else { $characters = mysql_select_multi("SELECT `name`, `level`, `vocation`, `town_id`, `lastlogin`, `online` FROM `players` WHERE `account_id`='{$account_id}' ORDER BY `level` DESC"); } if ($characters !== false) { $count = count($characters); for ($i = 0; $i < $count; $i++) { $characters[$i]['vocation'] = vocation_id_to_name($characters[$i]['vocation']); // Change vocation id to vocation name $characters[$i]['town_id'] = town_id_to_name($characters[$i]['town_id']); // Change town id to town name // Make lastlogin human read-able. if ($characters[$i]['lastlogin'] != 0) { $characters[$i]['lastlogin'] = getClock($characters[$i]['lastlogin'], true, false); } else { $characters[$i]['lastlogin'] = '******'; } $characters[$i]['online'] = online_id_to_name($characters[$i]['online']); // 0 to "offline", 1 to "ONLINE". } } return $characters; }