Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Rumble

Archived
  • Posts

    631
  • Joined

  • Last visited

Profile Information

  • Real Name
    A Reddy
  • Interests
    F1 Racing!

Rumble's Achievements

  1. Ok last try!!! :D That other line in product_reviews.php try $reviews_query_raw = "select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and rd.languages_id = '" . $languages_id . "' and r.approved='1' order by r.reviews_id DESC"; Last try im all out of suggestions!?
  2. i think its in catalog/product_reviews_info.php
  3. ok revert back to your version of that line, i suspect you've pasted the wrond lin anyway, it should contain select count somewhere in the line we need to fix! So look for that and paste me the line that includes that somewhere in there! :)
  4. Try :) $reviews_query_raw = "select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and rd.languages_id = '" . $languages_id . "' and p2c.categories_id = c.categories_id and r.approved = '1' order by r.reviews_id DESC";
  5. Try $reviews_query_raw = "select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and rd.languages_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and r.approved= '1' order by r.reviews_id DESC";
  6. try finding the actual code and pasting that line
  7. hi you need to change all instances of tep_array_merge( to array_merge( the contributiong was probably written for an earlier version of osCommerce and the function was renamed in later versions.
  8. No you need phpmyadmin or maybe your hosting providers' control panel allows you to adminiter your database. Alternatively, make a backup of your database on your pc, open the file add the sql at the bottom then restore/upload the sql file. These should all work! Happy Halloween! :D
  9. You need to change all instances of tep_array_merge( to...... array_merge( This should fix it for you
  10. in ot_shipping.php find the following function process() { global $order, $currencies; and change to function process() { global $order, $currencies, $shipping_weight; then in your code change from $total_weight = $cart->show_weight(); to..... $total_weight = $shipping_weight; Back up before you try
  11. In catalog/includes/modules/new_products.php change this line 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id']))); to....... 'text' => $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '<br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a>'); Hopefully that should be what you're looking for! Back up before you try! :D
  12. i meant phone cards, long distant calling cards!? Whereby someone buys one and they get sent a pin number etc. I dont need it right now but might be a good one for the future. :D
  13. Well done, im guessing this can be used for a calling card business too!?
×
×
  • Create New...