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

Viewing file:     clsUmUser.php (6.71 KB)      -rw-r--r--

<?php
//--Class umuser--------------------------
//--PK of umuser ::
//	1. UsID
class umuser extends clsDB{

var $result;

var $UsID;
var $UsName;
var $UsLogin;
var $UsPassword;
var $UsPsCode;			//personId, studentId
var $UsWgID;
var $UsQsID;
var $UsAnswer;
var $UsEmail;
var $UsActive;
var $UsAdmin;
var $UsDesc;
var $UsPwdExpDt;
var $UsUpdDt;
var $UsUpdUsID;
var $UsSessionID;

var $name;
var $dptID;
var $dptName;
var $posID;
var $posName;

function umuser(&$c){
	$this->c=$c->c; 
	$this->DB=$c->db;
}

function Save(){
//--гЄйаБёНґ№ХйаБЧиНµйН§ЎТГєС№·ЦЎўйНБЩЕг№НкНєаЁкЎаўйТКЩи°Т№ўйНБЩЕ
//--вґВЁРµГЗЁКНєК¶Т№РўН§ўйНБЩЕЗиТўйНБЩЕг№НкНєаЁкЎа»з№ўйНБЩЕгЛБиЛГЧНўйНБЩЕаґФБ
//--1 а»з№ўйНБЩЕгЛБи  2 а»з№ўйНБЩЕаґФБ
	if ($this->status==1){
		$this->UsID=$this->GetNextCode();
		$sql = "insert into umuser values(
			'$this->UsID',
			'$this->UsName',
 			'$this->UsLogin',
 			'$this->UsPassword',
 			'$this->UsPsCode',
 			'$this->UsWgID',
 			'$this->UsQsID',
 			'$this->UsAnswer',
 			'$this->UsEmail',
 			'$this->UsActive',
 			'$this->UsAdmin',
 			'$this->UsDesc',
 			'$this->UsPwdExpDt',
 			'$this->UsUpdDt',
 			'$this->UsUpdUsID',
 			'$this->UsSessionID'
			)";
	}else {
		$sql = "update umuser set 
			UsName='$this->UsName', 
			UsLogin='$this->UsLogin', 
			UsPassword='$this->UsPassword', 
			UsPsCode='$this->UsPsCode', 
			UsWgID='$this->UsWgID', 
			UsQsID='$this->UsQsID', 
			UsAnswer='$this->UsAnswer', 
			UsEmail='$this->UsEmail', 
			UsActive='$this->UsActive', 
			UsAdmin='$this->UsAdmin', 
			UsDesc='$this->UsDesc', 
			UsPwdExpDt='$this->UsPwdExpDt', 
			UsUpdDt='$this->UsUpdDt', 
			UsUpdUsID='$this->UsUpdUsID', 
			UsSessionID='$this->UsSessionID' 
			where UsID='$this->UsID' ";
	}
	return $this->Dml($sql);
}

function Delete(){
//--гЄйаБёНґ№ХйаѕЧиНЕєўйНБЩЕаґФБг№НкНєаЁкЎ
//--а»з№ЎТГЕєўйНБЩЕ·ХЕР 1 аГ¤НГмґ
//--µйН§аГХВЎаБёНґµТБЕУґСєґС§№Хй SearchByKey()-->GetRecord()-->Delete()
	include_once("global.php");
    if (!class_exists("clsConnection"))
	    include_once("../class/clsConnection.php");
    if (!class_exists("clsDB"))
	    include_once("../class/clsDB.php");
    if (!class_exists("clsUmUserGroup"))
	    include_once("clsUmUserGroup.php");
    if (!class_exists("clsUmPermission"))
	    include_once("clsUmPermission.php");
	$oC1 = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB'], $GLOBALS['USER'], $GLOBALS['PASSWORD']);
	$oUg = new umusergroup($oC1);
	$oUp = new umpermission($oC1);
	$flg=true;
	$flg = $oUg->DeleteByUsID($this->UsID);
	$flg = $oUp->DeleteByUs($this->UsID);
	$sql="delete from umuser where UsID='$this->UsID' ";
	$flg = $this->Dml($sql);
	return flg;
}

function GetNextCode(){
//--гЄйаБёНґ№ХйаѕЧиНЛТ¤иТКЩ§КШґўН§їФЕґм·ХигЄйа»з№¤ХВмўН§µТГТ§ г№ЕСЎЙіР auto increment
//--µйН§а»з№їФЕґм·ХидБидґйЎУЛ№ґГЛСКаН§·Т§ЁНАТѕ
	$this->SetQuery("select max(UsID) as num from umuser");
	if ($result=$this->GetResult()) {
		return $result['num']+1;
	}else{
		return 1;	
	}
}

function RSumuser(){
//--аБёНґ·ХиўЦ鹵鹴йЗВ RS (Result Set) БХ¤ЗТБЛБТВЗиТЁРдґйГСєўйНБЩЕЎЕСєБТЁТЎЎТГ select БТЎЎЗиТ 1 аГ¤НГмґ
//--»ЎµФаБЧиНаГХВЎгЄйаБёНґ RSxxxx ЁРµйН§аГХВЎаБёНґ GetRecord() ґйЗВаКБН
//--вґВКТБТГ¶аѕФиБаБёНґдґйµТБµйН§ЎТГ бµиµйН§ўЦ鹵鹴йЗВ RS
	$this->SetQuery("select * 	from umuser order by uspscode");
}

function GetRecord(){
//--а»з№аБёНґ·Хи№УўйНБЩЕЁТЎ ResultSet БТЎУЛ№ґгЛйЎСєбНµ·ГФєФЗµмўН§НкНєаЁзЎ
//--аГХВЎ GetRecord() Л№Ц觤ГСй§ ЁРаЕЧиН№µСЗЄХйаГ¤НГмґд»НХЎЛ№Ци§аГ¤НГмґ
	if ($this->result = $this->GetResult()) {
		$this->UsID = $this->result['UsID'];
		$this->UsName = $this->result['UsName'];
		$this->UsLogin = $this->result['UsLogin'];
		$this->UsPassword = $this->result['UsPassword'];
		$this->UsPsCode = $this->result['UsPsCode'];
		$this->UsWgID = $this->result["UsWgID"];
		$this->UsQsID = $this->result['UsQsID'];
		$this->UsAnswer = $this->result['UsAnswer'];
		$this->UsEmail = $this->result['UsEmail'];
		$this->UsActive = $this->result['UsActive'];
		$this->UsAdmin = $this->result['UsAdmin'];
		$this->UsDesc = $this->result['UsDesc'];
		$this->UsPwdExpDt = $this->result['UsPwdExpDt'];
		$this->UsUpdDt = $this->result['UsUpdDt'];
		$this->UsUpdUsID = $this->result['UsUpdUsID'];
		$this->UsSessionID = $this->result['UsSessionID'];
		$this->name=$this->result['NAME'];
		$this->dptID=$this->result['DID'];
		$this->dptName=$this->result['DNAME'];
		$this->posID=$this->result['PID'];
		$this->posName=$this->result['PNAME'];
		return 1;
	}else {
		return 0;
	}
}

function SearchByKey($xKey){
//--гЄйаБёНґ№ХйаѕЧиН¤й№ЛТўйНБЩЕµТБ PK µйН§ГРєШѕТГТБФаµНГмґйЗВ
//--бЕРµйН§µТБґйЗВаБёНґ GetRecord() аКБН
	if ($this->SetQuery("select * from umuser where UsID= '$xKey' ")) { 
		return 1;
	}else {
		return 0;
	}
}
//****************** You can add new functions below **********************//
function SearchByPersonID($xKey){
//--гЄйаБёНґ№ХйаѕЧиН¤й№ЛТўйНБЩЕµТБ PK µйН§ГРєШѕТГТБФаµНГмґйЗВ
//--бЕРµйН§µТБґйЗВаБёНґ GetRecord() аКБН
	if ($this->SetQuery("select * from umuser where UsPsCode= '$xKey' ")) { 
		return 1;
	}else {
		return 0;
	}
}

function SearchByLogin($xKey, $passwd){
//--гЄйаБёНґ№ХйаѕЧиН¤й№ЛТўйНБЩЕµТБ uslogin, uspassword  µйН§ГРєШѕТГТБФаµНГмґйЗВ
//--бЕРµйН§µТБґйЗВаБёНґ GetRecord() аКБН
	$sql="select * from umuser where UsLogin= '$xKey' and UsPassword='".md5("O]O".$passwd."O[O")."' and UsActive=1";
	if ($this->SetQuery($sql)) { 
		return 1;
	}else {
		return 0;
	}
}
function SetSessionID($UsID, $SessionID){
	$sql = "Update umuser set UsSessionID='$SessionID' where UsID='$UsID' ";
	$this->Dml($sql);
}
function SearchByFilter($strFilter){
	if ($this->SetQuery("select * from umuser where  $strFilter")) { 
		return 1;
	}else {
		return 0;
	}
}

function SearchByNameWGroup($loginname="", $name="", $WgID=""){
	$strCond = "";
   if ($loginname<>"") $strCond.=" and UsLogin like '%$loginname%' ";
	if ($name<>"") $strCond.=" and UsName like '%$name%' ";
	if ($WgID<>"") $strCond.=" and UsWgId='$WgID' ";
	$sql = "select *
			from umuser 
			where 1 $strCond ";
	if ($this->SetQuery($sql)) { 
		return 1;
	}else {
		return 0;
	}
}
function SearchByUserLogin($xKey){
//--гЄйаБёНґ№ХйаѕЧиН¤й№ЛТўйНБЩЕµТБ uslogin, uspassword  µйН§ГРєШѕТГТБФаµНГмґйЗВ
//--бЕРµйН§µТБґйЗВаБёНґ GetRecord() аКБН
	if ($this->SetQuery("select * from umuser where UsLogin= '$xKey' ")) { 
		return 1;
	}else {
		return 0;
	}
}
function RSUserBySt($StID){
	$sql="select distinct umuser.* 
		  from umgroup, umusergroup, umuser
		  where GpStID=$StID and GpID=UgGpID and UgUsID=UsID 
		  order by UsName";
	$this->SetQuery($sql);
}

function SearchByPsCode($PsCode){
	$sql = "select * from umuser where UsPsCode='$PsCode' order by UsName";
	if ($this->SetQuery($sql)) { 
		return 1;
	}else {
		return 0;
	}
}

function SearchByPsCodeWg($PsCode, $WgID){
	$sql = "select * from umuser where UsPsCode='$PsCode' and UsWgID='$WgID' order by UsName";
	if ($this->SetQuery($sql)) { 
		return 1;
	}else {
		return 0;
	}
}

} //--End class umuser--

?>