Jump to content

davchi2005

Members
  • Content count

    26
  • Joined

  • Last visited

Everything posted by davchi2005

  1. I want to can put on Manufactures in one select, but these have sub-Manufactures. Ej Manufactures A = Have e Manufactures 1 - 2 - 3 - 4. Manufactures B = Have e Manufactures 5 - 6 - 7 - 8. Manufactures C = Have e Manufactures 9 - 10 - 11 - 12. I need by Ajax can, if the chose manufacture, give me the other select and the option to chose sub-manufacturer. Anybody knows any contribution or maybe give me some hand to start make it.
  2. davchi2005

    Help

    I want to can put on Manufactures in one select, but these have sub-Manufactures. Ej Manufactures A = Have e Manufactures 1 - 2 - 3 - 4. Manufactures B = Have e Manufactures 5 - 6 - 7 - 8. Manufactures C = Have e Manufactures 9 - 10 - 11 - 12. I need by Ajax can, if the chose manufacture, give me the other select and the option to chose sub-manufacturer. Anybody knows any contribution or maybe give me some hand to start make it.
  3. Show categories in modules new_products.php and product_listing.php $categories_query = tep_db_query("select categories_name from categories_description c, products_to_categories pc where pc.categories_id = c.categories_id and c.language_id='" . (int)$languages_id ."' and $products_id='".(int)$id."' = pc.products_id"); $categories = tep_db_fetch_array($categories_query); Any idea
  4. davchi2005

    Show Categories Name in index.php

    shown on each product in that category belongs to index.php
  5. davchi2005

    Shoe Categories

    Show categories in modules new_products.php and product_listing.php $categories_query = tep_db_query("select categories_name from categories_description c, products_to_categories pc where pc.categories_id = c.categories_id and c.language_id='" . (int)$languages_id ."' and $products_id='".(int)$id."' = pc.products_id"); $categories = tep_db_fetch_array($categories_query); Any idea
  6. davchi2005

    All products with select

    Solution <?php $products_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name "); if ($number_of_rows = tep_db_num_rows($products_query)) { $products_array = array(); if ($products_name < 2) { $products_array[] = array('id' => '', 'text' => PULL_DOWN_DEFAULT); } while ($products = tep_db_fetch_array($products_query)) { $products_name = ((strlen($products['products_name']) > '50') ? substr($products['products_name'], 0, '50') . '..' : $products['products_name']); $products_array[] = array('id' => $products['products_id'], 'text' => $products_name); } $info_box_contents = array(); $info_box_contents[] = array('form' => tep_draw_form('products', tep_href_link(FILENAME_PRODUCT_INFO, '', 'NONSSL', false), 'get'), 'text' => tep_draw_pull_down_menu('products_id', $products_array, (isset($HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : ''), 'onChange="this.form.submit();" size="' . '1' . '" style="width: 100%"') . tep_hide_session_id()); new infoBox($info_box_contents); } ?>
  7. my problem is that I doubled the name <?php $products_query = tep_db_query("select products_name, products_id from " . TABLE_PRODUCTS_DESCRIPTION . " order by products_name"); if ($number_of_rows = tep_db_num_rows($products_query)) { $products_array = array(); while ($products = tep_db_fetch_array($products_query)) { $products_name = ((strlen($products['products_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($products['products_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN) . '..' : $products['products_name']); $products_array[] = array('id' => $products['products_id'], 'text' => $products_name); } $info_box_contents = array(); $info_box_contents[] = array('form' => tep_draw_form('products', tep_href_link(FILENAME_PRODUCT_INFO, '', 'NONSSL', false), 'get'), 'text' => tep_draw_pull_down_menu('products_id', $products_array, (isset($HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : ''), 'onChange="this.form.submit();" size="' . MAX_MANUFACTURERS_LIST . '" style="width: 100%"') . tep_hide_session_id()); new infoBox1($info_box_contents); } ?>
  8. davchi2005

    All products with select

    Solutions <?php $products_query = tep_db_query("SELECT products_id, products_name FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE language_id = '" . $languages_id . "' ORDER BY products_name"); if ($number_of_rows = tep_db_num_rows($products_query)) { $products_array = array(); while ($products = tep_db_fetch_array($products_query)) { $products_name = ((strlen($products['products_name']) > '50') ? substr($products['products_name'], 0, '50') . '..' : $products['products_name']); $products_array[] = array('id' => $products['products_id'], 'text' => $products_name); } $info_box_contents = array(); $info_box_contents[] = array('form' => tep_draw_form('products', tep_href_link(FILENAME_PRODUCT_INFO, '', 'NONSSL', false), 'get'), 'text' => tep_draw_pull_down_menu('products_id', $products_array, (isset($HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : ''), 'onChange="this.form.submit();" size="' . MAX_MANUFACTURERS_LIST . '" style="width: 100%"') . tep_hide_session_id()); new infoBox1($info_box_contents); } ?> and include status ? any idea
  9. davchi2005

    Article Manager v1.0 + Menu CSS

    Nadie puede ayudarme?
  10. davchi2005

    Article Manager v1.0 + Menu CSS

    Error Warning: Invalid argument supplied for foreach() in C:\wamp\www\catalog\includes\boxes\articles_css.php on line 244 Please HELP <? // cssMenu - Begin of configuration // $cssMenuConfig1 = array(); $cssMenuConfig1['ShowEmptyCategories'] = true; $cssMenuConfig1['includeProducts'] = false; // Should CSSMenu show products $cssMenuConfig1['maxProductsInMenu'] = 8; // Maximum number of products to show in a menu ( stops massive menus being created ) $cssMenuConfig1['moreText'] = "More...."; // Maximum number of products to show in a menu ( stops massive menus being created ) $cssMenuConfig1['showSubMenu'] = true; // Show category dependent menu // $cssMenuConfig['idSubMenu'] = array('619', '620'); // Category id for the dependent menu // cssMenu - End of configuration // $topics_subs = array(); $topics_start = array(); $topics_subs_query = tep_db_query("select count(*) as count, parent_id from " . TABLE_TOPICS . " GROUP BY parent_id"); while($row = tep_db_fetch_array($topics_subs_query)) { $topics_subs[$row['parent_id']] = $row['count']; } $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($row = tep_db_fetch_array($topics_query)) { $topics_start['T_' . $row['topics_id'] . '_' . $row['parent_id'] . '_F'] = $row; } ?> <style type="text/css"> /*Credits: Dynamic Drive CSS Library */ /*URL: [url="http://www.dynamicdrive.com/style/"]http://www.dynamicdrive.com/style/[/url] */ .suckerdiv ul{ margin: 0; padding: 0; list-style-type: none; width: 146px; /* Width of Menu Items */ border-bottom: 1px solid #2D3D4C; font-family: arial; font-size: 12px; } .suckerdiv ul li{ position: relative; } /*1st level sub menu style */ .suckerdiv ul li ul{ left: 146px; /* Parent menu width - 1*/ position: absolute; width: 145px; /*sub menu width*/ top: 0; display: none; } /*All subsequent sub menu levels offset */ .suckerdiv ul li ul li ul{ left: 145px; /* Parent menu width - 1*/ } /*All subsequent sub menu levels offset */ .suckerdiv ul li ul li a{ left: 145px; /* Parent menu width - 1*/ background-color: #FFFFFF; } /*All subsequent sub menu levels offset */ .suckerdiv ul li ul li ul li a{ background-color: #FFFFFF; } /*All subsequent sub menu levels offset */ .suckerdiv ul li ul li ul li ul li a{ background-color: #FFFFFF; } /* menu links style */ .suckerdiv ul li a{ display: block; color: #000000; text-decoration: none; background-color: #FFFFFF; padding: 1px 5px; border: 1px solid #2D3D4C; border-right: 0; border-bottom: 0; line-height: 1.75em; } .suckerdiv ul li a:hover{ background-color: #D6D6D6; color: black; text-decoration: none; } .suckerdiv ul li ul li a:hover{ background-color: #D6D6D6; color: black; text-decoration: none; } .suckerdiv ul li ul li ul li a:hover{ background-color: #D6D6D6; color: black; text-decoration: none; } /* The main categories with sub-categories */ .suckerdiv .subfolderstyle{ background: url(images/arrow-list.gif) no-repeat center right; } /* This one colors the sub-folder with other sub-folders */ .suckerdiv ul li ul .subfolderstyle { background-color: #D6D6D6; } /* This one colors the sub-folder with other sub-folders */ .suckerdiv ul li ul li ul .subfolderstyle { background-color: #D6D6D6; } /* This one colors the sub-folder with other sub-folders */ .suckerdiv ul li ul li ul li ul .subfolderstyle { background-color: #D6D6D6; } /* Holly Hack for IE \*/ * html .suckerdiv ul li { float: left; height: 1%; } * html .suckerdiv ul li a { height: 1%; } /* End */ </style> <script type="text/javascript"> //SuckerTree Vertical Menu (Aug 4th, 06) //By Dynamic Drive: [url="http://www.dynamicdrive.com/style/"]http://www.dynamicdrive.com/style/[/url] var menuids=["suckertree1"] //Enter id(s) of SuckerTree UL menus, separated by commas function buildsubmenus(){ for (var i=0; i<menuids.length; i++){ var ultags=document.getElementById(menuids[i]).getElementsByTagName("ul") for (var t=0; t<ultags.length; t++){ ultags[t].parentNode.getElementsByTagName("a")[0].className="subfolderstyle" ultags[t].parentNode.onmouseover=function(){ this.getElementsByTagName("ul")[0].style.display="block" } ultags[t].parentNode.onmouseout=function(){ this.getElementsByTagName("ul")[0].style.display="none" } } } } if (window.addEventListener) window.addEventListener("load", buildsubmenus, false) else if (window.attachEvent) window.attachEvent("onload", buildsubmenus) </script> <? function PrintArticles( $topics_id, $topics_string , $includeul, $languageID) { global $cssMenuConfig1; $article_path="article_info.php?cPath=".$article_id."&article_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 = '0' and t.topics_id = td.topics_id and td.language_id = '" . (int)$languages_id . "' order by sort_order, td.topics_name"); //$articles_query = tep_db_query("select pc.articles_id, pc.categories_id from articles_to_categories pc, articles p where pc.categories_id = " . $category_id . " and p.articles_id = pc.articles_id and articles_status=1 order by articles_price"); $articlesDisplay=mysql_num_rows( $articles_query ); $addMore= false; if ( $includeul && $articlesDisplay > 0 ) { $returnval .= "<ul>"; } if ( $articlesDisplay > $cssMenuConfig1['maxarticlesInMenu'] ) { $articlesDisplay=$cssMenuConfig1['maxarticlesInMenu']; $addMore= true; } $count_string = ''; if (SHOW_COUNTS == 'true') { if ($totalitemsincategory > 0) { $count_string = ' (' . $totalitemsincategory . ')'; } } $i=0; while ($i < $articlesDisplay) { $articles = tep_db_fetch_array($articles_query); $article_query = tep_db_query("select articles_name from articles_description where articles_id = " . $articles['articles_id'] . " AND language_id = ".$languageID ); $article = tep_db_fetch_array($article_query); $returnval .= "<li><a href='".$article_path.$articles['articles_id']."'>".$article['articles_name']."</a></li>\n"; $i++; } if ( $addMore ) { $returnval .= "<li><a href='".$topics_string."'>".$cssMenuConfig1['moreText']."</a></li>\n"; } if ( $articlesDisplay > 0 || !$includeul ) { $returnval .= "</ul>"; } return $returnval; } function PrintSubTopics( $parentID, $languageID, $start_path ){ global $cssMenuConfig1, $topics_subs, $topics_start; $returnval = ''; if (($start_path == '') && ($parentID > 0)) { $start_path = $parentID; } else { if ($parentID > 0) $start_path .= "_" . $parentID; } if ($parentID != 0) { $returnval .= "<ul>"; } else { $returnval .= "<div class='suckerdiv'>"; $returnval .= "<ul id='suckertree1'>"; } // $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 = '".$parentID."' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languageID ."' order by sort_order, cd.categories_name"); $top_subs = array(); foreach($topics_start as $key => $value) { if(strstr($key, '_' . $parentID . '_F')) { $top_subs[$parentID][] = substr($key, 2, strpos($key, "_", 2) - 2); } } // if (!isset($_GET['cPath'])) { foreach ($top_subs[$parentID] as $v) { //$categories = tep_db_fetch_array($categories_query) $topics = $topics_start['T_' . $v . '_' . $parentID . '_F']; if ($start_path == "") { $grouppath = $topics['topics_id']; } else { $grouppath = $start_path . "_" . $topics['topics_id']; } $tPath_new = 'tPath=' . $grouppath; $topics_string = tep_href_link(FILENAME_ARTICLES, $tPath_new); $totalitemsintopic = tep_count_articles_in_topic($topics['topics_id']); $count_string = ''; if ((SHOW_COUNTS == 'false') && ($totalitemsintopic > 0) ){ $count_string = ' (' . $totalitemsintopic . ')'; } if (cssMenu_ShowTopics($cssMenuConfig1['ShowEmptyTopics'], $totalitemsintopic)) { $returnval .= "<li><a href='".$topics_string."'>".$topics['topics_name'].$count_string."</a>\n"; } if (array_key_exists($topics['topics_id'], $topics_subs)) { //tep_has_category_subcategories($categories['categories_id']) $returnval .= PrintSubTopics( $topics['topics_id'], $languageID, $start_path ); if ( $cssMenuConfig1['includearticles'] ) { $returnval .= PrintArticles($topics['topics_id'],$topics_string, false, $languageID); } } else { if ( $cssMenuConfig1['includearticles'] ) { $returnval .= PrintArticles($topics['topics_id'],$topics_string, true, $languageID); } } if (cssMenu_ShowTopics($cssMenuConfig1['ShowEmptyTopics'], $totalitemsintopics)) { $returnval .= "</li>"; } } // } if ( !$cssMenuConfig1['includearticles'] ) { $returnval .= "</ul>"; } if ($parentID == 0) $returnval .= "</div>"; return $returnval; } function cssMenu_ShowTopics( $switch, $articles) { if ( $switch == 1 ) { return true; } else { if ($articles > 0) { return true; } else { return false; } } } ?> <!-- topics //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => PrintSubTopics( 0, $languages_id, '' )); new infoBox2($info_box_contents); ?> </td> </tr>
  11. davchi2005

    Sorting Customers

    Thank you
  12. davchi2005

    Sorting Customers

    <?php switch ($listing) { case "id-asc": $order = "c.customers_id"; break; case "firstname": $order = "c.customers_firstname"; break; case "firstname-desc": $order = "c.customers_firstname DESC"; break; case "lastname": $order = "c.customers_lastname, c.customers_firstname"; break; case "lastname-desc": $order = "c.customers_lastname DESC, c.customers_firstname"; break; default: $order = "c.customers_id DESC"; } ?> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><a href="<?php echo "$PHP_SELF?listing=lastname"; ?>"><?php echo tep_image_button('ic_up.gif', ' Sort ' . TABLE_HEADING_LASTNAME . ' --> A-B-C From Top '); ?></a> <a href="<?php echo "$PHP_SELF?listing=lastname-desc"; ?>"><?php echo tep_image_button('ic_down.gif', ' Sort ' . TABLE_HEADING_LASTNAME . ' --> Z-X-Y From Top '); ?></a><br><?php echo TABLE_HEADING_LASTNAME; ?></td> <td class="dataTableHeadingContent"><a href="<?php echo "$PHP_SELF?listing=firstname"; ?>"><?php echo tep_image_button('ic_up.gif', ' Sort ' . TABLE_HEADING_FIRSTNAME . ' --> A-B-C From Top '); ?></a> <a href="<?php echo "$PHP_SELF?listing=firstname-desc"; ?>"><?php echo tep_image_button('ic_down.gif', ' Sort ' . TABLE_HEADING_FIRSTNAME . ' --> Z-X-Y From Top '); ?></a><br><?php echo TABLE_HEADING_FIRSTNAME; ?></td> <td class="dataTableHeadingContent" align="right"><a href="<?php echo "$PHP_SELF?listing=id-asc"; ?>"><?php echo tep_image_button('ic_up.gif', ' Sort ' . TABLE_HEADING_ACCOUNT_CREATED . ' --> 1-2-3 From Top '); ?></a> <a href="<?php echo "$PHP_SELF?listing=id-desc"; ?>"><?php echo tep_image_button('ic_down.gif', ' Sort ' . TABLE_HEADING_ACCOUNT_CREATED . ' --> 3-2-1 From Top '); ?></a><br><?php echo TABLE_HEADING_ACCOUNT_CREATED; ?> </td><td class="dataTableHeadingContent" align="right"><br><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $search = ''; if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) { $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search'])); $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by $order"; $customers_split = new splitPageResults($HTTP_GET_VARS['page'], '15', $customers_query_raw, $customers_query_numrows); $customers_query = tep_db_query($customers_query_raw); while ($customers = tep_db_fetch_array($customers_query)) { $info_query = tep_db_query("select customers_info_date_account_created as date_account_created, customers_info_date_account_last_modified as date_account_last_modified, customers_info_date_of_last_logon as date_last_logon, customers_info_number_of_logons as number_of_logons from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customers['customers_id'] . "'"); $info = tep_db_fetch_array($info_query); For RC2 MySQL 4.1.22-standard Version PHP: 4.4.4 (Zend: 1.3.0) Servidor HTTP: Apache/1.3.37
  13. davchi2005

    Bundled Products

    How to make bundled products in product_linting, advanced search result and the entire site Thanks
  14. davchi2005

    Not working

    Someone hiozo work, any ideas <?php // BOF Separate Pricing Per Customer if(!tep_session_is_registered('sppc_customer_group_id')) { $customer_group_id = '0'; } else { $customer_group_id = $sppc_customer_group_id; } // EOF Separate Pricing Per Customer if ($product_info['products_bundle'] == "yes") { $products_bundle = $product_info['products_bundle']; //echo TEXT_BUNDLE_CONTENTS . "<br><table>"; if ($customer_group_id != '0') { $bundle_query = tep_db_query(" SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, pgp.products_price FROM products p LEFT JOIN products_group_prices_cg_".(int)$customer_group_id." pgp using(products_id) INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'"); } else { $bundle_query = tep_db_query(" SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'"); } Error 1146 - Table 'patagonia.products_group_prices_cg_2' doesn't exist SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, pgp.products_price FROM products p LEFT JOIN products_group_prices_cg_2 pgp using(products_id) INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = 29 and language_id = '3' Im using Bundle 1.5.1 and SPPC 4.2
  15. davchi2005

    Not working

    not work 1146 - Table 'patagonia.products_group_prices_cg_2' doesn't exist SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, pgp.products_price FROM products p LEFT JOIN products_group_prices_cg_2 pgp using(products_id) INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = 29 and language_id = '3' any help or idea
  16. davchi2005

    Not working

    Not work error 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2 pgp using(products_id) INNER JOIN products_description pd ON p.products_id=pd' at line 2 SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, pgp.products_price FROM products p LEFT JOIN customer_group_id=2 pgp using(products_id) INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = 29 and language_id = '3' SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, pgp.products_price FROM products p LEFT JOIN customer_group_id=".(int)$customer_group_id." pgp using(products_id) INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'"); } else { $bundle_query = tep_db_query(" SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'"); } any ideas Help
  17. Someone did for sppc // We show them all // BOF Separate Pricing Per Customer --last query changed for mysql 5 compatibility if ($status_product_prices_table == true) { // original, no need to change for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // either retail or no need to get correct special prices -- changed for mysql 5 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } // end else { // either retail... // EOF Separate Pricing per Customer
  18. davchi2005

    Anyone can help us?

    Anyone can help us??
  19. Anyone can help us?? The code function GetAllZones() { $zones_query = tep_db_query("SELECT z.zone_code, z.zone_name FROM zones as z,countries as c, configuration as co, geo_zones as g WHERE co.configuration_value = g.geo_zone_id AND co.configuration_key = 'MODULE_SHIPPING_INDVSHIP_ZONE' AND g.geo_zone_name = c.countries_name AND c.countries_id=z.zone_country_id"); while ($row = tep_db_fetch_array($zones_query)) { $array[$row['zone_code']] = $row['zone_name']; } return $array; }
  20. davchi2005

    [Contribution] Extra Fields

    nobody that can do it
  21. davchi2005

    View example

    http://www.wizardscupboard.com/advanced_search.php somebody has done it
  22. davchi2005

    [Contribution] Extra Fields

    like doing checkbox with extra fields in advanced_search and advanced_search_result. something thus, extra fields=aire in advanced search checkbox for aire example: http://www.carone.com.ar/carone-0km.php
  23. davchi2005

    Help Please

    like doing checkbox with extra fields in advanced_search and advanced_search_result. something thus, extra fields=aire in advanced search checkbox for aire example: http://www.carone.com.ar/carone-0km.php
×