Re: [Savannah-hackers] Re: Active pending users?

[Sylvain Beucler]

On Wed, Oct 20, 2004 at 11:21:16PM +0200, Mathieu Roy wrote:
> Sylvain Beucler <address@hidden> tapota :
> 
> > Hmm, at least I get the time to work on this issue:
> >
> > On Fri, Oct 01, 2004 at 01:31:33PM +0200, Mathieu Roy wrote:
> >> Sylvain Beucler <address@hidden> tapota :
> >> 
> >> > Hi,
> >> >
> >> > In our database at savannah, there are about ten users who are both
> >> > pending and member of a project. They have no registered SSH keys and
> >> > thus are quite useless. For example, user 'sevy'.
> >> >
> >> > Do you know how such accounts could have been created?
> >> 
> >> No clue.
> >> 
> >> How old are these accounts?
> >
> > It ranges from Wed Nov 14 20:39:07 2001 to Tue Nov 25 12:41:45 2003.
> >
> >> Who added these users to projets (should be
> >> printed in these projects history)? Was it a site admin or a project
> >> admin?
> >
> > Project admins.
> >
> > However, I tried to add a pending user myself, and the system did not
> > returned it in the "Adding User(s) to Group" search box. Maybe this
> > situation is checked since when you installed Savannah?
> 
> The search is made only of users that are not already member of a
> group.

?

Here's the query (useradmin.php):

$result = db_query("SELECT user_id, user_name, realname "
                   . "FROM user "
                   . "WHERE ((user_name LIKE '%$words1%') OR (realname LIKE 
'%$words2%'))
                        AND (status='A') ORDER BY user_name LIMIT 0,26");

Since this script only exists since the CERN branch from 2003/09, I
guess there was a bug in the previous member management code...

-- 
Sylvain