- 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);
+ 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);