Forums / Developer / Get calendar and corresponding events from database

Get calendar and corresponding events from database

Next topic

Author	Message
Ivan Švogor	Tuesday 04 January 2011 6:38:03 am Hello, I need to access the database so I could do some tweaking of calendar. So what I need is the calendar and its events, in php code. I will than export it to ical format. Can anyone tell me how to access this in code? tnx
Edi Modrić	Monday 10 January 2011 7:16:52 am Hi Ivan, Calendar and events are just regular content objects and you can use eZ Publish PHP API to access them in your code. Take a look at here http://pubsvn.ez.no/doxygen/4.4/html/ , specifically the documentation for eZContentObject and eZContentObjectTreeNode PHP classes. For example, you can use eZContentObjectTreeNode::subTreeByNodeID(false, 123) static function to fetch all nodes below node with node_id = 123 eZ Publish certified developer http://ez.no/certification/verify/350658

Author

Message

Tuesday 04 January 2011 6:38:03 am

Hello, I need to access the database so I could do some tweaking of calendar. So what I need is the calendar and its events, in php code. I will than export it to ical format.

Can anyone tell me how to access this in code?

tnx

Edi Modrić

Monday 10 January 2011 7:16:52 am

Hi Ivan,

Calendar and events are just regular content objects and you can use eZ Publish PHP API to access them in your code.

Take a look at here http://pubsvn.ez.no/doxygen/4.4/html/ , specifically the documentation for eZContentObject and eZContentObjectTreeNode PHP classes.

For example, you can use eZContentObjectTreeNode::subTreeByNodeID(false, 123) static function to fetch all nodes below node with node_id = 123

eZ Publish certified developer

http://ez.no/certification/verify/350658

eZ debug

Timing:

Jan 30 2025 00:55:16

Script start

Timing:

Jan 30 2025 00:55:16

Module start 'content'

Timing:

Jan 30 2025 00:55:16

Module end 'content'

Timing:

Jan 30 2025 00:55:16

Script end

Main resources:

Total runtime

0.2406 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.0056	588.0781	180.8203
Module start 'content'	0.0056	0.0073	768.8984	93.9453
Module end 'content'	0.0129	0.2276	862.8438	521.9844
Script end	0.2406		1,384.8281

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0056

588.0781

180.8203

Module start 'content'

0.0056

0.0073

768.8984

93.9453

Module end 'content'

0.0129

0.2276

862.8438

521.9844

Script end

0.2406

1,384.8281

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	1.3239	20	0.0002
Check MTime	0.0013	0.5453	20	0.0001
Mysql Total
Database connection	0.0007	0.3092	1	0.0007
Mysqli_queries	0.1966	81.6839	141	0.0014
Looping result	0.0010	0.4145	139	0.0000
Template Total	0.2273	94.5	1	0.2273
Template load	0.0008	0.3138	1	0.0008
Template processing	0.2265	94.1432	1	0.2265
Override
Cache load	0.0005	0.2074	1	0.0005
Sytem overhead
Fetch class attribute can translate value	0.0006	0.2701	1	0.0006
XML
Image XML parsing	0.0002	0.1022	1	0.0002
General
dbfile	0.0088	3.6501	20	0.0004
String conversion	0.0000	0.0020	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.0032

1.3239

0.0002

Check MTime

0.0013

0.5453

0.0001

Mysql Total

Database connection

0.0007

0.3092

0.0007

Mysqli_queries

0.1966

81.6839

141

0.0014

Looping result

0.0010

0.4145

139

0.0000

Template Total

0.2273

94.5

0.2273

Template load

0.0008

0.3138

0.0008

Template processing

0.2265

94.1432

0.2265

Override

Cache load

0.0005

0.2074

0.0005

Sytem overhead

Fetch class attribute can translate value

0.0006

0.2701

0.0006

XML

Image XML parsing

0.0002

0.1022

0.0002

General

dbfile

0.0088

3.6501

0.0004

String conversion

0.0000

0.0020

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