Jump to content

Rumble

Members
  • Content count

    631
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    A Reddy
  • Interests
    F1 Racing!
  1. Rumble

    Problem with review approvals..

    I'm sorry im all out of ideas!
  2. Rumble

    Problem with review approvals..

    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!?
  3. Rumble

    Problem with review approvals..

    Yup catalog/product_reviews_info.php
  4. Rumble

    Problem with review approvals..

    i think its in catalog/product_reviews_info.php
  5. Rumble

    Problem with review approvals..

    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! :)
  6. Rumble

    Problem with review approvals..

    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";
  7. Rumble

    Problem with review approvals..

    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";
  8. Rumble

    Problem with review approvals..

    try finding the actual code and pasting that line
  9. Rumble

    Problem with review approvals..

    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.
  10. Rumble

    Modifying the database

    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
  11. Rumble

    Banner Manager v1.3 error

    You need to change all instances of tep_array_merge( to...... array_merge( This should fix it for you
  12. 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
  13. 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
  14. Rumble

    Automated Keycode Issues

    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
  15. Rumble

    Automated Keycode Issues

    Well done, im guessing this can be used for a calling card business too!?
×