Ceon URI Mapping (SEO)

[conor]

Hi Loyd,

I was able to figure out that if I were to query the db the code to use is:

Why are you using a SQL statement when I said that using the Insert function is easier?

It won't have taken you more than a few minutes to learn how to use the Insert function, but instead I have to answer more questions, taking up more of my time.

I appreciate your nice comments about the module but you are making things harder for me by not trying things out yourself but relying on me to answer questions first. That's a little unfair on me.

Using the Insert or the query command, do I still need to associate the uri I'm entering with 'associated_db_id' for contact_us, about_us, shippinginfo and so forth? If not, I leave the value as empty?

As the documentation clearly says, you make the associated_db_id field NULL.

When using the Insert function this means leaving the box "Null" ticked.

A quick test or research into the PHPMyAdmin tool would have helped you work that out or showed you that's how it works.

For the about_us, contact_us, shippinginfo, and so on pages, for 'main_page' value, do we need to enter: index for value or for example: CONTACT-US main_page value would be:contact_us and so forth as anyone could see just pointing the cursor to the link and seeing the browser footer link it gives where index.php?main_page=value?

Yes, for the main_page field you use the Zen Cart main page name, e.g.:

about_us

or

contact_us

Sorry for keep asking questions about it. I just want to use your addon and I need to have these solved so it could work for me. I'm pretty sure that this thread will help others having similar problem until a new version help handdling the current and historic URI from admin.

You're the first person I know of to attempt to enter the data using SQL instead of learning the PHPMyAdmin Insert function so I doubt many will ever need to know this information (and for those who know SQL it's easy enough to see from the database structure). I appreciate you are trying but it would be better if for future work on Zen Cart you tried to listen to what the developer was saying to you a bit more, both in the documentation and on the forum.

Hopefully you've enough information now to get what you need done.

All the best..

Conor
ceon