Open Notes Picture Database - Feature Request: comments and authors in html picture overviewCreated on |
Nov 2, 2005 |
Created by |
heinz koton |
Status |
Submitted |
please add to view "HTML\PhotosForPublic"
in view selection:
SELECT ((Form = "Picture") | (Form = "Video") | (Form = "Album_sub") | (Form = "StoryResponse")) & (!@Contains(delete; "1"))& (!@Contains(PhotoStatus; "Private"))
in view formula:
webdbname := @WebDbName;
_subject := @If(@IsAvailable(Subject);Subject;"Album: "+AlbumName);
_subject := @ReplaceSubstring(_Subject;"&";"&");
_subject := @ReplaceSubstring(_Subject;"\"";""");
_comments:= " - Comm: "+@DocChildren;
_res := @If(@IsNumber(PHOTO_THUMB_HEIGHT);" height=\"" + @Text(PHOTO_THUMB_HEIGHT) + "\" width=\"" + @Text(PHOTO_THUMB_WIDTH) + "\"";"");
link := "/"+webdbname+@If(Form="Album_sub";"/albums/";"/pictures/")+PermaLink;
image1 := "<img src=\"/"+WebDbName+"/pictures/"+@If(Form="Album_sub";AlbumPicture;PermaLink)+"/$File/"+@If(Form="Album_sub";AlbumPictureThumbnail;PHOTO_THUMB_FILENAME)+"\"" + _res + " alt=\"" + _Subject + "\" title=\"" + _Subject + "\" class=\"showThumbs\">";
image2 := "<img src=\"/"+WebDbName+@If(Form="Album_sub";"/images/photoalbum.jpg";"/no_preview_available.gif")+"\" border=\"0\">";
@If(@If(Form="Album_sub";AlbumPictureThumbnail;PHOTO_THUMB_FILENAME) = "";image:=image2;image:=image1);
@If(Form="StoryResponse";@Unique(NameAuthor);
"<div class=\"Thumbnail\">" + @NewLine +
"<a href=\""+link+"\">"+@NewLine
+image+"</a><br clear=\"right\">"+ @NewLine +
_Subject+_comments+"<br clear=\"all\"> </div>" + @NewLine)
or even better code for proper viewing the hmtl text in the pic's overview.
thks
heinz
Taken Actions by OwnersNo actions have been taken yet.