Jump to content

paulchen2005

Members
  • Content count

    154
  • Joined

  • Last visited

2 Followers

Profile Information

  • Real Name
    Paul
  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????
×