aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
Commit message (Collapse)AuthorAgeFilesLines
...
* - add some language variables i will need at another location. ;)Meik Sievertsen2006-08-201-1/+1
| | | | | | | - also add X-Sendfile support to the download.php file. git-svn-id: file:///svn/phpbb/trunk@6308 89ea8834-ac86-4346-8a33-228a782c2dd0
* Minor schema change related to avatars so that they can be > 127px in sizeGraham Eames2006-08-203-6/+6
| | | | | | | | Add additional note about the install directory Remove some empty tags from the template git-svn-id: file:///svn/phpbb/trunk@6305 89ea8834-ac86-4346-8a33-228a782c2dd0
* Firebird :PDavid M2006-08-121-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6278 89ea8834-ac86-4346-8a33-228a782c2dd0
* bugfixesMeik Sievertsen2006-08-127-25/+25
| | | | git-svn-id: file:///svn/phpbb/trunk@6275 89ea8834-ac86-4346-8a33-228a782c2dd0
* update schema for oracleMeik Sievertsen2006-08-124-11/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@6270 89ea8834-ac86-4346-8a33-228a782c2dd0
* - oopsDavid M2006-08-121-166/+160
| | | | git-svn-id: file:///svn/phpbb/trunk@6265 89ea8834-ac86-4346-8a33-228a782c2dd0
* so.... what does this thing do?David M2006-08-116-105/+43
| | | | | | | | | | | well, the super fast, ultra efficient, massively huge BBCode handling system was implemented differently on each DBMS. Although this provided the best performance, the solution was a bit hacky. So what does this new thing do? We use base64 encoding to make everything nice and shiny, it turns into nice, safe characters that we can just jam into varchars on essentially any database. This has two implications: we must decode every bitfield we get AND we have slightly fewer IDs to work with. It goes down from 2040 BBCodes to 1512. We lose like a quarter of them :P P.S. I hope nothing broke :P git-svn-id: file:///svn/phpbb/trunk@6263 89ea8834-ac86-4346-8a33-228a782c2dd0
* upsMeik Sievertsen2006-08-071-97/+97
| | | | git-svn-id: file:///svn/phpbb/trunk@6251 89ea8834-ac86-4346-8a33-228a782c2dd0
* updated schema files. Also added a new load setting and some missing keys.Meik Sievertsen2006-08-077-100/+182
| | | | git-svn-id: file:///svn/phpbb/trunk@6250 89ea8834-ac86-4346-8a33-228a782c2dd0
* Databases that gain cool points:David M2006-08-064-4/+4
| | | | | | | | | | | | | | | | MSSQL Firebird SQLite Oracle Databases that lose cool points: MySQL PostgreSQL MySQL recently-ish gained character set features. PostgreSQL has zero, none; one must create the database as unicode. The only way I can think of getting PostgreSQL to do what I want it to do would require something rather crazy... git-svn-id: file:///svn/phpbb/trunk@6246 89ea8834-ac86-4346-8a33-228a782c2dd0
* This should end some issues we have been having regarding the proper binary ↵David M2006-08-061-151/+158
| | | | | | | | | encoding of stuff. :D Acyd Burn: quit breaking the schema :P git-svn-id: file:///svn/phpbb/trunk@6238 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixed some bugsMeik Sievertsen2006-08-057-1602/+1970
| | | | | | | | | - made imageset naming more consistent - updated every schema to be consistent and also fixed it (every db should install fine now) - git-svn-id: file:///svn/phpbb/trunk@6237 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixing some bugsMeik Sievertsen2006-08-017-159/+174
| | | | | | | | | - shortening some db columns to meet the requirements - correctly increase/decrease user post counts - fix the topic title length bug(s) git-svn-id: file:///svn/phpbb/trunk@6224 89ea8834-ac86-4346-8a33-228a782c2dd0
* - BBCode helpline is now customizableDavid M2006-08-016-0/+6
| | | | git-svn-id: file:///svn/phpbb/trunk@6223 89ea8834-ac86-4346-8a33-228a782c2dd0
* me === idiotDavid M2006-08-011-0/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6219 89ea8834-ac86-4346-8a33-228a782c2dd0
* Who is an idiot? I AMDavid M2006-07-301-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@6218 89ea8834-ac86-4346-8a33-228a782c2dd0
* - removed an accidentaly pasted line [Bug #3227]Nils Adermann2006-07-307-1/+7
| | | | | | | | | | - added missing images to acp_styles [Bug #2623] and added a new image btn_warn - use the style name when exporting a style instead of the non existant path [Bug #2343] - fixed an incorrect call of acp_styles::install_style() [Bug #2325] - always define $search_query in fulltext_mysql [Bug #3476] git-svn-id: file:///svn/phpbb/trunk@6216 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Fix OracleDavid M2006-07-281-6/+6
| | | | | | | | - Make MySQL schema a little different than the others... - Fix MCP_TOPIC git-svn-id: file:///svn/phpbb/trunk@6212 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixed the age calculation (note: turn on your brain before commiting ↵Nils Adermann2006-07-271-1/+1
| | | | | | | | | | | | | | | | something like this the next time) [Bug #3337] - removed the split_words array, introduced an enforced search_query - the forum used for global topics in the search is now a forum, and no longer a category [Bug #2561] - Bug #3404 - allow accessing reports by report_id, in contrast to mcp_queue this cannot just use the post id, since there can be multiple closed reports per post, so closed reports have to be accessed by report id, open reports, can optionally be accessed by report id or post id [Bug #3149] - only attempt to unflag reported topics on closing a report when there are any without other reported posts [Bug #3057] - updated fulltext_mysql to use the the search_query string - overwrote the old fulltext_native with our improved version since it consumes too much time to maintain boths and we would switch to the improved version later anyway - always show a link to search a user's posts even if the postcount is zero since he might only have posted in forums which do not count posts [Bug #3267] git-svn-id: file:///svn/phpbb/trunk@6211 89ea8834-ac86-4346-8a33-228a782c2dd0
* OK...David M2006-07-247-551/+669
| | | | | | | | | | | | | | | | | | | | | | | | | 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
* - some bugfixesMeik Sievertsen2006-07-201-1/+1
| | | | | | | | - set ip_check to A.B.C. by default - display postings in other encodings by default and present link to force the encoding as usual. git-svn-id: file:///svn/phpbb/trunk@6198 89ea8834-ac86-4346-8a33-228a782c2dd0
* fix the schema files as well as other tiny bugs.Meik Sievertsen2006-07-176-18/+18
| | | | git-svn-id: file:///svn/phpbb/trunk@6190 89ea8834-ac86-4346-8a33-228a782c2dd0
* hmm... This commit does not increase the number of BBCodes. However, this ↵David M2006-07-175-0/+15
| | | | | | does other things that we need to do first. This splits the usage of allow_* from the BBCode bitfield in forum descriptions, forum rules and group descriptions. This also fixes a tiny, tiny severe issue that nobody found :D I hope it works :P git-svn-id: file:///svn/phpbb/trunk@6188 89ea8834-ac86-4346-8a33-228a782c2dd0
* add not applied sql_escape in memberlistMeik Sievertsen2006-07-141-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@6178 89ea8834-ac86-4346-8a33-228a782c2dd0
* - renamed the following columns:Meik Sievertsen2006-07-137-5825/+4746
| | | | | | | | | | | | | | | comment -> attach_comment new, forwarded, unread, marked, deleted -> pm_new, pm_forwarded, pm_unread, pm_marked, pm_deleted module_name -> module_basename value -> lang_value - every column is now NOT NULL - every column is now having a DEFAULT value - hopefully mostly consistent across every db schema - untested schemas: sqlite, oracle, firebird git-svn-id: file:///svn/phpbb/trunk@6177 89ea8834-ac86-4346-8a33-228a782c2dd0
* - tackle some usability issuesMeik Sievertsen2006-07-097-12/+96
| | | | | | | | | - fix bug #3147 - added the lock-images made by SHS` - fixed MSSQL errors (adding the correct ESCAPE sequence) git-svn-id: file:///svn/phpbb/trunk@6161 89ea8834-ac86-4346-8a33-228a782c2dd0
* Realized that we never needed to CAST() in the first place after i ↵David M2006-07-091-4/+0
| | | | | | | | | remembered why i chose a DOMAIN implementation over a TYPE implementation... DOMAINs are simpler and thus the system is capable of determining what is _really_ going on (which is why it handles indexing for us :D) git-svn-id: file:///svn/phpbb/trunk@6160 89ea8834-ac86-4346-8a33-228a782c2dd0
* - display age in user profile and make it available on viewtopicNils Adermann2006-07-071-0/+1
| | | | | | | | | | | | | | | - various tiny bugfixes including [Bug #2351] [Bug #2549] [Bug #2681] [Bug #3015] - strip first, then change newlines [Bug #2403] - added support for creating user profiles to the login function (makes use of user_add), triggered by LOGIN_SUCCESS_CREATE_PROFILE constant - moved newest user updating from ucp_register to user_add function - renamed the admin_ auth module function to acp_ - added initialisation code to auth_apache which checks whether it will work - added user_add support to both auth_ldap and auth_apache - some auth_ldap tweaks, should work with users deeper in the organisation structure too now - adjusted global topics in mcp_report to work like mcp_queue git-svn-id: file:///svn/phpbb/trunk@6151 89ea8834-ac86-4346-8a33-228a782c2dd0
* some bugfixesMeik Sievertsen2006-07-065-9/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@6149 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add additional auth check to the permission roles modulesMeik Sievertsen2006-07-017-6/+7
| | | | | | | | | | | | - added new function to return globally used expressions (get_preg_expression($mode)). This should be very helpful in getting wide spread similar checks (regular expressions) to one place reducing the risk of forgetting to change every location if you fix one. ;) We will add additional ones later, at the moment only the email check is retrieved... - added "active module" var to the module class returning the current active module - changed call to image magick - add administrator to global moderators group by default - extend auth_option column a little bit - other bugfixes git-svn-id: file:///svn/phpbb/trunk@6135 89ea8834-ac86-4346-8a33-228a782c2dd0
* Some changes to the way folder images are handled for "special" topicsGraham Eames2006-06-251-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6126 89ea8834-ac86-4346-8a33-228a782c2dd0
* The ability to view hidden users should not be part of the standard or ↵Graham Eames2006-06-241-4/+4
| | | | | | restricted user roles git-svn-id: file:///svn/phpbb/trunk@6125 89ea8834-ac86-4346-8a33-228a782c2dd0
* Improve i18n by installing all available language packs on installGraham Eames2006-06-212-15/+12
| | | | | | | + unb0rk the mysql schema ;) git-svn-id: file:///svn/phpbb/trunk@6113 89ea8834-ac86-4346-8a33-228a782c2dd0
* schema! hooray!David M2006-06-215-76/+102
| | | | git-svn-id: file:///svn/phpbb/trunk@6110 89ea8834-ac86-4346-8a33-228a782c2dd0
* what? yeah...David M2006-06-206-5/+6
| | | | | | | | - 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
* This fixes a consistancy issue re the ISO language code on install, but ↵Graham Eames2006-06-181-1/+1
| | | | | | there's still a bigger issue related to thsi to look at git-svn-id: file:///svn/phpbb/trunk@6097 89ea8834-ac86-4346-8a33-228a782c2dd0
* I missed the version change. Anyone knows what is with the private checkin ↵Meik Sievertsen2006-06-171-1/+1
| | | | | | list? I seem to get no mails - it used to be fast. git-svn-id: file:///svn/phpbb/trunk@6093 89ea8834-ac86-4346-8a33-228a782c2dd0
* hey dev team mates, here are the brand new beta checkins (as promised). ↵Meik Sievertsen2006-06-171-2/+2
| | | | | | Please ensure this stays in our private cvs until the 23rd June, except the bug fixes. git-svn-id: file:///svn/phpbb/trunk@6092 89ea8834-ac86-4346-8a33-228a782c2dd0
* - SQLite handling in custom profilesDavid M2006-06-171-3/+2
| | | | | | | | - Removed an extra ';' - Install works with SQLite again git-svn-id: file:///svn/phpbb/trunk@6082 89ea8834-ac86-4346-8a33-228a782c2dd0
* - removed db cache (might re-appear, but for now we do not see the need for it)Meik Sievertsen2006-06-166-76/+10
| | | | | | | | | | | - all changes to styles/subsilver/template are purely cosmetic (no functional changes) - cosmetics - bugfixes - add index to modules table - use modules ordering code for forums too git-svn-id: file:///svn/phpbb/trunk@6073 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Change groups listed on index by defaultGraham Eames2006-06-091-19/+3
| | | | | | | - Change addition of bots on install git-svn-id: file:///svn/phpbb/trunk@6026 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fix some smaller bugsMeik Sievertsen2006-06-081-1/+1
| | | | | | | - removed custom profiles preview field from acp git-svn-id: file:///svn/phpbb/trunk@6022 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, sorry for this. :/Meik Sievertsen2006-06-077-441/+441
| | | | | | | - cleaned up table names/constants git-svn-id: file:///svn/phpbb/trunk@6021 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, this one is rather large... the most important change:Meik Sievertsen2006-06-061-34/+29
| | | | | | | | | 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
* DB stuff, nothing cool at all unless you use Oracle.David M2006-06-032-166/+166
| | | | git-svn-id: file:///svn/phpbb/trunk@6006 89ea8834-ac86-4346-8a33-228a782c2dd0
* - create forums by defaultMeik Sievertsen2006-06-016-24/+24
| | | | | | | | | | - hide prune options if not enabled - fixed module management enable/disable switch if in module itself - fixed some schema errors - adjusted $user->page array generation for developers calling scripts outside of phpBB root git-svn-id: file:///svn/phpbb/trunk@5995 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add support for min/max of numerical search backend settingsNils Adermann2006-05-306-6/+6
| | | | | | | | - change word_text maximum length - don't update search settings if nothing was changed git-svn-id: file:///svn/phpbb/trunk@5993 89ea8834-ac86-4346-8a33-228a782c2dd0
* - We are now at _seven_ different policies, not counting the non-GD version. ↵David M2006-05-301-3/+6
| | | | | | | | | | | | | We must remove something... - Made the CAPTCHA system idiot proof, disabling all the policies still lets an image get created. - We handle the case of a user having GD but no TTF. Thankfully, we have CAPTCHAs that don't need TTF! - Fixed that stupid language string... - Renamed Occlude to Overlap - Shape is now only enabled if TTF support is detected git-svn-id: file:///svn/phpbb/trunk@5985 89ea8834-ac86-4346-8a33-228a782c2dd0
* - making user_last_search a NULL column so MSSQL won't hate usNils Adermann2006-05-286-6/+6
| | | | | | | - making ignore_words and synonyms optional for language packs git-svn-id: file:///svn/phpbb/trunk@5983 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added search by author_id to solve problems with looking up posts of users ↵Nils Adermann2006-05-287-1/+7
| | | | | | | | | | | | | | with a name containing wildcards - user based flood control (seperate limits for users and guests) [Bug #1357] - inform the user about ignored words if he receives a "no words specified" message - solve problems with the number of entries per page [Bug #1973] - different height for popup window ["Bug" #1814] - speed improvements for posting and search reindexing in fulltext_native -> use php files for ignore words and synonyms git-svn-id: file:///svn/phpbb/trunk@5981 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2026-04-11 06:35:40 +0000