$rec_itemdata = mysql_fetch_array(mysql_query($sql_itemdata)); $item_resource += $rec_itemdata['cost_steel'] + $rec_itemdata['cost_crystal'] + $rec_itemdata['cost_erbium'] + $rec_itemdata['cost_titanium']; } $sql_resunits = "SELECT * FROM $table[playerunit] WHERE `player_id` = '$id'"; $res_resunits = mysql_query($sql_resunits); while ($rec_resunits = mysql_fetch_array($res_resunits)) { $sql_unitdata = "SELECT `cost_steel`, `cost_crystal`, `cost_erbium`, `cost_titanium` FROM $table[ships] WHERE `id` = '$rec_resunits[unit_id]'"; $rec_unitdata = mysql_fetch_array(mysql_query($sql_unitdata)); $unit_resource += ($rec_unitdata['cost_steel'] + $rec_unitdata['cost_crystal'] + $rec_unitdata['cost_erbium'] + $rec_unitdata['cost_titanium']) * $rec_resunits['amount']; } $total_asteroids = $p['roid_steel'] + $p['roid_crystal'] + $p['roid_erbium'] + $p['roid_unused']; $new['score'] = ($stock_resource / 150) + ($item_resource / 30) + ($unit_resource / 15) + ($total_asteroids * 1000); include('ticker.battle-engine.php'); updatePlayerData($id, $new); } include('ticker.fleetcheck.php'); putCurrentTick($current); include('ticker.universe.php'); } else { //putCurrentTick(0); } $time_end = getmicrotime(); $time = $time_end - $time_start; $num = rand(); //echo 'The ticker ran for '.$time.' seconds.'; ?>
$table[items].cost_steel, $table[items].cost_crystal, $table[items].cost_erbium, $table[items].cost_titanium FROM $table[productions] INNER JOIN $table[items] ON $table[productions].item_id = $table[items].id WHERE $table[productions].id = '$prod_id' AND $table[productions].player_id = $playerdata[id]"; $res_findcprod = mysql_query($sql_findcprod); $num_findcprod = mysql_num_rows($res_findcprod); if ($num_findcprod > 0) { $rec_findcprod = mysql_fetch_assoc($res_findcprod); $sql_cancelprod = "DELETE FROM $table[productions] WHERE `id` = '$rec_findcprod[id]'"; mysql_query($sql_cancelprod); if (mysql_affected_rows() > 0) { $playerdata['res_steel'] += ($rec_findcprod['cost_steel'] * 0.80); $playerdata['res_crystal'] += ($rec_findcprod['cost_crystal'] * 0.80); $playerdata['res_erbium'] += ($rec_findcprod['cost_erbium'] * 0.80); $playerdata['res_titanium'] += ($rec_findcprod['cost_titanium'] * 0.80); updatePlayerData(IB_PLAYER_ID, $playerdata); $error = 2; } else { $error = 106; } } else { $error = 107; } } switch($error) { case 1: $msg = "Succesfully added production."; break; case 2: $msg = 'Succesfully canceled production.<br />You got 80% of the spent resources back.';
updatePlayerData($playerdata['id'], $playerdata); $error = 2; } else { $error = 104; } } if ($do == 'joinalliance') { $password = secureData($_POST['password']); $sql_checkalliance = "SELECT `id` FROM $table[alliance] WHERE `password` = '$password'"; $res_checkalliance = mysql_query($sql_checkalliance); $num_checkalliance = mysql_num_rows($res_checkalliance); $rec_checkalliance = mysql_fetch_array($res_checkalliance); if ($num_checkalliance > 0) { if ($rec_checkalliance['id'] != $playerdata['alliance_id']) { $playerdata['alliance_id'] = $rec_checkalliance['id']; updatePlayerData($playerdata['id'], $playerdata); $error = 3; } else { $error = 105; } } else { $error = 106; } } if ($do == 'changerulerplanet') { $rulername = secureData($_POST['rulername']); $planetname = secureData($_POST['planetname']); if (!$rulername || !$planetname) { $error = 108; } if (getCurrentTick() > 1500) { $error = 109; } if ((getIdByRulername($rulername)) && ($rulername != $playerdata['rulername'])) { $error = 110; } if ((getIdByPlanetname($planetname)) && ($planetname != $playerdata['planetname'])) { $error = 111; }
function decreaseCurrentResources($player_id, $steel, $crystal, $erbium, $titanium) { global $table, $playerdata; $new = $playerdata; $new['res_steel'] = $playerdata['res_steel'] - $steel; $new['res_crystal'] = $playerdata['res_crystal'] - $crystal; $new['res_erbium'] = $playerdata['res_erbium'] - $erbium; $new['res_titanium'] = $playerdata['res_titanium'] - $titanium; updatePlayerData($player_id, $new); }