Forums / Developer / Howto find registered users in groups in eZ p. with sql?

Howto find registered users in groups in eZ p. with sql?

Previous topic

Developer

Next topic

Author	Message
K259	Monday 11 July 2005 5:52:53 am I have some questions about listing registered users in mysql. What is the sql-syntax? I have problems with finding these users through the admin interface. We have 30 different user groups, and when I'm going to search for a user, I don't know where these users are located. The admin-interface don't have the option to search for users like many other CMS either, which makes the administration difficult to manage. So I need to have a sql-query which lists all users in a spesific role. Anyone who knows?

Author

Message

K259

Monday 11 July 2005 5:52:53 am

I have some questions about listing registered users in mysql. What is the sql-syntax?

I have problems with finding these users through the admin interface. We have 30 different user groups, and when I'm going to search for a user, I don't know where these users are located.

The admin-interface don't have the option to search for users like many other CMS either, which makes the administration difficult to manage.

So I need to have a sql-query which lists all users in a spesific role.

Anyone who knows?

eZ debug

Timing:

Jan 20 2025 10:00:54

Script start

Timing:

Jan 20 2025 10:00:54

Module start 'content'

Timing:

Jan 20 2025 10:00:54

Module end 'content'

Timing:

Jan 20 2025 10:00:54

Script end

Main resources:

Total runtime

0.1683 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.0059	589.1953	180.8125
Module start 'content'	0.0059	0.0089	770.0078	89.7734
Module end 'content'	0.0148	0.1535	859.7813	518.2969
Script end	0.1683		1,378.0781

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0059

589.1953

180.8125

Module start 'content'

0.0059

0.0089

770.0078

89.7734

Module end 'content'

0.0148

0.1535

859.7813

518.2969

Script end

0.1683

1,378.0781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	2.1934	20	0.0002
Check MTime	0.0014	0.8457	20	0.0001
Mysql Total
Database connection	0.0007	0.3909	1	0.0007
Mysqli_queries	0.1143	67.9195	141	0.0008
Looping result	0.0014	0.8506	139	0.0000
Template Total	0.1530	90.9	1	0.1530
Template load	0.0009	0.5162	1	0.0009
Template processing	0.1521	90.3720	1	0.1521
Override
Cache load	0.0006	0.3541	1	0.0006
Sytem overhead
Fetch class attribute can translate value	0.0007	0.4355	1	0.0007
XML
Image XML parsing	0.0002	0.1396	1	0.0002
General
dbfile	0.0094	5.5643	20	0.0005
String conversion	0.0000	0.0031	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.0037

2.1934

0.0002

Check MTime

0.0014

0.8457

0.0001

Mysql Total

Database connection

0.0007

0.3909

0.0007

Mysqli_queries

0.1143

67.9195

141

0.0008

Looping result

0.0014

0.8506

139

0.0000

Template Total

0.1530

90.9

0.1530

Template load

0.0009

0.5162

0.0009

Template processing

0.1521

90.3720

0.1521

Override

Cache load

0.0006

0.3541

0.0006

Sytem overhead

Fetch class attribute can translate value

0.0007

0.4355

0.0007

XML

Image XML parsing

0.0002

0.1396

0.0002

General

dbfile

0.0094

5.5643

0.0005

String conversion

0.0000

0.0031

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