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:
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:
HTML file size limit (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
serial number generation (1997)
Image as submit button (2000)
[searchString] (1997)
Size Limitation through a POST via SSL? (2005)
Hosts who have upgraded to v5.0? (2003)
Webcatalog quitting (1997)
First postarg not taking in $Commands (1997)
4.5 Upgrade (2003)
StoreBuilder Shopping Cart (2000)
two unique banners on one page (1997)
[REFERRER] bug? (1998)
possible, WebCat2.0 and checkboxes-restated (1997)
Multiple Merchant Accounts? (1997)
Requiring that certain fields be completed (1997)
What's wrong with this? (2005)
Are [CART]'s always > Previous [CART]'s (2000)
[foundItems] context problem (2000)
Webcatalog acgi conflict? (1999)