[Mod] Randomizing {new_images}

[tripiyon]

Hi,

I have Mysql 5.0.45 and me the script does not work.
What change do I need in the code in order that it works well?

Thanks

Just replace in index.php

Code: [Select]

ORDER BY i.image_date DESC with

Code: [Select]

AND i.image_date >= ".(time() - 60 * 60 * 24 * $config['new_cutoff'])."
ORDER BY RAND() This requires MySQL version >= 3.23.23

Greets Jan

[tripiyon]

Solved 

Thanks

http://www.4homepages.de/forum/index.php?topic=7430.0

[relu]

I'm using it but i notticed that page is loading after a few secconds... 15-20 sec of thinking. Without the randomizing code is instant.