attach($this, array('NOTIFY_HEADER_START_CHECKOUT_SUCCESS')); } function update(&$class, $eventID, $paramsArray) { if (FEC_CHECKBOX == 'true') { global $db; // find out the last order number generated for this customer account $orders_query = "SELECT * FROM " . TABLE_ORDERS . " WHERE customers_id = :customersID ORDER BY date_purchased DESC LIMIT 1"; $orders_query = $db->bindVars($orders_query, ':customersID', $_SESSION['customer_id'], 'integer'); $orders = $db->Execute($orders_query); $orders_id = $orders->fields['orders_id']; // use order-id generated by the actual order process // this uses the SESSION orders_id, or if doesn't exist, grabs most recent order # for this cust (needed for paypal et al). // Needs reworking in v1.4 for checkout-rewrite $zv_orders_id = (isset($_SESSION['order_number_created']) && $_SESSION['order_number_created'] >= 1) ? $_SESSION['order_number_created'] : $orders_id; $orders_id = $zv_orders_id; // get the value of the checkbox $checkbox = ($_SESSION['fec_checkbox'] == '1' ? 1 : 0); // add checkbox value option to the orders table $db->Execute("UPDATE " . TABLE_ORDERS . " SET checkbox = '" . $checkbox . "' WHERE orders_id = " . $orders_id . " LIMIT 1"); // unset sessions unset($_SESSION['fec_checkbox']); } } } // eof