chamilo / chamilo-lms

     * @param $courseId

     * @return array

     */

    public static function getUserCourseCategoryForCourse($userId, $courseId)

    {

        $tblCourseRelUser = Database::get_main_table(TABLE_MAIN_COURSE_USER);

        $tblUserCategory = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);

        $courseId = intval($courseId);

        $userId = intval($userId);

        $sql = "SELECT user_course_cat, title

                FROM $tblCourseRelUser cru

                LEFT JOIN $tblUserCategory ucc

                ON cru.user_course_cat = ucc.id

                WHERE

                    cru.user_id = $userId AND c_id= $courseId ";

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

        $data = array();

        if (Database::num_rows($res) > 0) {

            $data = Database::fetch_assoc($res);

        }

        return $data;

    }

    /**

     * Get the course id based on the original id and field name in the extra fields.

     * @return bool    True if the user is a coach

     *

     */

    public static function is_session_course_coach($user_id, $courseId, $session_id)

    {

        $tbl_session_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        // Protect data

        $user_id = intval($user_id);

        $courseId = intval($courseId);

        $session_id = intval($session_id);

        $result = false;

        $sql = "SELECT session_id FROM $tbl_session_course_rel_user

                WHERE

                  session_id = $session_id AND

                  c_id = $courseId AND

                  user_id = $user_id AND

                  status = 2 ";

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

        if (Database::num_rows($res) > 0) {

            $result = true;

        }

        return $result;

    }

    /**

     * This function returns an icon path that represents the favicon of the website of which the url given.