// Clear some vars

$can_upload = (file_exists($phpbb_root_path . $config['avatar_path']) && is_writeable($phpbb_root_path . $config['avatar_path']) && $file_uploads) ? true : false;

// Grab basic data for group, if group_id is set and exists

if ($group_id)

FROM ' . GROUPS_TABLE . "

WHERE group_id = $group_id";

$result = $db->sql_query($sql);

{

trigger_error($user->lang['NO_GROUP']);

}

}

switch ($mode)

// Common javascript

?>

<!--

function marklist(match, status)

{

{

trigger_error($user->lang['NO_GROUP']);

}

switch ($action)

{

case 'demote':

$message = 'GROUP_MODS_DEMOTED';

case 'promote':

$message = 'GROUP_MODS_PROMOTED';

case 'approve':

$message = 'USERS_APPROVED';

}

trigger_error($user->lang[$message]);

case 'default':

if (!$group_id)

$sql = 'SELECT user_id

FROM ' . USER_GROUP_TABLE . "

WHERE group_id = $group_id

$mark_ary = array();

if ($row = $db->sql_fetchrow($result))

}

while ($row = $db->sql_fetchrow($result));

$start = (sizeof($user_id_ary) < 200) ? 0 : $start + 200;

}

}

else

{

}

trigger_error($user->lang['GROUP_DEFS_UPDATED']);

case 'deleteusers':

case 'delete':

switch ($action)

{

case 'delete':

case 'deleteusers':

}

if ($error)

$message = ($action == 'delete') ? 'GROUP_DELETED' : 'GROUP_USERS_REMOVE';

trigger_error($user->lang[$message]);

}

case 'addusers':

if (!$group_id)

$name_ary = array_unique(explode("\n", $name_ary));

// Add user/s to group

{

trigger_error($user->lang[$error]);

}

$message = ($action == 'addleaders') ? 'GROUP_MODS_ADDED' : 'GROUP_USERS_ADDED';

trigger_error($user->lang[$message]);

case 'edit':

case 'add':

if ($action == 'edit' && !$group_id)

{

trigger_error($user->lang['NO_GROUP']);

{

$group_name = request_var('group_name', '');

$group_desc = request_var('group_description', '');

$data['uploadurl'] = request_var('uploadurl', '');

$data['remotelink'] = request_var('remotelink', '');

$delete = request_var('delete', '');

$avatar = '';

if ((!empty($_FILES['uploadfile']['tmp_name']) || $data['uploadurl']) && $can_upload)

{

}

else if ($data['remotelink'])

{

}

}

}

else if ($delete)

{

}

{

}

// Only set the rank, colour, etc. if it's changed or if we're adding a new

// group. This prevents existing group members being updated if no changes

// were made.

foreach (array('rank', 'colour', 'avatar', 'avatar_type', 'avatar_width', 'avatar_height', 'receive_pm', 'message_limit') as $test)

{

}

{

$message = ($action == 'edit') ? 'GROUP_UPDATED' : 'GROUP_CREATED';

trigger_error($message);

else if (!$group_id)

{

$group_name = request_var('group_name', '');

}

?>

<p><?php echo $user->lang['GROUP_EDIT_EXPLAIN']; ?></p>

<?php

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

WHERE rank_special = 1

$type_closed = ($group_type == GROUP_CLOSED) ? ' checked="checked"' : '';

$type_hidden = ($group_type == GROUP_HIDDEN) ? ' checked="checked"' : '';

{

{

case AVATAR_UPLOAD:

$avatar_img = $phpbb_root_path . $config['avatar_path'] . '/';

$avatar_img = $phpbb_root_path . $config['avatar_gallery_path'] . '/';

break;

}

}

else

{

if ($group_type != GROUP_SPECIAL)

{

}

else

</tr>

<tr>

<td class="row2"><b><?php echo $user->lang['GROUP_DESC']; ?>:</b></td>

</tr>

<?php

</tr>

<tr>

<td class="row2"><b><?php echo $user->lang['GROUP_RECEIVE_PM']; ?>:</b></td>

</tr>

<tr>

<td class="row2"><b><?php echo $user->lang['GROUP_MESSAGE_LIMIT']; ?>:</b><br /><span class="gensmall"><?php echo $user->lang['GROUP_MESSAGE_LIMIT_EXPLAIN']; ?></span></td>

</tr>

<tr>

<td class="row2"><b><?php echo $user->lang['GROUP_COLOR']; ?>:</b><br /><span class="gensmall"><?php echo $user->lang['GROUP_COLOR_EXPLAIN']; ?></span></td>

</tr>

<tr>

<td class="row2"><b><?php echo $user->lang['GROUP_RANK']; ?>:</b></td>

</tr>

<tr>

<td class="row2" width="35%"><b><?php echo $user->lang['LINK_REMOTE_SIZE']; ?>: </b><br /><span class="gensmall"><?php echo $user->lang['LINK_REMOTE_SIZE_EXPLAIN']; ?></span></td>

</tr>

<?php

<td class="cat" colspan="2" align="center" valign="middle"><span class="genmed"><?php echo $user->lang['AVATAR_CATEGORY']; ?>: </span><select name="avatarcat">{S_CAT_OPTIONS}</select>&nbsp; <span class="genmed"><?php echo $user->lang['AVATAR_PAGE']; ?>: </span><select name="avatarpage">{S_PAGE_OPTIONS}</select>&nbsp;<input class="btnlite" type="submit" value="<?php echo $user->lang['GO']; ?>" name="avatargallery" /></td>

</tr>

<tr>

<!-- BEGIN avatar_row -->

<tr>

<!-- BEGIN avatar_column -->

<!-- END avatar_option_column -->

</tr>

<!-- END avatar_row -->

</tr>

<?php

<?php

adm_page_footer();

}

if ($mode == 'list' || $group_id)

FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . " ug

WHERE ug.group_id = $group_id

AND u.user_id = ug.user_id

$leader = $member = 0;

$group_data = array();

}

$db->sql_freeresult($result);

{

?>

?>

<tr>

foreach (array('default' => 'DEFAULT', 'approve' => 'APPROVE', 'demote' => 'DEMOTE', 'promote' => 'PROMOTE', 'deleteusers' => 'DELETE') as $option => $lang)

{

echo '<option value="' . $option . '">' . $user->lang['GROUP_' . $lang] . '</option>';

}

</tr>

<table width="95%" cellspacing="1" cellpadding="1" border="0" align="center">

<tr>

<?php

adm_page_footer();

// Setting groupwide preferences

case 'prefs':

<?php

adm_page_footer();

default:

trigger_error($user->lang['NO_MODE']);

<p>Sessions should be initiated on each page, as near the top as possible using the following code:</p>

<blockquote><pre>

$auth->acl($user->data);

$user->setup();

</pre></blockquote>

}

$db->sql_freeresult($result);

{

{

}

}

// Delete posts, attachments, etc.

$sql = 'SELECT user_id, username

FROM ' . USERS_TABLE . '

WHERE user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')

if ($row = $db->sql_fetchrow($result))

{

FROM ' . USERS_TABLE . "

WHERE user_id = $user_id";

$result = $db->sql_query($sql);

$db->sql_freeresult($result);

}

global $db, $user, $auth;

// Delete stale bans

$db->sql_query($sql);

$ban_list = (!is_array($ban)) ? array_unique(explode("\n", $ban)) : $ban;

switch (SQL_LAYER)

{

case 'mysql':

break;

case 'mysql4':

case 'mysqli':

case 'mssql':

case 'sqlite':

break;

default:

$sql = 'INSERT INTO ' . BANLIST_TABLE . " ($type, ban_start, ban_end, ban_exclude, ban_reason)

$db->sql_query($sql);

}

}

$result = $db->sql_query($sql);

$sql_in = array();

if ($row = $db->sql_fetchrow($result))

{

do

$sql = 'WHERE session_user_id IN (' . str_replace('*', '%', implode(', ', $sql_in)) . ")";

}

break;

}

global $db, $user, $auth;

// Delete stale bans

$db->sql_query($sql);

$unban_sql = implode(', ', $ban);

if ($unban_sql)

{

$l_unban_list = '';

// Grab details of bans for logging information later

switch ($mode)

{

*/

function avatar_gallery($category, &$error)

{

$path = $phpbb_root_path . $config['avatar_gallery_path'];

//

// Usergroup functions

//

/**

* Add or edit a group. If we're editing a group we only update user

* parameters such as rank, etc. if they are changed

*/

{

global $phpbb_root_path, $config, $db, $user, $file_upload;

$error = array();

// Check data

if (!strlen($name) || strlen($name) > 40)

'group_type' => (int) $type,

);

{

{

}

}

$sql = ($group_id) ? 'UPDATE ' . GROUPS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE group_id = $group_id" : 'INSERT INTO ' . GROUPS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

$db->sql_query($sql);

$sql_ary = array();

{

{

}

}

FROM ' . GROUPS_TABLE . "

WHERE group_id = $group_id";

$result = $db->sql_query($sql);

$db->sql_freeresult($result);

}

$sql = 'SELECT u.user_id, u.username

FROM ' . USER_GROUP_TABLE . ' ug, ' . USERS_TABLE . " u

WHERE ug.group_id = $group_id

if ($row = $db->sql_fetchrow($result))

{

/**

* Add user(s) to group

*/

{

global $db, $auth;

if ($default)

{

}

// Clear permissions cache of relevant users

$group_order = array('ADMINISTRATORS', 'SUPER_MODERATORS', 'REGISTERED_COPPA', 'REGISTERED', 'BOTS', 'GUESTS');

// We need both username and user_id info

user_get_id_name($user_id_ary, $username_ary);

{

$group_order_id[$row['group_name']] = $row['group_id'];

}

$db->sql_freeresult($result);

foreach ($special_group_data as $gid => $default_data_ary)

{

{

$db->sql_query($sql);

}

}

WHERE group_id = $group_id

AND user_id IN (" . implode(', ', $user_id_ary) . ')';

$db->sql_query($sql);

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

FROM ' . GROUPS_TABLE . "

WHERE group_id = $group_id";

$result = $db->sql_query($sql);

}

if (!function_exists('add_log'))

add_log('admin', $log, $group_name, implode(', ', $username_ary));

return false;

}

/**

* This is used to promote (to leader), demote or set as default a member/s

*/

{

global $db, $auth;

$db->sql_query($sql);

$log = ($action == 'promote') ? 'LOG_GROUP_PROMOTED' : 'LOG_GROUP_DEMOTED';

case 'approve':

$sql = 'UPDATE ' . USER_GROUP_TABLE . "

$db->sql_query($sql);

$log = 'LOG_GROUP_APPROVE';

case 'default':

$log = 'LOG_GROUP_DEFAULTS';

break;

}

FROM ' . GROUPS_TABLE . "

WHERE group_id = $group_id";

$result = $db->sql_query($sql);

}

add_log('admin', $log, $group_name, implode(', ', $username_ary));

return false;

}

/**

* Obtain either the members of a specified group, the groups the specified user is subscribed to

* or checking if a specified user is in a specified group

*