Adding watermark to whole album

Hello.
Is there some way I could add watermark to a whole album at once?

I've a tempory solution. With the module or url rewriting, ( Apache platform ).

Choose watermark for external link in watermark page.

You must activate url rewriting for watermarking external photo. After Go to you edit .htaccess and comment or delete this line :

RewriteCond %{HTTP_REFERER} !://galerie\.gerpho\.com/ [NC]

Now you have :
RewriteCond %{QUERY_STRING} view=core.DownloadItem
RewriteCond %{QUERY_STRING} itemId=([0-9]+)
#RewriteCond %{HTTP_REFERER} !://galerie\.gerpho\.com/ [NC]
RewriteRule . /main.php?g2_view=watermark.DownloadItem&g2_itemId=%1 [L]

And All photo have watermark.!!!!

I had an idea how to workaround this "batch watermarking issue", just not have enough gallery knowledge to validate idea/find the right spot for modification.

As I understand, currently at the upload we can mark album/items to be watermarked. So, original image will be kept intact while all derivative will get created with watermark. What happens when we clear derivative cache and then recreate them? Looks for me that, as expected, derivatives get recreated with watermark on them.
If it is true, then my idea for "workaround" would be - mark all existing items/albums as uploaded with watermark switched on and force gallery to regenerate derivatives. Not sure how difficult this "mark all exsting" would be, as I'm not sure what attribute gets filled upon upload of watermarked images. Is it db or file level? In first case it should be just a question of executing correct sql statement.

On other hand - idea looks so simple that I would wonder if somebody haven't already thought about it. Sorry if it's already been discussed here and everyone is aware it won't work

Any hint for direction where to look will be highly appreciated.

cheers,
Austris

thanks for your reply, fryfrog. was already giving up, but had to keep trying as you said it's in DB

g2_Derivative.g_postFilterOperations does all magic. for testing I wanted to add watermark to some existing yourimagefilename.jpg image from my gallery.

to do this:
+ add your watermark through gallery UI.
+ in update below replace <field_name> with coresponding values from g2_WatermarkImage table
UPDATE g2_Derivative SET g_postFilterOperations='composite|plugins_data/modules/watermark/<g_fileName>,<g_mimeType>,
<g_width>,<g_height>,manual,<g_xPercentage>,<g_yPercentage>' where g_derivativeType = 2 and g_derivativeSourceId = select g_id from g2_FileSystemEntity where g_pathComponent='yourimagefilename.jpg'

this will add watermark to all derivatives, but thumbnails (g_derivativeType = 1 would be thumbnail).

executed update, cleared all cache (also client side;) ), opened image and watermark was there.

still has to find out how to get all items of given album (probably using g2_ChildEntity table), to apply personalized watermarks to different albums, but not now. atm I need some sleep

cheers,
austris
P.S.
coding nice UI would be too much from me, but more friendly SQL could come as soon as I'll get some time to play with this.

Austris, please if this work..can you explain more clearly and step by step on how to add the watermarking to all existing images... All my pictures are being stealed..

thks

What the hell do you mean???

I'm a newbie too with the same request as geraldmorales2. Could somebody at least give it a thought?

ok, and here comes SQLs

UPDATE g2test_Derivative gDeriv, g2test_ChildEntity gChildE, g2test_Entity gEntity, g2test_FileSystemEntity gFileSysE, g2test_WatermarkImage gWaterm
SET gDeriv.g_postFilterOperations=concat('composite|plugins_data/modules/watermark/', gWaterm.g_fileName,',',gWaterm.g_mimeType,',',gWaterm.g_width,',',gWaterm.g_height,',manual,',gWaterm.g_xPercentage,',',gWaterm.g_yPercentage)
WHERE gDeriv.g_derivativeType in (2,3)
AND gDeriv.g_derivativeSourceId = gChildE.g_id
AND gChildE.g_id = gEntity.g_id
AND gEntity.g_entityType in ('GalleryPhotoItem','GalleryDerivativeImage')
AND gChildE.g_parentId = gFileSysE.g_id
AND gFileSysE.g_pathComponent = 'testAlbum'
AND gWaterm.g_name='my_watermark'

UPDATE g2test_Derivative gDeriv, g2test_ChildEntity gChildE, g2test_ChildEntity gChildE2, g2test_Entity gEntity, g2test_FileSystemEntity gFileSysE, g2test_WatermarkImage gWaterm
SET gDeriv.g_postFilterOperations=concat('composite|plugins_data/modules/watermark/', gWaterm.g_fileName,',',gWaterm.g_mimeType,',',gWaterm.g_width,',',gWaterm.g_height,',manual,',gWaterm.g_xPercentage,',',gWaterm.g_yPercentage)
WHERE gDeriv.g_derivativeType in (2,3)
AND gDeriv.g_derivativeSourceId = gChildE2.g_id AND gChildE2.g_parentID=gChildE.g_id
AND gChildE.g_id = gEntity.g_id
AND gEntity.g_entityType in ('GalleryPhotoItem','GalleryDerivativeImage')
AND gChildE.g_parentId = gFileSysE.g_id
AND gFileSysE.g_pathComponent = 'testAlbum'
AND gWaterm.g_name='my_watermark'

Sofia, I'm not an expert w/ neither php nor mysql, could be older version of mysql does not support table aliases.
Just checked that I'm using phpMyAdmin 2.6.1-pl3 and MySQL 4.0.15.

Try shorter version of same sql:
select gDeriv.g_id, gDeriv.g_derivativeType from g2_Derivative gDeriv
if it works then it's most likely something with syntax in your changed update statement.
if it does not work then try
select g2_Derivative.g_id, g2_Derivative.g_derivativeType from g2_Derivative
if this works then just use "g2_Derivative" instead of "g2_Derivative gDeriv" in first line and "g2_Derivative" instead of "gDeriv" in all subsequent lines (and, of course, same for other tables - g2_ChildEntity, g2_Entity, g2_FileSystemEntity, g2_WatermarkImage).

hope this helps.

cheers,
Austris

well, if it works then I have no idea why update did not work.

What about:
select * from g2_Derivative gDeriv, g2_ChildEntity gChildE, g2_Entity gEntity, g2_FileSystemEntity gFileSysE, g2_WatermarkImage gWaterm

if it also works then I don't know. try to repeat copy&paste of update statement. just guessing - maybe some weird symbol instead of space before gDeriv.

and, in worst case, try to use just table names w/out aliases as I wrote before.

Austris
P.S.
here would be example of one of updates where tale aliases replaces with table names (hope I did not mistype anywhere):
UPDATE g2_Derivative, g2_ChildEntity, g2_Entity, g2_FileSystemEntity, g2_WatermarkImage
SET g2_Derivative.g_postFilterOperations=concat('composite|plugins_data/modules/watermark/', g2_WatermarkImage.g_fileName,',',g2_WatermarkImage.g_mimeType,',',g2_WatermarkImage.g_width,',',g2_WatermarkImage.g_height,',manual,',g2_WatermarkImage.g_xPercentage,',',g2_WatermarkImage.g_yPercentage)
WHERE g2_Derivative.g_derivativeType in (2,3)
AND g2_Derivative.g_derivativeSourceId = g2_ChildEntity.g_id
AND g2_ChildEntity.g_id = g2_Entity.g_id
AND g2_Entity.g_entityType in ('GalleryPhotoItem','GalleryDerivativeImage')
AND g2_ChildEntity.g_parentId = g2_FileSystemEntity.g_id
AND g2_FileSystemEntity.g_pathComponent = 'artistes'
AND g2_WatermarkImage.g_name='watermarkGenerations'

MichaelH99 - if postFilterOperations got updated and watermarks are still missing then my guess would be that you haven't cleared cache (including previously created derivative images)

1) make sure "Build all thumbnails/resizes" did not clear postoperation field. That's what I noticed in my installation.
It actually cleared the postoperation field in both cases - when it originally was filled by watermark module and when filled by my sql.
2) "Delete database cache" definetly won't help. Most expensive way (clearing _all_ derivatives) would be going to http://your host/gallery2/lib/support/ then CacheMaintenance and check "Thumbnails and resizes". Or delete content of galerydata/cache/derivative folder.

Hope it helps,
Austris

It was closed because the feature has been implemented in current cvs and will be one of the many new features in G2.2 when it is released. If you wanted to check it out, you could grab a copy via svn or nightly build.
_________________________________
Support & Documentation || Donate to Gallery || My Website

f**k i must be blind. I just upgraded to the latest version as i was still using 2.1, but I can't find it nowhere. At 'watermark' (almost down at the bottom of the list at site admin) nothing seems to have changed since 2.1. So I looked elsewhere but I just don't see it. Neither at the front end. I mean, I have a gallery with lots of unwatermarked images, I was hoping this new feature would enable me to just tell gallery2 to watermark all images found in the root album and all subalbums.... Can anyone point me in the right direction? Thanks!

Hi Carl, thanks for your reply!

However, I can see 'general, album and theme' (and 'custom fields' (i think it's called)), but no 'watermark' here... Yet I've got the latest version of Gallery2. Could it be a theme thing? Seems unlikely, but I'll check that out anyway right now.