Latest News: (loading..)

yustis_83

Members
  • Content count

    92
  • Joined

  • Last visited

1 Follower

About yustis_83

Profile Information

  • Real Name
    oscar
  1. Hello everyone i downloaded and installed the ULTIMATE SEO URLs contribution. now the problem that i have is that the "add to cart" button is not working i already tried to find a solution for this and i can't find it. please if someone know why is this happening and how to solve it it would be awsome. Please help me ! thank you in advance.
  2. i have a problem hopefully you guys can help me with this. The problem is that my "sale" price doesn't show on my "specials.php" only shows after i go into productinfo heres my specials code please if someone can take a look at this and let me know what am i doing wrong i would really appreciate it !!:) <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SPECIALS); $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; $need_manufacturer = false; for ($i = 0, $n = sizeof($column_list); $i < $n; ++$i) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; $need_manufacturer = true; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // start building the sql $listing_sql = "SELECT DISTINCT " . $select_column_list . " p.products_id, p.products_image, p.products_price, p.products_tax_class_id "; // add the tables to be selected from if ($need_manufacturer === true) { $listing_sql .= " FROM (" . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_SPECIALS . " s using(products_id) ) LEFT JOIN " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd "; } else { $listing_sql .= " FROM (" . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_SPECIALS . " s using(products_id) ), " . TABLE_PRODUCTS_DESCRIPTION . " pd "; } // now add the where conditions $listing_sql .= " WHERE s.status = '1' AND p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '" . (int)$languages_id . "' "; // and finially add the order by as needed if ( (!isset($_GET['sort'])) || (!ereg('[1-8][ad]', $_GET['sort'])) || (substr($_GET['sort'], 0, 1) > sizeof($column_list)) ) { $sort_column = CATEGORIES_SORT_ORDER; $sort_order = 'a'; } else { $sort_col = substr($_GET['sort'], 0 , 1); $sort_column = $column_list[$sort_col-1]; $sort_order = substr($_GET['sort'], 1); } // check to see if it is one of the columns being allowed for switch ($sort_column) { case 'PRODUCT_LIST_MODEL': $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': // sorting by image name makes no sense, so just ignore it break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SPECIALS)); $content = CONTENT_SPECIALS; require(DIR_WS_TEMPLATES . TEMPLATE_NAME . '/' . TEMPLATENAME_MAIN_PAGE); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>