function addGalaxieSekScans($galaxiemitglieder) { global $Benutzer; global $SQL_DBConn; for ($i = 0; $i < sizeof($galaxiemitglieder); $i++) { echo $galaxiemitglieder[$i]["galaxie"] . ":" . $galaxiemitglieder[$i]["planet"] . " " . $galaxiemitglieder[$i]["name"] . " -> " . $galaxiemitglieder[$i]["punkte"] . "<br>\n"; addgnuser($galaxiemitglieder[$i]["galaxie"], $galaxiemitglieder[$i]["planet"], $galaxiemitglieder[$i]["name"]); $delcommand = "DELETE FROM `gn4scans` WHERE rg='" . $galaxiemitglieder[$i]["galaxie"] . "' AND rp='" . $galaxiemitglieder[$i]["planet"] . "' AND type='0';"; $SQL_Result = tic_mysql_query($delcommand, $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error()); $addcommand = "INSERT INTO `gn4scans` (type, zeit, g, p, rg, rp, gen, pts, s, d, me, ke, a)\n\t\tVALUES ('0', '" . date("H:i d.m.Y") . "', '" . $Benutzer['galaxie'] . "', '" . $Benutzer['planet'] . "', '" . $galaxiemitglieder[$i]["galaxie"] . "', '" . $galaxiemitglieder[$i]["planet"] . "', '99', '" . $galaxiemitglieder[$i]["punkte"] . "', '" . $galaxiemitglieder[$i]["flotte"] . "', '" . $galaxiemitglieder[$i]["geschuetze"] . "', '" . $galaxiemitglieder[$i]["mextraktoren"] . "', '" . $galaxiemitglieder[$i]["kextraktoren"] . "', '" . $galaxiemitglieder[$i]["asteroiden"] . "');"; $SQL_Result = tic_mysql_query($addcommand, $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error()); } }
} if (!isset($_POST['txtAccGalaxie'])) { $_POST['txtAccGalaxie'] = ''; } if (!isset($_POST['txtAccPlanet'])) { $_POST['txtAccPlanet'] = ''; } if (!isset($_POST['txtAccPasswort'])) { $_POST['txtAccPasswort'] = ''; } if (!isset($_POST['lstAllianz'])) { $_POST['lstAllianz'] = ''; } if (!isset($_POST['lstRang'])) { $_POST['lstRang'] = 0; } if ($_POST['txtAccName'] == '' || $_POST['txtAccGalaxie'] == '' || $_POST['txtAccPlanet'] == '' || $_POST['txtAccPasswort'] == '' || $_POST['lstAllianz'] == '') { $error_code = 6; } else { if ($Benutzer['rang'] <= $_POST['lstRang']) { $error_code = 5; } else { addgnuser($_POST['txtAccGalaxie'], $_POST['txtAccPlanet'], $_POST['txtAccName']); $SQL_Result = tic_mysql_query('INSERT INTO `gn4accounts` (ticid, name, passwort, galaxie, planet, rang, allianz) VALUES ("' . $AllianzInfo[$_POST['lstAllianz']]['meta'] . '", "' . $_POST['txtAccName'] . '", "' . md5($_POST['txtAccPasswort']) . '","' . $_POST['txtAccGalaxie'] . '", "' . $_POST['txtAccPlanet'] . '", "' . $_POST['lstRang'] . '", "' . $_POST['lstAllianz'] . '")', $SQL_DBConn) or $error_code = 7; if ($error_code == 0) { LogAction("Account erstellt: Name=" . $_POST['txtAccName'] . "; Koordinaten=" . $_POST['txtAccGalaxie'] . ":" . $_POST['txtAccPlanet'] . "; Rang=" . $_POST['lstRang'] . "; Allianz=" . $_POST['lstAllianz'] . ";"); } } } } }
$ga = 0; } if (!isset($gr)) { $gr = 0; } if ($action == '') { header('Location: ./scan_help.html'); die; } $SQL_Result = tic_mysql_query('SELECT id, name, passwort FROM `gn4accounts` WHERE galaxie="' . $g . '" and passwort="' . md5($pw) . '" AND planet="' . $p . '";', $SQL_DBConn); if (mysql_num_rows($SQL_Result) != 1) { die("<html>\n<body>\nERROR 0 Spieler nicht gefunden\n</body>\n</html>"); } $name = mysql_result($SQL_Result, 0, 'name'); CountScans(mysql_result($SQL_Result, 0, 'id')); addgnuser($rg, $rp, $rn); if ($action == 'ss') { $SQL_Result = tic_mysql_query('DELETE FROM `gn4scans` WHERE rg="' . $rg . '" AND rp="' . $rp . '" AND type="0";', $SQL_DBConn); $insert_names = 'pts, s, d, me, ke, a'; $insert_values = '"' . $pts . '", "' . $s . '", "' . $d . '", "' . $me . '", "' . $ke . '", "' . $a . '"'; $SQL_Result = tic_mysql_query('INSERT INTO `gn4scans` (type, zeit, g, p, rg, rp, gen, ' . $insert_names . ') VALUES ("0", "' . date("H") . ':' . date("i") . ' ' . date("d") . '.' . date("m") . '.' . date("Y") . '", "' . $g . '", "' . $p . '", "' . $rg . '", "' . $rp . '", "' . $gen . '", ' . $insert_values . ');', $SQL_DBConn) or die("<html>\n<body>\nERROR 2 Konnte Datensatz nicht schreiben\n</body>\n</html>"); } if ($action == 'se') { $SQL_Result = tic_mysql_query('DELETE FROM `gn4scans` WHERE rg="' . $rg . '" AND rp="' . $rp . '" AND type="1";', $SQL_DBConn); $insert_names = 'sfj, sfb, sff, sfz, sfkr, sfsa, sft, sfko, sfka, sfsu'; $insert_values = '"' . $sfj . '", "' . $sfb . '", "' . $sff . '", "' . $sfz . '", "' . $sfkr . '", "' . $sfsa . '", "' . $sft . '", "' . $sfko . '", "' . $sfka . '", "' . $sfsu . '"'; $SQL_Result = tic_mysql_query('INSERT INTO `gn4scans` (type, zeit, g, p, rg, rp, gen, ' . $insert_names . ') VALUES ("1", "' . date("H") . ':' . date("i") . ' ' . date("d") . '.' . date("m") . '.' . date("Y") . '", "' . $g . '", "' . $p . '", "' . $rg . '", "' . $rp . '", "' . $gen . '", ' . $insert_values . ');', $SQL_DBConn) or die("<html>\n<body>\nERROR 2 Konnte Datensatz nicht schreiben\n</body>\n</html>"); } if ($action == 'sm') { $SQL_Result = tic_mysql_query('DELETE FROM `gn4scans` WHERE rg="' . $rg . '" AND rp="' . $rp . '" AND type="2";', $SQL_DBConn); $insert_names = 'sf0j, sf0b, sf0f, sf0z, sf0kr, sf0sa, sf0t, sf0ko, sf0ka, sf0su';
$qry = $qry . ', ' . $scan['27'] . ', ' . $scan['28'] . ', ' . $scan['29'] . ', ' . $scan['30'] . ', ' . $scan['31'] . ', ' . $scan['32'] . ', ' . $scan['33']; $formart = 'sf0ka, sf0su, sf0f, sf0z, sf0kr, sf0sa, sf0t, sf0j, sf0b'; $formart = $formart . ', sf1ka, sf1su, sf1f, sf1z, sf1kr, sf1sa, sf1t, sf1j, sf1b'; $formart = $formart . ', sf2ka, sf2su, sf2f, sf2z, sf2kr, sf2sa, sf2t, sf2j, sf2b'; } if ($scan['1'] == 'Geschützscan') { $modi = 3; $qry = $scan['5'] . ', ' . $scan['6'] . ', ' . $scan['7'] . ', ' . $scan['8'] . ', ' . $scan['9']; $formart = 'glo, glr, gmr, gsr, ga'; } if (isset($modi)) { $koords = explode(":", $scan['4']); $koord = explode(":", $_GET['koord']); tic_mysql_query('DELETE FROM `gn4scans` WHERE rg="' . $koords['0'] . '" AND rp="' . $koords['1'] . '" AND type="' . $modi . '";', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error()); tic_mysql_query('INSERT INTO `gn4scans` (p, g, type, zeit, rg, rp, gen, ' . $formart . ') VALUES ("' . $koord['0'] . '", "' . $koord['1'] . '", "' . $modi . '", "' . date("H:i d.m.Y") . '", "' . $koords['0'] . '", "' . $koords['1'] . '", "' . $scan['2'] . '", ' . $qry . ');', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error()); addgnuser($koords['0'], $koords['1'], $scan['3']); } } elseif ($_GET['modus'] == 7) { if (isset($_GET['auth'])) { $SQL_Result = tic_mysql_query('SELECT * FROM `gn4accounts` WHERE authnick="' . $_GET['auth'] . '";', $SQL_DBConn) or die(mysql_errno() . " - " . mysql_error()); $ok = 'ok'; if (mysql_num_rows($SQL_Result) != 1) { $ok = 'fail ' . mysql_num_rows($SQL_Result); } else { $ticid = mysql_result($SQL_Result, 0, 'ticid'); $ally = mysql_result($SQL_Result, 0, 'allianz'); $status = mysql_result($SQL_Result, 0, 'spy'); $rang = mysql_result($SQL_Result, 0, 'rang'); echo $ok . '|' . $status . '|' . $ticid . '|' . $ally . '|' . $rang; } }
LogAction('Koordinaten für ID=' . $_POST['uid'] . ' ([' . $AllianzInfo[$userchange['allianz']]['tag'] . '] ' . $userchange['name'] . ') geändert auf ' . $_POST['planet'] . '.'); } else { $sql = 'UPDATE `gn4accounts` SET galaxie="' . $_POST['selgala'] . '" WHERE id=' . $_POST['uid']; addgnuser($_POST['selgala'], $selplanet, $_POST['selname']); LogAction('Koordinaten für ID=' . $_POST['uid'] . ' ([' . $AllianzInfo[$userchange['allianz']]['tag'] . '] ' . $userchange['name'] . ') geändert auf ' . $_POST['selgala'] . '.'); } } } elseif ($_POST['change'] == 'pw') { $sql = 'UPDATE `gn4accounts` SET pwdandern="1", passwort="' . md5($_POST['pw']) . '" WHERE id=' . $_POST['uid']; LogAction('Passwort für ID=' . $_POST['uid'] . ' ([' . $AllianzInfo[$userchange['allianz']]['tag'] . '] ' . $userchange['name'] . ') neu vergeben.'); } elseif ($_POST['change'] == 'allianz') { $sql = 'UPDATE `gn4accounts` SET allianz="' . $_POST['allianz'] . '", ticid="' . $AllianzInfo[$_POST['allianz']]['meta'] . '" WHERE id=' . $_POST['uid']; LogAction('AllianzID für ID=' . $_POST['uid'] . ' ([' . $AllianzInfo[$userchange['allianz']]['tag'] . '] ' . $userchange['name'] . ') geändert auf ' . $_POST['allianz'] . ' ([' . $AllianzInfo[$_POST['allianz']]['tag'] . ']).'); } elseif ($_POST['change'] == 'name') { $sql = 'UPDATE `gn4accounts` SET name="' . $_POST['name'] . '" WHERE id=' . $_POST['uid']; addgnuser($_POST['selgala'], $selplanet, $_POST['name']); LogAction('Name für ID=' . $_POST['uid'] . ' ([' . $AllianzInfo[$userchange['allianz']]['tag'] . '] ' . $userchange['name'] . ') geändert auf ' . $_POST['name'] . '.'); } elseif ($_POST['change'] == 'umode') { if ($_POST['umode'] == 'on') { if (!isset($_POST['umodedate']) || $_POST['umodedate'] == '') { $_POST['umodedate'] = "tt.mm.jjjj"; } $sql = 'UPDATE `gn4accounts` SET umod="' . date("d") . '.' . date("m") . '.' . date("Y") . '-' . $_POST['umodedate'] . '" WHERE id="' . $_POST['uid'] . '"'; LogAction('Umode für ID=' . $_POST['uid'] . ' ([' . $AllianzInfo[$userchange['allianz']]['tag'] . '] ' . $userchange['name'] . ') gesetzt.'); } else { $sql = 'UPDATE `gn4accounts` SET umod="" WHERE id=' . $_POST['uid']; LogAction('Umode für ID=' . $_POST['uid'] . ' ([' . $AllianzInfo[$userchange['allianz']]['tag'] . '] ' . $userchange['name'] . ') gelöscht.'); } } elseif ($_POST['change'] == 'spy') { if ($_POST['spy'] == 'gesperrt') { $sql = 'UPDATE `gn4accounts` SET spy="1" WHERE id=' . $_POST['uid'];
function mili_write_to_db() { global $SQL_DBConn, $Benutzer; $trg = $_POST['galakoord']; $trp = $_POST['planetkoord']; $ttype = 2; $tgen = 99; $tsf0ko = 0; $tsf1ko = 0; $tsf2ko = 0; $tstatus0 = 4; $tstatus1 = 4; $tstatus2 = 4; $SQL_Result = tic_mysql_query('DELETE FROM `gn4scans` WHERE rg="' . $trg . '" AND rp="' . $trp . '" AND type="' . $ttype . '";', $SQL_DBConn); $insert_names = 'sf0j, sf0b, sf0f, sf0z, sf0kr, sf0sa, sf0t, sf0ka, sf0su'; $insert_names = $insert_names . ', sf1j, sf1b, sf1f, sf1z, sf1kr, sf1sa, sf1t, sf1ka, sf1su, status1'; $insert_names = $insert_names . ', sf2j, sf2b, sf2f, sf2z, sf2kr, sf2sa, sf2t, sf2ka, sf2su, status2'; $insert_values = '"' . $_POST['tsf0j'] . '", "' . $_POST['tsf0b'] . '", "' . $_POST['tsf0f'] . '", "' . $_POST['tsf0z'] . '", "' . $_POST['tsf0kr'] . '", "' . $_POST['tsf0sa'] . '", "' . $_POST['tsf0t'] . '", "' . $_POST['tsf0ka'] . '", "' . $_POST['tsf0su'] . '"'; $insert_values = $insert_values . ', "' . $_POST['tsf1j'] . '", "' . $_POST['tsf1b'] . '", "' . $_POST['tsf1f'] . '", "' . $_POST['tsf1z'] . '", "' . $_POST['tsf1kr'] . '", "' . $_POST['tsf1sa'] . '", "' . $_POST['tsf1t'] . '", "' . $_POST['tsf1ka'] . '", "' . $_POST['tsf1su'] . '", "' . $_POST['tstatus1'] . '"'; $insert_values = $insert_values . ', "' . $_POST['tsf2j'] . '", "' . $_POST['tsf2b'] . '", "' . $_POST['tsf2f'] . '", "' . $_POST['tsf2z'] . '", "' . $_POST['tsf2kr'] . '", "' . $_POST['tsf2sa'] . '", "' . $_POST['tsf2t'] . '", "' . $_POST['tsf2ka'] . '", "' . $_POST['tsf2su'] . '", "' . $_POST['tstatus2'] . '"'; addgnuser($trg, $trp, $_POST['trn']); $SQL_Result = tic_mysql_query('INSERT INTO `gn4scans` (type, zeit, g, p, rg, rp, gen, ' . $insert_names . ') VALUES ("' . $ttype . '", "' . date("H") . ':' . date("i") . ' ' . date("d") . '.' . date("m") . '.' . date("Y") . '", "' . $Benutzer['galaxie'] . '", "' . $Benutzer['planet'] . '", "' . $trg . '", "' . $trp . '", "' . $tgen . '", ' . $insert_values . ');', $SQL_DBConn) or die('ERROR 2 Konnte Datensatz nicht schreiben'); $ttype = 1; // j�er $_POST['tsfj'] = $_POST['tsf0j'] + $_POST['tsf1j'] + $_POST['tsf2j']; // bomber $_POST['tsfb'] = $_POST['tsf0b'] + $_POST['tsf1b'] + $_POST['tsf2b']; // fregs $_POST['tsff'] = $_POST['tsf0f'] + $_POST['tsf1f'] + $_POST['tsf2f']; // zerries $_POST['tsfz'] = $_POST['tsf0z'] + $_POST['tsf1z'] + $_POST['tsf2z']; // kreuzer $_POST['tsfkr'] = $_POST['tsf0kr'] + $_POST['tsf1kr'] + $_POST['tsf2kr']; // schlachter $_POST['tsfsa'] = $_POST['tsf0sa'] + $_POST['tsf1sa'] + $_POST['tsf2sa']; // tr�er $_POST['tsft'] = $_POST['tsf0t'] + $_POST['tsf1t'] + $_POST['tsf2t']; // komisches ding $sfko = 0; // Kaper $_POST['tsfka'] = $_POST['tsf0ka'] + $_POST['tsf1ka'] + $_POST['tsf2ka']; // schutzies $_POST['tsfsu'] = $_POST['tsf0su'] + $_POST['tsf1su'] + $_POST['tsf2su']; $SQL_Result = tic_mysql_query('DELETE FROM `gn4scans` WHERE rg="' . $trg . '" AND rp="' . $trp . '" AND type="' . $ttype . '";', $SQL_DBConn); $insert_names = 'sfj, sfb, sff, sfz, sfkr, sfsa, sft, sfka, sfsu'; $insert_values = '"' . $_POST['tsfj'] . '", "' . $_POST['tsfb'] . '", "' . $_POST['tsff'] . '", "' . $_POST['tsfz'] . '", "' . $_POST['tsfkr'] . '", "' . $_POST['tsfsa'] . '", "' . $_POST['tsft'] . '", "' . $_POST['tsfka'] . '", "' . $_POST['tsfsu'] . '"'; $SQL_Result = tic_mysql_query('INSERT INTO `gn4scans` (type, zeit, g, p, rg, rp, gen, ' . $insert_names . ') VALUES ("' . $ttype . '", "' . date("H") . ':' . date("i") . ' ' . date("d") . '.' . date("m") . '.' . date("Y") . '", "' . $Benutzer['galaxie'] . '", "' . $Benutzer['planet'] . '", "' . $trg . '", "' . $trp . '", "' . $tgen . '", ' . $insert_values . ');', $SQL_DBConn) or die('ERROR 2 Konnte Datensatz nicht schreiben'); addgnuser($trg, $trp, $_POST['trn']); // ??? $txtScanGalaxie = $_POST['galakoord']; $txtScanPlanet = $_POST['planetkoord']; }
} $_ruckflug = $_flugzeit + $rfdauer * $tsec; //echo "rfdauer = $rfdauer<br />"; } if ($modus == "rueckflug" || $modus == "rueckflug_angreifen" || $modus == "rueckflug_verteidigen") { $_ankunft = 0; $_flugzeit = 0; $_ruckflug = $_time + $lst_ETA * $tsec; } if (!isset($tparser)) { $tparser = 0; } // echo "Modus: ".$modus." / AG: ".$txt_Angreifer_Galaxie." / AP: ".$txt_Angreifer_Planet." / VG: ".$txt_Verteidiger_Galaxie." / VP: ".$txt_Verteidiger_Planet." / ETA: ".$lst_ETA." / Flug: ".$lst_Flugzeit."<br>\n"; if ($form_ok) { addgnuser($txt_Angreifer_Galaxie, $txt_Angreifer_Planet, $txt_Angreifer_Name); addgnuser($txt_Verteidiger_Galaxie, $txt_Verteidiger_Planet, $txt_Verteidiger_Name); $SQL_names = "modus, ticid, angreifer_galaxie, angreifer_planet, verteidiger_galaxie, verteidiger_planet, eta, flugzeit, flottennr, ankunft, flugzeit_ende, ruckflug_ende, erfasser, erfasst_am"; $SQL_values = '"' . $Benutzer['ticid'] . '", "' . $txt_Angreifer_Galaxie . '", "' . $txt_Angreifer_Planet . '", "' . $txt_Verteidiger_Galaxie . '", "' . $txt_Verteidiger_Planet . '", "' . $lst_ETA . '", "' . $lst_Flugzeit . '", "' . $lst_Flotte . '","' . $_ankunft . '", "' . $_flugzeit . '", "' . $_ruckflug . '", "' . $erfasser . '", "' . date("H") . ':' . date("i") . ' Uhr am ' . date("d") . '.' . date("m") . '.' . date("Y") . '"'; if ($modus == 'angreifen') { $SQL_Result = tic_mysql_query('INSERT INTO `gn4flottenbewegungen` (' . $SQL_names . ', tparser, save) VALUES ("1", ' . $SQL_values . ', ' . $tparser . ', ' . $txt_not_safe . ');', $SQL_DBConn) or $error_code = 7; } elseif ($modus == 'verteidigen') { $SQL_Result = tic_mysql_query('INSERT INTO `gn4flottenbewegungen` (' . $SQL_names . ', tparser) VALUES ("2", ' . $SQL_values . ', ' . $tparser . ');', $SQL_DBConn) or $error_code = 7; } elseif ($modus == 'rueckflug_angreifen') { $SQL_Result = tic_mysql_query('INSERT INTO `gn4flottenbewegungen` (' . $SQL_names . ') VALUES ("3", ' . $SQL_values . ');', $SQL_DBConn) or $error_code = 7; } elseif ($modus == 'rueckflug_verteidigen') { $SQL_Result = tic_mysql_query('INSERT INTO `gn4flottenbewegungen` (' . $SQL_names . ') VALUES ("4", ' . $SQL_values . ');', $SQL_DBConn) or $error_code = 7; } elseif ($modus == 'rueckflug') { $SQL_Result = tic_mysql_query('INSERT INTO `gn4flottenbewegungen` (' . $SQL_names . ') VALUES ("0", ' . $SQL_values . ');', $SQL_DBConn) or $error_code = 7; } } else { $error_code = 6;