<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'] : '',

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)

'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'],

'template_inherits_id' => array('UINT:4', 0),

'template_inherit_path' => array('VCHAR', ''),

),

),

),

);

*/

function change_database_data(&$no_updates, $version)

{

switch ($version)

{

set_config('enable_queue_trigger', '0');

set_config('queue_trigger_posts', '3');

// Not prefilling yet

set_config('dbms_version', '');

{

}

$no_updates = false;

break;

group_sig_chars INTEGER DEFAULT 0 NOT NULL,

group_receive_pm INTEGER DEFAULT 0 NOT NULL,

group_message_limit INTEGER DEFAULT 0 NOT NULL,

group_legend INTEGER DEFAULT 1 NOT NULL

);;

[group_sig_chars] [int] DEFAULT (0) NOT NULL ,

[group_receive_pm] [int] DEFAULT (0) NOT NULL ,

[group_message_limit] [int] DEFAULT (0) NOT NULL ,

[group_legend] [int] DEFAULT (1) NOT NULL

) ON [PRIMARY]

GO

group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name(255))

group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name)

group_sig_chars number(8) DEFAULT '0' NOT NULL,

group_receive_pm number(1) DEFAULT '0' NOT NULL,

group_message_limit number(8) DEFAULT '0' NOT NULL,

group_legend number(1) DEFAULT '1' NOT NULL,

CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id)

)

group_sig_chars INT4 DEFAULT '0' NOT NULL CHECK (group_sig_chars >= 0),

group_receive_pm INT2 DEFAULT '0' NOT NULL CHECK (group_receive_pm >= 0),

group_message_limit INT4 DEFAULT '0' NOT NULL CHECK (group_message_limit >= 0),

group_legend INT2 DEFAULT '1' NOT NULL CHECK (group_legend >= 0),

PRIMARY KEY (group_id)

);

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_%';

group_sig_chars INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_receive_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_message_limit INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_legend INTEGER UNSIGNED NOT NULL DEFAULT '1'

);

'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';