[MOD] Hide Admin/Moderator Accounts from People Page

[videosforkids]

This question was asked in the Support board and I was glad to see it, because I had not thought of this before but it's a nice little mod to hide the admin account from the main member list on the People page.

Easy mod but backup people.php just in case.

Open people.php

Find:

Code: [Select]

//query for all members
$sqlquery = "SELECT * FROM member_profile WHERE account_status = 'active' ORDER BY user_id DESC";

Change to:

Code: [Select]

//query for all members
$sqlquery = "SELECT * FROM member_profile WHERE account_status = 'active' AND user_group = 'member' ORDER BY user_id DESC";


[chejugu]

hi, nice trick!!
my people.php file looks like this:
<sup>include_once ('classes/config.php');

include_once ('classes/sessions.php');



// this is per template from config.inc.php advanced config settings

$page_display_small_width   = $config['general_medium_thumb_width'];

$page_title            = $lang_browse_members . ' ' . $lang_on .  ' ' . $site_name;

$submitted             = $_POST['submitted'];

$limit             = 20;



$sql                = "SELECT user_id FROM member_profile";

$members_total          = number_format( @mysql_num_rows( mysql_query( $sql ) ) );



$which_one            = mysql_real_escape_string($_GET['load']);





//CHECK IF FORM SUBMITTED

if ($_POST['submitted'] == 'yes') {



   //check for search fields and buld sql query

       if ($_POST['firstname'] != "") {

          $query_1 = " AND first_name = '" . mysql_real_escape_string($_POST['firstname']) ."' ";

       }



       if ($_POST['surname'] != "") {

         $query_2 = "AND last_name = '" . mysql_real_escape_string($_POST['surname']) ."' ";

       }



       if ($_POST['username'] != "") {

         $query_3 = "AND user_name = '" . mysql_real_escape_string($_POST['username']) ."' ";

       }



       if ($_POST['home_country'] != "") {

         $query_4 = "AND current_country = '" . mysql_real_escape_string($_POST['home_country']) ."' ";

       }



   $sqlquery = "SELECT * FROM member_profile WHERE account_status ='active'" . $query_1 . $query_2 . $query_3 . $query_4;</sup>


wich query needs to be changed?
Thanx

[xtjoeywx]

I'm trying to do the same thing but my people.php looks like chejugu's too. What do we change to make this work?

[epinett]

I'm trying to do the same thing but my people.php looks like chejugu's too. What do we change to make this work?

change this:  $sqlquery = "SELECT * FROM member_profile WHERE account_status ='active'" . $query_1 . $query_2 . $query_3 . $query_4;


to:

 $sqlquery = "SELECT * FROM member_profile WHERE account_status ='active' AND user_group = 'member' " . $query_1 . $query_2 . $query_3 . $query_4;

[xtjoeywx]

@sol5m

I changed this:

$sqlquery = "SELECT * FROM member_profile WHERE account_status ='active'" . $query_1 . $query_2 . $query_3 . $query_4;

To this:

 $sqlquery = "SELECT * FROM member_profile WHERE account_status ='active' AND user_group = 'member' " . $query_1 . $query_2 . $query_3 . $query_4;


Like you said.. But my admin account still shows up on the people page. Please go to www.weeklyfame.com/people to see what I mean. My admin account is called weeklyfa.

Did I do something wrong or did I not do enough?

Thanks!

[chejugu]

it didn't work for me either! 

[keyshawn]

This mod works your just not going down far enough. Look for //Show all members then under that you will see //query for all members. Only difference is instead of DESC it has ASC.

Is there anyway to just hide the admin profile and not the mods? That is what I need.

[sbcjr]

This mod works your just not going down far enough. Look for //Show all members then under that you will see //query for all members. Only difference is instead of DESC it has ASC.

Is there anyway to just hide the admin profile and not the mods? That is what I need.

You could use something like: AND user_group != 'admin'

[keyshawn]

You could use something like: AND user_group != 'admin'

Thanks that worked perfectly

[pakmotion]

Very nice mod Thanks for sharing

[pakmotion]

This mod works your just not going down far enough. Look for //Show all members then under that you will see //query for all members. Only difference is instead of DESC it has ASC.

Is there anyway to just hide the admin profile and not the mods? That is what I need.

You could use something like: AND user_group != 'admin'

Its not works for me i change that ASC into DESC and my admin account went at the end of member list mean its still shows and if i use ASC then the result is that my admin account came at 1st postion
and i'm useing this method

Code: [Select]

$sqlquery = "SELECT * FROM member_profile WHERE account_status ='active'AND user_group = 'member'" . $query_1 . $query_2 . $query_3 . $query_4;

[pakmotion]

This mod works your just not going down far enough. Look for //Show all members then under that you will see //query for all members. Only difference is instead of DESC it has ASC.

Is there anyway to just hide the admin profile and not the mods? That is what I need.

You could use something like: AND user_group != 'admin'

Its not works for me i change that ASC into DESC and my admin account went at the end of member list mean its still shows and if i use ASC then the result is that my admin account came at 1st postion
and i'm useing this method

Code: [Select]

$sqlquery = "SELECT * FROM member_profile WHERE account_status ='active'AND user_group = 'member'" . $query_1 . $query_2 . $query_3 . $query_4;

Got it work change line

Code: [Select]

$sqlquery = 'SELECT * FROM member_profile ORDER BY user_id ASC';into  this

Code: [Select]

$sqlquery = "SELECT * FROM member_profile WHERE account_status = 'active' AND user_group = 'member' ORDER BY user_id ASC";and now i want to know if there is anyway that only admin can see evry member