Re: Adding new tables to the database
The standard database table names are defined in includes/database_tables.php - that's how the cart knows that TABLE_PRODUCTS = zen_products.
When adding a new table to the database, you need to give the cart a way of knowing what that table is - the normal way to do this is to create a new file and save it in the includes/extra_datafiles/ folder. So in your case, create a new file with this content
Code:
define('TABLE_PRODUCTS_KITS', DB_PREFIX . 'products_kits');
and save it as includes/extra_datafiles/kits_database_names.php, (put a copy in admin/includes/extra_datafiles as well so you can access it from admin pages).
Then your sql query can be modified to access that table, referring to it as TABLE_PRODUCTS_KITS
Neville
An assumption is what you arrive at when you get tired of thinking...
Bookmarks