| 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/common/ |
Upload File : |
<?
// common/GetSessions.phpinc
// Calculate $_SESSION['YRTR'] values.
#debugTrackBegin(); d_On();
#if ( isset($_SESSION['userId']) && $_SESSION['userId'] == 1 ) { setDebugOn(); d_On(); }
#unset($_SESSION['YRTR']);
#d_Var("\$_SESSION['YRTR']",$_SESSION['YRTR'],'d');
#echo __FILE__;
if ( !isset($_SESSION['YRTR']) ) {
// Create $_SESSION['YRTR'] array.
$_SESSION['YRTR'] = array();
// Get the first session.
$query = "
SELECT MIN(YRTR) AS MINYRTR
FROM session
WHERE ( sessionType = 1 OR sessionType = 2 )
";
$sessionList = query_do($query);
$sessionInfo = mysqli_fetch_assoc($sessionList);
$_SESSION['YRTR']['FIRST'] = $sessionInfo['MINYRTR'];
d_Var("\$_SESSION['YRTR']['FIRST']",$_SESSION['YRTR']['FIRST']);
// Get the last session
$query = "
SELECT MAX(YRTR) AS MAXYRTR
FROM session
WHERE ( sessionType = 1 OR sessionType = 2 )
";
$sessionList = query_do($query);
$sessionInfo = mysqli_fetch_assoc($sessionList);
$_SESSION['YRTR']['LAST'] = $sessionInfo['MAXYRTR'];
d_Var("\$_SESSION['YRTR']['LAST']",$_SESSION['YRTR']['LAST']);
// Get the current session
$f_currentDate = currentDate();
$date = date("Y-m-d");
d_Var('$date',$date);
d_Var('strtotime($date)',strtotime($date));
$lastWeek = date('Y-m-d', strtotime(date("Y-m-d", strtotime($date)) . " -1 week"));
d_Var('$lastWeek',$lastWeek);
$query = "
SELECT YRTR
, sessionName
FROM session
WHERE ( sessionStart <= '".$f_currentDate."' AND sessionEnd >= '".$lastWeek."' )
AND ( sessionType = 1 OR sessionType = 2 )
";
#d_Var('$sessionList',$query,'dq');
$sessionList = query_do($query);
$sessionCount = $_SESSION['qry']['count'];
#d_Var('$sessionList',$sessionList,'d');
if ( $sessionCount ) {
// Today is inside of the current session, so setup for the current session.
mysqli_data_seek($sessionList, 0);
$sessionInfo = mysqli_fetch_assoc($sessionList);
//echo "Current session = ".$sessionInfo['YRTR']."<br>\n";
$_SESSION['YRTR']['CURRENT'] = $sessionInfo['YRTR'];
} else {
// Today is not inside a session, so get the next session.
$query = "
SELECT YRTR
FROM session
WHERE sessionStart > '".$f_currentDate."'
AND ( sessionType = 1 OR sessionType = 2 )
ORDER BY sessionStart
";
d_Var('$sessionList',$query,'q');
$sessionList = query_do($query);
$sessionCount = $_SESSION['qry']['count'];
#d_Var('$sessionList',$sessionList,'d');
if ( $sessionCount ) {
// Today is before a session, so setup for the next session.
mysqli_data_seek($sessionList, 0);
$sessionInfo = mysqli_fetch_assoc($sessionList);
$_SESSION['YRTR']['CURRENT'] = $sessionInfo['YRTR'];
} else {
// Today is after any sessions, so setup for the last session.
$_SESSION['YRTR']['CURRENT'] = $_SESSION['YRTR']['LAST'];
}
}
// Get the previous session.
switch (substr($_SESSION['YRTR']['CURRENT'],4,1)) {
case '1':
$_SESSION['YRTR']['PREVIOUS'] = (substr($_SESSION['YRTR']['CURRENT'],0,4)-1).'5';
break;
case '3':
$_SESSION['YRTR']['PREVIOUS'] = substr($_SESSION['YRTR']['CURRENT'],0,4).'1';
break;
case '5':
$_SESSION['YRTR']['PREVIOUS'] = substr($_SESSION['YRTR']['CURRENT'],0,4).'3';
break;
default:
$_SESSION['YRTR']['PREVIOUS'] = 'none';
break;
}
// Get the session names.
$query = "
SELECT *
FROM session
WHERE YRTR = ".$_SESSION['YRTR']['CURRENT']."
LIMIT 5
";
#d_Var('sessionResult',$query,'dq');
$sessionResult = query_do($query);
$sessionCount = $_SESSION['qry']['count'];
#d_Var('$sessionResult',$sessionResult,'d+');
if ( $sessionCount ) {
mysqli_data_seek($sessionResult, 0);
$sessionCurrentInfo = mysqli_fetch_assoc($sessionResult);
$_SESSION['YRTR']['CURRENT_NAME'] = $sessionCurrentInfo['sessionName'];
$ct = explode(' ',$_SESSION['YRTR']['CURRENT_NAME']);
$_SESSION['YRTR']['CURRENT_TYPE'] = $ct[1];
if ( !isset($_SESSION['YRTR']['User']) ) {
$_SESSION['YRTR']['User'] = $sessionCurrentInfo['YRTR'];
$_SESSION['YRTR']['User_NAME'] = $sessionCurrentInfo['sessionName'];
$_SESSION['YRTR']['User_Start'] = $sessionCurrentInfo['sessionStart'];
$_SESSION['YRTR']['User_End'] = $sessionCurrentInfo['sessionEnd'];
}
} else {
$_SESSION['YRTR']['CURRENT_NAME'] = '';
$_SESSION['YRTR']['CURRENT_TYPE'] = '';
}
$query = "
SELECT sessionName
FROM session
WHERE YRTR = ".$_SESSION['YRTR']['PREVIOUS']."
";
$sessionResult = query_do($query);
$sessionCount = $_SESSION['qry']['count'];
if ($sessionCount) {
mysqli_data_seek($sessionResult, 0);
$sessionInfo = mysqli_fetch_assoc($sessionResult);
$_SESSION['YRTR']['PREVIOUS_NAME'] = $sessionInfo['sessionName'];
} else {
$_SESSION['YRTR']['PREVIOUS_NAME'] = '';
}
#printVar('$YRTR',$YRTR,'d');
// Set session user is using.
#unset($_SESSION['YRTR']['User']);
#unset($_SESSION['YRTR']['SESSIONID_NEXT_SUMMER']);
#printVar("\$_SESSION['YRTR']['User']",$_SESSION['YRTR']['User'],'d');
/**/
// Calculare next year and session number.
$_SESSION['YRTR']['YR'] = substr($_SESSION['YRTR']['User'],0,4);
$_SESSION['YRTR']['TR'] = substr($_SESSION['YRTR']['User'],4,1);
if ($_SESSION['YRTR']['TR'] == '1') $_SESSION['YRTR']['YR']++;
$nextYear = $_SESSION['YRTR']['YR']+1;
#printVar("\$_SESSION['YRTR']['YR']",$_SESSION['YRTR']['YR']);
#printVar("\$_SESSION['YRTR']['TR']",$_SESSION['YRTR']['TR']);
$summerSession = $nextYear.'1';
// Get or INSERT sessionId.
$query = "
SELECT sessionId
FROM session
WHERE YRTR = '".$summerSession."'
";
$summersessionResult = query_do($query);
$summersessionCount = $_SESSION['qry']['count'];
if ($summersessionCount) {
$summersessionRow = mysqli_fetch_assoc($summersessionResult);
$_SESSION['YRTR']['SESSIONID_NEXT_SUMMER'] = $summersessionRow['sessionId'];
} else {
// INSERT session
$query = "
INSERT INTO session (
YRTR,
sessionType,
sessionName
) VALUES (
'".$summerSession."',
2,
'".$_SESSION['YRTR']['YR']." Summer Session'
)
";
d_Var('$query',$query,'q');
#$summerSessionINSERT = query_do($query);
#d_Var('$summerSessionINSERT',$summerSessionINSERT);
$_SESSION['YRTR']['SESSIONID_NEXT_SUMMER'] = mysqli_insert_id($_SESSION['DATABASE_LINK']);
}
}
$YRTR = formValue('YRTR','');
#printVar('$YRTR',$YRTR);
if ( $YRTR ) {
$query = "
SELECT sessionName
FROM `session`
WHERE YRTR = ".$YRTR."
";
$sessionResult = query_do($query);
$sessionResultCount = $_SESSION['qry']['count'];
if ( $sessionResultCount ) {
$sessionYRTR = mysqli_fetch_assoc($sessionResult);
$_SESSION['YRTR']['User'] = $YRTR;
$_SESSION['YRTR']['User_NAME'] = $sessionYRTR['sessionName'];
}
#printVar("\$_SESSION['YRTR']['User']",$_SESSION['YRTR']['User']);
#printVar("\$_SESSION['YRTR']['User_NAME']",$_SESSION['YRTR']['User_NAME']);
}
d_Var("\$_SESSION['YRTR']",$_SESSION['YRTR']);
if ( isset($_SESSION['userId']) && $_SESSION['userId'] == 1 ) { setDebugOff(); d_Off(); }
debugTrackEnd(); d_Off();
?>