Mysql Query to do the following...

Hello,

I would like to change a setting in the categories section from a mysql query. The setting I would like to change is Users add subcategories setting.

Specifically - I want to know the mysql query to change every single category & subcategory to yes for user add sub-categories setting. Also, I would like to do the same thing for the include sub-categories setting as well.

note - regarding the including sub-category setting, how I can change that to disabled (unchecked) if I need to do that?

Thank you
Brian

Hello Brian,

Quote:

---

The setting I would like to change is Users add subcategories setting.

---

Use this query:

Code:

---

Only registered members can view the code.

---

This code allow users add new categories through add listing page.

Code:

---

Only registered members can view the code.

---

This code allow to add sub-categories.

If you want to deactivate this functions you need to set '0' instead of '1'