Register
phpBB.com Wiki · Home Projects Help

root / trunk / phpBB / install / install_install.php

install_install.php

View | Annotate | Download (71.1 KB)

# Date Author Comment
9044 View | Annotate 11/02/2008 12:36 PM acydburn

db_tools from static to non-static due to the db dependancy (#31245)

9027 View | Annotate 10/17/2008 04:56 PM acydburn

gah@trunk

9025 View | Annotate 10/17/2008 12:33 PM acydburn

Disable referer validation on install if it is not possible to determine correct referer due to a proxy setup (Bug #32765)

8889 View | Annotate 09/19/2008 03:17 PM Kellanved

Okay, that is pretty raw, but better to have it in place than trying to play catch-up. Introducing an early stage of CAPTCHA modules.

8821 View | Annotate 09/04/2008 04:10 PM acydburn

Get real dbms version instead of relying on php internal functions which only grab the local library version

8812 View | Annotate 09/04/2008 01:39 PM toonarmy

Remove caching of templates from the database completely, themes is cut down ready for a complete chop, and fix the installer :)

8781 View | Annotate 08/22/2008 03:32 PM acydburn

Merge chmod changes into trunk

8759 View | Annotate 08/15/2008 03:00 PM aptx

PHP5.3 compatibility.

8659 View | Annotate 06/18/2008 11:32 PM aptx

Change 5.1.0 to 5.2.0

8637 View | Annotate 06/09/2008 07:10 PM acydburn

#27395

8599 View | Annotate 06/04/2008 05:38 PM naderman

removed executable props [Bug #6464]

8590 View | Annotate 06/04/2008 01:23 PM acydburn

fix adm redirect

8583 View | Annotate 06/03/2008 04:57 PM acydburn

add missing constant to config file

8572 View | Annotate 05/29/2008 02:25 PM acydburn

ok… i hope i haven’t messed too much with the code and everything is still 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.

8477 View | Annotate 03/29/2008 01:08 AM naderman

Go away evil carriage returns\!

8452 View | Annotate 03/18/2008 03:47 PM acydburn

merging… again

8349 View | Annotate 01/29/2008 04:57 PM acydburn

Merging revisions #r8346, #r8347 and #r8348

8319 View | Annotate 01/11/2008 06:07 AM davidmj

- use proper OOP for db_tools
- 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…

8318 View | Annotate 01/10/2008 10:46 PM davidmj

we enter a brave new world…

- 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

8315 View | Annotate 01/08/2008 07:44 AM davidmj

- make viewforum work again
- remove the lower case functions, they were stupid anyway
- added some indexes
- added a group_name_clean column

8313 View | Annotate 01/07/2008 04:19 PM davidmj

- a few tiny clean ups
- a new MS SQL DBAL, it does not work so hot because of issues with the extension it depends on

8308 View | Annotate 01/06/2008 02:46 PM davidmj

- add DB2 support
/me takes a nap

8307 View | Annotate 01/06/2008 03:21 AM davidmj

the end of an era…
- 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

8295 View | Annotate 01/03/2008 06:00 PM davidmj

oh boy…
- Migrate code base to PHP 5.1+

8294 View | Annotate 01/03/2008 03:37 PM kellanved

cross-ci to the head

8290 View | Annotate 12/27/2007 06:34 PM acydburn

#16695
#s17235

8248 View | Annotate 11/19/2007 05:44 PM acydburn

further updates

8224 View | Annotate 11/03/2007 09:31 PM acydburn

further fixes
- fix infinite loop on checking ban for those not having ever visited the page (or removed all session cookies)
- avatar width/height switched in language files
- fix windows switching to background on IE7 (smlies window for example)

8211 View | Annotate 10/21/2007 01:26 PM acydburn

make sure we always check for a valid directory handle

8167 View | Annotate 10/12/2007 06:11 PM kellanved

#14704
That should solve the issue for the user table, I hope that it doesn’t manifest at other places.

8139 View | Annotate 10/04/2007 08:50 PM acydburn

#i42
new password hashing mechanism for storing passwords

8130 View | Annotate 10/04/2007 01:33 PM acydburn

deregister globals to install too

8116 View | Annotate 10/01/2007 07:43 PM acydburn

#i112

8072 View | Annotate 08/30/2007 11:21 PM acydburn

necessary changes…

7961 View | Annotate 07/27/2007 07:33 PM acydburn

err, forgot to commit

7929 View | Annotate 07/23/2007 06:25 PM acydburn

needed fixes

7920 View | Annotate 07/22/2007 10:11 PM acydburn

try to normalize everything…

7884 View | Annotate 07/14/2007 05:44 PM acydburn

a bunch of fixes

7875 View | Annotate 07/12/2007 06:14 PM acydburn

some more fixes

7866 View | Annotate 07/11/2007 05:03 PM acydburn

some fixes

7860 View | Annotate 07/10/2007 05:14 PM acydburn

some fixes here and there

7830 View | Annotate 07/03/2007 05:36 PM acydburn

let’s see if i can break something. :o

7818 View | Annotate 07/01/2007 06:09 PM acydburn

some fixes… most importantly the ability to update the board with the automatic files while having fsockopen disabled (instead, the update file information will be used, which may be inaccurate if the admin did a mistake).

7736 View | Annotate 06/09/2007 01:11 PM acydburn

ok, mess around with the templates + fixing some bugs + adjusting headers for those files already modified to circumvent conflicts for those having their editor set to remove trailing spaces (not recommended!)

7734 View | Annotate 06/08/2007 06:01 PM davidmj

same old, same old

7733 View | Annotate 06/08/2007 06:00 PM davidmj

another Oracle fix

7684 View | Annotate 05/26/2007 02:44 PM kellanved

#11431

7644 View | Annotate 05/19/2007 05:44 PM acydburn

Allow pre-setting language dependant data in schema_data.sql… specified with {L_*}, also create the search index on installation

7631 View | Annotate 05/18/2007 04:33 PM acydburn

Disable DEBUG by default, enable backtrace by default

7583 View | Annotate 05/15/2007 03:48 PM kellanved

Be more explicit regarding the requirements.

Once more, this introduces language variables.

7527 View | Annotate 05/11/2007 02:25 PM acydburn

We do not support nesting code tags – #10763
#10741
Confirm box on pruning forums – #10619
Not stripping empty lines on parsing messages – #10579
Remove reports alongside with users – #10501

7478 View | Annotate 05/05/2007 11:33 PM kellanved

Introducing a new CAPTCHA. Thanks to Robert “Xore” Hetzler for idea & code and Ashley “Neothermic” Pinner for her expertise and contributions to said code.

This introduces new language variables, so take note translators :).

7469 View | Annotate 05/05/2007 12:22 PM acydburn

Better support for nested transactions…

7455 View | Annotate 05/03/2007 04:29 PM acydburn

some language-specific adjustements
fix prune users (adding the list of users to the confirmation page)
tried to fix the show/hide trigger in ACP by not using width: auto; (which gets somehow inherited to each other element)

7429 View | Annotate 04/30/2007 12:46 PM kellanved

Prepare to be yelled at and brace for the tide of bug reports: I had hoped we would not have to do this, but it seems that we have to.

Route all avatar downloads through download.php – adrien
-Change the way inline attachments are delivered
-Fixes a few (unreported) bugs, notably avatar upload during group generation
#10079

7421 View | Annotate 04/28/2007 04:24 PM davidmj

I am not having much luck these days…

7420 View | Annotate 04/28/2007 04:18 PM davidmj

typo

7417 View | Annotate 04/28/2007 02:02 PM davidmj

ok, now let it actually work :P

7415 View | Annotate 04/28/2007 02:54 AM davidmj

oops

7414 View | Annotate 04/28/2007 02:53 AM davidmj

installer tries to install language specific imageset entries

7302 View | Annotate 04/08/2007 05:14 PM acydburn

#9659
#9569

7255 View | Annotate 04/01/2007 02:39 PM davidmj

- PostgreSQL can now use schemas. During install, under database name, enter databasename.schema
- phpversion() to PHP_VERSION

7180 View | Annotate 03/12/2007 10:43 PM acydburn

remove user with empty username_clean…

7078 View | Annotate 02/26/2007 12:00 AM shs

A couple changes to improve usability:

1) Reworded the “Install missing” explain for the converter
2) “Forked” the final page of a clean install to give two options… #1 being going to the convertor and #2 being the already existing “Take me to your ACP!” stuff.

Shouldn’t have broken anything else, though the i18n/L10n lot will need to update their strings for this. ;)

7010 View | Annotate 02/19/2007 05:15 AM davidmj

- forgot a few places :P

6995 View | Annotate 02/17/2007 12:06 AM naderman

- allow converting from one database to another, no need for tables to be in one database anylonger (this also allows switching from one DBMS that was used with phpBB2 to another DBMS supported by phpBB3 including new systems available in Olympus only)
- abstracted some installation code that is now relevant to converting as well into functions_install.php (mostly DBMS selection related)
- fixed a weird smiley path problem, no idea why nobody else noticed this, maybe my fix was incorrect?
- forgot to commit a file last time

6956 View | Annotate 02/02/2007 04:36 PM acydburn

only very tiny fixes.

6934 View | Annotate 01/27/2007 01:30 PM acydburn

#7424
- rebuild username_clean column due to changes in utf8_clean_string()

6927 View | Annotate 01/24/2007 06:19 PM acydburn

- fix severe bug with email hash calculation
- fix bug in convertor not correctly converting config values

6912 View | Annotate 01/20/2007 06:58 PM acydburn

- fixing some bugs
- removing utf8 characters from email files (has been discussed internally, you guys know why)
- making sure some opendir calls are checked before calling readdir.

6910 View | Annotate 01/20/2007 05:20 AM davidmj

#7256

6908 View | Annotate 01/19/2007 12:58 PM acydburn

some opendir/closedir fixes

6872 View | Annotate 01/10/2007 05:47 PM acydburn

fix some general bugs and some convertor related

6863 View | Annotate 01/09/2007 02:33 AM davidmj

- installer now checks if the page size is correct for Firebird
- Firebird now has a proper explain page

6842 View | Annotate 01/05/2007 04:31 PM acydburn

unique cookie name anyone?

6826 View | Annotate 12/31/2006 05:56 PM acydburn

- telling the admin for what the board contact and board email addresses are used for and also making sure this explanation is correct ;)
- fixes for bugs #6694, #6664 and #6662

6815 View | Annotate 12/27/2006 05:51 PM davidmj

#6600

6803 View | Annotate 12/24/2006 02:11 PM acydburn

some fixes today
- most important change is the consolidation of the display attachment functions; merging them together to have one function we need to call.

6785 View | Annotate 12/21/2006 03:07 AM davidmj

#6460, thanks to ToonArmy for the patch :D
- removed pregenerated template variables from the installer

6781 View | Annotate 12/18/2006 06:29 PM acydburn

- Modules are not added correctly [#6370]
- Minor bug in ucp_prefs_personal.html (Opera) [#6348]
- MCP-Warnings section colspan problem in Opera [#6338]
- Loading extensions on install [#6332]
- Adjust PM rules if folder removed [#6326]
- #6318
- Coppa registration [#6306]
- Quick-Mod Topic Type Changes Fail when Topic == Global [#6228]
- added the possibility to change topic type for more than one topic (within mcp)

6730 View | Annotate 12/08/2006 04:20 PM acydburn

- re-add script_path for “strange configurations” to let them force the generated urls correctly
- show rank title if no rank image present in memberlist
- other fixes.

6701 View | Annotate 12/02/2006 07:16 PM davidmj

- pretty serious speed improvement for strtoupper/strtolower
- mbstring envrio checks
#5774

6678 View | Annotate 11/27/2006 10:34 PM davidmj

don’t mind me, I just forgot something :D

6676 View | Annotate 11/27/2006 10:24 PM davidmj

#5640

6650 View | Annotate 11/24/2006 03:59 PM acydburn

rather large update, most important things done:
- implemented provided patch/diff file for bug #5350 (Highway of Life) with some tiny changes and alterations
- more username/colour changes/fixes
- added a note about PM rule-dependant message removals so the user is not wondering too much if he can’t remember his rules. :)
- some column changes to fix unicode issues
- bugfixes

6629 View | Annotate 11/21/2006 07:20 PM acydburn

decrease the barrier for E_ALL error reporting and email traces from DEBUG_EXTRA to DEBUG

6628 View | Annotate 11/21/2006 07:15 PM acydburn

- fixing a bunch of bugs
- moved the install trigger error to sessions and also disabled it for those having DEBUG_EXTRA enabled.
i hope not having introduced too many new bugs.

6602 View | Annotate 11/18/2006 06:26 PM acydburn

let us be more strict while testing for writeable directories.

6584 View | Annotate 11/15/2006 04:35 PM acydburn

- fixes for the following bugs:
#5326
#5318
#5304
#5290
#5288
#5278
#5276
#5272
#5266
- also fixed the “Call-time pass-by-reference” bug #5252
- within this step changed the normalize calls to require references.
- added captcha size variables to the class scope (suggestion was posted at area51)

6581 View | Annotate 11/13/2006 11:44 PM davidmj

@#$x%x!

6570 View | Annotate 11/12/2006 03:42 PM davidmj

blah blah blah :D

6563 View | Annotate 11/10/2006 03:56 PM davidmj

- cleaned up firebirdsql
- cleaned up install

6552 View | Annotate 11/04/2006 06:19 PM acydburn

- use the $var_ary for settings in a more logical way (hopefully removes the clutter and shows where which variable is set how)
- hopefully utf8 passwords are working too now

6549 View | Annotate 11/04/2006 12:09 AM davidmj

- compress is nicer (fixed a bug :P)
- UTF-8 code is nicer (fixed a bug :P)
- new CAPTCHA. Replaced the old one for size and usability issues. The old CAPTCHA will most likely be released as a separate package

6548 View | Annotate 11/03/2006 10:05 PM acydburn

ok, i am an idiot…

6546 View | Annotate 11/03/2006 06:50 PM acydburn

- make sure the sql layer for mysql always states mysql4 and get to mysql if using mysql < 4
- assign some default vars to email templates (we always need some basic ones)

6545 View | Annotate 11/03/2006 12:26 PM acydburn

- implemented the suggested html_entity_decode function made by david
- fixed string length checking by also decoding entities for the sake of checking
- used the new html_entity_decode function

6517 View | Annotate 10/22/2006 03:32 PM acydburn

- now username changes should work as desired
- removed some extract() calls

6511 View | Annotate 10/19/2006 03:55 PM acydburn

Revised attachment categories a bit
Fixes for the following bugs:
#4830
#4818
#4816
#4810
#4808
#4798
#4796
#4772
#4662
#4646
#4546
#4524
#4270

I hope not having introduced additional severe errors :)

6509 View | Annotate 10/18/2006 11:39 PM davidmj

#4812
#4804

6497 View | Annotate 10/14/2006 04:56 PM acydburn

- store sql_layer directly within the layer itself
- new method sql_multi_insert to circumvent db-specific hacks
(hopefully not introduced any parsing errors)

6495 View | Annotate 10/14/2006 03:02 PM grahamje

Need to set the clean form on install

6461 View | Annotate 10/07/2006 09:07 PM grahamje

Make the UTF tools available – recent changes require them in the install and they are likely to be needed in conversion as well
Fix some broken redirects
Change the structure of language packs we scan for.
(language packs should be named in the form xx-yy – all lowercase with hyphens as the separator)

6452 View | Annotate 10/07/2006 02:36 PM acydburn

tried to begin adjusting all string functions where applicable – still a lot to do.
i hope i catched all relevant sections and did not mess something up.

6447 View | Annotate 10/06/2006 08:43 PM acydburn

- support re-caching of theme data if stylesheet.css changed and load_tplcompile enabled
- mcp fixes
- fixed some usability issues

6440 View | Annotate 10/04/2006 08:25 PM grahamje

Check that we actually have a valid fp

6436 View | Annotate 10/03/2006 08:35 PM acydburn

- extend config checking to include check for writeable path
- removed not utilized user_allow_email column from schema
- removed inactive groups (they had no use at all, since inactive users are not able to login)
The only benefit those brought are distinguish users – but this is no longer needed too due to the inactive code present. This also allows us to retain group memberships as well as default settings for users being set inactive due to profile changes.
- rewrote user_active_flip to support multiple users and a mode, as well as coping with the aforementioned changes
- implemented updated jabber class to support SRV server records and for better jabberd2 support.
- jabber errors now logged to the error log with a full transaction
- fixed user_delete calls to include usernames where possible and also update last post information correctly
- implemented additioal checks to user management to cope with common mistakes
- On installation, guess the required mysql schema as best as possible. Users now only need to decide if they want to use the mysqli extension or not (mysqli selected by default) and no longer need to know their mysql version.
- founders do not need to re-activate their account on profile changes
- remove older session if re-authentication was successful (re-authentication always assigns a new session id)
- set the cookie directly instead of using php’s function
- added inactive_remind to see which users got deactivated because of reminders (or re-activation) sent out

hopefully not introduced too many bugs – those testing with CVS releases, please concentrate on user registration, activation, profile changes (email/password)...

6433 View | Annotate 10/03/2006 05:17 AM davidmj

complete check for FB

6431 View | Annotate 10/02/2006 05:33 PM davidmj

remove my debug code

6429 View | Annotate 10/02/2006 05:31 PM davidmj

#4564

6425 View | Annotate 10/01/2006 06:20 PM davidmj

- Goodbye MySQL4, hello unified MySQL driver. MySQL 3.23 to MySQL 5.0 are now in one driver.

6422 View | Annotate 10/01/2006 10:48 AM davidmj

- forgot to make the same change to the ODBC driver
- MySQL 3.x works now
- FirebirdSQL is now on the same level as MySQL and PostgreSQL, zero hacks exist inside the core code now

6394 View | Annotate 09/23/2006 02:27 PM grahamje

A reworking of how we handle inactive users

6381 View | Annotate 09/19/2006 06:50 AM davidmj

- Oracle now works with large amounts of text
- MSSQL now works :P (sans UTF-8 support)
- The current schema files work well enough to install, etc. but must be tightened. Will get to it when I get some time…

6375 View | Annotate 09/16/2006 09:36 PM grahamje
  • Fix default language option if more than one pack is present
  • Fix moderator roles to match their description
  • Add new forum role for closer mapping of converted permissions
6374 View | Annotate 09/16/2006 04:04 PM grahamje

Extra check on table prefix for mysql

6373 View | Annotate 09/16/2006 03:27 PM davidmj

oops

6371 View | Annotate 09/16/2006 08:07 AM davidmj

bug fixes
schema changes
i really hope nothing went wrong

6364 View | Annotate 09/13/2006 06:08 PM acydburn

- fixed some bugs
- changed attachment handling a bit
- tried to remove target tags out of the code
- do not add session ids to urls for bots as well as not creating a new session on each page view for them

I bet i introduced some bugs too. ;)

6361 View | Annotate 09/08/2006 10:06 PM grahamje

Add the lock file to allow dynamic menus

6345 View | Annotate 09/02/2006 03:33 PM acydburn

some changes/fixes

6337 View | Annotate 08/30/2006 09:44 PM grahamje

Correctly set IP address on initial post and user profile

6308 View | Annotate 08/20/2006 09:50 PM acydburn

- add some language variables i will need at another location. ;)
- also add X-Sendfile support to the download.php file.

6298 View | Annotate 08/17/2006 03:23 PM davidmj
  • empty log message *
6291 View | Annotate 08/13/2006 08:21 PM grahamje

Add GD to the list of optional requirements since it allows more VC images to be used

6275 View | Annotate 08/12/2006 05:10 PM acydburn

bugfixes

6268 View | Annotate 08/12/2006 09:00 AM grahamje

Check the prefix length to ensure that the key names are within the maximum for that DBMS

6265 View | Annotate 08/12/2006 03:38 AM davidmj

- oops

6263 View | Annotate 08/11/2006 11:52 PM davidmj

so…. what does this thing do?

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

6255 View | Annotate 08/09/2006 05:53 PM davidmj

Nobody found this bug so i guess nobody has such an old DB :P

MySQL < 4.1.2 has a broken varbinary. TINYBLOB is (2**8)-1 characters = 255. This means we can let older DBs use our stuff without any fear.

6241 View | Annotate 08/06/2006 07:25 PM naderman

- finally making the age calculation work [Bug #3582]
- replacing all occurances of L_NONE with a more specific string [Bug #3494]
- a few corrections to html id attributes in the installer
- using correct permission in mcp_report [Bug #2471]
- allow deleting the avatar, when no upload method is enabled and hide the delete button if no avatar is set

6238 View | Annotate 08/06/2006 07:52 AM davidmj

This should end some issues we have been having regarding the proper binary encoding of stuff. :D
Acyd Burn: quit breaking the schema :P

6237 View | Annotate 08/05/2006 05:49 PM acydburn

- fixed some bugs
- made imageset naming more consistent
- updated every schema to be consistent and also fixed it (every db should install fine now)
-

6209 View | Annotate 07/24/2006 12:08 PM davidmj

OK…

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

6203 View | Annotate 07/23/2006 10:59 PM grahamje

Include a link to the post by default when issuing a warning

6201 View | Annotate 07/23/2006 07:43 PM grahamje

Make sure that the language does get passed between all modules

6200 View | Annotate 07/23/2006 06:04 PM grahamje

Changes to the language handling during the install

6196 View | Annotate 07/20/2006 10:27 PM grahamje
  • Missing image in imageset editing
  • Sort the list of images
  • Enforce default username limits on install
6177 View | Annotate 07/13/2006 02:51 PM acydburn

- renamed the following columns:
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

6161 View | Annotate 07/09/2006 06:23 PM acydburn

- tackle some usability issues
- fix bug #3147
- added the lock-images made by SHS`
- fixed MSSQL errors (adding the correct ESCAPE sequence)

6156