function scan_vessels($vessel_id, $range, $scans, $i)
{
list($src_distance, $src_angle) = get_correct_da($vessel_id);
// Scan for vessels
$result = sql_query("SELECT * FROM g_vessels ORDER BY user_id");
while ($vessel = sql_fetchrow($result)) {
if ($vessel['id'] == $vessel_id) {
continue;
}
$race = user_get_race($vessel['user_id']);
if ($vessel['sector_id'] == 0) {
$distance = calc_distance($src_distance, $src_angle, $vessel['distance'], $vessel['angle']);
if ($distance <= $range and $distance != 0) {
$scans[$i]['str'] = "<tr class=bl><td> Vessel </td><td> " . $vessel['name'] . " (" . $race . ") </td><td> " . $vessel['distance'] . " / " . $vessel['angle'] . " </td><td> " . $distance . " </td></tr>\n";
$scans[$i]['range'] = $distance;
$i++;
}
} else {
$vessel_sector = sector_get_sector($vessel['sector_id']);
$distance = calc_distance($src_distance, $src_angle, $vessel_sector['distance'], $vessel_sector['angle']);
if ($distance <= $range and $distance != 0) {
// Check if it's not inside a nebula
$planet = anomaly_get_anomaly($vessel['planet_id']);
if (!(vessel_is_in_orbit($vessel) and anomaly_is_nebula($planet['id']))) {
$scans[$i]['str'] = "<tr class=bl><td> Vessel </td><td> " . $vessel['name'] . " (" . $race . ") </td><td> SECTOR: " . $vessel_sector['distance'] . " / " . $vessel_sector['angle'] . " </td><td> " . $distance . " </td></tr>\n";
$scans[$i]['range'] = $distance;
$i++;
}
}
}
}
return array($scans, $i);
}
function wormhole_show_wormhole($wormhole_id)
{
assert(!empty($wormhole_id));
global $_GALAXY;
if (!anomaly_is_wormhole($wormhole_id)) {
return;
}
$wormhole = anomaly_get_anomaly($wormhole_id);
$sector = sector_get_sector($wormhole['sector_id']);
$race = user_get_race($wormhole['user_id']);
$result = sql_query("SELECT * FROM w_wormhole WHERE id=" . $wormhole['id']);
$dst_wormhole = sql_fetchrow($result);
if ($race == "") {
$race = "-";
}
echo "<table border=1 width=500 align=center>\n";
echo " <tr><td align=center><b><i>Sector: " . $sector['name'] . " / Anomaly: " . $wormhole['name'] . "</i></b></td></tr>\n";
echo " <tr><td>\n";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>\n";
echo " <tr><td width=200>\n";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>\n";
echo " <tr><th>Anomaly View</th></tr>\n";
echo " <tr><td width=100%><center><img src=\"" . $_CONFIG['URL'] . $_GALAXY['image_dir'] . "/wormholes/" . $wormhole['image'] . ".jpg\" width=150 height=150></center></td></tr>\n";
echo " <tr><th> </th></tr>\n";
echo " </table>\n";
echo " </td>\n";
echo " <td> </td>\n";
echo " <td nowrap valign=top>\n";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>\n";
echo " <tr><td nowrap width=40%><strong>Wormhole Name </strong></td><td nowrap width=1%><b>:</b></td>\n";
if ($wormhole['unknown'] == 1) {
form_start();
echo "<td nowrap>\n";
echo " <input type=hidden name=aid value=" . encrypt_get_vars($wormhole_id) . ">\n";
echo " <input type=hidden name=cmd value=" . encrypt_get_vars("claim") . ">\n";
echo " <input type=text size=15 maxlength=30 name=ne_name>\n";
echo " <input name=submit type=submit value=\"Claim\">\n";
echo "</td>\n";
form_end();
} else {
echo "<td nowrap>" . $wormhole['name'] . "</td>\n";
}
echo " </tr>\n";
echo " <tr><td colspan=3> </td></tr>\n";
echo " <tr><td nowrap width=40%><strong>Caretaker </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $race . "</td></tr>\n";
echo " <tr><td nowrap width=40%><strong>Radius </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $wormhole['radius'] . " km</td></tr>\n";
echo " <tr><td nowrap width=40%><strong>Distance to sun </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $wormhole['distance'] . " km (10<sup>6</sup>)</td></tr>\n";
echo " <tr><td colspan=3> </td></tr>\n";
echo " <tr><td nowrap width=40%><strong>Destination </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $dst_wormhole['distance'] . " / " . $dst_wormhole['angle'] . "</td></tr>\n";
echo " <tr><td nowrap width=40%><strong>Stability </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . wormhole_get_wormhole_stability($dst_wormhole['next_jump']) . " </td></tr>\n";
echo " </table>\n";
echo " </td>\n";
echo " </tr>\n";
echo " </table>\n";
echo " </td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "<br><br>\n";
}
function starbase_show_starbase($starbase_id)
{
assert(!empty($starbase_id));
global $_GALAXY;
if (!anomaly_is_starbase($starbase_id)) {
return;
}
$starbase = anomaly_get_anomaly($starbase_id);
$sector = sector_get_sector($starbase['sector_id']);
$race = user_get_race($starbase['user_id']);
if ($race == "") {
$race = "-";
}
echo "<table border=1 width=500 align=center>";
echo " <tr><td align=center><b><i>Starbase: " . $starbase['name'] . "</i></b></td></tr>";
echo " <tr><td>";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>";
echo " <tr><td width=200>";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>";
echo " <tr><th>Starbase View</th></tr>";
echo " <tr><td width=100%><center><img src=\"" . $_CONFIG['URL'] . $_GALAXY['image_dir'] . "/starbase/" . $starbase['image'] . ".jpg\" width=150 height=150></center></td></tr>";
echo " <tr><th> </th></tr>";
echo " </table>";
echo " </td>";
echo " <td> </td>";
echo " <td nowrap valign=top>";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>";
echo " <tr><td nowrap width=40%><strong>Starbase Name </strong></td><td nowrap width=1%><b>:</b></td>";
if ($starbase['unknown'] == 1) {
form_start();
echo "<td nowrap>";
echo " <input type=hidden name=aid value=" . encrypt_get_vars($starbase_id) . ">";
echo " <input type=hidden name=cmd value=" . encrypt_get_vars("claim") . ">";
echo " <input type=text size=15 maxlength=30 name=ne_name> ";
echo " <input name=submit type=submit value=\"Claim\">";
echo "</td>";
form_end();
} else {
echo "<td nowrap>" . $starbase['name'] . "</td>";
}
echo " </tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr><td nowrap width=40%><strong>Caretaker </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $race . "</td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr><td nowrap width=40%><strong>Attack </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $starbase['cur_attack'] . "</td></tr>";
echo " <tr><td nowrap width=40%><strong>Defense </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $starbase['cur_defense'] . "</td></tr>";
echo " <tr><td nowrap width=40%><strong>Strength </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $starbase['cur_strength'] . "</td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " </table>";
echo " </td>";
echo " </tr>";
echo " </table>";
echo " </td>";
echo " </tr>";
echo "</table>";
echo "<br><br>";
}
function blackhole_show_blackhole($blackhole_id)
{
assert(is_numeric($blackhole_id));
global $_GALAXY;
if (!anomaly_is_blackhole($blackhole_id)) {
return;
}
$blackhole = anomaly_get_anomaly($blackhole_id);
$race = user_get_race($blackhole['user_id']);
$sector = sector_get_sector($blackhole['sector_id']);
if ($race == "") {
$race = "-";
}
echo "<table border=1 width=500 align=center>";
echo " <tr><td align=center><b><i>Sector: " . $sector['name'] . " / Anomaly: " . $blackhole['name'] . "</i></b></td></tr>";
echo " <tr><td>";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>";
echo " <tr><td width=200>";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>";
echo " <tr><th>Anomaly View</th></tr>";
echo " <tr><td width=100%><center><img src=\"" . $_CONFIG['URL'] . $_GALAXY['image_dir'] . "/blackholes/" . $blackhole['image'] . ".jpg\" width=150 height=150></center></td></tr>";
echo " <tr><th> </th></tr>";
echo " </table>";
echo " </td>";
echo " <td> </td>";
echo " <td nowrap valign=top>";
echo " <table border=0 cellpadding=0 cellspacing=0 width=100%>";
echo " <tr><td nowrap width=40%><strong>Blackhole Name </strong></td><td nowrap width=1%><b>:</b></td>";
if ($blackhole['unknown'] == 1) {
form_start();
echo "<td nowrap>";
echo " <input type=hidden name=aid value=" . encrypt_get_vars($blackhole_id) . ">";
echo " <input type=hidden name=cmd value=" . encrypt_get_vars("claim") . ">";
echo " <input type=text size=15 maxlength=30 name=ne_name> ";
echo " <input name=submit type=submit value=\"Claim\">";
echo "</td>";
form_end();
} else {
echo "<td nowrap>" . $blackhole['name'] . "</td>";
}
echo " </tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr><td nowrap width=40%><strong>Caretaker </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $race . "</td></tr>";
echo " <tr><td nowrap width=40%><strong>Radius </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $blackhole['radius'] . " km</td></tr>";
echo " <tr><td nowrap width=40%><strong>Distance to sun </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . $blackhole['distance'] . " km (10<sup>6</sup>)</td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr><td nowrap width=40%><strong>Fatalities </strong></td><td nowrap width=1%><b>:</b> </td><td nowrap>" . blackhole_get_fatalities($blackhole_id) . " ship(s)</td></tr>";
echo " </table>";
echo " </td>";
echo " </tr>";
echo " </table>";
echo " </td>";
echo " </tr>";
echo "</table>";
echo "<br><br>";
}
function vessel_show_table_row($vessel_id, $href_url, $show_species = "NO")
{
assert(is_numeric($vessel_id));
assert(!empty($href_url));
global $_GALAXY;
global $_CONFIG;
// Get information
$vessel = vessel_get_vessel($vessel_id);
$vesseltype = vessel_get_vesseltype($vessel_id);
$planet = anomaly_get_anomaly($vessel['planet_id']);
$race = user_get_race($vessel['user_id']);
$img = "explore.jpg";
$type = "Unknown Type";
if ($vesseltype['type'] == VESSEL_TYPE_EXPLORE) {
$img = "explore.jpg";
$type = $vesseltype['name'];
}
if ($vesseltype['type'] == VESSEL_TYPE_TRADE) {
$img = "trade.jpg";
$type = $vesseltype['name'];
}
if ($vesseltype['type'] == VESSEL_TYPE_BATTLE) {
$img = "battle.jpg";
$type = $vesseltype['name'];
}
$tmp['image'] = $_CONFIG['IMAGE_URL'] . $_GALAXY['image_dir'] . "/ships/" . $img;
$tmp['href'] = $href_url . "?cmd=" . encrypt_get_vars("showvid") . "&vid=" . encrypt_get_vars($vessel['id']);
$tmp['name'] = $vessel['name'];
$tmp['type'] = $type;
$tmp['status'] = vessel_get_current_status($vessel_id, true);
$tmp['status_nohref'] = vessel_get_current_status($vessel_id, false);
$tmp['distance'] = $vessel['distance'];
$tmp['angle'] = $vessel['angle'];
$tmp['race'] = $race;
return $tmp;
}
function sector_show_sector($sector_id, $user_id)
{
assert(!empty($sector_id));
assert(!empty($user_id));
global $_RUN;
// Create the submenu where we can easily move between sectors
$result = sql_query("SELECT * FROM g_sectors WHERE user_id = " . $user_id);
$tmp = sql_fetchrow($result);
$sectors = csl($tmp['csl_sector_id']);
$idx = array_search($sector_id, $sectors);
$first = reset($sectors);
$last = end($sectors);
if ($idx == 0) {
$prev = $sectors[$idx];
} else {
$prev = $sectors[$idx - 1];
}
if ($idx == count($sectors) - 1) {
$next = $sectors[$idx];
} else {
$next = $sectors[$idx + 1];
}
create_submenu(array("First Sector" => "sector.php?cmd=" . encrypt_get_vars("show") . "&sid=" . encrypt_get_vars($first), "Previous Sector" => "sector.php?cmd=" . encrypt_get_vars("show") . "&sid=" . encrypt_get_vars($prev), "Next Sector" => "sector.php?cmd=" . encrypt_get_vars("show") . "&sid=" . encrypt_get_vars($next), "Last Sector" => "sector.php?cmd=" . encrypt_get_vars("show") . "&sid=" . encrypt_get_vars($last)));
$sector = sector_get_sector($sector_id);
$template = new Smarty();
$template->debugging = true;
help_set_template_vars($template);
$template->assign("sector_id", $sector['sector']);
$template->assign("sector_name", $sector['name']);
$template->assign("sector_coordinate", $sector['distance'] . " / " . $sector['angle']);
if ($sector['user_id'] == UID_NOBODY) {
$template->assign("rename_form_visible", "true");
} else {
$template->assign("rename_form_visible", "false");
}
// And now, do all anomalies
$tmp = user_get_all_anomalies_from_user($user_id);
$anomalies = csl($tmp['csl_discovered_id']);
$undiscovered_anomalies = csl($tmp['csl_undiscovered_id']);
$anomalies = csl_merge_fields($anomalies, $tmp['csl_undiscovered_id']);
// We didn't find any discovered anomalies in this sector per default
$i = 0;
$tmpvar = array();
// Get anomaly information for all anomalies in the sector
$result = sql_query("SELECT * FROM s_anomalies WHERE sector_id=" . $sector_id . " ORDER BY distance");
while ($anomaly = sql_fetchrow($result)) {
// We didn't discover this anomaly yet, continue with another
if (!in_array($anomaly['id'], $anomalies)) {
continue;
}
// Thread undiscovered planets different...
if (in_array($anomaly['id'], $undiscovered_anomalies)) {
$tmp['name'] = "Unknown";
$tmp['class'] = "";
$tmp['population'] = "";
$tmp['owner'] = "";
$tmp['status'] = "";
$tmp['radius'] = $anomaly['radius'];
$tmp['distance'] = $anomaly['distance'];
$tmpvar[] = $tmp;
continue;
}
// If we are here, we have found an anomaly with we already
// discovered and explored, show all the info about it...
$state = sql_get_state($anomaly['state_id']);
if ($anomaly['user_id'] != 0) {
$race = user_get_race($anomaly['user_id']);
} else {
$race = "Nobody";
}
// Show the population status in a different color
if ($anomaly['population_capacity'] == 0) {
$p = 0;
} else {
$p = $anomaly['population'] / $anomaly['population_capacity'] * 100;
}
$popcol = 'people_class1';
if ($p > 50) {
$popcol = 'people_class2';
}
if ($p > 75) {
$popcol = 'people_class3';
}
if ($p > 99) {
$popcol = 'people_class4';
}
if (!anomaly_is_planet($anomaly['id'])) {
$anomaly['class'] = "";
$anomaly['population'] = "";
}
// Show the class in different colors, A..J are orange... K..M are white... L..Z are red
$classcol = "class_normal";
if (planet_is_habitable($anomaly['id'])) {
$classcol = 'class_habitable';
} elseif (planet_is_minable($anomaly['id'])) {
$classcol = 'class_minable';
} else {
$classcol = 'class_unusable';
}
$tmp = array();
$tmp['name_href'] = "anomaly.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($anomaly['id']);
$tmp['name'] = $anomaly['name'];
$tmp['class'] = $anomaly['class'];
$tmp['class_class'] = $classcol;
if (planet_is_habitable($anomaly['id'])) {
$tmp['population'] = $anomaly['population'];
} else {
$tmp['population'] = "---";
}
$tmp['population_class'] = $popcol;
$tmp['owner'] = $race;
$tmp['status'] = $state;
$tmp['radius'] = $anomaly['radius'];
$tmp['distance'] = $anomaly['distance'];
$tmpvar[] = $tmp;
}
$template->assign("anomalies", $tmpvar);
$template->display($_RUN['theme_path'] . "/sectors-item.tpl");
}
function message_create_alliance($user_id)
{
$user = user_get_user($user_id);
$race = user_get_race($user['user_id']);
$result = sql_query("SELECT * FROM g_alliance WHERE id=" . $user['alliance_id']);
$alliance = sql_fetchrow($result);
print_remark("Createmessage");
form_start();
echo " <table align=center border=0 width=80%>\n";
echo " <tr><th>Send message</th></tr>\n";
echo " <tr><td>From: </td><td>" . $race . " race</td></tr>\n";
echo " <tr><td>To: </td><td>All members of " . $alliance['name'] . "</td></tr>\n";
echo " <tr><td>Subject: </td><td><input type=text name=ne_subject size=50 maxvalue=50></td></tr>\n";
echo " <tr><td>Msg: </td><td><textarea name=ne_msg rows=5 cols=60></textarea></td></tr>\n";
echo " <tr><td> </td><td><input type=submit name=submit value='Send Message'></td></tr>\n";
echo " </table>\n";
echo " <br><br>\n";
echo "\n";
echo "<input type=hidden name=src_uid value=" . encrypt_get_vars($user['user_id']) . ">\n";
echo "<input type=hidden name=dst_uid value=" . encrypt_get_vars($user['alliance_id']) . ">\n";
echo "<input type=hidden name=target value=" . encrypt_get_vars("ALLIANCE") . ">\n";
echo "<input type=hidden name=cmd value=" . encrypt_get_vars("post") . ">\n";
form_end();
}
function trade_create_route($user_id)
{
assert(is_numeric($user_id));
$found_at_least_one_ship = false;
$result = sql_query("SELECT g.* FROM g_vessels AS g, s_vessels AS s WHERE g.user_id={$user_id} AND s.id = g.vessel_id AND s.type='" . VESSEL_TYPE_TRADE . "'");
while ($vessel = sql_fetchrow($result)) {
if (!vessel_in_traderoute($vessel['id'])) {
$found_at_least_one_ship = true;
}
}
if ($found_at_least_one_ship == false) {
print_line("You do not have any tradeships currently available for setting up a traderoute");
return;
}
print_remark("Create form");
form_start();
echo " <input type=hidden name=cmd value=" . encrypt_get_vars("create2") . ">\n";
echo " <table align=center>\n";
echo " <tr>\n";
echo " <td> Vessel: </td>\n";
echo " <td>\n";
echo " <select name=vid>\n";
$result = sql_query("SELECT g.* FROM g_vessels AS g, s_vessels AS s WHERE g.user_id={$user_id} AND s.id = g.vessel_id AND s.type='" . VESSEL_TYPE_TRADE . "'");
while ($vessel = sql_fetchrow($result)) {
if (!trade_is_vessel_in_route($vessel['id'])) {
echo " <option value=" . encrypt_get_vars($vessel['id']) . ">" . $vessel['name'] . "</option>\n";
}
}
echo " </select>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr><td> </td></tr>\n";
echo " <tr>\n";
echo " <td> Source Planet: </td>\n";
echo " <td>\n";
echo " <select name=src_pid>\n";
$result = sql_query("SELECT a.*,s.name AS sectorname FROM s_anomalies AS a, s_sectors AS s WHERE a.user_id={$user_id} AND a.type='P' AND a.sector_id = s.id");
while ($planet = sql_fetchrow($result)) {
if (anomaly_is_planet($planet['id']) and planet_is_minable($planet['id'])) {
echo " <option value=" . encrypt_get_vars($planet['id']) . ">" . $planet['sectorname'] . " / " . $planet['name'] . "</option>\n";
}
}
echo " </select>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td> Ores: </td>\n";
echo " <td>";
echo " <table border=0 cellspacing=0 colspacing=0>\n";
echo " <tr>";
for ($i = 0; $i != ore_get_ore_count(); $i++) {
if ($i % 3 == 0) {
echo " </tr>\n";
echo " <tr>\n";
}
echo " <td><input type=checkbox name=src_ore_" . $i . ">" . ore_get_ore_name($i) . "</td>\n";
}
echo " </tr>\n";
echo " </table>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr><td colspan=2> </td></tr>\n";
echo " <tr>\n";
echo " <td> Destination Planet: </td>\n";
echo " <td>\n";
echo " <select name=dst_pid>\n";
$result = sql_query("SELECT * FROM g_anomalies WHERE user_id={$user_id}");
$planetlist = csl_create_array($result, 'csl_discovered_id');
// Get all planets which we own...
foreach ($planetlist as $planet_id) {
$planet = anomaly_get_anomaly($planet_id);
if ($planet['user_id'] == 0) {
continue;
}
if ($planet['user_id'] != $user_id) {
continue;
}
if (user_is_mutual_friend($user_id, $planet['user_id']) and anomaly_is_planet($planet['id']) and planet_is_minable($planet['id'])) {
$sector = sector_get_sector($planet['sector_id']);
echo " <option value=" . encrypt_get_vars($planet['id']) . ">" . $sector['name'] . " / " . $planet['name'] . "</option>\n";
}
}
// And now, all other planets with a different user_id
foreach ($planetlist as $planet_id) {
$planet = anomaly_get_anomaly($planet_id);
if ($planet['user_id'] == 0) {
continue;
}
if ($planet['user_id'] == $user_id) {
continue;
}
if (user_is_mutual_friend($user_id, $planet['user_id']) and anomaly_is_planet($planet['id']) and planet_is_minable($planet)) {
$sector = sector_get_sector($planet['sector_id']);
$race = user_get_race($planet['user_id']);
echo " <option value=" . encrypt_get_vars($planet['id']) . ">(" . $race . ") " . $sector['name'] . " / " . $planet['name'] . "</option>\n";
}
}
echo " </select>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td> Ores: </td>\n";
echo " <td>\n";
echo " <table border=0 cellspacing=0 colspacing=0>\n";
echo " <tr>\n";
for ($i = 0; $i != ore_get_ore_count(); $i++) {
if ($i % 3 == 0) {
echo " </tr>\n";
echo " <tr>\n";
}
echo " <td><input type=checkbox name=dst_ore_" . $i . ">" . ore_get_ore_name($i) . "</td>\n";
}
echo " </tr>\n";
echo " </table>\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr><td colspan=2> </td></tr>\n";
echo " <tr><td></td><td><input type=submit name=submit value='create traderoute'></td></tr>\n";
echo " </table>\n";
form_end();
}
function user_showinfo($user_id, $extended_info = USER_SHOWINFO_NORMAL)
{
assert(is_numeric($user_id));
$user = user_get_user($user_id);
$px_user = user_get_perihelion_user($user_id);
$result = sql_query("SELECT * FROM perihelion.u_access WHERE user_id=" . $user_id . " ORDER BY login DESC LIMIT 1");
$access = sql_fetchrow($result);
sql_query("USE " . $px_user['galaxy_db']);
$result = sql_query("SELECT SUM(population) FROM s_anomalies WHERE user_id=" . $user_id);
$row = sql_fetchrow($result);
$people = $row['0'];
$result = sql_query("SELECT COUNT(*) FROM s_sectors WHERE user_id=" . $user_id);
$row = sql_fetchrow($result);
$sectors_owned = $row['0'];
$result = sql_query("SELECT COUNT(*) FROM s_anomalies WHERE user_id=" . $user_id);
$row = sql_fetchrow($result);
$planets_owned = $row['0'];
$result = sql_query("SELECT DISTINCT sector_id, COUNT(*) FROM s_anomalies WHERE user_id=" . $user_id . " GROUP BY sector_id");
$sector_count = sql_countrows($result);
$sector = sector_get_sector(user_get_home_sector($user_id));
$planet = anomaly_get_anomaly(user_get_home_planet($user_id));
$race = user_get_race($user_id);
$result = sql_query("SELECT * FROM g_alliance WHERE id=" . $user['alliance_id']);
$alliance = sql_fetchrow($result);
if ($user['alliance_id'] != 0) {
$result = sql_query("SELECT COUNT(*) AS count FROM g_users WHERE alliance_id = " . $alliance['id']);
$tmp = sql_fetchrow($result);
$alliance_size = $tmp['count'];
}
$status = "Unknown";
if (user_is_friend(user_ourself(), $user_id)) {
$status = "Single side friend";
}
if (user_is_mutual_friend(user_ourself(), $user_id)) {
$status = "Mutual friend";
}
if (user_is_neutral(user_ourself(), $user_id)) {
$status = "Neutral";
}
if (user_is_enemy(user_ourself(), $user_id)) {
$status = "Enemy";
}
if (user_ourself() == $user_id) {
$status = "";
}
echo "<table border=0 align=center width=60%>";
echo "<tr><th class=white colspan=2>" . $px_user['name'] . "</th><th> </th></tr>";
echo "<tr><th colspan=2><b>" . $px_user['tag'] . "</b></th></tr>";
echo "<tr valign=top>";
echo " <td width=120>";
echo " <img width=100 height=100 src='images/users/" . $px_user['avatar'] . "'><br>";
echo " <br>";
if ($user['alliance_id'] != 0) {
echo " <img width=100 height=100 src='images/users/" . $alliance['avatar'] . "'><br>";
}
echo " </td>";
echo " <td><table border=0 nowrap>";
echo " <tr class=bl><td> Full Name </td><td>:</td><td> " . $px_user['name'] . " </td></tr>";
echo " <tr class=bl><td> User ID </td><td>:</td><td> " . $px_user['id'] . " </td></tr>";
echo " <tr class=bl><td> City </td><td>:</td><td> " . $px_user['city'] . " </td></tr>";
echo " <tr class=bl><td> Country </td><td>:</td><td> " . $px_user['country'] . " </td></tr>";
echo " <tr><td colspan=3> </td></tr>";
if ($status != "") {
echo " <tr class=bl><td> Diplomatic Status </td><td>:</td><td> " . $status . " </td></tr>";
}
echo " <tr class=bl><td> Race </td><td>:</td><td> " . $race . " </td></tr>";
echo " <tr class=bl><td> Home Planet </td><td>:</td><td> " . $planet['name'] . " </td></tr>";
echo " <tr class=bl><td> Home Sector </td><td>:</td><td> " . $sector['name'] . " </td></tr>";
echo " <tr class=bl><td> Population </td><td>:</td><td> " . $people . " </td></tr>";
echo " <tr class=bl><td> Sectors Owned </td><td>:</td><td> " . $sectors_owned . " </td></tr>";
echo " <tr class=bl><td> Planets Owned </td><td>:</td><td> " . $planets_owned . " planet(s) in " . $sector_count . " sector(s) </td></tr>";
if ($user['alliance_id'] != 0) {
echo " <tr class=bl><td> Alliance </td><td>:</td><td> <a href=alliance.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($alliance['id']) . ">" . $alliance['name'] . "</a> </td></tr>";
echo " <tr class=bl><td> Alliance Size </td><td>:</td><td> " . $alliance_size . " user(s) </td></tr>";
}
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Times logged in </td><td>:</td><td> " . $px_user['login_count'] . " </td></tr>";
echo " <tr class=bl><td> Last login </td><td>:</td><td> " . $access['login'] . " </td></tr>";
echo " <tr class=bl><td> Last action </td><td>:</td><td> " . $access['logout'] . " </td></tr>";
if ($extended_info == USER_SHOWINFO_EXTENDED) {
if ($px_user['gender'] == "M") {
$gender = "Male";
} else {
$gender = "Female";
}
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Email </td><td>:</td><td> " . $px_user['email'] . " </td></tr>";
echo " <tr class=bl><td> Login Name </td><td>:</td><td> " . $px_user['login_name'] . " </td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> City </td><td>:</td><td> " . $px_user['city'] . " </td></tr>";
echo " <tr class=bl><td> Country </td><td>:</td><td> " . $px_user['country'] . " </td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Birthday </td><td>:</td><td> " . $px_user['birthday'] . " </td></tr>";
echo " <tr class=bl><td> Gender </td><td>:</td><td> " . $gender . " </td></tr>";
}
if ($user_id != user_ourself()) {
echo "<tr><th colspan=3>";
echo "[ <a href=message.php?uid=" . encrypt_get_vars($user_id) . ">Send Message</a> ]";
echo "</th></tr>";
echo "<tr><th colspan=3>";
echo "[ <a href=user.php?cmd=" . encrypt_get_vars("relation") . "&uid=" . encrypt_get_vars($user_id) . "&wid=" . encrypt_get_vars(RELATION_FRIEND) . ">Set as friend</a> ] - ";
echo "[ <a href=user.php?cmd=" . encrypt_get_vars("relation") . "&uid=" . encrypt_get_vars($user_id) . "&wid=" . encrypt_get_vars(RELATION_NEUTRAL) . ">Set as neutral</a> ] - ";
echo "[ <a href=user.php?cmd=" . encrypt_get_vars("relation") . "&uid=" . encrypt_get_vars($user_id) . "&wid=" . encrypt_get_vars(RELATION_ENEMY) . ">Set as enemy</a> ]";
echo "</th></tr>";
}
echo " </table></td>";
echo "</tr>";
echo "</table>";
echo "<br><br>";
}
function planet_show_planet($planet_id)
{
assert(!empty($planet_id));
global $_GALAXY;
global $_CONFIG;
global $_RUN;
if (!anomaly_is_planet($planet_id)) {
return;
}
$planet = anomaly_get_anomaly($planet_id);
$result = sql_query("SELECT * FROM g_ores WHERE planet_id=" . $planet_id);
$ore = sql_fetchrow($result);
$stock_ore = ore_csl_to_list($ore['stock_ores']);
$race = user_get_race($planet['user_id']);
$sector = sector_get_sector($planet['sector_id']);
$result = sql_query("SELECT * FROM s_state WHERE id=" . $planet['state_id']);
$state = sql_fetchrow($result);
if ($race == "") {
$race = "-";
}
$extra_attack = 0;
$extra_defense = 0;
$attack = $planet['cur_attack'];
$defense = $planet['cur_attack'];
// Count all ships and their attack/defense currently in orbit around the planet
$result = sql_query("SELECT COUNT(*) FROM g_vessels AS g, s_vessels AS s WHERE g.planet_id=" . $planet_id . " AND s.id = g.vessel_id AND s.type='" . VESSEL_TYPE_BATTLE . "' AND status='ORBIT' AND created=1");
$tmp = sql_fetchrow($result);
$battle_vessels = $tmp[0];
$result = sql_query("SELECT COUNT(*) FROM g_vessels AS g, s_vessels AS s WHERE g.planet_id=" . $planet_id . " AND s.id = g.vessel_id AND s.type='" . VESSEL_TYPE_TRADE . "' AND status='ORBIT' AND created=1");
$tmp = sql_fetchrow($result);
$trade_vessels = $tmp[0];
$result = sql_query("SELECT COUNT(*) FROM g_vessels AS g, s_vessels AS s WHERE g.planet_id=" . $planet_id . " AND s.id = g.vessel_id AND s.type='" . VESSEL_TYPE_EXPLORE . "' AND status='ORBIT' AND created=1");
$tmp = sql_fetchrow($result);
$explore_vessels = $tmp[0];
$result = sql_query("SELECT SUM(cur_attack) AS CA, SUM(cur_defense) AS CD FROM g_vessels AS g WHERE g.planet_id=" . $planet_id . " AND status='ORBIT' AND created=1");
$tmp = sql_fetchrow($result);
if (isset($tmp['CA'])) {
$extra_attack = $extra_attack + $tmp['CA'];
}
if (isset($tmp['CD'])) {
$extra_defense = $extra_defense + $tmp['CD'];
}
$template = new Smarty();
$template->debugging = true;
$template->assign("sector_name", $sector['name']);
$template->assign("planet_name", $planet['name']);
$template->assign("image", $_CONFIG['IMAGE_URL'] . $_GALAXY['image_dir'] . "/planets/" . $planet['image'] . ".jpg");
if ($planet['unknown'] == 1) {
$template->assign("cmd", encrypt_get_vars("claim"));
$template->assign("formid", generate_form_id());
$template->assign("aid", encrypt_get_vars($planet_id));
$template->assign("rename_form_visible", "true");
} else {
$template->assign("rename_form_visible", "false");
}
$template->assign("class", $planet['class']);
$template->assign("race", $race);
$template->assign("state", $state['name']);
$template->assign("happieness", planet_get_happy_string($planet['happieness']));
$template->assign("healtieness", planet_get_healty_string($planet['sickness']));
$template->assign("population", $planet['population']);
$template->assign("radius", $planet['radius']);
$template->assign("distance", $planet['distance']);
$template->assign("water", $planet['water']);
$template->assign("temperature", $planet['temperature']);
for ($i = 0; $i != ore_get_ore_count(); $i++) {
$tmp = array();
$tmp['name'] = ore_get_ore_name($i);
$tmp['stock'] = $stock_ore[$i];
$tmpvar[] = $tmp;
}
$template->assign("ores", $tmpvar);
$template->assign("attack", $attack);
$template->assign("extra_attack", $extra_attack);
$template->assign("defense", $defense);
$template->assign("extra_defense", $extra_defense);
$template->assign("strength", $planet['cur_strength']);
$template->assign("orbit_battle", $trade_vessels);
$template->assign("orbit_trade", $battle_vessels);
$template->assign("orbit_explore", $explore_vessels);
$template->assign("description", convert_px_to_html_tags($planet['description']));
$template->display($_RUN['theme_path'] . "/planet-details.tpl");
$commands = array();
// If we have at least 1 ship in orbit, we can view them here...
if ($explore_vessels + $trade_vessels + $battle_vessels > 0) {
$commands['View Vessels'] = "vessel.php?cmd=" . encrypt_get_vars("showaid") . "&aid=" . encrypt_get_vars($planet_id);
}
// If it's a solid-class planet (lower than M), we can view the surface.
if (planet_is_habitable($planet_id) or planet_is_minable($planet_id)) {
$commands['View Surface'] = "surface.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($planet_id);
}
// If it's our planet we might construct and manufacture,..
if (anomaly_am_i_owner($planet['id'])) {
$commands['Change Description'] = "anomaly.php?cmd=" . encrypt_get_vars("description") . "&aid=" . encrypt_get_vars($planet_id);
// Only minable or habitable or lower can construct
if (planet_is_habitable($planet_id) or planet_is_minable($planet_id)) {
$commands['Construct'] = "construct.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($planet_id);
$commands['Manufacture'] = "manufacture.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($planet_id);
}
if (planet_has_vesselbuilding_capability($planet_id)) {
$commands['Create Vessel'] = "vesselcreate.php?cmd=" . encrypt_get_vars("showaid") . "&aid=" . encrypt_get_vars($planet_id);
}
}
create_submenu($commands);
}
function alliance_showinfo($alliance_id, $user_id, $extended_info = USER_SHOWINFO_NORMAL)
{
assert(is_numeric($alliance_id));
assert(is_numeric($user_id));
assert(is_numeric($extended_info));
$result = sql_query("SELECT * FROM g_alliance WHERE id={$alliance_id}");
$alliance = sql_fetchrow($result);
$race = user_get_race($alliance['owner_id']);
$result = sql_query("SELECT COUNT(*) AS count FROM g_users WHERE alliance_id = " . $alliance['id']);
$tmp = sql_fetchrow($result);
$alliance_size = $tmp['count'];
$user = user_get_user($user_id);
$result = sql_query("SELECT COUNT(*) FROM s_sectors, g_users WHERE s_sectors.user_id = g_users.user_id AND g_users.alliance_id = " . $alliance_id);
$row = sql_fetchrow($result);
$sectors_owned = $row['0'];
$result = sql_query("SELECT COUNT(*) FROM s_anomalies, g_users WHERE s_anomalies.user_id = g_users.user_id AND g_users.alliance_id = " . $alliance_id);
$row = sql_fetchrow($result);
$planets_owned = $row['0'];
echo "<table border=0 align=center width=60%>";
echo "<tr><th class=white colspan=2>" . $alliance['name'] . "</th></tr>";
echo "<tr><th colspan=2><b>" . $alliance['tag'] . "</b></th></tr>";
echo "<tr valign=top>";
echo " <td width=120>";
echo " <img width=100 height=100 src='images/users/" . $alliance['avatar'] . "'><br>";
echo " </td>";
echo " <td><table border=0 nowrap width=100%>";
echo " <tr class=bl><td colspan=3>" . $alliance['description'] . "</td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Owner </td><td>:</td><td> <a href=stats.php?cmd=" . encrypt_get_vars("show") . "&uid=" . encrypt_get_vars($alliance['owner_id']) . ">" . $race . " race</a> </td></tr>";
echo " <tr class=bl><td> Size </td><td>:</td><td> " . $alliance_size . " user(s)</a> </td></tr>";
echo " <tr><td colspan=3> </td></tr>";
echo " <tr class=bl><td> Sectors Owned </td><td>:</td><td> " . $sectors_owned . " sector(s) </td></tr>";
echo " <tr class=bl><td> Planets Owned </td><td>:</td><td> " . $planets_owned . " planet(s)</td></tr>";
echo " <tr class=bl><td colspan=3>\n";
// Only show the users in the alliance when we are part of that alliance...
if ($user['alliance_id'] == $alliance_id) {
$result = sql_query("SELECT * FROM g_users WHERE alliance_id=" . $alliance['id']);
while ($tmp_user = sql_fetchrow($result)) {
$tmp_race = user_get_race($tmp_user['user_id']);
echo "<a href=stats.php?cmd=" . encrypt_get_vars("show") . "&uid=" . encrypt_get_vars($tmp_user['user_id']) . ">" . $tmp_race . " race</a>, \n";
}
echo " </td></tr>\n";
// We can only part an alliance if we're not the owner of it, if we are owner, we can disband the alliance (?)
if ($user['user_id'] == $alliance['owner_id']) {
echo "<tr><th colspan=3>";
echo "[ Disband this alliance ] ";
echo "</th></tr>";
} else {
echo "<tr><th colspan=3>";
echo "[ <a href=alliance.php?aid=" . encrypt_get_vars(0 - $alliance_id) . "&uid=" . encrypt_get_vars($user['user_id']) . ">Part this alliance</a> ] ";
echo "</th></tr>";
}
}
// We're not part of an alliance.. We can join if we want...
if ($user['alliance_id'] == 0) {
$result2 = sql_query("SELECT * FROM g_alliance_pending WHERE user_id=" . $user['user_id']);
$pending = sql_fetchrow($result2);
// If we already are pending for joining this alliance, we cannot click it anymore..
if ($pending['alliance_id'] == $alliance_id) {
echo "<tr><th colspan=3>";
echo "[ Request pending ] ";
echo "</th></tr>";
} else {
echo "<tr><th colspan=3>";
echo "[ <a href=alliance.php?aid=" . encrypt_get_vars($alliance_id) . "&uid=" . encrypt_get_vars($user['user_id']) . ">Join this alliance</a> ] ";
echo "</th></tr>";
}
}
echo " </table></td>";
echo "</tr>";
echo "</table>";
echo "<br><br>";
}
