ich habe bereits die SuFu benutzt aber nichts passendes gefunden.
Und zwar möchte ich in die memb_list.php eine Abfrage einbauen ob in der Datenbank eine Homepage hinterlegt ist.
also etwa so:
if { Eintrag in Datenbank vorhanden ?
echo '<a href="[homepage]"><img src="bild.jpg" border="0"></a>' } else { echo 'keine Homepage' }
Bin absoluter php Noob, bitte um Nachsicht ^^
meine aktuelle memb_list.php sieht so aus (schon etwas umgebaut):
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Gastgeberverzeichnis :: '.$lang['listofmembers'];
$hmenu = $extented_forum_menu.'Gastgeberverzeichnis <b> » </b> '.$lang['listofmembers'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
$aftercheck = '';
if ( isset($row['homepage'])) {
$aftercheck = '<a href="'.$row['homepage'].'">hier</a>';
}
else { $aftercheck = '---'; }
$limit = 20; // Limit
$tpl = new tpl ( 'user/memb_list.htm' );
if($menu->exists('filtername')){
$page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 );
$filtername = escape($menu->get(2), 'string');
}else{
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
}
$anfang = ($page - 1) * $limit;
$tpl = new tpl ( 'user/memb_list.htm' );
if(isset($_GET['filtername']) AND !empty($_GET['filtername'])){
$filtername = escape($_GET['filtername'], 'string');
}
if(!empty($filtername)){
$sql_search=" WHERE prefix_user.name LIKE '%".$filtername."%'";
$MPL = db_make_sites ($page , $sql_search , $limit , '?user-filtername-'.$filtername , 'user' );
}else{
$sql_search="";
$MPL = db_make_sites ($page , "" , $limit , '?user' , 'user' );
}
$tpl->set_out ( 'SITELINK', $MPL, 0);
$class = '';
$erg = db_query("SELECT
posts,
prefix_user.id,
prefix_grundrechte.name as recht_name,
regist,
prefix_user.avatar,
prefix_user.sterne,
prefix_user.gastro,
prefix_user.wohnort,
prefix_user.homepage,
prefix_user.name
FROM prefix_user
LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id
$sql_search
WHERE prefix_user.recht = -2
ORDER by sterne,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar = array ( 'NAME' => $row->name,
'RANG' => userrang($row->posts,$row->id),
'CLASS' => $class,
'POSTS' => $row->posts,
'UID' => $row->id,
'DATE' => date('d.m.Y',$row->regist),
'BILD' => $row->avatar,
'HOMEPAGE' => $aftercheck,
'ORTSTEIL' => $row->wohnort,
'GASTRO' => $row->gastro,
'STERNE' => $row->sterne,
'GRUPE' => $row->recht_name
);
$tpl->set_ar_out($ar,1);
}
$erg2 = db_query("SELECT
posts,
prefix_user.id,
prefix_grundrechte.name as recht_name,
regist,
prefix_user.avatar,
prefix_user.sterne,
prefix_user.gastro,
prefix_user.wohnort,
prefix_user.homepage,
prefix_user.name
FROM prefix_user
LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id
$sql_search
WHERE prefix_user.recht = -1
ORDER by name,prefix_user.posts DESC LIMIT ".$anfang.",".$limit);
while ($row = db_fetch_object($erg2)) {
if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$ar1 = array ( 'NAME' => $row->name,
'RANG' => userrang($row->posts,$row->id),
'CLASS' => $class,
'POSTS' => $row->posts,
'UID' => $row->id,
'DATE' => date('d.m.Y',$row->regist),
'BILD' => $row->avatar,
'HOMEPAGE' => $aftercheck,
'ORTSTEIL' => $row->wohnort,
'GASTRO' => $row->gastro,
'STERNE' => $row->sterne,
'GRUPE' => $row->recht_name
);
$tpl->set_ar_out($ar1,1);
}
$tpl->set_out('filtername',$filtername ? $filtername : '',2);
$design->footer();
?>
Vielen Dank im Voraus für Eure Hilfe
Zuletzt modifiziert von kugelschubs am 27.11.2010 - 12:12:11
Zitat
