| 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/DARS.cloak/RankClasses/ |
Upload File : |
<?
// /Admin/DARS/RankClasses/RankClasses_Verify.phpinc
// purpose_of_page_goes_here
#$DEBUG_RankClasses_Verify = true;
if ( !isset($DEBUG_RankClasses_Verify) ) $DEBUG_RankClasses_Verify = false;
// Get darsclassIds.
$query = "
SELECT darsclassId,
darsclassDept,
darsclassNumb,
darsclassCredits
FROM `darsclass`
ORDER BY darsclassDept, darsclassNumb
";
$darsclassResult = query_do($query);
$darsclassResultCount = $_SESSION['qry']['count'];
if (!$darsclassResultCount) {
$f_error = 'There are no darsclassIds.<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
}
// Get darscredentialcodeIds.
$query = "
SELECT darscredentialcodeId,
darscredentialcodeCode
FROM `darscredentialcode`
ORDER BY darscredentialcodeCode
";
$darscredentialcodeResult = query_do($query);
$darscredentialcodeResultCount = $_SESSION['qry']['count'];
if (!$darscredentialcodeResultCount) {
$f_error = 'There are no darscredentialcodeIds.<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
}
$f_error = '';
$f_message = '';
mysql_data_seek($darsclassResult, 0);
while ($darsclassRow = mysql_fetch_assoc($darsclassResult)) {
$f_darsclassId = $darsclassRow['darsclassId'];
$f_darsclassCredits = formValue('darsclassCredits_'.$f_darsclassId);
if ($f_darsclassCredits == '') $f_darsclassCredits = -1;
$f_darsclassOffered = formValue('darsclassOffered_'.$f_darsclassId);
if ($f_darsclassOffered == '') $f_darsclassOffered = 0;
if (is_numeric($f_darsclassCredits)) {
// UPDATE the darsclassCredits.
$query = "
UPDATE `darsclass`
SET darsclassCredits = ".$f_darsclassCredits.",
darsclassOffered = ".$f_darsclassOffered."
WHERE darsclassId = ".$f_darsclassId."
";
$darsclassUpdate = query_do($query);
#if ($f_darsclassCredits != -1) $f_message .= $darsclassRow['darsclassDept'].$darsclassRow['darsclassNumb'].' credits set to '.$f_darsclassCredits.'.<br>';
} else {
$f_error .= $darsclassRow['darsclassDept'].$darsclassRow['darsclassNumb'].' credits set to non-numeric value ('.htmlView($f_darsclassCredits).').<br>';
}
#if ($f_darsclassCredits != '') printVar('$f_darsclassCredits_'.$f_darsclassId,$f_darsclassCredits);
mysql_data_seek($darscredentialcodeResult, 0);
while ($darscredentialcodeRow = mysql_fetch_assoc($darscredentialcodeResult)) {
$f_darscredentialcodeId = $darscredentialcodeRow['darscredentialcodeId'];
$f_darsclassrankRank = formValue('darsclassrankRank_'.$f_darsclassId.'_'.$f_darscredentialcodeId);
if ($f_darsclassrankRank == '') $f_darsclassrankRank = 0;
#if ($f_darsclassrankRank != f_darsclassrankRank) printVar('$f_darsclassrankRank_'.$f_darsclassId.'_'.$f_darscredentialcodeId,$f_darsclassrankRank);
if (is_numeric($f_darsclassrankRank)) {
// Test if the darsclassId is in the database.
$query = "
SELECT darsclassrankId
FROM `darsclassrank`
WHERE darsclassId = ".$f_darsclassId."
AND darscredentialcodeId = ".$f_darscredentialcodeId."
";
$darsclassrankResult = query_do($query);
$darsclassrankResultCount = $_SESSION['qry']['count'];
if ($darsclassrankResultCount) {
// UPDATE the darsclassrankRank.
$query = "
UPDATE `darsclassrank`
SET darsclassrankRank = ".$f_darsclassrankRank."
WHERE darsclassId = ".$f_darsclassId."
AND darscredentialcodeId = ".$f_darscredentialcodeId."
";
$darsclassrankUpdate = query_do($query);
#if ($f_darsclassrankRank != 0) $f_message .= $darsclassRow['darsclassDept'].$darsclassRow['darsclassNumb'].' rank for '.$darscredentialcodeRow['darscredentialcodeCode'].' set to '.$f_darsclassrankRank.'.<br>';
} else {
// INSERT the darsclassrankRank.
$query = "
INSERT
INTO `darsclassrank` (
darsclassId,
darscredentialcodeId,
darsclassrankRank
) VALUES (
".$f_darsclassId.",
".$f_darscredentialcodeId.",
".$f_darsclassrankRank."
)
";
$darsclassrankInsert = query_do($query);
if ( $DEBUG_RankClasses_Verify ) printVar('$query',$query,'q');
}
} else {
$f_error .= $darsclassRow['darsclassDept'].$darsclassRow['darsclassNumb'].' rank for '.$darscredentialcodeRow['darscredentialcodeCode'].' set to non-numeric value ('.htmlView($f_darsclassrankRank).').<br>';
}
}
}
?>