Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage/class/ drwxr-xr-x |
Viewing file: Select action/file-type: SetQuery("select * from StudentStatus where studentId='$xKey'"); } function GetMaxAcadYearByStId($xKey){ $this->SetQuery("select max(acadYear) as num from StudentStatus where studentId='$xKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function GetMaxSemesterByStIdAndAcY($xKey, $yKey){ $this->SetQuery("select max(semester) as num from StudentStatus where studentId='$xKey' and acadYear='$yKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function GetMaxAcadYearByPgIdAndAdYAndStY($xKey, $yKey, $zKey){ $this->SetQuery("select max(acadYear) as num from StudentStatus, StudentMaster where programId='$xKey' and admitAcadYear='$yKey' and studentYear='$zKey' and StudentMaster.studentId=StudentStatus.studentId"); if ($result=$this->GetResult()) { return $result['num']; } } function GetMaxSemesterByPgIdAndAdYAndStYAndAcY($wKey, $xKey, $yKey, $zKey){ $this->SetQuery("select max(semester) as num from StudentStatus, StudentMaster where programId='$wKey' and admitAcadYear='$xKey' and studentYear='$yKey' and StudentMaster.studentId=StudentStatus.studentId and acadYear='$zKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function RSStudentStatusGroupByStId($StID){ $this->SetQuery("select studentId from StudentStatus where studentId='$StID' and studentStatus!='4' group by studentId"); } function RSStudentStatusGroupByStIdMAcYMSeM($StID,$AcY,$SeM){ // $this->SetQuery("select max(acadYear) as num1, max(semester) as num2 from StudentStatus where studentId='$StID' and studentStatus!='4' group by studentId"); $this->SetQuery("select passStatus from StudentStatus where studentId='$StID' and acadYear='$AcY' and semester='$SeM' and studentStatus!='4' group by studentId"); // $result=$this->GetResult(); // return $result['num1']."-".$result['num2']; } function GetCountStIdByPgIdAndAdYAndAcYAndSeAndPassStatus($pgId, $adY, $acY, $se, $passStatus){ $this->SetQuery("select count(s.studentId) as num from StudentStatus s, StudentMaster m where m.programId='$pgId' and m.admitAcadYear='$adY' and m.studentId=s.studentId and s.acadYear='$acY' and s.semester='$se' and s.passStatus='$passStatus' and s.studentStatus!=4 and m.studentStatus!=4"); if ($result=$this->GetResult()) { return $result['num']; } } //-- Use on page processChgStudProg.php -- function CountGPAAndGPAXNoZero($AcY, $SeM){ $this->SetQuery("select count(studentId) as num from StudentStatus where acadYear='$AcY' and semester='$SeM' and GPA!=0 and GPAX!=0 order by studentId"); $result=$this->GetResult(); return $result['num']; } //-- The end -- } //--End class StudentStatus-- ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.005 ]-- |