- /***********************************************************/
- /****************** REALLY CREATE ACCOUNT ******************/
- /***********************************************************/
-
- XDB::execute('UPDATE auth_user_md5
- SET password={?}, perms="user",
- date=NOW(), naissance={?}, date_ins = NOW()
- WHERE user_id={?}', $password, $naissance, $uid);
- XDB::execute('REPLACE INTO auth_user_quick (user_id) VALUES ({?})', $uid);
- XDB::execute('INSERT INTO aliases (id,alias,type)
- VALUES ({?}, {?}, "a_vie")', $uid,
- $forlife);
- XDB::execute('INSERT INTO aliases (id,alias,type,flags)
- VALUES ({?}, {?}, "alias", "bestalias")',
- $uid, $bestalias);
- if ($mailorg2) {
- XDB::execute('INSERT INTO aliases (id,alias,type)
- VALUES ({?}, {?}, "alias")', $uid,
- $mailorg2);
+ //
+ // Create the user account.
+ //
+ XDB::startTransaction();
+ XDB::execute("UPDATE accounts
+ SET password = {?}, state = 'active',
+ registration_date = NOW(), email = NULL
+ WHERE uid = {?}", $password, $uid);
+ XDB::execute("UPDATE profiles
+ SET birthdate = {?}, last_change = NOW()
+ WHERE pid = {?}", $birthdate, $pid);
+ XDB::execute('INSERT INTO email_source_account (email, uid, type, flags, domain)
+ SELECT {?}, {?}, \'forlife\', \'\', id
+ FROM email_virtual_domains
+ WHERE name = {?}',
+ $forlife, $uid, $mail_domain);
+ XDB::execute('INSERT INTO email_source_account (email, uid, type, flags, domain)
+ SELECT {?}, {?}, \'alias\', \'bestalias\', id
+ FROM email_virtual_domains
+ WHERE name = {?}',
+ $bestalias, $uid, $mail_domain);
+ if ($emailXorg2) {
+ XDB::execute('INSERT INTO email_source_account (email, uid, type, flags, domain)
+ SELECT {?}, {?}, \'alias\', \'\', id
+ FROM email_virtual_domains
+ WHERE name = {?}',
+ $emailXorg2, $uid, $mail_domain);