Rumble

I'm sorry im all out of ideas!

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!?

Yup catalog/product_reviews_info.php

i think its in catalog/product_reviews_info.php

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! :)

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

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

try finding the actual code and pasting that line

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.

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

You need to change all instances of tep_array_merge( to...... array_merge( This should fix it for you

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

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

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

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

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

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!

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); }

it could probably be done with iframes

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

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.

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.

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">

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

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