function xenoberegen()
{
global $playerinfo, $xen_unemployment, $xenobeisdead, $db;
// Xenobe Unempoyment Check
$playerinfo['credits'] = $playerinfo['credits'] + $xen_unemployment;
$maxenergy = NUM_ENERGY($playerinfo['power']);
// Regenerate energy
if ($playerinfo['ship_energy'] <= $maxenergy - 50) {
$playerinfo['ship_energy'] = $playerinfo['ship_energy'] + round(($maxenergy - $playerinfo['ship_energy']) / 2);
// Regen half of remaining energy
$gene = "regenerated Energy to {$playerinfo['ship_energy']} units,";
}
$maxarmor = NUM_ARMOR($playerinfo['armor']);
// Regenerate armor
if ($playerinfo['armor_pts'] <= $maxarmor - 50) {
$playerinfo['armor_pts'] = $playerinfo['armor_pts'] + round(($maxarmor - $playerinfo['armor_pts']) / 2);
// Regen half of remaining armor
$gena = "regenerated Armor to {$playerinfo['armor_pts']} points,";
}
// Buy fighters & torpedos at 6 credits per fighter
$available_fighters = NUM_FIGHTERS($playerinfo['computer']) - $playerinfo['ship_fighters'];
if ($playerinfo['credits'] > 5 && $available_fighters > 0) {
if (round($playerinfo['credits'] / 6) > $available_fighters) {
$purchase = $available_fighters * 6;
$playerinfo['credits'] = $playerinfo['credits'] - $purchase;
$playerinfo['ship_fighters'] = $playerinfo['ship_fighters'] + $available_fighters;
$genf = "purchased {$available_fighters} fighters for {$purchase} credits,";
}
if (round($playerinfo['credits'] / 6) <= $available_fighters) {
$purchase = round($playerinfo['credits'] / 6);
$playerinfo['ship_fighters'] = $playerinfo['ship_fighters'] + $purchase;
$genf = "purchased {$purchase} fighters for {$playerinfo['credits']} credits,";
$playerinfo['credits'] = 0;
}
}
// Xenobe pay 3 credits per torpedo
$available_torpedoes = NUM_TORPEDOES($playerinfo['torp_launchers']) - $playerinfo['torps'];
if ($playerinfo['credits'] > 2 && $available_torpedoes > 0) {
if (round($playerinfo['credits'] / 3) > $available_torpedoes) {
$purchase = $available_torpedoes * 3;
$playerinfo['credits'] = $playerinfo['credits'] - $purchase;
$playerinfo['torps'] = $playerinfo['torps'] + $available_torpedoes;
$gent = "purchased {$available_torpedoes} torpedoes for {$purchase} credits,";
}
if (round($playerinfo['credits'] / 3) <= $available_torpedoes) {
$purchase = round($playerinfo['credits'] / 3);
$playerinfo['torps'] = $playerinfo['torps'] + $purchase;
$gent = "purchased {$purchase} torpedoes for {$playerinfo['credits']} credits,";
$playerinfo['credits'] = 0;
}
}
// Update Xenobe record
$resg = $db->Execute("UPDATE {$db->prefix}ships SET ship_energy=?, armor_pts=?, ship_fighters=?, torps=?, credits=? WHERE ship_id=?", array($playerinfo['ship_energy'], $playerinfo['armor_pts'], $playerinfo['ship_fighters'], $playerinfo['torps'], $playerinfo['credits'], $playerinfo['ship_id']));
db_op_result($db, $resg, __LINE__, __FILE__);
if (!$gene == '' || !$gena == '' || !$genf == '' || !$gent == '') {
playerlog($db, $playerinfo[ship_id], LOG_RAW, "Xenobe {$gene} {$gena} {$genf} {$gent} and has been updated.");
}
}
echo "Option Plan 2: Payment from Intergalactic Bank [Full/Partial Payments]<br>\n";
$l_port_bounty3 = "Click <a href='port.php?pay=2'>here</a> to pay the bounty of [amount] Credits from your Intergalactic Bank Account.";
$l_port_bounty3 = str_replace("[amount]", NUMBER($bty['total_bounty']), $l_port_bounty3);
echo $l_port_bounty3 . "<br>\n";
echo "<br>\n";
echo "<a href=\"bounty.php\">" . $l_by_placebounty . "</a><br><br>";
TEXT_GOTOMAIN();
die;
}
}
}
$genesis_free = $max_genesis - $playerinfo['dev_genesis'];
$beacon_free = $max_beacons - $playerinfo['dev_beacon'];
$emerwarp_free = $max_emerwarp - $playerinfo['dev_emerwarp'];
$warpedit_free = $max_warpedit - $playerinfo['dev_warpedit'];
$fighter_max = NUM_FIGHTERS($playerinfo['computer']);
$fighter_free = $fighter_max - $playerinfo['ship_fighters'];
$torpedo_max = NUM_TORPEDOES($playerinfo['torp_launchers']);
$torpedo_free = $torpedo_max - $playerinfo['torps'];
$armor_max = NUM_ARMOR($playerinfo['armor']);
$armor_free = $armor_max - $playerinfo['armor_pts'];
$colonist_max = NUM_HOLDS($playerinfo['hull']) - $playerinfo['ship_ore'] - $playerinfo['ship_organics'] - $playerinfo['ship_goods'];
if ($colonist_max < 0) {
$colonist_max = 0;
}
$colonist_free = $colonist_max - $playerinfo['ship_colonists'];
TEXT_JAVASCRIPT_BEGIN();
echo "function MakeMax(name, val)\n";
echo "{\n";
echo " if (document.forms[0].elements[name].value != val)\n";
echo " {\n";
TEXT_GOTOMAIN();
?>
</div></div>
<?php
include "footer.php";
die;
}
$quantity = stripnum($quantity);
if ($quantity < 0) {
$quantity = 0;
}
if ($quantity > $defenceinfo['quantity']) {
$quantity = $defenceinfo['quantity'];
}
$torpedo_max = NUM_TORPEDOES($playerinfo['torp_launchers']) - $playerinfo['torps'];
$fighter_max = NUM_FIGHTERS($playerinfo['computer']) - $playerinfo['ship_fighters'];
if ($defenceinfo['defence_type'] == 'F') {
if ($quantity > $fighter_max) {
$quantity = $fighter_max;
}
}
if ($defenceinfo['defence_type'] == 'M') {
if ($quantity > $torpedo_max) {
$quantity = $torpedo_max;
}
}
$ship_id = $playerinfo['ship_id'];
if ($quantity > 0) {
$db->Execute("UPDATE {$db->prefix}sector_defence SET quantity=quantity - {$quantity} WHERE defence_id = {$defence_id}");
if ($defenceinfo['defence_type'] == 'M') {
$db->Execute("UPDATE {$db->prefix}ships SET torps=torps + {$quantity} WHERE ship_id = {$ship_id}");
echo "</TABLE><P>"; //echo "</TD><TD VALIGN=TOP>"; echo "<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 WIDTH=\"100%\">"; $holds_used = $shipinfo[ship_ore] + $shipinfo[ship_organics] + $shipinfo[ship_goods] + $shipinfo[ship_colonists]; $holds_max = NUM_HOLDS($shipinfo[hull]); echo "<TR BGCOLOR=\"$color_header\"><TD><B>$l_holds</B></TD><TD ALIGN=RIGHT><B>" . NUMBER($holds_used) . " / " . NUMBER($holds_max) . "</B></TD></TR>"; echo "<TR BGCOLOR=\"$color_line1\"><TD>$l_ore</TD><TD ALIGN=RIGHT>" . NUMBER($shipinfo[ship_ore]) . "</TD></TR>"; echo "<TR BGCOLOR=\"$color_line2\"><TD>$l_organics</TD><TD ALIGN=RIGHT>" . NUMBER($shipinfo[ship_organics]) . "</TD></TR>"; echo "<TR BGCOLOR=\"$color_line1\"><TD>$l_goods</TD><TD ALIGN=RIGHT>" . NUMBER($shipinfo[ship_goods]) . "</TD></TR>"; echo "<TR BGCOLOR=\"$color_line2\"><TD>$l_colonists</TD><TD ALIGN=RIGHT>" . NUMBER($shipinfo[ship_colonists]) . "</TD></TR>"; //echo "<TR><TD> </TD></TR>"; echo "</TABLE><P>"; echo "<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 WIDTH=\"100%\">"; $armour_pts_max = NUM_ARMOUR($shipinfo[armour]); $ship_fighters_max = NUM_FIGHTERS($shipinfo[computer]); $torps_max = NUM_TORPEDOES($shipinfo[torp_launchers]); echo "<TR BGCOLOR=\"$color_header\"><TD COLSPAN=2 align=center><B>$l_arm_weap</B></TD></TR>"; echo "<TR BGCOLOR=\"$color_line1\"><TD>$l_armourpts</TD><TD ALIGN=RIGHT>" . NUMBER($shipinfo[armour_pts]) . " / " . NUMBER($armour_pts_max) . "</TD></TR>"; echo "<TR BGCOLOR=\"$color_line2\"><TD>$l_fighters</TD><TD ALIGN=RIGHT>" . NUMBER($shipinfo[ship_fighters]) . " / " . NUMBER($ship_fighters_max) . "</TD></TR>"; echo "<TR BGCOLOR=\"$color_line1\"><TD>$l_torps</TD><TD ALIGN=RIGHT>" . NUMBER($shipinfo[torps]) . " / " . NUMBER($torps_max) . "</TD></TR>"; //echo "<TR><TD> </TD></TR>"; echo "</TABLE><p>"; //echo "</TD><TD VALIGN=TOP>"; echo "<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 WIDTH=\"100%\">"; $energy_max = NUM_ENERGY($shipinfo[power]); echo "<TR BGCOLOR=\"$color_header\"><TD><B>$l_energy</B></TD><TD ALIGN=RIGHT><B>" . NUMBER($shipinfo[ship_energy]) . " / " . NUMBER($energy_max) . "</B></TD></TR>"; echo "</TABLE><P>"; echo "<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1 WIDTH=\"100%\">"; echo "<TR BGCOLOR=\"$color_header\"><TD COLSPAN=2 align=center><B>$l_devices</B></TD></TR>"; echo "<TR BGCOLOR=\"$color_line1\"><TD>$l_beacons</TD><TD ALIGN=RIGHT>$shipinfo[dev_beacon]</TD></TR>";
{
$makepass="";
$syllables="er,in,tia,wol,fe,pre,vet,jo,nes,al,len,son,cha,ir,ler,bo,ok,tio,nar,sim,ple,bla,ten,toe,cho,co,lat,spe,ak,er,po,co,lor,pen,cil,li,ght,wh,at,the,he,ck,is,mam,bo,no,fi,ve,any,way,pol,iti,cs,ra,dio,sou,rce,sea,rch,pa,per,com,bo,sp,eak,st,fi,rst,gr,oup,boy,ea,gle,tr,ail,bi,ble,brb,pri,dee,kay,en,be,se";
$syllable_array=explode(",", $syllables);
srand((double)microtime()*1000000);
for ($count=1;$count<=4;$count++) {
if (rand()%10 == 1) {
$makepass .= sprintf("%0.0f",(rand()%50)+1);
} else {
$makepass .= sprintf("%s",$syllable_array[rand()%62]);
}
}
if ($furlevel=='') $furlevel=0;
$maxenergy = NUM_ENERGY($furlevel);
$maxarmour = NUM_ARMOUR($furlevel);
$maxfighters = NUM_FIGHTERS($furlevel);
$maxtorps = NUM_TORPEDOES($furlevel);
$stamp=date("Y-m-d H:i:s");
// *****************************************************************************
// *** ADD FURANGEE RECORD TO ships TABLE ... MODIFY IF ships SCHEMA CHANGES ***
// *****************************************************************************
$result2 = $db->Execute("INSERT INTO $dbtables[players] (`player_id`, `character_name`, `password`, `email`, `credits`, `sector`, `on_planet`,`turns_used`, `last_login`, `rating`, `score`, `team`, `team_invite`, `interface`, `ip_address`, `planet_id`, `preset1`, `preset2`, `preset3`, `trade_colonists`, `trade_fighters`, `trade_torps`, `trade_energy`, `cleared_defences`, `lang`, `alerts`, `alert2`, `subscribed`, `ore_price`, `organics_price`, `goods_price`, `energy_price`, `currentship`,`preset4`,`preset5`,`preset6`) VALUES ('', '$character', '$makepass', '$emailname','10000000', '$sector','N', '3000', '$stamp', '0', '0', '0', '0', 'N', '127.0.0.1', '0', '0', '0', '0', 'N', 'N', 'N', 'N', NULL, '$default_lang', 'N', 'N', NULL, '0', '0', '0', '0', '1',0,0,0)");
$res = $db->Execute("SELECT player_id from $dbtables[players] WHERE email='$emailname'");
$player_id = $res->fields[player_id];
// Calculate ship type
$shipavg = $furlevel;
if($shipavg < 4)
$shiptype = 1;
elseif($shipavg < 6)
$shiptype = 2;
elseif($shipavg < 10)
function planetbombing()
{
global $playerinfo;
global $ownerinfo;
global $ownershipinfo;
global $sectorinfo;
global $planetinfo;
global $planetbeams;
global $planetfighters;
global $attackerfighters;
global $planettorps;
global $torp_dmg_rate;
global $l_cmb_atleastoneturn;
global $db, $dbtables;
global $l_bombsaway;
global $l_bigfigs;
global $l_bigbeams;
global $l_bigtorps;
global $l_strafesuccess;
global $shipinfo;
$debug = false;
//echo "<pre> Planet INFO \n";
//print_r($planetinfo);
//echo "</pre>";
// Check to see if there are enough fighters
$res = $db->Execute("SELECT ship_fighters FROM $dbtables[ships] WHERE player_id=$playerinfo[player_id] AND ship_id=$playerinfo[currentship] AND ship_fighters>0");
if ($res->RowCount()==0) {
echo "You need fighters to be able to SOFA!<BR><BR>";
TEXT_GOTOMAIN();
include("footer.php");
die();
} else {
$row=$res->fields;
$attackerfighters = $row[ship_fighters];
}
// Immediately reduce the ship's fighters to zero
$res = $db->Execute("UPDATE $dbtables[ships] SET ship_fighters=0 WHERE player_id=$playerinfo[player_id] AND ship_id=$playerinfo[currentship]");
if($playerinfo[turns] < 1)
{
echo "$l_cmb_atleastoneturn<BR><BR>";
TEXT_GOTOMAIN();
include("footer.php");
die();
}
echo "<h2>SOFA Attack!</h2>";
echo "<b>$l_bombsaway</b><br><br>\n";
$attackerfighterslost = 0;
$planetfighterslost = 0;
$attackerfightercapacity = NUM_FIGHTERS($shipinfo[computer]);
$ownerfightercapacity = NUM_FIGHTERS($ownershipinfo[computer]);
$beamsused = 0;
$planettorps = calcplanettorps();
$planetbeams = calcplanetbeams();
$planetfighters = calcplanetfighters();
//$attackerfighters = $shipinfo[ship_fighters];
if ($debug) echo "FigsCapacity $attackerfightercapacity <BR>\n";
if ($debug) echo "Figsused $attackerfighters<BR>\n";
// Beams can only take out up to half of the attacking fighters
if($planetbeams <= floor($attackerfighters/2))
{
$attackerfighterslost=$planetbeams;
$beamsused=$planetbeams;
}
else
{
$attackerfighterslost=floor($attackerfighters/2);
$beamsused=floor($attackerfighters/2);
}
if ($beamsused>0) {
echo "<b>Some of your fighters get past the planet's beams! Others are not so lucky...</b><br><br>";
} else {
echo "<b>The planet's beams fail to fire!</b><br><br>";
}
// next are the torpedoe attacks - this if statement should always be true
if($attackerfighters>$attackerfighterslost)
{
if ($debug) echo "pfigs $planetfighterslost mefigs $attackerfighters - $attackerfighterslost<BR>\n";
$attackerfighterslost+=$planettorps*$torp_dmg_rate;
if ($planettorps>0) {
echo "<b>The planet's missile torpedoes take out some of your fighters!</b><br><br>";
} else {
echo "<b>The planet fails to fire any torpedoes! What luck!</b><br><br>";
}
if($attackerfighters<=$attackerfighterslost)
echo "<b>$l_bigtorps</b><br><br>";
else
{
echo "<b>$l_strafesuccess</b><br><br>";
$planetfighterslost=$attackerfighters-$attackerfighterslost;
if ($debug) echo "bigguy figs go boom $planetfighterslost<BR>\n";
if($planetfighterslost>$planetfighters)
{
$planetfighterslost = $planetfighters;
}
}
}
if ($debug) echo "total figs go boom $planetfighterslost<BR>\n";
echo "<br><br>\n";
playerlog($ownerinfo[player_id], LOG_PLANET_BOMBED, "$planetinfo[name]|$playerinfo[sector]|$playerinfo[character_name]|".NUMBER($beamsused)."|".NUMBER($planettorps)."|".NUMBER($planetfighterslost));
$res = $db->Execute("UPDATE $dbtables[players] SET turns=turns-1, turns_used=turns_used+1 WHERE player_id=$playerinfo[player_id]");
$res = $db->Execute("UPDATE $dbtables[planets] SET energy=energy-$beamsused,fighters=fighters-$planetfighterslost, torps=torps-$planettorps WHERE planet_id=$planetinfo[planet_id]");
$res = $db->Execute("UNLOCK TABLES");
}
function createFur($orders)
{
global $db,$dbtables,$sector_max;
// Create A New Furangee
// Create Furangee Name
$nametry = 1;
$namecheck = false;
while ((!$namecheck) and ($nametry <= 9)) {
$Sylable1 = array("Ak","Al","Ar","B","Br","D","F","Fr","G","Gr","K","Kr","N","Ol","Om","P","Qu","R","S","Z");
$Sylable2 = array("a","ar","aka","aza","e","el","i","in","int","ili","ish","ido","ir","o","oi","or","os","ov","u","un");
$Sylable3 = array("ag","al","ak","ba","dar","g","ga","k","ka","kar","kil","l","n","nt","ol","r","s","ta","til","x");
$sy1roll = rand(0,19);
$sy2roll = rand(0,19);
$sy3roll = rand(0,19);
$character = $Sylable1[$sy1roll] . $Sylable2[$sy2roll] . $Sylable3[$sy3roll];
$emailname = str_replace(" ","_",$character) . "@furangee";
$resultnm = $db->Execute ("select email from $dbtables[players] where email='$emailname'");
if (!$resultnm->EOF) {
echo "Email exists for $character [$emailname]<br>";
$nametry++;
} else {
$namecheck=true;
}
}
if ($namecheck == false) {
echo "Failed to create Furangee!<br>";
return;
}
// Create Ship Name
$shipname = "Furangee- " . $character;
// Select Random Sector
$sector = rand(1,$sector_max);
$furlevel = rand(3,30);
$active="on";
$aggression=0; // 0 = Peaceful 1 = Attack Sometimes 2=Attack Always
$makepass="******";
$maxenergy = NUM_ENERGY($furlevel);
$maxarmour = NUM_ARMOUR($furlevel);
$maxfighters = NUM_FIGHTERS($furlevel);
$maxtorps = NUM_TORPEDOES($furlevel);
$maxcloak = min(22,$furlevel);
$stamp=date("Y-m-d H:i:s");
// *****************************************************************************
// *** ADD FURANGEE RECORD TO ships TABLE ... MODIFY IF ships SCHEMA CHANGES ***
// *****************************************************************************
$result2 = $db->Execute("INSERT INTO $dbtables[players] (`player_id`, `character_name`, `password`, `email`, `credits`, `sector`, `on_planet`,`turns_used`, `last_login`, `rating`, `score`, `team`, `team_invite`, `interface`, `ip_address`, `planet_id`, `preset1`, `preset2`, `preset3`, `trade_colonists`, `trade_fighters`, `trade_torps`, `trade_energy`, `cleared_defences`, `lang`, `alerts`, `alert2`, `subscribed`, `ore_price`, `organics_price`, `goods_price`, `energy_price`, `currentship`,`preset4`,`preset5`,`preset6`) VALUES ('', '$character', '$makepass', '$emailname','10000000', '$sector','N', '3000', '$stamp', '0', '0', '0', '0', 'N', '127.0.0.1', '0', '0', '0', '0', 'N', 'N', 'N', 'N', NULL, '$default_lang', 'N', 'N', NULL, '0', '0', '0', '0', '1',0,0,0)");
$res = $db->Execute("SELECT player_id from $dbtables[players] WHERE email='$emailname'");
$player_id = $res->fields[player_id];
$shiptype=20; // We have a special furangee ship now.
if ($furlevel > 16) {
$ewd = rand(1,2);
} else {
$ewd = 0;
}
$result3 = $db->Execute("INSERT INTO $dbtables[ships] (`ship_id`, `player_id`, `type`, `ship_name`, `ship_destroyed`, `hull`, `engines`, `power`, `computer`, `sensors`, `beams`, `torp_launchers`, `torps`, `shields`, `armour`, `armour_pts`, `cloak`, `sector`, `ship_ore`, `ship_organics`, `ship_goods`, `ship_energy`, `ship_colonists`, `ship_fighters`, `tow`, `on_planet`, `dev_warpedit`, `dev_genesis`, `dev_beacon`, `dev_emerwarp`, `dev_escapepod`, `dev_fuelscoop`, `dev_minedeflector`, `planet_id`, `cleared_defences`, `dev_lssd`, `dev_sectorwmd`) VALUES ('', $player_id, '$shiptype', '$shipname', 'N', $furlevel,$furlevel,$furlevel,$furlevel,$furlevel,$furlevel,$furlevel,$maxtorps,$furlevel,$furlevel,$maxarmour,$maxcloak, $sector,0,0,0,$maxenergy,0,$maxfighters, '0', 'N', '0', '0', '0', '$ewd', 'N', 'N', '0', '0', NULL, 'N', 'N')");
$result4 = $db->Execute("UPDATE $dbtables[players] SET currentship=LAST_INSERT_ID() WHERE player_id=$player_id");
if(!$result2 | !result3) {
echo $db->ErrorMsg() . "<br>";
} else {
echo "Level $furlevel Furangee has been created.<BR>";
// Choose a preferance
$commods = array("ore","goods","organics");
$prefer = $commods[rand(0,2)];
$result3 = $db->Execute("INSERT INTO $dbtables[furangee] (furangee_id,active,aggression,orders,prefer) VALUES('$emailname','Y','$aggression','$orders','$prefer')");
if(!$result3) {
echo $db->ErrorMsg() . "<br>";
} else {
echo "$emailname with orders $orders<br>";
}
}
}
function traderoute_engage($j)
{
global $playerinfo, $color_line1, $color_line2, $color_header;
global $engage, $dist, $servertimezone;
global $color_line2;
global $color_line1;
global $traderoutes;
global $fighter_price;
global $torpedo_price;
global $colonist_price;
global $colonist_limit;
global $inventory_factor;
global $ore_price;
global $ore_delta;
global $ore_limit;
global $organics_price;
global $organics_delta;
global $organics_limit;
global $goods_price;
global $goods_delta;
global $goods_limit;
global $energy_price;
global $energy_delta;
global $energy_limit;
global $mine_hullsize;
global $l_tdr_turnsused, $l_tdr_turnsleft, $l_tdr_credits, $l_tdr_profit, $l_tdr_cost, $l_tdr_totalprofit, $l_tdr_totalcost;
global $l_tdr_planetisovercrowded, $l_tdr_engageagain, $l_tdr_onlyonewaytdr, $l_tdr_engagenonexist, $l_tdr_notowntdr;
global $l_tdr_invalidspoint, $l_tdr_inittdr, $l_tdr_invalidsrc, $l_tdr_inittdrsector, $l_tdr_organics, $l_tdr_energy, $l_tdr_loaded;
global $l_tdr_nothingtoload, $l_tdr_scooped, $l_tdr_dumped, $l_tdr_portisempty, $l_tdr_portisfull, $l_tdr_ore, $l_tdr_sold;
global $l_tdr_goods, $l_tdr_notyourplanet, $l_tdr_invalidssector, $l_tdr_invaliddport, $l_tdr_invaliddplanet;
global $l_tdr_invaliddsector, $l_tdr_nowlink1, $l_tdr_nowlink2, $l_tdr_moreturnsneeded, $l_tdr_hostdef;
global $l_tdr_globalsetbuynothing, $l_tdr_nosrcporttrade, $l_tdr_tradesrcportoutsider, $l_tdr_res, $l_tdr_torps;
global $l_tdr_nodestporttrade, $l_tdr_tradedestportoutsider, $l_tdr_portin, $l_tdr_planet, $l_tdr_bought, $l_tdr_colonists;
global $l_tdr_fighters, $l_tdr_nothingtotrade, $l_here, $l_tdr_five, $l_tdr_ten, $l_tdr_fifty;
global $l_tdr_nothingtodump;
global $db;
global $db_logging;
global $portfull;
foreach ($traderoutes as $testroute) {
if ($testroute['traderoute_id'] == $engage) {
$traderoute = $testroute;
}
}
if (!isset($traderoute)) {
traderoute_die($l_tdr_engagenonexist);
}
if ($traderoute['owner'] != $playerinfo['ship_id']) {
traderoute_die($l_tdr_notowntdr);
}
// Source Check
if ($traderoute['source_type'] == 'P') {
// Retrieve port info here, we'll need it later anyway
$result = $db->Execute("SELECT * FROM {$db->prefix}universe WHERE sector_id=?;", array($traderoute['source_id']));
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
// $result = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id=$traderoute[source_id] AND (owner = $playerinfo[ship_id] OR (corp <> 0 AND corp = $playerinfo[team]));");
if (!$result || $result->EOF) {
traderoute_die($l_tdr_invalidspoint);
}
$source = $result->fields;
if ($traderoute['source_id'] != $playerinfo['sector']) {
$l_tdr_inittdr = str_replace("[tdr_source_id]", $traderoute['source_id'], $l_tdr_inittdr);
traderoute_die($l_tdr_inittdr);
}
} elseif ($traderoute['source_type'] == 'L' || $traderoute['source_type'] == 'C') {
// $result = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id=$traderoute[source_id]");
$result = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id=? AND (owner = ? OR (corp <> 0 AND corp = ?));", array($traderoute['source_id'], $playerinfo['ship_id'], $playerinfo['team']));
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
if (!$result || $result->EOF) {
traderoute_die($l_tdr_invalidsrc);
}
$source = $result->fields;
if ($source['sector_id'] != $playerinfo['sector']) {
// Check for valid Owned Source Planet
// $l_tdr_inittdrsector = str_replace("[tdr_source_sector_id]", $source['sector_id'], $l_tdr_inittdrsector);
// traderoute_die ($l_tdr_inittdrsector);
traderoute_die("You must be in starting sector before you initiate a trade route!");
}
if ($traderoute['source_type'] == 'L') {
if ($source['owner'] != $playerinfo['ship_id']) {
// $l_tdr_notyourplanet = str_replace("[tdr_source_name]", $source[name], $l_tdr_notyourplanet);
// $l_tdr_notyourplanet = str_replace("[tdr_source_sector_id]", $source[sector_id], $l_tdr_notyourplanet);
// traderoute_die ($l_tdr_notyourplanet);
traderoute_die($l_tdr_invalidsrc);
}
} elseif ($traderoute['source_type'] == 'C') {
if ($source['corp'] != $playerinfo['team']) {
// $l_tdr_notyourplanet = str_replace("[tdr_source_name]", $source[name], $l_tdr_notyourplanet);
// $l_tdr_notyourplanet = str_replace("[tdr_source_sector_id]", $source[sector_id], $l_tdr_notyourplanet);
// $not_corp_planet = "$source[name] in $source[sector_id] not a Copporate Planet";
// traderoute_die ($not_corp_planet);
traderoute_die($l_tdr_invalidsrc);
}
}
// Store starting port info, we'll need it later
$result = $db->Execute("SELECT * FROM {$db->prefix}universe WHERE sector_id=?;", array($source['sector_id']));
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
if (!$result || $result->EOF) {
traderoute_die($l_tdr_invalidssector);
}
$sourceport = $result->fields;
}
// Destination Check
if ($traderoute['dest_type'] == 'P') {
$result = $db->Execute("SELECT * FROM {$db->prefix}universe WHERE sector_id=?;", array($traderoute['dest_id']));
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
if (!$result || $result->EOF) {
traderoute_die($l_tdr_invaliddport);
}
$dest = $result->fields;
} elseif ($traderoute['dest_type'] == 'L' || $traderoute['dest_type'] == 'C') {
// Check for valid Owned Source Planet
// This now only returns Planets that the player owns or planets that belong to the team and set as corp planets..
// $result = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id=$traderoute[dest_id]");
$result = $db->Execute("SELECT * FROM {$db->prefix}planets WHERE planet_id=? AND (owner = ? OR (corp <> 0 AND corp = ?));", array($traderoute['dest_id'], $playerinfo['ship_id'], $playerinfo['team']));
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
if (!$result || $result->EOF) {
traderoute_die($l_tdr_invaliddplanet);
}
$dest = $result->fields;
if ($traderoute['dest_type'] == 'L') {
if ($dest['owner'] != $playerinfo['ship_id']) {
$l_tdr_notyourplanet = str_replace("[tdr_source_name]", $dest['name'], $l_tdr_notyourplanet);
$l_tdr_notyourplanet = str_replace("[tdr_source_sector_id]", $dest['sector_id'], $l_tdr_notyourplanet);
traderoute_die($l_tdr_notyourplanet);
}
} elseif ($traderoute['dest_type'] == 'C') {
if ($dest['corp'] != $playerinfo['team']) {
$l_tdr_notyourplanet = str_replace("[tdr_source_name]", $dest['name'], $l_tdr_notyourplanet);
$l_tdr_notyourplanet = str_replace("[tdr_source_sector_id]", $dest['sector_id'], $l_tdr_notyourplanet);
traderoute_die($l_tdr_notyourplanet);
}
}
$result = $db->Execute("SELECT * FROM {$db->prefix}universe WHERE sector_id=?;", array($dest['sector_id']));
db_op_result($db, $result, __LINE__, __FILE__, $db_logging);
if (!$result || $result->EOF) {
traderoute_die($l_tdr_invaliddsector);
}
$destport = $result->fields;
}
if (!isset($sourceport)) {
$sourceport = $source;
}
if (!isset($destport)) {
$destport = $dest;
}
// Warp or RealSpace and generate distance
if ($traderoute['move_type'] == 'W') {
$query = $db->Execute("SELECT link_id FROM {$db->prefix}links WHERE link_start=? AND link_dest=?;", array($source['sector_id'], $dest['sector_id']));
db_op_result($db, $query, __LINE__, __FILE__, $db_logging);
if ($query->EOF) {
$l_tdr_nowlink1 = str_replace("[tdr_src_sector_id]", $source['sector_id'], $l_tdr_nowlink1);
$l_tdr_nowlink1 = str_replace("[tdr_dest_sector_id]", $dest['sector_id'], $l_tdr_nowlink1);
traderoute_die($l_tdr_nowlink1);
}
if ($traderoute['circuit'] == '2') {
$query = $db->Execute("SELECT link_id FROM {$db->prefix}links WHERE link_start=? AND link_dest=?;", array($dest['sector_id'], $source['sector_id']));
db_op_result($db, $query, __LINE__, __FILE__, $db_logging);
if ($query->EOF) {
$l_tdr_nowlink2 = str_replace("[tdr_src_sector_id]", $source['sector_id'], $l_tdr_nowlink2);
$l_tdr_nowlink2 = str_replace("[tdr_dest_sector_id]", $dest['sector_id'], $l_tdr_nowlink2);
traderoute_die($l_tdr_nowlink2);
}
$dist['triptime'] = 4;
} else {
$dist['triptime'] = 2;
}
$dist['scooped'] = 0;
$dist['scooped1'] = 0;
$dist['scooped2'] = 0;
} else {
$dist = traderoute_distance('P', 'P', $sourceport, $destport, $traderoute['circuit']);
}
// Check if player has enough turns
if ($playerinfo['turns'] < $dist['triptime']) {
$l_tdr_moreturnsneeded = str_replace("[tdr_dist_triptime]", $dist['triptime'], $l_tdr_moreturnsneeded);
$l_tdr_moreturnsneeded = str_replace("[tdr_playerinfo_turns]", $playerinfo['turns'], $l_tdr_moreturnsneeded);
traderoute_die($l_tdr_moreturnsneeded);
}
// Sector Defense Check
$hostile = 0;
$result99 = $db->Execute("SELECT * FROM {$db->prefix}sector_defence WHERE sector_id = ? AND ship_id <> ?;", array($source['sector_id'], $playerinfo['ship_id']));
db_op_result($db, $result99, __LINE__, __FILE__, $db_logging);
if (!$result99->EOF) {
$fighters_owner = $result99->fields;
$nsresult = $db->Execute("SELECT * FROM {$db->prefix}ships WHERE ship_id=?;", array($fighters_owner['ship_id']));
db_op_result($db, $nsresult, __LINE__, __FILE__, $db_logging);
$nsfighters = $nsresult->fields;
if ($nsfighters['team'] != $playerinfo['team'] || $playerinfo['team'] == 0) {
$hostile = 1;
}
}
$result98 = $db->Execute("SELECT * FROM {$db->prefix}sector_defence WHERE sector_id = ? AND ship_id <> ?;", array($dest['sector_id'], $playerinfo['ship_id']));
db_op_result($db, $result98, __LINE__, __FILE__, $db_logging);
if (!$result98->EOF) {
$fighters_owner = $result98->fields;
$nsresult = $db->Execute("SELECT * FROM {$db->prefix}ships WHERE ship_id=?;", array($fighters_owner['ship_id']));
db_op_result($db, $nsresult, __LINE__, __FILE__, $db_logging);
$nsfighters = $nsresult->fields;
if ($nsfighters['team'] != $playerinfo['team'] || $playerinfo['team'] == 0) {
$hostile = 1;
}
}
if ($hostile > 0 && $playerinfo['hull'] > $mine_hullsize) {
traderoute_die($l_tdr_hostdef);
}
// Special Port Nothing to do
if ($traderoute['source_type'] == 'P' && $source['port_type'] == 'special' && $playerinfo['trade_colonists'] == 'N' && $playerinfo['trade_fighters'] == 'N' && $playerinfo['trade_torps'] == 'N') {
traderoute_die($l_tdr_globalsetbuynothing);
}
// Check if zone allows trading SRC
if ($traderoute['source_type'] == 'P') {
$res = $db->Execute("SELECT * FROM {$db->prefix}zones,{$db->prefix}universe WHERE {$db->prefix}universe.sector_id=? AND {$db->prefix}zones.zone_id={$db->prefix}universe.zone_id;", array($traderoute['source_id']));
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$zoneinfo = $res->fields;
if ($zoneinfo['allow_trade'] == 'N') {
traderoute_die($l_tdr_nosrcporttrade);
} elseif ($zoneinfo['allow_trade'] == 'L') {
if ($zoneinfo['corp_zone'] == 'N') {
$res = $db->Execute("SELECT team FROM {$db->prefix}ships WHERE ship_id=?;", array($zoneinfo['owner']));
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$ownerinfo = $res->fields;
if ($playerinfo['ship_id'] != $zoneinfo['owner'] && $playerinfo['team'] == 0 || $playerinfo['team'] != $ownerinfo['team']) {
traderoute_die($l_tdr_tradesrcportoutsider);
}
} else {
if ($playerinfo['team'] != $zoneinfo['owner']) {
traderoute_die($l_tdr_tradesrcportoutsider);
}
}
}
}
// Check if zone allows trading DEST
if ($traderoute['dest_type'] == 'P') {
$res = $db->Execute("SELECT * FROM {$db->prefix}zones,{$db->prefix}universe WHERE {$db->prefix}universe.sector_id=? AND {$db->prefix}zones.zone_id={$db->prefix}universe.zone_id;", array($traderoute['dest_id']));
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$zoneinfo = $res->fields;
if ($zoneinfo['allow_trade'] == 'N') {
traderoute_die($l_tdr_nodestporttrade);
} elseif ($zoneinfo['allow_trade'] == 'L') {
if ($zoneinfo['corp_zone'] == 'N') {
$res = $db->Execute("SELECT team FROM {$db->prefix}ships WHERE ship_id=?;", array($zoneinfo['owner']));
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$ownerinfo = $res->fields;
if ($playerinfo['ship_id'] != $zoneinfo['owner'] && $playerinfo['team'] == 0 || $playerinfo['team'] != $ownerinfo['team']) {
traderoute_die($l_tdr_tradedestportoutsider);
}
} else {
if ($playerinfo['team'] != $zoneinfo['owner']) {
traderoute_die($l_tdr_tradedestportoutsider);
}
}
}
}
traderoute_results_table_top();
// Determine if Source is Planet or Port
if ($traderoute['source_type'] == 'P') {
echo "{$l_tdr_portin} {$source['sector_id']}";
} elseif ($traderoute['source_type'] == 'L' || $traderoute['source_type'] == 'C') {
echo "{$l_tdr_planet} {$source['name']} in {$sourceport['sector_id']}";
}
traderoute_results_source();
// Determine if Destination is Planet or Port
if ($traderoute['dest_type'] == 'P') {
echo "{$l_tdr_portin} {$dest['sector_id']}";
} elseif ($traderoute['dest_type'] == 'L' || $traderoute['dest_type'] == 'C') {
echo "{$l_tdr_planet} {$dest['name']} in {$destport['sector_id']}";
}
traderoute_results_destination();
$sourcecost = 0;
// Source is Port
if ($traderoute['source_type'] == 'P') {
// Special Port Section (begin)
if ($source['port_type'] == 'special') {
$ore_buy = 0;
$goods_buy = 0;
$organics_buy = 0;
$energy_buy = 0;
$total_credits = $playerinfo['credits'];
if ($playerinfo['trade_colonists'] == 'Y') {
$free_holds = NUM_HOLDS($playerinfo['hull']) - $playerinfo['ship_ore'] - $playerinfo['ship_organics'] - $playerinfo['ship_goods'] - $playerinfo['ship_colonists'];
$colonists_buy = $free_holds;
if ($playerinfo['credits'] < $colonist_price * $colonists_buy) {
$colonists_buy = $playerinfo['credits'] / $colonist_price;
}
if ($colonists_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($colonists_buy) . " {$l_tdr_colonists}<br>";
}
$sourcecost -= $colonists_buy * $colonist_price;
$total_credits -= $colonists_buy * $colonist_price;
} else {
$colonists_buy = 0;
}
if ($playerinfo['trade_fighters'] == 'Y') {
$free_fighters = NUM_FIGHTERS($playerinfo['computer']) - $playerinfo['ship_fighters'];
$fighters_buy = $free_fighters;
if ($total_credits < $fighters_buy * $fighter_price) {
$fighters_buy = $total_credits / $fighter_price;
}
if ($fighters_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($fighters_buy) . " {$l_tdr_fighters}<br>";
}
$sourcecost -= $fighters_buy * $fighter_price;
$total_credits -= $fighters_buy * $fighter_price;
} else {
$fighters_buy = 0;
}
if ($playerinfo['trade_torps'] == 'Y') {
$free_torps = NUM_FIGHTERS($playerinfo['torp_launchers']) - $playerinfo['torps'];
$torps_buy = $free_torps;
if ($total_credits < $torps_buy * $torpedo_price) {
$torps_buy = $total_credits / $torpedo_price;
}
if ($torps_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($torps_buy) . " {$l_tdr_torps}<br>";
}
$sourcecost -= $torps_buy * $torpedo_price;
} else {
$torps_buy = 0;
}
if ($torps_buy == 0 && $colonists_buy == 0 && $fighters_buy == 0) {
echo "{$l_tdr_nothingtotrade}<br>";
}
if ($traderoute['circuit'] == '1') {
$resb = $db->Execute("UPDATE {$db->prefix}ships SET ship_colonists=ship_colonists+?, ship_fighters=ship_fighters+?,torps=torps+?, ship_energy=ship_energy+? WHERE ship_id=?;", array($colonists_buy, $fighters_buy, $torps_buy, $dist['scooped1'], $playerinfo['ship_id']));
db_op_result($db, $resb, __LINE__, __FILE__, $db_logging);
}
} else {
// Sells commodities
// Added below initializations, for traderoute bug
$ore_buy = 0;
$goods_buy = 0;
$organics_buy = 0;
$energy_buy = 0;
if ($source['port_type'] != 'ore') {
$ore_price1 = $ore_price + $ore_delta * $source['port_ore'] / $ore_limit * $inventory_factor;
if ($source['port_ore'] - $playerinfo['ship_ore'] < 0) {
$ore_buy = $source['port_ore'];
$portfull = 1;
} else {
$ore_buy = $playerinfo['ship_ore'];
}
$sourcecost += $ore_buy * $ore_price1;
if ($ore_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($ore_buy) . " {$l_tdr_ore} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($ore_buy) . " {$l_tdr_ore}<br>";
}
}
$playerinfo['ship_ore'] -= $ore_buy;
}
$portfull = 0;
if ($source['port_type'] != 'goods') {
$goods_price1 = $goods_price + $goods_delta * $source['port_goods'] / $goods_limit * $inventory_factor;
if ($source['port_goods'] - $playerinfo['ship_goods'] < 0) {
$goods_buy = $source['port_goods'];
$portfull = 1;
} else {
$goods_buy = $playerinfo['ship_goods'];
}
$sourcecost += $goods_buy * $goods_price1;
if ($goods_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($goods_buy) . " {$l_tdr_goods} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($goods_buy) . " {$l_tdr_goods}<br>";
}
}
$playerinfo['ship_goods'] -= $goods_buy;
}
$portfull = 0;
if ($source['port_type'] != 'organics') {
$organics_price1 = $organics_price + $organics_delta * $source['port_organics'] / $organics_limit * $inventory_factor;
if ($source['port_organics'] - $playerinfo['ship_organics'] < 0) {
$organics_buy = $source['port_organics'];
$portfull = 1;
} else {
$organics_buy = $playerinfo['ship_organics'];
}
$sourcecost += $organics_buy * $organics_price1;
if ($organics_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($organics_buy) . " {$l_tdr_organics} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($organics_buy) . " {$l_tdr_organics}<br>";
}
}
$playerinfo['ship_organics'] -= $organics_buy;
}
$portfull = 0;
if ($source['port_type'] != 'energy' && $playerinfo['trade_energy'] == 'Y') {
$energy_price1 = $energy_price + $energy_delta * $source['port_energy'] / $energy_limit * $inventory_factor;
if ($source['port_energy'] - $playerinfo['ship_energy'] < 0) {
$energy_buy = $source['port_energy'];
$portfull = 1;
} else {
$energy_buy = $playerinfo['ship_energy'];
}
$sourcecost += $energy_buy * $energy_price1;
if ($energy_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($energy_buy) . " {$l_tdr_energy} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($energy_buy) . " {$l_tdr_energy}<br>";
}
}
$playerinfo['ship_energy'] -= $energy_buy;
}
$free_holds = NUM_HOLDS($playerinfo['hull']) - $playerinfo['ship_ore'] - $playerinfo['ship_organics'] - $playerinfo['ship_goods'] - $playerinfo['ship_colonists'];
// Time to buy
if ($source['port_type'] == 'ore') {
$ore_price1 = $ore_price - $ore_delta * $source['port_ore'] / $ore_limit * $inventory_factor;
$ore_buy = $free_holds;
if ($playerinfo['credits'] + $sourcecost < $ore_buy * $ore_price1) {
$ore_buy = ($playerinfo['credits'] + $sourcecost) / $ore_price1;
}
if ($source['port_ore'] < $ore_buy) {
$ore_buy = $source['port_ore'];
if ($source['port_ore'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($ore_buy) . " {$l_tdr_ore} ({$l_tdr_portisempty})<br>";
}
}
if ($ore_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($ore_buy) . " {$l_tdr_ore}<br>";
}
$playerinfo['ship_ore'] += $ore_buy;
$sourcecost -= $ore_buy * $ore_price1;
$resc = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $source['sector_id']));
db_op_result($db, $resc, __LINE__, __FILE__, $db_logging);
}
if ($source['port_type'] == 'goods') {
$goods_price1 = $goods_price - $goods_delta * $source['port_goods'] / $goods_limit * $inventory_factor;
$goods_buy = $free_holds;
if ($playerinfo['credits'] + $sourcecost < $goods_buy * $goods_price1) {
$goods_buy = ($playerinfo['credits'] + $sourcecost) / $goods_price1;
}
if ($source['port_goods'] < $goods_buy) {
$goods_buy = $source['port_goods'];
if ($source['port_goods'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($goods_buy) . " {$l_tdr_goods} ({$l_tdr_portisempty})<br>";
}
}
if ($goods_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($goods_buy) . " {$l_tdr_goods}<br>";
}
$playerinfo['ship_goods'] += $goods_buy;
$sourcecost -= $goods_buy * $goods_price1;
$resd = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $source['sector_id']));
db_op_result($db, $resd, __LINE__, __FILE__, $db_logging);
}
if ($source['port_type'] == 'organics') {
$organics_price1 = $organics_price - $organics_delta * $source['port_organics'] / $organics_limit * $inventory_factor;
$organics_buy = $free_holds;
if ($playerinfo['credits'] + $sourcecost < $organics_buy * $organics_price1) {
$organics_buy = ($playerinfo['credits'] + $sourcecost) / $organics_price1;
}
if ($source['port_organics'] < $organics_buy) {
$organics_buy = $source['port_organics'];
if ($source['port_organics'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($organics_buy) . " {$l_tdr_organics} ({$l_tdr_portisempty})<br>";
}
}
if ($organics_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($organics_buy) . " {$l_tdr_organics}<br>";
}
$playerinfo['ship_organics'] += $organics_buy;
$sourcecost -= $organics_buy * $organics_price1;
$rese = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $source['sector_id']));
db_op_result($db, $rese, __LINE__, __FILE__, $db_logging);
}
if ($source['port_type'] == 'energy') {
$energy_price1 = $energy_price - $energy_delta * $source['port_energy'] / $energy_limit * $inventory_factor;
$energy_buy = NUM_ENERGY($playerinfo['power']) - $playerinfo['ship_energy'] - $dist['scooped1'];
if ($playerinfo['credits'] + $sourcecost < $energy_buy * $energy_price1) {
$energy_buy = ($playerinfo['credits'] + $sourcecost) / $energy_price1;
}
if ($source['port_energy'] < $energy_buy) {
$energy_buy = $source['port_energy'];
if ($source['port_energy'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($energy_buy) . " {$l_tdr_energy} ({$l_tdr_portisempty})<br>";
}
}
if ($energy_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($energy_buy) . " {$l_tdr_energy}<br>";
}
$playerinfo['ship_energy'] += $energy_buy;
$sourcecost -= $energy_buy * $energy_price1;
$resf = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $source['sector_id']));
db_op_result($db, $resf, __LINE__, __FILE__, $db_logging);
}
if ($dist['scooped1'] > 0) {
$playerinfo['ship_energy'] += $dist['scooped1'];
if ($playerinfo['ship_energy'] > NUM_ENERGY($playerinfo['power'])) {
$playerinfo['ship_energy'] = NUM_ENERGY($playerinfo['power']);
}
}
if ($ore_buy == 0 && $goods_buy == 0 && $energy_buy == 0 && $organics_buy == 0) {
echo "{$l_tdr_nothingtotrade}<br>";
}
if ($traderoute['circuit'] == '1') {
$resf = $db->Execute("UPDATE {$db->prefix}ships SET ship_ore=?, ship_goods=?, ship_organics=?, ship_energy=? WHERE ship_id=?;", array($playerinfo['ship_ore'], $playerinfo['ship_goods'], $playerinfo['ship_organics'], $playerinfo['ship_energy'], $playerinfo['ship_id']));
db_op_result($db, $resf, __LINE__, __FILE__, $db_logging);
}
}
} elseif ($traderoute['source_type'] == 'L' || $traderoute['source_type'] == 'C') {
$free_holds = NUM_HOLDS($playerinfo['hull']) - $playerinfo['ship_ore'] - $playerinfo['ship_organics'] - $playerinfo['ship_goods'] - $playerinfo['ship_colonists'];
if ($traderoute['dest_type'] == 'P') {
// Pick stuff up to sell at port
if ($playerinfo['ship_id'] == $source['owner'] || $playerinfo['team'] == $source['corp']) {
if ($source['goods'] > 0 && $free_holds > 0 && $dest['port_type'] != 'goods') {
if ($source['goods'] > $free_holds) {
$goods_buy = $free_holds;
} else {
$goods_buy = $source['goods'];
}
$free_holds -= $goods_buy;
$playerinfo['ship_goods'] += $goods_buy;
echo "{$l_tdr_loaded} " . NUMBER($goods_buy) . " {$l_tdr_goods}<br>";
} else {
$goods_buy = 0;
}
if ($source['ore'] > 0 && $free_holds > 0 && $dest['port_type'] != 'ore') {
if ($source['ore'] > $free_holds) {
$ore_buy = $free_holds;
} else {
$ore_buy = $source['ore'];
}
$free_holds -= $ore_buy;
$playerinfo['ship_ore'] += $ore_buy;
echo "{$l_tdr_loaded} " . NUMBER($ore_buy) . " {$l_tdr_ore}<br>";
} else {
$ore_buy = 0;
}
if ($source['organics'] > 0 && $free_holds > 0 && $dest['port_type'] != 'organics') {
if ($source['organics'] > $free_holds) {
$organics_buy = $free_holds;
} else {
$organics_buy = $source['organics'];
}
$free_holds -= $organics_buy;
$playerinfo['ship_organics'] += $organics_buy;
echo "{$l_tdr_loaded} " . NUMBER($organics_buy) . " {$l_tdr_organics}<br>";
} else {
$organics_buy = 0;
}
if ($ore_buy == 0 && $goods_buy == 0 && $organics_buy == 0) {
echo "{$l_tdr_nothingtoload}<br>";
}
if ($traderoute['circuit'] == '1') {
$resg = $db->Execute("UPDATE {$db->prefix}ships SET ship_ore=?, ship_goods=?, ship_organics=? WHERE ship_id=?;", array($playerinfo['ship_ore'], $playerinfo['ship_goods'], $playerinfo['ship_organics'], $playerinfo['ship_id']));
db_op_result($db, $resg, __LINE__, __FILE__, $db_logging);
}
} else {
}
$resh = $db->Execute("UPDATE {$db->prefix}planets SET ore=ore-?, goods=goods-?, organics=organics-? WHERE planet_id=?;", array($ore_buy, $goods_buy, $organics_buy, $source['planet_id']));
db_op_result($db, $resh, __LINE__, __FILE__, $db_logging);
} elseif ($traderoute['dest_type'] == 'L' || $traderoute['dest_type'] == 'C') {
if ($source['colonists'] > 0 && $free_holds > 0 && $playerinfo['trade_colonists'] == 'Y') {
if ($source['colonists'] > $free_holds) {
$colonists_buy = $free_holds;
} else {
$colonists_buy = $source['colonists'];
}
$free_holds -= $colonists_buy;
$playerinfo['ship_colonists'] += $colonists_buy;
echo "{$l_tdr_loaded} " . NUMBER($colonists_buy) . " {$l_tdr_colonists}<br>";
} else {
$colonists_buy = 0;
}
$free_torps = NUM_TORPEDOES($playerinfo['torp_launchers']) - $playerinfo['torps'];
if ($source['torps'] > 0 && $free_torps > 0 && $playerinfo['trade_torps'] == 'Y') {
if ($source['torps'] > $free_torps) {
$torps_buy = $free_torps;
} else {
$torps_buy = $source['torps'];
}
$free_torps -= $torps_buy;
$playerinfo['torps'] += $torps_buy;
echo "{$l_tdr_loaded} " . NUMBER($torps_buy) . " {$l_tdr_torps}<br>";
} else {
$torps_buy = 0;
}
$free_fighters = NUM_FIGHTERS($playerinfo['computer']) - $playerinfo['ship_fighters'];
if ($source['fighters'] > 0 && $free_fighters > 0 && $playerinfo['trade_fighters'] == 'Y') {
if ($source['fighters'] > $free_fighters) {
$fighters_buy = $free_fighters;
} else {
$fighters_buy = $source['fighters'];
}
$free_fighters -= $fighters_buy;
$playerinfo['ship_fighters'] += $fighters_buy;
echo "{$l_tdr_loaded} " . NUMBER($fighters_buy) . " {$l_tdr_fighters}<br>";
} else {
$fighters_buy = 0;
}
if ($fighters_buy == 0 && $torps_buy == 0 && $colonists_buy == 0) {
echo "{$l_tdr_nothingtoload}<br>";
}
if ($traderoute['circuit'] == '1') {
$resi = $db->Execute("UPDATE {$db->prefix}ships SET torps=?, ship_fighters=?, ship_colonists=? WHERE ship_id=?;", array($playerinfo['torps'], $playerinfo['ship_fighters'], $playerinfo['ship_colonists'], $playerinfo['ship_id']));
db_op_result($db, $resi, __LINE__, __FILE__, $db_logging);
}
$resj = $db->Execute("UPDATE {$db->prefix}planets SET colonists=colonists-?, torps=torps-?, fighters=fighters-? WHERE planet_id=?;", array($colonists_buy, $torps_buy, $fighters_buy, $source['planet_id']));
db_op_result($db, $resj, __LINE__, __FILE__, $db_logging);
}
}
if ($dist['scooped1'] != 0) {
echo "{$l_tdr_scooped} " . NUMBER($dist['scooped1']) . " {$l_tdr_energy}<br>";
}
traderoute_results_close_cell();
if ($traderoute['circuit'] == '2') {
$playerinfo['credits'] += $sourcecost;
$destcost = 0;
if ($traderoute['dest_type'] == 'P') {
// Added the below for traderoute bug
$ore_buy = 0;
$goods_buy = 0;
$organics_buy = 0;
$energy_buy = 0;
// Sells commodities
$portfull = 0;
if ($dest['port_type'] != 'ore') {
$ore_price1 = $ore_price + $ore_delta * $dest['port_ore'] / $ore_limit * $inventory_factor;
if ($dest['port_ore'] - $playerinfo['ship_ore'] < 0) {
$ore_buy = $dest['port_ore'];
$portfull = 1;
} else {
$ore_buy = $playerinfo['ship_ore'];
}
$destcost += $ore_buy * $ore_price1;
if ($ore_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($ore_buy) . " {$l_tdr_ore} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($ore_buy) . " {$l_tdr_ore}<br>";
}
}
$playerinfo['ship_ore'] -= $ore_buy;
}
$portfull = 0;
if ($dest['port_type'] != 'goods') {
$goods_price1 = $goods_price + $goods_delta * $dest['port_goods'] / $goods_limit * $inventory_factor;
if ($dest['port_goods'] - $playerinfo['ship_goods'] < 0) {
$goods_buy = $dest['port_goods'];
$portfull = 1;
} else {
$goods_buy = $playerinfo['ship_goods'];
}
$destcost += $goods_buy * $goods_price1;
if ($goods_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($goods_buy) . " {$l_tdr_goods} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($goods_buy) . " {$l_tdr_goods}<br>";
}
}
$playerinfo['ship_goods'] -= $goods_buy;
}
$portfull = 0;
if ($dest['port_type'] != 'organics') {
$organics_price1 = $organics_price + $organics_delta * $dest['port_organics'] / $organics_limit * $inventory_factor;
if ($dest['port_organics'] - $playerinfo['ship_organics'] < 0) {
$organics_buy = $dest['port_organics'];
$portfull = 1;
} else {
$organics_buy = $playerinfo['ship_organics'];
}
$destcost += $organics_buy * $organics_price1;
if ($organics_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($organics_buy) . " {$l_tdr_organics} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($organics_buy) . " {$l_tdr_organics}<br>";
}
}
$playerinfo['ship_organics'] -= $organics_buy;
}
$portfull = 0;
if ($dest['port_type'] != 'energy' && $playerinfo['trade_energy'] == 'Y') {
$energy_price1 = $energy_price + $energy_delta * $dest['port_energy'] / $energy_limit * $inventory_factor;
if ($dest['port_energy'] - $playerinfo['ship_energy'] < 0) {
$energy_buy = $dest['port_energy'];
$portfull = 1;
} else {
$energy_buy = $playerinfo['ship_energy'];
}
$destcost += $energy_buy * $energy_price1;
if ($energy_buy != 0) {
if ($portfull == 1) {
echo "{$l_tdr_sold} " . NUMBER($energy_buy) . " {$l_tdr_energy} ({$l_tdr_portisfull})<br>";
} else {
echo "{$l_tdr_sold} " . NUMBER($energy_buy) . " {$l_tdr_energy}<br>";
}
}
$playerinfo['ship_energy'] -= $energy_buy;
} else {
$energy_buy = 0;
}
$free_holds = NUM_HOLDS($playerinfo['hull']) - $playerinfo['ship_ore'] - $playerinfo['ship_organics'] - $playerinfo['ship_goods'] - $playerinfo['ship_colonists'];
// Time to buy
if ($dest['port_type'] == 'ore') {
$ore_price1 = $ore_price - $ore_delta * $dest['port_ore'] / $ore_limit * $inventory_factor;
if ($traderoute['source_type'] == 'L') {
$ore_buy = 0;
} else {
$ore_buy = $free_holds;
if ($playerinfo['credits'] + $destcost < $ore_buy * $ore_price1) {
$ore_buy = ($playerinfo['credits'] + $destcost) / $ore_price1;
}
if ($dest['port_ore'] < $ore_buy) {
$ore_buy = $dest['port_ore'];
if ($dest['port_ore'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($ore_buy) . " {$l_tdr_ore} ({$l_tdr_portisempty})<br>";
}
}
if ($ore_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($ore_buy) . " {$l_tdr_ore}<br>";
}
$playerinfo['ship_ore'] += $ore_buy;
$destcost -= $ore_buy * $ore_price1;
}
$resk = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $dest['sector_id']));
db_op_result($db, $resk, __LINE__, __FILE__, $db_logging);
}
if ($dest['port_type'] == 'goods') {
$goods_price1 = $goods_price - $goods_delta * $dest['port_goods'] / $goods_limit * $inventory_factor;
if ($traderoute['source_type'] == 'L') {
$goods_buy = 0;
} else {
$goods_buy = $free_holds;
if ($playerinfo['credits'] + $destcost < $goods_buy * $goods_price1) {
$goods_buy = ($playerinfo['credits'] + $destcost) / $goods_price1;
}
if ($dest['port_goods'] < $goods_buy) {
$goods_buy = $dest['port_goods'];
if ($dest['port_goods'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($goods_buy) . " {$l_tdr_goods} ({$l_tdr_portisempty})<br>";
}
}
if ($goods_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($goods_buy) . " {$l_tdr_goods}<br>";
}
$playerinfo['ship_goods'] += $goods_buy;
$destcost -= $goods_buy * $goods_price1;
}
$resl = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $dest['sector_id']));
db_op_result($db, $resl, __LINE__, __FILE__, $db_logging);
}
if ($dest['port_type'] == 'organics') {
$organics_price1 = $organics_price - $organics_delta * $dest['port_organics'] / $organics_limit * $inventory_factor;
if ($traderoute['source_type'] == 'L') {
$organics_buy = 0;
} else {
$organics_buy = $free_holds;
if ($playerinfo['credits'] + $destcost < $organics_buy * $organics_price1) {
$organics_buy = ($playerinfo['credits'] + $destcost) / $organics_price1;
}
if ($dest['port_organics'] < $organics_buy) {
$organics_buy = $dest['port_organics'];
if ($dest['port_organics'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($organics_buy) . " {$l_tdr_organics} ({$l_tdr_portisempty})<br>";
}
}
if ($organics_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($organics_buy) . " {$l_tdr_organics}<br>";
}
$playerinfo['ship_organics'] += $organics_buy;
$destcost -= $organics_buy * $organics_price1;
}
$resm = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $dest['sector_id']));
db_op_result($db, $resm, __LINE__, __FILE__, $db_logging);
}
if ($dest['port_type'] == 'energy') {
$energy_price1 = $energy_price - $energy_delta * $dest['port_energy'] / $energy_limit * $inventory_factor;
if ($traderoute['source_type'] == 'L') {
$energy_buy = 0;
} else {
$energy_buy = NUM_ENERGY($playerinfo['power']) - $playerinfo['ship_energy'] - $dist['scooped1'];
if ($playerinfo['credits'] + $destcost < $energy_buy * $energy_price1) {
$energy_buy = ($playerinfo['credits'] + $destcost) / $energy_price1;
}
if ($dest['port_energy'] < $energy_buy) {
$energy_buy = $dest['port_energy'];
if ($dest['port_energy'] == 0) {
echo "{$l_tdr_bought} " . NUMBER($energy_buy) . " {$l_tdr_energy} ({$l_tdr_portisempty})<br>";
}
}
if ($energy_buy != 0) {
echo "{$l_tdr_bought} " . NUMBER($energy_buy) . " {$l_tdr_energy}<br>";
}
$playerinfo['ship_energy'] += $energy_buy;
$destcost -= $energy_buy * $energy_price1;
}
if ($ore_buy == 0 && $goods_buy == 0 && $energy_buy == 0 && $organics_buy == 0) {
echo "{$l_tdr_nothingtotrade}<br>";
}
$resn = $db->Execute("UPDATE {$db->prefix}universe SET port_ore=port_ore-?, port_energy=port_energy-?, port_goods=port_goods-?, port_organics=port_organics-? WHERE sector_id=?;", array($ore_buy, $energy_buy, $goods_buy, $organics_buy, $dest['sector_id']));
db_op_result($db, $resn, __LINE__, __FILE__, $db_logging);
}
if ($dist['scooped2'] > 0) {
$playerinfo['ship_energy'] += $dist['scooped2'];
if ($playerinfo['ship_energy'] > NUM_ENERGY($playerinfo['power'])) {
$playerinfo['ship_energy'] = NUM_ENERGY($playerinfo['power']);
}
}
$reso = $db->Execute("UPDATE {$db->prefix}ships SET ship_ore=?, ship_goods=?, ship_organics=?, ship_energy=? WHERE ship_id=?;", array($playerinfo['ship_ore'], $playerinfo['ship_goods'], $playerinfo['ship_organics'], $playerinfo['ship_energy'], $playerinfo['ship_id']));
db_op_result($db, $reso, __LINE__, __FILE__, $db_logging);
} else {
if ($traderoute['source_type'] == 'L' || $traderoute['source_type'] == 'C') {
$colonists_buy = 0;
$fighters_buy = 0;
$torps_buy = 0;
}
$setcol = 0;
if ($playerinfo['trade_colonists'] == 'Y') {
$colonists_buy += $playerinfo['ship_colonists'];
$col_dump = $playerinfo['ship_colonists'];
if ($dest['colonists'] + $colonists_buy >= $colonist_limit) {
$exceeding = $dest['colonists'] + $colonists_buy - $colonist_limit;
$col_dump = $exceeding;
$setcol = 1;
$colonists_buy -= $exceeding;
if ($colonists_buy < 0) {
$colonists_buy = 0;
}
}
} else {
$col_dump = 0;
}
if ($colonists_buy != 0) {
if ($setcol == 1) {
echo "{$l_tdr_dumped} " . NUMBER($colonists_buy) . " {$l_tdr_colonists} ({$l_tdr_planetisovercrowded})<br>";
} else {
echo "{$l_tdr_dumped} " . NUMBER($colonists_buy) . " {$l_tdr_colonists}<br>";
}
}
if ($playerinfo['trade_fighters'] == 'Y') {
$fighters_buy += $playerinfo['ship_fighters'];
$fight_dump = $playerinfo['ship_fighters'];
} else {
$fight_dump = 0;
}
if ($fighters_buy != 0) {
echo "{$l_tdr_dumped} " . NUMBER($fighters_buy) . " {$l_tdr_fighters}<br>";
}
if ($playerinfo['trade_torps'] == 'Y') {
$torps_buy += $playerinfo['torps'];
$torps_dump = $playerinfo['torps'];
} else {
$torps_dump = 0;
}
if ($torps_buy != 0) {
echo "{$l_tdr_dumped} " . NUMBER($torps_buy) . " {$l_tdr_torps}<br>";
}
if ($torps_buy == 0 && $fighters_buy == 0 && $colonists_buy == 0) {
echo "{$l_tdr_nothingtodump}<br>";
}
if ($traderoute['source_type'] == 'L' || $traderoute['source_type'] == 'C') {
if ($playerinfo['trade_colonists'] == 'Y') {
if ($setcol != 1) {
$col_dump = 0;
}
} else {
$col_dump = $playerinfo['ship_colonists'];
}
if ($playerinfo['trade_fighters'] == 'Y') {
$fight_dump = 0;
} else {
$fight_dump = $playerinfo['ship_fighters'];
}
if ($playerinfo['trade_torps'] == 'Y') {
$torps_dump = 0;
} else {
$torps_dump = $playerinfo['torps'];
}
}
$resp = $db->Execute("UPDATE {$db->prefix}planets SET colonists=colonists+?, fighters=fighters+?, torps=torps+? WHERE planet_id=?;", array($colonists_buy, $fighters_buy, $torps_buy, $traderoute['dest_id']));
db_op_result($db, $resp, __LINE__, __FILE__, $db_logging);
if ($traderoute['source_type'] == 'L' || $traderoute['source_type'] == 'C') {
$resq = $db->Execute("UPDATE {$db->prefix}ships SET ship_colonists=?, ship_fighters=?, torps=?, ship_energy=ship_energy+? WHERE ship_id=?;", array($col_dump, $fight_dump, $torps_dump, $dist['scooped'], $playerinfo['ship_id']));
db_op_result($db, $resq, __LINE__, __FILE__, $db_logging);
} else {
if ($setcol == 1) {
$resr = $db->Execute("UPDATE {$db->prefix}ships SET ship_colonists=?, ship_fighters=ship_fighters-?, torps=torps-?, ship_energy=ship_energy+? WHERE ship_id=?;", array($col_dump, $fight_dump, $torps_dump, $dist['scooped'], $playerinfo['ship_id']));
db_op_result($db, $resr, __LINE__, __FILE__, $db_logging);
} else {
$ress = $db->Execute("UPDATE {$db->prefix}ships SET ship_colonists=ship_colonists-?, ship_fighters=ship_fighters-?, torps=torps-?, ship_energy=ship_energy+? WHERE ship_id=?;", array($col_dump, $fight_dump, $torps_dump, $dist['scooped'], $playerinfo['ship_id']));
db_op_result($db, $ress, __LINE__, __FILE__, $db_logging);
}
}
}
if ($dist['scooped2'] != 0) {
echo "{$l_tdr_scooped} " . NUMBER($dist['scooped1']) . " {$l_tdr_energy}<br>";
}
} else {
echo $l_tdr_onlyonewaytdr;
$destcost = 0;
}
traderoute_results_show_cost();
if ($sourcecost > 0) {
echo "{$l_tdr_profit} : " . NUMBER(abs($sourcecost));
} else {
echo "{$l_tdr_cost} : " . NUMBER(abs($sourcecost));
}
traderoute_results_close_cost();
if ($destcost > 0) {
echo "{$l_tdr_profit} : " . NUMBER(abs($destcost));
} else {
echo "{$l_tdr_cost} : " . NUMBER(abs($destcost));
}
traderoute_results_close_table();
$total_profit = $sourcecost + $destcost;
traderoute_results_display_totals($total_profit);
if ($traderoute['circuit'] == '1') {
$newsec = $destport['sector_id'];
} else {
$newsec = $sourceport['sector_id'];
}
$rest = $db->Execute("UPDATE {$db->prefix}ships SET turns=turns-?, credits=credits+?, turns_used=turns_used+?, sector=? WHERE ship_id=?;", array($dist['triptime'], $total_profit, $dist['triptime'], $newsec, $playerinfo['ship_id']));
db_op_result($db, $rest, __LINE__, __FILE__, $db_logging);
$playerinfo['credits'] += $total_profit - $sourcecost;
$playerinfo['turns'] -= $dist['triptime'];
$tdr_display_creds = NUMBER($playerinfo['credits']);
traderoute_results_display_summary($tdr_display_creds);
// echo $j." -- ";
if ($traderoute['circuit'] == 2) {
$l_tdr_engageagain = str_replace("[here]", "<a href=\"traderoute.php?engage=[tdr_engage]\">" . $l_here . "</a>", $l_tdr_engageagain);
$l_tdr_engageagain = str_replace("[five]", "<a href=\"traderoute.php?engage=[tdr_engage]&tr_repeat=5\">" . $l_tdr_five . "</a>", $l_tdr_engageagain);
$l_tdr_engageagain = str_replace("[ten]", "<a href=\"traderoute.php?engage=[tdr_engage]&tr_repeat=10\">" . $l_tdr_ten . "</a>", $l_tdr_engageagain);
$l_tdr_engageagain = str_replace("[fifty]", "<a href=\"traderoute.php?engage=[tdr_engage]&tr_repeat=50\">" . $l_tdr_fifty . "</a>", $l_tdr_engageagain);
$l_tdr_engageagain = str_replace("[tdr_engage]", $engage, $l_tdr_engageagain);
if ($j == 1) {
echo $l_tdr_engageagain . "\n";
traderoute_results_show_repeat();
}
}
if ($j == 1) {
traderoute_die("");
}
}
function planetbombing()
{
global $playerinfo, $ownerinfo, $sectorinfo, $planetinfo, $planetbeams, $planetfighters, $attackerfighters;
global $planettorps, $torp_dmg_rate, $l_cmb_atleastoneturn, $db, $db_logging;
global $l_bombsaway, $l_bigfigs, $l_bigbeams, $l_bigtorps, $l_strafesuccess;
if ($playerinfo['turns'] < 1) {
echo $l_cmb_atleastoneturn . "<br><br>";
TEXT_GOTOMAIN();
?>
</div></div>
<?php
include "footer.php";
die;
}
$res = $db->Execute("LOCK TABLES {$db->prefix}ships WRITE, {$db->prefix}planets WRITE");
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
echo $l_bombsaway . "<br><br>\n";
$attackerfighterslost = 0;
$planetfighterslost = 0;
$attackerfightercapacity = NUM_FIGHTERS($playerinfo['computer']);
$ownerfightercapacity = NUM_FIGHTERS($ownerinfo['computer']);
$beamsused = 0;
$planettorps = calcplanettorps();
$planetbeams = calcplanetbeams();
$planetfighters = $planetinfo['fighters'];
$attackerfighters = $playerinfo['ship_fighters'];
if ($ownerfightercapacity / $attackerfightercapacity < 1) {
echo $l_bigfigs . "<br><br>\n";
}
if ($planetbeams <= $attackerfighters) {
$attackerfighterslost = $planetbeams;
$beamsused = $planetbeams;
} else {
$attackerfighterslost = $attackerfighters;
$beamsused = $attackerfighters;
}
if ($attackerfighters <= $attackerfighterslost) {
echo $l_bigbeams . "<br>\n";
} else {
$attackerfighterslost += $planettorps * $torp_dmg_rate;
if ($attackerfighters <= $attackerfighterslost) {
echo $l_bigtorps . "<br>\n";
} else {
echo $l_strafesuccess . "<br>\n";
if ($ownerfightercapacity / $attackerfightercapacity > 1) {
$planetfighterslost = $attackerfighters - $attackerfighterslost;
} else {
$planetfighterslost = round(($attackerfighters - $attackerfighterslost) * $ownerfightercapacity / $attackerfightercapacity);
}
if ($planetfighterslost > $planetfighters) {
$planetfighterslost = $planetfighters;
}
}
}
echo "<br><br>\n";
playerlog($db, $ownerinfo[ship_id], LOG_PLANET_BOMBED, "{$planetinfo['name']}|{$playerinfo['sector']}|{$playerinfo['character_name']}|{$beamsused}|{$planettorps}|{$planetfighterslost}");
$res = $db->Execute("UPDATE {$db->prefix}ships SET turns=turns-1, turns_used=turns_used+1, ship_fighters=ship_fighters-{$attackerfighters} WHERE ship_id={$playerinfo['ship_id']}");
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$res = $db->Execute("UPDATE {$db->prefix}planets SET energy=energy-{$beamsused},fighters=fighters-{$planetfighterslost}, torps=torps-{$planettorps} WHERE planet_id={$planetinfo['planet_id']}");
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$res = $db->Execute("UNLOCK TABLES");
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
}
$makepass = "";
$syllables = "er,in,tia,wol,fe,pre,vet,jo,nes,al,len,son,cha,ir,ler,bo,ok,tio,nar,sim,ple,bla,ten,toe,cho,co,lat,spe,ak,er,po,co,lor,pen,cil,li,ght,wh,at,the,he,ck,is,mam,bo,no,fi,ve,any,way,pol,iti,cs,ra,dio,sou,rce,sea,rch,pa,per,com,bo,sp,eak,st,fi,rst,gr,oup,boy,ea,gle,tr,ail,bi,ble,brb,pri,dee,kay,en,be,se";
$syllable_array = explode(",", $syllables);
for ($count = 1; $count <= 4; $count++) {
if (mt_rand() % 10 == 1) {
$makepass .= sprintf("%0.0f", mt_rand() % 50 + 1);
} else {
$makepass .= sprintf("%s", $syllable_array[mt_rand() % 62]);
}
}
if ($xenlevel == '') {
$xenlevel = 0;
}
$maxenergy = NUM_ENERGY($xenlevel);
$maxarmor = NUM_ARMOR($xenlevel);
$maxfighters = NUM_FIGHTERS($xenlevel);
$maxtorps = NUM_TORPEDOES($xenlevel);
$stamp = date("Y-m-d H:i:s");
// *****************************************************************************
// *** ADD Xenobe RECORD TO ships table ... MODIFY IF ships SCHEMA CHANGES ***
// *****************************************************************************
$thesql = "INSERT INTO {$db->prefix}ships ( `ship_id` , `ship_name` , `ship_destroyed` , `character_name` , `password` , `email` , `hull` , `engines` , `power` , `computer` , `sensors` , `beams` , `torp_launchers` , `torps` , `shields` , `armor` , `armor_pts` , `cloak` , `credits` , `sector` , `ship_ore` , `ship_organics` , `ship_goods` , `ship_energy` , `ship_colonists` , `ship_fighters` , `ship_damage` , `turns` , `on_planet` , `dev_warpedit` , `dev_genesis` , `dev_beacon` , `dev_emerwarp` , `dev_escapepod` , `dev_fuelscoop` , `dev_minedeflector` , `turns_used` , `last_login` , `last_kami` , `last_sofa` , `ship_kills` , `ship_deaths` , `rating` , `score` , `points` , `team` , `team_invite` , `ip_address` , `planet_id` , `preset1` , `preset2` , `preset3` , `preset4` , `preset5` , `trade_colonists` , `trade_fighters` , `trade_torps` , `trade_energy` , `cleared_defences` , `lang` , `dev_lssd` )\n values (NULL,'{$shipname}','N','{$character}','{$makepass}','{$emailname}',{$xenlevel},{$xenlevel},{$xenlevel},{$xenlevel},{$xenlevel},{$xenlevel},{$xenlevel},{$maxtorps},{$xenlevel},{$xenlevel},{$maxarmor},{$xenlevel},{$start_credits},{$sector},0,0,0,{$maxenergy},0,{$maxfighters},0,{$start_turns},'N',0,0,0,0,'N','N',0,0, '{$stamp}','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'127.0.0.1',0,0,0,0,0,0,'Y','N','N','Y',NULL,'{$default_lang}','Y')";
$result2 = $db->Execute($thesql);
db_op_result($db, $result2, __LINE__, __FILE__, $db_logging);
if (!$result2) {
echo $db->ErrorMsg() . "<br>";
} else {
echo "Xenobe has been created.<br><br>";
echo "password has been set.<br><br>";
echo "Ship Records have been updated.<br><br>";
}
// You should have received a copy of the GNU Affero General Public License
// along with this program. If not, see <http://www.gnu.org/licenses/>.
//
// File: sched_thegovernor.php
if (preg_match("/sched_turns.php/i", $_SERVER['PHP_SELF'])) {
echo "You can not access this file directly!";
die;
}
echo "<strong>The Governor</strong><br><br>";
echo "Validating Ship Fighters, Torpedoes, Armor points and Credits...<br>\n";
$tdres = $db->Execute("SELECT * FROM {$db->prefix}ships;");
db_op_result($db, $tdres, __LINE__, __FILE__, $db_logging);
$detected = (bool) false;
while (!$tdres->EOF) {
$playerinfo = $tdres->fields;
$ship_fighters_max = NUM_FIGHTERS($playerinfo['computer']);
$torps_max = NUM_TORPEDOES($playerinfo['torp_launchers']);
$armor_pts_max = NUM_ARMOR($playerinfo['armor']);
// Checking Fighters
if ($playerinfo['ship_fighters'] > $ship_fighters_max) {
echo "'-> <span style='color:#f00;'>Detected Fighters Overload on Ship: {$playerinfo['ship_id']}.</span> <span style='color:#0f0;'>*** FIXED ***</span><br>\n";
$resx = $db->Execute("UPDATE {$db->prefix}ships SET ship_fighters = ? WHERE ship_id = ? LIMIT 1;", array($ship_fighters_max, $playerinfo['ship_id']));
db_op_result($db, $resx, __LINE__, __FILE__, $db_logging);
if ($db->ErrorNo() > 0) {
echo "error: " . $db->ErrorMsg() . "<br>\n";
}
$detected = (bool) true;
adminlog($db, 960, "1|{$playerinfo['ship_id']}|{$playerinfo['ship_fighters']}|{$ship_fighters_max}");
} elseif ($playerinfo['ship_fighters'] < 0) {
echo "'-> <span style='color:#f00;'>Detected Fighters Flip on Ship: {$playerinfo['ship_id']}.</span> <span style='color:#0f0;'>*** FIXED ***</span><br>\n";
$resy = $db->Execute("UPDATE {$db->prefix}ships SET ship_fighters = ? WHERE ship_id = ? LIMIT 1;", array(0, $playerinfo['ship_id']));
$shields_upgrade_cost = 0;
if($shields_upgrade > $shipinfo[maxshields])
$shields_upgrade = $shipinfo[maxshields];
if($shields_upgrade < $shipinfo[minshields])
$shields_upgrade = $shipinfo[minshields];
if($shields_upgrade > $shipinfo[shields])
{
$shields_upgrade_cost = phpChangeDelta($shields_upgrade, $shipinfo[shields]);
}
if($fighter_number < 0)
$fighter_number = 0;
$fighter_number = round(abs($fighter_number));
$fighter_max = NUM_FIGHTERS($shipinfo[computer]) - $shipinfo[ship_fighters];
if($fighter_max < 0)
{
$fighter_max = 0;
}
if($fighter_number > $fighter_max)
{
$fighter_number = $fighter_max;
}
$fighter_cost = $fighter_number * $fighter_price;
if($torpedo_number < 0)
$torpedo_number = 0;
$torpedo_number = round(abs($torpedo_number));
$torpedo_max = NUM_TORPEDOES($shipinfo[torp_launchers]) - $shipinfo[torps];
if($torpedo_max < 0)
{
function furangeeregen()
{
// *******************************
// *** SETUP GENERAL VARIABLES ***
// *******************************
global $playerinfo;
global $shipinfo;
global $furangeeisdead;
global $db, $dbtables;
// *******************************
// *** LETS REGENERATE ENERGY ****
// *******************************
$maxenergy = NUM_ENERGY($shipinfo[power]);
if ($shipinfo[ship_energy] <= ($maxenergy - 50)) // *** STOP REGEN WHEN WITHIN 50 OF MAX ***
{ // *** REGEN HALF OF REMAINING ENERGY ***
$shipinfo[ship_energy] = $shipinfo[ship_energy] + round(($maxenergy - $shipinfo[ship_energy])/2);
$gene = "regenerated Energy to $shipinfo[ship_energy] units,";
}
// *******************************
// *** LETS REGENERATE ARMOUR ****
// *******************************
$maxarmour = NUM_ARMOUR($shipinfo[armour]);
if ($shipinfo[armour_pts] <= ($maxarmour - 50)) // *** STOP REGEN WHEN WITHIN 50 OF MAX ***
{ // *** REGEN HALF OF REMAINING ARMOUR ***
$shipinfo[armour_pts] = $shipinfo[armour_pts] + round(($maxarmour - $shipinfo[armour_pts])/2);
$gena = "regenerated Armour to $shipinfo[armour_pts] points,";
}
// *******************************
// *** LETS BUY FIGHTERS/TORPS ***
// *******************************
// *******************************
// *** FURANGEE PAY 6/FIGHTER ****
// *******************************
if ($shipinfo[ship_fighters] < 0) {
playerlog($playerinfo[player_id], LOG_RAW, "Furangee had ".NUMBER($shipinfo[ship_fighters])." FIGHTERS!");
$shipinfo[ship_fighters] = 0;
}
$available_fighters = NUM_FIGHTERS($shipinfo[computer]) - $shipinfo[ship_fighters];
if ($available_fighters > 100000) {
$available_fighters = round($available_fighters/6);
}
if (($playerinfo[credits]>5) && ($available_fighters>0))
{
if (round($playerinfo[credits]/50)>$available_fighters)
{
$purchase = ($available_fighters*50);
$playerinfo[credits] = $playerinfo[credits] - $purchase;
$shipinfo[ship_fighters] = $shipinfo[ship_fighters] + $available_fighters;
$genf = "purchased $available_fighters fighters for $purchase credits,";
}
if (round($playerinfo[credits]/50)<=$available_fighters)
{
$purchase = round($playerinfo[credits]/50);
$shipinfo[ship_fighters] = $shipinfo[ship_fighters] + $purchase/50;
$genf = "purchased $purchase fighters for $playerinfo[credits] credits,";
$playerinfo[credits] = 0;
}
}
// *******************************
// *** FURANGEE PAY 3/TORPEDO ****
// *******************************
$available_torpedoes = (NUM_TORPEDOES($shipinfo[torp_launchers]) - $shipinfo[torps]);
if ($available_torpedoes > 10000) {
$available_torpedoes = round($available_torpedoes/6);
}
if (($playerinfo[credits]>24) && ($available_torpedoes>0))
{
if (round($playerinfo[credits]/25)>$available_torpedoes)
{
$purchase = $available_torpedoes*25;
$playerinfo[credits] = $playerinfo[credits] - $purchase;
$shipinfo[torps] = $shipinfo[torps] + $available_torpedoes;
$gent = "purchased $available_torpedoes torpedoes for $purchase credits,";
}
if (round($playerinfo[credits]/25)<=$available_torpedoes)
{
$purchase = (round($playerinfo[credits]/25));
$shipinfo[torps] = $shipinfo[torps] + $purchase;
$gent = "purchased $purchase torpedoes for $playerinfo[credits] credits,";
$playerinfo[credits] = 0;
}
}
// *********************************
// *** UPDATE FURANGEE RECORD ******
// *********************************
$db->Execute ("UPDATE $dbtables[players] SET credits=$playerinfo[credits] WHERE player_id=$playerinfo[player_id]");
$db->Execute ("UPDATE $dbtables[ships] SET ship_energy=$shipinfo[ship_energy], armour_pts=$shipinfo[armour_pts], ship_fighters=$shipinfo[ship_fighters], torps=$shipinfo[torps] WHERE player_id=$playerinfo[player_id] AND ship_id=$playerinfo[currentship]");
if (!$genf=='' || !$gent=='')
{
playerlog($playerinfo[player_id], LOG_RAW, "Furangee $genf $gent and has been updated.");
}
}
