aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db
Commit message (Collapse)AuthorAgeFilesLines
* Add sql_bit_or() dbal method. Add ability to enable quick reply in all ↵Andreas Fischer2010-02-153-0/+28
| | | | | | forums. -- Voila ;-) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10491 89ea8834-ac86-4346-8a33-228a782c2dd0
* Forgot to properly update the file header of mssqlnative.php, revising ↵Nils Adermann2010-02-111-2/+4
| | | | | | r10489 [Bug #57055] git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10490 89ea8834-ac86-4346-8a33-228a782c2dd0
* Support for Microsoft's Native SQL Server Driver for PHP - Patch by Chris ↵Nils Adermann2010-02-112-2/+657
| | | | | | | | | | | | | Pucci at Microsoft [Bug #57055] If you are using SQL Server, please try to test this new dbal so we can safely include it in 3.0.8. If you want to try it on a current phpBB version you can apply the latest version of the patch to your board which you can find attached to the bug tracker ticket (look in the comments for the latest version, the one in the ticket itself is outdated): http://www.phpbb.com/bugs/phpbb3/ticket.php?ticket_id=57055 git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10489 89ea8834-ac86-4346-8a33-228a782c2dd0
* Database updater now separates ADD COLUMN from SET NOT NULL and SET DEFAULT, ↵Nils Adermann2010-01-261-1/+23
| | | | | | when using PostgreSQL <= 7.4 [Bug #54435] git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10446 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix Bug #55785 - Correct call to mysql_pconnect().Andreas Fischer2009-12-231-1/+1
| | | | | | | Note: As pointed out by gn#36, phpBB doesn't use persistent connections at all. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10375 89ea8834-ac86-4346-8a33-228a782c2dd0
* Several fixes:Meik Sievertsen2009-10-301-1/+1
| | | | | | | | Fix Bug #53335 Fix wrong unique index fetch for oracle and sqlite Fix alter column definition for firebird (although the query will fail in these circumstances [primary key] because firebird (again) does not support simple things... although... mssql/oracle having the same "problems", but there you are able to do more advanced queries) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10248 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix another bug in WHERE statement rewrite for oracle. The bug(s) actually ↵Meik Sievertsen2009-10-301-1/+1
| | | | | | consist of not detecting correct parameters and then resulting in partial WHERE statements, where non-detected strings are simply removed. grrrrrr git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10247 89ea8834-ac86-4346-8a33-228a782c2dd0
* saw this bug while debugging... we really really need another layer in 3.1.x ↵Meik Sievertsen2009-10-301-1/+1
| | | | | | (better sooner than later), but retaining backwards compatibility. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10246 89ea8834-ac86-4346-8a33-228a782c2dd0
* fix table creation in db_tools. Meik Sievertsen2009-10-241-0/+6
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10231 89ea8834-ac86-4346-8a33-228a782c2dd0
* I think i need to check other DBMS more often. :/Meik Sievertsen2009-09-241-5/+29
| | | | | | | | - fix index check for sqlite, firebird and oracle - add check for unique index - fix changing default value for column in mssql (add constraint) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10185 89ea8834-ac86-4346-8a33-228a782c2dd0
* And now i feel even more dirty because i had to adjust the oracle hack to ↵Meik Sievertsen2009-09-211-1/+50
| | | | | | allow for queries > 4k to let it recognise concatenated strings and strings having the character ")" in it. I also added fallback code in case our regex splits too much. :/ git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10175 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
* Lifted minimum requirement for Firebird DBMS from 2.0+ to 2.1+.Meik Sievertsen2009-08-131-2/+2
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9970 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, i am very sorry, but this needs to be fixed.Meik Sievertsen2009-08-123-0/+28
| | | | | | | | | 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
* Fix database updater and db tools to support multiple column ↵Meik Sievertsen2009-07-081-17/+229
| | | | | | changes/additions/removals with SQLite git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9735 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fix sql_column_exists for firebird (had same problem as oracle)Meik Sievertsen2009-06-131-2/+12
| | | | | | - fix sql_column_change for firebird (interbase6 only supports TYPE and SET DEFAULT, but not the same syntax ass ADD COLUMN) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9586 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix sql_column_exists for oracle (oracle uses uppercase table names)Meik Sievertsen2009-06-131-1/+1
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9583 89ea8834-ac86-4346-8a33-228a782c2dd0
* due to popular demand... this may be quite useful for automatic installer ↵Meik Sievertsen2009-04-291-0/+22
| | | | | | and modifications git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9495 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix column handling in db updater, custom profile fields an db tools for ↵Meik Sievertsen2009-04-281-3/+3
| | | | | | firebird DBMS (Bug #44555) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9492 89ea8834-ac86-4346-8a33-228a782c2dd0
* Fix bug in postgresql db layer for LIMIT ALL clauses (reported by JRSweets)Meik Sievertsen2009-03-301-3/+3
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9412 89ea8834-ac86-4346-8a33-228a782c2dd0
* Set connection encoding for MySQL versions 4.1.0 to 4.1.2. This may fix some ↵Meik Sievertsen2009-03-161-2/+2
| | | | | | conversion issues with special characters. (Bug #41805) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9378 89ea8834-ac86-4346-8a33-228a782c2dd0
* fix bug #42635 (missed identity)Meik Sievertsen2009-03-081-3/+27
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9361 89ea8834-ac86-4346-8a33-228a782c2dd0
* - adjust db_tools again to not remove any schema (they may be required)Meik Sievertsen2009-02-281-34/+13
| | | | | | - fill dbms version if not yet filled git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9351 89ea8834-ac86-4346-8a33-228a782c2dd0
* add more checks to schema changesMeik Sievertsen2009-02-281-12/+28
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9349 89ea8834-ac86-4346-8a33-228a782c2dd0
* add "drop table" and "create table" functionality to db_tools. Meik Sievertsen2009-02-281-21/+349
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9347 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-052-2/+47
| | | | | | 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
* Remove NUL-Bytes directly in request_var() for strings and within the custom ↵Meik Sievertsen2008-10-024-4/+4
| | | | | | DBAL sql_escape() functions (MSSQL, Firebird, Oracle) (reported by AdhostMikeSw) git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8967 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
* Use correct port delimiter for MSSQL connections in windows. (Bug #16615)Meik Sievertsen2008-09-172-2/+6
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8866 89ea8834-ac86-4346-8a33-228a782c2dd0
* direct callsMeik Sievertsen2008-09-041-5/+3
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8815 89ea8834-ac86-4346-8a33-228a782c2dd0
* Ok, story real database server info, as well as caching itMeik Sievertsen2008-09-0410-66/+183
| | | | | | 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
* Refine fix for #31445 originally committed in r8758Chris Smith2008-09-028-8/+8
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8809 89ea8834-ac86-4346-8a33-228a782c2dd0
* some changes for proper code documentationMeik Sievertsen2008-08-231-2/+2
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8783 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
* Correctly return results for nested cached queries (Bug #31445 - Patch by faw)Chris Smith2008-08-148-8/+8
| | | | git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@8758 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
* hopefully fixing bug #14890 - need to test laterMeik Sievertsen2007-11-191-6/+10
| | | | git-svn-id: file:///svn/phpbb/trunk@8247 89ea8834-ac86-4346-8a33-228a782c2dd0
* MSSQL works properly with SQL update related toolsDavid M2007-10-161-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8198 89ea8834-ac86-4346-8a33-228a782c2dd0
* small fixMeik Sievertsen2007-10-121-1/+1
| | | | | | | - david: please review the mssql change git-svn-id: file:///svn/phpbb/trunk@8165 89ea8834-ac86-4346-8a33-228a782c2dd0
* dumdidum... sorry. ;)Meik Sievertsen2007-10-0510-60/+69
| | | | git-svn-id: file:///svn/phpbb/trunk@8147 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2025-11-13 18:36:26 +0000