SQL query for remository's groups

Home

Forum

Remository Forum

home | post reply | threaded view | help | rules

Boardwalk :: Forum List

Remository

Joomla 1.5 and Remository

antoine94

Karma: 2

SQL query for remository's groups - 2010/11/30 10:31 Hi,
can you tell me what is the sql query to retrieve the members of a group Remository?

I want to make a list with the names of the members, the group Remository which they belong (several groups) and the number of files uploaded by each member..

I do not understand the tables (it is jos_permissions?)
I have several groups Remository and I want to make a list for each of them and display in frontend.

(may be with Community Builder list wich can make SQL queries and display in the frontend. My site is CB and remository powered. )

thanks for any help

Post edited by: antoine94, at: 2010/11/30 10:32

Post edited by: antoine94, at: 2010/11/30 10:33

| | Sorry, you do not currently have permission to write here.

antoine94 Karma: 2	Re:SQL query for remository's groups - 2010/11/30 12:58 in fact it seems impossible to make this list with CB because CB list can't make querys output CB tables. nor i don't know how to do. but i'm always looking for the good sql syntax to have all the members of a remository group. is someone can help me, please ? thanks Post edited by: antoine94, at: 2010/11/30 13:24
	\| \| Sorry, you do not currently have permission to write here.

admin Karma: 101	Re:SQL query for remository's groups - 2010/12/07 18:19 The table you need to use is xxx_assignments and the relevant records will contain a subject_type of "aUser" and the subject_id will be the user ID number (matches the CMS user table). The role is the same thing as the group. Martin Brampton aka Counterpoint http://aliro.org http://black-sheep-research.com
	\| \| Sorry, you do not currently have permission to write here.

paskuale Karma: 0	Re:SQL query for remository's groups - 2011/07/22 10:53 for make a new group I must insert new record in jos_assignments table ? Great, thanks
	\| \| Sorry, you do not currently have permission to write here.

Boardwalk :: Forum List Remository Joomla 1.5 and Remository

Aliroboard Forum Component 1.2
Aliro Software

Advice Notes

Login

Subscribe to Premium Support

Get priority support for Remository and Glossary, sign up now for a Premium Support monthly subscription:

Or purchase a year's support:

Recommended SEF

Who is Online

Remository welcomes guests and visitors

remository