$template->assign_vars(array(

'DEBUG_OUTPUT' => (defined('DEBUG')) ? $debug_output : '',

'S_COPYRIGHT_HTML' => $copyright_html,

'VERSION' => $config['version'])

);

<div id="page-footer">

<!-- IF S_COPYRIGHT_HTML -->

Powered by phpBB {VERSION} &copy; 2006 <a href="http://www.phpbb.com/">phpBB Group</a>

<!-- ENDIF -->

<!-- IF DEBUG_OUTPUT -->

<!-- IF S_COPYRIGHT_HTML -->

<br />Powered by phpBB {VERSION} &copy; 2006 <a href="http://www.phpbb.com/">phpBB Group</a>

<!-- ENDIF -->

<!-- IF DEBUG_OUTPUT -->

'COLUMNS' => array(

'bbcode_id' => array('TINT:3', 0),

'bbcode_tag' => array('VCHAR:16', ''),

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

'bbcode_match' => array('TEXT_UNI', ''),

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

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

$bbcode_tpl = htmlspecialchars_decode(request_var('bbcode_tpl', ''));

break;

}

}

$this->new_config = $config;

$error = array();

// We validate the complete config if whished

$forum_data = $this->get_forum_info($forum_id);

$subforums_id = array();

$subforums = get_forum_branch($forum_id, 'children');

foreach ($subforums as $row)

{

$subforums_id[] = $row['forum_id'];

'FORUM_NAME' => $forum_data['forum_name'],

'S_FORUM_POST' => ($forum_data['forum_type'] == FORUM_POST) ? true : false,

'S_HAS_SUBFORUMS' => ($forum_data['right_id'] - $forum_data['left_id'] > 1) ? true : false,

'S_FORUMS_LIST' => $forums_list,

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

$hidden_data = build_hidden_fields(array(

'file' => $this->language_file,

'dir' => $this->language_directory,

);

$template->assign_vars(array(

'S_UPLOAD' => true,

'NAME' => $method,

'yim' => request_var('yim', $user_row['user_yim']),

'jabber' => request_var('jabber', $user_row['user_jabber']),

'website' => request_var('website', $user_row['user_website']),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

);

if ($user_row['user_birthday'])

{

$enable_bbcode = ($config['allow_sig_bbcode']) ? request_var('enable_bbcode', $this->optionget($user_row, 'bbcode')) : false;

$enable_smilies = ($config['allow_sig_smilies']) ? request_var('enable_smilies', $this->optionget($user_row, 'smilies')) : false;

$enable_urls = request_var('enable_urls', true);

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

if ($submit || $preview)

break;

case 'save':

if (!$word || !$replacement)

{

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

*/

class captcha

{

function execute($code)

{

global $config;

$stats = gd_info();

preg_match('/[\\d.]+/', $stats['GD Version'], $version);

// create the image, stay compat with older versions of GD

if ($gd_version === 2)

$func2 = 'imagecolorclosest';

}

if ($bundled)

{

// set background color

$back = imagecolorallocate($image, mt_rand(224, 255), mt_rand(224, 255), mt_rand(224, 255));

// allocates the 216 websafe color palette to the image

if ($gd_version === 1)

}

}

// fill with noise or grid

if ($config['captcha_gd_noise'])

{

$size = mt_rand(8, 23);

$angle = mt_rand(0, 360);

$x = mt_rand(0, 360);

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

$text = chr(mt_rand(45, 250));

imagettftext($image, $size, $angle, $x, $y, $color, $this->get_font(), $text);

else

{

// generate grid

{

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

}

{

$color = $func2($image, mt_rand(160, 224), mt_rand(160, 224), mt_rand(160, 224));

}

}

$text = strtoupper($code[$i]);

$angle = mt_rand(-30, 30);

$size = mt_rand(20, 40);

$color = $func2($image, mt_rand(0, 127), mt_rand(0, 127), mt_rand(0, 127));

$shadow = $func2($image, mt_rand(127, 254), mt_rand(127, 254), mt_rand(127, 254));

class captcha

{

var $filtered_pngs;

/**

* Define filtered pngs on init

*/

function execute($code)

{

$img_width = 0;

list($usec, $sec) = explode(' ', microtime());

for ($i = 0; $i < $code_len; $i++)

{

$width = mt_rand(0, 4);

$raw_width = $this->filtered_pngs[$char]['width'];

}

}

$image = '';

{

$image .= chr(0);

$image .= $this->randomise(substr($hold_chars[$code{$j}][$i - $offset_y - 1], 1), $char_widths[$j]);

}

{

$image .= chr(mt_rand(140, 255));

}

}

else

{

{

$image .= chr(mt_rand(140, 255));

}

}

unset($hold_chars);

// Output image

header('Content-Type: image/png');

if (!function_exists('htmlspecialchars_decode'))

{

function htmlspecialchars_decode($string, $quote_style = ENT_COMPAT)

{

return strtr($string, array_flip(get_html_translation_table(HTML_SPECIALCHARS, $quote_style)));

/**

* Little helper for the build_hidden_fields function

*/

{

$hidden_fields = '';

if (!is_array($value))

{

$hidden_fields .= '<input type="hidden" name="' . $key . '" value="' . $value . '" />' . "\n";

}

{

foreach ($value as $_key => $_value)

{

}

}

/**

* Build simple hidden fields from array

*/

{

$s_hidden_fields = '';

foreach ($field_ary as $name => $vars)

{

}

return $s_hidden_fields;

@exec('nslookup -type=' . escapeshellarg($type) . ' ' . escapeshellarg($host), $output);

foreach ($output as $line)

{

if (!trim($line))

}

$template->assign_vars(array(

'U_ACP' => ($auth->acl_get('a_') && $user->data['is_registered']) ? append_sid("{$phpbb_root_path}adm/index.$phpEx", '', true, $user->session_id) : '')

);

if ($cron_type)

{

}

}

{

global $db, $config;

$forum_ids = $topic_ids = array();

if (is_array($where_ids))

'posts' => delete_posts($where_type, $where_ids, false, true)

);

FROM ' . TOPICS_TABLE . '

WHERE ' . $db->sql_in_set($where_type, $where_ids);

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

{

$forum_ids[] = $row['forum_id'];

$topic_ids[] = $row['topic_id'];

}

$db->sql_freeresult($result);

sync('topic_reported', $where_type, $where_ids);

}

return $return;

}

return false;

}

$post_ids = $topic_ids = $forum_ids = $post_counts = array();

FROM ' . POSTS_TABLE . '

WHERE ' . $db->sql_in_set($where_type, array_map('intval', $where_ids));

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

{

$post_counts[$row['poster_id']] = (!empty($post_counts[$row['poster_id']])) ? $post_counts[$row['poster_id']] + 1 : 1;

}

}

$db->sql_freeresult($result);

sync('forum', 'forum_id', $forum_ids, true);

}

return sizeof($post_ids);

}

'BBCODE_NAME' => "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",

'BBCODE_ID' => $num_predefined_bbcodes + ($i * 2),

'BBCODE_TAG' => $row['bbcode_tag'],

);

$i++;

if (gettype($value) == 'string')

{

}

}

case FIELD_STRING:

case FIELD_TEXT:

break;

case FIELD_INT:

// Set up some vars

$icon_id = request_var('icon', 0);

$start = request_var('start', 0);

$to_topic_id = request_var('to_topic_id', 0);

$to_forum_id = request_var('to_forum_id', 0);

$post_id_list = request_var('post_id_list', array(0));

// Split Topic?

if ($action == 'split_all' || $action == 'split_beyond')

{

{

$in = str_replace("\r\n", "\n", $this->message);

}

// Add other checks which needs to be placed before actually parsing anything (be it bbcodes, smilies, urls...)

$pos = strlen($in);

for ($i = 0, $tok_len = strlen($tok); $i < $tok_len; ++$i)

{

if ($tmp_pos !== false && $tmp_pos < $pos)

{

$pos = $tmp_pos;

}

$buffer .= substr($in, 0, $pos);

$in = substr($in, $pos + 1);

if ($tok == ']')

if ($buffer == '/quote' && sizeof($close_tags))

{

// we have found a closing tag

$tok = '[';

$buffer = '';

}

else if (preg_match('#^quote(?:=&quot;(.*?)&quot;)?$#is', $buffer, $m))

{

$error = array();

$num_attachments = sizeof($this->attachment_data);

$upload_file = (isset($_FILES[$form_name]) && $_FILES[$form_name]['name'] != 'none' && trim($_FILES[$form_name]['name'])) ? true : false;

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

{

if ($edit_comment)

{

$edit_comment = request_var('edit_comment', array(0 => ''));

$edit_comment = key($edit_comment);

{

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

$attachment_data = (isset($_POST['attachment_data'])) ? $_POST['attachment_data'] : array();

$this->attachment_data = array();

* @param string $allowed_chars String of special chars to allow

* @param string $encoding Text encoding

* @return string Cleaned up text, only alphanumeric chars are left

*/

function cleanup($text, $allowed_chars = null, $encoding = 'utf-8')

{

static $conv = array(), $conv_loaded = array();

$words = $allow = array();

$encoding = strtolower($encoding);

if ($encoding != 'utf-8')

{

* If we use it more widely, an instance of that class should be held in a

* a global variable instead

*/

/**

* The first thing we do is:

$this->check_ban($this->data['user_id'], $this->ip);

}

$this->data['is_registered'] = (!$bot && $this->data['user_id'] != ANONYMOUS && ($this->data['user_type'] == USER_NORMAL || $this->data['user_type'] == USER_FOUNDER)) ? true : false;

$this->data['is_bot'] = ($bot) ? true : false;

// Only update session DB a minute or so after last update or if page changes

if ($this->time_now - $this->data['session_time'] > 60 || ($this->update_session_page && $this->data['session_page'] != $this->page['page']))

{

$sql_ary = array('session_time' => $this->time_now, 'session_last_visit' => $this->time_now, 'session_admin' => 0);

if ($this->update_session_page)

$sql = 'UPDATE ' . SESSIONS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

WHERE session_id = '" . $db->sql_escape($this->session_id) . "'";

$db->sql_query($sql);

}

$SID = '?sid=';

if ($submit && $edit)

{

if ($draft_message && $draft_subject)

{

$draft_row = array(

// Save Draft

if ($save && $auth->acl_get('u_savedrafts'))

{

$subject = (!$subject && $action != 'post') ? $user->lang['NEW_MESSAGE'] : $subject;

if ($subject && $message)

{

if (confirm_box(true))

if ($submit || $preview || $refresh)

{

$icon_id = request_var('icon', 0);

$enable_bbcode = (!$bbcode_status || isset($_POST['disable_bbcode'])) ? false : true;

$rule_option = request_var('rule_option', 0);

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

$action_option = explode('|', request_var('action_option', ''));

$rule_user_id = ($cond_option != 'none') ? request_var('rule_user_id', 0) : 0;

$rule_group_id = ($cond_option != 'none') ? request_var('rule_group_id', 0) : 0;

$action = (int) $action_option[0];

$folder_id = (int) $action_option[1];

switch ($condition)

{

case 'text':

$template->assign_vars(array(

'S_TEXT_CONDITION' => true,

'CURRENT_STRING' => $rule_string,

case 'user':

$rule_user_id = request_var('rule_user_id', 0);

if ($rule_string && !$rule_user_id)

{

$sql = 'SELECT user_id

case 'group':

$rule_group_id = request_var('rule_group_id', 0);

$sql_and = ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? '<> ' . GROUP_SPECIAL : 'NOT IN (' . GROUP_SPECIAL . ', ' . GROUP_HIDDEN . ')';

$sql = 'SELECT group_id, group_name, group_type

FROM ' . GROUPS_TABLE . "

'yim' => request_var('yim', $user->data['user_yim']),

'jabber' => request_var('jabber', $user->data['user_jabber']),

'website' => request_var('website', $user->data['user_website']),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

);

if ($user->data['user_birthday'])

{

list($data['bday_day'], $data['bday_month'], $data['bday_year']) = explode('-', $user->data['user_birthday']);

$enable_bbcode = ($config['allow_sig_bbcode']) ? request_var('enable_bbcode', $user->optionget('bbcode')) : false;

$enable_smilies = ($config['allow_sig_smilies']) ? request_var('enable_smilies', $user->optionget('smilies')) : false;

$enable_urls = request_var('enable_urls', true);

if ($submit || $preview)

{

* The ultimate convenience function! Clean up invalid UTF-8 sequences,

* and convert to Normal Form C, canonical composition.

*

* @return string The same string, all shiny and cleaned-up

*/

{

// The string below is the list of all autorized characters, sorted by frequency in latin text

$pos = strspn($str, "\x20\x65\x69\x61\x73\x6E\x74\x72\x6F\x6C\x75\x64\x5D\x5B\x63\x6D\x70\x27\x0A\x67\x7C\x68\x76\x2E\x66\x62\x2C\x3A\x3D\x2D\x71\x31\x30\x43\x32\x2A\x79\x78\x29\x28\x4C\x39\x41\x53\x2F\x50\x22\x45\x6A\x4D\x49\x6B\x33\x3E\x35\x54\x3C\x44\x34\x7D\x42\x7B\x38\x46\x77\x52\x36\x37\x55\x47\x4E\x3B\x4A\x7A\x56\x23\x48\x4F\x57\x5F\x26\x21\x4B\x3F\x58\x51\x25\x59\x5C\x09\x5A\x2B\x7E\x5E\x24\x40\x60\x7F\x0D");

if ($pos == $len)

{

// ASCII strings with no special chars return immediately

}

// Note: we do not check for $GLOBALS['utf_canonical_decomp']. It is assumed they are always loaded together

// Replace any byte in the range 0x00..0x1F, except for \r, \n and \t

// We replace those characters with a 0xFF byte, which is illegal in UTF-8 and will in turn be replaced with a UTF replacement char

);

}

/**

* Validate and normalize a UTF string to NFC

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_nfc_qc']))

include($phpbb_root_path . 'includes/utf/data/utf_nfc_qc.' . $phpEx);

}

}

/**

* Validate and normalize a UTF string to NFKC

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_nfkc_qc']))

include($phpbb_root_path . 'includes/utf/data/utf_canonical_comp.' . $phpEx);

}

}

/**

* Validate and normalize a UTF string to NFD

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_canonical_decomp']))

include($phpbb_root_path . 'includes/utf/data/utf_canonical_decomp.' . $phpEx);

}

}

/**

* Validate and normalize a UTF string to NFKD

*

* @return string The string, validated and in normal form

*/

{

$pos = strspn($str, UTF8_ASCII_RANGE);

$len = strlen($str);

if ($pos == $len)

{

// ASCII strings return immediately

}

if (!isset($GLOBALS['utf_compatibility_decomp']))

include($phpbb_root_path . 'includes/utf/data/utf_compatibility_decomp.' . $phpEx);

}

}

$tmp = '';

$i = $tmp_pos = $last_cc = 0;

// UTF char length array

// This array is used to determine the length of a UTF character.

{

// Current char isn't well-formed or legal: either one or several trailing bytes are missing, or the Unicode char

// has been encoded in a five- or six- byte sequence

if ($utf_char[0] >= "\xF8")

{

if ($utf_char[0] < "\xF8")

default:

// Five- and six- byte sequences do not need being checked for here anymore

if ($utf_char > UTF8_MAX)

{

// Out of the Unicode range

ksort($utf_sort);

}

{

$tmp .= implode('', $utf_chars);

}

// LIndex can only range from 0 to 18, therefore it cannot influence the first two bytes of the L Jamo, which allows us to hardcode them (based on LBase).

//

// The same goes for VIndex, but for TIndex there's a catch: the value of the third byte could exceed 0xBF and we would have to increment the second byte

{

{

$utf_char = "\xE1\x84\x00\xE1\x85\x00\xE1\x86\x00";

}

else

{

$utf_char = "\xE1\x84\x00\xE1\x85\x00\xE1\x87\x00";

}

}

else

}

return $tmp;

}

else if ($tmp_pos)

{

* A wrapper function for the normalizer which takes care of including the class if required and modifies the passed strings

* to be in NFC (Normalization Form Composition).

*

*/

function utf8_normalize_nfc($strings)

{

{

}

}

}

/**

include($phpbb_root_path . 'includes/utf/utf_normalizer.' . $phpEx);

}

static $homographs = array(

// cyrllic

*

*/

if (defined('IN_PHPBB') && defined('IN_INSTALL'))

{

$database_update_info = array(

// Changes within this version

'3.0.b3' => array(

// Change the following columns...

'change_columns' => array(

),

),

'add_columns' => array(

{table} => array(

{column_name} => array('USINT', 0), -> column type

),

),

// Latest version

);

// Determine mapping database type

// No need to change here, before no break should appear

break;

default:

$no_updates = true;

break;

/* update the version

$sql = "UPDATE " . CONFIG_TABLE . "

SET config_value = '$updates_to_version'

WHERE config_name = 'version'";

_sql($sql, $errored, $error_ary);

// this should be done for each version in future along with

// the version number update

switch ($db->sql_layer)

</div>

<div id="page-footer">

</div>

</div>

{

global $db;

$db->sql_return_on_error(true);

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

$sql .= " {$column_type} ";

// For hexadecimal values do not use single quotes

{

$sql .= (strpos($column_data[1], '0x') === 0) ? "DEFAULT {$column_data[1]} " : "DEFAULT '{$column_data[1]}' ";

}

if (is_dir($path) && !is_link($path) && file_exists($path . '/iso.txt'))

{

$lang_pack = file("{$phpbb_root_path}language/$path/iso.txt");

$sql_ary = array(

'lang_iso' => basename($path),

'lang_dir' => basename($path),

'lang_english_name' => trim(htmlspecialchars($lang_pack[0])),

);

$db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

CREATE TABLE phpbb_bbcodes (

bbcode_id INTEGER DEFAULT 0 NOT NULL,

bbcode_tag VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,

display_on_posting INTEGER DEFAULT 0 NOT NULL,

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

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

CREATE TABLE phpbb_bbcodes (

bbcode_id tinyint(3) DEFAULT '0' NOT NULL,

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

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

bbcode_match text NOT NULL,

bbcode_tpl mediumtext NOT NULL,

CREATE TABLE phpbb_bbcodes (

bbcode_id number(3) DEFAULT '0' NOT NULL,

bbcode_tag varchar2(16) DEFAULT '' ,

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

bbcode_match clob DEFAULT '' ,

bbcode_tpl clob DEFAULT '' ,

'FORUM_CREATED' => 'Forum created successfully.',

'FORUM_DATA_NEGATIVE' => 'Pruning parameters cannot be negative.',

'FORUM_DELETE' => 'Delete forum',

'FORUM_DELETED' => 'Forum successfully deleted.',

'FORUM_DESC' => 'Description',

'FORUM_DESC_EXPLAIN' => 'Any markup entered here will displayed as is.',

'EXPORT_ICONS' => 'Export and download icons.pak',

'EXPORT_ICONS_EXPLAIN' => '%sOn clicking this link, the configuration for your installed icons will be packaged into <samp>icons.pak</samp> which once downloaded can be used to create a <samp>.zip</samp> or <samp>.tgz</samp> file containing all of your icons plus this <samp>icons.pak</samp> configuration file%s.',

'EXPORT_SMILIES' => 'Export and download smilies.pak',

'FIRST' => 'First',

'INST_ERR_DB_CONNECT' => 'Could not connect to the database, see error message below',

'INST_ERR_DB_FORUM_PATH' => 'The database file specified is within your forum directory tree. You should put this file in a non web-accessible location',

'INST_ERR_DB_NO_ERROR' => 'No error message given',

'INST_ERR_DB_NO_SQLITE' => 'The version of the SQLite extension you have installed is too old, it must be upgraded to at least 2.8.2.',

'INST_ERR_DB_NO_ORACLE' => 'The version of Oracle installed on this machine requires you to set the <var>NLS_CHARACTERSET</var> parameter to <var>UTF8</var>. Either upgrade your installation to 9.2+ or change the parameter.',

'INST_ERR_DB_NO_FIREBIRD' => 'The version of Firebird installed on this machine is older than 2.0, please upgrade to a newer version.',

// Save Draft

if ($save && $user->data['is_registered'] && $auth->acl_get('u_savedrafts'))

{

$subject = (!$subject && $mode != 'post') ? $post_data['topic_title'] : $subject;

if ($subject && $message)

{

if (confirm_box(true))

if ($submit || $preview || $refresh)

{

$post_data['topic_type'] = request_var('topic_type', (($mode != 'post') ? (int) $post_data['topic_type'] : POST_NORMAL));

$post_data['topic_time_limit'] = request_var('topic_time_limit', (($mode != 'post') ? (int) $post_data['topic_time_limit'] : 0));

$post_data['icon_id'] = request_var('icon', 0);

}

else

{

$post_data['poll_length'] = request_var('poll_length', 0);

$post_data['poll_max_options'] = request_var('poll_max_options', 1);

$post_data['poll_vote_change'] = ($auth->acl_get('f_votechg', $forum_id) && isset($_POST['poll_vote_change'])) ? 1 : 0;

}

// If replying/quoting and last post id has changed

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

$post_id = request_var('p', 0);

$reason_id = request_var('reason_id', 0);

$user_notify = (isset($_POST['notify']) && $user->data['is_registered']) ? true : false;

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

<div id="wrapfooter">

<!-- IF U_ACP --><span class="gensmall">[ <a href="{U_ACP}">{L_ACP}</a> ]</span><br /><br /><!-- ENDIF -->

<span class="copyright">Powered by <a href="http://www.phpbb.com/" target="_blank">phpBB</a> &copy; 2002, 2006 phpBB Group

<!-- IF DEBUG_OUTPUT --><br />[ {DEBUG_OUTPUT} ]<!-- ENDIF --></span>

</div>

// Do the forum Prune thang - cron type job ...

if ($forum_data['prune_next'] < time() && $forum_data['enable_prune'])

{

}

// Forum rules and subscription info