!c99Shell v. 1.0 pre-release build #16!

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/mis/application/models/eregis/   drwxr-xr-x
Free 51 GB of 127.8 GB (39.91%)
Home    Back    Forward    UPDIR    Refresh    Search    Buffer    Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    


Viewing file:     mo_rg_payment.php (5.56 KB)      -rw-r--r--
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once("da_rg_Payment.php");
class 
Mo_rg_payment extends Da_rg_Payment {

    
/**
     * หน้าที่ของฟังก์ชั่น คือ หาข้อมูลใบเสร็จตามเงื่อนไข
     *
     * @access    public
     * @param    array condition โดยรูปแบบของ array จะอยู่ในรูป condition('key' => value) ไว้สำหรับระบุเงื่อนไขของคำสั่ง SELECT
     * @param    array order โดยรูปแบบของ array จะอยู่ในรูป condition('key' => value) ไว้สำหรับระบุเงื่อนไขการเรียงลำดับ ORDER BY
     * @param    array group โดยรูปแบบของ array จะอยู่ในรูป condition('key' => value) ไว้สำหรับระบุเงื่อนไขการจัดกลุ่ม GROUP BY
     * @return    query >= 1 rows : rg_Payment.*
     * @todo    use
     */
    
public function qryPm($condition="",$order="",$group="") {
        
$where $this->checkCondition($condition);
        
$order $this->checkOrderBy($order);
        
$group $this->checkGroupBy($group);

        
$c1 substr($where0, -3);
        
$c2 substr($order0, -1);
        
$c3 substr($group0, -1);

        
$sql "SELECT *
                    FROM $this->rg_dbname.rg_Payment
                    $c1
                    $c2
                    $c3"
;
        
$query $this->db->query($sql);
        return 
$query;
    }

    function 
getSumLateFine($condition="") {
        
$where $this->checkCondition($condition);

        
$c1 substr($where0, -3);

        
$sql "SELECT IFNULL(SUM(pmLateFine), 0) AS num 
                    FROM $this->rg_dbname.rg_RegistFee 
                    INNER JOIN rg_Payment ON rfId = pmRfId 
                    $c1"
;
        
$query $this->db->query($sql);
        return 
$query->row()->num;
    }

    
//use รายงานการรับชำระค่าลงทะเบียน
    
function getPmBetweenpmDate($date1$date2$group="") {
        
$group $this->checkGroupBy($group);

        
$c3 substr($group0, -1);

        
$sql "SELECT *
                FROM $this->rg_dbname.rg_Payment
                LEFT JOIN $this->rg_dbname.rg_RegistFee ON rfId = pmRfId
                LEFT JOIN $this->rg_dbname.rg_Student ON rfStdId = stdId
                LEFT JOIN $this->ppc_dbname.Prefix ON stdPfId=prefixId
                WHERE pmDate BETWEEN ? AND ?
                $c3
                ORDER BY pmDate
                "
;
        
$query $this->db->query($sql,array($date1$date2));
        return 
$query;
    }

    
//use รายงานการรับชำระค่าลงทะเบียน
    
function getSumPmAmt($rfId$date) {
        
$sql "SELECT SUM(pmAmt) as num
                FROM $this->rg_dbname.rg_Payment
                INNER JOIN $this->rg_dbname.rg_RegistFee ON rfId = pmRfId
                WHERE pmRfId = ? AND pmDate < ?
                "
;
        
$query $this->db->query($sql,array($rfId$date));
        if (
$query->num_rows()) {
            return 
$query->row()->num;
        } else {
            return 
0;
        }
    }

    
//use รายงานสรุปชำระค่าลงทะเบียนรายวัน
    
function getSumPmAmtCon($condition="") {
        
$where $this->checkCondition($condition);

        
$c1 substr($where0, -3);

        
$sql "SELECT SUM(pmAmt) as num
                FROM $this->rg_dbname.rg_Payment
                $c1
                "
;
        
$query $this->db->query($sql);
        if (
$query->num_rows()) {
            return 
$query->row()->num;
        } else {
            return 
0;
        }
    }

    
//use รายงานรายรับลงทะเบียน
    
function getPmJoinRf ($date1$date2) {
        
$sql "SELECT *
                FROM $this->rg_dbname.rg_Payment
                LEFT JOIN $this->rg_dbname.rg_RegistFee ON rfId = pmRfId
                LEFT JOIN $this->rg_dbname.rg_Student ON rfStdId = stdId
                LEFT JOIN $this->ppc_dbname.Prefix ON stdPfId=prefixId
                LEFT JOIN $this->rg_dbname.rg_Curriculum ON stdCurId=curId
                WHERE pmDate BETWEEN ? AND ? AND rfBalance = 0 
                GROUP BY pmRfId
                "
;
        
$query $this->db->query($sql,array($date1$date2));
        return 
$query;
    }

//    public function GetSumLateFineByStIdAndAcYAndStYAndSe($condition="",$order="",$group="") {
//        $where = $this->checkCondition($condition);
//        $order = $this->checkOrderBy($order);
//        $group = $this->checkGroupBy($group);
//
//        $c1 = substr($where, 0, -3);
//        $c2 = substr($order, 0, -1);
//        $c3 = substr($group, 0, -1);
//
//        $sql = "SELECT SUM(pmLateFine) as num
//                    FROM rg_Payment
//                    INNER JOIN rg_RegistFee ON rfId = pmRfId
//                    $c1
//                    $c2
//                    $c3";
//        $query = $this->db->query($sql);
//        if ($query->num_rows()) {
//            return $query->row()->num;
//        } else {
//            return 0;
//        }
//    }

    
function getNumDateDiff($date1$date2) {
        
$sql "SELECT DATEDIFF(?, ?) AS num";
        
$query $this->db->query($sql, array($date1$date2));
        if (
$query->num_rows()) {
            return 
$query->row()->num;
        } else {
            return 
0;
        }
    }

    function 
getMaxRefNo() {
        
$sql "SELECT MAX(pmRefNo) AS num 
                    FROM $this->rg_dbname.rg_Payment"
;
        
$query $this->db->query($sql);
        return 
$query->row()->num;
    }

    function 
getMaxId($condition="") {
        
$where $this->checkCondition($condition);

        
$c1 substr($where0, -3);

        
$sql "SELECT IFNULL(MAX(pmId), 0) AS num 
                    FROM $this->rg_dbname.rg_Payment 
                    $c1"
;
        
$query $this->db->query($sql);
        return 
$query->row()->num;
    }

    
/*
        Create : 11/7/2556
    */
    
function qryPmJoinRf($condition="") { 
        
$where $this->checkCondition($condition);
        
$c1 substr($where0, -3);

        
$sql "SELECT *
                    FROM $this->rg_dbname.rg_Payment 
                    INNER JOIN $this->rg_dbname.rg_RegistFee ON pmRfId = rfId
                    $c1"
;
        
$query $this->db->query($sql);
        return 
$query;
    }

}
?>

:: Command execute ::

Enter:
 
Select:
 

:: Shadow's tricks :D ::

Useful Commands
 
Warning. Kernel may be alerted using higher levels
Kernel Info:

:: Preddy's tricks :D ::

Php Safe-Mode Bypass (Read Files)

File:

eg: /etc/passwd

Php Safe-Mode Bypass (List Directories):

Dir:

eg: /etc/

:: Search ::
  - regexp 

:: Upload ::
 
[ Read-Only ]

:: Make Dir ::
 
[ Read-Only ]
:: Make File ::
 
[ Read-Only ]

:: Go Dir ::
 
:: Go File ::
 

--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0072 ]--