Thank you for your registration.
An email with further instructions has been sent to you.
" , "You should receive the mail during the next 5 minutes. If not, please check your SPAM folder.
" FROM (SELECT '') AS fake WHERE '{{action:SE}}' = 'thanksRegistration' AND '{{form:SE}}'='' Form: registration """""""""""""""""" :: { "title": "Registration", "tableName": "Person", "permitNew": "always", "permitEdit": "never", "showButton": "close,save", "forwardMode": "url-sip-skip-history", "forwardPage": "?id=registration&action=thanksRegistration", "parameter": "submitButtonText=Register", "FormElement_ff": [ { "enabled": "yes", "name": "firstName", "label": "First name", "mode": "required", "type": "text" }, { "enabled": "yes", "name": "lastName", "label": "Last name", "mode": "required", "type": "text" }, { "enabled": "yes", "name": "email", "label": "Email", "mode": "required", "class": "native", "type": "text", "checkType": "email", "parameter": "retype\r\nretypeLabel=Retype email" }, { "enabled": "yes", "label": "Check for double registration", "mode": "show", "modeSql": "", "class": "action", "type": "beforeSave", "parameter": "sqlValidate={{!SELECT p.id FROM Person AS p WHERE p.email='{{email:F:alnumx}}' OR ('{{firstName:F:allbut}}'=p.firstName AND '{{lastName:F:allbut}}'=p.lastName ) LIMIT 1 }}\r\n expectRecords=0\r\nmessageFail=Sorry, person already registered by name or email. Please just reset the password under reset" }, { "enabled": "yes", "label": "auth, deadline", "class": "action", "type": "afterSave", "parameter": "# Set token & expiration\r\nsqlBefore={{UPDATE Person SET auth='{{random:V}}', authExpire=DATE_ADD(NOW(), INTERVAL 1 DAY) WHERE id={{id:R}} }}" }, { "enabled": "yes", "label": "a) sendEmail, b) fe user", "mode": "show", "class": "action", "type": "sendMail", "value": "Dear new user\r\nPlease set a new password under {{baseUrl:Y}}?id=set&auth={{auth:R}}\r\nRegards.", "parameter": "sendMailTo={{email:R}}\r\nsendMailSubject=Registration confirmation\r\nsendMailFrom={{ADMINISTRATIVE_EMAIL:Y}}\r\n\r\n# Create User in T3\r\nsqlAfter={{INSERT INTO {{dbNameT3:Y}}.fe_users (pid, usergroup, username, password, first_name, last_name, name, email) VALUES (6, '1', '{{email:F:alnumx}}','$p$initial invalid hash', '{{firstName:R}}', '{{lastName:R}}', '{{firstName:R}} {{lastName:R}}', '{{email:F:alnumx}}') }}" } ] } Request password reset link ^^^^^^^^^^^^^^^^^^^^^^^^^^^ Page: reset """"""""""" * Page Alias: reset QFQ content record:: # # {{action:SE}}: passwordReset # # Empty: {{action:SE}}='' > shows the form angezeigt 'passwordReset'. # Given: {{action:SE}}='confirmation' > show confirmation. # form={{SELECT IF('{{action:SE}}' = '','passwordReset','') }} r=1 10 { sql = SELECT '' FROM (SELECT '') AS fake WHERE '{{action:SE}}'='confirmation' head =Thank you.
If the email address is known in our database, we sent a password reset link to it.
The mail should be received during the next minutes. If not, please check you junk folder.
To set a new password, please click on the link provided in the email.