Question list ID of users who have access to my tree

mariannevanharten
Topic Author
Offline
Premium Member

4 months 3 weeks ago #1 by mariannevanharten

list ID of users who have access to my tree was created by mariannevanharten

I want to create a list of users (especially the INDI ID) who have access to my tree.
I think it is possible using PHPMyAdmin, but I do not know which table and which command I have to use.

Who can help me?

Best regards,
Marianne van Harten

Please Log in or Create an account to join the conversation.

Franz Frese
Offline
Elite Member

4 months 3 weeks ago #2 by Franz Frese

Replied by Franz Frese on topic list ID of users who have access to my tree

Have a look into your control panel.

p.s.: a user is not nexessarily in your tree.

For to get help, tell the address of your webtrees site!
mine is: freris.de

Please Log in or Create an account to join the conversation.

mariannevanharten
Topic Author
Offline
Premium Member

4 months 3 weeks ago #3 by mariannevanharten

Replied by mariannevanharten on topic list ID of users who have access to my tree

I have a long list of users, so I prefer to have a mysql command.
Also I know that not all users will be part of my tree. Although I add them manually.

Please Log in or Create an account to join the conversation.

Franz Frese
Offline
Elite Member

4 months 3 weeks ago #4 by Franz Frese

Replied by Franz Frese on topic list ID of users who have access to my tree

So, if you have a long list: what do you need more?
What should such a list be good for?

For to get help, tell the address of your webtrees site!
mine is: freris.de

Please Log in or Create an account to join the conversation.

bertkoor
Offline
Platinum Member
Greetings from Utrecht, Holland

4 months 3 weeks ago #5 by bertkoor

Replied by bertkoor on topic list ID of users who have access to my tree

Query something like select some columns from users and user tree prefs where tree id is one.
I'm on my phone, no access to the table structures...

stamboom.BertKoor.nl runs on webtrees v2.1.20

Please Log in or Create an account to join the conversation.

Franz Frese
Offline
Elite Member

4 months 3 weeks ago - 4 months 3 weeks ago #6 by Franz Frese

Replied by Franz Frese on topic list ID of users who have access to my tree

If you can't do this yourself with PHPMyAdmin, you should stay away from it.
If you can’t do it yourself, you should keep your hands off it.

For to get help, tell the address of your webtrees site!
mine is: freris.de

Last edit: 4 months 3 weeks ago by Franz Frese.

Please Log in or Create an account to join the conversation.

fisharebest
Offline
Administrator

4 months 3 weeks ago #7 by fisharebest

Replied by fisharebest on topic list ID of users who have access to my tree

Try this SQL statement:

select user_name, real_name, email, setting_value, gedcom_name
from wt_user_gedcom_setting
JOIN wt_user USING (user_id)
JOIN wt_gedcom USING (gedcom_id)
WHERE setting_name = 'gedcomid' and setting_value <> '';

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.