Sortierungs-Methode der Mitgliederliste

[Ralf S]

hallo,

eine frage habe zwar schon gesucht aber nichts passendes gefunden.

wie kann ich in der Sortierungs-Methode noch andere kriterien einbauen.
weil ich den gender mod drin habe und noch ein extra feld wo angezeigt wird wer ein profilbild hat (usercar mod).
würde gerne dann nach gender und wer hat alles ein profilbild suchen bzw auflisten lassen.

den normal ist ja anmededatum,benutzername,ort,email,webseite,top ten,beiträge total.

gibt es einen mod mit dem man das ändern bzw erweitern kann. oder wo muß man was rein schreiben.

gruß ralf

[Kortirion]

Der Suche schließe ich mich mal an, ich habe zusätzlich noch das Feld "letzter Besuch" in der Mitgliederliste und würde gerne auch danach sortieren lassen.

Gruß...

[Firestarter]

Code: Alles auswählen

###############################################
##	Hack Title:		Sort memberlist per letter
##	Hack Version:	1.0.1
##	Author:			Freakin' Booty ;-P
##	Website:		http://www.freakingbooty.tk
##	Description:	This enables people to search for users that have their name starting
##					with a specific letter. You can also choose "others" (meaning non-alpha
##					characters), and "all" (the regular list).
##	Compatibility:	2.0.3 - 2.0.6
##
##	Installation Level: Easy
##	Installation Time: 4 - 5 minutes
##	Files To Edit: 3
##		memberlist.php
##		language/lang_english/lang_main.php
##		templates/SubSliver/memberlist_body.tpl
##
##	Included Files: 0
##
##	History:
##		1.0.0:	Initial release
##		1.0.1:	Hack tested and confirmed to work on 2.0.4 - 2.0.6 aswell.
##				Added an HTML space so that the spacing is preserved at all times.
##
##	Author Notes:
##		None
##
##	Support:		http://www.phpbbhacks.com/forums
##	Copyright:		©2003 Sort memberlist per letter 1.0.1 - Freakin' Booty ;-P
##
###############################################
##   You downloaded this hack from phpBBHacks.com, the #1 source for phpBB related downloads.
##   Please visit http://www.phpbbhacks.com/forums for support.
###############################################
##
###############################################
##	This hack is released under the GPL License.
##	This hack can be freely used, but not distributed, without permission.
##	Intellectual Property is retained by the hack author(s) listed above.
###############################################

#
#-----[ OPEN ]--------------------------------------------
#
memberlist.php

#
#-----[ FIND ]--------------------------------------------
#
//
// End session management
//

#
#-----[ AFTER, ADD ]--------------------------------------
#
if(isset($HTTP_POST_VARS['letter']))
{
	$by_letter = ($HTTP_POST_VARS['letter']) ? $HTTP_POST_VARS['letter'] : 'all';
}
else if(isset($HTTP_GET_VARS['letter']))
{
	$by_letter = ($HTTP_GET_VARS['letter']) ? $HTTP_GET_VARS['letter'] : 'all';
}

#
#-----[ FIND ]--------------------------------------------
#
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar

#
#-----[ BEFORE, ADD ]-------------------------------------
#
//
// Set per-letter selection
//
$others_sql = '';
$select_letter = '';
for ($i = 97; $i <= 122; $i++)
{
	$others_sql .= " AND username NOT LIKE '" . chr($i) . "%' ";
	$select_letter .= ( $by_letter == chr($i) ) ? chr($i) . '&nbsp;' : '<a href="' . append_sid("memberlist.$phpEx?letter=" . chr($i) . "&mode=$mode&order=$sort_order&start=$start") . '">' . chr($i) . '</a>&nbsp;';
}
$select_letter .= ( $by_letter == 'others' ) ? $lang['Others'] . '&nbsp;' : '<a href="' . append_sid("memberlist.$phpEx?letter=others&mode=$mode&order=$sort_order&start=$start") . '">' . $lang['Others'] . '</a>&nbsp;';
$select_letter .= ( $by_letter == 'all' ) ? $lang['All'] : '<a href="' . append_sid("memberlist.$phpEx?letter=all&mode=$mode&order=$sort_order&start=$start") . '">' . $lang['All'] . '</a>';

$template->assign_vars(array(
	'L_SORT_PER_LETTER' => $lang['Sort_per_letter'],
	'S_LETTER_SELECT' => $select_letter,
	'S_LETTER_HIDDEN' => '<input type="hidden" name="letter" value="' . $by_letter . '">')
);

if($by_letter == 'all')
{
	$letter_sql = '';
}
else if($by_letter == 'others')
{
	$letter_sql = $others_sql;
}
else
{
	$letter_sql = " AND username LIKE '$by_letter%' ";
}

#
#-----[ FIND ]--------------------------------------------
#
	WHERE user_id <> " . ANONYMOUS . "
	ORDER BY $order_by";

#
#-----[ REPLACE WITH ]------------------------------------
#
	WHERE user_id <> " . ANONYMOUS . "$letter_sql
	ORDER BY $order_by";

#
#-----[ FIND ]--------------------------------------------
#
	$sql = "SELECT count(*) AS total
		FROM " . USERS_TABLE . "
		WHERE user_id <> " . ANONYMOUS;

#
#-----[ REPLACE WITH ]------------------------------------
#
	$sql = "SELECT count(*) AS total
		FROM " . USERS_TABLE . "
		WHERE user_id <> " . ANONYMOUS . $letter_sql;

#
#-----[ FIND ]--------------------------------------------
#
		$pagination = generate_pagination("memberlist.$phpEx?mode=$mode&order=$sort_order", $total_members, $board_config['topics_per_page'], $start). '&nbsp;';

#
#-----[ INLINE, FIND ]-------------------------------------
#
&order=$sort_order

#
#-----[ AFTER, ADD ]--------------------------------------
#
# this is before the quote!
#
&letter=$by_letter

#
#-----[ OPEN ]--------------------------------------------
#
# make sure to edit this file for every language installed
#
language/lang_english/lang_main.php

#
#-----[ FIND ]--------------------------------------------
#
//
// That's all, Folks!
// -------------------------------------------------

#
#-----[ BEFORE, ADD ]-------------------------------------
#
//
// Sort memberlist per letter
//
$lang['Sort_per_letter'] = 'Show only usernames starting with';
$lang['Others'] = 'others';
$lang['All'] = 'all';

#
#-----[ OPEN]--------------------------------------------
#
# make sure to edit this file for every template installed
#
templates/subSilver/memberlist_body.tpl

#
#-----[ FIND ]--------------------------------------------
#
		<input type="submit" name="submit" value="{L_SUBMIT}" class="liteoption" />
		</span></td>
	</tr>

#
#-----[ AFTER, ADD ]--------------------------------------
#
	<tr>
	  <td colspan="2" align="right" nowrap="nowrap"><span class="genmed">{L_SORT_PER_LETTER}:&nbsp;{S_LETTER_SELECT}{S_LETTER_HIDDEN}</span></td>
	</tr>

#
#-----[ SAVE & CLOSE ALL FILES ]--------------------------

oder dies

Code: Alles auswählen

## EasyMod 0.0.10a compliant
#################################################################
## MOD Title: 		Filter member list
## MOD Author: 		Shannado <sven@shannado.nl> (Sven) http://www.shannado.nl/forumorg
## MOD Description: With this MOD an user is able to filter the memberslist.
## MOD Version: 	1.0.8
##
##
## Installation Level: 	Easy
## Installation Time: 	10 - 20 Minutes
## Files To Edit: 		memberlist.php,
##						lang_main.php,
##						memberlist_body.tpl
## Included Files: N/A
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/
##############################################################
## Author Notes:
##
##############################################################
##
##	When you don't like the extra selectbox AND you don't mind that user only can filter on 'Username'
##	Then you don't put '{L_MEMBERLIST_FILTER_SEL}&nbsp;{S_FILTER_SELECT}&nbsp;' in the memberlist_body.tpl
##	By default the MOD filters on Username.
##	Change  $lang['Memberlist_filter'] = "keyword (wildcards allowed) "; into
##		$lang['Memberlist_filter'] = "username (wildcards allowed) ";
##
##	An user is able to filter on email, but if a user has set his email on hidden, then the user
##	will not show up in the list, if the filter matches the criteria. This does not concern if the user is an ADMIN
##
##############################################################
## MOD History:
##
## ------------
## 01-01-2002 - 0.9.0 beta
##	- Beta
##
## 01-01-2002 - 0.9.1 beta
##	- The pagination will not take into account the filter used,
##	  and as a result the pagination will be created based on the total members.
##	  Thanks goto JamesB for finding the bug and making the solution for this bug
##
## 01-01-2002 - 0.9.5 beta
##	- Text stays in the textarea when you hit the sort button or clicking for the next page
##	- User is able to filter on Username, location, email OR website
##
## 01-01-2002 - 0.9.6 beta
##	- When nothing matches the critera a message will be show
##
## 01-01-2002 - 0.9.7 beta
##	- Forgot to change some code in the HOWTO
##
## 01-01-2002 - 1.0.0 FINAL
##	- Final
##	- No changes
##
## 01-01-2002 - 1.0.1 FINAL
##	- Some minor code cosmetic updates
##
## 01-01-2002 - 1.0.2 FINAL
##	- Add rank to the filter
##
## 01-01-2002 - 1.0.3 FINAL
##	- Fixed small typos
##
## 01-01-2002 - 1.0.4 FINAL
##	- Fixed small typos
##
## 01-01-2002 - 1.0.5 FINAL
##	- Fixed small typos
##
## 01-01-2002 - 1.0.6 FINAL
##	- Made phpBB v2.0.2 complaint and EasyMod 0.0.7 complaint
##
## 01-01-2002 - 1.0.7 FINAL
##	- Made phpBB v2.0.4 complaint and fixed a small bug
##
## 05-12-2003 - 1.0.8 FINAL
##	- Made phpBB v2.0.6 complaint and EasyMod 0.0.10a complaint
##	- Adjusted to the new Template
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
#################################################################
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all, Folks!


#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Filter memberslist MOD
$lang['Memberlist_filter'] = 'keyword (wildcards allowed) ';
$lang['Memberlist_filter_sel'] = 'Choose filter: ';
$lang['Click_return_memberlist'] = 'Click %sHere%s to return to the memberlist';

#
#-----[ OPEN ]------------------------------------------
#
memberlist.php

#
#-----[ FIND ]------------------------------------------
#
//
// Memberlist sorting
//

#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Filter Memberlist MOD - BEGIN
//

$filter_mode_types_text = array($lang['Sort_Username'], $lang['Sort_Location'], $lang['Sort_Email'],  $lang['Sort_Website'], $lang['Poster_rank']);
$filter_mode_types = array('username', 'location', 'email', 'website', 'rank');

$select_filter_mode = '<select name="filter_mode">';
for($i = 0; $i < count($filter_mode_types_text); $i++)
{
	$selected = ( $filter_mode == $filter_mode_types[$i] ) ? ' selected="selected"' : '';
	$select_filter_mode .= "<option value=\"" . $filter_mode_types[$i] . "\"$selected>" . $filter_mode_types_text[$i] . "</option>";
}
$select_filter_mode .= '</select>';

//
// Filter Memberlist MOD - END
//

#
#-----[ FIND ]------------------------------------------
#
//
// Generate page
//

#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Filter Memberlist MOD - BEGIN
//
if ( isset($HTTP_POST_VARS['filter']) || isset($HTTP_GET_VARS['filter']) )
{
	$filter = ( isset($HTTP_POST_VARS['filter']) ) ? $HTTP_POST_VARS['filter'] : $HTTP_GET_VARS['filter'];

	if (empty($filter) )
	{
		$sql_filter = '';
	}
	else
	{
		$username_filter = "*". $filter . "*";
		$username_filter = preg_replace('/\*/', '%', trim(strip_tags($username_filter)));

		if ( isset($HTTP_GET_VARS['filter_mode']) || isset($HTTP_POST_VARS['filter_mode']) )
		{
			$filter_mode = ( isset($HTTP_POST_VARS['filter_mode']) ) ? $HTTP_POST_VARS['filter_mode'] : $HTTP_GET_VARS['filter_mode'];

			switch( $filter_mode )
			{

				case 'username':
					$sql_filter = " AND username LIKE '" . str_replace("\'", "''", $username_filter) . "'";
					break;
				case 'location':
					$sql_filter = " AND user_from LIKE '" . str_replace("\'", "''", $username_filter) . "'";
					break;
				case 'email':
					if ($userdata['user_level'] == ADMIN )
					{
						$sql_filter = " AND user_email LIKE '" . str_replace("\'", "''", $username_filter) . "'";
					}
					else
					{
						$sql_filter = " AND user_viewemail != '0' AND user_email LIKE '" . str_replace("\'", "''", $username_filter) . "'";
					}
					break;
				case 'website':
					$sql_filter = " AND user_website LIKE '" . str_replace("\'", "''", $username_filter) . "'";
					break;
				case 'rank':
					$sql_filter = " AND r.rank_title LIKE '" . str_replace("\'", "''", $username_filter) . "'";
					break;
				default:
					$sql_filter = " AND username LIKE '" . str_replace("\'", "''", $username_filter) . "'";
					break;
			}
		}
		else
		{
			$sql_filter = " AND username LIKE '" . str_replace("\'", "''", $username_filter) . "'";
		}

	}
}
else
{
	$sql_filter = '';
}

//
// Filter Memberlist MOD - END
//

#
#-----[ FIND ]------------------------------------------
#
	'L_POSTS' => $lang['Posts'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
	'FILTER' => $filter,
	'L_MEMBERLIST_FILTER' => $lang['Memberlist_filter'],
	'L_MEMBERLIST_FILTER_SEL' => $lang['Memberlist_filter_sel'],
	'S_FILTER_SELECT' => $select_filter_mode,

#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT username

#
#-----[ IN-LINE FIND ]------------------------------------------
#
, user_allowavatar

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, r.rank_title


#
#-----[ FIND ]------------------------------------------
#
	FROM " . USERS_TABLE . "
	WHERE user_id <> " . ANONYMOUS . "

#
#-----[ IN-LINE FIND ]------------------------------------------
#
	USERS_TABLE . "

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
 LEFT JOIN " . RANKS_TABLE . " r ON r.rank_id = user_rank

#
#-----[ IN-LINE FIND ]------------------------------------------
#
<> " . ANONYMOUS . "

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
 $sql_filter


#
#-----[ FIND ]------------------------------------------
#
	while ( $row = $db->sql_fetchrow($result) );
}


#
#-----[ AFTER, ADD ]------------------------------------------
#
else
{
	$message = $lang['No_match'] . '<br /><br />' . sprintf($lang['Click_return_memberlist'], '<a href="' . append_sid('memberlist.'.$phpEx) . '">', '</a>' );
	message_die(GENERAL_MESSAGE, $message);
}


#
#-----[ FIND ]------------------------------------------
#
		FROM " . USERS_TABLE . "
		WHERE user_id <> " . ANONYMOUS;

#
#-----[ REPLACE WITH ]------------------------------------------
#
		FROM " . USERS_TABLE . " LEFT JOIN " . RANKS_TABLE . " r
		ON r.rank_id = user_rank
		WHERE user_id <> " . ANONYMOUS . " $sql_filter";

#
#-----[ FIND ]------------------------------------------
#
	$pagination = generate_pagination("memberlist.$phpEx?mode=$mode&order=$sort_order", $total_members, $board_config['topics_per_page'], $start). '&nbsp;';


#
#-----[ IN-LINE FIND ]------------------------------------------
#
	memberlist.$phpEx?mode=$mode&order=$sort_order

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
	&filter=$filter&filter_mode=$filter_mode

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/memberlist_body.tpl

#
#-----[ FIND ]------------------------------------------
#
<form method="post" action="{S_MODE_ACTION}">
  <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
	<tr>
	  <td align="left"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
	  <td align="right" nowrap="nowrap"><span class="genmed">{L_SELECT_SORT_METHOD}:&nbsp;{S_MODE_SELECT}&nbsp;&nbsp;{L_ORDER}&nbsp;{S_ORDER_SELECT}&nbsp;&nbsp;
		<input type="submit" name="submit" value="{L_SUBMIT}" class="liteoption" />
		</span></td>
	</tr>
  </table>

#
#-----[ REPLACE WITH ]------------------------------------------
#
  <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
	<form method="post" action="{S_MODE_ACTION}">
	<tr>
		<td align="right" nowrap="nowrap" colspan="2"><span class="genmed">{L_SELECT_SORT_METHOD}:&nbsp;{S_MODE_SELECT}&nbsp;&nbsp;{L_ORDER}&nbsp;{S_ORDER_SELECT}&nbsp;&nbsp;</span></td>
	</tr>
	<tr>
		<td align="left" valign="bottom"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
		<td align="right" nowrap="nowrap"><span class="genmed">{L_MEMBERLIST_FILTER_SEL}&nbsp;{S_FILTER_SELECT}&nbsp;{L_MEMBERLIST_FILTER}<input type="text" style="width: 150px" name="filter" class="post" size="28" value="{FILTER}" />
		<input type="submit" name="submit" value="{L_SUBMIT}" class="liteoption" />
		</span></td>
	</tr>
	</form>
  </table>

#
#-----[ FIND ]------------------------------------------
#
</table></form>

#
#-----[ REPLACE WITH ]------------------------------------------
#
</table>

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

[Ralf S]

hallo,


habe mal beide mods eingebaut ist aber nicht das was ich brauche.
ich möchte ja nur das ich in der vorhandenen box wo die normalen suchkriterien drin stehen mit zwei sachen erweitern kann.

einmal nach gender suchen also Mann, Fau und nach profil bildern die ich mit dem usercar mod gemacht habe

keine extra felder wie die beiden mods

gruß ralf

[Ralf S]

hallo,

gibt es keine metode direckt nach meinen beiden neuen felder suchen zu lassen

gruß ralf

[makue]

Man müsste in der memberlist.php ab Sektion "// Memberlist sorting" entsprechende Suchkriterien dazubringen. Weiter unten dann bei "switch( $mode )" kann man die Sortierung für die MySQL-Abfrage im String $order_by ergänzen.

[timo111]

ist recht einfach.
am anfang der memberlist.php kommt irgendwo

Code: Alles auswählen

//
// Memberlist sorting
//

schau dir mal den code danach an.. ist eigentlich kein problem

[Leuchte]

Versucht folgendes (jeweils memberlist.php)

Ralf S (Gender Mod):

Code: Alles auswählen

## Suche
$mode_types_text = array($lang['Sort_Joined'], $lang['Sort_Username'], $lang['Sort_Location'], $lang['Sort_Posts'], $lang['Sort_Email'],  $lang['Sort_Website'], $lang['Sort_Top_Ten']);
$mode_types = array('joindate', 'username', 'location', 'posts', 'email', 'website', 'topten');

## Ersetze mit
$mode_types_text = array($lang['Sort_Joined'], $lang['Sort_Username'], $lang['Gender'], $lang['Sort_Location'], $lang['Sort_Posts'], $lang['Sort_Email'],  $lang['Sort_Website'], $lang['Sort_Top_Ten']);
$mode_types = array('joindate', 'username', 'gender', 'location', 'posts', 'email', 'website', 'topten');

## Suche
case 'username': 
      $order_by = "username $sort_order LIMIT $start, " . $board_config['topics_per_page']; 
      break;

## Füge DANACH ein
case 'gender': 
      $order_by = "user_gender $sort_order LIMIT $start, " . $board_config['topics_per_page']; 
      break;

Für das Alter sollte im BirthdayMod eine Datei zu finden sein (Part 6)
Für die Profilfotos ist der Vorgang identisch. Du musst nur Gender mit der Variable vom CarMod tauschen.
-----
Kortirion (Last Visit):

Code: Alles auswählen

## Suche
$mode_types_text = array($lang['Sort_Joined'], $lang['Sort_Username'], $lang['Sort_Location'], $lang['Sort_Posts'], $lang['Sort_Email'],  $lang['Sort_Website'], $lang['Sort_Top_Ten']);
$mode_types = array('joindate', 'username', 'location', 'posts', 'email', 'website', 'topten');

## Ersetze mit
$mode_types_text = array($lang['Last_logon'], $lang['Sort_Joined'], $lang['Sort_Username'], $lang['Sort_Location'], $lang['Sort_Posts'], $lang['Sort_Email'],  $lang['Sort_Website'], $lang['Sort_Top_Ten']);
$mode_types = array('lastlogon', 'joindate', 'username', 'location', 'posts', 'email', 'website', 'topten');

## Suche
case 'joined':
		$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['topics_per_page'];
		break;

## Füge DANACH ein
case 'lastlogon': 
   		$order_by = ($userdata['user_level'] == ADMIN ) ? "user_lastlogon $sort_order LIMIT $start, " . $board_config['topics_per_page'] : "username $sort_order LIMIT $start, " . $board_config['topics_per_page']; 
   		break;

[Ralf S]

hallo leuchte,

das mit dem gender funktioniert einwandfrei, aber das mit den bilder geht nicht.

ich habe ja um in der memberliste anzuzeigen wer ein userbild hat volgendes machen müssen. wen ein user ein profil bild hat dann wird dieses duchr eine kleines gif bild angezeigt in der memberliste. dazu habe ich das ein getragen.
memberlist.php:

Code: Alles auswählen

// Usercars 
      $sql = "SELECT COUNT(*) AS total FROM " . $table_prefix . "usercars WHERE user_id = " . $user_id; 
      if ( !($resultc = $db->sql_query($sql)) ) 
      { 
         message_die(GENERAL_MESSAGE, $lang['L_USERCARS_MOD2'], '', __LINE__, __FILE__, $sql); 
      } 
      $rowc = $db->sql_fetchrow($resultc); 
      if ( $rowc['total'] > '0' ) 
      { 
         $car_img = '<img src="images/dein_bild.gif" border="0"></img>'; 
      } 
      else 
      { 
         $car_img = ''; 
      } 
// End Usercars 

und das:

Code: Alles auswählen

'CAR_IMG' => $car_img, 

memberlist_body.tpl:

Code: Alles auswählen

 {memberrow.CAR_IMG}

so habe ich es geschaft das er mir eine kleines bild hinter dem namen anzeigt soballt der user mindestens 1 bild in seinem profil hat.


nun wie passe ich den dein code an habe es schon mit "car_img" und "L_USERCARS_MOD2" probiert aber nur fehler meldung. was muß ich den einsetzen damit er mir alle auflistet die ein bild haben.

gruß ralf

[Leuchte]

Kannst du mir deine aktuelle memberlist.php verlinken?