<?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);
