Memberlist Membergroups only

[Valconeye]

have like action=mlgroup1 where group1 is a membergroup. and it would list only them members in that current membergroup.

[Shadow's Pawn]

This would be really easy.. in fact, you can just copy the old MLMemgrp function and then edit the query info to add WHERE memberGroup = "whatever membergroup" as a condition for what members it should list..

I'm not sure right off hand without looking at memberlist.php but there are probably only a couple queries in that to edit.  Then just rename the new function to something like MLMemgrp1 and add it to the links.

I can probably post some code if you need it.

[Valconeye]

if you could post some code that would be great! im not that good with php, but ill take a look at it and see what i come up with, and post what i get done, then we can compare.

[Valconeye]

i was thinking of instead of having to edt the memberlist.php everytime i want to add a new membergroup, have something like action=mlmemgrp&<? $grp ?> where $grp = membergroupname , i hope i can figure this out

[Shadow's Pawn]

I'll post some later tonight when I get home from work.

If you do follow my suggestion, just make sure you add the new function to index.php.. somewhere around this area

Code Select Expand


      'mlall' => array("$sourcedir/Memberlist.php", 'MLAll'),
      'mlmemgrp' => array("$sourcedir/Memberlist.php", 'MLMemgrp'),

or it won't work.

[Valconeye]

i added WHERE memberGroup = '$grp'") but i can get it to work, and the command mlgrp&grp=<$grp?> (lol no clue if this is right) yeah im bad at php

[Valconeye]

any luck? i have had none  

[Shadow's Pawn]

Sorry, I've been busy.  What are the member group names that you want to display?  Anyway, here is a really quick way to do it, simply by copying the mlmgrp function.  Keep in mind that this is just quick and dirty.  All I did was insert a few things in a few spots to make it search for Administrators instead of all memberGroups.  Insert whatever membergroup you want to use where it says Administrator.

This is in Memberlist.php

Code Select Expand



function MLMemgrp1 ()
{
   global $user, $txt, $start, $MembersPerPage, $settings, $allow_hide_email, $color, $TableHeader, $MOST_POSTS;
   global $imagesdir, $cgi, $TableFooter, $db_prefix;
   global $NUM_MEMBERS, $yytitle;

   if ($MOST_POSTS == 0)
      $MOST_POSTS = 1;

   if ($user == 'Guest')
      fatal_error($txt[223]);

   // Get the number of members
   $result = mysql_query ("SELECT COUNT(*) FROM {$db_prefix}members WHERE memberGroup = 'Administrator'") or database_error(__FILE__, __LINE__);
   $row = mysql_fetch_row($result);
   $memcount = $row[0];
   
   if ($start == '')
      $start = 0;

   $numbegin = $start + 1;
   $numend = ($start + $MembersPerPage);
   if ($numend > $memcount)
      $numend = $memcount;

   $yytitle = "$txt[308] $numbegin $txt[311] $numend";
   template_header();

   echo '
      <table border="0" cellspacing="0" cellpadding="3" align="center" width="100%">
         <tr>
            <td bgcolor="' . $color['titlebg'] . '" align="center" class="titlebg">
               <font size="2" class="text1" color="' . $color['titletext'] . '"><b>' . $txt[308] . ' ' . $numbegin . ' ' . $txt[311] . ' ' . $numend . ' (' . $txt[309] . ' ' . $NUM_MEMBERS . ' ' . $txt[310] . ')</b></font>
            </td>
         </tr>
      </table>';

   echo $TableHeader;

   $membergroup = $row['memberGroup'];
   $mg_request = mysql_query("SELECT membergroup FROM {$db_prefix}membergroups ORDER BY ID_GROUP") or database_error(__FILE__, __LINE__); //query membergroups descriptions
   $membergroups = array();
   while ($mg_row = mysql_fetch_row($mg_request)) //retrieve all membergroups descriptions
      $membergroups[] = $mg_row[0];

   $query = "
      SELECT memberName,realName,websiteTitle,websiteUrl,posts,IF(memberGroup='Administrator','$membergroups[0]',IF(memberGroup='Global Moderator','$membergroups[7]',memberGroup)) AS theMemberGroup,ICQ,YIM,AIM,MSN,emailAddress,hideEmail,IF(memberGroup<>'',1,0) AS belongsToMembergroup, ID_MEMBER
      FROM {$db_prefix}members
      WHERE memberGroup='Administrator'
      ORDER by realName";
   printMemberListRows($query, true);

   echo $TableFooter;

   echo '
      <table border="0" width="100%" cellpadding="0" cellspacing="0">
         <tr>
            <td>
               <font size="2">
                  <b>' . $txt[139] . ':</b>';
   $c = 0;
   while (($c*$MembersPerPage) < $NUM_MEMBERS)
   {
      $viewc = $c + 1;
      $strt = $c * $MembersPerPage;
      if ($start == $strt)
         echo " $viewc";
      else
         echo " <a href=\"$cgi;action=mlmemgrp1;start=$strt\">$viewc</a>";
      $c++;
   }
   echo '
               </font>
            </td>
         </tr>
      </table>';

   footer();
   obExit();
}


Then in index.php look for

Code Select Expand


      'mlmemgrp' => array("$sourcedir/Memberlist.php", 'MLMemgrp'),


and add this afterwards

Code Select Expand


      'mlmemgrp1' => array("$sourcedir/Memberlist.php", 'MLMemgrp1'),


Then, going back to Memberlist.php, if you want to add the link to this in the memberlist, you need to find

Code Select Expand


if ($action == 'mlmemgrp')
   $Sort .= "$txt[yse288] | ";
else
   $Sort .= "<a href=\"$cgi;action=mlmemgrp\"><font size=\"2\" class=\"text1\" color=\"$color[titletext]\">$txt[yse288]</font></a> | ";


add this right after that

Code Select Expand


if ($action == 'mlmemgrp')
   $Sort .= "$txt[yse288] | ";
else
   $Sort .= "<a href=\"$cgi;action=mlmemgrp1\"><font size=\"2\" class=\"text1\" color=\"$color[titletext]\">$txt[yse288]</font></a> | ";


Keep in mind that in that last block of code, you will need to change the $txt[yse288] to something else, because you are going to need to go into english.lng and add in a new $txt to read 'Display Membergroup' where membergroup is whatever membergroup you are making the function display.

Also, if you look over what changes I made to mlmgrp, you'll see how to add this function for other membergroups.

Hope that helps.

[Valconeye]

yeah it works, although is there anyway to make that Administrator be a typed in value, cause i do have alot of membergroups.

[Metho]

Yeah. You'd just have your input box name="requestgroup" value="' . $requestgroup .'" and in those where statements (i.e. WHERE memberGroup = 'Administrator'") you'd have it WHERE memberGroup = $requestgroup. Also would have to global $requestgroup...and probably mess around a bit more. I only looked at the code for 2 seconds or so.

Methonis