[Logicampus-cvs] logicampus/src/logicreate/services/welcome catalog.lcp, 1.1, 1.2

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

Update of /cvsroot/logicampus/logicampus/src/logicreate/services/welcome
In directory sc8-pr-cvs6.sourceforge.net:/tmp/cvs-serv20379

Modified Files:
	catalog.lcp 
Log Message:
only show active courses from the course catalog.

Index: catalog.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/welcome/catalog.lcp,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** catalog.lcp	12 May 2007 18:54:49 -0000	1.1
--- catalog.lcp	26 Jan 2008 21:29:40 -0000	1.2
***************
*** 134,138 ****
  		"WS"=>'Women\'s Studies',
  		);
! 		return $courses;
  	}
  }
--- 134,146 ----
  		"WS"=>'Women\'s Studies',
  		);
! 		$db = DB::getHandle();
! //		echo ('SELECT * FROM courses WHERE courseFamily IN ("'.implode('","', array_keys($courses)).'")');
! 		$db->query('SELECT * FROM courses WHERE courseFamily IN ("'.implode('","', array_keys($courses)).'")');
! 		$availCourses = array();
! 
! 		while ($db->nextRecord()) {
! 			$availCourses[ $db->record['courseFamily'] ] = $courses[ $db->record['courseFamily'] ];
! 		}
! 		return $availCourses;
  	}
  }