echo 'You ask the bartender for some water and you quickly down it.<br>You dont feel quite so intoxicated anymore.<br>';
$db2->query('DELETE FROM player_has_drinks WHERE game_id=' . $player->game_id . ' AND account_id=' . $player->account_id . ' LIMIT 1');
} else {
$random = mt_rand(1, 20);
//only get Azool or Spock drink if they are very lucky
if ($random != 1) {
$db->query("SELECT * FROM bar_drink WHERE drink_id != 1 && drink_id != 11 ORDER BY rand() LIMIT 1");
} else {
$db->query("SELECT * FROM bar_drink ORDER BY rand() LIMIT 1");
}
if ($db->next_record()) {
$drink_name = $db->f("drink_name");
$drink_id = $db->f("drink_id");
$db2->query("SELECT * FROM player_has_drinks WHERE game_id = " . SmrSession::$game_id . " ORDER by drink_id DESC LIMIT 1");
if ($db2->next_record()) {
$curr_drink_id = $db2->f("drink_id") + 1;
} else {
$curr_drink_id = 1;
}
if ($drink_id != 11 && $drink_id != 1) {
print "You have bought a {$drink_name} for \$10";
$db2->query("INSERT INTO player_has_drinks (account_id, game_id, drink_id, time) VALUES ({$player->account_id}, " . SmrSession::$game_id . ", {$curr_drink_id}, {$time})");
} else {
print "The bartender says, Ive got something special for ya.<br>";
print "The bartender turns around for a minute and whips up a {$drink_name}.<br>";
if ($drink_id == 1) {
print "The bartender says that Spock himself gave him the directions to make this drink.<br>";
}
print "You drink the {$drink_name} and feel like like you have been drinking for hours.<br>";
if ($drink_id == 11) {
print "After drinking the {$drink_name} you feel like nothing can bring you down and like you are the best trader in the universe.<br>";
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();
$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>";
}
return;
}
print_topic("Confirmation");
print "Are you sure you want to transfer {$amount} credits to<br>";
$db->query("SELECT * FROM account WHERE account_id = {$account_id}");
if ($db->next_record()) {
$login = $db->f("login");
}
$db->query("SELECT * FROM player WHERE account_id = {$account_id}");
if ($db->nf()) {
while ($db->next_record()) {
$player_name = stripslashes($db->f("player_name"));
$game_id = $db->f("game_id");
$db2->query("SELECT * FROM game WHERE game_id = {$game_id}");
if ($db2->next_record()) {
$game_name = $db2->f("game_name");
}
print "{$player_name} in game {$game_name}({$game_id})<br>";
}
} else {
print "Player with login name {$login}?<br>";
}
print "<p> </p>";
$container = array();
$container["url"] = "preferences_processing.php";
$container["account_id"] = $account_id;
$container["amount"] = $amount;
print_form($container);
print_submit("Yes");
print " ";
print_submit("No");
$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;
}
// accumulate the attacker_damage
print_topic("FEDERAL HQ");
}
// header menue
include get_file_loc('menue.inc');
print_hq_menue();
// secondary db object
$db2 = new SmrMySqlDatabase();
if (isset($location_type_id)) {
print "<div align=\"center\">We are at WAR with<br><br>";
$db->query("SELECT * FROM race_has_relation WHERE game_id = {$player->game_id} AND race_id_1 = {$race_id}");
while ($db->next_record()) {
$relation = $db->f("relation");
$race_2 = $db->f("race_id_2");
$db2->query("SELECT * FROM race WHERE race_id = {$race_2}");
$db2->next_record();
$race_name = $db2->f("race_name");
if ($relation <= -300) {
print "<span style=\"color:red;\">The {$race_name}<br></span>";
}
}
print "<br>The government will PAY for the destruction of their ships!";
}
$db->query("SELECT * FROM bounty WHERE game_id = {$player->game_id} AND type = 'HQ' AND claimer_id = 0 ORDER BY amount DESC");
print "<p> </p>";
if ($db->nf()) {
print "<div align=\"center\">Most Wanted by Federal Government</div><br>";
print_table();
print "<tr>";
print "<th>Player Name</th>";
print "<th>Bounty Amount</th>";
print "</tr>";
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;
while ($db->next_record()) {
//get the account
$curr_account = new SMR_ACCOUNT();
$curr_account->get_by_id($db->f("account_id"));
$name = stripslashes($curr_account->HoF_name);
$db2 = new SmrMySqlDatabase();
if ($id == 'donation') {
$db2->query("SELECT sum(amount) FROM account_donated WHERE account_id = {$curr_account->account_id}");
$db2->next_record();
$stat = $db2->f("sum(amount)");
} else {
$stat = $db->f("{$id}");
}
print "<tr>";
print "<td align=\"center\">{$count}</td>";
print "<td align=center>{$name}</td>";
if ($action != "Experience Gained") {
print "<td align=center> " . number_format($stat) . " </td>";
} else {
print "<td align=center> " . number_format($stat / 4, 2) . " </td>";
}
$count++;
print "</tr>";
}
print "</table>";
if ($planet->build()) {
print "{$planet->current_building_name}<br>";
print print_time($planet->time_left);
} else {
print "Nothing";
}
print "</td>";
print "<td align=\"center\">{$planet->shields}</td>";
print "<td align=\"center\">{$planet->drones}</td>";
print "<td align=\"left\">";
$supply = false;
foreach ($planet->stockpile as $id => $amount) {
if ($amount > 0) {
$db2->query("SELECT * FROM good WHERE good_id = {$id}");
if ($db2->next_record()) {
print $db2->f("good_name") . ": {$amount}<br>";
}
$supply = true;
}
}
if (!$supply) {
print "none";
}
print "</td>";
}
print "</table>";
print "</div>";
} elseif ($planet_sec == 0) {
print "Your alliance has no claimed planets!";
} else {
print "Your planet is the only planet in the alliance!";
$db2->query("SELECT * FROM message WHERE account_id = {$player->account_id} AND message_type_id = " . MSG_POLITICAL . " AND game_id = {$player->game_id}");
if (onCouncil($player->race_id) || $db2->nf()) {
$db->query("SELECT * FROM message_type " . "WHERE message_type_id < 8 " . "ORDER BY message_type_id");
} else {
$db->query("SELECT * FROM message_type " . "WHERE message_type_id != 5 " . "ORDER BY message_type_id");
}
while ($db->next_record()) {
$message_type_id = $db->f("message_type_id");
$message_type_name = $db->f("message_type_name");
// do we have unread msges in that folder?
$db2->query("SELECT * FROM message " . "WHERE account_id = " . SmrSession::$old_account_id . " AND " . "game_id = " . SmrSession::$game_id . " AND " . "message_type_id = {$message_type_id} AND " . "msg_read = 'FALSE'");
$msg_read = $db2->nf();
// get number of msges
$db2->query("SELECT count(message_id) as message_count FROM message " . "WHERE account_id = " . SmrSession::$old_account_id . " AND " . "game_id = " . SmrSession::$game_id . " AND " . "message_type_id = {$message_type_id}");
if ($db2->next_record()) {
$message_count = $db2->f("message_count");
}
print "<tr>";
print "<td";
if ($msg_read) {
print " style=\"font-weight:bold;\"";
}
print ">";
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "message_view.php";
$container["folder_id"] = $message_type_id;
print_link($container, $message_type_name);
print "</td>";
print "<td align=\"center\" style=\"color:yellow;";
if ($msg_read) {
<?php
require_once get_file_loc('smr_sector.inc');
$sector = new SMR_SECTOR($player->sector_id, SmrSession::$game_id, SmrSession::$old_account_id);
print_topic("READING THE WALL");
include get_file_loc('menue.inc');
print_bar_menue();
$db = new SmrMySqlDatabase();
$db->query("SELECT message_id FROM bar_wall WHERE sector_id = {$sector->sector_id} AND game_id = " . SmrSession::$game_id . " ORDER BY message_id DESC");
if ($db->next_record()) {
$amount = $db->f("message_id") + 1;
} else {
$amount = 1;
}
$time_now = time();
$db2 = new SmrMySqlDatabase();
$wall = $_REQUEST['wall'];
if (isset($wall)) {
$db2->query("INSERT INTO bar_wall (sector_id, game_id, message_id, message, time) VALUES ({$sector->sector_id}, " . SmrSession::$game_id . ", {$amount}, " . format_string($wall, true) . " , {$time_now})");
}
$db->query("SELECT * FROM bar_wall WHERE game_id = {$player->game_id} AND sector_id = {$player->sector_id} ORDER BY time DESC");
if ($db->nf()) {
print "<table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" class=\"standard\">";
print "<tr>";
print "<th align=\"center\">Time written</th>";
print "<th align=\"center\">Message</th>";
print "</tr>";
while ($db->next_record()) {
$time = $db->f("time");
$message_on_wall = stripslashes($db->f("message"));
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;
}
print "<a href=\"http://www.mpogd.com/gotm/vote.asp\" target=\"_game_site\"><img border=\"0\" src=\"images/game_sites/mpogd.png\" width=\"98\" height=\"41\"></a> ";
}
$db->query("SELECT timeout FROM vote_links WHERE account_id=" . SmrSession::$old_account_id . " AND link_id=2 LIMIT 1");
if (isset(SmrSession::$game_id) && SmrSession::$game_id > 0 && (!$db->next_record() || $db->f("timeout") < time() - 86400) && rand(0, 100) < 80) {
$container["link_id"] = 2;
print "<a href='javascript:window.open(\"http://www.topwebgames.com/in.asp?id=136\");document.location=\"" . URL . "/loader2.php?sn=" . SmrSession::get_new_sn($container) . "\"'><img border=\"0\" src=\"images/game_sites/twg_vote.png\" width=\"98\" height=\"41\"></a>";
} else {
$container["link_id"] = 0;
print "<a href=\"http://www.topwebgames.com/in.asp?id=136\" target=\"_game_site\"><img border=\"0\" src=\"images/game_sites/twg.png\" width=\"98\" height=\"41\"></a> ";
}
$db->query("SELECT timeout FROM vote_links WHERE account_id=" . SmrSession::$old_account_id . " AND link_id=3 LIMIT 1");
if (isset(SmrSession::$game_id) && SmrSession::$game_id > 0 && (!$db->next_record() || $db->f("timeout") < time() - 86400) && rand(0, 100) < 80) {
$container["link_id"] = 3;
print "<a href='javascript:window.open(\"http://www.omgn.com/topgames/vote.php?Game_ID=30\");document.location=\"" . URL . "/loader2.php?sn=" . SmrSession::get_new_sn($container) . "\"'><img border=\"0\" src=\"images/game_sites/omgn_vote.jpg\" width=\"98\" height=\"41\"></a>";
} else {
$container["link_id"] = 0;
print "<a href=\"http://www.omgn.com/topgames/vote.php?Game_ID=30\" target=\"_game_site\"><img border=\"0\" src=\"images/game_sites/omgn.jpg\" width=\"98\" height=\"41\"></a> ";
}
print "</td>";
$db = new SmrMySqlDatabase();
$db->query("SELECT *\n\t\t\tFROM version\n\t\t\tORDER BY went_live DESC\n\t\t\tLIMIT 1\n\t\t ");
if ($db->next_record()) {
$version_id = $db->f("version_id");
$container = array('url' => 'skeleton.php', 'body' => 'changelog_view.php', 'version_id' => $version_id);
$version = create_link($container, 'v' . $db->f('major_version') . '.' . $db->f('minor_version') . '.' . $db->f('patch_level'));
}
$this_year = date("Y");
$time_elapsed = getmicrotime() - $time_start;
print "<td align=\"right\" width=\"100%\" style=\"vertical-align:bottom\"><span style=\"font-size:75%;\">Space Merchant Realms<br>{$version} © 2001-{$this_year}<br>hosted by <a href=\"http://www.fem.tu-ilmenau.de/fem_neu/scripts/index.php?fuseaction=page.content&id=1&menue_name=englisch\" target=\"fem\">FeM</a><br />Script runtime: " . number_format($time_elapsed, 3) . " sec</span></td>";
print "</tr>";
print "</table>";
} 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>";
print "<span style=\"color:red;\">All illegal goods have been removed from your ship and you have been fined " . number_format($fine) . " credits</span>";
}
if ($sender_id == -1) {
$playerName = 'Bank Reporter';
}
if ($sender_id == -2) {
$playerName = 'Forces Reporter';
}
if ($sender_id == -3) {
$playerName = 'Game Admins';
}
}
$threads[$i]['tail'] .= '</td><td class="shrink nowrap">';
$threads[$i]['tail'] .= stripslashes($playerName);
$db3->query("SELECT * FROM player_has_alliance_role WHERE account_id = {$player->account_id} AND game_id = {$player->game_id} AND alliance_id={$player->alliance_id}");
if ($db3->next_record()) {
$role_id = $db3->f("role_id");
} else {
$role_id = 0;
}
$db3->query("SELECT * FROM alliance_has_roles WHERE alliance_id = {$alliance_id} AND game_id = {$player->game_id} AND role_id = {$role_id}");
$db3->next_record();
if ($player->account_id == $sender_id || $db3->f("mb_messages")) {
$container['thread_id'] = $db->f('thread');
$threads[$i]['tail'] .= '<br><small>';
$threads[$i]['tail'] .= create_link($container, 'Delete Thread!');
$threads[$i]['tail'] .= '</small>';
}
$threads[$i]['tail'] .= '</td><td class="shrink center">';
$threads[$i]['tail'] .= $db->f('num_replies');
$thread_replies[$i] = $db->f('num_replies');
$threads[$i]['tail'] .= '</td><td class="shrink nowrap">';
<?php
print_topic("Change Log");
$db2 = new SmrMySqlDatabase();
$db->query("SELECT *\n\t\t\tFROM version\n\t\t\tWHERE version_id <= " . $var['version_id'] . "\n\t\t\tORDER BY version_id DESC");
while ($db->next_record()) {
$version_id = $db->f("version_id");
$version = $db->f("major_version") . "." . $db->f("minor_version") . "." . $db->f("patch_level");
$went_live = $db->f("went_live");
// get human readable format for date
if ($went_live > 0) {
$went_live = date("m/d/Y - h:i A", $went_live);
} else {
$went_live = "never";
}
print "<b><small>{$version} ({$went_live}):</small></b>";
print '<ul>';
$db2->query("SELECT *\n\t\t\t\tFROM changelog\n\t\t\t\tWHERE version_id = {$version_id}\n\t\t\t\tORDER BY changelog_id");
while ($db2->next_record()) {
print '<li>' . stripslashes($db2->f('change_title')) . '<br /><small>' . stripslashes($db2->f('change_message')) . '</small></li>';
}
print '</ul>';
}
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>";
}
$container["url"] = "skeleton.php";
$container["body"] = "message_view.php";
$container["folder_id"] = MSG_PLANET;
forward($container);
}
$db2 = new SmrMySqlDatabase();
//check for planet messages
$db->query("SELECT * FROM alliance_thread_topic WHERE alliance_id = {$player->alliance_id} AND game_id = {$player->game_id} AND " . "topic LIKE 'Planet Attack Report Sector %'");
$container = array();
$msg = array();
while ($db->next_record()) {
//get the newest post time and such
$thread_id = $db->f("thread_id");
$db2->query("SELECT * FROM alliance_thread WHERE thread_id = {$thread_id} AND alliance_id = {$player->alliance_id} AND game_id = {$player->game_id} ORDER BY reply_id DESC");
$db2->next_record();
$post_time = $db2->f("time");
$db2->query("SELECT * FROM player_read_thread WHERE thread_id = {$thread_id} AND alliance_id = {$player->alliance_id} AND game_id = {$player->game_id} AND account_id = {$player->account_id}");
if ($db2->next_record()) {
$time_read = $db2->f("time");
} else {
$time_read = 0;
}
if ($time_read < $post_time) {
$actual_id = $thread_id;
$msg[] = $thread_id;
}
}
if (!isset($actual_id)) {
$player->remove_message("3");
create_error("An error occured while processing your request.<br><small>This error most likely occured due to your leader deleting the message</small>");
}
print_link($container, $player->get_colored_race($db->f("race_id")));
// xp
echo '</td><td class="shrink center">';
echo $db->f('experience');
echo '</td>';
// Roles
if ($var['action'] == 'Show Alliance Roles') {
echo '<td class="shrink right">';
$db2 = new SmrMySqlDatabase();
$db2->query('SELECT role_id
FROM player_has_alliance_role
WHERE account_id=' . $db->f('account_id') . '
AND game_id=' . SmrSession::$game_id . ' AND alliance_id=' . $db->f('alliance_id') . '
LIMIT 1');
if ($db2->next_record()) {
$role_id = $db2->f('role_id');
} else {
$role_id = 0;
}
if ($allowed && $db->f("account_id") != $leader_id) {
// ok do we display a select box or just a plain entry
/*if (SmrSession::$old_account_id == $db->f('account_id') ||
SmrSession::$old_account_id == $leader_id) {*/
echo '<select name="role[' . $db->f('account_id') . ']" id="InputFields">';
foreach ($roles as $curr_role_id => $role) {
echo '<option value="' . $curr_role_id . '"';
if ($curr_role_id == $role_id) {
echo ' selected';
}
echo '>';
echo stripslashes($role);
if ($debug) {
print "get rid of plotted course<br>";
}
// forget plotted course
$db->query("DELETE FROM player_plotted_course WHERE account_id = {$killed_id} AND game_id = {$player->game_id}");
if ($debug) {
print "news entry<br>";
}
$killed->get_relations();
// create news msg
if ($killed->relations_global[$killer->race_id] <= -300 || $killer->relations_global[$killed->race_id] <= -300) {
$news_message = "<span style=\"color:red;\">News from the War Front</span><br /> " . "{$killed_name} ({$killed->race_name})";
$db2->query("SELECT * FROM ship_has_name WHERE game_id = {$player->game_id} AND " . "account_id = {$killed->account_id}");
if ($db2->next_record()) {
//they have a name so we print it
$db->query("SELECT '" . htmlentities($db2->f("ship_name")) . "' LIKE '<img%'");
$named_ship = stripslashes($db2->f("ship_name"));
$named_ship = strip_tags($db2->f("ship_name"), "<font><span>");
if ($db->next_record() && $db->f(0) != 0) {
//nothing
} else {
$news_message .= " flying <font color=\"yellow\">{$named_ship}</font>";
}
}
$news_message .= " was killed by " . "{$killer_name} ({$killer->race_name})";
$db2->query("SELECT * FROM ship_has_name WHERE game_id = {$player->game_id} AND " . "account_id = {$killer->account_id}");
if ($db2->next_record()) {
//they have a name so we print it
$db->query("SELECT '" . htmlentities($db2->f("ship_name")) . "' LIKE '<img%'");
$named_ship = stripslashes($db2->f("ship_name"));
$named_ship = strip_tags($db2->f("ship_name"), "<font><span>");
print_topic("Underground HQ");
include get_file_loc('menue.inc');
print_ug_menue();
$db2 = new SmrMySqlDatabase();
$db->query("SELECT * FROM bounty WHERE game_id = {$player->game_id} AND type = 'UG' AND claimer_id = 0 ORDER BY amount DESC");
if ($db->nf()) {
print "Most Wanted by the Underground<br><br>";
print_table();
print "<tr>";
print "<th>Player Name</th>";
print "<th>Bounty Amount</th>";
print "</tr>";
while ($db->next_record()) {
$id = $db->f("account_id");
$db2->query("SELECT * FROM player WHERE game_id = {$player->game_id} AND account_id = {$id}");
if ($db2->next_record()) {
$name = stripslashes($db2->f("player_name"));
$amount = $db->f("amount");
print "<tr>";
print "<td align=\"center\"><font color=yellow>{$name}</font></td>";
print "<td align=\"center\"><font color=red> " . number_format($amount) . " </font></td>";
print "</tr>";
}
}
print "</table>";
}
if ($player->alignment <= 99 && $player->alignment >= -100) {
print_form(create_container("government_processing.php", ""));
print_submit("Become a gang member");
print "</form>";
}
if ($race == 1) {
$race = 9;
} else {
$race -= 1;
}
//3 bytes total...
$db2->query("SELECT * FROM good ORDER BY good_id");
for ($i = 0; $i <= 2; $i++) {
$CurrByte = 0;
$CurrAdd = 128;
for ($j = 0; $j <= 3; $j++) {
$db2->next_record();
$good_id = $db2->f("good_id");
$db3->query("SELECT * FROM port_has_goods WHERE game_id = {$game_id} AND sector_id = {$sector_id} AND good_id = {$good_id}");
if ($db3->next_record()) {
if ($db3->f("transaction") == "Sell") {
$CurrByte += $CurrAdd;
} else {
$CurrByte += $CurrAdd / 2;
}
}
$CurrAdd /= 4;
}
$file .= addbyte($CurrByte);
}
}
//add port race byte...
$race = $race * 16;
$db2->query("SELECT * FROM planet WHERE game_id = {$game_id} AND sector_id = {$sector_id}");
if ($db2->next_record()) {
$db2->query("SELECT * FROM planet WHERE game_id = {$game_id} AND sector_id = {$sector_id} AND owner_id IN {$alliance}");
$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");
print_form($container);
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];
print "</td>";
print "</tr>";
while ($db->next_record()) {
$curr_player = new SMR_PLAYER($db->f("account_id"), $player->game_id);
$curr_player->get_display_xp_lvl();
print "<tr>";
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "trader_search_result.php";
$container["player_id"] = $curr_player->player_id;
print "<td>";
print_link($container, $curr_player->get_colored_name());
print "<br>";
$db2->query("SELECT * FROM ship_has_name WHERE game_id = {$player->game_id} AND " . "account_id = {$curr_player->account_id}");
if ($db2->next_record()) {
//they have a name so we print it
$named_ship = stripslashes($db2->f("ship_name"));
print "{$named_ship}";
}
print "</td>";
print "<td>";
if ($curr_player->alliance_id > 0) {
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "alliance_roster.php";
$container["alliance_id"] = $curr_player->alliance_id;
print_link($container, "{$curr_player->alliance_name}");
} else {
print "(none)";
}
print "</td>";
$container = array();
$db->query("SELECT * FROM account_has_stats WHERE account_id = {$account->account_id}");
if ($db->next_record()) {
print "<b>Extended Stats</b><br>";
print "You have joined " . $db->f("games_joined") . " games.<br>";
print "You have busted " . $db->f("planet_busts") . " planets.<br>";
print "You have busted a total of " . $db->f("planet_bust_levels") . " combined levels on planets.<br>";
print "You have raided " . $db->f("port_raids") . " ports.<br>";
print "You have raided a total of " . $db->f("port_raid_levels") . " combined levels of ports.<br>";
print "You have done " . $db->f("planet_damage") . " damage to planets.<br>";
print "You have done " . $db->f("port_damage") . " damage to ports.<br>";
print "You have explored " . $db->f("sectors_explored") . " sectors.<br>";
print "You have died " . $db->f("deaths") . " times.<br>";
print "You have traded " . $db->f("goods_traded") . " goods.<br>";
$db2->query("SELECT sum(amount) as amount FROM account_donated WHERE account_id = {$account->account_id}");
if ($db2->next_record()) {
print "You have donated " . $db2->f("amount") . " dollars to SMR.<br>";
}
print "You have claimed " . $db->f("bounties_claimed") . " bounties.<br>";
print "You have claimed " . $db->f("bounty_amount_claimed") . " credits from bounties.<br>";
print "You have claimed " . $db->f("military_claimed") . " credits from military payment.<br>";
print "You have had a total of " . $db->f("bounty_amount_on") . " credits bounty placed on you.<br>";
print "You have done " . $db->f("player_damage") . " damage to other ships.<br>";
print "The total experience of traders you have killed is " . $db->f("traders_killed_exp") . ".<br>";
print "You have gained " . $db->f("kill_exp") . " experience from killing other traders.<br>";
print "You have used " . $db->f("turns_used") . " turns since your last death.<br>";
print "You have won " . $db->f("blackjack_win") . " credits from Blackjack.<br>";
print "You have lost " . $db->f("blackjack_lose") . " credits from Blackjack.<br>";
print "You have won " . $db->f("lotto") . " credits from the lotto.<br>";
print "You have had " . $db->f("drinks") . " drinks at the bar.<br>";
print "You have bought " . $db->f("mines") . " mines.<br>";
print "You have bought " . $db->f("combat_drones") . " combat_drones.<br>";
<?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);
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';
print "</tr>";
$db2 = new SmrMySqlDatabase();
while ($db->next_record()) {
$race_id_2 = $db->f("race_id_2");
$type = $db->f("type");
$end_time = $db->f("end_time");
print "<tr>";
print "<td align=\"center\">" . $player->get_colored_race($race_id_2) . "</td>";
print "<td align=\"center\">{$type}</td>";
$container = array();
$container["url"] = "council_vote_processing.php";
$container["race_id"] = $race_id_2;
print_form($container);
$db2->query("SELECT * FROM player_votes_pact " . "WHERE account_id = {$player->account_id} AND " . "game_id = {$player->game_id} AND " . "race_id_1 = {$player->race_id} AND " . "race_id_2 = {$race_id_2}");
if ($db2->next_record()) {
$voted_for = $db2->f("vote");
} else {
$voted_for = "";
}
print "<td nowrap=\"nowrap\" align=\"center\">";
if ($voted_for == "YES") {
print_submit_style("Yes", "background-color:green;");
} else {
print_submit("Yes");
}
print " ";
if ($voted_for == "NO") {
print_submit_style("No", "background-color:green;");
} else {
print_submit("No");
}
$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()) {
$file .= add2bytes($db2->f("mgu_id"));
}
}
$size = strlen($file);
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/force-download");
header("Content-Disposition: attachment; filename=\"{$game_name}.cmf\"");
header("Content-Transfer-Encoding: binary");
header("Content-Length: " . $size);
$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_damage += $mines_dead * 20;
