$file .= addbyte(sqrt($db->f("num_sec")));
}
//planet definitions (num of, [size of name, name])
$file .= addbyte(2);
$file .= addbyte(8);
$file .= "Friendly";
$file .= addbyte(5);
$file .= "Enemy";
//done with all header info
$db2 = new SmrMySqlDatabase();
$db3 = new SmrMySqlDatabase();
$db->query("SELECT * FROM sector WHERE game_id = {$game_id} ORDER BY sector_id");
while ($db->next_record()) {
$sector_id = $db->f("sector_id");
$db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$sector_id} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
if ($db2->nf() > 0) {
$CurrByte = 3;
$up = $db->f("link_up");
$db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$up} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
if ($db2->nf() == 0 && $up != 0) {
$CurrByte += 128;
}
$right = $db->f("link_right");
$db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$right} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
if ($db2->nf() == 0 && $right != 0) {
$CurrByte += 64;
}
$down = $db->f("link_down");
$db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$down} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
if ($db2->nf() == 0 && $down != 0) {
$CurrByte += 32;
if ($db->f("link_left") > 0) {
$CurrByte += 16;
}
//do we have a planet here?
$db2->query("SELECT * FROM planet WHERE game_id = {$game_id} AND sector_id = {$sector_id}");
if ($db2->next_record()) {
$CurrByte += 8;
}
//do we have a port here?
$db2->query("SELECT * FROM port WHERE game_id = {$game_id} AND sector_id = {$sector_id}");
if ($db2->next_record()) {
$CurrByte += 4;
}
//sector friendliness
$db2->query("SELECT * FROM sector_has_forces WHERE sector_id = {$sector_id} AND mines > 0 AND owner_id IN {$alliance}");
if ($db2->nf() > 0) {
//we want a green "friendly" sector
$CurrByte += 1;
} else {
//we want a blue "neutral" sector
$CurrByte += 0;
}
$file .= addbyte($CurrByte);
$db2->query("SELECT * FROM port WHERE game_id = {$game_id} AND sector_id = {$sector_id}");
$race = 0;
$has_port = FALSE;
if ($db2->next_record()) {
$has_port = TRUE;
$race = $db2->f("race_id");
if ($race == 1) {
$race = 9;
include get_file_loc("council.inc");
include get_file_loc('menue.inc');
print_topic("RULING COUNCIL OF {$player->race_name}");
print_council_menue($player->race_id, getPresident($player->race_id));
print "<table border=\"0\" class=\"standard\" cellspacing=\"0\" align=\"center\" width=\"50%\">";
print "<tr>";
print "<th>Race</th>";
print "<th>Treaty</th>";
print "</tr>";
$db2 = new SmrMySqlDatabase();
$db->query("SELECT * FROM race " . "WHERE race_id != {$player->race_id} AND " . "race_id > 1");
while ($db->next_record()) {
$race_id = $db->f("race_id");
$race_name = $db->f("race_name");
$db2->query("SELECT * FROM race_has_voting " . "WHERE game_id = {$player->game_id} AND " . "race_id_1 = {$player->race_id} AND " . "race_id_2 = {$race_id}");
if ($db2->nf() > 0) {
continue;
}
print "<tr>";
print "<td align=\"center\">" . $player->get_colored_race($race_id) . "</td>";
$container = array();
$container["url"] = "council_embassy_processing.php";
$container["race_id"] = $race_id;
print_form($container);
print "<td align=\"center\">";
print_submit("Peace");
print " ";
print_submit("War");
print "</td>";
print "</form>";
print "</tr>";
}
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");
}
if ($president->account_id == $player->account_id) {
print " ";
print_submit("Veto");
}
print "</td>";
// get 'yes' votes
$db2->query("SELECT * FROM player_votes_pact " . "WHERE game_id = {$player->game_id} AND " . "race_id_1 = {$player->race_id} AND " . "race_id_2 = {$race_id_2} AND " . "vote = 'YES'");
$yes_votes = $db2->nf();
// get 'no' votes
$db2->query("SELECT * FROM player_votes_pact " . "WHERE game_id = {$player->game_id} AND " . "race_id_1 = {$player->race_id} AND " . "race_id_2 = {$race_id_2} AND " . "vote = 'NO'");
$no_votes = $db2->nf();
print "<td align=\"center\">{$yes_votes} / {$no_votes}</td>";
print "<td nowrap=\"nowrap\"align=\"center\">" . date("n/j/Y", $end_time) . "<br>" . date("g:i:s A", $end_time) . "</td>";
print "</form>";
print "</tr>";
}
print "</table>";
}
$db->query("SELECT * FROM alliance WHERE game_id = {$player->game_id} ORDER BY alliance_kills DESC, alliance_name LIMIT 5");
while ($db->next_record()) {
$alliance_vs[] = $db->f("alliance_id");
}
//print("emtpy $alliancer");
} else {
$alliance_vs = $alliancer;
}
$alliance_vs[] = 0;
foreach ($alliance_vs as $key => $id) {
// get current alliance
$curr_alliance_id = $id;
if ($id > 0) {
$curr_alliance = new SMR_ALLIANCE($id, SmrSession::$game_id);
$db2->query("SELECT * FROM player WHERE alliance_id = {$id} AND game_id = " . SmrSession::$game_id);
if ($db2->nf() == 0) {
$out = TRUE;
} else {
$out = FALSE;
}
print "<td width=15% valign=\"top\"";
if ($player->alliance_id == $curr_alliance_id) {
print " style=\"font-weight:bold;\"";
}
print ">";
/*$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "alliance_roster.php";
$container["alliance_id"] = $curr_alliance_id;
print_link($container, "$curr_alliance->alliance_name");*/
print "<select name=alliancer[] style=width:105>";
<?php
$db = new SmrMySqlDatabase();
$db->query("SELECT * FROM account, announcement " . "WHERE account_id = " . SmrSession::$old_account_id . " AND " . "last_login < time");
$container = array();
// do we have announcements?
if ($db->nf() != 0) {
$container["url"] = "skeleton.php";
$container["body"] = "announcements.php";
} else {
$container["url"] = "logged_in.php";
}
forward($container);
print_link(create_container("skeleton.php", "galactic_post_view_article.php"), "View the articles");
print "<br>";
print_link(create_container("skeleton.php", "galactic_post_make_paper.php"), "Make a paper");
print "<br>";
print_link(create_container("skeleton.php", "galactic_post_view_members.php"), "View Members");
print "<br>";
$db->query("SELECT * FROM galactic_post_paper WHERE game_id = {$player->game_id}");
if ($db->nf()) {
print "The following papers are already made (note papers must have 3-8 articles to go to the press)";
}
while ($db->next_record()) {
$paper_name = $db->f("title");
$paper_id = $db->f("paper_id");
print "<font color=red>***</font><i>{$paper_name}</i>";
$db2->query("SELECT * FROM galactic_post_paper_content WHERE paper_id = {$paper_id} AND game_id = {$player->game_id}");
print " which contains <font color=red> " . $db2->nf() . " </font>articles. ";
if ($db2->nf() > 2 && $db2->nf() < 9) {
$container = array();
$container["url"] = "galactic_post_make_current.php";
$container["id"] = $paper_id;
print_link($container, "<b>HIT THE PRESS!</b>");
}
print "<br>";
$container = array();
$container["url"] = "skeleton.php";
$container["body"] = "galactic_post_delete_confirm.php";
$container["paper"] = "yes";
$container["id"] = $paper_id;
print_link($container, "Delete {$paper_name}");
print "<br>";
$container = array();
if (!isset($var["folder_id"])) {
print_topic("VIEW MESSAGES");
include get_file_loc('menue.inc');
print_message_menue();
print "<p>Please choose your Message folder!</p>";
print "<p>";
print "<table border=\"0\" class=\"standard\" cellspacing=\"0\" cellpadding=\"3\">";
print "<tr>";
print "<th>Folder</th>";
print "<th>Messages</th>";
print "<th> </th>";
print "</tr>";
$db2 = new SmrMySqlDatabase();
include get_file_loc("council.inc");
$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_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>";
print "<td align=\"center\"><b> " . date("n/j/Y g:i:s A", $time) . " </b></td>";
print "<td align=\"center\"><b>{$message_on_wall}</b></td>";
print "</tr>";
}
print "</table>";
}
print_topic("GALACTIC POST");
$db2 = new SmrMySqlDatabase();
$db3 = new SmrMySqlDatabase();
$db->query("SELECT * FROM galactic_post_online WHERE game_id = {$player->game_id}");
if ($db->nf()) {
$db->next_record();
$paper_id = $db->f("paper_id");
$db2->query("SELECT * FROM galactic_post_paper WHERE game_id = {$player->game_id} AND paper_id = {$paper_id}");
$db2->next_record();
$paper_name = stripslashes($db2->f("title"));
print_topic("READING <i>GALACTIC POST</i> EDITION : {$paper_name}");
include get_file_loc('menue.inc');
print_galactic_post_menue();
$db2->query("SELECT * FROM galactic_post_paper_content WHERE paper_id = {$paper_id} AND game_id = {$player->game_id}");
if (floor($db2->nf() / 2) == $db2->nf() / 2) {
$even = "yes";
} else {
$even = "no";
}
$curr_position = 0;
print "<table align=\"center\" spacepadding=\"20\" cellspacing=\"20\">";
if ($even == "yes") {
$amount = $db2->nf();
} else {
$amount = $db2->nf() + 1;
}
while ($curr_position + 1 <= $amount) {
$curr_position += 1;
if ($db2->nf() + 1 == $curr_position && $even != "yes") {
print "<td> </td>";
