[Logicampus-cvs] logicampus/src/logicreate/services/classmgr adjustDates.lcp, 1.2, 1.3 adjustLesson

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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

Modified Files:
	adjustDates.lcp adjustLessonDates.lcp assignmentManage.lcp 
	cal.lcp classSetup.lcp contactStudents.lcp dataexchange.lcp 
	ettendance.lcp examschedule.lcp exportContent.lcp forum.lcp 
	lessonContent.lcp lessonManager.lcp lessonNew.lcp 
	lessonObjectives.lcp lessonWebliography.lcp links.lcp 
	orientations.lcp semestercopy.lcp seminars.lcp 
	studentPresentation.lcp studentProfile.lcp teacherclass.lcp 
	textbooks.lcp users.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: lessonObjectives.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/lessonObjectives.lcp,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** lessonObjectives.lcp	18 Nov 2006 00:09:34 -0000	1.5
--- lessonObjectives.lcp	8 Oct 2007 14:21:07 -0000	1.6
***************
*** 85,90 ****
  		$classmgr_itemsToTitles = array();

! 		while ($db->next_record()) {
! 			$classmgr_itemsToTitles[$db->Record['id_class_objectives']][] = $db->Record['title'];
  		}
  		//collapse the double array into one string
--- 85,90 ----
  		$classmgr_itemsToTitles = array();

! 		while ($db->nextRecord()) {
! 			$classmgr_itemsToTitles[$db->record['id_class_objectives']][] = $db->record['title'];
  		}
  		//collapse the double array into one string
***************
*** 183,187 ****
  			where id_classes='{$u->activeClassTaught->id_classes}'
  			and id_class_objectives='{$objectiveid}'");
! 		if (!$db->Record['cnt']) {
  			$this->presentor = 'errorMessage';
  			$t['message'] = "You don't have permission to modify that objective.";
--- 183,187 ----
  			where id_classes='{$u->activeClassTaught->id_classes}'
  			and id_class_objectives='{$objectiveid}'");
! 		if (!$db->record['cnt']) {
  			$this->presentor = 'errorMessage';
  			$t['message'] = "You don't have permission to modify that objective.";

Index: adjustDates.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/adjustDates.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** adjustDates.lcp	3 Sep 2007 20:33:49 -0000	1.2
--- adjustDates.lcp	8 Oct 2007 14:21:07 -0000	1.3
***************
*** 265,272 ****
  				$lc->postvars['deactiveOn'][$row]['year']);

! 			if ( $activeOnStamp != $db->Record['date_available'] 
! 				|| $deactiveOnStamp != $db->Record['date_unavailable'] ) {
! 				$updates[$db->Record['id_class_lessons']]['date_available'] = $activeOnStamp;
! 				$updates[$db->Record['id_class_lessons']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
--- 265,272 ----
  				$lc->postvars['deactiveOn'][$row]['year']);

! 			if ( $activeOnStamp != $db->record['date_available'] 
! 				|| $deactiveOnStamp != $db->record['date_unavailable'] ) {
! 				$updates[$db->record['id_class_lessons']]['date_available'] = $activeOnStamp;
! 				$updates[$db->record['id_class_lessons']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
***************
*** 336,343 ****
  				$lc->postvars['deactiveOn'][$row]['year']);

! 			if ( $activeOnStamp != $db->Record['date_available'] 
! 				|| $deactiveOnStamp != $db->Record['date_unavailable'] ) {
! 				$updates[$db->Record['assessment_id']]['date_available'] = $activeOnStamp;
! 				$updates[$db->Record['assessment_id']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
--- 336,343 ----
  				$lc->postvars['deactiveOn'][$row]['year']);

! 			if ( $activeOnStamp != $db->record['date_available'] 
! 				|| $deactiveOnStamp != $db->record['date_unavailable'] ) {
! 				$updates[$db->record['assessment_id']]['date_available'] = $activeOnStamp;
! 				$updates[$db->record['assessment_id']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
***************
*** 443,452 ****

! 			if ( $activeStamp != $db->Record['activeDate'] 
! 				|| $dueDateStamp != $db->Record['dueDate'] 
! 				|| $dateNoAcceptStamp != $db->Record['dateNoAccept'] ) {
! 				$updates[$db->Record['id_class_assignments']]['activeDate'] = $activeStamp;
! 				$updates[$db->Record['id_class_assignments']]['dueDate'] = $dueDateStamp;
! 				$updates[$db->Record['id_class_assignments']]['dateNoAccept'] = $dateNoAcceptStamp;
  			}
  			++$row;
--- 443,452 ----

! 			if ( $activeStamp != $db->record['activeDate'] 
! 				|| $dueDateStamp != $db->record['dueDate'] 
! 				|| $dateNoAcceptStamp != $db->record['dateNoAccept'] ) {
! 				$updates[$db->record['id_class_assignments']]['activeDate'] = $activeStamp;
! 				$updates[$db->record['id_class_assignments']]['dueDate'] = $dueDateStamp;
! 				$updates[$db->record['id_class_assignments']]['dateNoAccept'] = $dateNoAcceptStamp;
  			}
  			++$row;
***************
*** 523,530 ****
  				$lc->postvars['dt_hide'][$row]['year']));

! 			if ( $dtDisplayStamp != $db->Record['dt_display'] 
! 				|| $dtHideStamp != $db->Record['dt_hide'] ) {
! 				$updates[$db->Record['id_class_announcements']]['dt_display'] = $dtDisplayStamp;
! 				$updates[$db->Record['id_class_announcements']]['dt_hide'] = $dtHideStamp;
  			}
  			++$row;
--- 523,530 ----
  				$lc->postvars['dt_hide'][$row]['year']));

! 			if ( $dtDisplayStamp != $db->record['dt_display'] 
! 				|| $dtHideStamp != $db->record['dt_hide'] ) {
! 				$updates[$db->record['id_class_announcements']]['dt_display'] = $dtDisplayStamp;
! 				$updates[$db->record['id_class_announcements']]['dt_hide'] = $dtHideStamp;
  			}
  			++$row;
***************
*** 593,600 ****
  				$lc->postvars['enddate'][$row]['year']);

! 			if ( $startDateStamp != $db->Record['startdate'] 
! 				|| $endDateStamp != $db->Record['enddate'] ) {
! 				$updates[$db->Record['pkey']]['startdate'] = $startDateStamp;
! 				$updates[$db->Record['pkey']]['enddate'] = $endDateStamp;
  			}
  			++$row;
--- 593,600 ----
  				$lc->postvars['enddate'][$row]['year']);

! 			if ( $startDateStamp != $db->record['startdate'] 
! 				|| $endDateStamp != $db->record['enddate'] ) {
! 				$updates[$db->record['pkey']]['startdate'] = $startDateStamp;
! 				$updates[$db->record['pkey']]['enddate'] = $endDateStamp;
  			}
  			++$row;

Index: lessonContent.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/lessonContent.lcp,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** lessonContent.lcp	2 Jun 2007 19:42:24 -0000	1.14
--- lessonContent.lcp	8 Oct 2007 14:21:07 -0000	1.15
***************
*** 122,126 ****
  			where id_class_lesson_content='{$lc->getvars['id']}'
  			and id_classes='{$u->activeClassTaught->id_classes}'");
! 		if ( !$db->Record['txText'] ) {
  			$t['error'] = 'Content not available.';
  			$this->Run($db,$u,$lc,$t);
--- 122,126 ----
  			where id_class_lesson_content='{$lc->getvars['id']}'
  			and id_classes='{$u->activeClassTaught->id_classes}'");
! 		if ( !$db->record['txText'] ) {
  			$t['error'] = 'Content not available.';
  			$this->Run($db,$u,$lc,$t);
***************
*** 128,132 ****
  		}

! 		$lc->postvars['NOTPOSTVARtxText'] = $db->Record['txText'];

  		$this->processRun($db,$u,$lc,$t);
--- 128,132 ----
  		}

! 		$lc->postvars['NOTPOSTVARtxText'] = $db->record['txText'];

  		$this->processRun($db,$u,$lc,$t);
***************
*** 417,421 ****
  			where id_classes='{$u->activeClassTaught->id_classes}'
  			and id_class_lesson_content='{$contentid}'");
! 		if (!$db->Record['cnt']) {
  			$this->presentor = 'errorMessage';
  			$t['message'] = "You don't have permission to modify that content.";
--- 417,421 ----
  			where id_classes='{$u->activeClassTaught->id_classes}'
  			and id_class_lesson_content='{$contentid}'");
! 		if (!$db->record['cnt']) {
  			$this->presentor = 'errorMessage';
  			$t['message'] = "You don't have permission to modify that content.";

Index: examschedule.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/examschedule.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** examschedule.lcp	15 Jan 2007 05:12:32 -0000	1.4
--- examschedule.lcp	8 Oct 2007 14:21:07 -0000	1.5
***************
*** 115,120 ****
  		$db->query($sql);
  		$emailTo = '';
! 		while($db->next_record() )
! 		{	$emailTo .= $db->Record['email'].',';	
  		}

--- 115,120 ----
  		$db->query($sql);
  		$emailTo = '';
! 		while($db->nextRecord() )
! 		{	$emailTo .= $db->record['email'].',';	
  		}

***************
*** 197,203 ****

  			$db->queryOne($sql);
! 			if (is_array($db->Record))
  			{	
! 				$t['tx_noexam'] = $db->Record['noExam'];

  			} else
--- 197,203 ----

  			$db->queryOne($sql);
! 			if (is_array($db->record))
  			{	
! 				$t['tx_noexam'] = $db->record['noExam'];

  			} else
***************
*** 278,282 ****
  				where facultyId="'.$u->username.'"
  				and id_classes="'.(int)$lc->getvars['id'].'"');
! 			if ( !$db->Record['id_classes'] ) {
  				$this->presentation = 'errorMessage';
  				$t['message'] = 'We\'re sorry, but access was denied to that class. '
--- 278,282 ----
  				where facultyId="'.$u->username.'"
  				and id_classes="'.(int)$lc->getvars['id'].'"');
! 			if ( !$db->record['id_classes'] ) {
  				$this->presentation = 'errorMessage';
  				$t['message'] = 'We\'re sorry, but access was denied to that class. '
***************
*** 407,412 ****
  		$time = time();

! 		if ( $time > strtotime($db->Record['dateStartExam'])
! 		  && $time < strtotime($db->Record['dateEndExam']) )
  				return true;

--- 407,412 ----
  		$time = time();

! 		if ( $time > strtotime($db->record['dateStartExam'])
! 		  && $time < strtotime($db->record['dateEndExam']) )
  				return true;

Index: users.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/users.lcp,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** users.lcp	22 May 2007 03:25:11 -0000	1.9
--- users.lcp	8 Oct 2007 14:21:07 -0000	1.10
***************
*** 213,222 ****
  				where classes.id_semesters=$semesterId 
  				and classes.id_courses = courses.id_courses order by courses.courseFamily, courses.courseNumber, courseName");
! 		while($db->next_record()) {
! 			$x = explode("\n",$db->Record['sectionNumbers']);
  			foreach($x as $k=>$v) { 
! 				$c[$v] = $db->Record['courseFamily']." ".
! 				$db->Record['courseNumber']." - ".$db->Record['courseName']." - ".
! 				" ($v) - ".$db->Record['facultyId'];
  			}
  		}
--- 213,222 ----
  				where classes.id_semesters=$semesterId 
  				and classes.id_courses = courses.id_courses order by courses.courseFamily, courses.courseNumber, courseName");
! 		while($db->nextRecord()) {
! 			$x = explode("\n",$db->record['sectionNumbers']);
  			foreach($x as $k=>$v) { 
! 				$c[$v] = $db->record['courseFamily']." ".
! 				$db->record['courseNumber']." - ".$db->record['courseName']." - ".
! 				" ($v) - ".$db->record['facultyId'];
  			}
  		}
***************
*** 247,251 ****
  // 
  		$db->queryOne("select id_semesters from semesters where dateStart<=now()  and dateDeactivation>=now()");
! 		$semesterId = $db->Record['id_semesters'];

  		$name = addslashes(stripslashes($lc->getvars['username']));
--- 247,251 ----
  // 
  		$db->queryOne("select id_semesters from semesters where dateStart<=now()  and dateDeactivation>=now()");
! 		$semesterId = $db->record['id_semesters'];

  		$name = addslashes(stripslashes($lc->getvars['username']));
***************
*** 289,304 ****
  		}

! 		while ($db->next_record() ) {
! 			if ( ($db->Record['firstname']== '') and 
!            ($db->Record['lastname'] == '') ) {

! 				$db->Record['profiledata'] = "<i>Incomplete profile data</i>";

  			} else {

! 				$db->Record['profiledata'] = $db->Record['lastname'].", ".$db->Record['firstname'];

  			}
! 			$t['users'][] = $db->Record;
  		}

--- 289,304 ----
  		}

! 		while ($db->nextRecord() ) {
! 			if ( ($db->record['firstname']== '') and 
!            ($db->record['lastname'] == '') ) {

! 				$db->record['profiledata'] = "<i>Incomplete profile data</i>";

  			} else {

! 				$db->record['profiledata'] = $db->record['lastname'].", ".$db->record['firstname'];

  			}
! 			$t['users'][] = $db->record;
  		}

***************
*** 311,318 ****
  		}

! 		$db->next_record();
! 		$t['result_pages'] = ceil( $db->Record['usrcount'] / $this->PAGE_SIZE);
  		$t['current_page'] = ceil( $t[start] / $this->PAGE_SIZE) + 1;
! 		$t['max_results'] = $db->Record['usrcount'];
  		$t['PAGE_SIZE'] = $this->PAGE_SIZE;

--- 311,318 ----
  		}

! 		$db->nextRecord();
! 		$t['result_pages'] = ceil( $db->record['usrcount'] / $this->PAGE_SIZE);
  		$t['current_page'] = ceil( $t[start] / $this->PAGE_SIZE) + 1;
! 		$t['max_results'] = $db->record['usrcount'];
  		$t['PAGE_SIZE'] = $this->PAGE_SIZE;

***************
*** 320,336 ****
  		//profile
  		$db->query("describe profile");	//get profile meta data
! 		$db->next_record(); 		//drop off pkey
  		$t['profile_opt'] .= "<option value='_email'>Email</option>\n";
  		$t['profile_opt'] .= "<option value='_username'>Username</option>\n";
  		$db->setResultType('BOTH');
! 		while ($db->next_record() ) {
! 			$t['profile_opt'] .= "<option value=\"".$db->Record[0]."\">".$db->Record[0]."</option>\n";
  		}

  		$db->query("select * from courses order by courseFamily, courseNumber, courseName");

! 		while($db->next_record()) {

! 			$x[$db->Record['id_courses']] = substr($db->Record['courseFamily']." ".$db->Record['courseNumber']." - ".$db->Record['courseName'], 0, 40);

  		}
--- 320,336 ----
  		//profile
  		$db->query("describe profile");	//get profile meta data
! 		$db->nextRecord(); 		//drop off pkey
  		$t['profile_opt'] .= "<option value='_email'>Email</option>\n";
  		$t['profile_opt'] .= "<option value='_username'>Username</option>\n";
  		$db->setResultType('BOTH');
! 		while ($db->nextRecord() ) {
! 			$t['profile_opt'] .= "<option value=\"".$db->record[0]."\">".$db->record[0]."</option>\n";
  		}

  		$db->query("select * from courses order by courseFamily, courseNumber, courseName");

! 		while($db->nextRecord()) {

! 			$x[$db->record['id_courses']] = substr($db->record['courseFamily']." ".$db->record['courseNumber']." - ".$db->record['courseName'], 0, 40);

  		}
***************
*** 338,343 ****
  		$t['courses'] = makeOptions($x, (int)$this->course);
  		$db->query("select * from semesters");
! 		while($db->next_record()) {
! 			$s[$db->Record['id_semesters']] = $db->Record['semesterId'];
  		}
  		$t['semesters'] = makeOptions($s, (int)$this->semester);
--- 338,343 ----
  		$t['courses'] = makeOptions($x, (int)$this->course);
  		$db->query("select * from semesters");
! 		while($db->nextRecord()) {
! 			$s[$db->record['id_semesters']] = $db->record['semesterId'];
  		}
  		$t['semesters'] = makeOptions($s, (int)$this->semester);
***************
*** 488,495 ****

  		$db->query($sql);
! 		while($db->next_record() )
  		{
! 			$data['courseFamily'][$db->Record['id_profile_faculty_coursefamily']] =
! 			$db->Record['id_profile_faculty_coursefamily'];

  		}
--- 488,495 ----

  		$db->query($sql);
! 		while($db->nextRecord() )
  		{
! 			$data['courseFamily'][$db->record['id_profile_faculty_coursefamily']] =
! 			$db->record['id_profile_faculty_coursefamily'];

  		}
***************
*** 569,576 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 	    $t['user'] = $db->Record;

! 		$t['photo'] = is_file(IMAGES_PATH.'photos/'.$db->Record['photo'])
! 			? IMAGES_URL.'photos/'.$db->Record['photo']
  			: IMAGES_URL.'noimage.png';

--- 569,576 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 	    $t['user'] = $db->record;

! 		$t['photo'] = is_file(IMAGES_PATH.'photos/'.$db->record['photo'])
! 			? IMAGES_URL.'photos/'.$db->record['photo']
  			: IMAGES_URL.'noimage.png';

***************
*** 594,599 ****
  			$sql = "select pkey,username from lcUsers where pkey = $orclause";
  			$db->query($sql);
! 			while ($db->next_record() ) {
! 				$u->sessionvars['user_collection'][$db->Record['pkey']] = $db->Record['username'];
  				$n++;
  			}
--- 594,599 ----
  			$sql = "select pkey,username from lcUsers where pkey = $orclause";
  			$db->query($sql);
! 			while ($db->nextRecord() ) {
! 				$u->sessionvars['user_collection'][$db->record['pkey']] = $db->record['username'];
  				$n++;
  			}

Index: lessonNew.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/lessonNew.lcp,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** lessonNew.lcp	4 Oct 2007 17:50:57 -0000	1.11
--- lessonNew.lcp	8 Oct 2007 14:21:07 -0000	1.12
***************
*** 335,341 ****
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$itemsToTitles[$db->Record['id_class_assignments']][] = $db->Record['title'];
! 			$itemsToLessons[$db->Record['id_class_assignments']][] = $db->Record['id_class_lessons'];
  		}

--- 335,341 ----
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$itemsToTitles[$db->record['id_class_assignments']][] = $db->record['title'];
! 			$itemsToLessons[$db->record['id_class_assignments']][] = $db->record['id_class_lessons'];
  		}

***************
*** 400,406 ****
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$itemsToTitles[$db->Record['assessment_id']][] = $db->Record['title'];
! 			$itemsToLessons[$db->Record['assessment_id']][] = $db->Record['lesson_id'];
  		}

--- 400,406 ----
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$itemsToTitles[$db->record['assessment_id']][] = $db->record['title'];
! 			$itemsToLessons[$db->record['assessment_id']][] = $db->record['lesson_id'];
  		}

***************
*** 464,470 ****
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$itemsToTitles[$db->Record['id_class_links']][] = $db->Record['title'];
! 			$itemsToLessons[$db->Record['id_class_links']][] = $db->Record['id_class_lessons'];
  		}

--- 464,470 ----
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$itemsToTitles[$db->record['id_class_links']][] = $db->record['title'];
! 			$itemsToLessons[$db->record['id_class_links']][] = $db->record['id_class_lessons'];
  		}

***************
*** 527,533 ****
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$itemsToTitles[$db->Record['id_class_objectives']][] = $db->Record['title'];
! 			$itemsToLessons[$db->Record['id_class_objectives']][] = $db->Record['id_class_lesson'];
  		}

--- 527,533 ----
  			ORDER BY B.title";
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$itemsToTitles[$db->record['id_class_objectives']][] = $db->record['title'];
! 			$itemsToLessons[$db->record['id_class_objectives']][] = $db->record['id_class_lesson'];
  		}

***************
*** 575,580 ****
  			WHERE A.id_classes = ".$class_id;
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$allowableItems[] = $db->Record['id_class_objectives'];
  		}

--- 575,580 ----
  			WHERE A.id_classes = ".$class_id;
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$allowableItems[] = $db->record['id_class_objectives'];
  		}

***************
*** 622,627 ****
  			WHERE A.class_id = ".$class_id;
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$allowableItems[] = $db->Record['assessment_id'];
  		}

--- 622,627 ----
  			WHERE A.class_id = ".$class_id;
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$allowableItems[] = $db->record['assessment_id'];
  		}

***************
*** 661,666 ****
  			WHERE A.id_classes = ".$class_id;
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$allowableItems[] = $db->Record['id_class_links'];
  		}

--- 661,666 ----
  			WHERE A.id_classes = ".$class_id;
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$allowableItems[] = $db->record['id_class_links'];
  		}

***************
*** 699,704 ****
  			WHERE A.id_classes = ".$class_id;
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$allowableItems[] = $db->Record['id_class_assignments'];
  		}

--- 699,704 ----
  			WHERE A.id_classes = ".$class_id;
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$allowableItems[] = $db->record['id_class_assignments'];
  		}

***************
*** 767,771 ****
  			where l.id_classes='{$u->activeClassTaught->id_classes}'
  			and l.id_class_lessons='{$lessonid}'");
! 		if (!$db->Record['cnt'] || intval($lessonid) == 0 ) {
  			$this->presentor = 'errorMessage';
  			$t['message'] = "You don't have permission to modify that lesson.";
--- 767,771 ----
  			where l.id_classes='{$u->activeClassTaught->id_classes}'
  			and l.id_class_lessons='{$lessonid}'");
! 		if (!$db->record['cnt'] || intval($lessonid) == 0 ) {
  			$this->presentor = 'errorMessage';
  			$t['message'] = "You don't have permission to modify that lesson.";

Index: orientations.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/orientations.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** orientations.lcp	15 Aug 2004 20:30:40 -0000	1.2
--- orientations.lcp	8 Oct 2007 14:21:07 -0000	1.3
***************
*** 395,401 ****
  		'%|semmgr|%'";
  		$db->query($sql);
! 		while($db->next_record() )
  		{
! 			$emailTo .= $db->Record['email'].',';	
  		}
  		$emailTo = substr($emailTo, 0, -1);
--- 395,401 ----
  		'%|semmgr|%'";
  		$db->query($sql);
! 		while($db->nextRecord() )
  		{
! 			$emailTo .= $db->record['email'].',';	
  		}
  		$emailTo = substr($emailTo, 0, -1);
***************
*** 419,424 ****

  			// making sure we have a friggin record..
! 			if ($db->Record != false)
! 			{	$return_date = date('F j Y', strtotime($db->Record['date'])).' '.date('g:i A', strtotime('2003-02-03 '.$db->Record['time_start'])).' - '.date('g:i A', strtotime('2003-02-03 '.$db->Record['time_end'])).'';
  			}

--- 419,424 ----

  			// making sure we have a friggin record..
! 			if ($db->record != false)
! 			{	$return_date = date('F j Y', strtotime($db->record['date'])).' '.date('g:i A', strtotime('2003-02-03 '.$db->record['time_start'])).' - '.date('g:i A', strtotime('2003-02-03 '.$db->record['time_end'])).'';
  			}

Index: forum.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/forum.lcp,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** forum.lcp	15 May 2007 17:27:47 -0000	1.5
--- forum.lcp	8 Oct 2007 14:21:07 -0000	1.6
***************
*** 40,49 ****
  			FROM forumPosts 
  			WHERE parent=0 and fid='$fid' and status='y'");
! 		$count = $db->Record['total'];
  		$db->query("update forums set numthreads=$count where fid='$fid'");
  		$db->queryOne("select count(pkey) AS total
  			FROM forumPosts 
  			WHERE fid='$fid' and status='y'");
! 		$count = $db->Record['total'];
  		$db->query("update forums set validposts=$count where fid='$fid'");
  	}
--- 40,49 ----
  			FROM forumPosts 
  			WHERE parent=0 and fid='$fid' and status='y'");
! 		$count = $db->record['total'];
  		$db->query("update forums set numthreads=$count where fid='$fid'");
  		$db->queryOne("select count(pkey) AS total
  			FROM forumPosts 
  			WHERE fid='$fid' and status='y'");
! 		$count = $db->record['total'];
  		$db->query("update forums set validposts=$count where fid='$fid'");
  	}
***************
*** 59,70 ****
  		$g = implode("' or groups='",$u->groups);
  		$db->query("select fid from forumPerms where perm='view' and (groups='$g')");
! 		while($db->next_record()) {
! 			$fids[] = $db->Record[0];
  		}
  		$fid = @implode(" ' or fid='",$fids);

  		$db->query("select * from forums where fid='$fid'");
! 		while($db->next_record()) {
! 		$list[] = $db->Record;
  		}

--- 59,70 ----
  		$g = implode("' or groups='",$u->groups);
  		$db->query("select fid from forumPerms where perm='view' and (groups='$g')");
! 		while($db->nextRecord()) {
! 			$fids[] = $db->record[0];
  		}
  		$fid = @implode(" ' or fid='",$fids);

  		$db->query("select * from forums where fid='$fid'");
! 		while($db->nextRecord()) {
! 		$list[] = $db->record;
  		}

***************
*** 96,100 ****
  			//allowed to view this forum
  			$db->query("select pref_val from forumPrefs where username = '".$u->username."' and pref_key = 'sendEmail' and pref_val = '".$arg->postvars[fid]."'");
! 			if ($db->next_record() ) {
  				//has perm, must remove if checkbox is empty
  				if ( $pref != 'on' ) {
--- 96,100 ----
  			//allowed to view this forum
  			$db->query("select pref_val from forumPrefs where username = '".$u->username."' and pref_key = 'sendEmail' and pref_val = '".$arg->postvars[fid]."'");
! 			if ($db->nextRecord() ) {
  				//has perm, must remove if checkbox is empty
  				if ( $pref != 'on' ) {
***************
*** 170,177 ****
  			$t["forumname"] = $foruminfo["forumname"];
  			$db->queryOne("select count(pkey) from forumPosts where 1=1 and $clause");
! 			$threadcount = $db->Record[0];
  $db->query("select * from forumPosts where 1=1 and $clause order by stamptime DESC limit $start,$limit");
! while($db->next_record()) {
! 	$list[] = $db->Record;
  }
  //			$list = $post->_getAll("stamptime DESC",$clause,$start,$limit);
--- 170,177 ----
  			$t["forumname"] = $foruminfo["forumname"];
  			$db->queryOne("select count(pkey) from forumPosts where 1=1 and $clause");
! 			$threadcount = $db->record[0];
  $db->query("select * from forumPosts where 1=1 and $clause order by stamptime DESC limit $start,$limit");
! while($db->nextRecord()) {
! 	$list[] = $db->record;
  }
  //			$list = $post->_getAll("stamptime DESC",$clause,$start,$limit);
***************
*** 381,387 ****
  			//update the forum info
  			$db->queryOne("select count(pkey) from forumPosts where fid='".$post->fid."'");
! 			$count = $db->Record[0];		
  			$db->queryOne("select max(recentpost) from forumPosts where fid='".$post->fid."'");
! 			$time = $db->Record[0];		
  			$db->query("update forums set validposts = $count, recentpost=$time where fid='".$post->fid."'");

--- 381,387 ----
  			//update the forum info
  			$db->queryOne("select count(pkey) from forumPosts where fid='".$post->fid."'");
! 			$count = $db->record[0];		
  			$db->queryOne("select max(recentpost) from forumPosts where fid='".$post->fid."'");
! 			$time = $db->record[0];		
  			$db->query("update forums set validposts = $count, recentpost=$time where fid='".$post->fid."'");

***************
*** 414,419 ****
  		if ($post->status == 'y') {
  			$db->query("select forumPrefs.username, lcUsers.email from forumPrefs LEFT JOIN lcUsers on lcUsers.username = forumPrefs.username where pref_key = 'sendEmail' and pref_val = '".$forumID."'");
! 			while ($db->next_record() ) {
! 				mail($db->Record[1],$subject,$body, "From: ".$this->_FromEmail."\nReply-To: ".$this->_ReplyTo."\nReturn-Path: ".$this->_ReturnPath."\n");
  			}
  		}
--- 414,419 ----
  		if ($post->status == 'y') {
  			$db->query("select forumPrefs.username, lcUsers.email from forumPrefs LEFT JOIN lcUsers on lcUsers.username = forumPrefs.username where pref_key = 'sendEmail' and pref_val = '".$forumID."'");
! 			while ($db->nextRecord() ) {
! 				mail($db->record[1],$subject,$body, "From: ".$this->_FromEmail."\nReply-To: ".$this->_ReplyTo."\nReturn-Path: ".$this->_ReturnPath."\n");
  			}
  		}
***************
*** 456,460 ****

  		$db->queryOne("select parent from forumPosts where pkey=$pkey");
! 		$parent = $db->Record[0]; // save for later on
  		/*****  End Replies ****/

--- 456,460 ----

  		$db->queryOne("select parent from forumPosts where pkey=$pkey");
! 		$parent = $db->record[0]; // save for later on
  		/*****  End Replies ****/

***************
*** 469,473 ****
  				{
  					$db->queryOne("select count(pkey) from forumPosts where parent=$pkey");
! 					$count = intval($db->Record[0]);
  					$db->query("update forumPosts set replies = $count where pkey=$parent");
  				}
--- 469,473 ----
  				{
  					$db->queryOne("select count(pkey) from forumPosts where parent=$pkey");
! 					$count = intval($db->record[0]);
  					$db->query("update forumPosts set replies = $count where pkey=$parent");
  				}

Index: teacherclass.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/teacherclass.lcp,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** teacherclass.lcp	8 Apr 2007 02:05:59 -0000	1.13
--- teacherclass.lcp	8 Oct 2007 14:21:07 -0000	1.14
***************
*** 364,371 ****
  		$sql_string = 'SELECT id_class_assignments FROM class_assignments WHERE id_classes='.$id_classes;
  		$db->query($sql_string);
! 		while ($db->next_record()) {
! 			$sql[] = 'DELETE FROM class_assignments_grades WHERE id_class_assignments='.$db->Record['id_class_assignments'];
! 			$sql[] = 'DELETE FROM class_assignments_turnin WHERE id_class_assignments='.$db->Record['id_class_assignments'];
! 			$sql[] = 'DELETE FROM class_assignments_link WHERE id_class_assignments='.$db->Record['id_class_assignments'];
  		}
  		$sql[] = 'DELETE FROM class_assignments WHERE id_classes='.$id_classes;
--- 364,371 ----
  		$sql_string = 'SELECT id_class_assignments FROM class_assignments WHERE id_classes='.$id_classes;
  		$db->query($sql_string);
! 		while ($db->nextRecord()) {
! 			$sql[] = 'DELETE FROM class_assignments_grades WHERE id_class_assignments='.$db->record['id_class_assignments'];
! 			$sql[] = 'DELETE FROM class_assignments_turnin WHERE id_class_assignments='.$db->record['id_class_assignments'];
! 			$sql[] = 'DELETE FROM class_assignments_link WHERE id_class_assignments='.$db->record['id_class_assignments'];
  		}
  		$sql[] = 'DELETE FROM class_assignments WHERE id_classes='.$id_classes;
***************
*** 380,386 ****
  		$sql_string = 'SELECT id_class_lessons FROM class_lessons WHERE id_classes='.$id_classes;
  		$db->query($sql_string);
! 		while ($db->next_record()) {
! 			$sql[] = 'DELETE FROM class_lesson_links WHERE id_class_lessons='.$db->Record['id_class_lessons'];
! 			$sql[] = 'DELETE FROM class_lesson_objectives WHERE id_class_lesson='.$db->Record['id_class_lessons'];
  		}
  		$sql[] = 'DELETE FROM class_lessons WHERE id_classes='.$id_classes;
--- 380,386 ----
  		$sql_string = 'SELECT id_class_lessons FROM class_lessons WHERE id_classes='.$id_classes;
  		$db->query($sql_string);
! 		while ($db->nextRecord()) {
! 			$sql[] = 'DELETE FROM class_lesson_links WHERE id_class_lessons='.$db->record['id_class_lessons'];
! 			$sql[] = 'DELETE FROM class_lesson_objectives WHERE id_class_lesson='.$db->record['id_class_lessons'];
  		}
  		$sql[] = 'DELETE FROM class_lessons WHERE id_classes='.$id_classes;
***************
*** 415,420 ****
  		$sql_string = 'SELECT assessment_id FROM assessment WHERE class_id='.$id_classes;
  		$db->query($sql_string);
! 		while ($db->next_record()) {
! 			$sql[] = 'DELETE FROM assessment_question WHERE assessment_id='.$db->Record['assessment_id'];
  		}

--- 415,420 ----
  		$sql_string = 'SELECT assessment_id FROM assessment WHERE class_id='.$id_classes;
  		$db->query($sql_string);
! 		while ($db->nextRecord()) {
! 			$sql[] = 'DELETE FROM assessment_question WHERE assessment_id='.$db->record['assessment_id'];
  		}

***************
*** 433,438 ****
  		$db->query($sql_string);

! 		while ($db->next_record()) {
! 			$sql[] = 'DELETE FROM classdoclib_Files WHERE folder='.$db->Record['pkey'];
  		}

--- 433,438 ----
  		$db->query($sql_string);

! 		while ($db->nextRecord()) {
! 			$sql[] = 'DELETE FROM classdoclib_Files WHERE folder='.$db->record['pkey'];
  		}

Index: semestercopy.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/semestercopy.lcp,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** semestercopy.lcp	18 Nov 2006 00:09:34 -0000	1.16
--- semestercopy.lcp	8 Oct 2007 14:21:07 -0000	1.17
***************
*** 57,64 ****
  		$db->query($sql);
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ($db->next_record()) {
! 		//	$t['selections'][$db->Record['id_classes']] = $db->Record;
! 			$class[$db->Record['id_classes']] = $db->Record['courseFamilyNumber']." ".
! 			htmlentities($db->Record['courseName'],ENT_QUOTES)." (".$db->Record['semesterId'].")";
  		}
                  $t['fromoptions'] = makeOptions($class, $u->activeClassTaught->id_classes);
--- 57,64 ----
  		$db->query($sql);
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ($db->nextRecord()) {
! 		//	$t['selections'][$db->record['id_classes']] = $db->record;
! 			$class[$db->record['id_classes']] = $db->record['courseFamilyNumber']." ".
! 			htmlentities($db->record['courseName'],ENT_QUOTES)." (".$db->record['semesterId'].")";
  		}
                  $t['fromoptions'] = makeOptions($class, $u->activeClassTaught->id_classes);
***************
*** 76,83 ****
                  $db->query($sql);
                  $db->RESULT_TYPE = MYSQL_ASSOC;
!                 while ($db->next_record()) {
!                 //      $t['selections'][$db->Record['id_classes']] = $db->Record;
!                         $class[$db->Record['id_classes']] = $db->Record['courseFamilyNumber']." ".
!                         htmlentities($db->Record['courseName'],ENT_QUOTES)." (".$db->Record['semesterId'].")";
                  }
                  $t['tooptions'] = makeOptions($class);
--- 76,83 ----
                  $db->query($sql);
                  $db->RESULT_TYPE = MYSQL_ASSOC;
!                 while ($db->nextRecord()) {
!                 //      $t['selections'][$db->record['id_classes']] = $db->record;
!                         $class[$db->record['id_classes']] = $db->record['courseFamilyNumber']." ".
!                         htmlentities($db->record['courseName'],ENT_QUOTES)." (".$db->record['semesterId'].")";
                  }
                  $t['tooptions'] = makeOptions($class);
***************
*** 118,129 ****
  		$db->query($sql);

! 		while ($db->next_record()) {
! 			if ($id_classes == $db->Record['id_classes']) {
! 				$db->Record['id_classes_update'] = $db->Record['id_classes'];
! 				$t['selected'] = $db->Record;
  				$fl_ismyclass = true;
  			}

! 			$t['selections'][$db->Record['id_classes']] = $db->Record;

  		}
--- 118,129 ----
  		$db->query($sql);

! 		while ($db->nextRecord()) {
! 			if ($id_classes == $db->record['id_classes']) {
! 				$db->record['id_classes_update'] = $db->record['id_classes'];
! 				$t['selected'] = $db->record;
  				$fl_ismyclass = true;
  			}

! 			$t['selections'][$db->record['id_classes']] = $db->record;

  		}
***************
*** 530,534 ****
  		$db->queryOne($sql);

! 		return $db->Record;
  	}
  }
--- 530,534 ----
  		$db->queryOne($sql);

! 		return $db->record;
  	}
  }

Index: studentPresentation.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/studentPresentation.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** studentPresentation.lcp	18 Nov 2006 00:09:34 -0000	1.3
--- studentPresentation.lcp	8 Oct 2007 14:21:07 -0000	1.4
***************
*** 75,79 ****

  		$db->queryOne("select firstname,lastname from profile where username='{$pres->author}'");
! 		$name = $db->Record;
  		$t['author'] = $name['firstname'].' '.$name['lastname'];
  		$t['createdOn'] = $pres->createdOn;
--- 75,79 ----

  		$db->queryOne("select firstname,lastname from profile where username='{$pres->author}'");
! 		$name = $db->record;
  		$t['author'] = $name['firstname'].' '.$name['lastname'];
  		$t['createdOn'] = $pres->createdOn;

Index: seminars.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/seminars.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** seminars.lcp	15 Aug 2004 20:30:40 -0000	1.2
--- seminars.lcp	8 Oct 2007 14:21:07 -0000	1.3
***************
*** 80,84 ****
  			$db->queryOne($sql);
  			# update the count on the seminar
! 			$obj->numSeminar = $db->Record['count'] + 1;
  			$obj->idClasses = $u->activeClassTaught->id_classes;
  			if ($obj->numSeminar == 5)
--- 80,84 ----
  			$db->queryOne($sql);
  			# update the count on the seminar
! 			$obj->numSeminar = $db->record['count'] + 1;
  			$obj->idClasses = $u->activeClassTaught->id_classes;
  			if ($obj->numSeminar == 5)
***************
*** 156,160 ****
  			$db->queryOne($sql);
  			# update the count on the seminar
! 			$obj->numSeminar = $db->Record['count'] + 1;
  			$obj->idClasses = $u->activeClassTaught->id_classes;
  			if ($obj->numSeminar == 5)
--- 156,160 ----
  			$db->queryOne($sql);
  			# update the count on the seminar
! 			$obj->numSeminar = $db->record['count'] + 1;
  			$obj->idClasses = $u->activeClassTaught->id_classes;
  			if ($obj->numSeminar == 5)

Index: adjustLessonDates.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/adjustLessonDates.lcp,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** adjustLessonDates.lcp	29 Nov 2006 03:31:21 -0000	1.1
--- adjustLessonDates.lcp	8 Oct 2007 14:21:07 -0000	1.2
***************
*** 162,169 ****
  				$lc->postvars['deactiveOn'][$row]['year']);

! 			if ( $activeOnStamp != $db->Record['date_available'] 
! 				|| $deactiveOnStamp != $db->Record['date_unavailable'] ) {
! 				$updates[$db->Record['id_class_lessons']]['date_available'] = $activeOnStamp;
! 				$updates[$db->Record['id_class_lessons']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
--- 162,169 ----
  				$lc->postvars['deactiveOn'][$row]['year']);

! 			if ( $activeOnStamp != $db->record['date_available'] 
! 				|| $deactiveOnStamp != $db->record['date_unavailable'] ) {
! 				$updates[$db->record['id_class_lessons']]['date_available'] = $activeOnStamp;
! 				$updates[$db->record['id_class_lessons']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
***************
*** 208,215 ****
  				$lc->postvars['dateUnavailable'][$row]['year']);

! 			if ( $activeOnStamp != $db->Record['date_available'] 
! 				|| $deactiveOnStamp != $db->Record['date_unavailable'] ) {
! 				$updates[$db->Record['assessment_id']]['date_available'] = $activeOnStamp;
! 				$updates[$db->Record['assessment_id']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
--- 208,215 ----
  				$lc->postvars['dateUnavailable'][$row]['year']);

! 			if ( $activeOnStamp != $db->record['date_available'] 
! 				|| $deactiveOnStamp != $db->record['date_unavailable'] ) {
! 				$updates[$db->record['assessment_id']]['date_available'] = $activeOnStamp;
! 				$updates[$db->record['assessment_id']]['date_unavailable'] = $deactiveOnStamp;
  			}
  			++$row;
***************
*** 277,286 ****

! 			if ( $activeStamp != $db->Record['activeDate'] 
! 				|| $dueDateStamp != $db->Record['dueDate'] 
! 				|| $dateNoAcceptStamp != $db->Record['dateNoAccept'] ) {
! 				$updates[$db->Record['id_class_assignments']]['activeDate'] = $activeStamp;
! 				$updates[$db->Record['id_class_assignments']]['dueDate'] = $dueDateStamp;
! 				$updates[$db->Record['id_class_assignments']]['dateNoAccept'] = $dateNoAcceptStamp;
  			}
  			++$row;
--- 277,286 ----

! 			if ( $activeStamp != $db->record['activeDate'] 
! 				|| $dueDateStamp != $db->record['dueDate'] 
! 				|| $dateNoAcceptStamp != $db->record['dateNoAccept'] ) {
! 				$updates[$db->record['id_class_assignments']]['activeDate'] = $activeStamp;
! 				$updates[$db->record['id_class_assignments']]['dueDate'] = $dueDateStamp;
! 				$updates[$db->record['id_class_assignments']]['dateNoAccept'] = $dateNoAcceptStamp;
  			}
  			++$row;

Index: textbooks.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/textbooks.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** textbooks.lcp	15 Aug 2004 20:30:40 -0000	1.2
--- textbooks.lcp	8 Oct 2007 14:21:07 -0000	1.3
***************
*** 87,91 ****
  		} else {
  			$db->queryOne("select noTextbooks from textbook where id_classes='{$u->activeClassTaught->id_classes}'");
! 			$t['noTextbooks'] = $db->Record['noTextbooks'];
  		}

--- 87,91 ----
  		} else {
  			$db->queryOne("select noTextbooks from textbook where id_classes='{$u->activeClassTaught->id_classes}'");
! 			$t['noTextbooks'] = $db->record['noTextbooks'];
  		}

Index: links.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/links.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** links.lcp	16 Dec 2006 01:28:23 -0000	1.3
--- links.lcp	8 Oct 2007 14:21:07 -0000	1.4
***************
*** 40,44 ****
  		$db->query("update class_links set hits=hits+1 where lid='$link'");
  		$db->queryOne("select url from class_links where pkey='$link'");
! 		header ("Location: ".$db->Record['url']."");
  	}

--- 40,44 ----
  		$db->query("update class_links set hits=hits+1 where lid='$link'");
  		$db->queryOne("select url from class_links where pkey='$link'");
! 		header ("Location: ".$db->record['url']."");
  	}

***************
*** 46,52 ****
  		$sql = "select * from class_link_categories where parentPkey='$pkey'";
  		$db->query($sql);
! 		while($db->next_record())
  		{
! 			$x[$db->Record['pkey']][] = $db->Record;
  		}	
  		return $x;
--- 46,52 ----
  		$sql = "select * from class_link_categories where parentPkey='$pkey'";
  		$db->query($sql);
! 		while($db->nextRecord())
  		{
! 			$x[$db->record['pkey']][] = $db->record;
  		}	
  		return $x;

Index: studentProfile.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/studentProfile.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** studentProfile.lcp	18 Nov 2006 00:09:34 -0000	1.3
--- studentProfile.lcp	8 Oct 2007 14:21:07 -0000	1.4
***************
*** 54,67 ****
  		$tbl = array();

! 		while ($db->next_record()) {

! 			$photo = is_file(IMAGES_PATH.'photos/'.$db->Record['photo'])
! 				? 'photos/'.$db->Record['photo']
  				: 'noimage.png';

! 			$tbl[] = '<a href="'.appurl('users/view/'.$db->Record['username']).'">'
  				.'<img border="0" src="'.IMAGES_URL.$photo.'" alt="'
! 				.$db->Record['lastname'].', '.$db->Record['firstname'].'" /><br/>'
! 				.$db->Record['lastname'].', '.$db->Record['firstname'].'</a>';
  		}

--- 54,67 ----
  		$tbl = array();

! 		while ($db->nextRecord()) {

! 			$photo = is_file(IMAGES_PATH.'photos/'.$db->record['photo'])
! 				? 'photos/'.$db->record['photo']
  				: 'noimage.png';

! 			$tbl[] = '<a href="'.appurl('users/view/'.$db->record['username']).'">'
  				.'<img border="0" src="'.IMAGES_URL.$photo.'" alt="'
! 				.$db->record['lastname'].', '.$db->record['firstname'].'" /><br/>'
! 				.$db->record['lastname'].', '.$db->record['firstname'].'</a>';
  		}

Index: cal.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/cal.lcp,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** cal.lcp	29 Nov 2006 03:31:21 -0000	1.5
--- cal.lcp	8 Oct 2007 14:21:07 -0000	1.6
***************
*** 351,355 ****
  	function viewRun($db,&$u,&$lc,&$t) {
  		$db->queryOne("select * from _activities where pkey='".addslashes($lc->getvars['pkey'])."'");
! 		$t = array_merge($t,$db->Record);
  		$this->activityRun($db,$u,$lc,$t);
  	}
--- 351,355 ----
  	function viewRun($db,&$u,&$lc,&$t) {
  		$db->queryOne("select * from _activities where pkey='".addslashes($lc->getvars['pkey'])."'");
! 		$t = array_merge($t,$db->record);
  		$this->activityRun($db,$u,$lc,$t);
  	}
***************
*** 447,452 ****
  		*/
  		$db->query("select gid,groupname from lcGroups order by groupname");
! 		while($db->next_record()) {
! 			$t['groups'][$db->Record[0]] = $db->Record[1];
  		}

--- 447,452 ----
  		*/
  		$db->query("select gid,groupname from lcGroups order by groupname");
! 		while($db->nextRecord()) {
! 			$t['groups'][$db->record[0]] = $db->record[1];
  		}

Index: classSetup.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/classSetup.lcp,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** classSetup.lcp	3 Oct 2007 02:09:00 -0000	1.6
--- classSetup.lcp	8 Oct 2007 14:21:07 -0000	1.7
***************
*** 51,56 ****
  		id_classes='".$u->activeClassTaught->id_classes."'";
  		$db->queryOne($sql);
! 		$current_id_class_resource = $db->Record['id_class_resource'];
! 		$current_id_class_orientation= $db->Record['id_class_orientation'];
  */

--- 51,56 ----
  		id_classes='".$u->activeClassTaught->id_classes."'";
  		$db->queryOne($sql);
! 		$current_id_class_resource = $db->record['id_class_resource'];
! 		$current_id_class_orientation= $db->record['id_class_orientation'];
  */

***************
*** 61,67 ****
  				BY txTitle";
  		$db->query($sql);
! 		while($db->next_record() )
  		{
! 			$options[$db->Record['id_class_lesson_content']] = $db->Record['txTitle']; 	
  		}

--- 61,67 ----
  				BY txTitle";
  		$db->query($sql);
! 		while($db->nextRecord() )
  		{
! 			$options[$db->record['id_class_lesson_content']] = $db->record['txTitle']; 	
  		}

Index: ettendance.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/ettendance.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** ettendance.lcp	18 Nov 2006 00:09:34 -0000	1.3
--- ettendance.lcp	8 Oct 2007 14:21:07 -0000	1.4
***************
*** 58,62 ****
  		$db->queryOne("select sectionNumbers from classes where id_classes = '$id_class' and facultyId='".$u->username."'");

! 		if ($db->Record[0]=='') { // we have nothing
  						// might not be our class, or bad data
  			$this->presentor='errorMessage';
--- 58,62 ----
  		$db->queryOne("select sectionNumbers from classes where id_classes = '$id_class' and facultyId='".$u->username."'");

! 		if ($db->record[0]=='') { // we have nothing
  						// might not be our class, or bad data
  			$this->presentor='errorMessage';
***************
*** 65,69 ****
  		}

! 		$numbers = explode("\n",$db->Record[0]);
  		$id_semester = $u->activeClassTaught->id_semesters;

--- 65,69 ----
  		}

! 		$numbers = explode("\n",$db->record[0]);
  		$id_semester = $u->activeClassTaught->id_semesters;

***************
*** 71,81 ****

  		$db->query($sql);
! 		while($db->next_record()) { 
! 			$student[$db->Record['id_student']] = $db->Record['dateWithdrawn'];
  		}	

  		$db->queryOne("Select * from semesters where id_semesters='$id_semester'");
! 		$start = strtotime($db->Record['dateStart']);
! 		$end = strtotime($db->Record['dateEnd']);

  // we'll only show logins this semester, not how
--- 71,81 ----

  		$db->query($sql);
! 		while($db->nextRecord()) { 
! 			$student[$db->record['id_student']] = $db->record['dateWithdrawn'];
  		}	

  		$db->queryOne("Select * from semesters where id_semesters='$id_semester'");
! 		$start = strtotime($db->record['dateStart']);
! 		$end = strtotime($db->record['dateEnd']);

  // we'll only show logins this semester, not how
***************
*** 85,89 ****
  // select count of good logins this semester
  			$db->queryOne("select count(*) from lc_users_login_attempt where login_attempt>=$start and login_attempt<=$end and username='$k' and login_status=1");
! 			$studentCount[$k] = $db->Record[0];
  		}

--- 85,89 ----
  // select count of good logins this semester
  			$db->queryOne("select count(*) from lc_users_login_attempt where login_attempt>=$start and login_attempt<=$end and username='$k' and login_status=1");
! 			$studentCount[$k] = $db->record[0];
  		}

Index: lessonWebliography.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/lessonWebliography.lcp,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** lessonWebliography.lcp	18 Nov 2006 00:09:34 -0000	1.5
--- lessonWebliography.lcp	8 Oct 2007 14:21:07 -0000	1.6
***************
*** 51,56 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;

! 		while ($db->next_record())
! 		{	$cats[] = $db->Record;
  		}

--- 51,56 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;

! 		while ($db->nextRecord())
! 		{	$cats[] = $db->record;
  		}

***************
*** 100,105 ****
  		$classmgr_itemsToTitles = array();

! 		while ($db->next_record()) {
! 			$classmgr_itemsToTitles[$db->Record['id_class_links']][] = $db->Record['title'];
  		}
  		//collapse the double array into one string
--- 100,105 ----
  		$classmgr_itemsToTitles = array();

! 		while ($db->nextRecord()) {
! 			$classmgr_itemsToTitles[$db->record['id_class_links']][] = $db->record['title'];
  		}
  		//collapse the double array into one string

Index: exportContent.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/exportContent.lcp,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** exportContent.lcp	6 Oct 2007 21:59:50 -0000	1.19
--- exportContent.lcp	8 Oct 2007 14:21:07 -0000	1.20
***************
*** 110,120 ****
  		/*
  		$classroom_node[] = new xml_node('CLASSROOM', 
! 						array(	'ID'=>$db->Record['id_classes'], 
! 								'CLASSTYPE'=>$db->Record['classType'],
! 								'ID_SEMESTERS'=>$db->Record['id_semesters'],
! 								'STYLESHEET'=>$db->Record['stylesheet'], 
! 								'FACULTYID'=>$db->Record['facultyId'],
! 								'SECTIONNUMBERS'=>$db->Record['sectionNumbers'],
! 								'NOEXAM'=>$db->Record['noexam']
  							 )
  						);
--- 110,120 ----
  		/*
  		$classroom_node[] = new xml_node('CLASSROOM', 
! 						array(	'ID'=>$db->record['id_classes'], 
! 								'CLASSTYPE'=>$db->record['classType'],
! 								'ID_SEMESTERS'=>$db->record['id_semesters'],
! 								'STYLESHEET'=>$db->record['stylesheet'], 
! 								'FACULTYID'=>$db->record['facultyId'],
! 								'SECTIONNUMBERS'=>$db->record['sectionNumbers'],
! 								'NOEXAM'=>$db->record['noexam']
  							 )
  						);
***************
*** 122,126 ****
  		 */
  		//get the semester start dates
! 		$this->semesterId = $db->Record['id_semesters'];
  		$db->query("SELECT * FROM semesters WHERE id_semesters = ".$this->semesterId);
  		$db->nextRecord();
--- 122,126 ----
  		 */
  		//get the semester start dates
! 		$this->semesterId = $db->record['id_semesters'];
  		$db->query("SELECT * FROM semesters WHERE id_semesters = ".$this->semesterId);
  		$db->nextRecord();
***************
*** 900,904 ****
  		$db2->RESULT_TYPE = MYSQL_ASSOC;

! 		while ($db->next_record())
  		{	$xml_sub_child = null;
  			$xml_links = null;
--- 900,904 ----
  		$db2->RESULT_TYPE = MYSQL_ASSOC;

! 		while ($db->nextRecord())
  		{	$xml_sub_child = null;
  			$xml_links = null;
***************
*** 911,919 ****
  			SELECT * FROM 
  			class_lesson_links
! 			WHERE id_class_lessons='. $db->Record['id_class_lessons'];

  			$db2->query($sql2);
! 			while ($db2->next_record())
! 			{	$xml_links[] = new xml_node('id_class_links',null, null, $db2->Record['id_class_links']);
  			}
  			$xml_sub_sub_child[] = new xml_node('LINKS',null, $xml_links);
--- 911,919 ----
  			SELECT * FROM 
  			class_lesson_links
! 			WHERE id_class_lessons='. $db->record['id_class_lessons'];

  			$db2->query($sql2);
! 			while ($db2->nextRecord())
! 			{	$xml_links[] = new xml_node('id_class_links',null, null, $db2->record['id_class_links']);
  			}
  			$xml_sub_sub_child[] = new xml_node('LINKS',null, $xml_links);
***************
*** 922,930 ****
  			SELECT * FROM 
  			class_lesson_objectives
! 			WHERE id_class_lesson='. $db->Record['id_class_lessons'];

  			$db2->query($sql2);
! 			while ($db2->next_record())
! 			{	$xml_objectives[] = new xml_node('id_class_objectives',null, null, $db2->Record['id_class_objectives']);
  			}
  			$xml_sub_sub_child[] = new xml_node('OBJECTIVES',null,$xml_objectives);
--- 922,930 ----
  			SELECT * FROM 
  			class_lesson_objectives
! 			WHERE id_class_lesson='. $db->record['id_class_lessons'];

  			$db2->query($sql2);
! 			while ($db2->nextRecord())
! 			{	$xml_objectives[] = new xml_node('id_class_objectives',null, null, $db2->record['id_class_objectives']);
  			}
  			$xml_sub_sub_child[] = new xml_node('OBJECTIVES',null,$xml_objectives);
***************
*** 934,943 ****
  			SELECT * FROM 
  			class_assignments_link
! 			WHERE id_class_lessons='. $db->Record['id_class_lessons'];

  die('lskdjfas');
  			$db2->query($sql2);
! 			while ($db2->next_record())
! 			{	$xml_assignments[] = new xml_node('id_class_assignments',null, null, $db2->Record['id_class_assignments']);
  			}
  			$xml_sub_sub_child[] = new xml_node('ASSIGNMENTS',null,$xml_assignments);
--- 934,943 ----
  			SELECT * FROM 
  			class_assignments_link
! 			WHERE id_class_lessons='. $db->record['id_class_lessons'];

  die('lskdjfas');
  			$db2->query($sql2);
! 			while ($db2->nextRecord())
! 			{	$xml_assignments[] = new xml_node('id_class_assignments',null, null, $db2->record['id_class_assignments']);
  			}
  			$xml_sub_sub_child[] = new xml_node('ASSIGNMENTS',null,$xml_assignments);
***************
*** 950,962 ****
  			$xml_sub_child[] = new xml_node('MAPPINGS',null, $xml_sub_sub_child);

! 			$xml_sub_child[] = new xml_node('createdOn',null, null, $db->Record['createdOn']);
! 			$xml_sub_child[] = new xml_node('title', array('BASE64'=>'1'), null, $db->Record['title']);
! 			$xml_sub_child[] = new xml_node('description', array('BASE64'=>'1'), null, $db->Record['description']);
! 			$xml_sub_child[] = new xml_node('activeOn', null, null, $db->Record['activeOn']);
! 			$xml_sub_child[] = new xml_node('inactiveOn', null, null, $db->Record['inactiveOn']);
! 			$xml_sub_child[] = new xml_node('checkList', array('BASE64'=>'1'), null, $db->Record['checkList']);

  			$xml_child_node[] =new xml_node('ITEM', 
! 									array(	'id_class_lessons'=>$db->Record['id_class_lessons']
  									 	 ), $xml_sub_child
  									);
--- 950,962 ----
  			$xml_sub_child[] = new xml_node('MAPPINGS',null, $xml_sub_sub_child);

! 			$xml_sub_child[] = new xml_node('createdOn',null, null, $db->record['createdOn']);
! 			$xml_sub_child[] = new xml_node('title', array('BASE64'=>'1'), null, $db->record['title']);
! 			$xml_sub_child[] = new xml_node('description', array('BASE64'=>'1'), null, $db->record['description']);
! 			$xml_sub_child[] = new xml_node('activeOn', null, null, $db->record['activeOn']);
! 			$xml_sub_child[] = new xml_node('inactiveOn', null, null, $db->record['inactiveOn']);
! 			$xml_sub_child[] = new xml_node('checkList', array('BASE64'=>'1'), null, $db->record['checkList']);

  			$xml_child_node[] =new xml_node('ITEM', 
! 									array(	'id_class_lessons'=>$db->record['id_class_lessons']
  									 	 ), $xml_sub_child
  									);

Index: contactStudents.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/contactStudents.lcp,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** contactStudents.lcp	15 Jan 2007 05:48:17 -0000	1.10
--- contactStudents.lcp	8 Oct 2007 14:21:07 -0000	1.11
***************
*** 61,66 ****
  		$db->query($sql);

! 		while ($db->next_record())
! 		{	$t['students'][$db->Record['username']] = '<input type="checkbox" name="student_'.$db->Record['username'].'" id="student_'.$db->Record['username'].'"><label for="student_'.$db->Record['username'].'"> '.$db->Record['lastname'].', '.$db->Record['firstname']. '</label>';
  		}

--- 61,66 ----
  		$db->query($sql);

! 		while ($db->nextRecord())
! 		{	$t['students'][$db->record['username']] = '<input type="checkbox" name="student_'.$db->record['username'].'" id="student_'.$db->record['username'].'"><label for="student_'.$db->record['username'].'"> '.$db->record['lastname'].', '.$db->record['firstname']. '</label>';
  		}

***************
*** 116,122 ****
  		$db->query($sql);

! 		while ($db->next_record())
! 		{	$t['students'][$db->Record['username']] = '<input type="checkbox" name="student_'.$db->Record['username'].'" id="student_'.$db->Record['username'].'"><label for="student_'.$db->Record['username'].'"> '.$db->Record['lastname'].', '.$db->Record['firstname']. '</label>';
! 			$my_students[$db->Record['username']] = $db->Record['email'];
  		}

--- 116,122 ----
  		$db->query($sql);

! 		while ($db->nextRecord())
! 		{	$t['students'][$db->record['username']] = '<input type="checkbox" name="student_'.$db->record['username'].'" id="student_'.$db->record['username'].'"><label for="student_'.$db->record['username'].'"> '.$db->record['lastname'].', '.$db->record['firstname']. '</label>';
! 			$my_students[$db->record['username']] = $db->record['email'];
  		}

Index: dataexchange.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/dataexchange.lcp,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** dataexchange.lcp	13 May 2007 04:22:38 -0000	1.5
--- dataexchange.lcp	8 Oct 2007 14:21:07 -0000	1.6
***************
*** 76,80 ****
  		$db->queryOne($sql);

! 		$t['filename'] = 'classroom_'.$db->Record['courseFamily']. $db->Record['courseNumber'].'_'.$db->Record['semesterId'].'.zip';

  		$this->presentor = 'htmlPresentation';
--- 76,80 ----
  		$db->queryOne($sql);

! 		$t['filename'] = 'classroom_'.$db->record['courseFamily']. $db->record['courseNumber'].'_'.$db->record['semesterId'].'.zip';

[...1303 lines suppressed...]
  									);
--- 1318,1335 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;

! 		while ($db->nextRecord())
  		{
  			$xml_sub_child = null;
! 			$xml_sub_child[] = new xml_node('id_class_gradebook_entries', null, null, $db->record['id_class_gradebook_entries']);
! 			$xml_sub_child[] = new xml_node('username', array('BASE64'=>'1'), null, $db->record['username']);
! 			$xml_sub_child[] = new xml_node('score', null, null, (($db->record['score'] == null) ? 'NULL' : $db->record['score']));

! 			$xml_sub_child[] = new xml_node('comments', array('BASE64'=>'1'), null, $db->record['comments']);

! 			$xml_sub_child[] = new xml_node('date_created', null, null, $db->record['date_created']);
! 			$xml_sub_child[] = new xml_node('date_modified', null, null, $db->record['date_modified']);

  			$xml_child_node[] =new xml_node('ITEM', 
! 									array(	'id_class_gradebook_val'=>$db->record['id_class_gradebook_val']											
  									 	 ), $xml_sub_child
  									);

Index: assignmentManage.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classmgr/assignmentManage.lcp,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** assignmentManage.lcp	4 Oct 2007 17:13:29 -0000	1.24
--- assignmentManage.lcp	8 Oct 2007 14:21:07 -0000	1.25
***************
*** 60,73 ****
  		$db->query($sql);

! 		while ($db->next_record())
  		{
  			$i++;
  			$daHasha = ''; // clobering
! 			$daHasha = md5($db->Record['displayname'].microtime().$i.$db->Record['folder']);

  			$sql = '
  			UPDATE classdoclib_Files
  			SET daHasha=\''.$daHasha.'\'
! 			WHERE pkey='.$db->Record['pkey'].'
  			';
  			$db_saver->query($sql);
--- 60,...

[truncated message content]