With unconfirmed emails
With unapproved
![](\"./images/desc_order.gif\")
";
}
else
{
$sorttype = "ASC";
$sortor_image = "![](\"./images/asc_order.gif\")
";
}
}
setcookie( "sorttype", $sorttype );
/* the check for member status
* in case we have the full member list without any statuses we set it to nothing
* in other case we add another option to the query
* $inc_profiles - variable returning the incoming parameter for profile status
*/
if ( $profiles != "" )
{
$inc_profiles = "profiles=$profiles&";
}
else
{
$inc_profiles = "";
}
$n_arr = db_arr( 'SELECT COUNT(*) FROM `Profiles`' . " WHERE {$sqlCouple}" );
$status_arr[0] = "Active";
$status_arr[1] = "Approval";
$status_arr[2] = "Unconfirmed";
$status_arr[3] = "Rejected";
$status_arr[4] = "Suspended";
if (getParam("free_mode") != 'on') {
$sMemField = ", `IDLevel`, IF(ISNULL(`MemLevels`.`Name`),'', `MemLevels`.`Name`) AS `MemName`";
$sMemJoin = "LEFT JOIN `ProfileMemLevels` ON `ProfileMemLevels`.`IDMember` = `Profiles`.`ID`
LEFT JOIN `MemLevels` ON `ProfileMemLevels`.`IDLevel` = `MemLevels`.`ID` ";
$sMemLevelShow = 'style="display:block;"';
$sGroup = "GROUP BY `Profiles`.`ID`";
}
else
$sMemLevelShow = 'style="display:none;"';
$sQuery = "
SELECT
`Profiles`.`ID` as `ID`,
`NickName`,
`Email`,
`Sex`,
DATE_FORMAT(`DateLastLogin`, '$date_format' ) AS `DateLastLoginCur`,
DATE_FORMAT(`DateReg`, '$date_format' ) AS `DateReg`,
`Status`
$sMemField
FROM `Profiles`
$aff_part_f
$sqlJoinPart
$sMemJoin
WHERE
1 $email_part $aff_part_w $prof_part $sex_part $sqlWhere
$sqlGroup
$sGroup
ORDER BY $sortor $sorttype
LIMIT $real_first_p, $p_per_page
";
$result = db_res($sQuery);
$_page['header'] = "Members' Profiles";
$_page['header_text'] = "Members profiles sorted by modification date";
$_page['js'] = 1;
TopCodeAdmin();
ContentBlockHead("Total registered members");
?>
'Active' AND {$sqlCouple}";
$iK++;
$sCapt = 'Inactive';
} else
continue;
}
$n_arr = db_arr( "SELECT COUNT(*) FROM `Profiles` WHERE $sAdd" );
if ( $n_arr[0] ) {
?>
$sVal)
{
$sqlUnp = "SELECT * FROM `media` WHERE `med_status` = 'passive' AND `med_type`= '$sVal' GROUP BY `med_prof_id`";
$rUnp = db_res($sqlUnp);
if ($rUnp && mysql_num_rows($rUnp))
{
?>
| Total registered members: | |
|
|
|
|
With unconfirmed emails
|
|
|
With unapproved
|
| Add a new profile |