Index: openacs-4/packages/acs-subsite/www/user/portrait/upload.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/user/portrait/upload.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-subsite/www/user/portrait/upload.tcl	10 Jan 2007 21:22:11 -0000	1.6
+++ openacs-4/packages/acs-subsite/www/user/portrait/upload.tcl	29 May 2007 05:37:25 -0000	1.7
@@ -15,6 +15,22 @@
 
 set current_user_id [ad_conn user_id]
 
+set portrait_p [db_0or1row "checkportrait" {SELECT live_revision as revision_id, item_id
+          FROM acs_rels a, cr_items c
+          WHERE a.object_id_two = c.item_id
+          AND a.rel_type = 'user_portrait_rel'
+          AND a.object_id_one = :current_user_id
+          AND c.live_revision is not NULL
+} ]
+
+
+if { $portrait_p } {
+	set story [db_string "getstory" "select description from cr_revisions where revision_id = :revision_id"]
+} else {
+	set story ""
+	set revision_id ""
+}
+
 if {$user_id eq ""} {
     subsite::upload_allowed
     set user_id $current_user_id