chamilo / chamilo-lms

     *

     * @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, $courseId)

    {

        $result = Database::fetch_array(

            Database::query("

                SELECT is_tutor

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

                WHERE

                    c_id = '" . Database::escape_string($courseId) . "' AND

                    user_id = " . intval($user_id)

            )

        );

        return $result['is_tutor'];

    }

    /**

     * Unsubscribe one or more users from a course