Periodic rotation of displayed articles

Next topic

Author	Message
martin k	Friday 14 October 2005 10:00:54 am Hello, I'm wondering if it's possible to make a periodic rotation of which article will be displayed once a user visits page. What I had in mind was to display a different "article of the day" chosen from all available articles. I'm really not sure how to do this, didn't found any useful documentation. Took a look at cronjob.ini, but this only runs php-scripts?
Marko Žmak	Friday 14 October 2005 4:28:31 pm Could you explain a little? Do you want that articles rotate in some order or randomly? If the sceond is the case, you coul just fetch a random article every time a page is displayed. A way to get a random nubmer is using eZ function for getting current time, together with the mod() function. Does this help you? -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
martin k	Tuesday 18 October 2005 2:48:06 am Yes, I wanted the articles to be rotated daily in some order. I think the right word for it is round-robin. Anyway, we came up with a solution. My mate at work who is quite bright when it comes to databases made a solution using sql. He figured out that structure of the dynamic content was quite neatly arranged in the database. Since EZ uses article priority when it comes to which article to display, he just made a small script that rearranges priorities daily (runs from cron)

Author

Message

Friday 14 October 2005 10:00:54 am

Hello,

I'm wondering if it's possible to make a periodic rotation of which article will be displayed once a user visits page. What I had in mind was to display a different "article of the day" chosen from all available articles.

I'm really not sure how to do this, didn't found any useful documentation. Took a look at cronjob.ini, but this only runs php-scripts?

Marko Žmak

Friday 14 October 2005 4:28:31 pm

Could you explain a little? Do you want that articles rotate in some order or randomly? If the sceond is the case, you coul just fetch a random article every time a page is displayed. A way to get a random nubmer is using eZ function for getting current time, together with the mod() function. Does this help you?

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

martin k

Tuesday 18 October 2005 2:48:06 am

Yes, I wanted the articles to be rotated daily in some order. I think the right word for it is round-robin.

Anyway, we came up with a solution. My mate at work who is quite bright when it comes to databases made a solution using sql. He figured out that structure of the dynamic content was quite neatly arranged in the database. Since EZ uses article priority when it comes to which article to display, he just made a small script that rearranges priorities daily (runs from cron)

eZ debug

Timing:	Jan 18 2025 19:22:59
Script start
Timing:	Jan 18 2025 19:22:59
Module start 'layout'
Timing:	Jan 18 2025 19:22:59
Module start 'content'
Timing:	Jan 18 2025 19:23:00
Module end 'content'
Timing:	Jan 18 2025 19:23:00
Script end

Main resources:

Total runtime	0.6798 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.0082	589.1484	152.6406
Module start 'layout'	0.0082	0.0030	741.7891	39.4766
Module start 'content'	0.0112	0.6669	781.2656	534.5156
Module end 'content'	0.6781	0.0017	1,315.7813	8.2969
Script end	0.6798		1,324.0781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.5501	16	0.0002
Check MTime	0.0016	0.2399	16	0.0001
Mysql Total
Database connection	0.0012	0.1745	1	0.0012
Mysqli_queries	0.6329	93.0979	57	0.0111
Looping result	0.0005	0.0707	55	0.0000
Template Total	0.6451	94.9	2	0.3225
Template load	0.0029	0.4334	2	0.0015
Template processing	0.6421	94.4507	2	0.3210
Template load and register function	0.0002	0.0359	1	0.0002
states
state_id_array	0.0019	0.2845	1	0.0019
state_identifier_array	0.0009	0.1328	2	0.0005
Override
Cache load	0.0024	0.3567	12	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1009	2	0.0003
Fetch class attribute name	0.0012	0.1696	4	0.0003
XML
Image XML parsing	0.0009	0.1253	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0012	4	0.0000
General
dbfile	0.0009	0.1272	18	0.0000
String conversion	0.0000	0.0012	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
3	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: 9 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs