if (tep_not_null($products[$field])) {
$result = tep_get_translation($products[$field]);
${$field} = $result['translation'];
if (tep_not_null($HTTP_GET_VARS['products_id'])) {
echo $result['page'];
die;
}
} else {
${$field} = '';
}
}
$products_text = $products_name;
$products_model = $products['products_model'];
$authors_name = tep_transliterate($products['authors_name']);
$manufacturers_name = tep_transliterate($products['manufacturers_name']);
$series_name = tep_transliterate($products['series_name']);
if (tep_not_null($products_model)) {
$products_text .= ' ISBN ' . $products_model;
}
if (strlen($authors_name) > 2) {
$products_text .= ' by ' . $authors_name;
}
// if (strlen($manufacturers_name) > 2) $products_text .= ' publisher ' . $manufacturers_name;
// if (strlen($series_name) > 2) $products_text .= ' serie ' . $series_name;
$products_text = strip_tags(strtolower(html_entity_decode($products_text)));
$products_text = str_replace(array('«', '»', '+', '"', '/', '.', ',', '(', ')', '{', '}', '[', ']', '!', '?', '*', ';', '\'', '—', '_', ' - ', ':', '#', '\\', '|', '`', '~', '$', '^'), ' ', $products_text);
$products_text = trim(preg_replace('/\\s+/', ' ', $products_text));
$sql = "insert ignore into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, products_name, products_description, products_text, language_id) values ('" . (int) $products_id . "', '" . tep_db_input($products_name) . "', '" . tep_db_input($products_description) . "', ' " . tep_db_input($products_text) . " ', '1')";
tep_db_query($sql);
}
}
function tep_get_full_product_info($products_id)
{
global $languages_id, $all_categories, $currency, $currencies, $HTTP_GET_VARS, $categories_audio, $for, $customer_discount;
$products = tep_db_query_fetch_array("SELECT * FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . (int) $products_id . "'");
if (DEFAULT_LANGUAGE_ID == $languages_id) {
$product_info = tep_db_query_fetch_array("SELECT * FROM " . TABLE_PRODUCTS_INFO . " WHERE products_id = '" . (int) $products['products_id'] . "'");
$product_info = array_merge($product_info, $products);
$product_info['products_url'] = HTTP_SERVER . $product_info['products_url'];
} else {
//Добавление перевода
$product_info_query = tep_db_query("\n\t\t\tSELECT products_name, \n\t\t\tproducts_description \n\t\t\tFROM " . TABLE_PRODUCTS_DESCRIPTION . " \n\t\t\tWHERE products_id = '" . (int) $products['products_id'] . "' \n\t\t\tAND language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$product_info = tep_db_fetch_array($product_info_query);
if (DEFAULT_LANGUAGE_ID == 1) {
$product_ru_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT products_name, \n\t\t\t\tproducts_description \n\t\t\t\tFROM " . TABLE_PRODUCTS_DESCRIPTION . " \n\t\t\t\tWHERE products_id = '" . (int) $products['products_id'] . "' \n\t\t\t\tAND language_id = '" . (int) $languages_id . "'");
$product_ru_name = tep_transliterate($product_ru_info['products_name']);
if ($product_info['products_name'] != $product_ru_info['products_name'] && $product_info['products_name'] != $product_ru_name) {
$product_info['products_name'] .= (tep_not_null($product_info['products_name']) ? ' / ' : '') . $product_ru_name;
}
}
$author_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT authors_name \n\t\t\t\tFROM " . TABLE_AUTHORS . " \n\t\t\t\tWHERE authors_id = '" . (int) $products['authors_id'] . "' \n\t\t\t\tAND language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
if (!is_array($author_info)) {
$author_info = array();
}
$serie_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT series_name \n\t\t\t\tFROM " . TABLE_SERIES . " \n\t\t\t\tWHERE series_id = '" . (int) $products['series_id'] . "' \n\t\t\t\tAND language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
if (!is_array($serie_info)) {
$serie_info = array();
}
$manufacturer_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT manufacturers_name \n\t\t\t\tFROM " . TABLE_MANUFACTURERS_INFO . " \n\t\t\t\tWHERE manufacturers_id = '" . (int) $products['manufacturers_id'] . "' \n\t\t\t\tAND languages_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
if (!is_array($manufacturer_info)) {
$manufacturer_info = array();
}
$product_info['products_width'] = '';
$product_info['products_height'] = '';
$product_info['products_width_height_measure'] = '';
$product_format_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT products_formats_name \n\t\t\t\tFROM " . TABLE_PRODUCTS_FORMATS . " \n\t\t\t\tWHERE products_formats_id = '" . (int) $products['products_formats_id'] . "'");
if (!is_array($product_format_info)) {
$product_format_info = array();
}
if (tep_not_null($product_format_info['products_formats_name'])) {
$product_format = $product_format_info['products_formats_name'];
list($product_format) = explode(' ', $product_format);
list($product_format) = explode('/', $product_format);
if (preg_match('/^(\\d+)x(\\d+)$/i', $product_format, $regs)) {
$product_info['products_width'] = $regs[1];
$product_info['products_height'] = $regs[1];
$product_info['products_width_height_measure'] = 'mm';
}
}
$product_cover_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT products_covers_name \n\t\t\t\tFROM " . TABLE_PRODUCTS_COVERS . " \n\t\t\t\tWHERE products_covers_id = '" . (int) $products['products_covers_id'] . "' \n\t\t\t\tAND language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
if (!is_array($product_cover_info)) {
$product_cover_info = array();
}
$product_type_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT products_types_name \n\t\t\t\tFROM " . TABLE_PRODUCTS_TYPES . " \n\t\t\t\tWHERE products_types_id = '" . (int) $products['products_types_id'] . "' \n\t\t\t\tAND language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
if (!is_array($product_type_info)) {
$product_type_info = array();
}
$category_info = tep_db_query_fetch_array("\n\t\t\t\tSELECT categories_id \n\t\t\t\tFROM " . TABLE_PRODUCTS_TO_CATEGORIES . " \n\t\t\t\tWHERE products_id = '" . (int) $products['products_id'] . "' \n\t\t\t\tORDER BY categories_id DESC \n\t\t\t\tLIMIT 1");
if (!is_array($category_info)) {
$category_info = array();
}
$product_info = array_merge($product_info, $products, $author_info, $serie_info, $manufacturer_info, $product_format_info, $product_cover_info, $category_info);
$product_info['products_url'] = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL', false);
}
if ($customer_discount['type'] == 'purchase' && $products['products_purchase_cost'] > 0) {
$product_info['products_price'] = $products['products_purchase_cost'] * (1 + $customer_discount['value'] / 100);
}
if (mb_strpos($product_info['products_description'], '<table', 0, 'CP1251') !== false) {
$product_info['products_description'] = mb_substr($product_info['products_description'], 0, mb_strpos($product_info['products_description'], '<table', 0, 'CP1251'), 'CP1251');
}
$short_description = trim(preg_replace('/\\s+/', ' ', preg_replace('/<\\/?[^>]+>/', ' ', $product_info['products_description'])));
$product_info['products_description'] = $short_description;
$product_info['products_description_short'] = $short_description;
if (!in_array($currency, array('RUR', 'EUR', 'USD', 'UAH'))) {
$product_info['products_currency'] = 'RUR';
$product_info['products_price'] = str_replace(',', '.', round($product_info['products_price'], $currencies->get_decimal_places($product_info['products_currency'])));
} else {
$product_info['products_currency'] = str_replace('RUB', 'RUR', DEFAULT_CURRENCY);
$product_info['products_price'] = str_replace(',', '.', round($product_info['products_price'] * $currencies->get_value($product_info['products_currency']), $currencies->get_decimal_places($product_info['products_currency'])));
}
if (tep_not_null($product_info['products_image'])) {
$product_info['products_image_big'] = 'http://85.236.24.26/big/' . $product_info['products_image'];
$product_info['products_image'] = 'http://85.236.24.26/thumbs/' . $product_info['products_image'];
}
$product_info['products_buy'] = tep_href_link(FILENAME_SHOPPING_CART, 'action=buy_now&product_id=' . $product_info['products_id'], 'NONSSL', false);
$product_info['products_quantity'] = '';
$product_info['is_audio'] = false;
if (in_array($product_info['categories_id'], $categories_audio)) {
$product_info['is_audio'] = true;
}
if (ALLOW_SHOW_AVAILABLE_IN == 'true' && tep_not_null($HTTP_GET_VARS['limit']) || SHOP_ID == 4) {
//пусто
} elseif ($product_info['products_listing_status'] == 1) {
$product_info['products_available_in'] = 1;
} else {
$product_info['products_available_in'] = 10;
}
reset($product_info);
while (list($k, $v) = each($product_info)) {
$v = str_replace($from1, $to, str_replace($from, $to, $v));
if (in_array($k, array('products_name', 'products_description'))) {
$v = preg_replace('/\\s{2,}/', ' ', preg_replace('/[^_\\/\\w\\d\\#\\&(\\)\\-\\[\\]\\.",;]/', ' ', $v));
}
$product_info[$k] = htmlspecialchars(strip_tags(tep_html_entity_decode($v)), ENT_QUOTES);
}
return $product_info;
}
$check = tep_db_fetch_array($check_query);
if ($check['total'] == 0) {
reset($fields);
$products_name = '';
$products_description = '';
while (list(, $field) = each($fields)) {
if (tep_not_null($products[$field])) {
${$field} = tep_get_translation($products[$field]);
} else {
${$field} = '';
}
}
$products_text = $products_name;
$products_model = $products['products_model'];
$authors_name = tep_transliterate($products['authors_name']);
$manufacturers_name = tep_transliterate($products['manufacturers_name']);
$product_serie_info_query = tep_db_query("select series_id from " . TABLE_PRODUCTS . " where products_id = '" . (int) $products_id . "'");
$product_serie_info = tep_db_fetch_array($product_serie_info_query);
$serie_info_query = tep_db_query("select series_name from " . TABLE_SERIES . " where series_id = '" . (int) $product_serie_info['series_id'] . "' and language_id = '1'");
$serie_info = tep_db_fetch_array($serie_info_query);
$series_name = $serie_info['series_name'];
if (tep_not_null($products_model)) {
$products_text .= ' ISBN ' . $products_model;
}
if (strlen($authors_name) > 2) {
$products_text .= ' by ' . $authors_name;
}
if (strlen($manufacturers_name) > 2) {
$products_text .= ' publisher ' . $manufacturers_name;
}
if (strlen($series_name) > 2) {
}
}
$serie_info_query = tep_db_query("select series_name from " . TABLE_SERIES . " where series_id = '" . (int) $product_info['series_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$serie_info = tep_db_fetch_array($serie_info_query);
if (!is_array($serie_info)) {
$serie_info = array();
}
$author_info_query = tep_db_query("select authors_name from authors where authors_id = '" . (int) $product_info['authors_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$author_info = tep_db_fetch_array($author_info_query);
if (!is_array($author_info)) {
$author_info = array();
}
$product_info = array_merge($product_info, $product_description_info, $product_description_en_info, $manufacturer_info, $serie_info, $author_info);
if (DEFAULT_LANGUAGE_ID == 1) {
$product_info['products_name'] .= ' / ' . (tep_not_null($product_info['products_en_name']) ? $product_info['products_en_name'] : tep_transliterate($product_info['products_name']));
$product_info['products_short_description'] = tep_not_null($product_info['products_en_short_description']) ? $product_info['products_en_short_description'] : tep_transliterate($product_info['products_short_description']);
}
reset($product_info);
while (list($k, $v) = each($product_info)) {
while (strpos($v, "\\'") !== false) {
$v = str_replace("\\'", "'", $v);
}
while (strpos($v, '\\"') !== false) {
$v = str_replace('\\"', '"', $v);
}
$product_info[$k] = $v;
}
$special_text = '';
if (basename(PHP_SELF) != FILENAME_SHOPPING_CART) {
$special_types_query = tep_db_query("select distinct specials_types_id from " . TABLE_SPECIALS . " where products_id = '" . (int) $product_info['products_id'] . "' and specials_date_added >= '" . tep_db_input($min_specials_date_added) . " 00:00:00'");
while ($special_types = tep_db_fetch_array($special_types_query)) {
function tep_get_full_product_info($products_id, $pricelist_type = 'csv')
{
global $languages_id, $all_categories, $currency, $currencies, $HTTP_GET_VARS, $categories_audio, $for, $customer_discount;
$products_query = tep_db_query("select * from " . TABLE_PRODUCTS . " where products_id = '" . (int) $products_id . "'");
$products = tep_db_fetch_array($products_query);
if (DEFAULT_LANGUAGE_ID == $languages_id) {
$product_info_query = tep_db_query("select * from " . TABLE_PRODUCTS_INFO . " where products_id = '" . (int) $products['products_id'] . "'");
$product_info = tep_db_fetch_array($product_info_query);
$product_info = array_merge($product_info, $products);
$product_info['products_url'] = HTTP_SERVER . $product_info['products_url'];
} else {
$product_info_query = tep_db_query("select products_name, products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $products['products_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$product_info = tep_db_fetch_array($product_info_query);
if (DEFAULT_LANGUAGE_ID == 1) {
$product_ru_info_query = tep_db_query("select products_name, products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $products['products_id'] . "' and language_id = '" . (int) $languages_id . "'");
$product_ru_info = tep_db_fetch_array($product_ru_info_query);
$product_ru_name = tep_transliterate($product_ru_info['products_name']);
if ($product_info['products_name'] != $product_ru_info['products_name'] && $product_info['products_name'] != $product_ru_name) {
$product_info['products_name'] .= (tep_not_null($product_info['products_name']) ? ' / ' : '') . $product_ru_name;
}
}
$author_info_query = tep_db_query("select authors_name from " . TABLE_AUTHORS . " where authors_id = '" . (int) $products['authors_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$author_info = tep_db_fetch_array($author_info_query);
if (!is_array($author_info)) {
$author_info = array();
}
$serie_info_query = tep_db_query("select series_name from " . TABLE_SERIES . " where series_id = '" . (int) $products['series_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$serie_info = tep_db_fetch_array($serie_info_query);
if (!is_array($serie_info)) {
$serie_info = array();
}
$manufacturer_info_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int) $products['manufacturers_id'] . "' and languages_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$manufacturer_info = tep_db_fetch_array($manufacturer_info_query);
if (!is_array($manufacturer_info)) {
$manufacturer_info = array();
}
$product_info['products_width'] = '';
$product_info['products_height'] = '';
$product_info['products_width_height_measure'] = '';
$product_format_info_query = tep_db_query("select products_formats_name from " . TABLE_PRODUCTS_FORMATS . " where products_formats_id = '" . (int) $products['products_formats_id'] . "'");
$product_format_info = tep_db_fetch_array($product_format_info_query);
if (!is_array($product_format_info)) {
$product_format_info = array();
}
if (tep_not_null($product_format_info['products_formats_name'])) {
$product_format = $product_format_info['products_formats_name'];
list($product_format) = explode(' ', $product_format);
list($product_format) = explode('/', $product_format);
if (preg_match('/^(\\d+)x(\\d+)$/i', $product_format, $regs)) {
$product_info['products_width'] = $regs[1];
$product_info['products_height'] = $regs[1];
$product_info['products_width_height_measure'] = 'mm';
}
}
$product_cover_info_query = tep_db_query("select products_covers_name from " . TABLE_PRODUCTS_COVERS . " where products_covers_id = '" . (int) $products['products_covers_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$product_cover_info = tep_db_fetch_array($product_cover_info_query);
if (!is_array($product_cover_info)) {
$product_cover_info = array();
}
$product_type_info_query = tep_db_query("select products_types_name from " . TABLE_PRODUCTS_TYPES . " where products_types_id = '" . (int) $products['products_types_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$product_type_info = tep_db_fetch_array($product_type_info_query);
if (!is_array($product_type_info)) {
$product_type_info = array();
}
$category_info_query = tep_db_query("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int) $products['products_id'] . "' order by categories_id desc limit 1");
$category_info = tep_db_fetch_array($category_info_query);
if (!is_array($category_info)) {
$category_info = array();
}
$product_info = array_merge($product_info, $products, $author_info, $serie_info, $manufacturer_info, $product_format_info, $product_cover_info, $category_info);
$product_info['products_url'] = tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL', false);
}
if ($customer_discount['type'] == 'purchase' && $products['products_purchase_cost'] > 0) {
$product_info['products_price'] = $products['products_purchase_cost'] * (1 + $customer_discount['value'] / 100);
}
if (mb_strpos($product_info['products_description'], '<table', 0, 'CP1251') !== false) {
$product_info['products_description'] = mb_substr($product_info['products_description'], 0, mb_strpos($product_info['products_description'], '<table', 0, 'CP1251'), 'CP1251');
}
$short_description = trim(preg_replace('/\\s+/', ' ', preg_replace('/<\\/?[^>]+>/', ' ', $product_info['products_description'])));
$product_info['products_description'] = $short_description;
$product_info['products_description_short'] = $short_description;
if ($pricelist_type == 'csv') {
if ($for == 'shopmania' || $for == 'nur_kz') {
if ($for == 'nur_kz') {
$categories_delimiter = ' | ';
} else {
$categories_delimiter = ' > ';
}
if (!in_array($product_info['categories_id'], array_keys($all_categories))) {
$parent_categories = array($product_info['categories_id']);
tep_get_parents($parent_categories, $product_info['categories_id']);
$parent_categories = array_reverse($parent_categories);
$categories_names = array_map('tep_get_category_name', $parent_categories);
$category_tree_string = implode($categories_delimiter, $categories_names);
$all_categories[$category_info['categories_id']] = $category_tree_string;
} else {
$category_tree_string = $all_categories[$category_info['categories_id']];
}
// list($product_info['categories_name']) = explode(' > ', $category_tree_string);
$product_info['categories_name'] = $product_info['products_types_name'] . $categories_delimiter . $category_tree_string;
}
if ($for == 'amazon_uk') {
$product_info['products_currency'] = 'GBP';
} else {
$product_info['products_currency'] = DEFAULT_CURRENCY;
}
if (strpos($for, 'amazon') !== false) {
$product_info['products_price'] = str_replace(',', '.', sprintf("%01.2f", round($product_info['products_cost'] * 1.8 * $currencies->get_value($product_info['products_currency']), 1) + 1.2));
$product_info['products_weight'] = str_replace(',', '.', round($product_info['products_weight'], 2));
$product_info['products_model'] = preg_replace('/[^\\dX]/', '', $product_info['products_model']);
if (strlen($product_info['products_name']) > 500) {
$product_info['products_name'] = substr($product_info['products_name'], 0, 500);
}
if ($product_info['authors_name'] == '') {
$product_info['authors_name'] = 'unknown';
}
} elseif ($for == 'ebay') {
if (tep_not_null($product_info['authors_name'])) {
$product_info['products_name'] .= ' by ' . $product_info['authors_name'];
}
$product_info['products_price'] = str_replace(',', '.', round($product_info['products_price'] * $currencies->get_value($product_info['products_currency']), $currencies->get_decimal_places($product_info['products_currency'])));
$product_info['products_model'] = preg_replace('/[^\\dX]/', '', $product_info['products_model']);
} else {
$product_info['products_price'] = str_replace('.', ',', round($product_info['products_price'] * $currencies->get_value($product_info['products_currency']), $currencies->get_decimal_places($product_info['products_currency'])));
}
} else {
if (!in_array($currency, array('RUR', 'EUR', 'USD', 'UAH'))) {
$product_info['products_currency'] = 'RUR';
$product_info['products_price'] = str_replace(',', '.', round($product_info['products_price'], $currencies->get_decimal_places($product_info['products_currency'])));
} else {
$product_info['products_currency'] = str_replace('RUB', 'RUR', DEFAULT_CURRENCY);
$product_info['products_price'] = str_replace(',', '.', round($product_info['products_price'] * $currencies->get_value($product_info['products_currency']), $currencies->get_decimal_places($product_info['products_currency'])));
}
}
if (tep_not_null($product_info['products_image'])) {
// $product_info['products_image_big'] = tep_href_link(DIR_WS_IMAGES . 'big/' . $product_info['products_image'], '', 'NONSSL', false);
$product_info['products_image_big'] = 'http://85.236.24.26/big/' . $product_info['products_image'];
if (strpos($for, 'amazon') !== false || $for == 'ebay') {
$product_info['products_image'] = $product_info['products_image_big'];
} else {
// $product_info['products_image'] = tep_href_link(DIR_WS_IMAGES . 'thumbs/' . $product_info['products_image'], '', 'NONSSL', false);
$product_info['products_image'] = 'http://85.236.24.26/thumbs/' . $product_info['products_image'];
// $product_info['products_image'] = str_replace(HTTP_SERVER, 'http://images.setbook.ru', $product_info['products_image']);
}
}
$product_info['products_buy'] = tep_href_link(FILENAME_SHOPPING_CART, 'action=buy_now&product_id=' . $product_info['products_id'], 'NONSSL', false);
$product_info['products_quantity'] = '';
$product_info['is_audio'] = false;
if (in_array($product_info['categories_id'], $categories_audio)) {
$product_info['is_audio'] = true;
}
if (ALLOW_SHOW_AVAILABLE_IN == 'true' && tep_not_null($HTTP_GET_VARS['limit']) || SHOP_ID == 4) {
} elseif ($product_info['products_listing_status'] == 1) {
$product_info['products_available_in'] = 1;
} else {
$product_info['products_available_in'] = 10;
}
reset($product_info);
while (list($k, $v) = each($product_info)) {
$v = str_replace($from1, $to, str_replace($from, $to, $v));
if (in_array($k, array('products_name', 'products_description'))) {
$v = preg_replace('/\\s{2,}/', ' ', preg_replace('/[^_\\/\\w\\d\\#\\&(\\)\\-\\[\\]\\.",;]/', ' ', $v));
}
if ($pricelist_type == 'csv') {
$product_info[$k] = strip_tags(tep_html_entity_decode($v));
} else {
$product_info[$k] = htmlspecialchars(strip_tags(tep_html_entity_decode($v)), ENT_QUOTES);
}
}
// print_r($product_info); die;
return $product_info;
}
$authors_name = tep_transliterate($authors['authors_name']);
$check_query = tep_db_query("select count(*) as total from " . TABLE_AUTHORS . " where authors_id = '" . (int) $authors_id . "' and language_id = '" . (int) $lang_id . "'");
$check = tep_db_fetch_array($check_query);
if ($check['total'] == 0) {
$authors_description = '';
reset($fields);
while (list(, $field) = each($fields)) {
if (tep_not_null($authors[$field])) {
${$field} = tep_get_translation($authors[$field]);
} else {
${$field} = '';
}
}
$letter_query = tep_db_query("select authors_letter from " . TABLE_AUTHORS . " where authors_id = '" . (int) $authors_id . "' and language_id = '" . (int) $languages_id . "'");
$letter = tep_db_fetch_array($letter_query);
$sql = "replace into " . TABLE_AUTHORS . " (authors_id, authors_code, authors_letter, authors_name, authors_description, language_id, authors_image, authors_status, authors_path, sort_order, date_added, last_modified) select authors_id, authors_code, '" . tep_db_input(tep_transliterate($letter['authors_letter'])) . "', '" . tep_db_input($authors_name) . "', '" . tep_db_input($authors_description) . "', '" . (int) $lang_id . "', authors_image, authors_status, authors_path, sort_order, date_added, last_modified from " . TABLE_AUTHORS . " where authors_id = '" . (int) $authors_id . "' and language_id = '" . (int) $languages_id . "'";
tep_db_query($sql);
}
$content_type = 'author';
$content_id = $authors_id;
$check_query = tep_db_query("select count(*) as total from " . TABLE_METATAGS . " where language_id = '" . (int) $lang_id . "' and content_type = '" . tep_db_input($content_type) . "' and content_id = '" . (int) $content_id . "'");
$check = tep_db_fetch_array($check_query);
if ($check['total'] == 0) {
$metatags_page_title = $common_array[$lang_code]['authors'] . '. ' . $authors_name . (substr($authors_name, -1) != '.' ? '.' : '') . ' ' . $common_array[$lang_code]['bookshop'] . ' Setbook.';
$metatags_title = $authors_name;
$metatags_keywords = $authors_name;
$metatags_description = $common_array[$lang_code]['authors'] . '. ' . $authors_name . (substr($authors_name, -1) != '.' ? '.' : '');
tep_db_query("replace into " . TABLE_METATAGS . " (metatags_page_title, metatags_title, metatags_keywords, metatags_description, language_id, content_type, content_id) values ('" . tep_db_input($metatags_page_title) . "', '" . tep_db_input($metatags_title) . "', '" . tep_db_input($metatags_keywords) . "', '" . tep_db_input($metatags_description) . "', '" . (int) $lang_id . "', '" . tep_db_input($content_type) . "', '" . (int) $content_id . "')");
}
}
}
function get_products()
{
global $languages_id;
$this->get_customer_discount();
if (!is_array($this->contents)) {
return false;
}
$max_available_in = 0;
$products_array = array();
reset($this->contents);
while (list($products_id, ) = each($this->contents)) {
$products_query = tep_db_query("select * from " . TABLE_PRODUCTS . " where products_id = '" . (int) $products_id . "'");
if ($products = tep_db_fetch_array($products_query)) {
$product_description_info_query = tep_db_query("select products_name, products_description, manufacturers_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $products_id . "' and language_id = '" . (int) $languages_id . "'");
$product_description_info = tep_db_fetch_array($product_description_info_query);
if (!is_array($product_description_info)) {
$product_description_info = array();
}
if (DEFAULT_LANGUAGE_ID == 1) {
$product_description_en_info_query = tep_db_query("select products_name, products_description, manufacturers_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $products_id . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "' and products_name <> ''");
$product_description_en_info = tep_db_fetch_array($product_description_en_info_query);
if (!is_array($product_description_en_info)) {
$product_description_en_info = array();
}
if (tep_not_null($product_description_en_info['products_name'])) {
$product_description_info['products_name'] = $product_description_en_info['products_name'];
} else {
$product_description_info['products_name'] = tep_transliterate($product_description_info['products_name']);
}
if (tep_not_null($product_description_en_info['products_description'])) {
$product_description_info['products_description'] = $product_description_en_info['products_description'];
} else {
$product_description_info['products_description'] = tep_transliterate($product_description_info['products_description']);
}
}
$manufacturers_name = $product_description_info['manufacturers_name'];
if ($products['products_types_id'] == 1) {
$manufacturer_info_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int) $products['manufacturers_id'] . "' and languages_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$manufacturer_info = tep_db_fetch_array($manufacturer_info_query);
$manufacturers_name = $manufacturer_info['manufacturers_name'];
}
$author_info_query = tep_db_query("select authors_name from " . TABLE_AUTHORS . " where authors_id = '" . (int) $products['authors_id'] . "' and language_id = '" . (int) DEFAULT_LANGUAGE_ID . "'");
$author_info = tep_db_fetch_array($author_info_query);
if (!is_array($author_info)) {
$author_info = array();
}
$products = array_merge($products, $product_description_info, $author_info);
$prid = $products['products_id'];
$products_price = $products['products_price'];
$specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int) $prid . "' and status = '1' and specials_new_products_price > '0' order by specials_date_added desc limit 1");
if (tep_db_num_rows($specials_query)) {
$specials = tep_db_fetch_array($specials_query);
$products_price = $specials['specials_new_products_price'];
} elseif ($this->customer_discount['type'] == 'purchase' && $products['products_purchase_cost'] > 0) {
$products_price = $products['products_purchase_cost'] * (1 + $this->customer_discount['value'] / 100);
}
$products_tax = tep_get_tax_rate($products['products_tax_class_id']);
$products_array[] = array('id' => $products_id, 'name' => (tep_not_null($products['authors_name']) ? $products['authors_name'] . ': ' : '') . $products['products_name'], 'description' => $products['products_description'], 'model' => $products['products_model'], 'code' => $products['products_code'], 'image' => $products['products_image'], 'manufacturer' => $manufacturers_name, 'year' => $products['products_year'], 'type' => $products['products_types_id'], 'periodicity' => $products['products_periodicity'], 'periodicity_min' => $products['products_periodicity_min'], 'available_in' => $products['products_available_in'], 'pack' => $products['products_pack'], 'price' => $products_price, 'filename' => $products['products_filename'], 'quantity' => $this->contents[$products_id]['qty'], 'weight' => $products['products_weight'], 'warranty' => $products['products_warranty'], 'final_price' => tep_add_tax($products_price, $products_tax), 'tax_class_id' => $products['products_tax_class_id']);
if ($products['products_available_in'] > 0 && $products['products_available_in'] > $max_available_in) {
$max_available_in = $products['products_available_in'];
}
}
}
$this->info['delivery_transfer'] = $max_available_in;
return $products_array;
}
