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;
