aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db/dbal.php
Commit message (Collapse)AuthorAgeFilesLines
* [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
* DBAL extension motivated by #22125Henry Sudhof2008-02-271-3/+5
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8414 89ea8834-ac86-4346-8a33-228a782c2dd0
* #17025Meik Sievertsen2008-01-291-0/+7
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8346 89ea8834-ac86-4346-8a33-228a782c2dd0
* commit all transactions on closing the db (there is only one, but we support ↵Meik Sievertsen2007-12-061-1/+5
| | | | | | inner transactions - logically speaking) git-svn-id: file:///svn/phpbb/trunk@8271 89ea8834-ac86-4346-8a33-228a782c2dd0
* - on database update, execute garbage_collection(). This ensures a proper ↵Meik Sievertsen2007-12-061-1/+6
| | | | | | | | | | | closed db and written cache - on sql errors returning (and not triggering an error) execute the rollback too both "bugs" resulted in transactions left open if a query returned an error on database update preventing a clean update. Symptoms being for example oracle users not having all database info updated, the version number not changing or config variables not written. git-svn-id: file:///svn/phpbb/trunk@8270 89ea8834-ac86-4346-8a33-228a782c2dd0
* further updatesMeik Sievertsen2007-11-191-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8248 89ea8834-ac86-4346-8a33-228a782c2dd0
* dumdidum... sorry. ;)Meik Sievertsen2007-10-051-10/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@8147 89ea8834-ac86-4346-8a33-228a782c2dd0
* some tiny fixes...Meik Sievertsen2007-09-121-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@8087 89ea8834-ac86-4346-8a33-228a782c2dd0
* necessary changes...Meik Sievertsen2007-08-301-2/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@8072 89ea8834-ac86-4346-8a33-228a782c2dd0
* this should work fine now...Meik Sievertsen2007-07-241-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7937 89ea8834-ac86-4346-8a33-228a782c2dd0
* tweak the sql_like_expression feature a little bit to allow correct escapingMeik Sievertsen2007-06-241-7/+17
| | | | git-svn-id: file:///svn/phpbb/trunk@7789 89ea8834-ac86-4346-8a33-228a782c2dd0
* new wrapper for LIKE expressions to streamline the fixes. We actually need ↵Meik Sievertsen2007-06-231-0/+15
| | | | | | to adjust them for different DBMS as well as SQLite2 not supporting escaping characters in LIKE statements (which is a reason why we think about dropping sqlite support completely). git-svn-id: file:///svn/phpbb/trunk@7788 89ea8834-ac86-4346-8a33-228a782c2dd0
* oh my god - what did he do? Adding attachment display to post/topic review, ↵Meik Sievertsen2007-05-191-3/+3
| | | | | | queue, reports, post details, mcp topic view... fixing other tiny things along the line. git-svn-id: file:///svn/phpbb/trunk@7642 89ea8834-ac86-4346-8a33-228a782c2dd0
* The Grand Copyright Year Unification... breakdown of years, of ↵Jonathan Stanley2007-05-171-1/+1
| | | | | | | | | | | | | | | | re-copyrighting due to major changes: 2000 - phpBB1.0.0 released 2002 - phpBB2.0.0 released & phpBB2.2.x commenced 2005 - phpBB2.2.x is canned with phpBB3.0.0 to succeed it, prosilver also starts development proper 2007 - phpBB3.0.x... Anyone that so much as whimpers "OMG copyright year is wrong!!!1~"... read: http://en.wikipedia.org/wiki/Copyright Considering copyright (from the year started) last for at least 50 years, and up to 70 years after the author's _death_, even phpBB1.x.x will remain copyrighted well into the 22nd century. git-svn-id: file:///svn/phpbb/trunk@7624 89ea8834-ac86-4346-8a33-228a782c2dd0
* Better support for nested transactions...Meik Sievertsen2007-05-051-4/+24
| | | | git-svn-id: file:///svn/phpbb/trunk@7469 89ea8834-ac86-4346-8a33-228a782c2dd0
* - changed the way we do forum accounting in phpBB, far less intensive and ↵David M2007-05-051-16/+15
| | | | | | | | | | | much faster. sync() recalculates the number of topics and posts using just the topics table instead of having to join topics and posts together. However, even this can be avoided if we know what operation is happening and an auto sync is not in action. Since MCP operations are "known", we can provide very fast MCP operations. - changed the way we decide if a DB gets multi value support. Old method uses switch/case, new method assumes a DB can't unless the DB says it can via a property I hope nothing is broken :P git-svn-id: file:///svn/phpbb/trunk@7466 89ea8834-ac86-4346-8a33-228a782c2dd0
* - (x)HTML bugDavid M2007-04-081-0/+1
| | | | | | | - added functionality for MySQL 5.0.37+ (on the community branch), EXPLAIN is now more detailed. To reap full benefits, use *NIX OS. This may or may not stay git-svn-id: file:///svn/phpbb/trunk@7301 89ea8834-ac86-4346-8a33-228a782c2dd0
* Sync... applying the two line change as happened to the ACP templates ↵Jonathan Stanley2007-03-071-0/+2
| | | | | | earlier in the week. git-svn-id: file:///svn/phpbb/trunk@7142 89ea8834-ac86-4346-8a33-228a782c2dd0
* #8354Meik Sievertsen2007-03-011-2/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@7101 89ea8834-ac86-4346-8a33-228a782c2dd0
* - clean up mssql and mssql_odbc, mssql now uses a different method of ↵David M2007-02-191-5/+2
| | | | | | | | | | | | | dealing with IDENTITY - clean up firebird, I will consider changing it to use fetch array instead of fetch object. it's identity code already uses this method as of right... now :D - fix a tiny bug in MySQL's driver (remember to pass the connect id to all DBAL functions) - add new_link as a new param for sql_connect. This allows you to make connections that are not dependant on each other. This is done for our friends mysql, mssql, postgresql and oracle. Now for everybody else.. (I said this was clever ;) MySQLi and SQLite should always spawn a new connection when you call it while mssql_odbc and firebird both will create new links if you give them different params (different creds) than the previous connection(s). Thus we can always promise new links :D - fixed a bug in the converter - cleaned up the dbal a little git-svn-id: file:///svn/phpbb/trunk@7009 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fix some oddities (doubled spaces for example)Meik Sievertsen2007-01-261-1/+1
| | | | | | | | | | - changed the way make_forum_select() is returning the forum list - now including skipped forums but being disabled. This should make identifying the correct forum much more easier. - Changed some permission namings based on suggestions by the community - Tried to comply to the permission field ordering within the language files while displaying permission sets. Hopefully it's worth the additional processing time. - Disable submit buttons after clicking for installation and conversions. git-svn-id: file:///svn/phpbb/trunk@6930 89ea8834-ac86-4346-8a33-228a782c2dd0
* sql_in_set only allows empty sets if the last parameter is set to true, ↵Nils Adermann2007-01-201-7/+20
| | | | | | otherwise it will throw an error message and a backtrace git-svn-id: file:///svn/phpbb/trunk@6913 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2026-04-03 00:34:29 +0000