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_22222/class/ drwxr-xr-x |
Viewing file: clsStudentActivity.php (2.65 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | SetQuery("select * from StudentActivity where studentId='$stId' and activityName='$actName' and acadYear='$acY' and classYear='$stY' and semester='$se' and dateFrom='$dateFrom' and dateTo='$dateTo'"); } function GetNextSeqByStId($xKey){ $this->SetQuery("select max(sequenceId) as num from StudentActivity where studentId='$xKey'"); if ($result=$this->GetResult()) { return $result['num']+1; } } function RSStudentActivityByStId($stId){ $this->SetQuery("select * from StudentActivity where studentId='$stId' order by acadYear, semester, dateFrom"); } function RSStudentActivityByStIdAndGEAdY($stId, $adY){ $this->SetQuery("select * from StudentActivity where studentId='$stId' and acadYear>='$adY' order by acadYear, semester, dateFrom"); } function RSStudentActivityByStIdAndLTAdY($stId, $adY){ $this->SetQuery("select * from StudentActivity where studentId='$stId' and acadYear<'$adY' order by acadYear, semester, dateFrom"); } function RSStudentActivityByAcYAndDateGroupActNameAndDate($acY, $dateFrom, $dateTo){ $this->SetQuery("select activityName, dateFrom, dateTo from StudentActivity where acadYear='$acY' and dateFrom>='$dateFrom' and dateTo<='$dateTo' group by activityName, dateFrom, dateTo order by dateFrom, dateTo"); } function RSStudentActivityByStIdAndActNameAndAcYAndDate($stId, $actName, $acY, $dateFrom, $dateTo){ $this->SetQuery("select * from StudentActivity where studentId='$stId' and activityName='$actName' and acadYear='$acY' and dateFrom='$dateFrom' and dateTo='$dateTo'"); } function GetCountStIdByAcYAndActNameAndDate($acY, $actName, $dateFrom, $dateTo){ $this->SetQuery("select count(studentId) as num from StudentActivity where acadYear='$acY' and activityName='$actName' and dateFrom='$dateFrom' and dateTo='$dateTo'"); if ($result=$this->GetResult()) { return $result['num']; } } function GetCountStIdByAcYAndActNameAndStYAndDateAndPgId($acY, $actName, $stY, $dateFrom, $dateTo, $pgId){ $this->SetQuery("select count(a.studentId) as num from StudentActivity a, StudentMaster m where a.acadYear='$acY' and a.activityName='$actName' and a.classYear='$stY' and a.dateFrom='$dateFrom' and a.dateTo='$dateTo' and a.studentId=m.studentId and m.programId='$pgId'"); if ($result=$this->GetResult()) { return $result['num']; } } } //--End class StudentActivity-- ?> |
:: 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.0059 ]-- |