Index: openacs-4/contrib/packages/simulation/www/siminst/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/www/siminst/Attic/index.adp,v
diff -u -r1.10 -r1.11
--- openacs-4/contrib/packages/simulation/www/siminst/index.adp 11 Dec 2003 13:21:53 -0000 1.10
+++ openacs-4/contrib/packages/simulation/www/siminst/index.adp 11 Dec 2003 15:48:32 -0000 1.11
@@ -2,9 +2,8 @@
-
Index: openacs-4/contrib/packages/simulation/www/siminst/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/www/siminst/Attic/index.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/contrib/packages/simulation/www/siminst/index.tcl 11 Dec 2003 15:41:46 -0000 1.8
+++ openacs-4/contrib/packages/simulation/www/siminst/index.tcl 11 Dec 2003 15:48:32 -0000 1.9
@@ -73,11 +73,13 @@
(select count(*)
from sim_roles sr,
workflow_roles wr
- where wr.workflow_id = w.workflow_id) as role_count,
+ where sr.role_id = wr.role_id
+ and wr.workflow_id = w.workflow_id) as role_count,
(select count(*)
from sim_roles sr,
workflow_roles wr
- where wr.workflow_id = w.workflow_id
+ where sr.role_id = wr.role_id
+ and wr.workflow_id = w.workflow_id
and character_id is null) as role_empty_count,
(select count(*)
from sim_task_object_map stom,
Index: openacs-4/packages/simulation/www/siminst/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/www/siminst/index.adp,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/simulation/www/siminst/index.adp 11 Dec 2003 13:21:53 -0000 1.10
+++ openacs-4/packages/simulation/www/siminst/index.adp 11 Dec 2003 15:48:32 -0000 1.11
@@ -2,9 +2,8 @@
-
Index: openacs-4/packages/simulation/www/siminst/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/www/siminst/index.tcl,v diff -u -r1.8 -r1.9 --- openacs-4/packages/simulation/www/siminst/index.tcl 11 Dec 2003 15:41:46 -0000 1.8 +++ openacs-4/packages/simulation/www/siminst/index.tcl 11 Dec 2003 15:48:32 -0000 1.9 @@ -73,11 +73,13 @@ (select count(*) from sim_roles sr, workflow_roles wr - where wr.workflow_id = w.workflow_id) as role_count, + where sr.role_id = wr.role_id + and wr.workflow_id = w.workflow_id) as role_count, (select count(*) from sim_roles sr, workflow_roles wr - where wr.workflow_id = w.workflow_id + where sr.role_id = wr.role_id + and wr.workflow_id = w.workflow_id and character_id is null) as role_empty_count, (select count(*) from sim_task_object_map stom,