Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Rumble

Members
  • Content count

    631
  • Joined

  • Last visited

Everything posted by Rumble

  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!?
  16. A temporary fix to this is to FTP the images yoursef to the correct directory, until you sort out the new product image upload problem
  17. Rumble

    Clean Basket Button

    Hi there, In catalog/shopping_cart.php place this code where you want the clear cart button to appear <?php echo tep_draw_form('cart_clear', tep_href_link(FILENAME_SHOPPING_CART, 'action=clear_cart')); echo tep_image_submit('button_clear_cart.gif', 'Clear Cart'); echo '</form>'; ?> Dont forget you need to create a 'button_clear_cart.gif'. Then in application_top.php place this code around line 400 after case: cust_order case 'clear_cart' : $cart->reset(true); break; Now when you click the button it clears the cart contents Back up before you try!
  18. In your payment module you need something like if ($this->get_order_total() >= 10) { $this->enabled = ((MODULE_PAYMENT_EPT == 'True') ? true : false); } else { $this->enabled = ((MODULE_PAYMENT_EPT == 'False') ? true : false); }
  19. Rumble

    Rotating Specials

    it could probably be done with iframes
  20. Yeah i'm sure if the developers of contributions have the time they will do it. But im sure they would prioritise that conversion/update if your desperacy was coupled with a donation to them! :D
  21. Rumble

    Accounting Contribution

    Theres a report contribution that Gives you Sales and Tax info, might not be exactly what you need but it is a start. This would probably need someone to customise one for you to get the exact results.
  22. Rumble

    OrderCheck v 1.3 Released

    Hi there, I'm having a problem with this contribution. Its working fine-ish for paypal, the order is logged and shows up in the admin>orders page, but it doesnt work for other payment options, (i have one called WorldPay) Also the orders thats are being logged show up in the holding orders tables when i look at the database but dont show up in the admin panel under the Order Check page? Any help would be appreciated.
  23. Rumble

    Domain name

    Why not set up a meta refresh on your index.html page? So when someone hits your domain name 'www.yourdomainname.com' they get redirected automatically to your shop homepage. ie in your head tags place this code <meta http-equiv="refresh" content="1; url=catalog/default.php">
  24. Hi, Can the visitors email address be captured aswell? If not does anyone know of a contribution that can do this Email address Time and date Last URL Thanks in advance
  25. Hi Pablo, In PayPal_ID i’ve put the email address of the business paypal email address. This is the only email address for the account! The money is received when a customer pays and a paypal confirmation is sent to the above email address. And the customer also gets a confirmation email from PayPal. But nothing appears in Admin>PayPal_IPN>Transactions, and no order email is sent to the customer from my store. Thank you
×