Article Manager v1.0

♥GLWalker · June 14, 2008

i know how to create a new table, but when i open CREATE NEW TABLE in phpmyadmin, it gives me a lot of options which are not explained in the instructions. How many fields should each table have? One each?? also what TYPE? Do i have to name the fields?

i really hope someone can give me a hand> I am doing all the researching i can on different websites (including this one) and i am just STUCK.

When inside phpMyadmin, use the tab that says SQL and then paste your code into there. Then hit the go or run button.

lindsayanng · June 14, 2008

Do i paste the ENTIRE code from the article_manager_sql readme file? I do not need to do each INSERT individually?? I enter it in the configuration table correct? not the configuration_groups table...

Also, it says i have to add the new tables first, don't I have to do this manually through the OPERATIONS?

BTW thanks so much for your quick response!!

lindsayanng · June 14, 2008

oh yea, and one more quick one.

When i click the sql button, some text automatically pops up in the text field

SELECT * FROM `configuration` WHERE 1

do i leave this or write over it?

lindsayanng · June 14, 2008

p.s. I answered ONE of my own questions. I know now that it will be added to the configuration table and NOT the configuration_groups table. I figured this out by looking at the article_manager_sql code that is given in the contribution. All of the sub-items listed in the () are in the configuration table.

Thanks..

but i am still trying to figure out about creating the NEW tables. What type and how many fields.

lindsayanng · June 14, 2008

ok. i figured it out (with some help) and thought i should post if for the other newbies to sql. You DO NOT have to make the tables by hand like i though. When you copy the Article_Manager_sql.txt file and paste it into the field box that shows when your click MYSQL (in the phpmyadmin section) it will make everything for you.

And there should NOT be any text in that field either like i saw. That meant i was in the wrong place. I backed out and got back into phpmyadmin, chose the oscommerce database and THEN clicked SQL and entered. I must have been clicking around too much.. but its and easy way to get back to where you started

lindsayanng · June 14, 2008

ok. everything is set up and in the admin and on the website.. But i have an error. i HOPE someone can explain what this error is:

Parse error: syntax error, unexpected T_ELSE in /home/furryfam/public_html/catalog/includes/modules/article_listing.php on line 127

My new article shows up in the info box, and when i click on the category, all of the category info pops up, but the article is not there, instead there is the above quote

Here is my code for the article_listing.php file

<?php
/*
 $Id: article_listing.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
*/

$listing_split = new splitPageResults($listing_sql, MAX_ARTICLES_PER_PAGE);
 if (($listing_split->number_of_rows > 0) && ((ARTICLE_PREV_NEXT_BAR_LOCATION == 'top') || (ARTICLE_PREV_NEXT_BAR_LOCATION == 'both'))) {
?>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_ARTICLES); ?></td>
		<td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php
 }
?>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
 if ($listing_split->number_of_rows > 0) {
$articles_listing_query = tep_db_query($listing_split->sql_query);
?>
  <tr>
	<td class="main"><?php echo TEXT_ARTICLES; ?></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php
while ($articles_listing = tep_db_fetch_array($articles_listing_query)) {
?>
	  <tr>
		<td valign="top" class="main" width="75%">
<?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>
<?php

  if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true') {
?>
	  <tr>
		<td>
<table>

<tr>
<td style="padding-left:5px" valign="top">
<img src="/images/magazin-<?php echo $articles_listing['articles_id']; ?>.jpg" alt="<?php echo $articles_listing['articles_name']; ?>" title="<?php echo $articles_listing['articles_name']; ?>">
</td>
<td class="main" style="padding-left:15px" valign="top">
<?php echo clean_html_comments(substr($articles_listing['articles_head_desc_tag'],0, MAX_ARTICLE_ABSTRACT_LENGTH)) . ((strlen($articles_listing['articles_head_desc_tag']) >= MAX_ARTICLE_ABSTRACT_LENGTH) ? '...' : ''); ?>
<br><br><font size="-3"><b>
<?php echo TEXT_DATE_ADDED . ' ' . tep_date_long($articles_listing['articles_date_added']); ?>
</td>
</tr>
<tr><td class="smalltext">
<?php echo tep_draw_separator('pixel_tr.gif', '100%', '5'); ?>
</td></tr>
</table>
</tr>

That is all.
Image names, direcory:
The following line may be change to control image names: 
<img src="/images/magazin-<?php echo $articles_listing['articles_id']; ?>.jpg">

<?php
  if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true') {
?>
	  <tr>
		<td>
<table>

<tr>
<td style="padding-left:5px" valign="top">
<img src="/images/magazin-<?php echo $articles_listing['articles_id']; ?>.jpg" alt="<?php echo $articles_listing['articles_name']; ?>" title="<?php echo $articles_listing['articles_name']; ?>">
</td>
<td class="main" style="padding-left:15px" valign="top">
<?php echo clean_html_comments(substr($articles_listing['articles_head_desc_tag'],0, MAX_ARTICLE_ABSTRACT_LENGTH)) . ((strlen($articles_listing['articles_head_desc_tag']) >= MAX_ARTICLE_ABSTRACT_LENGTH) ? '...' : ''); ?>
<br><br><font size="-3"><b>
<?php echo TEXT_DATE_ADDED . ' ' . tep_date_long($articles_listing['articles_date_added']); ?>
</td>
</tr>
<tr><td class="smalltext">

<?php echo tep_draw_separator('pixel_tr.gif', '100%', '5'); ?>
</td></tr>
</table>


	  </tr>

<?php
  }
  if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true' || DISPLAY_DATE_ADDED_ARTICLE_LISTING) {
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
<?php
}
} // End of listing loop
 } else {
?>
	  <tr>
		<td class="main"><?php if ($listing_no_article<>'') {
								 echo $listing_no_article;
							   } elseif ($topic_depth == 'articles') {
								 echo TEXT_NO_ARTICLES;
							   } elseif (isset($HTTP_GET_VARS['authors_id'])) {
								echo  TEXT_NO_ARTICLES2;
							   } ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
<?php
 }
?>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	</table></td>
  </tr>
<?php
 if (($listing_split->number_of_rows > 0) && ((ARTICLE_PREV_NEXT_BAR_LOCATION == 'bottom') || (ARTICLE_PREV_NEXT_BAR_LOCATION == 'both'))) {
?>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_ARTICLES); ?></td>
		<td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
	  </tr>
	</table></td>
  </tr>
<?php
 }
?>

lindsayanng · June 14, 2008

can someone please gimme a hand with this??

lindsayanng · June 15, 2008

I am STILL trying to find the PARSE ERROR issue, but i found another issue with this contribution..

I can not cross sell. I have all of the cross sell files in place, and the link comes up in admin, and the one article i added is there and there is an add/remove button, but when i click that, nothing happens. Can someone please gimme a hand with that too. Much appreciated.

lindsayanng · June 15, 2008

I thought that maybe the }else{ code around line 127 was the culprit so i added another } to close it, and know the syntax error is gone, but now the article comes up TWICE when i click the category.

I really could use some help here. Thanks

lindsayanng · June 15, 2008

I re-installed the files and the doubling of the articles is gone, but now i having an issue that seems to be a VERY VERY common one, however i TRIED the fixes that were suggested and i CAN NOT figure out what the issue is because that error will not go away.

I am ONLY getting this error on the ALL ARTICLES on my website, and not on the NEW ARTICLES. that one has no problems, unlike what i read about with other people who, if they had problems with one, they had problems with the other.

I am REALLY at my witts end. I tried ALL the fixes on here, and found an download on another website that was supposed to give me a code tohelp this and there was no change there either..

here is the error, i KNOW you all have seen this before..

1054 - Unknown column 'a.authors_id' in 'on clause'

select count(*) as total from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

[TEP STOP]

here is the code for catalog/articles.php file

<?php
/*
 $Id: articles.php, v1.5.1 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');

// the following tPath references come from application_top.php
 $topic_depth = 'top';

 if (isset($tPath) && tep_not_null($tPath)) {
$topics_articles_query = tep_db_query("SELECT COUNT(*) as total from " . TABLE_ARTICLES_TO_TOPICS . " where topics_id = '" . (int)$current_topic_id . "'");
$topics_articles = tep_db_fetch_array($topics_articles_query);
if ($topics_articles['total'] > 0) {
  $topic_depth = 'articles'; // display articles
} else {
  $topic_parent_query = tep_db_query("SELECT COUNT(*) as total from " . TABLE_TOPICS . " where parent_id = '" . (int)$current_topic_id . "'");
  $topic_parent = tep_db_fetch_array($topic_parent_query);
  if ($topic_parent['total'] > 0) {
	$topic_depth = 'nested'; // navigate through the topics
  } else {
	$topic_depth = 'articles'; // topic has no articles, but display the 'no articles' message
  }
}
 }

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

 if ($topic_depth == 'top' && !isset($HTTP_GET_VARS['authors_id'])) {
$breadcrumb->add(NAVBAR_TITLE_DEFAULT, tep_href_link(FILENAME_ARTICLES));
 }

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<?php
// Mofification of Header Tags Contribution
// BOF: WebMakers.com Changed: Header Tag Controller v1.0
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'article_header_tags.php') ) {
 require(DIR_WS_INCLUDES . 'article_header_tags.php');
} else {
?>
<title><?php echo TITLE ?></title>
<?php
}
// EOF: WebMakers.com Changed: Header Tag Controller v1.0
?>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</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; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
	<!-- left_navigation //-->
	<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
	<!-- left_navigation_eof //-->
  </table></td>
<!-- body_text //-->
<?php
 if ($topic_depth == 'nested') {
$topic_query = tep_db_query("select td.topics_name, td.topics_heading_title, td.topics_description from " . TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where t.topics_id = '" . (int)$current_topic_id . "' and td.topics_id = '" . (int)$current_topic_id . "' and td.language_id = '" . (int)$languages_id . "'");
$topic = tep_db_fetch_array($topic_query);
?>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
	<tr>
	  <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td valign="top" class="pageHeading"><?php
/* bof catdesc for bts1a, replacing "echo HEADING_TITLE;" by "topics_heading_title" */
		 if ( tep_not_null($topic['topics_heading_title']) ) {
			 echo $topic['topics_heading_title'];
		   } else {
			 echo HEADING_TITLE;
		   }
/* eof catdesc for bts1a */ ?></td>
			<td valign="top" class="pageHeading" align="right"></td>
		  </tr>
		  <?php if ( tep_not_null($topic['topics_description']) ) { ?>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <tr>
			<td align="left" colspan="2" class="main"><?php echo $topic['topics_description']; ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <?php } ?>
		</table></td>
	</tr>
	<tr>
	  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	</tr>
	<tr>
	  <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
				<tr>
				  <?php
if (isset($tPath) && strpos('_', $tPath)) {
// check to see if there are deeper topics within the current topic
  $topic_links = array_reverse($tPath_array);
  for($i=0, $n=sizeof($topic_links); $i<$n; $i++) {
	$topics_query = tep_db_query("SELECT COUNT(*) as total 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 . "'");
	$topics = tep_db_fetch_array($topics_query);
	if ($topics['total'] < 1) {
	  // do nothing, go through the loop
	} else {
	  $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");
	  break; // we've found the deepest topic the customer is in
	}
  }
} else {
  $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)$current_topic_id . "' and t.topics_id = td.topics_id and td.language_id = '" . (int)$languages_id . "' order by sort_order, td.topics_name");
}

// needed for the new articles module shown below
$new_articles_topic_id = $current_topic_id;
?>
				</tr>
			  </table></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <tr>
			<td><?php /*include(DIR_WS_MODULES . FILENAME_NEW_ARTICLES); */ ?></td>
		  </tr>
		</table></td>
	</tr>
  </table></td>
<?php
 } elseif ($topic_depth == 'articles' || isset($HTTP_GET_VARS['authors_id'])) {

/* bof catdesc for bts1a */
// Get the topic name and description from the database
$topic_query = tep_db_query("select td.topics_name, td.topics_heading_title, td.topics_description from " . TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where t.topics_id = '" . (int)$current_topic_id . "' and td.topics_id = '" . (int)$current_topic_id . "' and td.language_id = '" . (int)$languages_id . "'");
$topic = tep_db_fetch_array($topic_query);
/* bof catdesc for bts1a */

// show the articles of a specified author
if (isset($HTTP_GET_VARS['authors_id'])) {
  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific topic
   $listing_sql = "select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_name, td.topics_name, a2t.topics_id from " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_ARTICLES . " a on (a.articles_id=a2t.articles_id) left join " . TABLE_ARTICLES_DESCRIPTION . " ad on (a.articles_id=ad.articles_id) left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.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 au.authors_id = '" . (int)$HTTP_GET_VARS['authors_id'] . "' and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a2t.topics_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' order by a.articles_date_added desc, ad.articles_name";
  } else {
// We show them all
	$listing_sql = "select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_name, td.topics_name, a2t.topics_id from " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_ARTICLES . " a on (a.articles_id=a2t.articles_id) left join " . TABLE_ARTICLES_DESCRIPTION . " ad on (a.articles_id=ad.articles_id) left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.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 au.authors_id = '" . (int)$HTTP_GET_VARS['authors_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";
  }
} else {
// show the articles in a given category
  if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory
	$listing_sql = "select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_name, td.topics_name, a2t.topics_id from " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_ARTICLES . " a on (a.articles_id=a2t.articles_id) left join " . TABLE_ARTICLES_DESCRIPTION . " ad left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.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 ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a2t.topics_id = '" . (int)$current_topic_id . "' and au.authors_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' order by a.articles_date_added desc, ad.articles_name";
  } else {
// We show them all
	$listing_sql = "select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_name, td.topics_name, a2t.topics_id from " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_ARTICLES . " a on (a.articles_id=a2t.articles_id) left join " . TABLE_ARTICLES_DESCRIPTION . " ad on (a.articles_id=ad.articles_id) left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.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 ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a2t.topics_id = '" . (int)$current_topic_id . "' order by a.articles_date_added desc, ad.articles_name";
  }
}
?>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
	<tr>
	  <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td valign="top" align="left" class="pageHeading"><?php
	   /* bof catdesc for bts1a, replacing "echo HEADING_TITLE;" by "topics_heading_title" */
		   if ( tep_not_null($topic['topics_heading_title']) ) {
			 echo $topic['topics_heading_title'];
		   } else {
			 echo HEADING_TITLE;
		   }

		 if (isset($HTTP_GET_VARS['authors_id'])) {
		   $author_query = tep_db_query("select au.authors_name, aui.authors_description, aui.authors_url from " . TABLE_AUTHORS . " au, " . TABLE_AUTHORS_INFO . " aui where au.authors_id = '" . (int)$HTTP_GET_VARS['authors_id'] . "' and au.authors_id = aui.authors_id and aui.languages_id = '" . (int)$languages_id . "'");
		   $authors = tep_db_fetch_array($author_query);
		   $author_name = $authors['authors_name'];
		   $authors_description = $authors['authors_description'];
		   $authors_url = $authors['authors_url'];

		   echo TEXT_ARTICLES_BY . $author_name;
		 }

	   /* eof catdesc for bts1a */
	   ?>
			</td>
			<?php
// optional Article List Filter
if (ARTICLE_LIST_FILTER) {
  if (isset($HTTP_GET_VARS['authors_id'])) {
	$filterlist_sql = "select distinct t.topics_id as id, td.topics_name as name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t, " . TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where a.articles_status = '1' and a.articles_id = a2t.articles_id and a2t.topics_id = t.topics_id and a2t.topics_id = td.topics_id and td.language_id = '" . (int)$languages_id . "' and a.authors_id = '" . (int)$HTTP_GET_VARS['authors_id'] . "' order by td.topics_name";
  } else {
	$filterlist_sql= "select distinct au.authors_id as id, au.authors_name as name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t, " . TABLE_AUTHORS . " au where a.articles_status = '1' and a.authors_id = au.authors_id and a.articles_id = a2t.articles_id and a2t.topics_id = '" . (int)$current_topic_id . "' order by au.authors_name";
  }
  $filterlist_query = tep_db_query($filterlist_sql);
  if (tep_db_num_rows($filterlist_query) > 1) {
	echo '<td align="right" class="main">' . tep_draw_form('filter', FILENAME_ARTICLES, 'get') . TEXT_SHOW . ' ';
	if (isset($HTTP_GET_VARS['authors_id'])) {
	  echo tep_draw_hidden_field('authors_id', $HTTP_GET_VARS['authors_id']);
	  $options = array(array('id' => '', 'text' => TEXT_ALL_TOPICS));
	} else {
	  echo tep_draw_hidden_field('tPath', $tPath);
	  $options = array(array('id' => '', 'text' => TEXT_ALL_AUTHORS));
	}
	echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
	while ($filterlist = tep_db_fetch_array($filterlist_query)) {
	  $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
	}
	echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');
	echo '</form></td>' . "\n";
  }
}
?>
		  </tr>
		  <?php if ( tep_not_null($topic['topics_description']) ) { ?>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <tr>
			<td align="left" colspan="2" class="main"><?php echo $topic['topics_description']; ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <?php } ?>
		  <?php if (tep_not_null($authors_description)) { ?>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <tr>
			<td class="main" colspan="2" valign="top"><?php echo $authors_description; ?></td>
		  <tr>
			<?php } ?>
			<?php if (tep_not_null($authors_url)) { ?>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td class="main" colspan="2" valign="top"><?php echo sprintf(TEXT_MORE_INFORMATION, $authors_url); ?></td>
		  <tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <?php } ?>
		</table></td>
	</tr>
	<tr>
	  <td><?php include(DIR_WS_MODULES . FILENAME_ARTICLE_LISTING); ?></td>
	</tr>
  </table></td>
<?php
 } else { // default page
?>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
	<tr>
	  <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
		  </tr>
		</table></td>
	</tr>
	<tr>
	  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	</tr>
	<tr>
	  <td><?php include(DIR_WS_MODULES . FILENAME_ARTICLES_UPCOMING); ?></td>
	</tr>
	<tr>
	  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	</tr>
	<tr>
	  <td class="main"><?php echo '<b>' . TEXT_CURRENT_ARTICLES . '</b>'; ?></td>
	</tr>
	<tr>
	  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	</tr>
	<?php
 $articles_all_array = array();
// Rigadin2: query modified for Mysql5 and added ledt join for TABLE_ARTICLES_DESCRIPTION.
//  $articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ((" . TABLE_ARTICLES . " a) left join " . TABLE_AUTHORS . " au using(authors_id)) left join " . TABLE_ARTICLES_DESCRIPTION . " ad using(articles_id), " . 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_id = a2t.articles_id and a.articles_status = '1' and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name";
 $articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.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";

 $listing_sql = $articles_all_query_raw;

 //$articles_all_split = new splitPageResults($articles_all_query_raw, MAX_ARTICLES_PER_PAGE); 

?>
	<tr>
	  <td><?php include(DIR_WS_MODULES . FILENAME_ARTICLE_LISTING); ?></td>
	</tr>
	<tr>
	  <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
		  <tr>
		</table></td>
	</tr>
	<?php
 if (($articles_all_split->number_of_rows > 0) && ((ARTICLE_PREV_NEXT_BAR_LOCATION == 'bottom') || (ARTICLE_PREV_NEXT_BAR_LOCATION == 'both'))) {
?>
	<tr>
	  <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td class="smallText"><?php echo $articles_all_split->display_count(TEXT_DISPLAY_NUMBER_OF_ARTICLES); ?></td>
			<td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $articles_all_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
		  </tr>
		</table></td>
	</tr>
	<?php
 }
?>
  </table></td>
<?php } ?>
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" 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'); ?>

lindsayanng · June 15, 2008

here is the code from the boxes/articles.php file

<?php
/*

$Id: articles.php, v1.0 2003/12/04 12:00:00 ra Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright © 2003 osCommerce

Released under the GNU General Public License

*/

function tep_show_topic($counter) {

global $tree, $topics_string, $tPath_array;

for ($i=0; $i<$tree[$counter]['level']; $i++) {

$topics_string .= " ";

}

$topics_string .= '<a href="';

if ($tree[$counter]['parent'] == 0) {

$tPath_new = 'tPath=' . $counter;

} else {

$tPath_new = 'tPath=' . $tree[$counter]['path'];

}

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

if (isset($tPath_array) && in_array($counter, $tPath_array)) {

$topics_string .= '';

}

// display topic name

$topics_string .= $tree[$counter]['name'];

if (isset($tPath_array) && in_array($counter, $tPath_array)) {

$topics_string .= '';

}

if (tep_has_topic_subtopics($counter)) {

$topics_string .= ' ->';

}

$topics_string .= '</a>';

if (SHOW_ARTICLE_COUNTS == 'true') {

$articles_in_topic = tep_count_articles_in_topic($counter);

if ($articles_in_topic > 0) {

$topics_string .= ' (' . $articles_in_topic . ')';

}

}

$topics_string .= ' ';

if ($tree[$counter]['next_id'] != false) {

tep_show_topic($tree[$counter]['next_id']);

}

}

?>



<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => BOX_HEADING_ARTICLES);

new infoBoxHeading($info_box_contents, true, false);

$topics_string = '';

$tree = array();

$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 = '0' and t.topics_id = td.topics_id and td.language_id = '" . (int)$languages_id . "' order by sort_order, td.topics_name");

while ($topics = tep_db_fetch_array($topics_query)) {

$tree[$topics['topics_id']] = array('name' => $topics['topics_name'],

'parent' => $topics['parent_id'],

'level' => 0,

'path' => $topics['topics_id'],

'next_id' => false);

if (isset($parent_id)) {

$tree[$parent_id]['next_id'] = $topics['topics_id'];

}

$parent_id = $topics['topics_id'];

if (!isset($first_topic_element)) {

$first_topic_element = $topics['topics_id'];

}

}

//------------------------

if (tep_not_null($tPath)) {

$new_path = '';

reset($tPath_array);

while (list($key, $value) = each($tPath_array)) {

unset($parent_id);

unset($first_id);

$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)$value . "' 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)) {

$new_path .= $value;

while ($row = tep_db_fetch_array($topics_query)) {

$tree[$row['topics_id']] = array('name' => $row['topics_name'],

'parent' => $row['parent_id'],

'level' => $key+1,

'path' => $new_path . '_' . $row['topics_id'],

'next_id' => false);

if (isset($parent_id)) {

$tree[$parent_id]['next_id'] = $row['topics_id'];

}

$parent_id = $row['topics_id'];

if (!isset($first_id)) {

$first_id = $row['topics_id'];

}

$last_id = $row['topics_id'];

}

$tree[$last_id]['next_id'] = $tree[$value]['next_id'];

$tree[$value]['next_id'] = $first_id;

$new_path .= '_';

} else {

break;

}

}

}

tep_show_topic($first_topic_element);

$info_box_contents = array();

$new_articles_string = '';

$all_articles_string = '';

if (DISPLAY_ALL_ARTICLES=='true') {

if (SHOW_ARTICLE_COUNTS == 'true') {

$articles_all_query = tep_db_query("select a.articles_id from " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_ARTICLES . " a on (a.articles_id=a2t.articles_id) left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id left join " . TABLE_ARTICLES_DESCRIPTION . " ad on (a.articles_id=ad.articles_id) where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "'");

$articles_all_count = ' (' . tep_db_num_rows($articles_all_query) . ')';

} else {

$articles_all_count = '';

}

if (strstr($_SERVER['PHP_SELF'],FILENAME_ARTICLES_NEW) or strstr($PHP_SELF,FILENAME_ARTICLES_NEW)) {

$new_articles_string = '';

}

$new_articles_string .= '<a href="' . tep_href_link(FILENAME_ARTICLES_NEW, '', 'NONSSL') . '">' . BOX_NEW_ARTICLES . '</a>';

if (strstr($_SERVER['PHP_SELF'],FILENAME_ARTICLES_NEW) or strstr($PHP_SELF,FILENAME_ARTICLES_NEW)) {

$new_articles_string .= '';

}

$new_articles_string .= $articles_new_count . ' ';

}

if (DISPLAY_ALL_ARTICLES=='true') {

if (SHOW_ARTICLE_COUNTS == 'true') {

$articles_all_query = tep_db_query("select a.articles_id from (" . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t) left join " . TABLE_TOPICS_DESCRIPTION . " td on (a2t.topics_id = td.topics_id) left join " . TABLE_AUTHORS . " au on (a.authors_id = au.authors_id), " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "'");

$articles_all_count = ' (' . tep_db_num_rows($articles_all_query) . ')';

} else {

$articles_all_count = '';

}

if ($topic_depth == 'top') {

$all_articles_string = '';

}

$all_articles_string .= '<a href="' . tep_href_link(FILENAME_ARTICLES, '', 'NONSSL') . '">' . BOX_ALL_ARTICLES . '</a>';

if ($topic_depth == 'top') {

$all_articles_string .= '';

}

$all_articles_string .= $articles_all_count . ' ';

}

$info_box_contents[] = array('text' => $new_articles_string . $all_articles_string . $topics_string);

new infoBox($info_box_contents);

?>

</td>

</tr>

lindsayanng · June 15, 2008

if you need ANY more info, let me know and i will post as soon as i can. THANKS EVERYONE

lindsayanng · June 16, 2008

I REALLY hope someone can help. I spoke to multiple people about this error, and my only answers were to ask someone who developed or USED this. PLEASE PLEASE PLEASE

lindsayanng · June 17, 2008

you are NOT NOT NOT going to believe this.. I FREAKING FIXED IT!!!!

I sat at the cpu for about 2 hours reading the code word by word and symbol by symbol. I was going crazy, and then i got to this odd little part of the code in catalog/articles.php

I WAS loosing my mind, but this little paragraph just stood out.. it said:

// Rigadin2: query modified for Mysql5 and added ledt join for TABLE_ARTICLES_DESCRIPTION.
//  $articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ((" . TABLE_ARTICLES . " a) left join " . TABLE_AUTHORS . " au using(authors_id)) left join " . TABLE_ARTICLES_DESCRIPTION . " ad using(articles_id), " . 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_id = a2t.articles_id and a.articles_status = '1' and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name";

$articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.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";

then i realized.. The paragraph of code on the top was the correct code for the more RECENT MYSQL5 and the paragraph below was for the older one. NO WHERE In the instructions did it say to go in a delete the one you will not be using (in my case the second one for the older version of MYSQL)

So i deleted that second whole block of code and VIOLA - MY ARTICLES MANAGER WORKS!!!

well, almost.. I am still having the issue with the cross sell.. i really an VERY proud of myself because i am just LEARNING this stuff, but i feel like everything is coming along nicely.

garfunkel41 · June 24, 2008

Hi,

I'm new to OSCommerce and am trying to install the latest version of Article Manager on my site hosted by site5 and am having trouble. I'm not sure if this is the correct forum to post this question and I'm sorry if it isn't (If this is the case, if someone would be kind enough to let me know where to post the question, I'd be truly grateful).

When I load the Article_Manager_sql.txt file into the field for MySQL, I get a "Rails application failed to start properly." error message. Is this because of something I've done or not done? Or is it something I need to contact Site5 about?

Any insight would be greatly appreciated.

Thanks :)

lindsayanng · June 24, 2008

when i did it, i didnt load the text file, but copied and pasted it into the query.. that worked for me.. i wish i could tell you what went wrong, but i am REALLY new to all this.

garfunkel41 · June 24, 2008

when i did it, i didnt load the text file, but copied and pasted it into the query.. that worked for me.. i wish i could tell you what went wrong, but i am REALLY new to all this.

I got it working actually. Turns out I had to sign into my site5 account differently.

But now I get a "500 Internal Server Error" when I click Articles either in osCommerce's admin site or from my site itself. Any idea how to solve this?

To the best of my knowledge, I've followed all the steps in the articles manager readme.

lindsayanng · June 24, 2008

you are getting the same error on both the admin side AND the user side? can you post a link to your site

did you check the permissions on your files? There is one file that needs open permissions that will then be deleted.. The other issue could be your server host. If you have error logs in your control panel, i would dig those up to get more specific info

Edited June 24, 2008 by lindsayanng

garfunkel41 · June 24, 2008

you are getting the same error on both the admin side AND the user side? can you post a link to your site

did you check the permissions on your files? There is one file that needs open permissions that will then be deleted.. The other issue could be your server host. If you have error logs in your control panel, i would dig those up to get more specific info

Yeah. I just solved the problem by changing the permissions from all the files I uploaded (they were at 777) to 755. :)

Thanks for your help.

lindsayanng · June 25, 2008

glad to be of service. You would have probably been here all day. I posted 6 questions with no response once!!

sunrise99 · June 25, 2008

Hi,

My hosting is

PHP Version: 4.4.7 (Zend: 1.3.0)

MySQL 4.1.22-standard-log

after I install article Manager, from admin --> Cross-Sell Articles can't run , when hit "Cross-Sell Actions" add/reMove , it will not go ....

would you please help to advise asap?

Thanks & Best Regards,

lindsayanng · June 27, 2008

i have the same issue.. my entire set up is right but i CAN NOT get the xsell to work and it has been driving me nuts!! the whole reason for putting articles in my website was to get info seekers to actrually see my products too!!!

ANYONE figure this one out?

lindsayanng · June 28, 2008

this is really frustrating!!!!

mediadream · July 2, 2008

Yes I agree, I have the exact same problem When I press "Add/Remove" Nothing i happening, What can bee wrong? I dont get any error message either.

lindsayanng · July 2, 2008

dont ask me.. I have been waiting for an answer for WEEKS>

Article Manager v1.0

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

RobAnderson

Jack_mcs

Jack_mcs

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation