Problem with group pagination count when users are excluded

[sbrajesh]

There is a problem with group pagination when some users are excluded using the exclude parameter in the bp_group_has_members(inside bp-default/groups/single/members.php)
It shows this message

`
Viewing member 1 to 0 (of 0 members)
`

The problem lies in Bp_Groups_Members::get_all_for_group method on line 1197.

The members table name is not aliased in the FROM clause but the alias m is used in the $exclude_sql.

Here is a patch attached again the BuddyPress 1.6 trunk. Need to check if we have same issue(might be) in 1.7 trunk too.

[sbrajesh]

patch for fixing the total members count of group when user is excluded

[johnjamesjacoby]

(In [6626]) Fix broken queries in bp-groups-classes.php.

• Fixes misspelled variables.
• Adds missing table alias. (props sbrajesh)
• Some code clean-up.
• Fixes #4711.