Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
  1. Found out what was wrong in my case. I'm not using boxes/categories.php anymore as I installed a different categories menu some time ago - I should have been editing ul_categories instead. So if you're having this problem, remember to check you're editing the right file for your shop
  2. I'm having the same problem. Looking in the database, the categories_status on an inactive category is correctly set to "0", but it's still showing up in the navigation. Here's the relevant code: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and c.categories_status = 1 and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); You can see the filter - "categories_status = 1" - so it should be ignoring categories_status = 0, right? Anyone got any ideas?
  3. Hi Michael, Did you find a way of displaying those other shipping modules, in addition to the free shipping? I'm having exactly the same problem. I have now installed the module freeamount, and while that displays with the radio button and the other shipping options, it is also displaying for international deliveries (which I don't want). Plus I have had to turn off the default free shipping in oscommerce admin (Modules --> Order Totals --> Shipping), which means I've post the blurb I used to have in the shopping basket that told customers how much they had to order to qualify for free delivery. Swings and roundabouts.... Please let me know if you found a solution that works for you :'( - Becca
  4. Turned out that the problem was actually in includes/classes/shopping_cart.php: // END Patch osc-060817 $check_product_query = tep_db_query("select products_status from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $check_product = tep_db_fetch_array($check_product_query); if (($check_product !== false) && ($check_product['products_status'] == '1')) { if ($notify == true) { $new_products_id_in_cart = $products_id; tep_session_register('new_products_id_in_cart'); } if ($this->in_cart($products_id_string)) { $this->update_quantity($products_id_string, $qty, $attributes); } else { $this->contents[$products_id_string] = array('qty' => $qty); // insert into database See the link saying product_status == 1 ? Changed it to: if (($check_product !== false) && ($check_product['products_status'] <= '1')) { And I can now add the products (which are inactive) to the cart. Hope it helps someone :-) - Becca
  5. There seem to be lots of MySQL 5 issues. Our server was upgraded yesterday, and I haven't stopped fixing things since! The patch from Sir Cuss fixed that problem, but I'm now finding I can't add freebies to the cart. I have had to change the way buy now links are made in the product_listing.php (in catalog/includes/modules/) - for some reason they work with the tep_draw_form function - and I think the dangling carrot issue is related. For example, in product_listing.php the following code: $lc_text = '<form name="buy_now_' . $listing['products_id'] . '" method="post" action="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now', 'NONSSL') . '"><input type="hidden" name="products_id" value="' . $listing['products_id'] . '" />' . tep_image_submit('button_buy_now.gif', TEXT_BUY . $listing_values['products_name'] . TEXT_NOW) . '</form> '; had to be changed to: $lc_text = tep_draw_form('buy_now' . $listing['products_id'], tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']), 'POST') . tep_image_submit('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</form> '; to get products to add to the basket from categories. (This also fixed the same problem with shop_by_price.php and product_reviews_info.php, incidentally). So to get the freebies to add to the cart, I tried this in shopping_cart.php: Replacing the code: $freebie[$p]['link'] = '<form name="buy_now_' . $gift['products_id'] . '" method="post" action="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $gift['products_id']) . '"> <input type="hidden" name="products_id" value="' . $gift['products_id'] . '">' . tep_image_submit('button_add_now.gif', IMAGE_BUTTON_IN_CART) . ' </form>'; $freebie[$p]['link'] = tep_draw_form('buy_now' . $gift['products_id'], tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $gift['products_id']), 'POST') . tep_image_submit('button_add_now.gif', IMAGE_BUTTON_ADD_NOW) . '</form> '; However, still no joy. Anyone got any ideas? TIA, Becca :'(
  6. Hi Jack, This problem was resolved some time ago, and i can't honestly remember what I did to fix it. I either installed a later version or found something on one of the discussion boards. Sorry that I can't give any more info (but thanks for taking the time). Thankfully the dangling carrots are working very successfully on my site - I am sure this contrib has helped with sales :D - Reb
  7. rebelina

    [Contribution] FCKosc 2.2 Support

    Hi, I'm having exactly the same problem with FCKEditor Newsletter HTML. The actual editor seems to work like a dream - I easily put together a nice html newsletter - but when it previews there are many lines of whitespace at the top and during the newsletter. Most importantly, it isn't only the preview - the actual email is also full of whitespace. So, if you're having this problem, don't send be tempted to send it out.... Anyone got a fix (or ideas)? Is this a "problem" with the Editor? I'm thinking it is, particularly looking at what muttsnuts says above - seems to be the way in which FCK saves the file - no good for newsletters??. [Apart from this the only other niggle with the FCKEditor Newsletter HTML contribution is the absence of an opportunity to send a test email to an address - you can only email all of the newsletter subscribers. Nor do you get to see the list of email addresses to which the newsletter will be sent (unless you look in the database)]. Would really like to know if anyone has solved the whitespace issue.... - Reb
  8. I'm having exactly the same problem - cannot update, edit or delete gifts on the admin side. I can insert new ones. Anybody got a solution? Great contribution btw. - Rebecca
  9. Hello. I have installed this contribution, and it is successfully working (big thanks to Nils Petersson). But, in common with some other people who posted here last year, I am trying to display all of the sub-categories automatically, not just when the user clicks on the parent category. I'm looking at categories.php but my php is fairly limited, and so far I haven't been able to do it. Has anyone sussed this out? Or is there another contribution I should be looking at? No other contributions that I can find seem to provide this, at least, not without javascript which I don't want. Hope someone can help! Even just a pointer in the right direction... - Rebelina