<span class="caption">' . constant($game->sprache("TEXT5")) . '</span><br><br> <table width="450" border="0" align="center"> <tr> <td>' . constant($game->sprache("TEXT6")) . '<br>' . constant($game->sprache("TEXT7")) . '<br>' . constant($game->sprache("TEXT8")) . ' ' . (round($game->planet['unit_1'] * 2 + $game->planet['unit_2'] * 3 + $game->planet['unit_3'] * 4 + $game->planet['unit_4'] * 4, 0) < $game->planet['min_troops_required'] ? '<br><u>' . constant($game->sprache("TEXT9")) . round(100 * round($game->planet['unit_1'] * 2 + $game->planet['unit_2'] * 3 + $game->planet['unit_3'] * 4 + $game->planet['unit_4'] * 4, 0) / $game->planet['min_troops_required'], 0) . '%</b> ' . constant($game->sprache("TEXT10")) . '</u>' : '') . ' </td> </tr> </table> <br><br> <table width="450" align="center" border="0" cellpadding="1" cellspacing="1" class="style_outer"><tr><td> <table width="450" align="center" border="0" cellpadding="2" cellspacing="2" class="style_inner"> <form name="metal_form" method="post" action="' . parse_link('a=mines') . '" onSubmit="return deactivate_buttons();"> <tr> <td width="350"><b>' . $BUILDING_NAME[$game->player['user_race']][1] . '</b> (<img src="' . $game->GFX_PATH . 'menu_metal_small.gif"> <b>' . ($ress_tax != 0 ? '' . $ress_tax * ResourcesPerTickMetal() . '' : '' . ResourcesPerTickMetal() . '') . '</b> <i>' . constant($game->sprache("TEXT11")) . '</i> / <b>' . ($ress_tax != 0 ? '' . $ress_tax * ResourcesPerHourMetal() . '' : '' . ResourcesPerHourMetal() . '') . '</b> <i>' . constant($game->sprache("TEXT12")) . '</i>)</td> <td width="100" rowspan="2" align="center" valign="middle"><input class="button" type="submit" name="submit" value="' . constant($game->sprache("TEXT13")) . '"></td> </tr> <tr> <td width="300">' . constant($game->sprache("TEXT14")) . ' <select name="worker">' . $metal_option_html . '</select></td> </tr> <input type="hidden" name="type" value="1"> </form> </table> </td></tr></table> <br><br> <table width="450" align="center" border="0" cellpadding="1" cellspacing="1" class="style_outer"><tr><td> <table width="450" align="center" border="0" cellpadding="2" cellspacing="2" class="style_inner"> <form name="minerals_form" method="post" action="' . parse_link('a=mines') . '" onSubmit="return deactivate_buttons();"> <tr> <td width="350"><b>' . $BUILDING_NAME[$game->player['user_race']][2] . '</b> (<img src="' . $game->GFX_PATH . 'menu_mineral_small.gif"> <b>' . ($ress_tax != 0 ? '' . $ress_tax * ResourcesPerTickMineral() . '' : '' . ResourcesPerTickMineral() . '') . '</b> <i>' . constant($game->sprache("TEXT11")) . '</i> / <b>' . ($ress_tax != 0 ? '' . $ress_tax * ResourcesPerHourMineral() . '' : '' . ResourcesPerHourMineral() . '') . '</b> <i>' . constant($game->sprache("TEXT12")) . '</i>)</td>
// Recompute Static Planet Values $sdl->start_job('Recompute Static Planet Values'); $sql = 'SELECT p.*, u.user_id, u.user_race, u.user_vacation_start, u.user_vacation_end FROM (planets p) LEFT join (user u) ON u.user_id = p.planet_owner WHERE p.recompute_static = 1'; if (($q_planets = $db->query($sql)) === false) { $sdl->log('<b>Error:</b> Could not query planets data to recompute static planet values! - SKIPPED'); } else { $n_recomputed = 0; while ($planet = $db->fetchrow($q_planets)) { if (empty($planet['user_id'])) { continue; } $add_1 = ResourcesPerTickMetal($planet); $add_2 = ResourcesPerTickMineral($planet); $add_3 = ResourcesPerTickLatinum($planet); $add_4 = $planet['rateo_4'] * $RACE_DATA[$planet['user_race']][12] + $planet['research_1'] * $RACE_DATA[$planet['user_race']][20] * 0.1 + $planet['research_2'] * $RACE_DATA[$planet['user_race']][20] * 0.2; if ($ACTUAL_TICK >= $planet['user_vacation_start'] && $ACTUAL_TICK <= $planet['user_vacation_end']) { $add_1 *= 0.2; $add_2 *= 0.2; $add_3 *= 0.2; $add_4 *= 0.2; } $sql = 'UPDATE planets SET add_1 = ' . $add_1 . ', add_2 = ' . $add_2 . ', add_3 = ' . $add_3 . ', add_4 = ' . $add_4 . ', recompute_static = 0,