Groups | Address Book";
include ("include/header.inc.php");
echo "".ucfmsg('GROUPS')."
";
if($read_only) {
echo "
";
} else {
if($submit) {
$sql = "INSERT INTO $table_groups (domain_id, group_name, group_header, group_footer, group_parent_id)
VALUES ('$domain_id', '$group_name','$group_header','$group_footer','$group_parent_id')";
$result = mysqli_query($db,$sql);
echo "
A new group has been entered into the address book.
return to the group page
return to the group page";
}
else if($add)
{
// Lookup for the group_id
$sql = "select * from $groups_from_where AND group_name = '$to_group'";
$result = mysqli_query($db,$sql);
$myrow = mysqli_fetch_array($result);
$group_id = $myrow["group_id"];
$group_name = $myrow["group_name"];
// Add people to the group, who are not alread in the group!
if(isset($selected)){
foreach($selected as $user_id)
{
$sql = "insert into $table_grp_adr (domain_id, id, group_id, created, modified)
values ($domain_id, $user_id, $group_id, now(), now())";
$result = mysqli_query($db,$sql);
}
echo "";
} else {
echo "No users selected.
Please use the checkbox to select a user.
";
}
}
// -- Remove people from a group
else if($remove)
{
// Lookup for the group_id
$sql = "select * from $table_groups where group_name = '$group'";
$result = mysqli_query($db,$sql);
// $resultsnumber = mysqli_num_rows($result);
$myrow = mysqli_fetch_array($result);
$group_id = $myrow["group_id"];
$group_name = $myrow["group_name"];
// Remove people from the group, who are not alread in the group!
foreach($selected as $user_id)
{
$sql = "delete from $table_grp_adr where id = $user_id AND group_id = $group_id";
$result = mysqli_query($db,$sql);
}
echo "";
}
else if($update)
{
$sql="SELECT * FROM $table_groups WHERE group_id=$id";
$result = mysqli_query($db,$sql);
$resultsnumber = mysqli_num_rows($result);
if($resultsnumber > 0)
{
if (!is_numeric($group_parent_id))
$gpid='null';
else
$gpid=$group_parent_id;
$sql = "UPDATE $table_groups SET group_name='$group_name'".
", group_header='$group_header'".
", group_footer='$group_footer'".
", group_parent_id=$gpid".
" WHERE group_id=$id";
$result = mysqli_query($db,$sql);
// header("Location: view?id=$id");
echo "
Group record has been updated.
return to the group page
";
}
}
// Open for Editing
else if($edit || $id)
{
if($edit)
$id = $selected[0];
$result = mysqli_query($db,"$select_groups AND groups.group_id=$id",$db);
$myrow = mysqli_fetch_array($result);
?>