I want to do a database lookup when a user logs in. I added a new field called TeamID to the mp_Users table that I want to read at login. I didn't use the mp_UserProperties table because I want to be able to sort users based on an integer stored in the TeamID field. Also, I'd like to redirect a user to a specific page based on their role when they login, or at least be able to redirect everyone to a "members.aspx" page.

I read the document "User Sign In Event Handlers" but that is way over my head. I don't know how to make a DLL. In other ASP.net websites I've built, I've added code in the Page_Load event of the login page. Is there an easy way to create a function and then call it at login?

I may want to use a session variable to track the TeamID.  If a user logs out, is there a way to clear the session var at logout? 

Yes, I am used to web site projects with VB, so I'm really struggling...

I found a key that solved my problem of running code when a user logs in: <add key="PageToRedirectToAfterSignIn" value="~/members.aspx"/> .  A user control on the members.aspx page runs code when the user logs in.  It may not be the cleanest solution, but it seems to work for what I want to do.  I understand that this is a global setting for all sites.

Now I want to redirect a newly registered user to a specific page.  I didn't see a key for "PageToRedirectToAfterREGISTRATION", so I think this would make a nice enhancement to mojoPortal, even if it is a global setting.

I'm trying to create a registered user event handler.  After several hours I'm not even close.  I just want to redirect a new user to somepage.aspx.  I get these errors when I try to build:

The type or namespace name 'Provider' does not exist in the namespace 'System.Configuration'
The type or namespace name 'log4net' could not be found
The type or namespace name 'UserRegisteredHandlerProvider' could not be found
The type or namespace name 'ILog' could not be found
The type or namespace name 'UserRegisteredEventArgs' could not be found

It sounds like I need to add some references, but this where I'm not sure what or where to find them. 

In VS2008 I'm choosing New > Project > Class Library.  I paste the sample from the documentation, rename the class and
namespace mojoPortal.Business.WebHelpers.UserRegisteredHandlers to MyUserRegisteredHandlers.  That's where I have no idea what to do.  I've tried downloading the mojoPortal source and building a solution there, but I get the same errors.  Can anyone point me in the right direction?

I'd love to see a \data\sites\1\site.config file for site settings like this.

Thanks!
Tom