function Trade_Ress() { global $game, $db, $ACTUAL_TICK; /* [22:07:05] <TotesTAP> [02:46] <rmA> 1 : 4 : 3 [22:07:05] <TotesTAP> [02:46] <rmA> Met : Min : Lat [22:07:08] <TotesTAP> [02:47] <rmA> bei 6h 50% steuern [22:07:08] <TotesTAP> [02:47] <rmA> bei 12h 35% steuern [22:07:08] <TotesTAP> [02:48] <rmA> bei 36h 15% steuern */ $game->out('<center><span class="sub_caption">' . constant($game->sprache("TEXT144")) . ' ' . HelpPopup('trade_ress') . ' :</span></center><br>'); if (isset($_POST['bezahlungsart'])) { $_POST['bezahlungsart'] = (int) $_POST['bezahlungsart']; } /* if(isset($_POST['plani_ziel'])) $_POST['plani_ziel']=(int)$_POST['plani_ziel']; if(isset($_POST['plani'])) $_POST['plani']=(int)$_POST['plani']; */ /* if(isset($_POST['Art'])) if($_POST['Art']!="Metall" && $_POST['Art']!="Latinum" && $_POST['Art']!="Mineral") { message(NOTICE, constant($game->sprache("TEXT145"))); } */ /* $daten=$db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1'); // 27/02/08 - AC: Check DB query if($daten == null) { $daten['ress_1'] = 0; $daten['ress_2'] = 0; $daten['ress_3'] = 0; } */ /* 04/03/08 - AC: If step is not specified, it si frist step */ if (!isset($_REQUEST['step'])) { $_REQUEST['step'] = '1'; } if (isset($_REQUEST['handel']) && $_REQUEST['handel'] == 'trade_ress' && isset($_POST['plani']) && $_REQUEST['step'] == '2') { /* 01/03/08 - AC: Check this value */ if (!isset($_POST['plani_ziel'])) { $_POST['plani_ziel'] = 0; } $plani_id_a = $db->queryrow('SELECT planet_id,planet_name FROM `planets` WHERE planet_id=' . decode_planet_id($_POST['plani_ziel']) . ' AND planet_owner=' . $game->player['user_id'] . ''); $plani_id_r = $db->queryrow('SELECT planet_id,planet_name FROM `planets` WHERE planet_id=' . decode_planet_id($_POST['plani']) . ' AND planet_owner=' . $game->player['user_id'] . ''); if ($plani_id_a['planet_id'] != decode_planet_id($_POST['plani_ziel']) || $plani_id_r['planet_id'] != decode_planet_id($_POST['plani'])) { $game->out(constant($game->sprache("TEXT146"))); } else { $kosten['Metall'] = 0; $kosten['Mineral'] = 0; $kosten['Latinum'] = 0; if ($_POST['transport'] != 1 && $_POST['transport'] != 2 && $_POST['transport'] != 3) { $game->out('Cheat'); exit; } if ($_POST['transport'] == 1) { $transportsatz = 0.5; $tickzeit = 20 * 6; } if ($_POST['transport'] == 2) { $transportsatz = 0.35; $tickzeit = 20 * 12; } if ($_POST['transport'] == 3) { $transportsatz = 0.15; $tickzeit = 20 * 36; } $daten = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1'); /* 27/02/08 - AC: Check DB query */ if ($daten == null) { $daten['ress_1'] = 0; $daten['ress_2'] = 0; $daten['ress_3'] = 0; } // DC --- Vediamo di compattare un poco il codice $db->lock('FHB_Handels_Lager', 'scheduler_resourcetrade'); $plani_inhalt = $db->queryrow('SELECT resource_1,resource_2,resource_3 FROM `planets` WHERE planet_id=' . decode_planet_id($_POST['plani']) . ' AND planet_owner=' . $game->player['user_id'] . ''); if ($_POST['risorsa_da'] == "Metall" && $_POST['risorsa_a'] == "Mineral") { $kosten['Mineral'] = (int) ($_POST['Qty'] * Ress_price(10, 9)); if ($_POST['Qty'] <= $plani_inhalt['resource_1']) { $steuern = (int) ($kosten['Mineral'] * $transportsatz); if ($daten['ress_2'] >= $kosten['Mineral'] - $steuern) { // dem user Ressourcen abziehen: if ($db->query('UPDATE planets SET resource_1=resource_1-' . $_POST['Qty'] . ' WHERE planet_id=' . decode_planet_id($_POST['plani']) . '') == true) { // dem NPC Ressourcen abziehen: if ($db->query('UPDATE FHB_Handels_Lager SET ress_2=ress_2-' . $kosten['Mineral'] . '+' . $steuern . ',ress_1=ress_1+' . $_POST['Qty'] . ' WHERE id=1') == true) { // Buyers goods in the Trade Register Scheduler: if ($db->query('INSERT INTO scheduler_resourcetrade (planet,resource_1,resource_2,resource_3,arrival_time) VALUES ("' . decode_planet_id($_POST['plani_ziel']) . '",0,' . ($kosten['Mineral'] - $steuern) . ',0,"' . ($ACTUAL_TICK + $tickzeit) . '")') == true) { $game->out('<table><tr><td>' . constant($game->sprache("TEXT147")) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT148")) . $plani_id_a['planet_name'] . '</td></tr> <tr><td>' . constant($game->sprache("TEXT149")) . $steuern . '</td></tr> <tr><td>' . constant($game->sprache("TEXT150")) . ($kosten['Mineral'] - $steuern) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT151")) . $_POST['Qty'] . '</td></tr> <tr><td><form name="ritorno" action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=trade_ress') . '" method="post"> <input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>'); } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(NOTICE, constant($game->sprache("TEXT153"))); } } else { message(NOTICE, constant($game->sprache("TEXT158"))); } } else { if ($_POST['risorsa_da'] == "Metall" && $_POST['risorsa_a'] == "Latinum") { $kosten['Latinum'] = (int) ($_POST['Qty'] * Ress_price(11, 9)); if ($_POST['Qty'] <= $plani_inhalt['resource_1']) { $steuern = (int) ($kosten['Latinum'] * $transportsatz); if ($daten['ress_3'] >= $kosten['Latinum'] - $steuern) { // dem user Ressourcen abziehen: if ($db->query('UPDATE planets SET resource_1=resource_1-' . $_POST['Qty'] . ' WHERE planet_id=' . decode_planet_id($_POST['plani']) . '') == true) { // dem NPC Ressourcen abziehen: if ($db->query('UPDATE FHB_Handels_Lager SET ress_3=ress_3-' . $kosten['Latinum'] . '+' . $steuern . ',ress_1=ress_1+' . $_POST['Qty'] . ' WHERE id=1') == true) { // Buyers goods in the Trade Register Scheduler: if ($db->query('INSERT INTO scheduler_resourcetrade (planet,resource_1,resource_2,resource_3,arrival_time) VALUES ("' . decode_planet_id($_POST['plani_ziel']) . '",0,0,' . ($kosten['Latinum'] - $steuern) . ',"' . ($ACTUAL_TICK + $tickzeit) . '")') == true) { $game->out('<table><tr><td>' . constant($game->sprache("TEXT147")) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT148")) . $plani_id_a['planet_name'] . '</td></tr> <tr><td>' . constant($game->sprache("TEXT149")) . $steuern . '</td></tr> <tr><td>' . constant($game->sprache("TEXT156")) . ($kosten['Latinum'] - $steuern) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT151")) . $_POST['Qty'] . '</td></tr> <tr><td><form name="ritorno" action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=trade_ress') . '" method="post"> <input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>'); } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(NOTICE, constant($game->sprache("TEXT153"))); } } else { message(NOTICE, constant($game->sprache("TEXT158"))); } } else { if ($_POST['risorsa_da'] == "Mineral" && $_POST['risorsa_a'] == "Metall") { $kosten['Metall'] = (int) ($_POST['Qty'] * Ress_price(9, 10)); if ($_POST['Qty'] <= $plani_inhalt['resource_2']) { $steuern = (int) ($kosten['Metall'] * $transportsatz); if ($daten['ress_1'] >= $kosten['Metall'] - $steuern) { // dem user Ressourcen abziehen: if ($db->query('UPDATE planets SET resource_2=resource_2-' . $_POST['Qty'] . ' WHERE planet_id=' . decode_planet_id($_POST['plani']) . '') == true) { // dem NPC Ressourcen abziehen: if ($db->query('UPDATE FHB_Handels_Lager SET ress_1=ress_1-' . $kosten['Metall'] . '+' . $steuern . ',ress_2=ress_2+' . $_POST['Qty'] . ' WHERE id=1') == true) { // Buyers goods in the Trade Register Scheduler: if ($db->query('INSERT INTO scheduler_resourcetrade (planet,resource_1,resource_2,resource_3,arrival_time) VALUES ("' . decode_planet_id($_POST['plani_ziel']) . '",' . ($kosten['Metall'] - $steuern) . ',0,0,"' . ($ACTUAL_TICK + $tickzeit) . '")') == true) { $game->out('<table><tr><td>' . constant($game->sprache("TEXT147")) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT148")) . $plani_id_a['planet_name'] . '</td></tr> <tr><td>' . constant($game->sprache("TEXT149")) . $steuern . '</td></tr> <tr><td>' . constant($game->sprache("TEXT154")) . ($kosten['Metall'] - $steuern) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT155")) . $_POST['Qty'] . '</td></tr> <tr><td><form name="ritorno" action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=trade_ress') . '" method="post"> <input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>'); } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(NOTICE, constant($game->sprache("TEXT153"))); } } else { message(NOTICE, constant($game->sprache("TEXT158"))); } } else { if ($_POST['risorsa_da'] == "Mineral" && $_POST['risorsa_a'] == "Latinum") { $kosten['Latinum'] = (int) ($_POST['Qty'] * Ress_price(11, 10)); if ($_POST['Qty'] <= $plani_inhalt['resource_2']) { $steuern = (int) ($kosten['Latinum'] * $transportsatz); if ($daten['ress_3'] >= $kosten['Latinum'] - $steuern) { // dem user Ressourcen abziehen: if ($db->query('UPDATE planets SET resource_2=resource_2-' . $_POST['Qty'] . ' WHERE planet_id=' . decode_planet_id($_POST['plani']) . '') == true) { // dem NPC Ressourcen abziehen: if ($db->query('UPDATE FHB_Handels_Lager SET ress_3=ress_3-' . $kosten['Latinum'] . '+' . $steuern . ',ress_2=ress_2+' . $_POST['Qty'] . ' WHERE id=1') == true) { // Buyers goods in the Trade Register Scheduler: if ($db->query('INSERT INTO scheduler_resourcetrade (planet,resource_1,resource_2,resource_3,arrival_time) VALUES ("' . decode_planet_id($_POST['plani_ziel']) . '",0,0,' . ($kosten['Latinum'] - $steuern) . ',"' . ($ACTUAL_TICK + $tickzeit) . '")') == true) { $game->out('<table><tr><td>' . constant($game->sprache("TEXT147")) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT148")) . $plani_id_a['planet_name'] . '</td></tr> <tr><td>' . constant($game->sprache("TEXT149")) . $steuern . '</td></tr> <tr><td>' . constant($game->sprache("TEXT156")) . ($kosten['Latinum'] - $steuern) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT155")) . $_POST['Qty'] . '</td></tr> <tr><td><form name="ritorno" action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=trade_ress') . '" method="post"> <input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>'); } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(NOTICE, constant($game->sprache("TEXT153"))); } } else { message(NOTICE, constant($game->sprache("TEXT158"))); } } else { if ($_POST['risorsa_da'] == "Latinum" && $_POST['risorsa_a'] == "Metall") { $kosten['Metall'] = (int) ($_POST['Qty'] * Ress_price(9, 11)); if ($_POST['Qty'] <= $plani_inhalt['resource_3']) { $steuern = (int) ($kosten['Metall'] * $transportsatz); if ($daten['ress_1'] >= $kosten['Metall'] - $steuern) { // dem user Ressourcen abziehen: if ($db->query('UPDATE planets SET resource_3=resource_3-' . $_POST['Qty'] . ' WHERE planet_id=' . decode_planet_id($_POST['plani']) . '') == true) { // dem NPC Ressourcen abziehen: if ($db->query('UPDATE FHB_Handels_Lager SET ress_1=ress_1-' . $kosten['Metall'] . '+' . $steuern . ',ress_3=ress_3+' . $_POST['Qty'] . ' WHERE id=1') == true) { // Buyers goods in the Trade Register Scheduler: if ($db->query('INSERT INTO scheduler_resourcetrade (planet,resource_1,resource_2,resource_3,arrival_time) VALUES ("' . decode_planet_id($_POST['plani_ziel']) . '",' . ($kosten['Metall'] - $steuern) . ',0,0,"' . ($ACTUAL_TICK + $tickzeit) . '")') == true) { $game->out('<table><tr><td>' . constant($game->sprache("TEXT147")) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT148")) . $plani_id_a['planet_name'] . '</td></tr> <tr><td>' . constant($game->sprache("TEXT149")) . $steuern . '</td></tr> <tr><td>' . constant($game->sprache("TEXT154")) . ($kosten['Metall'] - $steuern) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT157")) . $_POST['Qty'] . '</td></tr> <tr><td><form name="ritorno" action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=trade_ress') . '" method="post"> <input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>'); } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(NOTICE, constant($game->sprache("TEXT153"))); } } else { message(NOTICE, constant($game->sprache("TEXT158"))); } } else { if ($_POST['risorsa_da'] == "Latinum" && $_POST['risorsa_a'] == "Mineral") { $kosten['Mineral'] = (int) ($_POST['Qty'] * Ress_price(10, 11)); if ($_POST['Qty'] <= $plani_inhalt['resource_3']) { $steuern = (int) ($kosten['Mineral'] * $transportsatz); if ($daten['ress_2'] >= $kosten['Mineral'] - $steuern) { // dem user Ressourcen abziehen: if ($db->query('UPDATE planets SET resource_3=resource_3-' . $_POST['Qty'] . ' WHERE planet_id=' . decode_planet_id($_POST['plani']) . '') == true) { // dem NPC Ressourcen abziehen: if ($db->query('UPDATE FHB_Handels_Lager SET ress_2=ress_2-' . $kosten['Mineral'] . '+' . $steuern . ',ress_3=ress_3+' . $_POST['Qty'] . ' WHERE id=1') == true) { // Buyers goods in the Trade Register Scheduler: if ($db->query('INSERT INTO scheduler_resourcetrade (planet,resource_1,resource_2,resource_3,arrival_time) VALUES ("' . decode_planet_id($_POST['plani_ziel']) . '",0,' . ($kosten['Mineral'] - $steuern) . ',0,"' . ($ACTUAL_TICK + $tickzeit) . '")') == true) { $game->out('<table><tr><td>' . constant($game->sprache("TEXT147")) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT148")) . $plani_id_a['planet_name'] . '</td></tr> <tr><td>' . constant($game->sprache("TEXT149")) . $steuern . '</td></tr> <tr><td>' . constant($game->sprache("TEXT150")) . ($kosten['Mineral'] - $steuern) . '</td></tr> <tr><td>' . constant($game->sprache("TEXT157")) . $_POST['Qty'] . '</td></tr> <tr><td><form name="ritorno" action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=trade_ress') . '" method="post"> <input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>'); } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(DATABASE_ERROR, 'Internal database error'); } } else { message(NOTICE, constant($game->sprache("TEXT153"))); } } else { message(NOTICE, constant($game->sprache("TEXT158"))); } } } } } } } $db->unlock('FHB_Handels_Lager', 'scheduler_resourcetrade'); } } else { $ressavail = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1'); if ($ressavail == null) { $ressavail['ress_1'] = 0; $ressavail['ress_2'] = 0; $ressavail['ress_3'] = 0; } $game->out(' <script type="text/javascript"> function check_exchange(){ if(document.ScambioRisorse.risorsa_da.value == document.ScambioRisorse.risorsa_a.value) { alert("' . constant($game->sprache("TEXT278")) . '"); document.ScambioRisorse.risorsa_da.value = "Metall"; document.ScambioRisorse.risorsa_a.value = "Mineral"; document.ScambioRisorse.Qty.value = 0; document.ScambioRisorse.Result.value = 0; } } function display_rateo() { var res_from, res_to,value_from, value_to, rateo; res_from = document.ScambioRisorse.risorsa_da.value; res_to = document.ScambioRisorse.risorsa_a.value; if(res_from == "Metall") value_from = 4; if(res_from == "Mineral") value_from = 5; if(res_from == "Latinum") value_from = 2.8; if(res_to == "Metall") value_to = 4; if(res_to == "Mineral") value_to = 5; if(res_to == "Latinum") value_to = 2.8; rateo = Math.round((1 / value_from * value_to) * 100) / 100; document.ScambioRisorse.Rateo.value = rateo; } function display_avail() { if(document.ScambioRisorse.risorsa_a.value == "Metall") { document.ScambioRisorse.Avail.value = document.ScambioRisorse.Ress_Avail_1.value; } if(document.ScambioRisorse.risorsa_a.value == "Mineral") { document.ScambioRisorse.Avail.value = document.ScambioRisorse.Ress_Avail_2.value; } if(document.ScambioRisorse.risorsa_a.value == "Latinum") { document.ScambioRisorse.Avail.value = document.ScambioRisorse.Ress_Avail_3.value; } } function recompute(){ var res_from, res_to, quantity = 0, exchanged = 0, tax; var tax_rate = new Array(0, 0.50, 0.65, 0.85); // Exchange rates: Metall; Minerals; Latinum => 4 ; 5 ; 2.8 res_from = document.ScambioRisorse.risorsa_da.value; res_to = document.ScambioRisorse.risorsa_a.value; quantity = document.ScambioRisorse.Qty.value; tax = document.ScambioRisorse.transport.value; if(res_from == "Metall") { if(res_to == "Mineral") { exchanged = Math.round((quantity / 4 * 5) * tax_rate[tax]); } if(res_to == "Latinum") { exchanged = Math.round((quantity / 4 * 2.8) * tax_rate[tax]); } } if(res_from == "Mineral") { if(res_to == "Metall") { exchanged = Math.round((quantity / 5 * 4) * tax_rate[tax]); } if(res_to == "Latinum") { exchanged = Math.round((quantity / 5 * 2.8) * tax_rate[tax]); } } if(res_from == "Latinum") { if(res_to == "Metall") { exchanged = Math.round((quantity / 2.8 * 4) * tax_rate[tax]); } if(res_to == "Mineral") { exchanged = Math.round((quantity / 2.8 * 5) * tax_rate[tax]); } } display_avail(); document.ScambioRisorse.Result.value = exchanged; if(exchanged > document.ScambioRisorse.Avail.value) document.ScambioRisorse.submit.disabled = true; else document.ScambioRisorse.submit.disabled = false; } </script> '); $game->out('<form name="ScambioRisorse" action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=trade_ress&step=2') . '" method="post">'); $game->out('<input type="hidden" name="Ress_Avail_1" value="' . $ressavail['ress_1'] . '"> <input type="hidden" name="Ress_Avail_2" value="' . $ressavail['ress_2'] . '"> <input type="hidden" name="Ress_Avail_3" value="' . $ressavail['ress_3'] . '"> '); $game->out('<table align=center> <tr> <td>' . constant($game->sprache("TEXT159")) . '</td> <td>: <select size="1" name="risorsa_da" onchange="display_rateo(); document.ScambioRisorse.Result.value = 0; document.ScambioRisorse.Qty.value = 0;"> <option value="Metall" selected>' . constant($game->sprache("TEXT123")) . '</option> <option value="Mineral">' . constant($game->sprache("TEXT165")) . '</option> <option value="Latinum">' . constant($game->sprache("TEXT167")) . '</option> </select> ==> <input name="Rateo" type="number" value="1.25" size="3" class="Field_nosize" readonly> ==> <select size="1" name="risorsa_a" onchange="display_rateo(); document.ScambioRisorse.Result.value = 0; document.ScambioRisorse.Qty.value = 0; display_avail();"> <option value="Metall">' . constant($game->sprache("TEXT123")) . '</option> <option value="Mineral" selected>' . constant($game->sprache("TEXT165")) . '</option> <option value="Latinum">' . constant($game->sprache("TEXT167")) . '</option> </select> </td> </tr> '); $game->out('<tr> <td>' . constant($game->sprache("TEXT276")) . '</td> <td>: <input name="Qty" type="number" value="0" class="Field_nosize" onchange="check_exchange(); recompute();"></td> </tr> '); $game->out('<tr> <td>' . constant($game->sprache("TEXT173")) . '</td> <td>: <select size="1" name="transport" onchange="recompute();"> <option value="1">' . constant($game->sprache("TEXT174")) . '</option> <option value="2">' . constant($game->sprache("TEXT175")) . '</option> <option value="3">' . constant($game->sprache("TEXT176")) . '</option> </select> </td> </tr> '); $game->out('<tr> <td>' . constant($game->sprache("TEXT277")) . '</td> <td>: <input name="Result" type="number" value="0" class="Field_nosize" disabled> ' . constant($game->sprache("TEXT245")) . ' <input name="Avail" type="number" value="' . $ressavail['ress_2'] . '" class="Field_nosize" disabled><td> </tr> '); $sql = 'SELECT planet_id,planet_name,building_11 FROM `planets` WHERE planet_owner=' . $game->player['user_id'] . ' ORDER BY planet_name ASC'; if (($planis = $db->query($sql)) == false) { $game->out(constant($game->sprache("TEXT178"))); } else { $game->out('<tr><td width="150">' . constant($game->sprache("TEXT179")) . '</td><td>: <select size="1" name="plani">'); while ($planeten = $db->fetchrow($planis)) { if ($planeten['building_11'] > 0) { if ($game->planet['planet_id'] == $planeten['planet_id']) { $game->out('<option value="' . encode_planet_id($planeten['planet_id']) . '" selected="selected">' . $planeten['planet_name'] . '</option>'); } else { $game->out('<option value="' . encode_planet_id($planeten['planet_id']) . '">' . $planeten['planet_name'] . '</option>'); } } } $game->out('</select></td></tr>'); } if (($planis = $db->query($sql)) == false) { $game->out(constant($game->sprache("TEXT178"))); } else { $game->out('<tr><td width="150">' . constant($game->sprache("TEXT180")) . '</td><td>: <select size="1" name="plani_ziel">'); while ($planeten = $db->fetchrow($planis)) { if ($planeten['building_11'] > 0) { if ($game->planet['planet_id'] == $planeten['planet_id']) { $game->out('<option value="' . encode_planet_id($planeten['planet_id']) . '" selected="selected">' . $planeten['planet_name'] . '</option>'); } else { $game->out('<option value="' . encode_planet_id($planeten['planet_id']) . '">' . $planeten['planet_name'] . '</option>'); } } } $game->out('</select></td></tr>'); } $game->out('<tr><td colspan="3" align="center"><input type="submit" value="' . constant($game->sprache("TEXT185")) . '" name="submit" class="Button_nosize" disabled></td></tr>'); $game->out('</table></form>'); } }
FROM (planets p, starsystems s) WHERE s.sector_id = ' . $sector_id . ' AND s.system_x = ' . $system_x . ' AND s.system_y = ' . $system_y . ' AND p.system_id = s.system_id AND p.planet_distance_id = ' . $distance_id; if (($planet = $db->queryrow($sql)) === false) { message(DATABASE_ERROR, 'Could not query planets data'); } if (empty($planet['planet_id'])) { message(NOTICE, constant($game->sprache("TEXT11")) . ' <b>' . $_POST['dest_coord'] . '</b>'); } $dest = (int) $planet['planet_id']; } else { if (!empty($_POST['dest'])) { $dest = is_numeric($_POST['dest']) ? (int) $_POST['dest'] : decode_planet_id($_POST['dest']); } } if (empty($dest)) { message(NOTICE, constant($game->sprache("TEXT12"))); } // ############################################################################# // Fetch start planet data if ($start == $game->planet['planet_id']) { $start_planet = $game->planet; $start_planet['user_id'] = $game->player['user_id']; $start_planet['user_name'] = $game->player['user_name']; $start_planet['user_attack_protection'] = $game->player['user_attack_protection']; $start_planet['user_vacation_start'] = $game->player['user_vacation_start']; $start_planet['user_vacation_end'] = $game->player['user_vacation_end']; // Player data can not be fetched, because they are not displayed / used
case 2: $selection = 2; break; case 3: $selection = 3; break; case 4: $selection = 4; break; default: $selection = 1; } } else { $selection = 1; } $detail_id = decode_planet_id(filter_input(INPUT_GET, 'detail', FILTER_SANITIZE_STRING)); if (isset($detail_id) && !empty($detail_id)) { $sub_action = constant($game->sprache("TEXT30")); } if (!isset($sub_action) || empty($sub_action)) { $sub_action = filter_input(INPUT_POST, 'step', FILTER_SANITIZE_STRING); if (!isset($sub_action) || empty($sub_action)) { $sub_action = constant($game->sprache("TEXT1")); } } $game->out('<span class="caption">' . constant($game->sprache("TEXT0")) . '</span><br><br>'); $game->out(' <table class="style_outer" width="90%" align="center" border="0" cellpadding="2" cellspacing="2"><tr><td> <table class="style_inner" width="100%" align="center" border="0" cellpadding="2" cellspacing="2"> <form method="post" action="' . parse_link('a=settlers') . '"> <tr>
<br><br> ' . constant($game->sprache("TEXT54")) . ' <b>' . (15 - $n_cmemo) . '</b> / <b>15</b><br><br> ' . constant($game->sprache("TEXT55")) . ' <input class="field" type="text" name="memo_name" value=""><br><br> '); while ($cmemo = $db->fetchrow($q_cmemo)) { $game->out('<input type="radio" name="memo_entry" value="' . $cmemo['tcm_id'] . '"> ' . $cmemo['memo_name'] . ' [<a href="' . parse_link('a=tactical_cartography&memo_delete=' . $cmemo['tcm_id']) . '">' . constant($game->sprache("TEXT56")) . '</a>]<br><br>'); } if ($n_cmemo < 15) { $game->out('<input type="radio" name="memo_entry" value="-1" checked="checked"> <i>' . constant($game->sprache("TEXT57")) . '<i><br><br>'); } $game->out('<br><input class="button" type="submit" name="memo_add" value="' . constant($game->sprache("TEXT58")) . '"></td></tr></form></table></td></tr></table>'); } elseif (!empty($_GET['planet_id'])) { if (is_numeric($_GET['planet_id'])) { die(constant($game->sprache("TEXT59"))); } else { $planet_id = (int) decode_planet_id($_GET['planet_id']); } $own_planet = $free_planet = false; if ($game->planet['planet_id'] == $planet_id) { $planet =& $game->planet; $sql = 'SELECT system_id, system_name, system_x, system_y FROM starsystems WHERE system_id = ' . $planet['system_id']; if (($_system = $db->queryrow($sql)) === false) { message(DATABASE_ERROR, 'Could not query starsystem data'); } if (empty($_system['system_id'])) { message(NOTICE, constant($game->sprache("TEXT41")) . $planet['system_id'] . constant($game->sprache("TEXT42"))); } $planet += $_system; } else {
<td><input type="text" name="pos_home_all" class="field"></td><td><input type="submit" name="mass_save" value="' . constant($game->sprache("TEXT63")) . '" class="button"></td> </tr> </table></td></tr> </table> </td></tr></table> </form> '); } else { $game->out(constant($game->sprache("TEXT64"))); } } else { $only_location = 0; if (!empty($_GET['only_location'])) { $only_location = is_numeric($_GET['only_location']) ? (int) $_GET['only_location'] : decode_planet_id($_GET['only_location']); } $order_by = !empty($_GET['order_by']) ? (int) $_GET['order_by'] : 0; if ($order_by < 0 || $order_by > 3) { message(NOTICE, 'No bad attempt...'); } if ($only_location > 0) { switch ($order_by) { case 0: $order_by_str = 'fleet_name ASC'; break; case 1: $order_by_str = 'fleet_name ASC'; break; case 2: $order_by_str = 'n_ships ASC';