$query = mysql_query("SELECT * FROM `cp_user` as `u` INNER JOIN `cp_script_squad` as `s` ON `u`.`squad_id` = `s`.`squad_id` WHERE `s`.`status`='on'");

$i=0;
while($daten = mysql_fetch_array($query))
{
$squad[$i]["squad_id"] = $daten["squad_id"];
$squad[$i]["name"] = $daten["name"];
$squad[$i]["description"] = $daten["description"];
$squad[$i]["icon"] = $daten["icon"];
$squad[$i]["status"] = $daten["status"];

$member[$i]["user_id"] = $daten["user_id"];
$member[$i]["nickname"] = $daten["nickname"];
$member[$i]["rank"] = $daten["task"];
$member[$i]["activity"] = $daten["activity"];
$member[$i]["email"] = $daten["email"];

$i++;

}

$smarty->assign("member",$member);
$smarty->assign("squad",$squad);

{section name=id loop=$squad}
<h2>{if $squad[id].icon}[img]data/squad/{$squad[id].icon}[/img]{/if} {$squad[id].name}</h2>


<table width="100%" border>
<tr>
<td align="center"><u>{#nickname#}</u></td>
<td align="center"><u>{#rank#}</u></td>
<td align="center"><u>{#activity#}</u></td>
<td align="center"><u>{#email#}</u></td>
<td align="center"><u>{#details#}</u></td>
</tr>

{section name=id2 loop=$member}
<tr>
<td>{$member[id2].nickname}</td>
<td>{$member[id2].rank}</td>
<td align="center">{if $member[id2].activity == "active"}<font color="#008000">{#active#}</font>{else}<font color="#ff0000">{#inactive#}</font>{/if}</td>
<td>{$member[id2].email}</td>
<td align="center">{#details#}</td>
</tr>
{sectionelse}
</table>

<table>
{#info_nomember#}
{/section}



{/section}