Top users according to Number of edits/posts

Next topic

Author	Message
liu spider	Sunday 06 March 2005 6:49:44 pm I am implementing something similar to the stat page in eZ: http://www.ez.no/community/forum/stat However, I can not figure out a straightforward way to achieve the list of Most active users according to Number of edits/posts. Could anyone enlighten me? Or do I need to write some php code to retrieve this kind of info from database? or do I have to write an extension to achieve it? (I search on eZ and the pubsvn for extensions, with no luck) thanks. http://liucougar.scim-im.org SCIM Input Method Platform http://scim.sf.net SJSD Online Editor http://sf.net/projects/sjsd
Łukasz Serwatka	Sunday 06 March 2005 10:01:16 pm Hi, You can use "object_count_by_user_id" to fetch number of objects of a specific class created by a user. http://ez.no/ez_publish/documentation/reference/data_fetching/content/object_count_by_user_id Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
liu spider	Monday 07 March 2005 5:37:52 am thanks, I also noticed that on the documentation. However, how can I figure out who are the top users? And how can I retrieve the modification number of a given user? Thanks a lot. http://liucougar.scim-im.org SCIM Input Method Platform http://scim.sf.net SJSD Online Editor http://sf.net/projects/sjsd
kevin wei	Wednesday 04 January 2006 9:04:37 pm how to sort these user when get the count?
Per-Espen Kindblad	Thursday 05 January 2006 1:58:13 am Hi! The eZ team has developed this: http://ez.no/community/forum/statistics with use of custom tag. Maybe they can add this custom tag to the contribution? Best regards
kevin wei	Thursday 05 January 2006 2:36:33 am it is a very useful feature, to list top 10 by the number of its child , wish someone can provide this code,thx!

eZ debug

Timing:	Jan 18 2025 22:32:28
Script start
Timing:	Jan 18 2025 22:32:28
Module start 'layout'
Timing:	Jan 18 2025 22:32:28
Module start 'content'
Timing:	Jan 18 2025 22:32:29
Module end 'content'
Timing:	Jan 18 2025 22:32:29
Script end

Main resources:

Total runtime	0.9162 sec
Peak memory usage	4,096.0000 KB
Database Queries	70

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0054	589.1797	152.6406
Module start 'layout'	0.0054	0.0032	741.8203	39.4766
Module start 'content'	0.0087	0.9057	781.2969	646.5938
Module end 'content'	0.9144	0.0018	1,427.8906	16.1250
Script end	0.9161		1,444.0156

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.3633	16	0.0002
Check MTime	0.0014	0.1557	16	0.0001
Mysql Total
Database connection	0.0007	0.0767	1	0.0007
Mysqli_queries	0.8544	93.2529	70	0.0122
Looping result	0.0008	0.0843	68	0.0000
Template Total	0.8797	96.0	2	0.4399
Template load	0.0020	0.2137	2	0.0010
Template processing	0.8778	95.8077	2	0.4389
Template load and register function	0.0001	0.0110	1	0.0001
states
state_id_array	0.0020	0.2221	1	0.0020
state_identifier_array	0.0012	0.1330	2	0.0006
Override
Cache load	0.0016	0.1780	30	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0823	4	0.0002
Fetch class attribute name	0.0015	0.1628	9	0.0002
XML
Image XML parsing	0.0015	0.1647	4	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0019	10	0.0000
General
dbfile	0.0011	0.1163	27	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
4	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
6	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
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 21 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs