News & Article Management [Support]

[HaIzI72G3T]

urgh iv did a huge mistake i forgot to back up mysql database and the installment sql included had errors and now my whole database is messed up..

is there a way i could unstall those sql querys? am really not experinced with sql and i dont wish to lose my work ..

Sidebox_Ticker_v1.000
Sidebox_Scroller_v1.000
News_Articles_Management_v2.110

i wish to unstall those sql querys
this is the sql installation i had

# Configuration
INSERT INTO configuration_group VALUES ('', 'News & Articles Management', 'The options which configure News & Articles Management', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
INSERT INTO configuration VALUES ('', 'Display News Summary', 'DISPLAY_NEWS_SUMMARY', 'true', 'Display the news summary on the main index page (part of the optional install)?', last_insert_id(), '0', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'News Summary Cutoff Days', 'DISPLAY_NEWS_SUMMARY_DAYS', '7', 'Only display the news summary if there was news in the past xx days', last_insert_id(), '1', NULL, now(), NULL, NULL),
('', 'News Summary Length', 'DISPLAY_NEWS_SUMMARY_LENGTH', '300', 'If no news summary is present for the article being displayed by the summary module, truncate the main article content to no more than this number of characters (will truncate at the nearest whole word)', last_insert_id(), '2', NULL, now(), NULL, NULL),
('', 'Comments Require Customer Login', 'NEWS_COMMENTS_REQUIRE_CUSTOMER', 'false', 'Require a user to be logged in to post comments on news articles?', last_insert_id(), '3', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Comments Name Min Length', 'ENTRY_NEWS_NAME_MIN_LENGTH', '3', 'Minimum length for the name input of news comments', last_insert_id(), '4', NULL, now(), NULL, NULL),
('', 'Comments Text Min Length', 'ENTRY_NEWS_COMMENTS_MIN_LENGTH', '25', 'Minimum length for the comments text input of news comments', last_insert_id(), '5', NULL, now(), NULL, NULL),
('', 'Email Admin Comments Notice', 'NEWS_COMMENTS_EMAIL_ADMIN_NOTICE', 'true', 'Email a notification to the store admin when comments are posted?', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'News RSS Feed Days', 'NEWS_RSS_FEED_NUMBER_OF_DAYS', '7', 'The RSS feed will only contain news from the past xx news days', last_insert_id(), '7', NULL, now(), NULL, NULL);

# Table structure for table news_articles
DROP TABLE IF EXISTS news_articles;
CREATE TABLE news_articles (
article_id int(11) NOT NULL auto_increment,
authors_id int(11) NOT NULL default '0',
news_image varchar(64) default NULL,
news_image_two varchar(64) default NULL,
news_date_added datetime NOT NULL default '0000-00-00 00:00:00',
news_last_modified datetime default NULL,
news_date_published datetime default NULL,
news_status tinyint(1) NOT NULL default '0',
sort_order tinyint(6) NOT NULL default '0',
PRIMARY KEY (article_id),
KEY (news_date_published)
) TYPE=MyISAM;

# Table structure for table news_articles_text
DROP TABLE IF EXISTS news_articles_text;
CREATE TABLE news_articles_text (
article_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
news_article_name varchar(64) NOT NULL default '',
news_article_text text,
news_article_shorttext text,
news_article_url varchar(255) default NULL,
news_article_url_text varchar(64) default NULL,
news_article_url_2 varchar(255) default NULL,
news_article_url_2_text varchar(64) default NULL,
news_article_url_3 varchar(255) default NULL,
news_article_url_3_text varchar(64) default NULL,
news_article_url_4 varchar(255) default NULL,
news_article_url_4_text varchar(64) default NULL,
news_article_url_store int(11) default NULL,
news_article_url_store_2 int(11) default NULL,
news_article_url_store_misc varchar(255) default NULL,
news_article_url_store_misc_text varchar(64) default NULL,
news_article_url_store_misc_2 varchar(255) default NULL,
news_article_url_store_misc_2_text varchar(64) default NULL,
news_image_text text,
news_image_text_two text,
PRIMARY KEY (article_id,language_id),
KEY (news_article_name)
) TYPE=MyISAM;

# Table structure for table news_authors
DROP TABLE IF EXISTS news_authors;
CREATE TABLE news_authors (
authors_id int(11) NOT NULL auto_increment,
author_name varchar(64) default NULL,
author_email varchar(96) default NULL,
status int(1) NOT NULL default '1',
PRIMARY KEY (authors_id)
) TYPE=MyISAM;

# Dumping data for table news_authors
INSERT INTO news_authors VALUES (1, 'Administrator', '[email protected]', 1);

# Table structure for table news_comments
DROP TABLE IF EXISTS news_comments;
CREATE TABLE news_comments (
comments_id int(11) NOT NULL auto_increment,
article_id int(11) NOT NULL default '0',
customers_id int(11) default NULL,
customers_name varchar(64) NOT NULL default '',
date_added datetime default NULL,
last_modified datetime default NULL,
approved tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (comments_id)
) TYPE=MyISAM;

# Table structure for table news_comments_description
DROP TABLE IF EXISTS news_comments_description;
CREATE TABLE news_comments_description (
comments_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
comments_subject varchar(64) default NULL,
comments_text text NOT NULL,
PRIMARY KEY (comments_id,language_id)
) TYPE=MyISAM;


Sidebox_Scroller_v1.000
# News Scroller Config
INSERT INTO configuration VALUES ('', 'News Sidebox Scroller Days', 'NEWS_SCROLLER_NUMBER_OF_DAYS', '7', 'The news sidebox scroller will only contain news from the past xx news days', '2504', '100', NULL, now(), NULL, NULL),
('', 'News Sidebox Scroller Height', 'NEWS_SCROLLER_HEIGHT', '250', 'The height of the news sidebox scroller box', '2504', '101', NULL, now(), NULL, NULL),
('', 'News Sidebox Scroller Amount', 'NEWS_SCROLLER_AMOUNT', '2', 'The amount to scroll by', '2504', '102', NULL, now(), NULL, NULL),
('', 'News Sidebox Scroller Delay', 'NEWS_SCROLLER_DELAY', '100', 'The amount of delay when scrolling', '2504', '103', NULL, now(), NULL, NULL);
UPDATE configuration, configuration_group SET configuration.configuration_group_id = configuration_group.configuration_group_id WHERE configuration_group.configuration_group_title = 'News & Articles Management' AND configuration.configuration_group_id = '2504';

and

# Configuration
INSERT INTO configuration_group VALUES ('', 'News & Articles Management', 'The options which configure News & Articles Management', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
INSERT INTO configuration VALUES ('', 'Display News Summary', 'DISPLAY_NEWS_SUMMARY', 'true', 'Display the news summary on the main index page (part of the optional install)?', last_insert_id(), '0', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'News Summary Cutoff Days', 'DISPLAY_NEWS_SUMMARY_DAYS', '7', 'Only display the news summary if there was news in the past xx days', last_insert_id(), '1', NULL, now(), NULL, NULL),
('', 'News Summary Length', 'DISPLAY_NEWS_SUMMARY_LENGTH', '300', 'If no news summary is present for the article being displayed by the summary module, truncate the main article content to no more than this number of characters (will truncate at the nearest whole word)', last_insert_id(), '2', NULL, now(), NULL, NULL),
('', 'Comments Require Customer Login', 'NEWS_COMMENTS_REQUIRE_CUSTOMER', 'false', 'Require a user to be logged in to post comments on news articles?', last_insert_id(), '3', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Comments Name Min Length', 'ENTRY_NEWS_NAME_MIN_LENGTH', '3', 'Minimum length for the name input of news comments', last_insert_id(), '4', NULL, now(), NULL, NULL),
('', 'Comments Text Min Length', 'ENTRY_NEWS_COMMENTS_MIN_LENGTH', '25', 'Minimum length for the comments text input of news comments', last_insert_id(), '5', NULL, now(), NULL, NULL),
('', 'Email Admin Comments Notice', 'NEWS_COMMENTS_EMAIL_ADMIN_NOTICE', 'true', 'Email a notification to the store admin when comments are posted?', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'News RSS Feed Days', 'NEWS_RSS_FEED_NUMBER_OF_DAYS', '7', 'The RSS feed will only contain news from the past xx news days', last_insert_id(), '7', NULL, now(), NULL, NULL);

# Table structure for table news_articles
DROP TABLE IF EXISTS news_articles;
CREATE TABLE news_articles (
article_id int(11) NOT NULL auto_increment,
authors_id int(11) NOT NULL default '0',
news_image varchar(64) default NULL,
news_image_two varchar(64) default NULL,
news_date_added datetime NOT NULL default '0000-00-00 00:00:00',
news_last_modified datetime default NULL,
news_date_published datetime default NULL,
news_status tinyint(1) NOT NULL default '0',
sort_order tinyint(6) NOT NULL default '0',
PRIMARY KEY (article_id),
KEY (news_date_published)
) TYPE=MyISAM;

# Table structure for table news_articles_text
DROP TABLE IF EXISTS news_articles_text;
CREATE TABLE news_articles_text (
article_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
news_article_name varchar(64) NOT NULL default '',
news_article_text text,
news_article_shorttext text,
news_article_url varchar(255) default NULL,
news_article_url_text varchar(64) default NULL,
news_article_url_2 varchar(255) default NULL,
news_article_url_2_text varchar(64) default NULL,
news_article_url_3 varchar(255) default NULL,
news_article_url_3_text varchar(64) default NULL,
news_article_url_4 varchar(255) default NULL,
news_article_url_4_text varchar(64) default NULL,
news_article_url_store int(11) default NULL,
news_article_url_store_2 int(11) default NULL,
news_article_url_store_misc varchar(255) default NULL,
news_article_url_store_misc_text varchar(64) default NULL,
news_article_url_store_misc_2 varchar(255) default NULL,
news_article_url_store_misc_2_text varchar(64) default NULL,
news_image_text text,
news_image_text_two text,
PRIMARY KEY (article_id,language_id),
KEY (news_article_name)
) TYPE=MyISAM;

# Table structure for table news_authors
DROP TABLE IF EXISTS news_authors;
CREATE TABLE news_authors (
authors_id int(11) NOT NULL auto_increment,
author_name varchar(64) default NULL,
author_email varchar(96) default NULL,
status int(1) NOT NULL default '1',
PRIMARY KEY (authors_id)
) TYPE=MyISAM;

# Dumping data for table news_authors
INSERT INTO news_authors VALUES (1, 'Administrator', '[email protected]', 1);

# Table structure for table news_comments
DROP TABLE IF EXISTS news_comments;
CREATE TABLE news_comments (
comments_id int(11) NOT NULL auto_increment,
article_id int(11) NOT NULL default '0',
customers_id int(11) default NULL,
customers_name varchar(64) NOT NULL default '',
date_added datetime default NULL,
last_modified datetime default NULL,
approved tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (comments_id)
) TYPE=MyISAM;

# Table structure for table news_comments_description
DROP TABLE IF EXISTS news_comments_description;
CREATE TABLE news_comments_description (
comments_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
comments_subject varchar(64) default NULL,
comments_text text NOT NULL,
PRIMARY KEY (comments_id,language_id)
) TYPE=MyISAM;

[bunker0]

i have installed this mod and ultimate seo url .

my htaccess include this :

# For dreamscape's News & Articles Manager
RewriteRule ^news/?$ index\.php?main_page=news&%{QUERY_STRING} [L]
RewriteRule ^news/rss.xml$ index\.php?main_page=news_rss&%{QUERY_STRING} [L]
RewriteRule ^news/archive/?$ index\.php?main_page=news_archive&%{QUERY_STRING} [L]
RewriteRule ^news/([0-9]{4})-([0-9]{2})-([0-9]{2}).html$ index\.php?main_page=news&date=$1-$2-$3&%{QUERY_STRING} [L]
RewriteRule ^news/archive/([0-9]{4})-([0-9]{2}).html$ index\.php?main_page=news_archive&date=$1-$2&%{QUERY_STRING} [L]
RewriteRule ^news/(.*)-a-([0-9]+)-comments.html$ index\.php?main_page=news_comments&article_id=$2&%{QUERY_STRING} [L]
RewriteRule ^news/(.*)-a-([0-9]+).html$ index\.php?main_page=news_article&article_id=$2&%{QUERY_STRING} [L] 

but no effect of url .

the other pages / products is - ***.html


my website - www.king-magic.com/

HI! Ive got the same problem.
Added the code to .htaccess and I see no effect. Ive seen on your website that at least the article URLs are friendly.

How did you achieve this?

Regards.

[gazag]

i can't find a solution in this thread - i am trying to make my home page have the news summary on it....

Has anyone got this working????

[bunker0]

i can't find a solution in this thread - i am trying to make my home page have the news summary on it....

Has anyone got this working????

I got is working on http://paladar.es/.


For a fresh Zen Cart Install, copy files from ` _optional_install` to your Zen Cart install.
For all other installs, open your Zen Cart file `includes/templates/template_default/templates/tpl_index_default.php` and place the following code where you would like the news summary module to display: <?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_NEWS_SUMMARY_MODULE)); ?>

regards

[gazag]

I got is working on http://paladar.es/.


For a fresh Zen Cart Install, copy files from ` _optional_install` to your Zen Cart install.
For all other installs, open your Zen Cart file `includes/templates/template_default/templates/tpl_index_default.php` and place the following code where you would like the news summary module to display: <?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_NEWS_SUMMARY_MODULE)); ?>

regards

Have you got any tips - i have installed this on two clean installs. Installed the optional files for showing on home page... And still can't get it to show up!!

I have tried manually inserting

<?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_NEWS_SUMMARY_MODULE)); ?>

into the define_main_page, the tpl_index_default, the index.php and more but still can't get it to work...

Did you have to adjust anything???

All i am trying to do is to get the summary showing on the home page!!

[bunker0]

Have you got any tips - i have installed this on two clean installs. Installed the optional files for showing on home page... And still can't get it to show up!!

I have tried manually inserting into the define_main_page, the tpl_index_default, the index.php and more but still can't get it to work...

Did you have to adjust anything???

All i am trying to do is to get the summary showing on the home page!!

make sure you've copied all needed files...
follow the instruccions...
report errors....


does

<?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_NEWS_SUMMARY_MODULE)); ?>

return anything?

[gazag]

make sure you've copied all needed files...
follow the instruccions...
report errors....


does

<?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_NEWS_SUMMARY_MODULE)); ?>

return anything?

i followed the instructions - it said if it is a clean install of zencart just copy the files so that is what i did - ran the SQL

no errors...

if you go to the news page the info is there but it doesn't show up on the home page.

link to site is www DOT spotlightfunding DOT org/demo

[gazag]

i followed the instructions - it said if it is a clean install of zencart just copy the files so that is what i did - ran the SQL

no errors...

if you go to the news page the info is there but it doesn't show up on the home page.

link to site is www DOT spotlightfunding DOT org/demo

OK I GOT IT

The problem is the tpl_index_Default.php is majorly different to the one i have one a clean install of 1.3.9h so i used my original and just added the line

<?php include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_NEWS_SUMMARY_MODULE)); ?>

Thanks for your help Bunker

[gxjenkins]

Has anyone got this working on version 1.50?

Gary

[Nixdomain]

Installed the RSS Feed and it is not displaying all the information on the feed.
The price, Weight, Quantity, Model, Brand and ID not showing. It only shows the Product name, Picture, Descriptions.
Can someone please help.