webadmin.php

/var/www/(Del)tsolpv.com/2013/webadmin/servicedownload_index.php

<?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");

// To array, not expected many records, so put all result into memory array
$sql1 = "select * from service where serpagemodule = 'servicedownload' order by sersort ASC ";
$result1 = mysql_query($sql1);
$rows1 = array();
while ($row1 = mysql_fetch_array($result1,MYSQL_ASSOC))
    $rows1[] = $row1;

// Initial serid
$serid = empty($_GET['serid']) ? NULL : $_GET['serid'];
if ($serid === NULL && count($rows1) > 0)
{
    // Get first row record
    $row1 = $rows1[0];
    $serid = $row1['serid'];
}
?>
<!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 MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<script type="text/javascript">
function DeleteRowCategory(serid,serdlwid,serdlwsort)
{
  if (confirm("Are you sure you want to delete?"))
    {
        window.location.href = 'servicedownload_delete.php?serid='+serid+'&serdlwid='+serdlwid+'&serdlwsort='+serdlwsort;    
    }
}
</script>

</head>

<body>
<!-- serid is <?php echo $serid; ?> -->
<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">&nbsp;</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">&nbsp;&nbsp;</td>
              <td width="50" align="center" class="icontxt"><a href="servicedownload_addform.php?serid=<?=$serid;?>"><img src="images/iconNew.png" alt="Add" width="32" height="32" border="0" /><br />&nbsp;建立&nbsp;&nbsp;</a></td>
            </tr>
          </table></td>
      </tr>
     <tr>
        <td class="pagetitletxt">&nbsp;&nbsp;<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle" /> 服务 - 下载 </b></td>
      </tr>
      <tr>
        <td height="25" align="left" valign="middle" class="msg"><?php echo $_GET['msg']; ?></td>
      </tr>
      <tr>
        <td height="35" align="right" valign="middle" class="content">&nbsp;<strong>页</strong>
          <select name="serid" onChange="MM_jumpMenu('self',this,0)">
              <?php
            foreach ($rows1 as $row1)
            {
                echo "<option value='servicedownload_index.php?serid=". $row1['serid'] ."' ". getSelect($serid, $row1['serid']) ." >". $row1['sertitleen'] ."</option>\n";
            }
            ?>
          </select></td>
      </tr>
      <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">排序</td>
              <td width="600" class="listtitletxt">主题</td>
              <td width="20" class="listtitletxt"></td>
              <td width="20" class="listtitletxt"></td>
              <td width="20" class="listtitletxt"></td>
            </tr>
            <?php
            if($serid !== NULL){
                $result = mysql_query("SELECT * FROM service_download WHERE serid = ".$serid." ORDER BY serdlwsort ASC ");
                while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
                {
                    print "<tr>";
                    print "<td class='listtxt' style='padding-left:5'>&nbsp;</td>";
                    print "<td class='listtxt' valign='middle' align='left'>";
                    print "<a href='servicedownload_sort.php?status=up&serid=".$row{'serid'}."&serdlwid=".$row{'serdlwid'}."&sort=".$row{'serdlwsort'}."'>";
                    print "<img src='images/up.gif' alt='Up' border='0'></a>&nbsp;";                
                    print "<a href='servicedownload_sort.php?status=down&serid=".$row{'serid'}."&serdlwid=".$row{'serdlwid'}."&sort=".$row{'serdlwsort'}."'>";
                    print "<img src='images/down.gif' alt='Down' border='0'></a>";
                    print "</td>";
                    if ($row{'serdlwtitlesc'} <> '') {
                        print "<td class='listtxt' style='padding-left:5'>".$row{'serdlwtitlesc'}."</td>";
                    } else {
                        print "<td class='listtxt' style='padding-left:5'>".$row{'serdlwtitleen'}."</td>";
                    } 
                    
                    //Status
                    print "<td class='listtxt' align='center'>";
                    if ($row{'serdlwstatus'} == '1') // Enable
                    {
                        print "<a href='servicedownload_status.php?serid=".$row{'serid'}."&serdlwid=".$row{'serdlwid'}."'>";
                        print "<img src='images/tick.png' title='启用' alt='启用' border='0' hspace='2'></a>";
                    }
                    else // Disable
                    {
                        print "<a href='servicedownload_status.php?serid=".$row{'serid'}."&serdlwid=".$row{'serdlwid'}."'>";
                        print "<img src='images/cross.png' title='停用' alt='停用' border='0' hspace='2'></a>";
                    }
                    print "</td>";
                    
                    // Modify            
                    print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='servicedownload_modifyform.php?serid=".$row{'serid'}."&serdlwid=".$row{'serdlwid'}."'\"><img src='images/btnModify.png' title='修改' alt='修改' hspace='2' border='0'></a></td>";
                    
                    // Delete
                    print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteRowCategory(".$row{'serid'}.", ".$row{'serdlwid'}.", ".$row{'serdlwsort'}.")\"><img src='images/btnDelete.png' title='删除' alt='删除' hspace='2' border='0'></a></td>";
                    print "</tr>";
                }
            }
            mysql_close($dbh);
            ?>
        </table></td>
      </tr>
</table>
</td></tr>
</table>
</body>
</html>
<?php
function getSelect($field1, $field2)
{
    if ($field1 == $field2)
    {
        return "selected";
    }
    else
    {
        return "";
    }
}
?>