+ return (isset($this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]][$field])) ? $this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]++][$field] : false;

+ global $acm_type;

+

+ return (isset($this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]][$field])) ? $this->sql_rowset[$query_id][$this->sql_row_pointer[$query_id]++][$field] : false;

+ 'img_max_thumb_width' => array('lang' => 'MAX_THUMB_WIDTH', 'validate' => 'int', 'type' => 'text:7:15', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),

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

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

+ $warn_text = preg_match('%<[^>]*\{text[\d]*\}[^>]*>%i', $bbcode_tpl);

+ if (!$warn_text || confirm_box(true))

+ {

+ $data = $this->build_regexp($bbcode_match, $bbcode_tpl);

+ // Make sure the user didn't pick a "bad" name for the BBCode tag.

+ $hard_coded = array('code', 'quote', 'quote=', 'attachment', 'attachment=', 'b', 'i', 'url', 'url=', 'img', 'size', 'size=', 'color', 'color=', 'u', 'list', 'list=', 'email', 'email=', 'flash', 'flash=');

+ if (($action == 'modify' && strtolower($data['bbcode_tag']) !== strtolower($row['bbcode_tag'])) || ($action == 'create'))

+ $sql = 'SELECT 1 as test

+ FROM ' . BBCODES_TABLE . "

+ WHERE LOWER(bbcode_tag) = '" . $db->sql_escape(strtolower($data['bbcode_tag'])) . "'";

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

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

+ $db->sql_freeresult($result);

+

+ // Grab the end, interrogate the last closing tag

+ if ($info['test'] === '1' || in_array(strtolower($data['bbcode_tag']), $hard_coded) || (preg_match('#\[/([^[]*)]$#', $bbcode_match, $regs) && in_array(strtolower($regs[1]), $hard_coded)))

+ {

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

+ }

+ if (substr($data['bbcode_tag'], -1) === '=')

+ {

+ $test = substr($data['bbcode_tag'], 0, -1);

+ }

+ else

+ {

+ $test = $data['bbcode_tag'];

+ }

+ if (!preg_match('%\\[' . $test . '[^]]*].*?\\[/' . $test . ']%s', $bbcode_match))

+ {

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

+ }

+ if (strlen($data['bbcode_tag']) > 16)

+ {

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

+ }

+ if (strlen($bbcode_match) > 4000)

+ {

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

+ }

+ if (strlen($bbcode_helpline) > 255)

+ {

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

+ }

+ $sql_ary = array(

+ 'bbcode_tag' => $data['bbcode_tag'],

+ 'bbcode_match' => $bbcode_match,

+ 'bbcode_tpl' => $bbcode_tpl,

+ 'display_on_posting' => $display_on_posting,

+ 'bbcode_helpline' => $bbcode_helpline,

+ 'first_pass_match' => $data['first_pass_match'],

+ 'first_pass_replace' => $data['first_pass_replace'],

+ 'second_pass_match' => $data['second_pass_match'],

+ 'second_pass_replace' => $data['second_pass_replace']

+ );

+

+ if ($action == 'create')

+ $sql = 'SELECT MAX(bbcode_id) as max_bbcode_id

+ FROM ' . BBCODES_TABLE;

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

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

+ $db->sql_freeresult($result);

+

+ if ($row)

+ {

+ $bbcode_id = $row['max_bbcode_id'] + 1;

+ // Make sure it is greater than the core bbcode ids...

+ if ($bbcode_id <= NUM_CORE_BBCODES)

+ {

+ $bbcode_id = NUM_CORE_BBCODES + 1;

+ }

+ }

+ else

+

+ if ($bbcode_id > 1511)

+ {

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

+ }

+

+ $sql_ary['bbcode_id'] = (int) $bbcode_id;

+

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

+ $cache->destroy('sql', BBCODES_TABLE);

+

+ $lang = 'BBCODE_ADDED';

+ $log_action = 'LOG_BBCODE_ADD';

+ $sql = 'UPDATE ' . BBCODES_TABLE . '

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

+ WHERE bbcode_id = ' . $bbcode_id;

+ $db->sql_query($sql);

+ $cache->destroy('sql', BBCODES_TABLE);

+ $lang = 'BBCODE_EDITED';

+ $log_action = 'LOG_BBCODE_EDIT';

+ add_log('admin', $log_action, $data['bbcode_tag']);

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

+ confirm_box(false, $user->lang['BBCODE_DANGER'], build_hidden_fields(array(

+ 'action' => $action,

+ 'bbcode' => $bbcode_id,

+ 'bbcode_match' => $bbcode_match,

+ 'bbcode_tpl' => htmlspecialchars($bbcode_tpl),

+ 'bbcode_helpline' => $bbcode_helpline,

+ 'display_on_posting' => $display_on_posting,

+ ))

+ , 'confirm_bbcode.html');

+ $utf8 = strpos($bbcode_match, 'INTTEXT') !== false;

+

+ // make sure we have utf8 support

+ $utf8_pcre_properties = false;

+ if (version_compare(PHP_VERSION, '5.1.0', '>=') || (version_compare(PHP_VERSION, '5.0.0-dev', '<=') && version_compare(PHP_VERSION, '4.4.0', '>=')))

+ {

+ // While this is the proper range of PHP versions, PHP may not be linked with the bundled PCRE lib and instead with an older version

+ if (@preg_match('/\p{L}/u', 'a') !== false)

+ {

+ $utf8_pcre_properties = true;

+ }

+ }

+ 'INTTEXT' => array(

+ ($utf8_pcre_properties) ? '!([\p{L}\p{N}\-+,_. ]+)!u' : '!([a-zA-Z0-9\-+,_. ]+)!u' => "$1"

+ ),

+ 'INTTEXT' => ($utf8_pcre_properties) ? '([\p{L}\p{N}\-+,_. ]+)' : '([a-zA-Z0-9\-+,_. ]+)',

+ $modifiers .= ($utf8 && $utf8_pcre_properties) ? 'u' : '';

+ $sp_match = '!' . $sp_match . '!s' . (($utf8) ? 'u' : '');

+ global $cache;

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

+ 'allow_quick_reply' => array('lang' => 'ALLOW_QUICK_REPLY', 'validate' => 'bool', 'type' => 'custom', 'method' => 'quick_reply', 'explain' => true),

+ 'allow_quick_reply' => array('lang' => 'ALLOW_QUICK_REPLY', 'validate' => 'bool', 'type' => 'custom', 'method' => 'quick_reply', 'explain' => true),

+ 'feed_http_auth' => array('lang' => 'ACP_FEED_HTTP_AUTH', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true),

+

+ 'legend2' => 'ACP_FEED_POST_BASED',

+ 'feed_limit_post' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => true),

+ 'feed_overall' => array('lang' => 'ACP_FEED_OVERALL', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+

+ 'legend3' => 'ACP_FEED_TOPIC_BASED',

+ 'feed_limit_topic' => array('lang' => 'ACP_FEED_LIMIT', 'validate' => 'int:5', 'type' => 'text:3:4', 'explain' => true),

+ 'feed_topics_new' => array('lang' => 'ACP_FEED_TOPICS_NEW', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+ 'feed_topics_active' => array('lang' => 'ACP_FEED_TOPICS_ACTIVE', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+

+ 'legend4' => 'ACP_FEED_SETTINGS_OTHER',

+ 'feed_overall_forums' => array('lang' => 'ACP_FEED_OVERALL_FORUMS', 'validate' => 'bool', 'type' => 'radio:enabled_disabled', 'explain' => true ),

+

+ if ($config_name == 'allow_quick_reply' && isset($_POST['allow_quick_reply_enable']))

+ {

+ enable_bitfield_column_flag(FORUMS_TABLE, 'forum_flags', log(FORUM_FLAG_QUICK_REPLY, 2));

+ }

+ $cache->destroy('_feed_news_forum_ids');

+ $cache->destroy('_feed_excluded_forum_ids');

+

+ * Global quick reply enable/disable setting and button to enable in all forums

+ */

+ function quick_reply($value, $key)

+ {

+ global $user;

+

+ $radio_ary = array(1 => 'YES', 0 => 'NO');

+

+ return h_radio('config[allow_quick_reply]', $radio_ary, $value) .

+ '<br /><br /><input class="button2" type="submit" id="' . $key . '_enable" name="' . $key . '_enable" value="' . $user->lang['ALLOW_QUICK_REPLY_BUTTON'] . '" />';

+ }

+

+

+ /**

+ $forum_list = make_forum_select(false, false, true, true, true, false, true);

+ 'max_login_attempts' => array('tpl' => 'MAX_LOGIN_ATTEMPTS', 'default' => 0),

+ case 'mssqlnative':

+ case 'mssqlnative':

+ $backup_files[(int) $matches[1]] = $file;

+ 'NAME' => $user->format_date($name, 'd-m-Y H:i:s', true),

+ else if($db->sql_layer === 'mssqlnative')

+ {

+ $this->write_data_mssqlnative($table_name);

+ }

+

+ function write_data_mssqlnative($table_name)

+ {

+ global $db;

+ $ary_type = $ary_name = $meta_array = array();

+ $ident_set = false;

+ $sql_data = '';

+

+ // Grab all of the data from current table.

+ $sql = "SELECT * FROM $table_name";

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

+

+ $retrieved_data = $db->mssqlnative_num_rows($result);

+

+ $meta_array = sqlsrv_field_metadata($result);

+ $i_num_fields = sqlsrv_num_fields($result);

+

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

+ {

+ $info = $db->mssqlnative_fieldInfo($table_name, $meta_array[$i]['Name']);

+ $ary_type[$i] = $info->type();

+ $ary_name[$i] = $info->name();

+ }

+

+ if ($retrieved_data)

+ {

+ $sql = "SELECT 1 as has_identity

+ FROM INFORMATION_SCHEMA.COLUMNS

+ WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

+ $row2 = $db->sql_fetchrow($result2);

+

+ if (!empty($row2['has_identity']))

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

+ $ident_set = true;

+ }

+ $db->sql_freeresult($result2);

+ }

+

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

+ {

+ $schema_vals = $schema_fields = array();

+ // Build the SQL statement to recreate the data.

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

+ {

+ $str_val = $row[$ary_name[$i]];

+

+ if (preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

+ {

+ $str_quote = '';

+ $str_empty = "''";

+ $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

+ }

+ else if (preg_match('#date|timestamp#i', $ary_type[$i]))

+ {

+ if (empty($str_val))

+ {

+ $str_quote = '';

+ }

+ else

+ {

+ $str_quote = "'";

+ }

+ }

+ else

+ {

+ $str_quote = '';

+ $str_empty = 'NULL';

+ }

+

+ if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

+ {

+ $str_val = $str_empty;

+ }

+

+ $schema_vals[$i] = $str_quote . $str_val . $str_quote;

+ $schema_fields[$i] = $ary_name[$i];

+ }

+

+ // Take the ordered fields and their associated data and build it

+ // into a valid sql statement to recreate that field in the data.

+ $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

+

+ $this->flush($sql_data);

+ $sql_data = '';

+ }

+ $db->sql_freeresult($result);

+

+ if ($retrieved_data && $ident_set)

+ {

+ $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

+ }

+ $this->flush($sql_data);

+ }

+

+ $sql = "SELECT COUNT(*) AS item_count

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

+

+ if (!is_dir($phpbb_root_path . 'language/' . $file))

+ {

+ continue;

+ }

+

+ if ($auth->acl_get('a_server') && version_compare(PHP_VERSION, '5.2.0', '<'))

+ {

+ $template->assign_vars(array(

+ 'S_PHP_VERSION_OLD' => true,

+ 'L_PHP_VERSION_OLD' => sprintf($user->lang['PHP_VERSION_OLD'], '<a href="http://www.phpbb.com/community/viewtopic.php?f=14&amp;t=1958605">', '</a>'),

+ ));

+ }

+

+ if (!is_dir($phpbb_root_path . 'styles/' . $file))

+ {

+ continue;

+ }

+

+ $show_captcha = $config['max_login_attempts'] && $row['user_login_attempts'] >= $config['max_login_attempts'];

+ if ($show_captcha)

+ if (!class_exists('phpbb_captcha_factory'))

+ {

+ global $phpbb_root_path, $phpEx;

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

+ }

+ $vc_response = $captcha->validate($row);

+ else

+ {

+ $captcha->reset();

+ }

+ 'status' => ($show_captcha) ? LOGIN_ERROR_ATTEMPTS : LOGIN_ERROR_PASSWORD,

+ 'error_msg' => ($show_captcha) ? 'LOGIN_ERROR_ATTEMPTS' : 'LOGIN_ERROR_PASSWORD',

+ if (isset($user->theme['template_inherits_id']) && $user->theme['template_inherits_id'])

+ if (preg_match_all('/\{(URL|LOCAL_URL|EMAIL|TEXT|SIMPLETEXT|INTTEXT|IDENTIFIER|COLOR|NUMBER)[0-9]*\}/', $rowset[$bbcode_id]['bbcode_match'], $m))

+ $unicode = ((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;

+

+ if ($unicode)

+ case 'mssqlnative':

+ if (empty($user->lang))

+ {

+ $user->setup();

+ }

+

+

+ // okay, if there is a confirm_id, we try to load that confirm's state. If not, we try to find one

+ if (!$this->load_answer() && (!$this->load_confirm_id() || !$this->load_answer()))

+ $sql = 'SELECT COUNT(question_id) AS question_count

+ return ((bool) $row['question_count']);

+ global $config, $db, $template;

+

+ if ($this->is_available())

+ {

+ $sql = 'SELECT question_text

+ FROM ' . CAPTCHA_QUESTIONS_TABLE . "

+ WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

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

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

+ {

+ $template->assign_vars(array(

+ 'QA_CONFIRM_QUESTION' => $row['question_text'],

+ ));

+ }

+ $db->sql_freeresult($result);

+ }

+ function garbage_collect($type = 0)

+ $sql = 'SELECT c.confirm_id

+ $sql_in[] = (string) $row['confirm_id'];

+ WHERE ' . $db->sql_in_set('confirm_id', $sql_in);

+

+ /**

+ * See if there is already an entry for the current session.

+ */

+ function load_confirm_id()

+ {

+ global $db, $user;

+

+ $sql = 'SELECT confirm_id

+ FROM ' . CAPTCHA_QA_CONFIRM_TABLE . "

+ WHERE

+ session_id = '" . $db->sql_escape($user->session_id) . "'

+ AND lang_iso = '" . $db->sql_escape($this->question_lang) . "'

+ AND confirm_type = " . $this->type;

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

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

+ $db->sql_freeresult($result);

+

+ if ($row)

+ {

+ $this->confirm_id = $row['confirm_id'];

+ return true;

+ }

+ return false;

+ }

+

+ if (!strlen($this->confirm_id) || !sizeof($this->question_ids))

+ if ($this->get_class_name() !== $config['captcha_plugin'] || !$this->acp_is_last($question_id))

+ if (confirm_box(true))

+ {

+ $this->acp_delete_question($question_id);

+ trigger_error($user->lang['QUESTION_DELETED'] . adm_back_link($list_url));

+ }

+ else

+ {

+ confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields(array(

+ 'question_id' => $question_id,

+ 'action' => $action,

+ 'configure' => 1,

+ 'select_captcha' => $this->get_class_name(),

+ ))

+ );

+ }

+ trigger_error($user->lang['QA_LAST_QUESTION'] . adm_back_link($list_url), E_USER_WARNING);

+ trigger_error($user->lang['FORM_INVALID'] . adm_back_link($list_url), E_USER_WARNING);

+

+

+

+ /**

+ * See if there is a question other than the one we have

+ */

+ function acp_is_last($question_id)

+ {

+ global $config, $db;

+

+ if ($question_id)

+ {

+ $sql = 'SELECT question_id

+ FROM ' . CAPTCHA_QUESTIONS_TABLE . "

+ WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'

+ AND question_id <> " . (int) $question_id;

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

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

+ $db->sql_freeresult($result);

+

+ if (!$question)

+ {

+ return true;

+ }

+ return false;

+ }

+ }

+ var $recaptcha_server_secure = 'https://api-secure.recaptcha.net'; // class constants :(

+ // PHP4 Constructor

+ function phpbb_recaptcha()

+ {

+ $this->recaptcha_server = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? $this->recaptcha_server_secure : $this->recaptcha_server;

+ }

+

+define('PHPBB_VERSION', '3.0.7');

+ 'mssqlnative' => array(

+ 'INT:' => '[int]',

+ 'BINT' => '[float]',

+ 'UINT' => '[int]',

+ 'UINT:' => '[int]',

+ 'TINT:' => '[int]',

+ 'USINT' => '[int]',

+ 'BOOL' => '[int]',

+ 'VCHAR' => '[varchar] (255)',

+ 'VCHAR:' => '[varchar] (%d)',

+ 'CHAR:' => '[char] (%d)',

+ 'XSTEXT' => '[varchar] (1000)',

+ 'STEXT' => '[varchar] (3000)',

+ 'TEXT' => '[varchar] (8000)',

+ 'MTEXT' => '[text]',

+ 'XSTEXT_UNI'=> '[varchar] (100)',

+ 'STEXT_UNI' => '[varchar] (255)',

+ 'TEXT_UNI' => '[varchar] (4000)',

+ 'MTEXT_UNI' => '[text]',

+ 'TIMESTAMP' => '[int]',

+ 'DECIMAL' => '[float]',

+ 'DECIMAL:' => '[float]',

+ 'PDECIMAL' => '[float]',

+ 'PDECIMAL:' => '[float]',

+ 'VCHAR_UNI' => '[varchar] (255)',

+ 'VCHAR_UNI:'=> '[varchar] (%d)',

+ 'VCHAR_CI' => '[varchar] (255)',

+ 'VARBINARY' => '[varchar] (255)',

+ ),

+

+ var $supported_dbms = array('firebird', 'mssql', 'mssqlnative', 'mysql_40', 'mysql_41', 'oracle', 'postgres', 'sqlite');

+ case 'mssqlnative':

+ $this->sql_layer = 'mssqlnative';

+ break;

+

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ if (version_compare($this->db->sql_server_info(true), '8.0', '>='))

+ {

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type_sql'];

+ }

+ else

+ {

+ // old versions cannot add columns with default and null information

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ADD COLUMN "' . $column_name . '" ' . $column_data['column_type'] . ' ' . $column_data['constraint'];

+

+ if (isset($column_data['null']))

+ {

+ if ($column_data['null'] == 'NOT NULL')

+ {

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' SET NOT NULL';

+ }

+ }

+

+ if (isset($column_data['default']))

+ {

+ $statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN ' . $column_name . ' SET DEFAULT ' . $column_data['default'];

+ }

+ }

+

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ case 'mssqlnative':

+ if ($this->sql_layer == 'mssql' || $this->sql_layer == 'mssqlnative')

+ case 'mssqlnative':

+ * Run binary OR operator on DB column.

+ * Results in sql statement: "{$column_name} | (1 << {$bit}) {$compare}"

+ *

+ * @param string $column_name The column name to use

+ * @param int $bit The value to use for the OR operator, will be converted to (1 << $bit). Is used by options, using the number schema... 0, 1, 2...29

+ * @param string $compare Any custom SQL code after the check (for example "= 0")

+ */

+ function sql_bit_or($column_name, $bit, $compare = '')

+ {

+ if (method_exists($this, '_sql_bit_or'))

+ {

+ return $this->_sql_bit_or($column_name, $bit, $compare);

+ }

+

+ return $column_name . ' | ' . (1 << $bit) . (($compare) ? ' ' . $compare : '');

+ }

+

+ /**

+ function _sql_bit_or($column_name, $bit, $compare = '')

+ {

+ return 'BIN_OR(' . $column_name . ', ' . (1 << $bit) . ')' . (($compare) ? ' ' . $compare : '');

+ }

+

+<?php

+/**

+*

+* @package dbal

+* @version $Id$

+* @copyright (c) 2010 phpBB Group

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

+*

+* This is the MS SQL Server Native database abstraction layer.

+* PHP mssql native driver required.

+* @author Chris Pucci

+*

+*/

+

+/**

+* @ignore

+*/

+if (!defined('IN_PHPBB'))

+{

+ exit;

+}

+

+include_once($phpbb_root_path . 'includes/db/dbal.' . $phpEx);

+

+/**

+ * Prior to version 1.1 the SQL Server Native PHP driver didn't support sqlsrv_num_rows, or cursor based seeking so we recall all rows into an array

+ * and maintain our own cursor index into that array.

+ */

+class result_mssqlnative

+{

+ public function result_mssqlnative($queryresult = false)

+ {

+ $this->m_cursor = 0;

+ $this->m_rows = array();

+ $this->m_num_fields = sqlsrv_num_fields($queryresult);

+ $this->m_field_meta = sqlsrv_field_metadata($queryresult);

+

+ while ($row = sqlsrv_fetch_array($queryresult, SQLSRV_FETCH_ASSOC))

+ {

+ if ($row !== null)

+ {

+ foreach($row as $k => $v)

+ {

+ if (is_object($v) && method_exists($v, 'format'))

+ {

+ $row[$k] = $v->format("Y-m-d\TH:i:s\Z");

+ }

+ }

+ $this->m_rows[] = $row;//read results into memory, cursors are not supported

+ }

+ }

+

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

+ sqlsrv_free_stmt($queryresult);

+ }

+

+ private function array_to_obj($array, &$obj)

+ {

+ foreach ($array as $key => $value)

+ {

+ if (is_array($value))

+ {

+ $obj->$key = new stdClass();

+ array_to_obj($value, $obj->$key);

+ }

+ else

+ {

+ $obj->$key = $value;

+ }

+ }

+ return $obj;

+ }

+

+ public function fetch($mode = SQLSRV_FETCH_BOTH, $object_class = 'stdClass')

+ {

+ if ($this->m_cursor >= $this->m_row_count || $this->m_row_count == 0)

+ {

+ return false;

+ }

+

+ $ret = false;

+ $arr_num = array();

+

+ if ($mode == SQLSRV_FETCH_NUMERIC || $mode == SQLSRV_FETCH_BOTH)

+ {

+ foreach($this->m_rows[$this->m_cursor] as $key => $value)

+ {

+ $arr_num[] = $value;

+ }

+ }

+

+ switch ($mode)

+ {

+ case SQLSRV_FETCH_ASSOC:

+ $ret = $this->m_rows[$this->m_cursor];

+ break;

+ case SQLSRV_FETCH_NUMERIC:

+ $ret = $arr_num;

+ break;

+ case 'OBJECT':

+ $ret = $this->array_to_obj($this->m_rows[$this->m_cursor], $o = new $object_class);

+ break;

+ case SQLSRV_FETCH_BOTH:

+ default:

+ $ret = $this->m_rows[$this->m_cursor] + $arr_num;

+ break;

+ }

+ $this->m_cursor++;

+ return $ret;

+ }

+

+ public function get($pos, $fld)

+ {

+ return $this->m_rows[$pos][$fld];

+ }

+

+ public function num_rows()

+ {

+ return $this->m_row_count;

+ }

+

+ public function seek($iRow)

+ {

+ $this->m_cursor = min($iRow, $this->m_row_count);

+ }

+

+ public function num_fields()

+ {

+ return $this->m_num_fields;

+ }

+

+ public function field_name($nr)

+ {

+ $arr_keys = array_keys($this->m_rows[0]);

+ return $arr_keys[$nr];

+ }

+

+ public function field_type($nr)

+ {

+ $i = 0;

+ $int_type = -1;

+ $str_type = '';

+

+ foreach ($this->m_field_meta as $meta)

+ {

+ if ($nr == $i)

+ {

+ $int_type = $meta['Type'];

+ break;

+ }

+ $i++;

+ }

+

+ //http://msdn.microsoft.com/en-us/library/cc296183.aspx contains type table

+ switch ($int_type)

+ {

+ case SQLSRV_SQLTYPE_BIGINT: $str_type = 'bigint'; break;

+ case SQLSRV_SQLTYPE_BINARY: $str_type = 'binary'; break;

+ case SQLSRV_SQLTYPE_BIT: $str_type = 'bit'; break;

+ case SQLSRV_SQLTYPE_CHAR: $str_type = 'char'; break;

+ case SQLSRV_SQLTYPE_DATETIME: $str_type = 'datetime'; break;

+ case SQLSRV_SQLTYPE_DECIMAL/*($precision, $scale)*/: $str_type = 'decimal'; break;

+ case SQLSRV_SQLTYPE_FLOAT: $str_type = 'float'; break;

+ case SQLSRV_SQLTYPE_IMAGE: $str_type = 'image'; break;

+ case SQLSRV_SQLTYPE_INT: $str_type = 'int'; break;

+ case SQLSRV_SQLTYPE_MONEY: $str_type = 'money'; break;

+ case SQLSRV_SQLTYPE_NCHAR/*($charCount)*/: $str_type = 'nchar'; break;

+ case SQLSRV_SQLTYPE_NUMERIC/*($precision, $scale)*/: $str_type = 'numeric'; break;

+ case SQLSRV_SQLTYPE_NVARCHAR/*($charCount)*/: $str_type = 'nvarchar'; break;

+ case SQLSRV_SQLTYPE_NTEXT: $str_type = 'ntext'; break;

+ case SQLSRV_SQLTYPE_REAL: $str_type = 'real'; break;

+ case SQLSRV_SQLTYPE_SMALLDATETIME: $str_type = 'smalldatetime'; break;

+ case SQLSRV_SQLTYPE_SMALLINT: $str_type = 'smallint'; break;

+ case SQLSRV_SQLTYPE_SMALLMONEY: $str_type = 'smallmoney'; break;

+ case SQLSRV_SQLTYPE_TEXT: $str_type = 'text'; break;

+ case SQLSRV_SQLTYPE_TIMESTAMP: $str_type = 'timestamp'; break;

+ case SQLSRV_SQLTYPE_TINYINT: $str_type = 'tinyint'; break;

+ case SQLSRV_SQLTYPE_UNIQUEIDENTIFIER: $str_type = 'uniqueidentifier'; break;

+ case SQLSRV_SQLTYPE_UDT: $str_type = 'UDT'; break;

+ case SQLSRV_SQLTYPE_VARBINARY/*($byteCount)*/: $str_type = 'varbinary'; break;

+ case SQLSRV_SQLTYPE_VARCHAR/*($charCount)*/: $str_type = 'varchar'; break;

+ case SQLSRV_SQLTYPE_XML: $str_type = 'xml'; break;

+ default: $str_type = $int_type;

+ }

+ return $str_type;

+ }

+

+ public function free()

+ {

+ unset($this->m_rows);

+ return;

+ }

+}

+

+/**

+* @package dbal

+*/

+class dbal_mssqlnative extends dbal

+{

+ var $m_insert_id = NULL;

+ var $last_query_text = '';

+

+ /**

+ * Connect to server

+ */

+ function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)

+ {

+ # Test for driver support, to avoid suppressed fatal error

+ if (!function_exists('sqlsrv_connect'))

+ {

+ trigger_error('Native MS SQL Server driver for PHP is missing or needs to be updated. Version 1.1 or later is required to install phpBB3. You can download the driver from: http://www.microsoft.com/sqlserver/2005/en/us/PHP-Driver.aspx\n', E_USER_ERROR);

+ }

+

+ //set up connection variables

+ $this->persistency = $persistency;

+ $this->user = $sqluser;

+ $this->dbname = $database;

+ $port_delimiter = (defined('PHP_OS') && substr(PHP_OS, 0, 3) === 'WIN') ? ',' : ':';

+ $this->server = $sqlserver . (($port) ? $port_delimiter . $port : '');

+

+ //connect to database

+ error_reporting(E_ALL);

+ $this->db_connect_id = sqlsrv_connect($this->server, array(

+ 'Database' => $this->dbname,

+ 'UID' => $this->user,

+ 'PWD' => $sqlpassword

+ ));

+

+ return ($this->db_connect_id) ? $this->db_connect_id : $this->sql_error('');

+ }

+

+ /**

+ * Version information about used database

+ * @param bool $raw if true, only return the fetched sql_server_version

+ * @return string sql server version

+ */

+ function sql_server_info($raw = false)

+ {

+ global $cache;

+

+ if (empty($cache) || ($this->sql_server_version = $cache->get('mssql_version')) === false)

+ {

+ $arr_server_info = sqlsrv_server_info($this->db_connect_id);

+ $this->sql_server_version = $arr_server_info['SQLServerVersion'];

+

+ if (!empty($cache))

+ {

+ $cache->put('mssql_version', $this->sql_server_version);

+ }

+ }

+

+ if ($raw)

+ {

+ return $this->sql_server_version;

+ }

+

+ return ($this->sql_server_version) ? 'MSSQL<br />' . $this->sql_server_version : 'MSSQL';

+ }

+

+ /**

+ * SQL Transaction

+ * @access private

+ */

+ function _sql_transaction($status = 'begin')

+ {

+ switch ($status)

+ {

+ case 'begin':

+ return sqlsrv_begin_transaction($this->db_connect_id);

+ break;

+

+ case 'commit':

+ return sqlsrv_commit($this->db_connect_id);

+ break;

+

+ case 'rollback':

+ return sqlsrv_rollback($this->db_connect_id);

+ break;

+ }

+ return true;

+ }

+

+ /**

+ * Base query method

+ *

+ * @param string $query Contains the SQL query which shall be executed

+ * @param int $cache_ttl Either 0 to avoid caching or the time in seconds which the result shall be kept in cache

+ * @return mixed When casted to bool the returned value returns true on success and false on failure

+ *

+ * @access public

+ */

+ function sql_query($query = '', $cache_ttl = 0)

+ {

+ if ($query != '')

+ {

+ global $cache;

+

+ // EXPLAIN only in extra debug mode

+ if (defined('DEBUG_EXTRA'))

+ {

+ $this->sql_report('start', $query);

+ }

+

+ $this->last_query_text = $query;

+ $this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

+ $this->sql_add_num_queries($this->query_result);

+

+ if ($this->query_result === false)

+ {

+ if (($this->query_result = @sqlsrv_query($this->db_connect_id, $query)) === false)

+ {

+ $this->sql_error($query);

+ }

+

+ if (defined('DEBUG_EXTRA'))

+ {

+ $this->sql_report('stop', $query);

+ }

+

+ if ($cache_ttl && method_exists($cache, 'sql_save'))

+ {

+ $this->open_queries[(int) $this->query_result] = $this->query_result;

+ $cache->sql_save($query, $this->query_result, $cache_ttl);

+ }

+ else if (strpos($query, 'SELECT') === 0 && $this->query_result)

+ {

+ $this->open_queries[(int) $this->query_result] = $this->query_result;

+ }

+ }

+ else if (defined('DEBUG_EXTRA'))

+ {

+ $this->sql_report('fromcache', $query);

+ }

+ }

+ else

+ {

+ return false;

+ }

+ return $this->query_result;

+ }

+

+ /**

+ * Build LIMIT query

+ */

+ function _sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

+ {

+ $this->query_result = false;

+

+ if ($offset === false || $offset == 0)

+ {

+ if (strpos($query, "SELECT") === false)

+ {

+ $query = "TOP {$total} " . $query;

+ }

+ else

+ {

+ $query = preg_replace('/SELECT(\s*DISTINCT)?/Dsi', 'SELECT$1 TOP '.$total, $query);

+ }

+ }

+ else

+ {

+ $query = preg_replace('/SELECT(\s*DISTINCT)?/Dsi', 'SELECT$1 TOP(10000000) ', $query);

+ $query = 'SELECT *

+ FROM (SELECT sub2.*, ROW_NUMBER() OVER(ORDER BY sub2.line2) AS line3

+ FROM (SELECT 1 AS line2, sub1.* FROM (' . $query . ') AS sub1) as sub2) AS sub3

+ WHERE line3 BETWEEN ' . ($offset+1) . ' AND ' . ($offset + $total);

+ }

+

+ $result = $this->sql_query($query, $cache_ttl);

+

+ return $result;

+ }

+

+ /**

+ * Return number of affected rows

+ */

+ function sql_affectedrows()

+ {

+ return ($this->db_connect_id) ? @sqlsrv_rows_affected($this->db_connect_id) : false;

+ }

+

+ /**

+ * Fetch current row

+ */

+ function sql_fetchrow($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_fetchrow($query_id);

+ }

+

+ if ($query_id === false)

+ {

+ return false;

+ }

+

+ $row = @sqlsrv_fetch_array($query_id, SQLSRV_FETCH_ASSOC);

+

+ // I hope i am able to remove this later... hopefully only a PHP or MSSQL bug

+ if ($row)

+ {

+ foreach ($row as $key => $value)

+ {

+ $row[$key] = ($value === ' ' || $value === NULL) ? '' : $value;

+ }

+ }

+ return $row;

+ }

+

+ /**

+ * Seek to given row number

+ * rownum is zero-based

+ */

+ function sql_rowseek($rownum, &$query_id)

+ {

+ global $cache;

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_rowseek($rownum, $query_id);

+ }

+

+ $seek = new result_mssqlnative($query_id);

+ $row = $seek->seek($rownum);

+ return ($row = $seek->fetch()) ? $row : false;

+ }

+

+ /**

+ * Get last inserted id after insert statement

+ */

+ function sql_nextid()

+ {

+ $result_id = @sqlsrv_query($this->db_connect_id, 'SELECT @@IDENTITY');

+

+ if ($result_id !== false)

+ {

+ $row = @sqlsrv_fetch_array($result_id);

+ $id = $row[0];

+ @sqlsrv_free_stmt($result_id);

+ return $id;

+ }

+ else

+ {

+ return false;

+ }

+ }

+

+ /**

+ * Free sql result

+ */

+ function sql_freeresult($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

+ if (isset($cache->sql_rowset[$query_id]))

+ {

+ return $cache->sql_freeresult($query_id);

+ }

+

+ if (isset($this->open_queries[$query_id]))

+ {

+ unset($this->open_queries[$query_id]);

+ return @sqlsrv_free_stmt($query_id);

+ }

+ return false;

+ }

+

+ /**

+ * Escape string used in sql query

+ */

+ function sql_escape($msg)

+ {

+ return str_replace(array("'", "\0"), array("''", ''), $msg);

+ }

+

+ /**

+ * Build LIKE expression

+ * @access private

+ */

+ function _sql_like_expression($expression)

+ {

+ return $expression . " ESCAPE '\\'";

+ }

+

+ /**

+ * return sql error array

+ * @access private

+ */

+ function _sql_error()

+ {

+ $errors = @sqlsrv_errors(SQLSRV_ERR_ERRORS);

+ $error_message = '';

+

+ if ($errors != null)

+ {

+ foreach ($errors as $error)

+ {

+ $error_message .= "SQLSTATE: ".$error[ 'SQLSTATE']."\n";

+ $error_message .= "code: ".$error[ 'code']."\n";

+ $error_message .= "message: ".$error[ 'message']."\n";

+ }

+ $this->last_error_result = $error_message;

+ $error = $this->last_error_result;

+ }

+ else

+ {

+ $error = (isset($this->last_error_result) && $this->last_error_result) ? $this->last_error_result : array();

+ }

+ return $error;

+ }

+

+ /**

+ * Build db-specific query data

+ * @access private

+ */

+ function _sql_custom_build($stage, $data)

+ {

+ return $data;

+ }

+

+ /**

+ * Close sql connection

+ * @access private

+ */

+ function _sql_close()

+ {

+ return @sqlsrv_close($this->db_connect_id);

+ }

+

+ /**

+ * Build db-specific report

+ * @access private

+ */

+ function _sql_report($mode, $query = '')

+ {

+ switch ($mode)

+ {

+ case 'start':

+ $html_table = false;

+ @sqlsrv_query($this->db_connect_id, 'SET SHOWPLAN_TEXT ON;');

+ if ($result = @sqlsrv_query($this->db_connect_id, $query))

+ {

+ @sqlsrv_next_result($result);

+ while ($row = @sqlsrv_fetch_array($result))

+ {

+ $html_table = $this->sql_report('add_select_row', $query, $html_table, $row);

+ }

+ }

+ @sqlsrv_query($this->db_connect_id, 'SET SHOWPLAN_TEXT OFF;');

+ @sqlsrv_free_stmt($result);

+

+ if ($html_table)

+ {

+ $this->html_hold .= '</table>';

+ }

+ break;

+

+ case 'fromcache':

+ $endtime = explode(' ', microtime());

+ $endtime = $endtime[0] + $endtime[1];

+

+ $result = @sqlsrv_query($this->db_connect_id, $query);

+ while ($void = @sqlsrv_fetch_array($result))

+ {

+ // Take the time spent on parsing rows into account

+ }

+ @sqlsrv_free_stmt($result);

+

+ $splittime = explode(' ', microtime());

+ $splittime = $splittime[0] + $splittime[1];

+

+ $this->sql_report('record_fromcache', $query, $endtime, $splittime);

+

+ break;

+ }

+ }

+

+ /**

+ * Utility method used to retrieve number of rows

+ * Emulates mysql_num_rows

+ * Used in acp_database.php -> write_data_mssqlnative()

+ */

+ function mssqlnative_num_rows($res)

+ {

+ if ($res !== false)

+ {

+ $row = new result_mssqlnative($res);

+ $num_rows = $row->num_rows();

+ return $num_rows;

+ }

+ else

+ {

+ return false;

+ }

+ }

+}

+

+?> \ No newline at end of file

+ $this->db_connect_id = ($this->persistency) ? @mysql_pconnect($this->server, $this->user, $sqlpassword) : @mysql_connect($this->server, $this->user, $sqlpassword, $new_link);

+ function _sql_bit_or($column_name, $bit, $compare = '')

+ {

+ return 'BITOR(' . $column_name . ', ' . (1 << $bit) . ')' . (($compare) ? ' ' . $compare : '');

+ }

+

+ $rand_str = str_replace(array('0', 'O'), array('Z', 'Y'), strtoupper(base_convert($rand_str, 16, 34)));

+* @return string Unsigned Big Integer

+ return sprintf('%u', crc32(strtolower($email))) . strlen($email);

+ if (!$disable_cd_check && !file_exists($pathinfo['dirname']))

+ {

+ $url = str_replace('../', '', $url);

+ $pathinfo = pathinfo($url);

+

+ if (!file_exists($pathinfo['dirname']))

+ {

+ // fallback to "last known user page"

+ $url = generate_board_url() . '/' . $user->page['page'];

+ break;

+ }

+ }

+

+ if ((defined('DEBUG') || defined('IN_CRON') || defined('IMAGE_OUTPUT')) && isset($db))

+* Login using http authenticate.

+*

+* @param array $param Parameter array, see $param_defaults array.

+*

+* @return void

+*/

+function phpbb_http_login($param)

+{

+ global $auth, $user;

+ global $config;

+

+ $param_defaults = array(

+ 'auth_message' => '',

+

+ 'autologin' => false,

+ 'viewonline' => true,

+ 'admin' => false,

+ );

+

+ // Overwrite default values with passed values

+ $param = array_merge($param_defaults, $param);

+

+ // User is already logged in

+ // We will not overwrite his session

+ if (!empty($user->data['is_registered']))

+ {

+ return;

+ }

+

+ // $_SERVER keys to check

+ $username_keys = array(

+ 'PHP_AUTH_USER',

+ 'Authorization',

+ 'REMOTE_USER', 'REDIRECT_REMOTE_USER',

+ 'HTTP_AUTHORIZATION', 'REDIRECT_HTTP_AUTHORIZATION',

+ 'REMOTE_AUTHORIZATION', 'REDIRECT_REMOTE_AUTHORIZATION',

+ 'AUTH_USER',

+ );

+

+ $password_keys = array(

+ 'PHP_AUTH_PW',

+ 'REMOTE_PASSWORD',

+ 'AUTH_PASSWORD',

+ );

+

+ $username = null;

+ foreach ($username_keys as $k)

+ {

+ if (isset($_SERVER[$k]))

+ {

+ $username = $_SERVER[$k];

+ break;

+ }

+ }

+

+ $password = null;

+ foreach ($password_keys as $k)

+ {

+ if (isset($_SERVER[$k]))

+ {

+ $password = $_SERVER[$k];

+ break;

+ }

+ }

+

+ // Decode encoded information (IIS, CGI, FastCGI etc.)

+ if (!is_null($username) && is_null($password) && strpos($username, 'Basic ') === 0)

+ {

+ list($username, $password) = explode(':', base64_decode(substr($username, 6)), 2);

+ }

+

+ if (!is_null($username) && !is_null($password))

+ {

+ set_var($username, $username, 'string', true);

+ set_var($password, $password, 'string', true);

+

+ $auth_result = $auth->login($username, $password, $param['autologin'], $param['viewonline'], $param['admin']);

+

+ if ($auth_result['status'] == LOGIN_SUCCESS)

+ {

+ return;

+ }

+ else if ($auth_result['status'] == LOGIN_ERROR_ATTEMPTS)

+ {

+ header('HTTP/1.0 401 Unauthorized');

+ trigger_error('NOT_AUTHORISED');

+ }

+ }

+

+ // Prepend sitename to auth_message

+ $param['auth_message'] = ($param['auth_message'] === '') ? $config['sitename'] : $config['sitename'] . ' - ' . $param['auth_message'];

+

+ // We should probably filter out non-ASCII characters - RFC2616

+ $param['auth_message'] = preg_replace('/[\x80-\xFF]/', '?', $param['auth_message']);

+

+ header('WWW-Authenticate: Basic realm="' . $param['auth_message'] . '"');

+ header('HTTP/1.0 401 Unauthorized');

+

+ trigger_error('NOT_AUTHORISED');

+}

+

+/**

+ 'S_ENABLE_FEEDS_OVERALL' => ($config['feed_overall']) ? true : false,

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

+ 'S_ENABLE_FEEDS_TOPICS_ACTIVE' => ($config['feed_topics_active']) ? true : false,

+ if (!$ignore_acl && $auth->acl_get('f_list', $row['forum_id']))

+ if ($only_acl_post && !$auth->acl_get('f_post', $row['forum_id']) || (!$auth->acl_get('m_approve', $row['forum_id']) && !$auth->acl_get('f_noapprove', $row['forum_id'])))

+ else if (!$only_acl_post && !$auth->acl_gets(array('f_list', 'a_forum', 'a_forumadd', 'a_forumdel'), $row['forum_id']))

+ $disabled = true;

+ else if (!$ignore_acl)

+ {

+ continue;

+ }

+ // 0 is as bad as an empty array

+ if (empty($ids))

+ {

+ return false;

+ }

+

+ if (is_array($ids))

+ case 'mssqlnative':

+/**

+ * Enables a particular flag in a bitfield column of a given table.

+ *

+ * @param string $table_name The table to update

+ * @param string $column_name The column containing a bitfield to update

+ * @param int $flag The binary flag which is OR-ed with the current column value

+ * @param string $sql_more This string is attached to the sql query generated to update the table.

+ *

+ * @return void

+ */

+function enable_bitfield_column_flag($table_name, $column_name, $flag, $sql_more = '')

+{

+ global $db;

+

+ $sql = 'UPDATE ' . $table_name . '

+ SET ' . $column_name . ' = ' . $db->sql_bit_or($column_name, $flag) . '

+ ' . $sql_more;

+ $db->sql_query($sql);

+}

+

+ else

+ {

+ // $src does not exist

+ return false;

+ }

+ if (!file_exists($src))

+ {

+ return false;

+ }

+

+* @param bool $allow_reply Allow Re: in front of string

+* NOTE: This parameter can cause undesired behavior (returning strings longer than $max_store_legnth) and is deprecated.

+function truncate_string($string, $max_length = 60, $max_store_length = 255, $allow_reply = false, $append = '')

+*

+* Note: Deprecated, calls should directly go to phpbb_email_hash()

+ return phpbb_email_hash($email);

+ if (isset($convert->config_schema['array_name']))

+ {

+ unset($convert->config_schema['array_name']);

+ }

+

+

+ if ($schema['table_format'] != 'file' || empty($schema['array_name']))

+ {

+ $config_value = (isset($convert_config[$src])) ? $convert_config[$src] : '';

+ }

+ else if (!empty($schema['array_name']))

+ {

+ $src_ary = $schema['array_name'];

+ $config_value = (isset($convert_config[$src_ary][$src])) ? $convert_config[$src_ary][$src] : '';

+ }

+ }

+ case 'mssqlnative':

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

+ //

+ // On top of this sometimes the SQLite extension is compiled for a different version of PDO

+ // by some Linux distributions which causes phpBB to bomb out with a blank page.

+ //

+ // Net result we'll disable automatic inclusion of SQLite support

+ //

+ // See: r9618 and #56105

+ if ($dll == 'sqlite')

+ 'mssqlnative' => array(

+ 'LABEL' => 'MS SQL Server 2005+ [ Native ]',

+ 'SCHEMA' => 'mssql',

+ 'MODULE' => 'sqlsrv',

+ 'DELIM' => 'GO',

+ 'COMMENTS' => 'remove_comments',

+ 'DRIVER' => 'mssqlnative',

+ 'AVAILABLE' => true,

+ '2.0.x' => false,

+ ),

+ case 'mssqlnative':

+ case 'mssqlnative':

+ // fall back to board default language if the user's language is

+ // missing $template_file. If this does not exist either,

+ // $tpl->set_custom_template will do a trigger_error

+ $fallback_template_path = false;

+

+

+ // we can only specify default language fallback when the path is not a custom one for which we

+ // do not know the default language alternative

+ if ($template_lang !== basename($config['default_lang']))

+ {

+ $fallback_template_path = (!empty($user->lang_path)) ? $user->lang_path : $phpbb_root_path . 'language/';

+ $fallback_template_path .= basename($config['default_lang']) . '/email';

+ }

+ $tpl->set_custom_template($template_path, $template_lang . '_email', $fallback_template_path);

+ $sql = 'SELECT COUNT(smiley_id) AS item_count

+ $sql = 'SELECT smiley_url, MIN(emotion) as emotion, MIN(code) AS code, smiley_width, smiley_height, MIN(smiley_order) AS min_smiley_order

+ ORDER BY min_smiley_order';

+ else if (($config['email_enable'] || $config['jab_enable']) && $data['notify_set'] && !$data['notify'])

+ 'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start),

+ else if (!$auth->acl_get('f_post', $to_forum_id) || (!$auth->acl_get('m_approve', $to_forum_id) && !$auth->acl_get('f_noapprove', $to_forum_id)))

+ view_log('user', $log_data, $log_count, $config['topics_per_page'], $start, 0, 0, $user_id, $sql_where, $sql_sort, $keywords);

+ 'PAGE_NUMBER' => on_page($log_count, $config['topics_per_page'], $start),

+ 'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param$keywords_param", $log_count, $config['topics_per_page'], $start),

+ if ($auth->acl_get('m_approve', $topic_info['forum_id']))

+ {

+ $total = $topic_info['topic_replies_real'] + 1;

+ }

+ else

+ {

+ $total = $topic_info['topic_replies'] + 1;

+ }

+ case 'mssqlnative':

+ 'private_ip' => $this->is_private_ip($server_address),

+ 'ipv6' => strpos($server_address, ':') !== false,

+ );

+ }

+

+ /**

+ * Checks whether the given IP is in a private network.

+ *

+ * @param string $ip IP in v4 dot-decimal or v6 hex format

+ * @return bool true if the IP is from a private network, else false

+ */

+ function is_private_ip($ip)

+ {

+ // IPv4

+ if (strpos($ip, ':') === false)

+ {

+ $ip_address_ary = explode('.', $ip);

+

+ // build ip

+ if (!isset($ip_address_ary[0]) || !isset($ip_address_ary[1]))

+ {

+ $ip_address_ary = explode('.', '0.0.0.0');

+ }

+

+ if ($ip_address_ary[0] == '10' ||

+ ($ip_address_ary[0] == '172' && intval($ip_address_ary[1]) > 15 && intval($ip_address_ary[1]) < 32) ||

+ ($ip_address_ary[0] == '192' && $ip_address_ary[1] == '168') ||

+ ($ip_address_ary[0] == '192' && $ip_address_ary[1] == '168'))

+ {

+ return true;

+ }

+ }

+ // IPv6

+ else

+ {

+ // unique local unicast

+ $prefix = substr($ip, 0, 2);

+ if ($prefix == 'fc' || $prefix == 'fd')

+ {

+ return true;

+ }

+ }

+

+ return false;

+ unset($dbhost, $dbport, $dbname, $dbuser, $dbpasswd); // Just a precaution

+ 'feed_http_auth' => true,

+ 'feed_limit_post' => true,

+ 'feed_limit_topic' => true,

+ 'feed_overall' => true,

+ 'feed_topics_new' => true,

+ 'feed_topics_active' => true,

+ global $db;

+

+ $result['dbms_version'] = $db->sql_server_info(true);

+ $id_ary[] = (int) $row[$field];

+ $id_ary[] = (int) $row[$field];

+ WHERE ' . $db->sql_in_set('word_text', $exact_words) . '

+ ORDER BY word_count ASC';

+ $must_contain_ids = $this->must_contain_ids;

+ $must_not_contain_ids = $this->must_not_contain_ids;

+ $must_exclude_one_ids = $this->must_exclude_one_ids;

+

+ sort($must_contain_ids);

+ sort($must_not_contain_ids);

+ sort($must_exclude_one_ids);

+

+ serialize($must_contain_ids),

+ serialize($must_not_contain_ids),

+ serialize($must_exclude_one_ids),

+ $id_ary[] = (int) $row[(($type == 'posts') ? 'post_id' : 'topic_id')];

+ $id_ary[] = (int) $row[$field];

+ // If the user is logged in, update last visit info first before deleting sessions

+ if ($row)

+ {

+ $sql = 'UPDATE ' . USERS_TABLE . '

+ SET user_lastvisit = ' . (int) $row['session_time'] . ", user_lastpage = '" . $db->sql_escape($row['session_page']) . "'

+ WHERE user_id = " . (int) $user_id;

+ $db->sql_query($sql);

+ }

+ function set_custom_template($template_path, $template_name, $fallback_template_path = false)

+ if ($fallback_template_path !== false)

+ if (substr($fallback_template_path, -1) == '/')

+ {

+ $fallback_template_path = substr($fallback_template_path, 0, -1);

+ }

+

+ $this->inherit_root = $fallback_template_path;

+ $this->orig_tpl_inherits_id = true;

+ }

+ else

+ {

+ $this->orig_tpl_inherits_id = false;

+ // the database does not store the path or name of a custom template

+ // so there is no way we can properly store custom templates there

+ $this->orig_tpl_storedb = false;

+

+ // reload these settings to have the values they had when this object was initialised

+ // using set_template or set_custom_template, they might otherwise have been overwritten

+ // by other template class instances in between.

+ $user->theme['template_storedb'] = $this->orig_tpl_storedb;

+ $user->theme['template_inherits_id'] = $this->orig_tpl_inherits_id;

+

+ global $module;

+

+ $exclude = array();

+

+ if (!$module->loaded('zebra', 'friends'))

+ {

+ $exclude[RULE_IS_FRIEND] = true;

+ }

+

+ if (!$module->loaded('zebra', 'foes'))

+ {

+ $exclude[RULE_IS_FOE] = true;

+ }

+ if (isset($exclude[$value]))

+ {

+ continue;

+ }

+ if ($auth->acl_get('u_chgemail') && $config['email_enable'] && $data['email'] != $user->data['user_email'] && $user->data['user_type'] != USER_FOUNDER && ($config['require_activation'] == USER_ACTIVATION_SELF || $config['require_activation'] == USER_ACTIVATION_ADMIN))

+ // Okay, captcha, your job is done.

+ if ($config['enable_confirm'] && isset($captcha))

+ {

+ $captcha->reset();

+ }

+

+ // Make password at least 8 characters long, make it longer if admin wants to.

+ // gen_rand_string() however has a limit of 12 or 13.

+ $user_password = gen_rand_string(max(8, rand((int) $config['min_pass_chars'], (int) $config['max_pass_chars'])));

+

+ // For the activation key a random length between 6 and 10 will do.

+ $user_actkey = gen_rand_string(rand(6, 10));