Latest News: (loading..)

paulchen2005

Members
  • Content count

    144
  • Joined

  • Last visited

About paulchen2005

Profile Information

  • Real Name
    Paul
  1. 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
  2. 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
  3. 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
  4. 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?
  5. 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
  6. The customers_ID in database is 0... that is not correct if i create a order for an existing customer... :(
  7. 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... :)
  8. 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 :)
  9. 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 ;)
  10. 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
  11. Hi, it works only if your product has one attribute... if the product has more than one attribute it works not :(
  12. 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?
  13. 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????
  14. yes, i think too... but what is wrong?