Contributions

- Zip file contains 1 file, "/admin/articles_xsell.php". In version 1.57_3 this file will only work with REGISTER_GLOBALS on. Overwrite your current articles_xsell.php with the one attached.

This is not a full package.

The support thread is at
http://forums.oscommerce.com/index.php?showtopic=68866

IF you have more than one oscommerce using one database you may encounter problems adding products to your articles in 'articles_xsell.php'

Solution: about line 200 change:
"$query = "[...] TABLE_PRODUCTS_DESCRIPTION . " pd, products_to_categories p2c where p2c.categories_id=[...] ";"

into:
"$query = "[...] TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p2c.categories_id=[...] ";"

products_to_categories --into--> " . TABLE_PRODUCTS_TO_CATEGORIES . "

Although it looks similar it makes difference.
Thanks for great contribution.
File added: THIS TEXT ONLY

- Added an all topics page
- Added a submit articles page
- Added code to admin/articles_xsell.php to prevent having to login when updating
- Removed references to the HTMLArea. In future releases, the code for that will be removed altogether.


This is a full package.

The support thread is at
http://forums.oscommerce.com/index.php?showtopic=68866

- Added admin/includes/application_top.php files for installation
- Fixed code to display link to RSS page
- Applied mysql 5 fixes to articles.php and articles_new.php files

This is a full package.

The support thread is at
http://forums.oscommerce.com/index.php?showtopic=68866

Hi

This is a FIX at articles_description table

- Added code so the articles would appear in the breadcrumb trail.
- Corrected installation instructions.

This is a full package.

This is a reworked version to allow it to properly work with Header Tags SEO, which is required with this version. The following changes were made:

- Converted much of the code to work with Header Tags SEO. Header Tags SEO is required to use this version.
- Fixed mistakes in the database file
- Added option to automatically check that at least one author exists in admin before allowing an article to be created.
- Removed unnecssay files and database code due to the use of Header Tags SEO.
- Included missing files from earlier versions.

This is a full package.

Hi, I just add italian files, so you can use previosus contribute and simply add italian pages or if you prefer, use this pakage, is full and contains all files uploaded by kustomjs on 19 Aug 2008.

Remember that fckeditor (optional) it's not included in this pakage, but you can find it in contributions here in OsCommerce.

Good work!

I must have forgotten 2 files in there so here is my full rework of this package

here is my full package with all updated information for php5 and MySql 5.XX and for v2.2 RC 2a

this is a fix for php 5 and v2.2 RC 2a

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.

I just noticed also the v1.5.5 package does not also include the redirect fix by "speedman" dated 27 Nov 2006.

A very 2 easy step install and now article manager works great!

The problem was that if you specify a link to another webpage when adding an article, then in the catalog try clicking on the link and the link will not display, it will only go to your index.php instead.

Please download my below fix and the "speedman" redirect fix to have a complete working package!

This contribution is excellent and is a worthy addition to any site! Thanks!

I noticed an error when using a server with PHP 5, within the article review page in the admin.

You would get the function array_merge error on line 148

This is the PHP5 compatible file.

Either copy included file to catalog/admin/ and overwrite old file or manually change the file like below:

#######Manual instruction:

------------->>>>Open Catalog/Admin/article_reviews.php

Find the code around line 148,

$rInfo_array = array_merge($reviews, $articles, $articles_name);

------->>Change to:

$rInfo_array = array_merge((array)$reviews, (array)$articles, (array)$articles_name);




All done!

More osCommerce friendly links for warnings.

I put together some of the patches after 1.5 and installed on a fresh version of OSC. Everything works so I'm publishing it. I didn't include the last xsell file because I wasn't sure where that went, and when placed in my catalog/admin folder, it caused my xsell page to break when adding products.

- When displaying all articles the text below the page count was incorrectly displayed
- When an article has no topic it is not displayed. I created a topic with the id of 0
- Added an rss feed for articles
- MySql5 queries fix for article.php and articles_new.php
- Added extra folder for attaching heading image, tinyMCE anywhere, articles infobox, and dyanmic_sitemap patch
- Now keeps "articles" in breadcrumb and add the topic names afterwards
- Bug fix for articles name in the trail
- Bug fix for style class name in article_listing.php
- MySQL5 fix for includes/box/articles.php

Full Package

Hi for all...
sometimes I don't know if I sleep or not...
I uploaded for 2 times the wrong file... (NOTE: those were removed 2008/03/10)
Now it's the correct file...
see you...

I made a mistake earlier. Here is the proper code. Just overwrite the old code I wrote,

or place this where ever you want the articles to appear.




<?php
//ARTICLE MANAGER START
echo '<ul class="sitemap">';
echo '<li><a href="' . tep_href_link(FILENAME_ARTICLES, '',

'NONSSL') . '">' . BOX_ALL_ARTICLES . '</a></li>' . "";
$topics_query = tep_db_query("select t.topics_id, td.topics_name, t.parent_id from " .

TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where t.parent_id = '" . (int)

$topic_links[$i] . "' and t.topics_id = td.topics_id and td.language_id = '" . (int)

$languages_id . "' order by sort_order, td.topics_name");
if (tep_db_num_rows($topics_query) > 0) {
$row = 0;
while ($topics = tep_db_fetch_array($topics_query)) {
$row++;
echo '<li><a href="' . tep_href_link(FILENAME_ARTICLES, 'tPath=' . $topics['topics_id'])

. '">' . $topics['topics_name'] . '</a></li>' . "";
}
}
echo '</ul>';
//ARTICLE MANAGER END
?>

This update fixes one file that is located as the includes/box/articles.php file. The reason for the MySQL incompatibility is that the existing LEFT JOIN syntax was missing the proper parenthesis that must now be in place in order to parse the SQL string in the correct order of precendence.

find line 73 in modules/article_listing.php
<td class="smalltext" ...
change to <td class="smallText" ...

bug is sensible for Firefox users.
No files to upload

Fixed the bug to allow this block to be used on the sites with multiple languages.

Just drop the file in your includes/boxes directory and include it in your column_right.php like this:
require(DIR_WS_BOXES . 'articles_lastN.php');

Or if you want to go fancy and display it only on certain pages (e.g. anywhere else but the articles themselves) do it this way

if ((isset($HTTP_GET_VARS['articles_id'])) || ($_SERVER['PHP_SELF'] == '/articles.php') || (sizeof($HTTP_GET_VARS) < 1)){
require(DIR_WS_BOXES . 'articles.php');
}
else {
require(DIR_WS_BOXES . 'articles_lastN.php');
}

Enjoy

To Fix the bug in the name of the news to the breadcrumb trail:
When you select an other language than English, it shows english title if existing , if not = nothing.



In application_top.php, change this :

CODE
// add the articles name to the breadcrumb trail
if (isset($HTTP_GET_VARS['articles_id'])) {
$article_query = tep_db_query("select articles_name from " . TABLE_ARTICLES_DESCRIPTION . " where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "'");
if (tep_db_num_rows($article_query)) {
$article = tep_db_fetch_array($article_query);
if (isset($HTTP_GET_VARS['authors_id'])) {
$breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'authors_id=' . $HTTP_GET_VARS['authors_id'] . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
} else {
$breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'tPath=' . $tPath . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
}
}
}


By this :

CODE
// add the articles name to the breadcrumb trail
if (isset($HTTP_GET_VARS['articles_id'])) {
$article_query = tep_db_query("select articles_name from " . TABLE_ARTICLES_DESCRIPTION . " where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and language_id = '" . (int)$languages_id . "'");
if (tep_db_num_rows($article_query)) {
$article = tep_db_fetch_array($article_query);
if (isset($HTTP_GET_VARS['authors_id'])) {
$breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'authors_id=' . $HTTP_GET_VARS['authors_id'] . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
} else {
$breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'tPath=' . $tPath . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
}
}
}

Displays the last n number of articles, specifically the titles and a short description. Note: this is to be saved as an infobox (includes/boxes) and called via <? require(DIR_WS_BOXES . 'articles_lastN.php'); ?>

To avoid redundancy and display this infobox only on the pages other then articles.php (or any page for that matter) you can use the following trick:

<?
if ((isset($HTTP_GET_VARS['articles_id'])) || ($_SERVER['PHP_SELF'] == '/articles.php')){
require(DIR_WS_BOXES . 'articles.php');
}
else {
require(DIR_WS_BOXES . 'articles_lastN.php');
}
?>

Example can be seen at http://www.PetsReady.com (right column)

Simply add this to catalog/dynamic_sitemap.php where ever you want it to appear.






<?php
//ARTICLE MANAGER START
echo '<ul class="sitemap">';
echo '<li><a href="' . tep_href_link(FILENAME_ARTICLES, '',

'NONSSL') . '">' . BOX_ALL_ARTICLES . '</a></li>' . "";
$topics_query = tep_db_query("select t.topics_id, td.topics_name, t.parent_id from " .

TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where t.parent_id = '" . (int)

$topic_links[$i] . "' and t.topics_id = td.topics_id and td.language_id = '" . (int)

$languages_id . "' order by sort_order, td.topics_name");
if (tep_db_num_rows($topics_query) > 0) {
$row = 0;
while ($topics = tep_db_fetch_array($topics_query)) {
$row++;
echo '<li><a href="' . tep_href_link(FILENAME_ARTICLES, 'topics_id=' . $topics

['topics_id']) . '">' . $topics['topics_name'] . '</a></li>' . "";
}
}
echo '</ul>';
//ARTICLE MANAGER END
?>

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

This is only the 2 files that had problems with queries with MySql5: article.php and articles_new.php

Replace these files or best, use a file compare program to merge the changes.

For users of tinyMCE Anywhere (contribution 4852), here are the 2 files to replace in catalog/admin to have tinyMCE as wysiwyg editor for your articles and authors.

TinyMCE Anywhere must be installed separately.

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.

This "contrib" allows you to attach heading images to the articles listing.

working demo:
<a href="http://www.anrodiszlec.hu/articles.php/tPath/1">http://www.anrodiszlec.hu/articles.php/tPath/1</a>

I found that on the catalog/articles.php file - on line 143 there is the following:

<td><?php include(DIR_WS_MODULES . FILENAME_NEW_ARTICLES); ?></td>

and in the filenames.php file - the following

define('FILENAME_NEW_ARTICLES', 'new_articles.php');

that file is not included in the package below.

there is a articles_new.php file but not a new_articles.php file

Could someone please if there is a file - post it. thx :)

Nothing to download - empty file

Sorry, I forgot to include the admin side of v1.5, now it is. articles_pxsell module is also corrected.

Full package

Small mistake found in includes/modules/pxsell.php that gives a mySql error in product info, in some cases. Please update your v1.5 with this file.

- Use of only 1 file to generate the articles listing (new, all, topic), makes life easier than modifying 3 places to get same design.

- Article description would not display if author not set. Corrected.

- Added possibility to link (xsell) from product to article, not only from article to product. This is a new box to place on product_info page.

There's a bug on redirect function on article_info.php.
On the previous package if you choice to diplay also a web page related to article it will be not available.
Now all works fine

Bug Fix Notes

The previous version would only count the number of reviews, regardless of language. If e.g. a customer visited the site in French and the article had one review in English, then the count would be "1" but the article reviews page would be empty (as no review in French is available)

The bug fix adds the condition to count number of reviews in current language only. "Read Review button" is only displayed if reviews in current language are available.

THIS IS A BUG FIX ONLY (not complete package)

I thought it would be a great idea to have a category drop down box, so I have made this add-on for the article manager.

simple to install. Remember to backup!

Version 1.4 (12 july 06) by Gnidhal
minor update
- articles_xsell.php updated with <?php in place to <? (thanks dwdonline)
- SQL scripts in french and english modified with reorder (configuration) and add a FCKeditor option
WARNING : this package don't include FCK editor and YOU HAVE TO INSTALL IT FROM ANOTHER CONTRIBUTION
However : if you don't active this option all the contribution will run correctly with or not HTML Area (like before).
- Minor debug to hide "date added" and "author" in Articles display if they are designed as non-display in configuration panel
****************************
Note : if you just want to update your installation, you can use only the first part of the sql script about the configuration section
and replace :
* admin/articles_xsell.php
* admin/articles.php
* admin/authors.php
* catalog/articles.php
* catalog/article_info.php

I just updated the <? to <?php in articles_xsell.php as the other does not work on many configurations.

This is the complete package.

Full package.
- Version 1.3 include a french translation (admin with sql and catalog )
- sql queries are now mysql5 compatibles
- and somes minors modifications
This update include the article_xsell.php updated by teniemi

enjoy...

Cross-selling was impossible when store had tens of thousands of products. This updates the articles_xsell.php only. It now includes categories when selecting products.

If you get this message:

Call to undefined function: clean_html_comments() etc etc,

simply add

require(DIR_WS_FUNCTIONS . 'clean_html_comments.php');

into your catalog/application_top.php file.

Seeing as I wasn't the only one having this problem, I thought I'd post the solution directly here.

Credit goes to the guys at phpfreaks.com where I found this solution in a post there.

Please download the version 1.2 from post below.

add to /catalog/includes/languages/german.php before the EndOf File ?>

// Article Manager
define('BOX_HEADING_ARTICLES', 'Artikel');
define('BOX_ALL_ARTICLES', 'Alle Artikel');
define('BOX_NEW_ARTICLES', 'Neue Artikel');
define('TEXT_DISPLAY_NUMBER_OF_ARTICLES', '<b>%d</b> to <b>%d</b> (of <b>%d</b> Artikel)');
define('TEXT_DISPLAY_NUMBER_OF_ARTICLES_NEW', '<b>%d</b> to <b>%d</b> (of <b>%d</b> neue Artikel)');
define('TABLE_HEADING_AUTHOR', 'Autor');
define('TABLE_HEADING_ABSTRACT', 'Zusammenfassung');
define('BOX_HEADING_AUTHORS', 'Artikel nach Autor');
define('NAVBAR_TITLE_DEFAULT', 'Artikel');

You have to replace this:

$topics_string .= tep_href_link(FILENAME_ARTICLES, $tPath_new) . '">';

( arround line 28 )

Not this.

Look for (around line 35):
$topics_string .= $tree[$counter]['name'];



Installation instructions:

Open catalogincludesboxesarticles.php

Look for (around line 35):
$topics_string .= $tree[$counter]['name'];

Replace with:
// START: Links to topics with single article go directly to the article
$articles_id_query = tep_db_query("select att.articles_id from " . TABLE_ARTICLES_TO_TOPICS . " att where att.topics_id = '" . (int)$counter . "'");
$articles_id = tep_db_fetch_array($articles_id_query);
$articles_id_url = 'articles_id=' . $articles_id[articles_id];

$articles_in_topic_count = tep_count_articles_in_topic($counter);

if ($articles_in_topic_count == 1 ) {
$topics_string .= tep_href_link(FILENAME_ARTICLE_INFO, $articles_id_url) . '">';
} else {
$topics_string .= tep_href_link(FILENAME_ARTICLES, $tPath_new) . '">';
}
// END: Links to topics with single article go directly to the article



That's it.

This is a mod to Article Manager v1.2b by Rob Anderson. I haven't tested it with other versions, but it's so small that I'd guess it's compatible with most.

Many people have asked in the main forum thread how they can link to articles directly from the top level, rather than put them into topics and sub-topics which require the customer to click twice to get to the actual article text. I've seen various solutions suggested and used, some of which involve substantial modifications to the original code. This mod addresses that need, and has the advantage of only making one small modificiation to the info-box file, so you can easily take advantage of future updates.

One interesting use for Article Manager with this mod, is as a replacement for the standard "Information" info-box (Shipping & Returns, Privacy, Contact Us, etc). This lets you more easily add to the original 4 categories, in a way that may be more natural to your customers who don't need to visually hunt through two arbitrary categories to look for a subject that interests them.

To use: Create a topic with the name you want to appear in the info-box. Create an article (probably with the same name) inside that topic. The info-box link will now point to that article. If you later decide to create a 2nd article within the topic, the link reverts to the article list as normal.

This package contains the update only, as I don't feel entitled to modify the original code. Last complete package is available below, dated 11 June 2004.

These are the German files for Article Manager V1.2b
As I use the English Admin interface, only the language files in the catalog section are included.

Change the following file:

In includes/languages/german.php add the following:

// Article Manager V1.2b
define('BOX_HEADING_ARTICLES', 'Artikel');
define('BOX_ALL_ARTICLES', 'Alle Artikel');
define('BOX_NEW_ARTICLES', 'Neue Artikel');
define('TEXT_DISPLAY_NUMBER_OF_ARTICLES', 'Anzeige von <b>%d</b> bis <b>%d</b> (von insgesamt <b>%d</b> Artikeln)');
define('TEXT_DISPLAY_NUMBER_OF_ARTICLES_NEW', 'Anzeige von <b>%d</b> bis <b>%d</b> (von insgesamt <b>%d</b> neuen Artikeln)');
define('TABLE_HEADING_AUTHOR', 'Autor');
define('TABLE_HEADING_ABSTRACT', 'Zusammenfassung');
define('BOX_HEADING_AUTHORS', 'Artikel dieses Autors');
define('NAVBAR_TITLE_DEFAULT', 'Artikel');

Best regards,
Mark Horne
MinkgLove.com

I'm sorry, in the /catalog/admin/includes/languages/espanol/articles_xsell.php is a typo error: change this line:
define('TEXT_LINK_SORT_PRODUCTS', '<a href="%s">Haz click aqu%iacute;</a> para ordenar los productos asociados con esta noticia.<br><small>Nota: esto es necesario siempre que un producto es añadido o borrado.</small>');

With this:
define('TEXT_LINK_SORT_PRODUCTS', '<a href="%s">Haz click aquí</a> para ordenar los productos asociados con esta noticia.<br><small>Nota: esto es necesario siempre que un producto es añadido o borrado.</small>');



The download package is corrected.

In the zip is the full package.
Images and files and are translated.
Also the instrauctions are modified to install the spanish files in their correct directories.

/****SPANISH****/
He traducido la parte catalogo y la parte de administración, además de las imagenes y la instruciones para que todo quede en castellano. Algunas cosas han sido dificiles porque en castellano podrían conducir a errores de comprension, p.ej: article lo he traducido como noticia en lugar de artículo por no confundirlo con un producto.
No soy ningún experto en idiomas así que si alguien se anima a mejorarlo invito a que lo suba como contribución. Gracias

- Bug fix to article_manager_sql.txt database query so that the "split into pages" bar is displayed when all articles do not fit in one page (changed PREV_NEXT_BAR_LOCATION to ARTICLE_PREV_NEXT_BAR_LOCATION)

This is a complete release with the following changes:

- Bug fix to catalog/articles.php to eliminate "Division by zero" error in sub-sub-topic pages
- Bug fix to catalog/articles.php to remove obsolete reference to topic image
- Bug fix to admin/includes/functions/articles.php to enable the deletion of topics containing articles
- Updated installation instructions

Thanks to Jiten (Unified) and Salvo for these suggestions

Note: If you have installed Version 1.1, you DO NOT need to reinstall. Simply follow the instructions in the following posts to fix these minor bugs:

http://forums.oscommerce.com/index.php?showtopic=68866&view=findpost&p=270346

and

http://forums.oscommerce.com/index.php?showtopic=68866&view=findpost&p=271235

This is a complete release with the following changes:

- Bug fix to article_info.php to display article if no author assigned
- Full tell_a_friend.php file and associated language file included to simplify installation
- Updated installation instructions

Thanks to Dave (daithi) for these suggestions.

Note: If you have installed Version 1.0, you DO NOT need to reinstall. Simply follow the instructions in the following post to fix a minor bug:

http://forums.oscommerce.com/index.php?showtopic=68866&view=findpost&p=269972

Screen captures of Article Manager v1.0.

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