Activate all clients as affiliates

[madbutcher]

Hello, 

I want to activate all existing clients as affiliates and to automatically activate as affiliate every new client. Do you have any suggestions how I can achieve this?

Thank you in advance.

[DemoTiger]

Use a WHMCS hook to activate the affiliate program for new clients. For all existing clients, I believe you can achieve this using an SQL query.

[SimpleSonic]

Here is an example hook to enable affiliate status for new clients:

 

<?php

use WHMCS\Database\Capsule;

add_hook('ClientAdd', 1, function($vars) {
    $clientID = $vars['userid'];

    // Check if the client is already an affiliate.
    $affiliateData = Capsule::table('tblaffiliates')->where('clientid', $clientID)->first();

    if (!$affiliateData) {
        // If not an affiliate, enable affiliate status for this client.
        Capsule::table('tblaffiliates')->insert([
            'clientid' => $clientID,
            'date' => date('Y-m-d'),
            'status' => 'Active'
        ]);
    }
});

 

[madbutcher]

On 10/23/2023 at 8:41 PM, SimpleSonic said:

Here is an example hook to enable affiliate status for new clients:

 

<?php

use WHMCS\Database\Capsule;

add_hook('ClientAdd', 1, function($vars) {
    $clientID = $vars['userid'];

    // Check if the client is already an affiliate.
    $affiliateData = Capsule::table('tblaffiliates')->where('clientid', $clientID)->first();

    if (!$affiliateData) {
        // If not an affiliate, enable affiliate status for this client.
        Capsule::table('tblaffiliates')->insert([
            'clientid' => $clientID,
            'date' => date('Y-m-d'),
            'status' => 'Active'
        ]);
    }
});

 

Hello, 
Thank you for your help. Unfortunately it doesn't work for me for some reason. 

[SimpleSonic]

9 hours ago, madbutcher said:

Hello, 
Thank you for your help. Unfortunately it doesn't work for me for some reason. 

Sorry about that. I have tested the following and it works to enable affiliate when a new client registers:

<?php

use WHMCS\Database\Capsule;

add_hook('ClientAdd', 1, function($vars) {
    $clientID = $vars['userid'];

    // Check if the client is already an affiliate.
    $affiliateData = Capsule::table('tblaffiliates')->where('clientid', $clientID)->first();

    if (!$affiliateData) {
        // Use WHMCS API to enable affiliate status for the client.
        localAPI('AffiliateActivate', ['userid' => $clientID]);
    }
});

 

[madbutcher]

Hi, 

This one works great, thank you! 

[SimpleSonic]

54 minutes ago, madbutcher said:

Hi, 

This one works great, thank you! 

You're welcome!

[CMS911]

Sorry for asking an obvious question but where do you put that code? In a specific template file?

[SimpleSonic]

28 minutes ago, CMS911 said:

Sorry for asking an obvious question but where do you put that code? In a specific template file?

Create a PHP file named "auto_affiliate.php" and place that code in the file and then move the file to the folder:

includes/hooks/