Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

tlalochj

Archived
  • Posts

    8
  • Joined

  • Last visited

Everything posted by tlalochj

  1. Hi I install the contribution Add new product fields http://www.oscommerce.com/community/contributions,2779 , but I have a problem , I make a new installation all is clean I make a new field called Autor, I registered a new product with this new field but when I try to search whit basic search or advanced search the product but I can't view it , but If i click in directly in the product I can view it , what I'm doig wrong I install ok. the instructions but I can make a search please help me You can view it in www.2enamorados.com/libreria2 please help me the new product I can view is the book harry potter, sorry for the bad english
  2. Hi , I install the products extra field contribution but when I try to make a search or advanced search no one product is display it, I install the advanced serch and advaced search resul files that have the contribution, but I don't know i I put in the correct place, I put in the catalog/advacend_serarch.php it's that correct please help me
  3. I have this error message whet I try to search or make an advanced search , I install the Products Extra field Contribution, When I change the original files with the search and advanced search files of the products extra field contribution I have a error message Product not foun And If I put the original search and advanced search the error message tha appears it's 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_extra_fields pef, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and pef.products_extra_fields_id=p2pef.products_extra_fields_id and ((pd.products_name like '%harry%' or p.products_model like '%harry%' or m.manufacturers_name like '%harry%' or pef.products_extra_fields_name like '%harry%' or p2pef.products_extra_fields_value like '%harry%') ) [TEP STOP] Somebody can help me
  4. I install the Product Extra field contribution and I need a lot of but I have too many problem's another problem that results whe I make a serch or an advanced serch it's that this message appears 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_extra_fields pef, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and pef.products_extra_fields_id=p2pef.products_extra_fields_id and ((pd.products_name like '%harry%' or p.products_model like '%harry%' or m.manufacturers_name like '%harry%' or pef.products_extra_fields_name like '%harry%' or p2pef.products_extra_fields_value like '%harry%') ) I install the advanced search results and the advnced search that comes in the contribution and nothing happend Somebody please can help me
  5. Hi I have the same problem when I change the tep_show_category with this one tep_show_category_template I can view the details of my product but It's display it whit two more columns one in the rigth with the categories,advanced search etc, and other to the left with the coins and with other things , and in the middle the details but this details are accumulated, can you help me orsomebody can fix this problem
  6. I read all the post's and I can't found a solution please help me I install the Script Product Extra Field version extra_fields_v2_0i ,I can Add some Extra fields like Autor , ISBN etc. but when I try to see the details of the product in the main store the program, give me this message Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/enamora/public_html/libreria/includes/header.php:194) in /home/enamora/public_html/libreria/includes/boxes/categories.php on line 13 Before I install the script of Product Extra Field I can view the details of the products after not I check the code and I have this in the two files that make the mistake please somebody can check it I put the lines that send the message and also the complete files please help me header.php in line 194 function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; if(!$tree[$counter]['level']){ $categories_string .= $categories_string ? '<tr><td><img src=images/m26.gif width=167 height=1><br><br class=px2></td></tr>' : ''; $categories_string .= '<tr><td><img src=images/m25.gif width=5 height=5 align=absmiddle> & <a class=ml1 href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>'; the categories file in line 13 function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; for ($i=0; $i<$tree[$counter]['level']; $i++) { $categories_string .= "&&"; } $categories_string .= '<a href="'; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '<b>'; } And the complete files The header.php file <?php /* $Id: header.php,v 1.42 2003/06/10 18:20:38 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // check if the 'install' directory exists, and warn of its existence if (WARN_INSTALL_EXISTENCE == 'true') { if (file_exists(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/install')) { $messageStack->add('header', WARNING_INSTALL_DIRECTORY_EXISTS, 'warning'); } } // check if the configure.php file is writeable if (WARN_CONFIG_WRITEABLE == 'true') { if ( (file_exists(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/includes/configure.php')) && (is_writeable(dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/includes/configure.php')) ) { $messageStack->add('header', WARNING_CONFIG_FILE_WRITEABLE, 'warning'); } } // check if the session folder is writeable if (WARN_SESSION_DIRECTORY_NOT_WRITEABLE == 'true') { if (STORE_SESSIONS == '') { if (!is_dir(tep_session_save_path())) { $messageStack->add('header', WARNING_SESSION_DIRECTORY_NON_EXISTENT, 'warning'); } elseif (!is_writeable(tep_session_save_path())) { $messageStack->add('header', WARNING_SESSION_DIRECTORY_NOT_WRITEABLE, 'warning'); } } } // check session.auto_start is disabled if ( (function_exists('ini_get')) && (WARN_SESSION_AUTO_START == 'true') ) { if (ini_get('session.auto_start') == '1') { $messageStack->add('header', WARNING_SESSION_AUTO_START, 'warning'); } } if ( (WARN_DOWNLOAD_DIRECTORY_NOT_READABLE == 'true') && (DOWNLOAD_ENABLED == 'true') ) { if (!is_dir(DIR_FS_DOWNLOAD)) { $messageStack->add('header', WARNING_DOWNLOAD_DIRECTORY_NON_EXISTENT, 'warning'); } } if ($messageStack->size('header') > 0) { echo $messageStack->output('header'); } ?> <table cellspacing=0 cellpadding=0 width=736 align=center> <tr><td> <table cellspacing=0 cellpadding=0> <tr><td height=13 colspan=6></td></tr> <tr><td><a href=<?=tep_href_link('index.php')?>><img src=images/m01.gif width=251 height=70 border=0></a></td> <td width=75></td> <td><p> </p> <p><img src=images/m02.jpg width=125 height=70 align="bottom"></p></td> <td width=125 height=70> <table cellspacing=0 cellpadding=0 width=86 align=center> <tr> <td class=cy>Escoge tu Idioma :</td> </tr> <tr><td height=8></td></tr> <tr><td> <? // LANGUAGES if (!isset($lng) || (isset($lng) && !is_object($lng))) { include(DIR_WS_CLASSES . 'language.php'); $lng = new language; } $languages_string = ''; reset($lng->catalog_languages); while (list($key, $value) = each($lng->catalog_languages)) { $languages_string .= ' <a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('language', 'currency')) . 'language=' . $key, $request_type) . '">' . tep_image(DIR_WS_LANGUAGES . $value['directory'] . '/images/' . $value['image'], $value['name']) . '</a> '; } echo $languages_string; ?> </td></tr> </table> </td> <td><img src=images/m17.gif width=1 height=70></td> <td width=159 height=70> <table cellspacing=0 cellpadding=0 align=center width=133> <tr><td height=10 colspan=2></td></tr> <tr><td align=center><a href=<?=tep_href_link('shopping_cart.php')?>><img src=images/m03.gif width=33 height=33 border=0></a></td> <td class=cy>Carro de Compras </td> </tr> <tr><td height=3 colspan=2></td></tr> <tr> <td colspan=2>Ahora en tu carro <b> <a href=<?=tep_href_link('shopping_cart.php')?> class=ml><?=$cart->count_contents()?> artículos</a></b></td> </tr> <tr><td height=8 colspan=2></td></tr> </table> </td></tr> </table> <table cellspacing=0 cellpadding=0> <tr><td width=199 valign=top> <table cellspacing=0 cellpadding=0> <tr><td><img src=images/m07.gif width=199 height=13></td></tr> <tr><td><a href=<?=tep_href_link('index.php')?>><img src=images/m18.gif width=199 height=29 border=0></a></td></tr> <tr><td><a href=<?=tep_href_link('products_new.php')?>><img src=images/m19.gif width=199 height=25 border=0></a></td></tr> <tr><td><a href=<?=tep_href_link('account.php')?>><img src=images/m20.gif width=199 height=24 border=0></a></td></tr> <tr><td><a href=<?=tep_href_link('shopping_cart.php')?>><img src=images/m21.gif width=199 height=24 border=0></a></td></tr> <tr><td><a href=<?=tep_href_link('checkout_shipping.php')?>><img src=images/m22.gif width=199 height=31 border=0></a></td></tr> <tr><td><img src=images/m15.gif width=199 height=18></td></tr> </table> </td> <td valign=top><img src=images/m08.jpg width=203 height=164><img src=images/m09.jpg width=174 height=164></td> <td> <table cellspacing=0 cellpadding=0 height=164 border=0> <tr><td><img src=images/m10.gif width=160 height=16></td></tr> <tr><td class=bg> <table cellspacing=0 cellpadding=0 width=127 align=center> <tr> <td><img src=images/m12.gif width=3 height=3 align=absmiddle> <a href=<?=tep_href_link('specials.php')?> class=ml1>Especiales</a></td> </tr> <tr><td height=2></td></tr> <tr> <td><img src=images/m12.gif width=3 height=3 align=absmiddle> <a href=<?=tep_href_link('advanced_search.php')?> class=ml1>Buscar</a></td> </tr> <tr><td height=2></td></tr> <tr> <td><img src=images/m12.gif width=3 height=3 align=absmiddle> <a href=<?=tep_href_link('contact_us.php')?> class=ml1>Contactanos</a></td> </tr> <tr><td height=2></td></tr> <tr> <td><img src=images/m12.gif width=3 height=3 align=absmiddle> <a href=<?=tep_href_link('create_account.php')?> class=ml1>Crear una Cuenta</a></td> </tr> <tr><td height=2></td></tr> <tr> <td><img src=images/m12.gif width=3 height=3 align=absmiddle> <a href=<?=tep_href_link('login.php')?> class=ml1>Acceso Clientes </a></td> </tr> <tr><td height=12></td></tr> <tr><td><img src=images/m14.gif width=127 height=1></td></tr> <tr><td height=4></td></tr> <tr> <td><b><font color=#000000>Moneda</font></b></td> </tr> <tr><td height=4></td></tr> <tr><td> <? // CURRENCIES echo tep_draw_form('currencies', tep_href_link(basename($PHP_SELF), '', $request_type, false), 'get'); reset($currencies->currencies); $currencies_array = array(); while (list($key, $value) = each($currencies->currencies)) { $currencies_array[] = array('id' => $key, 'text' => $value['title']); } $hidden_get_variables = ''; reset($HTTP_GET_VARS); while (list($key, $value) = each($HTTP_GET_VARS)) { if ( ($key != 'currency') && ($key != tep_session_name()) && ($key != 'x') && ($key != 'y') ) { $hidden_get_variables .= tep_draw_hidden_field($key, $value); } } echo tep_draw_pull_down_menu('currency', $currencies_array, $currency, 'onChange="this.form.submit();" style="width: 100%"') . $hidden_get_variables . tep_hide_session_id(); echo '</form>'; ?> </td></tr> </table> </td></tr> <tr><td><img src=images/m16.gif width=160 height=18></td></tr> </table> </td></tr> </table> <table cellspacing=0 cellpadding=0> <tr><td colspan=3 height=3></td></tr> <tr><td width=207 valign=top> <table cellspacing=0 cellpadding=0> <tr><td><img src=images/m24.gif width=207 height=40></td></tr> <tr><td class=bg1> <table cellspacing=0 cellpadding=0 width=167 align=center> <tr><td height=18></td></tr> <? // ---- CATEGORIES function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; if(!$tree[$counter]['level']){ $categories_string .= $categories_string ? '<tr><td><img src=images/m26.gif width=167 height=1><br><br class=px2></td></tr>' : ''; $categories_string .= '<tr><td><img src=images/m25.gif width=5 height=5 align=absmiddle> <a class=ml1 href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>'; // display category name $categories_string .= $tree[$counter]['name']; $categories_string .= '</a><br><br class=px4></td></tr>'; }else{ $categories_string .= '<tr><td>'; for($i=0;$i<$tree[$counter]['level'];$i++) $categories_string .= ' '; $categories_string .= ' - <a class=ml1 href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>'; // display category name $categories_string .= $tree[$counter]['name']; $categories_string .= '</a><br><br class=px4></td></tr>'; } if ($tree[$counter]['next_id'] != false) { tep_show_category($tree[$counter]['next_id']); } } define(TABLE_CATEGORIES, "categories"); define(TABLE_CATEGORIES_DESCRIPTION, "categories_description"); $categories_string = ''; $tree = array(); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $tree[$categories['categories_id']] = array('name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $categories['categories_id']; } $parent_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if ($cPath) { $new_path = ''; reset($cPath_array); while (list($key, $value) = each($cPath_array)) { unset($parent_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); if (tep_db_num_rows($categories_query)) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $tree[$row['categories_id']] = array('name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $row['categories_id']; } $parent_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $tree[$last_id]['next_id'] = $tree[$value]['next_id']; $tree[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } $categories_string .= ''; tep_show_category($first_element); $categories_string .= ''; echo $categories_string; ?> <tr><td height=5></td></tr> </table> </td></tr> <tr><td><img src=images/m27.gif width=207 height=6></td></tr> <tr><td height=3></td></tr> </table> <table cellspacing=0 cellpadding=0> <tr><td><img src=images/m28.gif width=207 height=40></td></tr> <tr><td class=bg1> <table cellspacing=0 cellpadding=0 width=175 align=center border=0> <? echo tep_draw_form('quick_find', tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT, '', 'NONSSL', false), 'get'); echo '<tr><td height=17 colspan=2></td></tr> <tr><td valign=top align=right>'.tep_draw_input_field('keywords', '', 'size="20" maxlength="30" class=go') . ' ' . tep_hide_session_id() . '</td><td valign=top align=left> <input type=image src=images/m30.gif width=31 height=21></td></tr> <tr><td height=8 colspan=2></td></tr> <tr><td colspan=2><a class=ml2 href="' . tep_href_link(FILENAME_ADVANCED_SEARCH) . '">' . BOX_SEARCH_ADVANCED_SEARCH . '</a></td></tr> <tr><td height=8 colspan=2></td></tr> </form>'; ?> </table> </td></tr> <tr><td><img src=images/m27.gif width=207 height=6></td></tr> </table> </td> <td width=3 valign=top></td> <td width=526 valign=top> and in the categories.php I have this <?php /* $Id: categories.php,v 1.25 2003/07/09 01:13:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; for ($i=0; $i<$tree[$counter]['level']; $i++) { $categories_string .= " "; } $categories_string .= '<a href="'; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '<b>'; } // display category name $categories_string .= $tree[$counter]['name']; if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '</b>'; } if (tep_has_category_subcategories($counter)) { $categories_string .= '->'; } $categories_string .= '</a>'; if (SHOW_COUNTS == 'true') { $products_in_category = tep_count_products_in_category($counter); if ($products_in_category > 0) { $categories_string .= ' (' . $products_in_category . ')'; } } $categories_string .= '<br>'; if ($tree[$counter]['next_id'] != false) { tep_show_category($tree[$counter]['next_id']); } } ?> <!-- categories //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES); new infoBoxHeading($info_box_contents, true, false); $categories_string = ''; $tree = array(); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $tree[$categories['categories_id']] = array('name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $categories['categories_id']; } $parent_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if (tep_not_null($cPath)) { $new_path = ''; reset($cPath_array); while (list($key, $value) = each($cPath_array)) { unset($parent_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); if (tep_db_num_rows($categories_query)) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $tree[$row['categories_id']] = array('name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $row['categories_id']; } $parent_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $tree[$last_id]['next_id'] = $tree[$value]['next_id']; $tree[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } tep_show_category($first_element); $info_box_contents = array(); $info_box_contents[] = array('text' => $categories_string); new infoBox($info_box_contents); ?> </td> </tr> <!-- categories_eof //--> please somebody help me
  7. Hi I have a big problem I istall the script Product Extra Fiel in the post http://www.oscommerce.com/community/contributions,2202 the version that I install it's extra_fields_v2_0i I can install it without any problem but When I'm trying to view the details of one product this message of Eror appears Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/enamora/public_html/libreria/includes/header.php:194) in /home/enamora/public_html/libreria/includes/boxes/categories.php on line 13 Before I install the script I can vie the details of the products but after install it no. I view the file header.php and in the line 194 I can view this function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; if(!$tree[$counter]['level']){ $categories_string .= $categories_string ? '<tr><td><img src=images/m26.gif width=167 height=1><br><br class=px2></td></tr>' : ''; $categories_string .= '<tr><td><img src=images/m25.gif width=5 height=5 align=absmiddle> & <a class=ml1 href='; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link('index.php', $cPath_new) . '>'; and in the file categories.php in the 13 line function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; for ($i=0; $i<$tree[$counter]['level']; $i++) { $categories_string .= "&&"; } $categories_string .= '<a href="'; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '<b>'; } Somebody please help me , or tell me I somebody install other version that work's fine thanks
×
×
  • Create New...