new column in TABLE_ORDERS_PRODUCTS

[Robbie_79]

Hello,

I'm new to ZC and am experiencing some hard times in finding my way around the scripts. Hopefully anyone can point me into the right direction.

I added a new column (products_cost) in the products table and orders_products table.
When an order is placed, I need the products_cost data to be inserted in to the new column in the orders_products table.

Which files need to be edited to achive this?

thank you for your time ;)
cheers

[kobra]

As most things around this take place in includes/classes/shopping_cart.php this would be a good place to begin

[DrByte]

If you look for references to TABLE_ORDERS_PRODUCTS in the /includes/classes/order.php file, you'll see where the insert happens. You'll have to add your extra field to the array of fields being passed to the zen_db_perform() function.

[Robbie_79]

Thank you both very much for your reply.

Before I posted my question here in the forum, I edited the orders class so it inserts the data in TABLE_ORDERS_PRODUCTS.
Also the shopping_cart class was changed to retreive data out of TABLE_PRODUCTS.

Now what happens is that the inserted data is zero, while it should insert the data from TABLE_PRODUCTS.

What am I missing here?

[DrByte]

If you want to keep it simple, then instead of changing the shopping_cart class, why don't you just read the data from the products table fresh when you need it (in the orders class just before writing to the orders_products table), especially since the data has no relevance to the customer?

[Robbie_79]

That's probably a good idea. Sometimes I want to desperately keep all codes as original as possible...without any reason.

The past year I worked quite intence with phpbb3, which was, along with its community forums, my main learning school for mysql and php. Now starting with zc while thinking it would be the same as phpbb 3, i find myself lost many times