function top_match()
{
global $db, $allowHover, $llwars, $picformat, $sql_prefix;
$qry = db("SELECT s1.datum,s1.cid,s1.id,s1.bericht,s1.xonx,s1.punkte,s1.gpunkte,s1.squad_id,s2.icon,s2.name FROM " . $db['cw'] . " AS s1\n LEFT JOIN " . $db['squads'] . " AS s2 ON s1.squad_id = s2.id\n WHERE `top` = '1'\n ORDER BY RAND()");
if ($get = _fetch($qry)) {
//Clans Mod
$clandetailssql = db("SELECT clantag, gegner FROM " . $sql_prefix . "clans WHERE id LIKE " . $get['cid']);
$clans = _fetch($clandetailssql);
$squad = '_defaultlogo.jpg';
$gegner = '_defaultlogo.jpg';
foreach ($picformat as $end) {
if (file_exists(basePath . '/inc/images/clanwars/' . $get['cid'] . '_logo.' . $end)) {
$gegner = $get['cid'] . '_logo.' . $end;
}
if (file_exists(basePath . '/inc/images/squads/' . $get['squad_id'] . '_logo.' . $end)) {
$squad = $get['squad_id'] . '_logo.' . $end;
}
}
if ($allowHover == 1 || $allowHover == 2) {
$hover = 'onmouseover="DZCP.showInfo(\'<tr><td colspan=2 align=center padding=3 class=infoTop>' . jsconvert(re($get['name'])) . '<br/>vs.<br/> ' . jsconvert(re($clans['gegner'])) . '</td></tr><tr><td><b>' . _played_at . ':</b></td><td>' . date("d.m.Y H:i", $get['datum']) . _uhr . '</td></tr><tr><td><b>' . _cw_xonx . ':</b></td><td>' . jsconvert(re($get['xonx'])) . '</td></tr><tr><td><b>' . _result . ':</b></td><td>' . cw_result_nopic_raw($get['punkte'], $get['gpunkte']) . '</td></tr><tr><td><b>' . _comments_head . ':</b></td><td>' . cnt($db['cw_comments'], "WHERE cw = '" . $get['id'] . "'") . '</td></tr>\')" onmouseout="DZCP.hideInfo()"';
}
$topmatch .= show("menu/top_match", array("id" => $get['id'], "clantag" => re(cut($clans['clantag'], $llwars)), "team" => re(cut($get['name'], $llwars)), "game" => substr(strtoupper(str_replace('.' . $icon, '', re($get['icon']))), 0, 5), "id" => $get['id'], "gegner" => $gegner, "squad" => $squad, "hover" => $hover, "info" => $get['datum'] > time() ? date("d.m.Y", $get['datum']) : cw_result_nopic($get['punkte'], $get['gpunkte'])));
}
return empty($topmatch) ? '<center style="margin:3px 0">' . _no_top_match . '</center>' : '<table class="navContent" cellspacing="0">' . $topmatch . '</table>';
}
while ($get = _fetch($qry)) {
$logo_gegner = '_defaultlogo.jpg';
foreach ($picformat as $end) {
if (file_exists('../inc/images/clanwars/' . $get['id'] . '_logo.' . $end)) {
$logo_gegner = $get['id'] . '_logo.' . $end;
}
}
//Wars start
$qry = db("SELECT s1.id,s1.datum,s1.xonx,s1.liga,s1.punkte,s1.gpunkte,s1.squad_id,s1.gametype,s2.icon,s2.name\n FROM " . $db['cw'] . " AS s1\n LEFT JOIN " . $db['squads'] . " AS s2 ON s1.squad_id = s2.id\n WHERE s1.cid LIKE " . $get["id"] . " \n ORDER BY s1.datum DESC");
while ($getm = _fetch($qry)) {
$img = squad($getm['icon']);
$details = show(_clans_cw_show_details, array("id" => $getm['id']));
$class = $color % 2 ? "contentMainSecond" : "contentMainFirst";
$color++;
if ($getm['datum'] < mktime()) {
$result = cw_result_nopic($getm['gpunkte'], $getm['punkte']);
} else {
$result = "-:-";
}
$wars .= show($dir . "/wars", array("datum" => date("d.m.y", $getm['datum']), "squad" => $img . " " . $getm["name"], "gegner" => $gegner, "xonx" => re($getm['xonx']), "liga" => re($getm['liga']), "gametype" => re($getm['gametype']), "class" => $class, "result" => $result, "details" => $details));
}
//Wars Ende
$index = show($dir . "/show", array("head" => $get["clantag"] . " - " . $get["gegner"], "foot" => "", "logo" => "<img src=\"../inc/images/clanwars/" . $logo_gegner . "\">", "clantag" => $get["clantag"], "tag" => _cw_admin_clantag, "land" => _cw_admin_head_country, "name" => _cw_head_gegner, "web" => _url, "gegner" => $get["gegner"], "flagge" => flag($get['country']) . " - " . $get["country"], "website" => "<a href=\"" . $get["url"] . "\" target=\"_blank\">" . $get["url"] . "</a>", "wars" => $wars, "t_datum" => _cw_head_datum, "t_squad" => _cw_head_gegner, "t_liga" => _cw_head_liga, "t_xonx" => _cw_head_xonx, "t_result" => _cw_head_result, "t_details" => _cw_head_details_show));
}
break;
}
## SETTINGS ##
$time_end = generatetime();
$time = round($time_end - $time_start, 4);
page($index, $title, $where, $time);
## OUTPUT BUFFER END ##
$i = $entrys - ($page - 1) * $maxcw;
$entrys = cnt($db['cw'], " WHERE DATE_FORMAT(FROM_UNIXTIME('" . $get['datum'] . "'), '%d.%m.%Y') = '" . date("d.m.Y", intval($_GET['time'])) . "'");
if (_rows($qry)) {
$show = "";
while ($get = _fetch($qry)) {
//Clans Mod Start
$clandetailssql = db("SELECT clantag, gegner, url, country FROM " . $sql_prefix . "clans WHERE id LIKE " . $get['cid']);
$clans = _fetch($clandetailssql);
$flagge = flag($clans['country']);
$gegner = show(_cw_details_gegner, array("gegner" => re(cut($clans['clantag'] . " - " . $clans['gegner'], $lcwgegner)), "url" => '../clans/?action=show&id=' . $get['cid']));
//Clans Mod Ende
$img = squad($get['icon']);
$details = show(_cw_show_details, array("id" => $get['id']));
$class = $color % 2 ? "contentMainSecond" : "contentMainFirst";
$color++;
$show .= show($dir . "/clanwars_show", array("datum" => date("d.m.y", $get['datum']), "img" => $img, "flagge" => $flagge, "gegner" => $gegner, "xonx" => re($get['xonx']), "liga" => re($get['liga']), "gametype" => re($get['gametype']), "class" => $class, "result" => cw_result_nopic($get['punkte'], $get['gpunkte']), "details" => $details));
}
if (_rows($qry)) {
$anz_wo_wars = cnt($db['cw'], " WHERE punkte > gpunkte");
$anz_lo_wars = cnt($db['cw'], " WHERE punkte < gpunkte");
$anz_dr_wars = cnt($db['cw'], " WHERE datum < " . time() . " && punkte = gpunkte");
$anz_ge_wars = cnt($db['cw'], " WHERE datum < " . time() . "");
if (!$_GET['time']) {
$wo_percent = round($anz_wo_wars * 100 / $anz_ge_wars, 1);
$lo_percent = round($anz_lo_wars * 100 / $anz_ge_wars, 1);
$dr_percent = round($anz_dr_wars * 100 / $anz_ge_wars, 1);
$wo_rawpercent = round($anz_wo_wars * 100 / $anz_ge_wars, 0);
$lo_rawpercent = round($anz_lo_wars * 100 / $anz_ge_wars, 0);
$dr_rawpercent = round($anz_dr_wars * 100 / $anz_ge_wars, 0);
}
$anz_ges_wars = show(_cw_stats_ges_wars, array("ge_wars" => $anz_ge_wars));
