$out .= "</table>";
print_page("Planet List", $out);
} else {
$out .= "There are no planets in the game.<p />";
}
//give listing of all players in game to admin, and some of their details.
} elseif (isset($_GET['player_list'])) {
db("select login_id, cash, turns, turns_run, tech, game_login_count, genesis, one_brob, alpha, gamma, delta from {$db_name}_users where login_id > 5");
while ($player_info = dbr(1)) {
db2("select count(planet_id), sum(fighters), sum(cash), sum(tech), sum(colon), sum(mining_drones), sum(metal), sum(fuel), sum(elect) from {$db_name}_planets where login_id = '{$player_info['login_id']}'");
$planet_info = dbr2(1);
db2("select count(ship_id), sum(fighters), sum(shields), sum(armour), sum(cargo_bays), sum(metal), sum(fuel), sum(elect), sum(colon), sum(point_value), count(distinct location) from {$db_name}_ships where login_id = '{$player_info['login_id']}'");
$ship_info = dbr2(1);
$out .= "<center><hr width = '200'></center><table cellspacing='1' cellpadding='2' border='0' bgcolor='#111111'><tr><th align='left'>" . print_name($player_info) . "</th></tr><tr><td>";
unset($player_info['login_id']);
$player_info['one_brob'] = num_flagships($player_info['one_brob']);
//player info
$out .= make_table(array("Account Cash", "Turns", "Turns Run", "Account Tech", "Logins to game", "Genesis", "Flagship Count", "Alphas", "Gammas", "Delta"));
$out .= make_row($player_info);
//planet info
$out .= "</table><br />Planets<br />" . make_table(array("Planet Count", "Planet Fighters", "Planet Cash", "Tech", "Colonists", "Mining Drones", "Metal", "Fuel", "Electronics"));
$out .= make_row($planet_info);
//ship info
$out .= "</table><br />Ships<br />" . make_table(array("Ship<br />Count", "Ship<br />Fighters", "Shields", "Armour", "Cargo<br />Bays", "Metal", "Fuel", "Electronics", "Colonists", "Point<br />Value", "# Systems <br />with ships"));
$out .= make_row($ship_info);
$out .= "</table></td></tr></table>";
}
print_page("Player Info", $out);
//change intro message
} elseif (isset($_REQUEST['messag'])) {
if ($_REQUEST['messag'] == 1) {
$text .= quick_row($cw['cash'], calc_perc($player['cash'], $all_player['cash']));
$text .= quick_row($st[1516], calc_perc($player['approx_value'], $all_player['approx_value']));
if ($GAME_VARS['uv_num_bmrkt'] > 0) {
$text .= quick_row($st[1517], calc_perc($player['tech'], $all_player['tech']));
}
$text .= quick_row($cw['turns'], calc_perc($player['turns'], $all_player['turns']));
}
$text .= quick_row($cw['turns_run'], calc_perc($player['turns_run'], $all_player['turns_run']));
$text .= quick_row(" ", "");
$text .= quick_row($st[999], calc_perc($player['ships_killed'], $all_player['ships_killed']));
$text .= quick_row($st[998], calc_perc($player['ships_lost'], $all_player['ships_lost']));
$text .= quick_row($st[1518], calc_perc($player['ships_killed_points'], $all_player['ships_killed_points']));
$text .= quick_row($st[1519], calc_perc($player['ships_lost_points'], $all_player['ships_lost_points']));
$text .= quick_row($cw['fighters_killed'], calc_perc($player['fighters_killed'], $all_player['fighters_killed']));
$text .= quick_row($cw['fighters_lost'], calc_perc($player['fighters_lost'], $all_player['fighters_lost']));
$text .= quick_row($st[1520], num_flagships($player['one_brob']));
if ($GAME_VARS['score_method'] != 0) {
db("select count(login_id) from {$db_name}_users where score > '{$player['score']}' && login_id > 5");
$score_front = dbr();
db("select count(login_id) from {$db_name}_users where login_id > 5");
$score_back = dbr();
$score_front[0]++;
$text .= quick_row($cw['score'], $player['score'] . " ({$score_front['0']} of {$score_back['0']})");
}
if ($player['last_attack'] <= 1) {
$text .= quick_row($st[1521], $st[1522]);
$player['last_attack_by'] = " -";
} else {
$text .= quick_row($st[1521], date("M d - H:i", $player['last_attack']));
}
$text .= quick_row($st[1523], $player['last_attack_by']);
