$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=''.$db['map'].''; } } } } $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']; }