Community Add-Ons

Bug fixes for Newsdesk 1.49 for Oscommerce2.2rc1

I had the following issues with catalog/newsdesk_index.php:

Drop down would appear even when there are no categories.
You could select the 'SELECT' option sending you to a blank page.
If you clicked on 'search' with nothing in the box, you would get an error.

Attached is an updated version of catalog/newsdesk_index.php. It does not have the stunami bug fix as I never saw any error.

Also attached is a version of catalog/admin/newsdesk.php with FCKeditor instead of html_editor, I think it gives a much better interface, if your going to use this you must install

FCKeditor http://addons.oscommerce.com/info/2900, its an easy install.
I did have to modify the page layout as FCK needs more width.

Aqui explico cómo añador RSS a NEWSDESK.

Explicado de manera sencilla y clara.

Nada de archivos redundantes.

http://www.oscommerce.com/community/contributions,5906

Managed to geth the database updated and validated the code with http://feedvalidator.org/check.cgi?url=

Puthe the 2 files in the root directory and link to them with http://www.yourdomain.com/rss.php

Another update this time I have added a link to the rss title which will take visitoes to the article

I have got a bit further with the rss feeds. Now I have added a stylesheet to the RSS. <br><br>Place both files in the root directory and open rss.php and change the urls to your domain name. I would advise not to open rss.xsl file? If you do not have a good text editor you may unknowingly corrupt it then it will not work for you. <br><br>The next job will be to get multiple database tables accessible to the call for data.

ok its a bit crude but I have now added the database which will give a working RSS list to build on.

include("includes/application_top.php");
header("Content-Type: text/xml");

$gmtdiff = date("O", time());
$gmtstr = substr($gmtdiff, 0, 3) . ":" . substr($gmtdiff, 3, 9);
$now = date("m-d-Y H:i:s", time());
$now = $now . $gmtstr;

echo "<?xml version="1.0" encoding="iso-8859-1"?>n";
echo "<rss version="2.0">n";
echo "<channel>n";
echo "<title>RSS Newsfeeds</title>n";
echo "<link>http://www.yourdomain.com/</link>n";
echo "<description>description</description>n";
echo "<date>".$now."</date>nn";
echo "<updatePeriod>hourly</updatePeriod>n";
echo "<updateFrequency>1</updateFrequency>n";
echo "<updateBase>".$now."</updateBase>nn";


$result = mysql_query("SELECT * FROM newsdesk_description");
while ( $row = mysql_fetch_array($result) ) {
$ndid=$row["newsdesk_id"];
$ndlanguageid=$row["language_id"];
$ndarticlename=$row["newsdesk_article_name"];
$ndarticledescription=$row["newsdesk_article_description"];
$ndshorttext=$row["newsdesk_article_shorttext"];
$ndarticleurl=$row["newsdesk_article_url"];
$ndarticlurlename=$row["newsdesk_article_url_name"];
$ndarticleviewed=$row["newsdesk_article_viewed"];
$ndimagetext=$row["newsdesk_image_text"];
$ndimagetexttwo=$row["newsdesk_image_text_two"];
$ndimagetextthree=$row["newsdesk_image_text_three"];


echo "<item>n";
echo "<title>".$ndarticlename."</title>n";
echo "<link>http://www.yourdomain.com/newsdesk_info.php?newsdesk_id=$ndid</link>n";
echo "<description>$ndshorttext</description>n";
echo "<guid isPermaLink="false">sales@yourdomain.com</guid>n";
echo "<subject>".$ndshorttext."</subject>n";
echo "<date>".$ndadded."</date>n";
echo "<creator>Posted by</creator>n";
echo "</item>nn";

}

echo " </channel>n";
echo "</rss>n";

To help with the RSS, here is the template to start with, need someone to add the database stuff to call for the articles.

header("Content-Type: text/xml");

$gmtdiff = date("O", time());
$gmtstr = substr($gmtdiff, 0, 3) . ":" . substr($gmtdiff, 3, 9);
$now = date("m-d-Y H:i:s", time());
$now = $now . $gmtstr;

echo "<?xml version="1.0" encoding="iso-8859-1"?>n";
echo "<rss version="2.0">n";
echo "<channel>n";
echo "<title>RSS Newsfeeds</title>n";
echo "<link>http://www.yourdomain.com/</link>n";
echo "<description>description</description>n";
echo "<date>".$now."</date>nn";
echo "<updatePeriod>hourly</updatePeriod>n";
echo "<updateFrequency>1</updateFrequency>n";
echo "<updateBase>".$now."</updateBase>nn";


database{
echo "<item>n";
echo "<title>".$title."</title>n";
echo "<link>http://www.yourdomain.com/newsdesk_info.php?newsdesk_id=</link>n";
echo "<description></description>n";
echo "<guid isPermaLink="false">sales@yourdomain.com</guid>n";
echo "<subject>".$category."</subject>n";
echo "<date>".$date."</date>n";
echo "<creator>Posted by</creator>n";
echo "</item>nn";
}

echo " </channel>n";
echo "</rss>n";

Fixes error message "1054 - Unknown column 'p.newsdesk_id' in 'on clause'" that appears when clicking on any of the news items in the news categories box.

Replace catalog/newsdesk_index.php with attached.

Just a little syntax problem for the French language in the catalog/admin/includes/languages/french/newsdesk_reviews.php. On line 14 find:
define('ENTRY_REVIEW_TEXT', '<small><font color="#ff0000"><b>NOTE:</b></font></small> HTML n'est pas pris en compte''! '); And just remove the two '' before the ! and you're done!!!
Great contrib all credits to the oriinal author(s).

Newsdesk 1.49 full package with
Russian and Ukrenian language in user area
Russian language in admin area
cp1251 codepage

Newsdesk 1.49 &#1087;&#1086;&#1083;&#1085;&#1099;&#1081; &#1087;&#1072;&#1082;&#1077;&#1090;
&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081; &#1080; &#1059;&#1082;&#1088;&#1072;&#1080;&#1085;&#1089;&#1082;&#1080;&#1081; &#1103;&#1079;&#1099;&#1082;&#1080; &#1076;&#1083;&#1103; &#1087;&#1086;&#1089;&#1077;&#1090;&#1080;&#1090;&#1077;&#1083;&#1077;&#1081;
&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081; &#1103;&#1079;&#1099;&#1082; &#1074; &#1072;&#1076;&#1084;&#1080;&#1085;&#1082;&#1077;
&#1050;&#1086;&#1076;&#1080;&#1088;&#1086;&#1074;&#1082;&#1072; cp1251

Newsdesk 1.49 &#1087;&#1086;&#1074;&#1085;&#1080;&#1081; &#1087;&#1072;&#1082;&#1077;&#1090;
&#1056;&#1086;&#1089;&#1110;&#1081;&#1089;&#1100;&#1082;&#1072; &#1110; &#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072; &#1084;&#1086;&#1074;&#1080; &#1076;&#1083;&#1103; &#1074;&#1110;&#1076;&#1074;&#1110;&#1076;&#1091;&#1074;&#1072;&#1095;&#1110;&#1074;
&#1056;&#1086;&#1089;&#1110;&#1081;&#1089;&#1100;&#1082;&#1072; &#1084;&#1086;&#1074;&#1072; &#1074; &#1072;&#1076;&#1084;&#1110;&#1085;&#1082;&#1077;
&#1050;&#1086;&#1076;&#1091;&#1074;&#1072;&#1085;&#1085;&#1103; cp1251

I've taken the recently posted updates and rolled them together into one package. I take no credit for any of the code - all I did was follow the instructions. All credit belongs to the original authors.

If you find that you can only upload one image in the admin section.

In catalog/admin/newsdesk.php ( Unmodified )

Around line 937 change

FROM

// copy image only if modified
$newsdesk_image = tep_get_uploaded_file('newsdesk_image');
$newsdesk_image = tep_get_uploaded_file('newsdesk_image_two');
$newsdesk_image = tep_get_uploaded_file('newsdesk_image_three');


TO

// copy image only if modified
$newsdesk_image = tep_get_uploaded_file('newsdesk_image');
$newsdesk_image_two = tep_get_uploaded_file('newsdesk_image_two');
$newsdesk_image_three = tep_get_uploaded_file('newsdesk_image_three');

###Description
Very simple contribution. Articles written for your site can help generate free search engine traffic, however they work alot better if the title tags correspond. This contri will change the title tag to include the article and category in the following format:
article name: Blue Widget
category: Gadgets
store name: Joe's Toy World
*Title Tag would be: Blue Widget Gadgets Joe's Toy World

I have cleaned up the newsdesk_index.php tags. I was having problems with the display so I went through and cleaned up the extra end tags and properly lined up the tags and braces.

To install just replace the newsdesk_index.php in your catalog directory.

I added a 'Delete' button for each of the three images. The function clears the file and the linked textual descriptions.

Many tnx to Steve aka 241 for this great contribution.
This is full package updated from forum post, so other ppl dont have problems with the fake 1.44 version.
Extra Faq folder include problems that ware soved on forum.

TNX again Steve

Just a minor bug with image

Not a complete package.

www.oscommerce-fr.info

This is the modified version of the contribution newsdesk_v1.48.3 originally created by Carsten.

I have only added M-S functionality and renamed it newsdesk_v1.48.4 with modified install instructions, .sql file, and version changes. The two most notable bugs are listed in the version changes.

just a tiny bug, to fix the image broken link, when the article has no image, in [read more], newsdesk_info.php file, it still displays an image broken link.


how to fix it?
[open file -> newsdesk_info.php]

[find]

if ($product_info_values['newsdesk_image'] != 'Array') {


[replace with ]


if ($product_info_values['newsdesk_image'] != '') {



that's all. :)
(bascially, just delete 'Array',)


OR
replace the file

- added search function
- added more functions to admin WYSIWYG editor
- fixed issues with reviews titles in admin

This is the full package and is based on 2.2MS2 not CVS

This is the complete package.

- added missing back, new category and new news items to Admin side
- added missing accept and reject buttons for reviews (english only)
- updated code and fixed a lot of bugs.
- fixed the I.E.6 crash issue.
- added languages Dutch, French, German and Spanish to catalog and admin.
- added support for more languages (upto 9 at the last count).
- added a sort by date and column to the admin side to help with removal of unwanted articles.
- included the missing new news item image for admin english only.
- added a back button for categories to articles listing.
- added a new define to admin/includes/languages/[language]/newsdesk.php
- Re-Fixed the errors in the sql.
- Ammended part of the code to correct the listing date so that it allways
shows the latest news by date on first load and subsequent pages.

- changed code that was specific to my css setup to the default format

- RSS has yet to be sorted out

*************** Warning WARNING read this first ****************
* *
* This has been written for 2.2MS2 and not for cvs versions. *
* There are function changes and code changes in the cvs versions. *
* These cvs versions will be 2.2MS3 versions not 2.2MS2 versions. *
* *
********************************************************************

The support thread for 2.2MS2 versions not cvs versions is here:

[URL=http://forums.oscommerce.com/index.php?showtopic=92136&st=0]http://forums.oscommerce.com/index.php?showtopic=92136&st=0[/URL]

This is the complete package.

- added missing accept and reject buttons for reviews (english only)
- updated code and fixed a lot of bugs.
- fixed the I.E.6 crash issue.
- added languages Dutch, French, German and Spanish to catalog and admin.
- added support for more languages (upto 9 at the last count).
- added a sort by date and column to the admin side to help with removal of unwanted articles.
- included the missing new news item image for admin english only.
- added a back button for categories to articles listing.
- added a new define to admin/includes/languages/[language]/newsdesk.php
- Re-Fixed the errors in the sql.
- Ammended part of the code to correct the listing date so that it allways
shows the latest news by date on first load and subsequent pages.

- changed code that was specific to my css setup to the default format

- RSS has yet to be sorted out

*************** Warning WARNING read this first ****************
* *
* This has been written for 2.2MS2 and not for cvs versions. *
* There are function changes and code changes in the cvs versions. *
* These cvs versions will be 2.2MS3 versions not 2.2MS2 versions. *
* *
********************************************************************

The support thread for 2.2MS2 versions not cvs versions is here:

[URL=http://forums.oscommerce.com/index.php?showtopic=92136&st=0]http://forums.oscommerce.com/index.php?showtopic=92136&st=0[/URL]

This is just a patch file.


Download "full" version below.

This is just a tar version.

Don't mind the DS_Store files. Just erase them.

It's here!

version 1.4 ::

More fun changes!
- delete image with article (based on a hack from the contribs)
- some minor bug fixes that were reported in the forums
- bbcode bar (based on fusion)
- newline breaks now work
- rss (basically small code changes to a contrib)
- article review approval (based on a hack from the contribs)
- sticky by Emiliano (base code by Emiliano, adjustments and few changes added by me)
- image subtitles by Emiliano (including some of my own code)
- my own bug fixes (now can see image when editing, some massive html restructuring, and such)
- you can turn on/off catagories (sorry, I wasn't able to come up with a more dynamic solution)
- 3 images per article


AND!!! basica intergration with Loaded 5 patch 3 !!!

Many thanks to the folks who reported back with bugs and to Talme and mikimoto for their translations!!

Review System Implemented!

More configuration for the admin area!

Latest News!

control different viewing aspects of your News!
Don't want to show Latest News? No problem!
Check out all those options!!!

This version also takes care of the osC non-image blank browser image hopefully, I added checks into the code so that if no image exists for a catagory or Article nothing will show.

This release includes:

- Backend configuration within the Admin section to configure your news listings. NOTE:: currently only for the article listing page

- Column box that functions exactly like the Catagory box

- Breadcrumb trail to help Navigation

Bug fix!

Made several changes to the catalog/includes/modules/news.php file ::

- Fixed the loopy problem.
- changed the formatting of the news
- proveided a solution to prevent blank images (hopefully)


Adpoted Will Mays configuration sql column (still need to work on a user friendly setting page)

cleaned up some minor code and html.

included an upgrade file

Thanks for all the great feedback and ideas!!!!

cheers

small bug in the catalog/modules/newsdesk.php file.
this file will hopefully fix that.

Just upload over the previous file.

What is it :::
-----------------------------------------------------------------------------
NewsDesk is based on 3 files from the osC system. general.php (I had to change many of the functions to compensate for the different table and
column names). catagories.php and catagory_info.php (These are the grunt files that I changed to run a news system.)

NewsDesk is also based on latest_news by Will Mays <fred@volutin.net>. I had orginally started hacking his script to include images and
languages but I kept having troubles due to my lack of programming skills. I did use some of his ideas, news image button and parts of his
instalation guide.


Features :::
-----------------------------------------------------------------------------
Being based on catagories, you can expect alot!

- News is stored in the database.
- Full Mutlilingual support.
- code is (far as I know) fully osC standardized

- Fits right in on the top page of the site like the "New Products for February" box ;-) NewsDesk was released in February.
- Like lastest_news it won't display news if status is set to "inactive aka red"
- headline, summary, image, [read more] link on top page
- [read more] full content page

- News is full controlled by the admin area which looks and behaves just like the catagories/products section does.
- status setting "red/green" to make articles active and inactive.
- drop down menu to jump to catagory quickly
- searchable news articles
- picture upload
- preview page just in case you flub-up ;-)