[Album] - Where does the album comment get stored?

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
rtkd
Forum Members
Forum Members
Posts: 126
Joined: Tue Dec 12, 2006 3:57 pm

[Album] - Where does the album comment get stored?

Post by rtkd »

hi there,

i have several different albums in different categories in my picturemanager.

kat 1.
- album 1
- album 2
kat 2.
- album 1
...

i now want to create an overview of each kat.
if im not mistaken this fature is not yet(?) implemented in the album module,
(if it is pls spare me the work and tell me how to use it)
so i have to code a little workaround by selecting thumbnail and comment from db
and displaying then.

album 1 > thumb_01 + comment album 1
album 2 > thumb_01 + comment album 2
...

but i somehow can't find the comment i have written for the test album in the db
(module_album_albums, module_album_pictures), neither in a file... ???
btw: what r the tables ending with _seq for?

would be nice if s.o. could ponit me in the right direction.

greets, rtkd
User avatar
Elijah Lofgren
Power Poster
Power Poster
Posts: 811
Joined: Mon Apr 24, 2006 1:01 am

Re: [Album] - Where does the album comment get stored?

Post by Elijah Lofgren »

rtkd wrote: hi there,

i have several different albums in different categories in my picturemanager.

kat 1.
- album 1
- album 2
kat 2.
- album 1
...

i now want to create an overview of each kat.
if im not mistaken this fature is not yet(?) implemented in the album module,
(if it is pls spare me the work and tell me how to use it)
so i have to code a little workaround by selecting thumbnail and comment from db
and displaying then.

album 1 > thumb_01 + comment album 1
album 2 > thumb_01 + comment album 2
...
How did you get the Albums into categories? (I have not yet implemented categories in Album)
What exactly would you like to be shown in the overview?
It seems to me that just calling Album like this will already do what you are wanting (It shows a list of all Albums with comments. Or are you wanting categories?):

Code: Select all

{cms_module module='album'}
rtkd wrote: but i somehow can't find the comment i have written for the test album in the db
(module_album_albums, module_album_pictures), neither in a file... ???
It should be in the "cms_module_album_albums" table in the "comment" field.
album_id  album_name  album_number  thumbnail_path  comment column_number  row_number  template
1 test 1 /thumb_FwAreyou(1).jpg Test comment for a test Album. 5 0 default
rtkd wrote: btw: what r the tables ending with _seq for?
Those tables are used to keep track of what the next id will be. It is used instead of Auto Increment in order to work with more versions of SQL.


I hope this helps,

Elijah

(I could maybe try adding categories to Album if I get around to it. Hopefully it wouldn't be too hard.)

It'd be cool if you could post details of how you'd like categories to work here: http://dev.cmsmadesimple.org/tracker/in ... 7&atid=728
Note: I don't have time to take on any more projects. I'm quite busy. I may be too busy to reply to emails or messages. Thanks for your understanding. :)
rtkd
Forum Members
Forum Members
Posts: 126
Joined: Tue Dec 12, 2006 3:57 pm

Re: [Album] - Where does the album comment get stored?

Post by rtkd »

How did you get the Albums into categories? (I have not yet implemented categories in Album)
i know, see above ;)
i just used different folders in the picturemanager to categorize them.
What exactly would you like to be shown in the overview?
the default thumb of each album per categorie.
so i get an overview for summer, winter and so on, then click on a thumb and
see all the pictures in the album

summer
- pictures 01.05.06
- pictures 04.05.06
winter
- pictures 01.11.06
- pictures 04.11.06
...

It should be in the "cms_module_album_albums" table in the "comment" field.
omg, dont ask... i just found it... i was working online but checking on localhost.. lol :)
Post Reply

Return to “CMSMS Core”