Re: User Authentication

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 54531
interpreted = N
texte = Don't forget that LOOKUP is case sensitive :) On Friday, November 28, 2003, at 01:11 AM, Alan White wrote: > Hi Folks... > > Can anyone help me debug this or let me know if I am going down the > right > track for creating a user authentication system. At the moment it just > seems to be executing the final else statement. > > Thanks in advance... > > Alan > > P.S. Comments are heavy so you know what I am trying to do.... > > [!] > > Description > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > The idea is that when the user logs in the following will take place:- > > 1) Enter login details > 2) Check username is valid otherwise display error1 > 3) If the username is valid, check the password against it. > 4) If the username and password are valid then check which level of > access > is allowed and redirect to content. > 5) Display error2 if the username and password do not match. > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > Example of database format > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > ------------------------------------------------------- > userID userName password accessLevel > ------------------------------------------------------- > 1 alan freak 1 > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > > [!] > > Variables being passed > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > _userName // Username from login > _password // Password from login > > error1 & 2 // Used to display the following messages on index page > > error1 : Username has not been recognised please re-enter > > error2 : There is a problem with your password please re-enter it > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > The Code > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [text]checkName=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=userNam > e][/text] > [if "[_userName]"="[checkName]"] > [then] > [text]checkPass=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=passwor > d][/text] > [if ("[_userName]"="[checkName]") & ("[_password]"="[checkPass]") > [then] > [lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=accessL > evel] > [redirect > url=https://www.hanon-shop.com/press/ > press.html?accessLevel=[accessLevel]] > [/then] > [else] > [redirect > url=https://www.hanon-shop.com/press/index.html?error=2] > [/else] > [/if] > [redirect url=https://www.hanon-shop.com/press/press.html] > [/then] > [else] > [redirect url=https://www.hanon-shop.com/press/index.html?error=1] > [/else] > [/if] > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: user authentication via TCPSend ( Terry Wilson 2005)
  2. Re: user authentication via TCPSend ( John Peacock 2005)
  3. user authentication via TCPSend ( Terry Wilson 2005)
  4. Re: User Authentication ( Stuart Tremain 2003)
  5. Re: User Authentication ( Gary Krockover 2003)
  6. Re: wierd... [Was] User Authentication ( Alan White 2003)
  7. wierd... [Was] User Authentication ( Alan White 2003)
  8. Re: User Authentication ( Alan White 2003)
  9. Re: User Authentication ( Alan White 2003)
  10. Re: User Authentication ( Gary Krockover 2003)
  11. Re: User Authentication ( Alex McCombie 2003)
  12. Re: User Authentication ( Alex McCombie 2003)
  13. Re: User Authentication ( Andy Mowrey 2003)
  14. Re: User Authentication ( Alex McCombie 2003)
  15. Re: User Authentication ( Alan White 2003)
  16. Re: User Authentication ( Alex McCombie 2003)
  17. User Authentication ( Alan White 2003)
Don't forget that LOOKUP is case sensitive :) On Friday, November 28, 2003, at 01:11 AM, Alan White wrote: > Hi Folks... > > Can anyone help me debug this or let me know if I am going down the > right > track for creating a user authentication system. At the moment it just > seems to be executing the final else statement. > > Thanks in advance... > > Alan > > P.S. Comments are heavy so you know what I am trying to do.... > > [!] > > Description > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > The idea is that when the user logs in the following will take place:- > > 1) Enter login details > 2) Check username is valid otherwise display error1 > 3) If the username is valid, check the password against it. > 4) If the username and password are valid then check which level of > access > is allowed and redirect to content. > 5) Display error2 if the username and password do not match. > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > Example of Database format > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > ------------------------------------------------------- > userID userName password accessLevel > ------------------------------------------------------- > 1 alan freak 1 > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > > [!] > > Variables being passed > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > _userName // Username from login > _password // Password from login > > error1 & 2 // Used to display the following messages on index page > > error1 : Username has not been recognised please re-enter > > error2 : There is a problem with your password please re-enter it > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [!] > > The Code > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > [/!] > > [text]checkName=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=userNam > e][/text] > [if "[_userName]"="[checkName]"] > [then] > [text]checkPass=[lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=passwor > d][/text] > [if ("[_userName]"="[checkName]") & ("[_password]"="[checkPass]") > [then] > [lookup > db=admin/ > users.db&value=[_userName]&lookinfield=userName&returnfield=accessL > evel] > [redirect > url=https://www.hanon-shop.com/press/ > press.html?accessLevel=[accessLevel]] > [/then] > [else] > [redirect > url=https://www.hanon-shop.com/press/index.html?error=2] > [/else] > [/if] > [redirect url=https://www.hanon-shop.com/press/press.html] > [/then] > [else] > [redirect url=https://www.hanon-shop.com/press/index.html?error=1] > [/else] > [/if] > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Stuart Tremain

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Re:WebCat Emailer & Liststar (1997) RE: Formulas.db + Users.db (1997) Detecting SSL or port (2005) Stumpted Again (1997) PCS Frames (1997) Using files in an Email broadcast (1999) WebCat Performance Issue (2000) international time (1997) Problem with [Search] inside of [Loop]? (1997) Credit Card Number checking (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Using [detete] (1998) WC2b12: Yes, Formulas.db is for real (1997) blank page from template (1997) WebCatalog2 Feature Feedback (1996) Locking up with WebCatalog... (1997) Error & Problem (1997) A little help on e-mail (HELP!!! :-) ) (1998) Searching multiple Databases (1997) request for new command (1997)