USER_ID via Auto Action

Hi,

I have a problem with the Plugin Auto Action. Hopefully I can find an approach to that problem by this way.

explenation:

I want to calculate the age of an user after successfully login. Therefor I use the Auto Action (Type Code). I wrote an php script which calculates the age as a function of birthday and the current date. So far no problem, it works but only when I write the user_id of the logged in rider manuelly in my php script.

part of my sql query from the php script:

(...WHERE `user_id`='1124'...)

Now my question:

How can I get the user_id of the logged in user automatically.

something like that (unfortunately it didn't work by this way):

(...WHERE `user_id`='$user_id'...)

Up to now I couldn't found a solution to include the user_id of the current logged in user in my php script.

Do you have a solution for that problem?

Thanks in advance!

Hi there,

Why not use the cb age field and display as age and not birthdate?

If you're using a Code action to perform a query then just use a Query action. Substitutions work in Code actions as well (e.g. [user_id]). Please see tutorials within my signature for further substitution usage information. If you're wanting to populate $user_id inside your PHP then you need to use normal Joomla/CB APIs to get $user_id (e.g. $_CB_Framework->myId()).