function mission_check($id)
{
$dbh = db_connect();
include 'einheiten_preise.php';
// eigene missionen
$select = "SELECT * FROM `missionen` WHERE `id` = '" . $id . "';";
$result = mysql_query($select);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
if ($row['parsed'] == 0) {
if ($row) {
if ($row['type'] == 1) {
// angriff
kampf($row['id']);
} elseif ($row['type'] == 2) {
// transport
$select = "SELECT * FROM `user` WHERE `omni` = '" . $row['ziel'] . "';";
$rows = mysql_query($select);
$target = mysql_fetch_array($rows);
if ($target and $target['group'] != 1000) {
$ressis = ressistand($row['ziel']);
$select = "UPDATE `ressis` SET `eisen` = eisen+" . $row['eisen'] . ",`titan` = titan+" . $row['titan'] . ",`oel` = oel+" . $row['oel'] . ",`uran` = uran+" . $row['uran'] . ",`gold` = gold+" . $row['gold'] . ",`chanje` = chanje+" . $row['chanje'] . " WHERE `omni` = '" . $row['ziel'] . "' LIMIT 1;";
$ressiupdate = mysql_query($select);
$select = "UPDATE `missionen` SET `eisen` = '0',`titan` = '0',`oel` = '0',`uran` = '0',`gold` = '0',`chanje` = '0' WHERE `id` = '" . $row['id'] . "' LIMIT 1;";
mysql_query($select);
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['ziel'] . "', '" . $row['ankunft'] . "', '0', 'Rohstofflieferung von " . $row['start'] . "', '" . $row['start'] . " hat dir<br />" . $row['eisen'] . " Eisen<br />" . $row['titan'] . " Titan<br /> " . $row['oel'] . " Oel<br />" . $row['uran'] . " Uran<br />" . $row['gold'] . " Gold<br />" . $row['chanje'] . " Chanje<br />geliefert.' );";
mysql_query($select);
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['start'] . "', '" . $row['ankunft'] . "', '0', 'Transport zu " . $row['ziel'] . "', 'Du hast an die Basis bei " . $row['ziel'] . "<br />" . $row['eisen'] . " Eisen<br />" . $row['titan'] . " Titan<br /> " . $row['oel'] . " Oel<br />" . $row['uran'] . " Uran<br />" . $row['gold'] . " Gold<br />" . $row['chanje'] . " Chanje<br />geliefert.' );";
mysql_query($select);
$handel = mysql_query("SELECT * FROM `handel` WHERE `p1` = '" . $row['start'] . "' AND `p2` = '" . $row['ziel'] . "' LIMIT 1;");
$handel = @mysql_fetch_array($handel);
if ($handel) {
mysql_query("UPDATE `handel` SET `s1` = s1-(" . ($row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "), `s2` = s2+(" . ($row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . ") WHERE `id` = '" . $handel['id'] . "' LIMIT 1;");
} else {
$handel = mysql_query("SELECT * FROM `handel` WHERE `p2` = '" . $row['start'] . "' AND `p1` = '" . $row['ziel'] . "' LIMIT 1;");
$handel = @mysql_fetch_array($handel);
if ($handel) {
mysql_query("UPDATE `handel` SET `s1` = s1+(" . ($row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "), `s2` = s2-(" . ($row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . ") WHERE `id` = '" . $handel['id'] . "' LIMIT 1;");
} else {
mysql_query("INSERT INTO `handel` ( `id` , `p1` , `p2` , `s1` , `s2` ) VALUES ( '', '" . $row['start'] . "', '" . $row['ziel'] . "', '" . ($row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "', '-" . ($row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "' );");
}
}
} else {
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['start'] . "', '" . $row['ankunft'] . "', '0', 'Transport zu " . $row['ziel'] . "', 'Du hast keine Basis bei " . $row['ziel'] . " vorgefunden.<br />Deine Einheiten kehren incl. Ladung zurück.' );";
mysql_query($select);
}
} elseif ($row['type'] == 3) {
// ueberfuehrung
$select = "SELECT * FROM `user` WHERE `omni` = '" . $row['ziel'] . "';";
$rows = mysql_query($select);
$target = mysql_fetch_array($rows);
if ($target and $target['group'] != 1000) {
$ressis = ressistand($row['ziel']);
$select = "UPDATE `ressis` SET `eisen` = '" . ($ressis['eisen'] + $row['eisen']) . "',`titan` = '" . ($ressis['titan'] + $row['titan']) . "',`oel` = '" . ($ressis['oel'] + $row['oel']) . "',`uran` = '" . ($ressis['uran'] + $row['uran']) . "',`gold` = '" . ($ressis['gold'] + $row['gold']) . "',`chanje` = '" . ($ressis['chanje'] + $row['chanje']) . "' WHERE `omni` = '" . $row['ziel'] . "' LIMIT 1;";
$ressiupdate = mysql_query($select);
$select = "SELECT * FROM `gebauede` WHERE `omni` = '" . $row['ziel'] . "';";
$selectResult = mysql_query($select);
$gebaeude = mysql_fetch_array($selectResult);
// checken ob einheiten fertig sind und dann hangar setzen
$hangar = new_units_check($row['ziel']);
$count = 0;
do {
$count++;
$type = 'einh' . $count;
$kosten += einh2ress($count, $row[$type]);
} while ($count < 15);
if ($row['einh1']) {
$units .= $row['einh1'] . ' ' . $einh[1]['name'] . '<br />';
}
if ($row['einh2']) {
$units .= $row['einh2'] . ' ' . $einh[2]['name'] . '<br />';
}
if ($row['einh3']) {
$units .= $row['einh3'] . ' ' . $einh[3]['name'] . '<br />';
}
if ($row['einh4']) {
$units .= $row['einh4'] . ' ' . $einh[4]['name'] . '<br />';
}
if ($row['einh5']) {
$units .= $row['einh5'] . ' ' . $einh[5]['name'] . '<br />';
}
if ($row['einh6']) {
$units .= $row['einh6'] . ' ' . $einh[6]['name'] . '<br />';
}
if ($row['einh7']) {
$units .= $row['einh7'] . ' ' . $einh[7]['name'] . '<br />';
}
if ($row['einh8']) {
$units .= $row['einh8'] . ' ' . $einh[8]['name'] . '<br />';
}
if ($row['einh9']) {
$units .= $row['einh9'] . ' ' . $einh[9]['name'] . '<br />';
}
if ($row['einh10']) {
$units .= $row['einh10'] . ' ' . $einh[10]['name'] . '<br />';
}
if ($row['einh11']) {
$units .= $row['einh11'] . ' ' . $einh[11]['name'] . '<br />';
}
if ($row['einh12']) {
$units .= $row['einh12'] . ' ' . $einh[12]['name'] . '<br />';
}
if ($row['einh13']) {
$units .= $row['einh13'] . ' ' . $einh[13]['name'] . '<br />';
}
if ($row['einh14']) {
$units .= $row['einh14'] . ' ' . $einh[14]['name'] . '<br />';
}
if ($row['einh15']) {
$units .= $row['einh15'] . ' ' . $einh[15]['name'] . '<br />';
}
// fahrwege
if ($gebaeude['fahrwege'] < 1) {
$klatsch_fw['einh5'] = $row['einh5'];
$row['einh5'] = 0;
}
if ($gebaeude['fahrwege'] < 3) {
$klatsch_fw['einh6'] = $row['einh6'];
$row['einh6'] = 0;
}
if ($gebaeude['fahrwege'] < 6) {
$klatsch_fw['einh7'] = $row['einh7'];
$row['einh7'] = 0;
}
if ($gebaeude['fahrwege'] < 8) {
$klatsch_fw['einh8'] = $row['einh8'];
$row['einh8'] = 0;
}
if ($gebaeude['fahrwege'] < 6) {
$klatsch_fw['einh9'] = $row['einh9'];
$row['einh9'] = 0;
}
if ($gebaeude['fahrwege'] < 10) {
$klatsch_fw['einh10'] = $row['einh10'];
$row['einh10'] = 0;
}
if ($gebaeude['fahrwege'] < 15) {
$klatsch_fw['einh11'] = $row['einh11'];
$row['einh11'] = 0;
}
if ($gebaeude['fahrwege'] < 1) {
$klatsch_fw['einh12'] = $row['einh12'];
$row['einh12'] = 0;
}
if ($gebaeude['fahrwege'] < 3) {
$klatsch_fw['einh13'] = $row['einh13'];
$row['einh13'] = 0;
}
if ($gebaeude['fahrwege'] < 1) {
$klatsch_fw['einh14'] = $row['einh14'];
$row['einh14'] = 0;
}
if ($gebaeude['fahrwege'] < 3) {
$klatsch_fw['einh15'] = $row['einh15'];
$row['einh15'] = 0;
}
for ($count = 1; $count <= 15; $count++) {
$type = 'einh' . $count;
for (; $row[$type];) {
if ($ressis['hangar'] - $einh[$count]['size'] >= 0 and $row[$type] > 0) {
$hangar[$type]++;
$row[$type]--;
$ressis['hangar'] -= $einh[$count]['size'];
} else {
$klatsch[$count] = $row[$type];
$row[$type] = 0;
}
}
}
if ($klatsch) {
$count = 0;
do {
$count++;
if ($klatsch[$count]) {
$klatscher .= $klatsch[$count] . ' x ' . $einh[$count]['name'] . '<br />';
}
} while ($count < 15);
if ($klatscher) {
$geklatscht .= '<br /><br />Leider konnten aufgrund mangelnden Hangarplatzes <br />' . $klatscher . ' nicht eingelagert werden.';
}
}
if ($klatsch_fw) {
unset($klatscher);
$count = 0;
do {
$count++;
if ($klatsch_fw[$count]) {
$klatscher .= $klatsch[$count] . ' x ' . $einh[$count]['name'] . '<br />';
}
} while ($count < 15);
if ($klatscher) {
$geklatscht .= '<br /><br />Leider konnten aufgrund mangelnden Fahrwegeausbaus <br />' . $klatscher . ' nicht eingelagert werden.';
}
}
if (!$klatsch and !$klatsch_fw) {
$geklatscht = '<br /><br />Alle Einheiten wurden ordnungsgemäss eingelagert.';
}
$select = "UPDATE `hangar` SET `einh1` = '" . $hangar['einh1'] . "', `einh2` = '" . $hangar['einh2'] . "', `einh3` = '" . $hangar['einh3'] . "', `einh4` = '" . $hangar['einh4'] . "', `einh5` = '" . $hangar['einh5'] . "', `einh6` = '" . $hangar['einh6'] . "', `einh7` = '" . $hangar['einh7'] . "', `einh8` = '" . $hangar['einh8'] . "', `einh9` = '" . $hangar['einh9'] . "', `einh10` = '" . $hangar['einh10'] . "', `einh11` = '" . $hangar['einh11'] . "', `einh12` = '" . $hangar['einh12'] . "', `einh13` = '" . $hangar['einh13'] . "', `einh14` = '" . $hangar['einh14'] . "', `einh15` = '" . $hangar['einh15'] . "' WHERE `omni` = '" . $row['ziel'] . "' LIMIT 1;";
mysql_query($select);
for ($i = 1; $i <= 15; $i++) {
$klatsch[$i] += $klatsch_fw[$i];
$k += $klatsch[$i];
}
if ($k <= 0) {
mysql_query("DELETE FROM `missionen` WHERE `id` = '" . $row['id'] . "' LIMIT 1;");
} else {
mysql_query("UPDATE `missionen` SET `einh1` = '" . $klatsch[1] . "',\n`einh2` = '" . $klatsch[2] . "',\n`einh3` = '" . $klatsch[3] . "',\n`einh4` = '" . $klatsch[4] . "',\n`einh5` = '" . $klatsch[5] . "',\n`einh6` = '" . $klatsch[6] . "',\n`einh7` = '" . $klatsch[7] . "',\n`einh8` = '" . $klatsch[8] . "',\n`einh9` = '" . $klatsch[9] . "',\n`einh10` = '" . $klatsch[10] . "',\n`einh11` = '" . $klatsch[11] . "',\n`einh12` = '" . $klatsch[12] . "',\n`einh13` = '" . $klatsch[13] . "',\n`einh14` = '" . $klatsch[14] . "',\n`einh15` = '" . $klatsch[15] . "',\n`eisen` = '0',\n`titan` = '0',\n`oel` = '0',\n`uran` = '0',\n`gold` = '0',\n`chanje` = '0' WHERE `id` ='" . $row['id'] . "' LIMIT 1;");
}
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['ziel'] . "', '" . $row['ankunft'] . "', '0', 'Überführung von " . $row['start'] . "', '" . $row['start'] . " hat dir<br />" . $row['eisen'] . " Eisen<br />" . $row['titan'] . " Titan<br /> " . $row['oel'] . " Oel<br />" . $row['uran'] . " Uran<br />" . $row['gold'] . " Gold<br />" . $row['chanje'] . " Chanje<br /><br />" . $units . "geliefert. " . $geklatscht . "' );";
mysql_query($select);
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['start'] . "', '" . $row['ankunft'] . "', '0', 'Überführung zu " . $row['ziel'] . "', 'Du hast an die Basis bei " . $row['ziel'] . "<br />" . $row['eisen'] . " Eisen<br />" . $row['titan'] . " Titan<br /> " . $row['oel'] . " Oel<br />" . $row['uran'] . " Uran<br />" . $row['gold'] . " Gold<br />" . $row['chanje'] . " Chanje<br /><br />" . $units . "geliefert. " . $geklatscht . "' );";
mysql_query($select);
$handel = mysql_query("SELECT * FROM `handel` WHERE `p1` = '" . $row['start'] . "' AND `p2` = '" . $row['ziel'] . "' LIMIT 1;");
$handel = @mysql_fetch_array($handel);
if ($handel) {
mysql_query("UPDATE `handel` SET `s1` = s1-(" . ($kosten + $row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "), `s2` = s2+(" . ($kosten + $row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . ") WHERE `id` = '" . $handel['id'] . "' LIMIT 1;");
} else {
$handel = mysql_query("SELECT * FROM `handel` WHERE `p2` = '" . $row['start'] . "' AND `p1` = '" . $row['ziel'] . "' LIMIT 1;");
$handel = @mysql_fetch_array($handel);
if ($handel) {
mysql_query("UPDATE `handel` SET `s1` = s1+(" . ($kosten + $row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "), `s2` = s2-(" . ($kosten + $row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . ") WHERE `id` = '" . $handel['id'] . "' LIMIT 1;");
} else {
mysql_query("INSERT INTO `handel` ( `id` , `p1` , `p2` , `s1` , `s2` ) VALUES ( '', '" . $row['start'] . "', '" . $row['ziel'] . "', '" . ($kosten + $row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "', '-" . ($kosten + $row['eisen'] + $row['titan'] + $row['oel'] + $row['uran'] + $row['gold'] + $row['chanje'] * 1000) . "' );");
}
}
} else {
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['start'] . "', '" . $row['ankunft'] . "', '0', 'Überführung zu " . $row['ziel'] . "', 'Du hast keine Basis bei " . $row['ziel'] . " vorgefunden.<br />Deine Einheiten kehren incl. Ladung zurück.' );";
mysql_query($select);
}
} elseif ($row['type'] == 4) {
// sammeln
$select = "SELECT * FROM `user` WHERE `omni` = '" . $row['ziel'] . "';";
$res = mysql_query($select);
$tf = mysql_fetch_array($res, MYSQL_ASSOC);
$space = $row['einh15'] * $einh[15]['space'];
if ($space >= $tf['tf_eisen']) {
$sammeln['eisen'] = $tf['tf_eisen'];
$space -= $tf['tf_eisen'];
} else {
$sammeln['eisen'] = $space;
$space = 0;
}
if ($space >= $tf['tf_titan']) {
$sammeln['titan'] = $tf['tf_titan'];
$space -= $tf['tf_titan'];
} else {
$sammeln['titan'] = $space;
}
$select = "UPDATE `missionen` SET `eisen` = '" . $sammeln['eisen'] . "',`titan` = '" . $sammeln['titan'] . "',`oel` = '0',`uran` = '0',`gold` = '0',`chanje` = '0' WHERE `id` = '" . $row['id'] . "' LIMIT 1;";
mysql_query($select);
$select = "UPDATE `user` SET `tf_eisen` = '" . ($tf['tf_eisen'] - $sammeln['eisen']) . "', `tf_titan` = '" . ($tf['tf_titan'] - $sammeln['titan']) . "' WHERE `omni` = '" . $row['ziel'] . "' LIMIT 1 ;";
mysql_query($select);
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['start'] . "', '" . $row['ankunft'] . "', '0', 'Sammeln bei " . $row['ziel'] . "', 'Deine " . $row['einh15'] . " Sammler haben einen Gesamtladeplatz von " . $row['einh15'] * $einh[15]['space'] . ".<br />Bei der Zielbasis lagen " . $tf['tf_eisen'] . " Eisen " . $tf['tf_titan'] . " Titan<br />Du hast davon " . $sammeln['eisen'] . " Eisen " . $sammeln['titan'] . " Titan gesammelt.' );";
mysql_query($select);
}
$select = "UPDATE `missionen` SET `parsed` = '1' WHERE `id` = '" . $row['id'] . "' LIMIT 1;";
mysql_query($select);
$select = "INSERT INTO `events` ( `id` , `type` , `eid` , `date` ) VALUES ('', '1', '" . $row['id'] . "', '" . $row['return'] . "');";
$selectResult = mysql_query($select);
}
} else {
if ($row) {
$ressis = ressistand($row['start']);
$select = "UPDATE `ressis` SET `eisen` = '" . ($ressis['eisen'] + $row['eisen']) . "',`titan` = '" . ($ressis['titan'] + $row['titan']) . "',`oel` = '" . ($ressis['oel'] + $row['oel']) . "',`uran` = '" . ($ressis['uran'] + $row['uran']) . "',`gold` = '" . ($ressis['gold'] + $row['gold']) . "',`chanje` = '" . ($ressis['chanje'] + $row['chanje']) . "' WHERE `omni` = '" . $row['start'] . "' LIMIT 1;";
mysql_query($select);
$ressiupdate = mysql_errno($dbh);
$select = "SELECT * FROM `gebauede` WHERE `omni` = '" . $omni . "' LIMIT 1;";
$selectResult = mysql_query($select);
$gebaeude = mysql_fetch_array($selectResult);
// checken ob einheiten fertig sind und dann hangar setzen
$hangar = new_units_check($row['start']);
if ($row['einh1']) {
$einheiten .= $row['einh1'] . ' x ' . $einh[1]['name'] . '<br />';
}
if ($row['einh2']) {
$einheiten .= $row['einh2'] . ' x ' . $einh[2]['name'] . '<br />';
}
if ($row['einh3']) {
$einheiten .= $row['einh3'] . ' x ' . $einh[3]['name'] . '<br />';
}
if ($row['einh4']) {
$einheiten .= $row['einh4'] . ' x ' . $einh[4]['name'] . '<br />';
}
if ($row['einh5']) {
$einheiten .= $row['einh5'] . ' x ' . $einh[5]['name'] . '<br />';
}
if ($row['einh6']) {
$einheiten .= $row['einh6'] . ' x ' . $einh[6]['name'] . '<br />';
}
if ($row['einh7']) {
$einheiten .= $row['einh7'] . ' x ' . $einh[7]['name'] . '<br />';
}
if ($row['einh8']) {
$einheiten .= $row['einh8'] . ' x ' . $einh[8]['name'] . '<br />';
}
if ($row['einh9']) {
$einheiten .= $row['einh9'] . ' x ' . $einh[9]['name'] . '<br />';
}
if ($row['einh10']) {
$einheiten .= $row['einh10'] . ' x ' . $einh[10]['name'] . '<br />';
}
if ($row['einh11']) {
$einheiten .= $row['einh11'] . ' x ' . $einh[11]['name'] . '<br />';
}
if ($row['einh12']) {
$einheiten .= $row['einh12'] . ' x ' . $einh[12]['name'] . '<br />';
}
if ($row['einh13']) {
$einheiten .= $row['einh13'] . ' x ' . $einh[13]['name'] . '<br />';
}
if ($row['einh14']) {
$einheiten .= $row['einh14'] . ' x ' . $einh[14]['name'] . '<br />';
}
if ($row['einh15']) {
$einheiten .= $row['einh15'] . ' x ' . $einh[15]['name'] . '<br />';
}
$count = 0;
do {
$count++;
$type = 'einh' . $count;
do {
if ($ressis['hangar'] >= $einh[$count]['size'] and $row[$type] > 0) {
$hangar[$type]++;
$row[$type]--;
$ressis['hangar'] -= $einh[$count]['size'];
} else {
$klatsch[$count] = $row[$type];
$row[$type] = 0;
}
} while ($row[$type] > 0);
} while ($count < 15);
$count = 0;
do {
$count++;
if ($klatsch[$count]) {
$geklatscht .= $klatsch[$count] . ' x ' . $einh[$count]['name'] . '<br />';
}
} while ($count < 15);
if ($geklatscht) {
$rand = rand(2 * 3600, 6 * 3600);
$restsekunden = $rand;
$stunden = floor($restsekunden / 60 / 60);
$restsekunden = $restsekunden - $stunden * 60 * 60;
$minuten = $restsekunden / 60;
// Umrechnung in Minuten
$ganzzahl = floor($minuten);
// Abrunden auf Ganzzahl
$sekunden2 = $ganzzahl * 60;
// Rest errechnen
$restsek = $restsekunden - $sekunden2;
// Restsekunden
$restsek = number_format($restsek, 0, '', '');
$ganzzahl = str_pad($ganzzahl, 2, "0", STR_PAD_LEFT);
$restsek = str_pad($restsek, 2, "0", STR_PAD_LEFT);
$geklatscht = '<br /><br />Leider sind aufgrund mangelnden Hangarplatzes: <br />' . $geklatscht . 'für ' . $stunden . ' Stunden und ' . $ganzzahl . ' Minuten' . ' verloren gegangen.<br />';
$select = "INSERT INTO `missionen` ( `id` , `type` , `start` , `ziel` , `started` , `ankunft` , `return` , `parsed` , `speed` , `einh1` , `einh2` , `einh3` , `einh4` , `einh5` , `einh6` , `einh7` , `einh8` , `einh9` , `einh10` , `einh11` , `einh12` , `einh13` , `einh14` , `einh15` , `eisen` , `titan` , `oel` , `uran` , `gold` , `chanje` ) VALUES ( '', '2', '" . $row['start'] . "', '" . $row['start'] . "', '" . (date(U) - $rand) . "', '" . date(U) . "', '" . (date(U) + $rand) . "', '1', '10', '" . $klatsch[1] . "', '" . $klatsch[2] . "', '" . $klatsch[3] . "', '" . $klatsch[4] . "', '" . $klatsch[5] . "', '" . $klatsch[6] . "', '" . $klatsch[7] . "', '" . $klatsch[8] . "', '" . $klatsch[9] . "', '" . $klatsch[10] . "', '" . $klatsch[11] . "', '" . $klatsch[12] . "', '" . $klatsch[13] . "', '" . $klatsch[14] . "', '" . $klatsch[15] . "', '0', '0', '0', '0', '0', '0' );";
$selectResult = mysql_query($select);
$eid = mysql_insert_id($dbh);
$select = "INSERT INTO `events` ( `id` , `type` , `eid` , `date` ) VALUES ('', '1', '" . $eid . "', '" . (date(U) + $rand) . "');";
$selectResult = mysql_query($select);
}
$einheiten = str_replace("'", '`', $einheiten);
$select = "UPDATE `hangar` SET `einh1` = '" . $hangar['einh1'] . "', `einh2` = '" . $hangar['einh2'] . "', `einh3` = '" . $hangar['einh3'] . "', `einh4` = '" . $hangar['einh4'] . "', `einh5` = '" . $hangar['einh5'] . "', `einh6` = '" . $hangar['einh6'] . "', `einh7` = '" . $hangar['einh7'] . "', `einh8` = '" . $hangar['einh8'] . "', `einh9` = '" . $hangar['einh9'] . "', `einh10` = '" . $hangar['einh10'] . "', `einh11` = '" . $hangar['einh11'] . "', `einh12` = '" . $hangar['einh12'] . "', `einh13` = '" . $hangar['einh13'] . "', `einh14` = '" . $hangar['einh14'] . "', `einh15` = '" . $hangar['einh15'] . "' WHERE `omni` = '" . $row['start'] . "' LIMIT 1;";
mysql_query($select);
if ($ressiupdate != 0) {
$eingelagert = "Die Ressourcen wurden <b>NICHT</b>erfolgreich eingelagert.<br />DAS IST EIN BUG, BITTE MELDEN!!!!!!!!!";
}
if ($row['type'] == 1) {
$from = "vom Angriff auf " . $row['ziel'];
} elseif ($row['type'] == 2) {
$from = "vom Transport nach " . $row['ziel'];
} elseif ($row['type'] == 3) {
$from = "von der Überführung zu " . $row['ziel'];
} elseif ($row['type'] == 4) {
$from = "vom Sammeln bei " . $row['ziel'];
}
$select = "INSERT INTO `berichte` ( `id` , `from` , `to` , `timestamp` , `gelesen` , `subject` , `text` ) VALUES ( '', 'Missionszentrum', '" . $row['start'] . "', '" . $row['return'] . "', '0', 'Rückkehr " . $from . "', 'Einheiten sind zurückgekehrt:<br />" . $einheiten . "<br /> und haben <br />" . $row['eisen'] . " Eisen<br />" . $row['titan'] . " Titan<br /> " . $row['oel'] . " Oel<br />" . $row['uran'] . " Uran<br />" . $row['gold'] . " Gold<br />" . $row['chanje'] . " Chanje<br />geliefert. <br />" . $eingelagert . "<br /> " . $geklatscht . "' );";
mysql_query($select);
$select = "DELETE FROM `missionen` WHERE `parsed` = '1' AND `id` = '" . $row['id'] . "' LIMIT 1;";
mysql_query($select);
}
}
}
do {
$i++;
$deinh += $_POST['de' . $i];
} while ($i < 15);
$i = 4;
do {
$i++;
$deinh += $_POST['dd' . $i];
} while ($i < 10);
$i = 0;
if ($_POST['sim'] == 1 and $oeinh > 600) {
$result = "Du kannst nur Angriffe mit 600 Einheiten jeweils planen.";
} elseif ($_POST['sim'] == 1 and $deinh > 600) {
$result = "Du kannst nur Angriffe mit 600 Einheiten jeweils planen.";
} elseif ($_POST['sim'] == 1) {
$result = kampf();
} else {
$result = "<center><b>noch kein Kampf berechnet</b></center>";
}
$content .= template('kampfsim');
$content = tag2value('result', $result, $content);
$content = tag2value('o_f', $_POST['o_f'], $content);
$content = tag2value('d_f', $_POST['d_f'], $content);
do {
$i++;
$content = tag2value('einh' . $i, $einh[$i]['name'], $content);
$content = tag2value('oe' . $i, $_POST['oe' . $i], $content);
$content = tag2value('de' . $i, $_POST['de' . $i], $content);
} while ($i < 15);
$i = 4;
do {
