Order of Items in Database

AnselTk1

Joined: 2009-09-24
Posts: 3
Posted: Thu, 2009-09-24 18:30

Hi - wondering if someone can point me in the right direction - in which table does Gallery2 save the order of images within an album? I am using mysql.

Thanks
 
alecmyers

Joined: 2006-08-01
Posts: 4338
Posted: Thu, 2009-09-24 23:57

That's a very interesting question. Do you mean where does it store your choice of by-name/date-modified/date-added/custom-order, or where does it store the custom order value?
 
AnselTk1

Joined: 2009-09-24
Posts: 3
Posted: Fri, 2009-09-25 15:35

Thank you alecmyers - I mean the custom order value. I am listing the album photos in a custom page and would like to display them in the order arranged by the user in Gallery2.
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 6138
Posted: Fri, 2009-09-25 15:57

Did you try mediaBlock?
or actually embedding?

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
 
AnselTk1

Joined: 2009-09-24
Posts: 3
Posted: Fri, 2009-09-25 16:12

Thanks suprsidr - I think (if I can find out where the order is stored) just create a repeating region in my page. I think it would be simpler for the application and easier to match the look the client wants.
 
alecmyers

Joined: 2006-08-01
Posts: 4338
Posted: Sun, 2009-09-27 20:49

It's in g2_ItemAttributesMap, column name is g_orderWeight, I think.