| 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 : /nginx/html/Admin/User/ |
Upload File : |
<?
// Admin/User/UserInfo_by_StudentId_Name.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
$skipAuthentication = true;
include('application.phpinc');
$f_userStudentId = formValue('userStudentId');
$f_userFirstName = formValue('userFirstName');
$f_userLastName = formValue('userLastName');
if ( $f_userStudentId != '0' ) {
// Get user info by userStudentId.
$query = "
SELECT userId,
userUsername,
userPassword,
userPasswordMD5,
userStudentId,
userFirstName,
userMiddleName,
userLastName,
userNickname,
userDN,
userEmail,
userImage,
userIsInactive,
userIsStudent,
userIsAlumni,
userComments,
userDefaultDrive,
userDataFolder,
userLoggedIn,
userLoginCount,
userAccessTime,
userIPAddress,
userIPDecimal,
userPHPSESSID,
lastModified,
modifiedBy
FROM `user`
WHERE userStudentId = '".query_safe($f_userStudentId)."'
";
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
} else {
$userResultCount = 0;
}
#printVar('$userResultCount',$userResultCount);
#mysqli_data_seek($userResult, 0);
#$userRow = mysqli_fetch_assoc($userResult);
#while ($userRow = mysqli_fetch_assoc($userResult)) {
#}
if ( $userResultCount == 0 ) {
// Get user info by userFirstName, userLastName.
$query = "
SELECT userId,
userUsername,
userPassword,
userPasswordMD5,
userStudentId,
userFirstName,
userMiddleName,
userLastName,
userNickname,
userDN,
userEmail,
userImage,
userIsInactive,
userIsStudent,
userIsAlumni,
userComments,
userDefaultDrive,
userDataFolder,
userLoggedIn,
userLoginCount,
userAccessTime,
userIPAddress,
userIPDecimal,
userPHPSESSID,
lastModified,
modifiedBy
FROM `user`
WHERE userFirstName = '".query_safe($f_userFirstName)."'
AND userLastName = '".query_safe($f_userLastName)."'
";
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
if ( $userResultCount == 0 ) {
#echo "N 0;";
} elseif ( $userResultCount == 1 ) {
mysqli_data_seek($userResult, 0);
$userRow = mysqli_fetch_assoc($userResult);
#echo "N 1;".$userRow['userStudentId'].';'.$userRow['userFirstName'].';'.$userRow['userMiddleName'].';'.$userRow['userLastName'].';'.$userRow['userLoginCount'].';';
} else {
mysqli_data_seek($userResult, 0);
$userRow = mysqli_fetch_assoc($userResult);
#echo 'N '.$userResultCount.";".$userRow['userStudentId'].';'.$userRow['userFirstName'].';'.$userRow['userMiddleName'].';'.$userRow['userLastName'].';'.$userRow['userLoginCount'].';';
}
} elseif ( $userResultCount == 1 ) {
mysqli_data_seek($userResult, 0);
$userRow = mysqli_fetch_assoc($userResult);
#echo "I 1;".$userRow['userStudentId'].';'.$userRow['userFirstName'].';'.$userRow['userMiddleName'].';'.$userRow['userLastName'].';'.$userRow['userLoginCount'].';';
} else {
mysqli_data_seek($userResult, 0);
$userRow = mysqli_fetch_assoc($userResult);
#echo 'I '.$userResultCount.";".$userRow['userStudentId'].';'.$userRow['userFirstName'].';'.$userRow['userMiddleName'].';'.$userRow['userLastName'].';'.$userRow['userLoginCount'].';';
}
?>
<?
if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n";
?>