| 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/Scheduler/Schedule/ |
Upload File : |
<?
// Schedule/GetScheduleClassMeeting.phpinc
// Get the scheduleclass meetings for $scheduleclassInfo['scheduleclassId'].
#$DEBUG_GetScheduleClassMeeting = true;
#if ( $_SESSION['gameId'] == 0 ) $DEBUG_GetScheduleClassMeeting = true; // DEBUG by gameId.
#if ( $_SESSION['userId'] == 0 ) $DEBUG_GetScheduleClassMeeting = true; // DEBUG by userId.
if ( !isset($DEBUG_GetScheduleClassMeeting) ) $DEBUG_GetScheduleClassMeeting = d_O(); // DEBUG by passthrough.
#if ( !isset($DEBUG_GetScheduleClassMeeting) ) $DEBUG_GetScheduleClassMeeting = false; // Default false.
#if ( $DEBUG_GetScheduleClassMeeting ) d_On(); // Use instead of t_Begin() for AJAX call.
t_Begin($DEBUG_GetScheduleClassMeeting); // Begin TRACKing GetScheduleClassMeeting.phpinc.
f('scmId');
#d_V('scmId','d');
$query = "
SELECT scheduleclassmeetingId
, scheduleclassmeetingStartDate
, scheduleclassmeetingEndDate
, scheduleclassmeetingBeginTime
, scheduleclassmeetingEndTime
, IFNULL(scheduleclassmeetingOnCampus, 1) AS scheduleclassmeetingOnCampus
FROM `scheduleclassmeeting`
WHERE scheduleclassId = ".$scheduleclassInfo['scheduleclassId'];//."
//";
if ( $f['scmId'] ) {
$query .= "
AND scheduleclassmeetingId = ".$f['scmId'];
}
$query .= "
ORDER BY (
SELECT MIN(weekdayNumber)
FROM `scheduleclassmeetingweekday`
JOIN `weekday` ON weekday.weekdayId = scheduleclassmeetingweekday.weekdayId
WHERE scheduleclassmeetingweekday.scheduleclassmeetingId = scheduleclassmeeting.scheduleclassmeetingId
)
, scheduleclassmeetingBeginTime
";
d_Var('scheduleclassmeetingResult',$query,'q');
$scheduleclassmeetingResult = query_do($query);
$scheduleclassmeetingCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingResult',$scheduleclassmeetingResult,'');
#if ( $DEBUG_GetScheduleClassMeeting ) d_Off(); // Use instead of t_End() for AJAX call.
unset($DEBUG_GetScheduleClassMeeting);
t_End(); // End TRACKing GetScheduleClassMeeting.phpinc.
?>