public function create(UserAccountModel $user) { global $DB; $uavem = new UserAccountVerifyEmailModel(); $uavem->setEmail($user->getEmail()); $uavem->setUserAccountId($user->getId()); $uavem->setAccessKey(createKey(2, 250)); // TODO check not already used $stat = $DB->prepare("INSERT INTO user_account_verify_email (user_account_id, email, access_key, created_at) " . "VALUES (:user_account_id, :email, :access_key, :created_at)"); $stat->execute(array('user_account_id' => $uavem->getUserAccountId(), 'access_key' => $uavem->getAccessKey(), 'email' => substr($uavem->getEmail(), 0, VARCHAR_COLUMN_LENGTH_USED), 'created_at' => \TimeSource::getFormattedForDataBase())); return $uavem; }