CB Auto Actions Code

Hello,

I want to use some PHP code in the CB Auto Actions Code. I want change value of one CB field after user profile updated.

I try to put this code:

<?php
$HostName='***';
$DBName='***';
$DBUserName='***';
$DBPass='***';
$con=mysql_connect(***,***,***,***);

$strSqlUpdateLink="UPDATE jum2593_comprofiler
SET cb_web=' www.yahoo.com '
WHERE id = [user_id]";
mysql_query($con,$strSqlUpdateLink);
?>

"cb_web" is field as web address type, and I set triggers as "onAfterUserUpdate,onAfterUpdateUser".

but it doesn't have effect.

Many thanks

Is there a reason you are not using a CB Field action directly?

Thanks for reply
I used Query action and I could updated CB field, but now I want call "Direct Admin Api" with parameters after user profile updated.Is there any way?

Don't understand the question. What is "Direct Admin Api"? To change a fields value simply use the Field action as Nick suggested.

Thanks for your suggest.
I have php file that this get dynamic parameters and connect to API and execute it. I used Redirect CB action and all things were OK but I don't want my user redirect to another page and this happen in background or CB action call my php code.
Thanks

Use a Code action with Method set to PHP then you can execute whatever PHP you want.