Ich habe schon im Forum nach einem ähnlichen Beitrag gesucht (und auch was gefunden) aber da war leider nichts nützliches dabei.
Mein Problem:
Ich möchte die Memberliste nach "Gruppe" sortieren, dann nach "Posts" und anschließend nach "Name".
Die memb_list.php habe ich aus SLJ Modul Paket. Hier der Code:
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: User :: '.$lang['listofmembers'];
$hmenu = $extented_forum_menu.'User <b> » </b> '.$lang['listofmembers'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1, 'forum/index.htm' );
$design->header();
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc ){
$name = '<a href="?user-name-desc">'.$lang['name'].'</a>';
}else{
$name = '<a href="?user-name-asc">'.$lang['name'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc ){
$rang = '<a href="?user-spezrank-desc">'.$lang['rank'].'</a>';
}else{
$rang = '<a href="?user-spezrank-asc">'.$lang['rank'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$gruppe = '<a href="?user-recht1-desc">'.$lang['group'].'</a>';
}else{
$gruppe = '<a href="?user-recht1-asc">'.$lang['group'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$reg = '<a href="?user-regist1-desc">'.$lang['regtime'].'</a>';
}else{
$reg = '<a href="?user-regist1-asc">'.$lang['regtime'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$icq = '<a href="?user-icq-asc">'.$lang['icq'].'</a>';
}else{
$icq = '<a href="?user-icq-desc">'.$lang['icq'].'</a>';
}
if (( $menu->get(2) ? escape($menu->get(2), 'textarea') : 0 ) == asc){
$a = '<a href="?user-e-desc">'.$lang['posts'].'</a>';
}else{
$a = '<a href="?user-e-asc">'.$lang['posts'].'</a>';
}
$limit = 20; // Limit
$page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 );
$MPL = db_make_sites ($page , "" , $limit , '?user-name-asc' , 'user' );
$anfang = ($page - 1) * $limit;
$tpl = new tpl ( 'user/memb_list.htm' );
$ar = array (
'oname' => $name,
'orank' => $rang,
'ogroup' => $gruppe,
'oicq' => $icq,
'oposts' => $a,
'oregtime' => $reg,
'SITELINK' => $MPL
);
$tpl->set_ar_out($ar,0);
$aufab = ( $menu->get(2) ? escape($menu->get(2), 'textarea') : desc );
$sort1 = ( $menu->get(1) ? escape($menu->get(1), 'textarea') : posts );
if ($sort1 == 'recht1'){
$sort2 = 'recht';
}else{
$sort2 = $sort1;
}
if ($sort2 == 'regist1'){
$sort3 = 'regist';
}else{
$sort3 = $sort2;
}
if ($sort3 == 'e'){
$sort = 'posts';
}else{
$sort = $sort3;
}
$class = '';
$erg = db_query("SELECT
prefix_user.posts,
prefix_user.id,
prefix_grundrechte.name as recht_name,
regist,
prefix_user.staat,
prefix_user.icq,
prefix_user.geschlecht,
prefix_user.gebdatum,
prefix_user.name
FROM prefix_user
LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id ORDER by $sort $aufab
LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg)) {
$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=5" border="0"></a>';
}else{
$icq = '';
}
$ga = '';
$age1=explode("-",$row->gebdatum);
$age = date("Y",time())-$age1[0];
if (date("m",time())-$age1[1] < 0) $age = $age - 1;
elseif ((date("m",time())-$age1[1] == 0) && (date("d",time())-$age1[2] < 0)) $age = $age - 1;
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.='<img src="include/images/icons/mann.gif" border="0"> - '.$age.'';
}else{
$ga.='<img src="include/images/icons/mann.gif" border="0">';
}
}
elseif ($row->geschlecht == 2){
if ($row->gebdatum != 0000-00-00 ){
$ga.='<img src="include/images/icons/frau.gif" border="0"> - '.$age.'';
}else{
$ga.='<img src="include/images/icons/frau.gif" border="0">';
}
}
if ($row->staat){
$flagg = '<img src="include/images/flags/'.$row->staat.'" alt="" border="0">';
}else{
$flagg = '';
}
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar = array ( 'NAME' => $row->name,
'RANG' => userrang($row->posts,$row->id),
'FLAGG' => $flagg,
'ICQ' => $icq,
'GA' => $ga,
'CLASS' => $class,
'POSTS' => $row->posts,
'UID' => $row->id,
'DATE' => date('d.m.Y',$row->regist),
'GRUPE' => $row->recht_name
);
$tpl->set_ar_out($ar,1);
}
$tpl->out(2);
$design->footer();
?>
Ich hoffe ihr könnt mir helfen, weil ich absolut unerfahren bin in PHP.
Vielen Dank!!
Gruß,
shadow
verwendete ilchClan Version: 1.1
