+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: Themes (https://forum.zenphoto.org/forum-5.html)
+--- Thread: Album Tags for Images (/thread-7484.html)
Pages:
1
2
Album Tags for Images - Sabyre - 2010-08-16
I would like to be able to call the album tags for each image, instead of each image having individual tags.
For example: When creating an album, tags would be defined for that album and those tags would be displayed for every image within that album.
Album Tags for Images - kagutsuchi - 2010-08-16
Depending on how you want to output the tags, you could use the `tags_from_album` plugin. You could also simply use something such as `$_zp_current_album->getTags()` and output them accordingly. Or, for a different approach, you could copy over the album's tags to a new image via the `new_image` filter. The former methods are probably easier, however.
Album Tags for Images - Sabyre - 2010-08-16
I tried using the tags_from_album plugin but I am having a hard time getting it to work ... not sure exactly what to put in my image.php file....
Album Tags for Images - sbillard - 2010-08-17
If you are intending these tags to be used for such things as searching there is not currently a solution. We have on our list a bulk-edit type feature for setting tags, but implementation has not begun on it.
Album Tags for Images - Sabyre - 2010-08-17
Nope, just want to be able to define tags for an album and then have those same tags display with each individual image within that album.
I enabled the tags_from_album plugin and placed the following code on my image.php, but all I got was SQL errors.
[code]
<?php printAllTagsFromAlbum("sasha",false,albums,'|','',false,true,1,5,1,50); ?>
[/code]
Album Tags for Images - sbillard - 2010-08-17
Let us know the SQL errors. Off hand that call looks correct.
Album Tags for Images - Sabyre - 2010-08-17
Zenphoto encountered an error
MySQL Query ( SELECT DISTINCT t.name, t.id, (SELECT DISTINCT COUNT(*) FROM `zp_obj_to_tag` WHERE tagid = t.id AND o.type = 'albums') as count `zp_obj_to_tag`as o,`zp_tags`as t WHERE (o.objectid =10 AND o.tagid = t.id AND o.type = 'albums') ORDER by t.name ) failed. MySQL returned the error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`zp_obj_to_tag`as o,`zp_tags`as t WHERE (o.objectid =10 AND o.tagid = t.id AND o' at line 1
Album Tags for Images - acrylian - 2010-08-17
Actually kagutsuchi's way is a good ay for getting the direct tags of the album you are in. You will of course write a foreach loop to show them as a list.
Regarding your function call `<?php printAllTagsFromAlbum("sasha",false,albums,'|','',false,true,1,5,1,50); ?>`. Try setting the `albums` parameter as `"albums"` (in quotes). Is the album "sasha" a toplevel album? If not you have to write "toplevel/sublevel(...)".
Maybe you could also tell what MySQL version you are running. It seems that one value is empty on your sql but I don't know right now why that can happen.
Album Tags for Images - Sabyre - 2010-08-17
MySQL 5.1.39
"sasha" is the name of the toplevel album folder.
I tried putting albums in quotes... Same error
I tried putting "toplevel(sasha)".... same error.
Album Tags for Images - sbillard - 2010-08-17
There is an error in the function code which is resulting in the string `zp_tagsas` where it should read `zp_tags AS`. (Note the missing space.) I will get a correction made to this in tonight's nightly build.
Thank you for posting the SQL error. Could not have seen this without that hint.
Album Tags for Images - acrylian - 2010-08-17
Ah, now I see it as well...
Album Tags for Images - Sabyre - 2010-08-17
So where do I need to adjust the code? Which file? im not seeing it in tags_from_album.php
Album Tags for Images - sbillard - 2010-08-17
See http://www.zenphoto.org/trac/changeset/5770/
Album Tags for Images - Sabyre - 2010-08-17
well, I put the spaces in around line 69 in tags_from_album.php and then there is a similar line below it it I adjusted that as well.
Here is the adjustment.
[code]
$tags = query_full_array("SELECT DISTINCT t.name, t.id, (SELECT DISTINCT COUNT(*) FROM ". prefix('obj_to_tag'). " WHERE tagid = t.id AND type = 'images') as count FROM ". prefix('obj_to_tag'). " as o,". prefix('tags'). " as t".$tagWhere." ORDER by t.name");
[/code]
I still get the same error.
Album Tags for Images - Sabyre - 2010-08-17
Just looked at your change and adjusted mine ... still doesnt work
Album Tags for Images - Sabyre - 2010-08-17
Got it ... line 81 is missing a FROM...
should be...
[code]
$tags = query_full_array("SELECT DISTINCT t.name, t.id, (SELECT DISTINCT COUNT(*) FROM ". prefix('obj_to_tag'). " WHERE tagid = t.id AND o.type = 'albums') AS count FROM ". prefix('obj_to_tag'). "AS o, " . prefix('tags'). " AS t " .$tagWhere. " ORDER by t.name");
[/code]
Album Tags for Images - acrylian - 2010-08-17
Indeed! Good find! Fix is in the svn.
(Btw, we don't use bbcode on the forum, just use `backticks`)
Album Tags for Images - Sabyre - 2010-08-17
<?php printAllTagsFromAlbum("getAlbumTitle()",false,"albums",'|','',false,true,1,5,1,50); ?>
ok, this is what im using on my image.php.... I'm looking for a way for it to return the current album and I thought that this would do it. However it returning all tags from all albums instead.
Any ideas?
Album Tags for Images - Sabyre - 2010-08-17
and what are backticks?
Album Tags for Images - Sabyre - 2010-08-17
again.... got it ...
<?php printAllTagsFromAlbum(getAlbumTitle(""),false,"albums",'|','',false,true,1,5,1,50); ?>
Had the quotes wrong.