ilch Forum » Ilch Clan 1.1 » Module und Modifikationen » Anpassung Teamliste

Geschlossen
  1. Di. 15.12.2015 15:29 Uhr #1
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    Hallo
    Ihc möchte gerne unter teams die liste auch firstname familyname angezeigt wird unter user lsite wird alles angezeit was und wo muss ich in teams.php einfügen damit es unter teams liste angezeigt wird 
    <?php
#   Copyright by: Manuel
#   Support: www.ilch.de
defined ('main') or die ( 'no direct access' );

function show_members ($gid,$tpl) {
	global $allgAr;

    # icq team bild, hier die zahl aendern.
    $teams_show_icq_pic = 7;


	$q = "SELECT b.uid, a.icq, a.avatar, a.status, a.name, c.name as posi, staat FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_groupfuncs c ON b.fid = c.id WHERE b.gid = ".$gid." ORDER BY c.pos ASC, a.name ASC";
	$erg = db_query($q);
	if (db_num_rows($erg) < 1) {
	    return false;
	}
    $tpl->out(1);
    $class = 'Cnorm';
	while($row = db_fetch_assoc($erg) ) {
		$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
		$row['class'] = $class;
        if ( $row['staat'] != '' ) {
			$row['staat'] = '<img src="include/images/flags/'.$row['staat'].'" alt="" border="0">';
		} else {
            $row['staat'] = 'n/a';
        }
		$row['status'] = ($row['status']? 'aktiv' : 'inaktiv' );
		if(!empty($row['icq'])){
            $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$row['icq'].'&action=add"><img src="http://wwp.icq.com/scripts/online.dll?icq='.$row['icq'].'&img='.$teams_show_icq_pic.'" valign="bottom"  border="0"></a>';
		} else {
			$row['icq'] = 'n/a';
		}
		if($allgAr['teams_show_list']==1){
			if(empty($row['avatar'])){
				$row['avatar'] = 'n/a';
			} else {
				$row['avatar'] = '<img src="'.$row['avatar'].'" alt="Avatar von '.$row['name'].'" border="0" >';
			}
			$tpl->set_ar_out($row,2);
		} else {
			$tpl->set_ar_out($row,3);
		}
	}
	$tpl->out(4);
}



if ($menu->get(1) == 'show') {
	$groups = array();  #collect given teams
	$i = 2;
  while($gid = escape($menu->get($i), 'integer')){
    $groups[] = $gid;
    $i++;
  }
  #$gid = escape($menu->get(2), 'integer');
  if(count($groups) == 1){   #only 1 group to show
    $gid=$groups[0];
    $name = @db_result (db_query("SELECT name FROM prefix_groups WHERE id =".$gid));
  	$bild = @db_result (db_query("SELECT img FROM prefix_groups WHERE id =".$gid));
    $title = $allgAr['title'].' :: Teams :: '.$name;
  	$hmenu = '<a class="smalfont" href="?teams">Teams</a> &raquo; '.$name;
  	$design = new design ( $title , $hmenu );
  	$design->header();
  	$tpl = new tpl ('teams');
  	if (!empty($bild) ) {
      $show = '<img src="'.$bild.'" title="'.$name.'" alt="'.$name.'" border="0"></a>';
    } else {
  	  $show = '<b>'.$name.'</b>';
    }
    $tpl->set_out('show', $show,0);
    show_members ($gid,$tpl);

  }else{  #more groups to show
    $title = $allgAr['title'].' :: Teams :: ';
    $hmenu = '<a class="smalfont" href="?teams">Teams</a>';
    $design = new design ( $title , $hmenu );
    $design->header();
    $tpl = new tpl ('teams');

    foreach($groups as $gid){
      $sql = db_query("SELECT name, img FROM prefix_groups WHERE id =".$gid);
      if (db_num_rows($sql) < 1) {
          continue;
      }
      $row = db_fetch_assoc ($sql);
      if (!empty($row['img']) ) {
        $show = '<img src="'.$row['img'].'" title="'.$row['name'].'" alt="'.$row['name'].'" border="0"></a>';
      } else {
    	  $show = '<b>'.$row['name'].'</b>';
      }
      $tpl->set_out('show', $show,0);
      show_members ($gid,$tpl);
    }

  }

} else {
	$title = $allgAr['title'].' :: Teams';
	$hmenu = 'Teams';
	$design = new design ( $title , $hmenu );
	$design->header();
	$tpl = new tpl ('teams');
  $erg1 = db_query("SELECT name,img,id as gid FROM prefix_groups WHERE zeigen = 1 ORDER BY pos");
	while ($row = db_fetch_assoc($erg1) ) {
	  if (!empty($row['img']) ) {
  		$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><img src="'.$row['img'].'" title="'.$row['name'].'" alt="'.$row['name'].'" border="0"></a>';
		} else {
	  	$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><b>'.$row['name'].'</b></a>';
		}
		$tpl->set_ar_out($row,0);
    if ($allgAr['teams_show_cat'] == 0) {
      show_members ($row['gid'],$tpl);
    }
  }
}

$design->footer(0);
?>

    mfg


    verwendete ilch Version: 1.1 P
    0 Mitglieder finden den Beitrag gut.
  2. Do. 17.12.2015 19:06 Uhr #2
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    hallo ich habe es selber hinbekommen die vornamen und nachnamen werden angezeigt
    wie kann ich ich die profilbilder bzw avatars in memberlis oder teams list vor den namen einblenden
    und möchte anstelle geburtsdatum alter angezeigt bekommen
    ich würde mich über eure hilfen freuen
    mfg


    Zuletzt modifiziert von oflu am 17.12.2015 - 19:26:57
    0 Mitglieder finden den Beitrag gut.
  3. Fr. 18.12.2015 14:33 Uhr #3
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    niemand der mir helfen kann
    0 Mitglieder finden den Beitrag gut.
  4. Fr. 18.12.2015 14:35 Uhr #4
    User Pic
    Nex4T Moderator
    Registriert seit
    28.02.2007
    Beiträge
    3.414
    Beitragswertungen
    213 Beitragspunkte
    Poste mal dein aktuelle code
    while(!asleep()) sheep++;
    www.movely.biz
    www.webplant.eu
    0 Mitglieder finden den Beitrag gut.
  5. Fr. 18.12.2015 14:37 Uhr #5
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    <?php
#   Copyright by: Manuel
#   Support: www.ilch.de
defined ('main') or die ( 'no direct access' );

function show_members ($gid,$tpl) {
	global $allgAr;

    # icq team bild, hier die zahl aendern.
    $teams_show_icq_pic = 7;


	$q = "SELECT b.uid, a.icq, a.avatar, a.familyname, a.firstname, a.status, a.name, c.name as posi, gebdatum, staat FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_groupfuncs c ON b.fid = c.id WHERE b.gid = ".$gid." ORDER BY c.pos ASC, a.name ASC";
	$erg = db_query($q);
	if (db_num_rows($erg) < 1) {
	    return false;
	}
    $tpl->out(1);
    $class = 'Cnorm';
	while($row = db_fetch_assoc($erg) ) {
		$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
		$row['class'] = $class;
        if ( $row['staat'] != '' ) {
			$row['staat'] = '<img src="include/images/flags/'.$row['staat'].'" alt="" border="0">';
		} else {
            $row['staat'] = 'n/a';
        }
		$row['status'] = ($row['status']? 'aktiv' : 'inaktiv' );
		if(!empty($row['icq'])){
            $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$row['icq'].'&action=add"><img src="http://wwp.icq.com/scripts/online.dll?icq='.$row['icq'].'&img='.$teams_show_icq_pic.'" valign="bottom"  border="0"></a>';
		} else {
			$row['icq'] = 'n/a';
		}
		if($allgAr['teams_show_list']==1){
			if(empty($row['avatar'])){
				$row['avatar'] = 'n/a';
			} else {
				$row['avatar'] = '<img src="'.$row['avatar'].'" alt="Avatar von '.$row['name'].'" border="0" >';
			}
			$tpl->set_ar_out($row,2);
		} else {
			$tpl->set_ar_out($row,3);
		}
	}
	$tpl->out(4);
}



if ($menu->get(1) == 'show') {
	$groups = array();  #collect given teams
	$i = 2;
  while($gid = escape($menu->get($i), 'integer')){
    $groups[] = $gid;
    $i++;
  }
  #$gid = escape($menu->get(2), 'integer');
  if(count($groups) == 1){   #only 1 group to show
    $gid=$groups[0];
    $name = @db_result (db_query("SELECT name FROM prefix_groups WHERE id =".$gid));
  	$bild = @db_result (db_query("SELECT img FROM prefix_groups WHERE id =".$gid));
    $title = $allgAr['title'].' :: Teams :: '.$name;
  	$hmenu = '<a class="smalfont" href="?teams">Teams</a> &raquo; '.$name;
  	$design = new design ( $title , $hmenu );
  	$design->header();
  	$tpl = new tpl ('teams');
  	if (!empty($bild) ) {
      $show = '<img src="'.$bild.'" title="'.$name.'" alt="'.$name.'" border="0"></a>';
    } else {
  	  $show = '<b>'.$name.'</b>';
    }
    $tpl->set_out('show', $show,0);
    show_members ($gid,$tpl);

  }else{  #more groups to show
    $title = $allgAr['title'].' :: Teams :: ';
    $hmenu = '<a class="smalfont" href="?teams">Teams</a>';
    $design = new design ( $title , $hmenu );
    $design->header();
    $tpl = new tpl ('teams');

    foreach($groups as $gid){
      $sql = db_query("SELECT name, img FROM prefix_groups WHERE id =".$gid);
      if (db_num_rows($sql) < 1) {
          continue;
      }
      $row = db_fetch_assoc ($sql);
      if (!empty($row['img']) ) {
        $show = '<img src="'.$row['img'].'" title="'.$row['name'].'" alt="'.$row['name'].'" border="0"></a>';
      } else {
    	  $show = '<b>'.$row['name'].'</b>';
      }
      $tpl->set_out('show', $show,0);
      show_members ($gid,$tpl);
    }

  }

} else {
	$title = $allgAr['title'].' :: Teams';
	$hmenu = 'Teams';
	$design = new design ( $title , $hmenu );
	$design->header();
	$tpl = new tpl ('teams');
  $erg1 = db_query("SELECT name,img,id as gid FROM prefix_groups WHERE zeigen = 1 ORDER BY pos");
	while ($row = db_fetch_assoc($erg1) ) {
	  if (!empty($row['img']) ) {
  		$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><img src="'.$row['img'].'" title="'.$row['name'].'" alt="'.$row['name'].'" border="0"></a>';
		} else {
	  	$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><b>'.$row['name'].'</b></a>';
		}
		$tpl->set_ar_out($row,0);
    if ($allgAr['teams_show_cat'] == 0) {
      show_members ($row['gid'],$tpl);
    }
  }
}

$design->footer(0);
?>


    <table width="100%" cellspacing="0" border="0" cellspacing="0" >
<tr class="Cnorm">
	<td colspan="6" valign="bottom" style="padding-left: 0; padding-right: 0;" align="center">{show}</td>
</tr>
</table>
{EXPLODE}
<table width="100%" cellspacing="0" border="0" cellspacing="0" >
{EXPLODE}
<tr class="{class}">
	<td>
<table width="100%" cellspacing="0" border="0" cellspacing="0" >
	<tr>
		td colspan="4" style="vertical-align: bottom;"><a href="index.php?user-details-{uid}">{familyname}</a></td>
		<td colspan="4" style="vertical-align: bottom;"><a href="index.php?user-details-{uid}">{familyname}</a></td>
	</tr><tr>
		<td width="10%"  style="vertical-align: top; padding: 6px;" align="center">{staat}</td>
		<td width="50%"  style="vertical-align: top;">{posi}</td>

		<td width="15%"  style="vertical-align: top;" class="{status}">{gebdatum}</td>

	</tr>
	</table>
	</td>
</tr>
{EXPLODE}
<tr class="{class}">
	<td width="20%"><a href="index.php?user-details-{uid}">{firstname}</a></td>
	<td width="20%"><a href="index.php?user-details-{uid}">{familyname}</a></td>
		<td width="10%" align="center">{staat}</td>
	<td width="40%">{posi}</td>

	<td width="10%" class="{status}">{gebdatum}</td>

</tr>
{EXPLODE}
<tr class="Cdark">
    <td colspan="4">&nbsp;</td>
</tr>
</table>
    0 Mitglieder finden den Beitrag gut.
  6. Fr. 18.12.2015 19:35 Uhr #6
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    bei der memberlist habe ich es hinbekommen bild hinzufügen aber es zeigt nur den standard bild wurstegal.jpg obwohl ich ein profil bild habe hier der code 

    <?php 
#   Copyright by: David Schwarz
#   Support: www.baduncles.game-host.org


defined ('main') or die ( 'no direct access' );

$title = $allgAr['title'].' :: User :: '.$lang['listofmembers'];
$hmenu = $extented_forum_menu.'User <b> &raquo; </b> '.$lang['listofmembers'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu);
$design->header();

$limit = 20;  // Limit 

function getgroups ($uid) {
    $groups = '';
    $res = db_query('SELECT b.name, b.id 
                    FROM prefix_groupusers as a 
                    LEFT JOIN prefix_groups as b ON a.gid = b.id 
                    WHERE a.uid = "' . $uid . '"
                    ORDER BY b.pos');
    if (db_num_rows($res) == 0)
    {
        $groups = '';
    }
    else
    {
        while ($row = db_fetch_object($res))
        {
            $groups .= '<a href="?teams-show-' . $row->id . '">' . $row->name . '</a>, ';
        }
    }
    $groups = substr($groups, 0, -2);
    return ($groups);
}


function profildaten ($uid, $value)
{
    $res = db_query('SELECT a.val 
                    FROM prefix_userfields as a 
                    LEFT JOIN prefix_profilefields as b ON a.fid = b.id
                    WHERE a.uid = ' . $uid . ' AND b.show = "' . $value . '"');
    $show = (db_num_rows($res) ? db_result($res) : '');
    return ($show);
}
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
$MPL = db_make_sites ($page , "" , $limit , '?user' , 'user' );
$anfang = ($page - 1) * $limit;

$tpl = new tpl ( 'user/memb_list.htm' );
$tpl->set_out ( 'SITELINK', $MPL, 0);

$class = '';

$erg92 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -9");
while ($row = db_fetch_object($erg92))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar92 = array('GRUPP9' => $picr,);
    $tpl->set_ar_out($ar92,1);
}

$erg9 = db_query("
SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -9 ORDER by regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg9))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar9 = array('NAME9'  => $row->name,
		 'FAMILYNAME9'  => $row->familyname, 
		 'FIRSTNAME9'	  => $row->firstname, 
		 'TEAMS9' => getgroups($row->id),
		 'GA9'	  => $ga,
		 'CLASS9' => $class,
		 'POSTS9' => $row->posts,
		 'UID9'   => $row->id,
		 'DATE9'  => date('d.m.Y',$row->regist),
		 'AVATAR9' => $avatar
    );
    $tpl->set_ar_out($ar9,2);
}

$erg82 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -8");
while ($row = db_fetch_object($erg82))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar82 = array('GRUPP8' => $picr,);
    $tpl->set_ar_out($ar82,3);
}

$erg8 = db_query("SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -8 ORDER by regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg8))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar8 = array('NAME8'  => $row->name,
		 'FAMILYNAME8'  => $row->familyname, 
		 'FIRSTNAME8'	  => $row->firstname, 
		 'TEAMS8' => getgroups($row->id),
		 'GA8'	  => $ga,
		 'CLASS8' => $class,
		 'POSTS8' => $row->posts,
		 'UID8'	  => $row->id,
		 'DATE8'  => date('d.m.Y',$row->regist),
		 'AVATAR8' => $avatar
    );
    $tpl->set_ar_out($ar8,4);
}

$erg72 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -7");
while ($row = db_fetch_object($erg72))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar72 = array('GRUPP7' => $picr,);
    $tpl->set_ar_out($ar72,5);
}

$erg7 = db_query("SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -7 ORDER by regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg7))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar7 = array('NAME7'  => $row->name,
		 'FAMILYNAME7'  => $row->familyname, 
		 'FIRSTNAME7'   => $row->firstname, 
		 'TEAMS7' => getgroups($row->id),
		 'GA7'	  => $ga,
		 'CLASS7' => $class,
		 'POSTS7' => $row->posts,
		 'UID7'   => $row->id,
		 'DATE7'  => date('d.m.Y',$row->regist),
		 'AVATAR7' => $avatar
    );
    $tpl->set_ar_out($ar7,6);
}

$erg62 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -6");
while ($row = db_fetch_object($erg62))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar62 = array('GRUPP6' => $picr,);
    $tpl->set_ar_out($ar62,7);
}

$erg6 = db_query("SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -6 ORDER by recht,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg6))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar6 = array('NAME6'  => $row->name,
		 'FAMILYNAME6'  => $row->familyname, 
		 'FIRSTNAME6'   => $row->firstname, 
		 'TEAMS6' => getgroups($row->id),
		 'GA6'	  => $ga,
		 'CLASS6' => $class,
		 'POSTS6' => $row->posts,
		 'UID6'	  => $row->id,
		 'DATE6'  => date('d.m.Y',$row->regist),
		 'AVATAR6' => $avatar
    );
    $tpl->set_ar_out($ar6,8);
}

$erg52 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -5");
while ($row = db_fetch_object($erg52))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar52 = array('GRUPP5' => $picr,);
    $tpl->set_ar_out($ar52,9);
}

$erg5 = db_query("SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -5 ORDER by recht,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg5))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar5 = array('NAME5'  => $row->name,
		 'FAMILYNAME5'  => $row->familyname, 
		 'FIRSTNAME5'   => $row->firstname, 
		 'TEAMS5' => getgroups($row->id),
		 'GA5'	  => $ga,
		 'CLASS5' => $class,
		 'POSTS5' => $row->posts,
		 'UID5'   => $row->id,
		 'DATE5'  => date('d.m.Y',$row->regist),
		 'AVATAR5' => $avatar
    );
    $tpl->set_ar_out($ar5,10);
}

$erg42 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -4");
while ($row = db_fetch_object($erg42))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar42 = array('GRUPP4' => $picr,);
    $tpl->set_ar_out($ar42,11);
}

$erg4 = db_query("SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -4 ORDER by recht,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg4))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar4 = array('NAME4'  => $row->name,
		 'FAMILYNAME4'  => $row->familyname, 
		 'FIRSTNAME4'   => $row->firstname, 
		 'TEAMS4' => getgroups($row->id),
		 'GA4'	  => $ga,
		 'CLASS4' => $class,
		 'POSTS4' => $row->posts,
		 'UID4'	  => $row->id,
		 'DATE4'  => date('d.m.Y',$row->regist),
		 'AVATAR4' => $avatar
    );
    $tpl->set_ar_out($ar4,12);
}

$erg32 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -3");
while ($row = db_fetch_object($erg32))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar32 = array('GRUPP3' => $picr,);
    $tpl->set_ar_out($ar32,13);
}

$erg3 = db_query("SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -3 ORDER by recht,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg3))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar3 = array('NAME3'  => $row->name,
		 'FAMILYNAME3'  => $row->familyname, 
		 'FIRSTNAME3'   => $row->firstname, 
		 'TEAMS3' => getgroups($row->id),
		 'GA3'	  => $ga,
		 'CLASS3' => $class,
		 'POSTS3' => $row->posts,
		 'UID3'	  => $row->id,
		 'DATE3'  => date('d.m.Y',$row->regist),
		 'AVATAR3' => $avatar
    );
    $tpl->set_ar_out($ar3,14);
}

$erg22 = db_query("SELECT id,name FROM prefix_grundrechte WHERE id = -2");
while ($row = db_fetch_object($erg22))
{ $pic = 'include/images/rangs/'.$row->name.'.gif';
  $picr = (file_exists($pic)?'<img src="'.$pic.'">':$row->name);
  $ar22 = array('GRUPP2' => $picr,);
    $tpl->set_ar_out($ar22,15);
}

$erg2 = db_query("SELECT posts,firstname,familyname,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -2 ORDER by recht,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg2))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
  $ga = '';
  $age1=explode("-",$row->gebdatum);
  $age = date("Y",time())-$age1[0];
  if ($row->geschlecht == 0)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.= $age;
    }else
    {$ga.= '';
    }
   }elseif($row->geschlecht == 1)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }elseif ($row->geschlecht == 2)
   {if ($row->gebdatum != 0000-00-00 )
    {$ga.=' - '.$age.'';
    }else
    {$ga.='';
    }
   }if ($class == 'Cmite')
   { $class = 'Cnorm';
   } else
    { $class = 'Cmite';
    }
	if (!empty($row->avatar) and file_exists($row->avatar))
{
    $avatar = '<img alt="avatar" src="'.$row->avatar.'" border="0" />';
} else {
    $avatar = '<img alt="avatar" src="include/images/avatars/wurstegal.jpg" border="0" />';
}
    $ar2 = array('NAME2'  => $row->name,
		 'FAMILYNAME2'  => $row->familyname, 
		 'FIRSTNAME2'   => $row->firstname, 
		 'TEAMS2' => getgroups($row->id),
		 'GA2'	  => $ga,
		 'CLASS2' => $class,
		 'POSTS2' => $row->posts,
		 'UID2'	  => $row->id,
		 'DATE2'  => date('d.m.Y',$row->regist),
		 'AVATAR2' => $avatar
    );
    $tpl->set_ar_out($ar2,16);
}


$tpl->out(17);

$design->footer();
?>


    <table width="100%" border="0" cellpadding="3" cellspacing="1" class="border">
{EXPLODE}
<tr><td><table width="99%" border="0" cellpadding="0" cellspacing="0">
	<tr>
	 <td class="Cmember">{GRUPP9}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	 <tr class="Chead" >
	 <th height="20" width="20%">Avatar</th>
	 <th align="center" width="20%">Username</th>
	 <th align="center" width="20%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	</tr>
	{EXPLODE}
	<tr class="{CLASS9}">
	<td align="center">{AVATAR9}</td>
	 <td><a href="index.php?user-details-{UID9}">{NAME9}</a>&nbsp;{GA9}</td>
	 <td align="center">{FAMILYNAME9}</td>
	 <td align="center">{FIRSTNAME9}</td>
     <td align="center">{TEAMS9}</td>
     <td align="center">{DATE9}</td>
	 <td align="center">{POSTS9}</td>
  	</tr>{EXPLODE}
	
</table></td></tr>

<tr><td><br><table width="99%" border="0" cellpadding="0" cellspacing="0">
	<tr>
	 <td class="Cmember">{GRUPP8}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	<tr class="Chead" >
	<th height="20" width="20%">Avatar</th>
	 <th height="20" width="20%">Username</th>
	 <th align="center" width="17%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	</tr>
	{EXPLODE}
	<tr class="{CLASS8}">
	<td align="center">{AVATAR8}</td>
	 <td><a href="index.php?user-details-{UID8}">{NAME8}</a>&nbsp;{GA8}</td>
	 <td align="center">{FAMILYNAME8}</td>
     <td align="center">{FIRSTNAME8}</td>
     <td align="center">{TEAMS8}</td>
	 <td align="center">{DATE8}</td>
	 <td align="center">{POSTS8}</td>
	</tr>{EXPLODE}
	
</table></td></tr>

<tr><td><br><table width="99%" border="0" cellpadding="0" cellspacing="0">
	<tr>
	 <td class="Cmember">{GRUPP7}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	<tr class="Chead" >
	<th height="20" width="20%">Avatar</th>
	 <th height="20" width="20%">Username</th>
	 <th align="center" width="17%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	</tr>
	{EXPLODE}
	<tr class="{CLASS7}">
	<td align="center">{AVATAR7}</td>
	 <td><a href="index.php?user-details-{UID7}">{NAME7}</a>&nbsp;{GA7}</td>
	 <td align="center">{FAMILYNAME7}</td>
	 <td align="center">{FIRSTNAME7}</td>
     <td align="center">{TEAMS7}</td>
     <td align="center">{DATE7}</td>
	 <td align="center">{POSTS7}</td>
	</tr>{EXPLODE}
	
</table></td></tr>

<tr><td><br><table width="99%" border="0" cellpadding="0" cellspacing="0">
	<tr>
	 <td class="Cmember">{GRUPP6}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	<tr class="Chead" >
	<th height="20" width="20%">Avatar</th>
	 <th height="20" width="20%">Username</th>
	 <th align="center" width="17%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	</tr>
	{EXPLODE}
	<tr class="{CLASS6}">
	<td align="center">{AVATAR6}</td>
	 <td><a href="index.php?user-details-{UID6}">{NAME6}</a>&nbsp;{GA6}</td>
	 <td align="center">{FAMILYNAME6}</td>
     <td align="center">{FIRSTNAME6}</td>
     <td align="center">{TEAMS6}</td>
	 <td align="center">{DATE6}</td>
	 <td align="center">{POSTS6}</td>
	</tr>{EXPLODE}
	
</table></td></tr>

<tr><td><br><table width="99%" border="0" cellpadding="0" cellspacing="0">
	<tr>
	 <td class="Cmember">{GRUPP5}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	<tr class="Chead" >
	<th height="20" width="20%">Avatar</th>
	 <th height="20" width="20%">Username</th>
	 <th align="center" width="17%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	</tr>
	{EXPLODE}
	<tr class="{CLASS5}">
	<td align="center">{AVATAR5}</td>
	 <td><a href="index.php?user-details-{UID5}">{NAME5}</a>&nbsp;{GA5}</td>
	 <td align="center">{FAMILYNAME5}</td>
     <td align="center">{FIRSTNAME5}</td>
     <td align="center">{TEAMS5}</td>
	 <td align="center">{DATE5}</td>
	 <td align="center">{POSTS5}</td>
	</tr>{EXPLODE}
	
</table></td></tr>

<tr><td><br><table width="99%" border="0" cellpadding="0" cellspacing="0">
	<tr>
	 <td class="Cmember">{GRUPP4}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	<tr class="Chead" >
	<th height="20" width="20%">Avatar</th>
	 <th height="20" width="20%">Username</th>
	 <th align="center" width="17%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	 </tr>
	{EXPLODE}
	<tr class="{CLASS4}">
	<td align="center">{AVATAR4}</td>
	 <td><a href="index.php?user-details-{UID4}">{NAME4}</a>&nbsp;{GA4}</td>
	 <td align="center">{FAMILYNAME4}</td>
     <td align="center">{FIRSTNAME4}</td>
     <td align="center">{TEAMS4}</td>
	 <td align="center">{DATE4}</td>
	 <td align="center">{POSTS4}</td>
	</tr>{EXPLODE}
	
</table></td></tr>

<tr><td><br><table width="99%" border="0" cellpadding="0" cellspacing="0">
	<tr>
	 <td class="Cmember">{GRUPP3}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	<tr class="Chead" >
	<th height="20" width="20%">Avatar</th>
	 <th height="20" width="15%">Username</th>
	 <th align="center" width="20%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	</tr>
	{EXPLODE}
	<tr class="{CLASS3}">
	<td align="center">{AVATAR3}</td>
	 <td><a href="index.php?user-details-{UID3}">{NAME3}</a>&nbsp;{GA3}</td>
	 <td align="center">{FAMILYNAME3}</td>
     <td align="center">{FIRSTNAME3}</td>
     <td align="center">{TEAMS3}</td>
	 <td align="center">{DATE3}</td>
	 <td align="center">{POSTS3}</td>
	</tr>{EXPLODE}
	
</table></td></tr>

<tr><td><table width="99%" border="0" cellpadding="0" cellspacing="0">
	 <tr>
	 <td class="Cmember">{GRUPP2}</td>
	</tr>
</table></td></tr>

<tr><td><table width="98%" border="0" cellpadding="3" cellspacing="1" class="border">
	<tr class="Chead" >
	<th height="20" width="20%">Avatar</th>
	 <th height="20" width="20%">Username</th>
	 <th align="center" width="20%">{_lang_familyname}</th>
     <th align="center" width="20%">{_lang_firstname}</th>
     <th align="center" width="20%">{_lang_active}</th>
	 <th align="center" width="17%">{_lang_regtime}</th>
	 <th align="center" width="16%" align="center">{_lang_posts}</th>
	</tr>
	{EXPLODE}
	<tr class="{CLASS2}">
	<td align="center">{AVATAR2}</td>
	 <td><a href="index.php?user-details-{UID2}">{NAME2}</a>&nbsp;{GA2}</td>
	 <td align="center">>{FAMILYNAME2}</td>
      <td align="center">{FIRSTNAME2}</td>
      <td align="center">{TEAMS2}</td>
	 <td align="center">{DATE2}</td>
	 <td align="center">{POSTS2}</td>
	</tr>
	{EXPLODE}
</table></td></tr>

</table>


<br />
<div align="center">{SITELINK}</div>


    ich möchte gerne das die bilder bei memberlist und unter teams list wo die namen aufgelistet sind angezeigt wird .
    danke für jede hilfe
    mfg
    0 Mitglieder finden den Beitrag gut.
  7. Fr. 18.12.2015 23:23 Uhr #7
    User Pic
    Nex4T Moderator
    Registriert seit
    28.02.2007
    Beiträge
    3.414
    Beitragswertungen
    213 Beitragspunkte
    ein wenig durcheinander und viel aber du bist auf dem richtigen weg, schau dir mal die show_post.php aus dem content ordner für forum an zwinker
    while(!asleep()) sheep++;
    www.movely.biz
    www.webplant.eu
    0 Mitglieder finden den Beitrag gut.
  8. Sa. 19.12.2015 10:35 Uhr #8
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    bin auf der arbeit muss die stelle so aussehen bei db_query noch avatar hibzufügen??? 

    $erg9 = db_query("
SELECT posts,firstname,familyname,avatar,prefix_user.id,regist,prefix_user.icq,prefix_user.geschlecht,prefix_user.gebdatum,prefix_user.name FROM prefix_user WHERE prefix_user.recht = -9 ORDER by regist,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg9))
{ $icq1 = str_replace("-","",$row->icq);
  $icq2 = str_replace(" ","",$icq1);
   if (is_numeric($icq2))
   {$icq= '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?icq='.$icq2.'&img=12" border="0"></a>';
   }
    0 Mitglieder finden den Beitrag gut.
  9. Sa. 19.12.2015 14:30 Uhr #9
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    hi
    den memberlist habe ich hinbekommen da werden die bilder angezeigt jetzt möchte ich unter teams auch bilder vor den user haben hier ist mein code klappt aber nicht 

    <?php
#   Copyright by: Manuel
#   Support: www.ilch.de
defined ('main') or die ( 'no direct access' );

function show_members ($gid,$tpl) {
	global $allgAr;

    # icq team bild, hier die zahl aendern.
    $teams_show_icq_pic = 7;
$q = "SELECT b.uid, a.icq, a.avatar, a.familyname, a.firstname, a.status, a.name, c.name as posi, gebdatum, staat FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_groupfuncs c ON b.fid = c.id WHERE b.gid = ".$gid." ORDER BY c.pos ASC, a.name ASC";
	$erg = db_query($q);
	if (db_num_rows($erg) < 1) {
	    return false;
	}
    $tpl->out(1);
    $class = 'Cnorm';
	while($row = db_fetch_assoc($erg) ) {
		$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
		$row['class'] = $class;
        if ( $row['staat'] != '' ) {
			$row['staat'] = '<img src="include/images/flags/'.$row['staat'].'" alt="" border="0">';
		} else {
            $row['staat'] = 'n/a';
        }
		$row['status'] = ($row['status']? 'aktiv' : 'inaktiv' );
		if(!empty($row['icq'])){
            $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$row['icq'].'&action=add"><img src="http://wwp.icq.com/scripts/online.dll?icq='.$row['icq'].'&img='.$teams_show_icq_pic.'" valign="bottom"  border="0"></a>';
		} else {
			$row['icq'] = 'n/a';
		}
		if($allgAr['teams_show_list']==1){
			if(empty($row['avatar'])){
				$row['avatar'] = 'n/a';
			} else {
				$row['avatar'] = '<img src="'.$row['avatar'].'" alt="Avatar von '.$row['name'].'" border="0" >';
			}
			$tpl->set_ar_out($row,2);
		} else {
			$tpl->set_ar_out($row,3);
		}
	}
	$tpl->out(4);
}



if ($menu->get(1) == 'show') {
	$groups = array();  #collect given teams
	$i = 2;
  while($gid = escape($menu->get($i), 'integer')){
    $groups[] = $gid;
    $i++;
  }
  #$gid = escape($menu->get(2), 'integer');
  if(count($groups) == 1){   #only 1 group to show
    $gid=$groups[0];
    $name = @db_result (db_query("SELECT name FROM prefix_groups WHERE id =".$gid));
  	$bild = @db_result (db_query("SELECT img FROM prefix_groups WHERE id =".$gid));
    $title = $allgAr['title'].' :: Teams :: '.$name;
  	$hmenu = '<a class="smalfont" href="?teams">Teams</a> &raquo; '.$name;
  	$design = new design ( $title , $hmenu );
  	$design->header();
  	$tpl = new tpl ('teams');
  	if (!empty($bild) ) {
      $show = '<img src="'.$bild.'" title="'.$name.'" alt="'.$name.'" border="0"></a>';
    } else {
  	  $show = '<b>'.$name.'</b>';
    }
    $tpl->set_out('show', $show,0);
    show_members ($gid,$tpl);

  }else{  #more groups to show
    $title = $allgAr['title'].' :: Teams :: ';
    $hmenu = '<a class="smalfont" href="?teams">Teams</a>';
    $design = new design ( $title , $hmenu );
    $design->header();
    $tpl = new tpl ('teams');

    foreach($groups as $gid){
      $sql = db_query("SELECT name, img FROM prefix_groups WHERE id =".$gid);
      if (db_num_rows($sql) < 1) {
          continue;
      }
      $row = db_fetch_assoc ($sql);
      if (!empty($row['img']) ) {
        $show = '<img src="'.$row['img'].'" title="'.$row['name'].'" alt="'.$row['name'].'" border="0"></a>';
      } else {
    	  $show = '<b>'.$row['name'].'</b>';
      }
      $tpl->set_out('show', $show,0);
      show_members ($gid,$tpl);
    }

  }

} else {
	$title = $allgAr['title'].' :: Teams';
	$hmenu = 'Teams';
	$design = new design ( $title , $hmenu );
	$design->header();
	$tpl = new tpl ('teams');
  $erg1 = db_query("SELECT name,img,id as gid FROM prefix_groups WHERE zeigen = 1 ORDER BY pos");
	while ($row = db_fetch_assoc($erg1) ) {
	  if (!empty($row['img']) ) {
  		$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><img src="'.$row['img'].'" title="'.$row['name'].'" alt="'.$row['name'].'" border="0"></a>';
		} else {
	  	$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><b>'.$row['name'].'</b></a>';
		}
		$tpl->set_ar_out($row,0);
    if ($allgAr['teams_show_cat'] == 0) {
      show_members ($row['gid'],$tpl);
    }
  }
}

$design->footer(0);
?>

    <table width="100%" cellspacing="0" border="0" cellspacing="0" >
<tr class="Cnorm">
	<td colspan="6" valign="bottom" style="padding-left: 0; padding-right: 0;" align="center">{show}</td>
</tr>
</table>
{EXPLODE}
<table width="100%" cellspacing="0" border="0" cellspacing="0" >
{EXPLODE}
<tr class="{class}">
	<td>
<table width="100%" cellspacing="0" border="0" cellspacing="0" >
	<tr>
	<td width="%"  style="vertical-align: top; padding: 6px;" align="center">{AVATAR}</td>
		td colspan="4" style="vertical-align: bottom;"><a href="index.php?user-details-{uid}">{familyname}</a></td>
		<td colspan="4" style="vertical-align: bottom;"><a href="index.php?user-details-{uid}">{familyname}</a></td>
	</tr><tr>
		<td width="10%"  style="vertical-align: top; padding: 6px;" align="center">{staat}</td>
		<td width="50%"  style="vertical-align: top;">{posi}</td>

		<td width="15%"  style="vertical-align: top;" class="{status}">{gebdatum}</td>

	</tr>
	</table>
	</td>
</tr>
{EXPLODE}
<tr class="{class}">
<td width="20%"  style="vertical-align: top; padding: 6px;" align="center">{AVATAR}</td>
	<td width="20%"><a href="index.php?user-details-{uid}">{firstname}</a></td>
	<td width="20%"><a href="index.php?user-details-{uid}">{familyname}</a></td>
		<td width="10%" align="center">{staat}</td>
	<td width="40%">{posi}</td>

	<td width="10%" class="{status}">{gebdatum}</td>

</tr>
{EXPLODE}
<tr class="Cdark">
    <td colspan="4">&nbsp;</td>
</tr>
</table>
    0 Mitglieder finden den Beitrag gut.
  10. So. 20.12.2015 10:37 Uhr #10
    User Pic
    Lord|Schirmer Administrator
    Registriert seit
    21.03.2007
    Beiträge
    7.675
    Beitragswertungen
    1212 Beitragspunkte
    <?php
#   Copyright by: Manuel
#   Support: www.ilch.de
defined ('main') or die ('no direct access');
 
function show_members($gid, $tpl)
{
	global $allgAr;
	$teams_show_icq_pic = 7; # icq team bild, hier die zahl aendern.
	$q = "SELECT b.`uid`, a.`icq`, a.`avatar`, a.`familyname`, a.`firstname`, a.`status`, a.`name`, c.`name` as `posi`, a.`gebdatum`, a.`staat` 
		  FROM `prefix_groupusers` b 
		  LEFT JOIN `prefix_user` a ON a.`id` = b.`uid` 
		  LEFT JOIN `prefix_groupfuncs` c ON b.`fid` = c.`id` 
		  WHERE b.`gid` = " . $gid . " 
		  ORDER BY c.`pos` ASC, a.`name` ASC";
    $erg = db_query($q);
    if (db_num_rows($erg) < 1)
	{
		return false;
    }
    $tpl->out(1);
    $class = 'Cnorm';
    while ($row = db_fetch_assoc($erg))
	{
		$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite');
        $row['class'] = $class;
        if ($row['staat'] != '')
		{
			$row['staat'] = '<img src="include/images/flags/' . $row['staat'] . '" alt="" border="0" />';
        }
		else
		{
			$row['staat'] = 'kein Land';
		}
		$row['status'] = ($row['status']? 'aktiv' : 'inaktiv');
		if (!empty($row['icq']))
		{
			$row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin=' . $row['icq'] . '&action=add">';
			$row['icq'].= '<img src="http://wwp.icq.com/scripts/online.dll?icq=' . $row['icq'] . '&img=' . $teams_show_icq_pic . '" valign="bottom" border="0" /></a>';
        } else {
            $row['icq'] = 'n/a';
        }
        if ($allgAr['teams_show_list'] == 1)
		{
			if (empty($row['avatar']))
			{
				$row['avatar'] = 'kein Avatar';
            }
			else
			{
				$row['avatar'] = '<img src="' . $row['avatar'] . '" alt="Avatar von ' . $row['name'] . '" border="0" />';
            }
			$tpl->set_ar_out($row, 2);
        }
		else
		{
			$tpl->set_ar_out($row, 3);
        }
    }
    $tpl->out(4);
}

if ($menu->get(1) == 'show')
{
	$groups = array(); #collect given teams
    $i = 2;
	while ($gid = escape($menu->get($i), 'integer'))
	{
		$groups[] = $gid;
		$i++;
	}
	#$gid = escape($menu->get(2), 'integer');
	if (count($groups) == 1) #only 1 group to show
	{
		$gid = $groups[0];
		$name = @db_result(db_query("SELECT `name` FROM `prefix_groups` WHERE `id` = " . $gid));
		$bild = @db_result(db_query("SELECT `img` FROM `prefix_groups` WHERE `id` = " . $gid));
		$title = $allgAr['title'].' :: Teams :: ' . $name;
		$hmenu = '<a class="smalfont" href="?teams">Teams</a> &raquo; ' . $name;
		$design = new design ($title, $hmenu);
		$design->header();
		$tpl = new tpl('teams');
		if (!empty($bild))
		{
			$show = '<img src="' . $bild . '" title="' . $name . '" alt="' . $name . '" border="0" /></a>';
		}
		else
		{
			$show = '<b>' . $name . '</b>';
		}
		$tpl->set_out('show', $show, 0);
		show_members($gid, $tpl);
	}
	else #more groups to show
	{ 
		$title = $allgAr['title'] . ' :: Teams :: ';
		$hmenu = '<a class="smalfont" href="?teams">Teams</a>';
		$design = new design ($title, $hmenu);
		$design->header();
		$tpl = new tpl ('teams');
		foreach($groups as $gid)
		{
			$sql = db_query("SELECT `name`, `img` FROM `prefix_groups` WHERE `id` = " . $gid);
			if (db_num_rows($sql) < 1)
			{
				continue;
			}
			$row = db_fetch_assoc($sql);
			if (!empty($row['img']))
			{
				$show = '<img src="' . $row['img'] . '" title="' . $row['name'] . '" alt="' . $row['name'] . '" border="0" /></a>';
			}
			else
			{
				$show = '<b>' . $row['name'] . '</b>';
			}
			$tpl->set_out('show', $show, 0);
			show_members($gid, $tpl);
		}
	}
}
else
{
	$title = $allgAr['title'] . ' :: Teams';
    $hmenu = 'Teams';
    $design = new design($title, $hmenu);
    $design->header();
    $tpl = new tpl ('teams');
	$erg1 = db_query("SELECT `name`, `img`, `id` as `gid` FROM `prefix_groups` WHERE `zeigen` = 1 ORDER BY `pos`");
	while ($row = db_fetch_assoc($erg1))
	{
		if (!empty($row['img']))
		{
			$row['show'] = '<a href="index.php?teams-show-' . $row['gid'] . '"><img src="' . $row['img'] . '" title="' . $row['name'] . '" alt="' . $row['name'] . '" border="0" /></a>';
        }
		else
		{
			$row['show'] = '<a href="index.php?teams-show-' . $row['gid'] . '"><b>' . $row['name'] . '</b></a>';
        }
        $tpl->set_ar_out($row, 0);
		if ($allgAr['teams_show_cat'] == 0)
		{
			show_members($row['gid'], $tpl);
		}
	}
}
$design->footer(0);
?>


    <table width="100%" cellspacing="0" border="0" cellspacing="0">
  <tr class="Cnorm">
    <td colspan="6" valign="bottom" style="padding-left:0; padding-right:0;" align="center">{show}</td>
  </tr>
</table>
{EXPLODE}
<table width="100%" cellspacing="0" border="0" cellspacing="0" >
  {EXPLODE}
  <tr class="{class}">
    <td rowspan="2" style="vertical-align:top; padding:6px;" align="center">{avatar}</td>
    <td><a href="index.php?user-details-{uid}">{firstname} {familyname}</a></td>
    <td>{posi}</td>
  </tr><tr class="{class}">
    <td class="{status}">{gebdatum}</td>
    <td>{staat}</td>
  </tr>
  {EXPLODE}
  <tr class="{class}">
    <td><a href="index.php?user-details-{uid}">{firstname} {familyname}</a></td>
    <td>{posi}</td>
    <td class="{status}">{gebdatum}</td>
  </tr>
  {EXPLODE}
  <tr class="Cdark">
    <td colspan="3">&nbsp;</td>
  </tr>
</table>




    Admin --> Konfiguration --> Team Optionen --> Avatar bei den Usern? --> JA

    JA = Liste mit Avatar & Staat
    NEIN = Liste ohne Avatar & Staat
    rules :: doku :: faq :: linkus
    0 Mitglieder finden den Beitrag gut.
  11. Mo. 21.12.2015 07:56 Uhr #11
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    danke hat geklappt mein fehler war auch das ich unter konfrigation avatar aus gehabt hatte jetzt klappts .
    aber ich habe noch ein anliegen
    1.die avatars werden in volle grösse abgebildet kann man es in bestimmte grösse angezeigt bekommen
    2.so einstellen das user nur bestimmte grösse avatar uploaden können.
    3.geburtsdatum wird angezeigt ich möchte aber gerne das alter angezeigt bekommen.

    mfg


    Zuletzt modifiziert von oflu am 21.12.2015 - 07:58:34
    0 Mitglieder finden den Beitrag gut.
  12. Mo. 21.12.2015 10:31 Uhr #12
    User Pic
    Lord|Schirmer Administrator
    Registriert seit
    21.03.2007
    Beiträge
    7.675
    Beitragswertungen
    1212 Beitragspunkte
    ZitatZitat geschrieben von oflu
    1.die avatars werden in volle grösse abgebildet kann man es in bestimmte grösse angezeigt bekommen


    In dem folgend angepassten Code in Zeile 74 kann im <img> Tag ein width hinzugefügt werden, so zum Beispiel mit 60px Breite: 
    $row['avatar'] = '<img src="' . $row['avatar'] . '" alt="Avatar von ' . $row['name'] . '" border="0" width="60" />';


    ZitatZitat geschrieben von oflu
    2.so einstellen das user nur bestimmte grösse avatar uploaden können.


    Adminbereich --> Konfiguration --> Forum Optionen --> max Breite für den Avatar / max Höhe für den Avatar / max Größe in Bytes für den Avatar

    ZitatZitat geschrieben von oflu
    3.geburtsdatum wird angezeigt ich möchte aber gerne das alter angezeigt bekommen.


    Habe den Code angepasst ... nun mit Ausgabe des Alters 

    <?php
#   Copyright by: Manuel
#   Support: www.ilch.de
defined ('main') or die ('no direct access');
 
function show_members($gid, $tpl)
{
	global $allgAr;
	$teams_show_icq_pic = 7; # icq team bild, hier die zahl aendern.
	
	$q = "SELECT b.`uid`, a.`icq`, a.`avatar`, a.`familyname`, a.`firstname`, a.`status`, a.`name`, c.`name` as `posi`, a.`gebdatum`, a.`staat` 
		  FROM `prefix_groupusers` b 
		  LEFT JOIN `prefix_user` a ON a.`id` = b.`uid` 
		  LEFT JOIN `prefix_groupfuncs` c ON b.`fid` = c.`id` 
		  WHERE b.`gid` = " . $gid . " 
		  ORDER BY c.`pos` ASC, a.`name` ASC";
    $erg = db_query($q);
    if (db_num_rows($erg) < 1)
	{
		return false;
    }
    $tpl->out(1);
    $class = 'Cnorm';
    while ($row = db_fetch_assoc($erg))
	{
		$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite');
        $row['class'] = $class;
		
		# ausgabe land flagge
        if ($row['staat'] != '')
		{
			$row['staat'] = '<img src="include/images/flags/' . $row['staat'] . '" alt="" border="0" />';
        }
		else
		{
			$row['staat'] = 'kein Land';
		}
		
		# aktivitaet status
		$row['status'] = ($row['status']? 'aktiv' : 'inaktiv');
		
		# formatierung icq ausgabe
		if (!empty($row['icq']))
		{
			$row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin=' . $row['icq'] . '&action=add">';
			$row['icq'].= '<img src="http://wwp.icq.com/scripts/online.dll?icq=' . $row['icq'] . '&img=' . $teams_show_icq_pic . '" valign="bottom" border="0" /></a>';
        } else {
            $row['icq'] = 'n/a';
        }
		
		# berechnung alter aus geburtsdatum
		list ($jahr, $monat, $tag) = explode('-', $row['gebdatum']);
		if ($jahr >= 1900 AND $jahr <= date("Y") AND $monat >= 1 AND $monat <= 12 AND $tag >= 1 AND $tag <= 31)
		{
			$jetzt = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
			$geburt = mktime(0, 0, 0, $monat, $tag, $jahr);
			$alter = intval(($jetzt - $geburt) / (3600 * 24 * 365));
			$row['alter'] = $alter . ' ' . (($alter == 1)?'Jahr':'Jahre') . ' alt'; 
		}
		else
		{
			$row['alter'] = 'keine Angabe';
		}

		# avatar ausgabe
        if ($allgAr['teams_show_list'] == 1)
		{
			if (empty($row['avatar']))
			{
				$row['avatar'] = 'kein Avatar';
            }
			else
			{
				$row['avatar'] = '<img src="' . $row['avatar'] . '" alt="Avatar von ' . $row['name'] . '" border="0" />';
            }
			$tpl->set_ar_out($row, 2);
        }
		else
		{
			$tpl->set_ar_out($row, 3);
        }
    }
    $tpl->out(4);
}

if ($menu->get(1) == 'show')
{
	$groups = array(); # anzeige mehrere teams
    $i = 2;
	while ($gid = escape($menu->get($i), 'integer'))
	{
		$groups[] = $gid;
		$i++;
	}
	# $gid = escape($menu->get(2), 'integer');
	
	if (count($groups) == 1) # anzeige nur einer gruppe
	{
		$gid = $groups[0];
		$name = @db_result(db_query("SELECT `name` FROM `prefix_groups` WHERE `id` = " . $gid));
		$bild = @db_result(db_query("SELECT `img` FROM `prefix_groups` WHERE `id` = " . $gid));
		$title = $allgAr['title'].' :: Teams :: ' . $name;
		$hmenu = '<a class="smalfont" href="?teams">Teams</a> &raquo; ' . $name;
		$design = new design ($title, $hmenu);
		$design->header();
		$tpl = new tpl('teams');
		if (!empty($bild))
		{
			$show = '<img src="' . $bild . '" title="' . $name . '" alt="' . $name . '" border="0" /></a>';
		}
		else
		{
			$show = '<b>' . $name . '</b>';
		}
		$tpl->set_out('show', $show, 0);
		show_members($gid, $tpl);
	}
	else # mehrere teams anzeigen
	{ 
		$title = $allgAr['title'] . ' :: Teams :: ';
		$hmenu = '<a class="smalfont" href="?teams">Teams</a>';
		$design = new design ($title, $hmenu);
		$design->header();
		$tpl = new tpl ('teams');
		foreach($groups as $gid)
		{
			$sql = db_query("SELECT `name`, `img` FROM `prefix_groups` WHERE `id` = " . $gid);
			if (db_num_rows($sql) < 1)
			{
				continue;
			}
			$row = db_fetch_assoc($sql);
			if (!empty($row['img']))
			{
				$show = '<img src="' . $row['img'] . '" title="' . $row['name'] . '" alt="' . $row['name'] . '" border="0" /></a>';
			}
			else
			{
				$show = '<b>' . $row['name'] . '</b>';
			}
			$tpl->set_out('show', $show, 0);
			show_members($gid, $tpl);
		}
	}
}
else
{
	$title = $allgAr['title'] . ' :: Teams';
    $hmenu = 'Teams';
    $design = new design($title, $hmenu);
    $design->header();
    $tpl = new tpl ('teams');
	$erg1 = db_query("SELECT `name`, `img`, `id` as `gid` FROM `prefix_groups` WHERE `zeigen` = 1 ORDER BY `pos`");
	while ($row = db_fetch_assoc($erg1))
	{
		if (!empty($row['img']))
		{
			$row['show'] = '<a href="index.php?teams-show-' . $row['gid'] . '"><img src="' . $row['img'] . '" title="' . $row['name'] . '" alt="' . $row['name'] . '" border="0" /></a>';
        }
		else
		{
			$row['show'] = '<a href="index.php?teams-show-' . $row['gid'] . '"><b>' . $row['name'] . '</b></a>';
        }
        $tpl->set_ar_out($row, 0);
		if ($allgAr['teams_show_cat'] == 0)
		{
			show_members($row['gid'], $tpl);
		}
	}
}
$design->footer(0);
?>


    <table width="100%" cellspacing="0" border="0" cellspacing="0">
  <tr class="Cnorm">
    <td colspan="6" valign="bottom" style="padding-left:0; padding-right:0;" align="center">{show}</td>
  </tr>
</table>
{EXPLODE}
<table width="100%" cellspacing="0" border="0" cellspacing="0" >
  {EXPLODE}
  <tr class="{class}">
    <td rowspan="2" style="vertical-align:top; padding:6px;" align="center">{avatar}</td>
    <td><a href="index.php?user-details-{uid}">{firstname} {familyname}</a></td>
    <td>{posi}</td>
  </tr><tr class="{class}">
    <td class="{status}">{alter}</td>
    <td>{staat}</td>
  </tr>
  {EXPLODE}
  <tr class="{class}">
    <td><a href="index.php?user-details-{uid}">{firstname} {familyname}</a></td>
    <td>{posi}</td>
    <td class="{status}">{alter}</td>
  </tr>
  {EXPLODE}
  <tr class="Cdark">
    <td colspan="3">&nbsp;</td>
  </tr>
</table>



    Zuletzt modifiziert von Lord|Schirmer am 21.12.2015 - 10:32:16
    rules :: doku :: faq :: linkus
    0 Mitglieder finden den Beitrag gut.
  13. Mo. 21.12.2015 11:51 Uhr #13
    User Pic
    oflu Mitglied
    Registriert seit
    25.08.2015
    Beiträge
    96
    Beitragswertungen
    0 Beitragspunkte
    danke alles hat wunderbar geklappt
    0 Mitglieder finden den Beitrag gut.
Geschlossen

Zurück zu Module und Modifikationen

Optionen: Bei einer Antwort zu diesem Thema eine eMail erhalten