Orders Table

[brycej2]

I was wondering if anyone knows where the customer information from the "address_book" and "customer" tables get inserted into the orders table at... I have some custom fields that are stored in these two tables that I need inserted along with the rest of the data that gets put in after each order. I know order.php pulls from the orders table but I don't ever see it filling these fields before it pulls from them.

thanks

[Ajeh]

The order information is managed in the order class ...

[brycej2]

yeah, thats what I have been looking at, and I am confused as to when/where in the file data is actually inserted in orders table fields. In create_account.php, the fields in tpl_modules_create_account.php, like name address and stuff are all inserted into the customers and address book tables. How does that data make it into the orders table, I sure can't find it in order.php.

[Ajeh]

  function create($zf_ot_modules, $zf_mode = 2) { 

Everything is built in there then applied to each table ...

[thoseguys26]

This is sort of off topic but similar. I think it's more of a database problem but I'm not sure. I have two custom written payment mods for TransFirst; ePay and eCheck. About two weeks ago I had the Admin Activity log full so I reset it without doing a backup I doubt that caused any problems but the issue now is only the first order seems to be able to be inserted into the two tables related to these modules. I've dropped the tables are recreated them and the same thing happens. The cart seems to work fine by taking multiple orders and the listing seems fine but only the first order made after dropping the tables can be inserted into the tables. I'm currently waiting for the host to recreate the tables to see if that will make a difference since I can't access phpMyAdmin because the cart just has an i.p. address until it's finished so I can reroute the dns.

Hopefully that all makes sense and someone can give some advice.

[brycej2]

  function create($zf_ot_modules, $zf_mode = 2) { 

Everything is built in there then applied to each table ...

thanks Ajeh appreciate it

[jacque427]

Bryce, did the fix work for you? Here is my quandry.....

I have a number of custom fields that customers fill out when registering.

The data is captured in the customers table of the database.

I have gotten as far as placing

No thank yous: <?php echo $order->customer['nothanks']; ?>

into super_invoice.php, the proper corresponding code into order.php in included/classes and the appropriate field into table_orders.

What I am wondering is how does the information get from the customers table into the orders table so that it will show on the invoice.

This is in ZC 1.3.7

Edit: I went into the DB, and entered some text into the field of the orders table and it shows on the invoice. So, how can I get the orders table to pull that field from the customers table like it gets the rest of the customer data?