| 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/Advising/ParseClasses/ |
Upload File : |
<?
// Admin/Advising/ParseClasses/UpdateClasses_Meetings.phpinc
// Update pclass data.
$d_O = d_O(); #d_On(); // Uncomment to DEBUG.
d_Line(basename(__FILE__));
d_Var('$class',$class,'k');
d_Var("\$class['MEETING']",$class['MEETING'],'k');
// DELETE class meetings.
$query = "
DELETE
FROM `pclassmeeting`
WHERE YRTR = '".query_safe($_SESSION['YRTR']['User'])."'
AND COU_ID = '".query_safe($class['COU_ID'])."'
";
$pclassmeetingDelete = query_do($query);
/** /
$d_O = d_O(); d_On(); // Uncomment to DEBUG.
d_Line($index.': '.$class['COU_ID'].' '.$class['SUBJ'].$class['NBR'].' '.$class['TITLE'].'.','li');
if ( isset($d_O) && !$d_O ) d_Off();
/**/
// INSERT meetings.
$meetingIndex = 0;
foreach ( $class['MEETING'] as $meeting ) {
d_Var('$meeting',$meeting,'');
$INSTRUCTOR = '';
foreach( $meeting['INSTRUCTOR'] as $instructor ) {
$INSTRUCTOR = listAppend($INSTRUCTOR,$instructor);
}
if ( $meeting['MTG_START'] ) { $meeting['MTG_START'] = "'".query_safe($meeting['MTG_START'])."'"; } else { $meeting['MTG_START'] = 'NULL'; }
if ( $meeting['MTG_END'] ) { $meeting['MTG_END'] = "'".query_safe($meeting['MTG_END'])."'"; } else { $meeting['MTG_END'] = 'NULL'; }
if ( $meeting['BEGIN'] ) { $meeting['BEGIN'] = "'".query_safe($meeting['BEGIN'])."'"; } else { $meeting['BEGIN'] = 'NULL'; }
if ( $meeting['END'] ) { $meeting['END'] = "'".query_safe($meeting['END'])."'"; } else { $meeting['END'] = 'NULL'; }
$query = "
INSERT
INTO `pclassmeeting` (
YRTR,
COU_ID,
numb,
MTG_START,
MTG_END,
DAYS,
BEGIN,
END,
BLDG,
ROOM,
INSTRUCTOR
) VALUES (
'".query_safe($_SESSION['YRTR']['User'])."',
'".query_safe($class['COU_ID'])."',
'".query_safe($meetingIndex)."',
".$meeting['MTG_START'].",
".$meeting['MTG_END'].",
'".query_safe($meeting['DAYS'])."',
".$meeting['BEGIN'].",
".$meeting['END'].",
'".query_safe($meeting['BLDG'])."',
'".query_safe($meeting['ROOM'])."',
'".query_safe($INSTRUCTOR)."'
)
";
d_Var('pclassmeetingINSERT',$query,'q');
$pclassmeetingINSERT = query_do($query);
@d_Var('$pclassmeetingINSERT',$pclassmeetingINSERT);
$meetingIndex++;
}
if ( isset($d_O) && !$d_O ) d_Off();
?>