<?php /** * @license http://opensource.org/licenses/gpl-2.0.php The GNU General Public License (GPL) * @copyright (C) 2000-2010 ilch.de * @version $Id$ */ defined('main') or die('no direct access'); $farbe = ''; $farb2 = ''; echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">'; $erg = db_query('SELECT * FROM `prefix_wars` WHERE `status` = "3" ORDER BY `datime` DESC LIMIT 3'); while ($row = db_fetch_object($erg)) { $row->tag = empty($row->tag) ? $row->gegner : $row->tag; if ($row->wlp == 1) { $bild = 'include/images/icons/win.gif'; } elseif ($row->wlp == 2) { $bild = 'include/images/icons/los.gif'; } elseif ($row->wlp == 3) { $bild = 'include/images/icons/pad.gif'; } echo '<tr><td>' . get_wargameimg($row->game) . '</td><td align="left">'; echo '<a href="index.php?wars-more-' . $row->id . '">'; echo $row->owp . ' ' . $lang['at2'] . ' ' . $row->opp . ' - ' . $row->tag . '</a></td><td><img src="' . $bild . '"></td></tr>'; } echo '</table>';
<?php /** * @license http://opensource.org/licenses/gpl-2.0.php The GNU General Public License (GPL) * @copyright (C) 2000-2010 ilch.de * @version $Id$ */ defined('main') or die('no direct access'); echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">'; $akttime = date('Y-m-d'); $erg = @db_query("SELECT DATE_FORMAT(`datime`,'%d.%m.%y - %H:%i') as `time`,`tag`,`gegner`, `id`, `game` FROM `prefix_wars` WHERE `status` = 2 AND `datime` > '" . $akttime . "' ORDER BY `datime`"); if (@db_num_rows($erg) == 0) { echo '<tr><td>kein War geplant</td></tr>'; } else { while ($row = @db_fetch_object($erg)) { $row->tag = empty($row->tag) ? $row->gegner : $row->tag; echo '<tr><td>' . get_wargameimg($row->game) . '</td>'; echo '<td><a class="box" href="index.php?wars-more-' . $row->id . '">'; echo $row->time . ' - ' . $row->tag . '</a></td></tr>'; } } echo '</table>';
$anfang = ($page - 1) * $limit; // seiten funktion $farbe1wlpar = array(1 => 'C8E1B8', 2 => 'D8B9B9', 3 => 'FDFBB7'); $farbe2wlpar = array(1 => '00FF00', 2 => 'FF0000', 3 => 'FFFF00'); $erg = db_query("SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id " . $sqla . " ORDER BY a.datime DESC, id DESC LIMIT " . $anfang . "," . $limit); while ($row = db_fetch_assoc($erg)) { $row['erg'] = $row['opp'] . ':' . $row['owp']; $row['farbe'] = $farbe1wlpar[$row['wlp']]; $row['farbe2'] = $farbe2wlpar[$row['wlp']]; if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } $row['page'] = get_homepage($row['page']); $row['team'] = get_wargameimg($row['game']) . ' ' . $row['team']; $row['class'] = $class; $tpl->set_ar_out($row, 5); } $tpl->set_out('MPL', $MPL, 6); } $design->footer(); } elseif (is_numeric($menu->get(2))) { $_GET['mehr'] = escape($menu->get(2), 'integer'); $erg = @db_query("SELECT\r\n\tDATE_FORMAT(datime,'%d.%m.%Y') as datum,\r\n\ttid, status, owp, opp, wlp,\r\n\tDATE_FORMAT(datime,'%H:%i:%s') as zeit,\r\n\tgegner, tag, page, mail, icq, wo, prefix_wars.`mod`, mtyp,\r\n\tgame, land, txt, prefix_wars.id,\r\n\tname as team\r\n\tFROM prefix_wars\r\n\tleft join prefix_groups ON prefix_wars.tid = prefix_groups.id\r\n\tWHERE prefix_wars.id = " . $_GET['mehr']); db_check_erg($erg); $row = db_fetch_assoc($erg); $row['page'] = get_homepage($row['page']); $row['txt'] = bbcode($row['txt']); if ($row['status'] == 2) { // nextwars
$class = $class == 'Cmite' ? 'Cnorm' : 'Cmite'; $r['class'] = $class; $r['game'] = get_wargameimg($r['game']); $tpl->set_ar($r); $tpl->out(1); } } $limit = 20; $MPL = db_make_sites($page, 'WHERE status = 2', $limit, 'admin.php?wars-next', 'wars'); $anfang = ($page - 1) * $limit; $abf = "SELECT `id`,`gegner`,`game` FROM `prefix_wars` WHERE `status` = 2 ORDER BY `id` DESC LIMIT " . $anfang . "," . $limit; $erg = db_query($abf); while ($row = db_fetch_assoc($erg)) { $class = $class == 'Cmite' ? 'Cnorm' : 'Cmite'; $row['class'] = $class; $row['game'] = get_wargameimg($row['game']); $tpl->set_ar($row); $tpl->out(2); } $tpl->set('MPL', $MPL); $tpl->out(3); $design->footer(); break; case 'info': $design = new design('Ilch Admin-Control-Panel :: Warsinfo', '', 2); $design->header(); $erg = db_query("SELECT DATE_FORMAT(`datime`,'%d.%m.%Y.%H.%i.%s') as `datime`, `id`,`status`,`gegner`,`tag`,`page`,`mail`,`icq`,`wo`,`tid`,`mod`,`game`,`mtyp`,`land`,`txt` FROM `prefix_wars` WHERE `id` = '" . intval($menu->get(2)) . "'"); $_ilch = db_fetch_assoc($erg); list($_ilch['day'], $_ilch['mon'], $_ilch['jahr'], $_ilch['stu'], $_ilch['min'], $_ilch['sek']) = explode('.', $_ilch['datime']); $tpl = new tpl('wars/info', 1); $tpl->set_ar_out($_ilch, 0);