Clansphere :: FREE Clan Content Management System

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

$cs_lang = cs_translate('wars');

$cs_option = cs_sql_option(__FILE__,'wars');

$data = array();

$select = 'war.games_id AS games_id, cln.clans_short AS clans_short, war.wars_score1 AS wars_score1, '
. 'war.wars_score2 AS wars_score2, war.wars_id AS wars_id, cat.categories_name AS category, war.wars_date AS wars_date';
$from = 'wars war INNER JOIN {pre}_categories cat ON war.categories_id = cat.categories_id INNER JOIN {pre}_clans cln ON war.clans_id = cln.clans_id';
$order = 'war.wars_date DESC';
$cs_wars = cs_sql_select(__FILE__,$from,$select,"war.wars_status = 'played'",$order,0,$cs_option['max_navlist']);

if (!empty($cs_wars)) {

$all = count($cs_wars);
for ($i = 0; $i < $all; $i++) {

$cs_wars[$i]['game_icon'] = file_exists('uploads/games/' . $cs_wars[$i]['games_id'] . '.gif') ?
cs_html_img('uploads/games/' . $cs_wars[$i]['games_id'] . '.gif') : '';
$secure_short = cs_secure($cs_wars[$i]['clans_short']);
$data['wars'][$run]['category'] = cs_secure($cs_wars[$run]['categories_name']);
$data['wars'][$run]['date'] = cs_date('unix',$cs_wars[$run]['wars_date']);
$cs_wars[$i]['enemy'] = cs_url('wars','view','id=' . $cs_wars[$i]['wars_id']);
$cs_wars[$i]['enemy_name'] = $secure_short;

$result = $cs_wars[$i]['wars_score1'] - $cs_wars[$i]['wars_score2'];
$icon = $result > 0 ? 'green' : 'red';
if(empty($result)) $icon = 'grey';
$cs_wars[$i]['icon'] = cs_html_img('symbols/clansphere/' . $icon . '.gif');
}

$data['wars'] = $cs_wars;
echo cs_subtemplate(__FILE__,$data,'wars','navlist');
}
else
echo $cs_lang['no_data'];

<link href="/root/test4/templates/extremegaming/clansphere.css" rel="stylesheet" type="text/css" />
<div>
<div class="lol">
{loop:categories}
<div class="bla">{categories:blank}<a class="board" href="{categories:list_url}">{categories:categories_ name}</a></div>
<div class="blub">Last Post</div>
<div class="angela">Topics</div>
<div align="right" class="krone">Posts</div></div>
<div class="eps">
{loop:board}
<div style="width:{categories:iconwidth}px">{categories:b lank}</div>
<div class="ka"><strong><a style="color:#747170;" href="{board:listcat_url}">{board:board_name}< /a></strong>
<br /><div class="kp">{board:board_text}</div></div>
<div class="rofl">
<div>{board:last_time}</div>
<div class="rot">{board:of} {board:last_usernick}</div></div>
<div class="party">{board:board_threads}</div>
<div class="tim">{board:board_comments}</div>
<div class="yo"><img src="/root/test4/templates/extremegaming/images/boardtr.png" style="margin-top:5px;" alt="" /></div>
{stop:board}
{stop:categories}
</div></div>

.lol {
background-image:url(images/boardbg.png);
height:24px;
margin-left:28px;
width:684px;
}

.bla {
float:left;
margin-left:12px;
margin-top:5px;
}

.blub {
color:#fff;
float:right;
font-family:Tahoma;
font-size:9pt;
font-weight:bold;
margin-right:103px;
margin-top:5px;
}

.angela {
color:#fff;
font-family:Tahoma;
font-size:9pt;
font-weight:bold;
margin-left:306px;
padding-top:5px;
}

.krone {
color:#fff;
font-family:Tahoma;
font-size:9pt;
font-weight:bold;
margin-right:227px;
margin-top:-14px;
}

.eps {
clear: both;
}

.ka {
float:left;
margin-left:40px;
margin-top:5px;
}

.kp {
color:#a3a3a3;
font-size:8pt;
}

.rofl {
float:right;
margin-top:5px;
width:180px;
}

.rot {
color:#a3a3a3;
}

.party {
margin-left:356px;
margin-top:5px;
width:60px;
}

.tim {
margin-left:458px;
margin-top:-14px;
width:60px;
}

.yo {
clear:both;
margin-left:28px;
}

|