Well, there are two parts to seo urls, translation from seo url keyword to get variable and visa versa.
1) to translate from keywords to get variables it uses:
Code: Select all
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE keyword = '" . $this->db->escape($part) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "'");
it is not concerned with language, as long as it finds a match it is ok.
Read somewhere long time ago that that was as a failsafe which is nonsense and a mistake in my view.
Still, you could change that to:
Code: Select all
$query = $this->db->query(
"SELECT *
FROM " . DB_PREFIX . "seo_url
WHERE keyword = '" . $this->db->escape($part) . "'
AND (store_id = '" . (int)$this->config->get('config_store_id') . "' OR store_id = 0)
ORDER BY store_id DESC"
);
which tries to find it for the current store id or the default store.
So chances are it could find 2 occurrences so we sort them to pick the current store over the default one.
2) to translate get variables to keywords it uses several depending on the route:
Code: Select all
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
here it does use the language id as it should.
you could use the same principle:
Code: Select all
$query = $this->db->query(
"SELECT *
FROM " . DB_PREFIX . "seo_url
WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "'
AND (store_id = '" . (int)$this->config->get('config_store_id') . "' OR store_id = 0)
AND language_id = '" . (int)$this->config->get('config_language_id') . "'
ORDER BY store_id DESC"
);
so instead of just finding the keyword for the current store, it finds the keyword for default as well but takes current over default.
you can do the same for the remaining category query.
I have not tested this as I do not have multiple stores but it is a peanut change.