[Logicampus-cvs] logicampus/src/logicreate/services/classroom content.lcp, 1.13, 1.14

[Mark K <har...@us...>]

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