logicampus-cvs — SVN Commit Logs

[Logicampus-cvs] logicampus/src/logicreate/services/textbookmgr dup.lcp, 1.2, 1.3 estimates.lcp, 1.2, 1.3 main.lcp, 1.4, 1.5 viewestimates.lcp, 1.1.1.1, 1.2

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

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

Modified Files:
	dup.lcp estimates.lcp main.lcp viewestimates.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: viewestimates.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/textbookmgr/viewestimates.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** viewestimates.lcp	21 Nov 2003 23:14:14 -0000	1.1.1.1
--- viewestimates.lcp	8 Oct 2007 14:31:27 -0000	1.2
***************
*** 82,86 ****
  	function editRun(&$db,&$u,&$lc,&$t) {
  		$db->queryOne("select * from textbook_estimates_data where textbook_estimates_data_key=".(int)$lc->getvars['key']);
! 		$t['books'][] = $db->Record;
  		$t['key'] = $lc->getvars['key'];
  		$lc->templateName = "viewestimates_edit";
--- 82,86 ----
  	function editRun(&$db,&$u,&$lc,&$t) {
  		$db->queryOne("select * from textbook_estimates_data where textbook_estimates_data_key=".(int)$lc->getvars['key']);
! 		$t['books'][] = $db->record;
  		$t['key'] = $lc->getvars['key'];
  		$lc->templateName = "viewestimates_edit";
***************
*** 104,109 ****
  		
  		//$db->query("select * from textbook_estimates_data where textbook_estimates_key=".(int)$lc->getvars['key'] ." order by courseFamily, courseNumber");
! 		while($db->next_record()) {
! 			$t['books'][$db->Record['textbook_estimates_data_key']] = $db->Record;
  		}
  		// oops - mgk - 11/12/03 - forgot 'required' - look it up
--- 104,109 ----
  		
  		//$db->query("select * from textbook_estimates_data where textbook_estimates_key=".(int)$lc->getvars['key'] ." order by courseFamily, courseNumber");
! 		while($db->nextRecord()) {
! 			$t['books'][$db->record['textbook_estimates_data_key']] = $db->record;
  		}
  		// oops - mgk - 11/12/03 - forgot 'required' - look it up
***************
*** 136,142 ****
  			and isbn='".$v['isbn']."' and title='".addslashes($v['title'])."' and 
  			author='".$v['author']."'");
! 			$v['required'] = $db->Record[0];
! 			$v['sectionNumbers'] = $db->Record['sectionNumbers'];
! 			$v['bundled_items'] = $db->Record['bundled_items'];
  			$t['books'][$k] = $v;
  
--- 136,142 ----
  			and isbn='".$v['isbn']."' and title='".addslashes($v['title'])."' and 
  			author='".$v['author']."'");
! 			$v['required'] = $db->record[0];
! 			$v['sectionNumbers'] = $db->record['sectionNumbers'];
! 			$v['bundled_items'] = $db->record['bundled_items'];
  			$t['books'][$k] = $v;
  

Index: dup.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/textbookmgr/dup.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** dup.lcp	12 May 2004 23:42:10 -0000	1.2
--- dup.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 43,48 ****
  		$lc->templateName = 'dup_main';
  		$db->query("select * from semesters");
! 		while($db->next_record()) { 
! 			$s[$db->Record[0]] = $db->Record[2]." - ".$db->Record[1];
  		}
  		$t['sem'] = makeOptions($s);
--- 43,48 ----
  		$lc->templateName = 'dup_main';
  		$db->query("select * from semesters");
! 		while($db->nextRecord()) { 
! 			$s[$db->record[0]] = $db->record[2]." - ".$db->record[1];
  		}
  		$t['sem'] = makeOptions($s);
***************
*** 70,74 ****
  
  		}
! 		$t['fromsemester'] = $db->Record[2]." - ".$db->Record[1];
  
  		$db->queryOne("select * from semesters where id_semesters=$to");
--- 70,74 ----
  
  		}
! 		$t['fromsemester'] = $db->record[2]." - ".$db->record[1];
  
  		$db->queryOne("select * from semesters where id_semesters=$to");
***************
*** 80,84 ****
  
  		}
! 		$t['tosemester'] = $db->Record[2]." - ".$db->Record[1];
  
  
--- 80,84 ----
  
  		}
! 		$t['tosemester'] = $db->record[2]." - ".$db->record[1];
  
  
***************
*** 90,125 ****
  		$sql ="select c.*, d.* from classes c, courses d where c.id_courses=d.id_courses and (c.id_semesters=$from) ORDER BY d.courseFamily, d.courseNumber";
  		$db->query($sql);
! 		while($db->next_record()){
! 			$num = $db->Record['courseFamilyNumber'];
! 			$name = $db->Record['courseName'];
! 			$first = $db->Record['firstname'];
! 			$last= $db->Record['lastname'];
! 			$id = $db->Record['facultyId'];
  			$id = ucwords(str_replace("."," ",$id));
  			$x = "$num - $name - $id";
! 			$arrayfrom[$db->Record['id_classes']] = $x;
  		}
  		$sql ="select c.*, d.* from classes c, courses d where c.id_courses=d.id_courses and (c.id_semesters=$to) ORDER BY d.courseFamily, d.courseNumber";
  		$db->query($sql);
  		if (strpos($button,"single")>0) { // copying a single to potential multiples - no restriction
! 			while($db->next_record()){
! 				$num = $db->Record['courseFamilyNumber'];
! 				$name = $db->Record['courseName'];
! 				$id = $db->Record['facultyId'];
  				$id = ucwords(str_replace("."," ",$id));
! 				$first = $db->Record['firstname'];
! 				$last= $db->Record['lastname'];
  				$x = "$num - $name - $id";
! 				$arrayto[$db->Record['id_classes']] = $x;
  			}
  		} else { // copying 'all' so we should only show classes that are the same both times
! 			while($db->next_record()){
! 				if ($arrayfrom[$db->Record[1]]!='') {
! 					$num = $db->Record['courseFamilyNumber'];
! 					$name = $db->Record['courseName'];
! 					$first = $db->Record['firstname'];
! 					$last= $db->Record['lastname'];
! 					$x = $db->Record['id_classes']." "."$num - $name - $first $last";
! 					$arrayto[$db->Record['id_classes']] = $x;
  				}
  			}
--- 90,125 ----
  		$sql ="select c.*, d.* from classes c, courses d where c.id_courses=d.id_courses and (c.id_semesters=$from) ORDER BY d.courseFamily, d.courseNumber";
  		$db->query($sql);
! 		while($db->nextRecord()){
! 			$num = $db->record['courseFamilyNumber'];
! 			$name = $db->record['courseName'];
! 			$first = $db->record['firstname'];
! 			$last= $db->record['lastname'];
! 			$id = $db->record['facultyId'];
  			$id = ucwords(str_replace("."," ",$id));
  			$x = "$num - $name - $id";
! 			$arrayfrom[$db->record['id_classes']] = $x;
  		}
  		$sql ="select c.*, d.* from classes c, courses d where c.id_courses=d.id_courses and (c.id_semesters=$to) ORDER BY d.courseFamily, d.courseNumber";
  		$db->query($sql);
  		if (strpos($button,"single")>0) { // copying a single to potential multiples - no restriction
! 			while($db->nextRecord()){
! 				$num = $db->record['courseFamilyNumber'];
! 				$name = $db->record['courseName'];
! 				$id = $db->record['facultyId'];
  				$id = ucwords(str_replace("."," ",$id));
! 				$first = $db->record['firstname'];
! 				$last= $db->record['lastname'];
  				$x = "$num - $name - $id";
! 				$arrayto[$db->record['id_classes']] = $x;
  			}
  		} else { // copying 'all' so we should only show classes that are the same both times
! 			while($db->nextRecord()){
! 				if ($arrayfrom[$db->record[1]]!='') {
! 					$num = $db->record['courseFamilyNumber'];
! 					$name = $db->record['courseName'];
! 					$first = $db->record['firstname'];
! 					$last= $db->record['lastname'];
! 					$x = $db->record['id_classes']." "."$num - $name - $first $last";
! 					$arrayto[$db->record['id_classes']] = $x;
  				}
  			}

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/textbookmgr/main.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** main.lcp	18 Nov 2006 00:09:35 -0000	1.4
--- main.lcp	8 Oct 2007 14:31:27 -0000	1.5
***************
*** 171,177 ****
  		$db->queryOne($sql);
  		
! 		$this->sectionTitle .= ' - '. $db->Record['courseName'].'('.$db->Record['courseFamily'].$db->Record['courseNumber'].')';
  
! 		$t['facultyId'] = $db->Record['facultyId'];			
  
  	}
--- 171,177 ----
  		$db->queryOne($sql);
  		
! 		$this->sectionTitle .= ' - '. $db->record['courseName'].'('.$db->record['courseFamily'].$db->record['courseNumber'].')';
  
! 		$t['facultyId'] = $db->record['facultyId'];			
  
  	}
***************
*** 190,196 ****
  			$db->queryOne($sql);
  			$this->sectionTitle = 'Adding Class Material ';
! 			$this->sectionTitle .= ' - '. $db->Record['courseName'].'('.$db->Record['courseFamily'].$db->Record['courseNumber'].')';
  
! 			$t['facultyId'] = $db->Record['facultyId'];		
  		} else {
  			$t['message'] = '<h3>Error</h3>Only text book admins or adminstrators can add books to the system.';
--- 190,196 ----
  			$db->queryOne($sql);
  			$this->sectionTitle = 'Adding Class Material ';
! 			$this->sectionTitle .= ' - '. $db->record['courseName'].'('.$db->record['courseFamily'].$db->record['courseNumber'].')';
  
! 			$t['facultyId'] = $db->record['facultyId'];		
  		} else {
  			$t['message'] = '<h3>Error</h3>Only text book admins or adminstrators can add books to the system.';
***************
*** 259,263 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		if (is_array($db->Record))
  		{
  			$sql = '
--- 259,263 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		if (is_array($db->record))
  		{
  			$sql = '
***************
*** 266,276 ****
  			id_textbook_classes='.$id_textbook_classes.',
  			textbook_estimates_key='.$lc->postvars['estimationlist'].',
! 			instructor=\''.$db->Record['facultyId'].'\',
  			bundled=\''.(int)$lc->postvars['bundled'].'\',
  			isbn=\''.$lc->postvars['isbn'].'\',
  			edition=\''.$lc->postvars['edition'].'\',
  			title=\''.addslashes($lc->postvars['title']).'\',
! 			courseFamily=\''.$db->Record['courseFamily'].'\',
! 			courseNumber=\''.$db->Record['courseNumber'].'\',
  			author=\''.addslashes($lc->postvars['author']).'\',
  			note=\''.addslashes($lc->postvars['note']).'\',
--- 266,276 ----
  			id_textbook_classes='.$id_textbook_classes.',
  			textbook_estimates_key='.$lc->postvars['estimationlist'].',
! 			instructor=\''.$db->record['facultyId'].'\',
  			bundled=\''.(int)$lc->postvars['bundled'].'\',
  			isbn=\''.$lc->postvars['isbn'].'\',
  			edition=\''.$lc->postvars['edition'].'\',
  			title=\''.addslashes($lc->postvars['title']).'\',
! 			courseFamily=\''.$db->record['courseFamily'].'\',
! 			courseNumber=\''.$db->record['courseNumber'].'\',
  			author=\''.addslashes($lc->postvars['author']).'\',
  			note=\''.addslashes($lc->postvars['note']).'\',
***************
*** 300,304 ****
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			$db->queryOne($sql);
! 			$semester_label = $db->Record['semesterLabel'];
  			
  			$sql = "SELECT a.courseFamily, a.courseNumber, a.facultyId, b.courseName FROM classes AS a INNER JOIN courses as b ON a.id_courses=b.id_courses WHERE a.id_classes='".$book->idClasses."'";
--- 300,304 ----
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			$db->queryOne($sql);
! 			$semester_label = $db->record['semesterLabel'];
  			
  			$sql = "SELECT a.courseFamily, a.courseNumber, a.facultyId, b.courseName FROM classes AS a INNER JOIN courses as b ON a.id_courses=b.id_courses WHERE a.id_classes='".$book->idClasses."'";
***************
*** 307,312 ****
  			include_once(SERVICE_PATH."pm/privmess.php");
  			$mess = new privMess();
! 			$mess->subject = $semester_label. ': Textbook status changed to '.getStatus($lc->postvars['status']).' on class '.$db->Record['courseFamily'].$db->Record['courseNumber'];
! 			$mess->message = $semester_label.': '.$u->profile->get('firstname').' '.$u->profile->get('lastname'). ' has reviewed your submission and the status of the material listed below has changed to "'.getStatus($lc->postvars['status']).'" in your '.$db->Record['courseName'].' - '.$db->Record['courseFamily'].$db->Record['courseNumber'];
  			$mess->message .= "\n\nMaterial:\n".$book->title. ' - '. $book->author;
  			
--- 307,312 ----
  			include_once(SERVICE_PATH."pm/privmess.php");
  			$mess = new privMess();
! 			$mess->subject = $semester_label. ': Textbook status changed to '.getStatus($lc->postvars['status']).' on class '.$db->record['courseFamily'].$db->record['courseNumber'];
! 			$mess->message = $semester_label.': '.$u->profile->get('firstname').' '.$u->profile->get('lastname'). ' has reviewed your submission and the status of the material listed below has changed to "'.getStatus($lc->postvars['status']).'" in your '.$db->record['courseName'].' - '.$db->record['courseFamily'].$db->record['courseNumber'];
  			$mess->message .= "\n\nMaterial:\n".$book->title. ' - '. $book->author;
  			
***************
*** 320,324 ****
  			$mess->messageFrom = $u->username;
  			
! 			$mess->messageTo = $db->Record['facultyId'];
  			$mess->add();
  			
--- 320,324 ----
  			$mess->messageFrom = $u->username;
  			
! 			$mess->messageTo = $db->record['facultyId'];
  			$mess->add();
  			
***************
*** 355,359 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->Record['courseName'].'('.$db->Record['courseFamily'].$db->Record['courseNumber'].')';
  		$t['id_classes'] = $lc->getvars['id'];
  		if (in_array('tbadmin', $u->groups) || in_array('admin', $u->groups)) 
--- 355,359 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->record['courseName'].'('.$db->record['courseFamily'].$db->record['courseNumber'].')';
  		$t['id_classes'] = $lc->getvars['id'];
  		if (in_array('tbadmin', $u->groups) || in_array('admin', $u->groups)) 

Index: estimates.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/textbookmgr/estimates.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** estimates.lcp	2 Jun 2005 02:06:36 -0000	1.2
--- estimates.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 54,58 ****
  		$books = $u->sessionvars['textbooks'];
  		$db->queryOne("Select * from textbook_estimates where textbook_estimates_name ='$name'");
! 		$key = $db->Record['textbook_estimates_key'];
  		if ($key) {
  			$db->query("delete from textbook_estimates_data where textbook_estimates_key=$key");
--- 54,58 ----
  		$books = $u->sessionvars['textbooks'];
  		$db->queryOne("Select * from textbook_estimates where textbook_estimates_name ='$name'");
! 		$key = $db->record['textbook_estimates_key'];
  		if ($key) {
  			$db->query("delete from textbook_estimates_data where textbook_estimates_key=$key");
***************
*** 110,115 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->query($sql);
! 		while($db->next_record()){ 
! 			$temp[$db->Record['id_semesters']] = $db->Record['semesterTerm']." ".$db->Record['semesterYear'];
  		}
  		$t['semester1'] = makeOptions($temp);
--- 110,115 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->query($sql);
! 		while($db->nextRecord()){ 
! 			$temp[$db->record['id_semesters']] = $db->record['semesterTerm']." ".$db->record['semesterYear'];
  		}
  		$t['semester1'] = makeOptions($temp);
***************
*** 126,130 ****
  		$db->queryOne($sql);
  		
! 		$t['semester_label'] = $db->Record['semesterYear'].' '.$db->Record['semesterTerm'];
  	
  		$sql = '
--- 126,130 ----
  		$db->queryOne($sql);
  		
! 		$t['semester_label'] = $db->record['semesterYear'].' '.$db->record['semesterTerm'];
  	
  		$sql = '
***************
*** 137,141 ****
  		$db->queryOne($sql);
  		
! 		$t['semester1_label'] = $db->Record['semesterYear'].' '.$db->Record['semesterTerm'];
  		
  		$sql = '
--- 137,141 ----
  		$db->queryOne($sql);
  		
! 		$t['semester1_label'] = $db->record['semesterYear'].' '.$db->record['semesterTerm'];
  		
  		$sql = '
***************
*** 148,152 ****
  		$db->queryOne($sql);
  		
! 		$t['semester2_label'] = $db->Record['semesterYear'].' '.$db->Record['semesterTerm'];
  		
  
--- 148,152 ----
  		$db->queryOne($sql);
  		
! 		$t['semester2_label'] = $db->record['semesterYear'].' '.$db->record['semesterTerm'];
  		
  
***************
*** 204,209 ****
  		$a_books = array();
  		// at most, 1000 records, first semester of this program there are only 200+
! 		while($db->next_record())
! 		{	$a_books[] = $db->Record;
  		}
  		
--- 204,209 ----
  		$a_books = array();
  		// at most, 1000 records, first semester of this program there are only 200+
! 		while($db->nextRecord())
! 		{	$a_books[] = $db->record;
  		}
  		
***************
*** 236,244 ****
  
  #			$db->queryOne("select facultyId, courseFamilyNumber from classes where id_classes='".$book['id_classes']."'");
! #			$temp= $db->Record;
  // now get me the info for that class (matching instructor and class name) for the selected 
  // previous semester
  #			$db->queryOne("select * from classes where facultyId='".$temp['facultyId']."' and courseFamilyNumber='".$temp['courseFamilyNumber']."' and id_semesters='".$sem1."'");
! #			$info = $db->Record;
  
  // now we have a list of section numbers for the same class taught by the same instructor 
--- 236,244 ----
  
  #			$db->queryOne("select facultyId, courseFamilyNumber from classes where id_classes='".$book['id_classes']."'");
! #			$temp= $db->record;
  // now get me the info for that class (matching instructor and class name) for the selected 
  // previous semester
  #			$db->queryOne("select * from classes where facultyId='".$temp['facultyId']."' and courseFamilyNumber='".$temp['courseFamilyNumber']."' and id_semesters='".$sem1."'");
! #			$info = $db->record;
  
  // now we have a list of section numbers for the same class taught by the same instructor 

[Logicampus-cvs] logicampus/src/logicreate/services/users articles.lcp, 1.2, 1.3 blog.lcp, 1.1, 1.2 chat.lcp, 1.4, 1.5 maillist.lcp, 1.2, 1.3 online.lcp, 1.5, 1.6 view.lcp, 1.3, 1.4 viewPhoto.lcp, 1.2, 1.3

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

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

Modified Files:
	articles.lcp blog.lcp chat.lcp maillist.lcp online.lcp 
	view.lcp viewPhoto.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: viewPhoto.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/users/viewPhoto.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** viewPhoto.lcp	18 Nov 2006 00:09:35 -0000	1.2
--- viewPhoto.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 26,33 ****
  			$sql = "select * from userPhotos where pkey='$pkey'";
  			$db->queryOne($sql);
! 			$t[image] = $db->Record;
  
  			$db->queryOne("select username, firstname, lastname from profile where username='".$t[image][username]."'");
! 			$t[profile] = $db->Record;
  
  			$db->query("update userPhotos set count=count+1 where pkey='$pkey'");
--- 26,33 ----
  			$sql = "select * from userPhotos where pkey='$pkey'";
  			$db->queryOne($sql);
! 			$t[image] = $db->record;
  
  			$db->queryOne("select username, firstname, lastname from profile where username='".$t[image][username]."'");
! 			$t[profile] = $db->record;
  
  			$db->query("update userPhotos set count=count+1 where pkey='$pkey'");

Index: view.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/users/view.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** view.lcp	18 Nov 2006 00:09:35 -0000	1.3
--- view.lcp	8 Oct 2007 14:31:27 -0000	1.4
***************
*** 40,47 ****
  		$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';
  
--- 40,47 ----
  		$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';
  

Index: online.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/users/online.lcp,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** online.lcp	2 Sep 2007 16:32:38 -0000	1.5
--- online.lcp	8 Oct 2007 14:31:27 -0000	1.6
***************
*** 31,36 ****
  			
  			$i=1;
! 			while($db->next_record()) {
! 				$t['users'][$i++]= $db->Record;
  			}
  			$t['anonymous'] = $x - count($t['users']);
--- 31,36 ----
  			
  			$i=1;
! 			while($db->nextRecord()) {
! 				$t['users'][$i++]= $db->record;
  			}
  			$t['anonymous'] = $x - count($t['users']);

Index: articles.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/users/articles.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** articles.lcp	18 Nov 2006 00:09:35 -0000	1.2
--- articles.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 23,34 ****
  		$sql = "select pkey, title, introtext, maintext, notes from articles where author='".$u->username."' and status='Return'";
  		$db->query($sql);
! 		while($db->next_record()) {
! 			$t[returned][] = $db->Record;
  		}
  		# Show all pending articles
  		$sql = "select title from articles where author='".$u->username."' and status='Pending'";
  		$db->query($sql);
! 		while($db->next_record()) {
! 			$t[pending][] = $db->Record;
  		}
  	}
--- 23,34 ----
  		$sql = "select pkey, title, introtext, maintext, notes from articles where author='".$u->username."' and status='Return'";
  		$db->query($sql);
! 		while($db->nextRecord()) {
! 			$t[returned][] = $db->record;
  		}
  		# Show all pending articles
  		$sql = "select title from articles where author='".$u->username."' and status='Pending'";
  		$db->query($sql);
! 		while($db->nextRecord()) {
! 			$t[pending][] = $db->record;
  		}
  	}
***************
*** 37,42 ****
  		$sql = "select pkey, title, introtext, maintext, author from articles where pkey='".$arg->getvars[pkey]."'";
  		$db->queryOne($sql);
! 		if ($db->Record[author] == $u->username) { 
! 			$t[article] = $db->Record;
  		} else {
  			$t[error] = "There was an error re-submitting this article.  Please contact the webmaster.";
--- 37,42 ----
  		$sql = "select pkey, title, introtext, maintext, author from articles where pkey='".$arg->getvars[pkey]."'";
  		$db->queryOne($sql);
! 		if ($db->record[author] == $u->username) { 
! 			$t[article] = $db->record;
  		} else {
  			$t[error] = "There was an error re-submitting this article.  Please contact the webmaster.";
***************
*** 47,51 ****
  	function editReturnPostRun(&$db,&$u,&$arg,&$t) {
  		$db->queryOne("select author from articles where pkey='".$arg->postvars[pkey]."'");
! 		if($u->username != $db->Record[author]) { 
  			$t[error] = "You are not the owner of this article.";
  			$this->run(&$db,&$u,&$arg,&$t);
--- 47,51 ----
  	function editReturnPostRun(&$db,&$u,&$arg,&$t) {
  		$db->queryOne("select author from articles where pkey='".$arg->postvars[pkey]."'");
! 		if($u->username != $db->record[author]) { 
  			$t[error] = "You are not the owner of this article.";
  			$this->run(&$db,&$u,&$arg,&$t);

Index: chat.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/users/chat.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** chat.lcp	11 Feb 2007 22:41:08 -0000	1.4
--- chat.lcp	8 Oct 2007 14:31:27 -0000	1.5
***************
*** 55,60 ****
  		$lcObj->templateName = "chat_main";
  #		$db->query("select pkey,chatName,chatDesc from chatArchives ORDER BY pkey DESC");
! #		while($db->next_record()) {
! #			$x[] = $db->Record;
  #		}
  		$t['archiveList'] = $x;
--- 55,60 ----
  		$lcObj->templateName = "chat_main";
  #		$db->query("select pkey,chatName,chatDesc from chatArchives ORDER BY pkey DESC");
! #		while($db->nextRecord()) {
! #			$x[] = $db->record;
  #		}
  		$t['archiveList'] = $x;
***************
*** 112,117 ****
  		$lcObj->templateName = "chat_show";
  		$db->query("select * from chatThreads");
! 		while($db->next_record()) { 
! 			extract($db->Record);
  			$x = "<a href=\"#\" onClick=\"window.open('";
  			$x .= appurl("{$this->module_name}/chat/event=admin/chatThread=$chatThread");
--- 112,117 ----
  		$lcObj->templateName = "chat_show";
  		$db->query("select * from chatThreads");
! 		while($db->nextRecord()) { 
! 			extract($db->record);
  			$x = "<a href=\"#\" onClick=\"window.open('";
  			$x .= appurl("{$this->module_name}/chat/event=admin/chatThread=$chatThread");
***************
*** 147,151 ****
  		$arg->templateName='chat_usershow';
  		$db->queryOne("select * from lcUsers where username='".$arg->getvars['username']."'"); 
! 		$t['usershow'] = $db->Record;
  		$this->presentor = "emptypresentation";
  	}
--- 147,151 ----
  		$arg->templateName='chat_usershow';
  		$db->queryOne("select * from lcUsers where username='".$arg->getvars['username']."'"); 
! 		$t['usershow'] = $db->record;
  		$this->presentor = "emptypresentation";
  	}
***************
*** 154,159 ****
  		$arg->templateName='chat_userlist';
  		$db->query("select distinct(username) from chat where chat_id='{$this->chat_id}' and  timeint>=".(time()-900)." order by username");
! 		while($db->next_record()) {
! 			$t['users'][] = $db->Record;
  		}
  		$this->presentor = "emptypresentation";
--- 154,159 ----
  		$arg->templateName='chat_userlist';
  		$db->query("select distinct(username) from chat where chat_id='{$this->chat_id}' and  timeint>=".(time()-900)." order by username");
! 		while($db->nextRecord()) {
! 			$t['users'][] = $db->record;
  		}
  		$this->presentor = "emptypresentation";
***************
*** 225,230 ****
  			$db->query($sql);
  
! 			while($db->next_record()) {
! 				extract($db->Record);
  				$message = stripslashes($message);
  				$nameclass = "regname$style";
--- 225,230 ----
  			$db->query($sql);
  
! 			while($db->nextRecord()) {
! 				extract($db->record);
  				$message = stripslashes($message);
  				$nameclass = "regname$style";
***************
*** 363,368 ****
  		$db->query($sql);
  
! 		while($db->next_record()) {
! 			extract($db->Record);
  			$message = stripslashes($message);
  			$post = "<a href=\"".appurl("chat/main/event=moveQ/move=1/pkey=$pkey")."\">approve</a>\n";
--- 363,368 ----
  		$db->query($sql);
  
! 		while($db->nextRecord()) {
! 			extract($db->record);
  			$message = stripslashes($message);
  			$post = "<a href=\"".appurl("chat/main/event=moveQ/move=1/pkey=$pkey")."\">approve</a>\n";
***************
*** 386,390 ****
  			if ($lcObj->getvars["move"]==1) { 
  				$db->queryOne("select * from chatQ where pkey=$pkey");
! 				extract($db->Record);
  				$message = addslashes($message);
  				$username = addslashes($username);
--- 386,390 ----
  			if ($lcObj->getvars["move"]==1) { 
  				$db->queryOne("select * from chatQ where pkey=$pkey");
! 				extract($db->record);
  				$message = addslashes($message);
  				$username = addslashes($username);

Index: maillist.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/users/maillist.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** maillist.lcp	18 Nov 2006 00:09:35 -0000	1.2
--- maillist.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 24,33 ****
  	function Run (&$db, &$u, &$arg, &$t) {
  		$db->query("select gid, groupName from lcGroups where gid like 'ml_%'");
! 		while($db->next_record())
  		  {
! 			$t['maillist'][$db->Record['gid']] = $db->Record;
! 			if (in_array($db->Record['gid'], $u->groups))
  			{
! 				$t['maillist'][$db->Record['gid']][checked] = 'yes';
  			}
  					
--- 24,33 ----
  	function Run (&$db, &$u, &$arg, &$t) {
  		$db->query("select gid, groupName from lcGroups where gid like 'ml_%'");
! 		while($db->nextRecord())
  		  {
! 			$t['maillist'][$db->record['gid']] = $db->record;
! 			if (in_array($db->record['gid'], $u->groups))
  			{
! 				$t['maillist'][$db->record['gid']][checked] = 'yes';
  			}
  					
***************
*** 70,77 ****
  		 
  		 $db->query($sql);
! 		 while($db->next_record())
  		 {
! 		 	if (in_array($db->Record['gid'], $list)) {
! 		 		$t['list'][] = $db->Record['groupName'];
  		 	}
  		 }
--- 70,77 ----
  		 
  		 $db->query($sql);
! 		 while($db->nextRecord())
  		 {
! 		 	if (in_array($db->record['gid'], $list)) {
! 		 		$t['list'][] = $db->record['groupName'];
  		 	}
  		 }

Index: blog.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/users/blog.lcp,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** blog.lcp	17 Dec 2003 00:07:23 -0000	1.1
--- blog.lcp	8 Oct 2007 14:31:27 -0000	1.2
***************
*** 194,199 ****
  		$message = "$x\n\n\nYou asked to be notified of any new postings to the '".$originalEntry->blogEntryTitle."' thread on the '".$blog->blogName."' web log.  Please visit ".modurl("blog/".$blog->blogOwner."/".$originalEntry->blogEntryId."/event=read")." to read new comments made to that thread.";
  
! 		while($db->next_record()){ 
! 			$mails[$db->Record[0]] = $db->Record[0];
  		}
  		while(list($k,$v) = each($mails)) { 
--- 194,199 ----
  		$message = "$x\n\n\nYou asked to be notified of any new postings to the '".$originalEntry->blogEntryTitle."' thread on the '".$blog->blogName."' web log.  Please visit ".modurl("blog/".$blog->blogOwner."/".$originalEntry->blogEntryId."/event=read")." to read new comments made to that thread.";
  
! 		while($db->nextRecord()){ 
! 			$mails[$db->record[0]] = $db->record[0];
  		}
  		while(list($k,$v) = each($mails)) { 

[Logicampus-cvs] logicampus/src/logicreate/services/seminarorientation orientations.lcp, 1.2, 1.3 seminarcal.lcp, 1.2, 1.3 seminars.lcp, 1.2, 1.3

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

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

Modified Files:
	orientations.lcp seminarcal.lcp seminars.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: seminarcal.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/seminarorientation/seminarcal.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** seminarcal.lcp	18 Nov 2006 00:09:35 -0000	1.2
--- seminarcal.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 278,283 ****
  		$db->query($sql);
  		
! 		while ($db->next_record())
! 		{	$idClassesArray[] = $db->Record['id_classes'];
  		}
  	
--- 278,283 ----
  		$db->query($sql);
  		
! 		while ($db->nextRecord())
! 		{	$idClassesArray[] = $db->record['id_classes'];
  		}
  	

Index: orientations.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/seminarorientation/orientations.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** orientations.lcp	18 Nov 2006 00:09:35 -0000	1.2
--- orientations.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 211,215 ****
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			$db->queryOne($sql);
! 			$db_temp = $db->Record;
  			
  			if ($o->idOrientationClasses)
--- 211,215 ----
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			$db->queryOne($sql);
! 			$db_temp = $db->record;
  			
  			if ($o->idOrientationClasses)
***************
*** 280,284 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->Record['courseName'].'('.$db->Record['courseFamily'].$db->Record['courseNumber'].') '.$db->Record['Faculty'];
  		
  		$t['form'] = ''; // cleaned
--- 280,284 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->record['courseName'].'('.$db->record['courseFamily'].$db->record['courseNumber'].') '.$db->record['Faculty'];
  		
  		$t['form'] = ''; // cleaned
***************
*** 487,492 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->Record['courseName'].'('.$db->Record['courseFamily'].$db->Record['courseNumber'].') '.$db->Record['Faculty'];
! 		$db_temp = $db->Record;
  		
  		$formObj = new SiteForm();
--- 487,492 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->record['courseName'].'('.$db->record['courseFamily'].$db->record['courseNumber'].') '.$db->record['Faculty'];
! 		$db_temp = $db->record;
  		
  		$formObj = new SiteForm();
***************
*** 524,534 ****
  					
  					$mess = new privMess();
! 					$mess->subject = '['.$db->Record['courseFamily'].$db->Record['courseNumber'].'] Your scheduled orientation has been updated to: '.$this->getStatus($lc->postvars['status']);
! 					$mess->message = 'There was a change to your orientation schedule *status* on: '.$db->Record['courseName'].' - '.$db->Record['courseFamily'].$db->Record['courseNumber'].' class.';
  					
  					$mess->sentTime = time();
  					$mess->messageFrom = $u->username;
  					
! 					$mess->messageTo = $db->Record['facultyId'];
  					$mess->add();
  				
--- 524,534 ----
  					
  					$mess = new privMess();
! 					$mess->subject = '['.$db->record['courseFamily'].$db->record['courseNumber'].'] Your scheduled orientation has been updated to: '.$this->getStatus($lc->postvars['status']);
! 					$mess->message = 'There was a change to your orientation schedule *status* on: '.$db->record['courseName'].' - '.$db->record['courseFamily'].$db->record['courseNumber'].' class.';
  					
  					$mess->sentTime = time();
  					$mess->messageFrom = $u->username;
  					
! 					$mess->messageTo = $db->record['facultyId'];
  					$mess->add();
  				
***************
*** 714,719 ****
  			
  			// 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'])).'';
  			}
  			
--- 714,719 ----
  			
  			// 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: seminars.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/seminarorientation/seminars.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** seminars.lcp	18 Nov 2006 00:09:35 -0000	1.2
--- seminars.lcp	8 Oct 2007 14:31:27 -0000	1.3
***************
*** 113,122 ****
  		$db->queryOne($sql);
  		$this->sectionTitle = 'Adding Seminar ';
! 		$this->sectionTitle .= ' - '. $db->Record['courseName'].'('.$db->Record['courseFamily'].$db->Record['courseNumber'].')';
  
! 		$t['courseName'] = $db->Record['courseName'];
  		$t['courseFamNum'] =
! 		$db->Record['courseFamily'].$db->Record['courseNumber'];
! 		$t['facultyId'] = $db->Record['facultyId'];
  
  		$lc->templateName = 'seminars_edit';
--- 113,122 ----
  		$db->queryOne($sql);
  		$this->sectionTitle = 'Adding Seminar ';
! 		$this->sectionTitle .= ' - '. $db->record['courseName'].'('.$db->record['courseFamily'].$db->record['courseNumber'].')';
  
! 		$t['courseName'] = $db->record['courseName'];
  		$t['courseFamNum'] =
! 		$db->record['courseFamily'].$db->record['courseNumber'];
! 		$t['facultyId'] = $db->record['facultyId'];
  
  		$lc->templateName = 'seminars_edit';
***************
*** 135,139 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->Record['courseName'].'('.$db->Record['courseFamily'].$db->Record['courseNumber'].')';
  
  		$t['id_classes'] = $lc->getvars['id'];
--- 135,139 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$this->sectionTitle .= ' - '. $db->record['courseName'].'('.$db->record['courseFamily'].$db->record['courseNumber'].')';
  
  		$t['id_classes'] = $lc->getvars['id'];
***************
*** 154,161 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$t['courseName'] = $db->Record['courseName'];
  		$t['courseFamNum'] =
! 		$db->Record['courseFamily'].$db->Record['courseNumber'];
! 		$t['facultyId'] = $db->Record['facultyId'];
  
  		$lc->templateName = 'seminars_edit';
--- 154,161 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$t['courseName'] = $db->record['courseName'];
  		$t['courseFamNum'] =
! 		$db->record['courseFamily'].$db->record['courseNumber'];
! 		$t['facultyId'] = $db->record['facultyId'];
  
  		$lc->templateName = 'seminars_edit';
***************
*** 176,180 ****
  			$db->queryOne($sql);
  			# update the count on the seminar
! 			$obj->numSeminar = $db->Record['count'] + 1;
  			$obj->idClasses = $lc->getvars['id_classes'];
  			if ($obj->numSeminar == 5)
--- 176,180 ----
  			$db->queryOne($sql);
  			# update the count on the seminar
! 			$obj->numSeminar = $db->record['count'] + 1;
  			$obj->idClasses = $lc->getvars['id_classes'];
  			if ($obj->numSeminar == 5)
***************
*** 203,207 ****
  			$mess = new privMess();
  			$mess->subject = 'Seminar '.$obj->numSeminar.' Updated To: '.getStatus($obj->entryStatus);
! 			$mess->message = 'Your Seminar '.$obj->numSeminar.'</a> status changed on your '.$db->Record['courseName'].' - '.$db->Record['courseFamily'].$db->Record['courseNumber'].' class.';
  			$mess->message .="\n\nThe following note was appeneded:\n\n".$obj->note;
  	
--- 203,207 ----
  			$mess = new privMess();
  			$mess->subject = 'Seminar '.$obj->numSeminar.' Updated To: '.getStatus($obj->entryStatus);
! 			$mess->message = 'Your Seminar '.$obj->numSeminar.'</a> status changed on your '.$db->record['courseName'].' - '.$db->record['courseFamily'].$db->record['courseNumber'].' class.';
  			$mess->message .="\n\nThe following note was appeneded:\n\n".$obj->note;
  	
***************
*** 210,217 ****
  			$mess->messageFrom = $u->username;
  			
! 			$mess->messageTo = $db->Record['facultyId'];
  			$mess->add();
  			
! 			$db_temp = $db->Record;
  			
  			include_once(LIB_PATH.'eventsObj.php');
--- 210,217 ----
  			$mess->messageFrom = $u->username;
  			
! 			$mess->messageTo = $db->record['facultyId'];
  			$mess->add();
  			
! 			$db_temp = $db->record;
  			
  			include_once(LIB_PATH.'eventsObj.php');

[Logicampus-cvs] logicampus/src/logicreate/services/welcome dummy_students.lcp, 1.4, 1.5 news.lcp, 1.2, 1.3

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

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

Modified Files:
	dummy_students.lcp news.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: news.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/welcome/news.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** news.lcp	10 Nov 2006 20:16:45 -0000	1.2
--- news.lcp	8 Oct 2007 14:31:26 -0000	1.3
***************
*** 11,16 ****
  
  		$db->queryOne("select * from lcHtml where filename='welcome.html'  $where");
! 		$t["title"] = $db->Record["title"];
! 		$t["file"] = $db->Record[filename];
  /********
  * The following two SQL queries only pull articles
--- 11,16 ----
  
  		$db->queryOne("select * from lcHtml where filename='welcome.html'  $where");
! 		$t["title"] = $db->record["title"];
! 		$t["file"] = $db->record[filename];
  /********
  * The following two SQL queries only pull articles
***************
*** 28,38 ****
  		$db->query("select introtext, title, articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'Articles' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ($db->next_record() ) {
! 			$t[articles][] = PersistantObject::createFromArray("NewsArticle",$db->Record);
  		}
  		$db->query("select introtext,title,articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'News' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ($db->next_record() ) {
! 			$t[news][] = PersistantObject::createFromArray("NewsArticle",$db->Record);
  		}
  
--- 28,38 ----
  		$db->query("select introtext, title, articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'Articles' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ($db->nextRecord() ) {
! 			$t[articles][] = PersistantObject::createFromArray("NewsArticle",$db->record);
  		}
  		$db->query("select introtext,title,articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'News' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ($db->nextRecord() ) {
! 			$t[news][] = PersistantObject::createFromArray("NewsArticle",$db->record);
  		}
  

Index: dummy_students.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/welcome/dummy_students.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** dummy_students.lcp	9 Feb 2007 19:49:49 -0000	1.4
--- dummy_students.lcp	8 Oct 2007 14:31:26 -0000	1.5
***************
*** 26,33 ****
  		$db->query($sql);
  
! 		while ( $db->next_record() ) {
  			$sql = "insert into class_assignments_link
! 				set id_class_assignments='{$db->Record['id_class_assignments']}',
! 				id_class_lessons='{$db->Record['id_class_lessons']}'";
  			$db2->query($sql);
  		}
--- 26,33 ----
  		$db->query($sql);
  
! 		while ( $db->nextRecord() ) {
  			$sql = "insert into class_assignments_link
! 				set id_class_assignments='{$db->record['id_class_assignments']}',
! 				id_class_lessons='{$db->record['id_class_lessons']}'";
  			$db2->query($sql);
  		}

[Logicampus-cvs] logicampus/src/logicreate/services/search/admin main.lcp, 1.1.1.1, 1.2

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/search/admin/main.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** main.lcp	21 Nov 2003 23:14:13 -0000	1.1.1.1
--- main.lcp	8 Oct 2007 14:31:27 -0000	1.2
***************
*** 37,44 ****
  			$x['mid'] = $plugin->filename;
  			$db->queryOne($plugin->getCountSQL);
! 			$x['rec'] = $db->Record[0];
  
  			$db->queryOne("select count(mkey) from lcSearch where modID = '".$plugin->mid."'");
! 			$x['irec'] = $db->Record[0];
  		$t[modlist][] = $x;
  		} 	
--- 37,44 ----
  			$x['mid'] = $plugin->filename;
  			$db->queryOne($plugin->getCountSQL);
! 			$x['rec'] = $db->record[0];
  
  			$db->queryOne("select count(mkey) from lcSearch where modID = '".$plugin->mid."'");
! 			$x['irec'] = $db->record[0];
  		$t[modlist][] = $x;
  		} 	
***************
*** 51,57 ****
  
  		$db->query("select text, count(*) as count from searchCache group by text order by count desc limit ".$this->_CacheResults."");
! 		while($db->next_record())
  			{
! 				$t[cacheResults][] = "<li><b>".$db->Record[text]."</b> (".$db->Record[count].")";
  			}
  
--- 51,57 ----
  
  		$db->query("select text, count(*) as count from searchCache group by text order by count desc limit ".$this->_CacheResults."");
! 		while($db->nextRecord())
  			{
! 				$t[cacheResults][] = "<li><b>".$db->record[text]."</b> (".$db->record[count].")";
  			}
  

[Logicampus-cvs] logicampus/src/logicreate/services/search main.lcp, 1.1.1.1, 1.2

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/search/main.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** main.lcp	21 Nov 2003 23:14:13 -0000	1.1.1.1
--- main.lcp	8 Oct 2007 14:31:27 -0000	1.2
***************
*** 114,118 ****
  		
  		$db->queryOne($query);
! 		$top_score = number_format($db->Record['score'], 2);
          
  		$query = " SELECT title,link,type, searchdata, MATCH searchdata AGAINST ";
--- 114,118 ----
  		
  		$db->queryOne($query);
! 		$top_score = number_format($db->record['score'], 2);
          
  		$query = " SELECT title,link,type, searchdata, MATCH searchdata AGAINST ";
***************
*** 125,132 ****
  		
  		$db->query($query);
! 		while ($db->next_record() ){
! 			$vt = number_format($db->Record['score'],2);
! 			$db->Record['score'] = ceil((($vt*100)/$top_score)). '%'; //
! 		    $t['results'][] = $db->Record;
  			$t['showing']++;
  		}
--- 125,132 ----
  		
  		$db->query($query);
! 		while ($db->nextRecord() ){
! 			$vt = number_format($db->record['score'],2);
! 			$db->record['score'] = ceil((($vt*100)/$top_score)). '%'; //
! 		    $t['results'][] = $db->record;
  			$t['showing']++;
  		}

[Logicampus-cvs] logicampus/src/logicreate/services/remotetest show.lcp, 1.1.1.1, 1.2

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

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

Modified Files:
	show.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: show.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/remotetest/show.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** show.lcp	21 Nov 2003 23:14:13 -0000	1.1.1.1
--- show.lcp	8 Oct 2007 14:31:27 -0000	1.2
***************
*** 25,29 ****
  			$hash = addslashes($lc->getvars[1]);
  			$db->queryOne("select * from remote_test_files where hash='$hash'");
! 			$t['file'] = $db->Record;
  			$lc->templateName='show_main';
  		}
--- 25,29 ----
  			$hash = addslashes($lc->getvars[1]);
  			$db->queryOne("select * from remote_test_files where hash='$hash'");
! 			$t['file'] = $db->record;
  			$lc->templateName='show_main';
  		}
***************
*** 32,36 ****
  			$hash = addslashes($lc->getvars[1]);
  			$db->queryOne("select * from remote_test_files where hash='$hash'");
! 			$x = $db->Record;
  			ob_end_clean();
  			header("Content-type: ".$x['mime']); 
--- 32,36 ----
  			$hash = addslashes($lc->getvars[1]);
  			$db->queryOne("select * from remote_test_files where hash='$hash'");
! 			$x = $db->record;
  			ob_end_clean();
  			header("Content-type: ".$x['mime']); 

[Logicampus-cvs] logicampus/src/logicreate/services/pm/admin main.lcp, 1.2, 1.3

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/pm/admin/main.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** main.lcp	11 Feb 2007 05:31:21 -0000	1.2
--- main.lcp	8 Oct 2007 14:31:30 -0000	1.3
***************
*** 19,23 ****
  		$without = createGroupCheck($arg->postvars['notgroups']);
  		$db->query("select username from lcUsers where  ( ($with) and not ($without) )");
! 		while($db->next_record()) {
  	                $mess = new privMess();
  	                $mess->subject = $arg->postvars['subject'];
--- 19,23 ----
  		$without = createGroupCheck($arg->postvars['notgroups']);
  		$db->query("select username from lcUsers where  ( ($with) and not ($without) )");
! 		while($db->nextRecord()) {
  	                $mess = new privMess();
  	                $mess->subject = $arg->postvars['subject'];
***************
*** 26,30 ****
  		          $mess->sentTime = time();
  	                 $mess->messageFrom =  "SYSTEM ADMIN";
! 	               $mess->messageTo = $db->Record['username'];
                        $mess->add();
  		}
--- 26,30 ----
  		          $mess->sentTime = time();
  	                 $mess->messageFrom =  "SYSTEM ADMIN";
! 	               $mess->messageTo = $db->record['username'];
                        $mess->add();
  		}

[Logicampus-cvs] logicampus/src/logicreate/services/menu/admin itemEditor.lcp, 1.4, 1.5 main.lcp, 1.2, 1.3 menuEditor.lcp, 1.2, 1.3

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

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

Modified Files:
	itemEditor.lcp main.lcp menuEditor.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: itemEditor.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/menu/admin/itemEditor.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** itemEditor.lcp	22 May 2007 03:25:12 -0000	1.4
--- itemEditor.lcp	8 Oct 2007 14:31:30 -0000	1.5
***************
*** 21,26 ****
  				include_once(LIB_PATH."LC_html.php");
  				$db->query("select filename, title from lcHtml");
! 				while($db->next_record()) {
! 					$t[html][$db->Record[0]] = $db->Record[1];
  				}
  				$t[html] = makeOptions($t[html]);
--- 21,26 ----
  				include_once(LIB_PATH."LC_html.php");
  				$db->query("select filename, title from lcHtml");
! 				while($db->nextRecord()) {
! 					$t[html][$db->record[0]] = $db->record[1];
  				}
  				$t[html] = makeOptions($t[html]);
***************
*** 30,35 ****
  				include_once(LIB_PATH."LC_html.php");
  				$db->query("select mid, moduleName from lcRegistry");
! 				while($db->next_record()) {
! 					$t[apps][$db->Record[0]] = $db->Record[1];
  				}
  				$t[apps] = makeOptions($t[apps]);
--- 30,35 ----
  				include_once(LIB_PATH."LC_html.php");
  				$db->query("select mid, moduleName from lcRegistry");
! 				while($db->nextRecord()) {
! 					$t[apps][$db->record[0]] = $db->record[1];
  				}
  				$t[apps] = makeOptions($t[apps]);
***************
*** 43,48 ****
  		//parent menus
  		$db->query("select pkey, title from menu order by title");
! 		while($db->next_record()) {
! 			$t[menuOpts] .= '<option value="'.$db->Record[0].'">'.$db->Record[1].'</option>';
  		}
  		$t['event'] = "insert";
--- 43,48 ----
  		//parent menus
  		$db->query("select pkey, title from menu order by title");
! 		while($db->nextRecord()) {
! 			$t[menuOpts] .= '<option value="'.$db->record[0].'">'.$db->record[1].'</option>';
  		}
  		$t['event'] = "insert";
***************
*** 117,123 ****
  			case "htm":
  				$db->query("select filename, title from lcHtml");
! 				while($db->next_record()) {
! 					$t[html][$db->Record['filename']] = $db->Record['title'];
! 					if ( $link->location == $db->Record['filename'] ) { $sel = $db->Record['filename']; }
  				}
  				$t[html] = makeOptions($t[html],$sel);
--- 117,123 ----
  			case "htm":
  				$db->query("select filename, title from lcHtml");
! 				while($db->nextRecord()) {
! 					$t[html][$db->record['filename']] = $db->record['title'];
! 					if ( $link->location == $db->record['filename'] ) { $sel = $db->record['filename']; }
  				}
  				$t[html] = makeOptions($t[html],$sel);
***************
*** 127,133 ****
  				include_once(LIB_PATH."LC_html.php");
  				$db->query("select mid, moduleName from lcRegistry");
! 				while($db->next_record()) {
! 					$t[apps][$db->Record['mid']] = $db->Record['moduleName'];
! 					if ( $link->location == $db->Record['mid'] ) { $sel = $db->Record['moduleName']; }
  
  				}
--- 127,133 ----
  				include_once(LIB_PATH."LC_html.php");
  				$db->query("select mid, moduleName from lcRegistry");
! 				while($db->nextRecord()) {
! 					$t[apps][$db->record['mid']] = $db->record['moduleName'];
! 					if ( $link->location == $db->record['mid'] ) { $sel = $db->record['moduleName']; }
  
  				}
***************
*** 231,236 ****
  		$db->query("select pkey,parentID,linkText,type from menuItems where menuID = ".$link->menuID." order by parentID, rank");
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ( $db->next_record() ) {
! 			$data[] = MenuItem::getMenuItem($db->Record);
  		}
  
--- 231,236 ----
  		$db->query("select pkey,parentID,linkText,type from menuItems where menuID = ".$link->menuID." order by parentID, rank");
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while ( $db->nextRecord() ) {
! 			$data[] = MenuItem::getMenuItem($db->record);
  		}
  

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/menu/admin/main.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** main.lcp	22 May 2007 03:25:12 -0000	1.2
--- main.lcp	8 Oct 2007 14:31:30 -0000	1.3
***************
*** 26,30 ****
  
  		$db->queryOne("select * from menuCache where pkey=$menuID");
! 		$cachedMenu = unserialize($db->Record['menuObj']);
  
  	}
--- 26,30 ----
  
  		$db->queryOne("select * from menuCache where pkey=$menuID");
! 		$cachedMenu = unserialize($db->record['menuObj']);
  
  	}

Index: menuEditor.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/menu/admin/menuEditor.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** menuEditor.lcp	22 May 2007 03:25:12 -0000	1.2
--- menuEditor.lcp	8 Oct 2007 14:31:31 -0000	1.3
***************
*** 12,26 ****
  
  		$db->query("select gid,groupName from lcGroups order by groupName");
! 		while($db->next_record()) {
! 			$t[groups] .= '<option value="'.$db->Record[0].'" ';
! 			$t[notgroups] .= '<option value="'.$db->Record[0].'" ';
! 			if ( in_array($db->Record[0],$t[menu]->groups) ) {
  				$t[groups] .= 'SELECTED';
  			}
! 			if ( in_array($db->Record[0],$t[menu]->notgroups) ) {
  				$t[notgroups] .= 'SELECTED';
  			}
! 			$t[groups] .= '>'.$db->Record[1].'</option>';
! 			$t[notgroups] .= '>'.$db->Record[1].'</option>';
  
  		}
--- 12,26 ----
  
  		$db->query("select gid,groupName from lcGroups order by groupName");
! 		while($db->nextRecord()) {
! 			$t[groups] .= '<option value="'.$db->record[0].'" ';
! 			$t[notgroups] .= '<option value="'.$db->record[0].'" ';
! 			if ( in_array($db->record[0],$t[menu]->groups) ) {
  				$t[groups] .= 'SELECTED';
  			}
! 			if ( in_array($db->record[0],$t[menu]->notgroups) ) {
  				$t[notgroups] .= 'SELECTED';
  			}
! 			$t[groups] .= '>'.$db->record[1].'</option>';
! 			$t[notgroups] .= '>'.$db->record[1].'</option>';
  
  		}
***************
*** 69,77 ****
  
  		$db->query("select gid,groupName from lcGroups order by groupName");
! 		while($db->next_record()) {
! 			$t[groups] .= '<option value="'.$db->Record[0].'" ';
! 			$t[notgroups] .= '<option value="'.$db->Record[0].'" ';
! 			$t[groups] .= '>'.$db->Record[1].'</option>';
! 			$t[notgroups] .= '>'.$db->Record[1].'</option>';
  
  		}
--- 69,77 ----
  
  		$db->query("select gid,groupName from lcGroups order by groupName");
! 		while($db->nextRecord()) {
! 			$t[groups] .= '<option value="'.$db->record[0].'" ';
! 			$t[notgroups] .= '<option value="'.$db->record[0].'" ';
! 			$t[groups] .= '>'.$db->record[1].'</option>';
! 			$t[notgroups] .= '>'.$db->record[1].'</option>';
  
  		}

[Logicampus-cvs] logicampus/src/logicreate/services/pm main.lcp, 1.10, 1.11

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/pm/main.lcp,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** main.lcp	11 Feb 2007 22:41:08 -0000	1.10
--- main.lcp	8 Oct 2007 14:31:30 -0000	1.11
***************
*** 23,29 ****
  		$db2 = db::GetHandle();
  		$db->query("select pkey,messageTo from privateMessages where sentReceived = 0 and messageTo like '%_%'");
! 		while($db->next_record()) {
! 			$pkey = $db->Record['pkey'];
! 			$messageTo = $db->Record['messageTo'];
  			$messageTo = str_replace("_",".",$messageTo);
  			$db2->query("update privateMessages set messageTo='$messageTo' where pkey=$pkey");
--- 23,29 ----
  		$db2 = db::GetHandle();
  		$db->query("select pkey,messageTo from privateMessages where sentReceived = 0 and messageTo like '%_%'");
! 		while($db->nextRecord()) {
! 			$pkey = $db->record['pkey'];
! 			$messageTo = $db->record['messageTo'];
  			$messageTo = str_replace("_",".",$messageTo);
  			$db2->query("update privateMessages set messageTo='$messageTo' where pkey=$pkey");
***************
*** 69,73 ****
  			WHERE sentReceived='$viewing' 
  			AND messageTo='".$u->username."'"); 
! 		$count = $db->Record['total'];
  		if ( ( ($max+$start) < $count)  && ($start<$count)) { 
  
--- 69,73 ----
  			WHERE sentReceived='$viewing' 
  			AND messageTo='".$u->username."'"); 
! 		$count = $db->record['total'];
  		if ( ( ($max+$start) < $count)  && ($start<$count)) { 
  
***************
*** 84,89 ****
  			$db->query("select pkey from privateMessages where sentReceived='$viewing' and messageFrom='".$u->username."' order by sentTime DESC limit $start,$max");
  		}
! 		while($db->next_record()) {
! 			$x = privMess::load($db->Record['pkey']);
  			$user = lcUser::getUserByUsername($x->messageFrom);
  			$x->userFrom = $user->username;
--- 84,89 ----
  			$db->query("select pkey from privateMessages where sentReceived='$viewing' and messageFrom='".$u->username."' order by sentTime DESC limit $start,$max");
  		}
! 		while($db->nextRecord()) {
! 			$x = privMess::load($db->record['pkey']);
  			$user = lcUser::getUserByUsername($x->messageFrom);
  			$x->userFrom = $user->username;
***************
*** 167,175 ****
  		$db2 = DB::getHandle();
  		$db->query("select gid, groupName from lcGroups where gid like 'r_%' order by groupName");
! 		while($db->next_record()) { 
! 			extract($db->Record);
  			$db2->query("select username from lcUsers where groups like '%$gid%'");
! 			while($db2->next_record()) {
! 				$username = $db2->Record['username'];
  				$x = lcUser::getUserByUsername($username);
  				$list[$username] = $x->username;
--- 167,175 ----
  		$db2 = DB::getHandle();
  		$db->query("select gid, groupName from lcGroups where gid like 'r_%' order by groupName");
! 		while($db->nextRecord()) { 
! 			extract($db->record);
  			$db2->query("select username from lcUsers where groups like '%$gid%'");
! 			while($db2->nextRecord()) {
! 				$username = $db2->record['username'];
  				$x = lcUser::getUserByUsername($username);
  				$list[$username] = $x->username;
***************
*** 219,223 ****
  		
  		$db->queryOne($sql);
! 		$user_exists = $db->Record['user_exists'];
  
  		$mess = new privMess();
--- 219,223 ----
  		
  		$db->queryOne($sql);
! 		$user_exists = $db->record['user_exists'];
  
  		$mess = new privMess();

[Logicampus-cvs] logicampus/src/logicreate/services/login main.lcp, 1.9, 1.10

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/login/main.lcp,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** main.lcp	15 May 2007 17:27:47 -0000	1.9
--- main.lcp	8 Oct 2007 14:29:09 -0000	1.10
***************
*** 33,41 ****
  
  		$db->query("select * from lcUsers where email = '$email'");		
! 		if ($db->next_record()) {
  			if (USE_MD5_PASSWORDS!=TRUE) { 
! 				$pass = $db->Record['password'];
  			}
! 			$message = "You have requested your account information:\n\nUsername: ".$db->Record['username']."\nPassword: $pass\n-----\n";
  			$message .= "If you require more indepth help, please email ".WEBMASTER_EMAIL."\n\n";
  			$message .= " \n\nPlease visit ".DEFAULT_URL." to log in.";
--- 33,41 ----
  
  		$db->query("select * from lcUsers where email = '$email'");		
! 		if ($db->nextRecord()) {
  			if (USE_MD5_PASSWORDS!=TRUE) { 
! 				$pass = $db->record['password'];
  			}
! 			$message = "You have requested your account information:\n\nUsername: ".$db->record['username']."\nPassword: $pass\n-----\n";
  			$message .= "If you require more indepth help, please email ".WEBMASTER_EMAIL."\n\n";
  			$message .= " \n\nPlease visit ".DEFAULT_URL." to log in.";
***************
*** 103,107 ****
  // mgk 9/2/03 - get last login time
  			$db->queryOne("select last_login from lc_users_last_login where username='".$lcUser->username."'");
! 			if ($db->Record[0]==0) { 
  				$lcUser->sessionvars['first_login'] = true;
  
--- 103,107 ----
  // mgk 9/2/03 - get last login time
  			$db->queryOne("select last_login from lc_users_last_login where username='".$lcUser->username."'");
! 			if ($db->record[0]==0) { 
  				$lcUser->sessionvars['first_login'] = true;
  

[Logicampus-cvs] logicampus/src/logicreate/services/html/admin dialog.lcp, 1.1.1.1, 1.2 edit.lcp, 1.1.1.1, 1.2 main.lcp, 1.1.1.1, 1.2

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

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

Modified Files:
	dialog.lcp edit.lcp main.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: dialog.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/html/admin/dialog.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** dialog.lcp	21 Nov 2003 23:14:11 -0000	1.1.1.1
--- dialog.lcp	8 Oct 2007 14:28:50 -0000	1.2
***************
*** 12,23 ****
  
  		$db->query("select filename,pkey from lcHtml order by filename");
! 		while($db->next_record()) {
  
  
! 		if ( strlen($db->Record['filename']) > 15) {
! 			$db->Record['filename'] = substr($db->Record['filename'],0,14). '...';
  		}
  
! 		$t[files][] = $db->Record;
  		}
  		$t['showDelete'] = $arg->getvars['d'];
--- 12,23 ----
  
  		$db->query("select filename,pkey from lcHtml order by filename");
! 		while($db->nextRecord()) {
  
  
! 		if ( strlen($db->record['filename']) > 15) {
! 			$db->record['filename'] = substr($db->record['filename'],0,14). '...';
  		}
  
! 		$t[files][] = $db->record;
  		}
  		$t['showDelete'] = $arg->getvars['d'];

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/html/admin/main.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** main.lcp	21 Nov 2003 23:14:11 -0000	1.1.1.1
--- main.lcp	8 Oct 2007 14:28:50 -0000	1.2
***************
*** 114,120 ****
  		if ( ! is_array($t['saved']) ) { 
  			$db->query("select count(pkey) from lcHtml");
! 			$db->next_record();
! 			$t['saved']['filename'] = 'document_'.(sprintf("%d",$db->Record[0])+1).'.html'; 
! 			$t['saved']['title'] = 'New Document '.(sprintf("%d",$db->Record[0])+1); 
  
  			if ($arg->getvars['template'] != '' ) {
--- 114,120 ----
  		if ( ! is_array($t['saved']) ) { 
  			$db->query("select count(pkey) from lcHtml");
! 			$db->nextRecord();
! 			$t['saved']['filename'] = 'document_'.(sprintf("%d",$db->record[0])+1).'.html'; 
! 			$t['saved']['title'] = 'New Document '.(sprintf("%d",$db->record[0])+1); 
  
  			if ($arg->getvars['template'] != '' ) {
***************
*** 131,136 ****
  	function addSharingRun( &$db, &$u, &$arg, &$t) {
  		$db->query("select * from lcGroups");
! 		while ( $db->next_record() ) {
! 			$gs[$db->Record['gid']] = $db->Record['groupName'];
  		}
  		$t['groupOpts'] = makeOptions($gs,$t['saved']['groups']);
--- 131,136 ----
  	function addSharingRun( &$db, &$u, &$arg, &$t) {
  		$db->query("select * from lcGroups");
! 		while ( $db->nextRecord() ) {
! 			$gs[$db->record['gid']] = $db->record['groupName'];
  		}
  		$t['groupOpts'] = makeOptions($gs,$t['saved']['groups']);

Index: edit.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/html/admin/edit.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** edit.lcp	21 Nov 2003 23:14:11 -0000	1.1.1.1
--- edit.lcp	8 Oct 2007 14:28:50 -0000	1.2
***************
*** 114,119 ****
  	function addSharingRun( &$db, &$u, &$arg, &$t) {
  		$db->query("select * from lcGroups");
! 		while ( $db->next_record() ) {
! 			$gs[$db->Record['gid']] = $db->Record['groupName'];
  		}
  		$t['groupOpts'] = makeOptions($gs,$t['saved']['groups']);
--- 114,119 ----
  	function addSharingRun( &$db, &$u, &$arg, &$t) {
  		$db->query("select * from lcGroups");
! 		while ( $db->nextRecord() ) {
! 			$gs[$db->record['gid']] = $db->record['groupName'];
  		}
  		$t['groupOpts'] = makeOptions($gs,$t['saved']['groups']);

[Logicampus-cvs] logicampus/src/logicreate/services/html main.lcp, 1.3, 1.4

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/html/main.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** main.lcp	18 Nov 2006 00:09:35 -0000	1.3
--- main.lcp	8 Oct 2007 14:28:50 -0000	1.4
***************
*** 23,35 ****
  		$db->queryOne("select * from lcHtml where filename='$file'  $where");
  
! 		if ($db->Record["filename"]) {
  
! 			$t["title"] = $db->Record["title"];
! 			$t["_author"] = $db->Record["author"];
! 			$t["_description"] = $db->Record["description"];
!                         $t["_keywords"] = $db->Record["keywords"];
!                         $t["_other"] = $db->Record["other"];
  
! 			$lcObj->templateName = $db->Record[filename];
  		} else {
  			$this->presentor = "errorMessage";
--- 23,35 ----
  		$db->queryOne("select * from lcHtml where filename='$file'  $where");
  
! 		if ($db->record["filename"]) {
  
! 			$t["title"] = $db->record["title"];
! 			$t["_author"] = $db->record["author"];
! 			$t["_description"] = $db->record["description"];
!                         $t["_keywords"] = $db->record["keywords"];
!                         $t["_other"] = $db->record["other"];
  
! 			$lcObj->templateName = $db->record[filename];
  		} else {
  			$this->presentor = "errorMessage";

[Logicampus-cvs] logicampus/src/logicreate/services/helpdesk faq.lcp, 1.3, 1.4 hdCategory.lcp, 1.1.1.1, 1.2 helpdeskSubmit.lcp, 1.9, 1.10 helpdeskView.lcp, 1.3, 1.4 history.lcp, 1.2, 1.3 main.lcp, 1.8, 1.9

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

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

Modified Files:
	faq.lcp hdCategory.lcp helpdeskSubmit.lcp helpdeskView.lcp 
	history.lcp main.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: helpdeskView.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/helpdesk/helpdeskView.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** helpdeskView.lcp	18 Nov 2006 00:09:35 -0000	1.3
--- helpdeskView.lcp	8 Oct 2007 14:28:31 -0000	1.4
***************
*** 50,55 ****
  			// get a list of technicians
  			$db->query("select * from lcUsers where groups like '%hdstaff%' or groups like '%|admin|%' or groups like '%|hdadmin|%'");
! 			while($db->next_record()) {
! 				$list[$db->Record['username']] = $db->Record['username'];
  			}
  			$t['techs'] = makeOptions($list);
--- 50,55 ----
  			// get a list of technicians
  			$db->query("select * from lcUsers where groups like '%hdstaff%' or groups like '%|admin|%' or groups like '%|hdadmin|%'");
! 			while($db->nextRecord()) {
! 				$list[$db->record['username']] = $db->record['username'];
  			}
  			$t['techs'] = makeOptions($list);
***************
*** 69,73 ****
  			where helpdesk_id=$id and userid='".$u->profile->get('username'). '\'');
  		}
! 		$t['hd'] = $db->Record;
  		
  		$j = HelpdeskCategory::loadAll();
--- 69,73 ----
  			where helpdesk_id=$id and userid='".$u->profile->get('username'). '\'');
  		}
! 		$t['hd'] = $db->record;
  		
  		$j = HelpdeskCategory::loadAll();
***************
*** 85,93 ****
  
  		// if we got a record back then we had permission to view it.
! 		if ($db->Record) { 
  			$u->sessionvars['helpdesk_id'] = $id;
  			$db->query("select * from helpdesk_incident_log where helpdesk_id=$id");
! 			while($db->next_record()) {
! 				$t['log'][] = $db->Record;
  			}
  		}
--- 85,93 ----
  
  		// if we got a record back then we had permission to view it.
! 		if ($db->record) { 
  			$u->sessionvars['helpdesk_id'] = $id;
  			$db->query("select * from helpdesk_incident_log where helpdesk_id=$id");
! 			while($db->nextRecord()) {
! 				$t['log'][] = $db->record;
  			}
  		}

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/helpdesk/main.lcp,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** main.lcp	18 Nov 2006 00:09:35 -0000	1.8
--- main.lcp	8 Oct 2007 14:28:31 -0000	1.9
***************
*** 49,54 ****
  		$t['categories'][0] = '<i>uncategorized</i>';
  		$db->query("select * from helpdesk_categories");
! 		while($db->next_record()) {
! 			$t['categories'][$db->Record['helpdesk_category_id']] = $db->Record['helpdesk_category_label'];
  		}
  				
--- 49,54 ----
  		$t['categories'][0] = '<i>uncategorized</i>';
  		$db->query("select * from helpdesk_categories");
! 		while($db->nextRecord()) {
! 			$t['categories'][$db->record['helpdesk_category_id']] = $db->record['helpdesk_category_label'];
  		}
  				
***************
*** 82,87 ****
  		
  		$db->query($sql);
! 		while($db->next_record()) 
! 		{	$t['open'][] =$db->Record;
  		}
  		
--- 82,87 ----
  		
  		$db->query($sql);
! 		while($db->nextRecord()) 
! 		{	$t['open'][] =$db->record;
  		}
  		
***************
*** 102,107 ****
  		
  		$db->query($sql);
! 		while($db->next_record()) 
! 		{	$t['closed'][] =$db->Record;
  		}
  		
--- 102,107 ----
  		
  		$db->query($sql);
! 		while($db->nextRecord()) 
! 		{	$t['closed'][] =$db->record;
  		}
  		
***************
*** 126,131 ****
  		// get a list of statuses
  		$db->query("select * from helpdesk_status");
! 		while($db->next_record()) {
! 			$t['status'][$db->Record[0]] = $db->Record['helpdesk_status_label'];
  		}		
  
--- 126,131 ----
  		// get a list of statuses
  		$db->query("select * from helpdesk_status");
! 		while($db->nextRecord()) {
! 			$t['status'][$db->record[0]] = $db->record['helpdesk_status_label'];
  		}		
  
***************
*** 225,236 ****
  		
  		$db->query("select * from helpdesk_status");
! 		while($db->next_record()) {
! 			$t['status'][$db->Record[0]] = $db->Record['helpdesk_status_label'];
  		}	
  		
  		// get a list of categories
  		$db->query("select * from helpdesk_categories");
! 		while($db->next_record()) {
! 			$t['categories'][$db->Record[0]] = $db->Record['helpdesk_category_label'];
  		}
  		
--- 225,236 ----
  		
  		$db->query("select * from helpdesk_status");
! 		while($db->nextRecord()) {
! 			$t['status'][$db->record[0]] = $db->record['helpdesk_status_label'];
  		}	
  		
  		// get a list of categories
  		$db->query("select * from helpdesk_categories");
! 		while($db->nextRecord()) {
! 			$t['categories'][$db->record[0]] = $db->record['helpdesk_category_label'];
  		}
  		

Index: helpdeskSubmit.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/helpdesk/helpdeskSubmit.lcp,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** helpdeskSubmit.lcp	18 Nov 2006 00:09:35 -0000	1.9
--- helpdeskSubmit.lcp	8 Oct 2007 14:28:31 -0000	1.10
***************
*** 203,207 ****
  				// should be cleaner code or integrated with something else
  				$db->queryOne("select email from lcUsers where username='".$arg->postvars['reassign']."'");
! 				$email = $db->Record[0];
  				if (trim($email)!='') {
  					mail($email, "Helpdesk task #$id",
--- 203,207 ----
  				// should be cleaner code or integrated with something else
  				$db->queryOne("select email from lcUsers where username='".$arg->postvars['reassign']."'");
! 				$email = $db->record[0];
  				if (trim($email)!='') {
  					mail($email, "Helpdesk task #$id",
***************
*** 244,248 ****
  			where helpdesk_status_id = '.$incident->status);
  
! 		$statusLabel = ($db->Record[0]) ? $db->Record[0]:'N/A';
  
  		$newStatus = $incident->status;
--- 244,248 ----
  			where helpdesk_status_id = '.$incident->status);
  
! 		$statusLabel = ($db->record[0]) ? $db->record[0]:'N/A';
  
  		$newStatus = $incident->status;

Index: history.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/helpdesk/history.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** history.lcp	18 Nov 2006 00:09:35 -0000	1.2
--- history.lcp	8 Oct 2007 14:28:31 -0000	1.3
***************
*** 59,64 ****
  // get the login attempt stuff - would have been nicer with PBDO version
  		$db->query("select * from lc_users_login_attempt where username='".$lc->getvars['username']."'");
! 		while($db->next_record()) {
! 			$t['history'][] = $db->Record;
  		}
  
--- 59,64 ----
  // get the login attempt stuff - would have been nicer with PBDO version
  		$db->query("select * from lc_users_login_attempt where username='".$lc->getvars['username']."'");
! 		while($db->nextRecord()) {
! 			$t['history'][] = $db->record;
  		}
  

Index: hdCategory.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/helpdesk/hdCategory.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** hdCategory.lcp	21 Nov 2003 23:14:11 -0000	1.1.1.1
--- hdCategory.lcp	8 Oct 2007 14:28:31 -0000	1.2
***************
*** 45,49 ****
  		$sql = 'SELECT COUNT(*) category_exists FROM helpdesk_categories WHERE helpdesk_category_label=\''.$arg->postvars['label'].'\'';
  		$db->queryOne($sql);
! 		if ($db->Record['category_exists'])
  		{
  			$this->presentor = "redirectPresentation";
--- 45,49 ----
  		$sql = 'SELECT COUNT(*) category_exists FROM helpdesk_categories WHERE helpdesk_category_label=\''.$arg->postvars['label'].'\'';
  		$db->queryOne($sql);
! 		if ($db->record['category_exists'])
  		{
  			$this->presentor = "redirectPresentation";

Index: faq.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/helpdesk/faq.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** faq.lcp	18 Nov 2006 00:09:35 -0000	1.3
--- faq.lcp	8 Oct 2007 14:28:31 -0000	1.4
***************
*** 208,213 ****
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			
! 			while ($db->next_record())
! 			{	$a_faq[] = $db->Record;
  			}
  		}
--- 208,213 ----
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			
! 			while ($db->nextRecord())
! 			{	$a_faq[] = $db->record;
  			}
  		}
***************
*** 232,237 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		
! 		while ($db->next_record())
! 		{	$a_faq_categoryless[] = $db->Record;
  		}
  		
--- 232,237 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		
! 		while ($db->nextRecord())
! 		{	$a_faq_categoryless[] = $db->record;
  		}
  		
***************
*** 255,260 ****
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			
! 			while ($db->next_record())
! 			{	$a_faq_notapproved[] = $db->Record;
  			}
  			
--- 255,260 ----
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			
! 			while ($db->nextRecord())
! 			{	$a_faq_notapproved[] = $db->record;
  			}
  			
***************
*** 303,308 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		
! 		while ($db->next_record())
! 		{	$a_question[] = $db->Record;
  		}
  		
--- 303,308 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		
! 		while ($db->nextRecord())
! 		{	$a_question[] = $db->record;
  		}
  		
***************
*** 367,373 ****
  		 *	Determining if we found a faq or not
  		 */	
! 		if ((int)$db->Record['id_faq'] > 0)
  		{
! 			$t['a_answer'] = $db->Record;
  		
  			/**
--- 367,373 ----
  		 *	Determining if we found a faq or not
  		 */	
! 		if ((int)$db->record['id_faq'] > 0)
  		{
! 			$t['a_answer'] = $db->record;
  		
  			/**
***************
*** 383,387 ****
  			$db->queryOne($sql);
  			
! 			$t['a_answer']['has_user_voted'] = $db->Record['has_user_voted'];
  			
  			// see if we should show a rating (this may be converted to allow anyone to see the rating)
--- 383,387 ----
  			$db->queryOne($sql);
  			
! 			$t['a_answer']['has_user_voted'] = $db->record['has_user_voted'];
  			
  			// see if we should show a rating (this may be converted to allow anyone to see the rating)
***************
*** 398,403 ****
  				$db->RESULT_TYPE = MYSQL_ASSOC;
  				$db->queryOne($sql);
! 				$t['a_answer']['users_voted'] = $db->Record['users_voted'];
! 				$t['a_answer']['user_vote_average'] = ceil($db->Record['user_vote_average']);
  
  			} else 
--- 398,403 ----
  				$db->RESULT_TYPE = MYSQL_ASSOC;
  				$db->queryOne($sql);
! 				$t['a_answer']['users_voted'] = $db->record['users_voted'];
! 				$t['a_answer']['user_vote_average'] = ceil($db->record['user_vote_average']);
  
  			} else 
***************
*** 466,470 ****
  		$db->queryOne($sql);
  		
! 		if ($db->Record['has_user_voted'])
  		{	
  			echo 'You\'ve voted before!';
--- 466,470 ----
  		$db->queryOne($sql);
  		
! 		if ($db->record['has_user_voted'])
  		{	
  			echo 'You\'ve voted before!';
***************
*** 486,490 ****
  				$db->queryOne($sql);
  				
! 				if ($db->Record['fl_approved'])
  				{
  					// Submitting the vote
--- 486,490 ----
  				$db->queryOne($sql);
  				
! 				if ($db->record['fl_approved'])
  				{
  					// Submitting the vote
***************
*** 607,611 ****
  		$db->queryOne($sql);
  		
! 		$faq = $db->Record;
  						
  		// check if we found the thing
--- 607,611 ----
  		$db->queryOne($sql);
  		
! 		$faq = $db->record;
  						
  		// check if we found the thing
***************
*** 621,626 ****
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			$db->queryOne($sql);
! 			$faq['votes_total'] = $db->Record['votes_total'];
! 			$faq['votes_average'] = ceil($db->Record['votes_average']);
  
  		
--- 621,626 ----
  			$db->RESULT_TYPE = MYSQL_ASSOC;
  			$db->queryOne($sql);
! 			$faq['votes_total'] = $db->record['votes_total'];
! 			$faq['votes_average'] = ceil($db->record['votes_average']);
  
  		
***************
*** 640,645 ****
  		$db->query($sql);
  		
! 		while ($db->next_record())
! 		{	$a_category[$db->Record['id_faq_category']] = $db->Record['tx_category'];
  		}
  
--- 640,645 ----
  		$db->query($sql);
  		
! 		while ($db->nextRecord())
! 		{	$a_category[$db->record['id_faq_category']] = $db->record['tx_category'];
  		}
  
***************
*** 856,862 ****
  		$db->query($sql);
  		
! 		while ($db->next_record())
! 		{	$a_category[$db->Record['id_faq_category']] = $db->Record['tx_category'];
! 			$t['category_faq_count'][$db->Record['id_faq_category']] = $db->Record['faq_count'];
  		}
  		
--- 856,862 ----
  		$db->query($sql);
  		
! 		while ($db->nextRecord())
! 		{	$a_category[$db->record['id_faq_category']] = $db->record['tx_category'];
! 			$t['category_faq_count'][$db->record['id_faq_category']] = $db->record['faq_count'];
  		}
  		
***************
*** 905,910 ****
  				$db->RESULT_TYPE = MYSQL_ASSOC;
  				
! 				while ($db->next_record())
! 				{	$a_results[] = $db->Record;
  				}
  				
--- 905,910 ----
  				$db->RESULT_TYPE = MYSQL_ASSOC;
  				
! 				while ($db->nextRecord())
! 				{	$a_results[] = $db->record;
  				}
  				

[Logicampus-cvs] logicampus/src/logicreate/services/gradebook assessment.lcp, 1.6, 1.7 category.lcp, 1.9, 1.10 entry.lcp, 1.10, 1.11 gradesbystudent.lcp, 1.6, 1.7 main.lcp, 1.9, 1.10 report.lcp, 1.10, 1.11

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

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

Modified Files:
	assessment.lcp category.lcp entry.lcp gradesbystudent.lcp 
	main.lcp report.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: report.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/gradebook/report.lcp,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** report.lcp	13 Feb 2007 01:57:57 -0000	1.10
--- report.lcp	8 Oct 2007 14:28:07 -0000	1.11
***************
*** 57,61 ****
  		$sql = "select sectionNumbers from classes where id_classes=$c";
  		$db->queryOne($sql);
! 		$s = explode("\n",$db->Record['sectionNumbers']);
  		$t['sections'] = $s;
  	}
--- 57,61 ----
  		$sql = "select sectionNumbers from classes where id_classes=$c";
  		$db->queryOne($sql);
! 		$s = explode("\n",$db->record['sectionNumbers']);
  		$t['sections'] = $s;
  	}

Index: gradesbystudent.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/gradebook/gradesbystudent.lcp,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** gradesbystudent.lcp	13 Feb 2007 01:57:57 -0000	1.6
--- gradesbystudent.lcp	8 Oct 2007 14:28:07 -0000	1.7
***************
*** 106,114 ****
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->next_record() ) {
! 			if ($lc->getvars['user'] == $db->Record['username']) {
! 				$usersScore = $db->Record['score'];
  			}
! 			$scores[$db->Record['username']] = $db->Record['score'];
  		}
  		foreach ($scores as $username => $score) {
--- 106,114 ----
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->nextRecord() ) {
! 			if ($lc->getvars['user'] == $db->record['username']) {
! 				$usersScore = $db->record['score'];
  			}
! 			$scores[$db->record['username']] = $db->record['score'];
  		}
  		foreach ($scores as $username => $score) {

Index: category.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/gradebook/category.lcp,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** category.lcp	26 Jan 2007 03:13:44 -0000	1.9
--- category.lcp	8 Oct 2007 14:28:07 -0000	1.10
***************
*** 177,181 ****
  			$db->queryOne('select calculation_type from class_gradebook
  				where id_classes="'.$u->activeClassTaught->id_classes.'"');
! 			if ($db->Record['calculation_type'] == 1) { // weighted
  
  				$sql = "SELECT SUM(weight) as sumweight FROM class_gradebook_categories
--- 177,181 ----
  			$db->queryOne('select calculation_type from class_gradebook
  				where id_classes="'.$u->activeClassTaught->id_classes.'"');
! 			if ($db->record['calculation_type'] == 1) { // weighted
  
  				$sql = "SELECT SUM(weight) as sumweight FROM class_gradebook_categories
***************
*** 184,189 ****
  				$db->queryOne($sql);
  
! 				if ( ($db->Record['sumweight'] + $gbCat->weight) > 100 ) {
! 					$t['error'] = 'Your current total of percentages is <b>'.$db->Record['sumweight'].'%</b>.  If we add another <b>'.$gbCat->weight.'%</b> as you requested, the total of these weights will be greater than 100%.  Please double check your calculation, or adjust another category.';
  					if ( $lc->getvars['event'] == 'edit' ) $this->editRun($db,$u,$lc,$t);
  					else $this->addRun($db,$u,$lc,$t);
--- 184,189 ----
  				$db->queryOne($sql);
  
! 				if ( ($db->record['sumweight'] + $gbCat->weight) > 100 ) {
! 					$t['error'] = 'Your current total of percentages is <b>'.$db->record['sumweight'].'%</b>.  If we add another <b>'.$gbCat->weight.'%</b> as you requested, the total of these weights will be greater than 100%.  Please double check your calculation, or adjust another category.';
  					if ( $lc->getvars['event'] == 'edit' ) $this->editRun($db,$u,$lc,$t);
  					else $this->addRun($db,$u,$lc,$t);

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/gradebook/main.lcp,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** main.lcp	13 Feb 2007 01:57:57 -0000	1.9
--- main.lcp	8 Oct 2007 14:28:07 -0000	1.10
***************
*** 88,92 ****
  		$db->queryOne('select semesterTerm, semesterYear from semesters
  			where id_semesters='.$u->activeClassTaught->id_semesters);
! 		$t['semester'] = $db->Record['semesterTerm'].' '.$db->Record['semesterYear'];
  
  		// stupid hack to get a feedback message
--- 88,92 ----
  		$db->queryOne('select semesterTerm, semesterYear from semesters
  			where id_semesters='.$u->activeClassTaught->id_semesters);
! 		$t['semester'] = $db->record['semesterTerm'].' '.$db->record['semesterYear'];
  
  		// stupid hack to get a feedback message

Index: assessment.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/gradebook/assessment.lcp,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** assessment.lcp	15 Jan 2007 04:14:37 -0000	1.6
--- assessment.lcp	8 Oct 2007 14:28:07 -0000	1.7
***************
*** 106,110 ****
  			WHERE id_classes = '.$u->activeClassTaught->id_classes.'
  			AND id_class_gradebook_entries = '.$lc->postvars['entryid']);
! 			if( !$db->next_record() ) {
  				$this->presentor = 'errorMessage';
  				$t['message'] = "You don't own this gradebook entry.";
--- 106,110 ----
  			WHERE id_classes = '.$u->activeClassTaught->id_classes.'
  			AND id_class_gradebook_entries = '.$lc->postvars['entryid']);
! 			if( !$db->nextRecord() ) {
  				$this->presentor = 'errorMessage';
  				$t['message'] = "You don't own this gradebook entry.";

Index: entry.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/gradebook/entry.lcp,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** entry.lcp	3 Oct 2007 20:26:00 -0000	1.10
--- entry.lcp	8 Oct 2007 14:28:07 -0000	1.11
***************
*** 123,127 ****
  			$db->queryOne('select count(id_class_gradebook_categories) as cnt from class_gradebook_categories
  				where id_classes="'.$u->activeClassTaught->id_classes.'"');
! 			if ($db->Record['cnt'] == 0) {
  				$this->presentor = 'errorMessage';
  				$t['message'] = 'You must first create a <a href="'
--- 123,127 ----
  			$db->queryOne('select count(id_class_gradebook_categories) as cnt from class_gradebook_categories
  				where id_classes="'.$u->activeClassTaught->id_classes.'"');
! 			if ($db->record['cnt'] == 0) {
  				$this->presentor = 'errorMessage';
  				$t['message'] = 'You must first create a <a href="'
***************
*** 383,388 ****
  			$t['user'] = array(
  				'username' => $user,
! 				'firstname' => $db->Record['firstname'],
! 				'lastname' => $db->Record['lastname']
  			);
  
--- 383,388 ----
  			$t['user'] = array(
  				'username' => $user,
! 				'firstname' => $db->record['firstname'],
! 				'lastname' => $db->record['lastname']
  			);
  

[Logicampus-cvs] logicampus/src/logicreate/services/forum LC_forum.php, 1.2, 1.3 LC_object.php, 1.1.1.1, 1.2 LcForum.php, 1.6, 1.7 LcForumPost.php, 1.5, 1.6

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

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

Modified Files:
	LC_forum.php LC_object.php LcForum.php LcForumPost.php 
Log Message:
Change function "next_record" to "nextRecord".

Index: LcForumPost.php
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/LcForumPost.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** LcForumPost.php	11 Feb 2007 05:31:20 -0000	1.5
--- LcForumPost.php	8 Oct 2007 14:26:49 -0000	1.6
***************
*** 299,303 ****
  			WHERE (lc_forum_post_thread_id=".$this->lcForumPostId . ") 
  			AND (lc_forum_post_status=0 or lc_forum_post_status IS NULL)");
!                 $this->lcForumReplyCount= $db->Record[0];
  
                  $db->queryOne("select max(lc_forum_post_id) as foo 
--- 299,303 ----
  			WHERE (lc_forum_post_thread_id=".$this->lcForumPostId . ") 
  			AND (lc_forum_post_status=0 or lc_forum_post_status IS NULL)");
!                 $this->lcForumReplyCount= $db->record[0];
  
                  $db->queryOne("select max(lc_forum_post_id) as foo 
***************
*** 305,309 ****
  			WHERE (lc_forum_post_id=".$this->lcForumPostId." or lc_forum_post_thread_id=".$this->lcForumPostId.") 
  			AND (lc_forum_post_status=0 or lc_forum_post_status IS NULL)");
!                 $max = sprintf('%d',$db->Record['foo']);
  
                  $db->queryOne("select * 
--- 305,309 ----
  			WHERE (lc_forum_post_id=".$this->lcForumPostId." or lc_forum_post_thread_id=".$this->lcForumPostId.") 
  			AND (lc_forum_post_status=0 or lc_forum_post_status IS NULL)");
!                 $max = sprintf('%d',$db->record['foo']);
  
                  $db->queryOne("select * 
***************
*** 311,316 ****
  			WHERE lc_forum_post_id=$max 
  			AND (lc_forum_post_status=0 or lc_forum_post_status IS NULL)");
!                 $this->lcForumRecentPostTimedate= $db->Record['lc_forum_post_timedate'];
!                 $this->lcForumRecentPoster = $db->Record['lc_forum_post_username'];
                  $this->lcForumRecentPostId = $max;
                  $this->save();  
--- 311,316 ----
  			WHERE lc_forum_post_id=$max 
  			AND (lc_forum_post_status=0 or lc_forum_post_status IS NULL)");
!                 $this->lcForumRecentPostTimedate= $db->record['lc_forum_post_timedate'];
!                 $this->lcForumRecentPoster = $db->record['lc_forum_post_username'];
                  $this->lcForumRecentPostId = $max;
                  $this->save();  

Index: LcForum.php
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/LcForum.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** LcForum.php	11 Feb 2007 05:31:20 -0000	1.6
--- LcForum.php	8 Oct 2007 14:26:49 -0000	1.7
***************
*** 373,377 ****
  			WHERE lc_forum_id=".$forumId." 
  			AND  (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $this->lcForumPostCount = $db->Record[0];
  
                  $db->queryOne("SELECT count(lc_forum_post_id) 
--- 373,377 ----
  			WHERE lc_forum_id=".$forumId." 
  			AND  (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $this->lcForumPostCount = $db->record[0];
  
                  $db->queryOne("SELECT count(lc_forum_post_id) 
***************
*** 380,384 ****
  			AND lc_forum_post_parent_id=0 
  			AND (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $this->lcForumThreadCount = $db->Record[0];
  
                  $db->queryOne("SELECT max(lc_forum_post_id) 
--- 380,384 ----
  			AND lc_forum_post_parent_id=0 
  			AND (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $this->lcForumThreadCount = $db->record[0];
  
                  $db->queryOne("SELECT max(lc_forum_post_id) 
***************
*** 386,390 ****
  			WHERE lc_forum_id=".$forumId. " 
  			AND (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $max = sprintf('%d',$db->Record[0]);
  
                  $db->queryOne("SELECT * 
--- 386,390 ----
  			WHERE lc_forum_id=".$forumId. " 
  			AND (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $max = sprintf('%d',$db->record[0]);
  
                  $db->queryOne("SELECT * 
***************
*** 392,397 ****
  			WHERE lc_forum_post_id=$max 
  			AND (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $this->lcForumRecentPostTimedate= $db->Record['lc_forum_post_timedate'];
!                 $this->lcForumRecentPoster = $db->Record['lc_forum_post_username'];
                  $this->lcForumRecentPostId = $max;
                  $this->save();  
--- 392,397 ----
  			WHERE lc_forum_post_id=$max 
  			AND (lc_forum_post_status=0 OR lc_forum_post_status IS NULL)");
!                 $this->lcForumRecentPostTimedate= $db->record['lc_forum_post_timedate'];
!                 $this->lcForumRecentPoster = $db->record['lc_forum_post_username'];
                  $this->lcForumRecentPostId = $max;
                  $this->save();  

Index: LC_object.php
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/LC_object.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** LC_object.php	21 Nov 2003 23:14:09 -0000	1.1.1.1
--- LC_object.php	8 Oct 2007 14:26:49 -0000	1.2
***************
*** 22,27 ****
                  $db->query($sql);
  
!                 while($db->next_record()) {
!                         arrayIntoObject($this,$db->Record);
                  }
          }
--- 22,27 ----
                  $db->query($sql);
  
!                 while($db->nextRecord()) {
!                         arrayIntoObject($this,$db->record);
                  }
          }
***************
*** 40,45 ****
  
  
!                 while($db->next_record()) {
!                         $idarray[] = $db->Record;
                  }
                  $this->_Array = $idarray;
--- 40,45 ----
  
  
!                 while($db->nextRecord()) {
!                         $idarray[] = $db->record;
                  }
                  $this->_Array = $idarray;
***************
*** 51,56 ****
                  $sql = "select pkey,".$this->_name." from ".$this->_tableName." where  ".$this->_tablePrefix."username = '$username' $o";
                  $db->query($sql);
!                 while($db->next_record()) {
!                         $idarray[$db->Record[0]] = $db->Record[1];
                  }
                  $this->_Array = $idarray;
--- 51,56 ----
                  $sql = "select pkey,".$this->_name." from ".$this->_tableName." where  ".$this->_tablePrefix."username = '$username' $o";
                  $db->query($sql);
!                 while($db->nextRecord()) {
!                         $idarray[$db->record[0]] = $db->record[1];
                  }
                  $this->_Array = $idarray;
***************
*** 62,67 ****
                  $sql = "select pkey,".$this->_name." from ".$this->_tableName." where  schoolID = '$schoolID' $o";
                  $db->query($sql);
!                 while($db->next_record()) {
!                         $idarray[$db->Record[0]] = $db->Record[1];
                  }
  
--- 62,67 ----
                  $sql = "select pkey,".$this->_name." from ".$this->_tableName." where  schoolID = '$schoolID' $o";
                  $db->query($sql);
!                 while($db->nextRecord()) {
!                         $idarray[$db->record[0]] = $db->record[1];
                  }
  
***************
*** 80,85 ****
                  $db->query($sql);
  
!                 while($db->next_record()) {
!                         $idarray[] = $db->Record;
                  }
                  $this->_Array = $idarray;
--- 80,85 ----
                  $db->query($sql);
  
!                 while($db->nextRecord()) {
!                         $idarray[] = $db->record;
                  }
                  $this->_Array = $idarray;
***************
*** 97,102 ****
                  $sql = $this->_getAllSQL." $where ".$this->_extrawhere." $o";
                  $db->query($sql);
!                 while($db->next_record()) {
!                         $idarray[] = $db->Record;
                  }
                  $this->_Array = $idarray;
--- 97,102 ----
                  $sql = $this->_getAllSQL." $where ".$this->_extrawhere." $o";
                  $db->query($sql);
!                 while($db->nextRecord()) {
!                         $idarray[] = $db->record;
                  }
                  $this->_Array = $idarray;

Index: LC_forum.php
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/LC_forum.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** LC_forum.php	11 Feb 2007 05:31:20 -0000	1.2
--- LC_forum.php	8 Oct 2007 14:26:49 -0000	1.3
***************
*** 28,32 ****
  		$fid = $this->fid;
  		$db->queryOne("select count(fid) AS total from forumPerms where perm='$perm' and fid='$fid' and (groups='$g')");
! 		$x = $db->Record['total'];
  		unset($db);
  		if ($x>0) { return true; } else { return false; }
--- 28,32 ----
  		$fid = $this->fid;
  		$db->queryOne("select count(fid) AS total from forumPerms where perm='$perm' and fid='$fid' and (groups='$g')");
! 		$x = $db->record['total'];
  		unset($db);
  		if ($x>0) { return true; } else { return false; }
***************
*** 40,44 ****
  		$sql = "select * from forumPrefs where username = '$username' and pref_key = 'sendEmail' and pref_val = '".$this->fid."'";
  		$db->query($sql);
! 		if ($db->next_record() ) {
  			return true;
  		} else {
--- 40,44 ----
  		$sql = "select * from forumPrefs where username = '$username' and pref_key = 'sendEmail' and pref_val = '".$this->fid."'";
  		$db->query($sql);
! 		if ($db->nextRecord() ) {
  			return true;
  		} else {
***************
*** 52,56 ****
  		if (!$fid) { $fid = $this->fid; }
  		$db->queryOne("select * from forums where fid='$fid'");
! 		$j = $db->Record;
  		unset($db);
  		return $j;
--- 52,56 ----
  		if (!$fid) { $fid = $this->fid; }
  		$db->queryOne("select * from forums where fid='$fid'");
! 		$j = $db->record;
  		unset($db);
  		return $j;
***************
*** 66,77 ****
  	function getmessage($db,$sql) {
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			$message = $db->Record["message"];
! 			$body = $db->Record["body"];
! 			$pkey = $db->Record["pkey"];
! 			$timedate = date("m/d/Y h:i:s A",$db->Record["stamptime"]);
! 			$parent = $db->Record["parent"];
! 			$fid = $db->Record["fid"];
! 			$username = $db->Record["username"];
  			if (!$username) { $username="Anonymous"; }
  			$messageshow .= "<h2>$message</h2>\n";
--- 66,77 ----
  	function getmessage($db,$sql) {
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			$message = $db->record["message"];
! 			$body = $db->record["body"];
! 			$pkey = $db->record["pkey"];
! 			$timedate = date("m/d/Y h:i:s A",$db->record["stamptime"]);
! 			$parent = $db->record["parent"];
! 			$fid = $db->record["fid"];
! 			$username = $db->record["username"];
  			if (!$username) { $username="Anonymous"; }
  			$messageshow .= "<h2>$message</h2>\n";
***************
*** 90,95 ****
  		$sql = "select forumname,fid,forumdesc from forums $where";
  		$db->query($sql);
! 		while ($db->next_record()) {
! 			extract($db->Record);
  			$this->forumList["forumid"][] = $fid;
  			$this->forumList["forumname"][] = $forumname;
--- 90,95 ----
  		$sql = "select forumname,fid,forumdesc from forums $where";
  		$db->query($sql);
! 		while ($db->nextRecord()) {
! 			extract($db->record);
  			$this->forumList["forumid"][] = $fid;
  			$this->forumList["forumname"][] = $forumname;
***************
*** 116,132 ****
  		$sql = "select * from forums where fid = '$fid'";
  		$db->query($sql);
! 		while($db->next_record()) {
  			$sql = "select count(pkey) AS total from forumPosts where fid='$fid' and status<>'y'";
  			$db2->query($sql);
! 			$db2->next_record();
! 			$count = intval($db2->Record['total']);
  			$this->off = $count;
! 			$this->forumname = $db->Record["forumname"];
! 			$this->forumdesc = $db->Record["forumdesc"];
! 			$this->forumemail = $db->Record["email"];
! 			$this->uploadmaxk = $db->Record["uploadmaxk"];
! 			$this->uploadcount = $db->Record["uploadcount"];
! 			$this->defaultstatus = $db->Record["defaultstatus"];
! 			$this->groups = explode("|",$db->Record["groups"]);
  		}
  	}
--- 116,132 ----
  		$sql = "select * from forums where fid = '$fid'";
  		$db->query($sql);
! 		while($db->nextRecord()) {
  			$sql = "select count(pkey) AS total from forumPosts where fid='$fid' and status<>'y'";
  			$db2->query($sql);
! 			$db2->nextRecord();
! 			$count = intval($db2->record['total']);
  			$this->off = $count;
! 			$this->forumname = $db->record["forumname"];
! 			$this->forumdesc = $db->record["forumdesc"];
! 			$this->forumemail = $db->record["email"];
! 			$this->uploadmaxk = $db->record["uploadmaxk"];
! 			$this->uploadcount = $db->record["uploadcount"];
! 			$this->defaultstatus = $db->record["defaultstatus"];
! 			$this->groups = explode("|",$db->record["groups"]);
  		}
  	}
***************
*** 136,141 ****
  		$sql = "select count(fid) AS total from forums where fid='".$this->fid."'";
  		$db->query($sql);
! 		$db->next_record();
! 		$count = intval($db->Record['total']);
  		if ($count>0) {
  			return false;
--- 136,141 ----
  		$sql = "select count(fid) AS total from forums where fid='".$this->fid."'";
  		$db->query($sql);
! 		$db->nextRecord();
! 		$count = intval($db->record['total']);
  		if ($count>0) {
  			return false;
***************
*** 163,167 ****
          $sql = "select count(fid) existance_count from forums where fid='".$this->fid."'";
  		$db->queryOne($sql);
!         if ((int)$db->Record['existance_count'] > 0)
          {
              $sql = '
--- 163,167 ----
          $sql = "select count(fid) existance_count from forums where fid='".$this->fid."'";
  		$db->queryOne($sql);
!         if ((int)$db->record['existance_count'] > 0)
          {
              $sql = '
***************
*** 207,212 ****
  		}
  		$db->query("select pkey from forumPosts where stamptime = $stamp and username='".$this->username."' and body='".$this->body."'");
! 		$db->next_record();
! 		$this->messageid = $db->Record['pkey'];
  	}
  
--- 207,212 ----
  		}
  		$db->query("select pkey from forumPosts where stamptime = $stamp and username='".$this->username."' and body='".$this->body."'");
! 		$db->nextRecord();
! 		$this->messageid = $db->record['pkey'];
  	}
  
***************
*** 234,240 ****
  		unset($name);
  		unset($desc);
! 		while ($db->next_record()) {
! 			$name[] = $db->Record["filename"];
! 			$desc[] = $db->Record["filedesc"];
  		}
  		$this->filename = $name;
--- 234,240 ----
  		unset($name);
  		unset($desc);
! 		while ($db->nextRecord()) {
! 			$name[] = $db->record["filename"];
! 			$desc[] = $db->record["filedesc"];
  		}
  		$this->filename = $name;
***************
*** 277,284 ****
  		}
  		$db->queryOne("select * from forumPosts where pkey=$message and parent=0 and fid='$forumID' $st");
! 		$results[] = $db->Record;
  		$db->query("select * from forumPosts where  parent=$message $st");
! 		while($db->next_record()) { 
! 			$results[] = $db->Record;
  		}
  		return $results;
--- 277,284 ----
  		}
  		$db->queryOne("select * from forumPosts where pkey=$message and parent=0 and fid='$forumID' $st");
! 		$results[] = $db->record;
  		$db->query("select * from forumPosts where  parent=$message $st");
! 		while($db->nextRecord()) { 
! 			$results[] = $db->record;
  		}
  		return $results;
***************
*** 371,376 ****
  			if (intval($count)==0) {
  				$db->query("select count(pkey) AS total from forumPosts where parent=$pkey and status='y'");
! 				$db->next_record();
! 				$count = intval($db->Record['total']);	
  			}
  			
--- 371,376 ----
  			if (intval($count)==0) {
  				$db->query("select count(pkey) AS total from forumPosts where parent=$pkey and status='y'");
! 				$db->nextRecord();
! 				$count = intval($db->record['total']);	
  			}
  			
***************
*** 444,448 ****
  		$db = DB::getHandle();
  		$db->queryOne("select count(fid) AS total from forums where 1=1 and ".createGroupCheck($groups)." and fid='$forumID'");
! 		return $db->Record['total'];
  	}
  
--- 444,448 ----
  		$db = DB::getHandle();
  		$db->queryOne("select count(fid) AS total from forums where 1=1 and ".createGroupCheck($groups)." and fid='$forumID'");
! 		return $db->record['total'];
  	}
  

[Logicampus-cvs] logicampus/src/logicreate/services/forum/admin main.lcp, 1.1.1.1, 1.2

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/admin/main.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** main.lcp	21 Nov 2003 23:14:10 -0000	1.1.1.1
--- main.lcp	8 Oct 2007 14:26:07 -0000	1.2
***************
*** 24,29 ****
  
  		$db->query("select * from forums");
! 		while($db->next_record()) { 
! 			extract($db->Record);
  
  // make the action tags (edit/del)
--- 24,29 ----
  
  		$db->query("select * from forums");
! 		while($db->nextRecord()) { 
! 			extract($db->record);
  
  // make the action tags (edit/del)
***************
*** 52,59 ****
  
  // pull record into vars
! 		@extract($db->Record);
  		
  // put general data into template
! 		$t = $db->Record;
  
  // deal with perms
--- 52,59 ----
  
  // pull record into vars
! 		@extract($db->record);
  		
  // put general data into template
! 		$t = $db->record;
  
  // deal with perms
***************
*** 67,72 ****
  
  		$db->query("select * from forumPerms where fid='$fid'");
! 		while($db->next_record()) {
! 			$perm[$db->Record["groups"]][$db->Record["perm"]] = true;
  		}
  		while(list($k,$v) = each($grouplist)) { 
--- 67,72 ----
  
  		$db->query("select * from forumPerms where fid='$fid'");
! 		while($db->nextRecord()) {
! 			$perm[$db->record["groups"]][$db->record["perm"]] = true;
  		}
  		while(list($k,$v) = each($grouplist)) { 

[Logicampus-cvs] logicampus/src/logicreate/services/forum admin.lcp, 1.2, 1.3 post.lcp, 1.2, 1.3 search.lcp, 1.1.1.1, 1.2 view.lcp, 1.3, 1.4 viewPost.lcp, 1.1.1.1, 1.2

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

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

Modified Files:
	admin.lcp post.lcp search.lcp view.lcp viewPost.lcp 
Log Message:
Change function "next_record" to "nextRecord".

Index: view.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/view.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** view.lcp	11 Feb 2007 05:31:20 -0000	1.3
--- view.lcp	8 Oct 2007 14:26:07 -0000	1.4
***************
*** 29,34 ****
  			FROM lc_forum_perm 
  			WHERE lc_forum_id=".(int)$key." and $x");
! 		while($db->next_record()) {
! 			$t['perms'][$db->Record['action']] = true;
  		}
  
--- 29,34 ----
  			FROM lc_forum_perm 
  			WHERE lc_forum_id=".(int)$key." and $x");
! 		while($db->nextRecord()) {
! 			$t['perms'][$db->record['action']] = true;
  		}
  

Index: post.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/post.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** post.lcp	6 Jun 2005 15:26:46 -0000	1.2
--- post.lcp	8 Oct 2007 14:26:07 -0000	1.3
***************
*** 55,60 ****
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->next_record()) {
! 			$t['perms'][$db->Record[0]] = true;
  		}
  		if ($t['perms']['delete']) { 
--- 55,60 ----
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->nextRecord()) {
! 			$t['perms'][$db->record[0]] = true;
  		}
  		if ($t['perms']['delete']) { 
***************
*** 74,79 ****
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->next_record()) {
! 			$t['perms'][$db->Record[0]] = true;
  		}
  		if ($t['perms']['delete']) { 
--- 74,79 ----
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->nextRecord()) {
! 			$t['perms'][$db->record[0]] = true;
  		}
  		if ($t['perms']['delete']) { 

Index: viewPost.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/viewPost.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** viewPost.lcp	21 Nov 2003 23:14:10 -0000	1.1.1.1
--- viewPost.lcp	8 Oct 2007 14:26:07 -0000	1.2
***************
*** 40,45 ****
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$forumPost->lcForumId." and $x");
! 		while($db->next_record()) {
! 			$t['perms'][$db->Record[0]] = true;
  		}
  		if (!$t['perms']['read']) { 
--- 40,45 ----
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$forumPost->lcForumId." and $x");
! 		while($db->nextRecord()) {
! 			$t['perms'][$db->record[0]] = true;
  		}
  		if (!$t['perms']['read']) { 

Index: admin.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/admin.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** admin.lcp	13 May 2005 19:10:53 -0000	1.2
--- admin.lcp	8 Oct 2007 14:26:07 -0000	1.3
***************
*** 149,155 ****
  #die(microtime());
  		
! 		while ($db->next_record())
  		{	
! 			$a_perms[$db->Record['lc_forum_perm_action']][$db->Record['lc_forum_perm_id']] = $db->Record['lc_forum_perm_group'];
  		}
  	return $a_perms;
--- 149,155 ----
  #die(microtime());
  		
! 		while ($db->nextRecord())
  		{	
! 			$a_perms[$db->record['lc_forum_perm_action']][$db->record['lc_forum_perm_id']] = $db->record['lc_forum_perm_group'];
  		}
  	return $a_perms;
***************
*** 168,173 ****
  		$db->query($sql);
  		
! 		while ($db->next_record())
! 		{	$a_group[$db->Record['gid']] = $db->Record['groupName'];
  		}
  		
--- 168,173 ----
  		$db->query($sql);
  		
! 		while ($db->nextRecord())
! 		{	$a_group[$db->record['gid']] = $db->record['groupName'];
  		}
  		

Index: search.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/forum/search.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** search.lcp	21 Nov 2003 23:14:10 -0000	1.1.1.1
--- search.lcp	8 Oct 2007 14:26:07 -0000	1.2
***************
*** 27,35 ****
  		$t['forum']->lcForumId;
  		$db->query("select lc_forum_post_id, lc_forum_post_thread_id from lc_forum_post where lc_forum_id=$key and (lc_forum_post_message like '%$term%' or lc_forum_post_title like '%$term%')");
! 		while($db->next_record()) {
! 			if ($db->Record[1]==0) { 
! 				$db->Record[1] = $db->Record[0];
  			}
! 			$xposts[$db->Record[0]] = lcForumPost::load($db->Record[1]);
  		}
  
--- 27,35 ----
  		$t['forum']->lcForumId;
  		$db->query("select lc_forum_post_id, lc_forum_post_thread_id from lc_forum_post where lc_forum_id=$key and (lc_forum_post_message like '%$term%' or lc_forum_post_title like '%$term%')");
! 		while($db->nextRecord()) {
! 			if ($db->record[1]==0) { 
! 				$db->record[1] = $db->record[0];
  			}
! 			$xposts[$db->record[0]] = lcForumPost::load($db->record[1]);
  		}
  
***************
*** 38,43 ****
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->next_record()) {
! 			$t['perms'][$db->Record[0]] = true;
  		}
  		if (!$t['perms']['read']) { 
--- 38,43 ----
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->nextRecord()) {
! 			$t['perms'][$db->record[0]] = true;
  		}
  		if (!$t['perms']['read']) { 

[Logicampus-cvs] logicampus/src/logicreate/services/examschedule/templates main_view.html, 1.1.1.1, 1.2

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

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

Modified Files:
	main_view.html 
Log Message:
Change function "next_record" to "nextRecord".


Index: main_view.html
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/examschedule/templates/main_view.html,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** main_view.html	21 Nov 2003 23:14:09 -0000	1.1.1.1
--- main_view.html	8 Oct 2007 14:25:28 -0000	1.2
***************
*** 19,25 ****
  	$db->queryOne($sql);
  	
! 	echo '<b><a href="'.APP_URL.'administration/facultylist/'.$db->Record['facultyId'].'" title="Click to view profile!" target="_blank">'.$db->Record['firstname']. ' '. $db->Record['lastname']. '</a>';
  	echo '<br>';
! 	echo $db->Record['courseFamilyNumber']. ' - '.$db->Record['courseName'].' ('.$db->Record['semesterTerm'].' '.$db->Record['semesterYear'].')';
  	echo '</b>';
  	
--- 19,25 ----
  	$db->queryOne($sql);
  	
! 	echo '<b><a href="'.APP_URL.'administration/facultylist/'.$db->record['facultyId'].'" title="Click to view profile!" target="_blank">'.$db->record['firstname']. ' '. $db->record['lastname']. '</a>';
  	echo '<br>';
! 	echo $db->record['courseFamilyNumber']. ' - '.$db->record['courseName'].' ('.$db->record['semesterTerm'].' '.$db->record['semesterYear'].')';
  	echo '</b>';
  	

[Logicampus-cvs] logicampus/src/logicreate/services/examschedule main.lcp, 1.2, 1.3 testdates.lcp, 1.2, 1.3

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

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

Modified Files:
	main.lcp testdates.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/examschedule/main.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** main.lcp	18 Nov 2006 00:09:34 -0000	1.2
--- main.lcp	8 Oct 2007 14:24:43 -0000	1.3
***************
*** 102,107 ****
  		';
  		$db->query($sql);
! 		while($db->next_record()) 
! 		{	$info[] = $db->Record;
  		}
  /*
--- 102,107 ----
  		';
  		$db->query($sql);
! 		while($db->nextRecord()) 
! 		{	$info[] = $db->record;
  		}
  /*
***************
*** 116,126 ****
  
  		$db->query("select A.*,B.*,C.* from exam_schedule_classes A, exam_schedule_classes_dates B, exam_schedule_dates C where A.status=3 and A.id_semester=$semid and A.id_classes = B.id_classes and B.id_exam_schedule_dates = C.id_exam_schedule_dates");
! 		while($db->next_record()) {
! 			$info[] = $db->Record;
  		}
  
  		while(list($k,$v) = each($info)) {
  			$db->queryOne("select A.*,B.* from classes A,courses B where A.id_classes=".$v['id_classes']." and A.id_courses = B.id_courses");
! 			$info[$k] = array_merge($v,$db->Record);
  		}
  #print_r($info);
--- 116,126 ----
  
  		$db->query("select A.*,B.*,C.* from exam_schedule_classes A, exam_schedule_classes_dates B, exam_schedule_dates C where A.status=3 and A.id_semester=$semid and A.id_classes = B.id_classes and B.id_exam_schedule_dates = C.id_exam_schedule_dates");
! 		while($db->nextRecord()) {
! 			$info[] = $db->record;
  		}
  
  		while(list($k,$v) = each($info)) {
  			$db->queryOne("select A.*,B.* from classes A,courses B where A.id_classes=".$v['id_classes']." and A.id_courses = B.id_courses");
! 			$info[$k] = array_merge($v,$db->record);
  		}
  #print_r($info);
***************
*** 319,325 ****
  			where l.id_classes="'.$classid.'"';
  		$db->queryOne($sql);
! 		$t['courseName'] = $db->Record['courseName'];
! 		$t['facultyName'] = $db->Record['title'].' '.$db->Record['firstname'].' '.$db->Record['lastname'];
! 		$t['noexam'] = $db->Record['noexam'];
  		
  	}
--- 319,325 ----
  			where l.id_classes="'.$classid.'"';
  		$db->queryOne($sql);
! 		$t['courseName'] = $db->record['courseName'];
! 		$t['facultyName'] = $db->record['title'].' '.$db->record['firstname'].' '.$db->record['lastname'];
! 		$t['noexam'] = $db->record['noexam'];
  		
  	}
***************
*** 343,347 ****
  				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. '
--- 343,347 ----
  				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. '
***************
*** 447,452 ****
  					$addevent->dbLoad(); // if it exists, it'll be loaded up.
  
! 					$addevent->set_owner($dbb->Record['facultyId']);
! 					$addevent->set_title('['.$dbb->Record['courseFamily'].$dbb->Record['courseNumber'].'] '.addslashes(stripslashes($escd->title)));
  					$addevent->set_description(addslashes(stripslashes($escd->instructions)));
  					
--- 447,452 ----
  					$addevent->dbLoad(); // if it exists, it'll be loaded up.
  
! 					$addevent->set_owner($dbb->record['facultyId']);
! 					$addevent->set_title('['.$dbb->record['courseFamily'].$dbb->record['courseNumber'].'] '.addslashes(stripslashes($escd->title)));
  					$addevent->set_description(addslashes(stripslashes($escd->instructions)));
  					
***************
*** 499,506 ****
  
  			$mess = new privMess();
! 			$mess->subject = '['.$db->Record['courseFamily'].$db->Record['courseNumber']
  				.'] Your exam schedule has been updated.';
! 			$mess->message = 'There was a change to your exam schedule *status* on: '.$db->Record['courseName']
! 				.' - '.$db->Record['courseFamily'].$db->Record['courseNumber'].' class.';
  
  			foreach($a_statuschange_description as $null=>$prvmsg)
--- 499,506 ----
  
  			$mess = new privMess();
! 			$mess->subject = '['.$db->record['courseFamily'].$db->record['courseNumber']
  				.'] Your exam schedule has been updated.';
! 			$mess->message = 'There was a change to your exam schedule *status* on: '.$db->record['courseName']
! 				.' - '.$db->record['courseFamily'].$db->record['courseNumber'].' class.';
  
  			foreach($a_statuschange_description as $null=>$prvmsg)
***************
*** 511,515 ****
  			$mess->messageFrom = $u->username;
  
! 			$mess->messageTo = $db->Record['facultyId'];
  			$mess->add();
  		}
--- 511,515 ----
  			$mess->messageFrom = $u->username;
  
! 			$mess->messageTo = $db->record['facultyId'];
  			$mess->add();
  		}
***************
*** 598,602 ****
  		$db->queryOne($sql);
  		
! 		return $db->Record['semesterTerm'].' '.$db->Record['semesterYear'];
  }
  ?>
--- 598,602 ----
  		$db->queryOne($sql);
  		
! 		return $db->record['semesterTerm'].' '.$db->record['semesterYear'];
  }
  ?>

Index: testdates.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/examschedule/testdates.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** testdates.lcp	18 Nov 2006 00:09:34 -0000	1.2
--- testdates.lcp	8 Oct 2007 14:24:44 -0000	1.3
***************
*** 147,151 ****
  		$db->queryOne($sql);
  		
! 		return $db->Record['semesterTerm'].' '.$db->Record['semesterYear'];
  }
  ?>
--- 147,151 ----
  		$db->queryOne($sql);
  		
! 		return $db->record['semesterTerm'].' '.$db->record['semesterYear'];
  }
  ?>

[Logicampus-cvs] logicampus/src/logicreate/services/docs/includes Directory.php, 1.1.1.1, 1.2 File.php, 1.1.1.1, 1.2

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

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

Modified Files:
	Directory.php File.php 
Log Message:
Change function "next_record" to "nextRecord".


Index: File.php
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/docs/includes/File.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** File.php	21 Nov 2003 23:14:09 -0000	1.1.1.1
--- File.php	8 Oct 2007 14:24:12 -0000	1.2
***************
*** 37,43 ****
  
        $result = $this->db->queryOne($sql);
!       if(is_array($this->db->Record) && count($this->db->Record))
        {
!         $this->setFrom($this->db->Record);
          return true;
        }
--- 37,43 ----
  
        $result = $this->db->queryOne($sql);
!       if(is_array($this->db->record) && count($this->db->record))
        {
!         $this->setFrom($this->db->record);
          return true;
        }

Index: Directory.php
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/docs/includes/Directory.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** Directory.php	21 Nov 2003 23:14:09 -0000	1.1.1.1
--- Directory.php	8 Oct 2007 14:24:12 -0000	1.2
***************
*** 27,33 ****
  
        $result = $this->db->queryOne($sql);
!       if(is_array($this->db->Record) && count($this->db->Record))
        {
!         $this->setFrom($this->db->Record);
          return true;
        }
--- 27,33 ----
  
        $result = $this->db->queryOne($sql);
!       if(is_array($this->db->record) && count($this->db->record))
        {
!         $this->setFrom($this->db->record);
          return true;
        }
***************
*** 44,50 ****
  
        $result = $this->db->queryOne($sql);
!       if(is_array($this->db->Record) && count($this->db->Record))
        {
!         $this->setFrom($this->db->Record);
          return true;
        }
--- 44,50 ----
  
        $result = $this->db->queryOne($sql);
!       if(is_array($this->db->record) && count($this->db->record))
        {
!         $this->setFrom($this->db->record);
          return true;
        }
***************
*** 64,71 ****
        if($this->db->getNumRows())
        {
!         while($this->db->next_record())
          {
            $dir = & new Docs_Directory();
!           $dir->setFrom($this->db->Record);
  
            $ret[] = $dir;
--- 64,71 ----
        if($this->db->getNumRows())
        {
!         while($this->db->nextRecord())
          {
            $dir = & new Docs_Directory();
!           $dir->setFrom($this->db->record);
  
            $ret[] = $dir;
***************
*** 90,97 ****
          if($this->db->getNumRows())
          {
!           while($this->db->next_record())
            {
              $file = & new Docs_File();
!             $file->setFrom($this->db->Record);
  
              $ret[] = $file;
--- 90,97 ----
          if($this->db->getNumRows())
          {
!           while($this->db->nextRecord())
            {
              $file = & new Docs_File();
!             $file->setFrom($this->db->record);
  
              $ret[] = $file;

[Logicampus-cvs] logicampus/src/logicreate/services/classroom announcements.lcp, 1.3, 1.4 assignments.lcp, 1.13, 1.14 chat.lcp, 1.5, 1.6 classmates.lcp, 1.2, 1.3 contactStudents.lcp, 1.4, 1.5 details.lcp, 1.10, 1.11 discussion_post.lcp, 1.2, 1.3 discussion_search.lcp, 1.1.1.1, 1.2 facultyProfile.lcp, 1.2, 1.3 faq.lcp, 1.1.1.1, 1.2 gradebook.lcp, 1.3, 1.4 gradebookall.lcp, 1.1, 1.2 gradebookallsem.lcp, 1.1, 1.2 lessons.lcp, 1.22, 1.23 links.lcp, 1.1.1.1, 1.2 main.lcp, 1.14, 1.15 online.lcp, 1.3, 1.4 presentations.lcp, 1.1.1.1, 1.2 syllabus.lcp, 1.4, 1.5 viewContent.lcp, 1.3, 1.4 webliography.lcp, 1.2, 1.3

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

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

Modified Files:
	announcements.lcp assignments.lcp chat.lcp classmates.lcp 
	contactStudents.lcp details.lcp discussion_post.lcp 
	discussion_search.lcp facultyProfile.lcp faq.lcp gradebook.lcp 
	gradebookall.lcp gradebookallsem.lcp lessons.lcp links.lcp 
	main.lcp online.lcp presentations.lcp syllabus.lcp 
	viewContent.lcp webliography.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: links.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/links.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** links.lcp	21 Nov 2003 23:14:08 -0000	1.1.1.1
--- links.lcp	8 Oct 2007 14:22:27 -0000	1.2
***************
*** 28,36 ****
  				$db->queryOne($sql);
  				$this->presentor = 'redirectPresentation';
! 				if ( substr($db->Record['url'],0,7) != 'http://' ) {
! 					$db->Record['url'] = 'http://'.$db->Record['url'];
  				}
  
! 				$t['url'] = $db->Record['url'];
  				return;
  			}
--- 28,36 ----
  				$db->queryOne($sql);
  				$this->presentor = 'redirectPresentation';
! 				if ( substr($db->record['url'],0,7) != 'http://' ) {
! 					$db->record['url'] = 'http://'.$db->record['url'];
  				}
  
! 				$t['url'] = $db->record['url'];
  				return;
  			}
***************
*** 51,55 ****
  					$tablePkeyLabel ='$contentPkey'";
  			$db->queryOne($sql);
! 			if ($activeClassTaken == $db->Record[$contentLabel])
  			{
  				return true;
--- 51,55 ----
  					$tablePkeyLabel ='$contentPkey'";
  			$db->queryOne($sql);
! 			if ($activeClassTaken == $db->record[$contentLabel])
  			{
  				return true;

Index: viewContent.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/viewContent.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** viewContent.lcp	2 Aug 2005 20:32:28 -0000	1.3
--- viewContent.lcp	8 Oct 2007 14:22:27 -0000	1.4
***************
*** 68,72 ****
  			';
  			$db->queryOne($sql);
! 			if ($db->Record == false)
  			{
  				//no permission to view this file
--- 68,72 ----
  			';
  			$db->queryOne($sql);
! 			if ($db->record == false)
  			{
  				//no permission to view this file
***************
*** 76,80 ****
  			}
  
! 		$pkey = $db->Record['pkey'];			
  		}
  		// END FHASH
--- 76,80 ----
  			}
  
! 		$pkey = $db->record['pkey'];			
  		}
  		// END FHASH
***************
*** 88,92 ****
  		if ($x == null ) {
  			$db->queryOne('select mime from classdoclib_Files where pkey = '.$pkey);
! 			list ($mimeFamily,$mimeType) = explode('/',$db->Record['mime']);
  			if ($mimeFamily == 'image') {
  				header("Cache-control: public");
--- 88,92 ----
  		if ($x == null ) {
  			$db->queryOne('select mime from classdoclib_Files where pkey = '.$pkey);
! 			list ($mimeFamily,$mimeType) = explode('/',$db->record['mime']);
  			if ($mimeFamily == 'image') {
  				header("Cache-control: public");

Index: contactStudents.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/contactStudents.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** contactStudents.lcp	9 Feb 2007 19:53:42 -0000	1.4
--- contactStudents.lcp	8 Oct 2007 14:22:27 -0000	1.5
***************
*** 47,60 ****
  			$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>';
  
! 				$photo = is_file(IMAGES_PATH.'photos/'.$db->Record['photo'])
! 					? 'photos/'.$db->Record['photo']
  					: 'noimage.png';
  
! 				$t['students'][$db->Record['username']] .= '<a href="'.appurl('users/view/'.$db->Record['username']).'">'
  				.'<img align="middle" border="0" src="'.IMAGES_URL.$photo.'" alt="'
! 				.$db->Record['lastname'].', '.$db->Record['firstname'].'" /></a>';
  			}
  
--- 47,60 ----
  			$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>';
  
! 				$photo = is_file(IMAGES_PATH.'photos/'.$db->record['photo'])
! 					? 'photos/'.$db->record['photo']
  					: 'noimage.png';
  
! 				$t['students'][$db->record['username']] .= '<a href="'.appurl('users/view/'.$db->record['username']).'">'
  				.'<img align="middle" border="0" src="'.IMAGES_URL.$photo.'" alt="'
! 				.$db->record['lastname'].', '.$db->record['firstname'].'" /></a>';
  			}
  
***************
*** 106,112 ****
  		$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'];
  		}
  		
--- 106,112 ----
  		$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: discussion_search.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/discussion_search.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** discussion_search.lcp	21 Nov 2003 23:14:08 -0000	1.1.1.1
--- discussion_search.lcp	8 Oct 2007 14:22:27 -0000	1.2
***************
*** 43,51 ****
  		$t['forum']->lcForumId;
  		$db->query("select lc_forum_post_id, lc_forum_post_thread_id from lc_forum_post where lc_forum_id=$key and (lc_forum_post_message like '%$term%' or lc_forum_post_title like '%$term%' or lc_forum_post_username like '%$term%')");
! 		while($db->next_record()) {
! 			if ($db->Record[1]==0) { 
! 				$db->Record[1] = $db->Record[0];
  			}
! 			$xposts[$db->Record[0]] = lcForumPost::load($db->Record[1]);
  		}
  
--- 43,51 ----
  		$t['forum']->lcForumId;
  		$db->query("select lc_forum_post_id, lc_forum_post_thread_id from lc_forum_post where lc_forum_id=$key and (lc_forum_post_message like '%$term%' or lc_forum_post_title like '%$term%' or lc_forum_post_username like '%$term%')");
! 		while($db->nextRecord()) {
! 			if ($db->record[1]==0) { 
! 				$db->record[1] = $db->record[0];
  			}
! 			$xposts[$db->record[0]] = lcForumPost::load($db->record[1]);
  		}
  

Index: announcements.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/announcements.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** announcements.lcp	18 Nov 2006 00:09:34 -0000	1.3
--- announcements.lcp	8 Oct 2007 14:22:27 -0000	1.4
***************
*** 39,43 ****
  			$db->query($sql); 
  
! 			while ($db->next_record()) $t['announcements'][] = $db->Record;
  
  			// figure out whether or not we want to display the prev/next links
--- 39,43 ----
  			$db->query($sql); 
  
! 			while ($db->nextRecord()) $t['announcements'][] = $db->record;
  
  			// figure out whether or not we want to display the prev/next links
***************
*** 46,50 ****
  				where id_classes='.$u->activeClassTaken->id_classes;
  			$db->queryOne($sql);
! 			$count = $db->Record['count'];
  			$t['showprev'] = $min > 0;
  			$t['shownext'] = $max < $count;
--- 46,50 ----
  				where id_classes='.$u->activeClassTaken->id_classes;
  			$db->queryOne($sql);
! 			$count = $db->record['count'];
  			$t['showprev'] = $min > 0;
  			$t['shownext'] = $max < $count;
***************
*** 64,70 ****
  			$db->queryOne($sql);
  
! 			$t['announcement_text'] = $db->Record['tx_description'];
! 			$t['announcement_title'] = $db->Record['tx_title'];
! 			$t['announcement_posted'] = $db->Record['dt_display'];
  			$this->sectionTitle = 'Announcement';
  
--- 64,70 ----
  			$db->queryOne($sql);
  
! 			$t['announcement_text'] = $db->record['tx_description'];
! 			$t['announcement_title'] = $db->record['tx_title'];
! 			$t['announcement_posted'] = $db->record['dt_display'];
  			$this->sectionTitle = 'Announcement';
  

Index: lessons.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/lessons.lcp,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -d -r1.22 -r1.23
*** lessons.lcp	5 Oct 2007 22:37:38 -0000	1.22
--- lessons.lcp	8 Oct 2007 14:22:27 -0000	1.23
***************
*** 43,47 ****
  
  		$db->query($sql);
! 		while ($db->next_record()){ $lessons[] = $db->Record; }
  
  
--- 43,47 ----
  
  		$db->query($sql);
! 		while ($db->nextRecord()){ $lessons[] = $db->record; }
  
  
***************
*** 132,137 ****
  			WHERE class_lesson_objectives.id_class_lesson='".$lesson_id."' 
  			AND f_hide=0 ORDER BY i_sort ASC");
! 		while ($db->next_record()) {
! 			$t['objectives'][] = $db->Record;
  		}
  
--- 132,137 ----
  			WHERE class_lesson_objectives.id_class_lesson='".$lesson_id."' 
  			AND f_hide=0 ORDER BY i_sort ASC");
! 		while ($db->nextRecord()) {
! 			$t['objectives'][] = $db->record;
  		}
  
***************
*** 218,222 ****
  			WHERE ll.id_class_lessons='".$lesson_id."'";
  		$db->query($sql);
! 		while ($db->next_record()) $t['weblinks'][] = $db->Record;
  
  
--- 218,222 ----
  			WHERE ll.id_class_lessons='".$lesson_id."'";
  		$db->query($sql);
! 		while ($db->nextRecord()) $t['weblinks'][] = $db->record;
  
  
***************
*** 271,275 ****
  			and id_class_lesson_content = $content_id";
  		$db->queryOne($sql);
! 		$t['content'] = $db->Record;
  		if ($lc->getvars['print']) {
  			$this->presentor = 'printPresentation';
--- 271,275 ----
  			and id_class_lesson_content = $content_id";
  		$db->queryOne($sql);
! 		$t['content'] = $db->record;
  		if ($lc->getvars['print']) {
  			$this->presentor = 'printPresentation';

Index: gradebookall.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/gradebookall.lcp,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** gradebookall.lcp	29 Aug 2004 22:50:20 -0000	1.1
--- gradebookall.lcp	8 Oct 2007 14:22:27 -0000	1.2
***************
*** 83,91 ****
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->next_record() ) {
! 			if ($u->username == $db->Record['username']) {
! 				$usersScore = $db->Record['score'];
  			}
! 			$scores[$db->Record['username']] = $db->Record['score'];
  		}
  
--- 83,91 ----
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->nextRecord() ) {
! 			if ($u->username == $db->record['username']) {
! 				$usersScore = $db->record['score'];
  			}
! 			$scores[$db->record['username']] = $db->record['score'];
  		}
  

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/main.lcp,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** main.lcp	2 Oct 2007 20:16:50 -0000	1.14
--- main.lcp	8 Oct 2007 14:22:27 -0000	1.15
***************
*** 54,60 ****
  
  			$db->queryOne($sql);
! 			if (is_array($db->Record))
  			{
! 				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li><ahref="'.APP_URL.'classroom/assignments/id_classes='.$u->classesTaken[$x]->id_classes.'/event=view/id='.$db->Record['id_class_assignments'].'">Assignment: '.$db->Record['title'].'</a></li>';
  			} else {
  				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li>Assignment: none</li>';
--- 54,60 ----
  
  			$db->queryOne($sql);
! 			if (is_array($db->record))
  			{
! 				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li><ahref="'.APP_URL.'classroom/assignments/id_classes='.$u->classesTaken[$x]->id_classes.'/event=view/id='.$db->record['id_class_assignments'].'">Assignment: '.$db->record['title'].'</a></li>';
  			} else {
  				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li>Assignment: none</li>';
***************
*** 70,76 ****
  
  			$db->queryOne($sql);
! 			if (is_array($db->Record))
  			{
! 				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li><ahref="'.APP_URL.'classroom/lessons/id_classes='.$u->classesTaken[$x]->id_classes.'/event=view/id='.$db->Record['id_class_lessons'].'">Lesson: '.$db->Record['title'].'</a></li>';
  			} else {
  				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li>Lesson: none</li>';
--- 70,76 ----
  
  			$db->queryOne($sql);
! 			if (is_array($db->record))
  			{
! 				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li><ahref="'.APP_URL.'classroom/lessons/id_classes='.$u->classesTaken[$x]->id_classes.'/event=view/id='.$db->record['id_class_lessons'].'">Lesson: '.$db->record['title'].'</a></li>';
  			} else {
  				$t['classdata'][$u->classesTaken[$x]->id_classes] .= '<li>Lesson: none</li>';
***************
*** 105,112 ****
  			{
  					$t['lessons'] = '<ul>';
! 					while ($db->next_record() )
  					{
  						$t['lessons'] .= '<li>
! 					<a href="'.APP_URL.'classroom/lessons/event=view/id_classes='.$db->Record['id_classes'].'/id='.$db->Record['id_class_lessons'].'">'.$db->Record['title'].'</a>&nbsp;-&nbsp;'.$db->Record['courseFamilyNumber'].'</li>';
  					}
  					$t['lessons'] .= '</ul>';
--- 105,112 ----
  			{
  					$t['lessons'] = '<ul>';
! 					while ($db->nextRecord() )
  					{
  						$t['lessons'] .= '<li>
! 					<a href="'.APP_URL.'classroom/lessons/event=view/id_classes='.$db->record['id_classes'].'/id='.$db->record['id_class_lessons'].'">'.$db->record['title'].'</a>&nbsp;-&nbsp;'.$db->record['courseFamilyNumber'].'</li>';
  					}
  					$t['lessons'] .= '</ul>';
***************
*** 134,142 ****
  
  				$t['assignments'] = '<ul>';
! 				while ($db->next_record() )
  				{
  					$t['assignments'] .= '<li>
! 	<a href="'.APP_URL.'classroom/assignments/event=view/id_classes='.$db->Record['id_classes'].'/id='.$db->Record['id_class_assignments'].'">
! 	'.$db->Record['title'].'</a>&nbsp;-&nbsp;'.$db->Record['courseFamilyNumber'].'</li>';
  				}
  		
--- 134,142 ----
  
  				$t['assignments'] = '<ul>';
! 				while ($db->nextRecord() )
  				{
  					$t['assignments'] .= '<li>
! 	<a href="'.APP_URL.'classroom/assignments/event=view/id_classes='.$db->record['id_classes'].'/id='.$db->record['id_class_assignments'].'">
! 	'.$db->record['title'].'</a>&nbsp;-&nbsp;'.$db->record['courseFamilyNumber'].'</li>';
  				}
  		

Index: assignments.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/assignments.lcp,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** assignments.lcp	3 Oct 2007 02:09:01 -0000	1.13
--- assignments.lcp	8 Oct 2007 14:22:27 -0000	1.14
***************
*** 216,220 ****
  					
  					$db2->queryOne($sql);
! 					$t['assigntext'] = $db2->Record['assign_text'];
  					$t['f_showform_text'] = true; 
  				
--- 216,220 ----
  					
  					$db2->queryOne($sql);
! 					$t['assigntext'] = $db2->record['assign_text'];
  					$t['f_showform_text'] = true; 
  				
***************
*** 262,268 ****
  		$db3->query($sql);
  
! 		while ($db3->next_record()) 
  		{
! 			$t['attachments'][] = $db3->Record;	
  		}
  */
--- 262,268 ----
  		$db3->query($sql);
  
! 		while ($db3->nextRecord()) 
  		{
! 			$t['attachments'][] = $db3->record;	
  		}
  */
***************
*** 372,381 ****
  						// the only problem i seem to have with below is 
  						// an update could potentially change things
! 						if ((int)$db->Record['id_class_assignments_turnin'] > 0)
  						{
  							// we have an assignment, lets update
  							$sql_head = 'UPDATE';
  							$sql_footer = 'WHERE id_class_assignments='.$lc->getvars['id']. '
! 							AND id_Class_assignments_turnin='. $db->Record['id_class_assignments_turnin'];
  							
  						} else
--- 372,381 ----
  						// the only problem i seem to have with below is 
  						// an update could potentially change things
! 						if ((int)$db->record['id_class_assignments_turnin'] > 0)
  						{
  							// we have an assignment, lets update
  							$sql_head = 'UPDATE';
  							$sql_footer = 'WHERE id_class_assignments='.$lc->getvars['id']. '
! 							AND id_Class_assignments_turnin='. $db->record['id_class_assignments_turnin'];
  							
  						} else

Index: classmates.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/classmates.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** classmates.lcp	9 Feb 2007 19:53:42 -0000	1.2
--- classmates.lcp	8 Oct 2007 14:22:27 -0000	1.3
***************
*** 32,45 ****
  		$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>';
  		}
  
--- 32,45 ----
  		$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: online.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/online.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** online.lcp	9 Feb 2007 18:08:31 -0000	1.3
--- online.lcp	8 Oct 2007 14:22:27 -0000	1.4
***************
*** 53,58 ****
  			$db->query($query);
  			$db->RESULT_TYPE = MYSQL_ASSOC;
! 			while($db->next_record()) {
! 				$t['users'][]= $db->Record;
  			}
  			$t['loggedin'] = count($t['users']);
--- 53,58 ----
  			$db->query($query);
  			$db->RESULT_TYPE = MYSQL_ASSOC;
! 			while($db->nextRecord()) {
! 				$t['users'][]= $db->record;
  			}
  			$t['loggedin'] = count($t['users']);

Index: syllabus.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/syllabus.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** syllabus.lcp	10 May 2007 16:05:08 -0000	1.4
--- syllabus.lcp	8 Oct 2007 14:22:27 -0000	1.5
***************
*** 46,50 ****
  		$db->queryOne("select * from classes where id_classes='$classId'");
  
! 		if (!$db->Record['id_classes']) {
  			// They didn't get back a record! Error out.
  			$this->presentor = 'errorMessage';
--- 46,50 ----
  		$db->queryOne("select * from classes where id_classes='$classId'");
  
! 		if (!$db->record['id_classes']) {
  			// They didn't get back a record! Error out.
  			$this->presentor = 'errorMessage';
***************
*** 53,57 ****
  		}
  
! 		$t['classes'] = $db->Record;
  
  		// profile_faculty table
--- 53,57 ----
  		}
  
! 		$t['classes'] = $db->record;
  
  		// profile_faculty table
***************
*** 59,63 ****
  			left join profile as p on f.username=p.username
  			where p.username='{$t['classes']['facultyId']}'");
! 		$t['profile'] = $db->Record;
  		
  
--- 59,63 ----
  			left join profile as p on f.username=p.username
  			where p.username='{$t['classes']['facultyId']}'");
! 		$t['profile'] = $db->record;
  		
  
***************
*** 65,74 ****
  		$db->queryOne("select * from courses
  			where id_courses='{$t['classes']['id_courses']}'");
! 		$t['course'] = $db->Record;
  
  		// get semester information
  		$db->queryOne("select * from semesters
  			where id_semesters='{$t['classes']['id_semesters']}'");
! 		$t['semester'] = $db->Record;
  
  		// get syllabus information
--- 65,74 ----
  		$db->queryOne("select * from courses
  			where id_courses='{$t['classes']['id_courses']}'");
! 		$t['course'] = $db->record;
  
  		// get semester information
  		$db->queryOne("select * from semesters
  			where id_semesters='{$t['classes']['id_semesters']}'");
! 		$t['semester'] = $db->record;
  
  		// get syllabus information
***************
*** 85,94 ****
  		$db->queryOne("select * from semesters_course_info
  			where id_semesters='{$u->activeClassTaken->id_semesters}'");
! 		$t['semester_course_info'] = $db->Record;
  
  		// get professor email addy
  		$db->queryOne("select email from lcUsers
  			where username='{$t['classes']['facultyId']}'");
! 		$t['email'] = $db->Record['email'];
  
  		// get textbook information
--- 85,94 ----
  		$db->queryOne("select * from semesters_course_info
  			where id_semesters='{$u->activeClassTaken->id_semesters}'");
! 		$t['semester_course_info'] = $db->record;
  
  		// get professor email addy
  		$db->queryOne("select email from lcUsers
  			where username='{$t['classes']['facultyId']}'");
! 		$t['email'] = $db->record['email'];
  
  		// get textbook information

Index: facultyProfile.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/facultyProfile.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** facultyProfile.lcp	9 Feb 2007 18:33:12 -0000	1.2
--- facultyProfile.lcp	8 Oct 2007 14:22:27 -0000	1.3
***************
*** 44,51 ****
  		$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';
  
--- 44,51 ----
  		$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';
  

Index: webliography.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/webliography.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** webliography.lcp	23 Aug 2005 17:58:00 -0000	1.2
--- webliography.lcp	8 Oct 2007 14:22:27 -0000	1.3
***************
*** 40,44 ****
  					where id_classes="'.$u->activeClassTaken->id_classes.'"
  					and id_class_links_categories="'.$category.'"');
! 				$t['catname'] = $db->Record['txTitle'];
  			}
  
--- 40,44 ----
  					where id_classes="'.$u->activeClassTaken->id_classes.'"
  					and id_class_links_categories="'.$category.'"');
! 				$t['catname'] = $db->record['txTitle'];
  			}
  
***************
*** 48,52 ****
  				and id_classes="'.$u->activeClassTaken->id_classes.'"';
  			$db->query($sql);
! 			while ( $db->next_record() ) {
  
  				$db2 = DB::GetHandle();
--- 48,52 ----
  				and id_classes="'.$u->activeClassTaken->id_classes.'"';
  			$db->query($sql);
! 			while ( $db->nextRecord() ) {
  
  				$db2 = DB::GetHandle();
***************
*** 54,62 ****
  				$db2->queryOne('SELECT count(id_class_links) AS count 
  					FROM class_links
! 					WHERE id_class_links_categories="'.$db->Record['id_class_links_categories'].'"');
  
! 				$t['cats'][$db->Record['id_class_links_categories']] = array(
! 					'title' => $db->Record['txTitle'],
! 					'count' => $db2->Record['count']
  				);
  			}
--- 54,62 ----
  				$db2->queryOne('SELECT count(id_class_links) AS count 
  					FROM class_links
! 					WHERE id_class_links_categories="'.$db->record['id_class_links_categories'].'"');
  
! 				$t['cats'][$db->record['id_class_links_categories']] = array(
! 					'title' => $db->record['txTitle'],
! 					'count' => $db2->record['count']
  				);
  			}
***************
*** 68,74 ****
  					and id_classes='".$u->activeClassTaken->id_classes."'";
  				$db->query($sql);
! 				while ( $db->next_record() ) {
! 					$t['cats'][$id]['subs'][$db->Record['id_class_links_categories']]
! 						= $db->Record['txTitle'];
  				}
  			}
--- 68,74 ----
  					and id_classes='".$u->activeClassTaken->id_classes."'";
  				$db->query($sql);
! 				while ( $db->nextRecord() ) {
! 					$t['cats'][$id]['subs'][$db->record['id_class_links_categories']]
! 						= $db->record['txTitle'];
  				}
  			}
***************
*** 83,88 ****
  				ORDER BY hits';
  			$db->query($sql);
! 			while ( $db->next_record() ) {
! 				$t['links'][] = $db->Record;
  			}
  
--- 83,88 ----
  				ORDER BY hits';
  			$db->query($sql);
! 			while ( $db->nextRecord() ) {
! 				$t['links'][] = $db->record;
  			}
  

Index: chat.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/chat.lcp,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** chat.lcp	11 Feb 2007 22:41:08 -0000	1.5
--- chat.lcp	8 Oct 2007 14:22:27 -0000	1.6
***************
*** 114,120 ****
  				</tr>';
  				$i_posting = 0;
! 				while ($db->next_record())
  				{	
! 			$temp = $db->Record;
  			unset($temp['pkey']);
  			$check = md5(serialize($temp));
--- 114,120 ----
  				</tr>';
  				$i_posting = 0;
! 				while ($db->nextRecord())
  				{	
! 			$temp = $db->record;
  			unset($temp['pkey']);
  			$check = md5(serialize($temp));
***************
*** 122,128 ****
  				$i_posting ++;
  					$t['output'] .= '<tr style="background-color: '.(($i_posting%2) ? '#e7e7e7': '').'">
! 						<td valign="top"><a target="_blank" href="'.appurl('users/view/'.$db->Record['username']).'">'.$db->Record['username'].'</a></td>
! 						<td valign="top">'.date('g:i A', $db->Record['timeint']). '</td>
! 						<td valign="top">'.stripslashes($db->Record['message']). '</td>
  					</tr>';
  			}
--- 122,128 ----
  				$i_posting ++;
  					$t['output'] .= '<tr style="background-color: '.(($i_posting%2) ? '#e7e7e7': '').'">
! 						<td valign="top"><a target="_blank" href="'.appurl('users/view/'.$db->record['username']).'">'.$db->record['username'].'</a></td>
! 						<td valign="top">'.date('g:i A', $db->record['timeint']). '</td>
! 						<td valign="top">'.stripslashes($db->record['message']). '</td>
  					</tr>';
  			}
***************
*** 168,173 ****
  /*
  //		$db->query("select pkey,chatName,chatDesc from chatArchives ORDER BY pkey DESC");
! 		while($db->next_record()) {
! 			$x[] = $db->Record;
  		}
  		$t['archiveList'] = $x;
--- 168,173 ----
  /*
  //		$db->query("select pkey,chatName,chatDesc from chatArchives ORDER BY pkey DESC");
! 		while($db->nextRecord()) {
! 			$x[] = $db->record;
  		}
  		$t['archiveList'] = $x;
***************
*** 200,206 ****
  			$db->query("select * from chat where chat_id=".$this->chat_id." and pkey>$last order by timeint");
  		}
! 		while($db->next_record()) { 
! 			$t['rows'][] = $db->Record;
! 			$max = $db->Record['pkey'];
  		}
  		if ($max>0) { 
--- 200,206 ----
  			$db->query("select * from chat where chat_id=".$this->chat_id." and pkey>$last order by timeint");
  		}
! 		while($db->nextRecord()) { 
! 			$t['rows'][] = $db->record;
! 			$max = $db->record['pkey'];
  		}
  		if ($max>0) { 
***************
*** 273,278 ****
  		$lcObj->templateName = "chat_show";
  		$db->query("select * from chatThreads");
! 		while($db->next_record()) { 
! 			extract($db->Record);
  			$x = "<a href=\"#\" onClick=\"window.open('";
  			$x .= appurl("{$this->module_name}/chat/event=admin/chatThread=$chatThread");
--- 273,278 ----
  		$lcObj->templateName = "chat_show";
  		$db->query("select * from chatThreads");
! 		while($db->nextRecord()) { 
! 			extract($db->record);
  			$x = "<a href=\"#\" onClick=\"window.open('";
  			$x .= appurl("{$this->module_name}/chat/event=admin/chatThread=$chatThread");
***************
*** 308,312 ****
  		$arg->templateName='chat_usershow';
  		$db->queryOne("select * from lcUsers where username='".$arg->getvars['username']."'"); 
! 		$t['usershow'] = $db->Record;
  		$this->presentor = "emptypresentation";
  	}
--- 308,312 ----
  		$arg->templateName='chat_usershow';
  		$db->queryOne("select * from lcUsers where username='".$arg->getvars['username']."'"); 
! 		$t['usershow'] = $db->record;
  		$this->presentor = "emptypresentation";
  	}
***************
*** 315,320 ****
  		$arg->templateName='chat_userlist';
  		$db->query("select distinct(username) from chat where chat_id='{$this->chat_id}' and timeint>=".(time()-900)." order by username");
! 		while($db->next_record()) {
! 			$t['users'][] = $db->Record;
  		}
  		$this->presentor = "emptypresentation";
--- 315,320 ----
  		$arg->templateName='chat_userlist';
  		$db->query("select distinct(username) from chat where chat_id='{$this->chat_id}' and timeint>=".(time()-900)." order by username");
! 		while($db->nextRecord()) {
! 			$t['users'][] = $db->record;
  		}
  		$this->presentor = "emptypresentation";
***************
*** 386,391 ****
  			$db->query($sql);
  
! 			while($db->next_record()) {
! 				extract($db->Record);
  				$message = stripslashes($message);
  				$nameclass = "regname$style";
--- 386,391 ----
  			$db->query($sql);
  
! 			while($db->nextRecord()) {
! 				extract($db->record);
  				$message = stripslashes($message);
  				$nameclass = "regname$style";
***************
*** 545,550 ****
  		$db->query($sql);
  
! 		while($db->next_record()) {
! 			extract($db->Record);
  			$message = stripslashes($message);
  			$post = "<a href=\"".appurl("chat/main/event=moveQ/move=1/pkey=$pkey")."\">approve</a>\n";
--- 545,550 ----
  		$db->query($sql);
  
! 		while($db->nextRecord()) {
! 			extract($db->record);
  			$message = stripslashes($message);
  			$post = "<a href=\"".appurl("chat/main/event=moveQ/move=1/pkey=$pkey")."\">approve</a>\n";
***************
*** 568,572 ****
  			if ($lcObj->getvars["move"]==1) { 
  				$db->queryOne("select * from chatQ where pkey=$pkey");
! 				extract($db->Record);
  				$message = addslashes($message);
  				$username = addslashes($username);
--- 568,572 ----
  			if ($lcObj->getvars["move"]==1) { 
  				$db->queryOne("select * from chatQ where pkey=$pkey");
! 				extract($db->record);
  				$message = addslashes($message);
  				$username = addslashes($username);

Index: details.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/details.lcp,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** details.lcp	2 Oct 2007 20:16:50 -0000	1.10
--- details.lcp	8 Oct 2007 14:22:27 -0000	1.11
***************
*** 67,71 ****
  
  		$db->queryOne($sql);
! 		$t['lessoncount'] = $db->Record['count'];
  		if ($t['lessoncount'] <= $this->_PortalNumOfLessons)
  		{
--- 67,71 ----
  
  		$db->queryOne($sql);
! 		$t['lessoncount'] = $db->record['count'];
  		if ($t['lessoncount'] <= $this->_PortalNumOfLessons)
  		{
***************
*** 98,106 ****
  		 {
  			$t['lessons'] = '<ul>';
! 			while ($db->next_record() )
  			{
  				$t['lessons'] .= '<li><a href="'.modurl('lessons/event=view').
! 				'/id='.$db->Record['id_class_lessons'].'">'.$db->Record['title'].'</a></li>';
! 				//('.date("m-d h:i A", $db->Record['activeOn']).')</a></li>';
  			}
  			$t['lessons'] .= '</ul>';
--- 98,106 ----
  		 {
  			$t['lessons'] = '<ul>';
! 			while ($db->nextRecord() )
  			{
  				$t['lessons'] .= '<li><a href="'.modurl('lessons/event=view').
! 				'/id='.$db->record['id_class_lessons'].'">'.$db->record['title'].'</a></li>';
! 				//('.date("m-d h:i A", $db->record['activeOn']).')</a></li>';
  			}
  			$t['lessons'] .= '</ul>';
***************
*** 201,207 ****
  		 {
  			$t['announcements'] = '<ul>';
! 			if($db->next_record() )
  			{
! 				$t['announcements'] .= '<li><a href="'.modurl('announcements').'/event=view/id='.$db->Record['id_class_announcements'].'">'.truncateText($db->Record['tx_description']).'</a></li>';
  			}
  			$t['announcements'] .= '</ul>';
--- 201,207 ----
  		 {
  			$t['announcements'] = '<ul>';
! 			if($db->nextRecord() )
  			{
! 				$t['announcements'] .= '<li><a href="'.modurl('announcements').'/event=view/id='.$db->record['id_class_announcements'].'">'.truncateText($db->record['tx_description']).'</a></li>';
  			}
  			$t['announcements'] .= '</ul>';
***************
*** 234,243 ****
  				id_classes = '".$u->activeClassTaken->id_classes."'";
  		$db->queryOne($sql);
! 		$id_content = $db->Record['id_class_resource'];
  
  		$sql = "SELECT txText from class_lesson_content WHERE 
  		id_class_lesson_content = '$id_content'";
  		$db->queryOne($sql);
! 		$t['classresource'] = $db->Record['txText'];
  
  
--- 234,243 ----
  				id_classes = '".$u->activeClassTaken->id_classes."'";
  		$db->queryOne($sql);
! 		$id_content = $db->record['id_class_resource'];
  
  		$sql = "SELECT txText from class_lesson_content WHERE 
  		id_class_lesson_content = '$id_content'";
  		$db->queryOne($sql);
! 		$t['classresource'] = $db->record['txText'];
  
  

Index: discussion_post.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/discussion_post.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** discussion_post.lcp	6 Jun 2004 02:12:51 -0000	1.2
--- discussion_post.lcp	8 Oct 2007 14:22:27 -0000	1.3
***************
*** 93,98 ****
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->next_record()) {
! 			$t['perms'][$db->Record[0]] = true;
  		}
  		if (!$t['perms']['dele']) { 
--- 93,98 ----
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->nextRecord()) {
! 			$t['perms'][$db->record[0]] = true;
  		}
  		if (!$t['perms']['dele']) { 
***************
*** 112,117 ****
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->next_record()) {
! 			$t['perms'][$db->Record[0]] = true;
  		}
  		if (!$t['perms']['dele']) { 
--- 112,117 ----
  		$x = " lc_forum_perm_group='".implode("' or lc_forum_perm_group='",$u->groups)."' ";
  		$db->query("select distinct lc_forum_perm_action from lc_forum_perm where lc_forum_id=".(int)$key." and $x");
! 		while($db->nextRecord()) {
! 			$t['perms'][$db->record[0]] = true;
  		}
  		if (!$t['perms']['dele']) { 

Index: presentations.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/presentations.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** presentations.lcp	21 Nov 2003 23:14:08 -0000	1.1.1.1
--- presentations.lcp	8 Oct 2007 14:22:27 -0000	1.2
***************
*** 36,40 ****
  			and status=1';
  		$db->queryOne($sql);
! 		$t['inactivePresCount'] = $db->Record['inactivePresCount'];
  
  		$dg = new datagrid( $this->modules, $this->serviceName );
--- 36,40 ----
  			and status=1';
  		$db->queryOne($sql);
! 		$t['inactivePresCount'] = $db->record['inactivePresCount'];
  
  		$dg = new datagrid( $this->modules, $this->serviceName );
***************
*** 65,69 ****
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$t['pres'] = $db->Record;
  	}
  
--- 65,69 ----
  		$db->RESULT_TYPE = MYSQL_ASSOC;
  		$db->queryOne($sql);
! 		$t['pres'] = $db->record;
  	}
  

Index: gradebook.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/gradebook.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** gradebook.lcp	15 Feb 2007 02:45:45 -0000	1.3
--- gradebook.lcp	8 Oct 2007 14:22:27 -0000	1.4
***************
*** 59,67 ****
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->next_record() ) {
! 			if ($u->username == $db->Record['username']) {
! 				$usersScore = $db->Record['score'];
  			}
! 			$scores[$db->Record['username']] = $db->Record['score'];
  		}
  
--- 59,67 ----
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->nextRecord() ) {
! 			if ($u->username == $db->record['username']) {
! 				$usersScore = $db->record['score'];
  			}
! 			$scores[$db->record['username']] = $db->record['score'];
  		}
  

Index: faq.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/faq.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** faq.lcp	21 Nov 2003 23:14:08 -0000	1.1.1.1
--- faq.lcp	8 Oct 2007 14:22:27 -0000	1.2
***************
*** 40,45 ****
  				order by category, clicks desc';
  			$db->query($sql);
! 			while ($db->next_record())
! 				$t['faqs'][] = $db->Record;
  
  			$inactivelinks[] = 'FAQs';
--- 40,45 ----
  				order by category, clicks desc';
  			$db->query($sql);
! 			while ($db->nextRecord())
! 				$t['faqs'][] = $db->record;
  
  			$inactivelinks[] = 'FAQs';
***************
*** 62,66 ****
  				and id_class_faqs='.(int)$lc->getvars['id'];
  			$db->queryOne($sql);
! 			$t['faq'] = $db->Record;
  
  		}
--- 62,66 ----
  				and id_class_faqs='.(int)$lc->getvars['id'];
  			$db->queryOne($sql);
! 			$t['faq'] = $db->record;
  
  		}

Index: gradebookallsem.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classroom/gradebookallsem.lcp,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** gradebookallsem.lcp	29 Aug 2004 22:50:20 -0000	1.1
--- gradebookallsem.lcp	8 Oct 2007 14:22:27 -0000	1.2
***************
*** 84,92 ****
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->next_record() ) {
! 			if ($u->username == $db->Record['username']) {
! 				$usersScore = $db->Record['score'];
  			}
! 			$scores[$db->Record['username']] = $db->Record['score'];
  		}
  
--- 84,92 ----
  		//assume rank is one, push rank down for each student that has a higher score
  		$t['rank'] = 1;
! 		while ($db->nextRecord() ) {
! 			if ($u->username == $db->record['username']) {
! 				$usersScore = $db->record['score'];
  			}
! 			$scores[$db->record['username']] = $db->record['score'];
  		}
  

[Logicampus-cvs] logicampus/src/logicreate/services/classmgr adjustDates.lcp, 1.2, 1.3 adjustLessonDates.lcp, 1.1, 1.2 assignmentManage.lcp, 1.24, 1.25 cal.lcp, 1.5, 1.6 classSetup.lcp, 1.6, 1.7 contactStudents.lcp, 1.10, 1.11 dataexchange.lcp, 1.5, 1.6 ettendance.lcp, 1.3, 1.4 examschedule.lcp, 1.4, 1.5 exportContent.lcp, 1.19, 1.20 forum.lcp, 1.5, 1.6 lessonContent.lcp, 1.14, 1.15 lessonManager.lcp, 1.40, 1.41 lessonNew.lcp, 1.11, 1.12 lessonObjectives.lcp, 1.5, 1.6 lessonWebliography.lcp, 1.5, 1.6 links.lcp, 1.3, 1.4 orientations.lcp, 1.2, 1.3 semestercopy.lcp, 1.16, 1.17 seminars.lcp, 1.2, 1.3 studentPresentation.lcp, 1.3, 1.4 studentProfile.lcp, 1.3, 1.4 teacherclass.lcp, 1.13, 1.14 textbooks.lcp, 1.2, 1.3 users.lcp, 1.9, 1.10

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

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]

[Logicampus-cvs] logicampus/src/logicreate/services/classdoclib addFile.lcp, 1.2, 1.3 download.lcp, 1.3, 1.4 editFile.lcp, 1.1.1.1, 1.2 editFolder.lcp, 1.3, 1.4 main.lcp, 1.1.1.1, 1.2 trash.lcp, 1.1.1.1, 1.2 wysiwygcontentlinks.lcp, 1.2, 1.3 wysiwygimages.lcp, 1.2, 1.3 wysiwyglinks.lcp, 1.2, 1.3 wysiwygswf.lcp, 1.2, 1.3

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

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

Modified Files:
	addFile.lcp download.lcp editFile.lcp editFolder.lcp main.lcp 
	trash.lcp wysiwygcontentlinks.lcp wysiwygimages.lcp 
	wysiwyglinks.lcp wysiwygswf.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: wysiwygswf.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/wysiwygswf.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** wysiwygswf.lcp	21 Aug 2004 21:33:19 -0000	1.2
--- wysiwygswf.lcp	8 Oct 2007 14:19:51 -0000	1.3
***************
*** 50,54 ****
  			if ($openFolder=='') {
  				$db->queryOne("select pkey from classdoclib_Folders where order by pkey ASC");
! 				$openFolder = $db->Record[0]; 
  			}
  		}
--- 50,54 ----
  			if ($openFolder=='') {
  				$db->queryOne("select pkey from classdoclib_Folders where order by pkey ASC");
! 				$openFolder = $db->record[0]; 
  			}
  		}

Index: trash.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/trash.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** trash.lcp	21 Nov 2003 23:14:05 -0000	1.1.1.1
--- trash.lcp	8 Oct 2007 14:19:51 -0000	1.2
***************
*** 22,27 ****
  		and class_id = '.$u->activeClassTaught->id_classes);
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while($db->next_record()) {;
! 			$t['trash'][] =$db->Record;
  		}
  	}
--- 22,27 ----
  		and class_id = '.$u->activeClassTaught->id_classes);
  		$db->RESULT_TYPE = MYSQL_ASSOC;
! 		while($db->nextRecord()) {;
! 			$t['trash'][] =$db->record;
  		}
  	}

Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/main.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** main.lcp	21 Nov 2003 23:14:05 -0000	1.1.1.1
--- main.lcp	8 Oct 2007 14:19:51 -0000	1.2
***************
*** 35,39 ****
  		$thisclass = $u->activeClassTaught->id_classes;
  		$db->queryOne("select * from classdoclib_Folders where class_id=$thisclass and owner='".$u->username."' and folderType=0");
! 		if ($db->Record['pkey']==0) { 
  			$db->query("insert into classdoclib_Folders (name,parentKey,owner,class_id,folderType) values ('Trash',0,'{$u->username}','{$thisclass}',0)");
  		}
--- 35,39 ----
  		$thisclass = $u->activeClassTaught->id_classes;
  		$db->queryOne("select * from classdoclib_Folders where class_id=$thisclass and owner='".$u->username."' and folderType=0");
! 		if ($db->record['pkey']==0) { 
  			$db->query("insert into classdoclib_Folders (name,parentKey,owner,class_id,folderType) values ('Trash',0,'{$u->username}','{$thisclass}',0)");
  		}
***************
*** 52,61 ****
  		if ($openFolder) { 
  			$db->queryOne("select trashed,folderType from classdoclib_Folders where pkey=".(int)$openFolder);
! 			$folderType = $db->Record['folderType'];
  			if ($folderType==0) { $t['isTrash'] = 'y'; $isTrash = 'y';}
! 			if ($db->Record['trashed']=='') { $db->Record['trashed']='n'; }
! 			$t['isTrashed'] = $db->Record['trashed'];
! 			$t['folderType'] = $db->Record['folderType'];
! 			$isTrashed = $db->Record['trashed'];
  		}
  		if ($lcObj->getvars["order"]) { $u->sessionvars["filesorder"] = $lcObj->getvars["order"]; }
--- 52,61 ----
  		if ($openFolder) { 
  			$db->queryOne("select trashed,folderType from classdoclib_Folders where pkey=".(int)$openFolder);
! 			$folderType = $db->record['folderType'];
  			if ($folderType==0) { $t['isTrash'] = 'y'; $isTrash = 'y';}
! 			if ($db->record['trashed']=='') { $db->record['trashed']='n'; }
! 			$t['isTrashed'] = $db->record['trashed'];
! 			$t['folderType'] = $db->record['folderType'];
! 			$isTrashed = $db->record['trashed'];
  		}
  		if ($lcObj->getvars["order"]) { $u->sessionvars["filesorder"] = $lcObj->getvars["order"]; }

Index: editFolder.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/editFolder.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** editFolder.lcp	15 May 2007 17:27:47 -0000	1.3
--- editFolder.lcp	8 Oct 2007 14:19:51 -0000	1.4
***************
*** 207,212 ****
  		$query = 'insert into classdoclib_Sharing (folderKey, action, exclude, gid) VALUES (%d, %d, %d, "%s")';
  
! 		while ( $db->next_record() ) {
! 			$db->query( sprintf($query,$cat->pkey,$db->Record['action'],$db->Record['exclude'],$db->Record['gid']) );
  		}
  
--- 207,212 ----
  		$query = 'insert into classdoclib_Sharing (folderKey, action, exclude, gid) VALUES (%d, %d, %d, "%s")';
  
! 		while ( $db->nextRecord() ) {
! 			$db->query( sprintf($query,$cat->pkey,$db->record['action'],$db->record['exclude'],$db->record['gid']) );
  		}
  
***************
*** 228,232 ****
  		// selecting trash can (to move the requested folder too)
  		$db->queryOne("select pkey from classdoclib_Folders where folderType=0 and class_id=".$u->activeClassTaught->id_classes);
! 		$trashFolder = $db->Record['pkey'];
  
  		$db->query("update classdoclib_Folders set trashed='y', origparent= parentKey, parentKey=$trashFolder where (owner='".$u->username."' and pkey=".$trash->pkey. ")");
--- 228,232 ----
  		// selecting trash can (to move the requested folder too)
  		$db->queryOne("select pkey from classdoclib_Folders where folderType=0 and class_id=".$u->activeClassTaught->id_classes);
! 		$trashFolder = $db->record['pkey'];
  
  		$db->query("update classdoclib_Folders set trashed='y', origparent= parentKey, parentKey=$trashFolder where (owner='".$u->username."' and pkey=".$trash->pkey. ")");
***************
*** 272,276 ****
  		// Finding our trash folder
  		$db->queryOne("select pkey from classdoclib_Folders where folderType=0 and class_id=".$u->activeClassTaught->id_classes);
! 		$trashFolder = $db->Record['pkey'];
  		
  		if ((int)$trashFolder == 0)
--- 272,276 ----
  		// Finding our trash folder
  		$db->queryOne("select pkey from classdoclib_Folders where folderType=0 and class_id=".$u->activeClassTaught->id_classes);
! 		$trashFolder = $db->record['pkey'];
  		
  		if ((int)$trashFolder == 0)
***************
*** 284,289 ****
  		// selecting folders that were marked for trashing at an earlier time
  		$db->query("select pkey from classdoclib_Folders where trashed='y' and folderType=2 and class_id = ".$u->activeClassTaught->id_classes);
! 		while($db->next_record()) {
! 			$folders[] = $db->Record['pkey'];
  		}
  		
--- 284,289 ----
  		// selecting folders that were marked for trashing at an earlier time
  		$db->query("select pkey from classdoclib_Folders where trashed='y' and folderType=2 and class_id = ".$u->activeClassTaught->id_classes);
! 		while($db->nextRecord()) {
! 			$folders[] = $db->record['pkey'];
  		}
  		
***************
*** 313,318 ****
  	$loop = array();
  	
! 	while($db->next_record()) {
! 		$loop[] = $db->Record['pkey'];
  	}
  	
--- 313,318 ----
  	$loop = array();
  	
! 	while($db->nextRecord()) {
! 		$loop[] = $db->record['pkey'];
  	}
  	

Index: wysiwygimages.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/wysiwygimages.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** wysiwygimages.lcp	21 Aug 2004 21:33:19 -0000	1.2
--- wysiwygimages.lcp	8 Oct 2007 14:19:51 -0000	1.3
***************
*** 72,76 ****
  		$db = DB::getHandle();
  		$db->queryOne("select pkey from classdoclib_Folders where (owner='$facultyId' and name like 'Web Images%') order by pkey ASC");
! 		return $db->Record['pkey'];
  		
  	}
--- 72,76 ----
  		$db = DB::getHandle();
  		$db->queryOne("select pkey from classdoclib_Folders where (owner='$facultyId' and name like 'Web Images%') order by pkey ASC");
! 		return $db->record['pkey'];
  		
  	}
***************
*** 91,95 ****
  			if ($openFolder=='') {
  				$db->queryOne("select pkey from classdoclib_Folders  order by pkey ASC");
! 				$openFolder = $db->Record[0]; 
  			}
  		}
--- 91,95 ----
  			if ($openFolder=='') {
  				$db->queryOne("select pkey from classdoclib_Folders  order by pkey ASC");
! 				$openFolder = $db->record[0]; 
  			}
  		}

Index: wysiwyglinks.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/wysiwyglinks.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** wysiwyglinks.lcp	21 Aug 2004 21:33:19 -0000	1.2
--- wysiwyglinks.lcp	8 Oct 2007 14:19:51 -0000	1.3
***************
*** 52,58 ****
  		$db->query($sql);
  
! 		while ($db->next_record())
  		{
! 			$t['links'][] = "\n\n\n\n".'<a onclick="parent.document.getElementById(\'linklabel\').value = \''.addslashes(stripslashes(htmlentities($db->Record['txTitle']))).'\'; parent.document.getElementById(\'url\').value = \''. appurl('classroom/lessons/event=viewcontent/id='.$db->Record['id_class_lesson_content']).'\'; return false;" href="#">'.htmlentities(stripslashes($db->Record['txTitle']), ENT_QUOTES).'</a>';
  		
  		}
--- 52,58 ----
  		$db->query($sql);
  
! 		while ($db->nextRecord())
  		{
! 			$t['links'][] = "\n\n\n\n".'<a onclick="parent.document.getElementById(\'linklabel\').value = \''.addslashes(stripslashes(htmlentities($db->record['txTitle']))).'\'; parent.document.getElementById(\'url\').value = \''. appurl('classroom/lessons/event=viewcontent/id='.$db->record['id_class_lesson_content']).'\'; return false;" href="#">'.htmlentities(stripslashes($db->record['txTitle']), ENT_QUOTES).'</a>';
  		
  		}

Index: wysiwygcontentlinks.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/wysiwygcontentlinks.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** wysiwygcontentlinks.lcp	21 Aug 2004 21:33:19 -0000	1.2
--- wysiwygcontentlinks.lcp	8 Oct 2007 14:19:51 -0000	1.3
***************
*** 50,54 ****
  			if ($openFolder=='') {
  				$db->queryOne("select pkey from classdoclib_Folders order by pkey ASC");
! 				$openFolder = $db->Record[0]; 
  			}
  		}
--- 50,54 ----
  			if ($openFolder=='') {
  				$db->queryOne("select pkey from classdoclib_Folders order by pkey ASC");
! 				$openFolder = $db->record[0]; 
  			}
  		}

Index: addFile.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/addFile.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** addFile.lcp	27 Aug 2005 01:10:09 -0000	1.2
--- addFile.lcp	8 Oct 2007 14:19:51 -0000	1.3
***************
*** 28,35 ****
  		}
  		$db->query('select name from classdoclib_Folders where pkey = '.$lcObj->getvars['fid']);
! 		$db->next_record();
  
  		$t['max_file_size'] = sprintf("%.2f",ini_get('upload_max_filesize'));
! 		$t['folderName' ] = $db->Record['name'];
  		$t['folderID' ] = $lcObj->getvars['fid'];
  
--- 28,35 ----
  		}
  		$db->query('select name from classdoclib_Folders where pkey = '.$lcObj->getvars['fid']);
! 		$db->nextRecord();
  
  		$t['max_file_size'] = sprintf("%.2f",ini_get('upload_max_filesize'));
! 		$t['folderName' ] = $db->record['name'];
  		$t['folderID' ] = $lcObj->getvars['fid'];
  

Index: editFile.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/editFile.lcp,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** editFile.lcp	21 Nov 2003 23:14:05 -0000	1.1.1.1
--- editFile.lcp	8 Oct 2007 14:19:51 -0000	1.2
***************
*** 140,146 ****
  			$db->query("update classdoclib_Files set folder=origfolder, trashed='n' where pkey=".(int)$lc->getvars['file']);
  			$db->queryOne("select folder from classdoclib_Files where pkey=".(int)$lc->getvars['file']);
! 			$folder = $db->Record['folder'];
  			$db->queryOne("select trashed from classdoclib_Folders where pkey=$folder");
! 			if ($db->Record['trashed']=='y') { 
  			$db->query("update classdoclib_Files set folder=0, trashed='n' where pkey=".(int)$lc->getvars['file']);
  			}
--- 140,146 ----
  			$db->query("update classdoclib_Files set folder=origfolder, trashed='n' where pkey=".(int)$lc->getvars['file']);
  			$db->queryOne("select folder from classdoclib_Files where pkey=".(int)$lc->getvars['file']);
! 			$folder = $db->record['folder'];
  			$db->queryOne("select trashed from classdoclib_Folders where pkey=$folder");
! 			if ($db->record['trashed']=='y') { 
  			$db->query("update classdoclib_Files set folder=0, trashed='n' where pkey=".(int)$lc->getvars['file']);
  			}
***************
*** 160,164 ****
  		$class_id = $u->activeClassTaught->id_classes;
  		$db->queryOne("select pkey from classdoclib_Folders where class_id='$class_id' and folderType=0");
! 		$trashPkey = $db->Record['pkey'];
  
  		$trash = LC_file::getSingle($lc->getvars['file'],$u->activeClassTaught->id_classes,FOLDER_EDIT);
--- 160,164 ----
  		$class_id = $u->activeClassTaught->id_classes;
  		$db->queryOne("select pkey from classdoclib_Folders where class_id='$class_id' and folderType=0");
! 		$trashPkey = $db->record['pkey'];
  
  		$trash = LC_file::getSingle($lc->getvars['file'],$u->activeClassTaught->id_classes,FOLDER_EDIT);

Index: download.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classdoclib/download.lcp,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** download.lcp	21 Aug 2004 22:22:12 -0000	1.3
--- download.lcp	8 Oct 2007 14:19:51 -0000	1.4
***************
*** 78,82 ****
  			';
  			$db->queryOne($sql);
! 			if ($db->Record == false) {
  				//no permission to view this file
  				$this->presentor = 'errorMessage';
--- 78,82 ----
  			';
  			$db->queryOne($sql);
! 			if ($db->record == false) {
  				//no permission to view this file
  				$this->presentor = 'errorMessage';
***************
*** 86,90 ****
  			}
  			
! 		$pkey = $db->Record['pkey'];			
  		}
  		// END FHASH
--- 86,90 ----
  			}
  			
! 		$pkey = $db->record['pkey'];			
  		}
  		// END FHASH

[Logicampus-cvs] logicampus/src/logicreate/services/classchat main.lcp, 1.8, 1.9

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

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

Modified Files:
	main.lcp 
Log Message:
Change function "next_record" to "nextRecord".


Index: main.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/classchat/main.lcp,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** main.lcp	11 Feb 2007 22:41:08 -0000	1.8
--- main.lcp	8 Oct 2007 14:19:07 -0000	1.9
***************
*** 111,117 ****
  				</tr>';
  				$i_posting = 0;
! 				while ($db->next_record())
  				{	
! 			$temp = $db->Record;
  			unset($temp['pkey']);
  			$check = md5(serialize($temp));
--- 111,117 ----
  				</tr>';
  				$i_posting = 0;
! 				while ($db->nextRecord())
  				{	
! 			$temp = $db->record;
  			unset($temp['pkey']);
  			$check = md5(serialize($temp));
***************
*** 119,125 ****
  				$i_posting ++;
  					$t['output'] .= '<tr style="background-color: '.(($i_posting%2) ? '#e7e7e7': '').'">
! 						<td valign="top"><a target="_blank" href="'.appurl('users/view/'.$db->Record['username']).'">'.$db->Record['username'].'</a></td>
! 						<td valign="top">'.date('g:i A', $db->Record['timeint']). '</td>
! 						<td valign="top">'.stripslashes($db->Record['message']). '</td>
  					</tr>';
  			}
--- 119,125 ----
  				$i_posting ++;
  					$t['output'] .= '<tr style="background-color: '.(($i_posting%2) ? '#e7e7e7': '').'">
! 						<td valign="top"><a target="_blank" href="'.appurl('users/view/'.$db->record['username']).'">'.$db->record['username'].'</a></td>
! 						<td valign="top">'.date('g:i A', $db->record['timeint']). '</td>
! 						<td valign="top">'.stripslashes($db->record['message']). '</td>
  					</tr>';
  			}
***************
*** 212,228 ****
  
  		$x = 0;
! 		while($db->next_record()) {
! 			$t['rows'][] = $db->Record;
! 			$max = $db->Record['pkey'];
! 			if (strlen($db->Record['message']) < 1) {
  				$message = '&nbsp;';
  			} else {
! 				$message = htmlentities($db->Record['message']);
  				$message = url2links($message);
! 				//$message = $db->Record['message'];
  			}
  
! 			$out[$x]['html'] = '<div class="chat_message_time">'.date('H:i:s',$db->Record['timeint']).'</div><div class="chat_message_user">'.$db->Record['username'].':</div><div class="chat_message_body">'.$message.'</div>';
! 			$out[$x]['id']  = $db->Record['pkey'];
  			$x++;
  		}
--- 212,228 ----
  
  		$x = 0;
! 		while($db->nextRecord()) {
! 			$t['rows'][] = $db->record;
! 			$max = $db->record['pkey'];
! 			if (strlen($db->record['message']) < 1) {
  				$message = '&nbsp;';
  			} else {
! 				$message = htmlentities($db->record['message']);
  				$message = url2links($message);
! 				//$message = $db->record['message'];
  			}
  
! 			$out[$x]['html'] = '<div class="chat_message_time">'.date('H:i:s',$db->record['timeint']).'</div><div class="chat_message_user">'.$db->record['username'].':</div><div class="chat_message_body">'.$message.'</div>';
! 			$out[$x]['id']  = $db->record['pkey'];
  			$x++;
  		}
***************
*** 240,245 ****
  		$lc->templateName = "chat_show";
  		$db->query("select * from chatThreads");
! 		while($db->next_record()) { 
! 			extract($db->Record);
  			$x = "<a href=\"#\" onClick=\"window.open('";
  			$x .= appurl("{$this->module_name}/chat/event=admin/chatThread=$chatThread");
--- 240,245 ----
  		$lc->templateName = "chat_show";
  		$db->query("select * from chatThreads");
! 		while($db->nextRecord()) { 
! 			extract($db->record);
  			$x = "<a href=\"#\" onClick=\"window.open('";
  			$x .= appurl("{$this->module_name}/chat/event=admin/chatThread=$chatThread");
***************
*** 255,259 ****
  		$arg->templateName='chat_usershow';
  		$db->queryOne("select * from lcUsers where username='".$arg->getvars['username']."'"); 
! 		$t['usershow'] = $db->Record;
  		$this->presentor = "emptypresentation";
  	}
--- 255,259 ----
  		$arg->templateName='chat_usershow';
  		$db->queryOne("select * from lcUsers where username='".$arg->getvars['username']."'"); 
! 		$t['usershow'] = $db->record;
  		$this->presentor = "emptypresentation";
  	}
***************
*** 263,268 ****
  		$arg->templateName='chat_userlist';
  		$db->query("select distinct(username) from chat where chat_id='{$this->chatId}' and timeint>=".(time()-900)." order by username");
! 		while($db->next_record()) {
! 			$t['users'][] = $db->Record;
  		}
  		$this->presentor = "emptypresentation";
--- 263,268 ----
  		$arg->templateName='chat_userlist';
  		$db->query("select distinct(username) from chat where chat_id='{$this->chatId}' and timeint>=".(time()-900)." order by username");
! 		while($db->nextRecord()) {
! 			$t['users'][] = $db->record;
  		}
  		$this->presentor = "emptypresentation";
***************
*** 361,366 ****
  		$db->query($sql);
  
! 		while($db->next_record()) {
! 			extract($db->Record);
  			$message = stripslashes($message);
  			$post = "<a href=\"".appurl("chat/main/event=moveQ/move=1/pkey=$pkey")."\">approve</a>\n";
--- 361,366 ----
  		$db->query($sql);
  
! 		while($db->nextRecord()) {
! 			extract($db->record);
  			$message = stripslashes($message);
  			$post = "<a href=\"".appurl("chat/main/event=moveQ/move=1/pkey=$pkey")."\">approve</a>\n";
***************
*** 384,388 ****
  			if ($lc->getvars["move"]==1) { 
  				$db->queryOne("select * from chatQ where pkey=$pkey");
! 				extract($db->Record);
  				$message = addslashes($message);
  				$username = addslashes($username);
--- 384,388 ----
  			if ($lc->getvars["move"]==1) { 
  				$db->queryOne("select * from chatQ where pkey=$pkey");
! 				extract($db->record);
  				$message = addslashes($message);
  				$username = addslashes($username);