fetch ordered on publish date with google bar

Next topic

Author	Message
Joris Lint	Thursday 06 November 2003 3:30:02 am How do I make a fetch on news articles ordered by ' published on' date. And how can I show maximum of five with a goole bar under it to go to the next page of news articles. (a google bar is: [1][2][3]...)
Eirik Alfstad Johansen	Wednesday 12 November 2003 12:01:50 pm Hi Joris, Here are the bits and pieces. You'll have to glue them together yourself. To sort articles by the date they're published, use the parameter "sort_by,array(published,false())" to sort articles from new to old, and "sort_by,array(published,true())" to sort from old to new (in a fetch function). To show a maximum of five articles, use the parameter "limit, 5". Getting a Google toolbar should not be a problem as this is included in the default node/view.tpl, so just copy that one and add the parameters above. Good luck ! Sincerely, Eirik Johansen Netmaking AS http://www.netmaking.no/ Sincerely, Eirik Alfstad Johansen http://www.netmaking.no/
Joris Lint	Tuesday 18 November 2003 12:26:05 am Tx, this is what i needed.

Author

Message

Thursday 06 November 2003 3:30:02 am

How do I make a fetch on news articles ordered by ' published on' date.
And how can I show maximum of five with a goole bar under it to go to the next page of news articles. (a google bar is: [1][2][3]...)

Eirik Alfstad Johansen

Wednesday 12 November 2003 12:01:50 pm

Hi Joris,

Here are the bits and pieces. You'll have to glue them together yourself.

To sort articles by the date they're published, use the parameter "sort_by,array(published,false())" to sort articles from new to old, and "sort_by,array(published,true())" to sort from old to new (in a fetch function).

To show a maximum of five articles, use the parameter "limit, 5".

Getting a Google toolbar should not be a problem as this is included in the default node/view.tpl, so just copy that one and add the parameters above.

Good luck !

Sincerely,

Eirik Johansen
Netmaking AS

http://www.netmaking.no/

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Joris Lint

Tuesday 18 November 2003 12:26:05 am

Tx, this is what i needed.

eZ debug

Timing:	Jan 19 2025 00:35:30
Script start
Timing:	Jan 19 2025 00:35:30
Module start 'layout'
Timing:	Jan 19 2025 00:35:30
Module start 'content'
Timing:	Jan 19 2025 00:35:31
Module end 'content'
Timing:	Jan 19 2025 00:35:31
Script end

Main resources:

Total runtime	1.0082 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	588.0469	152.6406
Module start 'layout'	0.0066	0.0037	740.6875	39.4766
Module start 'content'	0.0104	0.9964	780.1641	530.1328
Module end 'content'	1.0068	0.0014	1,310.2969	8.1250
Script end	1.0081		1,318.4219

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.3283	16	0.0002
Check MTime	0.0014	0.1347	16	0.0001
Mysql Total
Database connection	0.0009	0.0917	1	0.0009
Mysqli_queries	0.9605	95.2687	57	0.0169
Looping result	0.0006	0.0584	55	0.0000
Template Total	0.9769	96.9	2	0.4885
Template load	0.0030	0.3006	2	0.0015
Template processing	0.9739	96.5956	2	0.4869
Template load and register function	0.0003	0.0264	1	0.0003
states
state_id_array	0.0007	0.0714	1	0.0007
state_identifier_array	0.0014	0.1356	2	0.0007
Override
Cache load	0.0024	0.2331	19	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0682	2	0.0003
Fetch class attribute name	0.0016	0.1594	4	0.0004
XML
Image XML parsing	0.0007	0.0682	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0011	4	0.0000
General
dbfile	0.0009	0.0888	16	0.0001
String conversion	0.0000	0.0011	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 12 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs