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>"; }