chamilo / chamilo-lms

     * @param int kind of rating

     * @return void()

     */

    public static function qualify_friend($id_friend_qualify, $type_qualify)

    {

        $tbl_user_friend = Database::get_main_table(TABLE_MAIN_USER_REL_USER);

        $user_id = api_get_user_id();

        $sql = 'UPDATE '.$tbl_user_friend.' SET relation_type='.((int) $type_qualify).'

                WHERE user_id = '.((int) $user_id).' AND friend_user_id='.(int) $id_friend_qualify;

        Database::query($sql);

    }

    /**

     * Sends invitations to friends

     * @param int $user_id

     * @return void

     */

    public static function deleteAssignedTask($blog_id, $task_id, $user_id)

    {

        $tbl_blogs_tasks_rel_user = Database::get_course_table(TABLE_BLOGS_TASKS_REL_USER);

        $course_id = api_get_course_int_id();

        // Delete posts

        $sql = "DELETE FROM $tbl_blogs_tasks_rel_user

                WHERE

                    c_id = $course_id AND

                    blog_id = '".(int) $blog_id."' AND

                    task_id = '".(int) $task_id."' AND

                    user_id = '".(int) $user_id."'";

        Database::query($sql);

    }

    /**

     * Get personal task list