Clansphere :: FREE Clan Content Management System

$replaced_nick = array();
$clan_id = 1;
$bx_clan = bx_sql_select(__FILE__,'clans','*',"clans_id = '" . $clan_id . "'");
$squads_order = 'squads_order, squads_name';
$bx_squads = bx_sql_select(__FILE__,'squads','*',"clans_id = '" . $clan_id . "'",$squads_order,0,0);
$squads_loop = count($bx_squads);

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

$select = 'mem.members_task AS members_task, mem.members_since AS members_since, ';
$select .= 'mem.users_id AS users_id, usr.users_nick AS users_nick, ';
$select .= 'usr.users_id AS users_id, usr.users_picture AS users_picture, ';
$select .= 'usr.users_country AS users_country, usr.users_laston AS users_laston';
$from = 'members mem INNER JOIN {pre}_users usr ON mem.users_id = usr.users_id ';
$where = "mem.squads_id='" . $bx_squads[$sq_run]['squads_id'] . "'";
$order = 'mem.members_order ASC, usr.users_nick ASC';

$bx_members = bx_sql_select(__FILE__,$from,$select,$where,$order,0,0);
$members_loop = count($bx_members);

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

$url = 'symbols/countries/' . $bx_members[$run]['users_country'] . '.png';
$users_country = $bx_members[$run]['users_country'];
$users_nick = $bx_members[$run]['users_nick'];
$users_id = $bx_members[$run]['users_id'];
$users_picture = $bx_members[$run]['users_picture'];
$returned_nick = bx_html_img($url,0,0,'align="top"', "[".$users_country."]").bx_html_big(1);
$returned_nick .= bx_link($users_nick,'users','view','id=' . $bx_members[$run]['users_id'], "bold-link").bx_html_big(0);

if(!empty($users_picture) && empty($replaced_nick[$users_id."bild"]))
{
$returned_userpic = bx_html_img("uploads/users/".$users_picture,0,0,'align="bott om"', $users_picture);


$replaced_nick[$users_id."bild"]=1;
$replace = str_replace("[userpic=".$users_nick."]",$returned_userpic,$replace);
}
else $replace = str_replace("[userpic=".$users_nick."]","",$replace);


if(empty($replaced_nick[$users_id.'name'])){
$replace = str_replace($users_nick,$returned_nick,$replace);
$replaced_nick[$users_id.'name']=1;
}

}
}