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

eZ debug

Timing:

Jan 17 2025 21:13:05

Script start

Timing:

Jan 17 2025 21:13:05

Module start 'content'

Timing:

Jan 17 2025 21:13:05

Module end 'content'

Timing:

Jan 17 2025 21:13:05

Script end

Main resources:

Total runtime

0.1342 sec

Peak memory usage

2,048.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0065	597.3281	180.8203
Module start 'content'	0.0065	0.0046	778.1484	95.5000
Module end 'content'	0.0111	0.1230	873.6484	522.3438
Script end	0.1342		1,395.9922

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0065

597.3281

180.8203

Module start 'content'

0.0065

0.0046

778.1484

95.5000

Module end 'content'

0.0111

0.1230

873.6484

522.3438

Script end

0.1342

1,395.9922

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	2.3454	20	0.0002
Check MTime	0.0012	0.8970	20	0.0001
Mysql Total
Database connection	0.0012	0.8760	1	0.0012
Mysqli_queries	0.0944	70.3239	141	0.0007
Looping result	0.0013	0.9924	139	0.0000
Template Total	0.1228	91.5	1	0.1228
Template load	0.0009	0.6369	1	0.0009
Template processing	0.1219	90.8179	1	0.1219
Override
Cache load	0.0005	0.3918	1	0.0005
Sytem overhead
Fetch class attribute can translate value	0.0007	0.5558	1	0.0007
XML
Image XML parsing	0.0003	0.1931	1	0.0003
General
dbfile	0.0015	1.1202	20	0.0001
String conversion	0.0000	0.0059	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0031

2.3454

0.0002

Check MTime

0.0012

0.8970

0.0001

Mysql Total

Database connection

0.0012

0.8760

0.0012

Mysqli_queries

0.0944

70.3239

141

0.0007

Looping result

0.0013

0.9924

139

0.0000

Template Total

0.1228

91.5

0.1228

Template load

0.0009

0.6369

0.0009

Template processing

0.1219

90.8179

0.1219

Override

Cache load

0.0005

0.3918

0.0005

Sytem overhead

Fetch class attribute can translate value

0.0007

0.5558

0.0007

XML

Image XML parsing

0.0003

0.1931

0.0003

General

dbfile

0.0015

1.1202

0.0001

String conversion

0.0000

0.0059

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

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

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs