Most viewed images

Fregior

Joined: 2011-02-24
Posts: 11
Posted: Tue, 2011-12-27 11:54

Hi, I would like to create a page with most viewed photos.
This should be the query run by PHP: SELECT * FROM sfondicell_items WHERE type LIKE 'photo' ORDER BY view_count DESC LIMIT 20

I ask you if you can show me what is the code that posts the images in the albums, so I avoid many unuseful work...

Thanks

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2011-12-27 22:15

I thought that there is a dynamic album module that does this?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
Fregior

Joined: 2011-02-24
Posts: 11
Posted: Wed, 2011-12-28 12:03

I don't know if there is a module that create an album with most viewed images. I've searched with google but I didn't find any result...

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Wed, 2011-12-28 16:04

The dynamic albums module has "Random, "Popular" and "Updates" albums.
http://codex.gallery2.org/Gallery2:Modules

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

 
Fregior

Joined: 2011-02-24
Posts: 11
Posted: Wed, 2011-12-28 19:32

How can I install/download it?
Thanks

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2011-12-28 19:45