Questions related to database tables

[superprg]

Hi
I have few questions related to tables in zencart so I am creating a new thread for it
1. There is a table zen_order_products_download. What is the use of it?
2. What is the purpose of column admin_level in zen_admin?

Thanks

[Ajeh]

If you have a download in the Order ... it would be handy to be able to give it to the customer ...

The admin level was/is for different capabilities of an admin ...

This was designed originally for sites to be able to "show off" their admin to someone and not get their shop destroyed ...

Currently, there are a lot of things that should be "more secure" based on this admin _level so we do not encourage its use unless:

1 you have a real clue what and why you are using it

2 you go through the whole admin and add this feature to more areas as needed to prevent annihilation of your shop by someone playing or being malicious ...

[superprg]

Thanks Ajeh

Few more questions related to products etc tables:

In the table zen_products what are these columns used for:
products_virtual
products_status
products_quantity_order_min
products_quantity_order_units
products_priced_by_attribute
product_is_free
product_is_call
products_quantity_mixed

Also, products_discount_type field gets its value from products_discount_quantity table...Is that right? Is it a constraint set up on the table? Is there any way I can see in phpmyadmin the foreign key constraints?


Also, for same product_id say 178 I can see 8 different records in the products_discount_quantity table. Does that mean that I can apply these discounts from time to time?
Thanks

[DrByte]

Almost the entire database schema is documented in the wiki:
http://www.zen-cart.com/wiki/index.p...atabase_Schema

The products table fields you asked about are here:
http://www.zen-cart.com/wiki/index.php/Table_products

for same product_id say 178 I can see 8 different records in the products_discount_quantity table. Does that mean that I can apply these discounts from time to time?

if you look at the individual records, you will see the different prices which may be applied as discounts when the different quantity levels are reached. These are built using the Products Price Manager in the admin.

[superprg]

Thanks for the links
By 'different quantity levels', do you mean if the value of
discount_qty=3 it means that if customer buys three products, he will get a discount as stated in the products_discount_quantity table?
Thanks

[DrByte]

By 'different quantity levels', do you mean if the value of
discount_qty=3 it means that if customer buys three products, he will get a discount as stated in the products_discount_quantity table?
Thanks

Yes



Are you writing a book ?

[superprg]

Yes

Are you writing a book ?

Not as of now :)

PS: Would you like if I attempt to write one? :)

[DrByte]

Not as of now :)

PS: Would you like if I attempt to write one? :)

Was just wondering what the basis behind all your technical questions was...

[superprg]

I stil havent understood how sorting works in Categories:
Let us I have this for Category 'Hardware'
Hardware-> (6)
|_ CDROM Drives
|_ Graphics Cards (2)
|_ Keyboards (1)
|_ Memory
|_ Mice (2)
|_ Monitors
|_ Printers (1)
|_ Speakers

Now, in the database I have for category hardware, sort_order=1( and therefore it came on the top in the box)

But for let us say sub categories CDROM Drives, Graphics Cards, sort_order=0

What do I do in order to bring 'Graphics Cards' to top in the Hardware category?
Thanks
San

[DrByte]

I stil havent understood how sorting works in Categories:

Now, in the database I have for category hardware, sort_order=1( and therefore it came on the top in the box)

But for let us say sub categories CDROM Drives, Graphics Cards, sort_order=0

What do I do in order to bring 'Graphics Cards' to top in the Hardware category?

Give it a lower sort order to bring it up higher in the list.
This might require renumbering other categories to re-arrange sort orders.
NOTE: Blank (null) values come before numbered values. But normally you should not have any null values in sort order, so this is normally not an issue.