Added an upgrade path for old URL aliases to node/view, book/view and user/view. This is amongst other things required for old node aliases to appear in the node form.

1 files changed, 14 insertions, 1 deletions

diff --git a/database/updates.inc b/database/updates.inc
index 3d7f408e9..c472800bc 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -67,7 +67,8 @@ $sql_updates = array(
   "2004-07-11" => "update_93",
   "2004-07-22" => "update_94",
   "2004-07-30" => "update_95",
-  "2004-08-04" => "update_96"
+  "2004-08-04" => "update_96",
+  "2004-08-06" => "update_97"
 );
 
 function update_32() {
@@ -1269,6 +1270,18 @@ function update_96() {
   return $ret;
 }
 
+function update_97() {
+  $convert = array('node/view/' => 'node/', 'book/view/' => 'book/', 'user/view/' => 'user/');
+  foreach ($convert as $from => $to) {
+    $result = db_query("SELECT pid, src FROM {url_alias} WHERE src LIKE '%s%%'", $from);
+    while ($alias = db_fetch_object($result)) {
+      db_query("UPDATE {url_alias} SET src = '%s' WHERE pid = '%s'", str_replace($from, $to, $alias->src), $alias->pid);
+    }
+  }
+
+  return array();
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);