function Trade_Sold_truppen()
{
global $db;
global $game, $ACTUAL_TICK;
$game->out('<center><span class="sub_caption">' . constant($game->sprache("TEXT186")) . ' ' . HelpPopup('trade_sold_truppen') . ' :</span></center><br>');
/*if($_POST['unit_1']==null || $_POST['unit_1']<0 )$_POST['unit_1']=0;
if($_POST['unit_2']==null || $_POST['unit_2']<0 )$_POST['unit_2']=0;
if($_POST['unit_3']==null || $_POST['unit_3']<0 )$_POST['unit_3']=0;
if($_POST['unit_4']==null || $_POST['unit_4']<0 )$_POST['unit_4']=0;
if($_POST['unit_5']==null || $_POST['unit_5']<0 )$_POST['unit_5']=0;
if($_POST['unit_6']==null || $_POST['unit_6']<0 )$_POST['unit_6']=0;*/
if (!isset($_POST['unit_1']) || $_POST['unit_1'] < 0) {
$_POST['unit_1'] = 0;
}
if (!isset($_POST['unit_2']) || $_POST['unit_2'] < 0) {
$_POST['unit_2'] = 0;
}
if (!isset($_POST['unit_3']) || $_POST['unit_3'] < 0) {
$_POST['unit_3'] = 0;
}
if (!isset($_POST['unit_4']) || $_POST['unit_4'] < 0) {
$_POST['unit_4'] = 0;
}
if (!isset($_POST['unit_5']) || $_POST['unit_5'] < 0) {
$_POST['unit_5'] = 0;
}
if (!isset($_POST['unit_6']) || $_POST['unit_6'] < 0) {
$_POST['unit_6'] = 0;
}
$_POST['unit_1'] = (int) $_POST['unit_1'];
$_POST['unit_2'] = (int) $_POST['unit_2'];
$_POST['unit_3'] = (int) $_POST['unit_3'];
$_POST['unit_4'] = (int) $_POST['unit_4'];
$_POST['unit_5'] = (int) $_POST['unit_5'];
$_POST['unit_6'] = (int) $_POST['unit_6'];
if (isset($_POST['plani_ziel'])) {
$_POST['plani_ziel'] = (int) $_POST['plani_ziel'];
}
if (isset($_POST['plani'])) {
$_POST['plani'] = (int) $_POST['plani'];
}
$daten = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1');
/* 27/02/08 - AC: Check DB query... */
if ($daten == null) {
$daten['unit_1'] = 0;
$daten['unit_2'] = 0;
$daten['unit_3'] = 0;
$daten['unit_4'] = 0;
$daten['unit_5'] = 0;
$daten['unit_6'] = 0;
$daten['ress_1'] = 0;
$daten['ress_2'] = 0;
$daten['ress_3'] = 0;
}
if (isset($_REQUEST['handel']) && $_REQUEST['handel'] == 'sold_truppen' && isset($_POST['plani']) && $_REQUEST['step'] == '3' && ($_POST['unit_1'] != 0 || $_POST['unit_2'] != 0 || $_POST['unit_3'] != 0 || $_POST['unit_4'] != 0 || $_POST['unit_5'] != 0 || $_POST['unit_6'] != 0)) {
$plani_id_a = $db->queryrow('SELECT planet_id,planet_name FROM `planets` WHERE 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=' . $_POST['plani'] . ' AND planet_owner=' . $game->player['user_id'] . '');
if ($plani_id_a['planet_id'] != $_POST['plani_ziel'] || $plani_id_r['planet_id'] != $_POST['plani']) {
$game->out(constant($game->sprache("TEXT146")));
} else {
$kosten['Metall'] = 0;
$kosten['Mineral'] = 0;
$kosten['gesamt'] = 0;
$kosten['Latinum'] = 0;
if ($_POST['unit_1'] != 0) {
$unit_1 = UnitPrice(0, 0);
$unit_2 = UnitPrice(0, 1);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_1'], "unit_1");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_1'], "unit_1");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'];
}
if ($_POST['unit_2'] != 0) {
$unit_1 = UnitPrice(1, 0);
$unit_2 = UnitPrice(1, 1);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_2'], "unit_2");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_2'], "unit_2");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'];
}
if ($_POST['unit_3'] != 0) {
$unit_1 = UnitPrice(2, 0);
$unit_2 = UnitPrice(2, 1);
$unit_3 = UnitPrice(2, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_3'], "unit_3");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_3'], "unit_3");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_3'], "unit_3");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
if ($_POST['unit_4'] != 0) {
$unit_1 = UnitPrice(3, 0);
$unit_2 = UnitPrice(3, 1);
$unit_3 = UnitPrice(3, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_4'], "unit_4");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_4'], "unit_4");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_4'], "unit_4");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
if ($_POST['unit_5'] != 0) {
$unit_1 = UnitPrice(4, 0);
$unit_2 = UnitPrice(4, 1);
$unit_3 = UnitPrice(4, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_5'], "unit_5");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_5'], "unit_5");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_5'], "unit_5");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
if ($_POST['unit_6'] != 0) {
$unit_1 = UnitPrice(5, 0);
$unit_2 = UnitPrice(5, 1);
$unit_3 = UnitPrice(5, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_6'], "unit_6");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_6'], "unit_6");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_6'], "unit_6");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
$kosten['gesamt'] = (int) $kosten['gesamt'];
$kosten['Metall'] = (int) $kosten['Metall'];
$kosten['Mineral'] = (int) $kosten['Mineral'];
$kosten['Latinum'] = (int) $kosten['Latinum'];
if ($_POST['transportsart'] != 1 && $_POST['transportsart'] != 2 && $_POST['transportsart'] != 3) {
$game->out('Cheat');
exit;
}
if ($_POST['transportsart'] == 1) {
$transportsatz = 0.3;
$tickzeit = 20 * 6;
}
if ($_POST['transportsart'] == 2) {
$transportsatz = 0.15;
$tickzeit = 20 * 12;
}
if ($_POST['transportsart'] == 3) {
$transportsatz = 0;
$tickzeit = 20 * 36;
}
$db->lock('FHB_Handels_Lager', 'scheduler_resourcetrade', 'FHB_handel_log', 'FHB_cache_trupp_trade');
$plani_inhalt = $db->queryrow('SELECT unit_1,unit_2,unit_3,unit_4,unit_5,unit_6 FROM `planets` WHERE planet_id=' . $_POST['plani'] . ' AND planet_owner=' . $game->player['user_id'] . '');
if ($_POST['bezahlungsart'] == 1 && isset($transportsatz) && $_POST['unit_1'] <= $plani_inhalt['unit_1'] && $_POST['unit_2'] <= $plani_inhalt['unit_2'] && $_POST['unit_3'] <= $plani_inhalt['unit_3'] && $_POST['unit_4'] <= $plani_inhalt['unit_4'] && $_POST['unit_5'] <= $plani_inhalt['unit_5'] && $_POST['unit_6'] <= $plani_inhalt['unit_6'] && $daten['ress_1'] >= $kosten['gesamt']) {
if ($transportsatz != 0) {
$steuern = (int) ($kosten['gesamt'] * $transportsatz);
} else {
$steuern = 0;
}
$daten = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1');
if ($daten['ress_1'] >= $kosten['gesamt']) {
// dem user Ressourcen abziehen:
if ($db->query('UPDATE planets SET unit_1=unit_1-' . $_POST['unit_1'] . ',unit_2=unit_2-' . $_POST['unit_2'] . ',unit_3=unit_3-' . $_POST['unit_3'] . ',unit_4=unit_4-' . $_POST['unit_4'] . ',unit_5=unit_5-' . $_POST['unit_5'] . ',unit_6=unit_6-' . $_POST['unit_6'] . ', resource_1=resource_1-' . $steuern . ' WHERE planet_id=' . $_POST['plani'] . '') == true) {
// dem NPC Ressourcen abziehen:
if ($db->query('UPDATE FHB_Handels_Lager SET ress_1=ress_1-' . $kosten['gesamt'] . '+' . $steuern . ' WHERE id=1') == true) {
$zufall_tick = mt_rand(23, 420);
$zufall_tick = $zufall_tick + $ACTUAL_TICK;
if ($db->query('INSERT INTO `FHB_cache_trupp_trade` (`unit_1` , `unit_2` , `unit_3` , `unit_4` , `unit_5` , `unit_6` , `tick` )
VALUES (' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ',' . $zufall_tick . ')') == 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 ("' . $_POST['plani_ziel'] . '",' . $kosten['gesamt'] . ',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("TEXT123")) . ':' . $kosten['gesamt'] . '</td></tr>
<tr><td><b>' . constant($game->sprache("TEXT187")) . '</b><br>Lv1:' . $_POST['unit_1'] . '<br>' . 'Lv2:' . $_POST['unit_2'] . '<br>Lv3:' . $_POST['unit_3'] . '<br>' . 'Lv4:' . $_POST['unit_4'] . '<br>Lv5:' . $_POST['unit_5'] . '<br>' . 'Lv6:' . $_POST['unit_6'] . '</td></tr>' . '<tr><td>' . '<form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen') . '" method="post">
<input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>');
$db->query('INSERT INTO FHB_handel_log VALUES (null,' . $game->player['user_race'] . ',1,' . $game->player['user_id'] . ',' . $ACTUAL_TICK . ',0,' . $_POST['transportsart'] . ',' . $kosten['gesamt'] . ',0,0,' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ')');
} else {
message(DATABASE_ERROR, 'Internal database error');
}
} 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")));
}
$db->unlock('FHB_Handels_Lager', 'scheduler_resourcetrade', 'FHB_handel_log', 'FHB_cache_trupp_trade');
} elseif ($_POST['bezahlungsart'] == 2 && isset($transportsatz) && $_POST['unit_1'] <= $plani_inhalt['unit_1'] && $_POST['unit_2'] <= $plani_inhalt['unit_2'] && $_POST['unit_3'] <= $plani_inhalt['unit_3'] && $_POST['unit_4'] <= $plani_inhalt['unit_4'] && $_POST['unit_5'] <= $plani_inhalt['unit_5'] && $_POST['unit_6'] <= $plani_inhalt['unit_6'] && $daten['ress_2'] >= $kosten['gesamt']) {
if ($transportsatz != 0) {
$steuern = (int) ($kosten['gesamt'] * $transportsatz);
} else {
$steuern = 0;
}
$daten = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1');
if ($daten['ress_2'] >= $kosten['gesamt']) {
if ($db->query('UPDATE planets SET unit_1=unit_1-' . $_POST['unit_1'] . ',unit_2=unit_2-' . $_POST['unit_2'] . ',unit_3=unit_3-' . $_POST['unit_3'] . ',unit_4=unit_4-' . $_POST['unit_4'] . ',unit_5=unit_5-' . $_POST['unit_5'] . ',unit_6=unit_6-' . $_POST['unit_6'] . ', resource_2=resource_2-' . $steuern . ' WHERE planet_id=' . $_POST['plani'] . '') == true) {
if ($db->query('UPDATE FHB_Handels_Lager SET ress_2=ress_2-' . $kosten['gesamt'] . '+' . $steuern . ' WHERE id=1') == true) {
$zufall_tick = mt_rand(23, 420);
$zufall_tick = $zufall_tick + $ACTUAL_TICK;
if ($db->query('INSERT INTO `FHB_cache_trupp_trade` (`unit_1` , `unit_2` , `unit_3` , `unit_4` , `unit_5` , `unit_6` , `tick` )
VALUES (' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ',' . $zufall_tick . ')') == 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 ("' . $_POST['plani_ziel'] . '",0,' . $kosten['gesamt'] . ',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>Mineral:' . $kosten['gesamt'] . '</td></tr>
<tr><td><b>' . constant($game->sprache("TEXT187")) . '</b><br>Lv1:' . $_POST['unit_1'] . '<br>' . 'Lv2:' . $_POST['unit_2'] . '<br>Lv3:' . $_POST['unit_3'] . '<br>' . 'Lv4:' . $_POST['unit_4'] . '<br>Lv5:' . $_POST['unit_5'] . '<br>' . 'Lv6:' . $_POST['unit_6'] . '</td></tr>' . '<tr><td>' . '<form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen') . '" method="post">
<input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>');
$db->query('INSERT INTO FHB_handel_log VALUES (null,' . $game->player['user_race'] . ',1,' . $game->player['user_id'] . ',' . $ACTUAL_TICK . ',1,' . $_POST['transportsart'] . ',0,' . $kosten['gesamt'] . ',0,' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ')');
} else {
message(DATABASE_ERROR, 'Internal database error');
}
} 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")));
}
$db->unlock('FHB_Handels_Lager', 'scheduler_resourcetrade', 'FHB_handel_log', 'FHB_cache_trupp_trade');
} elseif ($_POST['bezahlungsart'] == 3 && isset($transportsatz) && $_POST['unit_1'] <= $plani_inhalt['unit_1'] && $_POST['unit_2'] <= $plani_inhalt['unit_2'] && $_POST['unit_3'] <= $plani_inhalt['unit_3'] && $_POST['unit_4'] <= $plani_inhalt['unit_4'] && $_POST['unit_5'] <= $plani_inhalt['unit_5'] && $_POST['unit_6'] <= $plani_inhalt['unit_6'] && $daten['ress_3'] >= $kosten['gesamt']) {
if ($transportsatz != 0) {
$steuern = (int) ($kosten['gesamt'] * $transportsatz);
} else {
$steuern = 0;
}
$daten = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1');
if ($daten['ress_3'] >= $kosten['gesamt']) {
if ($db->query('UPDATE planets SET unit_1=unit_1-' . $_POST['unit_1'] . ',unit_2=unit_2-' . $_POST['unit_2'] . ',unit_3=unit_3-' . $_POST['unit_3'] . ',unit_4=unit_4-' . $_POST['unit_4'] . ',unit_5=unit_5-' . $_POST['unit_5'] . ',unit_6=unit_6-' . $_POST['unit_6'] . ', resource_3=resource_3-' . $steuern . ' WHERE planet_id=' . $_POST['plani'] . '') == true) {
// dem user Ressourcen abziehen:
if ($db->query('UPDATE FHB_Handels_Lager SET ress_3=ress_3+' . ($steuern - $kosten['gesamt']) . ' WHERE id=1') == true) {
$zufall_tick = mt_rand(23, 420);
$zufall_tick = $zufall_tick + $ACTUAL_TICK;
if ($db->query('INSERT INTO `FHB_cache_trupp_trade` (`unit_1` , `unit_2` , `unit_3` , `unit_4` , `unit_5` , `unit_6` , `tick` )
VALUES (' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ',' . $zufall_tick . ')') == 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 ("' . $_POST['plani_ziel'] . '",0,0,' . $kosten['gesamt'] . ',"' . ($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>Latinum:' . $kosten['gesamt'] . '</td></tr>
<tr><td><b>' . constant($game->sprache("TEXT187")) . '</b><br>Lv1:' . $_POST['unit_1'] . '<br>' . 'Lv2:' . $_POST['unit_2'] . '<br>Lv3:' . $_POST['unit_3'] . '<br>' . 'Lv4:' . $_POST['unit_4'] . '<br>Lv5:' . $_POST['unit_5'] . '<br>' . 'Lv6:' . $_POST['unit_6'] . '</td></tr>' . '<tr><td>' . '<form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen') . '" method="post">
<input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>');
$db->query('INSERT INTO FHB_handel_log VALUES (null,' . $game->player['user_race'] . ',1,' . $game->player['user_id'] . ',' . $ACTUAL_TICK . ',2,' . $_POST['transportsart'] . ',0,0,' . $kosten['gesamt'] . ',' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ')');
} else {
message(DATABASE_ERROR, 'Internal database error');
}
} 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")));
}
$db->unlock('FHB_Handels_Lager', 'scheduler_resourcetrade', 'FHB_handel_log', 'FHB_cache_trupp_trade');
} elseif ($_POST['bezahlungsart'] == 4 && isset($transportsatz) && $daten['ress_2'] >= $kosten['Mineral'] && $daten['ress_3'] >= $kosten['Latinum'] && $daten['ress_1'] >= $kosten['Metall'] && $_POST['unit_1'] <= $plani_inhalt['unit_1'] && $_POST['unit_2'] <= $plani_inhalt['unit_2'] && $_POST['unit_3'] <= $plani_inhalt['unit_3'] && $_POST['unit_4'] <= $plani_inhalt['unit_4'] && $_POST['unit_5'] <= $plani_inhalt['unit_5'] && $_POST['unit_6'] <= $plani_inhalt['unit_6']) {
if ($transportsatz != 0) {
$steuern['1'] = (int) ($kosten['Metall'] * $transportsatz);
$steuern['2'] = (int) ($kosten['Mineral'] * $transportsatz);
$steuern['3'] = (int) ($kosten['Latinum'] * $transportsatz);
} else {
$steuern['1'] = 0;
$steuern['2'] = 0;
$steuern['3'] = 0;
}
$daten = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1');
if ($daten['ress_1'] >= $kosten['Metall'] && $daten['ress_2'] >= $kosten['Mineral'] && $daten['ress_3'] >= $kosten['Latinum']) {
if ($db->query('UPDATE planets SET unit_1=unit_1-' . $_POST['unit_1'] . ',unit_2=unit_2-' . $_POST['unit_2'] . ',unit_3=unit_3-' . $_POST['unit_3'] . ',unit_4=unit_4-' . $_POST['unit_4'] . ',unit_5=unit_5-' . $_POST['unit_5'] . ',unit_6=unit_6-' . $_POST['unit_6'] . ',resource_1=resource_1-' . $steuern['1'] . ' ,resource_2=resource_2-' . $steuern['2'] . ',resource_3=resource_3-' . $steuern['3'] . ' WHERE planet_id=' . $_POST['plani'] . '') == true) {
// dem user Ressourcen abziehen:
if ($db->query('UPDATE FHB_Handels_Lager SET ress_1=ress_1-' . $kosten['Metall'] . '+' . $steuern['1'] . ',ress_2=ress_2-' . $kosten['Mineral'] . '+' . $steuern['2'] . ',ress_3=ress_3-' . $kosten['Latinum'] . '+' . $steuern['3'] . ' WHERE id=1') == true) {
$zufall_tick = mt_rand(23, 420);
$zufall_tick = $zufall_tick + $ACTUAL_TICK;
if ($db->query('INSERT INTO `FHB_cache_trupp_trade` (`unit_1` , `unit_2` , `unit_3` , `unit_4` , `unit_5` , `unit_6` , `tick` )
VALUES (' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ',' . $zufall_tick . ')') == 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 ("' . $_POST['plani_ziel'] . '",' . $kosten['Metall'] . ',' . $kosten['Mineral'] . ',' . $kosten['Latinum'] . ',"' . ($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("TEXT123")) . ':' . $kosten['Metall'] . '<br>Mineral:' . $kosten['Mineral'] . '<br>Latinum:' . $kosten['Latinum'] . '</td></tr>
<tr><td><b>' . constant($game->sprache("TEXT187")) . '</b><br>Lv1:' . $_POST['unit_1'] . '<br>' . 'Lv2:' . $_POST['unit_2'] . '<br>Lv3:' . $_POST['unit_3'] . '<br>' . 'Lv4:' . $_POST['unit_4'] . '<br>Lv5:' . $_POST['unit_5'] . '<br>' . 'Lv6:' . $_POST['unit_6'] . '</td></tr>' . '<tr><td>' . '<form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen') . '" method="post">
<input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></form></td></tr></table>');
$db->query('INSERT INTO FHB_handel_log VALUES (null,' . $game->player['user_race'] . ',1,' . $game->player['user_id'] . ',' . $ACTUAL_TICK . ',3,' . $_POST['transportsart'] . ',' . $kosten['Metall'] . ',' . $kosten['Mineral'] . ',' . $kosten['Latinum'] . ',' . $_POST['unit_1'] . ',' . $_POST['unit_2'] . ',' . $_POST['unit_3'] . ',' . $_POST['unit_4'] . ',' . $_POST['unit_5'] . ',' . $_POST['unit_6'] . ')');
} else {
message(DATABASE_ERROR, 'Internal database error');
}
} 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")));
}
$db->unlock('FHB_Handels_Lager', 'scheduler_resourcetrade', 'FHB_handel_log', 'FHB_cache_trupp_trade');
} else {
$game->out(constant($game->sprache("TEXT188")));
$db->unlock('FHB_Handels_Lager', 'scheduler_resourcetrade', 'FHB_cache_trupp_trade');
$game->out('<table><form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen&step=2') . '" method="post"><tr><td colspan=2>');
$game->out('<input type="hidden" name="unit_1" value="' . $_POST['unit_1'] . '">');
$game->out('<input type="hidden" name="unit_2" value="' . $_POST['unit_2'] . '">');
$game->out('<input type="hidden" name="unit_3" value="' . $_POST['unit_3'] . '">');
$game->out('<input type="hidden" name="unit_4" value="' . $_POST['unit_4'] . '">');
$game->out('<input type="hidden" name="unit_5" value="' . $_POST['unit_5'] . '">');
$game->out('<input type="hidden" name="unit_6" value="' . $_POST['unit_6'] . '">');
$game->out('<input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></td></tr></form></table>');
}
}
} elseif (isset($_REQUEST['handel']) && $_REQUEST['handel'] == 'sold_truppen' && isset($_REQUEST['step']) && $_REQUEST['step'] == '2' && ($_POST['unit_1'] != 0 || $_POST['unit_2'] != 0 || $_POST['unit_3'] != 0 || $_POST['unit_4'] != 0 || $_POST['unit_5'] != 0 || $_POST['unit_6'] != 0) && !($_POST['unit_1'] == 0 && $_POST['unit_2'] == 0 && $_POST['unit_3'] == 0 && $_POST['unit_4'] == 0 && $_POST['unit_5'] == 0 && $_POST['unit_6'] == 0)) {
$kosten['Metall'] = 0;
$kosten['Mineral'] = 0;
$kosten['gesamt'] = 0;
$kosten['Latinum'] = 0;
if ($_POST['unit_1'] != 0) {
$unit_1 = UnitPrice(0, 0);
$unit_2 = UnitPrice(0, 1);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_1'], "unit_1");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_1'], "unit_1");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'];
}
if ($_POST['unit_2'] != 0) {
$unit_1 = UnitPrice(1, 0);
$unit_2 = UnitPrice(1, 1);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_2'], "unit_2");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_2'], "unit_2");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'];
}
if ($_POST['unit_3'] != 0) {
$unit_1 = UnitPrice(2, 0);
$unit_2 = UnitPrice(2, 1);
$unit_3 = UnitPrice(2, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_3'], "unit_3");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_3'], "unit_3");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_3'], "unit_3");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
if ($_POST['unit_4'] != 0) {
$unit_1 = UnitPrice(3, 0);
$unit_2 = UnitPrice(3, 1);
$unit_3 = UnitPrice(3, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_4'], "unit_4");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_4'], "unit_4");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_4'], "unit_4");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
if ($_POST['unit_5'] != 0) {
$unit_1 = UnitPrice(4, 0);
$unit_2 = UnitPrice(4, 1);
$unit_3 = UnitPrice(4, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_5'], "unit_5");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_5'], "unit_5");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_5'], "unit_5");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
if ($_POST['unit_6'] != 0) {
$unit_1 = UnitPrice(5, 0);
$unit_2 = UnitPrice(5, 1);
$unit_3 = UnitPrice(5, 2);
$kosten['Metall'] += sold_formel_truppen($unit_1, $_POST['unit_6'], "unit_6");
$kosten['Mineral'] += sold_formel_truppen($unit_2, $_POST['unit_6'], "unit_6");
$kosten['Latinum'] += sold_formel_truppen($unit_3, $_POST['unit_6'], "unit_6");
$kosten['gesamt'] += $kosten['Metall'] + $kosten['Mineral'] + $kosten['Latinum'];
}
$kosten['gesamt'] = (int) $kosten['gesamt'];
$kosten['Metall'] = (int) $kosten['Metall'];
$kosten['Mineral'] = (int) $kosten['Mineral'];
$kosten['Latinum'] = (int) $kosten['Latinum'];
$steuern['1'] = (int) ($kosten['Metall'] * 0.3);
$steuern['2'] = (int) ($kosten['Mineral'] * 0.3);
$steuern['3'] = (int) ($kosten['Latinum'] * 0.3);
$steuern['4'] = (int) ($kosten['gesamt'] * 0.3);
$steuern['5'] = (int) ($kosten['Metall'] * 0.15);
$steuern['6'] = (int) ($kosten['Mineral'] * 0.15);
$steuern['7'] = (int) ($kosten['Latinum'] * 0.15);
$steuern['8'] = (int) ($kosten['gesamt'] * 0.15);
$daten = $db->queryrow('SELECT * FROM FHB_Handels_Lager WHERE id=1');
$game->out('<table>');
$game->out('<tr><td colspan=2><table><tr><td></td><td>' . constant($game->sprache("TEXT189")) . '</td><td>' . constant($game->sprache("TEXT123")) . '</td><td>' . constant($game->sprache("TEXT165")) . '</td><td>' . constant($game->sprache("TEXT167")) . '</td></tr>');
$game->out('<tr><td>' . constant($game->sprache("TEXT190")) . '</td><td>' . $kosten['gesamt'] . '</td><td><img src="' . $game->GFX_PATH . 'menu_metal_small.gif">' . $kosten['Metall'] . ' </td><td><img src="' . $game->GFX_PATH . 'menu_mineral_small.gif">' . $kosten['Mineral'] . ' </td><td><img src="' . $game->GFX_PATH . 'menu_latinum_small.gif"> ' . $kosten['Latinum'] . '</td></tr>');
$game->out('<tr><td>' . constant($game->sprache("TEXT191")) . '</td><td>' . $steuern['4'] . '</td><td><img src="' . $game->GFX_PATH . 'menu_metal_small.gif">' . $steuern['1'] . ' </td><td><img src="' . $game->GFX_PATH . 'menu_mineral_small.gif">' . $steuern['2'] . '</td><td><img src="' . $game->GFX_PATH . 'menu_latinum_small.gif"> ' . $steuern['3'] . '</td></tr>');
$game->out('<tr><td>' . constant($game->sprache("TEXT164")) . '</td><td>' . $steuern['8'] . '</td><td><img src="' . $game->GFX_PATH . 'menu_metal_small.gif">' . $steuern['5'] . ' </td><td><img src="' . $game->GFX_PATH . 'menu_mineral_small.gif">' . $steuern['6'] . '</td><td><img src="' . $game->GFX_PATH . 'menu_latinum_small.gif"> ' . $steuern['7'] . '</td></tr></table></td></tr>');
$game->out('<form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen&step=3') . '" method="post"><tr><td>' . constant($game->sprache("TEXT169")) . '</td><td><select size="1" name="bezahlungsart">
<option value="1">' . constant($game->sprache("TEXT192")) . '</option>
<option value="2">' . constant($game->sprache("TEXT193")) . '</option>
<option value="3">' . constant($game->sprache("TEXT194")) . '</option>
<option value="4">' . constant($game->sprache("TEXT195")) . '</option>
</select></td></tr>');
$game->out('<tr><td>' . constant($game->sprache("TEXT173")) . '</td><td><select size="1" name="transportsart">
<option value="1">' . constant($game->sprache("TEXT263")) . '</option>
<option value="2">' . constant($game->sprache("TEXT264")) . '</option>
<option value="3">' . constant($game->sprache("TEXT265")) . '</option>
</select></td></tr><tr><td colspan=2><br>' . constant($game->sprache("TEXT177")) . '</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>' . 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="' . $planeten['planet_id'] . '" selected="selected">' . $planeten['planet_name'] . '</option>');
} else {
$game->out('<option value="' . $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>' . 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="' . $planeten['planet_id'] . '" selected="selected">' . $planeten['planet_name'] . '</option>');
} else {
$game->out('<option value="' . $planeten['planet_id'] . '">' . $planeten['planet_name'] . '</option>');
}
}
}
$game->out('</select></td></tr>');
}
$game->out('<tr><td colspan=2>');
$game->out('<input type="hidden" name="unit_1" value="' . $_POST['unit_1'] . '">');
$game->out('<input type="hidden" name="unit_2" value="' . $_POST['unit_2'] . '">');
$game->out('<input type="hidden" name="unit_3" value="' . $_POST['unit_3'] . '">');
$game->out('<input type="hidden" name="unit_4" value="' . $_POST['unit_4'] . '">');
$game->out('<input type="hidden" name="unit_5" value="' . $_POST['unit_5'] . '">');
$game->out('<input type="hidden" name="unit_6" value="' . $_POST['unit_6'] . '">');
$game->out('<input type="submit" value="' . constant($game->sprache("TEXT181")) . '" name="submit" class="Button_nosize"></td></tr></form>');
$game->out('<tr><td colspan=2><form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen') . '" method="post"><tr><td colspan=2>');
$game->out('<input type="hidden" name="unit_1" value="' . $_POST['unit_1'] . '">');
$game->out('<input type="hidden" name="unit_2" value="' . $_POST['unit_2'] . '">');
$game->out('<input type="hidden" name="unit_3" value="' . $_POST['unit_3'] . '">');
$game->out('<input type="hidden" name="unit_4" value="' . $_POST['unit_4'] . '">');
$game->out('<input type="hidden" name="unit_5" value="' . $_POST['unit_5'] . '">');
$game->out('<input type="hidden" name="unit_6" value="' . $_POST['unit_6'] . '">');
$game->out('<input type="submit" value="' . constant($game->sprache("TEXT152")) . '" name="submit" class="Button_nosize"></td></tr></form></table>');
} else {
if (isset($_REQUEST['handel']) && $_REQUEST['handel'] == 'kaufen_truppen' && $_REQUEST['step'] == '2' && $_POST['unit_1'] == 0 && $_POST['unit_2'] == 0 && $_POST['unit_3'] == 0 && $_POST['unit_4'] == 0 && $_POST['unit_5'] == 0 && $_POST['unit_6'] == 0) {
$game->out('Du musst auch schon wo eine Zahl eintragen<br>');
}
$truppen = $db->queryrow('SELECT * FROM `FHB_Handels_Lager` Limit 1');
$game->out('<table align=center><tr><td>' . constant($game->sprache("TEXT196")) . '</td><td>' . constant($game->sprache("TEXT197")) . '</td></tr>');
$game->out('<tr><form action="' . parse_link('a=trade&view=' . $_REQUEST['view'] . '&handel=sold_truppen&step=2') . '" method="post"><td><img src="' . $game->GFX_PATH . 'menu_unit1_small.gif"></td><td><input type="text" name="unit_1" value="' . $_POST['unit_1'] . '" class="Field_nosize"></td></td></tr>');
$game->out('<tr><td><img src="' . $game->GFX_PATH . 'menu_unit2_small.gif"></td><td><input type="text" name="unit_2" value="' . $_POST['unit_2'] . '" class="Field_nosize"></td></tr>');
$game->out('<tr><td><img src="' . $game->GFX_PATH . 'menu_unit3_small.gif"></td><td><input type="text" name="unit_3" value="' . $_POST['unit_3'] . '" class="Field_nosize"></td></tr>');
$game->out('<tr><td><img src="' . $game->GFX_PATH . 'menu_unit4_small.gif"></td><td><input type="text" name="unit_4" value="' . $_POST['unit_4'] . '" class="Field_nosize"></td></tr>');
$game->out('<tr><td><img src="' . $game->GFX_PATH . 'menu_unit5_small.gif"></td><td><input type="text" name="unit_5" value="' . $_POST['unit_5'] . '" class="Field_nosize"></td></tr>');
$game->out('<tr><td><img src="' . $game->GFX_PATH . 'menu_unit6_small.gif"></td><td><input type="text" name="unit_6" value="' . $_POST['unit_6'] . '" class="Field_nosize"></td></tr>');
$game->out('<tr><td colspan="3"><input type="submit" value="' . constant($game->sprache("TEXT198")) . '" name="submit" class="Button_nosize"></td></form></tr></table>');
}
}
function display_ferengi_transfer($planet_id, $planet_system, $system_x, $system_y, $build_11)
{
global $game, $db;
$game->out('<br><br>
<table class="style_outer" width="400" align="center" border="0" cellpadding="2" cellspacing="2"><tr><td>
<table class="style_inner" wisth0"400" align="center" border="0" cellpadding="2" cellspacing="2">');
if ($game->option_retr('show_trade') == 0) {
$game->out('
<tr>
<td><b>' . constant($game->sprache("TEXT15")) . ' <b>[<a href="' . parse_link('a=tactical_cartography&planet_id=' . $_GET['planet_id'] . '&strade=1') . '"><i>' . constant($game->sprache("TEXT16")) . '</i></a>]</b></td></tr>');
} elseif ($build_11 < 1 || $game->planet['building_11'] < 1) {
$game->out('
<tr>
<td><b>' . constant($game->sprache("TEXT15")) . ' <b>[<a href="' . parse_link('a=tactical_cartography&planet_id=' . $_GET['planet_id'] . '"&strade=0') . '"><i>' . constant($game->sprache("TEXT17")) . '</i></a>]</b><br><b><br>' . constant($game->sprache("TEXT18")) . '</b></td></tr>');
} else {
$game->out('
<script language="JavaScript">
function UpdateValues()
{
var i;
var res_1=eval(document.tradeform.res_1.value);
var res_2=eval(document.tradeform.res_2.value);
var res_3=eval(document.tradeform.res_3.value);
');
for ($x = 0; $x < 6; $x++) {
$game->out('
if (document.tradeform.unit_' . ($x + 1) . '.value>0)
{
res_1+=eval("' . UnitPrice($x, 0, $game->player['user_race']) . '")*eval(document.tradeform.unit_' . ($x + 1) . '.value);
res_2+=eval("' . UnitPrice($x, 1, $game->player['user_race']) . '")*eval(document.tradeform.unit_' . ($x + 1) . '.value);
res_3+=eval("' . UnitPrice($x, 2, $game->player['user_race']) . '")*eval(document.tradeform.unit_' . ($x + 1) . '.value);
}
');
}
if ($game->planet['system_id'] == $planet_system) {
$distance = 6;
} else {
$distance = get_distance(array($game->planet['system_global_x'], $game->planet['system_global_y']), array($system_x, $system_y));
$velocity = warpf(6);
$distance = ceil($distance / $velocity / TICK_DURATION);
}
$game->out('
var ttax_set=' . (0.18 - 0.01 * $game->planet['building_11']) . ';
document.getElementById( "res1" ).firstChild.nodeValue = Math.round(res_1*ttax_set);
document.getElementById( "res2" ).firstChild.nodeValue = Math.round(res_2*ttax_set);
document.getElementById( "res3" ).firstChild.nodeValue = Math.round(res_3*ttax_set);
window.setTimeout( \'UpdateValues()\', 500 );
}
</script>
<form name="tradeform" method="post" action="' . parse_link('a=tactical_cartography&planet_id=' . $_GET['planet_id']) . '">
<tr>
<td colspan=3 align="center"><b>' . constant($game->sprache("TEXT19")) . '<br>(' . constant($game->sprache("TEXT22")) . ' ' . Zeit($distance * TICK_DURATION) . ')</b><br><br>
</td>
</tr>
<tr>
<td><img src=' . $game->GFX_PATH . 'menu_metal_small.gif> <input class="field" style="width: 60px;" type="text" name="res_1" value="0" onFocus="UpdateValues();">  </td>
<td><img src=' . $game->GFX_PATH . 'menu_unit1_small.gif> <input class="field" style="width: 60px;" type="text" name="unit_1" value="0" onFocus="UpdateValues();">  </td>
<td><img src=' . $game->GFX_PATH . 'menu_unit4_small.gif> <input class="field" style="width: 60px;" type="text" name="unit_4" value="0" onFocus="UpdateValues();">  </td>
</tr>
<tr>
<td><img src=' . $game->GFX_PATH . 'menu_mineral_small.gif> <input class="field" style="width: 60px;" type="text" name="res_2" value="0" onFocus="UpdateValues();">  </td>
<td><img src=' . $game->GFX_PATH . 'menu_unit2_small.gif> <input class="field" style="width: 60px;" type="text" name="unit_2" value="0" onFocus="UpdateValues();">  </td>
<td><img src=' . $game->GFX_PATH . 'menu_unit5_small.gif> <input class="field" style="width: 60px;" type="text" name="unit_5" value="0" onFocus="UpdateValues();">  </td>
</tr>
<tr>
<td><img src=' . $game->GFX_PATH . 'menu_latinum_small.gif> <input class="field" style="width: 60px;" type="text" name="res_3" value="0" onFocus="UpdateValues();">  </td>
<td><img src=' . $game->GFX_PATH . 'menu_unit3_small.gif> <input class="field" style="width: 60px;" type="text" name="unit_3" value="0" onFocus="UpdateValues();">  </td>
<td><img src=' . $game->GFX_PATH . 'menu_unit6_small.gif> <input class="field" style="width: 60px;" type="text" name="unit_6" value="0" onFocus="UpdateValues();">  </td>
</tr>
<tr>
<td colspan=3 align="center">
<b>' . constant($game->sprache("TEXT20")) . '</b>
<img src=' . $game->GFX_PATH . 'menu_metal_small.gif> <b id="res1">0</b>
<img src=' . $game->GFX_PATH . 'menu_mineral_small.gif> <b id="res2">0</b>
<img src=' . $game->GFX_PATH . 'menu_latinum_small.gif> <b id="res3">0</b>
</td>
</tr>
<tr>
<td colspan=3 align="center">
<input class="button" type="submit" name="trade" value="' . constant($game->sprache("TEXT21")) . '"><br><br><b>
[<a href="' . parse_link('a=tactical_cartography&planet_id=' . $_GET['planet_id'] . '&strade=0') . '"><i>' . constant($game->sprache("TEXT17")) . '</i></a>]</b>
</td>
</tr>
</form>');
}
$game->out('</table></td></tr></table><br>');
}
$sdl->log('<b>Error:</b> Could not query unittrain data! - SKIPPED');
} else {
while (($planet = $db->fetchrow($academyquery)) == true) {
// Look whether the construction number is within normal parameters, but should never lie outside:
if ($planet['unittrain_actual'] < 1 || $planet['unittrain_actual'] > 10) {
if (!$db->query('UPDATE planets SET unittrain_actual="1" WHERE planet_id="' . $planet['planet_id'] . '"')) {
$sdl->log('<b>Error:</b> Cannot fix training queue pointer on planet #' . $planet['planet_id'] . '- CONTINUED');
}
} else {
// Unit in training
$t = $planet['unittrainid_' . $planet['unittrain_actual']] - 1;
// Needed resources
$need_res_1 = UnitPrice($t, 0, $planet['user_race']);
$need_res_2 = UnitPrice($t, 1, $planet['user_race']);
$need_res_3 = UnitPrice($t, 2, $planet['user_race']);
$need_res_4 = UnitPrice($t, 3, $planet['user_race']);
// Check if we're handling a break and if we're training a
// unit, that the planet has the needed resources
if ($t > 5 || $t < 0 || $need_res_1 <= $planet['resource_1'] && $need_res_2 <= $planet['resource_2'] && $need_res_3 <= $planet['resource_3'] && $need_res_4 <= $planet['resource_4']) {
$sql = array();
// 2pre1: The SQL Query for 2. prepare, because the data under 1. can change:
$t++;
if ($t < 7 && $t > 0) {
$sql[] = 'resource_1=resource_1-' . $need_res_1 . ',
resource_2=resource_2-' . $need_res_2 . ',
resource_3=resource_3-' . $need_res_3 . ',
resource_4=resource_4-' . $need_res_4 . ',
unit_' . $t . '=unit_' . $t . '+1';
}
// 1. For the next unit jump + new time set:
// if left<=0
function Show_Main()
{
global $db;
global $game;
global $UNIT_NAME, $UNIT_DESCRIPTION, $UNIT_DATA, $MAX_BUILDING_LVL, $NEXT_TICK, $ACTUAL_TICK;
$pow_factor = 2;
///////////////////////// 1st Build in Progress
if ($game->planet['unittrainid_nexttime'] > 0) {
$game->out('
<table border="0" cellpadding="1" cellspacing="1" width="350" class="style_outer"><tr><td>
<table border="0" cellpadding="1" cellspacing="1" width="350" class="style_inner"><tr><td>');
if ($game->planet['unittrainid_' . $game->planet['unittrain_actual']] <= 6) {
$game->out(constant($game->sprache("Text1")) . ' <b>' . $UNIT_NAME[$game->player['user_race']][$game->planet['unittrainid_' . $game->planet['unittrain_actual']] - 1] . '</b><br>
' . constant($game->sprache("Text2")));
if ($game->planet['unittrain_error'] == 0) {
$game->out('<b id="timer3" title="time1_' . ($NEXT_TICK + TICK_DURATION * 60 * ($game->planet['unittrainid_nexttime'] - $ACTUAL_TICK)) . '_type1_1"> </b>');
} else {
if ($game->planet['unittrain_error'] == 1) {
$game->out('<b>' . constant($game->sprache("Text3")) . '</b>');
} else {
$game->out('<b>' . constant($game->sprache("Text36")) . '</b>');
}
}
} else {
$text = constant($game->sprache("Text26"));
if ($game->planet['unittrainid_' . $game->planet['unittrain_actual']] == 11) {
$text = constant($game->sprache("Text27"));
}
if ($game->planet['unittrainid_' . $game->planet['unittrain_actual']] == 12) {
$text = constant($game->sprache("Text28"));
}
$game->out(constant($game->sprache("Text4")) . '- <b>' . $text . '</b><br>' . constant($game->sprache("Text5")) . '
<b id="timer3" title="time1_' . ($NEXT_TICK + TICK_DURATION * 60 * ($game->planet['unittrainid_nexttime'] - $ACTUAL_TICK)) . '_type1_1"> </b>');
}
$game->out('</td></tr></table></td></tr></table><br>');
$game->set_autorefresh($NEXT_TICK + TICK_DURATION * 60 * ($game->planet['unittrainid_nexttime'] - $ACTUAL_TICK));
}
//////////////////////// 2nd Buildmenu
$game->out('<table border="0" cellpadding="2" cellspacing="2" width="400" class="style_outer">
<tr><td width=100%><span class="sub_caption2">' . constant($game->sprache("Text6")) . '</span><br>
<table border=0 cellpadding=1 cellspacing=1 width=398 class="style_inner">');
$game->out(constant($game->sprache("Text7")));
for ($t = 0; $t < 6; $t++) {
if (UnitMetRequirements($t)) {
$game->out('<tr height=20><td><img src="' . $game->GFX_PATH . 'menu_unit' . ($t + 1) . '_small.gif"> <b><a href="javascript:void(0);" onmouseover="return overlib(\'' . $UNIT_DESCRIPTION[$game->player['user_race']][$t] . constant($game->sprache("Text8")) . GetAttackUnit($t) . constant($game->sprache("Text9")) . $UNIT_DATA[$t][5] . constant($game->sprache("Text10")) . GetDefenseUnit($t) . constant($game->sprache("Text9")) . $UNIT_DATA[$t][6] . ')\', CAPTION, \'' . $UNIT_NAME[$game->player['user_race']][$t] . '\', WIDTH, 400, ' . OVERLIB_STANDARD . ');" onmouseout="return nd();">' . $UNIT_NAME[$game->player['user_race']][$t] . ' (' . $game->planet['unit_' . ($t + 1) . ''] . ')</a></b></td><td><img src="' . $game->GFX_PATH . 'menu_metal_small.gif"> ' . UnitPrice($t, 0) . ' <img src="' . $game->GFX_PATH . 'menu_mineral_small.gif">' . UnitPrice($t, 1) . ' <img src="' . $game->GFX_PATH . 'menu_latinum_small.gif"> ' . UnitPrice($t, 2) . ' <img src="' . $game->GFX_PATH . 'menu_worker_small.gif"> ' . UnitPrice($t, 3) . '</td><td>' . UnitTime($t) . '</td></tr>');
}
}
$game->out('</td></tr></table></td></tr></table>');
$game->out('<br><span class="sub_caption">' . constant($game->sprache("Text11")) . HelpPopup('academy_1') . ' :</span><br><br>
<table border="0" cellpadding="2" cellspacing="2" width="400" class="style_outer"><tr><td width=100%><span class="sub_caption2">');
if ($game->planet['unittrainid_nexttime'] > 0) {
$game->out(constant($game->sprache("Text12")));
} else {
$game->out(constant($game->sprache("Text13")));
}
$game->out('</span>');
$game->out('<table border="0" cellpadding="2" cellspacing="2" width="400" class="style_inner">
<tr><td align="center">
<br>
<form name="academy" method="post" action="' . parse_link('a=academy') . '"><input type="submit" name="start_list" class="button_nosize" value="' . constant($game->sprache("Text23")) . '"> <input type="submit" name="stop_list" class="button_nosize" value="' . constant($game->sprache("Text24")) . '"></form>
</td></tr></table></td></tr></table>');
$game->out('<br><span class="sub_caption">' . constant($game->sprache("Text14")) . ' ' . HelpPopup('academy_2') . ' :</span><br>');
$game->out('<script language="JavaScript">
function UpdateTroops() {
var tmpl = document.getElementById("templates_list");
var units = tmpl.options[tmpl.selectedIndex].value.split(\',\',7);
for (t=1;t<=6;t++)
document.getElementById( "unit"+t ).firstChild.nodeValue = units[t];
}
</script>');
$game->out('<br><form name="academy" method="post" action="' . parse_link('a=academy') . '">
<table border="0" cellpadding="2" cellspacing="2" width="400" class="style_outer">
<tr><td width=100%><span class="sub_caption2">' . constant($game->sprache("Text38")) . '</span><br>
<table border=0 cellpadding=1 cellspacing=1 width=398 class="style_inner">');
$sql = 'SELECT `id`,`name`,`min_unit_1`,`min_unit_2`,`min_unit_3`,
`min_unit_4`,`unit_5` AS min_unit_5, `unit_6` AS min_unit_6
FROM ship_templates
WHERE removed <> 1 AND owner = ' . $game->player['user_id'];
$templates = $db->query($sql);
$game->out('<tr><td>' . constant($game->sprache("Text39")) . '<select name="templates_list" id="templates_list" class="Select" size="1" onChange="UpdateTroops();"><option value="-1,0,0,0,0,0,0">' . constant($game->sprache("Text25")) . '</option>');
while ($template = $db->fetchrow($templates)) {
$game->out('<option value="' . $template['id'] . ',' . $template['min_unit_1'] . ',' . $template['min_unit_2'] . ',' . $template['min_unit_3'] . ',' . $template['min_unit_4'] . ',' . $template['min_unit_5'] . ',' . $template['min_unit_6'] . '">' . $template['name'] . '</option>');
}
$game->out('</select></td>');
for ($t = 0; $t < 6; $t++) {
$game->out('<td><img src="' . $game->GFX_PATH . 'menu_unit' . ($t + 1) . '_small.gif"> <b id="unit' . ($t + 1) . '">0</b></td>');
}
$game->out('<td><input type="submit" name="apply_template" class="button_nosize" value="' . constant($game->sprache("Text40")) . '"></td></tr></table></td></tr></table></form>');
$game->out('<br><table border="0" cellpadding="2" cellspacing="2" width="400" class="style_outer"><tr><td width=100%>
<span class="sub_caption2">' . constant($game->sprache("Text15")) . '</span><br>
<table border=0 cellpadding=2 cellspacing=2 width=398 class="style_inner">
<tr><td align="center">
<form name="academy" method="post" action="' . parse_link('a=academy') . '">
<table border=0 cellpadding=2 cellspacing=2 width=280><tr><td> </td>' . constant($game->sprache("Text16")) . '</tr>');
for ($t = 0; $t < 10; $t++) {
if ($game->planet['unittrain_actual'] != $t + 1) {
$game->out('<tr><td> </td><td width=40>' . ($t + 1) . ':</td>');
} else {
$game->out('<tr><td><img src="' . $game->PLAIN_GFX_PATH . 'arrow_right.png"></td><td width=40><b><u>' . ($t + 1) . '</u></b>:</td>');
}
$game->out('<td width=150><select name="listid_' . $t . '" class="Select" size="1"><option value="-1">' . constant($game->sprache("Text25")) . '</option>');
if ($game->planet['unittrainid_' . ($t + 1)] == 10) {
$game->out(constant($game->sprache("Text17")));
} else {
$game->out(constant($game->sprache("Text18")));
}
if ($game->planet['unittrainid_' . ($t + 1)] == 11) {
$game->out(constant($game->sprache("Text31")));
} else {
$game->out(constant($game->sprache("Text32")));
}
if ($game->planet['unittrainid_' . ($t + 1)] == 12) {
$game->out(constant($game->sprache("Text33")));
} else {
$game->out(constant($game->sprache("Text34")));
}
for ($u = 0; $u < 6; $u++) {
if (UnitMetRequirements($u)) {
if ($game->planet['unittrainid_' . ($t + 1)] == $u + 1) {
$game->out('<option value="' . ($u + 1) . '" selected>' . $UNIT_NAME[$game->player['user_race']][$u] . '</option>');
} else {
$game->out('<option value="' . ($u + 1) . '">' . $UNIT_NAME[$game->player['user_race']][$u] . '</option>');
}
}
}
$number = $game->planet['unittrainnumber_' . ($t + 1)];
if ($game->planet['unittrainendless_' . ($t + 1)] != 1) {
$number = $game->planet['unittrainnumberleft_' . ($t + 1)];
}
$game->out('
</select>
</td>
<td>
<input type="text" name="listnumber_' . $t . '" value="' . $number . '" class="Field_nosize" size="10" maxlength="5">
</td>
<td>
<input type="checkbox" name="listendless_' . $t . '" value="1" ' . ($game->planet['unittrainendless_' . ($t + 1)] ? 'checked="checked"' : '') . '>
</select>
</td>
</tr>
');
}
$game->out('</table>' . constant($game->sprache("Text19")) . ' <img src="' . $game->PLAIN_GFX_PATH . 'arrow_right.png"> ' . constant($game->sprache("Text19a")) . '<br>
<input type="submit" name="exec_list" class="button_nosize" value="' . constant($game->sprache("Text22")) . '">
<input type="submit" name="reset_list" class="button_nosize" value="' . constant($game->sprache("Text35")) . '"></form></td></tr></table></td></tr></table>');
}
