--SQL Action
UPDATE jos_users users INNER JOIN jos_comprofiler com ON com.user_id = users.id
INNER JOIN zip_code zip ON zip.zip_code = com.zipcode
SET users.params = CONCAT('language=en-GB',char(10),char(13),'timezone=-',zip.time_zone)
WHERE users.id = [user_id]
--Standard CB Update
UPDATE `jos_users`
SET `name`='Rodrigo Kammer',`username`='rkammer',`email`='rodrigokammer@hotmail.com',`password`='1a128079be812d0fa84b51a6a06aa004:PVx5z19R4YXDuguqfVKYBe1cFSc0XlK5',`usertype`='Registered',`block`='1',`sendEmail`='0',`gid`='18',`registerDate`='2011-02-23 17:34:21',`activation`='54cdc8b422dda4344873b42f489f2006',`params`='\n'
WHERE id='2678'
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Order seen in Plugin Management is also order of loading so the order at which plugins are executed, you can try moving it to last. Aside from this no. We've plans to improve the order of execution throughout CBSubs in a later release to prevent issues such as this.We are actually having this problem when trying to register from frontend. There is no way to change the order in which the SQL Action plugin is going to run?
I recommend the After Registration trigger.Also I will download and test CB Queries...
Please Log in to join the conversation.