Hook to add domain registrant name in to invoice description

[glardone]

Hi all,

I'm trying to create a hook to add the domain registrant name to invoice description:

 

<?php
function invoice_domain_registrant($vars) {
   $result = full_query("SELECT id, description, (SELECT (SELECT tblcontacts.companyname FROM tblcontacts WHERE id = tblorders.contactid) FROM tblorders WHERE userid ='".$vars['userid']."' AND invoiceid='".$vars['invoiceid']."') AS registrant FROM tblinvoiceitems WHERE invoiceid='".$vars['invoiceid']."'");
   while($data = mysql_fetch_array ($result))
       if($data['registrant'] !== NULL) // Add Company Name of client contact
           update_query("tblinvoiceitems", array("description" => $data['description']." - ".$data['registrant']), array("id" => $data['id']));
} else {
$result = full_query("SELECT id, description, (SELECT (SELECT tblclient.companyname FROM tblclients WHERE id = tblorders.userid) FROM tblorders WHERE userid ='".$vars['userid']."' AND invoiceid='".$vars['invoiceid']."') AS registrant FROM tblinvoiceitems WHERE invoiceid='".$vars['invoiceid']."'");
while($data = mysql_fetch_array ($result))
       if($data['registrant'] !== NULL) // Add Company Name of client
           update_query("tblinvoiceitems", array("description" => $data['description']." - ".$data['registrant']), array("id" => $data['id']));
}
add_hook("InvoiceCreationPreEmail", 1, "invoice_domain_registrant");

 

I do not understand what is the error, but the description does not change

 

Thank you!