[SOLVED] CB-Auto Actions: User ID with trigger After First Login

Hello,

When a new user registers, a welcome message is sent via PM using CB Auto Welcome.
I don't want to send a PM notification by email for this welcome message, so I have changed the default uddeim notification to Never.

When the user first logs in, I want to set their notification to When Offline and I am trying to do this with CB Auto Actions.

I have an action with trigger After First Login, the type is Query and the query is:

I have tested by changing [user_id] to an existing ID and that works, so I assume (cant find this trigger in the documentation) [user_id] is not available with this trigger?

Is their an alternative trigger/method I can use to achieve the same thing?

Thanks
David

Your trigger is fine, but your query has absolutely no quotes. Substitutions are typically strings and should be treated as such with ' quotes. Tables and columns should be surrounded with `. Your query would be as follows.


Now chances are the reason it's not working is they don't have a row to update to begin with. I believe UddeIM only creates one when it needs to, but I could be mistake; you'd need to post in the UddeIM forums for clarification on best way to do this, but there's probably an API call you can use in a Code action with Method set to PHP to properly do this with API.

www.joomlapolis.com/forum/25-uddeim-plugin-and-component

In this case user who have never logged in, do have rows in #__uddeim_emn
So I have updated the query and will see how it goes.

Thanks

I can confirm that adding quotes as recommended solves this.

Thanks