Index: openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/message-list-oracle.xql,v
diff -u -r1.2.2.1 -r1.2.2.2
--- openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql	9 Dec 2003 13:41:52 -0000	1.2.2.1
+++ openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql	9 Feb 2004 09:56:03 -0000	1.2.2.2
@@ -10,7 +10,8 @@
     select lmk.message_key,
            lm1.message as default_message,
            lm2.message as translated_message,
-           lmk.description
+           lmk.description,
+           nvl(lm2.deleted_p, 'f') as deleted_p
     from   lang_messages lm1,
            lang_messages lm2,
            lang_message_keys lmk
@@ -21,7 +22,6 @@
     and    lm2.locale (+) = :locale
     and    lm2.message_key (+) = lmk.message_key
     and    lm2.package_key (+) = lmk.package_key
-    and    (lm2.deleted_p = 'f' or lm2.deleted_p is null)
     and    lm1.deleted_p = 'f'
     $where_clause
     order  by upper(lm1.message_key), lm1.message_key
Index: openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/message-list-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql	9 Dec 2003 13:41:52 -0000	1.1.2.1
+++ openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql	9 Feb 2004 09:56:03 -0000	1.1.2.2
@@ -9,15 +9,15 @@
     select lm1.message_key,
            lm1.message as default_message,
            lm2.message as translated_message,
-           lmk.description
+           lmk.description,
+           coalesce(lm2.deleted_p, 'f') as deleted_p
     from   lang_messages lm1 left outer join 
            lang_messages lm2 on (lm2.locale = :locale and lm2.message_key = lm1.message_key and lm2.package_key = lm1.package_key),
            lang_message_keys lmk
     where  lm1.locale = :default_locale
     and    lm1.package_key = :package_key
     and    lm1.message_key = lmk.message_key
     and    lm1.package_key = lmk.package_key
-    and    (lm2.deleted_p = 'f' or lm2.deleted_p is null)
     and    lm1.deleted_p = 'f'
     $where_clause
     order  by upper(lm1.message_key), lm1.message_key
Index: openacs-4/packages/acs-lang/www/admin/message-list.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/message-list.adp,v
diff -u -r1.5.2.1 -r1.5.2.2
--- openacs-4/packages/acs-lang/www/admin/message-list.adp	9 Dec 2003 13:41:52 -0000	1.5.2.1
+++ openacs-4/packages/acs-lang/www/admin/message-list.adp	9 Feb 2004 09:56:03 -0000	1.5.2.2
@@ -61,9 +61,14 @@
               </td>
               <td>@messages.default_message@</td>
               <if @default_locale@ ne @current_locale@>
-                <td>
-                  <if @messages.translated_message@ not nil>@messages.translated_message@</if>
-                  <else><span style="color: gray; font-style: italic;">Not translated</span></else>
+                <td>                  
+                  <if @messages.deleted_p@>
+                    <span style="color: red; font-style: italic;">DELETED</span> (@messages.translated_message@)
+                  </if>
+                  <else>
+                    <if @messages.translated_message@ not nil>@messages.translated_message@</if>
+                    <else><span style="color: gray; font-style: italic;">Not translated</span></else>
+                  </else>
                 </td>
               </if>
               <if @messages.translated_message@ not nil>