$port_info[$good_id] = $transaction;
}
//insert the last port
$db2->query("REPLACE INTO player_visited_port (account_id, game_id, sector_id, visited, port_info) " . "VALUES({$account_id}, {$game_id}, {$current_sector_id}, {$current_time}, '" . addslashes(serialize($port_info)) . "')");
//offer another drink and such
print "<div align=center>Galaxy Info has been added. Enjoy!</div><br>";
include get_file_loc("bar_opening.php");
} else {
//find what gal they want
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "bar_main.php";
$container["script"] = "bar_galmap_buy.php";
$container["process"] = "yes";
print "<div align=center>What galaxy do you want info on?<br>";
print_form($container);
print "<select type=select name=gal_id>";
print "<option value=0>[Select a galaxy]</option>";
$db->query("SELECT galaxy_id FROM sector WHERE game_id = {$player->game_id} GROUP BY galaxy_id ORDER BY galaxy_id ASC");
$db2 = new SmrMySqlDatabase();
while ($db->next_record()) {
$gal_id = $db->f("galaxy_id");
$db2->query("SELECT * FROM galaxy WHERE galaxy_id = {$gal_id}");
if ($db2->next_record()) {
print "<option value={$gal_id}>" . $db2->f("galaxy_name") . "</option>";
}
}
print "</select><br>";
print_submit("Buy the map");
print "</form></div>";
}
//unknown level
$level = 0;
}
} else {
//no planet
$planet = 0;
$level = 0;
}
if ($planet > 0 || $race > 0) {
$file .= addbyte($planet + $race);
}
if ($planet > 0) {
$file .= addbyte($level);
}
$db3->query("SELECT * FROM warp WHERE game_id = {$game_id} AND (sector_id_1 = {$sector_id} OR sector_id_2 = {$sector_id}) LIMIT 1");
if ($db3->next_record()) {
$CurrByte = 128;
} else {
$CurrByte = 0;
}
// locations
$db2->query("SELECT * FROM location NATURAL JOIN location_type WHERE game_id = {$game_id} AND sector_id = {$sector_id} LIMIT 1");
$CurrByte += $db2->nf();
$file .= addbyte($CurrByte);
// warp
$db3->query("SELECT * FROM warp WHERE game_id = {$game_id} AND (sector_id_1 = {$sector_id} OR sector_id_2 = {$sector_id}) LIMIT 1");
if ($db3->next_record()) {
$warp_id = $db3->f("sector_id_1") == $sector_id ? $db3->f("sector_id_2") : $db3->f("sector_id_1");
$file .= add2bytes($warp_id);
}
while ($db2->next_record()) {
echo '<div align=center>';
echo '<table cellspacing="0" cellpadding="0" class="standard inset" ><tr><th>ID</th><th>Password</th><th>Last Transaction</th><th>Balance</th><th>Option</th></tr>';
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "bank_anon.php";
$db2 = new SmrMySqlDatabase();
while ($db->next_record()) {
$db2->query('SELECT MAX(time) FROM anon_bank_transactions
WHERE game_id=' . $player->game_id . '
AND anon_id=' . $db->f('anon_id') . ' LIMIT 1');
echo '<tr><td class="shrink center">';
echo $db->f("anon_id");
echo '</td><td>';
echo $db->f("password");
echo '</td><td class="shrink nowrap">';
if ($db2->next_record() && $db2->f('MAX(time)')) {
echo date('n/j/Y g:i:s A', $db2->f('MAX(time)'));
} else {
echo 'No transactions';
}
echo '</td><td class="right shrink">';
echo $db->f("amount");
echo '</td><td class="button">';
$container["account_num"] = $db->f("anon_id");
$container["password"] = $db->f("password");
print_button($container, 'Access Account');
echo '</td></tr>';
}
echo '</table></div><br>';
}
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "hall_of_fame_new.php";
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)) {
print "<th>Cost</th>";
print "<th>Build</th>";
print "</tr>";
// get game speed
$db->query("SELECT * FROM game WHERE game_id = {$player->game_id}");
if ($db->next_record()) {
$game_speed = $db->f("game_speed");
}
$db2 = new SmrMySqlDatabase();
$db->query("SELECT * FROM planet_construction ORDER BY construction_id");
while ($db->next_record()) {
$construction_id = $db->f("construction_id");
$construction_name = $db->f("construction_name");
$construction_description = $db->f("construction_description");
$db2->query("SELECT * FROM planet_cost_credits WHERE construction_id = {$construction_id}");
if ($db2->next_record()) {
$cost = $db2->f("amount");
}
/*$container = array();
$container["url"] = "planet_construction_processing.php";
$container["construction_id"] = $construction_id;
$container["cost"] = $cost;
print_form($container);*/
print "<tr>";
print "<td>{$construction_name}</td>";
print "<td>{$construction_description}</td>";
print "<td align=\"center\">";
print $planet->construction[$construction_id];
print "/";
print $planet->max_construction[$construction_id];
$curr_attacker->relations[$port->race_id] -= 5;
if ($curr_attacker->relations[$port->race_id] < -500) {
$curr_attacker->relations[$port->race_id] = -500;
}
// save what we got so far
$curr_attacker->update();
// disable cloak
$curr_attacker_ship->disable_cloak();
// the damage this attacker is going to do
$attacker_damage = 0;
// and his message array
$damage_msg = array();
$weapon = new SmrMySqlDatabase();
$weapon->query("SELECT * FROM ship_has_weapon NATURAL JOIN weapon_type " . "WHERE account_id = {$curr_attacker->account_id} AND " . "game_id = {$curr_attacker->game_id} " . "ORDER BY order_id");
// iterate over all existing weapons
while ($weapon->next_record()) {
//vars
$weapon_name = $weapon->f("weapon_name");
$shield_damage = $weapon->f("shield_damage");
$armor_damage = $weapon->f("armor_damage");
$accuracy = $weapon->f("accuracy");
// calc accuracy for this weapon
$hit = round($accuracy + $curr_attacker->level_id - $port->level / 2);
// did we hit with this weapon?
if (mt_rand(0, 100) < $hit) {
// does the port has shields?
if ($port->shields > 0) {
if ($shield_damage > 0) {
// do we do more damage than shields left?
if ($shield_damage > $port->shields) {
$shield_damage = $port->shields;
print "<th>Rank</th>";
print "<th>Race</th>";
print "<th>Total Experience</th>";
print "<th>Average Experience</th>";
print "<th>Total Traders</th>";
print "</tr>";
$rank = 0;
$db2 = new SmrMySqlDatabase();
$db->query("SELECT player.race_id as race_id, race_name, sum(player_cache.experience) as experience_sum, count(player_cache.account_id) as members FROM player,player_cache NATURAL JOIN race WHERE race.race_id = player.race_id AND (player_cache.account_id = player.account_id AND player_cache.game_id = {$player->game_id}) AND player.game_id = {$player->game_id} GROUP BY player.race_id ORDER BY experience_sum DESC");
while ($db->next_record()) {
$rank++;
$race_id = $db->f("race_id");
$db2->query("SELECT * FROM player WHERE race_id = {$race_id} AND game_id = {$player->game_id} AND out_of_game = 'TRUE'");
if ($player->race_id == $race_id) {
$style = " style=\"font-weight:bold;\"";
} elseif ($db2->next_record()) {
$style = " style=\"color:red;\"";
} else {
$style = "";
}
if ($db2->next_record()) {
$style .= (print "<tr>");
}
print "<td align=\"center\"{$style}>{$rank}</td>";
print "<td align=\"center\"{$style}>" . $db->f("race_name") . "</td>";
print "<td align=\"center\"{$style}>" . $db->f("experience_sum") . "</td>";
print "<td align=\"center\"{$style}>" . round($db->f("experience_sum") / $db->f("members")) . "</td>";
print "<td align=\"center\"{$style}>" . $db->f("members") . "</td>";
print "</tr>";
}
print "</table>";
if ($db->nf()) {
//we have people who meet this category
print_table();
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>";
$container["url"] = "skeleton.php";
$container["body"] = "galactic_post_view_article.php";
transfer("id");
print_form($container);
print_submit("No");
print "</form>";
} else {
$db->query("SELECT * FROM galactic_post_paper WHERE game_id = {$player->game_id} AND paper_id = {$var['id']}");
$db->next_record();
$title = $db->f("title");
print "Are you sure you want to delete the paper titled {$title} and the following articles with it<br><br>";
$db2->query("SELECT * FROM galactic_post_paper_content WHERE game_id = {$player->game_id} AND paper_id = {$var['id']}");
while ($db2->next_record()) {
$article_id = $db2->f("article_id");
$db3->query("SELECT * FROM galactic_post_article WHERE game_id = {$player->game_id} AND article_id = {$article_id}");
$db3->next_record();
$article_title = stripslashes($db3->f("title"));
print "{$article_title}<br>";
}
print "<br>";
$container = array();
$container["url"] = "galactic_post_delete.php";
transfer("paper");
transfer("id");
print_form($container);
print_submit("Yes");
print "</form>";
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "galactic_post_view_article.php";
transfer("id");
<?php
$container = array();
$container['url'] = 'skeleton.php';
$container['body'] = 'message_blacklist.php';
if (!isset($_REQUEST['PlayerName'])) {
$container['error'] = 1;
forward($container);
exit;
}
$player_name = mysql_real_escape_string($_REQUEST['PlayerName']);
$db = new SmrMySqlDatabase();
$db->query('SELECT account_id FROM player WHERE player_name=\'' . $player_name . '\' AND game_id=' . SmrSession::$game_id . ' LIMIT 1');
if (!$db->next_record()) {
$container['error'] = 1;
forward($container);
exit;
}
$blacklisted_id = $db->f('account_id');
$db->query('SELECT account_id FROM message_blacklist WHERE account_id=' . SmrSession::$old_account_id . ' AND blacklisted_id=' . $blacklisted_id . ' AND game_id=' . SmrSession::$game_id . ' LIMIT 1');
if ($db->next_record()) {
$container['error'] = 2;
forward($container);
exit;
}
$db->query('INSERT INTO message_blacklist (game_id,account_id,blacklisted_id) VALUES (' . SmrSession::$game_id . ',' . SmrSession::$old_account_id . ',' . $blacklisted_id . ')');
$container['error'] = 3;
forward($container);
print "<th align=\"center\">";
print_link($container, "<span style=\"color:#80C870;\">Scout Drones</span>");
print "</th>";
$container["category"] = "mines";
print "<th align=\"center\">";
print_link($container, "<span style=\"color:#80C870;\">Mines</span>");
print "</th>";
$container["category"] = "expire_time";
print "<th align=\"center\">";
print_link($container, "<span style=\"color:#80C870;\">Expire time</span>");
print "</th>";
print "</tr>";
while ($db->next_record()) {
$force_sector = $db->f("sector_id");
$db2->query("SELECT * FROM sector WHERE sector_id = {$force_sector} AND game_id = {$player->game_id}");
$db2->next_record();
$gal_id = $db2->f("galaxy_id");
$db2->query("SELECT * FROM galaxy WHERE galaxy_id = {$gal_id}");
$db2->next_record();
$galaxy_name = $db2->f("galaxy_name");
$force_sd = $db->f("scout_drones");
$force_cd = $db->f("combat_drones");
$force_mine = $db->f("mines");
$force_time = $db->f("expire_time");
print "<tr>";
print "<td align=\"center\">{$force_sector} ({$galaxy_name})</td>";
print "<td align=\"center\">{$force_cd}</td>";
print "<td align=\"center\">{$force_sd}</td>";
print "<td align=\"center\">{$force_mine}</td>";
print "<td align=\"center\">" . date("n/j/Y g:i:s A", $force_time) . "</td>";
print "</tr>";
function do_voodoo()
{
ob_clean();
global $lock, $var;
foreach ($GLOBALS as $key => $value) {
${$key} =& $GLOBALS[$key];
}
// initialize objects we usually need, like player, ship
if (SmrSession::$game_id > 0) {
$db = new SmrMySqlDatabase();
// We need to acquire locks BEFORE getting the player information
// Otherwise we could be working on stale information
$db->query('SELECT sector_id FROM player WHERE account_id=' . SmrSession::$old_account_id . ' AND game_id=' . SmrSession::$game_id . ' LIMIT 1');
$db->next_record();
$sector_id = $db->f('sector_id');
if (!$lock && $var['body'] != 'error.php' && !isset($var['ForwardError'])) {
if (!acquire_lock($sector_id)) {
create_error("Failed to acquire sector lock");
}
}
// Now that they've acquire a lock we can move on
$player = new SMR_PLAYER(SmrSession::$old_account_id, SmrSession::$game_id);
if ($player->dead == 'TRUE' && $var['body'] != 'death.php' && !isset($var['override_death'])) {
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "death.php";
forward($container);
}
$ship = new SMR_SHIP(SmrSession::$old_account_id, SmrSession::$game_id);
// update turns on that player
$player->update_turns($ship->speed);
if ($player->newbie_turns <= 20 && $player->newbie_warning == "TRUE" && $var["body"] != "newbie_warning.php") {
forward(create_container("skeleton.php", "newbie_warning.php"));
}
}
require get_file_loc($var["url"]);
SmrSession::update();
if ($lock) {
release_lock($lock);
}
exit;
}
// test if we are searched. (but only if we hadn't a previous trade here
} elseif ($player->controlled != $player->sector_id) {
$db->query("SELECT * FROM port_has_goods " . "WHERE game_id = {$player->game_id} AND " . "sector_id = {$player->sector_id} AND " . "(good_id = 5 OR good_id = 9 OR good_id = 12)");
$base_chance = 15 - $db->nf() * 4;
if ($ship->ship_type_id == 23 || $ship->ship_type_id == 24 || $ship->ship_type_id == 25) {
$base_chance -= 4;
}
$rand = mt_rand(1, 100);
if ($rand <= $base_chance) {
if (!empty($ship->cargo[5]) || !empty($ship->cargo[9]) || !empty($ship->cargo[12])) {
//find the fine
//get base for ports that dont happen to trade that good
$query = new SmrMySqlDatabase();
$query->query("SELECT * FROM good WHERE good_id = 5 OR good_id = 9 OR good_id = 12");
$base = array();
while ($query->next_record()) {
$base[$query->f("good_id")] = $query->f("base_price");
}
$fine = $port->level * ($ship->cargo[5] * $base[5] + $ship->cargo[9] * $base[9] + $ship->cargo[12] * $base[12]);
$player->credits -= $fine;
if ($player->credits < 0) {
// because credits is 0 it will take money from bank
$player->bank += $player->credits;
// set credits to zero
$player->credits = 0;
// leave insurance
if ($player->bank < 5000) {
$player->bank = 5000;
}
}
print "<span style=\"color:red;\">The Federation searched your ship and illegal goods were found!</span><br>";
$attacker_total_msg = array();
$attacker_msg = array();
if ($player->getAllianceID() != 0) {
$db->query('SELECT * FROM player ' . 'WHERE game_id = ' . $player->getGameID() . ' AND ' . 'alliance_id = ' . $player->getAllianceID() . ' AND ' . 'sector_id = ' . $player->getSectorID() . ' AND ' . 'land_on_planet = \'FALSE\' AND ' . 'newbie_turns = 0 ' . 'ORDER BY rand() LIMIT 10');
} else {
$db->query('SELECT * FROM player ' . 'WHERE game_id = ' . $player->getGameID() . ' AND ' . 'sector_id = ' . $player->getSectorID() . ' AND ' . 'account_id = ' . $player->getAccountID() . ' AND ' . 'land_on_planet = \'FALSE\' AND ' . 'newbie_turns = 0');
}
$db2 = new SmrMySqlDatabase();
while ($db->next_record() && ($forces->hasCDs() || $forces->hasSDs() || $forces->hasMines())) {
$curr_attacker =& SmrPlayer::getPlayer($db->f('account_id'), SmrSession::$game_id);
$curr_attacker_ship = new SMR_SHIP($db->f('account_id'), SmrSession::$game_id);
// disable cloak
$curr_attacker_ship->disable_cloak();
$db2->query('SELECT * FROM ship_has_weapon, weapon_type ' . 'WHERE account_id = ' . $curr_attacker->getAccountID() . ' AND ' . 'game_id = ' . SmrSession::$game_id . ' AND ' . 'ship_has_weapon.weapon_type_id = weapon_type.weapon_type_id ' . 'ORDER BY order_id');
// iterate over all existing weapons
while ($db2->next_record() && ($forces->hasCDs() || $forces->hasSDs() || $forces->hasMines())) {
$weapon_name = $db2->f('weapon_name');
$shield_damage = $db2->f('shield_damage');
$armour_damage = $db2->f('armour_damage');
$accuracy = $db2->f('accuracy');
if ($forces->hasMines()) {
if ($armour_damage > 0) {
// mines take 20 armour damage each
$mines_dead = round($armour_damage / 20);
// more damage than mines?
if ($mines_dead > $forces->getMines()) {
$mines_dead = $forces->getMines();
}
// subtract mines that died
$forces->takeMines($mines_dead);
// add damage we did
$attacker_total_msg = array();
$attacker_msg = array();
if ($player->alliance_id != 0) {
$db->query("SELECT * FROM player " . "WHERE game_id = {$player->game_id} AND " . "alliance_id = {$player->alliance_id} AND " . "sector_id = {$player->sector_id} AND " . "land_on_planet = 'FALSE' AND " . "newbie_turns = 0 " . "ORDER BY rand() LIMIT 10");
} else {
$db->query("SELECT * FROM player " . "WHERE game_id = {$player->game_id} AND " . "sector_id = {$player->sector_id} AND " . "account_id = {$player->account_id} AND " . "land_on_planet = 'FALSE' AND " . "newbie_turns = 0");
}
$db2 = new SmrMySqlDatabase();
while ($db->next_record() && ($forces->combat_drones > 0 || $forces->scout_drones > 0 || $forces->mines > 0)) {
$curr_attacker = new SMR_PLAYER($db->f("account_id"), SmrSession::$game_id);
$curr_attacker_ship = new SMR_SHIP($db->f("account_id"), SmrSession::$game_id);
// disable cloak
$curr_attacker_ship->disable_cloak();
$db2->query("SELECT * FROM ship_has_weapon, weapon_type " . "WHERE account_id = {$curr_attacker->account_id} AND " . "game_id = " . SmrSession::$game_id . " AND " . "ship_has_weapon.weapon_type_id = weapon_type.weapon_type_id " . "ORDER BY order_id");
// iterate over all existing weapons
while ($db2->next_record() && ($forces->combat_drones > 0 || $forces->scout_drones > 0 || $forces->mines > 0)) {
$weapon_name = $db2->f("weapon_name");
$shield_damage = $db2->f("shield_damage");
$armor_damage = $db2->f("armor_damage");
$accuracy = $db2->f("accuracy");
if ($forces->mines > 0) {
if ($armor_damage > 0) {
// mines take 20 armor damage each
$mines_dead = round($armor_damage / 20);
// more damage than mines?
if ($mines_dead > $forces->mines) {
$mines_dead = $forces->mines;
}
// subtract mines that died
$forces->mines -= $mines_dead;
// add damage we did
