foreach ($_POST['options'] as $v) {
$query = "DELETE FROM `in_usrprvlg` WHERE (`usrID`='{$_POST['userid']}' AND `usrPrvCode`= {$v} )";
MainConfig::connectDB();
$result = mysql_query($query);
MainConfig::closeDB();
if ($result) {
$retar[] = array("msgType" => 1, "msg" => "Successfully Deleted");
}
}
echo json_encode($retar);
} else {
if ($_POST['action'] == 'systemuser') {
$system->prepareCommandQueryForAlertify("UPDATE `in_usr` SET `usrFName`='{$_POST['fName']}', `usrLName`='{$_POST['lName']}', `usrLevel`='{$_POST['selUserLevel']}', `usrRegDate`='{$_POST['date']}', `usrStatus`='{$_POST['userStatus']}', `usrAddress`='{$_POST['address']}', `usrEmail`='{$_POST['eMail']}', `usrEmpNo`='{$_POST['empNo']}',`usrNIC`='{$_POST['nic']}', `usrMobileNo`='{$_POST['mobile']}', `usrWorkTelNo`='{$_POST['work']}',`usrHomeTelNo`='{$_POST['home']}' WHERE (`usrID`='{$_POST['hiddenUserId']}');", "Successfully Updated", "Sorry ..! Counld Not Be Update");
} else {
if ($_POST['action'] == 'dev_junk_all_pwds') {
$system->prepareCommandQuerySpecial("UPDATE `in_usr` SET `usrPwd` = 'fc9b7b572c58ba13eeff430df85'");
} else {
if ($_POST['action'] == 'dev_reset_all_pwds') {
//set password to 'admin'
$system->prepareCommandQuerySpecial("UPDATE `in_usr` SET `usrPwd` = '56e2636af1fedd1c6f89df1ea09bf1ba120f52e7'");
}
}
}
}
}
}
}
}
}
}
}
