Clansphere :: FREE Clan Content Management System

<?php
$cs_lang = cs_translate('squads');
$data = array();
$clan_id = 4;
$cs_squad_id = 4;

//squads
$select = 'sqd.squads_name AS squads_name, cln.clans_id AS clans_id';
$from = "squads sqd INNER JOIN {pre}_clans cln ON sqd.clans_id = '" . $clan_id . "'";
$where = "sqd.squads_id = '" . $cs_squad_id . "'";
$cs_squads = cs_sql_select(__FILE__,$from,$select,$where);

$data['squads']['name'] = cs_secure($cs_squads['squads_name']);
$data['squads']['info'] = cs_url('squads','view','id=' . $cs_squad_id);

//members
$select = 'mem.users_id AS users_id, usr.users_picture AS users_picture, usr.users_nick AS users_nick';
$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);
$nopic = cs_html_img('uploads/board/nopic.jpg', 50, 50);

if(!empty($cs_members)) {
$data = array();
$run = 0;
foreach ($cs_members AS $members) {
$data['squads'][$run]['link'] = cs_url('users','view','id=' . $cs_members[$run]['users_id']);
$data['squads'][$run]['nick'] = cs_secure($cs_members[$run]['users_nick']);
$data['squads'][$run]['picture'] = empty($cs_members[$run]['users_picture']) ? $nopic :
cs_html_img('uploads/users/' . $cs_members[$run]['users_picture'] , 50 , 50);
$run++;
}
}
echo cs_subtemplate(__FILE__,$data,'squads','navlist');
?>