function magicalInsert($row)
{
// send the appropriate data to insert customer
$customer = array_slice($row, 0, 14, true);
print_r("customer");
print_r($customer);
$CID = dbInsertNewCustomer($customer);
// send the appropriate data to insert order
$order = array_slice($row, 14, 19, true);
print_r("order");
print_r($order);
$OID = dbInsertNewOrder($CID, $order);
// send the appropriate data to insert items
$products = array_slice($row, 33, 1, true);
$items = $products["Products"];
foreach ($items as $item) {
print_r("item");
print_r($item);
dbInsertNewItem($OID, $item);
}
}
function addOrderToDataBase($CID, $data)
{
global $SETTINGS;
$OID = dbInsertNewOrder($CID, translateOrderInfo($data));
$item = array();
for ($i = 1; $i <= $SETTINGS["MaxItems"]; $i++) {
$item["PKID"] = $data["packages{$i}"];
$item["Personality"] = $data["personality{$i}"];
$item["Quantity"] = $data["quantity{$i}"];
if ($item["Quantity"] != 0) {
$IID = dbInsertNewItem($OID, $item);
}
}
return $OID;
}
function dbReplaceOrder($CID, $row)
{
return dbInsertNewOrder($CID, $row, true);
}
