| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/(Del)hsiaust.com.au/webadmin/ |
Upload File : |
<?php
include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1'))
{
header("Location: login.php");
exit;
}
require("configure.php");
$pid = $_GET['pid'];
?>
<!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=utf-8" />
<title>Content Management System (CMS) - Powered by One Solution Limited</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<!-- Main Menu -->
<link rel="stylesheet" type="text/css" href="css/menu.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="js/ddaccordion.js"></script>
<script type="text/javascript" src="js/menuddaccordion.js"></script>
<!-- End Main Menu -->
<script type="text/javascript">
function Deleteprojectscategory(parentid,projectscaseid,projectscasesort)
{
if (confirm("Are you sure you want to delete?"))
{
window.location.href = 'projects_case_delete.php?parentid='+parentid+'&projectscaseid='+projectscaseid+'&projectscasesort='+projectscasesort;
}
}
function DeleteprojectsDetail(parentid,projectsdetid,projectsdetsort)
{
if (confirm("Are you sure you want to delete?"))
{
window.location.href = 'projects_detail_delete.php?parentid='+parentid+'&projectsdetid='+projectsdetid+'&projectsdetsort='+projectsdetsort;
}
}
</script>
</head>
<body>
<table width="1000" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top"><table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu --><?php require("menu.php");?><!-- End Main Menu --></td>
</tr>
</table></td>
<td width="800" align="left" valign="top"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<?php if (getLevelNum($pid) <= 1) { echo '<td width="100" align="center" class="icontxt"><a href="projects_case_addform.php?pid='.$pid.'&lv='.getLevelNum($pid).'"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0" /><br /> Add Category </a></td>'; }
?>
</tr>
</table></td>
</tr>
<tr>
<td class="pagetitletxt"> <b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle" /> Projects Category </b></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php echo $_GET['msg']; ?></td>
</tr>
<tr>
<td height="35" align="left" valign="middle" class="content"><?php
echo "<b><a href='projects_case_index.php?pid=0' />You are here: All Category</a>". getLevel($pid) ."</b>";
?></td>
</tr>
<?php if (getLevelNum($pid) <= 1) { ?>
<tr>
<td align="left" valign="middle"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="40" class="listtitletxt">Sort</td>
<td width="600" class="listtitletxt">Categories</td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
$result = mysql_query("select * from projects_case where parentid = ".$pid." order by projectscasesort ASC, projectscaseid ASC ");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
print "<td class='listtxt' valign='middle' align='left'>";
print "<a href='projects_case_sort.php?status=up&parentid=".$row{'parentid'}."&projectscaseid=".$row{'projectscaseid'}."&sort=".$row{'projectscasesort'}."'>";
print "<img src='images/up.gif' alt='Up' border='0'></a> ";
print "<a href='projects_case_sort.php?status=down&parentid=".$row{'parentid'}."&projectscaseid=".$row{'projectscaseid'}."&sort=".$row{'projectscasesort'}."'>";
print "<img src='images/down.gif' alt='Down' border='0'></a>";
print "</td>";
if ($row{'projectscasenameen'} <> '') {
print "<td class='listtxt' style='padding-left:5'><a href='projects_case_index.php?pid=".$row{'projectscaseid'}."'>".$row{'projectscasenameen'}."</a></td>";
} else if ($row{'projectscasenametc'} <> '') {
print "<td class='listtxt' style='padding-left:5'><a href='projects_case_index.php?pid=".$row{'projectscaseid'}."'>".$row{'projectscasenametc'}."</a></td>";
} else if ($row{'projectscasenamesc'} <> '') {
print "<td class='listtxt' style='padding-left:5'><a href='projects_case_index.php?pid=".$row{'projectscaseid'}."'>".$row{'projectscasenamesc'}."</a></td>";
} else {
print "<td class='listtxt' style='padding-left:5'></td>";
}
//Status
print "<td class='listtxt' align='center'>";
if ($row{'projectscasestatus'} == '1') // Enable
{
print "<a href='projects_case_status.php?projectscaseid=".$row{'projectscaseid'}."&parentid=".$row{'parentid'}."'>";
print "<img src='images/tick.png' title='Enable' alt='Enable' border='0' hspace='2'></a>";
}
else // Disable
{
print "<a href='projects_case_status.php?projectscaseid=".$row{'projectscaseid'}."&parentid=".$row{'parentid'}."'>";
print "<img src='images/cross.png' title='Disable' alt='Disable' border='0' hspace='2'></a>";
}
print "</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='projects_case_modifyform.php?projectscaseid=".$row{'projectscaseid'}."'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";
// Delete
print "<td class='listtxt' align='center'><a href='#' onClick=\"Deleteprojectscategory(".$row{'parentid'}.", ".$row{'projectscaseid'}.", ".$row{'projectscasesort'}.")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "</tr>";
}
?>
</table></td>
</tr>
<?php } ?>
<tr><td height="20"><hr /></td></tr>
<!-- Page Content -->
<?php if (getLevelNum($pid) > 1) {
$result2 = mysql_query("select * from projects_case where projectscaseid = ". $pid ." order by projectscasesort ASC, projectscaseid ASC ");
$row2 = mysql_fetch_array($result2,MYSQL_ASSOC);
?>
<tr>
<td><table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> <b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle" />Projects Detail: <?=$row2{'projectscasenameen'};?></b></td>
<td width="130" align="center" class="icontxt"><a href="projects_detail_addform.php?pid=<?=$row2{'parentid'};?>&parentid=<?=$row2{'projectscaseid'};?>"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0" /><br />
Add Projects Details </a></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top" class="content"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="40" class="listtitletxt">Sort</td>
<td width="750" class="listtitletxt">Title</td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
$sql3 = "SELECT * FROM projects_case INNER JOIN projects_detail ON projects_case.projectscaseid = projects_detail.parentid WHERE projects_detail.parentid = ".$row2{'projectscaseid'}." ORDER BY projects_detail.projectsdetsort ASC, projects_detail.projectsdetid ASC ";
$result3 = mysql_query($sql3);
while ($row3 = mysql_fetch_array($result3,MYSQL_ASSOC)) {
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
print "<td class='listtxt' valign='middle' align='left'>";
print "<a href='projects_detail_sort.php?parentid=".$row3{'parentid'}."&status=up&projectsdetid=".$row3{'projectsdetid'}."&sort=".$row3{'projectsdetsort'}."'>";
print "<img src='images/up.gif' alt='Up' border='0'></a> ";
print "<a href='projects_detail_sort.php?parentid=".$row3{'parentid'}."&status=down&projectsdetid=".$row3{'projectsdetid'}."&sort=".$row3{'projectsdetsort'}."'>";
print "<img src='images/down.gif' alt='Down' border='0'></a>";
print "</td>";
if ($row3{'projectsdetnameen'} <> '') {
print "<td class='listtxt' style='padding-left:5'>".$row3{'projectsdetnameen'}."</td>";
} else if ($row3{'projectsdetnametc'} <> '') {
print "<td class='listtxt' style='padding-left:5'>".$row3{'projectsdetnametc'}."</td>";
} else if ($row3{'projectsdetnamesc'} <> '') {
print "<td class='listtxt' style='padding-left:5'>".$row3{'projectsdetnamesc'}."</td>";
} else {
print "<td class='listtxt' style='padding-left:5'></td>";
}
//Status
print "<td class='listtxt' align='center'>";
if ($row3{'projectsdetstatus'} == '1') // Enable
{
print "<a href='projects_detail_status.php?parentid=".$row3{'parentid'}."&projectsdetid=".$row3{'projectsdetid'}."'>";
print "<img src='images/tick.png' title='Enable' alt='Enable' border='0' hspace='2'></a>";
}
else // Disable
{
print "<a href='projects_detail_status.php?parentid=".$row3{'parentid'}."&projectsdetid=".$row3{'projectsdetid'}."'>";
print "<img src='images/cross.png' title='Disable' alt='Disable' border='0' hspace='2'></a>";
}
print "</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='projects_detail_modifyform.php?parentid=".$row3{'parentid'}."&projectsdetid=".$row3{'projectsdetid'}."'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";
// Delete
print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteprojectsDetail(".$row3{'parentid'}.", ".$row3{'projectsdetid'}.", ".$row3{'projectsdetsort'}.")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "</tr>";
}
mysql_close($dbh);
?>
</table>
</td>
</tr>
<?php } // check $pid ?>
<!-- End Page Content -->
</table>
</td></tr>
</table>
</body>
</html>
<?php
// echo path
function getLevel($p)
{
$sql1 = "select * from projects_case where projectscaseid = ". $p ." ";
$result1 = mysql_query($sql1);
while ($row1 = mysql_fetch_array($result1,MYSQL_ASSOC))
{
if ($row1{parentid} <> 0)
{
if ($row1{'projectscasenameen'} <> '') {
$n = $n . getLevel($row1{'parentid'}) ." > <a href='projects_case_index.php?pid=". $row1{'projectscaseid'} ."'>". $row1{'projectscasenameen'} ."</a>";
} else if ($row1{'projectscasenametc'} <> '') {
$n = $n . getLevel($row1{'parentid'}) ." > <a href='projects_case_index.php?pid=". $row1{'projectscaseid'} ."'>". $row1{'projectscasenametc'} ."</a>";
} else if ($row1{'projectscasenamesc'} <> '') {
$n = $n . getLevel($row1{'parentid'}) ." > <a href='projects_case_index.php?pid=". $row1{'projectscaseid'} ."'>". $row1{'projectscasenamesc'} ."</a>";
}
}
else
{
if ($row1{'projectscasenameen'} <> '') {
$n = " > <a href='projects_case_index.php?pid=". $row1{'projectscaseid'} ."'>". $row1{'projectscasenameen'} ."</a>";
} else if ($row1{'projectscasenametc'} <> '') {
$n = " > <a href='projects_case_index.php?pid=". $row1{'projectscaseid'} ."'>". $row1{'projectscasenametc'} ."</a>";
} else if ($row1{'projectscasenamesc'} <> '') {
$n = " > <a href='projects_case_index.php?pid=". $row1{'projectscaseid'} ."'>". $row1{'projectscasenamesc'} ."</a>";
}
}
}
return $n;
}
function getLevelNum($p)
{
$i_lv =1;
$sql1 = "select * from projects_case where projectscaseid = ". $p ." ";
$result1 = mysql_query($sql1);
if( mysql_num_rows($result1) ==0){
return $i_lv;
}
$i_lv++;
while($row1 = mysql_fetch_array($result1,MYSQL_ASSOC)){
if(strlen($row1["parentid"]) == 0 || $row1["parentid"] == 0 ){
return $i_lv;
}
$sql1 = "select * from projects_case where projectscaseid = ".$row1["parentid"] ." ";
$result1 = mysql_query($sql1);
$i_lv++;
}
}
?>