Member
Member
Jole   2010-08-07, 09:18
#1

I wish to edit some album informations from SQL database, from phpMyadmin in control panel.

What are the names of SQL tables and table fields for:

  1. Table name and table field where Zenphoto keeps "Album Title:" information?
  2. Table name and table field where Zenphoto keeps "Album Description:" information?
  3. Table name and table field where Zenphoto keeps "Location:" (also for album) information?
  4. Table name and table field where Zenphoto keeps "Custom data:" (also for album) information?
  5. Table name and table field where Zenphoto keeps album name (real folder name on disk)?

I believe I found it, please confirm?

  1. Table name and table field where Zenphoto keeps "Album Title:" information?
    Table: "zp_albums"
    Field: "title"

  2. Table name and table field where Zenphoto keeps "Album Description:" information?
    Table: "zp_albums"
    Field: "desc"

  3. Table name and table field where Zenphoto keeps "Location:" (also for album) information?
    Table: "zp_albums"
    Field: "location"

  4. Table name and table field where Zenphoto keeps "Custom data:" (also for album) information?
    Table: "zp_albums"
    Field: "custom_data"

  5. Table name and table field where Zenphoto keeps album name (real folder name on disk)?
    Table: "zp_albums"
    Field: "folder"

Administrator
Administrator
acrylian   2010-08-07, 09:58
#2

Yes, indeed, it's pretty straightforward named (there is also a database reference PDF included in the package's /doc_files folder btw).

Remember that the folder name includes the toplevel album names as well.

Member
Member
sbillard   2010-08-07, 18:59
#3

BUT, the folder name is relative to the "albums" folder. So it is not the full disk path.

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.