azer Posted October 10, 2007 Share Posted October 10, 2007 (edited) on its own, it works 100% - but running with categories dynamenu it doesnt. well yes i did a mistake on the file called for the possibility to use 2 Treemenu box in the same page i think in dynamenu support thread i rea taht already, it about a variables taht need to not be called 2 times maybe you could have a look good feature would be to have in the same menu, the categories and then the topics, cool design features. also , in dinamenu tree menu categories , someone manage to show products, taht mean we could also do that for articles ! tell me if you wanna try Edited October 10, 2007 by azer Quote MS2 Link to comment Share on other sites More sharing options...
azer Posted October 10, 2007 Share Posted October 10, 2007 (edited) by the way anyone worked on a way to order the topics and articles as we can do in the categories and products ? Edited October 10, 2007 by azer Quote MS2 Link to comment Share on other sites More sharing options...
azer Posted October 10, 2007 Share Posted October 10, 2007 i installed vesion 1.5 then the breadcrumb improvement lildog 14 Aug 2007 and i ca nsee a bug in the name of the news in the breadcrumb , it show the english title if existing , if not nothing :'( any solution ? Quote MS2 Link to comment Share on other sites More sharing options...
Guest Posted October 10, 2007 Share Posted October 10, 2007 i will hav to look 2nite when i get home - at work atm... my files are at home on my pc - but will try and get the two navigations to work together. i though that maybe if you duplicated the dynamenu folder and let the articles run of the duplicated folder instead of the main one - dont know if that will solve the problem... i'm also thinking that perhaps i should take out the instances where it calls for the contents of dynamenu folder - so it will only call it once in the categories menu and not again in the articles menu // Include required libraries based on menu type require_once 'includes/functions/dynamenu/lib/PHPLIB.php'; require_once 'includes/functions/dynamenu/lib/layersmenu-common.inc.php'; there's more of this one - just to point out what i mean... i dunno about adding the articles into the categories navigation - for my site its not required, and i didnt add in the breadcrumb feature either.... Quote Link to comment Share on other sites More sharing options...
azer Posted October 10, 2007 Share Posted October 10, 2007 wihtout a modification it seem to work with both menu, what is on your website the trouble when you use both, exepcet that it losse the opened tree shape from the other menu when you click on any link from the second one Quote MS2 Link to comment Share on other sites More sharing options...
georgec Posted October 10, 2007 Share Posted October 10, 2007 Ok.. so I ended up putting something together quickly myself. Uploaded it to the contribs as well. In case someone was looking for the similar feature. Enjoy, G Anyone has an infoblock which would list latest articles from predefined topics with a short description for each article? Thnx, George Quote Link to comment Share on other sites More sharing options...
Guest Posted October 11, 2007 Share Posted October 11, 2007 azer - i tried both the methods i suggested earlier - didnt work - and yes, when both are open at same time it looses its tree shape when you click on one of them. for my site its not a big thing - as i have two seperate sections for my products and articles - so i'm not too worried about it - but i would prefer to have something that works right and not halfway if you know what i mean :) Quote Link to comment Share on other sites More sharing options...
-RJM- Posted October 11, 2007 Share Posted October 11, 2007 Hello, After 2 days of reading, searching, and changing I am unable to get past these errors. In articles.php, the articles show up but at the end I get the following error. I have seen this errors in other posts, but no real solutions that worked. Fatal error: Call to undefined function clean_html_comments() in C:\AppServ\www\catalog\includes\modules\article_listing.php on line 66 In articles_new.php I get the following error. Fatal error: Call to undefined function clean_html_comments() in C:\AppServ\www\catalog\includes\article_header_tags.php on line 138 I have STS with HTC installed and have read through both threads, tried making all the changes with no success. I have gone over the install intructions 4 times now to the letter. Quote Link to comment Share on other sites More sharing options...
Touffy Posted October 12, 2007 Share Posted October 12, 2007 i installed vesion 1.5then the breadcrumb improvement lildog 14 Aug 2007 and i ca nsee a bug in the name of the news in the breadcrumb , it show the english title if existing , if not nothing :'( any solution ? In application_top.php, change this : // add the articles name to the breadcrumb trail if (isset($HTTP_GET_VARS['articles_id'])) { $article_query = tep_db_query("select articles_name from " . TABLE_ARTICLES_DESCRIPTION . " where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "'"); if (tep_db_num_rows($article_query)) { $article = tep_db_fetch_array($article_query); if (isset($HTTP_GET_VARS['authors_id'])) { $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'authors_id=' . $HTTP_GET_VARS['authors_id'] . '&articles_id=' . $HTTP_GET_VARS['articles_id'])); } else { $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'tPath=' . $tPath . '&articles_id=' . $HTTP_GET_VARS['articles_id'])); } } } By this : // add the articles name to the breadcrumb trail if (isset($HTTP_GET_VARS['articles_id'])) { $article_query = tep_db_query("select articles_name from " . TABLE_ARTICLES_DESCRIPTION . " where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and language_id = '" . (int)$languages_id . "'"); if (tep_db_num_rows($article_query)) { $article = tep_db_fetch_array($article_query); if (isset($HTTP_GET_VARS['authors_id'])) { $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'authors_id=' . $HTTP_GET_VARS['authors_id'] . '&articles_id=' . $HTTP_GET_VARS['articles_id'])); } else { $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'tPath=' . $tPath . '&articles_id=' . $HTTP_GET_VARS['articles_id'])); } } } Quote Link to comment Share on other sites More sharing options...
Guest Posted October 13, 2007 Share Posted October 13, 2007 Please post any bugs and suggestions about Article Manager v1.0 in this topic. I will do my best to provide support. Thanks ;-) Rob Anderson Hi Rob, Everyone I would be very grateful for suggestions - to stop me going totallt bananas... I have installed on a test system and the contribution works fine Install it on the production version and everything works with the sole exception that the articles wont show on the page Topics will show, admin works fine, articles in admin yup, but in the shop nada! The only difference between the two is on the production version Mysql 4 instead of 5 The shop runs in the root (ie no catalog) Any guidance suggestions welcomed Thank you nossum Quote Link to comment Share on other sites More sharing options...
azer Posted October 13, 2007 Share Posted October 13, 2007 toofy , nice work it works perfect with multilanguage, maybe you could update contribution part :blush: Quote MS2 Link to comment Share on other sites More sharing options...
dccsupplies Posted October 13, 2007 Share Posted October 13, 2007 Hi, I've looked back at posts, and may have missed the answer to this one, so my apologies if that's the case. I've just installed V1.5, and get this error when clicking on 'all articles' Current Articles 1054 - Unknown column 'OScatalogue.au.articles_id' in 'on clause' select count(*) as total from ((articles a) left join authors au using(authors_id)) left join articles_description ad using(articles_id), articles_to_topics a2t left join 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 = '1' and td.language_id = '1' I've installed the mysql5 fixes, and tried a few other things, but I can't seem to change the outcome, otherwise, everything works fine. Any pointers or advice gratefully received. Quote Link to comment Share on other sites More sharing options...
azer Posted October 15, 2007 Share Posted October 15, 2007 trouble to display all articles in catalog/articles.php with the topic sort_order here is the sql query, as i see the table topics is not called so i can not use at the end the sort_order by topic $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.sort_order, a.articles_date_added desc, ad.articles_name"; it would need at the end : order by t.sort_order , a.sort_order, a.articles_date_added desc, ad.articles_name"; by the way i added manually on the articles table a sort_order field so i give a number with php my admin and manage to get the articles sort by sort_order but I hope someone can include this field in the admin editing of any articles :-" Quote MS2 Link to comment Share on other sites More sharing options...
georgec Posted October 16, 2007 Share Posted October 16, 2007 Rob, Should be fairly easy to make. Just add another column to the articles table, and increment the value each time the article is hit. You'll have to set some type of a cookie of course so the number is updated only once per session. Then use something like my "articles_lastN.php" contribution, but modify it to sort descending by hits, limit 10 Good idea. Probably a bit beyond my skills at the moment unless I can find a good contribution to copy from (which is all I really do anyway!). Know of any like this?Also, where would you see this being displayed. As a module to plonk anywhere? Quote Link to comment Share on other sites More sharing options...
Touffy Posted October 16, 2007 Share Posted October 16, 2007 toofy , nice work it works perfect with multilanguage, maybe you could update contribution part :blush: Done. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 16, 2007 Share Posted October 16, 2007 Hi Rob, Everyone I would be very grateful for suggestions - to stop me going totally bananas... Nossum Hi folks no progress - the contribution works faultlessly on the admin side. On the catalog side it sees that there are articles (it displays the numbers in the column) and the Topic Information displays just no articles in the main screen. I have reinstalled all files, checked data tables, checked chcp etc but nothing Rob, anyone any ideas on how to start tracking this problem down would be appreciated Thank you Nossum Quote Link to comment Share on other sites More sharing options...
Snoboreders Posted October 27, 2007 Share Posted October 27, 2007 I've been reading through this post but haven't found an answer to my question. I recognize that this contrib is located in the left or right column. However, can this be placed on my main page somewhere? I'm looking for an RSS that can be placed on my main page, and I love this article manager concept. Thanks. Quote Link to comment Share on other sites More sharing options...
loganbest Posted November 1, 2007 Share Posted November 1, 2007 When I go to articles.php I get no display of any articles. I have three articles in the top and three in a topic. Why is this happening? Quote Link to comment Share on other sites More sharing options...
vetim Posted November 2, 2007 Share Posted November 2, 2007 Hi all, there is anyone that can upload a FULL PACKAGE of the latest version of Article Menager ? I have downloaded the others package..but there are missing many files... Thanks... Vetim. Quote Link to comment Share on other sites More sharing options...
mrhandley Posted November 2, 2007 Share Posted November 2, 2007 I recognize that this contrib is located in the left or right column. However, can this be placed on my main page somewhere? I'm looking for an RSS that can be placed on my main page, and I love this article manager concept. Haven´t tried to put the article box in the main content, but it shouldn´t be too much trouble. But I don´t understand what you are writing about "looking for an RSS that can be be placed on my main page". Article Manager isn´t rss enabled, or have I missed something? Quote Link to comment Share on other sites More sharing options...
jpcalkins Posted November 5, 2007 Share Posted November 5, 2007 I have in my database table 'hotcooki_p_os2.articles'. but i am recieving this error. 1146 - Table 'hotcooki_p_os2.ARTICLES' doesn't exist select distinct ax.articles_id, ad.articles_name, a.articles_last_modified from articles_xsell ax LEFT JOIN ARTICLES a USING(articles_id) LEFT JOIN articles_description ad USING(articles_id) where ax.xsell_id = '71' and ad.language_id = '1' and a.articles_status = '1' order by a.articles_last_modified. please help jpcalkins Quote Link to comment Share on other sites More sharing options...
Guest Posted November 6, 2007 Share Posted November 6, 2007 Please post any bugs and suggestions about Article Manager v1.0 in this topic. I will do my best to provide support. Thanks ;-) Rob Anderson I guess this is where I'm supposed to ask this question... My articles are appearing with the text centered and I want them to appear left aligned. How can I fix that? Does this work with HTC? Thanks, Sherry Quote Link to comment Share on other sites More sharing options...
stunami Posted November 6, 2007 Share Posted November 6, 2007 howdy, i've just installed article manager 1.5sp1, with the updates available up to nov 07, and all works fine except the x-sell page in the admin section. when i navigate to xsell, this is what appears on the page: ID Article Name Associated Products Cross-Sell Actions if (!$add_related_article_ID) if ($_POST && !$sort) { if ($_POST[run_update]==true) { $query ="DELETE FROM " . TABLE_ARTICLES_XSELL . " WHERE articles_id = '".$_POST[add_related_article_ID]."'"; if (!tep_db_query($query)) exit(TEXT_NO_DELETE); } if ($_POST[xsell_id]) foreach ($_POST[xsell_id] as $temp) { $query = "INSERT INTO " . TABLE_ARTICLES_XSELL . " VALUES ('',$_POST[add_related_article_ID],$temp,1)"; if (!tep_db_query($query)) exit(TEXT_NO_INSERT); } ?> The database has been updated. Click here to sort the products associated with this article. Note: this needs to be done every time a product is added or deleted. Click here to go back to the main page. the server is apache 2 with mysql5 and php5. any clues? regards, stuart Quote A crash reduces your expensive computer to a simple stone. Link to comment Share on other sites More sharing options...
leveera Posted November 7, 2007 Share Posted November 7, 2007 (edited) by the way anyone worked on a way to order the topics and articles as we can do in the categories and products ? Just tried to merge boxed/articles.php with my boxes/categories.php that is modified by Great Categories v2.1 contribution to make both look and function the same. No errors but also no result. All topics are missed. Generated html code: <!-- topics //--> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td height="14" class="infoBoxHeading"><img src="images/infobox/corner_left.gif" width="11" height="14" border="0" alt=""></td> <td width="100%" height="14" class="infoBoxHeading">Articles</td> <td height="14" class="infoBoxHeading" nowrap><img src="images/pixel_trans.gif" width="11" height="14" border="0" alt=""></td> </tr> </table> <table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> <tr> <td align="left" class="boxText"><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2"><br><img src="images/pixel_ltgray.gif" border="0" alt="" width="100%" height="1"><br><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2"><table class="categ"><tr><td class="categ" nowrap><img src="images/categories/arrow_right.gif" width="9" height="9" border="0" alt=""> </td><td class="categ"><a href="http://...../..../articles.php?cPath="> </a></td></tr></table></td> </tr> <tr> <td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td> </tr> </table> </td> </tr> </table> </td> </tr> <!-- topics_eof //--> Any professional help here to check and improve the code? modified boxed/articles.php <?php /* $id: Great Categories v2.1 2005/07/09 14:00:00 + articles.php, v1.0 2003/12/04 willross Exp $ http://www.palaia.com/ujp/ - reply@qwest.net *** For use with standard install of osCommerce 2.2MS2+ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2005 osCommerce Released under the GNU General Public License */ function tep_show_topic($counter) { global $tree, $topics_string, $cPath_array, $aa; for ($a=0; $a<$tree[$counter]['level']; $a++) { // $topics_string .= " "; } //category start if ($tree[$counter]['level'] == 0) { if ($aa == 1) { $topics_string .= '<img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2"><br><img src="images/pixel_ltgray.gif" border="0" alt="" width="100%" height="1"><br><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2">'; } else {$aa=1;} } // display category name if (tep_has_topic_subtopics($counter) || $tree[$counter]['level'] == 0) { if ( ($cPath_array) && (@in_array($counter, $cPath_array)) ) { $topics_string .= '<table class="categ"><tr><td class="categ" nowrap>' . tep_image(DIR_WS_IMAGES . 'categories/arrow_down.gif', '', '9', '9') . " </td>"; } else { $topics_string .= '<table class="categ"><tr><td class="categ" nowrap>' .tep_image(DIR_WS_IMAGES . 'categories/arrow_right.gif', '', '9', '9') . " </td>"; } } else { $topics_string .= '<table class="categ"><tr><td class="categ" nowrap> ' .tep_image(DIR_WS_IMAGES . 'categories/arrow_bullet.gif', 'nokta', '9', '9') . "</td>"; } $topics_string .= '<td class="categ"><a href="'; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $topics_string .= tep_href_link(FILENAME_ARTICLES, $cPath_new); $topics_string .= '">'; if ( ($cPath_array) && (@in_array($counter, $cPath_array)) ) { $topics_string .= '<b>'; } //display topic name $topics_string .= $tree[$counter]['name']; if ( ($cPath_array) && (@in_array($counter, $cPath_array)) ) { $topics_string .= '</b>'; } 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 .= '<br>'; $topics_string .= '</td></tr></table>'; if ($tree[$counter]['next_id']) { tep_show_topic($tree[$counter]['next_id']); } } ?> <!-- topics //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => BOX_HEADING_ARTICLES); new infoBoxHeading($info_box_contents, true, false); $topics_string = ''; $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_element)) { $first_topic_element = $topics['topics_id']; } } //------------------------ if ($cPath) { $cPath_array = split('_', $cPath); reset($cPath_array); while (list($key, $value) = each($cPath_array)) { $new_path .= $value; 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"); $topic_check = tep_db_num_rows($topics_query); 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']; } if ($topic_check != 0) { $tree[$last_id]['next_id'] = $tree[$value]['next_id']; $tree[$value]['next_id'] = $first_id; } $new_path .= '_'; } } tep_show_topic($first_topic_element); $info_box_contents = array(); $new_articles_string = ''; $all_articles_string = ''; if (DISPLAY_NEW_ARTICLES=='true') { if (SHOW_ARTICLE_COUNTS == 'true') { //originale // $articles_new_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 . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY))"); $articles_new_query = tep_db_query("SELECT a.articles_id from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t, " . TABLE_TOPICS_DESCRIPTION . " td, " . TABLE_AUTHORS . " au, " . TABLE_ARTICLES_DESCRIPTION . " ad where a.authors_id = au.authors_id and a2t.topics_id = td.topics_id and (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 . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY)"); $articles_new_count = ''; } if (strstr($_SERVER['PHP_SELF'],FILENAME_ARTICLES_NEW) or strstr($PHP_SELF,FILENAME_ARTICLES_NEW)) { $new_articles_string = '<b>'; } $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 .= '</b>'; } $new_articles_string .= $articles_new_count . '<br>'; } 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_new_query = tep_db_query("SELECT a.articles_id from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t, " . TABLE_TOPICS_DESCRIPTION . " td, " . TABLE_AUTHORS . " au, " . TABLE_ARTICLES_DESCRIPTION . " ad where a.authors_id = au.authors_id and a2t.topics_id = td.topics_id and (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 . "'"); } else { $articles_all_count = ''; } if ($topic_depth == 'top') { $all_articles_string = '<b>'; } $all_articles_string .= '<a href="' . tep_href_link(FILENAME_ARTICLES, '', 'NONSSL') . '">' . BOX_ALL_ARTICLES . '</a>'; if ($topic_depth == 'top') { $all_articles_string .= '</b>'; } $all_articles_string .= $articles_all_count . '<br>'; } $info_box_contents[] = array('align' => 'left', 'text' => $new_articles_string . $all_articles_string . $topics_string); new infoBox($info_box_contents); ?> </td> </tr> <!-- topics_eof //--> Edited November 7, 2007 by leveera Quote Link to comment Share on other sites More sharing options...
mr_griz Posted November 13, 2007 Share Posted November 13, 2007 Hi Rob, I have uploaded the 2 php 5 files, and it all works great except for getting the following error when viewing all articles: All Articles Current Articles 1054 - Unknown column 'overallb_pos1.au.articles_id' in 'on clause' select count(*) as total from ((articles a) left join authors au using(authors_id)) left join articles_description ad using(articles_id), articles_to_topics a2t left join 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 = '1' and td.language_id = '1' [TEP STOP] Anything I can do to get rid of this? Thanks, Griz Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.