[Logicampus-cvs] logicampus/src/logicreate/services/helpdesk faq.lcp, 1.3, 1.4 hdCategory.lcp, 1.1.

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

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/helpdesk faq.lcp, 1.3, 1.4 hdCategory.lcp, 1.1.

[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