| 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/_Archive/ |
Upload File : |
<?
// classRosterProcess.phpinc
//setDebugOn();
debugTrackBegin();
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; }
if ($_SESSION['uuid'] != $f_uuid) {
if ($f_subtask == "Process Changes" || $f_subtask == "Process Adds Only") {
$f_classRosterAdd = 1;
} else {
$f_classRosterAdd = 0;
}
if ($f_subtask == "Process Changes" || $f_subtask == "Process Drops Only") {
$f_classRosterDrop = 1;
} else {
$f_classRosterDrop = 0;
}
$f_classRosterEnteredCount = formValue('classRosterEnteredCount');
if (dc()) {
printVar("\$f_classRosterAdd",$f_classRosterAdd);
printVar("\$f_classRosterDrop",$f_classRosterDrop);
printVar("\$f_classRosterEnteredCount",$f_classRosterEnteredCount);
}
if ($f_classRosterEnteredCount) {
for ($i=0; $i<$f_classRosterEnteredCount; $i++) {
$f_Action = formValue('Action_'.$i);
$f_userAdvisor = formValue('Advisor_'.$i);
$f_userClassification = formValue('Classification_'.$i);
$f_credits = formValue('Credits_'.$i);
$f_userMajor = formValue('Major_'.$i);
$f_userFirstName = formValue('userFirstName_'.$i);
$f_userLastName = formValue('userLastName_'.$i);
$f_userMiddleName = formValue('userMiddleName_'.$i);
$f_userStudentId = formValue('userStudentId_'.$i);
if (dc()) {
printVar("\$f_Action",$f_Action);
printVar("\$f_userAdvisor",$f_userAdvisor);
printVar("\$f_userClassification",$f_userClassification);
printVar("\$f_credits",$f_credits);
printVar("\$f_userMajor",$f_userMajor);
printVar("\$f_userFirstName",$f_userFirstName);
printVar("\$f_userLastName",$f_userLastName);
printVar("\$f_userMiddleName",$f_userMiddleName);
printVar("\$f_userStudentId",$f_userStudentId);
}
if ($f_classRosterAdd == 1 && $f_Action == "Add") {
if (dc()) {
echo basename(__FILE__)," line ",__LINE__,": ",'<span class="user',$f_Action,'">',$f_userStudentId,' ',$f_userFirstName,' ',$f_userLastName,'</span> added.<br />';
}
$f_lastModified = currentDateTime();
$query = "
INSERT INTO classstudent (
classId,
classstudentCredits,
userStudentId,
userFirstName,
userMiddleName,
userLastName,
LastModified,
modifiedBy
) VALUES (
".$f_classId.",
".$f_credits.",
'".$f_userStudentId."',
'".$f_userFirstName."',
'".$f_userMiddleName."',
'".$f_userLastName."',
'".$f_lastModified."',
".$_SESSION['userId']."
)";
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","\$query=".$query."<br>\n";
}
if (dc()) {
printVar("\$query",$query);
}
$classstudentInsert = query_do($query);
}
if ($f_classRosterDrop == 1 && $f_Action == "Drop") {
if (dc()) {
echo basename(__FILE__)," line ",__LINE__,": ",'<span class="user',$f_Action,'">',$f_userStudentId,' ',$f_userFirstName,' ',$f_userLastName,'</span> dropped.<br />';
}
$query = "
DELETE FROM classstudent
WHERE classId = ".$f_classId."
AND userStudentId = '".$f_userStudentId."'
AND userFirstName = '".$f_userFirstName."'
AND userLastName = '".$f_userLastName."'
";
if (dc()) {
printVar("\$query",$query);
}
$classstudentDelete = query_do($query);
}
if ($f_Action == "Both") {
if (dc()) {
echo basename(__FILE__)," line ",__LINE__,": ",'<span class="user',$f_Action,'">',$f_userStudentId,' ',$f_userFirstName,' ',$f_userLastName,'</span> retained.<br />';
}
}
if ($f_Action == "Add" || $f_Action == "Both") {
// See if this user is in userdata.
$query = "
SELECT userStudentId
FROM userdata
WHERE userStudentId = '".$f_userStudentId."'
";
$userdataResult = query_do($query);
$userdataCount = $_SESSION['mysql_num_rows'];
if ($userdataCount) {
// The user is already in userdata. UPDATE the user data.
$query = "
UPDATE userdata
SET userStudentId = '".$f_userStudentId."',
userAdvisor = '".$f_userAdvisor."',
userClassification = '".$f_userClassification."',
userMajor = '".$f_userMajor."'
WHERE userStudentId = '".$f_userStudentId."'
";
$userdataUpdate = query_do($query);
} else {
// The user not in userdata. INSERET the user data.
$query = "
INSERT INTO userdata (
userStudentId,
userAdvisor,
userClassification,
userMajor
) VALUES ( '".$f_userStudentId."',
'".$f_userAdvisor."',
'".$f_userClassification."',
'".$f_userMajor."'
)";
$userdataInsert = query_do($query);
}
}
}
}
if (!dc()) {
$_SESSION['uuid'] = $f_uuid;
}
}
debugTrackEnd();
if (dc()) {
printVar("exit",'','fn'); exit;
}
#setDebugOff();
?>