echo "</table></td></tr>";
echo "<tr><td>Combat</td>";
echo "<td><table border=0 cellspacing=0 cellpadding=5>";
echo "<tr><td>Fighters</td><td><input type=text size=8 name=ship_fighters value=\"{$row['ship_fighters']}\"></td>";
echo "<td>Torpedoes</td><td><input type=text size=8 name=torps value=\"{$row['torps']}\"></td></tr>";
echo "<tr><td>Armor Pts</td><td><input type=text size=8 name=armor_pts value=\"{$row['armor_pts']}\"></td></tr>";
echo "</table></td></tr>";
echo "<tr><td>Devices</td>";
echo "<td><table border=0 cellspacing=0 cellpadding=5>";
echo "<tr><td>Beacons</td><td><input type=text size=5 name=dev_beacon value=\"{$row['dev_beacon']}\"></td>";
echo "<td>Warp Editors</td><td><input type=text size=5 name=dev_warpedit value=\"{$row['dev_warpedit']}\"></td>";
echo "<td>Genesis Torpedoes</td><td><input type=text size=5 name=dev_genesis value=\"{$row['dev_genesis']}\"></td></tr>";
echo "<tr><td>Mine Deflectors</td><td><input type=text size=5 name=dev_minedeflector value=\"{$row['dev_minedeflector']}\"></td>";
echo "<td>Emergency Warp</td><td><input type=text size=5 name=dev_emerwarp value=\"{$row['dev_emerwarp']}\"></td></tr>";
echo "<tr><td>Escape Pod</td><td><input type=checkbox name=dev_escapepod value=ON " . \Tki\Checked::check($row['dev_escapepod']) . "></td>";
echo "<td>FuelScoop</td><td><input type=checkbox name=dev_fuelscoop value=ON " . \Tki\Checked::check($row['dev_fuelscoop']) . "></td></tr>";
echo "</table></td></tr>";
echo "<tr><td>Credits</td><td><input type=text name=credits value=\"{$row['credits']}\"></td></tr>";
echo "<tr><td>Turns</td><td><input type=text name=turns value=\"{$row['turns']}\"></td></tr>";
echo "<tr><td>Current sector</td><td><input type=text name=sector value=\"{$row['sector']}\"></td></tr>";
echo "</table>";
echo "<br>";
echo "<input type=hidden name=user value={$user}>";
echo "<input type=hidden name=operation value=save>";
echo "<input type=submit value=Save>";
// Show Xenobe log data
echo "<hr>";
echo "<span style=\"font-family : courier, monospace; font-size: 12pt; color: #0f0;\">Log Data For This Xenobe</span><br>";
$logres = $db->Execute("SELECT * FROM {$db->prefix}logs WHERE ship_id = ? ORDER BY time DESC, type DESC;", array($row['ship_id']));
Tki\Db::LogDbErrors($pdo_db, $logres, __LINE__, __FILE__);
while (!$logres->EOF) {
echo " <input type='submit' value='" . $langvars['l_edit'] . "'>";
} else {
if (empty($operation)) {
// Get planet info from database
$sql = "SELECT * FROM ::prefix::planets WHERE planet_id=:planet_id LIMIT 1";
$stmt = $pdo_db->prepare($sql);
$stmt->bindParam(':planet_id', $planet);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
echo "<table border='0' cellspacing='2' cellpadding='2'>";
echo "<tr><td><tt>" . $langvars['l_admin_planet_id'] . "</tt></td><td><font color='#6f0'>" . $planet . "</font></td>";
echo "<td align='right'><tt>" . $langvars['l_admin_sector_id'] . "</tt><input type='text' size='5' name='sector_id' value=\"" . $row['sector_id'] . "\"></td>";
echo "<td align='right'><tt>" . $langvars['l_admin_defeated'] . "</tt><input type='checkbox' name='defeated' value='ON' " . \Tki\Checked::check($row['defeated']) . "></td></tr>";
echo "<tr><td><tt>" . $langvars['l_admin_planet_name'] . "</tt></td><td><input type='text' size='15' name='name' value=\"" . $row['name'] . "\"></td>";
echo "<td align='right'><tt>" . $langvars['l_base'] . "</tt><input type='checkbox' name='base' value='ON' " . \Tki\Checked::check($row['base']) . "></td>";
echo "<td align='right'><tt>" . $langvars['l_admin_sells'] . "</tt><input type='checkbox' name='sells' value='ON' " . \Tki\Checked::check($row['sells']) . "></td></tr>";
echo "<tr><td colspan='4'><hr></td></tr>";
echo "</table>";
echo "<table border='0' cellspacing='2' cellpadding='2'>";
echo "<tr><td><tt>" . $langvars['l_admin_planet_owner'] . "</tt></td><td>";
echo "<select size='1' name='owner'>";
$ressuba = $db->Execute("SELECT ship_id,character_name FROM {$db->prefix}ships ORDER BY character_name");
Tki\Db::LogDbErrors($pdo_db, $ressuba, __LINE__, __FILE__);
echo "<option value='0'>" . $langvars['l_admin_no_one'] . "</option>";
while (!$ressuba->EOF) {
$rowsuba = $ressuba->fields;
if ($rowsuba['ship_id'] == $row['owner']) {
echo "<option selected='" . $rowsuba['ship_id'] . "' value='" . $rowsuba['ship_id'] . "'>" . $rowsuba['character_name'] . "</option>";
} else {
echo "<option value='" . $rowsuba['ship_id'] . "'>" . $rowsuba['character_name'] . "</option>";
}
