Index: openacs-4/packages/simulation/www/role-edit.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/www/Attic/role-edit.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/simulation/www/role-edit.tcl	24 Oct 2003 09:46:13 -0000	1.1
+++ openacs-4/packages/simulation/www/role-edit.tcl	27 Oct 2003 07:31:55 -0000	1.2
@@ -37,12 +37,10 @@
 
 set char_options [db_list_of_lists character_option_list "
     select ci.name,
-           a.object_id
+           cr.item_id
       from cr_revisions cr,
-           cr_items ci,
-           acs_objects a
-     where a.object_type = 'sim_character'
-       and cr.revision_id = a.object_id
+           cr_items ci
+     where ci.content_type = 'sim_character'
        and ci.item_id = cr.item_id
 "]