$faq_categories_query = tep_db_query("select ic.categories_id, icd.categories_name \r\n from " . TABLE_FAQ_CATEGORIES . " ic, \r\n " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " icd \r\n where icd.categories_id = ic.categories_id \r\n and icd.language_id = '" . (int) $languages_id . "' \r\n and ic.products_group_access like '%" . $customer_group_id . "%'\r\n and ic.categories_status = '1' \r\n order by rand() "); $faq_categories_check = tep_db_num_rows($faq_categories_query); if ($faq_categories_query > 0) { $info_box_contents = array(); $info_box_contents[] = array('text' => TABLE_HEADING_NEW_FAQ); new contentBoxHeading($info_box_contents, tep_href_link(FILENAME_FAQ)); $info_box_contents = array(); $row = 0; $count = 0; while ($faq_categories = tep_db_fetch_array($faq_categories_query)) { if (MAINPAGE_FAQ_SHOW_CATEGORY_FAQ == 'true') { $faq_query = tep_db_query("select ip.faq_id, ip.question \r\n from " . TABLE_FAQ . " ip, \r\n " . TABLE_FAQ_TO_CATEGORIES . " ip2c \r\n where ip.faq_id = ip2c.faq_id \r\n and ip2c.categories_id = '" . $faq_categories['categories_id'] . "' \r\n and ip.products_group_access like '%" . $customer_group_id . "%'\r\n and ip.language = '" . $language . "' \r\n and ip.visible = '1' "); $faq_str = ''; $faq_num = 0; while ($faq = tep_db_fetch_array($faq_query)) { $faq_str .= ' » <a href="' . tep_href_link(FILENAME_FAQ, 'cID=' . (int) $faq_categories['categories_id']) . '#' . $faq['faq_id'] . '">' . cre_clean_html($faq['question']) . '</a><br>'; $faq_num++; if ($faq_num == MAINPAGE_FAQ_NUM_FAQ) { break; } } } $info_box_contents[$row][0] = array('align' => 'left', 'params' => 'class="main" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_FAQ, 'cID=' . (int) $faq_categories['categories_id']) . '"><strong>' . $faq_categories['categories_name'] . '</strong></a><br>' . $faq_str); $count++; $row++; if ($count == MAX_DISPLAY_MODULES_FAQ_CATEGORY) { break; } } new contentBox($info_box_contents, true, true); if (TEMPLATE_INCLUDE_CONTENT_FOOTER == 'true') {
$new_articles_query = tep_db_query("select a.articles_id, \r\n a.articles_date_added, \r\n ad.articles_name, \r\n ad.articles_head_desc_tag, \r\n au.authors_id, \r\n au.authors_name, \r\n td.topics_id, \r\n td.topics_name \r\n from " . TABLE_ARTICLES . " a, \r\n " . TABLE_AUTHORS . " au, \r\n " . TABLE_ARTICLES_DESCRIPTION . " ad, \r\n " . TABLE_ARTICLES_TO_TOPICS . " a2t \r\n left join " . TABLE_TOPICS_DESCRIPTION . " td on(a2t.topics_id = td.topics_id and td.language_id = '" . (int) $languages_id . "') \r\n where a.articles_status = '1' \r\n and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) \r\n and a.authors_id = au.authors_id \r\n and a.articles_id = a2t.articles_id \r\n and a.articles_id = ad.articles_id \r\n and ad.language_id = '" . (int) $languages_id . "' \r\n and a.articles_date_added > SUBDATE(now(), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY) \r\n order by a.articles_date_added desc, ad.articles_name"); $new_articles_check = tep_db_num_rows($new_articles_query); if ($new_articles_check > 0) { include_once DIR_WS_LANGUAGES . $language . '/' . FILENAME_ARTICLES_NEW; $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_ARTICLES, strftime('%B'))); new contentBoxHeading($info_box_contents, tep_href_link(FILENAME_ARTICLES_NEW)); $row = 0; $count = 0; $info_box_contents = array(); while ($new_articles = tep_db_fetch_array($new_articles_query)) { $article_abstract = ''; $article_author = ''; $article_publish = ''; if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true') { $article_abstract = substr(cre_clean_html($new_articles['articles_head_desc_tag']), 0, MAX_ARTICLE_ABSTRACT_LENGTH) . '...<br>'; } if (DISPLAY_AUTHOR_ARTICLE_LISTING == 'true') { $article_author = TEXT_BY . '<a href="' . tep_href_link(FILENAME_ARTICLES, 'authors_id=' . $new_articles['authors_id']) . '">' . $new_articles['authors_name'] . '</a><br>'; } if (DISPLAY_DATE_ADDED_ARTICLE_LISTING == 'true') { $article_publish = TEXT_DATE_ADDED . $new_articles['articles_date_added'] . '<br>'; } $info_box_contents[$row][0] = array('align' => 'left', 'params' => 'class="main" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_ARTICLE_INFO, 'articles_id=' . $new_articles['articles_id']) . '"><span class="pro_list">' . $new_articles['articles_name'] . '</span></a><br>' . $article_author . $article_abstract . $article_publish); if ($new_articles['topics_id'] != '' && DISPLAY_TOPIC_ARTICLE_LISTING == 'true') { $info_box_contents[$row][1] = array('align' => 'left', 'params' => 'class="main" valign="top"', 'text' => TEXT_TOPIC . '<a href="' . tep_href_link(FILENAME_ARTICLES, 'tPath=' . $new_articles['topics_id']) . '">' . $new_articles['topics_name'] . '</a><br>'); } $count++; $row++; if ($count == NEW_ARTICLES_HOMEPAGE_NUMBER_ITEMS) { break;
$cds_homepage_image = ''; $row = 0; $info_box_contents = array(); while ($cds_listing_result = tep_db_fetch_array($cds_listing_query)) { $cds_homepage_id = $cds_listing_result['pages_id']; if (defined('CDS_HOMEPAGE_SHOW_TITLE') && CDS_HOMEPAGE_SHOW_TITLE == 'true') { $cds_homepage_title = '<a href="' . tep_href_link(FILENAME_PAGES, 'pID=' . $cds_homepage_id . '&CDpath=' . cre_get_cds_page_path($cds_homepage_id)) . '"><span class="cds_home_title">' . htmlspecialchars(cre_get_page_title($cds_homepage_id)) . '</span></a><br>'; } if (defined('CDS_HOMEPAGE_SHOW_BLURB') && CDS_HOMEPAGE_SHOW_BLURB == 'true') { $cds_homepage_blurb = '<span class="cds_home_blurb">' . cre_clean_html(cre_get_page_blurb($cds_homepage_id)) . '</span><br>'; } if (defined('CDS_HOMEPAGE_SHOW_THUMB') && CDS_HOMEPAGE_SHOW_THUMB == 'true') { $cds_homepage_image = '<a href="' . tep_href_link(FILENAME_PAGES, 'pID=' . $cds_homepage_id . '&CDpath=' . cre_get_cds_page_path($cds_homepage_id)) . '">' . cre_get_page_thumbnail($cds_homepage_id) . '</a>'; } if (defined('CDS_HOMEPAGE_SHOW_BODY') && CDS_HOMEPAGE_SHOW_BODY == 'true') { $txt_only = trim(cre_clean_html(cre_get_page_body($cds_homepage_id))); if (strlen($txt_only) <= CDS_HOMEPAGE_BODY_COUNT) { $txt_to_use = $txt_only; } else { if (substr($txt_only, CDS_HOMEPAGE_BODY_COUNT, 1) == ' ' || substr($txt_only, CDS_HOMEPAGE_BODY_COUNT, 1) == '.') { // if the next character is a space, no agjustments needed $txt_to_use = substr($txt_only, 0, CDS_HOMEPAGE_BODY_COUNT); } else { $txt_short = substr($txt_only, 0, CDS_HOMEPAGE_BODY_COUNT); // now back up to the last space $pos = strrpos($txt_short, " "); $txt_to_use = substr($txt_short, 0, $pos); } } $cds_homepage_body = '<span class="cds_home_body">' . $txt_to_use . ' <a href="' . tep_href_link(FILENAME_PAGES, 'pID=' . $cds_homepage_id . '&CDpath=' . cre_get_cds_page_path($cds_homepage_id)) . '"><span class="cds_home_readmore">...Read More</span></a></span>'; }