Sam_lee Posted August 31, 2022 Share Posted August 31, 2022 I want to send an email Template that shows all the domains a client has , My template is custom made and in General field,I am trying to get the values with this code: <?php use WHMCS\Database\Capsule; add_hook('EmailPreSend', 1, function($vars) { if($vars['messagename'] == 'New Network Issue') { $merge_fields = []; $merge_fields['service_domain'] = Capsule::table('tblhosting') ->where('userid', $vars['relid']) ->where('server', '41') ->where('domainstatus','Active') ->get(); return $merge_fields; } }); 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.