0 )
{
$aff_part_w = " AND idAff = $showAffMembers AND idProfile = ID";
$aff_part_f = ",aff_members ";
}
switch( $profiles )
{
case 'Unconfirmed':
case 'Approval':
case 'Active':
case 'Rejected':
case 'Suspended':
$prof_part = "AND Status = '$profiles'";
break;
default:
$prof_part = '';
}
if ( strlen($sex) )
$sex_part = "AND Sex = '" . process_db_input($sex, 1) . "'";
else
$sex_part = '';
if (strlen($search))
{
if ($_GET[s_mail])
$email_part = " AND `Email` LIKE '%$search%' ";
elseif ($_GET[s_nickname])
$email_part = " AND `NickName` LIKE '%$search%' ";
elseif ($_GET[s_id])
$email_part = " AND `ID` = '$search' ";
}
// ------------------------------
$sql = "SELECT COUNT(*) FROM Profiles $aff_part_f WHERE 1 $email_part $aff_part_w $prof_part $sex_part";
$p_num = db_arr( $sql );
$p_num = $p_num[0];
$pages_num = ceil( $p_num / $p_per_page );
$real_first_p = (int)($page - 1) * $p_per_page;
$page_first_p = $real_first_p + 1;
$result = db_res( "
SELECT
`Profiles`.*,
DATE_FORMAT(`DateLastLogin`, '$date_format' ) AS `DateLastLogin`
FROM `Profiles`
$aff_part_f
WHERE
1
$email_part
$aff_part_w
$prof_part
$sex_part
ORDER BY `DateLastEdit` DESC
LIMIT $real_first_p, $p_per_page
" );
$page_p_num = mysql_num_rows( $result );
$_page['header'] = "Members' Profiles";
$_page['header_text'] = "Members profiles sorted by modification date";
$_page['js'] = 1;
TopCodeAdmin();
ContentBlockHead("Profiles");
?>
| Status of profile |
| |
Unconfirmed |
| |
Approval |
| |
Active |
| |
Rejected |
| |
Suspended |