auto update usergroup

I have used c-pr0mpt's hack to create an extra page on my site.

What I am trying to do is create a php page where a user in usergroup Y can click the submit button and automatically be upgraded to usergroup X.

I already have the submit button, based on the one in the register template. I already have the php file created, just need to the query necessary to make the update automatically when the user clicks the submit button.

Also, how would I go about tracking the date a member makes this upgrade? I need some way to either automatically put the user back in usergroup Y after 30 days, or way for the admin to get a list of when people in usergroup X upgraded, so he can manually move the user back to group Y.

Thank you!

[Xenon]

You're welcome

[midnightz]

Can you have a Default Auto PM or email sent when the user gets upgraded to the new usergroup?

Thanks

[Xenon]

all you have to do, is to insert a new row into the privatemessage table