Full contribution

Thanks to Olof Larsson for spotting a block of code I missed out from admin>functions>general.php

function tep_remove_order($order_id, $restock = false) {
if ($restock == 'on') {
//++++ QT Pro: Begin Changed code
$order_query = tep_db_query("select products_id, products_quantity, products_stock_attributes from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
while ($order = tep_db_fetch_array($order_query)) {
$product_stock_adjust = 0;
if (tep_not_null($order['products_stock_attributes'])) {
if ($order['products_stock_attributes'] != '$$DOWNLOAD$$') {
$attributes_stock_query = tep_db_query("SELECT products_stock_quantity
FROM " . TABLE_PRODUCTS_STOCK . "
WHERE products_stock_attributes = '" . $order['products_stock_attributes'] . "'
AND products_id = '" . (int)$order['products_id'] . "'");
if (tep_db_num_rows($attributes_stock_query) > 0) {
$attributes_stock_values = tep_db_fetch_array($attributes_stock_query);
tep_db_query("UPDATE " . TABLE_PRODUCTS_STOCK . "
SET products_stock_quantity = products_stock_quantity + '" . (int)$order['products_quantity'] . "'
WHERE products_stock_attributes = '" . $order['products_stock_attributes'] . "'
AND products_id = '" . (int)$order['products_id'] . "'");
$product_stock_adjust = min($order['products_quantity'], $order['products_quantity']+$attributes_stock_values['products_stock_quantity']);
} else {
tep_db_query("INSERT into " . TABLE_PRODUCTS_STOCK . "
(products_id, products_stock_attributes, products_stock_quantity)
VALUES ('" . (int)$order['products_id'] . "', '" . $order['products_stock_attributes'] . "', '" . (int)$order['products_quantity'] . "')");
$product_stock_adjust = $order['products_quantity'];
}
}
} else {
$product_stock_adjust = $order['products_quantity'];
}
tep_db_query("UPDATE " . TABLE_PRODUCTS . "
SET products_quantity = products_quantity + " . $product_stock_adjust . ", products_ordered = products_ordered - " . (int)$order['products_quantity'] . "
WHERE products_id = '" . (int)$order['products_id'] . "'");
//++++ QT Pro: End Changed Code
}
}

tep_db_query("delete from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");
tep_db_query("delete from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
tep_db_query("delete from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "'");
tep_db_query("delete from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . (int)$order_id . "'");
tep_db_query("delete from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "'");
}




More...