session_start();
header("Cache-control: private"); //IE 6 Fix
$_SESSION['McMember_SpecialTitle'] = "Edit Member Permissions";
// Gets rid of all the error reporting on servers which are not configured appropriately.
error_reporting(E_ALL ^ E_NOTICE);
Function IsZeroOrOne($theNewVal){
if ($theNewVal == "ON"){
$ZO = 1;
}
else{
$ZO = 0;
}
return $ZO;
}
Function IsOnOff($theval){
if ($theval == 1){
$OO = "checked" ;
}
else{
$OO = "";
}
return $OO;
}
// VALIDATE THAT THE USER IS ABLE TO CREATE MEMBERS.
// include "ValidateMember.php";
if ($_SESSION['ValidateProblem']!=1){
// >> CHECK TO SEE IF THE MEMBER LOGGED IN IS THE SAME AS THE MEMBER
// >> BEING CALLED
// IF NOT CURRENT MEMBER, CHECK TO SEE IF MEMBER INFO IS PUBLIC
// IF MEMBER INFO PUBLIC DISPLAY
// Get the PHP file containing the DbConnector class
require_once('DbConnector.php');
// Create an instance of DbConnector
$connector = new DbConnector();
$theMemId = $_POST['MemberId'];
$theOdaId = $_POST['OAId'];
$thehiddenSubmitter = $_POST['hiddensubmitter'];
$Admin1 = $_POST['R1'];
$M1= IsZeroOrOne($_POST['MEM_ADD']);
$M2= IsZeroOrOne($_POST['MEM_EDIT']);
$M3= IsZeroOrOne($_POST['MEM_DEL']);
$G1 = IsZeroOrOne($_POST['GRP_ADD']);
$G2 = IsZeroOrOne($_POST['GRP_EDIT']);
$G3 = IsZeroOrOne($_POST['GRP_DEL']);
$MT1 = IsZeroOrOne($_POST['MTG_ADD']);
$MT2 = IsZeroOrOne($_POST['MTG_EDIT']);
$MT3 = IsZeroOrOne($_POST['MTG_DEL']);
$C1 = IsZeroOrOne($_POST['CAL_ADD']);
$C2 = IsZeroOrOne($_POST['CAL_EDIT']);
$C3 = IsZeroOrOne($_POST['CAL_DEL']);
$N1 = IsZeroOrOne($_POST['NWS_ADD']);
$N2 = IsZeroOrOne($_POST['NWS_EDIT']);
$N3 = IsZeroOrOne($_POST['NWS_DEL']);
$E1 = IsZeroOrOne($_POST['EVT_ADD']);
$E2 = IsZeroOrOne($_POST['EVT_EDIT']);
$E3 = IsZeroOrOne($_POST['EVT_DEL']);
$F1 = IsZeroOrOne($_POST['FAQ_ADD']);
$F2 = IsZeroOrOne($_POST['FAQ_EDIT']);
$F3 = IsZeroOrOne($_POST['FAQ_DEL']);
// echo $Admin1;
if ($Admin1 == "V1"){
$M1= 1;$M2= 1;$M3= 1;
$G1 = 1;$G2 = 1;$G3 = 1;
$MT1 = 1;$MT2 = 1;$MT3 = 1;
$C1 = 1;$C2 = 1;$C3 = 1;
$N1 = 1;$N2 = 1;$N3 = 1;
$E1 = 1;$E2 = 1;$E3 = 1;
$F1 = 1;$F2 = 1;$F3 = 1;
$Admin1 = 1;
}
If ($thehiddenSubmitter == "pookachoo"){
$theString= "MemAdd='$M1', MemEdit='$M2',MemDel='$M3',";
$theString= $theString."GrpAdd='$G1', GrpEdit='$G2',GrpDel='$G3',";
$theString= $theString."MtgAdd='$MT1', MtgEdit='$MT2',MtgDel='$MT3',";
$theString= $theString."CalAdd='$C1', CalEdit='$C2',CalDel='$C3',";
$theString= $theString."NwsAdd='$N1', NwsEdit='$N2',NwsDel='$N3',";
$theString= $theString."EvtAdd='$E1', EvtEdit='$E2',EvtDel='$E3',";
$theString= $theString."FAQAdd='$F1', FAQEdit='$F2',FAQDel='$F3',Admin='$Admin1'";
$qVals = "UPDATE oda SET ".$theString." WHERE OdaId=".$theOdaId;
// echo $theString;
$result = $connector->query("$qVals");
echo '';
}
// >> GET ORG ID
if($_SESSION['McMember_OrgId']){
// everything is alright
}else{
// something has gone wrong, the org id cant be located
$_SESSION['McMember_FailureReason'] = "UnableToLocateOrgId";
header("location: Login.php");
}
// USED FOR TESTING PURPOSES
// $_SESSION['McMember_OrgId'] = 1;
// Gets rid of all the error reporting on servers which are not configured appropriately. error_reporting(E_ALL ^ E_NOTICE);
// Get the PHP file containing the DbConnector class
require_once('DbConnector.php');
// Create an instance of DbConnector
$connector = new DbConnector();
// GET THE ORG DETAILS
// THROW THEM INTO VARIABLES
$qVals11 = "SELECT * FROM org WHERE OrgId =".$_SESSION['McMember_OrgId'];
$result = $connector->query($qVals11);
// Get the result
$row = $connector->fetchArray($result);
$OrgName = $row["OrgName"];
$OrgNumber = $row["OrgNumber"];
// >> GET MEMBER PERMISSIONS
// CHECK PERMISSIONS OF THE USER TO SEE WHAT THEY CAN DO WITH MEMBERS
// POPULATE SESSION PERMISSIONS BASED ON THOSE VALUES.
// >> PULL UP THE DATA TO BE USED IN THE LIST
if(isset($_GET['ID'])){
$theMemId = $_GET['ID'];
}
$qVals11 = "SELECT * FROM oda LEFT JOIN mem ON oda.MemId = mem.MemID WHERE OrgId =".$_SESSION['McMember_OrgId']." AND mem.Deleted=0 AND mem.MemId=".$theMemId;
// $qVals11 = "SELECT * FROM mem WHERE MemId=".$theMemId." ORDER BY LastName";
// echo $qVals11;
$result = $connector->query($qVals11);
$record_found = mysql_num_rows($result);
$nrows = mysql_num_rows($result);
$row = $connector->fetchArray($result);
if($record_found > 0){
?>