Help me for SQL query about affiliate

[VolcanNET]

Hello,

If you go to Manage Orders in whmcs you can  Manual Affiliate Assign to a client .

I want to   Assign some oderers to a client by SQL command.

Please help me .

 

[Kian]

INSERT INTO `tblaffiliatesaccounts` (`affiliateid`, `relid`, `lastpaid`) VALUES ('{USER_ID}', '{PRODUCT_ID}', '0000-00-00')

 

[FFOX]

On 8/17/2020 at 3:06 PM, Kian said:

INSERT INTO `tblaffiliatesaccounts` (`affiliateid`, `relid`, `lastpaid`) VALUES ('{USER_ID}', '{PRODUCT_ID}', '0000-00-00')

 

Thank you! 

Is it enough to create an entry in the affiliatesaccounts table? Or there is a ready-made function, for example, as in WHMCS (admin area) I noticed a query:

jQuery("#affiliatefield").html(jQuery("#affid option:selected").text()); jQuery("#modalAffiliateAssign").modal("hide"); WHMCS.http.jqClient.post( "orders.php", { action: "affassign", orderid: 307, affid: jQuery("#affid").val(), token: "" } );