Register
phpBB.com Wiki · Home Projects Help

root / trunk / phpBB / install / database_update.php

database_update.php

View | Annotate | Download (46.7 KB)

# Date Author Comment
9042 View | Annotate 11/02/2008 12:22 PM acydburn

i had these changes sitting… must’ve been a merge not committed (and because we do not use svn 1.5 as the client version i am not able to say which they were)

8672 View | Annotate 06/23/2008 08:22 PM acydburn

merge? merge.

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.

8571 View | Annotate 05/28/2008 03:05 PM Kellanved

Merging mime and referer checks into the Trunk

8484 View | Annotate 03/31/2008 04:58 PM acydburn

merging some changes

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

Go away evil carriage returns\!

8391 View | Annotate 02/23/2008 03:23 PM acydburn

merge revisions #r8384, #r8387, #r8388, #r8389 and #r8390

8317 View | Annotate 01/09/2008 01:21 AM davidmj

- phpBB now uses a less ancient version of Oracle

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

8310 View | Annotate 01/06/2008 06:00 PM acydburn

- Do not split topic list for topics being promoted to announcements after been moved to another forum (Bug #18635)
- Allow editing usernames within database_update on username cleanup (Bug #18415)
- Fixing wrong sync() calls if moving all posts by a member in ACP (Bug #18385)
- Check entered imagemagick path for trailing slash (Bug #18205)
- Use proper title on index for new/unread posts (Bug #13101) – patch provided by Pyramide
- Allow calls to $user->set_cookie() define no cookie time for setting session cookies (Bug #18025)

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+

8274 View | Annotate 12/12/2007 11:54 AM acydburn

and the final version number ;)

8270 View | Annotate 12/06/2007 09:55 AM acydburn

- on database update, execute garbage_collection(). This ensures a proper 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.

8267 View | Annotate 12/05/2007 04:18 PM acydburn

fix unread/new pm columns

8261 View | Annotate 12/04/2007 05:20 PM naderman

Cleaned usernames contain only single spaces, so ‘a_name’ and ‘a__name’ are treated as the same name [Bug #15634]

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

further updates

8247 View | Annotate 11/19/2007 02:33 PM acydburn

hopefully fixing bug #14890 – need to test later

8223 View | Annotate 11/03/2007 12:10 PM acydburn

some changes

8198 View | Annotate 10/16/2007 04:59 PM davidmj

MSSQL works properly with SQL update related tools

8183 View | Annotate 10/14/2007 05:46 PM acydburn

more fixes…

8178 View | Annotate 10/14/2007 02:12 PM acydburn

forum rules, forum descriptions and group description bbcode uid fixes

8156 View | Annotate 10/09/2007 01:21 PM kellanved

new clicky thingies.

8152 View | Annotate 10/06/2007 01:45 PM acydburn

automatic updater supporting batch-processing diff

8151 View | Annotate 10/06/2007 01:20 PM acydburn

i think david just forgot these. ;)

8143 View | Annotate 10/05/2007 03:14 PM kellanved

#i43

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

#i42
new password hashing mechanism for storing passwords

8131 View | Annotate 10/04/2007 02:03 PM acydburn

- fixed database updater
- fixed hook function call in database updater
- fixed bot agent detection (we used a wildcard within the w3c-agent, therefore we should really support this. ;))

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

deregister globals to install too

8128 View | Annotate 10/04/2007 06:42 AM davidmj

#i71
#i72

8120 View | Annotate 10/03/2007 05:05 PM kellanved

Ok, here comes a big one. Poor updater. Also requires testing.

#i91
#i92
#i93
#i94
#i95
#i96

8101 View | Annotate 09/22/2007 11:58 PM davidmj

misc SQLite bugs

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

necessary changes…

8064 View | Annotate 08/23/2007 03:41 PM naderman

- added an option to specify a port for the LDAP server
- restricted access to “Recent searches” to admins who are allowed to configure search [Bug #14085]

8047 View | Annotate 08/18/2007 03:52 PM naderman

- allow multibyte search configuration
- added ldap_user_filter to add additional restrictions on the user objects used for authentication [Bug #12627]
- improved ldap explanations a bit
- display searchable subforums of invisible parents in advanced search forum selection [Bug #11395]

8041 View | Annotate 08/17/2007 06:02 PM acydburn

oki doki

8032 View | Annotate 08/14/2007 08:53 PM davidmj

add a noramlizer wrapper just for updates

8022 View | Annotate 08/12/2007 08:16 PM acydburn

fix bug with cron execution for all new RC4 installations as well as those having manually updated.

8001 View | Annotate 08/03/2007 06:42 AM davidmj

OH NO, WHAT HAS HE DONE?!
- bug in the normalizer, we must renormalize… again…

7991 View | Annotate 07/31/2007 11:00 PM davidmj

oops

7990 View | Annotate 07/31/2007 10:27 PM davidmj

- found a bug, it caused MSSQL not being able to use templates stored in the DB since the first beta. removing pointless auto_increment

7987 View | Annotate 07/31/2007 04:52 PM acydburn

my changes so far…

7986 View | Annotate 07/31/2007 05:26 AM davidmj

users are people too

7985 View | Annotate 07/30/2007 11:15 PM davidmj

LEAVE

7984 View | Annotate 07/30/2007 11:13 PM davidmj

add PostgreSQL support

7983 View | Annotate 07/30/2007 11:10 PM davidmj

remove debug code…

7982 View | Annotate 07/30/2007 11:09 PM davidmj

reset bad style related ids

7980 View | Annotate 07/29/2007 04:44 PM davidmj

#13862

7968 View | Annotate 07/28/2007 01:47 PM acydburn

same right for all. ;) Groups table using same column types as the users table for avatars.

7967 View | Annotate 07/28/2007 12:41 PM acydburn

let it work under different languages.

7954 View | Annotate 07/26/2007 05:51 PM acydburn

do not get too excited

7947 View | Annotate 07/25/2007 07:58 PM naderman

- cron now uses a locking variable to make sure it does not spawn too many webserver processes [Bug #12741]

7946 View | Annotate 07/25/2007 06:06 PM acydburn

please have a second look at the change within session.php – we had a few “doubled” keys within the db…

7937 View | Annotate 07/24/2007 05:17 PM acydburn

this should work fine now…

7933 View | Annotate 07/24/2007 10:57 AM naderman

should speed things up a bit

7932 View | Annotate 07/23/2007 08:59 PM acydburn
  • empty log message *
7929 View | Annotate 07/23/2007 06:25 PM acydburn

needed fixes

7923 View | Annotate 07/23/2007 01:05 AM naderman

Ok, so finally we have the code to update clean usernames from RC3 :D Updating code is really a pain as all functions are the buggy old versions :(
Our new method of finding clean usernames also fixes Bug #12143

7909 View | Annotate 07/19/2007 10:38 PM acydburn

again, a lot of bug fixes

7876 View | Annotate 07/12/2007 07:26 PM davidmj

#13179

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

some more fixes

7871 View | Annotate 07/12/2007 01:27 AM davidmj

- Bring MS SQL up to par

7870 View | Annotate 07/12/2007 12:25 AM davidmj

- This is well tested and should work, it is not pretty but it does finally bring parity across versions. Tested is RC1->RC2->RC3->RC4-dev, RC2->RC3->RC4-dev and RC3->RC4-dev

7858 View | Annotate 07/10/2007 05:59 AM davidmj

d’oh!

7857 View | Annotate 07/10/2007 05:54 AM davidmj

thankfully, we never used this feature

7855 View | Annotate 07/10/2007 12:39 AM davidmj

- better PostgreSQL support for ALTER TABLE
- stress tested sql_list_index(), found some bugs in it :/

7854 View | Annotate 07/09/2007 11:53 PM davidmj

#12965

7852 View | Annotate 07/09/2007 07:17 PM davidmj
  • empty log message *
7845 View | Annotate 07/08/2007 08:40 PM acydburn
  • empty log message *
7844 View | Annotate 07/08/2007 08:26 PM acydburn

ok… someone messed up. We will update the packages with the updated database_update script.

7842 View | Annotate 07/08/2007 06:39 PM acydburn

changes…

7839 View | Annotate 07/07/2007 04:42 AM davidmj

#12661

7826 View | Annotate 07/03/2007 07:12 AM davidmj

#12947

7821 View | Annotate 07/02/2007 12:35 PM kellanved

There might be incorrectly converted smilies in the DB. Let’s try to repair them.

7813 View | Annotate 06/30/2007 05:04 PM acydburn

some fixes…

7802 View | Annotate 06/27/2007 05:46 PM acydburn

reset permissions within the update process (also on re-runs of the updater due to it being outside of the version code).

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!)

7722 View | Annotate 06/07/2007 07:41 PM kellanved

Adding a little more exlanation about flash.
Enabling FLASH per default while leaving the default permissions to disable it.
There might be no mods and admins visible one a board
#12185

7715 View | Annotate 06/06/2007 04:00 PM kellanved

Changing the stance we take towards flash. (DelvarWorld, NeoThermic)
fixing a few smaller bugs.

#12007
#12003

7687 View | Annotate 05/26/2007 06:38 PM acydburn

hopefully not too late in the game. Checked in new jabber class (the class done by the flyspray project). It would be nice if this could be tested with more servers – jabber.org seems to work fine…
- other fixes

7675 View | Annotate 05/25/2007 02:22 PM davidmj

#11637

7669 View | Annotate 05/24/2007 01:37 AM davidmj

- Handle ISO-8859-8-i
- Renamed two indicies for Oracle support #11457

7667 View | Annotate 05/23/2007 05:47 PM acydburn

cleanup ;)

7666 View | Annotate 05/23/2007 05:05 PM kellanved

This probably broke things :|
#10697
#11421
#11555
#11421

7656 View | Annotate 05/20/2007 04:59 PM acydburn

dumdidum

7624 View | Annotate 05/17/2007 11:12 PM shs

The Grand Copyright Year Unification… breakdown of years, of 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.

7621 View | Annotate 05/17/2007 06:33 PM acydburn

so some version_compare magic. :o

7581 View | Annotate 05/15/2007 12:55 PM acydburn

added subforum read/unread icons (thanks to thatbitextra for providing them).
fixed issue with forum passwords only alloweing ASCII in administration while allowing non-ASCII on user-entered passwords

7497 View | Annotate 05/07/2007 03:19 PM acydburn

fixing some bugs
changed the way we are handling bookmarks. No order_id required, really! Order by last post time as suggested by BartVB.

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 :).

7466 View | Annotate 05/05/2007 06:53 AM davidmj

- changed the way we do forum accounting in phpBB, far less intensive and 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

7452 View | Annotate 05/02/2007 11:08 PM acydburn

some tiny changes

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

7374 View | Annotate 04/19/2007 10:59 PM davidmj

#9902

7355 View | Annotate 04/15/2007 12:59 PM naderman

- m_warn is no longer a local moderation permission
- magic urls should properly use html entities
- speed up posting on big boards, MAX query can be simplified a lot in certain cases
- user IP list should be labelled with “Other users” [Bug #9707]

7353 View | Annotate 04/13/2007 08:34 AM shs

icon_back_top.gif wasn’t imagesetified and was an ugly inlined image in viewtopic… bleurgh! :P

7337 View | Annotate 04/13/2007 01:12 AM davidmj

#9795

7328 View | Annotate 04/12/2007 12:08 AM davidmj

#9789

7313 View | Annotate 04/09/2007 08:33 PM davidmj

#9725

7308 View | Annotate 04/09/2007 07:10 AM davidmj

- Firebird is people too! (Firebird works again)
- small style.php bug

7306 View | Annotate 04/09/2007 04:59 AM shs

Blargh! Continuation of bug #9546 and some initial RTL related stuff. All prosilver images now have dimensions defined and CSS tidied up and refactored such that all localised images will show with their proper dimensions (eg: English imageset, “Locked Topic” and “New PM” had “phantom” white space to their right as clickable area)... which means languages like Turkish and Chinese, which typically have much short language strings can now have more “compact” images… and whatever languages that need 15+ characters for the equivalent of “Post” can now do so without having to shoehorn into a 96px width “big button”.

7305 View | Annotate 04/08/2007 07:48 PM davidmj

remove debug entries :P

7304 View | Annotate 04/08/2007 07:40 PM davidmj

- overhaul of imagesets
imagesets are now “intelligently” multilingual, one may use imagesets inside of CSS files now (as well as properties like the width and height of an imageset’s image)
all previous styles should change their imageset.cfg to be like prosilver and subsilver2 (notice how there is now an imageset.cfg in the /en folder, there should be one for each language)

7237 View | Annotate 03/28/2007 10:28 AM acydburn

database update fixes for a smooth update. ;)

7225 View | Annotate 03/24/2007 04:31 PM davidmj

#5275

7216 View | Annotate 03/22/2007 04:15 PM acydburn

some fixes… hopefully not breaking something. :o

7206 View | Annotate 03/18/2007 01:05 PM davidmj

better sorting is more important ;)

7202 View | Annotate 03/17/2007 03:32 AM davidmj

#4052
- utf8_general_ci picked over utf8_unicode_ci for performance reasons

7192 View | Annotate 03/14/2007 11:45 PM acydburn

using the correct layer may help in creating indexes. :)

7185 View | Annotate 03/14/2007 04:02 AM shs

Do the syncorama dance! :D/< :D\< :D|-<

7182 View | Annotate 03/13/2007 11:00 PM naderman

- improvements to search indexing performance, espacially tidy() by adding a word_count column, the database update from b5 to next version will take quite a while on bigger databases, I also lowered the default common word threshold from 20 to 5 percent, big boards might want to use 3 or 2 percent, 20 was way too high
- added some keys to ACL tables, great improvement of auth query performance
- we will only add new language strings to install.php language file and won’t modify any, if a language file is updated before phpBB is updated, the updater will not overwrite the user’s language with english if install.php was modified

7119 View | Annotate 03/04/2007 05:05 PM naderman

- added a UNIQUE index on the wordmatch table
- some modifications of search indexing which might improve the speed and hopefully fixes [Bug #8352]
- added logging to search indexing [Bug #8384]

7077 View | Annotate 02/25/2007 11:10 PM davidmj

forgot this :P

7075 View | Annotate 02/25/2007 11:07 PM davidmj

#8342

7074 View | Annotate 02/25/2007 10:23 PM davidmj

#7882

7072 View | Annotate 02/25/2007 07:09 PM davidmj

- small bug

7036 View | Annotate 02/22/2007 08:58 PM davidmj

#8244
- cleaned up the TRUNCATE/DELETE FROM in the native search backend
- fixed an imporoper default value on some upgrades

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

- forgot a few places :P

6974 View | Annotate 02/08/2007 11:11 PM naderman

- Pruning doesn’t lower user post counts anymore [Bug #7676]
- Better resync explanations in ACP
- relative link to board shouldn’t result in an empty link [Bug #7762]
- allow spaces to define multiple classes [Bug #7700]
- forgot addslashes for password conversion [Bug #7530]
- adjusted get_post_data call in mcp_post to retrieve read tracking info [Bug #7538]
- fixed sorting in reports/queue by properly generating the pagination links [Bug #7666]
- send UTF-8 charset header in database_update.php [Bug #7564]

6970 View | Annotate 02/06/2007 08:09 PM acydburn

Some… fixes… laying around here.

6960 View | Annotate 02/03/2007 03:17 AM davidmj

#7742 (and some unfound bugs :D), thanks Mr_E

6958 View | Annotate 02/03/2007 12:07 AM davidmj

#7742

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

only very tiny fixes.

6946 View | Annotate 01/28/2007 04:37 PM acydburn

some important changes to let the update work. ;)

6939 View | Annotate 01/27/2007 05:41 PM acydburn

some very tiny adjustements.

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

6915 View | Annotate 01/21/2007 07:33 PM acydburn

fixing some bugs, most being submitted grammatical/spelling errors.

6899 View | Annotate 01/18/2007 11:00 AM acydburn

fixing some bugs i introduced while fixing other bugs. :)

6894 View | Annotate 01/17/2007 07:41 PM acydburn

ok, handled some bugs… the most important being validate_username (the variable passed to validate_data([...]array(‘username’, [...])) and updating group listings while doing relevant group actions. Oh, and PM icons are working now. :o

6865 View | Annotate 01/09/2007 03:10 PM acydburn

- some bugfixes
- bugfixes for the convertor (typecasting for example was totally broken)

6816 View | Annotate 12/27/2006 06:43 PM acydburn

Unused Code inside function update_forum_data [Bug #6606]
Copy permissions protection for groups [Bug #6594]
HTML issues in ACP [Bug #6580, #6578]
Always send the correct encoding [related to bug #6576]
Mass email fixes for first loop iteration [Bug #6570]
Extension groups to be allowed in PM’s and/or Posts [Bug #6558]
Extension allowance checking clarified (no longer using forum id 0 for private messaging)
Using request_var() array method for some variables [Bug #6556]
Added confirmation for deletion of ranks/smilies/icons/word censores [Bug #6548, #6530, #6512, #6466]
Only show postable forums in dropdown list for moving posts on forum deletion as well as correct re-indexing [Bug #6510, #6476, #6384]
Jabber password being password field in jabber settings screen [Bug #6478]
user activity language variable if viewing not own profile [Bug #6432]
Show moderator group/user-name colour [Bug #6402]
Log rank creation/updating/removing [Bug #6398]
Update check permission changed from a_ to a_board [Bug #6392]

6814 View | Annotate 12/27/2006 01:06 AM naderman

- display search type as page title for premade searches [Bug #6508]
- flash enabled on user side by default, so that admins can actually change anything by activating it (still disabled by default)
- properly implemented password complexity check [Bug #6584]
- do not ldap_escape paramaters for the bind function [Bug #6208]
- deleted words in edited post subjects weren’t getting there search cache refreshed [Bug #6288]
- made common word threshold configurable [Bug #6168]
- recreated word match table entries after installation, side effect of bug #6060
- option to only allow ASCII usernames
- adjusted search page pagination [Bug #6424]
- correctly calculate unformatted search result extract length

6806 View | Annotate 12/24/2006 04:35 PM davidmj

#6372

6795 View | Annotate 12/23/2006 07:17 PM acydburn

comment the version mapping more appropiatly.

6793 View | Annotate 12/23/2006 06:50 PM davidmj

#6492

6773 View | Annotate 12/16/2006 02:16 PM acydburn

let set_config() calls success instead of fail if the config value already exist.

6770 View | Annotate 12/15/2006 03:54 PM acydburn

- fixed bug within the database update script
- #6254
- #6242
- #6184
- #6160
- #6020

6742 View | Annotate 12/10/2006 07:14 PM davidmj

#5242

6741 View | Annotate 12/10/2006 07:06 PM acydburn

add the added config vars

6740 View | Annotate 12/10/2006 06:44 PM naderman

- finally correctly calculate current time for birthday calculation [Bug #6030]
- allow searching forums with unsearchable subforums [Bug #6056]
- addition of an optional HTTP_X_FORWARDED_FOR check in sessions, including bans
- do not index forums which have indexing disabled on index recreation [Bug #6060]
- properly handle html entities in the theme editor [Bug #6048]
- anonymous access is no longer required for the LDAP auth plugin [Bug #6046]
- corrected mcp_front queue link to point to approve_details [Bug #6134]
- added direct (dis)approval to mcp_front queue items [Bug #6134]
- proper mysql version test for fulltext-compatibility [Bug #6054]
- added note to style/language “used by” column so it’s clear that bots are included
- correctl