<dd><input name="group_message_limit" type="text" id="group_message_limit" maxlength="4" size="4" value="{GROUP_MESSAGE_LIMIT}" /></dd>

</dl>

<dl>

<dt><label for="group_colour">{L_GROUP_COLOR}:</label><br /><span>{L_GROUP_COLOR_EXPLAIN}</span></dt>

<dd><input name="group_colour" type="text" id="group_colour" value="{GROUP_COLOUR}" size="6" maxlength="6" />&nbsp;&nbsp;<span>[ <a href="{U_SWATCH}" onclick="popup(this.href, 636, 150, '_swatch'); return false">{L_COLOUR_SWATCH}</a> ]</span></dd>

</dl>

'group_sig_chars' => array('UINT', 0),

'group_receive_pm' => array('BOOL', 0),

'group_message_limit' => array('UINT', 0),

'group_legend' => array('BOOL', 1),

),

'PRIMARY_KEY' => 'group_id',

'group_sig_chars' => array('UINT', 0),

'group_receive_pm' => array('BOOL', 0),

'group_message_limit' => array('UINT', 0),

'group_legend' => array('BOOL', 1),

),

'PRIMARY_KEY' => 'group_id',

'pm_max_msgs' => array('lang' => 'BOXES_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

'full_folder_action' => array('lang' => 'FULL_FOLDER_ACTION', 'validate' => 'int', 'type' => 'select', 'method' => 'full_folder_select', 'explain' => true),

'pm_edit_time' => array('lang' => 'PM_EDIT_TIME', 'validate' => 'int:0', 'type' => 'text:5:5', 'explain' => true, 'append' => ' ' . $user->lang['MINUTES']),

'legend2' => 'GENERAL_OPTIONS',

'allow_mass_pm' => array('lang' => 'ALLOW_MASS_PM', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'receive_pm' => isset($_REQUEST['group_receive_pm']) ? 1 : 0,

'legend' => isset($_REQUEST['group_legend']) ? 1 : 0,

'message_limit' => request_var('group_message_limit', 0),

'founder_manage' => 0,

);

// were made.

$group_attributes = array();

foreach ($test_variables as $test)

{

if (isset($submit_ary[$test]) && ($action == 'add' || $group_row['group_' . $test] != $submit_ary[$test]))

'GROUP_FOUNDER_MANAGE' => (isset($group_row['group_founder_manage']) && $group_row['group_founder_manage']) ? ' checked="checked"' : '',

'GROUP_LEGEND' => (isset($group_row['group_legend']) && $group_row['group_legend']) ? ' checked="checked"' : '',

'GROUP_MESSAGE_LIMIT' => (isset($group_row['group_message_limit'])) ? $group_row['group_message_limit'] : 0,

'GROUP_COLOUR' => (isset($group_row['group_colour'])) ? $group_row['group_colour'] : '',

trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);

}

{

}

add_log('admin', 'LOG_RESYNC_POSTCOUNTS');

return false;

}

// Before we begin, we will remove the reports the user issued.

$sql = 'SELECT r.post_id, p.topic_id

FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p

{

case 'retain':

if ($post_username === false)

{

$post_username = $user->lang['GUEST'];

$db->sql_query($sql);

}

}

break;

case 'remove':

break;

}

$table_ary = array(USERS_TABLE, USER_GROUP_TABLE, TOPICS_WATCH_TABLE, FORUMS_WATCH_TABLE, ACL_USERS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, FORUMS_TRACK_TABLE, PROFILE_FIELDS_DATA_TABLE, MODERATOR_CACHE_TABLE, DRAFTS_TABLE, BOOKMARKS_TABLE);

foreach ($table_ary as $table)

$db->sql_query($sql);

}

// Reset newest user info if appropriate

if ($config['newest_user_id'] == $user_id)

{

set_config('num_users', $config['num_users'] - 1, true);

}

return false;

}

'group_receive_pm' => 'int',

'group_legend' => 'int',

'group_message_limit' => 'int',

'group_founder_manage' => 'int',

);

// Those are group-only attributes

// Check data. Limit group name length.

if (!utf8_strlen($name) || utf8_strlen($name) > 60)

$lang_reasons[$post_data['user_lang']] = $user->lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang];

// Only load up the language pack if the language is different to the current one

{

// Load up the language pack

$lang = array();

// If we find the reason in this language pack use it

if (isset($lang['report_reasons']['DESCRIPTION'][$disapprove_reason_lang]))

'colour' => request_var('group_colour', ''),

'rank' => request_var('group_rank', 0),

'receive_pm' => isset($_REQUEST['group_receive_pm']) ? 1 : 0,

);

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

// were made.

$group_attributes = array();

foreach ($test_variables as $test)

{

if ($action == 'add' || (isset($submit_ary[$test]) && $group_row['group_' . $test] != $submit_ary[$test]))

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'GROUP_RECEIVE_PM' => (isset($group_row['group_receive_pm']) && $group_row['group_receive_pm']) ? ' checked="checked"' : '',

'GROUP_MESSAGE_LIMIT' => (isset($group_row['group_message_limit'])) ? $group_row['group_message_limit'] : 0,

'GROUP_DESC' => $group_desc_data['text'],

'S_DESC_BBCODE_CHECKED' => $group_desc_data['allow_bbcode'],

// Do NOT use request_var or specialchars here

$address_list = isset($_REQUEST['address_list']) ? $_REQUEST['address_list'] : array();

$submit = (isset($_POST['post'])) ? true : false;

$preview = (isset($_POST['preview'])) ? true : false;

$save = (isset($_POST['save'])) ? true : false;

// Output PM_TO box if message composing

if ($action != 'edit')

{

{

$sql = 'SELECT g.group_id, g.group_name, g.group_type

FROM ' . GROUPS_TABLE . ' g';

$template->assign_vars(array(

'S_SHOW_PM_BOX' => true,

'S_ALLOW_MASS_PM' => ($config['allow_mass_pm'] && $auth->acl_get('u_masspm')) ? true : false,

'U_FIND_USERNAME' => append_sid('memberlist', "mode=searchuser&amp;form=postform&amp;field=username_list&amp;select_single=$select_single"),

));

}

if (($action == 'reply' || $action == 'quote' || $action == 'quotepost') && !sizeof($address_list) && !$refresh && !$submit && !$preview)

{

}

else if ($action == 'edit' && !sizeof($address_list) && !$refresh && !$submit && !$preview)

{

$check_value = 0;

}

{

trigger_error('NO_AUTH_GROUP_MESSAGE');

}

redirect(append_sid('ucp', 'i=pm&amp;mode=view&amp;action=view_message&amp;p=' . $msg_id));

}

// Handle User/Group adding/removing

handle_message_list_actions($address_list, $error, $remove_u, $remove_g, $add_to, $add_bcc);

if ((!$config['allow_mass_pm'] || !$auth->acl_get('u_masspm')) && num_recipients($address_list) > 1)

{

}

// Always check if the submitted attachment data is valid and belongs to the user.

'URL_STATUS' => ($url_status) ? $user->lang['URL_IS_ON'] : $user->lang['URL_IS_OFF'],

'MINI_POST_IMG' => $user->img('icon_post_target', $user->lang['PM']),

'ERROR' => (sizeof($error)) ? implode('<br />', $error) : '',

'S_COMPOSE_PM' => true,

'S_EDIT_POST' => ($action == 'edit'),

}

}

// Add User/Group [TO]

if ($add_to || $add_bcc)

{

$type = ($add_to) ? 'to' : 'bcc';

if (sizeof($group_list))

{

foreach ($group_list as $group_id)

// User ID's to add...

$user_id_ary = array();

// Reveal the correct user_ids

if (sizeof($usernames))

{

}

// Add Friends if specified

$user_id_ary = array_merge($user_id_ary, $friend_list);

foreach ($user_id_ary as $user_id)

}

/**

*/

{

$recipient = array();

foreach ($address_list as $field => $adr_ary)

{

foreach ($adr_ary as $id => $type)

{

{

break 2;

}

$count++;

}

}

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_edit_time', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_boxes', '4');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('pm_max_msgs', '50');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page', '10');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('print_pm', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('queue_interval', '600');

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_hideonline', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_ignoreflood', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_masspm', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_attach', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_bbcode', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_pm_delete', 1);

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin', 'admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

# -- Groups

# -- User -> Group

INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (1, 1, 0, 0);

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 6, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_viewonline', 'u_chggrp', 'u_chgname', 'u_ignoreflood', 'u_pm_flash', 'u_pm_forward');

# Limited Features (u_)

# No Private Messages (u_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 8, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option IN ('u_', 'u_chgavatar', 'u_chgcensors', 'u_chgemail', 'u_chgpasswd', 'u_download', 'u_hideonline', 'u_sig', 'u_viewprofile');

# No Avatar (u_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_attach', 'u_chgavatar', 'u_viewonline', 'u_chggrp', 'u_chgname', 'u_ignoreflood', 'u_pm_attach', 'u_pm_emailpm', 'u_pm_flash', 'u_savedrafts', 'u_search', 'u_sendemail', 'u_sendim');

# Full Moderator (m_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 10, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%';

'ALLOW_FORWARD_PM' => 'Allow forwarding of private messages',

'ALLOW_IMG_PM' => 'Allow use of <code>[IMG]</code> BBCode tag',

'ALLOW_MASS_PM' => 'Allow sending of private messages to multiple users and groups',

'ALLOW_PRINT_PM' => 'Allow print view in private messaging',

'ALLOW_QUOTE_PM' => 'Allow quotes in private messages',

'ALLOW_SIG_PM' => 'Allow signature in private messages',

'HOLD_NEW_MESSAGES' => 'Hold new messages',

'PM_EDIT_TIME' => 'Limit editing time',

'PM_EDIT_TIME_EXPLAIN' => 'Limits the time available to edit a private message not already delivered. Setting the value to 0 disables this behaviour.',

));

// Post Settings

'GROUP_NAME_TAKEN' => 'The group name you entered is already in use, please select an alternative.',

'GROUP_OPEN' => 'Open',

'GROUP_PENDING' => 'Pending members',

'GROUP_PROMOTE' => 'Promote to group leader',

'GROUP_RANK' => 'Group rank',

'GROUP_RECEIVE_PM' => 'Group able to receive private messages',

'acl_u_sig' => array('lang' => 'Can use signature', 'cat' => 'post'),

'acl_u_sendpm' => array('lang' => 'Can send private messages', 'cat' => 'pm'),

'acl_u_readpm' => array('lang' => 'Can read private messages', 'cat' => 'pm'),

'acl_u_pm_edit' => array('lang' => 'Can edit own private messages', 'cat' => 'pm'),

'acl_u_pm_delete' => array('lang' => 'Can remove private messages from own folder', 'cat' => 'pm'),

'TIMEZONE' => 'Timezone',

'TO' => 'To',

'TOO_MANY_REGISTERS' => 'You have exceeded the maximum number of registration attempts for this session. Please try again later.',

'UCP' => 'User Control Panel',

'RANK_IMG' => $rank_img,

'RANK_IMG_SRC' => $rank_img_src,

);

$sql_select = ', ug.group_leader';