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

[apnetz]

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

This does not work on 1.7.7, no new images appear at all.

[Hagen-Roderich]

I have tryed this MOD, but dont get it to work. (4images Version 1.77 but index.php shows version 1.76)
Error:
An unexpected error occured. Please try again later.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /is/htdocs/47852/domainname/media/includes/db_mysql.php on line 116

After login as Admin the error is:

DB Error: Bad SQL Query: SELECT IF(i.image_date >= 1264340208,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, c.cat_name, u.user_name FROM gallery_images i, gallery_categories c LEFT JOIN gallery_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 264, 162, 132, 131, 130, 273, 252, 176, 150, 140, 108, 207, 219, 113, 275, 292, 257, 282, 261, 244, 255, 177, 144, 259, 122, 251, 191, 254, 186, 274, 142, 111, 204, 174, 272, 281, 283, 170, 136, 135, 237, 284, 296, 212, 217, 250, 234, 171, 208, 193, 265, 216, 262, 240, 209, 158, 256, 277, 178, 278, 247, 114, 201, 157, 290, 145, 196, 214, 185, 197, 198, 222, 260, 203, 258, 263, 295, 106, 133, 235, 141, 206, 143, 233, 189, 112, 169, 210, 179, 146, 276, 168, 269, 246, 194, 159, 213, 253, 215, 238, 243, 288, 123, 172, 151, 134, 109, 202, 220, 232, 271, 115, 279, 245, 124, 293, 267, 164, 147, 192, 116, 249, 205, 165, 125, 137, 218, 160, 231, 195, 211, 184, 118, 294, 161, 242, 163, 280, 200, 270, 199, 166, 138, 126, 149, 180, 190, 230, 285, 239, 268, 181, 156, 297, 119, 167, 139, 127, 148, 229, 183, 120, 152, 236, 286, 128, 107, 228, 298, 287, 182, 187, 153, 129, 227, 121, 154, 289, 226, 155, 291, 225, 224, 223) ORDER BY random_no DESC, i.image_date DESC LIMIT 3
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /is/htdocs/47852/domainname/media/includes/db_mysql.php on line 116

No Images are showend

What went wrong?
http://www.4homepages.de/forum/index.php?topic=22668.0? MySQL is V 5.0.32
"If your 4images is newer then v1.7.1 and you still get these errors, then you must have installed a mod that is not MySQL v5 compatible." Does thise mean this MOD is not MySQL v5 compatible? If so how to change the code to work with MySQL v5?

[Nicky]

change

Code: [Select]

       FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c
to

Code: [Select]

       FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
.. look now...

[Hagen-Roderich]

Thank you works perfectly.

Next question:
How to make "Neue Bilder" only be showed if there are new images?

[arabcine]

this work
http://www.4homepages.de/forum/index.php?topic=4010.msg64771#msg64771


but it's show to me 4 images how i can set it 6 pic ?

[V@no]

FAQ -> How can I show more new images on home page?

[dunyakupasi]

This does not work on 1.7.7

[arabcine]

This does not work on 1.7.7

try this its work
http://www.4homepages.de/forum/index.php?topic=4010.msg64771#msg64771

[Hagen-Roderich]

This does not work on 1.7.7

Whats your MySQL version, you are useing?

MySQL 5?
If so, try: http://www.4homepages.de/forum/index.php?topic=4010.msg145087#msg145087

[MrAndrew]

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

This rondomize my new images sorted by hits "image_hits" query too... How to randomize only random_no???

[brez]

Does not work with 1.7.10

DB Error: Bad SQL Query: 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, c.cat_name, u.user_name FROM (4images_images i, 4images_categories c) LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id NOT IN (0) ORDER BY random_no DESC, RAND(), i.image_date DESC LIMIT 8
Unknown column 'random_no' in 'order clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/irishavs/public_html/includes/db_mysql.php on line 116

[Rembrandt]

Does not work with 1.7.10
.....Unknown column 'random_no' in 'order clause'

you have no column 'random_no' in your DB

this works
http://www.4homepages.de/forum/index.php?topic=4010.msg64771#msg64771

[V@no]

Does not work with 1.7.10

It works, you just made a mistake on the first line of the code you were supposed to replace.

[brez]

Thanks Rembrandt it works alright but......
I had 8 images showing to fill the homepage, now i am reduced to 4 again.

[Rembrandt]

do you want 8 images only on home.html?
search in the code:
LIMIT $num_new_images";

replace:
LIMIT 8";


mfg Andi