acl_get('a_group') )
{
return;
}
$module['GROUP']['MANAGE'] = basename(__FILE__) . "$SID";
return;
}
define('IN_PHPBB', 1);
// Include files
$phpbb_root_path = '../';
require($phpbb_root_path . 'extension.inc');
require('pagestart.' . $phpEx);
// Do we have general permissions?
if (!$auth->acl_get('a_group') )
{
trigger_error($user->lang['NO_ADMIN']);
}
// Check and set some common vars
$action = (isset($_REQUEST['action']))? $_REQUEST['action'] : ((isset($_POST['addgroup'])) ? 'addgroup' : '');
$group_id = (isset($_REQUEST['g']))? intval($_REQUEST['g']) : '';
// Which page?
page_header($user->lang['MANAGE']);
switch ($action)
{
case 'edit':
case 'addgroup':
$error = '';
// Grab data, even when submitting updates
if ($action == 'edit')
{
$sql = "SELECT *
FROM " . GROUPS_TABLE . "
WHERE group_id = $group_id";
$result = $db->sql_query($sql);
if (!extract($db->sql_fetchrow($result)))
{
trigger_error($user->lang['NO_GROUP']);
}
}
// Did we submit?
if (isset($_POST['submit']) || isset($_POST['submitprefs']))
{
if (isset($_POST['submit']))
{
if ($group_type != GROUP_SPECIAL)
{
$group_name = (!empty($_POST['group_name'])) ? htmlspecialchars($_POST['group_name']) : '';
$group_type = (!empty($_POST['group_type'])) ? intval($_POST['group_type']) : '';
}
$group_description = (!empty($_POST['group_description'])) ? htmlspecialchars($_POST['group_description']) : '';
$group_colour = (!empty($_POST['group_colour'])) ? htmlspecialchars($_POST['group_colour']) : '';
$group_rank = (isset($_POST['group_rank'])) ? intval($_POST['group_rank']) : '';
$group_avatar = (!empty($_POST['group_avatar'])) ? htmlspecialchars($_POST['group_avatar']) : '';
// Check data
if ($group_name == '' || strlen($group_name) > 40)
{
$error .= (($error != '') ? '
' : '') . (($group_name == '') ? $user->lang['GROUP_ERR_USERNAME'] : $user->lang['GROUP_ERR_USER_LONG']);
}
if (strlen($group_description) > 255)
{
$error .= (($error != '') ? '
' : '') . $user->lang['GROUP_ERR_DESC_LONG'];
}
if ($group_type < GROUP_OPEN || $group_type > GROUP_FREE)
{
$error .= (($error != '') ? '
' : '') . $user->lang['GROUP_ERR_TYPE'];
}
}
else
{
$user_lang = (!empty($_POST['user_lang'])) ? htmlspecialchars($_POST['user_lang']) : '';
$user_tz = (isset($_POST['user_tz'])) ? doubleval($_POST['user_tz']) : '';
$user_dst = (isset($_POST['user_dst'])) ? intval($_POST['user_dst']) : '';
}
// Update DB
if (!$error)
{
// Update group preferences
$sql = "UPDATE " . GROUPS_TABLE . "
SET group_name = '$group_name', group_description = '$group_description', group_type = $group_type, group_rank = $group_rank, group_colour = '$group_colour'
WHERE group_id = $group_id";
$db->sql_query($sql);
$user_sql = '';
$user_sql .= (isset($_POST['submit'])) ? ((($user_sql != '') ? ', ' : '') . "user_colour = '$group_colour'") : '';
$user_sql .= (isset($_POST['submit']) && $group_rank != -1) ? ((($user_sql != '') ? ', ' : '') . "user_rank = $group_rank") : '';
$user_sql .= (isset($_POST['submitprefs']) && $user_lang != -1) ? ((($user_sql != '') ? ', ' : '') . "user_lang = '$user_lang'") : '';
$user_sql .= (isset($_POST['submitprefs']) && $user_tz != -14) ? ((($user_sql != '') ? ', ' : '') . "user_timezone = $user_tz") : '';
$user_sql .= (isset($_POST['submitprefs']) && $user_dst != -1) ? ((($user_sql != '') ? ', ' : '') . "user_dst = $user_dst") : '';
// Update group members preferences
switch (SQL_LAYER)
{
case 'mysql':
case 'mysql4':
// batchwise? 500 at a time or so maybe? try to reduce memory useage
$more = true;
$start = 0;
do
{
$sql = "SELECT user_id
FROM " . USER_GROUP_TABLE . "
WHERE group_id = $group_id
LIMIT $start, 500";
$result = $db->sql_query($sql);
if ($row = $db->sql_fetchrow($result))
{
$user_count = 0;
$user_id_sql = '';
do
{
$user_id_sql .= (($user_id_sql != '') ? ', ' : '') . $row['user_id'];
$user_count++;
}
while ($row = $db->sql_fetchrow($result));
$sql = "UPDATE " . USERS_TABLE . "
SET $user_sql
WHERE user_id IN ($user_id_sql)";
$db->sql_query($sql);
if ($user_count == 500)
{
$start += 500;
}
else
{
$more = false;
}
}
else
{
$more = false;
}
$db->sql_freeresult($result);
unset($user_id_sql);
}
while ($more);
break;
default:
$sql = "UPDATE " . USERS_TABLE . "
SET $user_sql
WHERE user_id IN (
SELECT user_id
FROM " . USER_GROUP_TABLE . "
WHERE group_id = $group_id)";
$db->sql_query($sql);
}
trigger_error($user->lang['GROUP_UPDATED']);
}
}
?>
lang['MANAGE'] . ' : ' . $group_name . ''; ?>
lang['GROUP_EDIT_EXPLAIN']; ?>
sql_query($sql);
$rank_options = '';
if ($row = $db->sql_fetchrow($result))
{
do
{
$selected = (!empty($group_rank) && $row['rank_id'] == $group_rank) ? ' selected="selected"' : '';
$rank_options .= '';
}
while ($row = $db->sql_fetchrow($result));
}
$type_open = ($group_type == GROUP_OPEN) ? ' checked="checked"' : '';
$type_closed = ($group_type == GROUP_CLOSED) ? ' checked="checked"' : '';
$type_hidden = ($group_type == GROUP_HIDDEN) ? ' checked="checked"' : '';
$type_free = ($group_type == GROUP_FREE) ? ' checked="checked"' : '';
?>
lang['GROUP_SETTINGS']; ?>
lang['GROUP_SETTINGS_EXPLAIN']; ?>
lang['GROUP_MEMBERS']; ?>
lang['GROUP_LIST_EXPLAIN']; ?>
lang['MANAGE']; ?>
lang['GROUP_MANAGE_EXPLAIN']; ?>
lang['USER_DEF_GROUPS']; ?>
lang['USER_DEF_GROUPS_EXPLAIN']; ?>