Ceon URI Mapping v4.x

**conor** · 14 Nov 2012, 02:36 PM

Hi,

Originally Posted by DivaVocals

Upgrading did the trick.. there were a few additional files from my custom product type that I modified following how other product types had your code applied. I hope that I did the right thing by modifying these files as well.. So far everything seems to be working flawlessly! Thanks for the help as always Conor!!

With the functionality added in 4.2.0 the only thing you needed to do was to add the custom product type's string to the array in the includes/extra_datafiles/ceon_uri_mapping_product_pages.php file, no other changes are needed. I don't know what changes you made but can guess and you can ignore them.. their presence won't mess anything up, nor will wiping those changes (e.g. when upgrading).

Hope that helps!

All the best..

Conor
ceon

**DivaVocals** · 14 Nov 2012, 05:01 PM

Originally Posted by conor

Hi,

With the functionality added in 4.2.0 the only thing you needed to do was to add the custom product type's string to the array in the includes/extra_datafiles/ceon_uri_mapping_product_pages.php file, no other changes are needed. I don't know what changes you made but can guess and you can ignore them.. their presence won't mess anything up, nor will wiping those changes (e.g. when upgrading).

Hope that helps!

All the best..

Conor
ceon

It does and I will undo the two changes I made that are not needed..

On another note.. I need to send you an an e-mail under separate cover with regards to questions I have regarding the mapping manager and "other" pages..

**saplanet** · 18 Nov 2012, 01:45 PM

Hi Conor,

I have just upgraded to 4.4.1, and now under the admin modules and settings, there are duplicate menu. Previously, a developer helped to upgrade my cart engine from 1.39h to 1.5, but not the add-on mod, so I just did the upgrade to zc1.5.1; and upgraded CEON mapping too.

Would you know what I might have done wrong? Both the links work the same though, and no error in debug or the installation check.

Appreciate your help. Thank you.

Click image for larger version.

Name: Screen Shot 2012-11-18 at 8.14.06 PM.png
Views: 63
Size: 45.9 KB
ID: 11474

Click image for larger version.

Name: Screen Shot 2012-11-18 at 8.32.13 PM.png
Views: 61
Size: 17.7 KB
ID: 11475

**conor** · 18 Nov 2012, 01:51 PM

Hi,

Originally Posted by saplanet

I have just upgraded to 4.4.1

What version did you upgrade from?

All the best...

Conor
ceon

**saplanet** · 18 Nov 2012, 02:35 PM

Originally Posted by conor

Hi,

What version did you upgrade from?

All the best...

Conor
ceon

From 4.0.7

**conor** · 19 Nov 2012, 05:34 PM

Hi,

Originally Posted by saplanet

From 4.0.7

The admin page key didn't change between those versions so I've no explanation for the duplication other than user error when installing. Just use PHPMyAdmin to remove the duplicate key by hand.

All the best...

Conor
ceon

**Ryk** · 30 Nov 2012, 10:47 PM

I regret to advise you that Conor passed away last night. Please see http://www.zen-cart.com/showthread.php?202939

**bobthemolder** · 7 Dec 2012, 06:21 PM

This is terrible to hear about Conor

I just found the CEON URI module this morning and it's a pretty good tool - after SSU had problems with V1.5 this has picked up the slack.

I didn't want to go through products 1-by-1 to add them to the database, so I put together this script in the past hour to do it automatically.

Open index.php, save it as update-ceon-uri.php and replace the content of <body>...</body> with the following: (make sure to keep the require header.php)

Code:

<div style='width:1000px;margin:0 auto;'>

	<p>Categories must be updated manually through the regular store interface before running this script.</p><hr/>

	<?php // display categories to select from
		$categories = mysql_query("SELECT * FROM zen_categories LEFT JOIN zen_categories_description ON zen_categories.categories_id = zen_categories_description.categories_id WHERE zen_categories.categories_status='1'");
		echo "<p>Click on a category to update it's products: <br/>";
		while ($showthiscat = mysql_fetch_assoc($categories)){
			echo "<a href='update-ceon-uri.php?updatecategory=".$showthiscat['categories_id']."'>".$showthiscat['categories_name']."</a>, \n";
		}
		echo "</p><hr/>";
	?>

	<?php 
		$replacechars = array("(",")","'","\""); // specify all characters to be eliminated
		// update all products in category
		$updateuris = mysql_query("SELECT * FROM zen_products WHERE master_categories_id='".$_GET['updatecategory']."'"); 
		while ($thisuri = mysql_fetch_assoc($updateuris)) {
			$productsid = $thisuri['products_id'];
			$productsname = implode(mysql_fetch_assoc(mysql_query("SELECT products_name FROM zen_products_description WHERE products_id='".$productsid."'"))); 
			$catname = implode(mysql_fetch_assoc(mysql_query("SELECT uri FROM zen_ceon_uri_mappings WHERE main_page='index' AND associated_db_id='".$thisuri['master_categories_id']."'")));
			$newuri = $catname."/".strtolower(str_replace(" ","-",$productsname));
			$newuri = str_replace($replacechars,"",$newuri); // remove characters from array above
			$today = date ('Y-m-d G:i:s'); // today
			
		$exists = implode(mysql_fetch_assoc(mysql_query("SELECT * FROM zen_ceon_uri_mappings WHERE main_page='product_info' AND associated_db_id='$productsid'")));	 // used to check if product already exists to do update vs insert
		
		if ($exists) { // if already in zen_ceon_uri_mappings, update
			mysql_query("UPDATE zen_ceon_uri_mappings SET uri='$newuri' WHERE main_page='product_info' AND associated_db_id='$productsid'");
			$result = "Updated... ".mysql_error();
		} else { // else, insert
			mysql_query("INSERT IGNORE INTO zen_ceon_uri_mappings 
						(`uri`, `language_id`, `current_uri`, `main_page`, `query_string_parameters`, `associated_db_id`, `alternate_uri`, `redirection_type_code`, `date_added`) VALUES 
						('$newuri','1','1','product_info',NULL,'$productsid',NULL,NULL,'$today')");
			$result = "Inserted... ".mysql_error();
		}
			echo "<p>$newuri - $result</p>\n"; // display whether updated or inserted and any problems encountered
		}
		
?>

</div><!-- end center div -->

NOTE: It always sets language_id to 1 (english in my case).
NOTE: You'll have to specify all the characters you want removed directly in the $replacechars[] array.
NOTE: You'll have to manually type in http://yoursite.com/admin/update-ceon-uri.php to run the script.

**lmdief** · 7 Dec 2012, 08:43 PM

Hello,

I had sent email to the email address on CEON website but have not received any reply. I ask Hostgator to installed Ceon Uri Mapping and they received the following errors and wanted me to contact the programmer of this module. Here is the email from Host Gator:

Is there anyone who can help me? Thx

Hi Lila, I apologize for the delay in getting back to you on this. I installed the CEON module, but there were issues with the isntallatioin to the point where I had to spend a considerable amount of time debugging the Zen-Cart installation. In the end, I had to disable the module to get your site's front-end to load properly again as spending more time debugging the issue would extend the downtime. Here's the error that I'm seeing: [05-Dec-2012 13:21:23] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/lmdief/public_html/includes/classes/class.CeonURIMappingHREFLinkBuilder.php on line 230 [05-Dec-2012 13:21:23] PHP Warning: in_array() [<a href='function.in-array'>function.in-array</a>]: Wrong datatype for second argument in /home/lmdief/public_html/includes/classes/class.CeonURIMappingHREFLinkBuilder.php on line 231 I didn't bill you for the install as it was not successful. At this juncture, I would recommend contacting the module provider regarding the above error. I have left the ceon files in place so that they can see how we set it up. Although I do also have the pre-installation backup that I made if you would prefer that I restore the files from there. ---------------------------------------------- Thank you for allowing me to help you. Sincerely, Ricardo C. Linux Systems Administrator II HostGator.com, LLC http://support.hostgator.com

**picandnix** · 7 Dec 2012, 08:54 PM

@ Imdeif...
please read 2 posts above yours. Sadly the author of this excellent mod has passed away. I'm sure someone at Ceon will contact you but maybe not just yet. Although as this isn't a commercial mod you can't expect to be a priority.
This mod is painfully simple to install, but I'm no expert so I can't help with you error other than to suggest you try again yourself to install.

Thread: Ceon URI Mapping v4.x

Thread Tools

Search Thread

Display

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Re: Ceon URI Mapping v4.x

Similar Threads

v139d Ceon uri mapping, how to generate uri mapping for bulk bulk-imported products?

CEON URI Mapping

Ceon URI Mapping (SEO)

Ceon URI Mapping v4

Bookmarks

Bookmarks

Posting Permissions