how can i extract the url of a page from the database?

Author Message

vlad katz

Sunday 21 August 2011 1:04:35 pm

i'm trying to get the virtual urls of some pages form the database.  is there a table where this info is stored?  i thought that this was stored in the path_identification_string column of the ezcontentobject_tree table, but it looks like those urls are not correct (they have special characters changed so a "_-_" in the actual url is just "_" in the path_identification_string.

Daniel A. Øien

Sunday 21 August 2011 10:17:03 pm

Virtual URL aliases are stored in the ezurlalias_ml and ezurlalias tables, but it's easier to get this info through a custom template that outputs the full url aliases using {$node.url_alias}.

Daniel A. Øien
Open Concept SA, Norway
Web: http://openconcept.no/
In English: http://openconcept.no/eng

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.