+ Reply to Thread
Results 1 to 2 of 2

Thread: Mysql Query to do the following...

  1. #1

    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

  2. #2
    Hello Brian,

    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'
    Viktor,
    Flynax technical department,
    Best wishes.

+ Reply to Thread