aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db
Commit message (Collapse)AuthorAgeFilesLines
* 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
* Firebird tooDavid M2007-06-241-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7791 89ea8834-ac86-4346-8a33-228a782c2dd0
* tweak the sql_like_expression feature a little bit to allow correct escapingMeik Sievertsen2007-06-249-34/+77
| | | | 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-234-0/+61
| | | | | | 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
* #12415David M2007-06-182-2/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@7778 89ea8834-ac86-4346-8a33-228a782c2dd0
* - tiny changesDavid M2007-06-183-56/+12
| | | | git-svn-id: file:///svn/phpbb/trunk@7773 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Oracle can't handle IN clauses with more than 1000 elements (Bug #12449)David M2007-06-162-34/+65
| | | | | | | - Firebird can now work properly in PHP4 git-svn-id: file:///svn/phpbb/trunk@7767 89ea8834-ac86-4346-8a33-228a782c2dd0
* correctly re-assign query resultMeik Sievertsen2007-06-128-8/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@7753 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Oracle gives us null instead of '', this is now fixed (thanks APTX)David M2007-06-091-1/+68
| | | | | | | - Oracle can now explain queries git-svn-id: file:///svn/phpbb/trunk@7741 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, mess around with the templates + fixing some bugs + adjusting headers ↵Meik Sievertsen2007-06-091-3/+3
| | | | | | for those files already modified to circumvent conflicts for those having their editor set to remove trailing spaces (not recommended!) git-svn-id: file:///svn/phpbb/trunk@7736 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Oracle, woe is you... I will say this much, this fixes Oracle's handling ↵David M2007-06-071-4/+110
| | | | | | of empty strings... We also fix custom profiles and now provide database size for Oracle... git-svn-id: file:///svn/phpbb/trunk@7721 89ea8834-ac86-4346-8a33-228a782c2dd0
* d'oh!David M2007-05-251-2/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7676 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added support for Oracle's easy connect namingDavid M2007-05-231-2/+15
| | | | git-svn-id: file:///svn/phpbb/trunk@7671 89ea8834-ac86-4346-8a33-228a782c2dd0
* #11255David M2007-05-221-1/+2
| | | | | | | | | | | | | | | #11259 #11291 #11335 #11457 #11473 #11475 #11511 #11523 #11527 git-svn-id: file:///svn/phpbb/trunk@7663 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-054-30/+42
| | | | | | | | | | | 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
* #10005, #10003, #10001, #9999, #9945, #9965, #9909, #9906, #9877, #9861, ↵Meik Sievertsen2007-04-221-0/+3
| | | | | | | | | | | | | | | | | | #9831, #9830, #9815, #9665, #9624 prosilver adjustments for important announcements in ucp - #9995 MCP fixes for user notes/warnings - #9981 Preserving imageset values on save/edit find a member link for Mass PM's - #9925 syndicate window.onload events where necessary - #9878 Duplicate topics in forums with announcements - #9840 Email template for forced re-activation - #9808 Topic pagination adjustment - #9763 Changed compose message layout in UCP - #9706, #9702 Fixed inline attachment font size (hopefully) git-svn-id: file:///svn/phpbb/trunk@7384 89ea8834-ac86-4346-8a33-228a782c2dd0
* my take on getting the bugs down... thanks to those also providing (usable) ↵Meik Sievertsen2007-04-121-1/+7
| | | | | | solutions to the problem. ;) Of course also to those reporting generally... git-svn-id: file:///svn/phpbb/trunk@7330 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixed Oracle's large data handlingDavid M2007-04-112-35/+114
| | | | | | | - Firebird explodes when you deal with single column update/inserts over 32767, we now turn these queries into prepared statements git-svn-id: file:///svn/phpbb/trunk@7326 89ea8834-ac86-4346-8a33-228a782c2dd0
* - (x)HTML bugDavid M2007-04-083-0/+120
| | | | | | | - 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
* - PostgreSQL can now use schemas. During install, under database name, enter ↵David M2007-04-011-2/+17
| | | | | | | | | databasename.schema - phpversion() to PHP_VERSION git-svn-id: file:///svn/phpbb/trunk@7255 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Firebird supports the standard format for escaping stuffDavid M2007-03-111-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7171 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
* #8538David M2007-03-061-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@7140 89ea8834-ac86-4346-8a33-228a782c2dd0
* - small MSSQL thingDavid M2007-03-041-1/+1
| | | | | | | - changed how we store tracking data git-svn-id: file:///svn/phpbb/trunk@7120 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-199-30/+27
| | | | | | | | | | | | | 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
* eh? meh.David M2007-02-031-11/+6
| | | | git-svn-id: file:///svn/phpbb/trunk@6961 89ea8834-ac86-4346-8a33-228a782c2dd0
* #7550David M2007-02-031-21/+27
| | | | | | | - this sucker required a cleverish regex, there should be no further problems. it is also optimized :D git-svn-id: file:///svn/phpbb/trunk@6959 89ea8834-ac86-4346-8a33-228a782c2dd0
* i hope this helps a bit. :oMeik Sievertsen2007-01-291-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6951 89ea8834-ac86-4346-8a33-228a782c2dd0
* #7424Meik Sievertsen2007-01-271-1/+1
| | | | | | | - rebuild username_clean column due to changes in utf8_clean_string() git-svn-id: file:///svn/phpbb/trunk@6934 89ea8834-ac86-4346-8a33-228a782c2dd0