[Mod] Display random images on homepage, if no new images

[police22]

..SNIP
At line 81 in index.php (with version 1.7), you will see the following code:
..SNIP
this should do it for you.
Regards,
Kelvin

So V@no, will this work with 1.7.1
gonna go ahead and try real quick but thought i should ask

[police22]

..SNIP
At line 81 in index.php (with version 1.7), you will see the following code:
..SNIP
this should do it for you.
Regards,
Kelvin

So V@no, will this work with 1.7.1
gonna go ahead and try real quick but thought i should ask

Well.. i installed it.. have new images on there so cant test but it didn't error... Thanks

[V@no]

u can lower your "new images" timeout in the settings

[garett]

that answer made me look into the code...
replace:

Code: [Select]

       ORDER BY random_no DESC, i.image_date DESCwith:

Code: [Select]

       ORDER BY random_no DESC, RAND(), i.image_date DESC

Do you know if there is a mod that do the same thing but with the categories (and sub-categories) and not with the homepage?
I mean if there is no image in a categorie, you display a line of random images from the subcategories.

It would makes the site more dynamic.

[egyptsons]

nice work I will try it 

[obmob01]

Oh, i added this to 1.7.2, seems to work fine.

Code: [Select]

$new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
$num_new_images = $config['image_cells'];
$sql = "SELECT IF(i.image_date >= $new_cutoff,RAND()+1,1) as random_no, i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
        WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").")
        ORDER BY random_no DESC, RAND(), i.image_date DESC
        LIMIT $num_new_images";

[viper357]

hey thanks man, I also added it to 1.7.2 and it works great 

[Sopur]

hum...no

that answer made me look into the code...
replace:

Code: [Select]

        ORDER BY random_no DESC, i.image_date DESCwith:

Code: [Select]

        ORDER BY random_no DESC, RAND(), i.image_date DESC

Does this mean, ONLY if there are no NEW images, it will take some other random?
(Das heisst also, erst wenn es keine "neuen" Bilder mehr hat, wird aus allen ausgewählt?)
Regards
Sopur

[V@no]

Yes, if there are some new images they will be displayed in random order, but it there no new images, then it will show random images from entire gallery.

[Ch*yeuk]

Hahah, awesome! Done it, and love it

[Fastian]

This little hack allows you to see random new images on the home page that fall within the cuttof limit, this makes the page look more active.

Code: [Select]

$new_cutoff = time() - 60 * 60 * 24 * $config['new_cutoff'];
$num_new_images = $config['image_cells'];
$sql = "SELECT IF(i.image_date >= $new_cutoff,RAND()+1,1) as random_no, i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c
        LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
        WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
        ORDER BY random_no DESC, i.image_date DESC
        LIMIT $num_new_images";


Is this possible to Exclude one category from this block of code ??
I dont want to show new/random images from One category

[V@no]

Add code in red in this line:[qcode]       WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").") AND i.cat_id NOT IN(1,2,3,4,5)
[/qcode]

[Fastian]

Thankx V@no
You are The Guru 

[eXtremer]

Hi all.
I've searched the forum and found only this : http://www.4homepages.de/forum/index.php?topic=4010.0
..but I can't integrate it in 1.7.6 version there is no such lines in index.php
Could someone give me another MOD ?
Help please.

[budduke]

The code changed a little, some brackets were added on the second line..
it is around line 106...
in version 1.7.6, it looks like this now

Code: [Select]

$num_new_images = $config['image_cells'];
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
        WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (".get_auth_cat_sql("auth_viewcat", "NOTIN").")
        ORDER BY i.image_date DESC
        LIMIT $num_new_images";
replace this with what is in that mod and it should work for you...
Also, add the random to it so the same images will not show up all the time. look further down the mod topic to find the random addition