Jump to content
Latest News: (loading..)

dix4life

Members
  • Content count

    15
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Martin
  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. dix4life

    ORDERLIST - SORT ON PRODUCT NAME

    Hallo, Ik had hem er zo ingeplaatst zoals jij hem nu ook hebt gemaakt. Echter werkte het bij mij niet. Ik zal ergens wel een typ foutje tussen hebben zitten. Ook had ik stiekem al even je site bekeken. Ziet er goed uit zeg. Daar zag ik ook aan dat we ook gewoon Nederlands konden praten echter voor de andere leden dacht ik ik blijf wel in het engels. Super bedankt voor de hulp en dit gaat ons gigantisch veel tijd schelen in alle producten! Echt super super! Ik heb je even toegevoegd in de favorieten. Mocht er wat zijn waar ik bij kan helpen graag. Dat zal niet op mysql gebied zijn wellicht hahaha ;) Gewoon alles uit hobby geleerd? Erg knap! Groetjes Martin
  3. dix4life

    ORDERLIST - SORT ON PRODUCT NAME

    Thanks, But i don't think i get it. Can you please place it for me in the script: <?php $products_query = tep_db_query("SELECT * from " . TABLE_ORDERS . " o join ". TABLE_ORDERS_PRODUCTS . " op using (orders_id) join " . TABLE_ORDERS_STATUS . " os on (o.orders_status = os.orders_status_id) left join ". TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " opa on (op.orders_products_id = opa.orders_products_id) join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using (products_id) join " . TABLE_CATEGORIES_DESCRIPTION . " cd using (categories_id) WHERE (o.orders_status = '1' OR o.orders_status = '2') AND os.language_id = '4' AND cd.language_id = 4 ORDER BY op.products_name"); while($products_rows = tep_db_fetch_array($products_query)) { echo "<tr>"; echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'>" . $products_rows["orders_status_name"] . "</td>"; echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'>" . $products_rows["orders_id"] . "</td>"; echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'>" . $products_rows["categories_name"] . "</td>"; echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'>" . $products_rows["products_quantity"] . "</td>"; echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'>" . $products_rows["products_name"] . "</td>"; echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'>" . $products_rows["products_options_values"] . "</td>"; $english_format_number = number_format($products_rows["products_price"], 2, '.', ''); echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'>€ " . $english_format_number . "</td>"; echo "<td class=dataTableContent style='border: 1px solid #C0C0C0;'><BR></td>"; echo "</tr>"; } ?>
  4. dix4life

    ORDERLIST - SORT ON PRODUCT NAME

    Thanks! This is also working. The only problem now is that some products are in multiple categories. This means in the orderlist the products shows up 2 or even 3 times because of the double categorie. Like this: STATUS ORDER# CATEGORIE QUANTITY PRODUCTNAME SIZE PRICE In behandeling 21897 Jeans 1 q12938-1 - Zwart 38 € 28.88 In behandeling 21897 Leggings 1 q12938-1 - Zwart 38 € 28.88 In behandeling 21897 Broeken 1 q12938-1 - Zwart 38 € 28.88 Is it possible to get it like this: STATUS ORDER# CATEGORIE QUANTITY PRODUCTNAME SIZE PRICE In behandeling 21897 Jeans/Leggings/Broeken 1 q12938-1 - Zwart 38 € 28.88 Again thanks for the help!
  5. dix4life

    ORDERLIST - SORT ON PRODUCT NAME

    Is there also an solution for getting the categorie name where the products is in? Carine Bruyndoncx - I'm very very thankfull for your work today :)
  6. dix4life

    ORDERLIST - SORT ON PRODUCT NAME

    Thanks! Exactly what i want! This is working great. Many thanks! Best regards, Martin
  7. dix4life

    ORDERLIST - SORT ON PRODUCT NAME

    Yes, Now it is working! Thanks! Only he shows both languages now. The Dutch version and english version of the order status. STATUS ORDERID QUANTITY PRODUCTNAME PRICE Payment Received 21887 1 q13952-2 - Licht roze 30.5372 Betaling ontvangen 21887 1 q13952-2 - Licht roze 30.5372 This has to be only one row off course. Further i want to add the size attribute. I have an contribution for attributes. They are stored in the TABLE orders_products_attributes. Then the field orders_id can be linked to get the right row and the field products_options_values shows the size name (like Small, Medium, Large ed.) Hope this is not asked to much. This will help me a lot if this all is working. Thanks in advanced!!
  8. dix4life

    ORDERLIST - SORT ON PRODUCT NAME

    Thanks for your reply! The script you send has been tested and get the following error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')WHERE (o.orders_status = '1' OR o.orders_status = '2')ORDER BY op.products_name' at line 1 SELECT * from orders o join orders_products op using (orders_id) join orders_status os on (o.orders_status = os.orders_status_id.)WHERE (o.orders_status = '1' OR o.orders_status = '2')ORDER BY op.products_name
  9. Hello, I've trying to sort on product name with this script. But everything i try the output always is sort on order number and i want to sort on product name. Please can anyone rewrite this script so the output is sort on product name? Thanks in advanced. <?php $orders_query = tep_db_query("SELECT * from " . TABLE_ORDERS . " WHERE (orders_status = '1' OR orders_status = '2')"); while($orders_rows = tep_db_fetch_array($orders_query)) { $products_query = tep_db_query("SELECT * FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . $orders_rows['orders_id'] . "' ORDER BY products_name"); while($products_rows = tep_db_fetch_array($products_query)) { $ordStatus_query = tep_db_query("SELECT * from " . TABLE_ORDERS_STATUS . " WHERE orders_status_id = '" . $orders_rows['orders_status'] . "' "); $ordStatus_rows = tep_db_fetch_array($ordStatus_query); echo "<tr>"; echo "<td class=dataTableContent>" . $ordStatus_rows["orders_status_name"] . "</td>"; echo "<td class=dataTableContent>" . $orders_rows["orders_id"] . "</td>"; echo "<td class=dataTableContent>" . $products_rows["products_quantity"] . "</td>"; echo "<td class=dataTableContent>" . $products_rows["products_name"] . "</td>"; echo "<td class=dataTableContent>" . $products_rows["products_price"] . "</td>"; echo "</tr>"; } } ?> Best regards, Martin
  10. 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
  11. 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
  12. 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!
  13. dix4life

    [Contribution] MATC

    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
×