- Patch #29910 by m3avrck, nsk, Thomas et al: added a mysqli database backend for use with PHP5 and MySQL 4.1 and above.

  NOTE: I don't have MySQL 4.1 setup at the moment so I could _not_ test this patch.  Luckily, various people reported that it works.

- Patch #29910 by m3avrck, nsk, Thomas et al: added a mysqli database backend for use with PHP5 and MySQL 4.1 and above.

  NOTE: I don't have MySQL 4.1 setup at the moment so I could _not_ test this patch.  Luckily, various people reported that it works.

- Patch #30801 by Allie Micka and m3avrck: performance improvements: improved the database scheme and queries of the block.module.

  for performance's sake.

- Patch #30622 by Gerhard: the update produces a type field in node_revisions which shouldn't be there.

- Fix collapsible fieldsets (broken since to 'IE5 icons alignment' fix)
- Fix JS upload (broken due to mysterious form submission abortion bug)

Thanks Bèr for letting me use VNC :).

- Patch #27949 by Robert: the two theme functions in profile.module both violate good theming practice by running user control logic in the middle of them. Worse yet, this isn't immediately visible since it happens in yet another function. Thus themers overriding these functions to style profile pages inadvertently break access control, thus leading to the misperception that overriding theme functions is inherently dangerous.

  TODO: look into http://drupal.org/node/28777?

  show an error message.

- Patch #18252 by tostinni: don't try creating the picture directory when picture support is not enabled.

  (Looks like MySQL rewrites ORto IN() internally.)

  Comment from Steven: It does this by redirecting the submission of the form to a hidden <iframe> when you click "Attach" (we cannot submit data through Ajax directly because you cannot read file contents from JS for security reasons).  Once the file is submitted, the upload-section of the form is updated.  Things to note:

    * The feature degrades back to the current behaviour without JS.
    * If there are errors with the uploaded file (disallowed type, too big, ...), they are displayed at the top of the file attachments fieldset.
    * Though the hidden-iframe method sounds dirty, it's quite compact and is 100% implemented in .js files. The drupal.js api makes it a snap to use.
    * I included some minor improvements to the Drupal JS API and code.
    * I added an API drupal_call_js() to bridge the PHP/JS gap: it takes a function name and arguments, and outputs a <script> tag. The kicker is that it preserves the structure and type of arguments, so e.g. PHP associative arrays end up as objects in JS.
    * I also included a progressbar widget that I wrote for drumm's ongoing update.php work. It includes Ajax status updating/monitoring, but it is only used as a pure throbber in this patch. But as the code was already written and is going to be used in the near future, I left that part in. It's pretty small ;). If PHP supports ad-hoc upload info in the future like Ruby on Rails, we can implement that in 5 minutes.

- Patch #29051 by mathias: made the update.php script work when Drupal is installed in a subdirectory.

All node revisions were stored in a serialized field in the node table and retrieved for _each_ page view although they are rarely needed. We created a separate revisions table which would be in principle identical to the node table, only that it could have several old copies of the same node.  This also allows us to revision-related information, and to provide log entries to non-book pages when a new revision is being created.

TODO:

1. Provide upgrade instructions for node module maintainers!
2. Upgrade modules that implement node types.
3. Provide an upgarde path for revisions.  Dependency on the upgrade system.

- Patch #20255 by Cvbge: simplified a query in the throttle.module.  Fixes a PostgreSQL compatibility bug too.