DW MX2004 ASP Membership App
I would like to get a tutorial on how to make a membership application, specifically where a new user registers and then the record is inserted into the db but with a flag that says the membership is inactive.
It then extracts the new record from the db, emails the administrator and includes an encrypted link to a confirmation page, which when opened with the encrypted link takes the URL parameter and updates the db to make the user 'active'. It then should email the new member telling them that their membership is now active.
I would like this to be based around existing the server behaviours, but I also have a few 3rd party ones (incl. Ultrasuite) so don't mind if they are used. I want to make sure that I am not leaving myself open to SQL injection attacks.
Thks.
Comments
Account status
You can set your database to have default in the a column, say AccountStatus, to be UnConfirmed when the new record is created, this is how I work it for mine.
Have an Email script within your Insert behaviour to email the Administrator, with the link to your Confirmation list page.
I use a List page, with a link next to all new entries for the Administrator to view each new registration, and then decide to Confirm or Denine the application.
Should they Confirm the application, the User is then Email their Username and Password.
I have a Tutorial on how to incorporate an email script into an Insert behaviour, which you can download for free.
It is within my Dreamweaver category, you might also find some other useful tutorials there.
URL = http://www.cgw3.co.uk/tutorials/list.asp?CategoryID=3
You must me logged in to write a comment.