|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_eoffice/application/tool/ |
Upload File : |
<?
session_start();
include "../../config/config.inc.php";
if($action == "run"){
/* $sql = "SELECT * FROM epm_staff WHERE staffname <> 'Administrator' and staffname <> 'Guest'";
$res = mysql_db_query($dbname,$sql);
while($rs1 = mysql_fetch_assoc($res)){
$strSQL = "SELECT app_list.app_id, permission_status.pid FROM app_list INNER JOIN permission_status ON app_list.app_id=permission_status WHERE app_list.app_status = 'on' and app_list.app_dir <> 'system' and permission_status.pid <> '10'";
$Result = mysql_db_query($dbname,$strSQL);
while($rs = mysql_fetch_assoc($Result)){
$strSQL_up = "REPLACE INTO app_admin(staff_id, app_id)VALUES('$rs1[staffid]','$rs[pid]')";
$result_up = mysql_db_query($dbname,$strSQL_up);
} // end while($rs = mysql_fetch_assoc($Result)){
} // end while($rs1 = mysql_fetch_assoc($res)){
*/
$sql = "SELECT app_list.app_id, permission_status.pid, permission_status.permit_id FROM app_list INNER JOIN permission_status ON app_list.app_id=permission_status.app_id WHERE app_list.app_status = 'on' and app_list.app_dir <> 'system' and permission_status.pid <> '10'";
$result = mysql_db_query($dbname,$sql);
while($rs = mysql_fetch_assoc($result)){
$strSQL1 = "SELECT staffid FROM epm_staff WHERE staffname <> 'Administrator' AND staffname <> 'Guest'";
$Result1 = mysql_db_query($dbname,$strSQL1);
while($rs1 = mysql_fetch_assoc($Result1)){
$sql_up = "REPLACE INTO app_admin(staff_id, app_id, type_user)VALUES('$rs1[staffid]','$rs[permit_id]','user') ";
@mysql_db_query($dbname,$sql_up);
}
} // end while($rs = mysql_fetch_assoc($result)){
} // end if($action == "run"){
?>
<html>
<head>
<title>tool gen password</title>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<link href="../../common/style.css" type="text/css" rel="stylesheet" />
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></script>
<style type="text/css">
<!--
body { margin: 0px 0px; padding: 0px 0px}
a:link { color: #005CA2; text-decoration: none}
a:visited { color: #005CA2; text-decoration: none}
a:active { color: #0099FF; text-decoration: underline}
a:hover { color: #0099FF; text-decoration: underline}
-->
</style>
</head>
<body>
<a href="?action=run"> || run gen user || </a>
</body>
</html>