Members List

[ammar]

YaBB SE Version: 1.5.5

Problem Description:
How should I set to my YaBB SE forum's members list to be in order? That is according to who registered first will be at the top and the newest members will be at the bottom? How should I set this?

[oldiesmann]

Do this so it will automatically sort them this way by default:

Open memberlist.php
Search for:

Code Select Expand

   $query = "SELECT memberName,realName,websiteTitle,websiteUrl,posts,memberGroup,ICQ,AIM,YIM,MSN,emailAddress,hideEmail,ID_MEMBER FROM {$db_prefix}members WHERE 1 LIMIT $start,$MembersPerPage";

Replace with:

Code Select Expand

   $query = "SELECT memberName,realName,websiteTitle,websiteUrl,posts,memberGroup,ICQ,AIM,YIM,MSN,emailAddress,hideEmail,ID_MEMBER FROM {$db_prefix}members WHERE 1 LIMIT $start,$MembersPerPage ORDER BY ID_MEMBER ASC";

That will order them by the internal member ID. Hope that helps.

[ammar]

The code you gave me earlier doesn't work. Insteed my Members List page appears in error. Can someone give me the correct code?

[homie]

You might have typed code in wrong becasue that guy knows what hes doing