OpenACS

arjun
committed
MAIN:arjun:20020709171633
on 09 Jul 02
updated content-repository-content-files section
openacs-4/.../imsld/tcl/imsld-procs.xql (+1 -1)
1119 1119
1120 1120                 select cpr.resource_id,
1121 1121                 cpr.item_id as resource_item_id,
1122 1122                 cpr.type as resource_type
1123 1123                 from imsld_cp_resourcesi cpr, imsld_itemsi ii,
1124 1124                 acs_rels ar
1125 1125                 where ar.object_id_one = ii.item_id
1126 1126                 and ar.object_id_two = cpr.item_id
1127 1127                 and content_revision__is_live(cpr.resource_id) = 't'
1128 1128                 and (imsld_tree_sortkey between tree_left((select imsld_tree_sortkey from imsld_items where imsld_item_id = :imsld_item_id))
1129 1129                      and tree_right((select imsld_tree_sortkey from imsld_items where imsld_item_id = :imsld_item_id))
1130 1130                      or ii.imsld_item_id = :imsld_item_id)
1131 1131
1132 1132          </querytext>
1133 1133         </fullquery>
1134 1134
1135 1135     <fullquery name="imsld::process_service_as_ul.get_send_mail_info">
1136 1136                 <querytext>
1137 1137
1138 1138                 select sm.title as send_mail_title, ar.object_id_two as sendmail_id
1139                   from imsld_send_mail_servicesi sm
  1139                 from imsld_send_mail_servicesi sm, acs_rels ar
1140 1140                 where sm.service_id = :service_item_id
1141 1141                 and sm.item_id = ar.object_id_one
1142 1142                 and ar.rel_type = 'imsld_send_mail_serv_data_rel'
1143 1143                 and content_revision__is_live(sm.mail_id) = 't'
1144 1144            
1145 1145                 </querytext>
1146 1146         </fullquery>
1147 1147
1148 1148         <fullquery name="imsld::process_service_as_ul.monitor_service_info">
1149 1149                 <querytext>
1150 1150
1151 1151                 select ims.title as monitor_service_title,
1152 1152                 ims.monitor_id,
1153 1153                 ims.item_id as monitor_item_id,
1154 1154                 ims.self_p,
1155 1155                 ims.role_id,
1156 1156                 cr.live_revision as imsld_item_id
1157 1157                 from imsld_monitor_servicesi ims, cr_items cr
1158 1158                 where ims.service_id = :service_item_id
1159 1159                 and cr.item_id = ims.imsld_item_id