<?php

$cs_lang = cs_translate('wars');

$select = 'war.games_id AS games_id, war.wars_date AS wars_date, sqd.squads_name AS squads_name, cln.clans_short AS clans_short, cln.clans_name AS clans_name, cln.clans_picture AS clans_picture, war.wars_id AS wars_id, war.categories_id AS categories_id';
$from = 'wars war INNER JOIN {pre}_squads sqd ON war.squads_id = sqd.squads_id INNER JOIN {pre}_clans cln ON war.clans_id = cln.clans_id ';
$upcome = "war.wars_date > '" . cs_time() . "' AND war.wars_status = 'upcoming'";
$order = 'war.wars_date ASC';

$data = array();
$data['wars'] = cs_sql_select(__FILE__,$from,$select,$upcome,$order,0,1);

if(empty($data['wars'])) {
echo cs_html_table(1);
echo cs_html_roco(1,'nonewposts');
echo cs_html_br(4);
echo $cs_lang['noupcomingwar'];
echo cs_html_roco(0);
echo cs_html_table(0);
}
else {
$data['categorie'] = cs_sql_select(__FILE__,'categories','*','categories_id = ' . $data['wars']['categories_id']);
$data['clan1'] = cs_sql_select(__FILE__,'clans','*','clans_id = 1');
foreach($data['categorie'] AS $categorie){
$data['categorie'][key($data['categorie'])] = cs_secure($categorie);
next($data['categorie']);
}

foreach($data['clan1'] AS $clan1){
$data['clan1'][key($data['clan1'])] = cs_secure($clan1);
next($data['clan1']);
}

$data['clan1']['clans_picture'] = !empty($data['clan1']['clans_picture']) ? cs_html_img('uploads/clans/'.$data['clan1']['clans_pict ure'],69,69) : '-';
$data['clan2']['clans_picture'] = !empty($data['wars']['clans_picture']) ? cs_html_img('uploads/clans/'.$data['wars']['clans_pictu re'],69,69) : '';
$data['wars']['date'] = cs_date('unix',$data['wars']['wars_date'],1);
$data['wars']['url'] = cs_url('wars','view','id=' . $data['wars']['wars_id']);
$data['clan1']['squads_name'] = cs_secure($data['wars']['squads_name']);
$data['clan2']['clans_name'] = cs_secure($data['wars']['clans_name']);
$data['clan2']['clans_short'] = cs_secure($data['wars']['clans_short']);



echo cs_subtemplate(__FILE__,$data,'wars','navnext2');
}

?>