clientID for a send email hook?

[theozsnowman]

Im trying to create a simple hook to send out an email when an Affiliate account is activated

 

<?php

use WHMCS\Database\Capsule;

add_hook('AffiliateActivation', 1, function($vars) {
    $affiliateId = $vars['affiliateid']; // Retrieve the affiliate ID from the hook's parameters

    // Fetch the client ID associated with the affiliate
    $clientId = Capsule::table('tblaffiliates')
                    ->where('id', $affiliateId)
                    ->value('clientid'); // Directly getting the client ID

    // Check if a valid client ID was retrieved
    if ($clientId) {
        // Send email using the WHMCS email template
        $response = localAPI('SendEmail', [
            'messagename' => 'Welcome to the Affiliate Program',
            'id' => $clientId
        ]);

        // Log the response for debugging
        logActivity("Send Email API Response: " . json_encode($response, JSON_PRETTY_PRINT));
    } else {
        // Log an error if the client ID was not found
        logActivity("Error: Client ID not found for affiliate ID " . $affiliateId);
    }
});

if i hard code the client ID to a client that im activating it for it works but otherwise for some reason this code coes back with the error message:
 

Send Email API Response: {"result":"error","message":"A related ID is required"}

this is in a log line directly after i get a line saying something like:
 

Activated Affiliate Account - Affiliate ID: 9 - User ID: 30

what am i missing?

[leemahoney3]

Just use the userid variable.

$clientId = $vars['userid'];

 

[theozsnowman]

On 12/31/2023 at 4:33 AM, leemahoney3 said:

Just use the userid variable.

$clientId = $vars['userid'];

 

cheers.. so simple...

 

[CMS911]

Can you share your email template? How did you get it to show them their affiliate link?