aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/acp/acp_database.php
Commit message (Collapse)AuthorAgeFilesLines
...
* - store sql_layer directly within the layer itselfMeik Sievertsen2006-10-141-27/+12
| | | | | | | | - new method sql_multi_insert to circumvent db-specific hacks (hopefully not introduced any parsing errors) git-svn-id: file:///svn/phpbb/trunk@6497 89ea8834-ac86-4346-8a33-228a782c2dd0
* consistent acp layout regarding backlinks and messages.Meik Sievertsen2006-10-021-4/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@6428 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some bugfixesMeik Sievertsen2006-08-281-2/+2
| | | | | | | - using E_USER_WARNING if an error occurred within the ACP (sadly not able to use it as a default for trigger_error - it seems to be hardcoded in PHP) git-svn-id: file:///svn/phpbb/trunk@6320 89ea8834-ac86-4346-8a33-228a782c2dd0
* some updates. Also adjusted the utf tools and normalizer more to our coding ↵Meik Sievertsen2006-08-221-1/+1
| | | | | | guidelines. git-svn-id: file:///svn/phpbb/trunk@6312 89ea8834-ac86-4346-8a33-228a782c2dd0
* forgot to remove some debug code :PDavid M2006-08-171-6/+6
| | | | git-svn-id: file:///svn/phpbb/trunk@6297 89ea8834-ac86-4346-8a33-228a782c2dd0
* If this does not fix it, I am not quite so sure it *can* be fixed as this ↵David M2006-08-171-18/+45
| | | | | | output exactly models that of the official MySQL tools... git-svn-id: file:///svn/phpbb/trunk@6295 89ea8834-ac86-4346-8a33-228a782c2dd0
* Backup files are now named backup_[timestamp].sql.*Nils Adermann2006-08-061-3/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@6245 89ea8834-ac86-4346-8a33-228a782c2dd0
* OK...David M2006-07-241-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | This commit should increase the total number of BBCodes from 31 to 2040. Some things to watch out for: Each database likes to deal with binary data in its own, special way. They are, quite frankly, too cool for school. MySQL, MSSQL and Oracle all allow me to send in a default value for their binary column using a hex number. However, MSSQL forces me to send the specific data as a hex number and thus we must CAST it. PostgreSQL allows me to set a binary column, but with a twist. It demands that the default be in _octal_ and its datatype allows somewhere around a gigabyte's worth of BBCodes ( PGSQL users, we shut you down to 2040 for your own good! ) Firebird has no decent mechanism for allowing me to shuttle in binary data so I must force my way in. By virtue of triggers and a UDF, we ram in our default values. SQLite is the most bizarre of them all. They have no mechanism for turning an ASCII code into a ASCII character. Because of this, we have a trigger and a UDF (just like Firebird!) but with a twist! The UDF is defined on the PHP side of things instead of SQL. SQLite also demands that it's data be encoded before being sent off. Other notes: - SQLite installs again :D - Firebird nearly installs again :P - Database backup is not screwed up :P P.S. I hope nothing broke :D git-svn-id: file:///svn/phpbb/trunk@6209 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Make sure that the table is empty before we start cramming things inside :DDavid M2006-07-041-3/+27
| | | | git-svn-id: file:///svn/phpbb/trunk@6145 89ea8834-ac86-4346-8a33-228a782c2dd0
* - CAPTCHA: removed the extra slashDavid M2006-07-041-39/+49
| | | | | | | | | | | | | More backup stuff - Made some things nicer for some of the DBs - Made postgreSQL work on non empty databases - Made SQLite ultra fast on restore - Properly escaped (as far as I know) the profile data fields so that one may now use reserved words as column names git-svn-id: file:///svn/phpbb/trunk@6144 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Database: eh? meh.David M2006-07-031-7/+7
| | | | | | | - CAPTCHA: A little easier to see which options map to which controls git-svn-id: file:///svn/phpbb/trunk@6141 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Dramatic speed-up in SQLite backup codeDavid M2006-07-031-3/+38
| | | | | | | | | | - Wrote *another* patch around SQLite - SQLite has a lack of (among other things) solid definition of their tables. e.g. "foo" and foo are both valid col names... Database backup and profile creation are now both aware of such "features" meh, i hope this all works... git-svn-id: file:///svn/phpbb/trunk@6140 89ea8834-ac86-4346-8a33-228a782c2dd0
* bugs? bugs.David M2006-07-011-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6133 89ea8834-ac86-4346-8a33-228a782c2dd0
* oops?David M2006-06-201-12/+12
| | | | git-svn-id: file:///svn/phpbb/trunk@6106 89ea8834-ac86-4346-8a33-228a782c2dd0
* what? yeah...David M2006-06-201-27/+35
| | | | | | | | - turns out the backup issue was not a backup issue but a schema issue - let there be color git-svn-id: file:///svn/phpbb/trunk@6105 89ea8834-ac86-4346-8a33-228a782c2dd0
* fixes...David M2006-06-181-1/+13
| | | | git-svn-id: file:///svn/phpbb/trunk@6099 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Some fixesDavid M2006-06-171-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6077 89ea8834-ac86-4346-8a33-228a782c2dd0
* Another one bites the dustDavid M2006-06-131-12/+32
| | | | git-svn-id: file:///svn/phpbb/trunk@6059 89ea8834-ac86-4346-8a33-228a782c2dd0
* assorted backup fixesDavid M2006-06-121-15/+72
| | | | git-svn-id: file:///svn/phpbb/trunk@6053 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Fixed a bugDavid M2006-06-091-10/+39
| | | | | | | - PGSQL got updated, we now backup created domains git-svn-id: file:///svn/phpbb/trunk@6027 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, this one is rather large... the most important change:Meik Sievertsen2006-06-061-1/+1
| | | | | | | | | re-introduce append_sid: old style continues to work, not a performance hog as it was in 2.0.x -> structure is different apart from this, code cleanage, bug fixing, etc. git-svn-id: file:///svn/phpbb/trunk@6015 89ea8834-ac86-4346-8a33-228a782c2dd0
* - eh? meh.David M2006-05-071-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5893 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Make it impossible to open/delete/download files that don't exist :PDavid M2006-05-061-8/+13
| | | | git-svn-id: file:///svn/phpbb/trunk@5891 89ea8834-ac86-4346-8a33-228a782c2dd0
* eh? meh.David M2006-05-041-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5876 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Bug #1709David M2006-05-021-9/+17
| | | | git-svn-id: file:///svn/phpbb/trunk@5874 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Use specfic keysDavid M2006-04-261-30/+79
| | | | | | | | | - Unborked mysqli :D - PGSQL now supports sequences! woo! - adsrc is not cool anymore, adbin is where it's all at... git-svn-id: file:///svn/phpbb/trunk@5846 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Tuples? Nah,David M2006-04-241-12/+72
| | | | | | | | | - Install works w/ Oracle - Got the queries in the database acp to conform to the CS - profile acp now creates the proper alter column statement depending on the dbal git-svn-id: file:///svn/phpbb/trunk@5842 89ea8834-ac86-4346-8a33-228a782c2dd0
* i can't seem to not commit this debug code :-(David M2006-04-221-3/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@5817 89ea8834-ac86-4346-8a33-228a782c2dd0
* - extrapolation is uncool, lets get the _real_name instead of guessingDavid M2006-04-221-11/+17
| | | | | | | - fixed some bugs :P git-svn-id: file:///svn/phpbb/trunk@5816 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Olympus can now _install_ every database, more work to come on getting the ↵David M2006-04-211-12/+190
| | | | | | rest of the board to work git-svn-id: file:///svn/phpbb/trunk@5811 89ea8834-ac86-4346-8a33-228a782c2dd0
* - d'oh!David M2006-04-191-4/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@5804 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Firebird support for backing upDavid M2006-04-191-10/+210
| | | | | | | - some bug fixes :P git-svn-id: file:///svn/phpbb/trunk@5803 89ea8834-ac86-4346-8a33-228a782c2dd0
* - CSDavid M2006-04-181-71/+65
| | | | git-svn-id: file:///svn/phpbb/trunk@5799 89ea8834-ac86-4346-8a33-228a782c2dd0
* - More bugfixes (Sorry!)David M2006-04-181-3/+98
| | | | | | | - ODBC support git-svn-id: file:///svn/phpbb/trunk@5798 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Nobody wants my debug code :DDavid M2006-04-181-3/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@5797 89ea8834-ac86-4346-8a33-228a782c2dd0
* - An index can have multiple columns :PDavid M2006-04-181-10/+21
| | | | git-svn-id: file:///svn/phpbb/trunk@5796 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Olympus now properly works with MS SQLDavid M2006-04-181-7/+226
| | | | | | | | - DB backup system handles MS SQL - A few bug fixes to the backup system ;) git-svn-id: file:///svn/phpbb/trunk@5793 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Store and Download is now takes advantage of on-the-fly stuff correctlyDavid M2006-04-161-37/+76
| | | | | | | - Download and deletion of stored backups now allowed git-svn-id: file:///svn/phpbb/trunk@5789 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, thought about this now for too long. I think the best solution ↵Meik Sievertsen2006-03-251-27/+0
| | | | | | circumventing memory consumption and not introducing "hacks" is to seperate module information (and probably more in 3.2 for installation/uninstallation) from the main code. git-svn-id: file:///svn/phpbb/trunk@5725 89ea8834-ac86-4346-8a33-228a782c2dd0
* - We do On-the-fly file writting for everything in backups, should speed ↵David M2006-03-251-109/+209
| | | | | | | | | | | | things up - Removed the ability to make archives for backups... Its one sql file, no need to use some heavy archive to store it... - Made it easier to use the restore feature - Flushed the data buffer at the end of every insert statement, this should make large tables (like posts and topics) faster to backup - Some bug fixes :D git-svn-id: file:///svn/phpbb/trunk@5708 89ea8834-ac86-4346-8a33-228a782c2dd0
* - a bunch of bugfixes. :PMeik Sievertsen2006-03-211-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5678 89ea8834-ac86-4346-8a33-228a782c2dd0
* - ok, we should try to write the sql data as early as possible (to prevent ↵Meik Sievertsen2006-03-191-358/+379
| | | | | | extensive memory consumption). What needs to be done now? Trying to compress in realtime if specified and it would be also nice if the filenames had a more meaningful naming. :) git-svn-id: file:///svn/phpbb/trunk@5666 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Free some results!David M2006-03-191-44/+104
| | | | | | | - Nicer MySQLhandling (still needs work) git-svn-id: file:///svn/phpbb/trunk@5665 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Cleaned up some compress stuffDavid M2006-03-181-0/+790
- Replaced deprecated functions in the PostrgreSQL DBAL - Added an undefined constant during install - Oh, and we now have backups :D We currently work with all the MySQL flavors, PostgreSQL and SQLite... git-svn-id: file:///svn/phpbb/trunk@5647 89ea8834-ac86-4346-8a33-228a782c2dd0