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

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

Next topic

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

Author

Message

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