while ($p = mysql_fetch_array($rec_playerids)) {
$time_end = getmicrotime();
$time = $time_end - $time_start;
$id = $p['id'];
$sql_playerdata = "SELECT `id`, `username`, `password`, `email`, `activated`, `activation_code`, `rulername`, `planetname`, `lastlogin`, `galaxy_id`, `galaxy_spot`, `alliance_id`, `res_steel`, `res_crystal`, `res_erbium`, `res_titanium`, `roid_steel`, `roid_crystal`, `roid_erbium`, `roid_unused`, `score` FROM $table[players] WHERE `id` = '$id'";
$res_playerdata = mysql_query($sql_playerdata);
$new = mysql_fetch_array($res_playerdata);
unset($p);
$p = array();
$p = $new;
checkProductions($id, $current);
$factory_id = getTitaniumFactoryId($p['id']);
$sql_factorydata = "SELECT `steel_investment`, `crystal_investment`, `erbium_investment` FROM $table[titanium_factory] WHERE `id` = '$factory_id'";
$res_factorydata = mysql_query($sql_factorydata);
$num_factorydata = mysql_num_rows($res_factorydata);
if ($num_factorydata > 0) {
$rec_factorydata = mysql_fetch_array($res_factorydata);
$steel_investment = $rec_factorydata['steel_investment'];
$crystal_investment = $rec_factorydata['crystal_investment'];
$erbium_investment = $rec_factorydata['erbium_investment'];
} else {
$steel_investment = 0;
$crystal_investment = 0;
$erbium_investment = 0;
}
$steel_res['planet'] = 0;
<table border="0" cellpadding="0" cellspacing="0" width="800">
<tr>
<td valign="top"><p align="center"><font color="<?echo $error_color;?>"><?echo $msg;?></font></td>
</tr>
<tr height="15">
<td valign="top"></td>
</tr>
</table>
<?
}
$playerdata = getPlayerdata($playerdata['id']);
$total_usedroids = $playerdata['roid_steel'] + $playerdata['roid_crystal'] + $playerdata['roid_erbium'];
$asteroid_initcost = round(($total_usedroids*$RES_FROM_STEEL_ROID*0.25)+((pow($total_usedroids, 1.55))*25));
if (checkItem($playerdata['id'], $TITANIUM_FACTORY)) {
$factory_id = getTitaniumFactoryId($playerdata['id']);
if ($factory_id > 0) {
$sql_factorydata = "SELECT `steel_investment`, `crystal_investment`, `erbium_investment` FROM $table[titanium_factory] WHERE `id` = '$factory_id'";
$res_factorydata = mysql_query($sql_factorydata);
$num_factorydata = mysql_num_rows($res_factorydata);
if ($num_factorydata > 0) {
$rec_factorydata = mysql_fetch_array($res_factorydata);
$steel_investment = $rec_factorydata['steel_investment'];
$crystal_investment = $rec_factorydata['crystal_investment'];
$erbium_investment = $rec_factorydata['erbium_investment'];
} else {
$steel_investment = 0;
$crystal_investment = 0;
$erbium_investment = 0;
}
}
