function smn_get_header_tag_products_title($product_id) { global $languages_id, $_GET; $product_header_tags = smn_db_query("select products_head_title_tag from " . TABLE_PRODUCTS_DESCRIPTION . " where language_id = '" . (int) $languages_id . "' and products_id = '" . (int) $_GET['products_id'] . "'"); $product_header_tags_values = smn_db_fetch_array($product_header_tags); return clean_html_comments($product_header_tags_values['products_head_title_tag']); }
function tep_get_header_tag_articles_title($article_id) { global $languages_id, $_GET; $article_header_tags = tep_db_query("select articles_head_title_tag from " . TABLE_ARTICLES_DESCRIPTION . " where language_id = '" . (int) $languages_id . "' and articles_id = '" . (int) $_GET['articles_id'] . "'"); $article_header_tags_values = tep_db_fetch_array($article_header_tags); return clean_html_comments($article_header_tags_values['articles_head_title_tag']); }
if (HEAD_DESC_TAG_SPECIALS != '') { if (HTDA_SPECIALS_ON == '1') { $the_desc = HEAD_DESC_TAG_SPECIALS . ' ' . HEAD_DESC_TAG_ALL; } else { $the_desc = HEAD_DESC_TAG_SPECIALS; } } else { $the_desc = HEAD_DESC_TAG_ALL; } if (HEAD_KEY_TAG_SPECIALS == '') { // Build a list of ALL specials product names to put in keywords $new = smn_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "' and s.status = '1' order by s.specials_date_added DESC "); $row = 0; $the_specials = ''; while ($new_values = smn_db_fetch_array($new)) { $the_specials .= clean_html_comments($new_values['products_name']) . ', '; } if (HTKA_SPECIALS_ON == '1') { $the_key_words = $the_specials . ' ' . HEAD_KEY_TAG_ALL; } else { $the_key_words = $the_specials; } } else { $the_key_words = HEAD_KEY_TAG_SPECIALS . ' ' . HEAD_KEY_TAG_ALL; } if (HEAD_TITLE_TAG_SPECIALS != '') { if (HTTA_SPECIALS_ON == '1') { $the_title = HEAD_TITLE_TAG_SPECIALS . ' - ' . HEAD_TITLE_TAG_ALL; } else { $the_title = HEAD_TITLE_TAG_SPECIALS; }
} else { $the_desc = HEAD_DESC_TAG_ARTICLES_NEW; } } else { $the_desc = NAVBAR_TITLE . '. ' . HEAD_DESC_TAG_ALL; } if (HEAD_KEY_TAG_ARTICLES_NEW == '') { // Build a list of ALL new article names to put in keywords $articles_new_array = array(); $articles_new_query_raw = "select ad.articles_name from " . TABLE_ARTICLES . " a left join " . TABLE_AUTHORS . " au on (a.authors_id = au.authors_id), " . TABLE_ARTICLES_DESCRIPTION . " ad where a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int) $languages_id . "' order by a.articles_date_added DESC, ad.articles_name"; $articles_new_split = new splitPageResults($articles_new_query_raw, MAX_NEW_ARTICLES_PER_PAGE); $articles_new_query = tep_db_query($articles_new_split->sql_query); $row = 0; $the_new_articles = ''; while ($articles_new = tep_db_fetch_array($articles_new_query)) { $the_new_articles .= clean_html_comments($articles_new['articles_name']) . ', '; } if (HTKA_ARTICLES_NEW_ON == '1') { $the_key_words = NAVBAR_TITLE . ', ' . $the_new_articles . ', ' . HEAD_KEY_TAG_ALL; } else { $the_key_words = NAVBAR_TITLE . ', ' . $the_new_articles; } } else { $the_key_words = HEAD_KEY_TAG_ARTICLES_NEW . ', ' . HEAD_KEY_TAG_ALL; } if (HEAD_TITLE_TAG_ARTICLES_NEW != '') { if (HTTA_ARTICLES_NEW_ON == '1') { $the_title = HEAD_TITLE_TAG_ALL . ' - ' . HEAD_TITLE_TAG_ARTICLES_NEW; } else { $the_title = HEAD_TITLE_TAG_ARTICLES_NEW; }
if (DISPLAY_TOPIC_ARTICLE_LISTING == 'true') { ?> <td valign="top" class="main" width="25%" nowrap><?php echo TEXT_TOPIC . ' ' . $articles_expected['topics_name']; ?> </td> <?php } ?> </tr> <?php if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true') { ?> <tr> <td class="main" style="padding-left:15px"><?php echo clean_html_comments(substr($articles_expected['articles_head_desc_tag'], 0, MAX_ARTICLE_ABSTRACT_LENGTH)) . (strlen($articles_expected['articles_head_desc_tag']) >= MAX_ARTICLE_ABSTRACT_LENGTH ? '...' : ''); ?> </td> </tr> <?php } ?> <tr> <td class="smallText" style="padding-left:15px"><?php echo TEXT_DATE_EXPECTED . ' ' . tep_date_long($articles_expected['date_expected']); ?> </td> </tr> <?php if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true' || DISPLAY_DATE_ADDED_ARTICLE_LISTING) { ?>