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/teacher/class/   drwxr-xr-x
Free 52.35 GB of 127.8 GB (40.96%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     clsSendReceive.php (14.28 KB)      -rw-r--r--

c=$c->c;
	$this->DB=$c->db;
}


function Save(){
	if ($this->status==1){
		 $sql = "insert into sendreceive values(
			'".th2a($this->tsr_id)."',
			'".th2a($this->tsr_fr_node)."',
			'".th2a($this->tsr_fr_node_date)."',
			'".th2a($this->tsr_to_node)."',
			'".th2a($this->tsr_to_node_date)."',
			'".th2a($this->tsr_docid)."',
			'".th2a($this->tsr_doc_url)."',
			'".th2a($this->tsr_doc_chksum)."',
			'".th2a($this->tsr_status)."',
			'".th2a($this->tsr_id_send)."',
			'".th2a($this->tsr_docgroup)."',
			'".th2a($this->tsr_DrsID)."',
			'".th2a($this->tsr_SendNew)."',
			'".th2a($this->tsr_DocSubject)."',
			'".th2a($this->tsr_DocNo)."',
			'".th2a($this->tsr_DocDate)."',
			'".th2a($this->tsr_DocFrom)."',
			'".th2a($this->tsr_DocTo)."',
			'".th2a($this->tsr_DocRef)."',
			'".th2a($this->tsr_DocOther)."',
			'".th2a($this->tsr_DslID)."',			
			'".th2a($this->tsr_DclID)."',
			'".th2a($this->tsr_DocShortDesc)."',
			'".th2a($this->tsr_PtID)."',
			'".th2a($this->tsr_DlcID)."',
			'".th2a($this->tsr_personId)."',
			'".th2a($this->tsr_DtID)."',
			'".th2a($this->tsr_docname)."',
			'".th2a($this->tsr_receive)."',
			'".th2a($this->tsr_receivedate)."',
			'".th2a($this->tsr_DrsDocDueDate)."',
			'".th2a($this->tsr_statusDocAtt)."'
			)";
	}else {
		$sql = "update sendreceive set 
			tsr_fr_node='".th2a($this->tsr_fr_node)."', 
			tsr_fr_node_date='".th2a($this->tsr_fr_node_date)."', 
			tsr_to_node='".th2a($this->tsr_to_node)."', 
			tsr_to_node_date='".th2a($this->tsr_to_node_date)."', 
			tsr_docid='".th2a($this->tsr_docid)."', 
			tsr_doc_url='".th2a($this->tsr_doc_url)."', 
			tsr_doc_chksum='".th2a($this->tsr_doc_chksum)."', 
			tsr_status='".th2a($this->tsr_status)."', 
			tsr_id_send='".th2a($this->tsr_id_send)."', 
			tsr_docgroup='".th2a($this->tsr_docgroup)."', 
			tsr_DrsID='".th2a($this->tsr_DrsID)."', 
			tsr_SendNew='".th2a($this->tsr_SendNew)."', 
			tsr_DocSubject='".th2a($this->tsr_DocSubject)."', 
			tsr_DocNo='".th2a($this->tsr_DocNo)."', 
			tsr_DocDate='".th2a($this->tsr_DocDate)."', 
			tsr_DocFrom='".th2a($this->tsr_DocFrom)."', 
			tsr_DocTo='".th2a($this->tsr_DocTo)."', 
			tsr_DocRef='".th2a($this->tsr_DocRef)."', 
			tsr_DocOther='".th2a($this->tsr_DocOther)."', 
			tsr_DslID='".th2a($this->tsr_DslID)."', 
			tsr_DclID='".th2a($this->tsr_DclID)."', 
			tsr_DocShortDesc='".th2a($this->tsr_DocShortDesc)."', 
			tsr_PtID='".th2a($this->tsr_PtID)."', 
			tsr_DlcID='".th2a($this->tsr_DlcID)."', 
			tsr_personId='".th2a($this->tsr_personId)."',
			tsr_DtID='".th2a($this->tsr_DtID)."',
			tsr_docname='".th2a($this->tsr_docname)."',
			tsr_receive='".th2a($this->tsr_receive)."',
			tsr_receivedate='".th2a($this->tsr_receivedate)."',
			tsr_DrsDocDueDate='".th2a($this->tsr_DrsDocDueDate)."',
			tsr_statusDocAtt='".th2a($this->tsr_statusDocAtt)."'
			where tsr_id='".th2a($this->tsr_id)."'";
	}
	return $this->Dml($sql);
}

function Delete(){
	$sql = "delete from sendreceive where tsr_id='$this->tsr_id'";
	if ($this->conn->Execute($sql)){
		return true;
	}else{
		$this->errNo=$this->conn->errNo;
		$this->errDesc=$this->conn->errDesc;
		return false;
	}
}
function GetRecord(){
	$numFields = $this->NumField();
	$row = $this->GetResult();
	if ($row){
		for ($i=0; $i<$numFields; $i++){
			eval("\$this->".mysql_field_name($this->rs, $i)."=\$row['".mysql_field_name($this->rs, $i)."'];");
		}
		return true;
	}else{	// clear value of Member;
		for ($i=0; $i<$numFields; $i++){
			eval("\$this->".mysql_field_name($this->rs, $i)."='';");
		}
		return false;
	}
}
function GetNextCode(){
//--гЄйаБёНґ№ХйаѕЧиНЛТ¤иТКЩ§КШґўН§їФЕґм·ХигЄйа»з№¤ХВмўН§µТГТ§ г№ЕСЎЙіР auto increment
//--µйН§а»з№їФЕґм·ХидБидґйЎУЛ№ґГЛСКаН§·Т§ЁНАТѕ
	$cmd = "select max(tsr_id) as num from sendreceive";
	$this->Open($cmd);
	if($this->GetRecord())
		return $this->num+1;
}

function RSsendreceive(){
	$this->SetQuery("select * from sendreceive order by tsr_to_node_date");
}

function SearchByKey($key){
	if ($this->SetQuery("select * from sendreceive where tsr_id='$key'")){ 
		return 1;
	}else {
		return 0;
	}
}

//***************************************************************************
//****************** You can add new methods below*********************************
//***************************************************************************
function SearchBytsr_docid($key){ 
	if ($this->SetQuery("select * from sendreceive where tsr_docid ='$key'")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_status($key){ 

	if ($this->SetQuery("select * from sendreceive where tsr_status = '$key' order by tsr_to_node_date")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_docid_tsr_fr_node($xKey,$yKey){ 
	if ($this->SetQuery("select * from sendreceive where tsr_docid = '$xKey' and  tsr_fr_node='$yKey'")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_docid_tsr_to_node_tsr_fr_node_date($xKey,$yKey,$zKey){ 
	if ($this->SetQuery("select * from sendreceive where tsr_docid = '$xKey' and  tsr_to_node='$yKey' and tsr_fr_node_date='$zKey'")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_docid_tsr_to_node_tsr_fr_node_date2($xKey,$yKey,$zKey){ 
	if ($this->SetQuery("select tsr_id from sendreceive where tsr_docid = '$xKey' and  tsr_to_node='$yKey' and tsr_fr_node_date='$zKey'")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_id_send($key){ 
	if ($this->SetQuery("select * from sendreceive where tsr_id_send ='$key'")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_DrsID($key){ 
	if ($this->SetQuery("select * from sendreceive where tsr_DrsID ='$key'")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_DrsID_tsr_to_node($xKey,$yKey){ 
	if ($this->SetQuery("select * from sendreceive where tsr_DrsID ='$xKey' and tsr_to_node='$yKey'")){ 	
		return 1;
	}else {
		return 0;
	}
}
function SearchBytsr_fr_node_tsr_DlcID_tsr_docgroup($xKey,$yKey,$zKey,$aKey){
//echo "select * from sendreceive where tsr_fr_node='$xKey' and (tsr_DlcID='$yKey' 
bool(false)