function db_kill_player($ship_id, $remove_planets = false)
{
global $default_prod_ore;
global $default_prod_organics;
global $default_prod_goods;
global $default_prod_energy;
global $default_prod_fighters;
global $default_prod_torp;
global $db, $l;
$resa = $db->Execute("UPDATE {$db->prefix}ships SET ship_destroyed='Y', on_planet='N', sector=0, cleared_defences=' ' WHERE ship_id=?", array($ship_id));
db_op_result($db, $resa, __LINE__, __FILE__);
$resb = $db->Execute("DELETE FROM {$db->prefix}bounty WHERE placed_by = ?", array($ship_id));
db_op_result($db, $resb, __LINE__, __FILE__);
$res = $db->Execute("SELECT DISTINCT sector_id FROM {$db->prefix}planets WHERE owner=? AND base='Y'", array($ship_id));
db_op_result($db, $res, __LINE__, __FILE__);
$i = 0;
while (!$res->EOF && $res) {
$sectors[$i] = $res->fields['sector_id'];
$i++;
$res->MoveNext();
}
if ($remove_planets == true && $ship_id > 0) {
$resc = $db->Execute("DELETE FROM {$db->prefix}planets WHERE owner = ?", array($ship_id));
db_op_result($db, $resc, __LINE__, __FILE__);
} else {
$resd = $db->Execute("UPDATE {$db->prefix}planets SET owner=0, corp=0, fighters=0, base='N' WHERE owner=?", array($ship_id));
db_op_result($db, $resd, __LINE__, __FILE__);
}
if (!empty($sectors)) {
foreach ($sectors as $sector) {
calc_ownership($sector);
}
}
$rese = $db->Execute("DELETE FROM {$db->prefix}sector_defence WHERE ship_id=?", array($ship_id));
db_op_result($db, $rese, __LINE__, __FILE__);
$res = $db->Execute("SELECT zone_id FROM {$db->prefix}zones WHERE corp_zone='N' AND owner=?", array($ship_id));
db_op_result($db, $res, __LINE__, __FILE__);
$zone = $res->fields;
$resf = $db->Execute("UPDATE {$db->prefix}universe SET zone_id=1 WHERE zone_id=?", array($zone['zone_id']));
db_op_result($db, $resf, __LINE__, __FILE__);
$query = $db->Execute("SELECT character_name FROM {$db->prefix}ships WHERE ship_id=?", array($ship_id));
db_op_result($db, $query, __LINE__, __FILE__);
$name = $query->fields;
$headline = $name['character_name'] . $l->get('l_killheadline');
$newstext = str_replace("[name]", $name['character_name'], $l->get('l_news_killed'));
$news = $db->Execute("INSERT INTO {$db->prefix}news (headline, newstext, user_id, date, news_type) VALUES (?,?,?,NOW(), 'killed')", array($headline, $newstext, $ship_id));
db_op_result($db, $news, __LINE__, __FILE__);
}
function xenobetoplanet($planet_id)
{
// Xenobe planet attack code
global $playerinfo, $planetinfo, $torp_dmg_rate, $level_factor;
global $rating_combat_factor, $upgrade_cost, $upgrade_factor, $sector_max, $xenobeisdead, $db;
$resh = $db->Execute("LOCK TABLES {$db->prefix}ships WRITE, {$db->prefix}universe WRITE, {$db->prefix}planets WRITE, {$db->prefix}news WRITE, {$db->prefix}logs WRITE");
db_op_result($db, $resh, __LINE__, __FILE__);
$resultp = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id=?", array($planet_id));
// Get target planet information
db_op_result($db, $resultp, __LINE__, __FILE__);
$planetinfo = $resultp->fields;
$resulto = $db->Execute("SELECT * FROM {$db->prefix}ships WHERE ship_id=?", array($planetinfo['owner']));
// Get target player information
db_op_result($db, $resulto, __LINE__, __FILE__);
$ownerinfo = $resulto->fields;
$base_factor = $planetinfo['base'] == 'Y' ? $basedefense : 0;
// Planet beams
$targetbeams = NUM_BEAMS($ownerinfo['beams'] + $base_factor);
if ($targetbeams > $planetinfo['energy']) {
$targetbeams = $planetinfo['energy'];
}
$planetinfo['energy'] -= $targetbeams;
// Planet shields
$targetshields = NUM_SHIELDS($ownerinfo['shields'] + $base_factor);
if ($targetshields > $planetinfo['energy']) {
$targetshields = $planetinfo['energy'];
}
$planetinfo['energy'] -= $targetshields;
// Planet torps
$torp_launchers = round(pow($level_factor, $ownerinfo['torp_launchers'] + $base_factor)) * 10;
$torps = $planetinfo['torps'];
$targettorps = $torp_launchers;
if ($torp_launchers > $torps) {
$targettorps = $torps;
}
$planetinfo['torps'] -= $targettorps;
$targettorpdmg = $torp_dmg_rate * $targettorps;
// Planet fighters
$targetfighters = $planetinfo['fighters'];
// Attacker beams
$attackerbeams = NUM_BEAMS($playerinfo['beams']);
if ($attackerbeams > $playerinfo['ship_energy']) {
$attackerbeams = $playerinfo['ship_energy'];
}
$playerinfo['ship_energy'] -= $attackerbeams;
// Attacker shields
$attackershields = NUM_SHIELDS($playerinfo['shields']);
if ($attackershields > $playerinfo['ship_energy']) {
$attackershields = $playerinfo['ship_energy'];
}
$playerinfo['ship_energy'] -= $attackershields;
// Attacker torps
$attackertorps = round(pow($level_factor, $playerinfo['torp_launchers'])) * 2;
if ($attackertorps > $playerinfo['torps']) {
$attackertorps = $playerinfo['torps'];
}
$playerinfo['torps'] -= $attackertorps;
$attackertorpdamage = $torp_dmg_rate * $attackertorps;
// Attacker fighters
$attackerfighters = $playerinfo['ship_fighters'];
// Attacker armor
$attackerarmor = $playerinfo['armor_pts'];
// Begin combat
if ($attackerbeams > 0 && $targetfighters > 0) {
if ($attackerbeams > $targetfighters) {
$lost = $targetfighters;
$targetfighters = 0;
// Target loses all fighters
$attackerbeams = $attackerbeams - $lost;
// Attacker loses beams equal to Target fighters
} else {
$targetfighters = $targetfighters - $attackerbeams;
// Target loses fighters equal to attacker beams
$attackerbeams = 0;
// Attacker loses all beams
}
}
if ($attackerfighters > 0 && $targetbeams > 0) {
if ($targetbeams > round($attackerfighters / 2)) {
$lost = $attackerfighters - round($attackerfighters / 2);
// Attacker loses half of all fighters
$attackerfighters = $attackerfighters - $lost;
$targetbeams = $targetbeams - $lost;
// Target loses beams equal to half of attackers fighters
} else {
// Target beams are less than half of attackers fighters
$attackerfighters = $attackerfighters - $targetbeams;
// Attacker loses fighters equal to target beams
$targetbeams = 0;
// Target loses all beams
}
}
if ($attackerbeams > 0) {
if ($attackerbeams > $targetshields) {
$attackerbeams = $attackerbeams - $targetshields;
// Attacker loses beams equal to target shields
$targetshields = 0;
// Target loses all shields
} else {
$targetshields = $targetshields - $attackerbeams;
// Target loses shields equal to attacker beams
$attackerbeams = 0;
// Attacker loses all beams
}
}
if ($targetbeams > 0) {
if ($targetbeams > $attackershields) {
$targetbeams = $targetbeams - $attackershields;
// Target loses beams equal to attacker shields
$attackershields = 0;
// Attacker loses all shields
} else {
$attackershields = $attackershields - $targetbeams;
// Attacker loses sheilds equal to target beams
$targetbeams = 0;
// Target loses all beams
}
}
if ($targetbeams > 0) {
if ($targetbeams > $attackerarmor) {
$targetbeams = $targetbeams - $attackerarmor;
// Target loses beams equal to attacker armor
$attackerarmor = 0;
// Attacker loses all armor (attacker destroyed)
} else {
$attackerarmor = $attackerarmor - $targetbeams;
// Attacker loses armor equal to target beams
$targetbeams = 0;
// Target loses all beams
}
}
if ($targetfighters > 0 && $attackertorpdamage > 0) {
if ($attackertorpdamage > $targetfighters) {
$lost = $targetfighters;
$targetfighters = 0;
// Target loses all fighters
$attackertorpdamage = $attackertorpdamage - $lost;
// Attacker loses fired torpedoes equal to target fighters
} else {
$targetfighters = $targetfighters - $attackertorpdamage;
// Target loses fighters equal to attacker torpedoes fired
$attackertorpdamage = 0;
// Attacker loses all torpedoes fired
}
}
if ($attackerfighters > 0 && $targettorpdmg > 0) {
if ($targettorpdmg > round($attackerfighters / 2)) {
$lost = $attackerfighters - round($attackerfighters / 2);
$attackerfighters = $attackerfighters - $lost;
// Attacker loses half of all fighters
$targettorpdmg = $targettorpdmg - $lost;
// Target loses fired torpedoes equal to half of attacker fighters
} else {
// Target fired torpedoes less than or equal to half of attacker fighters
$attackerfighters = $attackerfighters - $targettorpdmg;
// Attacker loses fighters equal to target torpedoes fired
$targettorpdmg = 0;
// Tartget loses all torpedoes fired
}
}
if ($targettorpdmg > 0) {
if ($targettorpdmg > $attackerarmor) {
$targettorpdmg = $targettorpdmg - $attackerarmor;
// Target loses fired torpedoes equal to attacker armor
$attackerarmor = 0;
// Attacker loses all armor (Attacker destroyed)
} else {
// Target fired torpedoes less than or equal to half attacker armor
$attackerarmor = $attackerarmor - $targettorpdmg;
// Attacker loses armor equal to the target torpedoes fired
$targettorpdmg = 0;
// Target loses all torpedoes fired
}
}
if ($attackerfighters > 0 && $targetfighters > 0) {
if ($attackerfighters > $targetfighters) {
$temptargfighters = 0;
// Target will lose all fighters
} else {
// Attackers fighters less than or equal to target fighters
$temptargfighters = $targetfighters - $attackerfighters;
// Target will loose fighters equal to attacker fighters
}
if ($targetfighters > $attackerfighters) {
// Target fighters greater than attackers fighters
$tempplayfighters = 0;
// Attackerwill loose ALL fighters
} else {
// Target fighters less than or equal to attackers fighters
$tempplayfighters = $attackerfighters - $targetfighters;
// Attacker will loose fighters equal to target fighters
}
$attackerfighters = $tempplayfighters;
$targetfighters = $temptargfighters;
}
if ($targetfighters > 0) {
if ($targetfighters > $attackerarmor) {
// Target fighters greater than attackers armor
$attackerarmor = 0;
// attacker loses all armor (attacker destroyed)
} else {
// Target fighters less than or equal to attackers armor
$attackerarmor = $attackerarmor - $targetfighters;
// attacker loses armor equal to target fighters
}
}
// Fix negative values
if ($attackerfighters < 0) {
$attackerfighters = 0;
}
if ($attackertorps < 0) {
$attackertorps = 0;
}
if ($attackershields < 0) {
$attackershields = 0;
}
if ($attackerbeams < 0) {
$attackerbeams = 0;
}
if ($attackerarmor < 0) {
$attackerarmor = 0;
}
if ($targetfighters < 0) {
$targetfighters = 0;
}
if ($targettorps < 0) {
$targettorps = 0;
}
if ($targetshields < 0) {
$targetshields = 0;
}
if ($targetbeams < 0) {
$targetbeams = 0;
}
if (!$attackerarmor > 0) {
playerlog($db, $playerinfo['ship_id'], LOG_RAW, "Ship destroyed by planetary defenses on planet {$planetinfo['name']}");
db_kill_player($playerinfo['ship_id']);
$xenobeisdead = 1;
$free_ore = round($playerinfo['ship_ore'] / 2);
$free_organics = round($playerinfo['ship_organics'] / 2);
$free_goods = round($playerinfo['ship_goods'] / 2);
$ship_value = $upgrade_cost * (round(pow($upgrade_factor, $playerinfo['hull'])) + round(pow($upgrade_factor, $playerinfo['engines'])) + round(pow($upgrade_factor, $playerinfo['power'])) + round(pow($upgrade_factor, $playerinfo['computer'])) + round(pow($upgrade_factor, $playerinfo['sensors'])) + round(pow($upgrade_factor, $playerinfo['beams'])) + round(pow($upgrade_factor, $playerinfo['torp_launchers'])) + round(pow($upgrade_factor, $playerinfo['shields'])) + round(pow($upgrade_factor, $playerinfo['armor'])) + round(pow($upgrade_factor, $playerinfo['cloak'])));
$ship_salvage_rate = mt_rand(10, 20);
$ship_salvage = $ship_value * $ship_salvage_rate / 100;
$fighters_lost = $planetinfo['fighters'] - $targetfighters;
// Log attack to planet owner
playerlog($db, $planetinfo['owner'], LOG_PLANET_NOT_DEFEATED, "{$planetinfo['name']}|{$playerinfo['sector']}|Xenobe {$playerinfo['character_name']}|{$free_ore}|{$free_organics}|{$free_goods}|{$ship_salvage_rate}|{$ship_salvage}");
// Update planet
$resi = $db->Execute("UPDATE {$db->prefix}planets SET energy=?, fighters=fighters-?, torps=torps-?, ore=ore+?, goods=goods+?, organics=organics+?, credits=credits+? WHERE planet_id=?", array($planetinfo['energy'], $fighters_lost, $targettorps, $free_ore, $free_goods, $free_organics, $ship_salvage, $planetinfo['planet_id']));
db_op_result($db, $resi, __LINE__, __FILE__);
} else {
$armor_lost = $playerinfo['armor_pts'] - $attackerarmor;
$fighters_lost = $playerinfo['ship_fighters'] - $attackerfighters;
$target_fighters_lost = $planetinfo['ship_fighters'] - $targetfighters;
playerlog($db, $playerinfo['ship_id'], LOG_RAW, "Made it past defenses on planet {$planetinfo['name']}");
// Update attackers
$resj = $db->Execute("UPDATE {$db->prefix}ships SET ship_energy=?, ship_fighters=ship_fighters-?, torps=torps-?, armor_pts=armor_pts-? WHERE ship_id=?", array($playerinfo['ship_energy'], $fighters_lost, $attackertorps, $armor_lost, $playerinfo['ship_id']));
db_op_result($db, $resj, __LINE__, __FILE__);
$playerinfo['ship_fighters'] = $attackerfighters;
$playerinfo['torps'] = $attackertorps;
$playerinfo['armor_pts'] = $attackerarmor;
// Update planet
$resk = $db->Execute("UPDATE {$db->prefix}planets SET energy=?, fighters=?, torps=torps-? WHERE planet_id=?", array($planetinfo['energy'], $targetfighters, $targettorps, $planetinfo['planet_id']));
db_op_result($db, $resk, __LINE__, __FILE__);
$planetinfo['fighters'] = $targetfighters;
$planetinfo['torps'] = $targettorps;
// Now we must attack all ships on the planet one by one
$resultps = $db->Execute("SELECT ship_id,ship_name FROM {$db->prefix}ships WHERE planet_id=? AND on_planet='Y'", array($planetinfo['planet_id']));
db_op_result($db, $resultps, __LINE__, __FILE__);
$shipsonplanet = $resultps->RecordCount();
if ($shipsonplanet > 0) {
while (!$resultps->EOF && $xenobeisdead < 1) {
$onplanet = $resultps->fields;
xenobetoship($onplanet['ship_id']);
$resultps->MoveNext();
}
}
$resultps = $db->Execute("SELECT ship_id,ship_name FROM {$db->prefix}ships WHERE planet_id=? AND on_planet='Y'", array($planetinfo['planet_id']));
db_op_result($db, $resultps, __LINE__, __FILE__);
$shipsonplanet = $resultps->RecordCount();
if ($shipsonplanet == 0 && $xenobeisdead < 1) {
// Must have killed all ships on the planet
playerlog($db, $playerinfo['ship_id'], LOG_RAW, "Defeated all ships on planet {$planetinfo['name']}");
// Log attack to planet owner
playerlog($db, $planetinfo['owner'], LOG_PLANET_DEFEATED, "{$planetinfo['name']}|{$playerinfo['sector']}|{$playerinfo['character_name']}");
// Update planet
$resl = $db->Execute("UPDATE {$db->prefix}planets SET fighters=0, torps=0, base='N', owner=0, corp=0 WHERE planet_id=?", array($planetinfo['planet_id']));
db_op_result($db, $resl, __LINE__, __FILE__);
calc_ownership($planetinfo['sector_id']);
} else {
// Must have died trying
playerlog($db, $playerinfo['ship_id'], LOG_RAW, "We were KILLED by ships defending planet {$planetinfo['name']}");
// Log attack to planet owner
playerlog($db, $planetinfo['owner'], LOG_PLANET_NOT_DEFEATED, "{$planetinfo['name']}|{$playerinfo['sector']}|Xenobe {$playerinfo['character_name']}|0|0|0|0|0");
// No salvage for planet because it went to the ship that won
}
}
$resx = $db->Execute("UNLOCK TABLES");
db_op_result($db, $resx, __LINE__, __FILE__);
}
<?php
bigtitle();
if ($action == "planetcorp") {
echo $l_corpm_tocorp . "<br>";
$result = $db->Execute("UPDATE {$db->prefix}planets SET corp='{$playerinfo['team']}', owner={$playerinfo['ship_id']} WHERE planet_id={$planet_id}");
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
$ownership = calc_ownership($playerinfo['sector']);
if (!empty($ownership)) {
echo "<p>{$ownership}<p>";
}
}
if ($action == "planetpersonal") {
echo $l_corpm_topersonal . "<br>";
$result = $db->Execute("UPDATE {$db->prefix}planets SET corp='0', owner={$playerinfo['ship_id']} WHERE planet_id={$planet_id}");
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
$ownership = calc_ownership($playerinfo['sector']);
// Kick other players off the planet
$result = $db->Execute("UPDATE {$db->prefix}ships SET on_planet='N' WHERE on_planet='Y' AND planet_id = {$planet_id} AND ship_id <> {$playerinfo['ship_id']}");
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
if (!empty($ownership)) {
echo "<p>" . $ownership . "<p>";
}
}
TEXT_GOTOMAIN();
?>
</div></div>
<?php
} else {
echo "<br>" . $l_corpm_exploit . "<br>";
TEXT_GOTOMAIN();
?>
function db_kill_player($player_id,$ship_id,$killer_id)
{
global $default_prod_ore;
global $default_prod_organics;
global $default_prod_goods;
global $default_prod_energy;
global $default_prod_fighters;
global $default_prod_torp;
global $gameroot;
global $db,$dbtables;
global $l_killheadline,$l_news_killed;
global $ibank_interest, $ibank_loaninterest;
global $ore_price;
global $organics_price;
global $goods_price;
global $energy_price;
global $upgrade_cost;
global $upgrade_factor;
global $dev_genesis_price;
global $dev_beacon_price;
global $dev_emerwarp_price;
global $dev_warpedit_price;
global $dev_minedeflector_price;
global $dev_escapepod_price;
global $dev_fuelscoop_price;
global $dev_lssd_price;
global $fighter_price;
global $torpedo_price;
global $armour_price;
global $colonist_price;
global $base_credits;
global $base_ore;
global $base_goods;
global $base_organics;
global $sector_max;
$db->Execute("UPDATE $dbtables[players] SET sector=0, on_planet='N' WHERE player_id=$player_id");
$res = $db->Execute("SELECT * FROM $dbtables[ships] WHERE ship_id=$ship_id");
$shipinfo = $res->fields;
if ($shipinfo[tow] > 0) {
if ($killer_id==-2) {
$sector = rand(1,$sector_max);
$db->Execute("UPDATE $dbtables[ships] SET player_id=0,on_planet='N',sector=$sector WHERE ship_id=$shipinfo[tow]");
} else {
$db->Execute("UPDATE $dbtables[ships] SET player_id=0,on_planet='N',sector=$shipinfo[sector] WHERE ship_id=$shipinfo[tow]");
}
}
$db->Execute("UPDATE $dbtables[ships] SET type=1, hull=0, engines=0, power=0, computer=0,sensors=0, beams=0, torp_launchers=0, torps=0, armour=0, armour_pts='$start_armour', cloak=0, shields=0, sector=0, ship_ore=0, ship_organics=0, ship_energy='$start_energy', ship_colonists=0, ship_goods=0, ship_fighters='$start_fighters', tow=0, on_planet='N', dev_warpedit=0, dev_genesis=0, dev_beacon=0, dev_emerwarp=0, dev_escapepod='N', dev_fuelscoop='N', dev_minedeflector=0, ship_destroyed='Y',dev_lssd='N',cleared_defences=' ',fur_tech='N' where ship_id=$ship_id AND player_id=$player_id");
$db->Execute("DELETE from $dbtables[bounty] WHERE placed_by = $player_id");
// Now the IGB gets to recover their loan if there is one
if ($killer_id != -1) {
$db->Execute("UPDATE $dbtables[ibank_accounts] SET loantime=0 WHERE player_id=$player_id");
if ($killer_id != -2) {
$playerDeath = true;
} else {
// Suicide
$db->Execute("UPDATE $dbtables[players] SET turns=turns-1500, turns_used=turns_used+1500 WHERE player_id=$player_id");
}
include("sched_IGB.php");
$playerDeath=false;
}
$res = $db->Execute("SELECT DISTINCT sector_id FROM $dbtables[planets] WHERE owner='$player_id' AND base='Y'");
$i=0;
while(!$res->EOF && $res)
{
$sectors[$i] = $res->fields[sector_id];
$i++;
$res->MoveNext();
}
$db->Execute("UPDATE $dbtables[planets] SET owner=0,fighters=0, base='N' WHERE owner=$player_id");
if(!empty($sectors))
{
foreach($sectors as $sector)
{
calc_ownership($sector);
}
}
$db->Execute("DELETE FROM $dbtables[sector_defence] where player_id=$player_id");
$res = $db->Execute("SELECT zone_id FROM $dbtables[zones] WHERE corp_zone='N' AND owner=$player_id");
$zone = $res->fields;
$db->Execute("UPDATE $dbtables[universe] SET zone_id=1 WHERE zone_id=$zone[zone_id]");
$query = $db->Execute("select character_name,email from $dbtables[players] where player_id='$player_id'");
$name = $query->fields;
// Update the killers stats
// Do we have an entry for this player already?
$res=$db->Execute("SELECT * FROM $dbtables[kills] WHERE player_id=$killer_id");
if ($res->EOF) {
$res=$db->Execute("INSERT INTO $dbtables[kills] SET player_id=$killer_id");
}
$res=$db->Execute("SELECT * FROM $dbtables[kills] WHERE player_id=$playerinf[player_id]");
if ($res->EOF) {
$res=$db->Execute("INSERT INTO $dbtables[kills] SET player_id=$playerinf[player_id]");
}
// Find out if furangee
if (strstr($name[email],"furangee")) {
$db->Execute("UPDATE $dbtables[kills] SET fks=fks+1 WHERE player_id=$killer_id");
} else {
// Player killed
$db->Execute("UPDATE $dbtables[kills] SET pks=pks+1 WHERE player_id=$killer_id");
}
// Update killed stats
$db->Execute("UPDATE $dbtables[kills] SET deaths=deaths+1 WHERE player_id=$player_id");
$headline = $name[character_name] . $l_killheadline;
$newstext=str_replace("[name]",$name[character_name],$l_news_killed);
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$newstext','$player_id',NOW(), 'killed')");
// Clear bank BUG!!!
$db->Execute("UPDATE $dbtables[ibank_accounts] SET balance='0' WHERE player_id=$player_id") ;
// Final clean up
$db->Execute("UPDATE $dbtables[players] SET credits=0 WHERE player_id=$player_id");
}
db_op_result($db, $resy, __LINE__, __FILE__, $db_logging);
$resz = $db->Execute("UPDATE {$db->prefix}teams SET number_of_members = number_of_members - 1, creator=? WHERE id=?;", array($newcreator, $whichteam));
db_op_result($db, $resz, __LINE__, __FILE__, $db_logging);
$res = $db->Execute("SELECT DISTINCT sector_id FROM {$db->prefix}planets WHERE owner=? AND base='Y' AND corp!=0;", array($playerinfo['ship_id']));
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$i = 0;
while (!$res->EOF) {
$sectors[$i] = $res->fields['sector_id'];
$i++;
$res->MoveNext();
}
$resx = $db->Execute("UPDATE {$db->prefix}planets SET corp=0 WHERE owner=?;", array($playerinfo['ship_id']));
db_op_result($db, $resx, __LINE__, __FILE__, $db_logging);
if (!empty($sectors)) {
foreach ($sectors as $sector) {
calc_ownership($sector);
}
}
playerlog($db, $playerinfo['ship_id'], LOG_TEAM_NEWLEAD, $team['team_name'] . "|" . $newcreatorname['character_name']);
playerlog($db, $newcreator, LOG_TEAM_LEAD, $team['team_name']);
}
LINK_BACK();
break;
case 3:
if ($playerinfo['team'] != 0) {
echo $l_team_leavefirst . "<br>";
} else {
if ($playerinfo['team_invite'] == $whichteam) {
$resx = $db->Execute("UPDATE {$db->prefix}ships SET team=?, team_invite=0 WHERE ship_id=?;", array($whichteam, $playerinfo['ship_id']));
db_op_result($db, $resx, __LINE__, __FILE__, $db_logging);
$resy = $db->Execute("UPDATE {$db->prefix}teams SET number_of_members=number_of_members+1 WHERE id=?;", array($whichteam));
function planetcombat()
{
global $upgrade_cost, $upgrade_factor;
global $playerinfo;
global $shipinfo;
global $ownerinfo;
global $ownershipinfo;
global $sectorinfo;
global $planetinfo;
global $torpedo_price;
global $colonist_price;
global $ore_price;
global $organics_price;
global $goods_price;
global $energy_price;
global $ibank_paymentfee;
global $planetbeams;
global $planetfighters;
global $planetshields;
global $planettorps;
global $attackerbeams;
global $attackerfighters;
global $attackershields;
global $attackertorps;
global $attackerarmor;
global $torp_dmg_rate;
global $level_factor;
global $attackertorpdamage;
global $start_energy;
global $min_value_capture;
global $l_cmb_atleastoneturn;
global $l_cmb_atleastoneturn, $l_cmb_shipenergybb, $l_cmb_shipenergyab, $l_cmb_shipenergyas, $l_cmb_shiptorpsbtl, $l_cmb_shiptorpsatl;
global $l_cmb_planettorpdamage, $l_cmb_attackertorpdamage, $l_cmb_beams, $l_cmb_fighters, $l_cmb_shields, $l_cmb_torps;
global $l_cmb_torpdamage, $l_cmb_armor, $l_cmb_you, $l_cmb_planet, $l_cmb_combatflow, $l_cmb_defender, $l_cmb_attackingplanet;
global $l_cmb_youfireyourbeams, $l_cmb_defenselost, $l_cmb_defenselost2, $l_cmb_planetarybeams, $l_cmb_planetarybeams;
global $l_cmb_youdestroyedplanetshields, $l_cmb_beamsexhausted, $l_cmb_breachedyourshields, $l_cmb_destroyedyourshields;
global $l_cmb_breachedyourarmor, $l_cmb_destroyedyourarmor, $l_cmb_torpedoexchangephase, $l_cmb_nofightersleft;
global $l_cmb_youdestroyfighters, $l_cmb_planettorpsdestroy, $l_cmb_planettorpsdestroy2, $l_cmb_torpsbreachedyourarmor;
global $l_cmb_planettorpsdestroy3, $l_cmb_youdestroyedallfighters, $l_cmb_youdestroyplanetfighters, $l_cmb_fightercombatphase;
global $l_cmb_youdestroyedallfighters2, $l_cmb_youdestroyplanetfighters2, $l_cmb_allyourfightersdestroyed, $l_cmb_fightertofighterlost;
global $l_cmb_youbreachedplanetshields, $l_cmb_shieldsremainup, $l_cmb_fighterswarm, $l_cmb_swarmandrepel, $l_cmb_engshiptoshipcombat;
global $l_cmb_shipdock, $l_cmb_approachattackvector, $l_cmb_noshipsdocked, $l_cmb_yourshipdestroyed, $l_cmb_escapepod;
global $l_cmb_finalcombatstats, $l_cmb_youlostfighters, $l_cmb_youlostarmorpoints, $l_cmb_energyused, $l_cmb_planetdefeated;
global $l_cmb_citizenswanttodie, $l_cmb_youmaycapture, $l_cmb_youmaycapture2, $l_cmb_planetnotdefeated, $l_cmb_planetstatistics;
global $l_cmb_fighterloststat, $l_cmb_energyleft;
global $db, $dbtables;
//$debug = true;
if($playerinfo[turns] < 1)
{
echo "$l_cmb_atleastoneturn<BR><BR>";
TEXT_GOTOMAIN();
include("footer.php");
die();
}
// Planetary defense system calculation
$planetbeams = calcplanetbeams();
$planetfighters = calcplanetfighters();
$planetshields = calcplanetshields();
$planettorps = calcplanettorps();
// Attacking ship calculations
$attackerbeams = NUM_BEAMS($shipinfo[beams]);
$attackerfighters = $shipinfo[ship_fighters];
$attackershields = NUM_SHIELDS($shipinfo[shields]);
$attackertorps = round(mypw($level_factor, $shipinfo[torp_launchers])) * 2;
$attackerarmor = $shipinfo[armour_pts];
// Now modify player beams, shields and torpedos on available materiel
$starting_energy = $shipinfo[ship_energy];
// Beams
if ($debug)
echo "$l_cmb_shipenergybb: $shipinfo[ship_energy]<BR>\n";
if ($attackerbeams > $shipinfo[ship_energy])
$attackerbeams = $shipinfo[ship_energy];
$shipinfo[ship_energy] = $shipinfo[ship_energy] - $attackerbeams;
if ($debug)
echo "$l_cmb_shipenergyab (before shields): $shipinfo[ship_energy]<BR>\n";
// Shields
if ($attackershields > $shipinfo[ship_energy])
$attackershields = $shipinfo[ship_energy];
$shipinfo[ship_energy] = $shipinfo[ship_energy] - $attackershields;
if ($debug)
echo "$l_cmb_shipenergyas: $shipinfo[ship_energy]<BR>\n";
// Torpedos
if ($debug)
echo "$l_cmb_shiptorpsbtl: $attackertorps ($shipinfo[torps] / $shipinfo[torp_launchers])<BR>\n";
if ($attackertorps > $shipinfo[torps])
$attackertorps = $shipinfo[torps];
$shipinfo[torps] = $shipinfo[torps] - $attackertorps;
if ($debug)
echo "$l_cmb_shiptorpsatl: $attackertorps ($shipinfo[torps] / $shipinfo[torp_launchers])<BR>\n";
// Setup torp damage rate for both Planet and Ship
$planettorpdamage = $torp_dmg_rate * $planettorps;
$attackertorpdamage = $torp_dmg_rate * $attackertorps;
if ($debug)
echo "$l_cmb_planettorpdamage: $planettorpdamage<BR>\n";
if ($debug)
echo "$l_cmb_attackertorpdamage: $attackertorpdamage<BR>\n";
echo "
<CENTER>
<HR>
<table width='75%' border='0'>
<tr ALIGN='CENTER'>
<td width='9%' height='27'></td>
<td width='12%' height='27'><FONT COLOR='WHITE'>$l_cmb_beams</FONT></td>
<td width='17%' height='27'><FONT COLOR='WHITE'>$l_cmb_fighters</FONT></td>
<td width='18%' height='27'><FONT COLOR='WHITE'>$l_cmb_shields</FONT></td>
<td width='11%' height='27'><FONT COLOR='WHITE'>$l_cmb_torps</FONT></td>
<td width='22%' height='27'><FONT COLOR='WHITE'>$l_cmb_torpdamage</FONT></td>
<td width='11%' height='27'><FONT COLOR='WHITE'>$l_cmb_armor</FONT></td>
</tr>
<tr ALIGN='CENTER'>
<td width='9%'> <FONT COLOR='RED'>$l_cmb_you</td>
<td width='12%'><FONT COLOR='RED'><B>$attackerbeams</B></FONT></td>
<td width='17%'><FONT COLOR='RED'><B>$attackerfighters</B></FONT></td>
<td width='18%'><FONT COLOR='RED'><B>$attackershields</B></FONT></td>
<td width='11%'><FONT COLOR='RED'><B>$attackertorps</B></FONT></td>
<td width='22%'><FONT COLOR='RED'><B>$attackertorpdamage</B></FONT></td>
<td width='11%'><FONT COLOR='RED'><B>$attackerarmor</B></FONT></td>
</tr>
<tr ALIGN='CENTER'>
<td width='9%'> <FONT COLOR='#6098F8'>$l_cmb_planet</FONT></td>
<td width='12%'><FONT COLOR='#6098F8'><B>$planetbeams</B></FONT></td>
<td width='17%'><FONT COLOR='#6098F8'><B>$planetfighters</B></FONT></td>
<td width='18%'><FONT COLOR='#6098F8'><B>$planetshields</B></FONT></td>
<td width='11%'><FONT COLOR='#6098F8'><B>$planettorps</B></FONT></td>
<td width='22%'><FONT COLOR='#6098F8'><B>$planettorpdamage</B></FONT></td>
<td width='11%'><FONT COLOR='#6098F8'><B>N/A</B></FONT></td>
</tr>
</table>
<HR>
</CENTER>
";
// Begin actual combat calculations
$planetdestroyed = 0;
$attackerdestroyed = 0;
echo "<BR><CENTER><B><FONT SIZE='+2'>$l_cmb_combatflow</FONT></B><BR><BR>\n";
echo "<table width='75%' border='0'><tr align='center'><td><FONT COLOR='RED'>$l_cmb_you</FONT></td><td><FONT COLOR='#6098F8'>$l_cmb_defender</FONT></td>\n";
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_attackingplanet $playerinfo[sector]</b></FONT></td><td></td>";
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youfireyourbeams</b></FONT></td><td></td>\n";
if($planetfighters > 0 && $attackerbeams > 0)
{
if($attackerbeams > $planetfighters)
{
$l_cmb_defenselost = str_replace("[cmb_planetfighters]", $planetfighters, $l_cmb_defenselost);
echo "<tr align='center'><td></td><td><FONT COLOR='#6098F8'><B>$l_cmb_defenselost</B></FONT>";
$planetfighters = 0;
$attackerbeams = $attackerbeams - $planetfighters;
}
else
{
$l_cmb_defenselost2 = str_replace("[cmb_attackerbeams]", $attackerbeams, $l_cmb_defenselost2);
$planetfighters = $planetfighters - $attackerbeams;
echo "<tr align='center'><td></td><td><FONT COLOR='#6098F8'><B>$l_cmb_defenselost2</B></FONT>";
$attackerbeams = 0;
}
}
if($attackerfighters > 0 && $planetbeams > 0)
{
// If there are more beams on the planet than attacker has fighters
if($planetbeams > round($attackerfighters / 2))
{
// Half the attacker fighters
$temp = round($attackerfighters / 2);
// Attacker loses half his fighters
$lost = $attackerfighters - $temp;
// Set attacker fighters to 1/2 it's original value
$attackerfighters = $temp;
// Subtract half the attacker fighters from available planetary beams
$planetbeams = $planetbeams - $lost;
$l_cmb_planetarybeams = str_replace("[cmb_temp]", $temp, $l_cmb_planetarybeams);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_planetarybeams</B></FONT><TD></TD>";
}
else
{
$l_cmb_planetarybeams2 = str_replace("[cmb_planetbeams]", $planetbeams, $l_cmb_planetarybeams2);
$attackerfighters = $attackerfighters - $planetbeams;
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_planetarybeams2</B></FONT><TD></TD>";
$planetbeams = 0;
}
}
if($attackerbeams > 0)
{
if($attackerbeams > $planetshields)
{
$attackerbeams = $attackerbeams - $planetshields;
$planetshields = 0;
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youdestroyedplanetshields</FONT></B><td></td>";
}
else
{
$l_cmb_beamsexhausted = str_replace("[cmb_attackerbeams]", $attackerbeams, $l_cmb_beamsexhausted);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_beamsexhausted</FONT></B><td></td>";
$planetshields = $planetshields - $attackerbeams;
$attackerbeams = 0;
}
}
if($planetbeams > 0)
{
if($planetbeams > $attackershields)
{
$planetbeams = $planetbeams - $attackershields;
$attackershields = 0;
echo "<tr align='center'><td></td><td><FONT COLOR='#6098F8'><B>$l_cmb_breachedyourshields</FONT></B></td>";
}
else
{
$attackershields = $attackershields - $planetbeams;
$l_cmb_destroyedyourshields = str_replace("[cmb_planetbeams]", $planetbeams, $l_cmb_destroyedyourshields);
echo "<tr align='center'><td></td><FONT COLOR='#6098F8'><B>$l_cmb_destroyedyourshields</FONT></B></td>";
$planetbeams = 0;
}
}
if($planetbeams > 0)
{
if($planetbeams > $attackerarmor)
{
$attackerarmor = 0;
echo "<tr align='center'><td></td><td><FONT COLOR='#6098F8'><B>$l_cmb_breachedyourarmor</B></FONT></td>";
}
else
{
$attackerarmor = $attackerarmor - $planetbeams;
$l_cmb_destroyedyourarmor = str_replace("[cmb_planetbeams]", $planetbeams, $l_cmb_destroyedyourarmor);
echo "<tr align='center'><td></td><td><FONT COLOR='#6098F8'><B>$l_destroyedyourarmor</FONT></B></td>";
}
}
echo "<tr align='center'><td><FONT COLOR='YELLOW'><B>$l_cmb_torpedoexchangephase</b></FONT></td><td><b><FONT COLOr='YELLOW'>$l_cmb_torpedoexchangephase</b></FONT></td><BR>";
if($planetfighters > 0 && $attackertorpdamage > 0)
{
if($attackertorpdamage > $planetfighters)
{
$l_cmb_nofightersleft = str_replace("[cmb_planetfighters]", $planetfighters, $l_cmb_nofightersleft);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_nofightersleft</FONT></B></td><td></td>";
$planetfighters = 0;
$attackertorpdamage = $attackertorpdamage - $planetfighters;
}
else
{
$planetfighters = $planetfighters - $attackertorpdamage;
$l_cmb_youdestroyfighters = str_replace("[cmb_attackertorpdamage]", $attackertorpdamage, $l_cmb_youdestroyfighters);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youdestroyfighters</FONT></B></td><td></td>";
$attackertorpdamage = 0;
}
}
if($attackerfighters > 0 && $planettorpdamage > 0)
{
if($planettorpdamage > round($attackerfighters / 2))
{
$temp = round($attackerfighters / 2);
$lost = $attackerfighters - $temp;
$attackerfighters = $temp;
$planettorpdamage = $planettorpdamage - $lost;
$l_cmb_planettorpsdestroy = str_replace("[cmb_temp]", $temp, $l_cmb_planettorpsdestroy);
echo "<tr align='center'><td></td><td><FONT COLOR='RED'><B>$l_cmb_planettorpsdestroy</B></FONT></td>";
}
else
{
$attackerfighters = $attackerfighters - $planettorpdamage;
$l_cmb_planettorpsdestroy2 = str_replace("[cmb_planettorpdamage]", $planettorpdamage, $l_cmb_planettorpsdestroy2);
echo "<tr align='center'><td></td><td><FONT COLOR='RED'><B>$l_cmb_planettorpsdestroy2</B></FONT></td>";
$planettorpdamage = 0;
}
}
if($planettorpdamage > 0)
{
if($planettorpdamage > $attackerarmor)
{
$attackerarmor = 0;
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_torpsbreachedyourarmor</B></FONT></td><td></td>";
}
else
{
$attackerarmor = $attackerarmor - $planettorpdamage;
$l_cmb_planettorpsdestroy3 = str_replace("[cmb_planettorpdamage]", $planettorpdamage, $l_cmb_planettorpsdestroy3);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_planettorpsdestroy3</B></FONT></td><td></td>";
}
}
if($attackertorpdamage > 0 && $planetfighters > 0)
{
$planetfighters = $planetfighters - $attackertorpdamage;
if ($planetfighters < 0)
{
$planetfighters = 0;
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youdestroyedallfighters</B></FONT></td><td></td>";
}
else
{
$l_cmb_youdestroyplanetfighters = str_replace("[cmb_attackertorpdamage]", $attackertorpdamage, $l_cmb_youdestroyplanetfighters);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youdestroyplanetfighters</B></FONT></td><td></td>";
}
}
echo "<tr align='center'><td><FONT COLOR='YELLOW'><B>$l_cmb_fightercombatphase</b></FONT></td><td><b><FONT COLOr='YELLOW'>$l_cmb_fightercombatphase</b></FONT></td><BR>";
if($attackerfighters > 0 && $planetfighters > 0)
{
if($attackerfighters > $planetfighters)
{
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youdestroyedallfighters2</B></FONT></td><td></td>";
$tempplanetfighters = 0;
}
else
{
$l_cmb_youdestroyplanetfighters2 = str_replace("[cmb_attackerfighters]", $attackerfighters, $l_cmb_youdestroyplanetfighters2);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youdestroyplanetfighters2</B></FONT></td><td></td>";
$tempplanetfighters = $planetfighters - $attackerfighters;
}
if($planetfighters > $attackerfighters)
{
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_allyourfightersdestroyed</B></FONT></td><td></td>";
$tempplayfighters = 0;
}
else
{
$tempplayfighters = $attackerfighters - $planetfighters;
$l_cmb_fightertofighterlost = str_replace("[cmb_planetfighters]", $planetfighters, $l_cmb_fightertofighterlost);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_fightertofighterlost</B></FONT></td><td></td>";
}
$attackerfighters = $tempplayfighters;
$planetfighters = $tempplanetfighters;
}
if($attackerfighters > 0 && $planetshields > 0)
{
if($attackerfighters > $planetshields)
{
$attackerfighters = $attackerfighters - round($planetshields / 2);
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_youbreachedplanetshields</B></FONT></td><td></td>";
$planetshields = 0;
}
else
{
$l_cmb_shieldsremainup = str_replace("[cmb_attackerfighters]", $attackerfighters, $l_cmb_shieldsremainup);
echo "<tr align='center'><td></td><FONT COLOR='#6098F8'><B>$l_cmb_shieldsremainup</B></FONT></td>";
$planetshields = $planetshields - $attackerfighters;
}
}
if($planetfighters > 0)
{
if($planetfighters > $attackerarmor)
{
$attackerarmor = 0;
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_fighterswarm</B></FONT></td><td></td>";
}
else
{
$attackerarmor = $attackerarmor - $planetfighters;
echo "<tr align='center'><td><FONT COLOR='RED'><B>$l_cmb_swarmandrepel</B></FONT></td><td></td>";
}
}
echo "</TABLE></CENTER>\n";
// Send each docked ship in sequence to attack agressor
$result4 = $db->Execute("SELECT * FROM $dbtables[players] WHERE planet_id=$planetinfo[planet_id] AND on_planet='Y'");
$playersonplanet = $result4->RecordCount();
if ($playersonplanet > 0)
{
$l_cmb_shipdock = str_replace("[cmb_shipsonplanet]", $shipsonplanet, $l_cmb_shipdock);
echo "<BR><BR><CENTER>$l_cmb_shipdock<BR>$l_cmb_engshiptoshipcombat</CENTER><BR><BR>\n";
while (!$result4->EOF)
{
$onplanet = $result4->fields;
//$shipinfo[ship_fighters] = $attackerfighters;
//$shipinfo[armour_pts] = $attackerarmor;
//$shipinfo[torps] = $shipinfo[torps] - $attackertorps;
if ($attackerfighters < 0)
$attackerfighters = 0;
if ($attackertorps < 0)
$attackertorps = 0;
if ($attackershields < 0)
$attackershields = 0;
if ($attackerbeams < 0)
$attackerbeams = 0;
if ($attackerarmor < 1)
break;
echo "<BR>-$onplanet[character_name] $l_cmb_approachattackvector-<BR>";
shiptoship($onplanet[currentship]);
$result4->MoveNext();
}
}
else
echo "<BR><BR><CENTER>$l_cmb_noshipsdocked</CENTER><BR><BR>\n";
if($attackerarmor < 1)
{
// Planet attacked and attacked blew up
$free_ore = round($shipinfo[ship_ore]/2);
$free_organics = round($shipinfo[ship_organics]/2);
$free_goods = round($shipinfo[ship_goods]/2);
$ship_value=$upgrade_cost*(round(mypw($upgrade_factor, $shipinfo[hull]))+round(mypw($upgrade_factor, $shipinfo[engines]))+round(mypw($upgrade_factor, $shipinfo[power]))+round(mypw($upgrade_factor, $shipinfo[computer]))+round(mypw($upgrade_factor, $shipinfo[sensors]))+round(mypw($upgrade_factor, $shipinfo[beams]))+round(mypw($upgrade_factor, $shipinfo[torp_launchers]))+round(mypw($upgrade_factor, $shipinfo[shields]))+round(mypw($upgrade_factor, $shipinfo[armor]))+round(mypw($upgrade_factor, $shipinfo[cloak])));
$ship_salvage_rate=rand(0,10);
$ship_salvage=$ship_value*$ship_salvage_rate/100;
// Triple salvage if this is an outlaw
$result3 = $db->Execute ("SELECT amount FROM $dbtables[bounty] WHERE placed_by=0 AND bounty_on=$playerinfo[player_id]");
$fugitive="";
if (!$result3->EOF) {
echo "Triple hull salvage goes to $ownerinfo[character_name] because you were a fugitive!<br>";
$ship_salvage *=3;
$fugitive = "Fugitive from justice ";
}
echo "<BR><CENTER><FONT SIZE='+2' COLOR='RED'><B>$l_cmb_yourshipdestroyed</FONT></B></CENTER><BR>";
// news
$headline="Planet Attacked!";
$newstext=$fugitive.$playerinfo[character_name]." in the ship ".$shipinfo[ship_name]." led an attack today against ".$ownerinfo[character_name]."'s planet ".$planetinfo[name]." but was brought down by heavy planetary defenses. ";
if ($playerinfo[score] < $ownerinfo[score]) {
$newstext = $newstext . $playerinfo[character_name]." knew it would be an uphill battle and it was. Too bad.";
} else {
$newstext = $newstext . $playerinfo[character_name]." thought it would be an easy battle but underestimated the planet defenses. Next time look before you leap.";
}
if ($fugitive != "") {
$newstext .= " $ownerinfo[character_name] collected triple salvage from the outlaw's ship wreckage!";
}
$newstext = addslashes($newstext);
$player_id = $playerinfo[player_id];
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$newstext','$player_id',NOW(), 'attack')");
if($shipinfo[dev_escapepod] == "Y")
{
echo "<CENTER><FONT COLOR='WHITE'>$l_cmb_escapepod</FONT></CENTER><BR><BR>";
$db->Execute("UPDATE $dbtables[players] SET on_planet='N',sector=0 WHERE player_id=$playerinfo[player_id]");
// Immediately release any ships being towed
if ($shipinfo[tow] > 0) {
$db->Execute("UPDATE $dbtables[ships] SET player_id=0,on_planet='N',sector=$shipinfo[sector] WHERE ship_id=$shipinfo[tow]");
}
$db->Execute("UPDATE $dbtables[ships] SET ship_destroyed ='Y', sector=0, tow=0 WHERE player_id=$playerinfo[player_id] AND ship_id=$playerinfo[currentship]");
collect_bounty($planetinfo[owner],$playerinfo[player_id]);
}
else
{
db_kill_player($playerinfo[player_id],$playerinfo[currentship],$planetinfo[owner]);
collect_bounty($planetinfo[owner],$playerinfo[player_id]);
}
}
else
{
// ********************* Attacker survived ****************************
$free_ore=0;
$free_goods=0;
$free_organics=0;
$ship_salvage_rate=0;
$ship_salvage=0;
$planetrating = $ownershipinfo[hull] + $ownershipinfo[engines] + $ownershipinfo[computer] + $ownershipinfo[beams] + $ownershipinfo[torp_launchers] + $ownershipinfo[shields] + $ownershipinfo[armor];
if($ownerinfo[rating]!=0)
{
$rating_change=($ownerinfo[rating]/abs($ownerinfo[rating]))*$planetrating*10;
}
else
{
$rating_change=-100;
}
echo "<CENTER><BR><B><FONT SIZE='+2'>$l_cmb_finalcombatstats</FONT></B><BR><BR>";
$fighters_lost = $shipinfo[ship_fighters] - $attackerfighters;
$l_cmb_youlostfighters = str_replace("[cmb_fighters_lost]", $fighters_lost, $l_cmb_youlostfighters);
$l_cmb_youlostfighters = str_replace("[cmb_playerinfo_ship_fighters]", $shipinfo[ship_fighters], $l_cmb_youlostfighters);
echo "$l_cmb_youlostfighters<BR>";
$armor_lost = $shipinfo[armour_pts] - $attackerarmor;
$l_cmb_youlostarmorpoints = str_replace("[cmb_armor_lost]", $armor_lost, $l_cmb_youlostarmorpoints);
$l_cmb_youlostarmorpoints = str_replace("[cmb_playerinfo_armour_pts]", $shipinfo[armour_pts], $l_cmb_youlostarmorpoints);
$l_cmb_youlostarmorpoints = str_replace("[cmb_attackerarmor]", $attackerarmor, $l_cmb_youlostarmorpoints);
echo "$l_cmb_youlostarmorpoints<BR>";
$energy=$shipinfo[ship_energy];
$energy_lost = $starting_energy - $shipinfo[ship_energy];
$l_cmb_energyused = str_replace("[cmb_energy_lost]", $energy_lost, $l_cmb_energyused);
$l_cmb_energyused = str_replace("[cmb_playerinfo_ship_energy]", $starting_energy, $l_cmb_energyused);
echo "$l_cmb_energyused<BR></CENTER>";
$db->Execute("UPDATE $dbtables[players] SET rating=rating-$rating_change WHERE player_id=$playerinfo[player_id]");
$db->Execute("UPDATE $dbtables[ships] SET ship_energy=$energy,ship_fighters=ship_fighters-$fighters_lost, torps=torps-$attackertorps,armour_pts=armour_pts-$armor_lost WHERE player_id=$playerinfo[player_id] AND ship_id=$playerinfo[currentship]");
}
$result4 = $db->Execute("SELECT * FROM $dbtables[players] WHERE planet_id=$planetinfo[planet_id] AND on_planet='Y'");
$shipsonplanet = $result4->RecordCount();
if($planetshields < 1 && $planetfighters < 1 && $attackerarmor > 0 && $shipsonplanet == 0)
{
// ************************ Planet defeated ***********************************
echo "<BR><BR><CENTER><FONT COLOR='GREEN'><B>$l_cmb_planetdefeated</b></FONT></CENTER><BR><BR>";
// news
$headline="Planetary Defeat!";
$newstext=$playerinfo[character_name]." in the ship ".$shipinfo[ship_name]." defeated ".$ownerinfo[character_name]."s planet ".$planetinfo[name].". ";
if ($playerinfo[score] < $ownerinfo[score]) {
$newstext = $newstext . $playerinfo[character_name]." knew it would be a difficult battle but succeeded!";
} else {
$newstext = $newstext . $playerinfo[character_name]." crushed the weak.";
}
$player_id = $playerinfo[player_id];
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$newstext','$player_id',NOW(), 'attack')");
if($min_value_capture != 0)
{
$playerscore = gen_score($playerinfo[player_id]);
$playerscore *= $playerscore;
$planetscore = $planetinfo[organics] * $organics_price + $planetinfo[ore] * $ore_price + $planetinfo[goods] * $goods_price + $planetinfo[energy] * $energy_price + $planetinfo[fighters] * $fighter_price + $planetinfo[torps] * $torpedo_price + $planetinfo[colonists] * $colonist_price + $planetinfo[credits];
$planetscore = $planetscore * $min_value_capture / 100;
// echo "playerscore $playerscore, planetscore $planetscore";
if($playerscore < $planetscore)
{
echo "<CENTER>$l_cmb_citizenswanttodie</CENTER><BR><BR>";
$db->Execute("DELETE FROM $dbtables[planets] WHERE planet_id=$planetinfo[planet_id]");
playerlog($ownerinfo[player_id], LOG_PLANET_DEFEATED_D, "$planetinfo[name]|$playerinfo[sector]|$playerinfo[character_name]");
adminlog(LOG_ADMIN_PLANETDEL, "$playerinfo[character_name]|$ownerinfo[character_name]|$playerinfo[sector]");
gen_score($ownerinfo[player_id]);
}
else
{
$l_cmb_youmaycapture = str_replace("[cmb_planetinfo_planet_id]", $planetinfo[planet_id], $l_cmb_youmaycapture);
echo "<CENTER><font color=red>$l_cmb_youmaycapture</font></CENTER><BR><BR>";
playerlog($ownerinfo[player_id], LOG_PLANET_DEFEATED, "$planetinfo[name]|$playerinfo[sector]|$playerinfo[character_name]");
gen_score($ownerinfo[player_id]);
// Make sure that credits are reduced on the planet
$update7a = $db->Execute("UPDATE $dbtables[planets] SET owner=0, fighters=0, torps=torps-$planettorps, base='N', defeated='Y',credits=(credits*(1-$ibank_paymentfee*5)) WHERE planet_id=$planetinfo[planet_id]");
}
}
else
{
$l_cmb_youmaycapture2 = str_replace("[cmb_planetinfo_planet_id]", $planetinfo[planet_id], $l_cmb_youmaycapture2);
echo "<CENTER>$l_cmb_youmaycapture2</CENTER><BR><BR>";
playerlog($ownerinfo[player_id], LOG_PLANET_DEFEATED, "$planetinfo[name]|$playerinfo[sector]|$playerinfo[character_name]");
gen_score($ownerinfo[player_id]);
$update7a = $db->Execute("UPDATE $dbtables[planets] SET owner=0,fighters=0, torps=torps-$planettorps, base='N', defeated='Y', credits=(credits*(1-$ibank_paymentfee*5)) WHERE planet_id=$planetinfo[planet_id]");
}
calc_ownership($planetinfo[sector_id]);
}
else if($attackerarmor < 1)
{
// ***************************** Planet not defeated and attacker blew up ************************
echo "<BR><BR><CENTER><FONT COLOR='#6098F8'><B>$l_cmb_planetnotdefeated</B></FONT></CENTER><BR><BR>";
if ($debug)
echo "<BR><BR>$l_cmb_planetstatistics<BR><BR>";
$fighters_lost = $planetinfo[fighters] - $planetfighters;
$l_cmb_fighterloststat = str_replace("[cmb_fighters_lost]", $fighters_lost, $l_cmb_fighterloststat);
$l_cmb_fighterloststat = str_replace("[cmb_planetinfo_fighters]", $planetinfo[fighters], $l_cmb_fighterloststat);
$l_cmb_fighterloststat = str_replace("[cmb_planetfighters]", $planetfighters, $l_cmb_fighterloststat);
if ($debug)
echo "$l_cmb_fighterloststat<BR>";
$energy=$planetinfo[energy];
if ($debug)
echo "$l_cmb_energyleft: $planetinfo[energy]<BR>";
playerlog($ownerinfo[player_id], LOG_PLANET_NOT_DEFEATED, "$planetinfo[name]|$playerinfo[sector]|$playerinfo[character_name]|".NUMBER($free_ore)."|".NUMBER($free_organics)."|".NUMBER($free_goods)."|$ship_salvage_rate|".NUMBER($ship_salvage));
gen_score($ownerinfo[player_id]);
$update7b = $db->Execute("UPDATE $dbtables[planets] SET energy=$energy,fighters=fighters-$fighters_lost, torps=torps-$planettorps, ore=ore+$free_ore, goods=goods+$free_goods, organics=organics+$free_organics, credits=credits+$ship_salvage WHERE planet_id=$planetinfo[planet_id]");
if ($debug)
echo "<BR>Set: energy=$energy, fighters lost=$fighters_lost, torps=$planetinfo[torps], sectorid=$sectorinfo[sector_id]<BR>";
} else {
// ***************************** Planet not defeated and attacker survived ************************
echo "<BR><BR><CENTER><FONT COLOR='#6098F8'><B>$l_cmb_planetnotdefeated</B></FONT></CENTER><BR><BR>";
$fighters_lost = $planetinfo[fighters] - $planetfighters;
$l_cmb_fighterloststat = str_replace("[cmb_fighters_lost]", $fighters_lost, $l_cmb_fighterloststat);
$l_cmb_fighterloststat = str_replace("[cmb_planetinfo_fighters]", $planetinfo[fighters], $l_cmb_fighterloststat);
$l_cmb_fighterloststat = str_replace("[cmb_planetfighters]", $planetfighters, $l_cmb_fighterloststat);
$energy=$planetinfo[energy];
playerlog($ownerinfo[player_id], LOG_PLANET_SURVIVED, "$planetinfo[name]|$playerinfo[sector]|$playerinfo[character_name]");
gen_score($ownerinfo[player_id]);
$update7b = $db->Execute("UPDATE $dbtables[planets] SET energy=$energy,fighters=fighters-$fighters_lost, torps=torps-$planettorps WHERE planet_id=$planetinfo[planet_id]");
// news
$headline="Planet Attack Fails!";
$newstext=$playerinfo[character_name]." in the ship ".$shipinfo[ship_name]." attacked ".$ownerinfo[character_name]."'s planet ".$planetinfo[name]." but the planet's citizens put up an unexpected defense and forced $playerinfo[character_name] to retreat! SUN will continue to report this story as the news breaks!";
$newstext = addslashes($newstext);
$player_id = $playerinfo[player_id];
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$newstext','$player_id',NOW(), 'attack')");
}
$update = $db->Execute("UPDATE $dbtables[players] SET turns=turns-1, turns_used=turns_used+1 WHERE player_id=$playerinfo[player_id]");
}
function planetcombat()
{
global $playerinfo, $ownerinfo, $sectorinfo, $planetinfo, $torpedo_price, $colonist_price, $ore_price, $organics_price, $goods_price, $energy_price;
global $planetbeams, $planetfighters, $planetshields, $planettorps, $attackerbeams, $attackerfighters, $attackershields, $upgrade_factor, $upgrade_cost;
global $attackertorps, $attackerarmor, $torp_dmg_rate, $level_factor, $attackertorpdamage, $start_energy, $min_value_capture, $l_cmb_atleastoneturn;
global $l_cmb_atleastoneturn, $l_cmb_shipenergybb, $l_cmb_shipenergyab, $l_cmb_shipenergyas, $l_cmb_shiptorpsbtl, $l_cmb_shiptorpsatl;
global $l_cmb_planettorpdamage, $l_cmb_beams, $l_cmb_fighters, $l_cmb_shields, $l_cmb_torps;
global $l_cmb_torpdamage, $l_cmb_armor, $l_cmb_you, $l_cmb_planet, $l_cmb_combatflow, $l_cmb_defender, $l_cmb_attackingplanet;
global $l_cmb_youfireyourbeams, $l_cmb_defenselost, $l_cmb_defenselost2, $l_cmb_planetarybeams, $l_cmb_planetarybeams2;
global $l_cmb_youdestroyedplanetshields, $l_cmb_beamsexhausted, $l_cmb_breachedyourshields, $l_cmb_destroyedyourshields;
global $l_cmb_breachedyourarmor, $l_cmb_destroyedyourarmor, $l_cmb_torpedoexchangephase, $l_cmb_nofightersleft;
global $l_cmb_youdestroyfighters, $l_cmb_planettorpsdestroy, $l_cmb_planettorpsdestroy2, $l_cmb_torpsbreachedyourarmor;
global $l_cmb_planettorpsdestroy3, $l_cmb_youdestroyedallfighters, $l_cmb_youdestroyplanetfighters, $l_cmb_fightercombatphase;
global $l_cmb_youdestroyedallfighters2, $l_cmb_youdestroyplanetfighters2, $l_cmb_allyourfightersdestroyed, $l_cmb_fightertofighterlost;
global $l_cmb_youbreachedplanetshields, $l_cmb_shieldsremainup, $l_cmb_fighterswarm, $l_cmb_swarmandrepel, $l_cmb_engshiptoshipcombat;
global $l_cmb_shipdock, $l_cmb_approachattackvector, $l_cmb_noshipsdocked, $l_cmb_yourshipdestroyed, $l_cmb_escapepod;
global $l_cmb_finalcombatstats, $l_cmb_youlostfighters, $l_cmb_youlostarmorpoints, $l_cmb_energyused, $l_cmb_planetdefeated;
global $l_cmb_citizenswanttodie, $l_cmb_youmaycapture, $l_cmb_planetnotdefeated, $l_cmb_planetstatistics;
global $l_cmb_fighterloststat, $l_cmb_energyleft;
global $db, $db_logging;
if ($playerinfo['turns'] < 1) {
echo $l_cmb_atleastoneturn . "<br><br>";
TEXT_GOTOMAIN();
?>
</div></div>
<?php
include "footer.php";
die;
}
// Planetary defense system calculation
$planetbeams = calcplanetbeams();
$planetfighters = $planetinfo['fighters'];
$planetshields = calcplanetshields();
$planettorps = calcplanettorps();
// Attacking ship calculations
$attackerbeams = NUM_BEAMS($playerinfo['beams']);
$attackerfighters = $playerinfo['ship_fighters'];
$attackershields = NUM_SHIELDS($playerinfo['shields']);
$attackertorps = round(pow($level_factor, $playerinfo['torp_launchers'])) * 2;
$attackerarmor = $playerinfo['armor_pts'];
// Now modify player beams, shields and torpedos on available materiel
$start_energy = $playerinfo['ship_energy'];
// Beams
if ($attackerbeams > $playerinfo['ship_energy']) {
$attackerbeams = $playerinfo['ship_energy'];
}
$playerinfo['ship_energy'] = $playerinfo['ship_energy'] - $attackerbeams;
// Shields
if ($attackershields > $playerinfo['ship_energy']) {
$attackershields = $playerinfo['ship_energy'];
}
$playerinfo['ship_energy'] = $playerinfo['ship_energy'] - $attackershields;
// Torpedos
if ($attackertorps > $playerinfo['torps']) {
$attackertorps = $playerinfo['torps'];
}
$playerinfo['torps'] = $playerinfo['torps'] - $attackertorps;
// Setup torp damage rate for both Planet and Ship
$planettorpdamage = $torp_dmg_rate * $planettorps;
$attackertorpdamage = $torp_dmg_rate * $attackertorps;
/*
Build table
*/
?>
<div class="general-table-container">
<?php
echo "<table><tbody>";
echo "<tr>\n\t<td>STATS</td>\n <td>Beams</td>\n <td>Fighters</td>\n <td>Shields</td>\n <td>Torpedoes Warhead Strength</td>\n <td>Armour</td>\n </tr><tr>\n <td><span class=\"table_word_blue\">Your Ship</span></td>\n <td>{$attackerbeams}</td>\n <td>{$attackerfighters}</td>\n <td>{$attackershields}</td>\n <td>{$attackertorpdamage}</td>\n <td>{$attackerarmor}</td>\n </tr><tr>\n <td><span class=\"table_word_orange\">The Planet</span></td>\n <td>{$planetbeams}</td>\n <td>{$planetfighters}</td>\n <td>{$planetshields}</td>\n <td>{$planettorpdamage}</td>\n <td>N/A</td>\n </tr>";
echo "</tbody></table></div>";
// Begin actual combat calculations
$planetdestroyed = 0;
$attackerdestroyed = 0;
echo "<br/>You are now engaging the planet in sector " . $playerinfo[sector] . "!<br/><br/>";
/*
Build table
*/
?>
<div class="general-table-container">
<?php
echo "<table><tbody>";
echo "<tr>";
echo "<td width=\"50%\">You</td>";
echo "<td width=\"50%\">Planet</td>";
echo "</tr>";
echo "<tr><td colspan=\"2\"><span class=\"table_word_yellow\">Firing Your Beams</span></td></tr>";
if ($planetfighters > 0 && $attackerbeams > 0) {
if ($attackerbeams > $planetfighters) {
echo "<tr><td></td><td><span class=\"table_word_orange\">Planetary defense lost " . $planetfighters . " fighters to your beams</span></td></tr>";
$attackerbeams = $attackerbeams - $planetfighters;
$planetfighters = 0;
} else {
$planetfighters = $planetfighters - $attackerbeams;
echo "<tr><td></td><td><span class=\"table_word_orange\">Planetary defense lost " . $planetfighters . " fighters, but there are more coming!</span></td></tr>";
$attackerbeams = 0;
}
}
if ($attackerfighters > 0 && $planetbeams > 0) {
// If there are more beams on the planet than attacker has fighters
if ($planetbeams > round($attackerfighters / 2)) {
// Half the attacker fighters
$temp = round($attackerfighters / 2);
// Attacker loses half his fighters
$lost = $attackerfighters - $temp;
// Set attacker fighters to 1/2 it's original value
$attackerfighters = $temp;
// Subtract half the attacker fighters from available planetary beams
$planetbeams = $planetbeams - $lost;
echo "<tr><td></td><td><span class=\"table_word_orange\">Planetary beams destroy " . $temp . " of your fighters</span></td></tr>";
} else {
$attackerfighters = $attackerfighters - $planetbeams;
echo "<tr><td></td><td><span class=\"table_word_orange\">Planetary beams destroy " . $planetbeams . " of your fighters</span></td></tr>";
$planetbeams = 0;
}
}
if ($attackerbeams > 0) {
if ($attackerbeams > $planetshields) {
$attackerbeams = $attackerbeams - $planetshields;
$planetshields = 0;
echo "<tr><td><span class=\"table_word_green\">Your beams have destroyed the planetary shields</span></td><td></td></tr>";
} else {
echo "<tr><td><span class=\"table_word_orange\">You destroy " . $attackerbeams . " planetary shields before your beams are exhausted</span></td><td></td></tr>";
$planetshields = $planetshields - $attackerbeams;
$attackerbeams = 0;
}
}
if ($planetbeams > 0) {
if ($planetbeams > $attackershields) {
$planetbeams = $planetbeams - $attackershields;
$attackershields = 0;
echo "<tr><td></td><td><span class=\"table_word_red\">Planetary beams have breached your shields</span></td></tr>";
} else {
$attackershields = $attackershields - $planetbeams;
echo "<tr><td></td><td><span class=\"table_word_red\">Planetary beams have destroyed " . $planetbeams . " of your shields</span></td></tr>";
$planetbeams = 0;
}
}
if ($planetbeams > 0) {
if ($planetbeams > $attackerarmor) {
$attackerarmor = 0;
echo "<tr><td></td><td><span class=\"table_word_red\">Planetary beams have breached your armor</span></td></tr>";
} else {
$attackerarmor = $attackerarmor - $planetbeams;
echo "<tr><td></td><td><span class=\"table_word_orange\">Planetary beams have destroyed " . $planetbeams . " points of armor</span></td></tr>";
}
}
if ($planetshields > 0) {
} else {
echo "<tr><td></td><td><span class=\"table_word_green\">Planets shields have been breached!</span></td></tr>";
}
echo "</tbody></table></div>";
/*
Build table
*/
?>
<div class="general-table-container">
<?php
echo "<table><tbody>";
echo "<tr>\n\t<td>UPDATE</td>\n <td>Beams</td>\n <td>Fighters</td>\n <td>Shields</td>\n <td>Torpedoes Warhead Strength</td>\n <td>Armour</td>\n </tr><tr>\n <td><span class=\"table_word_blue\">Your Ship</span></td>\n <td>{$attackerbeams}</td>\n <td>{$attackerfighters}</td>\n <td>{$attackershields}</td>\n <td>{$attackertorpdamage}</td>\n <td>{$attackerarmor}</td>\n </tr><tr>\n <td><span class=\"table_word_orange\">The Planet</span></td>\n <td>{$planetbeams}</td>\n <td>{$planetfighters}</td>\n <td>{$planetshields}</td>\n <td>{$planettorpdamage}</td>\n <td>N/A</td>\n </tr>";
echo "</tbody></table></div>";
?>
<div class="general-table-container">
<?php
echo "<table><tbody>";
echo "<tr>";
echo "<td width=\"50%\">You</td>";
echo "<td width=\"50%\">Planet</td>";
echo "</tr>";
echo "<tr><td colspan=\"2\"><span class=\"table_word_yellow\">Torpedo Exchange Phase</span></td></tr>";
if ($planetfighters > 0 && $attackertorpdamage > 0) {
if ($attackertorpdamage > $planetfighters) {
echo "<tr><td>Your torpedos destroy " . $planetfighters . " planetary fighters, no fighters are left</td><td></td></tr>";
$attackertorpdamage = $attackertorpdamage - $planetfighters;
$planetfighters = 0;
} else {
$planetfighters = $planetfighters - $attackertorpdamage;
echo "<tr><td><span class=\"table_word_orange\">Your torpedos destroy " . $attackertorpdamage . " planetary fighters</span></td><td></td></tr>";
$attackertorpdamage = 0;
}
}
if ($attackerfighters > 0 && $planettorpdamage > 0) {
if ($planettorpdamage > round($attackerfighters / 2)) {
$temp = round($attackerfighters / 2);
$lost = $attackerfighters - $temp;
$attackerfighters = $temp;
$planettorpdamage = $planettorpdamage - $lost;
echo "<tr><td></td><td><span class=\"table_word_orange\">Planetary torpedos destroy " . $temp . " of your fighters</span></td></tr>";
} else {
$attackerfighters = $attackerfighters - $planettorpdamage;
echo "<tr><td></td><td><span class=\"table_word_orange\">Planetary torpedos destroy " . $planettorpdamage . " of your fighters</span></td></tr>";
$planettorpdamage = 0;
}
}
if ($planettorpdamage > 0) {
if ($planettorpdamage > $attackerarmor) {
$attackerarmor = 0;
echo "<tr><td><span class=\"table_word_red\">Planetary torpedos have breached your armor</span></td><td></td></tr>";
} else {
$attackerarmor = $attackerarmor - $planettorpdamage;
echo "<tr><td><span class=\"table_word_orange\">Planetary torpedos have destroyed " . $planettorpdamage . " points of armor</span></td><td></td></tr>";
}
}
if ($attackertorpdamage > 0 && $planetfighters > 0) {
$planetfighters = $planetfighters - $attackertorpdamage;
if ($planetfighters < 0) {
$planetfighters = 0;
echo "<tr><td><span class=\"table_word_green\">Your torpedos have destroyed all the planetary fighters</span></td><td></td></tr>";
} else {
echo "<tr><td><span class=\"table_word_orange\">Your torpedos destroy " . $attackertorpdamage . " planetary fighters</span></td><td></td></tr>";
}
} else {
echo "<tr><td></td><td><span class=\"table_word_green\">Planet has no torpedoes</span></td></tr>";
}
echo "</tbody></table></div>";
/*
Build table
*/
?>
<div class="general-table-container">
<?php
echo "<table><tbody>";
echo "<tr>\n\t<td>UPDATE</td>\n <td>Beams</td>\n <td>Fighters</td>\n <td>Shields</td>\n <td>Torpedoes Warhead Strength</td>\n <td>Armour</td>\n </tr><tr>\n <td><span class=\"table_word_blue\">Your Ship</span></td>\n <td>{$attackerbeams}</td>\n <td>{$attackerfighters}</td>\n <td>{$attackershields}</td>\n <td>{$attackertorpdamage}</td>\n <td>{$attackerarmor}</td>\n </tr><tr>\n <td><span class=\"table_word_orange\">The Planet</span></td>\n <td>{$planetbeams}</td>\n <td>{$planetfighters}</td>\n <td>{$planetshields}</td>\n <td>{$planettorpdamage}</td>\n <td>N/A</td>\n </tr>";
echo "</tbody></table></div>";
?>
<div class="general-table-container">
<?php
echo "<table><tbody>";
echo "<tr>";
echo "<td width=\"50%\">You</td>";
echo "<td width=\"50%\">Planet</td>";
echo "</tr>";
echo "<tr><td colspan=\"2\"><span class=\"table_word_yellow\">Fighter Combat Phase</span></td></tr>";
if ($attackerfighters > 0 && $planetfighters > 0) {
if ($attackerfighters > $planetfighters) {
echo "<tr><td><span class=\"table_word_green\">Your fighters have destroyed all the planetary fighters</span></td><td></td></tr>";
$tempplanetfighters = 0;
} else {
echo "<tr><td><span class=\"table_word_orange\">Your fighters have destroyed " . $attackerfighters . " planetary fighters</span></td><td></td></tr>";
$tempplanetfighters = $planetfighters - $attackerfighters;
}
if ($planetfighters > $attackerfighters) {
echo "<tr><td><span class=\"table_word_red\">All your fighters were destroyed</span></td><td></td></tr>";
$tempplayfighters = 0;
} else {
$tempplayfighters = $attackerfighters - $planetfighters;
echo "<tr><td><span class=\"table_word_orange\">You lost " . $planetfighters . " fighters in fighter to fighter combat</span></td><td></td></tr>";
}
$attackerfighters = $tempplayfighters;
$planetfighters = $tempplanetfighters;
}
if ($attackerfighters > 0 && $planetshields > 0) {
if ($attackerfighters > $planetshields) {
$attackerfighters = $attackerfighters - round($planetshields / 2);
echo "<tr><td><span class=\"table_word_green\">Your fighters have breached the planetary shields</span></td><td></td></tr>";
$planetshields = 0;
} else {
echo "<tr><td></td><td><span class=\"table_word_orange\">Your fighters destroyed " . $attackerfighters . " planetary shields, but they remain up</span></td></tr>";
$planetshields = $planetshields - $attackerfighters;
}
}
if ($planetfighters > 0) {
if ($planetfighters > $attackerarmor) {
$attackerarmor = 0;
echo "<tr><td><span class=\"table_word_red\">Planetary fighters swarm your ship, your armor has been breached</span></td><td></td></tr>";
} else {
$attackerarmor = $attackerarmor - $planetfighters;
echo "<tr><td><span class=\"table_word_orange\">Planetary fighters swarm your ship, but your armor repels them</span></td><td></td></tr>";
}
} else {
echo "<tr><td></td><td><span class=\"table_word_green\">Planet has no fighters</span></td></tr>";
}
echo "</tbody></table></div>";
/*
Build table
*/
?>
<div class="general-table-container">
<?php
echo "<table><tbody>";
echo "<tr>\n\t<td>UPDATE</td>\n <td>Beams</td>\n <td>Fighters</td>\n <td>Shields</td>\n <td>Torpedoes Warhead Strength</td>\n <td>Armour</td>\n </tr><tr>\n <td><span class=\"table_word_blue\">Your Ship</span></td>\n <td>{$attackerbeams}</td>\n <td>{$attackerfighters}</td>\n <td>{$attackershields}</td>\n <td>{$attackertorpdamage}</td>\n <td>{$attackerarmor}</td>\n </tr><tr>\n <td><span class=\"table_word_orange\">The Planet</span></td>\n <td>{$planetbeams}</td>\n <td>{$planetfighters}</td>\n <td>{$planetshields}</td>\n <td>{$planettorpdamage}</td>\n <td>N/A</td>\n </tr>";
echo "</tbody></table></div>";
// Send each docked ship in sequence to attack agressor
$result4 = $db->Execute("SELECT * FROM {$db->prefix}ships WHERE planet_id={$planetinfo['planet_id']} AND on_planet='Y'");
db_op_result($db, $result4, __LINE__, __FILE__, $db_logging);
$shipsonplanet = $result4->RecordCount();
if ($shipsonplanet > 0) {
echo "<br/>There are " . $shipsonplanet . " ships docked at Spacedock!<br>Engaging in Ship to Ship combat.<br/><br/>";
while (!$result4->EOF) {
$onplanet = $result4->fields;
if ($attackerfighters < 0) {
$attackerfighters = 0;
}
if ($attackertorps < 0) {
$attackertorps = 0;
}
if ($attackershields < 0) {
$attackershields = 0;
}
if ($attackerbeams < 0) {
$attackerbeams = 0;
}
if ($attackerarmor < 1) {
break;
}
echo "<br/>" . $onplanet[ship_name] . " is approaching on an attack vector<br/>";
/*ENGAGE EACH SHIP ONE BY ONE!!!*/
shiptoship($onplanet['ship_id']);
$result4->MoveNext();
}
} else {
/*no SHIPS on the planet, noting to worry about*/
}
if ($attackerarmor < 1) {
$free_ore = round($playerinfo['ship_ore'] / 2);
$free_organics = round($playerinfo['ship_organics'] / 2);
$free_goods = round($playerinfo['ship_goods'] / 2);
$ship_value = $upgrade_cost * (round(pow($upgrade_factor, $playerinfo['hull'])) + round(pow($upgrade_factor, $playerinfo['engines'])) + round(pow($upgrade_factor, $playerinfo['power'])) + round(pow($upgrade_factor, $playerinfo['computer'])) + round(pow($upgrade_factor, $playerinfo['sensors'])) + round(pow($upgrade_factor, $playerinfo['beams'])) + round(pow($upgrade_factor, $playerinfo['torp_launchers'])) + round(pow($upgrade_factor, $playerinfo['shields'])) + round(pow($upgrade_factor, $playerinfo['armor'])) + round(pow($upgrade_factor, $playerinfo['cloak'])));
$ship_salvage_rate = mt_rand(0, 10);
$ship_salvage = $ship_value * $ship_salvage_rate / 100;
echo "<br><center><font size='+2' COLOR='red'>{$l_cmb_yourshipdestroyed}</font></center><br>";
if ($playerinfo['dev_escapepod'] == "Y") {
echo "<center><font color='white'>{$l_cmb_escapepod}</font></center><br><br>";
$resx = $db->Execute("UPDATE {$db->prefix}ships SET hull=0,engines=0,power=0,sensors=0,computer=0,beams=0,torp_launchers=0,torps=0,armor=0,armor_pts=100,cloak=0,shields=0,sector=0,ship_organics=0,ship_ore=0,ship_goods=0,ship_energy={$start_energy},ship_colonists=0,ship_fighters=100,dev_warpedit=0,dev_genesis=0,dev_beacon=0,dev_emerwarp=0,dev_escapepod='N',dev_fuelscoop='N',dev_minedeflector=0,on_planet='N',dev_lssd='N' WHERE ship_id={$playerinfo['ship_id']}");
db_op_result($db, $resx, __LINE__, __FILE__, $db_logging);
collect_bounty($planetinfo['owner'], $playerinfo['ship_id']);
} else {
db_kill_player($playerinfo['ship_id']);
collect_bounty($planetinfo['owner'], $playerinfo['ship_id']);
}
} else {
$free_ore = 0;
$free_goods = 0;
$free_organics = 0;
$ship_salvage_rate = 0;
$ship_salvage = 0;
$planetrating = $ownerinfo['hull'] + $ownerinfo['engines'] + $ownerinfo['computer'] + $ownerinfo['beams'] + $ownerinfo['torp_launchers'] + $ownerinfo['shields'] + $ownerinfo['armor'];
if ($ownerinfo['rating'] != 0) {
$rating_change = $ownerinfo['rating'] / abs($ownerinfo['rating']) * $planetrating * 10;
} else {
$rating_change = -100;
}
echo "<br/>Final Combat Stats<br/><br/>";
$fighters_lost = $playerinfo['ship_fighters'] - $attackerfighters;
echo "You lost " . $fighters_lost . " out of " . $playerinfo['ship_fighters'] . " total fighters.<br/>";
$armor_lost = $playerinfo['armor_pts'] - $attackerarmor;
echo "You lost " . $armor_lost . " out of " . $playerinfo['armor_pts'] . " total armor points, you have " . $attackerarmor . " points remaining.<br/>";
$energy = $playerinfo['ship_energy'];
$energy_lost = $start_energy - $playerinfo['ship_energy'];
echo "You used " . $energy_lost . " energy, from a total of " . $start_energy . " energy.<br/>";
$resx = $db->Execute("UPDATE {$db->prefix}ships SET ship_energy={$energy},ship_fighters=ship_fighters-{$fighters_lost}, torps=torps-{$attackertorps},armor_pts=armor_pts-{$armor_lost}, rating=rating-{$rating_change} WHERE ship_id={$playerinfo['ship_id']}");
db_op_result($db, $resx, __LINE__, __FILE__, $db_logging);
}
$result4 = $db->Execute("SELECT * FROM {$db->prefix}ships WHERE planet_id={$planetinfo['planet_id']} AND on_planet='Y'");
db_op_result($db, $result4, __LINE__, __FILE__, $db_logging);
$shipsonplanet = $result4->RecordCount();
#################
### LOG AND UPDATE THE STATS
##################
if ($planetshields < 1 && $planetfighters < 1 && $attackerarmor > 0 && $shipsonplanet == 0) {
echo "<br/><br/><span class=\"table_word_green\">Planet defeated</span><br/><br/>";
// Patch to stop players dumping credits for other players.
$self_tech = get_avg_tech($playerinfo);
$target_tech = round(get_avg_tech($ownerinfo));
$roll = mt_rand(0, (int) $target_tech);
if ($roll > $self_tech) {
// Reset Planet Assets.
$sql = "UPDATE {$db->prefix}planets ";
$sql .= "SET organics = '0', ore = '0', goods = '0', energy = '0', colonists = '2', credits = '0', fighters = '0', torps = '0', corp = '0', base = 'N', sells = 'N', prod_organics = '20', prod_ore = '20', prod_goods = '20', prod_energy = '20', prod_fighters = '10', prod_torp = '10' ";
$sql .= "WHERE `dev_planets`.`planet_id` ={$planetinfo['planet_id']} LIMIT 1;";
$resx = $db->Execute($sql);
db_op_result($db, $resx, __LINE__, __FILE__, $db_logging);
echo "<div style='text-align:center; font-size:18px; color:#f00;'>The planet become unstable due to not being looked after, and all life and assets have been destroyed.</div>\n";
}
if ($min_value_capture != 0) {
$playerscore = gen_score($playerinfo['ship_id']);
$playerscore *= $playerscore;
$planetscore = $planetinfo['organics'] * $organics_price + $planetinfo['ore'] * $ore_price + $planetinfo['goods'] * $goods_price + $planetinfo['energy'] * $energy_price + $planetinfo['fighters'] * $fighter_price + $planetinfo['torps'] * $torpedo_price + $planetinfo['colonists'] * $colonist_price + $planetinfo['credits'];
$planetscore = $planetscore * $min_value_capture / 100;
if ($playerscore < $planetscore) {
echo "The citizens of this planet have decided they'd rather die than serve a pathetic ruler like you. They use a laser drill to dig a hole to the planet's core. You barely have time to escape into orbit before the whole planet is reduced to a ball of molten lava.<br/><br/>";
$resx = $db->Execute("DELETE FROM {$db->prefix}planets WHERE planet_id={$planetinfo['planet_id']}");
db_op_result($db, $resx, __LINE__, __FILE__, $db_logging);
playerlog($db, $ownerinfo['ship_id'], LOG_PLANET_DEFEATED_D, "{$planetinfo['name']}|{$playerinfo['sector']}|{$playerinfo['character_name']}");
adminlog($db, LOG_ADMIN_PLANETDEL, "{$playerinfo['character_name']}|{$ownerinfo['character_name']}|{$playerinfo['sector']}");
gen_score($ownerinfo['ship_id']);
} else {
echo "You may <a href='planet.php?planet_id=", $planetinfo['planet_id'] . "&command=capture'>capture</a> the planet or just leave it undefended.<br><br>";
playerlog($db, $ownerinfo['ship_id'], LOG_PLANET_DEFEATED, "{$planetinfo['name']}|{$playerinfo['sector']}|{$playerinfo['character_name']}");
gen_score($ownerinfo['ship_id']);
$update7a = $db->Execute("UPDATE {$db->prefix}planets SET owner=0, fighters=0, torps=torps-{$planettorps}, base='N', defeated='Y' WHERE planet_id={$planetinfo['planet_id']}");
db_op_result($db, $update7a, __LINE__, __FILE__, $db_logging);
}
} else {
echo "You may <a href='planet.php?planet_id=", $planetinfo['planet_id'] . "&command=capture'>capture</a> the planet or just leave it undefended.<br><br>";
playerlog($db, $ownerinfo['ship_id'], LOG_PLANET_DEFEATED, "{$planetinfo['name']}|{$playerinfo['sector']}|{$playerinfo['character_name']}");
gen_score($ownerinfo['ship_id']);
$update7a = $db->Execute("UPDATE {$db->prefix}planets SET owner=0,fighters=0, torps=torps-{$planettorps}, base='N', defeated='Y' WHERE planet_id={$planetinfo['planet_id']}");
db_op_result($db, $update7a, __LINE__, __FILE__, $db_logging);
}
calc_ownership($planetinfo['sector_id']);
} else {
echo "<br><br><span class=\"table_word_red\">Planet Not Defeated</span><br><br>";
$fighters_lost = $planetinfo['fighters'] - $planetfighters;
$l_cmb_fighterloststat = str_replace("[cmb_fighters_lost]", $fighters_lost, $l_cmb_fighterloststat);
$l_cmb_fighterloststat = str_replace("[cmb_planetinfo_fighters]", $planetinfo['fighters'], $l_cmb_fighterloststat);
$l_cmb_fighterloststat = str_replace("[cmb_planetfighters]", $planetfighters, $l_cmb_fighterloststat);
$energy = $planetinfo['energy'];
playerlog($db, $ownerinfo['ship_id'], LOG_PLANET_NOT_DEFEATED, "{$planetinfo['name']}|{$playerinfo['sector']}|{$playerinfo['character_name']}|{$free_ore}|{$free_organics}|{$free_goods}|{$ship_salvage_rate}|{$ship_salvage}");
gen_score($ownerinfo['ship_id']);
$update7b = $db->Execute("UPDATE {$db->prefix}planets SET energy={$energy},fighters=fighters-{$fighters_lost}, torps=torps-{$planettorps}, ore=ore+{$free_ore}, goods=goods+{$free_goods}, organics=organics+{$free_organics}, credits=credits+{$ship_salvage} WHERE planet_id={$planetinfo['planet_id']}");
db_op_result($db, $update7b, __LINE__, __FILE__, $db_logging);
}
$update = $db->Execute("UPDATE {$db->prefix}ships SET turns=turns-1, turns_used=turns_used+1 WHERE ship_id={$playerinfo['ship_id']}");
db_op_result($db, $update, __LINE__, __FILE__, $db_logging);
}
{
echo ("$l_corpm_tocorp<BR>");
$result = $db->Execute("UPDATE $dbtables[planets] SET corp='$playerinfo[team]', owner=$playerinfo[player_id] WHERE planet_id=$planet_id");
$ownership = calc_ownership($playerinfo[sector]);
if(!empty($ownership))
echo "<p>$ownership<p>";
}
if ($action == "planetpersonal")
{
echo ("$l_corpm_topersonal<BR>");
$result = $db->Execute("UPDATE $dbtables[planets] SET corp='0', owner=$playerinfo[player_id] WHERE planet_id=$planet_id");
$ownership = calc_ownership($playerinfo[sector]);
// Kick other players off the planet
$result = $db->Execute("UPDATE $dbtables[players] SET on_planet='N' WHERE on_planet='Y' AND planet_id = $planet_id AND player_id <> $playerinfo[player_id]");
if(!empty($ownership))
echo "<p>$ownership<p>";
}
TEXT_GOTOMAIN();
}
else
{
echo ("<BR>$l_corpm_exploit<BR>");
TEXT_GOTOMAIN();
}
function go_build_base($planet_id, $sector_id)
{
global $db;
global $dbtables;
global $base_ore, $base_organics, $base_goods, $base_credits;
global $l_planet_bbuild;
global $username;
echo "<BR>Click <A HREF=planet-report.php?PRepType=1>here</A> to return to the Planet Status Report<BR><BR>";
$result = $db->Execute("SELECT * FROM $dbtables[players] WHERE email='$username'");
$playerinfo=$result->fields;
$result2 = $db->Execute("SELECT * FROM $dbtables[universe] WHERE sector_id=$playerinfo[sector]");
$sectorinfo=$result2->fields;
$result3 = $db->Execute("SELECT * FROM $dbtables[planets] WHERE planet_id=$planet_id");
if($result3)
$planetinfo=$result3->fields;
$result4 = Real_Space_Move($sector_id);
if ($result4 != "ON_PLANET" && $result4 != "HOSTILE") {
// build a base
if($planetinfo[ore] >= $base_ore && $planetinfo[organics] >= $base_organics && $planetinfo[goods] >= $base_goods && $planetinfo[credits] >= $base_credits)
{
// ** Create The Base
$update1 = $db->Execute("UPDATE $dbtables[planets] SET base='Y', ore=$planetinfo[ore]-$base_ore, organics=$planetinfo[organics]-$base_organics, goods=$planetinfo[goods]-$base_goods, credits=$planetinfo[credits]-$base_credits WHERE planet_id=$planet_id");
// ** Update User Turns
$update1b = $db->Execute("UPDATE $dbtables[players] SET turns=turns-1, turns_used=turns_used+1 where player_id=$playerinfo[player_id]");
// ** Refresh Plant Info
$result3 = $db->Execute("SELECT * FROM $dbtables[planets] WHERE planet_id=$planet_id");
$planetinfo=$result3->fields;
// ** Notify User Of Base Results
echo "$l_planet_bbuild<BR><BR>";
// ** Calc Ownership and Notify User Of Results
$ownership = calc_ownership($planetinfo[sector_id]);
if(!empty($ownership))
{
echo "$ownership<p>";
}
echo "<BR>Click <A HREF=planet.php?planet_id=$planet_id>here</A> to go to the Planet Menu<BR><BR>";
}
}
}
function furangeetoplanet($planet_id)
{
// ***********************************
// *** Furangee Planet Attack Code ***
// ***********************************
// *********************************
// *** SETUP GENERAL VARIABLES ****
// *********************************
global $playerinfo;
global $shipinfo;
global $planetinfo;
global $torp_dmg_rate;
global $level_factor;
global $rating_combat_factor;
global $upgrade_cost;
global $upgrade_factor;
global $sector_max;
global $furangeeisdead;
global $db, $dbtables;
// *** LOCKING TABLES ****
//$db->Execute("LOCK TABLES $dbtables[players] WRITE, $dbtables[ships] WRITE, $dbtables[universe] WRITE, $dbtables[planets] WRITE, $dbtables[news] WRITE, $dbtables[logs] WRITE");
// ********************************
// *** LOOKUP PLANET DETAILS ****
// ********************************
//$resultp = $db->Execute ("SELECT * FROM $dbtables[planets] WHERE planet_id='$planet_id'");
echo "The planet ID (ship id) = $planet_id<br>";
$resultp = $db->Execute ("SELECT * FROM $dbtables[planets] WHERE owner='$planet_id'");
if ($resultp->EOF) {
echo "Asked to get info on $planet_id and failed<br>";
return;
}
$planetinfo=$resultp->fields;
// ********************************
// *** LOOKUP OWNER DETAILS ****
// ********************************
$resulto = $db->Execute ("SELECT * FROM $dbtables[players] WHERE player_id='$planet_id'");
$ownerinfo=$resulto->fields;
// **********************************
// *** SETUP PLANETARY VARIABLES ****
// **********************************
$base_factor = ($planetinfo[base] == 'Y') ? $basedefense : 0;
// *** PLANET BEAMS ***
$targetbeams = NUM_BEAMS($ownerinfo[beams] + $base_factor);
if ($targetbeams > $planetinfo[energy]) $targetbeams = $planetinfo[energy];
$planetinfo[energy] -= $targetbeams;
// *** PLANET SHIELDS ***
$targetshields = NUM_SHIELDS($ownerinfo[shields] + $base_factor);
if ($targetshields > $planetinfo[energy]) $targetshields = $planetinfo[energy];
$planetinfo[energy] -= $targetshields;
// *** PLANET TORPS ***
$torp_launchers = round(mypw($level_factor, ($ownerinfo[torp_launchers])+ $base_factor)) * 10;
$torps = $planetinfo[torps];
$targettorps = $torp_launchers;
if ($torp_launchers > $torps) $targettorps = $torps;
$planetinfo[torps] -= $targettorps;
$targettorpdmg = $torp_dmg_rate * $targettorps;
// *** PLANET FIGHTERS ***
$targetfighters = $planetinfo[fighters];
// *********************************
// *** SETUP ATTACKER VARIABLES ****
// *********************************
// *** ATTACKER BEAMS ***
$attackerbeams = NUM_BEAMS($shipinfo[beams]);
if ($attackerbeams > $shipinfo[ship_energy]) $attackerbeams = $shipinfo[ship_energy];
$shipinfo[ship_energy] -= $attackerbeams;
// *** ATTACKER SHIELDS ***
$attackershields = NUM_SHIELDS($shipinfo[shields]);
if ($attackershields > $shipinfo[ship_energy]) $attackershields = $shipinfo[ship_energy];
$shipinfo[ship_energy] -= $attackershields;
// *** ATTACKER TORPS ***
$attackertorps = round(mypw($level_factor, $shipinfo[torp_launchers])) * 2;
if ($attackertorps > $shipinfo[torps]) $attackertorps = $shipinfo[torps];
$shipinfo[torps] -= $attackertorps;
$attackertorpdamage = $torp_dmg_rate * $attackertorps;
// *** ATTACKER FIGHTERS ***
$attackerfighters = $shipinfo[ship_fighters];
// *** ATTACKER ARMOUR ***
$attackerarmor = $shipinfo[armour_pts];
// *********************************
// **** BEGIN COMBAT PROCEDURES ****
// *********************************
if($attackerbeams > 0 && $targetfighters > 0)
{ //******** ATTACKER HAS BEAMS - TARGET HAS FIGHTERS - BEAMS VS FIGHTERS ********
if($attackerbeams > $targetfighters)
{ //****** ATTACKER BEAMS GT TARGET FIGHTERS ******
$lost = $targetfighters;
$targetfighters = 0; //**** T LOOSES ALL FIGHTERS ****
$attackerbeams = $attackerbeams-$lost; //**** A LOOSES BEAMS EQ TO T FIGHTERS ****
} else
{ //****** ATTACKER BEAMS LE TARGET FIGHTERS ******
$targetfighters = $targetfighters-$attackerbeams; //**** T LOOSES FIGHTERS EQ TO A BEAMS ****
$attackerbeams = 0; //**** A LOOSES ALL BEAMS ****
}
}
if($attackerfighters > 0 && $targetbeams > 0)
{ //******** TARGET HAS BEAMS - ATTACKER HAS FIGHTERS - BEAMS VS FIGHTERS ********
if($targetbeams > round($attackerfighters / 2))
{ //****** TARGET BEAMS GT HALF ATTACKER FIGHTERS ******
$lost=$attackerfighters-(round($attackerfighters/2));
$attackerfighters=$attackerfighters-$lost; //**** A LOOSES HALF ALL FIGHTERS ****
$targetbeams=$targetbeams-$lost; //**** T LOOSES BEAMS EQ TO HALF A FIGHTERS ****
} else
{ //****** TARGET BEAMS LE HALF ATTACKER FIGHTERS ******
$attackerfighters=$attackerfighters-$targetbeams; //**** A LOOSES FIGHTERS EQ TO T BEAMS ****
$targetbeams=0; //**** T LOOSES ALL BEAMS ****
}
}
if($attackerbeams > 0)
{ //******** ATTACKER HAS BEAMS LEFT - CONTINUE COMBAT - BEAMS VS SHIELDS ********
if($attackerbeams > $targetshields)
{ //****** ATTACKER BEAMS GT TARGET SHIELDS ******
$attackerbeams=$attackerbeams-$targetshields; //**** A LOOSES BEAMS EQ TO T SHIELDS ****
$targetshields=0; //**** T LOOSES ALL SHIELDS ****
} else
{ //****** ATTACKER BEAMS LE TARGET SHIELDS ******
$targetshields=$targetshields-$attackerbeams; //**** T LOOSES SHIELDS EQ TO A BEAMS ****
$attackerbeams=0; //**** A LOOSES ALL BEAMS ****
}
}
if($targetbeams > 0)
{ //******** TARGET HAS BEAMS LEFT - CONTINUE COMBAT - BEAMS VS SHIELDS ********
if($targetbeams > $attackershields)
{ //****** TARGET BEAMS GT ATTACKER SHIELDS ******
$targetbeams=$targetbeams-$attackershields; //**** T LOOSES BEAMS EQ TO A SHIELDS ****
$attackershields=0; //**** A LOOSES ALL SHIELDS ****
} else
{ //****** TARGET BEAMS LE ATTACKER SHIELDS ******
$attackershields=$attackershields-$targetbeams; //**** A LOOSES SHIELDS EQ TO T BEAMS ****
$targetbeams=0; //**** T LOOSES ALL BEAMS ****
}
}
if($targetbeams > 0)
{ //******** TARGET HAS BEAMS LEFT - CONTINUE COMBAT - BEAMS VS ARMOR ********
if($targetbeams > $attackerarmor)
{ //****** TARGET BEAMS GT ATTACKER ARMOR ******
$targetbeams=$targetbeams-$attackerarmor; //**** T LOOSES BEAMS EQ TO A ARMOR ****
$attackerarmor=0; //**** A LOOSES ALL ARMOR (A DESTROYED) ****
} else
{ //****** TARGET BEAMS LE ATTACKER ARMOR ******
$attackerarmor=$attackerarmor-$targetbeams; //**** A LOOSES ARMOR EQ TO T BEAMS ****
$targetbeams=0; //**** T LOOSES ALL BEAMS ****
}
}
if($targetfighters > 0 && $attackertorpdamage > 0)
{ //******** ATTACKER FIRES TORPS - TARGET HAS FIGHTERS - TORPS VS FIGHTERS ********
if($attackertorpdamage > $targetfighters)
{ //****** ATTACKER FIRED TORPS GT TARGET FIGHTERS ******
$lost=$targetfighters;
$targetfighters=0; //**** T LOOSES ALL FIGHTERS ****
$attackertorpdamage=$attackertorpdamage-$lost; //**** A LOOSES FIRED TORPS EQ TO T FIGHTERS ****
} else
{ //****** ATTACKER FIRED TORPS LE HALF TARGET FIGHTERS ******
$targetfighters=$targetfighters-$attackertorpdamage; //**** T LOOSES FIGHTERS EQ TO A TORPS FIRED ****
$attackertorpdamage=0; //**** A LOOSES ALL TORPS FIRED ****
}
}
if($attackerfighters > 0 && $targettorpdmg > 0)
{ //******** TARGET FIRES TORPS - ATTACKER HAS FIGHTERS - TORPS VS FIGHTERS ********
if($targettorpdmg > round($attackerfighters / 2))
{ //****** TARGET FIRED TORPS GT HALF ATTACKER FIGHTERS ******
$lost=$attackerfighters-(round($attackerfighters/2));
$attackerfighters=$attackerfighters-$lost; //**** A LOOSES HALF ALL FIGHTERS ****
$targettorpdmg=$targettorpdmg-$lost; //**** T LOOSES FIRED TORPS EQ TO HALF A FIGHTERS ****
} else
{ //****** TARGET FIRED TORPS LE HALF ATTACKER FIGHTERS ******
$attackerfighters=$attackerfighters-$targettorpdmg; //**** A LOOSES FIGHTERS EQ TO T TORPS FIRED ****
$targettorpdmg=0; //**** T LOOSES ALL TORPS FIRED ****
}
}
if($targettorpdmg > 0)
{ //******** TARGET FIRES TORPS - CONTINUE COMBAT - TORPS VS ARMOR ********
if($targettorpdmg > $attackerarmor)
{ //****** TARGET FIRED TORPS GT HALF ATTACKER ARMOR ******
$targettorpdmg=$targettorpdmg-$attackerarmor; //**** T LOOSES FIRED TORPS EQ TO A ARMOR ****
$attackerarmor=0; //**** A LOOSES ALL ARMOR (A DESTROYED) ****
} else
{ //****** TARGET FIRED TORPS LE HALF ATTACKER ARMOR ******
$attackerarmor=$attackerarmor-$targettorpdmg; //**** A LOOSES ARMOR EQ TO T TORPS FIRED ****
$targettorpdmg=0; //**** T LOOSES ALL TORPS FIRED ****
}
}
if($attackerfighters > 0 && $targetfighters > 0)
{ //******** ATTACKER HAS FIGHTERS - TARGET HAS FIGHTERS - FIGHTERS VS FIGHTERS ********
if($attackerfighters > $targetfighters)
{ //****** ATTACKER FIGHTERS GT TARGET FIGHTERS ******
$temptargfighters=0; //**** T WILL LOOSE ALL FIGHTERS ****
} else
{ //****** ATTACKER FIGHTERS LE TARGET FIGHTERS ******
$temptargfighters=$targetfighters-$attackerfighters; //**** T WILL LOOSE FIGHTERS EQ TO A FIGHTERS ****
}
if($targetfighters > $attackerfighters)
{ //****** TARGET FIGHTERS GT ATTACKER FIGHTERS ******
$tempplayfighters=0; //**** A WILL LOOSE ALL FIGHTERS ****
} else
{ //****** TARGET FIGHTERS LE ATTACKER FIGHTERS ******
$tempplayfighters=$attackerfighters-$targetfighters; //**** A WILL LOOSE FIGHTERS EQ TO T FIGHTERS ****
}
$attackerfighters=$tempplayfighters;
$targetfighters=$temptargfighters;
}
if($targetfighters > 0)
{ //******** TARGET HAS FIGHTERS - CONTINUE COMBAT - FIGHTERS VS ARMOR ********
if($targetfighters > $attackerarmor)
{ //****** TARGET FIGHTERS GT ATTACKER ARMOR ******
$attackerarmor=0; //**** A LOOSES ALL ARMOR (A DESTROYED) ****
} else
{ //****** TARGET FIGHTERS LE ATTACKER ARMOR ******
$attackerarmor=$attackerarmor-$targetfighters; //**** A LOOSES ARMOR EQ TO T FIGHTERS ****
}
}
// *********************************
// **** FIX NEGATIVE VALUE VARS ****
// *********************************
if ($attackerfighters < 0) $attackerfighters = 0;
if ($attackertorps < 0) $attackertorps = 0;
if ($attackershields < 0) $attackershields = 0;
if ($attackerbeams < 0) $attackerbeams = 0;
if ($attackerarmor < 0) $attackerarmor = 0;
if ($targetfighters < 0) $targetfighters = 0;
if ($targettorps < 0) $targettorps = 0;
if ($targetshields < 0) $targetshields = 0;
if ($targetbeams < 0) $targetbeams = 0;
// ******************************************
// *** CHECK IF ATTACKER SHIP DESTROYED ***
// ******************************************
if(!$attackerarmor>0)
{
playerlog($playerinfo[player_id], LOG_RAW, "Ship destroyed by planetary defenses on planet $planetinfo[name]");
$furangeeisdead = 1;
// news
$headline="Furangee Attacks ".$planetinfo[name]."!";
$newstext="Furangee ".$playerinfo[character_name]." in the ship ".$shipinfo[ship_name]." led an attack today against ".$ownerinfo[character_name]."s planet ".$planetinfo[name]." but was brought down by heavy planetary defenses. ";
if ($playerinfo[score] < $ownerinfo[score]) {
$newstext = $newstext . $playerinfo[character_name]." was blinded by the huge riches stored on the planet.";
} else {
$newstext = $newstext . $playerinfo[character_name]." thought it would be easy money but underestimated the planet defenses.";
}
$player_id = $playerinfo[player_id];
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$newstext','$player_id',NOW(), 'attack')");
$free_ore = round($shipinfo[ship_ore]/2);
$free_organics = round($shipinfo[ship_organics]/2);
$free_goods = round($shipinfo[ship_goods]/2);
$ship_value=$upgrade_cost*(round(mypw($upgrade_factor, $shipinfo[hull]))+round(mypw($upgrade_factor, $shipinfo[engines]))+round(mypw($upgrade_factor, $shipinfo[power]))+round(mypw($upgrade_factor, $shipinfo[computer]))+round(mypw($upgrade_factor, $shipinfo[sensors]))+round(mypw($upgrade_factor, $shipinfo[beams]))+round(mypw($upgrade_factor, $shipinfo[torp_launchers]))+round(mypw($upgrade_factor, $shipinfo[shields]))+round(mypw($upgrade_factor, $shipinfo[armor]))+round(mypw($upgrade_factor, $shipinfo[cloak])));
$ship_salvage_rate=rand(10,20);
$ship_salvage=$ship_value*$ship_salvage_rate/100;
$fighters_lost = $planetinfo[fighters] - $targetfighters;
db_kill_player($playerinfo[player_id],$playerinfo[currentship],$planetinfo[owner]);
// *** LOG ATTACK TO PLANET OWNER ***
playerlog($planetinfo[owner], LOG_PLANET_NOT_DEFEATED, "$planetinfo[name]|$planetinfo[sector_id]|Furangee $playerinfo[character_name]|".NUMBER($free_ore)."|".NUMBER($free_organics)."|".NUMBER($free_goods)."|".NUMBER($ship_salvage_rate)."|".NUMBER($ship_salvage));
// *** UPDATE PLANET ***
$db->Execute("UPDATE $dbtables[planets] SET energy=$planetinfo[energy],fighters=fighters-$fighters_lost, torps=torps-$targettorps, ore=ore+$free_ore, goods=goods+$free_goods, organics=organics+$free_organics, credits=credits+$ship_salvage WHERE planet_id=$planetinfo[planet_id]");
}
// **********************************************
// *** MUST HAVE MADE IT PAST PLANET DEFENSES ***
// **********************************************
else
{
$armor_lost = $shipinfo[armour_pts] - $attackerarmor;
$fighters_lost = $shipinfo[ship_fighters] - $attackerfighters;
$target_fighters_lost = $planetinfo[fighters] - $targetfighters;
playerlog($playerinfo[player_id], LOG_RAW, "Made it past defenses on planet $planetinfo[name]");
// *** UPDATE ATTACKER ***
$db->Execute ("UPDATE $dbtables[ships] SET energy=$shipinfo[ship_energy],fighters=fighters-$fighters_lost, torps=torps-$attackertorps, armour_pts=armour_pts-$armor_lost WHERE player_id=$playerinfo[player_id] AND ship_id=$playerinfo[currentship]");
$shipinfo[ship_fighters] = $attackerfighters;
$shipinfo[torps] = $attackertorps;
$shipinfo[armour_pts] = $attackerarmor;
// *** UPDATE PLANET ***
$db->Execute ("UPDATE $dbtables[planets] SET energy=$planetinfo[energy], fighters=$targetfighters, torps=torps-$targettorps WHERE planet_id=$planetinfo[planet_id]");
$planetinfo[fighters] = $targetfighters;
$planetinfo[torps] = $targettorps;
// *** NOW WE MUST ATTACK ALL SHIPS ON THE PLANET ONE BY ONE ***
echo "Planet Info Bug tracker<br>";
echo "Planet info planet ID = $planetinfo[planet_id]<br>";
$resultps = $db->Execute("SELECT * FROM $dbtables[players] WHERE planet_id=$planetinfo[planet_id] AND on_planet='Y'");
$shipsonplanet = $resultps->RecordCount();
if ($shipsonplanet > 0)
{
while (!$resultps->EOF && $furangeeisdead < 1)
{
$onplanet = $resultps->fields;
furangeetoship($onplanet[player_id]);
$resultps->MoveNext();
}
}
$resultps = $db->Execute("SELECT * FROM $dbtables[players] WHERE planet_id=$planetinfo[planet_id] AND on_planet='Y'");
$shipsonplanet = $resultps->RecordCount();
if ($shipsonplanet == 0 && $furangeeisdead < 1)
{
// *** MUST HAVE KILLED ALL SHIPS ON PLANET ***
playerlog($playerinfo[player_id], LOG_RAW, "Defeated all ships on planet $planetinfo[name]");
// *** LOG ATTACK TO PLANET OWNER ***
playerlog($planetinfo[owner], LOG_PLANET_DEFEATED, "$planetinfo[name]|$planetinfo[sector_id]|Furangee $playerinfo[character_name]");
// news
$headline="Furangee Defeat Planet ".$planetinfo[name]."!";
$newstext="Furangee ".$playerinfo[character_name]." in the ship ".$shipinfo[ship_name]." defeated ".$ownerinfo[character_name]."s planet ".$planetinfo[name].". ";
if ($playerinfo[score] < $ownerinfo[score]) {
$newstext = $newstext . $playerinfo[character_name]." mentioned that the bigger they are, the easier the fall.";
} else {
$newstext = $newstext . $playerinfo[character_name]." took the weak out and stamped on them.";
}
$player_id = $playerinfo[player_id];
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$newstext','$player_id',NOW(), 'attack')");
// *** UPDATE PLANET ***
$db->Execute("UPDATE $dbtables[planets] SET fighters=0, torps=0, base='N', owner=0, corp=0 WHERE planet_id=$planetinfo[planet_id]");
calc_ownership($planetinfo[sector_id]);
} else {
// *** MUST HAVE DIED TRYING ***
playerlog($playerinfo[player_id], LOG_RAW, "We were KILLED by ships defending planet $planetinfo[name]");
// news
$headline="Furangee burns up in attack!";
$newstext="Furangee ".$playerinfo[character_name]." got intimate with deep space today when he tried to attack ".$ownerinfo[character_name]."s planet ".$planetinfo[name].". ";
if ($playerinfo[score] < $ownerinfo[score]) {
$newstext = $newstext . $playerinfo[character_name]." felt like his time had come and in a note left on the Intergalactic Bulletin Board he said that he wanted to go out in at least a modicum of style.";
} else {
$newstext = $newstext . $playerinfo[character_name]." was blinded by his own feelings of superiority.";
}
$player_id = $playerinfo[player_id];
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$newstext','$player_id',NOW(), 'attack')");
// *** LOG ATTACK TO PLANET OWNER ***
playerlog($planetinfo[owner], LOG_PLANET_NOT_DEFEATED, "$planetinfo[name]|$planetinfo[sector_id]|Furangee $playerinfo[character_name]|0|0|0|0|0");
// *** NO SALVAGE FOR PLANET BECAUSE WENT TO SHIP WHO WON **
}
}
// *** END OF FURANGEE PLANET ATTACK CODE ***
//$db->Execute("UNLOCK TABLES");
}
function go_build_base($planet_id, $sector_id)
{
global $db;
global $db_logging;
global $base_ore, $base_organics, $base_goods, $base_credits;
global $l_planet_bbuild;
global $username;
echo "<br>Click <a href=planet_report.php?PRepType=1>here</A> to return to the Planet Status Report<br><br>";
$result = $db->Execute("SELECT * FROM {$db->prefix}ships WHERE ship_id='{$user_ship_id}'");
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
$playerinfo = $result->fields;
$result2 = $db->Execute("SELECT * FROM {$db->prefix}universe WHERE sector_id={$playerinfo['sector']}");
db_op_result($db, $result2, __LINE__, __FILE__, $db_logging);
$sectorinfo = $result2->fields;
$result3 = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id={$planet_id}");
db_op_result($db, $result3, __LINE__, __FILE__, $db_logging);
$planetinfo = $result3->fields;
// Error out and return if the Player isn't the owner of the Planet
// verify player owns the planet which is to have the base created on.
if ($planetinfo['owner'] != $playerinfo['ship_id']) {
echo "<div style='color:#f00; font-size:16px;'>Base Construction Failed!</div>\n";
echo "<div style='color:#f00; font-size:16px;'>Invalid Planet or Sector Information Supplied.</div>\n";
return (bool) false;
}
if (!is_numeric($planet_id) || !is_numeric($sector_id)) {
$ip = $_SERVER['REMOTE_ADDR'];
$hack_id = 0x1337;
adminlog($db, LOG_ADMIN_PLANETCHEAT, "{$hack_id}|{$ip}|{$planet_id}|{$sector_id}|{$playerinfo['ship_id']}");
echo "<div style='color:#f00; font-size:16px;'>Base Construction Failed!</div>\n";
return (bool) false;
}
// build a base
Real_Space_Move($sector_id);
echo "<br>Click <a href=planet.php?planet_id={$planet_id}>here</A> to go to the Planet Menu<br><br>";
if ($planetinfo['ore'] >= $base_ore && $planetinfo['organics'] >= $base_organics && $planetinfo['goods'] >= $base_goods && $planetinfo['credits'] >= $base_credits) {
// Create The Base
$update1 = $db->Execute("UPDATE {$db->prefix}planets SET base='Y', ore={$planetinfo['ore']}-{$base_ore}, organics={$planetinfo['organics']}-{$base_organics}, goods={$planetinfo['goods']}-{$base_goods}, credits={$planetinfo['credits']}-{$base_credits} WHERE planet_id={$planet_id}");
db_op_result($db, $update1, __LINE__, __FILE__, $db_logging);
// Update User Turns
$update1b = $db->Execute("UPDATE {$db->prefix}ships SET turns=turns-1, turns_used=turns_used+1 WHERE ship_id={$playerinfo['ship_id']}");
db_op_result($db, $update1b, __LINE__, __FILE__, $db_logging);
// Refresh Plant Info
$result3 = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id={$planet_id}");
db_op_result($db, $result3, __LINE__, __FILE__, $db_logging);
$planetinfo = $result3->fields;
// Notify User Of Base Results
echo "{$l_planet_bbuild}<br><br>";
// Calc Ownership and Notify User Of Results
$ownership = calc_ownership($playerinfo['sector']);
if (!empty($ownership)) {
echo "{$ownership}<p>";
}
}
}
