Jump to content


  • Content count

  • Joined

  • Last visited

  1. el_Juanky

    Article Manager v1.0

    I'm adapted the contribution Reviews in Product Info to Article Manager. This contribution is here: http://www.oscommerce.com/community/contributions,5140
  2. el_Juanky

    Support for Article Search v 1.0

    I'm adapted the article_search.php code into advanced_search_result.php. When an user want search something, this contribution find results in product and articles database. http://www.oscommerce.com/community/contributions,2393
  3. el_Juanky

    [Contribution] Admin Specials by Category

    ttstitches, you have an error with $sInfo. In specials.php, it's called $sInfo = new objectInfo($product); but in your contribution, you don't define sInfo. you must chage this variable because the problem is it! ... I continue browsing a solution. (sorry for my bad english :()
  4. el_Juanky

    [Contribution] Admin Specials by Category

    ttstitches, I've tested your contribution, but I have got some code errors. They're around line 167. I'm going to work in this code because I like your idea. PS: I made an update to the contribution, I traslate the lang file to Spanish... Español: Este es el codigo que debeis poner en admin/includes/languages/espanol/specialsbycategory.php English: this is the translate to admin/includes/languages/espanol/specialsbycategory.php <?php /* $Id: specialsbycategory.php,v 2.0 2006/11/06 23:35:00 stephenwald Exp $ osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2005 osCommerce Released under the GNU General Public License */ define('HEADING_TITLE', 'Ofertas por categorías.'); define('TEXT_SELECT_CAT', 'Selecciona la categoría.'); define('TEXT_SELECT_MAN', 'Excluir/Incluir Fabricante'); define('TEXT_ENTER_DISCOUNT','Establece el descuento:'); define('TEXT_PCT_AND','%'); define('TEXT_BUTTON_SUBMIT', 'Aceptar'); define('TEXT_INSTRUCT_1','Dejando la casilla de porcentaje vacía, se mostrarán todos los productos de la categoría seleccionada.'); define('TEXT_INSTRUCT_2','Si introduce un descuento al 0%, se eliminarán todos los porcentajes de los productos de la categoría seleccionada.'); define('TABLE_HEADING_PRODUCTS', 'Productos'); define('TABLE_HEADING_PRODUCTS_PRICE', 'Precio'); define('TABLE_HEADING_SPECIAL_PRICE', 'Precio con rebaja'); define('TABLE_HEADING_PCT_OFF', '% Descuento'); define('TABLE_HEADING_FULL_PRICE', 'Precio final'); define('TEXT_BUTTON_UPDATE', 'Actualizar todos los productos.'); ?> Español: Hay que añadir al archivo admin/includes/languages/espanol.php English: add to admin/includes/languages/espanol.php define('BOX_CATALOG_SPECIALSBYCAT','Ofertas por Categorías');
  5. el_Juanky

    Article Manager v1.0

    Do you install the sql file in your database??
  6. el_Juanky

    Article Manager v1.0

    I'm desing an infobox for Articles Manager. I'm modified of mazza and paz infobox. It's addapted to individual boxes. You can see it in www.gccompeticion.com sorry, my english isn't good! New new_articles.php module. <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <?php echo mws_header('PUT HERE THE TITTLE OF NEW ARTICLES'); ?> <td height=10> <?php $articles_new_array = array(); $articles_new_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_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"; $articles_new_split = new splitPageResults($articles_new_query_raw, MAX_NEW_ARTICLES_PER_PAGE); ?> <?php if ($articles_new_split->number_of_rows > 0) { $articles_new_query = tep_db_query($articles_new_split->sql_query); ?> <div class="cbox" id="newa"> <table class="listing" cellpadding=4 cellspacing=0> <?php while ($articles_new = tep_db_fetch_array($articles_new_query)) { ?> <tr> <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_ARTICLE_INFO, 'articles_id=' . $articles_new['articles_id']) . '"><b>' . $articles_new['articles_name']. '</b></a>' ?></td> <td class="main" width=150><?php echo '<a href="' . tep_href_link(FILENAME_ARTICLES, 'tPath=' . $articles_new['topics_id']) . '">' . $articles_new['topics_name'] . '</a>'; ?><br><?php echo tep_date_long($articles_new['articles_date_added']); ?></td> </tr> <tr> <td class="main" colspan="2" style="padding-left:10px"><?php echo clean_html_comments(substr($articles_new['articles_head_desc_tag'],0, MAX_ARTICLE_ABSTRACT_LENGTH)) . ((strlen($articles_new['articles_head_desc_tag']) >= MAX_ARTICLE_ABSTRACT_LENGTH) ? '...' : ''); ?><br><hr></td> </tr> <?php } // End of listing loop echo '</table></div>'; } else { ?><?php } ?> <br></td> <?php echo mws_footer(''); ?> </tr> </table> In index.php: <?php require(DIR_WS_MODULES . 'new_articles.php');?>