From 47cf9dd9fbb930ad2238ae131ae0fef60ce27a74 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 3 Mar 2006 08:46:09 +0000
Subject: - Patch #46746 by Matt: fixed inconsistent encoding of path aliases. 
 Fixes broken URLs on profile pages.

---
 database/updates.inc | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'database')

diff --git a/database/updates.inc b/database/updates.inc
index c4812c45a..07774956a 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -1659,3 +1659,12 @@ function system_update_174() {
   }
   return array();
 }
+
+function system_update_175() {
+  $result = db_query('SELECT * FROM {url_alias}');
+  while ($path = db_fetch_object($result)) {
+    $path->src = urldecode($path->src);
+    $path->dst = urldecode($path->dst);
+    db_query("UPDATE {url_alias} SET dst = '%s', src = '%s' WHERE pid = %d", $path->dst, $path->src, $path->pid);
+  }
+}
-- 
cgit v1.2.3