Articles Table in database

Author Message

John Smith

Tuesday 22 March 2005 4:25:21 am

Can anybody please tell me in which database tables the articles are stored.

I am using ez 3.5.1

cheers

 

Frederik Holljen

Tuesday 22 March 2005 4:30:43 am

Articles are stored together with all the other content objects in the table: ezcontentobject_ tables. The actual data can be found in the table ezcontentobject_attribute

John Smith

Tuesday 22 March 2005 4:34:29 am

Is that true for 3.5.0 as well?

Frederik Holljen

Tuesday 22 March 2005 4:39:03 am

yes, it's true for all 3.x versions.

John Smith

Tuesday 22 March 2005 4:39:52 am

One more thing i want to fetch the latest 10 new articles with php script and want to display on other site.

Would it be possible?

Frederik Holljen

Tuesday 22 March 2005 4:41:37 am

yes, that would be very possible :). There already fetch functions that do this kind of work. Take a look at how they work.

You can also export the latest 10 articles by rss to your other site. No programming needed.

John Smith

Tuesday 22 March 2005 4:48:34 am

you said no programming needed by rss. but how my other site will display those articles from the rss export.

Please clear this point.

Ekkehard Dörre

Tuesday 22 March 2005 7:56:35 am

e.g. a javascript rss viewer, look here:
http://www.hebig.org/blogs/archives/main/000877.php

more info:
http://en.wikipedia.org/wiki/RSS_%28protocol%29

in php:
http://www.zend.com/zend/spotlight/code-gallery-wade6.php

Greetings, ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

John Smith

Tuesday 22 March 2005 8:32:28 am

hi Doerre

You are doing wonderful by helping other, keep it up mate. thanks once again.

I will have a look. Mate one thing more, what is right way to export the rss in my case.

cheers

Ekkehard Dörre

Tuesday 22 March 2005 9:13:47 am

import:
http://ez.no/ez_publish/documentation/incoming/setting_up_rss_import
export via admin->setup->RSS.
http://ez.no/community/forum/setup_design/how_do_you_set_up_rss_exports

http://ez.no/content/advancedsearch?SearchText=rss+export&SearchDate=-1&SearchPageLimit=2&SearchContentClassID=14&SearchButton=Search
more help:
http://ez.no/products/books/ez_publish_book

Greetings, ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

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

eZ debug

Timing: Jan 20 2025 02:22:48
Script start
Timing: Jan 20 2025 02:22:48
Module start 'layout'
Timing: Jan 20 2025 02:22:48
Module start 'content'
Timing: Jan 20 2025 02:22:49
Module end 'content'
Timing: Jan 20 2025 02:22:49
Script end

Main resources:

Total runtime1.2256 sec
Peak memory usage4,096.0000 KB
Database Queries80

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0052 589.1563152.6250
Module start 'layout' 0.00520.0032 741.781339.4453
Module start 'content' 0.00841.2156 781.2266653.0000
Module end 'content' 1.22400.0015 1,434.226620.1641
Script end 1.2255  1,454.3906 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.2739160.0002
Check MTime0.00140.1123160.0001
Mysql Total
Database connection0.00060.046110.0006
Mysqli_queries1.148293.6833800.0144
Looping result0.00080.0666780.0000
Template Total1.192497.320.5962
Template load0.00190.151520.0009
Template processing1.190697.140820.5953
Template load and register function0.00020.018010.0002
states
state_id_array0.00120.099310.0012
state_identifier_array0.00100.077920.0005
Override
Cache load0.00180.1500490.0000
Sytem overhead
Fetch class attribute can translate value0.00100.078530.0003
Fetch class attribute name0.00220.1834120.0002
XML
Image XML parsing0.00140.116130.0005
class_abstraction
Instantiating content class attribute0.00000.0029150.0000
General
dbfile0.00120.0961220.0001
String conversion0.00000.000840.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
10content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
13content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
5content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 35
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs