<table class="forum" cellpadding="0" cellspacing="{page:cellspacing}" style="width:{page:width}">
<tr>
<td class="headb">{lang:mod_name} - {lang:head_list} </td>
</tr>
<tr>
<td class="leftb">{lang:body}</td>
</tr>
</table>
<br />
{loop:members}
<table class="forum" cellpadding="0" cellspacing="{page:cellspacing}" style="width:{page:width}">
<tr>
<td class="centerb" rowspan="4" style="width:30%"><a href="{url:squads_view:id=}">{members:pic}</ a></td>
<td style="width:20%"><br />{lang:name}</td>
<td><br />{members:icon} {members:name}</td>
</tr>
<tr>
<td> {lang:members}</td>
<td>{loop:squad_members}{squad_members:members}{s quad_members:dot}{stop:squad_members}</td>
</tr>
<tr>
<td>{lang:match}</td>
<td>here last match</td>
</tr>
<tr>
<td>{lang:award}</td>
<td>here last award</td>
</tr>
</table>
{stop:members}

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

$clan_id = 1;

$cs_lang = cs_translate('members');
$op_members = cs_sql_option(__FILE__,'members');

$squads_order = 'squads_order, squads_name';
$cs_squads = cs_sql_select(__FILE__,'squads','*','squads_own = \'1\'',$squads_order,0,0);
$squads_loop = count($cs_squads);

$data['lang']['mod_name'] = $cs_lang[$op_members['label']];

$data['lang']['body'] = sprintf($cs_lang['body_list'], $squads_loop);

if(empty($squads_loop)) {
$data['members'] = '';
}

for($sq_run=0; $sq_run<$squads_loop; $sq_run++) {
$select = 'mem.members_admin AS members_admin, mem.users_id AS users_id, usr.users_nick AS users_nick, usr.users_active AS users_active, usr.users_delete AS users_delete';
$from = 'members mem INNER JOIN {pre}_users usr ON mem.users_id = usr.users_id ';
$where = "mem.squads_id = '" . $cs_squads[$sq_run]['squads_id'] . "'";
$order = 'mem.members_order ASC, usr.users_nick ASC';

$cs_members = cs_sql_select(__FILE__,$from,$select,$where,$order,0,0);
$members_loop = count($cs_members);


if(empty($cs_squads[$sq_run]['squads_picture'])) {
$data['members'][$sq_run]['pic'] = $cs_lang['nopic'];
}
else {
$place = 'uploads/squads/' . $cs_squads[$sq_run]['squads_picture'];
$size = getimagesize($cs_main['def_path'] . '/' . $place);
$data['members'][$sq_run]['pic'] = cs_html_img($place,$size[1],$size[0]);
}

$id = 'id=' . $cs_squads[$sq_run]['squads_id'];
$squads_name = cs_secure($cs_squads[$sq_run]['squads_name']);
$data['members'][$sq_run]['name'] = cs_link($squads_name,'squads','view',$id);

if(!empty($cs_squads[$sq_run]['games_id'])) {
if(file_exists('uploads/games/' . $cs_squads[$sq_run]['games_id'] . '.gif')) {
$data['members'][$sq_run]['icon'] = cs_html_img('uploads/games/' . $cs_squads[$sq_run]['games_id'] . '.gif');
} else {
$data['members'][$sq_run]['icon'] = '';
}
$where = "games_id = '" . $cs_squads[$sq_run]['games_id'] . "'";
$cs_game = cs_sql_select(__FILE__,'games','games_name, games_id',$where);
$id = 'id=' . $cs_game['games_id'];
$data['members'][$sq_run]['game'] = ' ' . cs_link($cs_game['games_name'],'games','view',$id);
} else {
$data['members'][$sq_run]['game'] = ' - ';
$data['members'][$sq_run]['icon'] = '';
}

if(empty($members_loop)) {
$data['loop']['squad_members'] = '';
$data['stop']['squad_members'] = '';
$data['squad_members']['members'] = '';
$data['squad_members']['dot'] = '';
}


for($run=0; $run<$members_loop; $run++) {

$users_nick = cs_secure($cs_members[$run]['users_nick']);

$data['members'][$sq_run]['squad_members'][$run]['membe rs'] = cs_user($cs_members[$run]['users_id'], $users_nick, $cs_members[$run]['users_active'], $cs_members[$run]['users_delete']);

if($run == ($members_loop - 1)) {
$data['members'][$sq_run]['squad_members'][$run]['dot' ] = '';
} elseif(!empty($run)) {
$data['members'][$sq_run]['squad_members'][$run]['dot' ] = ', ';
} else {
$data['members'][$sq_run]['squad_members'][$run]['dot' ] = ', ';
}
}
}

echo cs_subtemplate(__FILE__,$data,'members','teams');