+ // Do not use (int) 0x80000000 - it evaluates to different

+ // values on 32-bit and 64-bit systems.

+ // Apparently -2147483648 is a float on 32-bit systems,

+ // despite fitting in an int, thus explicit cast is needed.

+ 'INT' => array('php_type' => 'int', 'min' => (int) -2147483648, 'max' => (int) 0x7fffffff),

+ document.getElementById('acp_unban').unbanlength.value = ban_length[option];

+ <dt><label for="banned">{L_MAIL_BANNED}:</label><br /><span>{L_MAIL_BANNED_EXPLAIN}</span></dt>

+ <dd><input id="banned" name="mail_banned_flag" type="checkbox" class="radio" /></dd>

+</dl>

+<dl>

+ <dd><label><input onclick="dE('posts', -1)" type="radio" class="radio" name="special_rank" value="1" id="special_rank"<!-- IF S_SPECIAL_RANK --> checked="checked"<!-- ENDIF --> />{L_YES}</label>

+ <label><input onclick="dE('posts', 1)" type="radio" class="radio" name="special_rank" value="0"<!-- IF not S_SPECIAL_RANK --> checked="checked"<!-- ENDIF --> /> {L_NO}</label></dd>

+ <!-- IF S_DELETE_STYLE -->

+ <hr />

+ <dl>

+ <dt><label for="new_template_id">{L_DELETE_TEMPLATE}:</label><br /><span>{L_REPLACE_TEMPLATE_EXPLAIN}</span></dt>

+ <dd><select id="new_template_id" name="new_template_id">{S_REPLACE_TEMPLATE_OPTIONS}</select></dd>

+ </dl>

+ <dl>

+ <dt><label for="new_theme_id">{L_DELETE_THEME}:</label><br /><span>{L_REPLACE_THEME_EXPLAIN}</span></dt>

+ <dd><select id="new_theme_id" name="new_theme_id">{S_REPLACE_THEME_OPTIONS}</select></dd>

+ </dl>

+ <dl>

+ <dt><label for="new_imageset_id">{L_DELETE_IMAGESET}:</label><br /><span>{L_REPLACE_IMAGESET_EXPLAIN}</span></dt>

+ <dd><select id="new_imageset_id" name="new_imageset_id">{S_REPLACE_IMAGESET_OPTIONS}</select></dd>

+ </dl>

+ <!-- ENDIF -->

+

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

+

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

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

+// Flush here to prevent browser from showing the page as loading while running cron.

+flush();

+ $queue->process();

+ $cache->tidy();

+ $search->tidy();

+ tidy_warnings();

+ tidy_database();

+ $user->session_gc();

+ auto_prune($row['forum_id'], 'posted', $row['forum_flags'], $row['prune_days'], $row['prune_freq']);

+ auto_prune($row['forum_id'], 'viewed', $row['forum_flags'], $row['prune_viewed'], $row['prune_freq']);

+unlock_cron();

+garbage_collection();

+ 'bbcode_id' => array('USINT', 0),

+<div class="copyright" align="center">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group</div>

+$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

+ 'bbcode_id' => array('USINT', 0),

+* phpBB3 © Copyright phpBB Group

+phpBB Developers: Acyd Burn (Meik Sievertsen) [Lead 09/2005 - 01/2010]

+ ckwalsh (Cullen Walsh)

+ nn- (Oleg Pudeyev)

+Contributions by: leviatan21 (Gabriel Vazquez)

+phpBB Developers: A_Jelly_Doughnut (Josh Woody) [01/2010 - 11/2010]

+ Ashe (Ludovic Arnaud) [10/2002 - 11/2003, 06/2006 - 10/2006]

+ BartVB (Bart van Bragt) [11/2000 - 03/2006]

+ DavidMJ (David M.) [12/2005 - 08/2009]

+ dhn (Dominik Dröscher) [05/2007 - 01/2011]

+ GrahamJE (Graham Eames) [09/2005 - 11/2006]

+ TerraFrost (Jim Wigginton) [04/2009 - 01/2011]

+ Vic D'Elfant (Vic D'Elfant) [04/2007 - 04/2009]

+<meta name="copyright" content="phpBB Group" />

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-license.php">GPL</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<meta name="copyright" content="phpBB Group" />

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-license.php">GPL</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<meta name="copyright" content="phpBB Group" />

+ <li><a href="#webserver_configuration">Webserver configuration</a></li>

+<a name="webserver_configuration"></a><h3>6.ii. Webserver configuration</h3>

+

+ <p>Depending on your web server you may have to configure your server to deny web access to the <code>cache/</code>, <code>files/</code>, <code>store/</code> and other directories. This is to prevent users from accessing sensitive files.</p>

+

+ <p>For <strong>apache</strong> there are <code>.htaccess</code> files already in place to do this for you. For other webservers you will have to adjust the configuration yourself. Sample files for <strong>nginx</strong> and <strong>lighttpd</strong> to help you get started may be found in docs directory.</p>

+

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-license.php">GPL</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<meta name="copyright" content="phpBB Group" />

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-license.php">GPL</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<meta name="copyright" content="phpBB Group" />

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-license.php">GPL</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<meta name="copyright" content="phpBB Group" />

+PHPBB_ACM_REDIS_HOST (overwrite redis host name, default is localhost)

+PHPBB_ACM_REDIS_PORT (overwrite redis port, default is 6379)

+PHPBB_ACM_REDIS_PASSWORD (overwrite redis password, default is empty)

+PHPBB_ACM_REDIS_DB (overwrite redis default database)

+

+ <p>Some of these functions are only chosen over others because of personal preference and having no other benefit than to be consistent over the code.</p>

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-license.php">GPL</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+<meta name="copyright" content="phpBB Group" />

+ <p>This application is opensource software released under the <a href="http://opensource.org/licenses/gpl-license.php">GPL</a>. Please see source code and the docs directory for more details. This package and its contents are Copyright (c) <a href="http://www.phpbb.com/">phpBB Group</a>, All Rights Reserved.</p>

+

+ # Compression levels over 6 do not give an appreciable improvement

+ # in compression ratio, but take more resources.

+

+ # IE 6 and lower do not support gzip with Vary correctly.

+ gzip_disable "msie6";

+ # Before nginx 0.7.63:

+ #gzip_disable "MSIE [1-6]\.";

+ # default specifies that this block is to be used when

+ # no other block matches.

+ listen 80 default;

+

+ # Default port is 80.

+ #listen 80;

+

+

+ # A trick from http://wiki.nginx.org/Pitfalls#Taxing_Rewrites:

+ rewrite ^ http://www.myforums.com$request_uri permanent;

+ # Equivalent to:

+ #rewrite ^(.*)$ http://www.myforums.com$1 permanent;

+ #listen 80;

+ # deny was ignored before 0.8.40 for connections over IPv6.

+ # Use internal directive to prohibit access on older versions.

+ internal;

+ internal;

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

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(404, 'Not Found');

+ send_status_line(403, 'Forbidden');

+ send_status_line(404, 'Forbidden');

+ send_status_line(404, 'Not Found');

+ send_status_line(500, 'Internal Server Error');

+ send_status_line(404, 'Not Found');

+ send_status_line(500, 'Internal Server Error');

+ send_status_line(500, 'Internal Server Error');

+ $published = ($feed->get('published') !== NULL) ? (int) $row[$feed->get('published')] : 0;

+ $updated = ($feed->get('updated') !== NULL) ? (int) $row[$feed->get('updated')] : 0;

+ 'published' => ($published > 0) ? feed_format_date($published) : '',

+ 'updated' => ($updated > 0) ? feed_format_date($updated) : '',

+ $feed_updated_time = max($feed_updated_time, $published, $updated);

+ echo '<updated>' . ((!empty($row['updated'])) ? $row['updated'] : $row['published']) . '</updated>' . "\n";

+

+ if (!empty($row['published']))

+ {

+ echo '<published>' . $row['published'] . '</published>' . "\n";

+ }

+

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ . ' ' . $this->separator_stats . ' ' . $user->format_date($row[$this->get('published')])

+ $this->set('published', 'post_time');

+ $this->set('updated', 'post_edit_time');

+ . ' ' . $this->separator_stats . ' ' . $user->format_date($row[$this->get('published')])

+ 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'SELECT' => 'p.post_id, p.topic_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ 'SELECT' => 'p.post_id, p.post_time, p.post_edit_time, p.post_approved, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url, ' .

+ $this->set('updated', 'forum_last_post_time');

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ t.topic_id, t.topic_title, t.topic_poster, t.topic_first_poster_name, t.topic_replies, t.topic_replies_real, t.topic_views, t.topic_time, t.topic_last_post_time,

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ p.post_id, p.post_time, p.post_edit_time, p.post_text, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.enable_smilies, p.enable_magic_url',

+ die('Fatal: ' . $this->cache_dir . ' is NOT writable.');

+ die('Fatal: Not able to open ' . $this->cache_dir . 'data_global.' . $phpEx);

+<?php

+/**

+*

+* @package acm

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+// Include the abstract base

+if (!class_exists('acm_memory'))

+{

+ require("{$phpbb_root_path}includes/acm/acm_memory.$phpEx");

+}

+

+if (!defined('PHPBB_ACM_REDIS_PORT'))

+{

+ define('PHPBB_ACM_REDIS_PORT', 6379);

+}

+

+if (!defined('PHPBB_ACM_REDIS_HOST'))

+{

+ define('PHPBB_ACM_REDIS_HOST', 'localhost');

+}

+

+if (!defined('PHPBB_ACM_REDIS'))

+{

+ //can define multiple servers with host1/port1,host2/port2 format

+ define('PHPBB_ACM_REDIS', PHPBB_ACM_REDIS_HOST . '/' . PHPBB_ACM_REDIS_PORT);

+}

+

+/**

+* ACM for Redis

+*

+* Compatible with the php extension phpredis available

+* at https://github.com/nicolasff/phpredis

+*

+* @package acm

+*/

+class acm extends acm_memory

+{

+ var $extension = 'redis';

+

+ var $redis;

+

+ function acm()

+ {

+ // Call the parent constructor

+ parent::acm_memory();

+

+ $this->redis = new Redis();

+ foreach (explode(',', PHPBB_ACM_REDIS) as $server)

+ {

+ $parts = explode('/', $server);

+ $this->redis->connect(trim($parts[0]), trim($parts[1]));

+ }

+

+ if (defined('PHPBB_ACM_REDIS_PASSWORD'))

+ {

+ if (!$this->redis->auth(PHPBB_ACM_REDIS_PASSWORD))

+ {

+ global $acm_type;

+

+ trigger_error("Incorrect password for the ACM module $acm_type.", E_USER_ERROR);

+ }

+ }

+

+ $this->redis->setOption(Redis::OPT_SERIALIZER, Redis::SERIALIZER_PHP);

+ $this->redis->setOption(Redis::OPT_PREFIX, $this->key_prefix);

+

+ if (defined('PHPBB_ACM_REDIS_DB'))

+ {

+ if (!$this->redis->select(PHPBB_ACM_REDIS_DB))

+ {

+ global $acm_type;

+

+ trigger_error("Incorrect database for the ACM module $acm_type.", E_USER_ERROR);

+ }

+ }

+ }

+

+ /**

+ * Unload the cache resources

+ *

+ * @return void

+ */

+ function unload()

+ {

+ parent::unload();

+

+ $this->redis->close();

+ }

+

+ /**

+ * Purge cache data

+ *

+ * @return void

+ */

+ function purge()

+ {

+ $this->redis->flushDB();

+

+ parent::purge();

+ }

+

+ /**

+ * Fetch an item from the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @return mixed Cached data

+ */

+ function _read($var)

+ {

+ return $this->redis->get($var);

+ }

+

+ /**

+ * Store data in the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @param mixed $data Data to store

+ * @param int $ttl Time-to-live of cached data

+ * @return bool True if the operation succeeded

+ */

+ function _write($var, $data, $ttl = 2592000)

+ {

+ return $this->redis->setex($var, $ttl, $data);

+ }

+

+ /**

+ * Remove an item from the cache

+ *

+ * @access protected

+ * @param string $var Cache key

+ * @return bool True if the operation succeeded

+ */

+ function _delete($var)

+ {

+ if ($this->redis->delete($var) > 0)

+ {

+ return true;

+ }

+ return false;

+ }

+}

+ if ($bbcode_id > BBCODE_LIMIT)

+ $sql = 'SELECT disallow_id

+ FROM ' . DISALLOW_TABLE . "

+ WHERE disallow_username = '" . $db->sql_escape($disallowed_user) . "'";

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

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ if ($row)

+ {

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

+ }

+

+ $sql_ary = array(

+ 'SELECT' => 'u.user_email, u.username, u.username_clean, u.user_lang, u.user_jabber, u.user_notify_type',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ USER_GROUP_TABLE => 'ug',

+ ),

+ 'WHERE' => 'ug.group_id = ' . $group_id . '

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')',

+ 'ORDER_BY' => 'u.user_lang, u.user_notify_type',

+ );

+ $sql_ary = array(

+ 'SELECT' => 'u.username, u.username_clean, u.user_email, u.user_jabber, u.user_lang, u.user_notify_type',

+ 'FROM' => array(

+ USERS_TABLE => 'u',

+ ),

+ 'WHERE' => 'u.user_allow_massemail = 1

+ AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')',

+ 'ORDER_BY' => 'u.user_lang, u.user_notify_type',

+ );

+

+ // Mail banned or not

+ if (!isset($_REQUEST['mail_banned_flag']))

+ {

+ $sql_ary['WHERE'] .= ' AND (b.ban_id IS NULL

+ OR b.ban_exclude = 1)';

+ $sql_ary['LEFT_JOIN'] = array(

+ array(

+ 'FROM' => array(

+ BANLIST_TABLE => 'b',

+ ),

+ 'ON' => 'u.user_id = b.ban_userid',

+ ),

+ );

+ }

+ $sql = $db->sql_build_query('SELECT', $sql_ary);

+ else if (!file_exists($phpbb_root_path . $img_path . '/' . $image))

+ {

+ $errors[$image] = 'SMILIE_NO_FILE';

+ }

+ // index.htm files

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/email/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/acp/index.htm');

+ $compress->add_data('', 'language/' . $row['lang_iso'] . '/mods/index.htm');

+ $this->main_files = array("captcha_qa.$phpEx", "captcha_recaptcha.$phpEx", "common.$phpEx", "groups.$phpEx", "install.$phpEx", "mcp.$phpEx", "memberlist.$phpEx", "posting.$phpEx", "search.$phpEx", "ucp.$phpEx", "viewforum.$phpEx", "viewtopic.$phpEx", "help_bbcode.$phpEx", "help_faq.$phpEx");

+ $log_count = false;

+ if ($action == 'create' && request_var('field_default_value', '') === '')

+ $buffer = $db->sql_buffer_nested_transactions();

+

+ if ($buffer)

+ {

+ $rows = $db->sql_fetchrowset($result);

+ $rows[] = false; // indicate end of array for while loop below

+

+ $db->sql_freeresult($result);

+ }

+

+ $i = 0;

+ while ($row = ($buffer ? $rows[$i++] : $db->sql_fetchrow($result)))

+ if (!$buffer)

+ {

+ $db->sql_freeresult($result);

+ }

+ $template_file = preg_replace('#\.{2,}#', '.', $template_file);

+ $sql_select = 'style_id, style_name, template_id, theme_id, imageset_id';

+ $sql_select = 'template_id, template_name, template_path, template_storedb';

+ $sql_select = 'theme_id, theme_name, theme_path, theme_storedb';

+ $sql_select = 'imageset_id, imageset_name, imageset_path';

+ $sql = "DELETE FROM $sql_from

+ WHERE {$mode}_id = $style_id";

+ $db->sql_query($sql);

+

+

+ // Remove the components

+ $components = array('template', 'theme', 'imageset');

+ foreach ($components as $component)

+ {

+ $new_id = request_var('new_' . $component . '_id', 0);

+ $component_id = $style_row[$component . '_id'];

+ $this->remove_component($component, $component_id, $new_id, $style_id);

+ }

+ $this->remove_component($mode, $style_id, $new_id);

+ $this->display_component_options($mode, $style_row[$mode . '_id'], $style_row);

+

+

+ if ($mode == 'style')

+ {

+ $template->assign_vars(array(

+ 'S_DELETE_STYLE' => true,

+ ));

+ }

+ }

+

+ /**

+ * Remove template/theme/imageset entry from the database

+ */

+ function remove_component($component, $component_id, $new_id, $style_id = false)

+ {

+ global $db;

+

+ if (($new_id == 0) || ($component === 'template' && ($conflicts = $this->check_inheritance($component, $component_id))))

+ {

+ // We can not delete the template, as the user wants to keep the component or an other template is inheriting from this one.

+ return;

+ }

+

+ $component_in_use = array();

+ if ($component != 'style')

+ {

+ $component_in_use = $this->component_in_use($component, $component_id, $style_id);

+ }

+

+ if (($new_id == -1) && !empty($component_in_use))

+ {

+ // We can not delete the component, as it is still in use

+ return;

+ }

+

+ if ($component == 'imageset')

+ {

+ $sql = 'DELETE FROM ' . STYLES_IMAGESET_DATA_TABLE . "

+ WHERE imageset_id = $component_id";

+ $db->sql_query($sql);

+ }

+

+ switch ($component)

+ {

+ case 'template':

+ $sql_from = STYLES_TEMPLATE_TABLE;

+ break;

+

+ case 'theme':

+ $sql_from = STYLES_THEME_TABLE;

+ break;

+

+ case 'imageset':

+ $sql_from = STYLES_IMAGESET_TABLE;;

+ break;

+ }

+

+ $sql = "DELETE FROM $sql_from

+ WHERE {$component}_id = $component_id";

+ $db->sql_query($sql);

+

+ $sql = 'UPDATE ' . STYLES_TABLE . "

+ SET {$component}_id = $new_id

+ WHERE {$component}_id = $component_id";

+ $db->sql_query($sql);

+ }

+

+ /**

+ * Display the options which can be used to replace a style/template/theme/imageset

+ */

+ function display_component_options($component, $component_id, $style_row = false, $style_id = false)

+ {

+ global $db, $template, $user;

+

+ $component_in_use = array();

+ if ($component != 'style')

+ {

+ $component_in_use = $this->component_in_use($component, $component_id, $style_id);

+ }

+

+ $sql_where = '';

+ switch ($component)

+ {

+ case 'style':

+ $sql_from = STYLES_TABLE;

+ $sql_where = 'WHERE style_active = 1';

+ break;

+

+ case 'template':

+ $sql_from = STYLES_TEMPLATE_TABLE;

+ $sql_where = 'WHERE template_inherits_id <> ' . $component_id;

+ break;

+

+ case 'theme':

+ $sql_from = STYLES_THEME_TABLE;

+ break;

+

+ case 'imageset':

+ $sql_from = STYLES_IMAGESET_TABLE;

+ break;

+ }

+

+ $s_options = '';

+ if (($component != 'style') && empty($component_in_use))

+ {

+ $sql = "SELECT {$component}_id, {$component}_name

+ FROM $sql_from

+ WHERE {$component}_id = {$component_id}";

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

+ $row = $db->sql_fetchrow($result);

+ $db->sql_freeresult($result);

+

+ $s_options .= '<option value="-1" selected="selected">' . $user->lang['DELETE_' . strtoupper($component)] . '</option>';

+ $s_options .= '<option value="0">' . sprintf($user->lang['KEEP_' . strtoupper($component)], $row[$component . '_name']) . '</option>';

+ }

+ else

+ {

+ $sql = "SELECT {$component}_id, {$component}_name

+ FROM $sql_from

+ $sql_where

+ ORDER BY {$component}_name ASC";

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

+

+ $s_keep_option = $s_options = '';

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

+ {

+ if ($row[$component . '_id'] != $component_id)

+ {

+ $s_options .= '<option value="' . $row[$component . '_id'] . '">' . sprintf($user->lang['REPLACE_WITH_OPTION'], $row[$component . '_name']) . '</option>';

+ }

+ else if ($component != 'style')

+ {

+ $s_keep_option = '<option value="0" selected="selected">' . sprintf($user->lang['KEEP_' . strtoupper($component)], $row[$component . '_name']) . '</option>';

+ }

+ }

+ $db->sql_freeresult($result);

+ $s_options = $s_keep_option . $s_options;

+ }

+

+ if (!$style_row)

+ {

+ $template->assign_var('S_REPLACE_' . strtoupper($component) . '_OPTIONS', $s_options);

+ }

+ else

+ {

+ $template->assign_var('S_REPLACE_OPTIONS', $s_options);

+ if ($component == 'style')

+ {

+ $components = array('template', 'theme', 'imageset');

+ foreach ($components as $component)

+ {

+ $this->display_component_options($component, $style_row[$component . '_id'], false, $component_id, true);

+ }

+ }

+ }

+ }

+

+ /**

+ * Check whether the component is still used by another style or component

+ */

+ function component_in_use($component, $component_id, $style_id = false)

+ {

+ global $db;

+

+ $component_in_use = array();

+

+ if ($style_id)

+ {

+ $sql = 'SELECT style_id, style_name

+ FROM ' . STYLES_TABLE . "

+ WHERE {$component}_id = {$component_id}

+ AND style_id <> {$style_id}

+ ORDER BY style_name ASC";

+ }

+ else

+ {

+ $sql = 'SELECT style_id, style_name

+ FROM ' . STYLES_TABLE . "

+ WHERE {$component}_id = {$component_id}

+ ORDER BY style_name ASC";

+ }

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

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

+ {

+ $component_in_use[] = $row['style_name'];

+ }

+ $db->sql_freeresult($result);

+

+ if ($component === 'template' && ($conflicts = $this->check_inheritance($component, $component_id)))

+ {

+ foreach ($conflicts as $temp_id => $conflict_data)

+ {

+ $component_in_use[] = $conflict_data['template_name'];

+ }

+ }

+

+ return $component_in_use;

+ // Replace multiple consecutive asterisks with single one as those are not needed

+ $word = preg_replace('#\*{2,}#', '*', $word);

+

+ $seq_cache = array();

+ if (isset($seq_cache[$subseq]))

+ {

+ $converted = $seq_cache[$subseq];

+ }

+ else

+ {

+ $converted = $seq_cache[$subseq] = str_pad(base_convert($subseq, 36, 2), 31, 0, STR_PAD_LEFT);

+ }

+

+ $this->acl[$f] .= $converted;

+ $censors['match'][] = get_censor_preg_expression($row['word']);

+ $noise[$i] = new char_cube3d($noise_bitmaps, mt_rand(1, sizeof($noise_bitmaps['data'])));

+ 'A' => $chars['A'][mt_rand(0, min(sizeof($chars['A']), $config['captcha_gd_fonts']) -1)],

+ 'B' => $chars['B'][mt_rand(0, min(sizeof($chars['B']), $config['captcha_gd_fonts']) -1)],

+ 'C' => $chars['C'][mt_rand(0, min(sizeof($chars['C']), $config['captcha_gd_fonts']) -1)],

+ 'D' => $chars['D'][mt_rand(0, min(sizeof($chars['D']), $config['captcha_gd_fonts']) -1)],

+ 'E' => $chars['E'][mt_rand(0, min(sizeof($chars['E']), $config['captcha_gd_fonts']) -1)],

+ 'F' => $chars['F'][mt_rand(0, min(sizeof($chars['F']), $config['captcha_gd_fonts']) -1)],

+ 'G' => $chars['G'][mt_rand(0, min(sizeof($chars['G']), $config['captcha_gd_fonts']) -1)],

+ 'H' => $chars['H'][mt_rand(0, min(sizeof($chars['H']), $config['captcha_gd_fonts']) -1)],

+ 'I' => $chars['I'][mt_rand(0, min(sizeof($chars['I']), $config['captcha_gd_fonts']) -1)],

+ 'J' => $chars['J'][mt_rand(0, min(sizeof($chars['J']), $config['captcha_gd_fonts']) -1)],

+ 'K' => $chars['K'][mt_rand(0, min(sizeof($chars['K']), $config['captcha_gd_fonts']) -1)],

+ 'L' => $chars['L'][mt_rand(0, min(sizeof($chars['L']), $config['captcha_gd_fonts']) -1)],

+ 'M' => $chars['M'][mt_rand(0, min(sizeof($chars['M']), $config['captcha_gd_fonts']) -1)],

+ 'N' => $chars['N'][mt_rand(0, min(sizeof($chars['N']), $config['captcha_gd_fonts']) -1)],

+ 'O' => $chars['O'][mt_rand(0, min(sizeof($chars['O']), $config['captcha_gd_fonts']) -1)],

+ 'P' => $chars['P'][mt_rand(0, min(sizeof($chars['P']), $config['captcha_gd_fonts']) -1)],

+ 'Q' => $chars['Q'][mt_rand(0, min(sizeof($chars['Q']), $config['captcha_gd_fonts']) -1)],

+ 'R' => $chars['R'][mt_rand(0, min(sizeof($chars['R']), $config['captcha_gd_fonts']) -1)],

+ 'S' => $chars['S'][mt_rand(0, min(sizeof($chars['S']), $config['captcha_gd_fonts']) -1)],

+ 'T' => $chars['T'][mt_rand(0, min(sizeof($chars['T']), $config['captcha_gd_fonts']) -1)],

+ 'U' => $chars['U'][mt_rand(0, min(sizeof($chars['U']), $config['captcha_gd_fonts']) -1)],

+ 'V' => $chars['V'][mt_rand(0, min(sizeof($chars['V']), $config['captcha_gd_fonts']) -1)],

+ 'W' => $chars['W'][mt_rand(0, min(sizeof($chars['W']), $config['captcha_gd_fonts']) -1)],

+ 'X' => $chars['X'][mt_rand(0, min(sizeof($chars['X']), $config['captcha_gd_fonts']) -1)],

+ 'Y' => $chars['Y'][mt_rand(0, min(sizeof($chars['Y']), $config['captcha_gd_fonts']) -1)],

+ 'Z' => $chars['Z'][mt_rand(0, min(sizeof($chars['Z']), $config['captcha_gd_fonts']) -1)],

+ 'x' => mt_rand($img_x - 45, $img_x - 5),

+ 'y' => mt_rand($img_y - 15, $img_y - 0),

+// BBCode hard limit

+define('BBCODE_LIMIT', 1511);

+

+ * Returns whether results of a query need to be buffered to run a transaction while iterating over them.

+ *

+ * @return bool Whether buffering is required.

+ */

+ function sql_buffer_nested_transaction()

+ {

+ return false;

+ }

+

+ /**

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

+ var $connect_error = '';

+ if ($this->persistency)

+ {

+ if (!function_exists('ibase_pconnect'))

+ {

+ $this->connect_error = 'ibase_pconnect function does not exist, is interbase extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ibase_pconnect($use_database, $this->user, $sqlpassword, false, false, 3);

+ }

+ else

+ {

+ if (!function_exists('ibase_connect'))

+ {

+ $this->connect_error = 'ibase_connect function does not exist, is interbase extension installed?';

+ return $this->sql_error('');

+ }

+ $this->db_connect_id = @ibase_connect($use_database, $this->user, $sqlpassword, false, false, 3);

+ }

+ // Do not call ibase_service_attach if connection failed,

+ // otherwise error message from ibase_(p)connect call will be clobbered.

+ if ($this->db_connect_id && function_exists('ibase_service_attach') && $this->server)

+ {

+ $this->service_handle = @ibase_service_attach($this->server, $this->user, $sqlpassword);

+ }

+ else

+ {

+ $this->service_handle = false;

+ }

+ // Need special handling here because ibase_errmsg returns

+ // connection errors, however if the interbase extension

+ // is not installed then ibase_errmsg does not exist and

+ // we cannot call it.

+ if (function_exists('ibase_errmsg'))

+ {

+ $msg = @ibase_errmsg();

+ if (!$msg)

+ {

+ $msg = $this->connect_error;

+ }

+ }

+ else

+ {

+ $msg = $this->connect_error;

+ }

+ 'message' => $msg,

+ $this->m_row_count = sizeof($this->m_rows);

+ * {@inheritDoc}

+ */

+ function sql_buffer_nested_transaction()

+ {

+ return true;

+ }

+

+ /**

+

+ preg_match_all('/\'(?:[^\']++|\'\')*+\'|[\d-.]+/', $regs[3], $vals, PREG_PATTERN_ORDER);

+

+if (!class_exists('phpbb_error_collector'))

+{

+ include($phpbb_root_path . 'includes/error_collector.' . $phpEx);

+}

+

+ var $connect_error = '';

+ if (!function_exists('pg_pconnect'))

+ {

+ $this->connect_error = 'pg_pconnect function does not exist, is pgsql extension installed?';

+ return $this->sql_error('');

+ }

+ $collector = new phpbb_error_collector;

+ $collector->install();

+ if (!function_exists('pg_connect'))

+ {

+ $this->connect_error = 'pg_connect function does not exist, is pgsql extension installed?';

+ return $this->sql_error('');

+ }

+ $collector = new phpbb_error_collector;

+ $collector->install();

+ $collector->uninstall();

+

+ $this->connect_error = $collector->format_errors();

+ // pg_last_error only works when there is an established connection.

+ // Connection errors have to be tracked by us manually.

+ if ($this->db_connect_id)

+ {

+ $message = @pg_last_error($this->db_connect_id);

+ }

+ else

+ {

+ $message = $this->connect_error;

+ }

+

+ 'message' => $message,

+<?php

+/**

+*

+* @package phpBB

+* @version $Id$

+* @copyright (c) 2011 phpBB Group

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

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+class phpbb_error_collector

+{

+ var $errors;

+

+ function phpbb_error_collector()

+ {

+ $this->errors = array();

+ }

+

+ function install()

+ {

+ set_error_handler(array(&$this, 'error_handler'));

+ }

+

+ function uninstall()

+ {

+ restore_error_handler();

+ }

+

+ function error_handler($errno, $msg_text, $errfile, $errline)

+ {

+ $this->errors[] = array($errno, $msg_text, $errfile, $errline);

+ }

+

+ function format_errors()

+ {

+ $text = '';

+ foreach ($this->errors as $error)

+ {

+ if (!empty($text))

+ {

+ $text .= "<br />\n";

+ }

+ list($errno, $msg_text, $errfile, $errline) = $error;

+ $text .= "Errno $errno: $msg_text";

+ if (defined('DEBUG_EXTRA') || defined('IN_INSTALL'))

+ {

+ $text .= " at $errfile line $errline";

+ }

+ }

+ return $text;

+ }

+}

+ case 'postgres':

+ // Need to cast to text first for PostgreSQL 7.x

+ $sql_update = 'CAST(CAST(config_value::text as DECIMAL(255, 0)) + ' . (int) $increment . ' as VARCHAR(255))';

+ break;

+

+ set_config('rand_seed', $config['rand_seed'], true);

+ if (substr($setting, 0, 3) != '$H$' && substr($setting, 0, 3) != '$P$')

+ $last_mark = (int) $user->data['user_lastmark'];

+ t.topic_last_post_time > $last_mark AND

+ (tt.mark_time IS NULL AND ft.mark_time IS NULL)

+*

+*

+* @return string the generated board url

+ if (!empty($_SERVER['SERVER_PROTOCOL']))

+ $version = $_SERVER['SERVER_PROTOCOL'];

+ }

+ else if (!empty($_SERVER['HTTP_VERSION']))

+ {

+ // I cannot remember where I got this from.

+ // This code path may never be reachable in reality.

+* Generate regexp for naughty words censoring

+* Depends on whether installed PHP version supports unicode properties

+*

+* @param string $word word template to be replaced

+* @param bool $use_unicode whether or not to take advantage of PCRE supporting unicode

+*

+* @return string $preg_expr regex to use with word censor

+*/

+function get_censor_preg_expression($word, $use_unicode = true)

+{

+ static $unicode_support = null;

+

+ // Check whether PHP version supports unicode properties

+ if (is_null($unicode_support))

+ {

+ $unicode_support = ((version_compare(PHP_VERSION, '5.1.0', '>=') || (version_compare(PHP_VERSION, '5.0.0-dev', '<=') && version_compare(PHP_VERSION, '4.4.0', '>='))) && @preg_match('/\p{L}/u', 'a') !== false) ? true : false;

+ }

+

+ // Unescape the asterisk to simplify further conversions

+ $word = str_replace('\*', '*', preg_quote($word, '#'));

+

+ if ($use_unicode && $unicode_support)

+ {

+ // Replace asterisk(s) inside the pattern, at the start and at the end of it with regexes

+ $word = preg_replace(array('#(?<=[\p{Nd}\p{L}_])\*+(?=[\p{Nd}\p{L}_])#iu', '#^\*+#', '#\*+$#'), array('([\x20]*?|[\p{Nd}\p{L}_-]*?)', '[\p{Nd}\p{L}_-]*?', '[\p{Nd}\p{L}_-]*?'), $word);

+

+ // Generate the final substitution

+ $preg_expr = '#(?<![\p{Nd}\p{L}_-])(' . $word . ')(?![\p{Nd}\p{L}_-])#iu';

+ }

+ else

+ {

+ // Replace the asterisk inside the pattern, at the start and at the end of it with regexes

+ $word = preg_replace(array('#(?<=\S)\*+(?=\S)#iu', '#^\*+#', '#\*+$#'), array('(\x20*?\S*?)', '\S*?', '\S*?'), $word);

+

+ // Generate the final substitution

+ $preg_expr = '#(?<!\S)(' . $word . ')(?!\S)#iu';

+ }

+

+ return $preg_expr;

+}

+

+/**

+ echo ' Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group';

+ }

+ if (!defined('IN_CRON') && $run_cron && !$config['board_disable'] && !$user->data['is_bot'])

+* If $log_count is set to false, we will skip counting all entries in the database.

+ if ($log_count !== false)

+ {

+ $sql = 'SELECT COUNT(l.log_id) AS total_entries

+ FROM ' . LOG_TABLE . ' l, ' . USERS_TABLE . " u

+ WHERE l.log_type = $log_type

+ AND l.user_id = u.user_id

+ AND l.log_time >= $limit_days

+ $sql_keywords

+ $sql_forum";

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

+ $log_count = (int) $db->sql_fetchfield('total_entries');

+ $db->sql_freeresult($result);

+ }

+ 'S_FEED_ENABLED' => ($config['feed_forum'] && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $row['forum_options']) && $row['forum_type'] == FORUM_POST) ? true : false,

+ if ($config['check_attachment_content'] && isset($config['mime_triggers']))

+ $sql = 'SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username, u.user_colour

+ $sql_data[TOPICS_TABLE] = 'topic_poster = ' . intval($row['poster_id']) . ', topic_first_post_id = ' . intval($row['post_id']) . ", topic_first_poster_colour = '" . $db->sql_escape($row['user_colour']) . "', topic_first_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "', topic_time = " . (int) $row['post_time'];

+ // Count the number of ! occurrences (not allowed in vars)

+ var $disallowed_content = array('body', 'head', 'html', 'img', 'plaintext', 'a href', 'pre', 'script', 'table', 'title');

+ $this->disallowed_content = array_diff($disallowed_content, array(''));

+ trigger_error('LENGTH_BAN_INVALID', E_USER_WARNING);

+ trigger_error('NO_USER_SPECIFIED', E_USER_WARNING);

+ trigger_error('NO_USERS', E_USER_WARNING);

+ trigger_error('NO_IPS_DEFINED', E_USER_WARNING);

+ trigger_error('NO_EMAILS_DEFINED', E_USER_WARNING);

+ trigger_error('NO_MODE', E_USER_WARNING);

+* Validate Language Pack ISO Name

+*

+* Tests whether a language name is valid and installed

+*

+* @param string $lang_iso The language string to test

+*

+* @return bool|string Either false if validation succeeded or

+* a string which will be used as the error message

+* (with the variable name appended)

+*/

+function validate_language_iso_name($lang_iso)

+{

+ global $db;

+

+ $sql = 'SELECT lang_id

+ FROM ' . LANG_TABLE . "

+ WHERE lang_iso = '" . $db->sql_escape($lang_iso) . "'";

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

+ $lang_id = (int) $db->sql_fetchfield('lang_id');

+ $db->sql_freeresult($result);

+

+ return ($lang_id) ? false : 'WRONG_DATA';

+}

+

+/**

+ if ($password === '' || $config['pass_complex'] === 'PASS_TYPE_ANY')

+ // Password empty or no password complexity required.

+ // No break statements below ...

+ // We require strong passwords in case pass_complex is not set or is invalid

+ default:

+

+ // Require mixed case letters, numbers and symbols

+ case 'PASS_TYPE_SYMBOL':

+ $chars[] = $sym;

+ // Require mixed case letters and numbers

+ // Require mixed case letters

+ case 'PASS_TYPE_CASE':

+ $upload = new fileupload('AVATAR_', array('jpg', 'jpeg', 'gif', 'png'), $config['avatar_filesize'], $config['avatar_min_width'], $config['avatar_min_height'], $config['avatar_max_width'], $config['avatar_max_height'], (isset($config['mime_triggers']) ? explode('|', $config['mime_triggers']) : false));

+ $log_count = false;

+ foreach ($topic_data as $topic_id => $topic_row)

+ {

+ if (!isset($search_type) && $topic_row['enable_indexing'])

+ // Select the search method and do some additional checks to ensure it can actually be utilised

+ $search_type = basename($config['search_type']);

+ if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))

+ {

+ trigger_error('NO_SUCH_SEARCH_MODULE');

+ }

+

+ if (!class_exists($search_type))

+ {

+ include("{$phpbb_root_path}includes/search/$search_type.$phpEx");

+ }

+ $error = false;

+ $search = new $search_type($error);

+ $search_mode = 'post';

+ if ($error)

+ {

+ trigger_error($error);

+ }

+ }

+ else if (!isset($search_type) && !$topic_row['enable_indexing'])

+ $search_type = false;

+ if (!empty($search_type))

+ $search->index($search_mode, $new_post_id, $sql_ary['post_text'], $sql_ary['post_subject'], $sql_ary['poster_id'], ($topic_row['topic_type'] == POST_GLOBAL) ? 0 : $to_forum_id);

+ $log_count = false;

+ if (!empty($log_data))

+ 'code' => array('bbcode_id' => 8, 'regexp' => array('#\[code(?:=([a-z]+))?\](.+\[/code\])#uise' => "\$this->bbcode_code('\$1', '\$2')")),

+ 'quote' => array('bbcode_id' => 0, 'regexp' => array('#\[quote(?:=&quot;(.*?)&quot;)?\](.+)\[/quote\]#uise' => "\$this->bbcode_quote('\$0')")),

+ 'attachment' => array('bbcode_id' => 12, 'regexp' => array('#\[attachment=([0-9]+)\](.*?)\[/attachment\]#uise' => "\$this->bbcode_attachment('\$1', '\$2')")),

+ 'b' => array('bbcode_id' => 1, 'regexp' => array('#\[b\](.*?)\[/b\]#uise' => "\$this->bbcode_strong('\$1')")),

+ 'i' => array('bbcode_id' => 2, 'regexp' => array('#\[i\](.*?)\[/i\]#uise' => "\$this->bbcode_italic('\$1')")),

+ 'url' => array('bbcode_id' => 3, 'regexp' => array('#\[url(=(.*))?\](.*)\[/url\]#uiUe' => "\$this->validate_url('\$2', '\$3')")),

+ 'img' => array('bbcode_id' => 4, 'regexp' => array('#\[img\](.*)\[/img\]#uiUe' => "\$this->bbcode_img('\$1')")),

+ 'size' => array('bbcode_id' => 5, 'regexp' => array('#\[size=([\-\+]?\d+)\](.*?)\[/size\]#uise' => "\$this->bbcode_size('\$1', '\$2')")),

+ 'color' => array('bbcode_id' => 6, 'regexp' => array('!\[color=(#[0-9a-f]{3}|#[0-9a-f]{6}|[a-z\-]+)\](.*?)\[/color\]!uise' => "\$this->bbcode_color('\$1', '\$2')")),

+ 'u' => array('bbcode_id' => 7, 'regexp' => array('#\[u\](.*?)\[/u\]#uise' => "\$this->bbcode_underline('\$1')")),

+ 'list' => array('bbcode_id' => 9, 'regexp' => array('#\[list(?:=(?:[a-z0-9]|disc|circle|square))?].*\[/list]#uise' => "\$this->bbcode_parse_list('\$0')")),

+ 'email' => array('bbcode_id' => 10, 'regexp' => array('#\[email=?(.*?)?\](.*?)\[/email\]#uise' => "\$this->validate_email('\$1', '\$2')")),

+ 'flash' => array('bbcode_id' => 11, 'regexp' => array('#\[flash=([0-9]+),([0-9]+)\](.*?)\[/flash\]#uie' => "\$this->bbcode_flash('\$1', '\$2', '\$3')"))

+ // 'u' modifier has been added to correctly parse smilies within unicode strings

+ // For details: http://tracker.phpbb.com/browse/PHPBB3-10117

+ $num_matches = preg_match_all('#(?<=^|[\n .])(?:' . implode('|', $match) . ')(?![^<>]*>)#u', $this->message, $matches);

+ // 'u' modifier has been added to correctly parse smilies within unicode strings

+ // For details: http://tracker.phpbb.com/browse/PHPBB3-10117

+

+ $this->message = trim(preg_replace(explode(chr(0), '#(?<=^|[\n .])' . implode('(?![^<>]*>)#u' . chr(0) . '#(?<=^|[\n .])', $match) . '(?![^<>]*>)#u'), $replace, $this->message));

+ // Bot user, if they have a SID in the Request URI we need to get rid of it

+ // otherwise they'll index this page with the SID, duplicate content oh my!

+ if ($bot && isset($_GET['sid']))

+ {

+ redirect(build_url(array('sid')));

+ }

+

+ break;

+ if (!file_exists($filename) || @filesize($filename) === 0 || defined('DEBUG_EXTRA'))

+

+ // Create the correct logs

+ add_log('user', $user_row['user_id'], 'LOG_USER_ACTIVE_USER');

+ if ($auth->acl_get('a_user'))

+ {

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

+ }

+ 'S_PM_UNREAD' => ($row['pm_unread']) ? true : false,

+ 'U_ICQ' => ($user_info['user_icq']) ? 'http://www.icq.com/people' . urlencode($user_info['user_icq']) . '/' : '',

+ 'lang' => array('language_iso_name'),

+ if (!validate_language_iso_name($use_lang))

+ 'lang' => array('language_iso_name'),

+ 'default_dateformat' => 'phpbb_set_encoding(default_dateformat)',

+// Firebird update from Firebird 2.0 to 2.1+ required?

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

+

+ // Changes from 3.0.8 to 3.0.9-RC1

+ '3.0.8' => array(

+ 'change_columns' => array(

+ BBCODES_TABLE => array(

+ 'bbcode_id' => array('USINT', 0),

+ ),

+ ),

+ ),

+

+ // Changes from 3.0.8 to 3.0.9-RC1

+ case '3.0.8':

+ // Update file extension group names to use language strings, again.

+ $sql = 'SELECT group_id, group_name

+ FROM ' . EXTENSION_GROUPS_TABLE . '

+ WHERE group_name ' . $db->sql_like_expression('EXT_GROUP_' . $db->any_char);

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

+

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

+ {

+ $sql_ary = array(

+ 'group_name' => substr($row['group_name'], 10), // Strip off 'EXT_GROUP_'

+ );

+

+ $sql = 'UPDATE ' . EXTENSION_GROUPS_TABLE . '

+ SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

+ WHERE group_id = ' . $row['group_id'];

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

+ }

+ $db->sql_freeresult($result);

+

+ $no_updates = false;

+ break;

+ echo ' Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group';

+ // If we can't insert this user then continue to the next one to avoid inconsistent data

+ bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

+ bbcode_id number(4) DEFAULT '0' NOT NULL,

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

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('IMAGES', 1, 1, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('ARCHIVES', 0, 1, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('PLAIN_TEXT', 0, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOCUMENTS', 0, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('REAL_MEDIA', 3, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('WINDOWS_MEDIA', 2, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('FLASH_FILES', 5, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('QUICKTIME_MEDIA', 6, 0, 1, '', 0, '');

+INSERT INTO phpbb_extension_groups (group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, allowed_forums) VALUES ('DOWNLOADABLE_FILES', 0, 0, 1, '', 0, '');

+ bbcode_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

+

+ 'MAIL_BANNED' => 'Mail banned users',

+ 'MAIL_BANNED_EXPLAIN' => 'When sending a mass e-mail to a group you can select here whether banned users will also receive the e-mail.',

+

+ 'SMILIE_NO_CODE' => 'The smiley “%s” was ignored, as there was no code entered.',

+ 'SMILIE_NO_EMOTION' => 'The smiley “%s” was ignored, as there was no emotion entered.',

+ 'SMILIE_NO_FILE' => 'The smiley “%s” was ignored, as the file is missing.',

+ 'ACP_DISALLOW_EXPLAIN' => 'Here you can control usernames which will not be allowed to be used. Disallowed usernames are allowed to contain a wildcard character of *.',

+ 'DISALLOWED_ALREADY' => 'The name you entered is already disallowed.',

+ 'DELETE_STYLE_EXPLAIN' => 'Here you can remove the selected style. Take care in deleting styles, there is no undo capability.',

+ 'KEEP_IMAGESET' => 'Keep "%s" imageset',

+ 'KEEP_TEMPLATE' => 'Keep "%s" template',

+ 'KEEP_THEME' => 'Keep "%s" theme',

+

+ 'REPLACE_WITH_OPTION' => 'Replace with "%s"',

+ 'FORUMS_MARKED' => 'The selected forums have been marked read.',

+ 'MARK_SUBFORUMS_READ' => 'Mark subforums read',

+ 'DB_HOST_EXPLAIN' => 'DSN stands for Data Source Name and is relevant only for ODBC installs. On PostgreSQL, use localhost to connect to the local server via UNIX domain socket and 127.0.0.1 to connect via TCP. For SQLite, enter the full path to your database file.',

+ 'PHP_URL_FOPEN_SUPPORT_EXPLAIN' => '<strong>Optional</strong> - This setting is optional, however certain phpBB functions like off-site avatars will not work properly without it.',

+

+ if (isset($find_key_match[$joined_select]) && sizeof($joined) == 3)

+ {

+ // Before PHP 5.1 an error value -1 can be returned instead of false.

+ // Theoretically gmmktime() can also legitimately return -1 as an actual timestamp.

+ // But since we do not pass the $second parameter to gmmktime(),

+ // an actual unix timestamp -1 cannot be returned in this case.

+ // Thus we can check whether it is -1 and treat -1 as an error.

+ $joined_time = gmmktime(0, 0, 0, (int) $joined[1], (int) $joined[2], (int) $joined[0]);

+

+ if ($joined_time !== false && $joined_time !== -1)

+ {

+ $sql_where .= " AND u.user_regdate " . $find_key_match[$joined_select] . ' ' . $joined_time;

+ }

+ }

+

+ if (isset($find_key_match[$active_select]) && sizeof($active) == 3 && $auth->acl_get('u_viewonline'))

+ {

+ $active_time = gmmktime(0, 0, 0, (int) $active[1], (int) $active[2], (int) $active[0]);

+

+ if ($active_time !== false && $active_time !== -1)

+ {

+ $sql_where .= " AND u.user_lastvisit " . $find_key_match[$active_select] . ' ' . $active_time;

+ }

+ }

+

+ 'U_ICQ' => ($data['user_icq']) ? 'http://www.icq.com/people/' . urlencode($data['user_icq']) . '/' : '',

+// Page title & action URL

+$s_action = append_sid("{$phpbb_root_path}posting.$phpEx", "mode=$mode&amp;f=$forum_id");

+ <object id="qtstream_{_file.ATTACH_ID}" classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0" width="320" height="285">

+ <embed name="qtstream_{_file.ATTACH_ID}" src="{_file.U_DOWNLOAD_LINK}" pluginspage="http://www.apple.com/quicktime/download/" enablejavascript="true" controller="true" width="320" height="285" type="video/quicktime" autoplay="false"></embed>

+ onload_functions.push('document.getElementById("<!-- IF S_ADMIN_AUTH -->{PASSWORD_CREDENTIAL}<!-- ELSE -->{USERNAME_CREDENTIAL}<!-- ENDIF -->").focus();');

+ <input class="button2" type="submit" value="{L_DISAPPROVE}" name="action[disapprove]" /> &nbsp;

+ <input class="button1" type="submit" value="{L_APPROVE}" name="action[approve]" />

+ <dd><a href="http://www.aim.com">{L_IM_DOWNLOAD_APP}</a> | <a href="http://www.aim.com/products/express">{L_IM_AIM_EXPRESS}</a></dd>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/forum_fn.js"></script>

+ <div class="copyright">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group

+ <!-- IF S_USER_PM_POPUP and S_NEW_PM -->

+ var url = '{UA_POPUP_PM}';

+ window.open(url.replace(/&amp;/g, '&'), '_phpbbprivmsg', 'height=225,resizable=yes,scrollbars=yes, width=400');

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/styleswitcher.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/forum_fn.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+ <div class="copyright">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/styleswitcher.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/forum_fn.js"></script>

+ <!-- IF S_PENDING_SET -->

+ <td colspan="2" align="center"><span class="gensmall">Powered by phpBB &copy; phpBB Group<br />http://www.phpbb.com/</span></td>

+ <li class="rightside"><a href="{U_MARK_FORUMS}">{L_MARK_SUBFORUMS_READ}</a></li>

+ <div class="copyright">Powered by phpBB &copy; phpBB Group<br />http://www.phpbb.com/</div>

+.pagination span a, .pagination span a:link, .pagination span a:visited {

+.pagination span a:active {

+ color: #5C758C;

+ background-color: #ECEDEE;

+ border-color: #B4BAC0;

+}

+

+.signature a, .signature a:visited, .signature a:hover, .signature a:active {

+.postprofile a:link, .postprofile a:visited, .postprofile dt.author a {

+.postprofile a:active {

+ color: #105289;

+}

+

+ background-image: url("{IMG_ICON_USER_ONLINE_SRC}");

+.signature a, .signature a:visited, .signature a:hover, .signature a:active {

+.postprofile a:link, .postprofile a:visited, .postprofile dt.author a {

+/* CSS spec requires a:link, a:visited, a:hover and a:active rules to be specified in this order. */

+/* See http://www.phpbb.com/bugs/phpbb3/59685 */

+.postprofile a:active {

+ font-weight: bold;

+ color: #898989;

+ text-decoration: none;

+}

+

+.postbody a:link, .postbody a:visited, .postbody a:hover, .postbody a:active {

+dl.codebox dt { display: none; }

+

+/* Headerbar height fix for IE7 and below */

+* html #site-description p {

+ margin-bottom: 1.0em;

+}

+

+*:first-child+html #site-description p {

+ margin-bottom: 1.0em;

+} \ No newline at end of file

+ <object id="qtstream_{_file.ATTACH_ID}" classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0" width="320" height="285">

+ <embed name="qtstream_{_file.ATTACH_ID}" src="{_file.U_DOWNLOAD_LINK}" pluginspage="http://www.apple.com/quicktime/download/" enablejavascript="true" controller="true" width="320" height="285" type="video/quicktime" autoplay="false">

+ var elements = document.getElementsByName("<!-- IF S_ADMIN_AUTH -->{PASSWORD_CREDENTIAL}<!-- ELSE -->{USERNAME_CREDENTIAL}<!-- ENDIF -->");

+ <td class="row1" colspan="2" align="center"><br /><a class="gen" href="{U_AIM_CONTACT}">{L_IM_ADD_CONTACT}</a><br /><a class="gen" href="{U_AIM_MESSAGE}">{L_IM_SEND_MESSAGE}</a><br /><br /><a class="gensmall" href="http://www.aim.com">{L_IM_DOWNLOAD_APP}</a> | <a class="gensmall" href="http://www.aim.com/products/express">{L_IM_AIM_EXPRESS}</a> </td>

+ <span class="copyright">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group

+<!-- IF S_USER_PM_POPUP and S_NEW_PM -->

+ popup('{UA_POPUP_PM}', 400, 225, '_phpbbprivmsg');

+ <script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+<script type="text/javascript" src="{T_SUPER_TEMPLATE_PATH}/editor.js"></script>

+ <span class="copyright">Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group</span>

+ <td colspan="2" align="center"><span class="gensmall">Powered by phpBB &copy; phpBB Group<br />http://www.phpbb.com/</span></td>

+ <td colspan="2" align="center"><span class="gensmall">Powered by phpBB &copy; phpBB Group<br />http://www.phpbb.com/</span></td>

+.postreported, .postreported a:link, .postreported a:visited, .postreported a:hover, .postreported a:active {

+.postapprove, .postapprove a:link, .postapprove a:visited, .postapprove a:hover, .postapprove a:active {

+/* CSS spec requires a:link, a:visited, a:hover and a:active rules to be specified in this order. */

+/* See http://www.phpbb.com/bugs/phpbb3/59685 */

+a:active {

+ color: #005784;

+ text-decoration: none;

+}

+

+}

+ $user_cache[$poster_id]['icq'] = 'http://www.icq.com/people/' . urlencode($row['user_icq']) . '/';

+ 'POST_NUMBER' => $i + $start + 1,