Как добавить название производителя в письмо Информация о заказе? - [VM1] Модификации и хаки

<!-- begin order items information --> 
  <tr bgcolor="#CCCCCC" class="Stil2"> 
    <td colspan="2"><b><?php echo $VM_LANG->_('PHPSHOP_ORDER_ITEM')?></b></td>
  </tr>
  <tr> 
    <td colspan="2"> 
      <table width=100% cellspacing=0 cellpadding=2 border=0>
        <tr align=left class="Stil1">
         <th><?php echo $VM_LANG->_('PHPSHOP_CART_QUANTITY')?></th>
           <th><?php echo $VM_LANG->_('PHPSHOP_CART_NAME')?></th>
           <th><?php echo $VM_LANG->_('PHPSHOP_CART_SKU')?></th>
         <th><?php echo $VM_LANG->_('PHPSHOP_CART_PRICE')?></th>
         <th><?php echo $VM_LANG->_('PHPSHOP_CART_SUBTOTAL')?></th>
        </tr>
<?php
// CREATE THE LIST WITH ALL ORDER ITEMS
$order_items = "";
$sub_total = 0.00;
while($dboi->next_record()) {
   $my_qty = $dboi->f("product_quantity");
   if ($auth["show_price_including_tax"] == 1) {
      $price = $dboi->f("product_final_price");
      $my_price = $CURRENCY_DISPLAY->getFullValue($dboi->f("product_final_price"), '', $db->f('order_currency'));
   } else {
      $price = $dboi->f("product_item_price");
      $my_price = $CURRENCY_DISPLAY->getFullValue($dboi->f("product_item_price"), '', $db->f('order_currency'));
   }
   $my_subtotal = $my_qty * $price;
   $sub_total += $my_subtotal;
   ?>
   <tr class="Stil1">
      <td><?php echo $my_qty ?></td>
      <td><?php $dboi->p("product_name")?> <?php echo ($dboi->f("product_attribute")? ' ('.$dboi->f("product_attribute").')' : ''); ?></td>
      <td><?php echo $ps_product->get_field($dboi->f("product_id"), "product_sku")?></td>
      <td><?php echo $my_price ?></td>
      <td><?php echo $CURRENCY_DISPLAY->getFullValue($my_subtotal, '', $db->f('order_currency'))?></td>
   </tr>
   <?php
}
?> 

<!-- begin order items information --> 
  <tr bgcolor="#CCCCCC" class="Stil2"> 
    <td colspan="2"><b><?php echo $VM_LANG->_('PHPSHOP_ORDER_ITEM')?></b></td>
  </tr>
  <tr> 
    <td colspan="2"> 
      <table width=100% cellspacing=0 cellpadding=2 border=0>
        <tr align=left class="Stil1">
         <th><?php echo $VM_LANG->_('PHPSHOP_CART_QUANTITY')?></th>
           <th><?php echo $VM_LANG->_('PHPSHOP_CART_NAME')?></th>
            <th>Márka</th>
           <th><?php echo $VM_LANG->_('PHPSHOP_CART_SKU')?></th>
         <th><?php echo $VM_LANG->_('PHPSHOP_CART_PRICE')?></th>
         <th><?php echo $VM_LANG->_('PHPSHOP_CART_SUBTOTAL')?></th>
        </tr>
<?php
// CREATE THE LIST WITH ALL ORDER ITEMS
$order_items = "";
$sub_total = 0.00;
while($dboi->next_record()) {
   $my_qty = $dboi->f("product_quantity");
   if ($auth["show_price_including_tax"] == 1) {
      $price = $dboi->f("product_final_price");
      $my_price = $CURRENCY_DISPLAY->getFullValue($dboi->f("product_final_price"), '', $db->f('order_currency'));
   } else {
      $price = $dboi->f("product_item_price");
      $my_price = $CURRENCY_DISPLAY->getFullValue($dboi->f("product_item_price"), '', $db->f('order_currency'));
   }
   $my_subtotal = $my_qty * $price;
   $sub_total += $my_subtotal;
      $db->query( "SELECT manufacturer_id FROM #__{vm}_product_mf_xref WHERE product_id='".$dboi->f("product_id")."'");
      $db->next_record();
      $manufacturer_id = $db->f("manufacturer_id");

      $db->query( "SELECT manufacturer_id, mf_name, mf_desc FROM #__{vm}_manufacturer WHERE manufacturer_id='$manufacturer_id'");
      $db->next_record();
      $manufacturer_name = $db->f("mf_name");
      


   ?>
   <tr class="Stil1">
      <td><?php echo $my_qty ?></td>
      <td><?php $dboi->p("product_name")?> <?php echo ($dboi->f("product_attribute")? ' ('.$dboi->f("product_attribute").')' : ''); ?></td>
          <td><?php echo $manufacturer_name ?></td>

      <td><?php echo $ps_product->get_field($dboi->f("product_id"), "product_sku")?></td>
      <td><?php echo $my_price ?></td>
      <td><?php echo $CURRENCY_DISPLAY->getFullValue($my_subtotal, '', $db->f('order_currency'))?></td>
   </tr>
   <?php
}
?> 

$db->query( "SELECT manufacturer_id FROM #__{vm}_product_mf_xref WHERE product_id='".$dboi->f("product_id")."'");
      $db->next_record();
      $manufacturer_id = $db->f("manufacturer_id");

      $db->query( "SELECT manufacturer_id, mf_name, mf_desc FROM #__{vm}_manufacturer WHERE manufacturer_id='$manufacturer_id'");
      $db->next_record();
      $manufacturer_name = $db->f("mf_name");