chamilo / chamilo-lms

     * @return bool

     * */

    public function lock($locked)

    {

        $table = Database::get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

        $sql = "UPDATE $table SET locked = '".intval($locked)."'

                WHERE id='".intval($this->id)."'";

        Database::query($sql);

    }

    /**

     * @param $locked

     *

     * @return mixed

     */

    public static function getUserCourseInfo($userId, $courseId)

    {

        $result = Database::fetch_array(

            Database::query("

                SELECT * FROM " . Database::get_main_table(TABLE_MAIN_COURSE_USER) . "

                WHERE

                    c_id  = '" . intval($courseId). "' AND

                    user_id = " . intval($userId)

            )

        );

        return $result;

    }

    /**

     * @param int  $userId

     *

     * @return mixed

     */

    public static function get_tutor_in_course_status($user_id, $course_code)

    {

        $result = Database::fetch_array(

            Database::query("

                SELECT is_tutor

                FROM " . Database::get_main_table(TABLE_MAIN_COURSE_USER) . "

                WHERE

                    course_code = '" . Database::escape_string($course_code) . "' AND

                    user_id = " . intval($user_id)

            )

        );

        return $result['is_tutor'];

    }

    /**

     * Unsubscribe one or more users from a course