Australia's Ian Thorpe collected six gold medals and one silver in the Commonwealth Games in Manchester