[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'];
  		}