Community Add-Ons

Article Manager v1.0
for osCommerce Online Merchant v2.2

Article Manager is a comprehensive article publishing system written for 2.2MS2. So if you want to offer articles on your

site with the option of cross-selling to your products, then this contribution is a must. It is easy to install and will

require minimal alteration to your existing site. Screen captures are included in a separate download.

Article Manager includes the following features:

- Articles can be stored in multi-leveled topics (use of topics optional)
- New Articles and All Articles lists included
- Article listings include: Article Title, Article Abstract, Author Name, Topic, Expected or Published Date (details can be turned on or off via the admin console)
- Articles accessible from Article and Authors box added to left or right column
- Articles can be assigned to Authors (optional)
- Author details include name and description (can include pictures)
- Optional Topic and Author filters lists available from Articles Info page
- Article Reviews built in, including approval or reviews by admin (use of reviews optional)
- Includes optional Tell a Friend link
- Article cross-selling included so you can associate articles with products in your shop (optional)
- WYSIWYG HTMLArea Editor (MS2 v1.7) built in for editing of Articles and Topic/Author descriptions (optional)
- Supports pre-loading of articles to appear on a certain date (until then they are viewable but not accessible)
- Supports management of Draft and Published article statuses
- Full Header Tags support for article-related meta-tagging
- Breadcrumb support included so Topic path and Article/Author name appear in breadcrumbs
- Full admin console with over 30 different configuration options
- Full multi-language capable (sorry, only English language files included in this version)
- And much, much more!

Note: Header Tags Controller and WYSIWYG HTMLArea Editor (MS2 v1.7) DO NOT need to be installed throughout the rest of your

site.

Bugs and suggestions: http://forums.oscommerce.com/index.php?act=ST&f=7&t=68866

Rob Anderson

Legend:

Download

Report

Expand All / Collapse All

Full Package

Compile with the updated bug contributed chrish123 after package v1.5.5

I found another small bug in catalog article_rss.php ,which prevents the feeds from showing

find (line 39) :

$news_query_raw = tep_db_query("select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, ad.articles_description, au.authors_name, td.topics_name, a2t.topics_id from " . TABLE_ARTICLES . " a left join " . TABLE_AUTHORS . " au using(authors_id), " . TABLE_ARTICLES_DESCRIPTION . " ad, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td using(topics_id) where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name limit". NEWS_RSS_ARTICLE);

Replace with:

$news_query_raw = tep_db_query("select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, ad.articles_description, au.authors_name, td.topics_name, a2t.topics_id from " . TABLE_ARTICLES . " a left join " . TABLE_AUTHORS . " au using(authors_id), " . TABLE_ARTICLES_DESCRIPTION . " ad, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td using(topics_id) where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name limit " . NEWS_RSS_ARTICLE);

This now makes rss feeds work, but I found another bug now I get an error with one article feed that that if it contains "&ndash" in the formatting it will not display!! and will give this error message in IE7:

Reference to undefined entity 'ndash'.

Empty file attached

Please delete double post, I forgot to include the find: data.

This will keep "articles" in breadcrumb and add the topic names afterwards, instead of replacing the "articles" root with the topic name and preventing the user from returning to articles once in the topics.

new format:
catalog >> articles>> topic name
old format:
catalog >> topic name

in applications_top.php
FIND:
// add topic names or the author name to the breadcrumb trail
if (isset($tPath_array)) {
for ($i=0, $n=sizeof($tPath_array); $i<$n; $i++) {
$topics_query = tep_db_query("select topics_name from " . TABLE_TOPICS_DESCRIPTION . " where topics_id = '" . (int)$tPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'");
if (tep_db_num_rows($topics_query) > 0) {
$topics = tep_db_fetch_array($topics_query);
$breadcrumb->add($topics['topics_name'], tep_href_link(FILENAME_ARTICLES, 'tPath=' . implode('_', array_slice($tPath_array, 0, ($i+1)))));
} else {
break;
}
}
} elseif (isset($HTTP_GET_VARS['authors_id'])) {
$authors_query = tep_db_query("select authors_name from " . TABLE_AUTHORS . " where authors_id = '" . (int)$HTTP_GET_VARS['authors_id'] . "'");
if (tep_db_num_rows($authors_query)) {
$authors = tep_db_fetch_array($authors_query);
$breadcrumb->add(NAVBAR_TITLE_DEFAULT, tep_href_link(FILENAME_ARTICLES));
}
}

REPLACE WITH:
// add topic names or the author name to the breadcrumb trail
if (isset($tPath_array)) {
for ($i=0, $n=sizeof($tPath_array); $i<$n; $i++) {
$topics_query = tep_db_query("select topics_name from " . TABLE_TOPICS_DESCRIPTION . " where topics_id = '" . (int)$tPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'");
if (tep_db_num_rows($topics_query) > 0) {
$topics = tep_db_fetch_array($topics_query);
$breadcrumb->add(NAVBAR_TITLE_DEFAULT, tep_href_link(FILENAME_ARTICLES));
$breadcrumb->add($topics['topics_name'], tep_href_link(FILENAME_ARTICLES, 'tPath=' . implode('_', array_slice($tPath_array, 0, ($i+1)))));
} else {
break;
}
}
} elseif (isset($HTTP_GET_VARS['authors_id'])) {
$authors_query = tep_db_query("select authors_name from " . TABLE_AUTHORS . " where authors_id = '" . (int)$HTTP_GET_VARS['authors_id'] . "'");
if (tep_db_num_rows($authors_query)) {
$authors = tep_db_fetch_array($authors_query);
$breadcrumb->add('Articles by ' . $authors['authors_name'], tep_href_link(FILENAME_ARTICLES, 'authors_id=' . $HTTP_GET_VARS['authors_id']));
$breadcrumb->add(NAVBAR_TITLE_DEFAULT, tep_href_link(FILENAME_ARTICLES));
}
}

just this file is included not a full package

I have fixed a couple of minor problems:
1. When displaying all articles the text below the page count was incorrectly displayed
2. When an article has no topic it is not displayed. I created a topic with the id of 0.
3. Also added an rss feed for articles.

The rss feed is heavily based on the News Blog V 1.0 contribution.

1. Add to catalog/includes/languages/english(and any other languages you use)

AFTER:
} elseif ($topic_depth == 'top') {

ADD:
define('TEXT_ARTICLES', 'Below is a list of articles with the most recent ones listed first.');

2. Create a topic for articles in the TOP category. The second SQl Statement needs to be duplicated for any language other than english you are using, replaceing the second VALUE with the id’s of the languages you are using.(look in phpMyAdmin)

Insert into your database via phpMyAdmin:
INSERT INTO topics (topics_id,topics_image, parent_id,sort_order, date_added, last_modified) VALUES (0,NULL, 0, 0, '2007-08-06 08:52:12', NULL);
INSERT INTO topics_description VALUES (0, 1, 'Miscellaneous Articles', 'Miscellaneous', 'Articles that do not fall into a specific category.');
INSERT INTO configuration (configuration_id,configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('', 'Number of articles to display in your RSS Feed.', 'NEWS_RSS_ARTICLE', '10', 'If you want all of your articles to display in the RSS type in something like 2000. The default is 10', '456', '34', now());
INSERT INTO configuration (configuration_id,configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('', 'Number of characters to display in each RSS article.', 'NEWS_RSS_CHARACTERS', '250', 'If you keep this at 250 it will hide a little bit of each of article from your viewers. They will have to come to your store to finish. The default is 250', '456', '35', now());

3. In catalog/includes/filenames.php
ADD:
define('FILENAME_ARTICLE_RSS', 'article_rss.php');

4. UPLOAD:
catalog/article_rss.php
catalog/includes/languages/english(and any other languages you use)/article_rss.php

5. Go to admin->configure->article manager an configure the two new options for rss.

our success? individual commitment to a group effort

Community Add-Ons

Article Manager v1.0for osCommerce Online Merchant v2.2

Article Manager v1.0
for osCommerce Online Merchant v2.2