Clansphere :: FREE Clan Content Management System

<?php
$clan_id = 1;
$cs_lang = cs_translate('squadsnav');

$op_squadsnav = cs_sql_option(__FILE__,'squadsnav');
$picwidth = $op_squadsnav['width'];
$picheight = $op_squadsnav['height'];
$picsinline = $op_squadsnav['inline'];
$std_squad_id = $op_squadsnav['stdsquad'];

$cs_squad_id = empty($_REQUEST['wheresquad']) ? $std_squad_id : $_REQUEST['wheresquad'];
settype($cs_squad_id,'integer');

$squads_order = 'squads_order, squads_short';
$where = "clans_id = '" . $clan_id . "' and squads_show IS NOT NULL and squads_show = 1";
$cs_squads = cs_sql_select(__FILE__,'squads','squads_id, squads_name, squads_short',$where,$squads_order,0,0);
$squads_loop = count($cs_squads);

if(!empty($_REQUEST['mod'])) {
if(!empty($_REQUEST['action'])) {
if(!empty($_REQUEST['where'])) {
echo cs_html_form(1,'squadsnav_navlist',$_REQUEST['mod'],$_REQUES T['action'] . '&where='. $_REQUEST['where']);
}
if(!empty($_REQUEST['id'])) {
echo cs_html_form(1,'squadsnav_navlist',$_REQUEST['mod'],$_REQUES T['action'] . '&id=' . $_REQUEST['id']);
}
echo cs_html_form(1,'squadsnav_navlist',$_REQUEST['mod'],$_REQUES T['action']);
}
echo cs_html_form(1,'squadsnav_navlist',$_REQUEST['mod']);
} else {
echo cs_html_form(1,'squadsnav_navlist');
}
echo cs_html_table(1);
echo cs_html_roco(1,'left');
echo cs_html_div(1);
echo cs_dropdown('wheresquad','squads_short',$cs_squads,$cs_squad _id,'squads_id');
echo cs_html_br(0);
echo cs_html_vote('submit',$cs_lang['show'],'submit');
echo cs_html_div(0);
echo cs_html_roco(0);
echo cs_html_table(0);
echo cs_html_form(0);

//Members
$select = 'mem.members_task AS members_task, mem.members_since AS members_since,
mem.users_id AS users_id, usr.users_nick AS users_nick, usr.users_name AS users_name,
usr.users_surname AS users_surname, usr.users_sex AS users_sex, usr.users_age AS users_age,
usr.users_postalcode AS users_postalcode, usr.users_place AS users_place,
usr.users_country AS users_country, usr.users_picture AS users_picture';
$from = 'members mem INNER JOIN {pre}_users usr ON mem.users_id = usr.users_id ';
$where = "mem.squads_id = '" . $cs_squad_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);

echo cs_html_table(1);
echo cs_html_div(1);
$tr = 1;
for($run=0; $run<$members_loop; $run++)
{
echo cs_html_roco($tr,'center',0,0);

if(empty($cs_members[$run]['users_picture']))
{
$place = 'uploads/nopic.png';
echo cs_link(cs_html_img($place,$picheight,$picwidth), 'users','view','id=' . $cs_members[$run]['users_id']);
//echo cs_link($cs_lang['nopic'], 'users','view','id=' . $cs_members[$run]['users_id']);
}
else
{
$place = 'uploads/users/' . $cs_members[$run]['users_picture'];
$size = getimagesize($cs_main['def_path'] . '/' . $place);
echo cs_link(cs_html_img($place,$picheight,$picwidth), 'users','view','id=' . $cs_members[$run]['users_id']);
}

if ($tr == $picsinline)
{
echo cs_html_roco(0);
$tr = 0;
}

$tr = $tr+1;
}
echo cs_html_roco(0);
echo cs_html_div(0);


//Members End
echo cs_html_table(0);
?>