+*~

+phpBB/config.php

+phpBB/files/*

+phpBB/images/avatars/upload/*

+phpBB/store/*

+ <!-- IF NEXT_FEATURE_VERSION -->

+ <div class="errorbox">

+ <p>{UPGRADE_INSTRUCTIONS}</p>

+ </div>

+ <!-- ENDIF -->

+

+ <input type="button" class="button2" accesskey="y" name="addlitsitem" value="[*]" style="width: 40px" onclick="bbstyle(-1)" onmouseover="helpline('e')" onmouseout="helpline('tip')" />

+if (file_exists($phpbb_root_path . 'config.' . $phpEx))

+ require($phpbb_root_path . 'config.' . $phpEx);

+ igorw (Igor Wiedler)

+ <li><a href="#acl_clear_prefetch">acl_clear_prefetch</a></li>

+ <li><a href="#acl_get_list">acl_get_list</a></li>

+ <li><a href="#misc">Miscellaneous</a></li>

+$result = $auth-&gt;acl_getf_global(<code>option</code>)

+ <a name="acl_clear_prefetch"></a><h3>2.vii. acl_clear_prefetch</h3>

+

+ <p>This method clears the user_permissions column in the users table for the given user. If the user ID passed is zero, the permissions cache is cleared for all users. This method should be called whenever permissions are set.</p>

+

+ <div class="codebox"><pre>

+// clear stored permissions for user 2

+$user_id = 2;

+$auth->acl_clear_prefetch($user_id);

+</pre></div>

+

+ <p>This method returns void.</p>

+

+ <a name="acl_get_list"></a><h3>2.viii. acl_get_list</h3>

+

+ <p>This method returns an an array describing which users have permissions in given fora. The resultant array contains an entry for permission that every user has in every forum when no arguments are passed.</p>

+

+ <div class="codebox"><pre>

+$user_id = array(2, 53);

+$permissions = array('f_list', 'f_read');

+$forum_id = array(1, 2, 3);

+$result = $auth-&gt;acl_get_list($user_id, $permissions, $forum_id);

+</pre></div>

+

+ <p>The parameters may be of the following legal types:</p>

+ <ul>

+ <li><strong>$user_id</strong>: <code>false</code>, int, array(int, int, int, ...)</li>

+ <li><strong>$permissions</strong>: <code>false</code>, string, array(string, string, ...)</li>

+ <li><strong>$forum_id</strong>: <code>false</code>, int, array(int, int, int, ...)</li>

+ </ul>

+

+ <a name="misc"></a><h3>2.ix. Miscellaneous</h3>

+

+ <p>There are other methods defined in the auth class which serve mostly as private methods, but are available for use if needed. Each of them is used to pull data directly from the database tables. They are:</p>

+ <ul>

+ <li><pre>function acl_group_raw_data($group_id = false, $opts = false, $forum_id = false)</pre></li>

+ <li><pre>function acl_user_raw_data($user_id = false, $opts = false, $forum_id = false)</pre></li>

+ <li><pre>function acl_raw_data_single_user($user_id)</pre></li>

+ <li><pre>function acl_raw_data($user_id = false, $opts = false, $forum_id = false)</pre></li>

+ <li><pre>function acl_role_data($user_type, $role_type, $ug_id = false, $forum_id = false)</pre></li>

+ </ul>

+

+ <p>Of these, <code>acl_raw_data</code> is the most general, but the others will be faster if you need a smaller amount of data.</p>

+

+ <div class="version">&nbsp;</div>

+ <li><a href="#commitmessage">Commit Messages and Repository Rules</a></li>

+ <p>The version control system for phpBB3 is git. The repository is available at <a href="http://github.com/phpbb/phpbb3" title="repository">http://github.com/phpbb/phpbb3</a>.</p>

+ <li><strong>develop</strong><br />The latest unstable development version with new features etc.</li>

+ <li><strong>develop-*</strong><br />Development branches of stable phpBB releases. Branched off of <code>develop</code> at the time of feature freeze.

+ <li><strong>phpBB3.0</strong><code>develop-olympus</code><br />Development branch of the stable 3.0 line. Bug fixes are applied here.</li>

+ <li><strong>phpBB3.1</strong><code>develop-ascraeus</code><br />Development branch of the stable 3.1 line. Bug fixes are applied here.</li>

+ <li><strong>master</strong><br />A branch containing all stable phpBB3 release points</li>

+ <li><strong>tags</strong><br />Released versions. Stable ones get merged into the master branch.

+ <li><code>release-3.Y-BX</code><br />Beta release X of the 3.Y line.</li>

+ <li><code>release-3.Y-RCX</code><br />Release candidate X of the 3.Y line.</li>

+ <li><code>release-3.Y.Z-RCX</code><br />Release candidate X of the stable 3.Y.Z release.</li>

+ <li><code>release-3.0.X</code><br />Stable <strong>3.0.X</strong> release.</li>

+ <li><code>release-2.0.X</code><br />Old stable 2.0.X release.</li>

+ <a name="commitmessage"></a><h3>7.ii. Commit Messages and Reposiory Rules</h3>

+ <p>Information on repository rules, such as commit messages can be found at <a href="http://wiki.phpbb.com/display/DEV/Git" title="phpBB Git Information">http://wiki.phpbb.com/display/DEV/Git</a></p>.

+ <div class="version">&nbsp;</div>

+ <div class="version">&nbsp;</div>

+<Files *>

+ Order Allow,Deny

+ Deny from All

+</Files>

+ $ary_type = $ary_name = array();

+ $db->mssqlnative_set_query_options(array('Scrollable' => SQLSRV_CURSOR_STATIC));

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

+ if (!$retrieved_data)

+ {

+ $db->sql_freeresult($result);

+ return;

+ }

+

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

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

+

+ $row = new result_mssqlnative($result_fields);

+ $i_num_fields = $row->num_fields();

+

+ $ary_type[$i] = $row->field_type($i);

+ $ary_name[$i] = $row->field_name($i);

+ $db->sql_freeresult($result_fields);

+

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

+ // defaults to type number - better quote just to be safe, so check for is_int too

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

+ if ($ident_set)

+ // Validate the length of "Maximum number of allowed recipients per private message" setting.

+ // We use 16777215 as a maximum because it matches MySQL unsigned mediumint maximum value

+ // which is the lowest amongst DBMSes supported by phpBB3

+ if ($max_recipients_error = validate_data($submit_ary, array('max_recipients' => array('num', false, 0, 16777215))))

+ {

+ // Replace "error" string with its real, localised form

+ $error = array_merge($error, array_map(array(&$user, 'lang'), $max_recipients_error));

+ }

+

+ // next feature release

+ $next_feature_version = $next_feature_announcement_url = false;

+ if (isset($info[2]) && trim($info[2]) !== '')

+ {

+ $next_feature_version = trim($info[2]);

+ $next_feature_announcement_url = trim($info[3]);

+ }

+

+ 'NEXT_FEATURE_VERSION' => $next_feature_version,

+ 'UPGRADE_INSTRUCTIONS' => $next_feature_version ? $user->lang('UPGRADE_INSTRUCTIONS', $next_feature_version, $next_feature_announcement_url) : false,

+ WHERE user_id = ' . (int) $row['user_id'] . '

+ AND user_login_attempts < ' . LOGIN_ATTEMPTS_MAX;

+ WHERE user_id = ' . (int) $row['user_id'] . '

+ AND user_login_attempts < ' . LOGIN_ATTEMPTS_MAX;

+ return $user->lang['RECAPTCHA_INCORRECT'];

+// Maximum login attempts

+// The value is arbitrary, but it has to fit into the user_login_attempts field.

+define('LOGIN_ATTEMPTS_MAX', 100);

+

+ var $query_options = array();

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

+ // reset options for next query

+ $this->query_options = array();

+ // total == 0 means all results - not zero results

+ if ($offset == 0 && $total !== 0)

+ else if ($offset > 0)

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

+

+ if ($total > 0)

+ {

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

+ }

+ else

+ {

+ $query .= ' WHERE line3 > ' . $offset;

+ }

+

+ // remove helper values from LIMIT queries

+ if (isset($row['line2']))

+ {

+ unset($row['line2'], $row['line3']);

+ }

+ * Requires a static or keyset cursor to be definde via

+ * mssqlnative_set_query_options()

+ return sqlsrv_num_rows($res);

+

+ /**

+ * Allows setting mssqlnative specific query options passed to sqlsrv_query as 4th parameter.

+ */

+ function mssqlnative_set_query_options($options)

+ {

+ $this->query_options = $options;

+ }

+?>

+ 'S_LOAD_UNREADS' => ($config['load_unreads_search'] && ($config['load_anon_lastread'] || $user->data['is_registered'])) ? true : false,

+ $info = get_remote_file('version.phpbb.com', '/phpbb',

+ * Obtains exclusive lock on queue cache file.

+ * Returns resource representing the lock

+ */

+ function lock()

+ {

+ // For systems that can't have two processes opening

+ // one file for writing simultaneously

+ if (file_exists($this->cache_file . '.lock'))

+ {

+ $mode = 'rb';

+ }

+ else

+ {

+ $mode = 'wb';

+ }

+

+ $lock_fp = @fopen($this->cache_file . '.lock', $mode);

+

+ if ($mode == 'wb')

+ {

+ if (!$lock_fp)

+ {

+ // Two processes may attempt to create lock file at the same time.

+ // Have the losing process try opening the lock file again for reading

+ // on the assumption that the winning process created it

+ $mode = 'rb';

+ $lock_fp = @fopen($this->cache_file . '.lock', $mode);

+ }

+ else

+ {

+ // Only need to set mode when the lock file is written

+ @chmod($this->cache_file . '.lock', 0666);

+ }

+ }

+

+ if ($lock_fp)

+ {

+ @flock($lock_fp, LOCK_EX);

+ }

+

+ return $lock_fp;

+ }

+

+ /**

+ * Releases lock on queue cache file, using resource obtained from lock()

+ */

+ function unlock($lock_fp)

+ {

+ // lock() will return null if opening lock file, and thus locking, failed.

+ // Accept null values here so that client code does not need to check them

+ if ($lock_fp)

+ {

+ @flock($lock_fp, LOCK_UN);

+ fclose($lock_fp);

+ }

+ }

+

+ /**

+ $lock_fp = $this->lock();

+ set_config('last_queue_run', time(), true);

+ if (!file_exists($this->cache_file) || filemtime($this->cache_file) > time() - $config['queue_interval'])

+ $this->unlock($lock_fp);

+ $this->unlock($lock_fp);

+ $this->unlock($lock_fp);

+ $lock_fp = $this->lock();

+

+

+ $this->unlock($lock_fp);

+ else if ($row['field_default_value'] === '' && $row['field_type'] == FIELD_INT)

+ {

+ // We cannot insert an empty string into an integer column.

+ $row['field_default_value'] = NULL;

+ }

+ <dl>

+ <dt><label>' . $user->lang['MIN_SEARCH_CHARS'] . ':</label><br /><span>' . $user->lang['FULLTEXT_MYSQL_MIN_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd>' . $config['fulltext_mysql_min_word_len'] . '</dd>

+ </dl>

+ <dl>

+ <dt><label>' . $user->lang['MAX_SEARCH_CHARS'] . ':</label><br /><span>' . $user->lang['FULLTEXT_MYSQL_MAX_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd>' . $config['fulltext_mysql_max_word_len'] . '</dd>

+ </dl>

+ 'avatar' => array('title' => 'UCP_PROFILE_AVATAR', 'auth' => 'cfg_allow_avatar && (cfg_allow_avatar_local || cfg_allow_avatar_remote || cfg_allow_avatar_upload || cfg_allow_avatar_remote_upload)', 'cat' => array('UCP_PROFILE')),

+ // update

+ $sql = 'UPDATE ' . MODULES_TABLE . '

+ SET module_auth = \'cfg_allow_avatar && (cfg_allow_avatar_local || cfg_allow_avatar_remote || cfg_allow_avatar_upload || cfg_allow_avatar_remote_upload)\'

+ WHERE module_class = \'ucp\'

+ AND module_basename = \'profile\'

+ AND module_mode = \'avatar\'';

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

+

+ 'REG_LIMIT_EXPLAIN' => 'Number of attempts users can make at solving the CAPTCHA before being locked out of that session.',

+ 'ACP_VC_SETTINGS_EXPLAIN' => 'Here you can select and configure CAPTCHA plugins, which are designed to block automated form submissions by spambots.',

+ 'VISUAL_CONFIRM_POST' => 'Enable CAPTCHA for guest postings',

+ 'VISUAL_CONFIRM_POST_EXPLAIN' => 'Requires guest users to solve a CAPTCHA to help prevent automated postings.',

+ 'VISUAL_CONFIRM_REG' => 'Enable CAPTCHA for registrations',

+ 'VISUAL_CONFIRM_REG_EXPLAIN' => 'Requires new users to solve a CAPTCHA to help prevent automated registrations.',

+ 'VISUAL_CONFIRM_REFRESH' => 'Enable users to refresh the CAPTCHA',

+ 'VISUAL_CONFIRM_REFRESH_EXPLAIN' => 'Allows users to request a new CAPTCHA if they are unable to solve the CAPTCHA during registration. Some plugins might not support this option.',

+ 'MAX_LOGIN_ATTEMPTS_EXPLAIN' => 'After this number of failed logins the user needs to additionally solve the CAPTCHA.',

+ 'FULLTEXT_MYSQL_MIN_SEARCH_CHARS_EXPLAIN' => 'Words with at least this many characters will be indexed for searching. You or your host can only change this setting by changing the mysql configuration.',

+ 'FULLTEXT_MYSQL_MAX_SEARCH_CHARS_EXPLAIN' => 'Words with no more than this many characters will be indexed for searching. You or your host can only change this setting by changing the mysql configuration.',

+ 'DELETE_IMAGESET_EXPLAIN' => 'Here you can remove the selected imageset from the database. Please note that there is no undo capability. It is recommended that you first export your set for possible future use.',

+ 'DELETE_STYLE_EXPLAIN' => 'Here you can remove the selected style. You cannot remove all the style elements from here. These must be deleted individually via their respective forms. Take care when deleting styles, there is no undo facility.',

+ 'DELETE_TEMPLATE_EXPLAIN' => 'Here you can remove the selected template set from the database. Please note that there is no undo capability. It is recommended that you first export your set for possible future use.',

+ 'DELETE_THEME_EXPLAIN' => 'Here you can remove the selected theme from the database. Please note that there is no undo capability. It is recommended that you first export your theme for possible future use.',

+ 'CONFIRM_QUESTION_EXPLAIN' => 'This question is a means of preventing automated form submissions by spambots.',

+ 'CONFIRM_QUESTION_WRONG' => 'You have provided an invalid answer to the question.',

+ 'QUESTIONS_EXPLAIN' => 'For every form submission where you have enabled the Q&amp;A CAPTCHA, users will be asked one of the questions specified here. To use this plugin at least one question must be set in the default language. These questions should be easy for your target audience to answer but beyond the ability of a bot capable of running a Google™ search. Using a large and regularly changed set of questions will yield the best results. Enable the strict setting if your question relies on mixed case, punctuation or whitespace.',

+ 'QUESTION_LANG_EXPLAIN' => 'The language this question and its answers are written in.',

+ 'QUESTION_STRICT_EXPLAIN' => 'Enable to enforce mixed case, punctuation and whitespace.',

+ 'QUESTION_TEXT_EXPLAIN' => 'The question presented to the user.',

+ 'RECAPTCHA_EXPLAIN' => 'In an effort to prevent automatic submissions, we require that you enter both of the words displayed into the text field underneath.',

+ 'LOGIN_CONFIRM_EXPLAIN' => 'To prevent brute forcing accounts the board requires you to enter a confirmation code after a maximum amount of failed logins. The code is displayed in the image you should see below. If you are visually impaired or cannot otherwise read this code please contact the %sBoard Administrator%s.', // unused

+ 'LOGIN_ERROR_ATTEMPTS' => 'You exceeded the maximum allowed number of login attempts. In addition to your username and password you now also have to solve the CAPTCHA below.',

+

+ 'TOO_LARGE' => 'The value you entered is too large.',

+ 'TOO_LARGE_MAX_RECIPIENTS' => 'The value of <strong>Maximum number of allowed recipients per private message</strong> setting you entered is too large.',

+

+ 'TOO_SMALL' => 'The value you entered is too small.',

+ 'TOO_SMALL_MAX_RECIPIENTS' => 'The value of <strong>Maximum number of allowed recipients per private message</strong> setting you entered is too small.',

+ 'UPGRADE_INSTRUCTIONS' => 'A new feature release <strong>%1$s</strong> is available. Please read <a href="%2$s" title="%2$s"><strong>the release announcement</strong></a> to learn about what it has to offer, and how to upgrade.',

+if (sizeof($post_data['poll_options']) || !empty($post_data['poll_title']))

+ theme : 'clean',

+ <li><a href="{U_SEARCH_UNANSWERED}">{L_SEARCH_UNANSWERED}</a><!-- IF S_LOAD_UNREADS --> &bull; <a href="{U_SEARCH_UNREAD}">{L_SEARCH_UNREAD}</a><!-- ENDIF --><!-- IF S_USER_LOGGED_IN --> &bull; <a href="{U_SEARCH_NEW}">{L_SEARCH_NEW}</a><!-- ENDIF --> &bull; <a href="{U_SEARCH_ACTIVE_TOPICS}">{L_SEARCH_ACTIVE_TOPICS}</a></li>

+<script type="text/javascript">

+// <![CDATA[

+ onload_functions.push('document.getElementById("{USERNAME_CREDENTIAL}").focus();');

+// ]]>

+</script>

+

+ <span class="right-box" id="expand"><a href="#post_details" onclick="viewableArea(getElementById('post_details'), true); var rev_text = getElementById('expand').getElementsByTagName('a').item(0).firstChild; if (rev_text.data == '{LA_EXPAND_VIEW}'){rev_text.data = '{LA_COLLAPSE_VIEW}'; } else if (rev_text.data == '{LA_COLLAPSE_VIEW}'){rev_text.data = '{LA_EXPAND_VIEW}'}; return false;">{L_EXPAND_VIEW}</a></span>

+<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7; IE=EmulateIE9" />

+ <input type="button" class="button2" accesskey="y" name="addlitsitem" value="[*]" style="width: 40px" onclick="bbstyle(-1)" title="{L_BBCODE_LISTITEM_HELP}" />

+ <!-- IF S_HAS_DRAFTS --><input type="submit" accesskey="d" tabindex="8" name="load" value="{L_LOAD_DRAFT}" class="button2" onclick="load_draft = true;" />&nbsp; <!-- ENDIF -->

+ <!-- IF S_SAVE_ALLOWED --><input type="submit" accesskey="k" tabindex="7" name="save" value="{L_SAVE_DRAFT}" class="button2" />&nbsp; <!-- ENDIF -->

+<script type="text/javascript">

+// <![CDATA[

+ onload_functions.push('document.getElementById("keywords").focus();');

+// ]]>

+</script>

+

+<!-- INCLUDE overall_footer.html -->

+#expand

+{

+ clear: both;

+}

+

+

+dl.codebox dt { display: none; } \ No newline at end of file

+ <!-- IF S_TYPE == 1 -->

+ <!-- ENDIF -->

+ theme : 'clean',

+<script type="text/javascript">

+// <![CDATA[

+ (function()

+ {

+ var elements = document.getElementsByName("{USERNAME_CREDENTIAL}");

+ for (var i = 0; i < elements.length; ++i)

+ {

+ if (elements[i].tagName.toLowerCase() == 'input')

+ {

+ elements[i].focus();

+ break;

+ }

+ }

+ })();

+// ]]>

+</script>

+

+<!-- INCLUDE overall_footer.html -->

+<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7; IE=EmulateIE9" />

+ <!-- IF S_USER_LOGGED_IN or S_LOAD_UNREADS -->

+ <span style="float: {S_CONTENT_FLOW_END};"><!-- IF S_LOAD_UNREADS --><a href="{U_SEARCH_UNREAD}">{L_SEARCH_UNREAD}</a><!-- IF S_USER_LOGGED_IN --> | <!-- ENDIF --><!-- ENDIF --><!-- IF S_USER_LOGGED_IN --><a href="{U_SEARCH_NEW}">{L_SEARCH_NEW}</a> | <a href="{U_SEARCH_SELF}">{L_SEARCH_SELF}</a><!-- ENDIF --></span>

+ <!-- IF S_SAVE_ALLOWED -->&nbsp; <input class="btnlite" type="submit" accesskey="k" tabindex="7" name="save" value="{L_SAVE_DRAFT}" /><!-- ENDIF -->

+ <!-- IF S_HAS_DRAFTS -->&nbsp; <input class="btnlite" type="submit" accesskey="d" tabindex="8" name="load" value="{L_LOAD_DRAFT}" /><!-- ENDIF -->

+ <!-- IF S_SAVE_ALLOWED -->&nbsp; <input class="btnlite" type="submit" accesskey="k" tabindex="12" name="save" value="{L_SAVE_DRAFT}" /><!-- ENDIF -->

+ <!-- IF S_HAS_DRAFTS -->&nbsp; <input class="btnlite" type="submit" accesskey="d" tabindex="13" name="load" value="{L_LOAD_DRAFT}" /><!-- ENDIF -->

+ <input type="button" class="btnbbcode" accesskey="y" name="addlitsitem" value="[*]" style="width: 40px" onclick="bbstyle(-1)" onmouseover="helpline('e')" onmouseout="helpline('tip')" />

+<script type="text/javascript">

+// <![CDATA[

+ (function()

+ {

+ var elements = document.getElementsByName("keywords");

+ for (var i = 0; i < elements.length; ++i)

+ {

+ if (elements[i].tagName.toLowerCase() == 'input')

+ {

+ elements[i].focus();

+ break;

+ }

+ }

+ })();

+// ]]>

+</script>

+

+<!-- INCLUDE overall_footer.html -->

+=============

+=============

+-------

+--------------

+Database Tests

+--------------

+By default all tests requiring a database connection will use sqlite. If you

+do not have sqlite installed the tests will be skipped. If you wish to run the

+tests on a different database you have to create a test_config.php file within

+your tests directory following the same format as phpBB's config.php. An example

+for mysqli can be found below. More information on configuration options can be

+found on the wiki (see below).

+

+ <?php

+ $dbms = 'mysqli';

+ $dbhost = 'localhost';

+ $dbport = '';

+ $dbname = 'database';

+ $dbuser = 'user';

+ $dbpasswd = 'password';

+

+Alternatively you can specify parameters in the environment, so e.g. the following

+will run phpunit with the same parameters as in the shown test_config.php file:

+

+ $ PHPBB_TEST_DBMS='mysqli' PHPBB_TEST_DBHOST='localhost' \

+ PHPBB_TEST_DBNAME='database' PHPBB_TEST_DBUSER='user' \

+ PHPBB_TEST_DBPASSWD='password' phpunit all_tests.php

+

+=======

+ $ phpunit all_tests.php

+================

+if (version_compare(PHPUnit_Runner_Version::id(), '3.5.0') >= 0)

+{

+ PHP_CodeCoverage_Filter::getInstance()->addDirectoryToBlacklist('./');

+}

+else

+{

+ PHPUnit_Util_Filter::addDirectoryToFilter('./');

+}

+require_once 'dbal/select.php';

+require_once 'dbal/write.php';

+ $suite->addTestSuite('phpbb_dbal_select_test');

+ $suite->addTestSuite('phpbb_dbal_write_test');

+<?xml version="1.0" encoding="UTF-8" ?>

+<dataset>

+ <table name="phpbb_config">

+ <column>config_name</column>

+ <column>config_value</column>

+ <column>is_dynamic</column>

+ <row>

+ <value>config1</value>

+ <value>foo</value>

+ <value>0</value>

+ </row>

+ <row>

+ <value>config2</value>

+ <value>bar</value>

+ <value>1</value>

+ </row>

+ </table>

+</dataset>

+class phpbb_dbal_select_test extends phpbb_database_test_case

+<?php

+/**

+*

+* @package testing

+* @copyright (c) 2008 phpBB Group

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

+*

+*/

+

+require_once 'test_framework/framework.php';

+require_once '../phpBB/includes/functions.php';

+

+class phpbb_dbal_write_test extends phpbb_database_test_case

+{

+ public function getDataSet()

+ {

+ return $this->createXMLDataSet(dirname(__FILE__).'/fixtures/config.xml');

+ }

+

+ public static function build_array_insert_data()

+ {

+ return array(

+ array(array(

+ 'config_name' => 'test_version',

+ 'config_value' => '0.0.0',

+ 'is_dynamic' => 1,

+ )),

+ array(array(

+ 'config_name' => 'second config',

+ 'config_value' => '10',

+ 'is_dynamic' => 0,

+ )),

+ );

+ }

+

+ /**

+ * @dataProvider build_array_insert_data

+ */

+ public function test_build_array_insert($sql_ary)

+ {

+ $db = $this->new_dbal();

+

+ $sql = 'INSERT INTO phpbb_config ' . $db->sql_build_array('INSERT', $sql_ary);

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

+

+ $sql = "SELECT *

+ FROM phpbb_config

+ WHERE config_name = '" . $sql_ary['config_name'] . "'";

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

+

+ $this->assertEquals($sql_ary, $db->sql_fetchrow($result));

+

+ $db->sql_freeresult($result);

+ }

+

+ public function test_delete()

+ {

+ $db = $this->new_dbal();

+

+ $sql = "DELETE FROM phpbb_config

+ WHERE config_name = 'config1'";

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

+

+ $sql = 'SELECT *

+ FROM phpbb_config';

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

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

+

+ $this->assertEquals(1, sizeof($rows));

+ $this->assertEquals('config2', $rows[0]['config_name']);

+

+ $db->sql_freeresult($result);

+ }

+

+ public function test_multiple_insert()

+ {

+ $db = $this->new_dbal();

+

+ // empty the table

+ $sql = 'DELETE FROM phpbb_config';

+ $db->sql_query($sql);

+

+ $batch_ary = array(

+ array(

+ 'config_name' => 'batch one',

+ 'config_value' => 'b1',

+ 'is_dynamic' => 0,

+ ),

+ array(

+ 'config_name' => 'batch two',

+ 'config_value' => 'b2',

+ 'is_dynamic' => 1,

+ ),

+ );

+

+ $result = $db->sql_multi_insert('phpbb_config', $batch_ary);

+

+ $sql = 'SELECT *

+ FROM phpbb_config

+ ORDER BY config_name ASC';

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

+

+ $this->assertEquals($batch_ary, $db->sql_fetchrowset($result));

+

+ $db->sql_freeresult($result);

+ }

+

+ public static function update_data()

+ {

+ return array(

+ array(

+ array(

+ 'config_value' => '23',

+ 'is_dynamic' => 0,

+ ),

+ " WHERE config_name = 'config1'",

+ array(

+ array(

+ 'config_name' => 'config1',

+ 'config_value' => '23',

+ 'is_dynamic' => 0,

+ ),

+ array(

+ 'config_name' => 'config2',

+ 'config_value' => 'bar',

+ 'is_dynamic' => 1,

+ ),

+ ),

+ ),

+ array(

+ array(

+ 'config_value' => '0',

+ 'is_dynamic' => 1,

+ ),

+ '',

+ array(

+ array(

+ 'config_name' => 'config1',

+ 'config_value' => '0',

+ 'is_dynamic' => 1,

+ ),

+ array(

+ 'config_name' => 'config2',

+ 'config_value' => '0',

+ 'is_dynamic' => 1,

+ ),

+ ),

+ ),

+ );

+ }

+

+ /**

+ * @dataProvider update_data

+ */

+ public function test_update($sql_ary, $where, $expected)

+ {

+ $db = $this->new_dbal();

+

+ $sql = 'UPDATE phpbb_config

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

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

+

+ $sql = 'SELECT *

+ FROM phpbb_config

+ ORDER BY config_name ASC';

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

+

+ $this->assertEquals($expected, $db->sql_fetchrowset($result));

+

+ $db->sql_freeresult($result);

+ }

+}

+ ob_end_clean();

+if (version_compare(PHPUnit_Runner_Version::id(), '3.5.0', '<'))

+{

+ require_once 'PHPUnit/Framework.php';

+ require_once 'PHPUnit/Extensions/Database/TestCase.php';

+}

+

+ private static $already_connected;

+

+ public function get_test_case_helpers()

+

+ return $this->test_case_helpers;

+ 'PDO' => 'sqlsrv',

+ public function get_database_config()

+ {

+ if (isset($_SERVER['PHPBB_TEST_DBMS']))

+ {

+ return array(

+ 'dbms' => isset($_SERVER['PHPBB_TEST_DBMS']) ? $_SERVER['PHPBB_TEST_DBMS'] : '',

+ 'dbhost' => isset($_SERVER['PHPBB_TEST_DBHOST']) ? $_SERVER['PHPBB_TEST_DBHOST'] : '',

+ 'dbport' => isset($_SERVER['PHPBB_TEST_DBPORT']) ? $_SERVER['PHPBB_TEST_DBPORT'] : '',

+ 'dbname' => isset($_SERVER['PHPBB_TEST_DBNAME']) ? $_SERVER['PHPBB_TEST_DBNAME'] : '',

+ 'dbuser' => isset($_SERVER['PHPBB_TEST_DBUSER']) ? $_SERVER['PHPBB_TEST_DBUSER'] : '',

+ 'dbpasswd' => isset($_SERVER['PHPBB_TEST_DBPASSWD']) ? $_SERVER['PHPBB_TEST_DBPASSWD'] : '',

+ );

+ }

+ else if (file_exists('test_config.php'))

+ {

+ include('test_config.php');

+

+ return array(

+ 'dbms' => $dbms,

+ 'dbhost' => $dbhost,

+ 'dbport' => $dbport,

+ 'dbname' => $dbname,

+ 'dbuser' => $dbuser,

+ 'dbpasswd' => $dbpasswd,

+ );

+ }

+ else if (extension_loaded('sqlite') && version_compare(PHPUnit_Runner_Version::id(), '3.4.15', '>='))

+ {

+ // Silently use sqlite

+ return array(

+ 'dbms' => 'sqlite',

+ 'dbhost' => 'phpbb_unit_tests.sqlite2', // filename

+ 'dbport' => '',

+ 'dbname' => '',

+ 'dbuser' => '',

+ 'dbpasswd' => '',

+ );

+ }

+ else

+ {

+ $this->markTestSkipped('Missing test_config.php: See first error.');

+ }

+ }

+

+ // remove comment lines starting with # - they are not proper sqlite

+ // syntax and break sqlite2

+ /**

+ * Retrieves a list of all tables from the database.

+ *

+ * @param PDO $pdo

+ * @param string $dbms

+ * @return array(string)

+ */

+ function get_tables($pdo, $dbms)

+ switch ($pdo)

+ {

+ case 'mysql':

+ case 'mysql4':

+ case 'mysqli':

+ $sql = 'SHOW TABLES';

+ break;

+

+ case 'sqlite':

+ $sql = 'SELECT name

+ FROM sqlite_master

+ WHERE type = "table"';

+ break;

+ case 'mssql':

+ case 'mssql_odbc':

+ case 'mssqlnative':

+ $sql = "SELECT name

+ FROM sysobjects

+ WHERE type='U'";

+ break;

+ case 'postgres':

+ $sql = 'SELECT relname

+ FROM pg_stat_user_tables';

+ break;

+ case 'firebird':

+ $sql = 'SELECT rdb$relation_name

+ FROM rdb$relations

+ WHERE rdb$view_source is null

+ AND rdb$system_flag = 0';

+ break;

+

+ case 'oracle':

+ $sql = 'SELECT table_name

+ FROM USER_TABLES';

+ break;

+ }

+

+ $result = $pdo->query($sql);

+

+ $tables = array();

+ while ($row = $result->fetch(PDO::FETCH_NUM))

+ $tables[] = current($row);

+

+ return $tables;

+ }

+

+ /**

+ * Returns a PDO connection for the configured database.

+ *

+ * @param array $config The database configuration

+ * @param array $dbms Information on the used DBMS.

+ * @param bool $use_db Whether the DSN should be tied to a

+ * particular database making it impossible

+ * to delete that database.

+ * @return PDO The PDO database connection.

+ */

+ public function new_pdo($config, $dbms, $use_db)

+ {

+ $dsn = $dbms['PDO'] . ':';

+

+ switch ($dbms['PDO'])

+ case 'sqlite2':

+ $dsn .= $config['dbhost'];

+ break;

+

+ case 'sqlsrv':

+ // prefix the hostname (or DSN) with Server= so using just (local)\SQLExpress

+ // works for example, further parameters can still be appended using ;x=y

+ $dsn .= 'Server=';

+ // no break -> rest like ODBC

+ case 'odbc':

+ // for ODBC assume dbhost is a suitable DSN

+ // e.g. Driver={SQL Server Native Client 10.0};Server=(local)\SQLExpress;

+ $dsn .= $config['dbhost'];

+

+ if ($use_db)

+ $dsn .= ';Database=' . $config['dbname'];

+ break;

+ default:

+ $dsn .= 'host=' . $config['dbhost'];

+

+ if ($use_db)

+ $dsn .= ';dbname=' . $config['dbname'];

+ break;

+ }

+ $pdo = new PDO($dsn, $config['dbuser'], $config['dbpasswd']);;

+ // good for debug

+ // $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

+ return $pdo;

+ }

+ private function recreate_db($config, $dbms)

+ {

+ switch ($config['dbms'])

+ {

+ case 'sqlite':

+ if (file_exists($config['dbhost']))

+ unlink($config['dbhost']);

+ break;

+

+ default:

+ $pdo = $this->new_pdo($config, $dbms, false);

+

+ try

+ $pdo->exec('DROP DATABASE ' . $config['dbname']);

+ catch (PDOException $e)

+ {

+ // try to delete all tables if dropping the database was not possible.

+ foreach ($this->get_tables() as $table)

+ {

+ try

+ {

+ $pdo->exec('DROP TABLE ' . $table);

+ }

+ catch (PDOException $e){} // ignore non-existent tables

+ }

+ }

+ $pdo->exec('CREATE DATABASE ' . $config['dbname']);

+ break;

+ }

+ }

+ private function load_schema($pdo, $config, $dbms)

+ {

+ if ($config['dbms'] == 'mysql')

+ {

+ $sth = $pdo->query('SELECT VERSION() AS version');

+ $row = $sth->fetch(PDO::FETCH_ASSOC);

+ if (version_compare($row['version'], '4.1.3', '>='))

+ {

+ $dbms['SCHEMA'] .= '_41';

+ }

+ else

+ $dbms['SCHEMA'] .= '_40';

+ }

+

+ $sql = $this->split_sql_file(file_get_contents("../phpBB/install/schemas/{$dbms['SCHEMA']}_schema.sql"), $config['dbms']);

+ foreach ($sql as $query)

+ {

+ $pdo->exec($query);

+ }

+ }

+

+ public function getConnection()

+ {

+ $config = $this->get_database_config();

+ $dbms = $this->get_dbms_data($config['dbms']);

+

+ if (!self::$already_connected)

+ {

+ $this->recreate_db($config, $dbms);

+ }

+

+ $pdo = $this->new_pdo($config, $dbms, true);

+

+ if (!self::$already_connected)

+ {

+ $this->load_schema($pdo, $config, $dbms);

+

+ self::$already_connected = true;

+ global $phpbb_root_path, $phpEx;

+

+ $config = $this->get_database_config();

+

+ require_once '../phpBB/includes/db/' . $config['dbms'] . '.php';

+ $dbal = 'dbal_' . $config['dbms'];

+ $db = new $dbal();

+ $db->sql_connect($config['dbhost'], $config['dbuser'], $config['dbpasswd'], $config['dbname'], $config['dbport']);

+

+ return $db;

+ $this->get_test_case_helpers()->setExpectedTriggerError($errno, $message);

+ public function get_test_case_helpers()

+

+ return $this->test_case_helpers;

+ $this->get_test_case_helpers()->setExpectedTriggerError($errno, $message);