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
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/manage/class/   drwxr-xr-x
Free 52.61 GB of 127.8 GB (41.16%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     clsStudentActivity.php (2.65 KB)      -rw-r--r--

<?php
//--Class StudentActivity--------------------------

include_once "clsbase_StudentActivity.php";

class StudentActivity extends base_StudentActivity {

function RSStudentActivityByStIdAndActNameAndAcYAndStYAndSeAndDate($stId, $actName, $acY, $stY, $se, $dateFrom, $dateTo){
	$this->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--
?>