}
if ($extnum) {
$ret = gs_user_external_number_add($edit_user, $extnum);
if (isGsError($ret)) {
echo '<div class="errorbox">', $ret->getMsg(), '</div>', "\n";
}
}
if ($u_pgrp_ed) {
$sql_query = 'DELETE `p` ' . 'FROM `pickupgroups_users` `p` , `users` `u` ' . 'WHERE ' . '`p`.`user_id` = `u`.`id` AND ' . '`u`.`user` = \'' . $DB->escape($edit_user) . '\'';
$ok = $DB->execute($sql_query);
if (is_array($u_pgrps)) {
foreach ($u_pgrps as $u_pgrp) {
if ($u_pgrp < 1) {
continue;
}
$ret = gs_pickupgroup_user_add($u_pgrp, $edit_user);
if (isGsError($ret)) {
echo '<div class="errorbox">', $ret->getMsg(), '</div>', "\n";
}
}
}
}
if ($u_prv_grp_ed) {
$query = 'UPDATE `users` SET ' . '`group_id`=' . ($u_prv_grp_id > 0 ? $u_prv_grp_id : 'NULL') . ' ' . 'WHERE `user`=\'' . $DB->escape($edit_user) . '\'';
$ok = $DB->execute($query);
}
if ($bp_add_h > 0) {
$user_id = (int) $DB->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $DB->escape($edit_user) . '\'');
if ($user_id > 0) {
$host_exists = $DB->executeGetOne('SELECT 1 FROM `hosts` WHERE `id`=' . $bp_add_h);
if ($host_exists) {
}
}
if ($title && !$save) {
$ret = gs_pickupgroup_add($title);
if (isGsError($ret)) {
echo $ret->getMsg();
}
}
if ($save) {
$sql_query = 'UPDATE `pickupgroups` SET
`title`=\'' . $DB->escape($title) . '\'
WHERE `id`=' . $save;
$rs = $DB->execute($sql_query);
}
if ($group && $user) {
$ret = gs_pickupgroup_user_add($group, $user);
if (isGsError($ret)) {
echo $ret->getMsg();
}
}
#####################################################################
# show pickup group {
#####################################################################
if (!$group) {
$sql_query = 'SELECT SQL_CALC_FOUND_ROWS
`p`.`id` `id`, `p`.`title` `title`,
COUNT(`pu`.`user_id`) `num_members`
FROM
`pickupgroups` `p` LEFT JOIN
`pickupgroups_users` `pu` ON (`pu`.`group_id`=`p`.`id`)
GROUP BY `p`.`id`