Nothing fancy, I can't remember right, but I think it is some Olympus, now several years old (4-5), without optical stabilizer, with some zoom, few basic modes (night, day, landscape, portrait, 2 macros), 5MPix - there was just 256MB card at the time.
Even with cheap camera (150 €) you can get some nice photos.
However it's almost impossible to get nice photo of my weakly lighted 200l aquarium (just 9W+18W compact fluorescent lamp, these and daylight are enough for cryptocorynes)...
some old photos (uni keeps me busy now)
with speed lamp
during day without speed lamp
taking photo of smaller 20l sufficiently lighted aquarium is easier:
This old cheap camera has problems with:
-taking photos of barely lighted objects (during twilight, interior in castles, fish in aquarium, etc.)
-taking photos of fast moving objects
-taking photos in the bright sun
with this camera it's possible to get photos like this (maybe it was the same camera model):
http://commons.wikim...y_makrofoto.jpg
So the best photos are those taken in the morning, late evening or cloudy weather which is
general truth.
There are various optical filters, tripods and other profi tools, but the most important is camera itself.
Today cameras are much better, with optical stabilizer and 8 MPix from 100€.