sort order of user galleries

[nickfzx]

after much searching (as this is a topic that has been covered a lot) I have decided to ask for help.

I want the default sort order of user galleries to be last-updated-album is first.  At the moment user galleries are sorted by the first registered user's album is shown first.

I only found this solution which is only for 1.3...I have the latest version(1.4.10)  :

http://forum.coppermine-gallery.net/index.php?topic=21504.0

Any ideas how I might do this.

p.s.
If the above can't be done then I would like to know how to reverse the sort order so that the last registered user's gallery was shown first instead.

[triepsyn]

I'm also looking into this situation, have attempted many different ideas I found in other threads to no avail.

Thanks! 

[Stramm]

bridge/udb_base.inc.php

in the function get_user_data find 2 times

Code Select Expand

                        $sql .= "ORDER BY category ";
and replace category with the table field you want to sort. Add ASC or DESC for ascending, descending order

thumb_pid is valid or user_name

[triepsyn]

Thank you for the response. I appreciate it. 

Unfortunately, it did not work for me. I found the get_user_data x 2 and replaced both instances with the //$sql .= "ORDER BY thumb_pid DESC ";\\ code; did not work. I also tried to put the code behind the get_user_data. I tried it a few different times but it would not work for me.

Any thoughts? I'd really like my album to be sorted by the last update. I have it organized in alphabetical order now and it took like 100 clicks to get there with the manual up and down buttons. 

http://www.nwaimports.com/gallery/index.php?cat=7

Thanks for any and all help.

-Kristina 

[nickfzx]

any ideas on how to do this anyone.

sorry, i don't really understand your instructions stramm

[nickfzx]

have followed your instructions as well as i can stramm but they produce no effect at all...

all I want is for the member galleries to be ordered by when they were last updated....last updated album first.

There is surely a way this can be done...I have searched the boards and can't find a way.

[nickfzx]

bridge/udb_base.inc.php

in the function get_user_data find 2 times

Code Select Expand

                        $sql .= "ORDER BY category ";
and replace category with the table field you want to sort. Add ASC or DESC for ascending, descending order

thumb_pid is valid or user_name

Stramm was in fact correct 100%, I was just using incorrect syntax, sorry for two previous posts

[triepsyn]

I've tried this a number of times using different combinations and nothing appears to work for me. Any suggestion?

I'm trying to get this: http://www.nwaimports.com/gallery/index.php?cat=48 ... To have the albums ordered by the last time they were updated.

Please help. Thanks.