$a5 = mysql_query($a4); } // SPIELER MIT FALSCHEM BESITZER RUNTER ENDE // ALTE AUKTIONEN BEENDEN UND VERTRAEGE ABSCHLIESSEN ANFANG $sql1 = "SELECT spieler, besitzer, bieter_highest, betrag_highest, autorestart FROM " . $prefix . "transfermarkt WHERE ende < " . time(); $sql2 = mysql_query($sql1); while ($sql3 = mysql_fetch_assoc($sql2)) { if ($sql3['bieter_highest'] != 'keiner') { $sql6 = "DELETE FROM " . $prefix . "transfermarkt WHERE spieler = '" . $sql3['spieler'] . "'"; $sql7 = mysql_query($sql6); // WEITERE SPIELERDATEN HOLEN ANFANG $getmanager1 = "SELECT vorname, nachname, marktwert, spiele_verein, staerke FROM " . $prefix . "spieler WHERE ids = '" . $sql3['spieler'] . "'"; $getmanager2 = mysql_query($getmanager1); $getmanager3 = mysql_fetch_assoc($getmanager2); // WEITERE SPIELERDATEN HOLEN ENDE $vertragsende = endOfDay(getTimestamp('+29 days')); // 29 Tage $neuesGehalt = round(pow($sql3['betrag_highest'] / 1000, 1.385 + 0.006 * 3)); $sql4 = "UPDATE " . $prefix . "spieler SET transfermarkt = 0, leiher = 'keiner', vertrag = " . $vertragsende . ", gehalt = " . $neuesGehalt . ", startelf_Liga = 0, startelf_Pokal = 0, startelf_Cup = 0, startelf_Test = 0, spiele_verein = 0, moral = 100, frische = " . getRegularFreshness(GameTime::getMatchDay()) . ", team = '" . $sql3['bieter_highest'] . "' WHERE ids = '" . $sql3['spieler'] . "'"; $sql5 = mysql_query($sql4); $move1 = "INSERT INTO " . $prefix . "transfers (spieler, besitzer, bieter, datum, gebot, damaligerWert, spiele_verein, damaligeStaerke) VALUES ('" . $sql3['spieler'] . "', '" . $sql3['besitzer'] . "', '" . $sql3['bieter_highest'] . "', " . time() . ", " . $sql3['betrag_highest'] . ", " . $getmanager3['marktwert'] . ", " . $getmanager3['spiele_verein'] . ", " . $getmanager3['staerke'] . ")"; $move2 = mysql_query($move1); if ($move2 !== FALSE) { // TRANSFERSTEUER ANFANG $transfersteuer = round($sql3['betrag_highest'] * 0.05); $kontoabzug = round($sql3['betrag_highest'] * 1.05); $buch1 = "INSERT INTO " . $prefix . "buchungen (team, verwendungszweck, betrag, zeit) VALUES ('" . $sql3['bieter_highest'] . "', 'Transfersteuer', -" . $transfersteuer . ", " . time() . ")"; $buch2 = mysql_query($buch1); // TRANSFERSTEUER ENDE $sql4 = "UPDATE " . $prefix . "teams SET konto = konto-" . $kontoabzug . " WHERE ids = '" . $sql3['bieter_highest'] . "'"; $sql5 = mysql_query($sql4);
<?php if (!isset($_GET['mode'])) { include 'zzserver.php'; } define('COMPUTER_MINIMUM_KONTOSTAND', 20000000); $in_14_tagen = endOfDay(getTimestamp('+14 days')); $ligaToKlasse = array(); $lig1a = "SELECT ids, name FROM " . $prefix . "ligen"; $lig1b = mysql_query($lig1a); while ($lig1c = mysql_fetch_assoc($lig1b)) { $ligaToKlasse[$lig1c['ids']] = substr($lig1c['name'], -1); } $demoTeamID1 = "SELECT team FROM " . $prefix . "users WHERE ids = '" . CONFIG_DEMO_USER . "'"; $demoTeamID2 = mysql_query($demoTeamID1); $sqlIsDemoTeam = ""; if (mysql_num_rows($demoTeamID2) == 1) { $demoTeamID3 = mysql_result($demoTeamID2, 0); $sqlIsDemoTeam = " OR ids = '" . mysql_real_escape_string($demoTeamID3) . "'"; } $urlaub1 = "SELECT user, team FROM " . $prefix . "urlaub WHERE ende > " . time(); $urlaub2 = mysql_query($urlaub1); $urlaub_string = "('LEER', "; $beurlaubte_teams = array(); while ($urlaub3 = mysql_fetch_assoc($urlaub2)) { if ($urlaub3['user'] != CONFIG_DEMO_USER) { $urlaub_string .= "'" . $urlaub3['user'] . "', "; $beurlaubte_teams[] = $urlaub3['team']; } } $urlaub_string = substr($urlaub_string, 0, -2);
return round(pow(M_E, $rand), 1); } function choosePosition() { if (Chance_Percent(12)) { return 'T'; } elseif (Chance_Percent(24)) { return 'S'; } elseif (Chance_Percent(50)) { return 'M'; } else { return 'A'; } } // KONFIGURATION ANFANG $in_33_tagen = endOfDay(getTimestamp('+33 days')); $spieltage_mit_aktion = array(3, 6, 9, 12, 15, 18, 21); if (!in_array(GameTime::getMatchDay(), $spieltage_mit_aktion)) { exit; } $datum_stamp = mktime(0, 0, 0, date('m', time()), date('d', time()), date('Y', time())); $datum_stamp_alt = getTimestamp('-36 hours', $datum_stamp); // vor 1,5 Tagen $vor1 = "SELECT name FROM " . $prefix . "namen_pool WHERE typ = 1"; $vor2 = mysql_query($vor1); $vor2a = mysql_num_rows($vor2) - 1; $vornamen = array(); while ($vor3 = mysql_fetch_assoc($vor2)) { $vornamen[] = $vor3['name']; } $nach1 = "SELECT name FROM " . $prefix . "namen_pool WHERE typ = 2";
</p> <?php setTaskDone('finance_prognosis'); // WERTE INITIALISIEREN ANFANG $ausgaben_jugendtrainer = 0; $fitnesstrainer3 = 0; $physiotherapeut = 0; $abloesesteuer3 = 0; $sponsor_einkommen = 0; $leihPraemien_ein = 0; $leihPraemien_aus = 0; $sonstiges_aus = 0; $sonstiges_ein = 0; $ausgaben_stadion = 0; // WERTE INITIALISIEREN ENDE $buchungsBeginn = endOfDay(getTimestamp('-' . GameTime::getMatchDay() . ' days')); $spe1 = "SELECT verwendungszweck, SUM(betrag), AVG(betrag) FROM " . $prefix . "buchungen WHERE team = '" . $cookie_team . "' AND zeit > " . $buchungsBeginn . " AND betrag != 0 GROUP BY verwendungszweck"; $spe2 = mysql_query($spe1); while ($spe3 = mysql_fetch_assoc($spe2)) { switch ($spe3['verwendungszweck']) { case 'Sponsoring': if (GameTime::getMatchDay() != 0) { $sponsor_einkommen = $spe3['AVG(betrag)'] * 22; } break; case 'Transfersteuer': $abloesesteuer3 = -$spe3['SUM(betrag)']; break; case 'Regenerations-Camp': $fitnesstrainer3 = -$spe3['SUM(betrag)']; break;
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); } } if (isset($_POST['laufzeit']) && isset($_POST['spieler'])) { $laufzeit = intval(trim($_POST['laufzeit'])); $spieler_id = mysql_real_escape_string(trim(strip_tags($_POST['spieler']))); if ($laufzeit == 22 || $laufzeit == 44 || $laufzeit == 66) { if ($cookie_id != CONFIG_DEMO_USER) { $laufzeit_end = endOfDay(getTimestamp('+' . $laufzeit . ' days')); $ina = "SELECT marktwert, wiealt, vertrag, moral FROM " . $prefix . "spieler WHERE ids = '" . $spieler_id . "' AND team = '" . $cookie_team . "'"; $inb = mysql_query($ina); if (mysql_num_rows($inb) == 0) { exit; } $inc = mysql_fetch_assoc($inb); if (isContractOptionAvailable($inc, $laufzeit)) { $pLevels = getPercentageLevels(round($inc['wiealt'] / 365)); switch ($laufzeit) { case 22: $percentageLevel = $pLevels[0]; break; case 44: $percentageLevel = $pLevels[1]; break;