Clansphere :: FREE Clan Content Management System

<?php
// ClanSphere 2009 - www.clansphere.net
// $Id$

$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, cat.categories_name AS category, war.wars_id AS wars_id';
$from = 'wars war INNER JOIN {pre}_categories cat ON war.categories_id = cat.categories_id 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,3);

if(empty($data['wars'])) {

echo $cs_lang['no_data'];

} else {

$count_wars = count($data['wars']);

for ($run = 0; $run < $count_wars; $run++) {
$data['wars'][$run]['date'] = cs_date('unix',$data['wars'][$run]['wars_date'],0);
$data['wars'][$run]['url'] = cs_url('wars','view','id=' . $data['wars'][$run]['wars_id']);
$data['wars'][$run]['category'] = cs_secure($data['wars'][$run]['categories_name']);
$data['wars'][$run]['squads_name'] = cs_secure($data['wars'][$run]['squads_name']);
$data['wars'][$run]['clans_name'] = cs_secure($data['wars'][$run]['clans_name']);
$data['wars'][$run]['games_img'] = cs_html_img('uploads/games/' . $data['wars'][$run]['games_id'] . '.gif');
}

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

{wars:category}

|

Bei Problemen mit Code von mir bitte eine Private Nachricht an mich

|

|

Clan-Page -> www.kultis-ohne-gnade.de

|

Bei Problemen mit Code von mir bitte eine Private Nachricht an mich

|

|