Request for gallery

I use hikashop for my business which is one of a kind jewelry.

A gallery/slideshow with a few settings on what to display based on criteria taken from the database would be cool.

Example(s):

Pull pictures from items added within the last week for a "new" slideshow
Pull pictures from sold items or items with 0 in stock for a "sold" gallery

Pull random pictures from the database.

When clicking on the item in the gallery/slideshow would bring the user to the product page.

Wish I was savvy on programming I'd so do this myself, but alas I'm not...