LONG Post: Need help with htaccess redirect in CMS

Hello,

(Apologies in advance for the long post, the bulk of it is htaccess. Hopefully someone is patient enough to help me with this and I wanted to include all the necessary info up-front.)
I'm in desperate need of some help with creating proper 301s on a CMS/gallery site with approx 14,000 "products" indexed.

Background info:

When a new product is created on the site, 3 physical files are required:
A. A large-size image which later gets displayed on the website, in the form of:
COMPANYNAME Category - Subcategory Name - AAA123 01.jpg
B. The corresponding thumbnail in the form of:
thumb_COMPANYNAME Category - Subcategory Name - AAA123 01.jpg
C. One or more 'deliverable' files in the form of:
LicenseA_COMPANYNAME Category - Subcategory Name - AAA123 01.zip

Once published, the product
COMPANYNAME Category - Sub-Category Name - AAA123 01 (.jpg/.zip)
gets the URL:

https://www.domain.com/detail/1000-COMPANYNAME-Category-_-Sub_Category-Name-_-AAA123-01.html

There are no actual html files in the /detail/ directory.. they're generated on-the-fly with that path.
The '1000' is the product number in the database.. i.e. the 1000th product added becomes '1000-' and so on.
Spaces in the actual filename become hyphens in the URL
Hyphens in the actual filename become underscores in the URL
The filenames are not renamed in any way on the filesystem.
If I right-click an image in my browser and select "View Image Info" it shows up like this:

https://www.domain.com/gallery/Images/Category/AAA/COMPANYNAME%20Category%20-%20Sub%20Category%20Name%20-%20AAA123%2001.jpg

This is the current state of the .htaccess as installed by the CMS, with a couple mods:

# PHP 5.2
AddType application/x-httpd-php52 .php

RewriteEngine On

# block some habitual hotlinkers
RewriteCond %{HTTP_REFERER} ^http://(.+\.)?gensun\.org/ [NC,OR]
RewriteCond %{HTTP_REFERER} ^http://(.+\.)?beling\.net/ [NC]
RewriteRule .*\.(jpg|gif|bmp|png)$ [F]

<Files .htaccess>
order allow,deny
deny from all
</Files>

########## Begin - Rewrite rules to block out some common exploits
RewriteCond %{QUERY_STRING} mosConfig_[a-zA-Z_]{1,21}(=|\%3D) [OR]
RewriteCond %{QUERY_STRING} base64_encode.*\(.*\) [OR]
RewriteCond %{QUERY_STRING} (\<|%3C).*script.*(\>|%3E) [NC,OR]
RewriteCond %{QUERY_STRING} GLOBALS(=|\[|\%[0-9A-Z]{0,2}) [OR]
RewriteCond %{QUERY_STRING} _REQUEST(=|\[|\%[0-9A-Z]{0,2})
# Send all blocked request to homepage with 403 Forbidden error!
Options FollowSymLinks
RewriteRule ^(.*)$ index.php [F,L]
########## End - Rewrite rules to block out some common exploits

RewriteRule ^(others)(.*)(.html|htm)$ $1$2$3 [NC,L]
RewriteRule ^(help)(.htm)$ $1$2 [NC,L]
RewriteRule ^(help_menu)(.htm)$ $1$2 [NC,L]
RewriteRule ^(help_contents)(.htm)$ $1$2 [NC,L]
RewriteRule ^(installation)(.html)$ $1$2 [NC,L]
RewriteRule ^(resultC)(.html)$ $1$2 [NC,L]
RewriteRule ^(resultY)(.html)$ $1$2 [NC,L]
RewriteRule ^(secure-hosting-htmlbad)(.html)$ $1$2 [NC,L]
RewriteRule ^(secure-hosting-htmlgood)(.html)$ $1$2 [NC,L]
RewriteRule ^(secure-hosting-template)(.html)$ $1$2 [NC,L]
RewriteRule ^(wtc_service)(.htm)$ $1$2 [NC,L]
RewriteRule ^(images)(.*)(.html|htm)$ $1$2$3 [NC,L]
RewriteRule ^(logout_private)/(.*).html$ logout.php?from=private_gallery.php&mode=$2 [NC,L]
RewriteRule ^(.*[\/])(logout_private)/(.*).html$ logout.php?from=private_gallery.php&mode=$3 [NC,L]
RewriteRule ^(logout_private.html)$ logout.php?from=private_gallery.php&mode=1 [NC,L]
RewriteRule ^(cb.html)$ cb.php [NC,L]
RewriteRule ^(login.html)$ user_login.php [NC,L]
RewriteRule ^(private_gallery.html)$ private_gallery.php [NC,L]
RewriteRule ^(index|logout)/(.*)?$ $1.php?link=$2 [NC,L]
RewriteRule ^(index)$ index.php [NC,L]
RewriteRule ^(index\/+)$ index.php [NC,L]

#new seo urls

RewriteRule ^(.*[\/])logout.html$ logout.php?from=index.php [NC,L]
RewriteRule ^logout.html$ logout.php?from=index.php [NC,L]

RewriteRule ^(rss[\/])(.*)(\.html)?$ rss.php?arg=$1$2 [NC,L]
RewriteRule ^(.*[\/])(rss[\/])(.*)(\.html)?$ rss.php?arg=$1$2$3 [NC,L]

RewriteRule ^register.html$ register.php [NC,L]
RewriteRule ^(.*[\/])(register.html)$ register.php?arg=$1$2 [NC,L]

RewriteRule ^((.*)\.html)?$ index.php?arg=$1 [NC,L]

RewriteRule ^(cms[\/])(.*)?$ index.php?arg=$1$2 [NC,L]
RewriteRule ^(.*[\/])(cms[\/])(.*)?$ index.php?arg=$1$2$3 [NC,L]

RewriteRule ^(.*[\/])search[\/]?$ index.php?arg=$1search/index.html [NC,L]
RewriteRule ^(.*[\/])search?$ index.php?arg=$1search/index.html [NC,L]
RewriteRule ^search[\/]?$ index.php?arg=search/index.html [NC,L]
RewriteRule ^search?$ index.php?arg=search/index.html [NC,L]

RewriteRule ^(.*[\/])new_media[\/]?$ index.php?arg=$1new_media/index.html [NC,L]
RewriteRule ^(.*[\/])new_media?$ index.php?arg=$1new_media/index.html [NC,L]
RewriteRule ^new_media[\/]?$ index.php?arg=new_media/index.html [NC,L]
RewriteRule ^new_media?$ index.php?arg=new_media/index.html [NC,L]

RewriteRule ^(.*[\/])popular[\/]?$ index.php?arg=$1popular/index.html [NC,L]
RewriteRule ^(.*[\/])popular?$ index.php?arg=$1popular/index.html [NC,L]
RewriteRule ^popular[\/]?$ index.php?arg=popular/index.html [NC,L]
RewriteRule ^popular?$ index.php?arg=popular/index.html [NC,L]

RewriteRule ^(.*[\/])lightbox[\/]?$ index.php?arg=$1lightbox/index.html [NC,L]
RewriteRule ^(.*[\/])lightbox?$ index.php?arg=$1lightbox/index.html [NC,L]
RewriteRule ^lightbox[\/]?$ index.php?arg=lightbox/index.html [NC,L]
RewriteRule ^lightbox?$ index.php?arg=lightbox/index.html [NC,L]

RewriteRule ^(.*[\/])news[\/]?$ index.php?arg=$1news/index.html [NC,L]
RewriteRule ^(.*[\/])news?$ index.php?arg=$1news/index.html [NC,L]
RewriteRule ^news[\/]?$ index.php?arg=news/index.html [NC,L]
RewriteRule ^news?$ index.php?arg=news/index.html [NC,L]

RewriteRule ^(.*[\/])portfolio[\/]?$ index.php?arg=$1portfolio/index.html [NC,L]
RewriteRule ^(.*[\/])portfolio?$ index.php?arg=$1portfolio/index.html [NC,L]
RewriteRule ^portfolio[\/]?$ index.php?arg=portfolio/index.html [NC,L]
RewriteRule ^portfolio?$ index.php?arg=portfolio/index.html [NC,L]

RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.domain.com/$1 [R=301,L]

#RewriteRule ^(.*)\.html?$ index.php?arg=$1.html [NC,L]

ErrorDocument 400 /errors/400.shtml
ErrorDocument 401 /errors/401.shtml
ErrorDocument 403 /403.php
ErrorDocument 404 /404.php
ErrorDocument 500 /errors/500.shtml

This is what I'd like to accomplish:

1. Rename the physical files on the system:
2. Replace capitals with lowercase (more desirable for SEO)
3. Replace spaces with hyphens and " - " with single hyphen (to eliminate potential issues with character encodings incorrectly translating the spaces)
I can write a batch script to do this directly on the server so that's no problem.

4. Rename the file and URL references in the database to match the changes made in 1-3. I can do this with sql queries.

After doing steps 1-4, I'll want to modify the htaccess so search engines and other inbound links will be bounced from the old and no longer existing URL:

https://www.domain.com/detail/5637-COMPANYNAME-Category-_-Sub_Category-Name-_-AAA123-01.html

to the new cleaned URL:

https://www.domain.com/detail/5637-companyname-category-sub-category-name-AAA123-01.html

and the old image name (which google loves to go to directly):

https://www.domain.com/gallery/COMPANYNAME Category - Sub-Category Name - AAA123 01.jpg

to the new:

https://www.domain.com/gallery/companyname-category-sub-category-name-AAA123-01.jpg

These redirects, as far as I can tell, should only happen on the /gallery/ and /detail/ directories, and only *after* that part of the path instead of applied to the whole URL.

Can this htaccess be cleaned up at all and/or streamlined without breaking the existing site?
How would I need to modify it to take into account the changes outlined in Steps 1 and 2 above? I hope someone can help with this. Again, sorry for the very long post and thank you sincerely for reading this far!

RewriteRule ^([^_]+)-_-([^_]+)-_-([^_]+)-_-([^_]+)$ http://www.example.com/$1-$2-$3-$4 [R=301,L] RewriteRule ^([^_]+)-_-([^_]+)-_-([^_]+)$ http://www.example.com/$1-$2-$3 [R=301,L] RewriteRule ^([^_]+)-_-([^_]+)$ http://www.example.com/$1-$2 [R=301,L]

LONG Post: Need help with htaccess redirect in CMS

minarets

lucy24

minarets

lucy24

minarets

minarets

minarets

lucy24

minarets

lucy24

minarets

lucy24

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week