chamilo / chamilo-lms

                    item_properties.tool = '".TOOL_FORUM_CATEGORY."'

                    $condition_session

                ORDER BY forum_categories.cat_order ASC";

        if (api_is_allowed_to_edit()) {

            $sql = "SELECT *

                    FROM ".$table_categories." forum_categories, ".$table_item_property." item_properties

                    WHERE

                        forum_categories.cat_id=item_properties.ref AND

                        item_properties.visibility<>2 AND

                        item_properties.tool='".TOOL_FORUM_CATEGORY."'

                        $condition_session

                    ORDER BY forum_categories.cat_order ASC";

        }

    } else {

        $sql = "SELECT *

                FROM ".$table_categories." forum_categories, ".$table_item_property." item_properties

                        $condition_session

                    ORDER BY forum_categories.cat_order ASC";

        }

    } else {

        $sql = "SELECT *

                FROM ".$table_categories." forum_categories, ".$table_item_property." item_properties

                WHERE

                    forum_categories.cat_id=item_properties.ref AND

                    item_properties.tool='".TOOL_FORUM_CATEGORY."' AND

                    forum_categories.cat_id = ".intval($id)."

                    $condition_session

                ORDER BY forum_categories.cat_order ASC";

    }

    $result = Database::query($sql);

    $forum_categories_list = array();