$product_name = zen_get_products_name($pr_list->fields['product_id'], $_SESSION['languages_id']);
    ?>
                <td class="dataTableContent"><?php 
    echo $_GET['cid'];
    ?>
</td>
                <td class="dataTableContent" align="center"><?php 
    echo $coupon->fields['coupon_name'];
    ?>
</td>
                <td class="dataTableContent" align="center"><?php 
    echo $pr_list->fields['product_id'];
    ?>
</td>
                <td class="dataTableContent" align="left"><?php 
    echo '<strong>' . $product_name . '</strong><br />' . TEXT_CATEGORY . zen_get_categories_name_from_product($pr_list->fields['product_id']) . '<br />' . TEXT_MANUFACTURER . zen_get_products_manufacturers_name($pr_list->fields['product_id']);
    ?>
</td>
<?php 
    if ($pr_list->fields['coupon_restrict'] == 'N') {
        echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ALLOW) . '</a></td>';
    } else {
        echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_DENY) . '</a></td>';
    }
    if ($pr_list->fields['coupon_restrict'] == 'Y') {
        echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_DENY) . '</a></td>';
    } else {
        echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ALLOW) . '</a></td>';
    }
    echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=remove&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickActionRemove(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icons/delete.gif', IMAGE_REMOVE) . '</a></td>';
    ?>

// This should be first line of the script:
$zco_notifier->notify('NOTIFY_MAIN_TEMPLATE_VARS_START_DOCUMENT_GENERAL_INFO');
$module_show_categories = DOCUMENT_GENERAL_INFO_CATEGORIES;
$sql = "select count(*) as total\n          from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n          where    p.products_status = '1'\n          and      p.products_id = '" . (int) $_GET['products_id'] . "'\n          and      pd.products_id = p.products_id\n          and      pd.language_id = '" . (int) $_SESSION['languages_id'] . "'";
$res = $db->Execute($sql);
if ($res->fields['total'] < 1) {
    $tpl_page_body = '/tpl_product_info_noproduct.php';
} else {
    $tpl_page_body = '/tpl_document_general_info_display.php';
    $sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "\n            set        products_viewed = products_viewed+1\n            where      products_id = '" . (int) $_GET['products_id'] . "'\n            and        language_id = '" . (int) $_SESSION['languages_id'] . "'";
    $res = $db->Execute($sql);
    $sql = "select p.products_id, pd.products_name,\n                  pd.products_description, p.products_model,\n                  p.products_quantity, p.products_image,\n                  pd.products_url, p.products_price,\n                  p.products_tax_class_id, p.products_date_added,\n                  p.products_date_available, p.manufacturers_id, p.products_quantity,\n                  p.products_weight, p.products_priced_by_attribute, p.product_is_free,\n                  p.products_qty_box_status,\n                  p.products_quantity_order_max,\n                  p.products_discount_type, p.products_discount_type_from, p.products_sort_order, p.products_price_sorter\n           from   " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n           where  p.products_status = '1'\n           and    p.products_id = '" . (int) $_GET['products_id'] . "'\n           and    pd.products_id = p.products_id\n           and    pd.language_id = '" . (int) $_SESSION['languages_id'] . "'";
    $product_info = $db->Execute($sql);
    $products_price_sorter = $product_info->fields['products_price_sorter'];
    $products_price = $currencies->display_price($product_info->fields['products_price'], zen_get_tax_rate($product_info->fields['products_tax_class_id']));
    $manufacturers_name = zen_get_products_manufacturers_name((int) $_GET['products_id']);
    if ($new_price = zen_get_products_special_price($product_info->fields['products_id'])) {
        $specials_price = $currencies->display_price($new_price, zen_get_tax_rate($product_info->fields['products_tax_class_id']));
    }
    // set flag for attributes module usage:
    $flag_show_weight_attrib_for_this_prod_type = SHOW_DOCUMENT_GENERAL_INFO_WEIGHT_ATTRIBUTES;
    // get attributes
    require DIR_WS_MODULES . zen_get_module_directory(FILENAME_ATTRIBUTES);
    // if review must be approved or disabled do not show review
    $review_status = " and r.status = '1'";
    $reviews_query = "select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd\n                       where r.products_id = '" . (int) $_GET['products_id'] . "'\n                       and r.reviews_id = rd.reviews_id\n                       and rd.languages_id = '" . (int) $_SESSION['languages_id'] . "'" . $review_status;
    $reviews = $db->Execute($reviews_query);
}
require DIR_WS_MODULES . zen_get_module_directory('product_prev_next.php');
$products_name = $product_info->fields['products_name'];
$products_model = $product_info->fields['products_model'];

 public function exportPrepareFields(array $fields)
 {
     $fields = parent::exportPrepareFields($fields);
     $products_id = $fields['products_id'];
     $tax_class_id = $fields['products_tax_class_id'];
     unset($fields['products_id'], $fields['products_tax_class_id']);
     $default_language_code = $this->first_language_code;
     global $db;
     if ($this->export_language == 'all') {
         $this->debugMessage('Products::exportPrepareFields, language = ' . $this->export_language . ', default language = ' . $default_language_code . ', sql: ' . $this->saved_data['products_description_sql'] . ', languages: ' . print_r($this->languages, true));
         foreach ($this->languages as $language_code => $language_id) {
             if ($language_code != $default_language_code) {
                 $description_info = $db->Execute(sprintf($this->saved_data['products_description_sql'], $products_id, $language_id));
                 if (!$description_info->EOF) {
                     $encoded_fields = $this->exportEncodeData($description_info->fields);
                     foreach ($encoded_fields as $field_name => $field_value) {
                         if ($field_name != 'products_id' && $field_name != 'language_id') {
                             $fields[$field_name . '_' . $language_code] = $field_value;
                         }
                     }
                 }
             }
         }
     }
     $fields['manufacturers_name'] = zen_get_products_manufacturers_name($products_id);
     $tax_class_info = $db->Execute("SELECT tax_class_title FROM " . TABLE_TAX_CLASS . " WHERE tax_class_id = {$tax_class_id} LIMIT 1");
     $fields['tax_class_title'] = $tax_class_info->EOF ? '' : $tax_class_info->fields['tax_class_title'];
     $cPath_array = explode('_', zen_get_product_path($products_id));
     $default_language_id = $this->languages[DEFAULT_LANGUAGE];
     $categories_name = '';
     foreach ($cPath_array as $next_category_id) {
         $category_info = $db->Execute("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = {$next_category_id} AND language_id = {$default_language_id} LIMIT 1");
         $categories_name .= ($category_info->EOF ? self::DBIO_UNKNOWN_VALUE : $category_info->fields['categories_name']) . '^';
     }
     $fields['categories_name'] = $this->exportEncodeData(substr($categories_name, 0, -1));
     return $fields;
 }