query("$qVals");
$theNewMemId = mysql_insert_id();
$theMemId = $theNewMemId;
// echo $theMemId." ";
// IF THERE IS A MEMBER ID WITH THIS SESSION,
// ASSIGN IT AS THE CREATORID SO THAT WE KNOW WHO CREATED IT
// -----------------------------------------------------------------
if($_SESSION['McMember_MemId']){
$qVals11 = "UPDATE mem SET CreatedByMemId=".$_SESSION['McMember_MemId']." WHERE MemId=".$theNewMemId;
$result11 = $connector->query("$qVals11");
// echo $qVals11;
}
else{ // ASSIGN THE NEW MEMBER ID TO THE SESSION
$_SESSION['McMember_MemId'] = $theNewMemId;
$qVals12 = "UPDATE mem SET CreatedByMemId=".$_SESSION['McMember_MemId']." WHERE MemId=".$theNewMemId;
$result12 = $connector->query("$qVals12");
// echo $qVals12;
}
// UPDATE THE USER ID AND PASSWORD FOR THE NEW MEMBER
// CREATE THE UID
// -----------------------------------------------------------------
$FN = $MemFName{0};
$LN = $MemLName{0}.$MemLName{1}.$MemLName{2}.$MemLName{3}.$MemLName{4};
$UserID = $FN.$LN.$theNewMemId;
// GENERATE THE PASSWORD
$UserString = str_makerand(6,8,0,0,0);
$UserPass = Encrypt($UserString);
// ASSIGN THE DATA TO SESSION DETAILS
$_SESSION['McMember_UserID'] = $UserID;
$_SESSION['McMember_UserPass'] = $UserString;
$_SESSION['McMember_UserHash'] = $UserPass;
// echo " ".$_SESSION['McMember_UserID']." - ".$_SESSION['McMember_UserPass']." ";
// UPDATE THE MEMBER RECORD IN THE DATABASE
$qVals15 = "UPDATE mem SET UID='".$UserID."',UPASS='".$UserPass."' WHERE MemId=".$theNewMemId;
$result15 = $connector->query($qVals15);
// echo $qVals15;
// TODO -----------------------------------------------------------------
// SEND THE NEW MEMBER A MAIL NOTIFICATION ASKING
// THEM TO ACTIVATE THEIR ACCOUNT
// SEND THE UID AND PASS TO THEM
// TODO -----------------------------------------------------------------
// - CHECK TO SEE IF THERE ARE ANY OTHER MEMBERS.
// - IF NO MEMBERS, FIRST MEMBER BECOMES ADMIN
// -----------------------------------------------------------------
// - CHECK FOR EXISTING MEMBERS
// BEFORE ADDING THE MEMBER
$qVals10 = "SELECT * FROM oda WHERE OrgId =".$_SESSION['McMember_OrgId'];
$result2 = $connector->query($qVals10);
$row = $connector->fetchArray($result2);
if (!empty($row)){
$ManyBefore = 1;
}
else{
$ManyBefore = 0;
}
// INSERT THE NEW MEMBER INFO INTO THE PERMISSIONS TABLE
// EVERYTHING IS SET TO NULL BY DEFAULT
$FieldNames2 = "OrgId,MemId";
$FieldValues2 =$_SESSION['McMember_OrgId'].",".$theNewMemId;
$qVals2 = "INSERT INTO oda ($FieldNames2) VALUES ($FieldValues2)";
$result3 = $connector->query("$qVals2");
$theNewOdaId = mysql_insert_id();
// echo " ".$qVals2;
// IF THERE ARE NO PREVIOUS MEMBERS SET THIS MEMBER AS ADMIN
If ($ManyBefore == 0){
$qVals3 = "UPDATE oda SET oda.Admin = 1, oda.MemAdd = 1, oda.MemDel = 1, oda.MemEdit = 1, oda.GrpAdd = 1, oda.GrpDel = 1, oda.GrpEdit = 1, oda.SendEmail = 1, oda.CalAdd = 1, oda.CalDel = 1, oda.CalEdit = 1 WHERE OdaId=$theNewOdaId";
$result4 = $connector->query("$qVals3");
// echo " ".$qVals3;
}
// FORWARD THE USER TO THE VIEWMEMBERS SCREEN
// header("location: ViewMembers.php");
// close window and reload previous window
// echo "$FromTheLandOf";
if ($FromTheLandOf=="Groups" || $FromTheLandOf=="Units"){
echo '';
}
header("Location: ViewMembers.php?MCID=2");
}
// 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"];
?>