We are using cbsubs SQL action to update username when user activates the subscription. We want to send the activation email after this has been executed.
when a user does the registration cbsubs will automatically create an account and user is logged in while doing the payment. When payment is done, a mail is being send out and then the SQL action takes place. This results in that the welcome email will display the wrong username. It will show joomla default ("first name last name") and not the username updated by SQL action.

We have tried to use cbemail plugin and trigger the email on the event onBeforeFirstLogin but that doesn't seem to work. I guess because user already login the first time, when user did the registration.

We have been looking for a trigger to use to solve this, like a onAfterUsernameChange... Anyone have an ide to send the welcome email one second or more after user has been activated so the welcome email gets right?

I have installed cbsubs email plugin and verified that it is last in the list of plugins, still the username is wrong when the email is being send.

I was thinking if I can use the URL plugin and have a php script sending the email... Do you think that possible or will I get the same result perhaps?

We have upgraded to cb 1.3 and cbsubs 1.1. Are there any new triggers introduced that we can use? Similar to afterSubscriptionActivation

Is there any way of delaying the email so that the mail is being send like a minute after activation has been done, so that SQL action have the time to update?

Was thinking about the URL plugin, aren't you suppose do send the input values to the php script together with the URL? Wouldn't this mean that the old username will be in the URL since SQL action have not had the time to update it?