function admiral_has_pending_upgrade($id)
{
$sth = mysql_query("select used_xp from admirals where id={$id}");
if (!$sth || mysql_num_rows($sth) == 0) {
return 0;
}
list($used_xp) = mysql_fetch_row($sth);
if (calculate_admiral_level($used_xp) < get_admiral_level($id)) {
return true;
} else {
return false;
}
}
function execute_examinefleet()
{
global $uid;
$its_fleet = new fleet($_GET["fid"]);
$can_see = false;
if ($its_fleet->uid == $uid) {
show_svg_message("There should be no button that would allow you doing this. :S");
return false;
}
$allies = get_allied_ids($uid);
if (is_array($allies)) {
array_push($allies, $uid);
} else {
$allies[] = $uid;
}
$allied_fleet = in_array($its_fleet->uid, $allies);
// check ob eigene oder alleierte planeten im system sind
$sth = mysql_query("select 1 from planets where sid=" . $its_fleet->sid . " and uid in (" . implode(",", $allies) . ") LIMIT 1");
if (!$sth) {
show_svg_message("There was an Database error #mcontrol:exec_exam_fleet:1");
return false;
}
if (mysql_num_rows($sth) > 0) {
$can_see = true;
}
// check ob eigene oder alleierte flotten im system sind
if (!$can_see) {
$sth = mysql_query("select 1 from fleet_info where sid=" . $its_fleet->sid . " and uid in (" . implode(",", $allies) . ") LIMIT 1");
if (!$sth) {
show_svg_message("There was an Database error #mcontrol:exec_exam_fleet:2");
return false;
}
if (mysql_num_rows($sth) > 0) {
$can_see = true;
}
}
if (can_see) {
$doc = domxml_new_doc("1.0");
$rootElem = $doc->create_element("SR_REQUEST");
$rootElem->set_attribute("type", "examine_fleet");
$rootElem->set_attribute("fid", $its_fleet->fid);
$rootElem->set_attribute("owner", $its_fleet->uid);
$missionElem = $doc->create_element("SR_FLEET_MISSION");
$no_scan = false;
// mission
if ($allied_fleet) {
// alleierte Flotte, wir sehen die mission
// mission kann sich unterscheiden wenn das ziel feindlich ist.
$no_target = false;
$target_relation = false;
if ($its_fleet->tsid > 0 && $its_fleet->tpid > 0) {
$sth = mysql_query("SELECT s.name as s_name, p.name, p.uid, p.type, p.id FROM systems s LEFT JOIN planets p on s.id = p.sid WHERE s.id = " . $its_fleet->tsid . " and p.id=" . $its_fleet->tpid);
} elseif ($its_fleet->tsid > 0) {
$sth = mysql_query("SELECT name as s_name from systems where id = " . $its_fleet->tsid);
} else {
$no_target = true;
}
if (!$no_target) {
if (!$sth || mysql_num_rows($sth) == 0) {
show_svg_message("ERR::Can not get Target");
return false;
}
$target_info = mysql_fetch_assoc($sth);
if ($target_info["s_name"]) {
$missionElem->set_attribute("tsys_name", htmlspecialchars($target_info["s_name"]));
}
if ($target_info["name"]) {
if ($target_info["name"] == "Unnamed") {
$target_info["name"] = get_planetname($target_info["id"]);
}
$missionElem->set_attribute("tpla_name", htmlspecialchars($target_info["name"]));
$missionElem->set_attribute("tpla_type", $target_info["type"]);
if ($target_info["uid"] > 0) {
$target_relation = get_uids_relation($its_fleet->uid, $target_info["uid"]);
}
}
$eta = get_true_ETA_by_fid($its_fleet->fid);
$rootElem->set_attribute("eta", $eta);
}
switch ($its_fleet->mission) {
case M_MOVE:
if ($target_relation == "enemy") {
$missionElem->set_attribute("mission", "fleet_mission_attack.svgz");
$missionElem->set_attribute("missionText", "Attacking");
} elseif ($target_relation == "allie" || $target_relation == "same" || $its_fleet->tsid == 0) {
$missionElem->set_attribute("mission", "fleet_mission_defend.svgz");
$missionElem->set_attribute("missionText", "Defending");
} else {
$missionElem->set_attribute("mission", "fleet_mission_move.svgz");
$missionElem->set_attribute("missionText", "Moving");
}
break;
case M_INVADE:
$missionElem->set_attribute("mission", "fleet_mission_invade.svgz");
$missionElem->set_attribute("missionText", "Invading");
break;
case M_BOMB:
$missionElem->set_attribute("mission", "fleet_mission_bomb.svgz");
$missionElem->set_attribute("missionText", "Bombarding");
break;
case M_COLONIZE:
$missionElem->set_attribute("mission", "fleet_mission_colonize.svgz");
$missionElem->set_attribute("missionText", "Colonizing");
break;
}
$missionElem->set_attribute("tactic", $its_fleet->tactic);
} else {
$missionElem->set_attribute("mission", "fleet_mission_unknown.svgz");
$missionElem->set_attribute("missionText", "unknown mission");
$missionElem->set_attribute("tactic", "-1");
// gucken ob wir no-scan schiffe haben (special 'N' in shipvalues)
$sth = mysql_query("SELECT s.prod_id FROM fleet f, shipvalues s WHERE s.special = 'N' AND s.prod_id = f.prod_id AND f.fid = " . $its_fleet->fid);
if (!$sth) {
show_svg_message("ERROR::Getting NOSCAN ships");
return false;
}
if (mysql_num_rows($sth) > 0) {
$no_scan = true;
}
// gucken ob der planet vielleicht so nen gebäude hat??
if (!$no_scan && $its_fleet->pid > 0) {
// alleierte der flotte
$fleet_allies = get_allied_ids($its_fleet->uid);
if (is_array($fleet_allies)) {
array_push($fleet_allies, $its_fleet->uid);
} else {
$fleet_allies[] = $its_fleet->uid;
}
$sth = mysql_query("SELECT s.prod_id FROM planets p, constructions c join shipvalues s using(prod_id) where s.special='N' and c.pid = p.id and p.id = " . $its_fleet->pid . " and p.uid in (" . implode(",", $fleet_allies) . ")");
if (!$sth) {
show_svg_message("ERROR::Getting NOSCAN buildings");
return false;
}
if (mysql_num_rows($sth) > 0) {
$no_scan = true;
}
}
}
$rootElem->append_child($missionElem);
// ships
if (!$no_scan) {
foreach ($its_fleet->ships as $prod_id => $values) {
$shipElem = $doc->create_element("SR_SHIP");
$shipElem->set_attribute("prod_id", $prod_id);
$shipElem->set_attribute("count", $values[0]);
if ($allied_fleet) {
$shipElem->set_attribute("reload", $values[1]);
} else {
$shipElem->set_attribute("reload", -1);
}
$rootElem->append_child($shipElem);
}
}
// admiral
$sth = mysql_query("SELECT a.pic, a.name, a.id, a.fid from admirals a join fleet_info f using(fid) having a.fid=" . $its_fleet->fid . "");
if (!$sth) {
show_svg_message("There was an Database error #mcontrol:exec_exam_fleet:3");
return false;
}
if (mysql_num_rows($sth) > 0) {
list($a_pic, $a_name, $a_id) = mysql_fetch_row($sth);
$admiralElem = $doc->create_element("SR_ADMIRAL");
$admiralElem->set_attribute("name", $a_name);
$admiralElem->set_attribute("pic", $a_pic);
$admiralElem->set_attribute("level", get_admiral_level($a_id));
$rootElem->append_child($admiralElem);
$rootElem->set_attribute("pic", "ADMIRAL");
} else {
if (!$no_scan) {
$rootElem->set_attribute("pic", get_strongest_ship_by_fid($its_fleet->fid));
} else {
$rootElem->set_attribute("pic", 0);
}
}
$doc->append_child($rootElem);
echo $doc->dump_mem();
} else {
show_svg_message("Either this is a bug or you're a h4xx0r. :S");
}
}
function show_admiral()
{
global $uid;
global $fid;
global $PHP_SELF;
$sth = mysql_query("select * from admirals where fid=" . $fid . " and uid=" . $uid);
if (!$sth) {
echo "Database failure!";
}
if (mysql_num_rows($sth) == 0) {
show_message("You currently don't have any Admiral assigned!");
} else {
$admiral = mysql_fetch_array($sth);
center_headline("Admiral");
table_start("center", "500");
table_head_text(array("Admiral " . $admiral["name"] . ""), "8");
table_text(array(" "), "", "", "8", "text");
table_text_open();
table_text_design(" ", "50", "", "", "head");
table_text_design("Name", "200", "", "", "head");
table_text_design("Rank", "75", "", "", "head");
table_text_design("Initiative", "75", "", "", "head");
table_text_design("Agility", "75", "", "", "head");
table_text_design("Sensor", "75", "", "", "head");
table_text_design("Weaponskill", "75", "", "", "head");
table_text_design(" ", "75", "", "", "head");
table_text_close();
if ($admiral["value"] < 1000) {
$level = 0;
} else {
$level = floor(log10($admiral["value"] / 1000) / log10(2) + 1);
}
table_text_open();
table_text_design("<img src=\"portraits/" . $admiral["pic"] . "\" border=\"0\" alt=\"" . $admiral["name"] . "\">", $admiral["name"], "200", "center", "", "text");
table_text_design($admiral["name"], "75", "center", "", "text");
table_text_design(get_admiral_level($admiral["id"]), "75", "center", "", "text");
foreach (array("initiative", "agility", "sensor", "weaponskill") as $dummy => $value) {
if (calculate_admiral_level($admiral["used_xp"]) < get_admiral_level($admiral["id"])) {
$upgrade = "<a href=\"" . $PHP_SELF . "?act=upgrade_admiral&id=" . $admiral["id"] . "&value=" . $value . "&fid={$fid}\"><img src=\"arts/plus.jpg\" border=\"0\" width=\"10\"></a>";
} else {
$upgrade = "";
}
table_text_design($upgrade . $admiral[$value], "75", "center", "", "text");
}
table_text_design("<a href=\"" . $PHP_SELF . "?act=unassign_admiral&fid=" . $fid . "\">unassign</a>", "75", "center", "", "text");
table_text_close();
table_end();
}
$sth = mysql_query("select * from admirals where fid=0 and uid={$uid}");
if (!$sth) {
show_error("Database error!");
return 0;
}
if (mysql_num_rows($sth) == 0) {
return 0;
}
center_headline("Admiral Pool");
table_start("center", "500");
table_head_text(array("Admiral Pool"), "8");
table_text(array(" "), "", "", "8", "text");
table_text_open("head", "center");
table_text_design(" ", "50", "", "", "head");
table_text_design("Name", "180", "", "", "head");
table_text_design("Rank", "75", "", "", "head");
table_text_design("Initiative", "75", "", "", "head");
table_text_design("Agility", "75", "", "", "head");
table_text_design("Sensor", "75", "", "", "head");
table_text_design("Weaponskill", "75", "", "", "head");
table_text_design(" ", "20", "", "", "head");
table_text_close();
while ($admiral = mysql_fetch_array($sth)) {
if ($admiral["value"] < 1000) {
$level = 0;
} else {
$level = floor(log10($admirals["value"] / 1000) / log10(2) + 1);
}
table_text_open();
table_text_design("<img src=\"portraits/" . $admiral["pic"] . "\" border=\"0\" alt=\"" . $admiral["name"] . "\">", $admiral["name"], "200", "center", "", "text");
table_text_design($admiral["name"], "75", "center", "", "text");
table_text_design(get_admiral_level($admiral["id"]), "75", "center", "", "text");
foreach (array("initiative", "agility", "sensor", "weaponskill") as $dummy => $value) {
if (calculate_admiral_level($admiral["used_xp"]) < get_admiral_level($admiral["id"])) {
$upgrade = "<a href=\"" . $PHP_SELF . "?act=upgrade_admiral&id=" . $admiral["id"] . "&value=" . $value . "&fid={$fid}\"><img src=\"arts/plus.jpg\" border=\"0\" width=\"10\"></a>";
} else {
$upgrade = "";
}
table_text_design($upgrade . $admiral[$value], "75", "center", "", "text");
}
table_text_design("<a href=\"" . $PHP_SELF . "?act=assign&fid={$fid}&aid=" . $admiral["id"] . "\">Assign</a>", "75", "center", "", "text");
table_text_close();
}
table_end();
}
