Simple SEO URL (OLD version) [support thread]

[yellow1912]

For now, this should fix your problem:
http://www.zen-cart.com/index.php?ma...roducts_id=113

Can you also go into your phpmyadmin and export the content of the table "ezpages" and table "languages" then post it here? That will be of great help

[nagelkruid]

For now, this should fix your problem:
http://www.zen-cart.com/index.php?ma...roducts_id=113

Can you also go into your phpmyadmin and export the content of the table "ezpages" and table "languages" then post it here? That will be of great help

-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generatie Tijd: 28 Nov 2008 om 11:34
-- Server versie: 5.0.33
-- PHP Versie: 5.2.1
-- 
-- Database: `-`
-- 

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `ezpages`
-- 

CREATE TABLE `ezpages` (
  `pages_id` int(11) NOT NULL auto_increment,
  `languages_id` int(11) NOT NULL default '1',
  `pages_title` varchar(64) collate utf8_unicode_ci NOT NULL,
  `alt_url` varchar(255) collate utf8_unicode_ci NOT NULL,
  `alt_url_external` varchar(255) collate utf8_unicode_ci NOT NULL,
  `pages_html_text` mediumtext collate utf8_unicode_ci,
  `status_header` int(1) NOT NULL default '1',
  `status_sidebox` int(1) NOT NULL default '1',
  `status_footer` int(1) NOT NULL default '1',
  `status_toc` int(1) NOT NULL default '1',
  `header_sort_order` int(3) NOT NULL default '0',
  `sidebox_sort_order` int(3) NOT NULL default '0',
  `footer_sort_order` int(3) NOT NULL default '0',
  `toc_sort_order` int(3) NOT NULL default '0',
  `page_open_new_window` int(1) NOT NULL default '0',
  `page_is_ssl` int(1) NOT NULL default '0',
  `toc_chapter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pages_id`),
  KEY `idx_lang_id_zen` (`languages_id`),
  KEY `idx_ezp_status_header_zen` (`status_header`),
  KEY `idx_ezp_status_sidebox_zen` (`status_sidebox`),
  KEY `idx_ezp_status_footer_zen` (`status_footer`),
  KEY `idx_ezp_status_toc_zen` (`status_toc`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `ezpages`
-- 

INSERT INTO `ezpages` (`pages_id`, `languages_id`, `pages_title`, `alt_url`, `alt_url_external`, `pages_html_text`, 

`status_header`, `status_sidebox`, `status_footer`, `status_toc`, `header_sort_order`, `sidebox_sort_order`, 

`footer_sort_order`, `toc_sort_order`, `page_open_new_window`, `page_is_ssl`, `toc_chapter`) VALUES 
(1, 1, 'Wie zijn wij', '', '', '<p style="font-family: tahoma,arial,helvetica,sans-serif;"><font size="2">\r\nHallo en 

hartelijk welkom bij blablabla alot of text stripped" />', 0, 1, 1, 1, 3, 1, 2, 1, 0, 0, 1),
(2, 1, 'fotopagina', '', '', '<p><span style="font-family: tahoma,arial,helvetica,sans-serif;">een tweede 

foto</span></p><p><span style="font-family: tahoma,arial,helvetica,sans-serif;"></span><br /></p><img src="stripped" />', 0, 

0, 0, 1, 0, 0, 0, 2, 0, 0, 1),
(3, 1, 'externe links fabrikanten feeders', '', '', '<p>Externe links &amp; Feeders waarmee verbonden is<br /><br /> <a 

title="Opgenomen in WebFeeder" href="http://www.webfeeder.nl/" target="_blank"><img style="width: 100px; height: 18px;" 

src="http://static.webfeeder.nl/images/misc/addedon.gif" border="0" alt="Opgenomen in WebFeeder" /></a></p>\r\n<p><a 

href="http://www.geekyspeaky.com">GeekySpeaky: Submit Your Site!</a></p>\r\n<p>&nbsp;</p>\r\n<p><a title="webgids" 

href="http://www.spinnenweb.nl"> Spinnenweb Webgids</a></p>', 0, 0, 0, 0, 0, 0, 995, 995, 0, 0, 9955),
(4, 1, 'Dushi', '', '', '<h3>Welkom in de wereld van Dushi blabla alot of text.</p>', 0, 0, 0, 1, 0, 0, 0, 3, 0, 0, 2),
(5, 1, 'Over onze merken', '', '', '<p>Hier volgt wat meer informatoe over onze leveranciers en hun producten.</p>', 0, 0, 0, 

1, 0, 0, 5, 1, 0, 0, 2),
(6, 1, 'Over de betalingsmogelijkheden', '', '', '<p>Hier volgt wat meer informatie over de betalingsmogelijkheden</p>', 0, 

0, 0, 1, 0, 0, 9, 1, 0, 0, 3),
(7, 1, 'iDEAL', '', '', '<p>Hier volgt een uitleg over iDEAL</p>', 0, 0, 0, 1, 0, 0, 0, 2, 0, 0, 3),
(8, 1, 'Vooruit betalen', '', '', '<p>Hier volgt informatie over vooruit betalen</p>', 0, 0, 0, 1, 0, 0, 0, 3, 0, 0, 3),
(9, 1, 'PayPal', '', '', '<p>Hier volgt informatie over betalen met PayPal</p>', 0, 0, 0, 1, 0, 0, 0, 4, 0, 0, 3),
(10, 1, 'leidsleuks', '', 'http://www.coolsite.nl', '', 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 1);



and


-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generatie Tijd: 28 Nov 2008 om 11:34
-- Server versie: 5.0.33
-- PHP Versie: 5.2.1
-- 
-- Database: `-`
-- 

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `languages`
-- 

CREATE TABLE `languages` (
  `languages_id` int(11) NOT NULL auto_increment,
  `name` varchar(32) collate utf8_unicode_ci NOT NULL,
  `code` char(2) collate utf8_unicode_ci NOT NULL,
  `image` varchar(64) collate utf8_unicode_ci default NULL,
  `directory` varchar(32) collate utf8_unicode_ci default NULL,
  `sort_order` int(3) default NULL,
  PRIMARY KEY  (`languages_id`),
  KEY `idx_languages_name_zen` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `languages`
-- 

INSERT INTO `languages` (`languages_id`, `name`, `code`, `image`, `directory`, `sort_order`) VALUES 
(2, 'Nederlands', 'NL', 'icon.gif', 'dutch', 0);

[yellow1912]

Thank you, now I know why ^_^. I will release a fix for that soon.
It's looking for page title with language id 2, so obviously it will not find any.

[nagelkruid]

Thank you, now I know why ^_^. I will release a fix for that soon.
It's looking for page title with language id 2, so obviously it will not find any.

Ah yes, i can see that now :)
If that can be easily fixed within ssu that would be great, although i see i have to think about making my easy pages create pages with language id 2 instead of 1 as well. (the mod you suggested will probably give extra input text fields which i don't really want/need for this shop) That's why i decided to remove the languange english as a whole to get it out of the product input fields as well and just have 1 input field for the dutch language.

[nagelkruid]

btw. now that you are looking at languages anyway :)
when i am going to the specials i can see it gets resolved to winkel/specials but that page is actually named winkel/aanbiedingen
that is probably very close to what you are looking at right now?

another thing i see is when i look in who's online i see alot of people browsing these lovely url's of which i now know where they are but i also noticed a lot of those get ammended the favicon.ico behind it. like so: /shop/category-c-1_10/favicon.ico
if i click on the link i simply get the correct page, not sure if this is only who's online page prob? (pretty sure didn't see those before the mod)

[nagelkruid]

btw. now that you are looking at languages anyway :)
when i am going to the specials i can see it gets resolved to winkel/specials but that page is actually named winkel/aanbiedingen
that is probably very close to what you are looking at right now?

Nah, thats unfair, these were also so named before off course and names are derived from the actual filename. Forget i mentioned this. This is were aliases would be great if i should so desire.

[nagelkruid]

sorry mate, got 1 more q.
i noticed my additional images are popping up without an image.
looking to replace jscript_dynamic_window_popup.js but i don't have such thing in my includes.
also nu luck tpl_popup_image_additional.php

any idea where i need to look for this one?

[yellow1912]

sorry mate, got 1 more q.
i noticed my additional images are popping up without an image.
looking to replace jscript_dynamic_window_popup.js but i don't have such thing in my includes.
also nu luck tpl_popup_image_additional.php

any idea where i need to look for this one?

This one is pretty simple, in ssu setting just put the additional image page in the exclude page list (I dont remember the exact page name, but if you check the additional image link you will see it is site.com/something/......, that "something" is what you want.

[yellow1912]

btw. now that you are looking at languages anyway :)
when i am going to the specials i can see it gets resolved to winkel/specials but that page is actually named winkel/aanbiedingen
that is probably very close to what you are looking at right now?

another thing i see is when i look in who's online i see alot of people browsing these lovely url's of which i now know where they are but i also noticed a lot of those get ammended the favicon.ico behind it. like so: /shop/category-c-1_10/favicon.ico
if i click on the link i simply get the correct page, not sure if this is only who's online page prob? (pretty sure didn't see those before the mod)

For favicon, just go into includes/templates/your_template/common/html_header.php

Starting from around line 34 you will see:

<?php if (defined('FAVICON')) { ?>
<link rel="icon" href="<?php echo FAVICON; ?>" type="image/x-icon" />
<link rel="shortcut icon" href="<?php echo FAVICON; ?>" type="image/x-icon" />
<?php } //endif FAVICON ?>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER . DIR_WS_HTTPS_CATALOG : HTTP_SERVER . DIR_WS_CATALOG ); ?>" />

Replace that by:

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER . DIR_WS_HTTPS_CATALOG : HTTP_SERVER . DIR_WS_CATALOG ); ?>" />

<?php if (defined('FAVICON')) { ?>
<link rel="icon" href="<?php echo FAVICON; ?>" type="image/x-icon" />
<link rel="shortcut icon" href="<?php echo FAVICON; ?>" type="image/x-icon" />
<?php } //endif FAVICON ?>

You can see that we simple switch the location of the 2 parts.

[nagelkruid]

This one is pretty simple, in ssu setting just put the additional image page in the exclude page list (I dont remember the exact page name, but if you check the additional image link you will see it is site.com/something/......, that "something" is what you want.

Ha! it's only simple if you know the answer ^_^
I tried it but it doesn't seem to work, i have this url in the additional:
http:/mysite/winkel/popup_image_additional/pID/530/pic/0?products_image_large_additional=images/large/taftan_dbedovertrek_bloemen_1_lrg.jpg

i tried to add popup_image_additional, cleared the cache, no go
i also tried products_image_large_additional, cleared the cache no go.

Am i overlooking the obvious?