chamilo / chamilo-lms

	 * @param Integer $blog_id

	 * @param Integer $assignment_id

	 */

	public static function delete_assigned_task($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

     * @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