How to update client record custom field in hook?

[akashpagare]

I want to update client record custom field on Clientedit hook.

[PUQ]

To update a custom field for a client record on the "ClientEdit" hook, you can use the update_client_custom_field function provided by WHMCS. Here's an example of how you can use it:

use WHMCS\Database\Capsule;

// Update the custom field with field ID 1 for client with client ID 123
$success = Capsule::table('tblcustomfieldsvalues')
    ->where('fieldid', 1)
    ->where('relid', 123)
    ->update(['value' => 'new value']);

if ($success) {
    // Custom field update was successful
} else {
    // Custom field update failed
}

Note that you will need to replace 1 with the ID of the custom field you want to update, and 123 with the ID of the client whose custom field you want to update. You will also need to replace 'new value' with the new value you want to set for the custom field.

You can use this code in the "ClientEdit" hook function, which is called whenever a client record is edited in the WHMCS admin area or by the client using the client area.