// RESOURCES
foreach (db_select('planet_resources', 'planet_id = ' . $id) as $arrResource) {
$iGain = applyRDChange('income_' . $arrResource['resource_id'], res_per_type($arrResource['asteroids']), $id);
if (0 < $iGain) {
db_update('planet_resources', 'amount = amount + ' . $iGain, 'planet_id = ' . $id . ' AND resource_id = ' . $arrResource['resource_id']);
}
}
#continue;
// COMBAT // SECTION F
// De info van de personen die $id AANVALLEN | $id = battlefield
$szAWhere = 'destination_planet_id = ' . $id . ' AND eta = 0 AND action = \'attack\' AND actiontime > 0 AND activated = \'1\'';
$arrAttackingFleets = db_select_by_field('fleets', 'id', $szAWhere);
if (0 < count($arrAttackingFleets)) {
$iAttackingOwners = db_select_one('fleets', 'COUNT(DISTINCT owner_planet_id)', $szAWhere);
$szDWhere = '(destination_planet_id = ' . $id . ' AND eta = 0 AND action = \'defend\' AND actiontime > 0 AND activated = \'1\') OR (owner_planet_id = ' . $id . ' AND ((destination_planet_id IS NULL AND eta = 0) OR activated != \'1\'))';
$arrDefendingFleets = db_select_by_field('fleets', 'id', $szDWhere);
$iDefendingOwners = db_select_one('fleets', 'COUNT(DISTINCT owner_planet_id)', $szDWhere);
if (empty($_GET['special'])) {
echo '<br />&battlefield = $id = `' . $id . '`.<br />';
echo 'Attacking: ' . count($arrAttackingFleets) . ' fleets<br />';
echo 'Defending: ' . count($arrDefendingFleets) . ' fleets<br /><br />';
}
// ATTACKING FLEETS //
$arrATotalShips = $arrATotalShipsLost = $arrABlockedShips = $g_arrShips;
$arrRoidSnatchersPerFleet = array();
// Numbers: per fleet & total
foreach ($arrAttackingFleets as &$arrFleet) {
$arrAShipsInFleet[$arrFleet['id']] = db_select_fields('ships_in_fleets', 'ship_id,amount', 'fleet_id = ' . (int) $arrFleet['id'] . ' AND 0 < amount') + $g_arrShips;
foreach ($arrAShipsInFleet[$arrFleet['id']] as $iShip => $iAmount) {
$arrATotalShips[$iShip] += $iAmount;
if ($g_iRoidSnatcher === (int) $iShip) {
<th align="center" title="Primary Target (value is `Short`)">PT</th>
<th align="center" title="Secondary Target (value is `Short`)">T2</th>
<th align="center" style="border-right:solid 1px black;" title="Tertiary Target (value is `Short`)">T3</th>
<?php
foreach ($rs as $r) {
echo '<th align="right">' . $r['resource'] . '</th>' . "\n";
}
?>
<th align="right" style="border-right:solid 1px black;">ETA</th>
<th align="right">Fuel/tick</th>
<th align="right">Min. ETA</th>
</tr>
<?php
$c = array('#333333', '#222222');
$i = $t = 0;
$arrFighterUnits = db_select_by_field('d_all_units', 'id', 'T IN (\'ship\', \'defence\') ORDER BY T ASC, o ASC');
foreach ($arrFighterUnits as $iUnitId => &$arrUnit) {
$arrUnit['targets'] = array_values(db_select_fields('d_combat_stats', 'receiving_unit_id,receiving_unit_id', 'shooting_unit_id = ' . (int) $arrUnit['id'] . ' ORDER BY target_priority ASC LIMIT 3'));
$szType = 'defence' === $arrUnit['T'] ? 'DEF' : ($arrUnit['is_stealth'] ? 'STE' : (!$arrUnit['is_offensive'] ? 'NLF' : 'NOR'));
$szTypes = array('NOR' => 'Normal', 'NLF' => 'Non-lethal', 'STE' => 'Stealth', 'DEF' => 'Defensive');
echo '<tr' . (0 < $i && $t !== $arrUnit['T'] ? ' class="bt"' : '') . ' bgcolor="' . $c[$i++ % 2] . '">';
echo '<td align="right" width="10">' . $arrUnit['id'] . '</td>';
echo '<td align="right">' . $arrUnit['unit'] . '</td>';
echo '<td align="center">' . strtolower($arrUnit['unit_short']) . '</td>';
echo '<td align="center" title="' . $szTypes[$szType] . '">' . $szType . '</td>';
echo '<td align="center">' . (isset($arrUnit['targets'][0]) ? strtolower($arrFighterUnits[$arrUnit['targets'][0]]['unit_short']) : '-') . '</td>';
echo '<td align="center">' . (isset($arrUnit['targets'][1]) ? strtolower($arrFighterUnits[$arrUnit['targets'][1]]['unit_short']) : '-') . '</td>';
echo '<td align="center" style="border-right:solid 1px black;">' . (isset($arrUnit['targets'][2]) ? strtolower($arrFighterUnits[$arrUnit['targets'][2]]['unit_short']) : '-') . '</td>';
foreach (db_fetch('SELECT c.*, r.resource FROM d_resources r LEFT JOIN d_unit_costs c ON r.id = c.resource_id AND c.unit_id = ' . $arrUnit['id'] . ' WHERE 1 ORDER BY r.id ASC') as $costs) {
echo '<td align="right" title="' . $costs['resource'] . '">' . nummertje($costs['amount']) . '</td>';
}
$szInserts .= ",(" . $iRDId . "," . implode("),(" . $iRDId . ",", $arrRaces) . ")";
}
echo $szSqlQuery = 'INSERT INTO d_r_d_per_race (r_d_id, race_id) VALUES ' . substr($szInserts, 1) . ';' . "\n";
db_query($szSqlQuery) or die("\n\n" . db_error());
exit;
} else {
if (isset($_POST['name'], $_POST['T'], $_POST['eta'], $_POST['explanation'], $_POST['costs'])) {
var_dump(db_query("INSERT INTO d_r_d_available (`T`, `name`, `eta`, `explanation`) VALUES ('" . $_POST['T'] . "', '" . $_POST['name'] . "', '" . $_POST['eta'] . "', '" . $_POST['explanation'] . "')"));
$iRdId = db_insert_id();
foreach ($_POST['costs'] as $iResourceId => $iAmount) {
var_dump(db_query("INSERT INTO d_r_d_costs (r_d_id, resource_id, amount) VALUES (" . $iRdId . ", " . $iResourceId . ", " . $iAmount . ")"));
}
exit;
}
}
$RD = db_select_by_field('d_r_d_available', 'id');
?>
<style type="text/css">
select { font-size : 9px; } .rb { border-right : solid 4px black; }
</style>
<script type="text/javascript" src="http://localhost/js/mootools_1_11.js"></script>
<form method="post" action="" autocomplete="off">
<table width="100%" border="0" cellpadding="3" cellspacing="0"><tr bgcolor="#dddddd"><th onclick="showColumn('r');" class="rb">RESEARCHES</th><th onclick="showColumn('d');">DEVELOPMENTS</th></tr><tr valign="top"><td class="rb" align="center">
<?php
$arrRequires = db_select('d_r_d_requires');
$g_arrRequires = array();
foreach ($arrRequires as $rd) {
$g_arrRequires[$rd['r_d_id']][$rd['r_d_requires_id']] = true;
}
$arrExcludes = db_select('d_r_d_excludes');
$g_arrExcludes = array();
function logincheck($f_bAct = true)
{
global $sessionname, $g_arrUser, $g_arrResources;
if (defined('PLANET_ID')) {
return true;
}
if (!isset($_SESSION[$sessionname]['planet_id'], $_SESSION[$sessionname]['unihash']) || !count($arrUsers = db_select('d_races r, galaxies g, planets p', "g.id = p.galaxy_id AND r.id = p.race_id AND p.id = " . (int) $_SESSION[$sessionname]['planet_id'] . " AND p.unihash = '" . addslashes($_SESSION[$sessionname]['unihash']) . "' AND closed != '1' LIMIT 1"))) {
unset($_SESSION[$sessionname]);
if ($f_bAct) {
exit('<a href="./login.php">Invalid session!</a>');
}
return false;
}
$g_arrUser = $arrUsers[0];
if (!defined('PLANET_ID')) {
define('PLANET_ID', (int) $g_arrUser['id']);
}
$g_arrResources = db_select_by_field('d_resources r, planet_resources p', 'id', 'p.planet_id = ' . PLANET_ID . ' AND p.resource_id = r.id ORDER BY r.id ASC');
echo db_error();
db_update('planets', 'lastaction = ' . time(), 'id = ' . PLANET_ID);
return true;
}
