Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * - 8 votes

Article Manager v1.0


2085 replies to this topic

#641 gardenho

  • Community Member
  • 12 posts
  • Real Name:Lynne
  • Gender:Female
  • Location:Canada

Posted 08 December 2006, 19:38

View Postrigadin2, on Dec 8 2006, 05:01 AM, said:

Have you modified the database using the file article_manager_sql.txt? It contains the queries to create necessary tables and add configuration parameters.

- Rigadin

I downloaded and installed version 1.5 same day it was uploaded to the contrib area. Everything appears to be working except the following:

I've got the same problem as HelleM except my database name is different of course. I ran the sql file included in version 1.5 twice with no change in the error message at the bottom of each product info page - this is the only place the error messages appear for me. Looks to me like the sql was missing creating a table or something? While I'm getting better at php coding, mysql is over my head java script:emoticon(':)', 'smid_5')
:)

Also wanted to clarify the htmlarea editor - I uploaded the entire folder as instructed but I see no new entry for this editor anywhere in the admin, judging by the number of other users who have asked about this it's an area that needs clarification with this contrib. Is this editor the same as that used for entering products in the catalog, because that is the only editor I seem to have with the same page layout and fields, except with article manager entries I have no field where I can upload an image. I see from the htmlarea folder readme file there are instructions for creating this field. I uploaded the htmlarea folder from article manager version 1.4 since it wasn't included in version 1.5.

I also lost my shopping cart box on product info pages, it was in the right column. I don't know if I lost it after installing this or not though, I didn't notice until today it was missing. I made no changes to column_left or column_right files as instructed in the install file as I am using infobox admin to control boxes. I have the article boxes on the left side so not sure why anything might be affected on the right?

This is truly a fantastic contrib for OsCommerce and all who have contributed deserve big, big thanks!!

#642 rigadin2

  • Community Member
  • 349 posts
  • Real Name:Chris
  • Gender:Male
  • Location:Helsinki/St-Petersburg

Posted 09 December 2006, 19:09

I found a mistake in includes/modules/articles_pxsell.php that gives a mySql error in some cases.
In the query (line 15), the table ARTICLES should in fact be TABLE_ARTICLES. It worked for me but seems that it's not the case for all. Sorry :-"

- Rigadin
STS v4.5 SP5 is out, and check the STS Power Pack contribution too!
New thumbnailer using phpThumb: oscThumb. Works great.

#643 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 10 December 2006, 12:43

It works - the PXSELL update

Just remember to put this in your /yourlanguage/product_info.php:
define('TEXT_PXSELL_ARTICLES', 'Article related to this product:');



One I guess small annoying thing - is in the admin when I preview the article, just before hitting the update button.

Is there any way to make the preview font size equal to the final output????

Helle :-)

#644 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 10 December 2006, 13:21

ehhhhh - was a little fast on the reply just before. On the article_info page the link to the product is gone??
Helle :-(

#645 rcplace

  • Community Member
  • 12 posts
  • Real Name:=-

Posted 12 December 2006, 22:28

Hello,

I have installed the contribution, all seems oke.


But nothing happens when I press "Cross-Sell Actions" on the add/remove button.

question 1
Must I get a list with products?

question 2
In what fill can i thiks it?

question 3,
Is it posible to put images in the artikel, how?

Thanks.

#646 rcplace

  • Community Member
  • 12 posts
  • Real Name:=-

Posted 12 December 2006, 22:29

Hello,

I have installed the contribution, all seems oke.


But nothing happens when I press "Cross-Sell Actions" on the add/remove button.

question 1
Must I get a list with products?

question 2
In what fill can i thiks it?

question 3,
Is it posible to put images in the artikel, how?

Thanks.

#647 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 13 December 2006, 00:39

Hi rcplace

If you already have an editor installed - you should be able to get it to work together med the article manager - I use an older editor Maxi DVD HTML Editor - and that does it. It has image upload etc.

Check your install notes again, you must have missed something - The cross sell works fine. I've just updated to Article Manager 1.5 - no problem

Helle :-)

#648 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 13 December 2006, 00:46

View PostSWSchwartz, on Nov 24 2006, 06:08 PM, said:

I have verified my install 2 times. Here is my store it is a work in progress so dont mind the mess. The issue that I am having is the articles are not showing up when you click on a link in the right column. If you click on the new articles you can see that there are there but when you click you get this. I dont know where to start. Could anyone please help?

Also for some reason it is overridding my stylesheet so that the backround is white not black like the rest of the store

Hi SWSchwartz
I found out, that when I updated to HTC 2.6 - and removed the "old" header tag from all articles pages - the my stylesheet incl. background were fine again

Hope it can help you
Helle :-)

#649 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 13 December 2006, 01:02

View PostHelleM, on Dec 13 2006, 01:46 AM, said:

Hi SWSchwartz
I found out, that when I updated to HTC 2.6 - and removed the "old" header tag from all articles pages - the my stylesheet incl. background were fine again

Hope it can help you
Helle :-)

Another little thing -I like your menu tree - which one is it??

#650 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 13 December 2006, 01:04

View PostHelleM, on Dec 10 2006, 02:21 PM, said:

ehhhhh - was a little fast on the reply just before. On the article_info page the link to the product is gone??
Helle :-(

ehh, has anybody found out how come the link to the article shows fine under the product_info page, but is gone on the article_info page after updating to 1.5?

Helle :blush:

#651 rigadin2

  • Community Member
  • 349 posts
  • Real Name:Chris
  • Gender:Male
  • Location:Helsinki/St-Petersburg

Posted 13 December 2006, 08:59

If articles are displayed in the infobox, but not when clicking the corresponding link, there is a problem with the query in article_info.php and v1.5 should solve it. This is for example the case when there is no author defined for an article.

The xsell from article to product is a box that appears in article_info.php, this box can be found in includes/modules/articles_xsell.php and this file has not been modified since 2003. You should investigate in this file to see why nothing is shown.

- Rigadin
STS v4.5 SP5 is out, and check the STS Power Pack contribution too!
New thumbnailer using phpThumb: oscThumb. Works great.

#652 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 13 December 2006, 18:50

Hi rigadin

The articles_xsell.php is identical with your version? I used WinMerged to compare most of yours/my files - and it seemed there were no differencies??
There is also an author attached to the article!

This is my article_info.php page

<?php
/*
  $Id: article_info.php, v1.0 2003/12/04 12:00:00 ra Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/

  require('includes/application_top.php');

  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ARTICLE_INFO);

  $article_check_query = tep_db_query("SELECT COUNT(*) as total from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_DESCRIPTION . " ad where a.articles_status = '1' and a.articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and ad.articles_id = a.articles_id and ad.language_id = '" . (int)$languages_id . "'");
  $article_check = tep_db_fetch_array($article_check_query);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<?php
// BOF: Header Tag Controller v2.6.0
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
  require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
?> 
  <title><?php echo TITLE; ?></title>
<?php
}
// EOF: Header Tag Controller v2.6.0
?>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<script language="javascript"><!--
function popupWindow(url) {
  window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
ft=150')
}
//--></script>
</head>
<body>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
  <tr>
	<td width="<?php echo BOX_WIDTH_LEFT; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
	</table></td>
<!-- body_text //-->
	<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
  if ($article_check['total'] < 1) {
?>
	  <tr>
		<td class="pageHeading" ><?php echo HEADING_ARTICLE_NOT_FOUND; ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main" ><?php echo TEXT_ARTICLE_NOT_FOUND; ?></td>
	  </tr>
<?php
  } else {
	$article_info_query = tep_db_query("select a.articles_id, a.articles_date_added, a.articles_date_available, a.authors_id, ad.articles_name, ad.articles_description, ad.articles_url, au.authors_name from " . TABLE_ARTICLES . " a left join " . TABLE_AUTHORS . " au using(authors_id), " . TABLE_ARTICLES_DESCRIPTION . " ad where a.articles_status = '1' and a.articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and ad.articles_id = a.articles_id and ad.language_id = '" . (int)$languages_id . "'");
	$article_info = tep_db_fetch_array($article_info_query);

	tep_db_query("update " . TABLE_ARTICLES_DESCRIPTION . " set articles_viewed = articles_viewed+1 where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and language_id = '" . (int)$languages_id . "'");

	$articles_name = $article_info['articles_name'];
	$articles_author_id = $article_info['authors_id'];
	$articles_author = $article_info['authors_name'];
?>
	  <tr>
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="pageHeading" valign="bottom"><?php echo $articles_name; ?></td>
			 <td class="main" align="right" valign="bottom">
			 <?php
			 if (tep_not_null($articles_author) && DISPLAY_AUTHOR_ARTICLE_LISTING == 'true') echo TEXT_BY . '<a href="' . tep_href_link(FILENAME_ARTICLES,'authors_id=' . $articles_author_id) . '">' . $articles_author . '</a>';
			 ?>
			 </td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main">
		  <p><?php echo stripslashes($article_info['articles_description']); ?></p>
		</td>
	  </tr>
<?php
	if (tep_not_null($article_info['articles_url'])) {
?>
	  <tr>
		<td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($article_info['articles_url']), 'NONSSL', true, false)); ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
<?php
	}
if (DISPLAY_DATE_ADDED_ARTICLE_LISTING == 'true') {
	if ($article_info['articles_date_available'] > date('Y-m-d H:i:s')) {
?>
	  <tr>
		<td align="left" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($article_info['articles_date_available'])); ?></td>
	  </tr>
<?php
	} else {
?>
	  <tr>
		<td align="left" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($article_info['articles_date_added'])); ?></td>
	  </tr>
<?php
	}
}
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
<?php  if (ENABLE_ARTICLE_REVIEWS == 'true') {
 $reviews_query = tep_db_query("select count(*) as count from " . TABLE_ARTICLE_REVIEWS . " r, ". TABLE_ARTICLE_REVIEWS_DESCRIPTION . " rd where r.approved = 1 and r.articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "'");	
	$reviews = tep_db_fetch_array($reviews_query);
?>
	  <tr>
		<td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>
	  </tr>
<?php
	if ($reviews['count'] <= 0) {
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_ARTICLE_REVIEWS_WRITE, tep_get_all_get_params()) . '">' . tep_image_button('button_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW) . '</a>'; ?></td>
	  </tr>
<?php
	} else {
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_ARTICLE_REVIEWS_WRITE, tep_get_all_get_params()) . '">' . tep_image_button('button_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW) . '</a> '; ?><?php echo '<a href="' . tep_href_link(FILENAME_ARTICLE_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>
	  </tr>
<?php
	}
  }
?>
	  </tr></form>
<!-- tell_a_friend //-->
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
		  <tr>
			<td>
<?php
  if (ENABLE_TELL_A_FRIEND_ARTICLE == 'true') {
	if (isset($HTTP_GET_VARS['articles_id'])) {
	  $info_box_contents = array();
	  $info_box_contents[] = array('text' => BOX_TEXT_TELL_A_FRIEND);

	  new infoBoxHeading($info_box_contents, true, true);

	  $info_box_contents = array();
	  $info_box_contents[] = array('form' => tep_draw_form('tell_a_friend', tep_href_link(FILENAME_TELL_A_FRIEND, '', 'NONSSL', false), 'get'),
								   'align' => 'left',
								   'text' => TEXT_TELL_A_FRIEND . ' ' . tep_draw_input_field('to_email_address', '', 'size="10" maxlength="30" style="width: ' . (BOX_WIDTH-30) . 'px"') . ' ' . tep_image_submit('button_tell_a_friend.gif', BOX_HEADING_TELL_A_FRIEND) . tep_draw_hidden_field('articles_id', $HTTP_GET_VARS['articles_id']) . tep_hide_session_id() );

	  new infoBox($info_box_contents);
	}
  }
?>
			</td>
		  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>		  
<!-- tell_a_friend_eof //-->
	  <tr>
		<td>
<?php
//added for cross-sell
   if ( (USE_CACHE == 'true') && !SID) {
	 include(DIR_WS_MODULES . FILENAME_ARTICLES_XSELL);
   } else {
	 include(DIR_WS_MODULES . FILENAME_ARTICLES_XSELL);
	}
   }
?>
		<?php echo '<a href="' . tep_href_link(FILENAME_ARTICLES, tep_get_all_get_params()) . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td>
	  </tr>
   </table></td>
<!-- body_text_eof //-->
	<td width="<?php echo BOX_WIDTH_RIGHT; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
	</table></td>
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>


#653 SWSchwartz

  • Community Member
  • 6 posts
  • Real Name:Stephen Schwartz

Posted 20 December 2006, 22:49

HelleM, Sorry I did not know you had asked me a question. I use dynamenu its easy to install and works great.

#654 Utriculus

  • Community Member
  • 2 posts
  • Real Name:Andrea

Posted 22 December 2006, 13:11

Hello

I am refining this great contribution on my shop.
I have a problem to correctly show the Italian-Spanish article names translations in breadcrumb, how can I correct it?

Regards

#655 mfg

  • Community Member
  • 52 posts
  • Real Name:michael

Posted 25 December 2006, 06:01

hello,

looks like a GREAT contrib.
;-)

i have installed latest version ( v1.5 with admin )

after activation STS 4.3 i got this error

Fatal error: Cannot redeclare clean_html_comments() (previously declared in I:\www.roh-shop.de\includes\functions\clean_html_comments.php:11) in I:\www.roh-shop.de\includes\functions\clean_html_comments.php on line 11


anyone knows what i have do wrong ?


thanks in advance.

bg
michael

#656 mfg

  • Community Member
  • 52 posts
  • Real Name:michael

Posted 25 December 2006, 06:16

sorry i forgot,
later i will add ultimate seo urls,
should i use a special version together with articl-manager or can i use each version ?

thanks
bg
Michael

#657 HelleM

  • Community Member
  • 234 posts
  • Real Name:Helle

Posted 25 December 2006, 14:59

View PostSWSchwartz, on Dec 20 2006, 11:49 PM, said:

HelleM, Sorry I did not know you had asked me a question. I use dynamenu its easy to install and works great.

Thanks
Helle

#658 mfg

  • Community Member
  • 52 posts
  • Real Name:michael

Posted 26 December 2006, 00:11

View Postmfg, on Dec 25 2006, 07:01 AM, said:

Fatal error: Cannot redeclare clean_html_comments() (previously declared in I:\www.roh-shop.de\includes\functions\clean_html_comments.php:11) in I:\www.roh-shop.de\includes\functions\clean_html_comments.php on line 11

hello,

sorry, i have made a mistake.
i do not read the "not" in the this install-instructions:

"add only if Header Tags not already installed"

i delete this lines and the problem is gone.

bg
Michael

#659 newtech

  • Community Member
  • 491 posts
  • Real Name:Rich
  • Gender:Male
  • Location:Seattle, WA

Posted 28 December 2006, 08:18

I have installed Article Manager 1.5.
Seems to be working fine so far. But there is one thing I would like to change:

When you view the articles page, the author and topic links are not in the correct order.
Here is how it appears:

Quote

Looking at Depression Differently by Dr. Gregg Topic: Depression
Jantz

It should appear like this:

Quote

Looking at Depression Differently by Dr. Gregg Jantz
Topic: Depression

It appears the code that needs to be changed is in articles_listing.php.
How can I change this to make the above?

Quote

<?php // osc-help.net: added class=main to the link.
echo '<a class="main" href="' . tep_href_link(FILENAME_ARTICLE_INFO, 'articles_id=' . $articles_listing['articles_id']) . '"><b>' . $articles_listing['articles_name'] . '</b></a> ';
if (DISPLAY_AUTHOR_ARTICLE_LISTING == 'true' && tep_not_null($articles_listing['authors_name'])) {
echo TEXT_BY . ' ' . '<a href="' . tep_href_link(FILENAME_ARTICLES, 'authors_id=' . $articles_listing['authors_id']) . '"> ' . $articles_listing['authors_name'] . '</a>';
}
?>
</td>
<?php
if (DISPLAY_TOPIC_ARTICLE_LISTING == 'true' && tep_not_null($articles_listing['topics_name'])) {
?>
<td valign="top" class="main" width="25%" nowrap><?php echo TEXT_TOPIC . ' <a href="' . tep_href_link(FILENAME_ARTICLES, 'tPath=' . $articles_listing['topics_id']) . '">' . $articles_listing['topics_name'] . '</a>'; ?></td>
<?php
}
?>
</tr>


#660 newtech

  • Community Member
  • 491 posts
  • Real Name:Rich
  • Gender:Male
  • Location:Seattle, WA

Posted 28 December 2006, 09:04

Tell a Friend feature

I have installed the Tell a Friend for Non-Product Contrib. Does anyone else have this contrib installed and edited the php file so that it will work with the Article Manager Tell a Friend?

If so, can ypu post the edits that you did to make both contribs work?