</dl>

<p class="submit-buttons">

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

{S_FORM_TOKEN}

</p>

</thead>

<tbody>

<!-- BEGIN legend -->

<td><strong{legend.GROUP_COLOUR}>{legend.GROUP_NAME}</strong></td>

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

</td>

</tr>

<!-- BEGINELSE -->

</tbody>

</table>

<fieldset class="quick">

<select name="g"><option value="0">{L_SELECT_GROUP}</option>{S_GROUP_SELECT_LEGEND}</select>

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

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

</td>

</tr>

<!-- BEGINELSE -->

</tbody>

</table>

<fieldset class="quick">

<select name="g"><option value="0">{L_SELECT_GROUP}</option>{S_GROUP_SELECT_TEAMPAGE}</select>

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

</fieldset>

</form>

<!-- INCLUDE overall_footer.html -->

- @dispatcher

- @controller.resolver

kernel_request_subscriber:

class: phpbb_event_kernel_request_subscriber

arguments:

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

// 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);

}

}

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

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

public function manage_position()

{

$this->tpl_name = 'acp_groups_position';

$this->page_title = 'ACP_GROUPS_POSITION';

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

{

}

else if ($field)

{

}

{

}

$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(

'S_GROUP_SELECT_LEGEND' => $s_group_select_legend,

'S_GROUP_SELECT_TEAMPAGE' => $s_group_select_teampage,

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

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

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

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

*/

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)

{

$current_legend = $legend->get_group_value($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

$legend->delete_group($group_id, true);

}

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

$legend->delete_group($group_id);

unset($legend);

$teampage->delete_group($group_id);

unset($teampage);

/**

*

* @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;

/**

*/

/**

*/

/**

* URI for the adm_back_link when there was an error.

/**

* 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)

}

/**

*

*/

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

}

/**

* 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)

{

// 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);

}

}

/**

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

}

}

}

'ext_name' => array('UNIQUE', 'ext_name'),

),

),

),

'add_columns' => array(

PROFILE_FIELDS_TABLE => array(

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

),

set_config('use_system_cron', 0);

}

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

$db->sql_freeresult($result);

if (!$added_groups_teampage)

{

WHERE group_type = ' . GROUP_SPECIAL . "

}

if (!isset($config['legend_sort_groupname']))

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

report_time INTEGER DEFAULT 0 NOT NULL,

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

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

);;

ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;

END;;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id INTEGER 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

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

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

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

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

/*

Table: 'phpbb_topics'

*/

CREATE TABLE [phpbb_topics] (

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))

);

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumblob NOT NULL,

reported_post_text mediumblob NOT NULL,

reported_post_uid varbinary(8) DEFAULT '' NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

);

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

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

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumtext NOT NULL,

reported_post_text mediumtext NOT NULL,

reported_post_uid varchar(8) DEFAULT '' NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_topics'

CREATE TABLE phpbb_topics (

topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,

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)

)

/

report_time number(11) DEFAULT '0' NOT NULL,

report_text clob DEFAULT '' ,

reported_post_text clob DEFAULT '' ,

reported_post_uid varchar2(8) DEFAULT '' ,

CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id)

)

/

/*

Table: 'phpbb_topics'

*/

CREATE TABLE phpbb_topics (

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)

);

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

report_text TEXT DEFAULT '' NOT NULL,

reported_post_text TEXT DEFAULT '' NOT NULL,

reported_post_uid varchar(8) DEFAULT '' NOT NULL,

PRIMARY KEY (report_id)

);

CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles (style_name);

/*

Table: 'phpbb_topics'

*/

CREATE SEQUENCE phpbb_topics_seq;

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

report_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_text mediumtext(16777215) NOT NULL DEFAULT '',

reported_post_text mediumtext(16777215) NOT NULL DEFAULT '',

);

CREATE INDEX phpbb_reports_post_id ON phpbb_reports (post_id);

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 ,

$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.',

'COPY_PERMISSIONS' => 'Copy permissions from',

'COPY_PERMISSIONS_EXPLAIN' => 'Once created, the group will have the same permissions as the one you select here.',

'CREATE_GROUP' => 'Create new group',

'GROUPS_NO_MEMBERS' => 'This group has no members',

'GROUPS_NO_MODS' => 'No group leaders defined',

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

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

<dataset>

<table name="phpbb_groups">

<column>group_id</column>

<column>group_legend</column>

<column>group_desc</column>

<row>

<value>1</value>

<value>0</value>

<value></value>

</row>

<row>

<value>2</value>

<value>1</value>

<value></value>

</row>

<row>

<value>3</value>

<value>2</value>

<value></value>

</row>

</table>