Ultimate SEO URLs

[michael_s]

This is not for everybody. But if you're getting URL's for your categories like this:
http;//www.yoursite.com/-c-2.html
instead of:
http://www.yoursite.com/categoryname_keyword-c-2.html
Then your version of mysql needs a new seo.class.php.
Just upload it to your (catalog)/includes/classes/ folder and your categories names will again appear!
This file contains only the seo.class.php file, and nothing else, so this is not the complete contribution -- this fix only for those who had the problem mentioned above.
Find
$sql = "SELECT cd.categories_seo_url, c.categories_id, c.parent_id, cd.categories_name as cName,
cd2.categories_name as pName
FROM ".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd
LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2
ON c.parent_id=cd2.categories_id AND
cd2.language_id='".(int)$this->languages_id."'
WHERE c.categories_id='".(int)$single_cID."'
AND cd.categories_id='".(int)$single_cID."'
AND cd.language_id='".(int)$this->languages_id."'
LIMIT 1";

Change it to:

$sql = "SELECT cd.categories_seo_url, c.categories_id, c.parent_id, cd.categories_name AS cName, cd2.categories_name AS pName
FROM ".TABLE_CATEGORIES." c
INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON cd.categories_id = '".(int)$single_cID."'
AND cd.language_id='".(int)$this->languages_id."'
LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2 ON c.parent_id = cd2.categories_id
AND cd2.language_id = '".(int)$this->languages_id."'
WHERE c.categories_id = '".(int)$single_cID."'
LIMIT 1";


Admin
http://www.oscommerce-packages.com

More...

[letmelearn]

Hi Michael,

I'm getting this problem, but I don't have an seo.class.php file full stop. This is a clean and fresh install, installed 2 days ago. Is this just a one off missing file or should I be checking others?

Thanks
LML

[michael_s]

This is a newer version of the mod and is not specifically for osCMax... Remember, this specific forum is for mods discussion for osCommerce standard, not osCMax.