[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

galey1981 · February 28, 2009

Forgive the formatting, i'm currently working on the layout so each page is a bit of a mess but you can see the exhibiting behaviour here:

http://gardenmachinerywebsite.co.uk/catalog/warner-m-3.html

If you click on the Show: and select a category, it will go back to home page. but this works with the contrib turned off. Puzzling.

Or go here: http://gardenmachinerywebsite.co.uk/catalog/conditions.php

and then select a manufacturer or category from the drop down boxes on left hand menu.

galey1981 · February 28, 2009

One last thing I'll add is that this would work on my website before I moved hosting provider. It works on a different host account perfectly, this is new and since i moved to 1&1 / 1 and 1.

I'm wondering if it's how the html output query works on 1&1 servers, or if the .htaccess rewrites need to be written in a certain way to accommodate....

Any help would be brilliant.

♥FWR Media · February 28, 2009

/index.php?catalog=index.php

However, I turn the seo function off and these search / filters all work perfectly.

You are using the wrong version of seo urls, use 2.1d ORIGINAL updated as last uploaded by me.

Another strange thing is I can access the search engine friendly page for the manufacturer by typing it in directly. e.g. /catalog/microsoft-m-2.html. It just seems like how it's handling the initial call from picking an option on any of my drop down menu's.

You should be able to do this .. this is normal operation.

Dennisra · February 28, 2009

(FWR Media @ Feb 9 2009, 08:46 AM) I would imagine that & is being passed in the querystring via tep_redirect() there are quite a few posts in this topic about the change to make. Failing that turn off the W3C option in admin.

I made this change to seo.class

// case ($this->attributes['USE_SEO_REDIRECT'] == 'true'):

// header("HTTP/1.0 301 Moved Permanently");

// $url = str_replace('&', '&', $url);

// header("Location: $url"); // redirect...bye bye

// break;

$url = str_replace('&', '&', $url); // Remove the W3C & when redirecting

header("HTTP/1.0 301 Moved Permanently");

header("Location: $url"); // redirect...bye bye

break;

and also tried your suggestion "turn off the W3C option ".

Sorry to say no joy. Any other suggestion you may have for me?

♥geoffreywalton · February 28, 2009

Thanks early bird!!

Sounds like I could be off to left join heaven.

Installing v2.0b on a server running mysql5?

http://addons.oscommerce.com/info/4654

galey1981 · February 28, 2009

Thanks for the heads up, I rolled back to your working version and read your note about people changing the contrib - it works now! I feel satisfied for the day!

Greens44 · March 1, 2009

Well after some coding I've came up with the following code to the manufacturer to product url that will add the category name to the url. So far this is what I have:

the SQL:

$sql = "SELECT p.products_id as id, pd.products_name as name, c.categories_id as id, cd.categories_name as cname FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS_TO_CATEGORIES." ptc WHERE p.products_id=ptc.products_id and c.categories_id=ptc.categories_id and c.categories_id = cd.categories_id and p.products_status='1'";

and the below portion:

while ($product = $this->DB->FetchArray($product_query)) {

$define = 'define(\'PRODUCT_NAME_' . $product['id'] . '\', \'' .

$this->strip($product['cname']) . '/' . $this->strip($product['name']) . '\');';

$prod_cache .= $define . "\n";

eval("$define");

The only problem with the code above is it pulls the category as the product id. So in otherwords.. if product 3 is in category 1 it will still display category 3 for product 3. Im not an SQL programmer but I know thats where we need to look at. Maybe do something with the PRODUCTS_TO_CATEGORIES table.

If anyone can fix my code above to display the proper category I will release alot of my mods to oscommerce including a completely converted version from tables to a div/css version. Thanks!

I've been trying many different things to add the category to the url. I've successfully coded my own version on a separate page that drops all urls from the cache and than remakes them. I suppose I could make a script that compares the current url with the url in the cache and update as needed. I would however like to see if anyone could fix the code above as that wouldn't only help me but alot of others. Thanks!

♥geoffreywalton · March 2, 2009

Version installed

2.1d ORIGINAL updated Jack_mcs 23 Nov 2008 on linux/php4/mysql5

Corrected the left joins so it will run on mysql5 as previously but on this site it is impossible to turn off the c- even when the admin setting

Add cPath to product URLs?

is set to false.

Believe it connected to this code in seo_classes.php, but hey what do i know.

Anyone have any thoughts?

Thanks

Geoffrey

/**
* Function to get the category name. Use evaluated cache, per page cache, or database query in that order of precedent 
* @author Bobby Easland 
* @version 1.1
* @param integer $cID NOTE: passed by reference
* @return string Stripped anchor text
*/		
	function get_category_name(&$cID){
			$full_cPath = $this->get_full_cPath($cID, $single_cID); // full cPath needed for uniformity
			switch(true){
					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && defined('CATEGORY_NAME_' . $full_cPath)):
							$this->performance['CACHE_QUERY_SAVINGS']++;
							$return = constant('CATEGORY_NAME_' . $full_cPath);
							$this->cache['CATEGORIES'][$full_cPath] = $return;
							break;
					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && isset($this->cache['CATEGORIES'][$full_cPath])):
							$this->performance['CACHE_QUERY_SAVINGS']++;
							$return = $this->cache['CATEGORIES'][$full_cPath];
							break;
					default:
							$this->performance['NUMBER_QUERIES']++;
							switch(true){
									case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'):
											$sql = "SELECT 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";
											$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );
											$cName = $this->not_null($result['pName']) ? $result['pName'] . ' ' . $result['cName'] : $result['cName'];
											break;
									default:
											$sql = "SELECT categories_name as cName 
															FROM ".TABLE_CATEGORIES_DESCRIPTION." 
															WHERE categories_id='".(int)$single_cID."' 
															AND language_id='".(int)$this->languages_id."' 
															LIMIT 1";
											$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );
											$cName = $result['cName'];
											break;
							}																				
							$cName = $this->strip($cName);
							$this->cache['CATEGORIES'][$full_cPath] = $cName;
							$this->performance['QUERIES']['CATEGORIES'][] = $sql;
							$return = $cName;
							break;																
			} # end switch				
			$cID = $full_cPath;
			return $return;
	} # end function

♥geoffreywalton · March 2, 2009

Version installed

2.1d ORIGINAL updated Jack_mcs 23 Nov 2008 on linux/php4/mysql5

Corrected the left joins so it will run on mysql5 as previously but on this site it is impossible to turn off the c- even when the admin setting

Add cPath to product URLs?

is set to false.

Believe it connected to this code in seo_classes.php, but hey what do i know.

Anyone have any thoughts?

Thanks

Geoffrey

/**
* Function to get the category name. Use evaluated cache, per page cache, or database query in that order of precedent 
* @author Bobby Easland 
* @version 1.1
* @param integer $cID NOTE: passed by reference
* @return string Stripped anchor text
*/		
	function get_category_name(&$cID){
			$full_cPath = $this->get_full_cPath($cID, $single_cID); // full cPath needed for uniformity
			switch(true){
					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && defined('CATEGORY_NAME_' . $full_cPath)):
							$this->performance['CACHE_QUERY_SAVINGS']++;
							$return = constant('CATEGORY_NAME_' . $full_cPath);
							$this->cache['CATEGORIES'][$full_cPath] = $return;
							break;
					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && isset($this->cache['CATEGORIES'][$full_cPath])):
							$this->performance['CACHE_QUERY_SAVINGS']++;
							$return = $this->cache['CATEGORIES'][$full_cPath];
							break;
					default:
							$this->performance['NUMBER_QUERIES']++;
							switch(true){
									case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'):
											$sql = "SELECT 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";
											$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );
											$cName = $this->not_null($result['pName']) ? $result['pName'] . ' ' . $result['cName'] : $result['cName'];
											break;
									default:
											$sql = "SELECT categories_name as cName 
															FROM ".TABLE_CATEGORIES_DESCRIPTION." 
															WHERE categories_id='".(int)$single_cID."' 
															AND language_id='".(int)$this->languages_id."' 
															LIMIT 1";
											$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );
											$cName = $result['cName'];
											break;
							}																				
							$cName = $this->strip($cName);
							$this->cache['CATEGORIES'][$full_cPath] = $cName;
							$this->performance['QUERIES']['CATEGORIES'][] = $sql;
							$return = $cName;
							break;																
			} # end switch				
			$cID = $full_cPath;
			return $return;
	} # end function

Found this http://www.oscommerce.com/forums/index.php?s=&...t&p=1365679 where it says

"If you are meaning the -c-21 that HAS to be there. "

But jailaxmi says

"This is the second site I install this contribution on, and never had this happen with the first one."

So the question is can you get rid of the c-path?

Cheers

G

treasurepleasure · March 2, 2009

I have a problem, I am getting this error.

Warning: main(includes/classes/preventDuplicates.php) [function.main]: failed to open stream: No such file or directory in /nfs/www/WWW_pages/cimmerin/treasurepleasuresextoys.com/includes/application_top.php on line 519

Fatal error: main() [function.require]: Failed opening required 'includes/classes/preventDuplicates.php' (include_path='.:/opt/php/lib/php/') in /nfs/www/WWW_pages/cimmerin/treasurepleasuresextoys.com/includes/application_top.php on line 519

I looked at my includes/application_top.php and the correct code

require_once(DIR_WS_CLASSES . 'preventDuplicates.php');

$preventDuplicates = new preventDuplicates();i

is at the bottom of the page. This is where this is said to be placed. What is happening?

Thanks in advance!!!

♥geoffreywalton · March 2, 2009

Because this file is not mentioned in the installation instructions but is included in the contribution file I guess you didn't put it in /includes/classes.

G

treasurepleasure · March 2, 2009

I found the problem. Thanks!

One thing though that is very important. After this contrib some of my products are appearing at the bottom, after the left column.

This doesn't work for me. Everything else is working except for that. ?? Any ideas anyone?

treasurepleasure · March 2, 2009

After this contrib some of my products are appearing at the bottom, after the left column.

This doesn't work for me. Everything else is working except for that. ?? Any ideas anyone?

March 4, 2009

IT seems like everything is working, the only thing that isn't working is the "REVIEWS" page. When I click on the page I get this:

Not Found

The requested URL /fitted-atlanta-braves-camo-blackwhitegrey-pr-356.html" was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.swaggashop.com Port 80

I noticed when I hover over the Review link it has this " at the end of the link which I think is causing the problem. Although when I take the " off in the address bar it works perfectly. Any way of editing some code so it doesn't have the " at the end of the link?

You can check out what I'm saying by going here -->> http://www.swaggashop.com/fitted-york-yank...-pr-348.html%22 Thanks

cornishpirate · March 4, 2009

Stuck on just 1 issue:

Navigating to a Category the first time, the URL is correctly generated as http://www.****************/candlelight-c-46.html

After navigating below it, then returning, it get generated, incorrectly, as http://www.****************/candlelight-c-46_44_46.html

Spent ages on this.

Any ideas, anyone?

March 4, 2009

OK... I have the SEO URLs working in local mode... I have only one last question to see if anyone can help me...

The Category name is: Iluminação auto

I must have something similar to: http://127.0.0.1/loja-pt/iluminacao-auto-c-12.html

But i have with strange characters: http://127.0.0.1/loja-pt/iluminaÃ§Ã£o-auto-c-12.html

It´s displaying properly on the web page but when i click i have that strange sintax, i know the problem it caused because special characters...

Any one can help on this last issue to get this working properly????

I appretiate any help

Best Regards

João Carrolo

KarTunes

r00ki3 · March 4, 2009

Dear All,

I just installed Ultimate SEO URL's 2.6 on a osCommerce 2.2-MS2 webshop.

I followed all the steps which are in the manual...but somehow when I login in the admin section of the webshop I don't have the option to setup the configuration for the SEO URLs

I couldn't find at which step they added the option to the admin section...

Can somebody help me out? I'm running a dutch version...Maybe it's somewhere in the language files?

I've got no Idea...

Suggestions are more then welcome!

Thnx

Greens44 · March 4, 2009

Well after some coding I've came up with the following code to the manufacturer to product url that will add the category name to the url. So far this is what I have:

the SQL:

$sql = "SELECT p.products_id as id, pd.products_name as name, c.categories_id as id, cd.categories_name as cname FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS_TO_CATEGORIES." ptc WHERE p.products_id=ptc.products_id and c.categories_id=ptc.categories_id and c.categories_id = cd.categories_id and p.products_status='1'";

and the below portion:

while ($product = $this->DB->FetchArray($product_query)) {

$define = 'define(\'PRODUCT_NAME_' . $product['id'] . '\', \'' .

$this->strip($product['cname']) . '/' . $this->strip($product['name']) . '\');';

$prod_cache .= $define . "\n";

eval("$define");

The only problem with the code above is it pulls the category as the product id. So in otherwords.. if product 3 is in category 1 it will still display category 3 for product 3. Im not an SQL programmer but I know thats where we need to look at. Maybe do something with the PRODUCTS_TO_CATEGORIES table.

If anyone can fix my code above to display the proper category I will release alot of my mods to oscommerce including a completely converted version from tables to a div/css version. Thanks!

You guys manage to code massive code segments and fix issues. I think someone here can fix the simple sql statement above.

♥geoffreywalton · March 4, 2009

Dear All,

I just installed Ultimate SEO URL's 2.6 on a osCommerce 2.2-MS2 webshop.

I followed all the steps which are in the manual...but somehow when I login in the admin section of the webshop I don't have the option to setup the configuration for the SEO URLs

I couldn't find at which step they added the option to the admin section...

Can somebody help me out? I'm running a dutch version...Maybe it's somewhere in the language files?

I've got no Idea...

Suggestions are more then welcome!

Thnx

It should be at the bottom of the Configuration section of the shop admin area.

Have you put all the files in the right directories?

Edited March 4, 2009 by geoffreywalton

r00ki3 · March 4, 2009

It should be at the bottom of the Configuration section of the shop admin area.

Normally...yes...but not in this case

This is what I have in the Configuration section:

My Store

Minimum Values

Maximum Values

Images

Customer Details

Shipping/Packaging

Product Listing

Stock

Logging

Cache

E-Mail Options

Download

GZip Compression

Sessions

Ideal

Any other ideas?

Thnx!

vampirehunter · March 6, 2009

which fucking version of this thing I am supposed to install???

there are so many damn versions, can't someone explain which is the one to install??

r00ki3 · March 6, 2009

which fucking version of this thing I am supposed to install???
there are so many damn versions, can't someone explain which is the one to install??

RTFM I would say....

How about the latest version?

r00ki3 · March 6, 2009

It should be at the bottom of the Configuration section of the shop admin area.

Have you put all the files in the right directories?

Yes I'm sure I did...

I even removed all the files and SQL stuff and started all over again...still no effect!

If it doesn't work somehow...I've to find another SEO contribution.

Thnx anyway...

r00ki3 · March 6, 2009

Yes I'm sure I did...
I even removed all the files and SQL stuff and started all over again...still no effect!

If it doesn't work somehow...I've to find another SEO contribution.

Thnx anyway...

I solved the problems by installing an earlier version. Version 2.1d is installed now...without any problems.

The only thing I still have question about is the url.

For instance when I click a product the url is like http://domain/catalog/diesel-polo-p-237.html

The category where the product is in is not generated in the url.

When I go to a category....let's say: Kids clothing > Boys > *Brand*

the url becomes like this: http://domain/catalog/-c-21_25.html

What I would like to see is something like: http://shop.joujou-kinderkleding.nl/catalo...s-brand123.html

Is that possible?

Thanx in advance!

~Kira · March 6, 2009

I just installed this and it works GREAT in firefox but in IE I still get the long URLs:

http://anxieties.com/store/cd-4-the-guide-p-38.html?osCsid=fa13efc3143debdf0549fe28a5497a90

I just want to see this type of URL:

http://anxieties.com/store/cd-4-the-guide-p-38.html

How can I fix that for IE?

Edited March 6, 2009 by ~Kira

[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Jack_mcs

Guest

Jack_mcs

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation