aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db/dbal.php
Commit message (Collapse)AuthorAgeFilesLines
* [ticket/11015] Fixup some things from the big mergeIgor Wiedler2012-11-121-1049/+0
| | | | PHPBB3-11015
* [ticket/11189] Replace DEBUG_EXTRA with DEBUGNathaniel Guse2012-11-101-2/+2
| | | | PHPBB3-11189
* [ticket/10875] Fix SQL CachingNathan Guse2012-07-301-2/+2
| | | | | | | | | | | The sql_save function cannot take arguments by reference since it is called by call_user_func_array() Replace use of isset($cache->sql_rowset[$query_id]) with $cache->sql_exists Replace $cache->cache_dir with $cache->get_driver()->cache_dir PHPBB3-10875
* [ticket/10942] Add access modifiersJoas Schilling2012-07-041-2/+2
| | | | PHPBB3-10942
* [ticket/10942] Use ANSI SQL standard || in dbal.phpJoas Schilling2012-07-021-1/+1
| | | | PHPBB3-10942
* [ticket/10942] Require same data type and do not cast expressions automaticallyJoas Schilling2012-07-021-0/+2
| | | | PHPBB3-10942
* [ticket/10942] Rename method sql_conditional() to sql_case()Joas Schilling2012-06-201-9/+9
| | | | PHPBB3-10942
* [ticket/10942] Change term string to expression to avoid confusionJoas Schilling2012-06-201-5/+5
| | | | PHPBB3-10942
* [ticket/10942] Add sql_concatenate to dbalJoas Schilling2012-06-201-0/+12
| | | | PHPBB3-10942
* [ticket/10942] Add sql_conditional to dbalJoas Schilling2012-06-201-0/+17
| | | | PHPBB3-10942
* Merge branch 'develop-olympus' into developNils Adermann2012-05-311-0/+12
|\ | | | | | | | | | | | | | | | | | | | | By Andreas Fischer via Andreas Fischer (1) and Nils Adermann (1) * develop-olympus: [ticket/10751] Use sql_lower_text() in view_log(). log_data is a text column. [ticket/10751] Add sql_lower_text() to database abstraction layer. Conflicts: phpBB/includes/db/dbal.php
| * [ticket/10751] Add sql_lower_text() to database abstraction layer.Andreas Fischer2012-05-311-0/+12
| | | | | | | | | | | | | | | | On MSSQL, LOWER() can only be called on bounded strings (i.e. varchar or char). So, in order to use it on a text column, we have to convert it to an appropriate type. We do so using the SUBSTRING function. PHPBB3-10751
* | Merge branch 'develop-olympus' into developAndreas Fischer2012-05-091-0/+43
|\ \ | |/ | | | | | | | | | | | | | | | | * develop-olympus: [ticket/10858] Move generic row seeking to DBAL [ticket/10858] Tests for row seeking with fetchfield() [ticket/10858] Fix MSSQL Native's row seeking behavior Conflicts: tests/dbal/select_test.php
| * [ticket/10858] Move generic row seeking to DBALPatrick Webster2012-05-081-0/+43
| | | | | | | | | | | | Removed from: firebird, mssql_odbc, and mssqlnative PHPBB3-10858
* | Merge branch 'develop-olympus' into developOleg Pudeyev2012-03-081-0/+35
|\ \ | |/ | | | | | | | | | | | | | | | | | | | | * develop-olympus: [ticket/10653] Call get_row_count of base class in mysql get_estimated_row_count [ticket/9813] Only get posts table row count if we detected a fulltext index. [ticket/9813] Also use estimated row count of posts table for fulltext mysql. [ticket/10653] Fix parameter to substr() in unit tests. Should be 1, not -1. [ticket/10653] Unit tests for get_row_count() and get_estimated_row_count(). [ticket/10653] Add ability to count table rows to database abstraction layer. [ticket/9813] Use table status row count only if greater than 100000 or exact. [ticket/9813] Use SHOW TABLE STATUS to get search stats for native on MySQL.
| * [ticket/10653] Add ability to count table rows to database abstraction layer.Andreas Fischer2012-03-031-0/+35
| | | | | | | | PHPBB3-10653
* | Merge branch 'develop-olympus' into developOleg Pudeyev2012-01-121-5/+0
|\ \ | |/ | | | | | | | | * develop-olympus: [ticket/9079] Always log backtrace to error log when logging errors. [ticket/9079] Display backtrace on all E_USER_ERROR errors, not only SQL errors
| * [ticket/9079] Display backtrace on all E_USER_ERROR errors, not only SQL errorsAndreas Fischer2011-12-241-5/+0
| | | | | | | | PHPBB3-9079
* | [ticket/9916] Updating header license and removing Version $Id$Unknown2011-12-311-2/+1
| | | | | | | | PHPBB3-9916
* | Merge branch 'develop-olympus' into developNils Adermann2011-11-181-1/+1
|\ \ | |/ | | | | | | | | * develop-olympus: [ticket/10296] Fix CROSS JOIN with INNER JOIN on MSSQL, Postgres and Oracle [ticket/10296] Add unit test for CROSS JOIN with INNER JOIN
| * [ticket/10296] Fix CROSS JOIN with INNER JOIN on MSSQL, Postgres and Oracledmauri2011-11-151-1/+1
| | | | | | | | PHPBB3-10296
* | [ticket/10258] Add HTML5 meta charset tagIgor Wiedler2011-07-291-0/+1
| | | | | | | | | | | | | | This allows knowing the charset when saving web pages to disk. Also, this is supported by all browsers. PHPBB3-10258
* | [ticket/10258] Remove the meta charset tagIgor Wiedler2011-07-121-1/+0
| | | | | | | | | | | | | | The charset tag is useless, because if a charset content-type header is present it takes precedence. And phpBB always sends such a header. PHPBB3-10258
* | [ticket/10258] Remove X-UA-Compatible and imagetoolbar meta tagsIgor Wiedler2011-07-101-2/+0
| | | | | | | | | | | | These meta tags are IE specific and do not validate as HTML5. PHPBB3-10258
* | [ticket/10258] Change the DOCTYPE to HTML5Igor Wiedler2011-07-091-4/+4
| | | | | | | | PHPBB3-10258
* | Merge branch 'develop-olympus' into developNils Adermann2011-07-061-1/+1
|\ \ | |/ | | | | | | | | * develop-olympus: [ticket/9859] Changing all phpBB footers to match the new credit line [ticket/9859] New footer copyright line with registered symbol
| * [ticket/9859] Changing all phpBB footers to match the new credit lineYuriy Rusko2011-07-061-1/+1
| | | | | | | | PHPBB3-9859
* | Merge branch 'develop-olympus' into developAndreas Fischer2011-06-021-1/+1
|\ \ | |/ | | | | | | | | * develop-olympus: [ticket/9685] Test for databases that are able to nest transactions [ticket/9685] Consistently name the new sql_buffer_nested_transactions function
| * [ticket/9685] Consistently name the new sql_buffer_nested_transactions functionNils Adermann2011-06-021-1/+1
| | | | | | | | PHPBB3-9685
* | Merge branch 'develop-olympus' into developAndreas Fischer2011-03-151-0/+10
|\ \ | |/ | | | | | | * develop-olympus: [ticket/9685] Buffer posts for search indexing when using mssqlnative.
| * [ticket/9685] Buffer posts for search indexing when using mssqlnative.Nils Adermann2011-03-151-0/+10
| | | | | | | | | | | | | | | | To have a generic solution there is now a sql_buffer_nested_transaction() which indicates that the given SQL driver requires buffering to run a transaction while iterating over another result set. PHPBB3-9685
* | Merge branch 'develop-olympus' into developNils Adermann2011-01-161-1/+1
|\ \ | |/ | | | | | | | | | | | | | | * develop-olympus: [ticket/9859] Remove the years from the copyright statements in docs files. [ticket/9859] Remove the year from the copyright meta tag in docs/*.html [ticket/9859] Remove the meta copyright tag as well. [ticket/9859] Remove the credit line comment from all html files. [ticket/9859] Remove years in credit line from some more files.
| * [ticket/9859] Remove years in credit line from some more files.Andreas Fischer2011-01-161-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | Standard HTML output now includes: Powered by <a href="http://www.phpbb.com/">phpBB</a> &copy; phpBB Group Print output now includes: Powered by phpBB &copy; phpBB Group<br />http://www.phpbb.com/ This also fixes an inconsistency where "phpBB Group" was linked instead of "phpBB". PHPBB3-9859
* | [task/config-class] Implemented a config class to replace the global array.Nils Adermann2011-01-101-0/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | There is a phpbb_config class which simply holds an array and does not persist any data. It implements ArrayAccess, Countable and IteratorAggregate to allow regular use of configuration as if it was still an array. The phpbb_config_db class depends on an instance of the dbal and a cache driver. It obtains the configuration data from cache and database as necessary and persists data to the database. The functions set_config and set_config_count remain for backward compatability but they only call methods on the new config class now instead of directly manipulating the database and cache. PHPBB3-9988
* | [ticket/9556] Drop php closing tags, add trailing newlineIgor Wiedler2010-11-111-2/+0
| | | | | | | | | | | | | | | | | | | | | | | | Closing tags converted using Oleg's script. remove-php-end-tags.py -a . Trailing newlines added using the following where $ext is file extension. find . -type f -name "*.$ext" -print | xargs printf "e %s\nw\n" | ed -s; Extensions: php, css, html, js, xml. PHPBB3-9556
* | [feature/request-class] Check for existence of $requestIgor Wiedler2010-10-121-1/+1
| | | | | | | | PHPBB3-9716
* | [feature/request-class] Convert any direct access to $_* to use $requestIgor Wiedler2010-09-251-1/+2
|/ | | | PHPBB3-9716
* Add sql_bit_or() dbal method. Add ability to enable quick reply in all ↵Andreas Fischer2010-02-151-0/+18
| | | | | | forums. -- Voila ;-) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10491 89ea8834-ac86-4346-8a33-228a782c2dd0
* - replaced the drop down menu log filter thing with log searchingJim Wigginton2009-08-211-2/+2
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10041 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, i am very sorry, but this needs to be fixed.Meik Sievertsen2009-08-121-0/+18
| | | | | | | | | Generally, our config table is not really suited for holding large datasets. Because feed settings for the forums to enable news feeds and excluded forums rely on the forums itself we have decided to introduce a forum_options table where custom options can be stored. Additionally, for this to work across all DBMS we support, we added a new method to the DBAL for the bitwise AND operator. Also moved the forum/topic feed template variable to the location where they belong to (forum and topic view) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9965 89ea8834-ac86-4346-8a33-228a782c2dd0
* forgot this in r9909Meik Sievertsen2009-08-011-2/+1
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9911 89ea8834-ac86-4346-8a33-228a782c2dd0
* return errors if return_on_error is true for multi_insert (Patch by bantu)Meik Sievertsen2009-08-011-2/+7
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9909 89ea8834-ac86-4346-8a33-228a782c2dd0
* Re-arrange the re-order code to only run if multi-aliases are usedMeik Sievertsen2008-12-061-23/+21
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9178 89ea8834-ac86-4346-8a33-228a782c2dd0
* Enforce a requirement for some DBMS (Oracle, PostgreSQL, MSSQL) where the ↵Meik Sievertsen2008-12-051-1/+46
| | | | | | table order is quite important in some situations. ;) Since this does not affect the operation of the other DBMS the code is placed into dbal.php. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9175 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix sql_multi_insert() if called with non multi-dimensional array (Bug #32975)Meik Sievertsen2008-09-191-2/+2
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8900 89ea8834-ac86-4346-8a33-228a782c2dd0
* Ok, story real database server info, as well as caching itMeik Sievertsen2008-09-041-0/+5
| | | | | | Store it on installation too - allows us to check the db version used on installation and used currently to warn the user about incompatibilities git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8814 89ea8834-ac86-4346-8a33-228a782c2dd0
* change the way we do chmodd'ing. I know, my implementation really sucked... ↵Meik Sievertsen2008-08-221-1/+1
| | | | | | good we have motivated community members who point this out. ;) Thanks to faw for providing a way better function and for discussing and also abiding to our needs. :) LEW21 should maybe credited too... he gave the inspiration without knowing it. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8780 89ea8834-ac86-4346-8a33-228a782c2dd0
* close db connection before delivering file. Also make sure connection can't ↵Meik Sievertsen2008-08-211-1/+7
| | | | | | be closed twice. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8772 89ea8834-ac86-4346-8a33-228a782c2dd0
* force the use of sql_multi_insert() for multi inserts... also adjusted the ↵Meik Sievertsen2008-07-281-31/+32
| | | | | | coding guidelines accordingly. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8693 89ea8834-ac86-4346-8a33-228a782c2dd0
* #22365Meik Sievertsen2008-02-281-1/+1
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8419 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2025-04-10 07:36:02 +0000