$temp_condition .= $mmrpg_database_players_filter;
}
// Collect the database players and fields
$player_fields = rpg_player::get_index_fields(true);
$db->query("SET @player_row_number = 0;");
$mmrpg_database_players = $db->get_array_list("SELECT {$player_fields} FROM mmrpg_index_players WHERE player_flag_published = 1 AND (player_flag_hidden = 0 OR player_token = '{$this_current_token}') {$temp_condition} ORDER BY player_flag_hidden ASC, player_order ASC;", 'player_token');
$mmrpg_database_players_count = $db->get_value("SELECT COUNT(player_id) AS player_count FROM mmrpg_index_players WHERE player_flag_published = 1 AND player_flag_hidden = 0 {$temp_condition_unfiltered};", 'player_count');
$mmrpg_database_players_numbers = $db->get_array_list("SELECT player_token, (@player_row_number:=@player_row_number + 1) AS player_key FROM mmrpg_index_players WHERE player_flag_published = 1 {$temp_condition_unfiltered} ORDER BY player_flag_hidden ASC, player_order ASC;", 'player_token');
// Remove unallowed players from the database
foreach ($mmrpg_database_players as $temp_token => $temp_info) {
// Define first player token if not set
if (!isset($first_player_token)) {
$first_player_token = $temp_token;
}
// Send this data through the player index parser
$temp_info = rpg_player::parse_index_info($temp_info);
// Collect this player's key in the index
$temp_info['player_key'] = $mmrpg_database_players_numbers[$temp_token]['player_key'];
// Ensure this player's image exists, else default to the placeholder
$mmrpg_database_players[$temp_token]['player_image'] = $temp_token;
// Update the main database array with the changes
$mmrpg_database_players[$temp_token] = $temp_info;
}
// Loop through the database and generate the links for these players
$key_counter = 0;
$mmrpg_database_players_links = '';
$mmrpg_database_players_links .= '<div class="float link group" data-game="MM00">';
$mmrpg_database_players_links_counter = 0;
$mmrpg_database_players_count_complete = 0;
// Loop through the results and generate the links for these players
foreach ($mmrpg_database_players as $player_key => $player_info) {
elseif ($active && $sort_direction == 'desc'){ echo ' <sup>↑</sup>'; }
echo '</th>'.PHP_EOL;
} else {
echo '<th class="'.$class.'"> </th>'.PHP_EOL;
}
}
?>
</tr>
</thead>
<tbody>
<?
// Loop through collected players and list their details
if (!empty($player_index)){
foreach ($player_index AS $player_id => $player_info){
// Parse the player info before displaying it
$player_info = rpg_player::parse_index_info($player_info);
// Collect the display fields from the array
$player_token = $player_info['player_token'];
$player_name = $player_info['player_name'];
$player_group = '<span class="token">'.$player_info['player_group'].'</span>';
$player_type1 = !empty($player_info['player_type']) && !empty($type_index[$player_info['player_type']]) ? $type_index[$player_info['player_type']] : $type_index['none'];
$type_string = '<span class="type '.$player_type1['type_token'].'">'.$player_type1['type_name'].'</span>';
$edit_link = 'admin/players/'.$player_id.'/';
$view_link = 'database/players/'.$player_token.'/';
$complete = $player_info['player_flag_complete'] ? true : false;
$published = $player_info['player_flag_published'] ? true : false;
$hidden = $player_info['player_flag_hidden'] ? true : false;
// Print out the player info as a table row
?>
<tr class="object<?php
echo !$published ? ' unpublished' : '';
