Index: openacs-4/packages/dotlrn/www/control-panel.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/control-panel.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn/www/control-panel.xql	8 Aug 2006 21:26:24 -0000	1.2
+++ openacs-4/packages/dotlrn/www/control-panel.xql	3 Apr 2009 12:13:49 -0000	1.3
@@ -3,10 +3,11 @@
  
 <fullquery name="get_portrait_info">      
   <querytext>
-    select cr.publish_date, cr.title as portrait_title, cr.description as portrait_description
-    from cr_revisions cr, cr_items ci, acs_rels a
-    where cr.revision_id = ci.live_revision
-    and  ci.item_id = a.object_id_two
+    select cr.publish_date, cr.title as portrait_title, cr.description as portrait_description, i.width, i.height, ci.item_id
+    from cr_revisions cr, cr_items ci, acs_rels a, images i
+    where i.image_id = cr.revision_id
+    and cr.revision_id = ci.live_revision
+    and ci.item_id = a.object_id_two
     and a.object_id_one = :user_id
     and a.rel_type = 'user_portrait_rel'
   </querytext>