Can anyone help understand the exact sequence of events that take place once the customer CONFIRMS the order..

specifically interested in understanding when is a ROW added to the orders table
and when is ORDER status updated by the Payment Gateway.

Is the Row added to the Orders table first and then the gateway updates the status.
OR
The row is added with the specified Order Status when u receive confirmation from the payment gateway.

I am trying to update the Customer's account with certain number of reward points once they buy a product. So I need to check if they have successfully paid for the PRODUCT and then update a table which track the points earned by the user.

thanks for you help....