Home› General support

Published or unpublished items

RichardB Member
in General support

Can you tell me what field in the albums table and the images table indicates whether album or image is published or unpublished - I cannot see any, nor another table within the database with this information.

Thank you,
Richard Ball

Comments

  • acrylian Administrator, Developer
    edited November 11

    The field is current called show. But you should never use the db fields directly but the object model instead.

    Nested items inherit their status from parent items. So if thte toplevel album is unpublished an image in a sub album is as well even if it itself is published. Same applies to password protection.

  • RichardB Member

    Thank you very much.

    I have translated a very large menalto gallery database into 11 separate Zenphoto databases (Zenphoto was too slow if all included in just one database):

    https://graves.eggsa.org/

    but would like to write one search function to search them all in one go for names.

    I don't know what the 'object model' is.

    Why should I not use the database fields directly?

    Thank you for your help.

    Richard

  • acrylian Administrator, Developer

    I have translated a very large menalto gallery database into 11 separate Zenphoto databases

    You mean 11 separate Zenphoto installs, right?

    Zenphoto was too slow if all included in just one database

    It's most likely your server or you got caught with uncached images. I would recommend to move such large galleries in steps to Zenphoto in any case.

    but would like to write one search function to search them all in one go for names.

    That will be complicated as that would have to be outside of Zenphoto as you would have to search cross installs. You may run in all sorts of issues with inheritance of status etc.

    I don't know what the 'object model' is.

    The core code of Zenphoto basically:
    https://www.zenphoto.org/news/zenphotos-object-model-framework/

    Why should I not use the database fields directly?

    I already explained above actually. So again: An image with "show" = 1 is published but if any parent album is not it is in fact also not. Same with password protection or whaterver we may add status like. Also database fields may change names so you have to keep an eye on that.

Sign In or Register to comment.