zen_redirect(zen_href_link(FILENAME_DEFAULT, '', 'SSL')); } } else { $message = true; } break; */ case "news": require_once DIR_WS_FUNCTIONS . 'news.php'; $date_selector = $db->Execute("SELECT news_date_published\n FROM " . TABLE_NEWS_ARTICLES . "\n WHERE news_status = '1'\n AND to_days(news_date_published) <= to_days(now())\n GROUP BY news_date_published DESC\n LIMIT " . (int) NEWS_RSS_FEED_NUMBER_OF_DAYS); while (!$date_selector->EOF) { $article = $db->Execute("SELECT n.article_id, na.author_name, na.author_email, nt.news_article_name, nt.news_article_text, nt.news_article_shorttext, n.news_image, nt.news_image_text, n.news_date_published\n FROM " . TABLE_NEWS_ARTICLES . " n\n LEFT JOIN " . TABLE_NEWS_ARTICLES_TEXT . " nt ON (n.article_id = nt.article_id AND nt.language_id = " . (int) $_SESSION['languages_id'] . "), " . TABLE_NEWS_AUTHORS . " na\n WHERE n.authors_id = na.authors_id\n AND n.news_status = '1'\n AND n.news_date_published = '" . $date_selector->fields['news_date_published'] . "'\n ORDER BY n.sort_order"); while (!$article->EOF) { $xtags = array(); $link = zen_href_link(FILENAME_NEWS_ARTICLE, 'article_id=' . $article->fields['article_id'] . $additionalURL, 'NONSSL', false); $rss->rss_feed_item($article->fields['news_article_name'], $link, array('url' => $link, 'PermaLink' => true), date('r', strtotime($article->fields['news_date_published'])), news_create_news_summary($article->fields['news_article_text'], $article->fields['news_article_shorttext']), $article->fields['news_image'], zen_href_link(FILENAME_NEWS_COMMENTS, 'article_id=' . $article->fields['article_id'] . $additionalURL, 'NONSSL', false), $article->fields['author_name'] . " <" . $article->fields['author_email'] . ">", false, false, $xtags); $article->MoveNext(); } $date_selector->MoveNext(); } break; case "categories": // don't build a tree when no categories $check_categories = $db->Execute("select categories_id from " . TABLE_CATEGORIES . " where categories_status = '1' limit 1"); if ($check_categories->RecordCount() > 0) { if (isset($_GET['cPath'])) { $categories = $db->Execute("SELECT c.categories_id, c.parent_id, GREATEST(c.date_added, IFNULL(c.last_modified, 0)) AS categories_date, c.categories_image, cd.categories_name, cd.categories_description\n FROM " . TABLE_CATEGORIES . " c\n LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id\n WHERE c.parent_id = " . (int) $id_parent . "\n AND cd.language_id = " . (int) $_SESSION['languages_id'] . "\n AND c.categories_status= '1'\n ORDER BY c.sort_order, cd.categories_name", '', false, 150); if (!$categories->EOF) { $link_categories = addslashes(zen_href_link(FILENAME_DEFAULT, 'cPath=' . $cPath . $additionalURL, 'NONSSL', false)); $rss->rss_feed_item($categories->fields['categories_name'], $link_categories, array('url' => $link_categories, 'PermaLink' => true), date('r', strtotime($categories->fields['categories_date'])), $categories->fields['categories_description'], $categories->fields['categories_image'], false, RSS_AUTHOR == '' ? STORE_OWNER_EMAIL_ADDRESS . " <" . STORE_OWNER . ">" : RSS_AUTHOR); if (!isset($_GET['limit']) || (int) $_GET['limit'] > 1) {