Dragonfly CMS - German Community

lexi_ · Dabei seit: Jul 07, 2004 Beiträge: 178

Hallo,
habe das modul memberlist erweitert. Es funktioniert auch wie es sollte das einzigste problem habe ich mit der sortierung, wo hab ich was falsch gemacht ?
/modules/memberlist/index.php

Array:

<?php
/***************************************************************************
 *					memberlist.php
 *				  -------------------
 *	 begin		  : Friday, May 11, 2001
 *	 copyright		  : (C) 2001 The phpBB Group
 *	 email		  :  support @ phpbb.com
 *
  Last modification notes:
  $Source: /cvs/html/modules/Members_List/index.php,v $
  $Revision: 9.3 $
  $Author: djmaze $
  $Date: 2005/03/12 03:14:55 $
 *
 ***************************************************************************
 *
 *	 This program is free software; you can redistribute it and/or modify
 *	 it under the terms of the GNU General Public License as published by
 *	 the Free Software Foundation; either version 2 of the License, or
 *	 (at your option) any later version.
 *
 ***************************************************************************/
if (!defined('CPG_NUKE')) { exit; }
global $pagetitle;
define('IN_PHPBB', true);
$phpbb_root_path = 'modules/Forums/';
include($phpbb_root_path.'common.php');
$mod_name = $module_title;
$members_per_page = 25;
	
init_userprefs($userinfo);

$start = ( isset($_GET['start']) && intval($_GET['start'])) ? $_GET['start'] : 0;

if ( isset($_GET['mode']) || isset($_POST['mode']) ) {
	$mode = isset($_POST['mode']) ? htmlprepare($_POST['mode']) : htmlprepare($_GET['mode']);
} else {
	$mode = 'joined';
}

if ( isset($_GET['order']) || isset($_POST['order']) ) {
	$sort_order = isset($_POST['order']) ? $_POST['order'] : $_GET['order'];
}
$sort_order = (isset($sort_order) && $sort_order == 'DESC') ? 'DESC' : 'ASC';

//
// Generate page
//
$pagetitle .= _Members_ListLANG;
define('HEADER_INC', TRUE);
require_once("header.php");
OpenTable();

if (!THEME_USES_TPL) {
	$template->set_filenames(array('body' => 'memberlist_body.tpl'));
}

$template->assign_vars(array(
	'L_SELECT_SORT_METHOD' => $lang['Select_sort_method'],
	'L_USERNAME' => $lang['Username'],
	'L_EMAIL' => $lang['Email'],
	'L_WEBSITE' => $lang['Website'],
	'L_FROM' => $lang['Location'],
	'L_USER_AGE' => $lang['User_age'],
	'L_ORDER' => $lang['Order'],
	'L_PRIVATE_MESSAGE' => $lang['Private_Message'],
	'L_SORT' => $lang['Sort'],
	'L_SUBMIT' => $lang['Sort'],
	'L_AIM' => $lang['AIM'],
	'L_YIM' => $lang['YIM'],
	'L_MSNM' => $lang['MSNM'],
	'L_ICQ' => $lang['ICQ'],
	'L_JOINED' => $lang['Joined'],
	'L_POSTS' => $lang['Posts'],
	'L_PM' => $lang['Private_Message'],

	'S_MODE_SELECT' => select_box('mode', $mode, array('joindate'=>'Joined date', 'username'=>'Username', 'location'=>'Location', 'User_age'=>'User_age', 'posts'=>'Posts', 'website'=>'Website')),
	'S_ORDER_SELECT' => select_box('order', $sort_order, array('ASC'=>'Ascending', 'DESC'=>'Descending')),
	'S_MODE_ACTION' => '')
);
//'S_MODE_ACTION' => getlink('Members_List') change to allow you to stay on home page if memberslist is home

if ( isset($_GET['mode']) || isset($_POST['mode']) )
{
	$mode = ( isset($_POST['mode']) ) ? $_POST['mode'] : $_GET['mode'];

	switch( $mode )
	{
	case 'joindate':
		$order_by = "user_id $sort_order LIMIT $start, " . $members_per_page;
		break;
	case 'username':
		$order_by = "username $sort_order LIMIT $start, " . $members_per_page;
		break;
	case 'location':
		$order_by = "user_from $sort_order LIMIT $start, " . $members_per_page;
		break;
	case 'user_age':
		$order_by = "user_age $sort_order LIMIT $start, " . $members_per_page;
		break;
	case 'posts':
		$order_by = "user_posts $sort_order LIMIT $start, " . $members_per_page;
		break;
	case 'website':
		$order_by = "user_website $sort_order LIMIT $start, " . $members_per_page;
		break;
	default:
		$order_by = "user_id $sort_order LIMIT $start, " . $members_per_page;
		break;
	}
}
else
{
	$order_by = "user_id $sort_order LIMIT $start, " . $members_per_page;
}

$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_age, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
	FROM " . USERS_TABLE . "
	WHERE user_id <> " . ANONYMOUS . " AND user_level > '0'
	ORDER BY $order_by";
$result = $db->sql_query($sql,false, __FILE__, __LINE__);

if ( $row = $db->sql_fetchrow($result) )
{
	$i = 0;
	do
	{
		$username = $row['username'];
		$user_id = $row['user_id'];
		if (( $row['user_website'] == "http:///") || ( $row['user_website'] == "http://")){
			$row['user_website'] =	"";
		}
		if (($row['user_website'] != "" ) && (substr($row['user_website'],0, 7) != "http://")) {
			$row['user_website'] = "http://".$row['user_website'];
		}
		$row['user_from'] = str_replace(".gif", "", $row['user_from']);
		$from = ( !empty($row['user_from']) ) ? $row['user_from'] : ' ';
		$user_age = $row['user_age'];
//		  $joined = date("M d, Y" , $row['user_regdate']);
		$joined = $row['user_regdate'];
		$posts = ( $row['user_posts'] ) ? $row['user_posts'] : 0;

		$poster_avatar = '';
		if ( $row['user_avatar_type'] && $user_id != ANONYMOUS && $row['user_allowavatar'] )
		{
			switch( $row['user_avatar_type'] )
			{
				case USER_AVATAR_UPLOAD:
					$poster_avatar = ( $MAIN_CFG['avatar']['allow_upload'] ) ? '<img src="' . $MAIN_CFG['avatar']['path'] . '/' . $row['user_avatar'] . '" alt="" border="0" />' : '';
					break;
				case USER_AVATAR_REMOTE:
					$poster_avatar = ( $MAIN_CFG['avatar']['allow_remote'] ) ? '<img src="' . $row['user_avatar'] . '" alt="" border="0" />' : '';
					break;
				case USER_AVATAR_GALLERY:
					$poster_avatar = ( $MAIN_CFG['avatar']['allow_local'] ) ? '<img src="' . $MAIN_CFG['avatar']['gallery_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" />' : '';
					break;
			}
		}

		if ( !empty($row['user_viewemail']) || is_admin() ) {
			$email_uri = ( $board_config['board_email_form'] ) ? getlink("Forums&file=profile&mode=email&" . POST_USERS_URL .'=' . $user_id) : 'mailto:' . $row['user_email'];
			$email_img = '<a href="' . $email_uri . '"><img src="' . $images['icon_email'] . '" alt="' . $lang['Send_email'] . '" title="' . $lang['Send_email'] . '" border="0" /></a>';
			$email = '<a href="' . $email_uri . '">' . $lang['Send_email'] . '</a>';
		} else {
			$email_img = ' ';
			$email = ' ';
		}

		$temp_url = getlink("Your_Account&profile=$user_id");
		$profile_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_profile'] . '" alt="' . $lang['Read_profile'] . '" title="' . $lang['Read_profile'] . '" border="0" /></a>';
		$profile = '<a href="' . $temp_url . '">' . $lang['Read_profile'] . '</a>';

		if (is_active("Private_Messages")) {
			$temp_url = getlink("Private_Messages&mode=post&" . POST_USERS_URL . "=$user_id");
			$pm_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_pm'] . '" alt="' . $lang['Send_private_message'] . '" title="' . $lang['Send_private_message'] . '" border="0" /></a>';
			$pm = '<a href="' . $temp_url . '">' . $lang['Send_private_message'] . '</a>';
		} else {
			$pm = $pm_img = '';
		}

		$www_img = ( $row['user_website'] ) ? '<a href="' . $row['user_website'] . '" target="_userwww"><img src="' . $images['icon_www'] . '" alt="' . $lang['Visit_website'] . '" title="' . $lang['Visit_website'] . '" border="0" /></a>' : '';
		$www = ( $row['user_website'] ) ? '<a href="' . $row['user_website'] . '" target="_userwww">' . $lang['Visit_website'] . '</a>' : '';

		if ( !empty($row['user_icq']) ) {
			$icq_status_img = '<a href="http://wwp.icq.com/' . $row['user_icq'] . '#pager"><img src="http://web.icq.com/whitepages/online?icq=' . $row['user_icq'] . '&amp;img=5" width="18" height="18" border="0" /></a>';
			$icq_img = '<a href="http://wwp.icq.com/scripts/search.dll?to=' . $row['user_icq'] . '"><img src="' . $images['icon_icq'] . '" alt="' . $lang['ICQ'] . '" title="' . $lang['ICQ'] . '" border="0" /></a>';
			$icq =	'<a href="http://wwp.icq.com/scripts/search.dll?to=' . $row['user_icq'] . '">' . $lang['ICQ'] . '</a>';
		} else {
			$icq_status_img = '';
			$icq_img = '';
			$icq = '';
		}

		$aim_img = ( $row['user_aim'] ) ? '<a href="aim:goim?screenname=' . $row['user_aim'] . '&amp;message=Hello+Are+you+there?"><img src="' . $images['icon_aim'] . '" alt="' . $lang['AIM'] . '" title="' . $lang['AIM'] . '" border="0" /></a>' : '';
		$aim = ( $row['user_aim'] ) ? '<a href="aim:goim?screenname=' . $row['user_aim'] . '&amp;message=Hello+Are+you+there?">' . $lang['AIM'] . '</a>' : '';

		$temp_url = getlink("Your_Account&profile=$user_id");
		$msn_img = ( $row['user_msnm'] ) ? '<a href="' . $temp_url . '"><img src="' . $images['icon_msnm'] . '" alt="' . $lang['MSNM'] . '" title="' . $lang['MSNM'] . '" border="0" /></a>' : '';
		$msn = ( $row['user_msnm'] ) ? '<a href="' . $temp_url . '">' . $lang['MSNM'] . '</a>' : '';

		$yim_img = ( $row['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $row['user_yim'] . '&amp;.src=pg"><img src="' . $images['icon_yim'] . '" alt="' . $lang['YIM'] . '" title="' . $lang['YIM'] . '" border="0" /></a>' : '';
		$yim = ( $row['user_yim'] ) ? '<a href="http://edit.yahoo.com/config/send_webmesg?.target=' . $row['user_yim'] . '&amp;.src=pg">' . $lang['YIM'] . '</a>' : '';

		$temp_url = getlink("Forums&file=search&search_author=" . urlencode($username) . "&showresults=posts");
		$search_img = '<a href="' . $temp_url . '"><img src="' . $images['icon_search'] . '" alt="' . $lang['Search_user_posts'] . '" title="' . $lang['Search_user_posts'] . '" border="0" /></a>';
		$search = '<a href="' . $temp_url . '">' . $lang['Search_user_posts'] . '</a>';

		$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
		$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

		$template->assign_block_vars('memberrow', array(
			'ROW_NUMBER' => $i + 1 + $start,
			'ROW_COLOR' => '#' . $row_color,
			'ROW_CLASS' => $row_class,
			'USERNAME' => $username,
			'FROM' => $from,
			'USER_AGE' => $user_age,
			'JOINED' => $joined,
			'POSTS' => $posts,
			'AVATAR_IMG' => $poster_avatar,
			'PROFILE_IMG' => $profile_img,
			'PROFILE' => $profile,
			'SEARCH_IMG' => $search_img,
			'SEARCH' => $search,
			'PM_IMG' => $pm_img,
			'PM' => $pm,
			'EMAIL_IMG' => $email_img,
			'EMAIL' => $email,
			'WWW_IMG' => $www_img,
			'WWW' => $www,
			'ICQ_STATUS_IMG' => $icq_status_img,
			'ICQ_IMG' => $icq_img,
			'ICQ' => $icq,
			'AIM_IMG' => $aim_img,
			'AIM' => $aim,
			'MSN_IMG' => $msn_img,
			'MSN' => $msn,
			'YIM_IMG' => $yim_img,
			'YIM' => $yim,

			'U_VIEWPROFILE' => getlink("Your_Account&profile=$user_id"))
		);

		$i++;
	}
	while ( $row = $db->sql_fetchrow($result) );
	$db->sql_freeresult($result);
}

	$sql = "SELECT count(*) AS total FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS;
	list($total_members) = $db->sql_ufetchrow($sql,SQL_NUM,__FILE__);

	$pagination = generate_pagination("Members_List&mode=$mode&order=$sort_order", $total_members, $members_per_page, $start). ' ';


$template->assign_vars(array(
	'PAGINATION' => $pagination,
	'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $members_per_page ) + 1 ), ceil( $total_members / $members_per_page )),

	'L_GOTO_PAGE' => $lang['Goto_page'])
);

if (THEME_USES_TPL) {
	$template->set_filenames(array('body' => 'memberslist.html'));
	$template->display('body');
} else {
	$template->pparse('body');
}

CloseTable();
require_once('footer.php');

/modules/forum/templates/subSilver/memberlist.tpl

Array:

<div class="legend">{PAGE_TITLE}</div>
<form method="post" action="{S_MODE_ACTION}" {I18N}>
  <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
    <tr>
      <td align="right" nowrap="nowrap"><span class="genmed">{L_SELECT_SORT_METHOD}: {S_MODE_SELECT}  {L_ORDER} {S_ORDER_SELECT}  
        <input type="submit" name="submit" value="{L_SUBMIT}" class="liteoption" />
        </span></td>
    </tr>
  </table>
  <table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
    <tr>
      <th height="25" class="thCornerL" nowrap="nowrap">#</th>
      <th class="thTop" nowrap="nowrap">{L_PM};</th>
      <th class="thTop" nowrap="nowrap">{L_USERNAME}</th>
      <th class="thTop" nowrap="nowrap">{L_EMAIL}</th>
      <th class="thTop" nowrap="nowrap">{L_FROM}</th>
      <th class="thTop" nowrap="nowrap">{L_USER_AGE}</th>
      <th class="thTop" nowrap="nowrap">{L_JOINED}</th>
      <th class="thTop" nowrap="nowrap">{L_POSTS}</th>
      <th class="thCornerR" nowrap="nowrap">{L_WEBSITE}</th>
    </tr>
    <!-- BEGIN memberrow -->
    <tr>
      <td class="{memberrow.ROW_CLASS}" align="center"><span class="gen"> {memberrow.ROW_NUMBER} </span></td>
      <td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.PM_IMG} </td>
      <td class="{memberrow.ROW_CLASS}" align="center"><span class="gen"><a href="{memberrow.U_VIEWPROFILE}" class="gen">{memberrow.USERNAME}</a></span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"> {memberrow.EMAIL_IMG} </td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.FROM}</span></td>
     <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.USER_AGE}</span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gensmall">{memberrow.JOINED}</span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.POSTS}</span></td>
      <td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.WWW_IMG} </td>
    </tr>
    <!-- END memberrow -->
    <tr>
      <td class="catbottom" colspan="8" height="28"> </td>
    </tr>
  </table>

<table width="100%" cellspacing="0" cellpadding="0" border="0">
  <tr>
    <td align="left"><span class="nav">{PAGE_NUMBER}</span></td>
    <td align="right"><span class="nav">{PAGINATION}</span></td>
  </tr>
</table></form>

/themes/dragonfly/template/memberslist.html

Array:

<div class="legend">{PAGE_TITLE}</div>
<form method="post" action="{S_MODE_ACTION}" {I18N}>
  <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
    <tr>
      <td align="right" nowrap="nowrap"><span class="genmed">{L_SELECT_SORT_METHOD}: {S_MODE_SELECT}  {L_ORDER} {S_ORDER_SELECT}  
        <input type="submit" name="submit" value="{L_SUBMIT}" class="liteoption" />
        </span></td>
    </tr>
  </table>
  <table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
    <tr>
      <th height="25" class="thCornerL" nowrap="nowrap">#</th>
      <th class="thTop" nowrap="nowrap">{L_PM};</th>
      <th class="thTop" nowrap="nowrap">{L_USERNAME}</th>
      <th class="thTop" nowrap="nowrap">{L_EMAIL}</th>
      <th class="thTop" nowrap="nowrap">{L_FROM}</th>
      <th class="thTop" nowrap="nowrap">{L_USER_AGE}</th>
      <th class="thTop" nowrap="nowrap">{L_JOINED}</th>
      <th class="thTop" nowrap="nowrap">{L_POSTS}</th>
      <th class="thCornerR" nowrap="nowrap">{L_WEBSITE}</th>
    </tr>
    <!-- BEGIN memberrow -->
    <tr>
      <td class="{memberrow.ROW_CLASS}" align="center"><span class="gen"> {memberrow.ROW_NUMBER} </span></td>
      <td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.PM_IMG} </td>
      <td class="{memberrow.ROW_CLASS}" align="center"><span class="gen"><a href="{memberrow.U_VIEWPROFILE}" class="gen">{memberrow.USERNAME}</a></span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"> {memberrow.EMAIL_IMG} </td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.FROM}</span></td>
     <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.USER_AGE}</span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gensmall">{memberrow.JOINED}</span></td>
      <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.POSTS}</span></td>
      <td class="{memberrow.ROW_CLASS}" align="center"> {memberrow.WWW_IMG} </td>
    </tr>
    <!-- END memberrow -->
    <tr>
      <td class="catbottom" colspan="8" height="28"> </td>
    </tr>
  </table>

<table width="100%" cellspacing="0" cellpadding="0" border="0">
  <tr>
    <td align="left"><span class="nav">{PAGE_NUMBER}</span></td>
    <td align="right"><span class="nav">{PAGINATION}</span></td>
  </tr>
</table></form>

so für mich gibts jetzt 2 fragen hab ich irgendeine datei vergessen anzupassen und wo werden die sprachdateien definiert
mfg
lexi

Ertan · Dabei seit: Mar 19, 2004 Beiträge: 1247 Wohnort: Germany

demo link ?