select firstname,lastname,password,email,emailvalid from TransformersClub where username = '#trim(form.username)#' and email ='#trim(form.emailaddress)#' Dear #forgotlogin.firstname# #forgotlogin.lastname#, according to our records, you forgot your password for the Transformers Club. Your password is: #forgotlogin.password# Click here http://www.transformersclub.com/members/tfmemberslogin.cfm to login. select username,firstname,lastname,password,email,emailvalid from TransformersClub where email ='#trim(form.emailaddress)#' and zip = '#trim(form.zipcode)#' Dear #forgotlogin.firstname# #forgotlogin.lastname#, according to our records, you forgot your username for the Transformers Club. Your username is: #forgotlogin.username# Your password is: #forgotlogin.password# Click here http://www.transformersclub.com/members/tfmemberslogin.cfm to login. select * from TransformersClub where username = '#form.username#' and password ='#form.password#' SELECT customerid, status, username, password from customers_#accountid# where transformersid = #chklogin.id# update customers_#accountid# set username = '#chklogin.username#', password = '#chklogin.password#' where transformersid = #chklogin.id# select * from TransformersClub where reg_key = '#form.reg_key#' UPDATE TransformersClub SET confirm_key = #form.reg_key#, security = 5, confirm_date = getdate() WHERE id = #chklogin.id# select * from TransformersClub where id = #session.memberid# select * from TransformersClub where firstname = '#form.firstname#' and lastname ='#form.lastname#' and zip ='#form.zip#' and (zip = '' or zip is null) and (convert(datetime, expiredate) = convert(datetime, '#comp_date#') OR convert(datetime, expiredate) = convert(datetime, '#comp_date2#')) select * from TransformersClub where firstname = '#form.firstname#' and lastname ='#form.lastname#' and zip ='#form.zip#' and (zip = '' or zip is null) and new_subscription = 1 SELECT id FROM TransformersClub WHERE Username = '#form.username#' UPDATE TransformersClub SET username = '#form.username#', password = '#form.password#', email = '#trim(form.email)#', collecting_interests = '#trim(form.collectinginterests)#", security = 5, reg_key = '#form.reg_key#' WHERE id = #form.id# select id,expiredate from TransformersClub where id = #form.id# Congratulations #form.firstname# #form.lastname#! Your online account has been created. Return to: http://www.transformersclub.com/members/index.cfm?do=memberslogin and enter your username and password. Then enter your Registration Key listed below. ============================================ #form.reg_key# ============================================ SELECT id FROM TransformersClub WHERE Username = '#form.username#' UPDATE TransformersClub SET username = '#form.username#', password = '#form.password#', email = '#trim(form.email)#', age = '#trim(form.age)#', collecting_interests = '#trim(form.collectinginterests)#', gender = '#trim(form.gender)#', security = 5, reg_key = '#form.reg_key#' WHERE id = #form.id# select id,expiredate from TransformersClub where id = #form.id# Congratulations #form.firstname# #form.lastname#! Your online account has been created. Return to: http://www.transformersclub.com/members/index.cfm?do=memberslogin and enter your username and password. Then enter your Registration Key listed below. ============================================ #form.reg_key# ============================================ SELECT id FROM TransformersClub WHERE Username = '#form.username#' and id <> #session.memberid# SELECT * FROM TransformersClub WHERE id=#session.memberid# UPDATE TransformersClub SET username = '#form.username#', password = '#form.password#', email = '#trim(form.email)#', age = '#form.age#', gender = '#form.gender#', collecting_interests = '#trim(form.collectinginterests)#', security = 5, emailvalid = 'Y' WHERE id = #session.memberid# A Transformers Club member has just updated thier profile. Here is the updated information: A '*' in front of the item means that it has changed. * Username : #form.username##chr(10)# * Email : #form.email##chr(10)# #chr(10)# * Age : #form.age##chr(10)# * Gender : #form.gender##chr(10)# #chr(10)# * Collecting Interests: #form.collectinginterests#