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) {
?>
