StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>It turns out this can be done with a relatively simple change to a single file. No .htaccess rewrite rules, simply patch the catalog/controller/common/seo_url.php file and add your pretty URLs to an existing database table.</p> <hr> <p><strong>The patch to seo_url.php:</strong></p> <pre><code>Index: catalog/controller/common/seo_url.php =================================================================== --- catalog/controller/common/seo_url.php (old) +++ catalog/controller/common/seo_url.php (new) @@ -48,7 +42,12 @@ $this->request->get['route'] = 'product/manufacturer/product'; } elseif (isset($this->request->get['information_id'])) { $this->request->get['route'] = 'information/information'; - } + } else { + $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE keyword = '" . $this->db->escape($this->request->get['_route_']) . "'"); + if ($query->num_rows) { + $this->request->get['route'] = $query->row['query']; + } + } if (isset($this->request->get['route'])) { return $this->forward($this->request->get['route']); @@ -88,7 +87,15 @@ } unset($data[$key]); - } + } else { + $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` = '" . $this->db->escape($data['route']) . "'"); + + if ($query->num_rows) { + $url .= '/' . $query->row['keyword']; + + unset($data[$key]); + } + } } } </code></pre> <p>There are two edits required. The first extends the <code>index()</code> function to look in the <code>url_alias</code> table for <em>any</em> keyword matching <code>$this->request->get['_route_']</code>.</p> <p>The second extends the <code>rewrite()</code> function to look in the <code>url_alias</code> table for <em>all</em> routes, not just those for products, manufacturers, and information pages.</p> <hr> <p><strong>Adding entries to the database:</strong></p> <pre><code>INSERT INTO `url_alias` (`url_alias_id`, `query`, `keyword`) VALUES (NULL, 'checkout/cart', 'cart'); </code></pre> <hr> <p>That's it. <a href="http://example.com/cart">http://example.com/cart</a> should return the same thing that <a href="http://example.com/index.php?route=checkout/cart">http://example.com/index.php?route=checkout/cart</a> does, and OpenCart should recognize <code>$this->url->link('checkout/cart');</code> and return a link to the pretty URL <a href="http://example.com/cart">http://example.com/cart</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload