Change content menu style from "table" to "div"

I have hundreds of categories and want to change all from style "table" to "tab". Can i do this in phpMyAdmin? I can't find the right table to edit.

Hi,

Can you explain with more details what you really need ?

Under "Display" - "Content menus", I have over 200 menu-items (type=product)

Under details, all of them have "type of layout" set to "table"

I want to change all my menu-tems from "table" to "div", but it will take much time to change all on by one. How can I change all in one? In back-end og hikashop, or maybe in the phpMyAdmin?

Hi,

In the backend there is no option to do that if you had set your type of layout to table for all your menus.
Since HikaShop 1.6.0 a new option has been created "Inherit" which allow you to use the default configuration in your menus/modules if it's set to inherit.

Using phpMyAdmin to change this value is not possible because the params are saved in the table "#__hikashop_config", and the value of these parameters are serialized and base64 encoded.

One way could be to write some PHP and MySQL requests to recover all the menus and their params, and for each menus unbase64 and unserialize their params, and check if it's a products listing menu type change the value of the type of layout and then serialize and base64 encode the data and save the values in the MySQL database.