Changing Random from last to first upload

[KDB9000]

Where is the code stored that will set the image to the last uploaded? I would like to change it so it uses the first uploaded image and not the last.

[KDB9000]

Come on. Someone has to know. Part of this question was in another post. Please check:

http://coppermine-gallery.com/forum/index.php?topic=49270.0

I want to change the random pic to be the first pic uploaded instead of the last one.

[Nibbler]

Look in index.php for the 2 uses of

Code Select Expand

max( p.pid )  AS last_pid

and change the max to min.