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 show_constructions($anomaly_id)
{
assert(is_numeric($anomaly_id));
// Get global information stuff
$planet = anomaly_get_anomaly($anomaly_id);
$user = user_get_user($planet['user_id']);
// And get the ores from the planet
$result = sql_query("SELECT * FROM g_ores WHERE planet_id=" . $anomaly_id);
$ores = sql_fetchrow($result);
// Get all buildings that are currently build on the planet
$surface = planet_get_surface($anomaly_id);
$current_buildings = csl($surface['csl_building_id']);
// If we've got an headquarter and it's inactive, we cannot build anything.. :(
if (in_array(BUILDING_HEADQUARTER_INACTIVE, $current_buildings)) {
print_line("Your headquarter is currently inactive due to insufficent resources for its upkeep. You cannot build anything on this planet until you replenish your resources.");
$cannot_build = true;
return;
}
print_subtitle("Construction on planet " . $planet['name']);
// And get all buildings, compare wether or not we may build them...
$result = sql_query("SELECT * FROM s_buildings ORDER BY id");
while ($building = sql_fetchrow($result)) {
// Default, we can build this
$cannot_build = false;
// Stage -1: Check planet class when we want to build a headquarter
if ($building['id'] == BUILDING_HEADQUARTER) {
if (!planet_is_habitable($anomaly_id)) {
$cannot_build = true;
}
}
// Stage 0: Check building_level
if ($building['build_level'] > $user['building_level']) {
$cannot_build = true;
}
// Stage 1: Building Count Check
// Build counter check
if ($building['max'] > 0) {
$times_already_build = 0;
for ($i = 0; $i != count($current_buildings); $i++) {
if (building_active_or_inactive($current_buildings[$i]) == $building['id']) {
$times_already_build++;
}
}
// Cannot build cause we already have MAX buildings of this kind.. :(
// building['max'] = 0 means unlimited buildings...
if ($times_already_build == $building['max']) {
$cannot_build = true;
}
}
// Stage 2: Dependency Check
// Get all dependencies
$buildings_needed = csl($building['csl_depends']);
// Do we need them? If not, skip dependency-check.
if (!empty($building['csl_depends'])) {
$deps_found = count($buildings_needed);
// Count to zero...
while (list($key, $building_dep_id) = each($buildings_needed)) {
if ($building_dep_id == "") {
$deps_found--;
continue;
}
// Get all dependencies
if (in_array($building_dep_id, $current_buildings)) {
$deps_found--;
// Found in current_buildings?
// Decrease counter
}
}
} else {
// No need for deps
$deps_found = 0;
// Zero is good...
}
// Not all dependencies found, we cannot build it.. :(
if ($deps_found > 0) {
$cannot_build = true;
}
// Stage 3: Show building if we can build it..
if ($cannot_build == false) {
building_show_details($building['id'], $planet['id'], $user['user_id'], $ores['stock_ores']);
}
}
}
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 conview_show_sector($user_id, $sector_id, $planets)
{
assert(is_numeric($user_id));
assert(is_numeric($sector_id));
assert(is_array($planets));
global $_RUN;
$tmpvar3 = array();
// Check how many planets we own in this sector. If none, don't show anything...
$result = sql_query("SELECT COUNT(*) AS count FROM s_anomalies WHERE sector_id = " . $sector_id . " AND user_id=" . $user_id, JUST_ONE_ALLOWED);
$tmp = sql_fetchrow($result);
if ($tmp['count'] == 0) {
return;
}
// Get sector information
$sector = sector_get_sector($sector_id);
// Get planet information for all planets in the sector
$result = sql_query("SELECT * FROM s_anomalies WHERE sector_id=" . $sector_id . " AND user_id=" . $user_id . " ORDER BY distance", MULTIPLE_ALLOWED);
while ($planet = sql_fetchrow($result)) {
// If we can't view the planet, then don't show it...
if (!in_array($planet['id'], $planets)) {
continue;
}
// Can we show this planet (eg, is it in our $planets-array)
if (!empty($visible_planets) && !in_array($planet['id'], $visible_planets)) {
continue;
}
$tmpvar = array();
$tmpvar['name'] = $planet['name'];
$tmpvar['href'] = "anomaly.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($planet['id']);
if (anomaly_is_planet($planet['id'])) {
$tmpvar['viewstring'] = "View Planet";
} else {
$tmpvar['viewstring'] = "View Anomaly";
}
$tmpvar2 = array();
if (planet_is_habitable($planet['id']) or planet_is_minable($planet['id'])) {
$tmpvar2['href'] = "surface.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($planet['id']);
$tmpvar2['str'] = "Surface View";
$tmpvar['href_array'][] = $tmpvar2;
$tmpvar2['href'] = "construct.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($planet['id']);
$tmpvar2['str'] = "Construction";
$tmpvar['href_array'][] = $tmpvar2;
$tmpvar2['href'] = "manufacture.php?cmd=" . encrypt_get_vars("show") . "&aid=" . encrypt_get_vars($planet['id']);
$tmpvar2['str'] = "Manufacturing";
$tmpvar['href_array'][] = $tmpvar2;
if (planet_has_vesselbuilding_capability($planet['id'])) {
$tmpvar2['href'] = "vesselcreate.php?cmd=" . encrypt_get_vars("showaid") . "&aid=" . encrypt_get_vars($planet['id']);
$tmpvar2['str'] = "Create Vessel";
$tmpvar['href_array'][] = $tmpvar2;
} else {
$tmpvar2['href'] = "";
$tmpvar2['str'] = "";
$tmpvar['href_array'][] = $tmpvar2;
}
} else {
$tmpvar2['href'] = "";
$tmpvar2['str'] = "";
$tmpvar['href_array'][] = $tmpvar2;
$tmpvar['href_array'][] = $tmpvar2;
$tmpvar['href_array'][] = $tmpvar2;
$tmpvar['href_array'][] = $tmpvar2;
}
$tmpvar3[] = $tmpvar;
}
// while
$template = new Smarty();
$template->debugging = true;
$template->assign("sector_id", $sector['sector']);
$template->assign("sector_name", $sector['name']);
$template->assign("planets", $tmpvar3);
$template->display($_RUN['theme_path'] . "/conview.tpl");
}
function info_get_anomaly_statistics($user_id)
{
assert(isset($user_id));
$minable = 0;
$habitable = 0;
$unusable = 0;
$starbase = 0;
$wormhole = 0;
$anomalies = 0;
$blackhole = 0;
$result = sql_query("SELECT * FROM s_anomalies WHERE user_id = " . $user_id);
while ($anomaly = sql_fetchrow($result)) {
if (anomaly_is_planet($anomaly['id'])) {
if (planet_is_habitable($anomaly['id'])) {
$habitable++;
} elseif (planet_is_minable($anomaly['id'])) {
$minable++;
} else {
$unusable++;
}
} elseif (anomaly_is_wormhole($anomaly['id'])) {
$wormhole++;
} elseif (anomaly_is_starbase($anomaly['id'])) {
$starbase++;
} elseif (anomaly_is_blackhole($anomaly['id'])) {
$blackhole++;
} else {
$anomalies++;
}
}
return array($minable, $habitable, $unusable, $starbase, $wormhole, $blackhole, $anomalies);
}
