Hi Timothy, It seems you didn't look hard enough. I suggest you have a look at Apache's mod_rewrite rewrite maps[1]. I've used them in the past to migrate sites with 1000's of pages to Typo3.
Let me know if you want more information on how to set this up. Regards, Oliver [1] http://httpd.apache.org/docs/1.3/mod/mod_rewrite.html#RewriteMap Timothy Patterson wrote: > We are moving away from a CMS that utilizes URLs in the form of > "http://www.domain.com/its/index.cfm?doc_id=10"; in favor of Typo3. > > I have RealURL working perfectly (great job devs!) and I am quite > satisfied with my setup. > > My problem is the fact that I have to keep all of the old URLs valid on > my site. Due to the 1000s of pages on my site I would like to implement > a type of redirection database to keep the old URLs valid while > increasing manageability of the redirections. > > After doing some research online, I have found that there is no > clean-cut way to redirect a URL in the style that our old CMS uses. > > Example: > You can only redirect "http://www.domain.com/its/index.cfm"; to any URL. > You cannot redirect "http://www.domain.com/its/index.cfm?doc_id=10"; to > a URL and "http://www.domain.com/its/index.cfm?doc_id=20"; to a different > URL. Catch my drift? "Standard" redirects only allow you to match file > names and not the parameters after the file name. > > My solution was to create a MySQL database, then use a combination of > mod_rewrite with PHP. > > If you view my sample .htaccess file and PHP script below, you can see > my problem... My setup works great except for the fact that I get a > ?myredirect=0 appended to every single URL on my site. I've played with > mod_rewrite for hours to try to get rid of that, but it seems to be the > only way to avoid an infinite rewriting loop (it is the only way I can > communicate from the PHP script back to mod_rewrite). I really don't > want the ?myredirect=0 on every page. > > Does anyone have any suggestions? Any better ways of accomplishing this > goal? Does anyone know of any other mass redirection solutions? Any > other hybrid PHP / mod_rewrite possibilities? Am I just crazy? > > If I can get some help I'd be glad to write up a How-to doc that will > help others migrating away from a different CMS. > > Here is what I have so far... (It works, just adds a ?myredirect=0 to > every page's url. Grr!) > > mod_rewrite (in a .htaccess file): > RewriteEngine On > RewriteCond %{QUERY_STRING} !(myredirect) > RewriteRule .* /redirect.php?dbredirection=%{REQUEST_URI} [L,QSA] > > And my PHP code: > <?php > // DB Connectivity Include... > include "config.php"; > > // Reads QUERY_STRING environment variable and grabs everything 'after > // dbredirection=' > list($junk, $request) = split("dbredirection=", getenv('QUERY_STRING')); > > // Replace the first instance of a & with a ? (caused by mod_rewrite) > $request = preg_replace("/(\&)/", "?", $request, 1); > > // Connect to MySQL... > $connection = mysql_connect($db_host, $db_user, $db_pass); > mysql_select_db($db); > > // Get today's date in MySQL format... > $expdate = date('Y-m-d'); > > // Build Query... > // Select & Check Expiration - Default is 2050-01-01 so we should be ok > // with this... > $query = "SELECT newurl FROM redirects WHERE oldurl='$request' AND > expires >= '$expdate' LIMIT 1"; > > // Execute Query... > $result = mysql_query($query); > > if(mysql_num_rows($result) != 0) > { > // Retrieve Row... > $row = mysql_fetch_row($result); > > //echo "Redirecting to: $row[0]"; > //die; > > // Perform Safe, "Permanent" Redirect... > header("HTTP/1.1 301 Moved Permanently"); > header("Location: $row[0]"); > die; > } else { > // No entries exist... Try to go to page... > // Add ?myredirect=0 to the URL to prevent mod_rewrite loops!!! > > // Does $request contain a '?' > $qmark = strstr($request, '?'); > if(!$qmark) > { > $request .= "?myredirect=0"; > } else { > $request .= "&myredirect=0"; > } > > header("Location: $request"); > die; > } > ?> -- Oliver Rowlands :: Liquid Light :: E - [EMAIL PROTECTED] W - http://www.liquidlight.co.uk T - 00 44 (0)845 6 58 88 35 F - 00 44 (0)845 6 58 44 35 _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
