print "<tr>"; print "<th align=\"center\">Rank</th>"; print "<th align=\"center\">Player</th>"; print "<th align=\"center\">{$second_display}</th>"; print "</tr>"; $count = 1; $db4 = new SmrMySqlDatabase(); while ($db->next_record()) { //get the account $curr_account = new SMR_ACCOUNT(); $acc_id = $db->f("account_id"); $db4->query("SELECT * FROM account WHERE account_id = {$acc_id}"); if (!$db4->next_record()) { continue; } $curr_account->get_by_id($db->f("account_id")); $name = stripslashes($curr_account->HoF_name); print "<tr>"; print "<td align=\"center\">{$count}</td>"; $count++; print "<td align=center>{$name}</td>"; print "<td align=center> " . number_format($db->f("{$id}") / $db->f("{$per}"), 2) . " </td>"; print "</tr>"; } print "</table>"; print "<br><br>"; print_table(); print "<tr>"; print "<th align=\"center\">Rank</th>"; print "<th align=\"center\">Player</th>"; print "<th align=\"center\">{$second_display}</th>";
if (isset($game_id)) { $container["game_id"] = $game_id; } print_link($container, "<b><<Back</b>"); print "<br>"; print "Here are the ranks of players by {$cat} {$action}<br><br>"; print_table(); print "<tr><th align=center>Rank</th><th align=center>Player</th><th align=center>{$cat} {$action}</th></tr>"; if ($cat == "<b>Money Donated to SMR</b>") { $db->query("SELECT account_id, sum(amount) as amount FROM account_donated " . "GROUP BY account_id ORDER BY amount DESC LIMIT 25"); } else { $db->query("SELECT account_id, {$row} as amount FROM {$table} {$row} > 0 ORDER BY amount DESC LIMIT 25"); } while ($db->next_record()) { $this_acc = new SMR_ACCOUNT(); $this_acc->get_by_id($db->f("account_id")); if ($db->f("account_id") == ".SmrSession::{$old_account_id}.") { $bold = " style=\"font-weight:bold;\""; } else { $bold = ""; } print "<tr>"; print "<td align=center{$bold}>" . $rank++ . "</td>"; //link to stat page $container = array(); $container["url"] = "skeleton.php"; $container["body"] = "hall_of_fame_player_detail.php"; $container["acc_id"] = $db->f("account_id"); if (isset($game_id)) { $container["game_id"] = $game_id; $container["sending_page"] = 'current_hof';
} //no duplicates $db->query("SELECT * FROM account_has_stats WHERE HoF_name = " . format_string($HoF_name, true) . " AND account_id <> {$account->account_id}"); if ($db->next_record()) { create_error("Someone is already using that name!"); } // set the HoF name in account stat $db->query("UPDATE account_has_stats SET HoF_name = " . format_string($HoF_name, true) . " WHERE account_id = {$account->account_id}"); } elseif ($action == "Yes") { $account_id = $var["account_id"]; $amount = $var["amount"]; // take from us $account->set_credits($account->get_credits() - $amount); // create his account $his_account = new SMR_ACCOUNT(); $his_account->get_by_id($account_id); // add to him $his_account->set_credits($his_account->get_credits() + $amount); } elseif ($action == "Change Timezone") { $timez = $_REQUEST['timez']; if (!is_numeric($timez)) { create_error("Numbers only please"); } $db->query("UPDATE account SET offset = {$timez} WHERE account_id = " . SmrSession::$old_account_id); } elseif ($action == "Change") { $account->images = $_REQUEST['images']; $account->update(); } else { if ($action == "Change Size" && is_numeric($_REQUEST['fontsize']) && $_REQUEST['fontsize'] > 50) { $db->query("UPDATE account SET fontsize=" . $_REQUEST['fontsize'] . " WHERE account_id = " . SmrSession::$old_account_id); $account->fontsize = $_REQUEST['fontsize'];
<?php require_once get_file_loc('smr_alliance.inc'); $alliance = new SMR_ALLIANCE($player->alliance_id, SmrSession::$game_id); $account_id = $_REQUEST['account_id']; foreach ($account_id as $id) { if ($id == $alliance->leader_id) { create_error("You can't remove the leader!"); } // generate list of messages that should be deleted if ($account_id_list) { $account_id_list .= ","; } $account_id_list .= $id; $player->send_message($id, 2, format_string("You were kicked out of the alliance!", false)); $curr_acc = new SMR_ACCOUNT(); $curr_acc->get_by_id($id); $curr_acc->log(3, "kicked from alliance: {$alliance->alliance_name} by leader", 0); } $db->query("UPDATE player SET alliance_id = 0 WHERE account_id IN ({$account_id_list}) AND " . "game_id = {$player->game_id}"); $db->query("DELETE FROM player_has_alliance_role WHERE game_id = {$player->game_id} AND account_id IN ({$account_id_list})"); forward(create_container("skeleton.php", "alliance_roster.php"));
function displayMessage($message_id, $sender_id, $message_text, $send_time, $msg_read, $type) { global $player, $account; $replace = explode("!", $message_text); foreach ($replace as $key => $timea) { if (($final = strtotime($timea)) !== false && $timea != "") { $final += $account->offset * 3600; $message_text = str_replace("!{$timea}!", date("n/j/Y g:i:s A", $final), "{$message_text}"); } } $replace = explode("?", $message_text); foreach ($replace as $key => $timea) { if (($final = strtotime($timea)) !== false && $sender_id > 0 && $timea != "") { $send_acc = new SMR_ACCOUNT(); $send_acc->get_by_id($sender_id); $final += $account->offset * 3600 - $send_acc->offset * 3600; $message_text = str_replace("?{$timea}?", date("n/j/Y g:i:s A", $final), "{$message_text}"); } } if (!empty($sender_id)) { $sender = new SMR_PLAYER($sender_id, $player->game_id); } print "<tr>"; print "<td width=\"10\"><input type=\"checkbox\" name=\"message_id[]\" value=\"{$message_id}\">"; // remember id for marking as read if ($msg_read == 'FALSE') { print "*"; } print "</td>"; print "<td nowrap=\"nowrap\" width=\"100%\">From: "; if (!empty($sender_id)) { $container = array(); $container["url"] = "skeleton.php"; $container["body"] = "trader_search_result.php"; $container["player_id"] = $sender->player_id; print_link($container, $sender->get_colored_name()); } else { if ($type == 7) { print "<span style=\"font:small-caps bold;color:blue;\">Administrator</span>"; } elseif ($type == 6) { print "<span class=\"green\">"; print "Alliance Ambassador"; print "</span>"; } elseif ($type == 2) { print "<span class=\"yellow\">Port Defenses</span>"; } else { print "Unknown"; } } print "</td>"; print "<td nowrap=\"nowrap\">Date: " . date("n/j/Y g:i:s A", $send_time) . "</td>"; print "<td>"; $container = array(); $container["url"] = "skeleton.php"; $container["body"] = "message_notify_confirm.php"; $container["message_id"] = $message_id; $container["sent_time"] = $send_time; $container["notified_time"] = time(); print_link($container, "<img src=\"images/notify.gif\" border=\"0\" align=\"right\"title=\"Report this message to an admin\">"); print "</td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"4\">{$message_text}</td>"; print "</tr>"; }
// * // ******************************** $db->query("SELECT account_id FROM hidden_players"); $HIDDEN_PLAYERS = array(0); while ($db->next_record()) { $HIDDEN_PLAYERS[] = $db->f("account_id"); } // ******************************** // * // * A c c o u n t // * // ******************************** // create account object $account = new SMR_ACCOUNT(); // get account from db $account->get_by_id(SmrSession::$old_account_id); // ******************************** // * // * g e t S e s s i o n // * // ******************************** $sn = $_REQUEST['sn']; // check if we got a sn number with our url if (empty($sn)) { create_error('Your browser lost the SN. Try to reload the page!'); } // do we have such a container object in the db? if (!($var = SmrSession::retrieveVar($sn))) { create_error('Please avoid using the back button!'); } //used for include if we need a spec game script outside of the game
<?php require_once get_file_loc("smr_history_db.inc"); function cust_round($x) { return round($x / 10) * 10; } $acc_id = $var["acc_id"]; //view rankings of other players $this_acc = new SMR_ACCOUNT(); $this_acc->get_by_id($acc_id); $rank_id = $this_acc->get_rank(); $game_id = $var["game_id"]; $hof_name = stripslashes($this_acc->HoF_name); $db->query("SELECT * FROM rankings WHERE rankings_id = {$rank_id}"); if ($db->next_record()) { $rank_name = $db->f("rankings_name"); } // initialize vars $kills = 0; $exp = 0; // get stats $db->query("SELECT * from account_has_stats_cache WHERE account_id = {$this_acc->account_id}"); if ($db->next_record()) { $kills = $db->f("kills") > 0 ? $db->f("kills") : 0; $exp = $db->f("experience_traded") > 0 ? $db->f("experience_traded") : 0; } if ($var['sending_page'] == 'hof') { print_topic("Extended User Rankings for {$hof_name}"); print "{$hof_name} has <font color=\"red\">{$kills}</font> kills and <font color=\"red\">{$exp}</font> traded experience<br><br>"; print "{$hof_name} is ranked as a <font size=\"4\" color=\"greenyellow\">{$rank_name}</font> player.<br><br>";
print "<th>"; print_link($container, "<font color=#80c870>Race</font>"); print "</th>"; $container["sort"] = "alliance_id"; print "<th>"; print_link($container, "<font color=#80c870>Alliance</font>"); print "</th>"; $container["sort"] = "experience"; print "<th>"; print_link($container, "<font color=#80c870>Experience</font>"); print "</th>"; print "</tr>"; //while ($db->next_record()) { foreach ($exp as $acc_id => $exp) { $curr_account = new SMR_ACCOUNT(); $curr_account->get_by_id($acc_id); //reset style $style = ""; $curr_player = new SMR_PLAYER($acc_id, SmrSession::$game_id); $curr_player->get_display_xp_lvl(); if ($curr_account->veteran == "FALSE" && $curr_account->get_rank() < FLEDGLING) { $style = "font-style:italic;"; } if ($curr_player->account_id == $player->account_id) { $style .= "font-weight:bold;"; } $fullStyle = ''; if (!empty($style)) { $fullStyle = " style=\"{$style}\""; } print "<tr>";
// We need a lock on the new sector so that more than one person isn't hitting the same mines acquire_lock($player->sector_id); // delete plotted course $db->query("DELETE FROM player_plotted_course " . "WHERE account_id = {$player->account_id} AND " . "game_id = {$player->game_id}"); // get new sector object $sector = new SMR_SECTOR($player->sector_id, $player->game_id, $player->account_id); // make current sector visible to him $sector->mark_visited(); // send scout msg $sector->entering_sector(); $db->query("SELECT * FROM sector_has_forces, player " . "WHERE sector_has_forces.game_id = player.game_id AND " . "sector_has_forces.owner_id = player.account_id AND " . "sector_has_forces.game_id = {$player->game_id} AND " . "sector_has_forces.sector_id = {$player->sector_id} AND " . "mines > 0 AND " . "owner_id != {$player->account_id} AND " . "(alliance_id != {$player->alliance_id} OR alliance_id = 0)"); while ($db->next_record()) { // we may skip forces if this is a protected gal. if ($sector->is_protected_gal()) { $forces_account = new SMR_ACCOUNT(); $forces_account->get_by_id($db->f("owner_id")); // if one is vet and the other is newbie we skip it if (different_level($rank_id, $forces_account->get_rank(), $account->veteran, $forces_account->veteran)) { continue; } } if ($player->newbie_turns > 0) { $container = array(); $container["url"] = "skeleton.php"; $container["body"] = "current_sector.php"; $container["msg"] = "You have just flown past a sprinkle of mines.<br>Because of your newbie status you have been spared from the harsh reality of the forces."; forward($container); } else { $owner_id = $db->f("owner_id"); include "forces_minefield_processing.php"; exit;