SELECT userID, firstName, lastName, username, email, phone, lastLogin, avatar, style, admin, active FROM #variables.tableprefix#users WHERE username = AND password = sLogin.userID = qLogin.userID; sLogin.firstName = qLogin.firstName; sLogin.lastName = qLogin.lastName; sLogin.username = qLogin.username; sLogin.email = qLogin.email; sLogin.phone = qLogin.phone; sLogin.lastLogin = qLogin.lastLogin; sLogin.avatar = qLogin.avatar; sLogin.style = qLogin.style; sLogin.admin = qLogin.admin; sLogin.active = qLogin.active; sLogin.projects = application.project.get(qLogin.userID); SELECT u.userID, u.firstName, u.lastName, u.username, u.email, u.phone, u.mobile, u.carrierID, u.lastLogin, u.avatar, u.style, u.email_files, u.mobile_files, u.email_issues, u.mobile_issues, u.email_msgs, u.mobile_msgs, u.email_mstones, u.mobile_mstones, u.email_todos, u.mobile_todos, u.admin, u.active, c.prefix, c.suffix FROM #variables.tableprefix#users u LEFT JOIN #variables.tableprefix#carriers c ON u.carrierID = c.carrierID WHERE 0=0 AND u.userID = AND u.userID IN () AND u.username = AND u.active = 1 ORDER BY u.lastName, u.firstName INSERT INTO #variables.tableprefix#users (userID, firstName, lastName, username, password, email, phone, avatar, style, email_files, mobile_files, email_issues, mobile_issues, email_msgs, mobile_msgs, email_mstones, mobile_mstones, email_todos, mobile_todos, admin, active) VALUES(, , , , , , , 0, '#application.settings.default_style#', 1,1,1,1,1,1,1,1,1,1, , ) An account has been setup for you to use the #application.settings.app_title#. You can login at #application.settings.rootURL##application.settings.mapping# Username: #arguments.username# Password: #arguments.password# #theMessage# #theMessage# INSERT INTO #variables.tableprefix#users (userID, firstName, lastName, username, password, email, phone, mobile, carrierID, avatar, style, email_files, mobile_files, email_issues, mobile_issues, email_msgs, mobile_msgs, email_mstones, mobile_mstones, email_todos, mobile_todos, admin, active) VALUES(, , , , , , , , , 0, '#application.settings.default_style#', , , , , , , , , , , , ) An account has been setup for you to use the #application.settings.app_title#. You can login at #application.settings.rootURL##application.settings.mapping# Username: #arguments.username# Password: #arguments.password# #theMessage# #theMessage# INSERT INTO #variables.tableprefix#users (userID, firstName, lastName, username, password, email, avatar, style, email_files, mobile_files, email_issues, mobile_issues, email_msgs, mobile_msgs, email_mstones, mobile_mstones, email_todos, mobile_todos, admin, active) VALUES(, , , , , , 0,'#application.settings.default_style#',0,0,0,0,0,0,0,0,0,0,0,0 ) An account has been setup for you to use the #application.settings.app_title#. You must confirm this account before using it by clicking here: #application.settings.rootURL##application.settings.mapping#/confirm.cfm?u=#arguments.userID# #theMessage# #theMessage# UPDATE #variables.tableprefix#users SET active = 1 WHERE userID = SELECT userID FROM #variables.tableprefix#users WHERE userID = AND active = 1 UPDATE #variables.tableprefix#users SET firstName = , lastName = , email = , phone = , mobile = , carrierID = WHERE userID = UPDATE #variables.tableprefix#users SET email_files = , mobile_files = , email_issues = , mobile_issues = , email_msgs = , mobile_msgs = , email_mstones = , mobile_mstones = , email_todos = , mobile_todos = WHERE userID = UPDATE #variables.tableprefix#users SET firstName = , lastName = , username = , password = , email = , phone = , mobile = , carrierID = , email_files = , mobile_files = , email_issues = , mobile_issues = , email_msgs = , mobile_msgs = , email_mstones = , mobile_mstones = , email_todos = , mobile_todos = , admin = , active = WHERE userID = UPDATE #variables.tableprefix#users SET username = , password = WHERE userID = UPDATE #variables.tableprefix#users SET avatar = WHERE userid = UPDATE #variables.tableprefix#users SET style = WHERE userid = DELETE FROM #variables.tableprefix#users WHERE 0=0 AND userID = UPDATE #variables.tableprefix#users SET lastLogin = #Now()# WHERE userid = SELECT username,firstName,lastName FROM #variables.tableprefix#users WHERE email = SELECT userid,email,firstName FROM #variables.tableprefix#users WHERE username = UPDATE #variables.tableprefix#users SET password = WHERE userid =