Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dix4life

Pioneers
  • Posts

    15
  • Joined

  • Last visited

Profile Information

  • Real Name
    Martin

dix4life's Achievements

  1. Hello, I've 3 big queries in my shop. Is there someone how can rewrite the contributions? This will be for all users here a great solution! I've installed a querie read tool so i can see on every page how many queries and wich queries are beeing loaded. 1. select specials_new_products_price from specials where products_id = '7230' and status This Is the standard special price querie from Oscommerce i believe. I got this on the products_new.php page. The querie loads for EACH product again. So i have 20 queries for loading on the special price. All products have normaling pricing. 2. I have installed this contribution: http://addons.oscommerce.com/info/2251 I've allready installed the querie reduce contri for the categories. But this contri for an advanced search box on every page also loads the categorie querie. select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and cd.language_id = '4' order by sort_order, cd.categories_name. In my case an extra 35 queries on every page!!! Can someone please look at this beautyfull contri and make it less querie needed please? Thanks! 3. The last contri i have installed how loads a lot of queries is http://addons.oscommerce.com/info/6674. This is also a very nice contri but also takes a lot of queries! I think this is also a simple mod to get the querie count less. I hope someone can help us to rewrite some code to minimize the querie counts. Thanks in advanced all of you! Best regards, Martin
  2. Thank you very much! I'm not that good with PHP. I've manage to get the most deprecated code change by a lot of searching, google, updating contributions. But this one i couldn't find so i thought i post it on the forum so maybe someone can change the code for me. It's only one line. Thanks again. Best regards, Martin
  3. Hello, I have the contribution newsletter_bulk installed (Advanced bulk mailer). Now the following problem has ocured when installing PHP 5.3 on the server. The ereg function has to be changed to i think preg_match. Line 38: if (eregi('^[-a-z0-9._]+@([-a-z0-9_]+\.)+[a-z]{2,6}$',$row['customers_email_address'])) { Can someone please change this to the right PHP 5.3 compatible line? Thanks in advanced! Best regards, Martin
  4. Hello, I've an Oscommerce v2.2RC2a with contribution QT Pro 4.51b. I use the Single radio buttons to show the attributes. When there is an attribute not on stock at the moment i have choosen for the option where it gives a message after the attribute. Like with clothing: Product 1 - S - Sold out! - M - L - Sold out! - XL Well thats no problem. But now i want also a message when they are on stock like this: Product 1 - S - Sold out! - M - Available! - L - Sold out! - XL - Available! This because if all sizes are on stock and the customer didn't look any further.. He don't know if the size is on stock because only sizes there are sold out are highlighted. Please can someone make a simple fix for this and reply where to put some new of changed scripts. Thanks in advanced everybody!
  5. Hello, I'm running the newest version of MATC 2.3.1. With IE 7 and Firefox there are no problems. But now that IE8 is out on the marked it doesnt function 100% anymore. The problem: If you haven't checked the Conditions you can't click on the next button. This is okay. But if you try when it's not checked it supose to be highlight the checkbox and the text before the checkbox.. In IE7 and Firefox this wasn't a problem. in IE8 this won't happen anymore and i can't figure it out what the problem is. If you do this on IE8 with compatible mode on it works again! without compatiblemode it doesnt! Can anyone please help me with this problem?! Thanks in advanced. Best regards, Martin
×
×
  • Create New...