How to add a member (Re: TODO list for the elections)

["Vincent Untz" <vuntz gnome org>]

On Fri, November 18, 2005 11:23, Vincent Untz wrote:
> >  * process the applications sent before the deadline
> >    => There's not a lot. Should be easy.
>
> IIRC, there's only two applications sent before the deadline to process:
>   + Gerald Friedland
>     see this thread:
> http://mail.gnome.org/archives/membership-committee/2005-November/msg00027.html
>   + Johan Dahlin (renewal)
>
> I won't process them.

I totally forgot to explain how to add a new member/renew a membership.
So here we go.

Log in MySQL.

To create a new member accepted on 2005/11/16:

$ INSERT INTO foundationmembers (firstname, lastname, email, first_added,
last_renewed_on) VALUES ('Rupert', 'The Monkey', 'rupert gnome rg',
'2005/11/16', '2005/11/16');

To renew a member, with the renewal accepted on 2005/11/16:

$ SELECT * FROM foundationmembers WHERE firstname = "Rupert";

Note the id of the member. Then:

$ UPDATE foundationmembers SET  last_renewed_on="2005-11-16" WHERE id=$ID;

If you need to update the email address too:

$ UPDATE foundationmembers SET  email='rupert newgnome org',
last_renewed_on="2005-11-16" WHERE id=$ID;

You'll then need to send the usual accept/renew mail and subscribe the
member to foundation-announce.

Vincent

-- 
Les gens heureux ne sont pas pressés.