Jump to content

paulchen2005

Members
  • Content count

    154
  • Joined

  • Last visited

Everything posted by paulchen2005

  1. paulchen2005

    Update osCommerce 2.2 Milestone 2

    Hi, ich empfehle dass Ihr euer Shop local, z.b. mit XAMPP, installiert, dann könnt Ihr dort in Ruhe alle Updates einbauen und testen ob noch alles funktioniert ohne den live shop zu stören, denn das wird einige Zeit beanspruchen... und wenn alles funktioniert könnt ihr, wenn Ihr fertig seit, die Daten hochladen da Ihr jedoch einen Kauf Shop habt wird es schwierig Unterstützung zu bekommen sollten Probleme auftreten... Gruß Paul
  2. paulchen2005

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    ok, please, can you say what must i change in the classes/seo_class.php for send a 404 if a product, categorie or manufacturer is not found? thank you very much, best regards, Paul
  3. paulchen2005

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    Hi Jack, first, sorry for my bad english... i install your SEO contrib and i have on big problem... i have in .htaccess this line: ErrorDocument 404 /catalog/404.php but there ist no redirect to the page 404.php if not found a product or category :( what must i change??? thank you, best regards Paul
  4. paulchen2005

    Header Tags SEO

    Hi, i have install this great contrib in my shop local with xampp :) i have 480 products on my xampp shop... i have: but i have this error: and if i press F5 after some Time this error: what can i do to fill all my tags? the error is coming if i use this option: Keywords Override -Fill keywords for all added pages from derived keywords on actual pages? thank you if you can help me best regards Paul
  5. paulchen2005

    NEW! Complete Order Editing Tool!

    Hi, i see the error is in the sort_order... what must i change to set the sort_order like the config in the admin?
  6. paulchen2005

    NEW! Complete Order Editing Tool!

    Hello, I would like to know how I can push in order editor in the list below to display the order total value added to bottom? the time it looks like this: but how do I reach it, as to get by somehow not ...:( I hope someone can help me? greetings Paul
  7. paulchen2005

    NEW! Complete Order Editing Tool!

    The customers_ID in database is 0... that is not correct if i create a order for an existing customer... :(
  8. paulchen2005

    NEW! Complete Order Editing Tool!

    Hi, very important is this fix: before: sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); // update the stock tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = products_stock_quantity + ".$order['products_quantity'] . " where products_id= '" . (int)$order['products_id'] . "' and products_stock_attributes='".$products_stock_attributes."'"); add: if (!empty($products_stock_attributes)) { and after the code add: } this is important because there is an error if i delete or update a product without attribute... :)
  9. paulchen2005

    NEW! Complete Order Editing Tool!

    Hi, here is the next very important bug fix: in: admin/edit_orders_add_product.php: in line 142 under //end sppc patch add: // QT Pro Addon BOF if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $products_stock_attributes[] = $option_id . '-'. $option_value_id; } // for loop sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); } // QT Pro Addon EOF under: 'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']), add: 'products_stock_attributes' => $products_stock_attributes); like this: 'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']), 'products_stock_attributes' => $products_stock_attributes); under: // QT Pro Addon BOF delete: if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $products_stock_attributes[] = $option_id . '-'. $option_value_id; } // for loop sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); and under: tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = ".$new_quantity." where products_id=" . $_POST['add_product_products_id']. " and products_stock_attributes='".$products_stock_attributes."'"); delete: } like this: //end sppc patch // QT Pro Addon BOF if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $products_stock_attributes[] = $option_id . '-'. $option_value_id; } // for loop sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); } // QT Pro Addon EOF $sql_data_array = array('orders_id' => tep_db_prepare_input($oID), 'products_id' => tep_db_prepare_input($add_product_products_id), 'products_model' => tep_db_prepare_input($product['products_model']), 'products_name' => tep_db_prepare_input($product['products_name']), 'products_price' => tep_db_prepare_input($product['products_price']), 'final_price' => tep_db_prepare_input(($product['products_price'] + $AddedOptionsPrice)), 'products_tax' => tep_db_prepare_input($products_tax), 'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']), 'products_stock_attributes' => $products_stock_attributes); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $new_product_id = tep_db_insert_id(); if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $sql_data_array = array('orders_id' => tep_db_prepare_input($oID), 'orders_products_id' => tep_db_prepare_input($new_product_id), 'products_options' => tep_db_prepare_input($option_names[$option_id]), 'products_options_values' => tep_db_prepare_input($option_values_names[$option_value_id]), 'options_values_price' => tep_db_prepare_input($option_value_details[$option_id][$option_value_id]['options_values_price']), 'price_prefix' => tep_db_prepare_input($option_value_details[$option_id][$option_value_id]['price_prefix'])); tep_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); //add on for downloads if (DOWNLOAD_ENABLED == 'true' && isset($filename[$option_id])) { $Query = "INSERT INTO " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " SET orders_id = '" . tep_db_prepare_input($oID) . "', orders_products_id = '" . tep_db_prepare_input($new_product_id) . "', orders_products_filename = '" . tep_db_prepare_input($filename[$option_id]) . "', download_maxdays = '" . tep_db_prepare_input($maxdays[$option_id]) . "', download_count = '" . tep_db_prepare_input($maxcount[$option_id]) . "'"; tep_db_query($Query); } //end if (DOWNLOAD_ENABLED == 'true') { //end downloads } } // Update inventory Quantity // This is only done if store is set up to use stock if (STOCK_LIMITED == 'true'){ tep_db_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity = products_quantity - " . $_POST['add_product_quantity'] . " WHERE products_id = '" . $_POST['add_product_products_id'] . "'"); // QT Pro Addon BOF $stock_chk_q = tep_db_query("select * from " . TABLE_PRODUCTS_STOCK . " where products_id=" . $_POST['add_product_products_id']. " and products_stock_attributes='".$products_stock_attributes."'"); $stock_chk_arr = tep_db_fetch_array($stock_chk_q); $new_quantity = $stock_chk_arr['products_stock_quantity'] - $_POST['add_product_quantity']; // update the stock tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = ".$new_quantity." where products_id=" . $_POST['add_product_products_id']. " and products_stock_attributes='".$products_stock_attributes."'"); // QT Pro Addon EOF now will saved products_stock_attributes in TABLE_ORDERS_PRODUCTS and if i delete the complete order in orders.php the qtpro stock will be update correct :)
  10. paulchen2005

    NEW! Complete Order Editing Tool!

    yes, the one block is for update quantity and the other if i delete a product... in /admin/edit_orders.php are 2 blocks to change same think like above, one block is for update quantity and the other if i delete a product... :) but this is not important if you use the ajax method ;)
  11. paulchen2005

    NEW! Complete Order Editing Tool!

    Hi, here is my fix, it works :) $attrib_q = tep_db_query("select distinct op.products_id, po.products_options_id, pov.products_options_values_id , pov.products_options_values_name,opa.products_options_values, opa.products_options, opa.products_options_values from products_options po, products_options_values pov, products_options_values_to_products_options po2pov, orders_products_attributes opa, orders_products op where op.orders_id = '" . $_GET['oID'] . "' and opa.orders_id = '" . $_GET['oID'] . "' and op.orders_products_id = '" . $_GET['pid'] . "' and opa.orders_products_id = '" . $_GET['pid'] . "' and po.products_options_name = opa.products_options and pov.products_options_values_name = opa.products_options_values "); best regards Paul
  12. paulchen2005

    NEW! Complete Order Editing Tool!

    Hi, it works only if your product has one attribute... if the product has more than one attribute it works not :(
  13. paulchen2005

    NEW! Complete Order Editing Tool!

    the problem is this part: and products_stock_attributes='".$products_stock_attributes."' because products_stock_attributes is 1,2-2,2 but $products_stock_attributes is 1-2 ??? what can i do?
  14. paulchen2005

    NEW! Complete Order Editing Tool!

    the error was in this code: // QT Pro Addon BOF $attrib_q = tep_db_query("select distinct op.products_id, po.products_options_id, pov.products_options_values_id from products_options po, products_options_values pov, products_options_values_to_products_options po2pov, orders_products_attributes opa, orders_products op where op.orders_id = '" . $oID . "' and op.orders_products_id = '" . $orders_products_id . "' and products_options_values_name = opa.products_options_values and pov.products_options_values_id = po2pov.products_options_values_id and po.products_options_id = po2pov.products_options_id and products_options_name = opa.products_options"); while($attrib_set = tep_db_fetch_array($attrib_q)) { // corresponding to each option find the attribute ids ( opts and values id ) $products_stock_attributes[] = $attrib_set['products_options_id'].'-'.$attrib_set['products_options_values_id']; } sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); // update the stock tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = products_stock_quantity + ".$products_details["qty"] . " where products_id= '" . $order_products['products_id'] . "' and products_stock_attributes='".$products_stock_attributes."'"); // QT Pro Addon EOF because this part: where products_id= '" . $order_products['products_id'] . "' and products_stock_attributes='".$products_stock_attributes."'"); what must i change to ask about products_stock_id and not products_stock_attributes in where clause????
  15. paulchen2005

    NEW! Complete Order Editing Tool!

    yes, i think too... but what is wrong?
  16. paulchen2005

    NEW! Complete Order Editing Tool!

    i have the problem too.... if i delete orders with qtpro that was never edited it works fine!!! but not with edited orders and qtpro best regards Paul
  17. paulchen2005

    Manual Order Maker

    hi, great job, thank you for that contrib :) i have a question please, what must i change to add a product manual (without my productlist) ? what must i change to create an input field for manual products input in orderlist? thank you best regards Paul
  18. paulchen2005

    RSS Feed contribution support thread

    Hi, i have installed this great contrib and i installed your update but i can not see the page like your screenshot... what must i do to see my page with products like your screenshot? thank you very much, best regards Paul
  19. paulchen2005

    fast easy checkout

    Hi, what must i change in checkout_shipping_adress.php if the customer without account only edit one error in her address? i can only create a new adress but i can not edit my adress <_< can someone help me to change the checkout_shipping_adress.php that the customer can edit the adress??? thank you very much!!!
  20. Hi, is it possible to combined the login site with create account and this PWA ? i think to use a radio button to register with account or no account... is it possible? what must i change to do that? thank you
  21. paulchen2005

    RMA Returns error for 2.2 MS2

    Hi, this contrib dont work with attribute and it work not with QTpro... what must i change to work with it? thank you
  22. paulchen2005

    Official PayPal IPN Support Thread

    Hi, is anyone here for help me? i want to start the paypal site only in checkout_success.php ... what must i change? best regards
  23. paulchen2005

    Header Tags SEO

    thank you i have install your contrib Header Tags Controller V2.6.3 Complete ... must i deinstall it to install this contrib ? best regards
  24. paulchen2005

    Easy Populate & Products Attributes

    Hi, what must i change to use easypopulate with the cross sell contrib ??? thank you
×