</div>

<!-- ENDIF -->

<fieldset>

<legend>{L_GROUP_DETAILS}</legend>

<legend>{L_GROUP_AVATAR}</legend>

<dl>

<dt><label>{L_CURRENT_IMAGE}{L_COLON}</label><br /><span>{L_AVATAR_EXPLAIN}</span></dt>

</dl>

</fieldset>

<fieldset class="submit-buttons">

</fieldset>

</form>

<!-- ELSEIF S_LIST -->

<a href="{U_BACK}" style="float: {S_CONTENT_FLOW_END};">&laquo; {L_BACK}</a>

</dl>

<p class="submit-buttons">

<input type="hidden" name="action" value="set_config_legend" />

{S_FORM_TOKEN}

</p>

</thead>

<tbody>

<!-- BEGIN legend -->

<td style="text-align: center;">{legend.GROUP_TYPE}</td>

<td style="vertical-align: top; width: 100px; text-align: right; white-space: nowrap;">

<!-- IF legend.S_FIRST_ROW && not legend.S_LAST_ROW -->

<!-- ELSEIF not legend.S_FIRST_ROW && not legend.S_LAST_ROW -->

<!-- ELSEIF legend.S_LAST_ROW && not legend.S_FIRST_ROW -->

<!-- ELSE -->

<!-- ENDIF -->

<a href="{legend.U_DELETE}">{ICON_DELETE}</a>

</td>

</tbody>

</table>

<fieldset class="quick">

<input class="button2" type="submit" name="submit" value="{L_ADD}" />

<input type="hidden" name="action" value="add" />

{S_FORM_TOKEN}

<fieldset>

<legend>{L_TEAMPAGE_SETTINGS}</legend>

<dl>

<dd>

<label><input type="radio" name="teampage_memberships" class="radio" value="0"<!-- IF DISPLAY_MEMBERSHIPS == 0 --> checked="checked"<!-- ENDIF --> /> {L_TEAMPAGE_DISP_FIRST}</label><br />

<label><input type="radio" name="teampage_memberships" class="radio" value="1"<!-- IF DISPLAY_MEMBERSHIPS == 1 --> checked="checked"<!-- ENDIF --> /> {L_TEAMPAGE_DISP_DEFAULT}</label><br />

</dl>

<p class="submit-buttons">

<input type="hidden" name="action" value="set_config_teampage" />

{S_FORM_TOKEN}

</p>

<p>{L_TEAMPAGE_EXPLAIN}</p>

<table cellspacing="1">

<col class="col1" /><col class="col2" /><col class="col2" />

<thead>

</thead>

<tbody>

<!-- BEGIN teampage -->

<td style="vertical-align: top; width: 100px; text-align: right; white-space: nowrap;">

<!-- IF teampage.S_FIRST_ROW && not teampage.S_LAST_ROW -->

<!-- ELSEIF not teampage.S_FIRST_ROW && not teampage.S_LAST_ROW -->

<!-- ELSEIF teampage.S_LAST_ROW && not teampage.S_FIRST_ROW -->

<!-- ELSE -->

<!-- ENDIF -->

<a href="{teampage.U_DELETE}">{ICON_DELETE}</a>

</td>

</tbody>

</table>

<fieldset class="quick">

<input class="button2" type="submit" name="submit" value="{L_ADD}" />

<input type="hidden" name="action" value="add" />

{S_FORM_TOKEN}

</fieldset>

</form>

<!-- INCLUDE overall_footer.html -->

<fieldset>

<legend>{L_ACP_USER_AVATAR}</legend>

<dl>

</dl>

<dl>

</dl>

</fieldset>

<fieldset class="quick">

</fieldset>

</form>

require($phpbb_root_path . 'includes/functions.' . $phpEx);

require($phpbb_root_path . 'includes/functions_content.' . $phpEx);

require($phpbb_root_path . 'includes/functions_container.' . $phpEx);

require($phpbb_root_path . 'includes/constants.' . $phpEx);

require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

- { resource: cron_tasks.yml }

- { resource: notifications.yml }

- { resource: migrator.yml }

services:

auth:

class: phpbb_auth

cache:

class: phpbb_cache_service

arguments:

- .%core.php_ext%

- _ext_finder

http_kernel:

class: Symfony\Component\HttpKernel\HttpKernel

arguments:

'group_desc_uid' => array('VCHAR:8', ''),

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

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

'group_avatar_width' => array('USINT', 0),

'group_avatar_height' => array('USINT', 0),

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

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

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

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

),

'PRIMARY_KEY' => 'group_id',

'KEYS' => array(

),

);

$schema_data['phpbb_topics'] = array(

'COLUMNS' => array(

'topic_id' => array('UINT', NULL, 'auto_increment'),

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

'user_options' => array('UINT:11', 230271),

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

'user_avatar_width' => array('USINT', 0),

'user_avatar_height' => array('USINT', 0),

'user_sig' => array('MTEXT_UNI', ''),

// worst-case default

$browser = strtolower($request->header('User-Agent', 'msie 6.0'));

$filename = request_var('avatar', '');

$avatar_group = false;

$exit = false;

{

global $db, $user, $auth, $template;

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/board');

break;

case 'avatar':

$display_vars = array(

'title' => 'ACP_AVATAR_SETTINGS',

'vars' => array(

'avatar_max_height' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => false, 'method' => false, 'explain' => false),

'allow_avatar' => array('lang' => 'ALLOW_AVATARS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'avatar_min' => array('lang' => 'MIN_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

'avatar_max' => array('lang' => 'MAX_AVATAR_SIZE', 'validate' => 'int:0', 'type' => 'dimension:3:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

)

);

break;

case 'message':

{

global $config, $db, $user, $auth, $template, $cache;

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $file_uploads;

$user->add_lang('acp/groups');

$this->tpl_name = 'acp_groups';

// Clear some vars

$group_row = array();

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

if ($group_id)

{

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

$group_row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$error = array();

$user->add_lang('ucp');

// Did we submit?

if ($update)

$allow_desc_urls = request_var('desc_parse_urls', false);

$allow_desc_smilies = request_var('desc_parse_smilies', false);

$submit_ary = array(

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

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

$submit_ary['founder_manage'] = isset($_REQUEST['group_founder_manage']) ? 1 : 0;

}

{

{

{

}

}

{

{

}

}

}

'rank' => 'int',

'colour' => 'string',

'avatar' => 'string',

'avatar_width' => 'int',

'avatar_height' => 'int',

'receive_pm' => 'int',

}

}

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

trigger_error($user->lang[$message] . adm_back_link($this->u_action));

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

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

}

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

switch ($back_link)

'S_ADD_GROUP' => ($action == 'add') ? true : false,

'S_GROUP_PERM' => ($action == 'add' && $auth->acl_get('a_authgroups') && $auth->acl_gets('a_aauth', 'a_fauth', 'a_mauth', 'a_uauth')) ? true : false,

'S_INCLUDE_SWATCH' => true,

'S_ERROR' => (sizeof($error)) ? true : false,

'S_SPECIAL_GROUP' => ($group_type == GROUP_SPECIAL) ? true : false,

'S_USER_FOUNDER' => ($user->data['user_type'] == USER_FOUNDER) ? true : false,

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

'GROUP_NAME' => ($group_type == GROUP_SPECIAL) ? $user->lang['G_' . $group_name] : $group_name,

'S_RANK_OPTIONS' => $rank_options,

'S_GROUP_OPTIONS' => group_select_options(false, false, (($user->data['user_type'] == USER_FOUNDER) ? false : 0)),

'AVATAR_MAX_FILESIZE' => $config['avatar_filesize'],

'AVATAR_WIDTH' => (isset($group_row['group_avatar_width'])) ? $group_row['group_avatar_width'] : '',

'AVATAR_HEIGHT' => (isset($group_row['group_avatar_height'])) ? $group_row['group_avatar_height'] : '',

public function manage_position()

{

$this->tpl_name = 'acp_groups_position';

$this->page_title = 'ACP_GROUPS_POSITION';

if ($field && !in_array($field, array('legend', 'teampage')))

{

// Invalid mode

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

}

{

}

{

}

$sql = 'SELECT group_id, group_name, group_colour, group_type, group_legend

FROM ' . GROUPS_TABLE . '

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

$s_group_select_legend = '';

if ($row['group_legend'])

{

$template->assign_block_vars('legend', array(

));

}

else

{

}

}

$db->sql_freeresult($result);

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

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

{

{

));

}

else

{

}

}

$db->sql_freeresult($result);

$template->assign_vars(array(

'DISPLAY_FORUMS' => ($config['teampage_forums']) ? true : false,

'DISPLAY_MEMBERSHIPS' => $config['teampage_memberships'],

'LEGEND_SORT_GROUPNAME' => ($config['legend_sort_groupname']) ? true : false,

if (!class_exists($info_class))

{

{

include($directory . $module . '.' . $phpEx);

}

}

// Get module title tag

global $config, $db, $user, $auth, $template, $cache;

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $file_uploads;

global $phpbb_dispatcher, $request;

$user->add_lang(array('posting', 'ucp', 'acp/users'));

$this->tpl_name = 'acp_users';

$sql_ary = array(

'user_avatar' => '',

'user_avatar_width' => 0,

'user_avatar_height' => 0,

);

$db->sql_query($sql);

// Delete old avatar if present

{

}

add_log('admin', 'LOG_USER_DEL_AVATAR', $user_row['username']);

case 'avatar':

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

{

{

trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action . '&amp;u=' . $user_id), E_USER_WARNING);

}

}

$template->assign_vars(array(

));

break;

define('STYLES_THEME_TABLE', $table_prefix . 'styles_theme');

define('STYLES_IMAGESET_TABLE', $table_prefix . 'styles_imageset');

define('STYLES_IMAGESET_DATA_TABLE',$table_prefix . 'styles_imageset_data');

define('TOPICS_TABLE', $table_prefix . 'topics');

define('TOPICS_POSTED_TABLE', $table_prefix . 'topics_posted');

define('TOPICS_TRACK_TABLE', $table_prefix . 'topics_track');

}

}

return true;

}

$state['migration_data_done'] = ($result === true) ? false : true;

}

}

else

{

* @param array $state

* @return null

*/

{

$migration_row = $state;

$migration_row['migration_depends_on'] = serialize($state['migration_depends_on']);

'migration_start_time' => time(),

'migration_end_time' => time(),

);

}

}

}

/**

* Get user avatar

*

* @param string $alt Optional language string for alt tag within image, can be a language key or text

* @param bool $ignore_config Ignores the config-setting, to be still able to view the avatar in the UCP

*

*/

{

{

return '';

}

{

}

}

/**

avatar_remove_db($row[$mode . '_avatar']);

}

$filename = get_avatar_filename($row[$mode . '_avatar']);

if (file_exists($phpbb_root_path . $config['avatar_path'] . '/' . $filename))

{

@unlink($phpbb_root_path . $config['avatar_path'] . '/' . $filename);

}

/**

* Generates avatar filename from the database entry

*/

function get_avatar_filename($avatar_entry)

}

/**

* Returns an explanation string with maximum avatar settings

*

* @return string

*/

function group_create(&$group_id, $type, $name, $desc, $group_attributes, $allow_desc_bbcode = false, $allow_desc_urls = false, $allow_desc_smilies = false)

{

$error = array();

$error[] = $user->lang['GROUP_ERR_TYPE'];

}

if (!sizeof($error))

{

if ($group_id)

{

}

if (!empty($group_attributes['group_legend']))

{

{

// Old group currently not in the legend or new group, add at the end.

$group_attributes['group_legend'] = 1 + $legend->get_group_count();

$group_attributes['group_legend'] = $current_legend;

}

}

{

// Group is removed from the legend

{

}

{

}

}

else

{

}

// Unset the objects, we don't need them anymore.

unset($legend);

$user_ary = array();

$sql_ary = array(

$db->sql_query($sql);

}

if (!$group_id)

{

$group_id = $db->sql_nextid();

}

}

// Set user attributes

$sql_ary = array();

if (sizeof($group_attributes))

*/

function group_delete($group_id, $group_name = false)

{

if (!$group_name)

{

while ($start);

// Delete group from legend and teampage

// Delete group

$sql = 'DELETE FROM ' . GROUPS_TABLE . "

/**

*

* @package phpBB3

* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

*

*/

}

/**

*

* If the value is 0 (self::GROUP_DISABLED) the group is not displayed.

* @package phpBB3

*/

{

/**

* Group is not displayed

const GROUP_DISABLED = 0;

/**

*/

/**

*/

/**

* Constructor

*/

{

$this->db = $db;

}

/**

*/

public function get_group_value($group_id)

{

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

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

$this->db->sql_freeresult($result);

if ($current_value === false)

{

// Group not found.

}

return (int) $current_value;

}

/**

*

*/

public function get_group_count()

{

FROM ' . GROUPS_TABLE . '

$result = $this->db->sql_query_limit($sql, 1);

$this->db->sql_freeresult($result);

return $group_count;

}

/**

*

*/

public function add_group($group_id)

{

$next_value = 1 + $this->get_group_count();

$sql = 'UPDATE ' . GROUPS_TABLE . '

AND group_id = ' . (int) $group_id;

$this->db->sql_query($sql);

}

}

/**

* Deletes a group by setting the field to self::GROUP_DISABLED and closing the gap in the list.

*

*/

public function delete_group($group_id, $skip_group = false)

{

$this->db->sql_transaction('begin');

$sql = 'UPDATE ' . GROUPS_TABLE . '

$this->db->sql_query($sql);

if (!$skip_group)

{

$sql = 'UPDATE ' . GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

$this->db->sql_query($sql);

}

$this->db->sql_transaction('commit');

}

}

/**

* Moves a group up by group_id

*

*/

public function move_up($group_id)

{

}

/**

* Moves a group down by group_id

*

*/

public function move_down($group_id)

{

}

/**

* Moves a group up/down

*

*/

public function move($group_id, $delta)

{

{

}

$move_up = ($delta > 0) ? true : false;

// First we move all groups between our current value and the target value up/down 1,

// so we have a gap for our group to move.

$sql = 'UPDATE ' . GROUPS_TABLE . '

$this->db->sql_query($sql);

// Because there might be fewer groups above/below the group than we wanted to move,

// And now finally, when we moved some other groups and built a gap,

// we can move the desired group to it.

$sql = 'UPDATE ' . GROUPS_TABLE . '

WHERE group_id = ' . (int) $group_id;

$this->db->sql_query($sql);

}

$this->db->sql_transaction('commit');

}

}

/**

* Get group type language var

*

* @param int $group_type group_type from the groups-table

*/

static public function group_type_language($group_type)

{

return 'GROUP_OPEN';

}

}

}

}

// Generate the appropriate user information for the user we are looking at

{

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

$rank_title = $rank_img = '';

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_DATE'], 'c' => $user->lang['SORT_IP'], 'd' => $user->lang['SORT_ACTION']);

$message = smiley_text($message);

// Generate the appropriate user information for the user we are looking at

{

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

$template->assign_vars(array(

'U_POST_ACTION' => $this->u_action,

}

// Generate the appropriate user information for the user we are looking at

{

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

get_user_rank($user_row['user_rank'], $user_row['user_posts'], $rank_title, $rank_img, $rank_img_src);

// OK, they didn't submit a warning so lets build the page for them to do so

$template->assign_vars(array(

'modes' => array(

'profile_info' => array('title' => 'UCP_PROFILE_PROFILE_INFO', 'auth' => 'acl_u_chgprofileinfo', 'cat' => array('UCP_PROFILE')),

'signature' => array('title' => 'UCP_PROFILE_SIGNATURE', 'auth' => 'acl_u_sig', 'cat' => array('UCP_PROFILE')),

'reg_details' => array('title' => 'UCP_PROFILE_REG_DETAILS', 'auth' => '', 'cat' => array('UCP_PROFILE')),

'autologin_keys'=> array('title' => 'UCP_PROFILE_AUTOLOGIN_KEYS', 'auth' => '', 'cat' => array('UCP_PROFILE')),

),

{

global $config, $phpbb_root_path, $phpEx, $phpbb_admin_path;

global $db, $user, $auth, $cache, $template;

$user->add_lang('groups');

$group_name = $group_row['group_name'];

$group_type = $group_row['group_type'];

$template->assign_vars(array(

'GROUP_NAME' => ($group_type == GROUP_SPECIAL) ? $user->lang['G_' . $group_name] : $group_name,

'GROUP_DESC_DISP' => generate_text_for_display($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_bitfield'], $group_row['group_desc_options']),

'GROUP_TYPE' => $group_row['group_type'],

'AVATAR_WIDTH' => (isset($group_row['group_avatar_width'])) ? $group_row['group_avatar_width'] : '',

'AVATAR_HEIGHT' => (isset($group_row['group_avatar_height'])) ? $group_row['group_avatar_height'] : '',

));

$error = array();

// Did we submit?

if ($update)

'max_recipients'=> request_var('group_max_recipients', 0),

);

{

{

{

}

}

{

{

}

}

}

'rank' => 'int',

'colour' => 'string',

'avatar' => 'string',

'avatar_width' => 'int',

'avatar_height' => 'int',

'receive_pm' => 'int',

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

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

{

}

$template->assign_vars(array(

'S_EDIT' => true,

'S_INCLUDE_SWATCH' => true,

'S_ERROR' => (sizeof($error)) ? true : false,

'S_SPECIAL_GROUP' => ($group_type == GROUP_SPECIAL) ? true : false,

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

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

'S_DESC_SMILIES_CHECKED'=> $group_desc_data['allow_smilies'],

'S_RANK_OPTIONS' => $rank_options,

'GROUP_TYPE_FREE' => GROUP_FREE,

'GROUP_TYPE_OPEN' => GROUP_OPEN,

}

}

{

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

}

get_user_rank($user_row['user_rank'], $user_row['user_posts'], $user_row['rank_title'], $user_row['rank_image'], $user_row['rank_image_src']);

function main($id, $mode)

{

global $request;

$user->add_lang('posting');

break;

case 'avatar':

{

{

}

}

{

}

}

$template->assign_vars(array(

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

'L_AVATAR_EXPLAIN' => phpbb_avatar_explanation_string(),

break;

group_desc_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,

group_display INTEGER DEFAULT 0 NOT NULL,

group_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

group_avatar_width INTEGER DEFAULT 0 NOT NULL,

group_avatar_height INTEGER DEFAULT 0 NOT NULL,

group_rank INTEGER DEFAULT 0 NOT NULL,

group_receive_pm INTEGER DEFAULT 0 NOT NULL,

group_message_limit INTEGER DEFAULT 0 NOT NULL,

group_max_recipients INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_groups ADD PRIMARY KEY (group_id);;

END;;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id INTEGER NOT NULL,

user_allow_massemail INTEGER DEFAULT 1 NOT NULL,

user_options INTEGER DEFAULT 230271 NOT NULL,

user_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_avatar_width INTEGER DEFAULT 0 NOT NULL,

user_avatar_height INTEGER DEFAULT 0 NOT NULL,

user_sig BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

[group_desc_uid] [varchar] (8) DEFAULT ('') NOT NULL ,

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

[group_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,

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

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

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

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

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

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

) ON [PRIMARY]

GO

/*

Table: 'phpbb_topics'

*/

CREATE TABLE [phpbb_topics] (

[user_allow_massemail] [int] DEFAULT (1) NOT NULL ,

[user_options] [int] DEFAULT (230271) NOT NULL ,

[user_avatar] [varchar] (255) DEFAULT ('') NOT NULL ,

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

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

[user_sig] [text] DEFAULT ('') NOT NULL ,

group_desc_uid varbinary(8) DEFAULT '' NOT NULL,

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

group_avatar varbinary(255) DEFAULT '' NOT NULL,

group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

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

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

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

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

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name(255))

);

);

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

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

user_options int(11) UNSIGNED DEFAULT '230271' NOT NULL,

user_avatar varbinary(255) DEFAULT '' NOT NULL,

user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

user_sig mediumblob NOT NULL,

group_desc_uid varchar(8) DEFAULT '' NOT NULL,

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

group_avatar varchar(255) DEFAULT '' NOT NULL,

group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

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

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

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

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

PRIMARY KEY (group_id),

KEY group_legend_name (group_legend, group_name)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

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

user_options int(11) UNSIGNED DEFAULT '230271' NOT NULL,

user_avatar varchar(255) DEFAULT '' NOT NULL,

user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

user_sig mediumtext NOT NULL,

group_desc_uid varchar2(8) DEFAULT '' ,

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

group_avatar varchar2(255) DEFAULT '' ,

group_avatar_width number(4) DEFAULT '0' NOT NULL,

group_avatar_height number(4) DEFAULT '0' NOT NULL,

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

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

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

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

CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id)

)

/

/*

Table: 'phpbb_topics'

*/

CREATE TABLE phpbb_topics (

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

user_options number(11) DEFAULT '230271' NOT NULL,

user_avatar varchar2(255) DEFAULT '' ,

user_avatar_width number(4) DEFAULT '0' NOT NULL,

user_avatar_height number(4) DEFAULT '0' NOT NULL,

user_sig clob DEFAULT '' ,

group_desc_uid varchar(8) DEFAULT '' NOT NULL,

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

group_avatar varchar(255) DEFAULT '' NOT NULL,

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

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

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

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

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

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

PRIMARY KEY (group_id)

);

CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);

/*

Table: 'phpbb_topics'

*/

CREATE SEQUENCE phpbb_topics_seq;

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

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

user_avatar varchar(255) DEFAULT '' NOT NULL,

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

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

user_sig TEXT DEFAULT '' NOT NULL,

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

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

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload', '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);

group_desc_uid varchar(8) NOT NULL DEFAULT '',

group_display INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_avatar varchar(255) NOT NULL DEFAULT '',

group_avatar_width INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_avatar_height INTEGER UNSIGNED NOT NULL DEFAULT '0',

group_rank 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_max_recipients INTEGER UNSIGNED NOT NULL DEFAULT '0',

);

CREATE INDEX phpbb_groups_group_legend_name ON phpbb_groups (group_legend, group_name);

CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id INTEGER PRIMARY KEY NOT NULL ,

user_allow_massemail INTEGER UNSIGNED NOT NULL DEFAULT '1',

user_options INTEGER UNSIGNED NOT NULL DEFAULT '230271',

user_avatar varchar(255) NOT NULL DEFAULT '',

user_avatar_width INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_avatar_height INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_sig mediumtext(16777215) NOT NULL DEFAULT '',

'ALLOW_AVATARS' => 'Enable avatars',

'ALLOW_AVATARS_EXPLAIN' => 'Allow general usage of avatars;<br />If you disable avatars in general or avatars of a certain mode, the disabled avatars will no longer be shown on the board, but users will still be able to download their own avatars in the User Control Panel.',

'ALLOW_LOCAL' => 'Enable gallery avatars',

'ALLOW_REMOTE' => 'Enable remote avatars',

'ALLOW_REMOTE_EXPLAIN' => 'Avatars linked to from another website.',

$lang = array_merge($lang, array(

'ACP_GROUPS_MANAGE_EXPLAIN' => 'From this panel you can administer all your usergroups. You can delete, create and edit existing groups. Furthermore, you may choose group leaders, toggle open/hidden/closed group status and set the group name and description.',

'ADD_USERS' => 'Add users',

'ADD_USERS_EXPLAIN' => 'Here you can add new users to the group. You may select whether this group becomes the new default for the selected users. Additionally you can define them as group leaders. Please enter each username on a separate line.',

'GROUP_APPROVED' => 'Approved members',

'GROUP_AVATAR' => 'Group avatar',

'GROUP_AVATAR_EXPLAIN' => 'This image will be displayed in the Group Control Panel.',

'GROUP_CLOSED' => 'Closed',

'GROUP_COLOR' => 'Group colour',

'GROUP_COLOR_EXPLAIN' => 'Defines the colour members’ usernames will appear in, leave blank for user default.',

'SPECIAL_GROUPS' => 'Pre-defined groups',

'SPECIAL_GROUPS_EXPLAIN' => 'Pre-defined groups are special groups, they cannot be deleted or directly modified. However you can still add users and alter basic settings.',

'TEAMPAGE_DISP_ALL' => 'All memberships',

'TEAMPAGE_DISP_DEFAULT' => 'User’s default group only',

'TEAMPAGE_DISP_FIRST' => 'First membership only',

'LOGOUT_USER' => 'Logout [ %s ]',

'LOG_ME_IN' => 'Remember me',

'MARK' => 'Mark',

'MARK_ALL' => 'Mark all',

'MARK_FORUMS_READ' => 'Mark forums read',

'NO_AUTH_ADMIN' => 'Access to the Administration Control Panel is not allowed as you do not have administrative permissions.',

'NO_AUTH_ADMIN_USER_DIFFER' => 'You are not able to re-authenticate as a different user.',

'NO_AUTH_OPERATION' => 'You do not have the necessary permissions to complete this operation.',

'NO_CONNECT_TO_SMTP_HOST' => 'Could not connect to smtp host : %1$s : %2$s',

'NO_BIRTHDAYS' => 'No birthdays today',

'NO_EMAIL_MESSAGE' => 'Email message was blank.',

'ATTACHMENT_DELETED' => 'Attachment successfully deleted.',

'AUTOLOGIN_SESSION_KEYS_DELETED'=> 'The selected "Remember Me" login keys were successfully deleted.',

'AVATAR_CATEGORY' => 'Category',

'AVATAR_EXPLAIN' => 'Maximum dimensions; width: %1$s, height: %2$s, file size: %3$.2f KiB.',

'AVATAR_FEATURES_DISABLED' => 'The avatar functionality is currently disabled.',

'AVATAR_GALLERY' => 'Local gallery',

'AVATAR_GENERAL_UPLOAD_ERROR' => 'Could not upload avatar to %s.',

'AVATAR_NOT_ALLOWED' => 'Your avatar cannot be displayed because avatars have been disallowed.',

'AVATAR_PAGE' => 'Page',

'AVATAR_TYPE_NOT_ALLOWED' => 'Your current avatar cannot be displayed because its type has been disallowed.',

'BACK_TO_DRAFTS' => 'Back to saved drafts',

'GLOBAL_ANNOUNCEMENT' => 'Global announcement',

'HIDE_ONLINE' => 'Hide my online status',

'HIDE_ONLINE_EXPLAIN' => 'Changing this setting won’t become effective until your next visit to the board.',

'HOLD_NEW_MESSAGES' => 'Do not accept new messages (New messages will be held back until enough space is available)',

$page_title = $user->lang['THE_TEAM'];

$template_html = 'memberlist_leaders.html';

$sql_ary = array(

'FROM' => array(GROUPS_TABLE => 'g'),

'LEFT_JOIN' => array(

array(

'FROM' => array(USER_GROUP_TABLE => 'ug'),

'ON' => 'ug.group_id = g.group_id AND ug.user_pending = 0 AND ug.user_id = ' . (int) $user->data['user_id'],

),

),

);

$result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));

$row['u_group'] = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&amp;g=' . $row['group_id']);

}

{

// Only put groups into the array we want to display.

// We are fetching all groups, to ensure we got all data for default groups.

}

}

{

{

$template->assign_block_vars('group', array(

'GROUP_NAME' => $group_data['group_name'],

'GROUP_COLOR' => $group_data['group_colour'],

if (isset($user_ary[$user_id]))

{

$row = $user_ary[$user_id];

{

// Display users in their primary group, instead of the first group, when it is displayed on the teampage.

continue;

$member['user_sig'] = smiley_text($member['user_sig']);

}

// We need to check if the modules 'zebra' ('friends' & 'foes' mode), 'notes' ('user_notes' mode) and 'warn' ('warn_user' mode) are accessible to decide if we can display appropriate links

$zebra_enabled = $friends_enabled = $foes_enabled = $user_notes_enabled = $warn_user_enabled = false;

break;

}

// ... same for group rank

$rank_title = $rank_img = $rank_img_src = '';

'A_USERNAME' => addslashes(get_username_string('username', $user_id, $username, $data['user_colour'])),

'ONLINE_IMG' => (!$config['load_onlinetrack']) ? '' : (($online) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),

'S_ONLINE' => ($config['load_onlinetrack'] && $online) ? true : false,

'RANK_IMG' => $rank_img,

<div class="panel">

<div class="inner">

<!-- IF not S_AVATARS_ENABLED -->

<fieldset>

<!-- IF ERROR --><p class="error">{ERROR}</p><!-- ENDIF -->

<dl>

</dl>

<dl>

</dl>

</fieldset>

</div>

</div>

</div>

<fieldset class="submit-buttons">

{S_HIDDEN_FIELDS}

<input type="submit" name="update" value="{L_SUBMIT}" class="button1" />

{S_FORM_TOKEN}

</fieldset>

<!-- INCLUDE ucp_avatar_options.html -->

</form>

<!-- INCLUDE ucp_footer.html -->

</tr>

<tr>

<td class="row1" width="35%"><label>{L_CURRENT_IMAGE}{L_COLON}</label><br /><span>{L_AVATAR_EXPLAIN}</span></td>

</tr>

<tr>

<input class="btnmain" type="reset" id="reset" name="reset" value="{L_RESET}" /></td>

</tr>

</table>

<!-- ELSEIF S_LIST -->

<h1>{L_GROUP_MEMBERS}</h1>

<tr>

<td class="row1" width="35%"><b class="genmed">{L_CURRENT_IMAGE}{L_COLON} </b><br /><span class="gensmall">{L_AVATAR_EXPLAIN}</span></td>

<td class="row2" align="center"><br />

<!-- ELSE --><img src="{T_THEME_PATH}/images/no_avatar.gif" alt="" />

<!-- ENDIF --></td>

</tr>

<td class="row3" colspan="2" align="center">{L_AVATAR_FEATURES_DISABLED}</td>

</tr>

<!-- ENDIF -->

</tr>

<tr>

<td class="cat" colspan="2" align="center">{S_HIDDEN_FIELDS}<input class="btnmain" type="submit" name="submit" value="{L_SUBMIT}" />&nbsp;&nbsp;<!-- IF S_IN_AVATAR_GALLERY --><input class="btnlite" type="submit" name="cancel" value="{L_CANCEL}" /><!-- ELSE --><input class="btnlite" type="reset" value="{L_RESET}" name="reset" /><!-- ENDIF --></td>

</tr>

</table>

<!-- INCLUDE ucp_footer.html -->

'sig_bbcode_bitfield' => '',

'online' => false,

'rank_title' => '',

'rank_image' => '',

'rank_image_src' => '',

'viewonline' => $row['user_allow_viewonline'],

'allow_pm' => $row['user_allow_pm'],

'age' => '',

'rank_title' => '',