?> <tr><td><?php echo _('Liga'); ?> </td><td><?php echo __('%d. Platz', $vd3['rank']); ?> </td></tr> <tr class="odd"><td><?php echo _('Pokal'); ?> </td><td><?php if ($vd3['pokalrunde'] == 0) { echo '-'; } else { echo pokalrunde_wort($vd3['pokalrunde']); } ?> </td></tr> <tr><td><?php echo _('Cup'); ?> </td><td><?php if ($vd3['cuprunde'] == 0) { echo '-'; } else { echo cuprunde_wort($vd3['cuprunde']); } ?> </td></tr> <tr class="odd"><td><?php
$vql1 = "SELECT ids, username, status FROM " . $prefix . "users WHERE team = '" . $clearid . "'"; $vql2 = mysql_query($vql1); $vql4 = mysql_num_rows($vql2); if ($vql4 == 0) { $last_managed = date('d.m.Y H:i', $sql3['last_managed']); $strainer = '<td>Computer (' . $last_managed . ')</td>'; } else { $vql3 = mysql_fetch_assoc($vql2); $strainer = '<td class="link">' . displayUsername($vql3['username'], $vql3['ids']) . '</td>'; } echo '<tr class="odd"><td>' . _('Trainer') . '</td>' . $strainer . '</tr>'; echo '<tr><td>' . _('Manager') . '</td>' . $strainer . '</tr>'; echo '<tr class="odd"><td>' . _('Finanzlage') . '</td><td>' . kontoToWort($sql3['konto']) . '</td></tr>'; echo '<tr><td>' . _('Land') . '</td><td class="link"><a href="/lig_tabelle.php?liga=' . $sql3['liga'] . '">' . $tql3['name'] . '</a></td></tr>'; echo '<tr class="odd"><td>' . _('Liga (Vorjahr)') . '</td><td>' . $sql3['rank'] . '. (' . $sql3['vorjahr_platz'] . '.)</td></tr>'; echo '<tr><td>' . _('Pokal (Vorjahr)') . '</td><td>' . pokalrunde_wort($sql3['pokalrunde']) . ' (' . pokalrunde_wort($sql3['vorjahr_pokalrunde']) . ')</td></tr>'; echo '<tr class="odd"><td>' . _('Cup (Vorjahr)') . '</td><td>' . cuprunde_wort($sql3['cuprunde']) . ' (' . cuprunde_wort($sql3['vorjahr_cuprunde']) . ')</td></tr>'; echo '<tr><td>' . _('Kaderstärke') . '</td><td>' . number_format($sql3['staerke'], 1, ',', '.') . '</td></tr>'; echo '<tr class="odd"><td>' . _('Aufstellungsstärke') . '</td><td>' . number_format($sql3['aufstellung'], 1, ',', '.') . '</td></tr>'; echo '<tr><td>' . _('Meisterschaft') . '</td><td>' . $sql3['meisterschaften'] . 'x</td></tr>'; echo '<tr class="odd"><td>' . _('Pokalsieg') . '</td><td>' . $sql3['pokalsiege'] . 'x</td></tr>'; echo '<tr><td>' . _('Cupsieg') . '</td><td>' . $sql3['cupsiege'] . 'x</td></tr>'; echo '<tr class="odd"><td>' . _('RKP (Vorjahr)') . '</td><td>' . __('%1$s (%2$s) Punkte', number_format($sql3['elo'], 0, ',', '.'), number_format($sql3['vorjahr_elo'], 0, ',', '.')) . '</td></tr>'; echo '<tr><td>' . _('Testspiele') . '</td><td>'; if ($live_scoring_spieltyp_laeuft == 'Test') { echo '?'; } else { echo __('%1$s (%2$s Siege)', $sql3['friendlies_ges'], $sql3['friendlies']); } echo '</td></tr>'; echo '<tr class="odd"><td>' . _('Stadion') . '</td><td>' . __('%s Plätze', number_format($stadion3['plaetze'], 0, ',', '.')) . '</td></tr>';
$lo2 = mysql_query($lo1); $lo3 = mysql_fetch_assoc($lo2); // LIGA-PLATZIERUNG VOM LETZTEN JAHR HOLEN ENDE if ($counter % 2 == 1) { echo '<tr>'; } else { echo '<tr class="odd">'; } $link_zur_tabelle = '/stat_geschichte.php?saison_spieltag=' . intval(GameTime::getSeason() - 1) . '-22&liga=' . $sql3['vorjahr_liga']; $bilanz = round($sql3['gewinnGeld'] / 1000000); if ($bilanz > 0) { $bilanz = '+' . $bilanz; } echo '<td>' . displayUsername($sql3['username'], $sql3['ids']) . ' (<a href="/team.php?id=' . $sql3['team'] . '">' . $sql3['name'] . '</a>)</td>'; echo '<td class="link"><a href="' . $link_zur_tabelle . '">' . $lo3['platz'] . '. (' . $lo3['punkte'] . ' PKT)</a></td>'; echo '<td>' . pokalrunde_wort($sql3['vorjahr_pokalrunde']) . '</td>'; echo '<td>' . __('%s Mio', $bilanz) . '</td>'; echo '<td class="link"><a href="/manager_der_saison.php?wahl_id=' . $sql3['ids'] . '&sec_id=' . $sec_id . '" onclick="return confirm(' . _('\'Bist Du sicher?\'') . ')">' . _('Klicken') . '</a></td>'; echo '</tr>'; $counter++; } ?> </tbody> </table> <?php } } else { // AUSWERTUNG ANFANG $sql1 = "SELECT a.manager, b.username, (COUNT(*)/(SELECT COUNT(*) FROM " . $prefix . "users_mds)*100) AS prozent FROM " . $prefix . "users_mds AS a JOIN " . $prefix . "users AS b ON a.manager = b.ids GROUP BY a.manager ORDER BY prozent DESC, b.regdate DESC LIMIT 0, 1"; $sql2 = mysql_query($sql1); if (mysql_num_rows($sql2) == 1) {