aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db
Commit message (Collapse)AuthorAgeFilesLines
...
* 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
* misc SQLite bugsDavid M2007-09-221-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8101 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some language tweaks suggested by JohnMeik Sievertsen2007-09-131-0/+1405
| | | | | | | | - some bug fixes - finally adding db_tools... git-svn-id: file:///svn/phpbb/trunk@8088 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
* #14207David M2007-08-241-2/+6
| | | | git-svn-id: file:///svn/phpbb/trunk@8069 89ea8834-ac86-4346-8a33-228a782c2dd0
* #14211David M2007-08-241-1/+1
| | | | | | | - doing is_null on Oracle is not good, we return empty strings instead git-svn-id: file:///svn/phpbb/trunk@8068 89ea8834-ac86-4346-8a33-228a782c2dd0
* patch by david for #14182Meik Sievertsen2007-08-241-7/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@8066 89ea8834-ac86-4346-8a33-228a782c2dd0
* increase the odbc limit (64k is too low, the theme data itself is >64k)Meik Sievertsen2007-08-161-1/+22
| | | | git-svn-id: file:///svn/phpbb/trunk@8038 89ea8834-ac86-4346-8a33-228a782c2dd0
* turn on strict mode for databases that support itDavid M2007-08-142-1/+51
| | | | git-svn-id: file:///svn/phpbb/trunk@8029 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13916David M2007-08-021-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7995 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13874David M2007-07-301-1/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@7981 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
* #13151David M2007-07-091-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7849 89ea8834-ac86-4346-8a33-228a782c2dd0
* #13033David M2007-07-052-12/+12
| | | | git-svn-id: file:///svn/phpbb/trunk@7835 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2025-11-12 23:11:00 +0000