public function showStatus()
{
if ($this->_sock !== null) {
return getTimestamp() . " Listening on {$this->_host}:{$this->_port}\n";
} else {
return getTimestamp() . " Not listening yet. Configured for {$this->_host}:{$this->_port}\n";
}
}
public function adicionar($conexao, $acao, $oQue, $quem, $qual)
{
try {
$timestamp = getTimestamp();
$conexao->query()->from("logs")->save(array("acao" => $acao, "oque" => $oQue, "quem" => $quem, "qual" => $qual, "data" => getData($timestamp), "timestampData" => $timestamp));
} catch (Exception $e) {
throw $e;
}
}
function isContractOptionAvailable($playerData, $durationDays)
{
if (!isset($playerData['vertrag'])) {
throw new Exception('Property "vertrag" not set in player data');
} elseif (!isset($playerData['wiealt'])) {
throw new Exception('Property "wiealt" not set in player data');
} elseif (!isset($playerData['moral'])) {
throw new Exception('Property "moral" not set in player data');
} else {
return $playerData['vertrag'] < getTimestamp('+' . $durationDays . ' days') && ($playerData['wiealt'] + GAME_DAYS_TO_REAL_DAYS_RATIO * $durationDays) / 365 < 35 && $playerData['moral'] >= getMinMoraleRequired($durationDays);
}
}
public function setUp()
{
parent::setUp();
$this->adapter = $this->getMockForAbstractClass('DynamicTable\\Adapter\\GenericDBAdapter');
$this->adapter->setSelect('*');
$this->adapter->setFrom('users');
$this->adapter->setWhere("");
$this->adapter->setParams([]);
$this->table = new Table();
$this->table->setAdapter($this->adapter);
$this->table->setColumns(['id' => ['title' => 'ID', 'sql_id' => 'id', 'type' => Table::TYPE_INTEGER, 'filters' => [Table::FILTER_EQUAL], 'sortable' => true, 'visible' => false], 'string' => ['title' => 'String', 'sql_id' => 'string', 'type' => Table::TYPE_STRING, 'filters' => [Table::FILTER_LIKE, Table::FILTER_NULL], 'sortable' => true, 'visible' => true], 'integer' => ['title' => 'Integer', 'sql_id' => 'integer', 'type' => Table::TYPE_INTEGER, 'filters' => [Table::FILTER_BETWEEN], 'sortable' => true, 'visible' => true], 'float' => ['title' => 'Float', 'sql_id' => 'float', 'type' => Table::TYPE_FLOAT, 'filters' => [Table::FILTER_NULL], 'sortable' => true, 'visible' => true], 'boolean' => ['title' => 'Boolean', 'sql_id' => 'boolean', 'type' => Table::TYPE_BOOLEAN, 'filters' => [Table::FILTER_EQUAL, Table::FILTER_NULL], 'sortable' => true, 'visible' => true], 'datetime' => ['title' => 'DateTime', 'sql_id' => 'datetime', 'type' => Table::TYPE_DATETIME, 'filters' => [Table::FILTER_NULL], 'sortable' => true, 'visible' => true]]);
$this->table->setMapper(function ($row) {
$result = $row;
if ($row['datetime'] !== null) {
$result['datetime'] = $row['datetime'] . getTimestamp();
}
return $result;
});
}
mysql_query("INSERT INTO login ( CODLOGIN, DTA, LOGIN, SENHA, PAPEL, OWNER, STATUS) VALUES ( '{$codlogin}', CURRENT_TIMESTAMP, '{$login}', '{$senha}', '{$administrador}{$gerente}{$guest}', '{$_SESSION['CODPESSOA']}', '{$status}' )");
mysql_query("INSERT INTO pessoa ( CODPESSOA, NOME, DTA, OWNER, SEXO, EMAIL) VALUES ( '{$codpessoa}', '{$nome_sobrenome}', CURRENT_TIMESTAMP, '" . $_SESSION['CODPESSOA'] . "', '" . $_POST['ISITEM'] . "', '{$email}' )");
mysql_query("INSERT INTO login_rel_pessoa ( `CODLOGIN`,`CODPESSOA`) VALUES ( '{$codlogin}', '{$codpessoa}')");
echo "<script>alert('* " . getLabel('LABEL_ADD_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!)</script>";
echo "<script>window.location = 'index.php?actionType=gerenciar.usuarios';</script>";
}
}
} else {
$erro = getLabel('ERRO_PREENCHER_TODOS_CAMPOS', $_SESSION['LANGUAGE']);
}
$pi = "<form name='formCpf' method='post' action='index.php?actionType=gerenciar.usuarios.add'>";
$pi .= "<div class='ErroMessage'>* {$erro}!</div>";
$pi .= "<br/>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div>";
$CODLOGIN = strtoupper(md5(getTimestamp()));
$pi .= "<input type='hidden' name='CODLOGIN' value='{$CODLOGIN}'/>";
$pi .= "</div>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div class='EntradaTextForm'>";
if (!empty($_POST)) {
$pi .= "<input class='LiloginText' style='width: 250px' type='text' id='nome' name='nome' value='" . $_POST['nome'] . "' maxlength='70' placeholder='" . getLabel('LABEL_NAME', $_SESSION['LANGUAGE']) . "'/>";
} else {
$pi .= "<input class='LiloginText' style='width: 250px' type='text' id='nome' name='nome' value='' maxlength='70' placeholder='" . getLabel('LABEL_NAME', $_SESSION['LANGUAGE']) . "'/>";
}
$pi .= "</div>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div class='EntradaTextForm'>";
if (!empty($_POST)) {
$pi .= "<input class='LiloginText' style='width: 250px' type='text' id='sobrenome' name='sobrenome' value='" . $_POST['sobrenome'] . "' maxlength='70' placeholder='" . getLabel('LABEL_SOBRENOME', $_SESSION['LANGUAGE']) . "'/>";
} else {
if (isset($conceptTableInfo['SESSION'])) {
if (!isset($sessionAtom) || !isAtomInConcept($sessionAtom, 'SESSION')) {
echo '<div class="MenuItem" id="MenuBarLogout"><a href="index.php?Login"><span class=TextContent>Loginx</span></a></div>';
} else {
echo '<div class="MenuItem" id="MenuBarLogout"><a href="javascript:resetSession()"><span class=TextContent>Logout</span></a></div>';
}
}
if ($isDev) {
echo '<div class="MenuItem" id="MenuBarReset"><a href="javascript:resetDatabase()"><span class=TextContent>Reset</span></a></div>';
}
echo '</div>';
// .MenuBar
echo '</div>';
// #TopLevelInterfaces
genNewAtomDropDownMenu();
$timeStamp = getTimestamp($err);
// access database to see if it is there
if ($err) {
echo '<br/>Cannot access database. Make sure the MySQL server is running, or <a href="javascript:resetDatabase()">create a new database</span></a>.';
} else {
if (isset($_REQUEST['Login'])) {
echo '<div id=AmpersandRoot>';
Login();
echo '</dev>';
} else {
if (isset($_REQUEST['CheckLogin'])) {
echo '<div id=AmpersandRoot>';
CheckLogin();
echo '</dev>';
} else {
if (!isset($_REQUEST['interface']) || !isset($_REQUEST['atom'])) {
if (mysql_affected_rows() > 0) {
$upd1 = "UPDATE " . $prefix . "teams SET scout = " . $temp . " WHERE ids = '" . $cookie_team . "'";
$upd2 = mysql_query($upd1);
$_SESSION['scout'] = $temp;
$cookie_scout = $temp;
// PROTOKOLL ANFANG
$formulierung = __('Du hast einen Scout der Stufe %d eingestellt.', $temp);
$sql7 = "INSERT INTO " . $prefix . "protokoll (team, text, typ, zeit) VALUES ('" . $cookie_team . "', '" . $formulierung . "', 'Assistenten', '" . time() . "')";
$sql8 = mysql_query($sql7);
// PROTOKOLL ENDE
setTaskDone('change_workers');
} else {
$ch1 = "SELECT zeit FROM " . $prefix . "personal_changes WHERE team = '" . $cookie_team . "' AND personal = 'Scout'";
$ch2 = mysql_query($ch1);
$ch3 = mysql_fetch_assoc($ch2);
addInfoBox(__('Du kannst jeden Assistenten nur alle 22 Tage austauschen. Du musst also noch bis %s warten.', date('d.m.Y H:i', getTimestamp('+22 days', $ch3['zeit']))));
}
}
}
$sql1 = "SELECT scout FROM " . $prefix . "teams WHERE ids = '" . $cookie_team . "'";
$sql2 = mysql_query($sql1);
$sql3 = mysql_fetch_assoc($sql2);
?>
<div style="float:left; width:280px;">
<form action="/ver_personal.php" method="post" accept-charset="utf-8">
<p>
<input type="radio" name="scout" value="1" <?php
if ($sql3['scout'] == 1) {
echo 'checked="checked" ';
}
?>
echo '<h1>' . _('Testspiel vereinbaren') . '</h1><p><strong>' . _('Zu spät:') . '</strong> ' . _('In dieser Saison können leider keine Testspiele mehr vereinbart werden.') . '</p>';
} elseif ($getkonto4 < Friendlies::getPrice($cookie_liga, $prefix)) {
echo '<h1>' . _('Testspiel vereinbaren') . '</h1><p><strong>' . _('Zu teuer:') . '</strong> ' . _('Im Moment hast Du leider nicht genügend Geld, um ein Testspiel vereinbaren zu können.') . '</p>';
} else {
$optionsStr = '';
$optionsStr .= '<h1>' . _('Testspiel vereinbaren') . '</h1>';
$optionsStr .= '<p><strong>' . _('Wichtig:') . '</strong> ' . __('Das Testspiel findet immer im Stadion des Anfragenden statt. Beide Teams müssen für ein Testspiel eine Entschädigung an den Verband zahlen, damit das Spiel genehmigt wird. Für Dich sind das %s €.', number_format(Friendlies::getPrice($cookie_liga, $prefix), 0, ',', '.')) . '</p>';
$optionsStr .= '<form action="/testspiel_anfrage.php" method="get" accept-charset="utf-8">';
$heute_tag = date('d', time());
$heute_monat = date('m', time());
$heute_jahr = date('Y', time());
$datum_spiel = mktime(23, 00, 00, $heute_monat, $heute_tag, $heute_jahr);
$nochMoeglicheTage = 0;
$optionsStr .= '<p><select name="datum" size="1" style="width:200px">';
for ($d = 2; $d < $gesp3_noch; $d++) {
$datum_spiel_temp = getTimestamp('+' . $d . ' days', $datum_spiel);
if (!in_array($datum_spiel_temp, $testspiel_tage)) {
$optionsStr .= '<option value="' . $datum_spiel_temp . '">' . date('d.m.Y', $datum_spiel_temp) . '</option>';
$nochMoeglicheTage++;
}
}
$optionsStr .= '</select>';
$optionsStr .= ' <input type="hidden" name="id" value="' . $sql3['team'] . '" /><input type="submit" value="' . _('Anfragen') . '"' . noDemoClick($cookie_id) . ' /></p>';
$optionsStr .= '</form>';
if ($nochMoeglicheTage == 0) {
echo '<h1>' . _('Testspiel vereinbaren') . '</h1><p>' . _('Eure Vereine haben keine freien Termine mehr für ein Testspiel.') . '</p>';
} else {
echo $optionsStr;
}
}
} else {
$json_response = json_decode($json_response, true);
$json_response = $json_response['BookMyShow'];
foreach ($json_response['arrEvent'] as $event) {
if ($event['arrVenues'][0]['RegionCode'] != 'NCR') {
continue;
}
$event_name = trim(str_replace("'", "", $event['EventTitle']));
$event_description = htmlspecialchars(trim($event['EventSynopsis']), ENT_QUOTES);
$category_array = $event['GenreArray'];
$date = (int) $event['arrDates'][0]['ShowDateCode'];
$date_year = (int) ($date / 10000);
$date = $date % 10000;
$date_month = (int) ($date / 100);
$date = $date % 100;
$date = $date_year . "-" . $date_month . "-" . $date;
$date = getTimestamp(strtotime($date));
$lat = (double) $event['arrVenues'][0]['VenueLatitude'];
$lng = (double) $event['arrVenues'][0]['VenueLongitude'];
$venueName = $event['arrVenues'][0]['VenueName'];
$image = $event['BannerURL'];
$link = $event['FShareURL'];
if ($link == '') {
$link = $event['EventWebViewURL'];
}
$query = "INSERT INTO `events` (`name`,`description`,`start_time`,`link`,`venue`,`latitude`,`longitude`,`image_url`) VALUES ('{$event_name}','{$event_description}','{$date}','{$link}','{$venueName}','{$lat}','{$lng}','{$image}')";
if (mysqli_query($connection, $query)) {
$id = mysqli_insert_id($connection);
foreach ($category_array as $cat) {
$cat_id = array_search($cat, $static_categories);
$temp = (int) $cat_id;
$temp++;
<?php
if ($loggedin == 1) {
setTaskDone('players_development');
echo '<table>';
echo '<thead>';
echo '<tr>';
echo '<th scope="col">' . _('MT') . '</th>';
echo '<th scope="col">' . _('Spieler') . '</th>';
echo '<th scope="col">' . _('Alter') . '</th>';
echo '<th scope="col">' . _('Datum') . '</th>';
echo '<th scope="col">' . _('Alt') . '</th>';
echo '<th scope="col">' . _('Neu') . '</th>';
echo '</tr>';
echo '</thead>';
echo '<tbody>';
$delOld_Timeout = getTimestamp('-28 days');
$delOld1 = "DELETE FROM " . $prefix . "spielerEntwicklung WHERE team = '" . $cookie_team . "' AND zeit < " . $delOld_Timeout;
$delOld2 = mysql_query($delOld1);
$sql1 = "SELECT a.spieler, a.zeit, a.staerkeNeu, a.staerkeAlt, b.vorname, b.nachname, b.position, b.wiealt FROM " . $prefix . "spielerEntwicklung AS a JOIN " . $prefix . "spieler AS b ON a.spieler = b.ids WHERE a.team = '" . $cookie_team . "' ORDER BY a.zeit DESC LIMIT " . $start . ", " . $eintraege_pro_seite;
$sql2 = mysql_query($sql1);
$blaetter3 = anzahl_datensaetze_gesamt($sql1);
while ($sql3 = mysql_fetch_assoc($sql2)) {
echo '<tr>';
echo '<td>' . $sql3['position'] . '</td>';
echo '<td class="link"><a href="/spieler.php?id=' . $sql3['spieler'] . '">' . $sql3['vorname'] . ' ' . $sql3['nachname'] . ' </a></td>';
echo '<td>' . floor($sql3['wiealt'] / 365) . '</td>';
echo '<td>' . date('d.m.Y', $sql3['zeit']) . '</td>';
if ($sql3['staerkeAlt'] == $sql3['staerkeNeu']) {
echo '<td colspan="2">' . _('Höhepunkt') . ' (' . number_format($sql3['staerkeNeu'], 1, ',', '.') . ')</td>';
} else {
echo '<td>' . number_format($sql3['staerkeAlt'], 1, ',', '.') . '</td>';
<?php
acessoDireto("ADMINISTRADOR;");
$erro = "";
if (!empty($_POST) && isset($_POST['ACTION'])) {
$codcentralemails = strtoupper(md5(getTimestamp()));
$titulo = trim(htmlentities(tratapost($_POST['titulo'])));
$status = trim(tratapost($_POST['status']));
$status == 'on' ? $status = 1 : ($status = 0);
mysql_query("INSERT INTO `central_emails`( `CODCENTRALEMAILS`, `TITULO`, `STATUS`, `OWNER`) VALUES ( '{$codcentralemails}', '{$titulo}','{$status}','" . $_SESSION['CODPESSOA'] . "')");
echo "<script>alert('* " . getLabel('LABEL_ADD_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
echo "<script>window.location = 'index.php?actionType=gerenciar.emails';</script>";
exit;
} else {
$erro = getLabel('ERRO_PREENCHER_TODOS_CAMPOS', $_SESSION['LANGUAGE']);
}
$pi = "<form name='formCpf' method='post' action='index.php?actionType=gerenciar.emails.add'>";
$pi .= "<div class='ErroMessage'>* {$erro}!</div>";
$pi .= "<br/>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div class='EntradaTextForm'>";
if (!empty($_POST)) {
$pi .= "<input class='LiloginText' style='width: 250px' type='text' id='titulo' name='titulo' value='" . $_POST['titulo'] . "' maxlength='70' placeholder='" . getLabel('LABEL_TITULO', $_SESSION['LANGUAGE']) . "'/>";
} else {
$pi .= "<input class='LiloginText' style='width: 250px' type='text' id='titulo' name='titulo' value='' maxlength='70' placeholder='" . getLabel('LABEL_TITULO', $_SESSION['LANGUAGE']) . "'/>";
}
$pi .= "</div>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div>";
if (!empty($_POST)) {
$_POST['status'] == 'on' ? $pi .= "<input type='checkbox' name='status' checked='true'/> <span class='Userlabel'>" . getLabel('LABEL_ATIVO_TEXT', $_SESSION['LANGUAGE']) . "</span>" : ($pi .= "<input type='checkbox' name='status'/> <span class='Userlabel'>" . getLabel('LABEL_ATIVO_TEXT', $_SESSION['LANGUAGE']) . "</span>");
<?php
acessoDireto("ADMINISTRADOR;");
$erro = "";
if (!empty($_POST) && isset($_POST['ACTION'])) {
$codquarto = strtoupper(md5(getTimestamp()));
$codquartotipo = trim(htmlentities(tratapost($_POST['codquartotipo'])));
$nome = trim(htmlentities(tratapost($_POST['nome'])));
$status = trim(tratapost($_POST['status']));
$status == 'on' ? $status = 1 : ($status = 0);
mysql_query("INSERT INTO `quartos`( `CODQUARTO`, `NOME`, `STATUS`, `OWNER` ) VALUES ( '{$codquarto}', '{$nome}','{$status}','" . $_SESSION['CODPESSOA'] . "')");
mysql_query("INSERT INTO `quartos_rel_quartos_tipo`(`CODQUARTO`,`CODQUARTOTIPO`)VALUES('{$codquarto}','{$codquartotipo}')");
echo "<script>alert('* " . getLabel('LABEL_ADD_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
echo "<script>window.location = 'index.php?actionType=gerenciar.quartos';</script>";
exit;
} else {
$erro = getLabel('ERRO_PREENCHER_TODOS_CAMPOS', $_SESSION['LANGUAGE']);
}
$pi = "<form name='formCpf' method='post' action='index.php?actionType=gerenciar.quartos.add'>";
$pi .= "<div class='ErroMessage'>* {$erro}!</div>";
$pi .= "<br/>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div class='EntradaTextForm'>";
$quartos = mysql_query("SELECT * FROM quartos_tipo WHERE STATUS=1 ORDER BY NOME ASC");
if (mysql_num_rows($quartos) != 0) {
$pi .= "<select class='LiloginText' style='width: 250px' name='codquartotipo' id='codquartotipo' >";
while ($quarto = mysql_fetch_object($quartos)) {
if (!empty($_POST) && isset($_POST['ACTION'])) {
$_POST['codquartotipo'] == $quarto->CODQUARTOTIPO ? $pi .= "<option value='{$quarto->CODQUARTOTIPO}' selected>{$quarto->NOME}</option>" : ($pi .= "<option value='{$quarto->CODQUARTOTIPO}'>{$quarto->NOME}</option>");
} else {
$pi .= "<option value='{$quarto->CODQUARTOTIPO}'>{$quarto->NOME}</option>";
logLine(getTimestamp() . "," . memory_get_usage(), $memory_usage_log_file);
$last_memory_log_entry = time();
}
}
// for if the connection to the sql database gives out.
// TODO Find a better way to check the connection. I think on Shared Hosting Servers mysql_ping might be disabled which causes this to always reconnect.
// if (!mysql_ping($sql_connection)) {
// //here is the major trick, you have to close the connection (even though its not currently working) for it to recreate properly.
// mysql_close($sql_connection);
// logLine("__MySQL connection lost, reconnecting__\n");
// $sql_connection = mysql_connect($sugar_config['dbconfig']['db_host_name'], $sugar_config['dbconfig']['db_user_name'], $sugar_config['dbconfig']['db_password']);
// $sql_db = mysql_select_db($sugar_config['dbconfig']['db_name']);
// db_checked_query("SET time_zone='+00:00'");
// }
}
logLine(getTimestamp() . "Event loop terminated, attempting to login again\n");
sleep(1);
}
// TODO i've seen asteriskLogger crash due to a script executing too long error... It was on a pretty budget shared hosting server.
// Hasn't ever happened to me personally... but still something noteworthy.
exit(0);
// ******************
// Helper functions *
// ******************
function createCallId()
{
$query = "SELECT UUID() AS id";
$result = db_checked_query($query);
$row = $GLOBALS['db']->fetchByAssoc($result);
return $row['id'];
}
$teams6 = "INSERT INTO " . $prefix . "spiele (team1, team2, liga, typ, simuliert, datum) VALUES ('keins', 'keins', 'keine', 'Pokal', 1, '" . time() . "')";
$teams7 = mysql_query($teams6);
// 1 leeres Spiel in die DB schreiben, damit Pokal-Auslosung immer abgebrochen wird
}
// TEAMS HOLEN ENDE
// SPIELPAARUNGEN ANFANG
$startzeit = getTimestamp('+' . intval(($naechste_runde - 1) * 4) . ' days', $startzeit);
// 1 abziehen, weil fuer den 1. Spieltag 0x86400 addiert werden muss
shuffle($teamliste);
for ($r1 = 0; $r1 <= round(count($teamliste) / 2 - 1); $r1++) {
// for-Schleife fuer Spielpaarungen: bei 32 Teams gibt es [0..15]
$temporaer_liga = 'Pokal_Runde_' . $naechste_runde;
$temporaer_team1 = $teamliste[$r1];
$temporaer_team2 = $teamliste[count($teamliste) - $r1 - 1];
// 0vs32, 1vs31, ..., 15vs16
$kennung = md5($temporaer_team1 . $temporaer_team2);
$ins1 = "INSERT INTO " . $prefix . "spiele (liga, datum, team1, team2, typ, kennung) VALUES ('" . $temporaer_liga . "', '" . $startzeit . "', '" . $temporaer_team1 . "', '" . $temporaer_team2 . "', 'Pokal', '" . $kennung . "')";
$ins2 = mysql_query($ins1);
if ($naechste_runde < 5) {
$ins1 = "INSERT INTO " . $prefix . "spiele (liga, datum, team1, team2, typ, kennung) VALUES ('" . $temporaer_liga . "', '" . getTimestamp('+1 day', $startzeit) . "', '" . $temporaer_team2 . "', '" . $temporaer_team1 . "', 'Pokal', '" . $kennung . "')";
$ins2 = mysql_query($ins1);
}
}
// SPIELPAARUNGEN ENDE
// POKALERGEBIS SETZEN ANFANG
foreach ($teamliste as $teamliste_pr) {
$yxcvjhsd1 = "UPDATE " . $prefix . "teams SET pokalrunde = " . $naechste_runde . " WHERE name = '" . $teamliste_pr . "'";
$yxcvjhsd2 = mysql_query($yxcvjhsd1);
// aktualisiere die erreichte Pokalrunde
}
// POKALERGEBIS SETZEN ENDE
$spielplan = array();
while ($plan3 = mysql_fetch_assoc($plan2)) {
$spielplan[$plan3['spieltag']][] = array('%' . $plan3['team1'] . '%', '%' . $plan3['team2'] . '%');
}
$platzhalter = array('%1%', '%2%', '%3%', '%4%', '%5%', '%6%', '%7%', '%8%', '%9%', '%10%', '%11%', '%12%', '%13%', '%14%', '%15%', '%16%', '%17%', '%18%', '%19%', '%20%');
$counterStart = mktime(15, 0, 0, date('m', time()), date('d', time()), date('Y', time()));
$sql4 = "SELECT ids, land FROM " . $prefix . "ligen";
$sql5 = mysql_query($sql4);
while ($sql6 = mysql_fetch_assoc($sql5)) {
$counter = getTimestamp('+1 day', $counterStart);
$liga_id = $sql6['ids'];
$liga_land = mysql_real_escape_string($sql6['land']);
$sql7 = "SELECT name FROM " . $prefix . "teams WHERE liga = '" . $liga_id . "'";
$sql8 = mysql_query($sql7);
$mannschaften = array();
while ($sql9 = mysql_fetch_assoc($sql8)) {
$mannschaften[] = $sql9['name'];
}
shuffle($mannschaften);
foreach ($spielplan as $spieltag) {
foreach ($spieltag as $begegnung) {
$team1 = str_replace($platzhalter, $mannschaften, $begegnung[0]);
$team1 = mysql_real_escape_string($team1);
$team2 = str_replace($platzhalter, $mannschaften, $begegnung[1]);
$team2 = mysql_real_escape_string($team2);
$rein1 = "INSERT INTO " . $prefix . "spiele (liga, datum, team1, team2, typ, land) VALUES ('" . $liga_id . "', " . $counter . ", '" . $team1 . "', '" . $team2 . "', 'Liga', '" . $liga_land . "')";
$rein2 = mysql_query($rein1);
}
$counter = getTimestamp('+1 day', $counter);
}
}
</a></p>
<?php
// CHAT-SPERREN ANFANG
$blockCom1 = "SELECT MAX(chatSperre) FROM " . $prefix . "helferLog WHERE managerBestrafen = '" . $cookie_id . "'";
$blockCom2 = mysql_query($blockCom1);
if (mysql_num_rows($blockCom2) > 0) {
$blockCom3 = mysql_fetch_assoc($blockCom2);
$chatSperreBis = $blockCom3['MAX(chatSperre)'];
if ($chatSperreBis > 0 && $chatSperreBis > time()) {
addInfoBox(__('Du bist noch bis zum %1$s Uhr für die Kommunikation im Spiel gesperrt. Wenn Dir unklar ist warum, frage bitte das %2$s', date('d.m.Y H:i', $chatSperreBis), '<a class="inText" href="/wio.php">' . _('Support-Team') . '</a>'));
include 'zz3.php';
exit;
}
}
// CHAT-SPERREN ENDE
$timeout = getTimestamp('-1 day');
$sql1 = "SELECT COUNT(*) FROM " . $prefix . "supportRequests WHERE timeAdded > " . $timeout . " AND author = '" . $cookie_id . "'";
$sql2 = mysql_query($sql1);
$sql3 = mysql_result($sql2, 0);
if ($sql3 <= 5) {
?>
<form action="/support.php" method="post" accept-charset="utf-8">
<?php
if ($_SESSION['status'] == 'Admin' or $_SESSION['status'] == 'Helfer') {
?>
<p><label for="newVisibility"><?php
echo _('Wer soll die Anfrage sehen können?');
?>
</label><select name="visibility" id="newVisibility" size="1" style="width:200px">
<option value="0"><?php
echo _('Jeder User');
$codguest = strtoupper(md5(getTimestamp() . $j . $_POST[$select_quarto_tipo]));
mysql_query("INSERT INTO `reservas_rel_guest`(`CODRESERVA`,`CODGUEST`,`REFERENCIA`)VAlUES('{$codreserva}','{$codguest}','{$i}')");
mysql_query("INSERT INTO `guest` (`CODGUEST`,`NOME`,`FAIXA_ETARIA`)VALUES('{$codguest}','" . $_POST[$quarto_text_name] . "','" . $_POST[$select_guest_faixa_etaria] . "')");
}
}
$nQuartos++;
}
}
$n_conhecimento = mysql_query("SELECT * FROM reservas");
(int) ($n = mysql_num_rows($n_conhecimento));
$n_conhecimento = $n + 1;
$n_conhecimento = compliteCod($n_conhecimento, $cod);
$codpessoa = strtoupper(md5(getTimestamp() . $codreserva));
$codlogin = strtoupper(md5(getTimestamp() . $codpessoa));
$codtelefone = strtoupper(md5(getTimestamp() . $codlogin));
$codvalor = strtoupper(md5(getTimestamp() . $codtelefone));
mysql_query("INSERT INTO `reservas_rel_valor` (`CODRESERVA`,`CODVALOR`)VALUES('{$codreserva}','{$codvalor}')");
mysql_query("INSERT INTO `valor` (`CODVALOR`,`ADULTO_PERC`,`ADULTO_PERC_MULT`,`ADULTO_VALOR`,`ADULTO_EXCEDENTE`,`CRIANCA_5_PERC`,`CRIANCA_5_PERC_MULT`,`CRIANCA_5_VALOR`,`CRIANCA_5_EXCEDENTE`,`CRIANCA_6A12_PERC`,`CRIANCA_6A12_PERC_MULT`,`CRIANCA_6A12_VALOR`,`CRIANCA_6A12_EXCEDENTE`,`CRIANCA_12_PERC`,`CRIANCA_12_PERC_MULT`,`CRIANCA_12_VALOR`,`CRIANCA_12_EXCEDENTE`,`VALOR_BRUTO`,`VALOR_DESC`,`VALOR_ACRESCIMO`,`ACRESCIMO_PERC`,`VALOR_SINAL`,`VALOR_TOTAL`,`FORMA_PGTO`,`PGTO_SINAL`,`PGTO_RESTANTE`,`STATUS`,`N_CONHECIMENTO`)VALUES('{$codvalor}','" . $_POST["ADULTO_PERC"] . "','" . $_POST["ADULTO_PERC_MULT"] . "','" . $_POST["ADULTO_VALOR"] . "','" . $_POST["ADULTO_EXCEDENTE"] . "','" . $_POST["CRIANCA_5_PERC"] . "','" . $_POST["CRIANCA_5_PERC_MULT"] . "','" . $_POST["CRIANCA_5_VALOR"] . "','" . $_POST["CRIANCA_5_EXCEDENTE"] . "','" . $_POST["CRIANCA_6A12_PERC"] . "','" . $_POST["CRIANCA_6A12_PERC_MULT"] . "','" . $_POST["CRIANCA_6A12_VALOR"] . "','" . $_POST["CRIANCA_6A12_EXCEDENTE"] . "','" . $_POST["CRIANCA_12_PERC"] . "','" . $_POST["CRIANCA_12_PERC_MULT"] . "','" . $_POST["CRIANCA_12_VALOR"] . "','" . $_POST["CRIANCA_12_EXCEDENTE"] . "','" . $_POST["VALOR_BRUTO"] . "','" . $_POST["VALOR_DESC"] . "','" . $_POST["VALOR_ACRESCIMO"] . "','" . $_POST["ACRESCIMO_PERC"] . "','" . $_POST["VALOR_SINAL"] . "','" . $_POST["VALOR_TOTAL"] . "','" . $_POST["FORMA_PGTO"] . "','" . $_POST["PGTO_SINAL"] . "','" . $_POST["PGTO_RESTANTE"] . "','0','" . $n_conhecimento . "')");
$login = $_POST["email"];
$senha = strtoupper(md5("12345"));
$existe_login = mysql_query("SELECT * FROM login WHERE LOGIN = '******'");
if (mysql_num_rows($existe_login) == 0) {
mysql_query("INSERT INTO `reservas_rel_pessoa` (`CODRESERVA`,`CODPESSOA`)VALUES('{$codreserva}','{$codpessoa}')");
mysql_query("INSERT INTO `login` (`CODLOGIN`,`LOGIN`,`SENHA`,`PAPEL`,`STATUS`,`OWNER`) VALUES('{$codlogin}','{$login}','{$senha}','GUEST;','0','B4EC91ED6E6C92AC52099D19C0B1A40E')");
mysql_query("INSERT INTO `login_rel_pessoa`(`CODPESSOA`,`CODLOGIN`)VALUES('{$codpessoa}','{$codlogin}')");
mysql_query("INSERT INTO `pessoa` (`CODPESSOA`,`NOME`,`EMAIL`,`OWNER`) VALUES ('{$codpessoa}','" . $_POST["nome_empresa"] . "','" . $_POST["email"] . "','B4EC91ED6E6C92AC52099D19C0B1A40E')");
mysql_query("INSERT INTO `pessoa_rel_telefones` (`CODPESSOA`,`CODTELEFONE`)VALUES('{$codpessoa}','{$codtelefone}')");
mysql_query("INSERT INTO `telefones` (`CODTELEFONE`,`TELEFONE`,`STATUS`,`OWNER`)VALUES('{$codtelefone}','" . $_POST["telefone"] . "','1','B4EC91ED6E6C92AC52099D19C0B1A40E')");
} else {
$existe_login = mysql_fetch_object($existe_login);
$pessoa = mysql_query("SELECT pessoa.* FROM pessoa\r\t\t\tINNER JOIN login_rel_pessoa ON pessoa.CODPESSOA=login_rel_pessoa.CODPESSOA\r\t\t\tINNER JOIN login ON login_rel_pessoa.CODLOGIN=login.CODLOGIN\r\t\t\tWHERE login.CODLOGIN='******'");
echo _('Nationaler Cup');
?>
</h1>
<p><?php
echo __('Für diesen Wettbewerb qualifizieren sich die 32 besten Teams aus %s, 16 davon durch ein Freilos. Von Liga 1 bis 4 - jeder hat die Chance auf den Cup-Sieg.', $temp_land);
?>
</p>
<p><?php
echo _('Es gibt eine Qualifikation und danach fünf Runden, die jeweils ausgelost werden. In einem KO-Spiel pro Runde ermitteln die Teams den Sieger, der dann die nächste Runde erreicht.');
?>
</p>
<?php
$temp = FALSE;
$tmp_dateiname = 'cache/cup_ergebnisse' . urlencode($temp_land) . '.html';
if (file_exists($tmp_dateiname)) {
if (filemtime($tmp_dateiname) > getTimestamp('+2 hours')) {
$tmp_liga_cache = file_get_contents($tmp_dateiname);
if (strlen($tmp_liga_cache) > 0) {
$ersatz_temp = '<strong>' . $cookie_teamname . '</strong>';
echo str_replace($cookie_teamname, $ersatz_temp, $tmp_liga_cache);
$temp = TRUE;
include 'zz3.php';
exit;
}
}
}
if ($temp == FALSE) {
$tmp_liga_cache = '';
// TEAM-IDS HOLEN ANFANG
$getteam1 = "SELECT ids, name, liga FROM " . $prefix . "teams WHERE cuprunde > 0";
$getteam2 = mysql_query($getteam1);
<th scope="col"><?php
echo _('Team');
?>
</th>
<th scope="col"><?php
echo _('Marktwert');
?>
</th>
</tr>
</thead>
<tbody>
<?php
$temp = FALSE;
$tmp_dateiname = 'cache/stat_wertvollste_teams' . $temp_liga . '.html';
if (file_exists($tmp_dateiname)) {
if (filemtime($tmp_dateiname) > getTimestamp('-1 day')) {
$tmp_liga_cache = file_get_contents($tmp_dateiname);
if (strlen($tmp_liga_cache) > 0) {
$ersatz_temp = '<strong>' . $cookie_teamname . '</strong>';
echo str_replace($cookie_teamname, $ersatz_temp, $tmp_liga_cache);
$temp = TRUE;
}
}
}
if ($temp == FALSE) {
$tmp_liga_cache = '';
$sql1 = "SELECT a.ids, a.name, SUM(b.marktwert) AS teamwert FROM " . $prefix . "teams AS a JOIN " . $prefix . "spieler AS b ON a.ids = b.team WHERE a.staerke > 1" . $temp_liga_query . " GROUP BY b.team ORDER BY teamwert DESC LIMIT 0, 20";
$sql2 = mysql_query($sql1);
$counter = 1;
while ($sql3 = mysql_fetch_assoc($sql2)) {
if ($counter % 2 == 1) {
<?php
acessoDireto("ADMINISTRADOR;");
$erro = "";
if (!empty($_POST) && isset($_POST['ACTION'])) {
$coddica = strtoupper(md5(getTimestamp()));
$ingles = trim(htmlentities(tratapost($_POST['ingles'])));
$espanhol = trim(htmlentities(tratapost($_POST['espanhol'])));
$portugues = trim(htmlentities(tratapost($_POST['portugues'])));
$ingles = str_replace("'", '‘', $ingles);
$espanhol = str_replace("'", '‘', $espanhol);
$portugues = str_replace("'", '‘', $portugues);
$status = trim(tratapost($_POST['status']));
$status == 'on' ? $status = 1 : ($status = 0);
mysql_query("INSERT INTO `dicas` (`CODDICA`,`INGLES`,`PORTUGUES`,`ESPANHOL`,`OWNER`,`STATUS`) VALUES('{$coddica}','{$ingles}','{$portugues}','{$espanhol}','" . $_SESSION['CODPESSOA'] . "','{$status}')");
echo "<script>alert('* " . getLabel('LABEL_ADD_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
echo "<script>window.location = 'index.php?actionType=gerenciar.dicas';</script>";
exit;
} else {
$erro = getLabel('ERRO_PREENCHER_TODOS_CAMPOS', $_SESSION['LANGUAGE']);
}
$pi = "<form name='formCpf' method='post' action='index.php?actionType=gerenciar.dicas.add'>";
$pi .= "<div class='ErroMessage'>* {$erro}!</div>";
$pi .= "<br/>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div class='EntradaTextForm'>";
if (!empty($_POST) && isset($_POST['ACTION'])) {
$pi .= "<input class='LiloginText' class='LiloginText' style='width: 250px' type='text' id='ingles' name='ingles' value='" . $_POST['ingles'] . "' maxlength='70' placeholder='" . getLabel('LABEL_INGLES', $_SESSION['LANGUAGE']) . "'/>";
} else {
$pi .= "<input class='LiloginText' class='LiloginText' style='width: 250px' type='text' id='ingles' name='ingles' value='' maxlength='70' placeholder='" . getLabel('LABEL_INGLES', $_SESSION['LANGUAGE']) . "'/>";
$phpf1 = "INSERT INTO ".$prefix."php_fehler (datei) VALUES ('transfermarkt_auktion KEIN Team')";
$phpf2 = mysql_query($phpf1);
exit;
}
$sql8 = "INSERT INTO ".$prefix."transfermarkt (spieler, besitzer, gehalt, ende, betrag_highest, autorestart) VALUES ('".$spieler_id."', '".$cookie_team."', ".ceil($sql3['marktwert']/11).", ".getTimestamp('+'.$laenge.' hours').", ".$startgebot.", ".$autorestart.")";
$sql9 = mysql_query($sql8);
if (mysql_affected_rows() != 0) {
$sql4 = "UPDATE ".$prefix."spieler SET transfermarkt = 1, moral = moral-15 WHERE ids = '".$spieler_id."'";
$sql5 = mysql_query($sql4);
}
}*/
} elseif ($_POST['typ'] > 999998) {
// Leihgabe
$sql4 = "UPDATE " . $prefix . "spieler SET transfermarkt = " . bigintval($_POST['typ']) . ", moral = moral-10 WHERE ids = '" . $spieler_id . "'";
$sql5 = mysql_query($sql4);
}
}
}
} elseif (isset($_POST['abbrechen']) && $cookie_id != CONFIG_DEMO_USER) {
if ($_POST['abbrechen'] == 'Ja') {
$sql6 = "DELETE FROM " . $prefix . "transfermarkt WHERE spieler = '" . $spieler_id . "' AND ende > " . getTimestamp('+30 minutes') . " AND gebote = 0";
$sql7 = mysql_query($sql6);
$sql6 = "DELETE FROM " . $prefix . "transfermarkt_leihe WHERE spieler = '" . $spieler_id . "' AND akzeptiert = 0";
$sql7 = mysql_query($sql6);
$sql4 = "UPDATE " . $prefix . "spieler SET transfermarkt = 0 WHERE ids = '" . $spieler_id . "'";
$sql5 = mysql_query($sql4);
}
}
}
header($hadresse);
exit;
<?php
acessoDireto("ADMINISTRADOR;");
$row = mysql_query("SELECT descricao.* FROM \r\r\tdescricao\r\r\tINNER JOIN pacotes_rel_descricao ON pacotes_rel_descricao.CODDESCRICAO=descricao.CODDESCRICAO\r\r\tWHERE pacotes_rel_descricao.CODPACOTE='" . $_GET['codpacote'] . "'");
if (mysql_num_rows($row) == 0) {
$coddescricao = strtoupper(md5(getTimestamp()));
mysql_query("INSERT INTO `descricao` (`CODDESCRICAO`,`INGLES`,`PORTUGUES`,`ESPANHOL`,`STATUS`,`OWNER`)VALUES('{$coddescricao}','','','','1','" . $_SESSION['CODPESSOA'] . "')");
mysql_query("INSERT INTO `pacotes_rel_descricao` (`CODPACOTE`,`CODDESCRICAO`)VALUES('" . $_GET['codpacote'] . "','{$coddescricao}')");
$row = mysql_query("SELECT descricao.* FROM \r\r\t\tdescricao\r\r\t\tINNER JOIN pacotes_rel_descricao ON pacotes_rel_descricao.CODDESCRICAO=descricao.CODDESCRICAO\r\r\t\tWHERE pacotes_rel_descricao.CODPACOTE='" . $_GET['codpacote'] . "'");
}
$row = mysql_fetch_object($row);
$erro = "";
if (!empty($_POST) && isset($_POST['ACTION'])) {
$coddescricao = mysql_query("SELECT \r\r\t\tpacotes_rel_descricao.CODDESCRICAO \r\r\t\tFROM \r\r\t\tdescricao\r\r\t\tINNER JOIN pacotes_rel_descricao ON pacotes_rel_descricao.CODDESCRICAO=descricao.CODDESCRICAO\r\r\t\tWHERE pacotes_rel_descricao.CODPACOTE='" . $_GET['codpacote'] . "'");
if (mysql_num_rows($coddescricao) != 0) {
$coddescricao = mysql_fetch_object($coddescricao);
}
$ingles = trim(stripslashes(tratapost($_POST['ingles'])));
$espanhol = trim(stripslashes(tratapost($_POST['espanhol'])));
$portugues = trim(stripslashes(tratapost($_POST['portugues'])));
$ingles = str_replace("'", '‘', $ingles);
$espanhol = str_replace("'", '‘', $espanhol);
$portugues = str_replace("'", '‘', $portugues);
mysql_query("UPDATE `descricao` SET `INGLES`='{$ingles}', `PORTUGUES`='{$portugues}',`ESPANHOL`='{$espanhol}' WHERE `CODDESCRICAO`='{$coddescricao->CODDESCRICAO}'");
echo "<script>alert('* " . getLabel('LABEL_EDIT_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
echo "<script>window.location = 'index.php?actionType=gerenciar.pacotes';</script>";
exit;
} else {
$erro = getLabel('ERRO_PREENCHER_TODOS_CAMPOS', $_SESSION['LANGUAGE']);
}
$pi = "<form name='formCpf' method='post' action='index.php?actionType=gerenciar.pacotes.descricao&codpacote=" . $_GET['codpacote'] . "'>";
echo '<option value="2">Verstoß gegen Regel II.</option>';
echo '<option value="3">Verstoß gegen Regel III.</option>';
echo '<option value="4">Verstoß gegen Regel IV.</option>';
echo '<option value="5">Verstoß gegen Regel V.</option>';
echo '</select></p>';
echo '<p><input type="submit" value="Ausführen" onclick="return confirm(\'Bist Du sicher?\')" /></p>';
echo '</form>';
}
// ANTRAEGE ENDE
?>
<h1>Letzte Sanktionen</h1>
<p>Bei unpassendem Verhalten und unfairen Aktionen können Sanktionen beschlossen werden. Für das betroffene Team kann es Transfer- oder Community-Sperren sowie Geldstrafen geben.</p>
<p>Die Höhe der Strafen wird automatisch festgelegt und kann nicht variiert werden.</p>
<p>Community-Sperren beinhalten Sperren für den Chat und das Versenden von privaten Nachrichten. Auch der Zugriff auf den Support-Bereich wird blockiert.</p>
<?php
$timeout = getTimestamp('-28 days');
$sql1 = "SELECT a.managerBestrafen, a.zeit, a.chatSperre, a.transferSperre, a.geldStrafe, a.helfer, a.verstoss, b.username FROM " . $prefix . "helferLog AS a JOIN " . $prefix . "users AS b ON a.managerBestrafen = b.ids WHERE zeit > " . $timeout . " OR chatSperre > " . time() . " OR transferSperre > " . time() . " ORDER BY zeit DESC";
$sql2 = mysql_query($sql1);
if (mysql_num_rows($sql2) > 0) {
?>
<table>
<thead>
<tr class="odd">
<th scope="col">Manager</th>
<th scope="col">Datum</th>
<th scope="col">Community</th>
<th scope="col">Transfer</th>
<th scope="col">Geld</th>
<th scope="col"> </th>
</tr>
</thead>
if ($email_valide == TRUE) {
$username = mysql_real_escape_string(trim(strip_tags($_POST['reg_benutzername'])));
$username = str_replace('_', '', $username);
$password = mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9) . mt_rand(1, 9);
$password_db = md5('1' . $password . '29');
$blackList1 = "SELECT COUNT(*) FROM " . $prefix . "blacklist WHERE email = '" . md5($email) . "' AND until > " . time();
$blackList2 = mysql_query($blackList1);
$blackList3 = mysql_result($blackList2, 0);
$schon_vorhandene_user = $blackList3;
$sql1 = "SELECT COUNT(*) FROM " . $prefix . "users WHERE email = '" . $email . "' OR username = '******'";
$sql2 = mysql_query($sql1);
$sql3 = mysql_result($sql2, 0);
$schon_vorhandene_user += $sql3;
if ($schon_vorhandene_user == 0) {
$uniqueIDHash = md5($email . time());
$sql4 = "INSERT INTO " . $prefix . "users (email, username, password, regdate, last_login, last_ip, ids, liga, team) VALUES ('" . $email . "', '" . $username . "', '" . $password_db . "', " . time() . ", " . bigintval(getTimestamp('-14 days')) . ", '" . $last_ip . "', '" . $uniqueIDHash . "', '', '__" . $uniqueIDHash . "')";
$sql5 = mysql_query($sql4);
if ($sql5 != FALSE) {
if (isset($_SESSION['referralID'])) {
$refID = mysql_real_escape_string(trim($_SESSION['referralID']));
if (mb_strlen($refID) == 32) {
$addReferral1 = "INSERT INTO " . $prefix . "referrals (werber, geworben, zeit) VALUES ('" . $refID . "', '" . $uniqueIDHash . "', " . time() . ")";
$addReferral2 = mysql_query($addReferral1);
}
}
$fehler_gemacht = FALSE;
if (CONFIG_IS_LOCAL_INSTALLATION) {
echo '<p><strong>' . _('Dein Passwort lautet:') . '</strong> ' . htmlspecialchars($password) . '</p>';
echo '<p>' . _('Du brauchst dieses Passwort unbedingt für den ersten Login. Danach kannst Du es in den Einstellungen ändern, wenn Du möchtest.') . '</p>';
} else {
echo '<p>' . _('Vielen Dank, die Registrierung war erfolgreich! Wir senden Dir nun an die angegebene Adresse eine E-Mail mit Deinem Passwort zu. Mit dem Benutzernamen und dem zugeschickten Passwort kannst Du Dich danach einloggen.') . '</p>';
$start_urlaub = 1;
$noch_urlaub = 30;
} elseif ($urlaub_erlaubt_kurz == TRUE) {
$start_urlaub = 1;
$noch_urlaub = 10;
} elseif ($urlaub_erlaubt_lang == TRUE) {
$start_urlaub = 11;
$noch_urlaub = 30;
} else {
$start_urlaub = 0;
$noch_urlaub = 0;
}
$_SESSION['urlaub_min'] = $start_urlaub;
$_SESSION['urlaub_max'] = $noch_urlaub;
for ($i = $start_urlaub; $i <= $noch_urlaub; $i++) {
$temp = getTimestamp('+' . $i . ' days');
echo '<option value="' . $temp . '">' . date('d.m.Y', $temp) . '</option>';
}
?>
</select></p>
<p><input type="submit" value="<?php
echo _('Beantragen');
?>
" onclick="return<?php
echo noDemoClick($cookie_id, TRUE);
?>
confirm('<?php
echo _('Bist Du sicher?');
?>
')" /></p>
</form>
?>
<h1><?php
echo _('Spieltag auswählen');
?>
</h1>
<form action="/lig_testspiele_liste.php" method="get" accept-charset="utf-8">
<p><select name="tag" size="1" style="width:200px">
<?php
if (isset($_GET['tag'])) {
$chosenStamp = bigintval($_GET['tag']);
} else {
$chosenStamp = mktime(23, 00, 00, date('m', time()), date('d', time()), date('Y', time()));
}
for ($i = 1; $i <= 22; $i++) {
$abzugTemp = '-' . intval(GameTime::getMatchDay() - $i) . ' days';
$abzug = getTimestamp($abzugTemp);
$abzugStamp = mktime(23, 00, 00, date('m', $abzug), date('d', $abzug), date('Y', $abzug));
$abzugStr = $i . '. Spieltag (' . date('d.m.Y', $abzugStamp) . ')';
echo '<option value="' . $abzugStamp . '"';
if (date('d.m.Y', $abzugStamp) == date('d.m.Y', $chosenStamp)) {
echo ' selected="selected"';
}
echo '>' . $abzugStr . '</option>';
}
?>
</select></p>
<p><input type="submit" value="<?php
echo _('Auswählen');
?>
" /></p>
</form>
/**
* Set the document modification timestamp
* @param $time (mixed) Document modification timestamp in seconds or date-time string.
* @public
* @since 5.9.152 (2012-03-23)
*/
public function setDocModificationTimestamp($time) {
if (is_string($time)) {
$time = getTimestamp($time);
}
$this->doc_modification_timestamp = intval($time);
}
$sql6 = "UPDATE " . $prefix . "spieler SET transfermarkt = 0 WHERE ids = '" . $sql3['spieler'] . "'";
$sql7 = mysql_query($sql6);
}
}
}
// ALTE AUKTIONEN BEENDEN UND VERTRAEGE ABSCHLIESSEN ENDE
?>
<table>
<thead><tr class="odd"><th scope="col"><?php
echo _('MT') . '</th><th scope="col">' . _('Spieler') . '</th><th scope="col">' . _('AL') . '</th><th scope="col">' . _('ST') . '</th><th scope="col">' . _('Gebot') . '</th><th scope="col">' . _('Noch');
?>
</th></tr></thead>
<tbody>
<?php
$sql1 = "SELECT a.spieler, a.gebote, a.betrag_highest, a.ende, a.besitzer, b.vorname, b.nachname, b.position, b.staerke, b.talent, b.wiealt FROM " . $prefix . "transfermarkt AS a";
$sql1 .= " JOIN " . $prefix . "spieler AS b ON a.spieler = b.ids WHERE a.ende > " . getTimestamp('+20 seconds') . $zusatzbedingungen . " ORDER BY a.ende ASC LIMIT " . $start . ", " . $eintraege_pro_seite;
$sql2 = mysql_query($sql1);
// Zeitlimit + 20 Sekunden zur Sicherheit
$blaetter3 = anzahl_datensaetze_gesamt($sql1);
if (mysql_num_rows($sql2) == 0) {
echo '<tr><td colspan="5">' . _('Zurzeit keine Auktionen!') . '</td></tr>';
} else {
while ($sql3 = mysql_fetch_assoc($sql2)) {
echo '<tr><td>' . $sql3['position'] . '</td><td class="link"><a href="/transfermarkt_auktion.php?id=' . $sql3['spieler'] . '">' . $sql3['vorname'] . ' ' . $sql3['nachname'] . '</a></td><td>' . floor($sql3['wiealt'] / 365) . '</td><td>' . number_format($sql3['staerke'], 1, ',', '.');
$schaetzungVomScout = schaetzungVomScout($cookie_team, $cookie_scout, $sql3['spieler'], $sql3['talent'], $sql3['staerke'], $sql3['besitzer']);
echo ' <span style="color:#999">(' . number_format($schaetzungVomScout, 1, ',', '.') . ')</span>';
echo '</td><td>[' . $sql3['gebote'] . '] ' . number_format($sql3['betrag_highest'], 0, ',', '.') . ' €</td><td>';
$noch_zeit = intval(($sql3['ende'] - time()) / 60);
if ($noch_zeit < 61) {
echo '<span style="color:red" title="' . date('d.m.Y H:i', $sql3['ende']) . '">' . $noch_zeit . ' min</span>';
} else {
protected function isValid($validdays)
{
//long standand = 1253525356;
$h = 3600;
$currentTime = new DateTime();
if ($currentTime . getTimestamp() / 1000 - 1253525356 >= $validdays * 24 * $h) {
return false;
} else {
return true;
}
}
$currentSpieltag = GameTime::getMatchDay() - round((time() - $sql3['datum']) / 86400);
echo '<td style="font-weight:bold;">' . $currentDate . '</td>';
echo '<td colspan="3" style="font-weight:bold;">' . __('Spieltag %d', $currentSpieltag) . '</td></tr><tr><td> </td>';
// Zeile mit Spieltag einschieben
$counter++;
// Zeilen-Counter erhöhen
if (isset($spieltagDescription[$currentSpieltag]) && is_array($spieltagDescription[$currentSpieltag])) {
// Zeile mit Spieltags-Beschreibung einschieben
foreach ($spieltagDescription[$currentSpieltag] as $special_date) {
echo '<td colspan="3" style="font-weight:bold;">' . $special_date . '</td></tr><tr><td> </td>';
$counter++;
// Zeilen-Counter erhöhen
}
}
}
echo '<td>' . __('%s Uhr', date('H:i', getTimestamp('-1 hour', $sql3['datum']))) . '</td><td>' . substr($sql3['typ'], 0, 1) . ': ';
if ($sql3['team1'] != $chosenTeam) {
$ergebnis = ergebnis_drehen($sql3['ergebnis']);
$gegner = $sql3['team1'];
$zusatz = ' ' . _('(A)');
} else {
$ergebnis = $sql3['ergebnis'];
$gegner = $sql3['team2'];
$zusatz = ' ' . _('(H)');
}
$sql4 = "SELECT ids FROM " . $prefix . "teams WHERE name = '" . $gegner . "'";
$sql5 = mysql_query($sql4);
$sql6 = mysql_fetch_assoc($sql5);
$sql6 = $sql6['ids'];
// LIVE ODER ERGEBNIS ANFANG
if ($sql3['typ'] == $live_scoring_spieltyp_laeuft && date('d', time()) == date('d', $sql3['datum'])) {
