Thank you Ray for your time. I hope you can replicate and provide a fix for everyone in your next update. As requested at the time of the call I have found 2 more bugs.
Whenever you amend or insert a WA eCart Get Info From MySQLi RS if corrupts the recordset:
Original recordset:
<?php
$rs_new_order_detail = new WA_MySQLi_RS("rs_new_order_detail",$dmbc_database,0);
$rs_new_order_detail->setQuery("SELECT * FROM cartdetail WHERE orderid = ? ORDER BY packingorder, itemnumber");
$rs_new_order_detail->bindParam("int", "".(isset($_SESSION['order_id'])?$_SESSION['order_id']:"") ."", "-1"); //colname
$rs_new_order_detail->execute();
?>
Recordset after amending or inserting a WA eCart Get Info From MySQLi RS:
<?php
$rs_new_order_detail = new WA_MySQLi_RS("rs_new_order_detail",$dmbc_database,0);
$rs_new_order_detail->setQuery("SELECT * FROM cartdetail WHERE orderid = %s ORDER BY packingorder, itemnumber");
$rs_new_order_detail->bindParam("int", "".(isset($_SESSION['order_id'])?$_SESSION['order_id']:"") ."", "-1"); //colname
$rs_new_order_detail->execute();
?>
it corrupts the WHERE orderid =
Also when you change the default 1 to a zero in the following code:
$dmbc_in_stock->AddToCart(1, "", $dmbc_in_stock_itemID, $dmbc_in_stock_itemName, $dmbc_in_stock_itemDescription, $dmbc_in_stock_itemThumbnail, $dmbc_in_stock_itemWeight, $dmbc_in_stock_itemQuantity, $dmbc_in_stock_itemPrice, $dmbc_in_stock_itemPack, $dmbc_in_stock_itemVD, $dmbc_in_stock_itemLocation, $dmbc_in_stock_itemCost, $dmbc_in_stock_itemCategory, $dmbc_in_stock_itemSupplier);
Dreamweaver freezes/timesout for around 60 seconds and displays this error:
---------------------------
Dreamweaver
---------------------------
A script in file UNKNOWN has been running for a long time. Do you want to continue?
---------------------------
Yes No
---------------------------