[Mod Req] Latest Image In Each Category

[Yegor]

Im wondering if such mod already exists.

Basically, on the main page, instead of showing x latest images, I want to show 1 image from each catgeory that was updated. So lets say I upload 10 images into 5 different categories (so 50 images in total), only the last image uploaded into each category will be displayed on index.php, instead of just the lastest 5 images in a single category.

I'd be willing to pay someone to code this mod for me real quick if it doesn't already exist.

[Yegor]

Come on, Im offering money to someone who will develop this mod for me.

[TheOracle]

Well, to be honnest - it is much simpler to request it than to code it.

[Yegor]

Yah, thats why Im offering money to whoever does.

[V@no]

In index.php find:

Code: [Select]

SELECT i.image_id, i.cat_idReplace with:

Code: [Select]

SELECT DISTINCT(i.cat_id), i.image_idThen a couple lines below find:

Code: [Select]

        ORDER BY i.image_date DESCInsert above:

Code: [Select]

        GROUP BY i.cat_id

[Yegor]

Spasibo! 

[IcEcReaM]

[Offtopic Mode On]

Spasibo!

Which language is that?
I only know spasiba, which is russian.

[Offtopic Mode Off]

[Yegor]

That was russian.

Btw V@no, your mod works well, but Im kinda confused how it selects the images from categories. Some of them are the first image in the category, and others seem to be randomly chosen from that category.

[V@no]

Btw V@no, your mod works well, but Im kinda confused how it selects the images from categories. Some of them are the first image in the category, and others seem to be randomly chosen from that category.

Unless the mysql query you have was changed, this code should not affect the way you've discribed...