<?php
// ClanSphere 2008 - www.clansphere.net
// $Id: list.php 185 2006-08-09 21:26:11Z hajo $

$cs_lang = cs_translate('members');

$op_members = cs_sql_option(__FILE__,'members');
$op_squads = cs_sql_option(__FILE__,'squads');

$tables = 'squads sq INNER JOIN {pre}_clans cln ON sq.clans_id = cln.clans_id';
$cells = 'sq.squads_id AS squads_id, sq.squads_picture AS squads_picture, sq.squads_name AS squads_name, ';
$cells .= 'sq.clans_id AS clans_id, cln.clans_tagpos AS clans_tagpos, ';
$cells .= 'cln.clans_tag AS clans_tag, sq.squads_picture AS squads_picture';
$cs_squads = cs_sql_select(__FILE__,$tables,$cells,'squads_own = \'1\'','squads_order, squads_name',0,0);
$squads_loop = count($cs_squads);

$members_count = cs_sql_count(__FILE__,'members',0,'users_id');

$data['lang']['members'] = $cs_lang[$op_members['label']];
$data['lang']['list'] = $cs_lang['head_list'];
$data['count']['members'] = $members_count;
$data['pictured']['url'] = cs_url('members','pictured');
$data['pictured']['name'] = $cs_lang['pictured'];

$data['lang']['country'] = $cs_lang['country'];

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

for($sq_run = 0; $sq_run < $squads_loop; $sq_run++) {

$select = 'mem.members_task AS members_task, mem.members_since AS members_since, mem.members_admin AS members_admin, mem.users_id AS users_id, usr.users_nick AS users_nick, usr.users_country AS users_country, usr.users_laston AS users_laston, usr.users_name AS users_name, usr.users_surname AS users_surname, usr.users_active AS users_active, usr.users_invisible AS users_invisible';
$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);

$data['squads'][$sq_run]['membercount'] = $members_loop . ' ' . $cs_lang['members'];

if(!empty($cs_squads[$sq_run]['squads_picture'])) {
$data['squads'][$sq_run]['squads_picture'] = cs_html_img('uploads/squads/' . $cs_squads[$sq_run]['squads_picture'] . '.gif');
}
else {
$data['squads'][$sq_run]['squadspicture'] = '';
}


$data['squads'][$sq_run]['name'] = cs_secure($cs_squads[$sq_run]['squads_name']);
$data['squads'][$sq_run]['squads_picture'] = cs_html_img('uploads/squads/'.$cs_squads[$sq_run]['squads_picture ']);

$data['squads'][$sq_run]['members'] = !empty($cs_members) ? $cs_members : array();

for($run = 0; $run < $members_loop; $run++) {
$url = 'symbols/countries/' . $cs_members[$run]['users_country'] . '.png';
$data['squads'][$sq_run]['members'][$run]['country'] = cs_html_img($url,11,16);
$nick_secure = cs_secure($cs_members[$run]['users_nick']);
$data['squads'][$sq_run]['members'][$run]['nick'] = $cs_squads[$sq_run]['clans_tagpos'] == 1 ?
$cs_squads[$sq_run]['clans_tag'] . ' ' : '';
$data['squads'][$sq_run]['members'][$run]['nick'] .=
cs_user($cs_members[$run]['users_id'],$cs_members[$run]['users_ni ck'], $cs_members[$run]['users_active']);
$data['squads'][$sq_run]['members'][$run]['nick'] .= $cs_squads[$sq_run]['clans_tagpos'] == 2 ?
' ' . $cs_squads[$sq_run]['clans_tag'] : '';
$data['squads'][$sq_run]['members'][$run]['task'] = cs_secure($cs_members[$run]['members_task']);
$data['squads'][$sq_run]['members'][$run]['since'] = empty($cs_members[$run]['members_since']) ? '-'
: cs_date('date',$cs_members[$run]['members_since']);
$data['squads'][$sq_run]['members'][$run]['status' ] = cs_userstatus($cs_members[$run]['users_laston'],$cs_members[$run][' users_invisible']);
$data['squads'][$sq_run]['members'][$run]['users_name' ] =
empty($data['squads'][$sq_run]['members'][$run]['users_ name']) ? '' :
$data['squads'][$sq_run]['members'][$run]['users_name'];
$data['squads'][$sq_run]['members'][$run]['users_surnam e'] =
empty($data['squads'][$sq_run]['members'][$run]['users_ surname']) ? '' :
$data['squads'][$sq_run]['members'][$run]['users_surnam e'];
}

}
echo cs_subtemplate(__FILE__,$data,'members','list');

?>

<table class="forum" style="width:{page:width}">
</table>
<br />

{loop:squads}
<table class="forum" style="width:{page:width}">
<tr>
<td class="headb" colspan="5">
<div style="float:left"><img src="uploads/squads/{squad:squads_picture}" alt="" /></div><br />
</td>
</tr>
<tr>
<td class="leftc" style="width:35px" align="center">{lang:country}</td>
<td class="leftc" style="width:150px">{lang:nick}</td>
<td class="leftc" >{lang:task}</td>
<td class="leftc" style="width:30px" align="center">{lang:page}</td>
</tr>
{loop:members}
<tr>
<td class="leftb">{members:country}</td>
<td class="leftb">{members:nick}</td>
<td class="leftb">{members:task}</td>
<td class="leftb">{members:status}</td>
</tr>
{stop:members}
</table>
<br />
{stop:squads}

|

|

|

|

|

|