Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

kdawg62

Archived
  • Posts

    4
  • Joined

  • Last visited

Everything posted by kdawg62

  1. Steve, I to get the error No Right Permission Access Please contact your Webmaster to request more access or if you found any problem. I am logged in as top administrator, i have changed file permissions to 755.. 644...444 nothing seems to work. any ideas? I use creloaded 6.15 and cannot get the security error bar across the top of the home page off. Thanks Kyle
  2. Trying to install both the msrp and minium advertised price contributions. Everything went smooth except on the product_info.php page I'm having trouble combining the two so that when the price of the item is below the 'map' price it will not display the saved percentage and simply display the add to cart text. the MSRP contributions has me do this. 6. In catalog/product_info.php starting from the top and moving down, Find: $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); and change it to read: $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_msrp, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); Find: if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } and change it to read: $products_price = '<table class="PriceList" border="0" width="100%" cellspacing="0" cellpadding="0">'; $new_price = tep_get_products_special_price($product_info['products_id']); if ($product_info['products_msrp'] > $product_info['products_price']) $products_price .= '<tr><td>' . TEXT_PRODUCTS_MSRP . '</td><td class="oldPrice" align="right">' . $currencies->display_price($product_info['products_msrp'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</td></tr>'; $products_price .= '<tr><td>' . TEXT_PRODUCTS_OUR_PRICE . '</td>'; if ($new_price != '') {$products_price .= '<td class="oldPrice"';} else {$products_price .= '<td';} $products_price .= ' align=right>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</td></tr>'; if ($new_price != '') {$products_price .= '<tr class="productSpecialPrice"><td>' . TEXT_PRODUCTS_SALE . '</td><td align=right>' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</td></tr>';} if ($product_info['products_msrp'] > $product_info['products_price']) {if ($new_price != '') {$products_price .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . ' (' . ceil((($product_info['products_msrp'] - $new_price) / $product_info['products_msrp']) * 100) . '% )</td></tr>';} else {$products_price .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . ' (' . ceil((($product_info['products_msrp'] - $product_info['products_price']) / $product_info['products_msrp']) * 100) . '% )</td></tr>';}} else {if ($new_price != '') {$products_price .= '<tr><td>' . TEXT_PRODUCTS_SAVINGS . '</td><td align=right>' . ' (' . ceil((($product_info['products_price'] - $new_price) / $product_info['products_price']) * 100) . '% )</td></tr>';}} $products_price .= '</table>'; Find: <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td> and change it to read: <td align="right" valign="top"><?php echo $products_price; ?></td> The 'MAP' Contribution has me doing this. 3.8) product_info.php 1. Added p.products_map to line 72 $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_map, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); 2. Changed Line 72 to(same as 3.4 step 2): if ($product_info['products_price'] < $product_info['products_map']) { $products_price = $currencies->display_price($product_info['products_map'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '<BR>' . MAP_WARNING; } else if ($new_price = tep_get_products_special_price($product_info['products_id'])) { I can't seem to get it right combining the two together to have it display what i need. I am hoping an expert could look at that and see the best way to combine the lines.
  3. Instructions tell me to add this... 1. Add a new field to the products table to hold the MSRP value. ALTER TABLE `products` ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_image` ; I was able to add the rest of the code just fine. I do now know where the products table is located, or which file it refers to. Just need someone to point me in the right direction. Thanks Kyle
×
×
  • Create New...