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

eZ debug

Timing:	Jan 29 2025 13:34:40
Script start
Timing:	Jan 29 2025 13:34:40
Module start 'layout'
Timing:	Jan 29 2025 13:34:40
Module start 'content'
Timing:	Jan 29 2025 13:34:40
Module end 'content'
Timing:	Jan 29 2025 13:34:40
Script end

Main resources:

Total runtime	0.0127 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0043	588.3594	151.2266
Module start 'layout'	0.0043	0.0026	739.5859	36.6875
Module start 'content'	0.0069	0.0047	776.2734	90.1094
Module end 'content'	0.0116	0.0011	866.3828	29.9766
Script end	0.0127		896.3594

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0020	15.4741	14	0.0001
Check MTime	0.0009	7.1159	14	0.0001
Mysql Total
Database connection	0.0008	6.0838	1	0.0008
Mysqli_queries	0.0020	15.9601	3	0.0007
Looping result	0.0000	0.2196	1	0.0000
Template Total	0.0009	6.7	1	0.0009
Template load	0.0006	4.9429	1	0.0006
Template processing	0.0002	1.7546	1	0.0002
Override
Cache load	0.0004	3.3365	1	0.0004
General
dbfile	0.0011	8.7617	8	0.0001
String conversion	0.0000	0.0582	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs