function myteams($tID = '')
{
global $db,$teamRow,$l_team;
global $picformat, $basePath,$sql_prefix;
//SQL
if(!empty($tID)) $where = "WHERE id = '".intval($tID)."' AND navi = 1";
else $where = "WHERE navi = '1' ORDER BY RAND()";
$get = _fetch(db("SELECT * FROM ".$db['squads']." ".$where.""));
//Members
$qrym = db("SELECT s1.squad,s2.id,s2.level,s2.nick,s2.status,s2.rlname,s2.bday,s4.position
FROM ".$db['squaduser']." AS s1
LEFT JOIN ".$db['users']." AS s2
ON s2.id=s1.user
LEFT JOIN ".$db['userpos']." AS s3
ON s3.squad=s1.squad AND s3.user=s1.user
LEFT JOIN ".$db['pos']." AS s4
ON s4.id=s3.posi
WHERE s1.squad='".$get['id']."'
AND s2.level != 0
ORDER BY s4.pid");
$i=1;
$cnt=0;
while($getm = _fetch($qrym)) {
foreach($picformat as $endung) {
if(file_exists(basePath."/inc/images/uploads/userpics/".$getm['id'].".".$endung)) {
$qryrahmensettings = db("SELECT * FROM ".$sql_prefix."playerrahmen_settings");
$qryrahmensettings = _fetch($qryrahmensettings);
if($qryrahmensettings['all'] != 0) {
$qry = db("SELECT * FROM ".$sql_prefix."playerrahmen
WHERE id = '".$qryrahmensettings['all']."'");
} else {
$qry2 = db("SELECT s1.rahmen,s2.* FROM ".$db['users']." AS s1
LEFT JOIN ".$sql_prefix."playerrahmen AS s2
ON s1.rahmen = s2.id
WHERE s1.id = '".$getm['id']."'");
}
$get2 = _fetch($qry2);
if($qryrahmensettings['show_nick'] == 1) {
$qrynick = db("SELECT nick FROM ".$db['users']."
WHERE id = '".intval($getm['id'])."'");
$getnick = _fetch($qrynick);
$nick = str_replace("#","ii35",$getnick['nick']);
$nick = str_replace("&","ii38",$nick);
}
if($get2['rahmen'] != 0 OR $qryrahmensettings['all'] != 0) $pic = '<img src="../inc/playerrahmen.php?pic='.$getm['id'].'.'.$endung.'&rahmen='.$get2['pic'].'&nick='.$nick.'&width=170&height=210&font='.$get2['font'].'&fontsize='.$get2['fontsize'].'&color='.$get2['color'].'&angle='.$get2['rotation'].'&x='.$get2['x'].'&y='.$get2['y'].'" longdesc="../user/?action=user&id='.$getm['id'].'" width="88" height="116" alt="" />';
else $pic = '<img src="../inc/images/uploads/userpics/'.$getm['id'].'.'.$endung.'" longdesc="../user/?action=user&id='.$getm['id'].'" width="88" height="116" title="'.re($getm['nick']).'" alt="'.re($getm['nick']).'" font-color="#ffffff" />';
break;
} else {
$pic = '<img src="../inc/images/nopic.gif" longdesc="../user/?action=user&id='.$getm['id'].'" width="88" height="116" title="'.re($getm['nick']).'" alt="'.re($getm['nick']).'" font-color="#ffffff" />';
}
}
$member .= '</pre>'.$pic.'<pre>';
}
return $member; |