chamilo / chamilo-lms

     *

     * @return array

     */

    public function getAllUserPerTag($fieldId, $tag)

    {

        $tagRelUserTable = Database::get_main_table(TABLE_MAIN_USER_REL_TAG);

        $tag = Database::escape_string($tag);

        $fieldId = (int) $fieldId;

        $sql = "SELECT user_id 

                FROM {$this->table_field_tag} f INNER JOIN $tagRelUserTable ft 

                ON tag_id = f.id 

                WHERE tag = '$tag' AND f.field_id = $fieldId;

        ";

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

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * @param int $fieldId

     * @param int $courseId

     * @return bool

     */

    public static function hasCourseSetting($variable, $courseId)

    {

        $courseSetting = Database::get_course_table(TABLE_COURSE_SETTING);

        $courseId = intval($courseId);

        $variable = Database::escape_string($variable);

        $sql = "SELECT variable FROM $courseSetting

                WHERE c_id = $courseId AND variable = '$variable'";

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

        return Database::num_rows($result) > 0;

    }

    /**

     * Get information from the track_e_course_access table