Home› General support

Sort Album Feature

harootun Member
in General support
When I sort an album using "Sort Album" and drag the thumbnails around to the order I want, how does Zenphoto "know" the order I've set. What I'm really asking is what column of what mysql table does it write this sort order to?

I'd like to know so I could tweak it in the database directly if need be. I've taken a look at the mysql tables, but haven't figured it out. (I'm assuming that's what zenphoto does, write the order to mysql, but I could (easily) be totally wrong!)

Comments

  • sbillard Member
    The `sort_order` field.
  • harootun Member
    Great. That's what I thought. Don't know why I didn't see it before, but looked again and see the #s.

    Now, my second question is, when I add new images to an album where I've previously sorted the album, the new images go to the front of the album. They appear first, before the sorted images. Is there a gallery sort setting I should use so that the new images appear at the end? I'm currently telling the gallery to sort images by "sort_order,date, title". Is there some other sort images order I should use that pushes new images to the back/end of the album?
  • sbillard Member
    There is nothing that works in conjunction to the manual sorting. What you might try is sort_order, ID ascending. Not sure if you can apply the ascending just to the ID, thougn.
Sign In or Register to comment.