Writing extra order info to the db

[jeffiec]

I am making a custom change to the order confirmation page, and I need to modify the sql that writes the order to the database, I assume it comes after the order confirmation page, but i cant find the actual SQL.
Thanks in advance
Jeff

[lat9]

That task occurs during the checkout_process page's processing ...

[jeffiec]

I need to know specifically where i can find the sql statement.
Thanks.

[lat9]

Look at /includes/classes/order.php; one of its member functions performs the database update.

[DrByte]

NOTE: You should be using notifier+observer calls to do additional database queries, instead of changing core code.

[jeffiec]

Thanks doc, im looking onto that now
I've made some changes to payment confirmation page, i want to append some stuff into the comments section of the order.

[DrByte]

If you wanted to add another comment record, you could do that using the NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_COMMENT notifier hook.

Or if you absolutely need to inject custom stuff into the first comment (the only customer's comment line), then you could hook NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER and append your special extra text onto the $class->info['comments'] variable, which corresponds with the order class's $this->info['comments']

[jeffiec]

Good god thank you! I was headed in the wrong direction lol

[DrByte]

See this recent blog post I made on building an observer class to respond to various notifier hooks: http://www.zen-cart.com/entry.php?4-...Create-Account

[jeffiec]

Or if you absolutely need to inject custom stuff into the first comment (the only customer's comment line), then you could hook NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER and append your special extra text onto the $class->info['comments'] variable, which corresponds with the order class's $this->info['comments']

This will fire when the confirm order button is press?
As I said, I modified the confirm order (step 3 in the checkout process), I have a small javascript so they can select option of options lol.
The confirm order button will be disabled until they select them. Since it is just a bunch of text boxes, I want to put them in an array, save them to the comments, and send them with the email.
Easy nough, eh. lol
Thanks again for your guidance.
Jeff