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'])) {