$ds = safe_query("SELECT * FROM ".PREFIX."clanwars ORDER BY ABS(`date`-".time().") ASC LIMIT 1");
$ds = mysql_fetch_array($ds);
$date=date("d.m.Y", $ds['date']);
$time=date("H:i", $ds['date']);
$unixtime = $ds['date'];
if($ds['complete'] == 1) $unixtime = 0;
//$opponent=''.getinput($ds['opptag']).' / '.($ds['opponent']).'';
$opponent=''.($ds['opponent']).'';
$league=''.getinput($ds['league']).'';
if(file_exists('images/games/'.$ds['game'].'.gif')) $game_ico = 'images/games/'.$ds['game'].'.gif';
$bg = "images/clanwars/".$ds['game']."_bg.png";
$game='
';
$maps="";
$hometeam="";
$homescr = array_sum(unserialize($ds['homescore']));
$oppscr = array_sum(unserialize($ds['oppscore']));
$theMaps = unserialize($ds['maps']);
if(is_array($theMaps)) {
$n=1;
foreach($theMaps as $map) {
if($n == 1) {
$maps.= getmapname($map);
} else {
if($map=='') {
$maps=$_language->module['no_maps'];
} else {
$maps.=', '.getmapname($map);
}
}
$n++;
}
}
if($homescr > $oppscr){
$results_1=''.$homescr.'';
$results_2=''.$oppscr.'';
} else if($homescr < $oppscr){
$results_1=''.$homescr.'';
$results_2=''.$oppscr.'';
} else {
$results_1=''.$homescr.'';
$results_2=''.$oppscr.'';
}
$results = $results_1.":".$results_2;
$report=cleartext($ds['report']);
$report = toggle($report, $ds['cwID']);
if($report=="") $report="n/a";
$squad=''.getsquadname($ds['squad']).'';
$opptag=getinput($ds['opptag']);
$oppteam=getinput($ds['oppteam']);
$server=getinput($ds['server']);
$hltv=getinput($ds['hltv']);
if(!empty($ds['hometeam'])) {
$array=unserialize($ds['hometeam']);
$n=1;
foreach($array as $id) {
if(!empty($id)) {
if($n>1) { $hometeam.=', '.getnickname($id).'';
$hometampic.= '
'; }
else {$hometeam.=''.getnickname($id).'';
$hometampic.= '
'; }
$n++;
}
}
}
if(is_array($theMaps)) {
$d=0;
foreach($theMaps as $map) {
if(0==$map) $output = '';
else {
$mapnames=safe_query("SELECT * FROM ".PREFIX."maps WHERE mapID='$map'");
while($db=mysql_fetch_array($mapnames)) {
if(file_exists('images/maps/'.$map.'.jpg')) $pic = $map.'.jpg'; elseif(file_exists('images/maps/'.$map.'.gif')) $pic = $map.'.gif'; else $pic = $map.'.png';
$mappic='
';
}
}
}
}
$clanwarslogos=safe_query("SELECT * FROM ".PREFIX."clanwars_logo WHERE logID='1'");
while($dm=mysql_fetch_array($clanwarslogos)) {
$opponent_logo = "images/clanwars/".$dm['nologo'];
$ownlogo = "images/clanwars/".$dm['logo'];
}
if($ds['banner']) {$opponent_logo="images/clanwars/".$ds['banner']; }