$tpl = '';

$name = 'config[' . $config_key . ']';

switch ($tpl_type[0])

{

case 'text':

break;

case 'select':

case 'custom':

$return = '';

}

else

{

$args = array($new[$config_key], $key);

}

$return = call_user_func_array($call, $args);

{

$tpl = '<select id="' . $key . '" name="' . $name . '">' . $return . '</select>';

}

'forum_last_poster_name'=> array('VCHAR_UNI', ''),

'forum_last_poster_colour'=> array('VCHAR:6', ''),

'forum_flags' => array('TINT:4', 32),

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

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

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

'forum_last_poster_name'=> array('VCHAR_UNI', ''),

'forum_last_poster_colour'=> array('VCHAR:6', ''),

'forum_flags' => array('TINT:4', 32),

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

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

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

break;

case 'news':

{

return false;

}

global $auth, $db, $config, $phpbb_root_path, $phpEx, $user;

// Which forums should not be searched ?

// Exclude forums the user is not able to read

$this->excluded_forums_ary = array_keys($auth->acl_getf('!f_read', true));

{

global $db, $config;

if (!sizeof($in_fid_ary))

{

'WHERE' => $db->sql_in_set('t.forum_id', $in_fid_ary) . '

AND f.forum_id = t.forum_id

AND p.post_id = t.topic_first_post_id

'ORDER_BY' => 't.topic_time DESC',

);

'feed_overall_topics_limit' => array('lang' => 'ACP_FEED_OVERALL_TOPIC_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => false),

'feed_forum' => array('lang' => 'ACP_FEED_FORUM', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

'feed_topic' => array('lang' => 'ACP_FEED_TOPIC', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

)

);

break;

// We go through the display_vars to make sure no one is trying to set variables he/she is not allowed to...

foreach ($display_vars['vars'] as $config_name => $null)

{

{

continue;

}

{

continue;

}

$this->new_config[$config_name] = $config_value = $cfg_array[$config_name];

if ($config_name == 'email_function_name')

}

}

if ($mode == 'auth')

{

// Retrieve a list of auth plugins and check their config values

{

global $user, $config;

// Build forum options

foreach ($forum_list as $f_id => $f_row)

{

$s_forum_options .= '<option value="' . $f_id . '"' . (($f_row['selected']) ? ' selected="selected"' : '') . (($f_row['disabled']) ? ' disabled="disabled" class="disabled-option"' : '') . '>' . $f_row['padding'] . $f_row['forum_name'] . '</option>';

}

return $s_forum_options;

}

{

global $user, $config;

// Build forum options

foreach ($forum_list as $f_id => $f_row)

{

$s_forum_options .= '<option value="' . $f_id . '"' . (($f_row['selected']) ? ' selected="selected"' : '') . (($f_row['disabled']) ? ' disabled="disabled" class="disabled-option"' : '') . '>' . $f_row['padding'] . $f_row['forum_name'] . '</option>';

}

return $s_forum_options;

}

}

?> \ No newline at end of file

define('FORUM_FLAG_POST_REVIEW', 32);

define('FORUM_FLAG_QUICK_REPLY', 64);

// Optional text flags

define('OPTION_FLAG_BBCODE', 1);

define('OPTION_FLAG_SMILIES', 2);

}

/**

* Run more than one insert statement.

*

* @param string $table table name to run the statements on

return $data;

}

/**

* return sql error array

* @access private

return $data;

}

/**

* return sql error array

* @access private

$l_notify = '<p>Please notify the board administrator or webmaster: <a href="mailto:' . $config['board_contact'] . '">' . $config['board_contact'] . '</a></p>';

}

}

if (defined('DEBUG') || defined('IN_CRON') || defined('IMAGE_OUTPUT'))

{

// let's avoid loops

);

}

/**

* Generate page header

* }

* </code>

*/

if ($forum_id)

{

$item_id = max($forum_id, 0);

{

$item_id = 0;

}

// workaround legacy code

$item = 'forum';

$online_users = obtain_users_online($item_id, $item);

$forum_id = request_var('f', 0);

$topic_id = request_var('t', 0);

// The following assigns all _common_ variables that may be used at any point in a template.

$template->assign_vars(array(

'SITENAME' => $config['sitename'],

'S_TOPIC_ID' => $topic_id,

'S_ENABLE_FEEDS' => ($config['feed_enable']) ? true : false,

'S_ENABLE_FEEDS_FORUMS' => ($config['feed_overall_forums']) ? true : false,

'S_ENABLE_FEEDS_TOPICS' => ($config['feed_overall_topics']) ? true : false,

'T_THEME_PATH' => "{$phpbb_root_path}styles/" . $user->theme['theme_path'] . '/theme',

'T_TEMPLATE_PATH' => "{$phpbb_root_path}styles/" . $user->theme['template_path'] . '/template',

$acl = ($ignore_acl) ? '' : (($only_acl_post) ? 'f_post' : array('f_list', 'a_forum', 'a_forumadd', 'a_forumdel'));

// This query is identical to the jumpbox one

FROM ' . FORUMS_TABLE . '

ORDER BY left_id ASC';

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

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set('topic_id', $topic_id_ary);

$db->sql_query($sql);

break;

}

$db->sql_transaction('commit');

break;

case 'topic_approved':

$db->sql_transaction('begin');

switch ($db->sql_layer)

{

$db->sql_query($sql);

break;

}

$db->sql_transaction('commit');

break;

case 'post_reported':

$post_ids = $post_reported = array();

$db->sql_transaction('begin');

$sql = 'SELECT p.post_id, p.post_reported

FROM ' . POSTS_TABLE . " p

$where_sql

WHERE ' . $db->sql_in_set('post_id', $post_ids);

$db->sql_query($sql);

}

$db->sql_transaction('commit');

break;

$topic_ids = $topic_reported = array();

$db->sql_transaction('begin');

$sql = 'SELECT DISTINCT(t.topic_id)

FROM ' . POSTS_TABLE . " t

$where_sql_and t.post_reported = 1";

WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

$db->sql_query($sql);

}

$db->sql_transaction('commit');

break;

$post_ids = $post_attachment = array();

$db->sql_transaction('begin');

$sql = 'SELECT p.post_id, p.post_attachment

FROM ' . POSTS_TABLE . " p

$where_sql

WHERE ' . $db->sql_in_set('post_id', $post_ids);

$db->sql_query($sql);

}

$db->sql_transaction('commit');

break;

WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

$db->sql_query($sql);

}

$db->sql_transaction('commit');

break;

case 'forum':

$db->sql_transaction('begin');

// 1: Get the list of all forums

$sql = 'SELECT f.*

FROM ' . FORUMS_TABLE . " f

$db->sql_query($sql);

}

}

$db->sql_transaction('commit');

break;

$topic_data = $post_ids = $approved_unapproved_ids = $resync_forums = $delete_topics = $delete_posts = $moved_topics = array();

$db->sql_transaction('begin');

$sql = 'SELECT t.topic_id, t.forum_id, t.topic_moved_id, t.topic_approved, ' . (($sync_extra) ? 't.topic_attachment, t.topic_reported, ' : '') . 't.topic_poster, t.topic_time, t.topic_replies, t.topic_replies_real, t.topic_first_post_id, t.topic_first_poster_name, t.topic_first_poster_colour, t.topic_last_post_id, t.topic_last_post_subject, t.topic_last_poster_id, t.topic_last_poster_name, t.topic_last_poster_colour, t.topic_last_post_time

FROM ' . TOPICS_TABLE . " t

$where_sql";

unset($topic_data);

$db->sql_transaction('commit');

// if some topics have been resync'ed then resync parent forums

// except when we're only syncing a range, we don't want to sync forums during

// batch processing.

PROFILE_FIELDS_TABLE => array(

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

),

),

'change_columns' => array(

USERS_TABLE => array(

set_config('feed_forum', '1');

set_config('feed_topic', '1');

set_config('feed_item_statistics', '1');

// Entries for smiley pagination

set_config('smilies_per_page', '50');

forum_last_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

forum_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,

forum_flags INTEGER DEFAULT 32 NOT NULL,

display_subforum_list INTEGER DEFAULT 1 NOT NULL,

display_on_index INTEGER DEFAULT 1 NOT NULL,

enable_indexing INTEGER DEFAULT 1 NOT NULL,

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

[forum_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,

[forum_flags] [int] DEFAULT (32) NOT NULL ,

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

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

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

forum_last_poster_name blob NOT NULL,

forum_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,

forum_flags tinyint(4) DEFAULT '32' NOT NULL,

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

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

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

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

forum_flags tinyint(4) DEFAULT '32' NOT NULL,

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

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

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

forum_last_poster_name varchar2(765) DEFAULT '' ,

forum_last_poster_colour varchar2(6) DEFAULT '' ,

forum_flags number(4) DEFAULT '32' NOT NULL,

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

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

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

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

forum_flags INT2 DEFAULT '32' NOT NULL,

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_overall_topics_limit', '15');

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval', '15');

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('form_token_lifetime', '7200');

forum_last_poster_name varchar(255) NOT NULL DEFAULT '',

forum_last_poster_colour varchar(6) NOT NULL DEFAULT '',

forum_flags tinyint(4) NOT NULL DEFAULT '32',

display_subforum_list INTEGER UNSIGNED NOT NULL DEFAULT '1',

display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1',

enable_indexing INTEGER UNSIGNED NOT NULL DEFAULT '1',

<!-- IF S_ENABLE_FEEDS_NEWS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_NEWS}" href="{U_FEED}?mode=news" /><!-- ENDIF -->

<!-- IF S_ENABLE_FEEDS_FORUMS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_FORUMS}" href="{U_FEED}?mode=forums" /><!-- ENDIF -->

<!-- IF S_ENABLE_FEEDS_TOPICS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_TOPICS}" href="{U_FEED}?mode=topics" /><!-- ENDIF -->

<!-- ENDIF -->

<!--

'S_SINGLE_MODERATOR' => (!empty($moderators[$forum_id]) && sizeof($moderators[$forum_id]) > 1) ? false : true,

'S_IS_LOCKED' => ($forum_data['forum_status'] == ITEM_LOCKED) ? true : false,

'S_VIEWFORUM' => true,

'U_MCP' => ($auth->acl_get('m_', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "f=$forum_id&amp;i=main&amp;mode=forum_view", true, $user->session_id) : '',

'U_POST_NEW_TOPIC' => ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS) ? append_sid("{$phpbb_root_path}posting.$phpEx", 'mode=post&amp;f=' . $forum_id) : '',

'S_DISPLAY_POST_INFO' => ($topic_data['forum_type'] == FORUM_POST && ($auth->acl_get('f_post', $forum_id) || $user->data['user_id'] == ANONYMOUS)) ? true : false,

'S_DISPLAY_REPLY_INFO' => ($topic_data['forum_type'] == FORUM_POST && ($auth->acl_get('f_reply', $forum_id) || $user->data['user_id'] == ANONYMOUS)) ? true : false,

'U_TOPIC' => "{$server_path}viewtopic.$phpEx?f=$forum_id&amp;t=$topic_id",

'U_FORUM' => $server_path,

// Grab all profile fields from users in id cache for later use - similar to the poster cache

$profile_fields_tmp = $cp->generate_profile_fields_template('grab', $id_cache);

// filter out fields not to be displayed on viewtopic. Yes, it's a hack, but this shouldn't break any MODs.

$profile_fields_cache = array();

foreach ($profile_fields_tmp as $profile_user_id => $profile_fields)