+ $r = q("DELETE FROM `register` WHERE `hash` = '%s'",
+ dbesc($register[0]['hash'])
+ );
+
+
+ $r = q("UPDATE `user` SET `blocked` = 0, `verified` = 1 WHERE `uid` = %d",
+ intval($register[0]['uid'])
+ );
+
+ $r = q("SELECT * FROM `profile` WHERE `uid` = %d AND `is-default` = 1",
+ intval($user[0]['uid'])
+ );
+ if (DBM::is_result($r) && $r[0]['net-publish']) {
+ $url = System::baseUrl() . '/profile/' . $user[0]['nickname'];
+ if ($url && strlen(Config::get('system','directory'))) {
+ Worker::add(PRIORITY_LOW, "Directory", $url);
+ }
+ }
+
+ push_lang($register[0]['language']);
+
+ send_register_open_eml(
+ $user[0]['email'],
+ $a->config['sitename'],
+ System::baseUrl(),
+ $user[0]['username'],
+ $register[0]['password']);
+
+ pop_lang();
+
+ if($res) {
+ info( t('Account approved.') . EOL );
+ return true;
+ }
+
+}