Clansphere :: FREE Clan Content Management System

<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: navnext.php 101 2006-07-12 09:36:29Z hajo $

$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_name AS clans_name, war.wars_id AS wars_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';
$cs_wars = cs_sql_select(__FILE__,$from,$select,$upcome,$order,0,4);

if(empty($cs_wars)) {
echo $cs_lang['no_data'];
}
else {
foreach ($cs_wars AS $wars) {
echo cs_date('unix',$wars['wars_date'],1);
echo cs_html_br(1);
echo cs_html_img('uploads/games/' . $wars['games_id'] . '.gif') . ' ';
$name = cs_secure($wars['squads_name']) . ' vs ' . cs_secure($wars['clans_name']);
echo cs_link($name,'wars','view','id=' . $wars['wars_id']);
echo cs_html_br(1);
}
}

?>

|

|