Auto action and change of username

Ok that's fine for username and password, your condition works very well, thanks !

But for email change, we have a problem with the trigger.
We use reconfirm_onAfterConfirm with user automatic for everybody, no conditions, and we need to access

The reconfirm_onAfterConfirm trigger doesn't provide the same variables as onAfterUpdateUser. Its variables are as follows.

[var1] = user object
[var2] = reconfirm object (has new and old email address, see __comprofiler_plugin_emails table)
[var3] = reconfirm code

do we need to add references, reload user object, use another substitution ?

No, but you can try [var1_email] I suppose.

But if I need to access other substitutions like [cb_refid] for instance, should I use [var1_email] and reload user object for [cb_refid] ?

I have some difficulties with this one

Accessing [var1_email] gives the old email address, so is this [var2_to] or [var2_email] to get the new email after reconfirmation ?

Acting on reconfirm_onAfterConfirm should not give the old email address. The user object has been updated at that point. If not try reload user to see if that solves it, but you shouldn't need to. You can also access the email addresses as follows for that trigger.

Old:
[var2_from]
New:
[var2_to]

For other fields just use normal substitutions or access var1 directly.

Thanks a lot, got it with [var2_to]
For info do you always follow var_database_field as a notation in CB ?

This will answer to lots of questions

For info do you always follow var_database_field as a notation in CB ?

Not necessarily. If it's a database object then yeah its variables should match the table, but the variables sent with a trigger aren't always database objects.