Update of /cvsroot/logicampus/logicampus/src/logicreate/services/classroom
In directory sc8-pr-cvs6.sourceforge.net:/tmp/cvs-serv15312/classroom
Modified Files:
content.lcp
Log Message:
Fix query for linked images in the content viewer.
Index: content.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/content.lcp,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** content.lcp 5 Oct 2007 22:37:38 -0000 1.13
--- content.lcp 8 Oct 2007 14:11:46 -0000 1.14
***************
*** 117,125 ****
// try to find it just linked up to this class
if ($curIdx == -1) {
! $db->query("SELECT * FROM lob_content as A
! LEFT JOIN lob_class_repo AS B on A.lob_content_id = B.lob_class_repo_id
WHERE B.lob_urltitle = '".$filename."'
AND B.class_id = ".$classId);
-
} else {
$db->query("SELECT A.*, B.lob_mime, B.lob_sub_type
--- 117,124 ----
// try to find it just linked up to this class
if ($curIdx == -1) {
! $db->query("SELECT * FROM lob_class_content as A
! LEFT JOIN lob_class_repo AS B on A.lob_class_repo_id = B.lob_class_repo_id
WHERE B.lob_urltitle = '".$filename."'
AND B.class_id = ".$classId);
} else {
$db->query("SELECT A.*, B.lob_mime, B.lob_sub_type
|
