}
$sql_query = tep_db_query("SELECT lp.library_id, lf.files_name, lfde.files_descriptive_name, fi.icon_small, lf.files_name \r\n from " . TABLE_LIBRARY_FILES . " lf, \r\n " . TABLE_LIBRARY_FILES_DESCRIPTION . " lfde, \r\n " . TABLE_LIBRARY_PRODUCTS . " lp, \r\n " . TABLE_FILE_ICONS . " fi \r\n WHERE lfde.language_id = '" . $languages_id . "' \r\n and lp.library_id = lf.files_id \r\n and lf.files_id = lfde.files_id \r\n and lf.files_icon = fi.icon_id \r\n and lf.files_status = '1' \r\n and lp.products_id ='" . $current_products_id . "'\r\n ORDER BY lfde.files_descriptive_name");
$num_files_related = tep_db_num_rows($sql_query);
if ($num_files_related > 0) {
$info_box_contents = array();
$info_box_contents[] = array('text' => TEXT_RELATED_FILES);
new contentBoxHeading($info_box_contents);
$info_box_contents = array();
$info_box_contents[0][] = array('align' => 'center', 'params' => 'class="productListing-heading"', 'text' => TEXT_DOWNLOAD_FILE);
$info_box_contents[0][] = array('params' => 'class="productListing-heading"', 'text' => TEXT_MORE_INFO);
$info_box_contents[0][] = array('align' => 'center', 'params' => 'class="productListing-heading"', 'text' => TEXT_FILE_NAME);
require_once DIR_WS_CLASSES . FILENAME_DOWNLOAD;
$download = new download();
$n = 0;
while ($listing_array = tep_db_fetch_array($sql_query)) {
$download->process($listing_array['library_id'], $_SESSION['customer_id']);
$download_criteria = $download->file_content;
if ($n / 2 == floor($n / 2)) {
$info_box_contents[] = array('params' => 'class="productListing-odd"');
} else {
$info_box_contents[] = array('params' => 'class="productListing-even"');
}
$cur_row = sizeof($info_box_contents) - 1;
$info_box_contents[$cur_row][] = array('params' => 'class="productListing-data"', 'text' => $download_criteria);
$info_box_contents[$cur_row][] = array('params' => 'class="productListing-data"', 'text' => '<a href="' . tep_href_link(FILENAME_FILE_DETAIL, 'file_id=' . $listing_array['library_id']) . '">' . $listing_array['files_descriptive_name'] . '</a>');
$info_box_contents[$cur_row][] = array('params' => 'class="productListing-data"', 'text' => '<a href="' . tep_href_link(FILENAME_FILE_DETAIL, 'file_id=' . $listing_array['library_id']) . '">' . tep_image('images/file_icons/' . $listing_array['icon_small']) . '</a> <a href="' . tep_href_link(FILENAME_FILE_DETAIL, 'file_id=' . $listing_array['library_id']) . '">' . $listing_array['files_name'] . '</a>');
$n++;
}
new contentBox($info_box_contents, true, true);
if (TEMPLATE_INCLUDE_CONTENT_FOOTER == 'true') {
$info_box_contents = array();
