aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db
Commit message (Collapse)AuthorAgeFilesLines
* add nils' request and super globals classMeik Sievertsen2008-12-251-1/+1
| | | | | | rename request:: to phpbb_request:: git-svn-id: file:///svn/phpbb/trunk@9230 89ea8834-ac86-4346-8a33-228a782c2dd0
* remove no longer necessary files... hoorayMeik Sievertsen2008-12-241-10/+0
| | | | git-svn-id: file:///svn/phpbb/trunk@9221 89ea8834-ac86-4346-8a33-228a782c2dd0
* fix postcount resync for situations where low and high post ids are higher ↵Meik Sievertsen2008-12-052-2/+47
| | | | | | | | | than step value, resulting in users having 0 posts. (Bug #38195) Enforce a requirement for some DBMS (Oracle, PostgreSQL, MSSQL) where the 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/trunk@9176 89ea8834-ac86-4346-8a33-228a782c2dd0
* - updated all code to use the request class instead of any direct access toNils Adermann2008-11-241-1/+1
| | | | | | | | | super globals - disabled super globals in common.php. See commit r9101 for more information - cleaned up/simplified a few lines along the way. git-svn-id: file:///svn/phpbb/trunk@9102 89ea8834-ac86-4346-8a33-228a782c2dd0
* db_tools from static to non-static due to the db dependancy (#31245)Meik Sievertsen2008-11-021-163/+139
| | | | git-svn-id: file:///svn/phpbb/trunk@9044 89ea8834-ac86-4346-8a33-228a782c2dd0
* [Change] Remove NUL-Bytes directly in request_var() for strings and within ↵Meik Sievertsen2008-10-024-4/+4
| | | | | | the custom DBAL sql_escape() functions (MSSQL, Firebird, Oracle) (reported by AdhostMikeSw) git-svn-id: file:///svn/phpbb/trunk@8968 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/trunk@8901 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/trunk@8867 89ea8834-ac86-4346-8a33-228a782c2dd0
* Get real dbms version instead of relying on php internal functions which ↵Meik Sievertsen2008-09-049-71/+188
| | | | | | only grab the local library version git-svn-id: file:///svn/phpbb/trunk@8821 89ea8834-ac86-4346-8a33-228a782c2dd0
* Merge in r8758, r8807, r8808, r8809Chris Smith2008-09-028-8/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@8810 89ea8834-ac86-4346-8a33-228a782c2dd0
* Merge of the language-specific custom path change Revision #r8782Meik Sievertsen2008-08-241-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@8786 89ea8834-ac86-4346-8a33-228a782c2dd0
* Merge chmod changes into trunkMeik Sievertsen2008-08-221-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8781 89ea8834-ac86-4346-8a33-228a782c2dd0
* mergeMeik Sievertsen2008-08-211-1/+7
| | | | git-svn-id: file:///svn/phpbb/trunk@8773 89ea8834-ac86-4346-8a33-228a782c2dd0
* margeMeik Sievertsen2008-07-281-31/+32
| | | | git-svn-id: file:///svn/phpbb/trunk@8696 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok... i hope i haven't messed too much with the code and everything is still ↵Meik Sievertsen2008-05-2911-12/+12
| | | | | | | | | | working. Changes: - Ascraeus now uses constants for the phpbb root path and the php extension. This ensures more security for external applications and modifications (no more overwriting of root path and extension possible through insecure mods and register globals enabled) as well as no more globalizing needed. - A second change implemented here is an additional short-hand-notation for append_sid(). It is allowed to omit the root path and extension now (for example calling append_sid('memberlist')) - in this case the root path and extension get added automatically. The hook is called after these are added. git-svn-id: file:///svn/phpbb/trunk@8572 89ea8834-ac86-4346-8a33-228a782c2dd0
* Some neat stuff, the new DBAL function has the potential of removing ↵David M2008-04-029-0/+241
| | | | | | | | | | | | | somewhere in the ballpark of 40% of all the DBAL code. It combines a few very common idioms into one statement, allowing us to implicitly use prepared statements. Short term advantages are the ability to remove the gross code that attempts to work around DB2, Oracle and Firebird. Long term advantages include removing the burden of sanitizing data (at least on input) from our end and placing it on shoulders of the backend PHP driver. Also included is a new posting API I am working on. It is not a real API in so much as it is a backend that a "nice" API could use. User submitted functions are welcome :) It represents a massive simplification in post and topic accounting and a generalization of concepts like "soft deletion" as it works across both topics and posts (yes, this has preliminary support for soft deletions). The only "interesting" problem left is global topics, this has yet to be solved. Enough talk, time for sleep. P.S. Sorry if I broke stuff, was not done on purpose :) git-svn-id: file:///svn/phpbb/trunk@8485 89ea8834-ac86-4346-8a33-228a782c2dd0
* #22355 and #22365Meik Sievertsen2008-02-281-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8421 89ea8834-ac86-4346-8a33-228a782c2dd0
* cross-ciHenry Sudhof2008-02-271-3/+5
| | | | git-svn-id: file:///svn/phpbb/trunk@8415 89ea8834-ac86-4346-8a33-228a782c2dd0
* Alright, this should give some improved performance :)David M2008-02-0311-331/+18
| | | | | | | | | | | | | | | | | | This is the end of random seek access to rows. If you have a compelling reason as to why they should stay, contact me. Else, they are gone forevermore... The following API calls are deprecated: acm::sql_rowseek() -> no replacement $db->sql_fetchfield($field, $rownum = false, $query_id = false) -> $db->sql_fetchfield($field, $query_id = false) Initial tests show that phpBB3 over four percent of memory against phpBB3.1 on an empty board. So far so good :) Other cool things: db2, MS SQL ODBC and MS SQL 2005 all use less memory because they do not need to reference the last executed query to handle random access seeks :) P.S. The crazy people using SVN: please report any issues with the new way we itterate through caches, I do not want to miss anything :) git-svn-id: file:///svn/phpbb/trunk@8372 89ea8834-ac86-4346-8a33-228a782c2dd0
* Merging revisions #r8346, #r8347 and #r8348Meik Sievertsen2008-01-291-0/+7
| | | | git-svn-id: file:///svn/phpbb/trunk@8349 89ea8834-ac86-4346-8a33-228a782c2dd0
* #19285David M2008-01-131-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8324 89ea8834-ac86-4346-8a33-228a782c2dd0
* I suppose I should fix this :PDavid M2008-01-131-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@8322 89ea8834-ac86-4346-8a33-228a782c2dd0
* arg, the voices in my head won't let me focus :PDavid M2008-01-111-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@8321 89ea8834-ac86-4346-8a33-228a782c2dd0
* db tools can now drop tablesDavid M2008-01-111-0/+64
| | | | git-svn-id: file:///svn/phpbb/trunk@8320 89ea8834-ac86-4346-8a33-228a782c2dd0
* - use proper OOP for db_toolsDavid M2008-01-111-212/+213
| | | | | | | - made it all static. If one of you disagree, you are free to change it. I just couldn't think of a reason of having it otherwise... git-svn-id: file:///svn/phpbb/trunk@8319 89ea8834-ac86-4346-8a33-228a782c2dd0
* we enter a brave new world...David M2008-01-101-33/+198
| | | | | | | | | - fix schema data so that it can now be used - replace the current system of packaging schemas with phpBB with a new system that dynamically generates the schemas on the fly - give the db tools package the power to create databases git-svn-id: file:///svn/phpbb/trunk@8318 89ea8834-ac86-4346-8a33-228a782c2dd0
* - phpBB now uses a less ancient version of OracleDavid M2008-01-092-11/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@8317 89ea8834-ac86-4346-8a33-228a782c2dd0
* - make viewforum work againDavid M2008-01-081-2/+2
| | | | | | | | | - remove the lower case functions, they were stupid anyway - added some indexes - added a group_name_clean column git-svn-id: file:///svn/phpbb/trunk@8315 89ea8834-ac86-4346-8a33-228a782c2dd0
* - a few tiny clean upsDavid M2008-01-0711-15/+434
| | | | | | | - a new MS SQL DBAL, it does not work so hot because of issues with the extension it depends on git-svn-id: file:///svn/phpbb/trunk@8313 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add DB2 supportDavid M2008-01-062-4/+587
| | | | | | | /me takes a nap git-svn-id: file:///svn/phpbb/trunk@8308 89ea8834-ac86-4346-8a33-228a782c2dd0
* the end of an era...David M2008-01-063-111/+41
| | | | | | | | | - MySQL < 4.1.3 support is removed - renamed mysql4 to mysql, no need to cause confusion - changed the cfg cacher, reduces file system lookups and include count by two on every page load git-svn-id: file:///svn/phpbb/trunk@8307 89ea8834-ac86-4346-8a33-228a782c2dd0
* Ch-ch-ch-changesDavid M2008-01-049-3/+150
| | | | | | | | | | | - Made us more DB independent by making many queries capability based instead of DB specific - Finished PHP5ifying of the acm_file class, now with some (hopefully) enhancements to its performance - Sped up viewforum considerably (also goes towards mcp_forum) I really hope I didn't explode CVS... git-svn-id: file:///svn/phpbb/trunk@8301 89ea8834-ac86-4346-8a33-228a782c2dd0
* oh boy...David M2008-01-037-110/+80
| | | | | | | - Migrate code base to PHP 5.1+ git-svn-id: file:///svn/phpbb/trunk@8295 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
generated by cgit v1.2.1 (git 2.21.0) at 2025-08-08 16:31:49 +0000