Re: patch members.php

[Baris Cicek <baris teamforce name tr>]

No problem. This kind of things are likely to happen, that's why I think
we need to add support for checking duplicates. 

"Never trust user input, even though he's MC member." :)

On Thu, 2007-03-22 at 08:27 +0530, Sankarshan Mukhopadhyay wrote:
> In both the cases I guess I am the $CULPRIT. I recall that the brower
> crashed and instead of checking whether they were already added I
> added them again. Mea Culpa. The one thing I don't understand is that
> the additions should show the same date of 15th rather than 14th, 15th
> and 22nd - why did that not happen ?
>
> Apologies to all and /me makes a note to be careful in future
>
> :Sankarshan
>
> On 3/21/07, Baris Cicek <baris teamforce name tr> wrote:
> > Ditto for Xavier Claessens. Here's dbase query:
> >
> > mysql> SELECT  * FROM `foundationmembers` WHERE firstname='Xavier' AND
> > lastname='Claessens';
> > +-----+-----------+-----------+--------------------+-----------+-------------+-----------------+---------------------+-------------+
> > | id  | firstname | lastname  | email              | comments  |
> > first_added | last_renewed_on | last_update         | resigned_on |
> > +-----+-----------+-----------+--------------------+-----------+-------------+-----------------+---------------------+-------------+
> > | 581 | Xavier    | Claessens | xclaesse gmail.com | RT #2225  |
> > 2007-02-15  | 2007-02-15      | 2007-02-15 00:00:00 | NULL        |
> > | 592 | Xavier    | Claessens | xclaesse gmail.com | RT # 2225 |
> > 2007-02-22  | 2007-02-22      | 2007-02-22 00:00:00 | NULL        |
> > +-----+-----------+-----------+--------------------+-----------+-------------+-----------------+---------------------+-------------+
> >
> >
> >
> > On Wed, 2007-03-21 at 19:49 +0200, Baris Cicek wrote:
> > > It looks like we added Marco twice by mistake. I'm removing latter
> > > record on database. Database query is below;
> > >
> > > This incident shows that we need to put Firstname Lastname check on
> > > mango while adding users.
> > >
> > > Thanks again for letting us know that.
> > >
> > >
> > > mysql> SELECT * FROM `foundationmembers` WHERE firstname='Marco';
> > > +-----+-----------+-----------+---------------------+-----------+-------------+-----------------+---------------------+-------------+
> > > | id  | firstname | lastname  | email               | comments  |
> > > first_added | last_renewed_on | last_update         | resigned_on |
> > > +-----+-----------+-----------+---------------------+-----------+-------------+-----------------+---------------------+-------------+
> > > | 579 | Marco     | Barisione | marco barisione.org | RT # 2448 |
> > > 2007-02-14  | 2007-02-14      | 2007-02-14 00:00:00 | NULL        |
> > > | 582 | Marco     | Barisione | marco barisione.org | RT #2448  |
> > > 2007-02-15  | 2007-02-15      | 2007-02-15 00:00:00 | NULL        |
> > > +-----+-----------+-----------+---------------------+-----------+-------------+-----------------+---------------------+-------------+
> > >
> > >
> > >
> > > On Wed, 2007-03-14 at 20:55 +0100, giskard wrote:
> > > > Hello,
> > > >
> > > > Attached you can find a patch for members.php which sort people from
> > > > A-Z.
> > > >
> > > > Marco Barisione appears twice in the list, i don't removed it in my
> > > > patch, but i think you want do that :)
> > > >
> > > > thank you in advance
> > > > _______________________________________________
> > > > membership-committee mailing list
> > > > membership-committee gnome org
> > > > http://mail.gnome.org/mailman/listinfo/membership-committee
> > >
> > > _______________________________________________
> > > membership-committee mailing list
> > > membership-committee gnome org
> > > http://mail.gnome.org/mailman/listinfo/membership-committee
> >
> > _______________________________________________
> > membership-committee mailing list
> > membership-committee gnome org
> > http://mail.gnome.org/mailman/listinfo/membership-committee