Linked Accounts

Suggestions - Linked Accounts

Suggestions

by Shenzy » Tue May 21, 2019 5:35 pm

Hello,
I've got 2 suggestions, though I'm not sure if the first one is possible, since it would skip the typing of passwords. I'll try to explain it with an example anyway:

I have 5 Accounts, Acc1, Acc2, Acc3, Acc4, Acc5, the 5th being the newest that I now want to link. But, if I just link it to Acc1 (the main Account), the rest of the accounts aren't accessible from Acc5 and also won't show up in the profile of Acc5. To make that possible, I'd also have to link the 2nd, 3rd and 4th to Acc5 (and Acc2 to Acc3, Acc2 to Acc4...you get what I mean).
Now my question is, is it somehow possible to program it so that when I link the Acc5 to Acc1, it will also link to the other Accounts that are already linked to the 1st?
If not, is it at least possible to make all of the Accounts visible in the profile, even if they don't have direct links to each other?

I hope you can understand what I mean. It would be a great feature for my forum.

The 2nd suggestion is: Maybe somehow make it possible to give the option to add custom profile fields to the linked accounts table in the user profile, like you can with the memberlist.
Shenzy
Registered User
Posts: 27
Joined: Mon May 28, 2018 10:42 pm
Contact:

Re: Suggestions

by Flerex » Tue May 21, 2019 8:36 pm

Hello,

Regarding your first suggestion. I have been thinking about implementing it for a while, as it's not the first time it is suggested. Unfortunately, I'm having trouble finding an efficient way of implementing this, as the ideal way would be to use recursive SQL queries, but I think it would only work in forums using PostgreSQL, so it's not an ideal solution. I'm still thinking about a way to implement it. Don't expect it any time soon though. If I find a way of doing this without compromising efficiency, I'll do it right away.

Regarding your second suggestion. Could you elaborate on that? I don't understand how that would be useful or relevant for the extension. Is it just showing some random field in the 1.2 feature that shows a table of the linked accounts in the profile? Or are you talking about the switching menu in the navigation bar?
User avatar
Flerex
Registered User
Posts: 87
Joined: Sun Oct 14, 2012 8:35 pm
Location: Galicia, Spain
Name: Flerex
Contact:

Re: Suggestions

by Shenzy » Tue May 21, 2019 9:21 pm

Hello,

I understand, take your time with it. It's just something that came up while chatting with my users today.

I'm using the newest version from github, where the linked accounts are visible as a table below the profile while viewing the profile of a user. At the moment it just shows the avatar, name and rank, I just thought it would be useful if custom profile fields could be added to it, to display more useful information in the table. I don't mean a random field, in the phpBB software you can already add custom profile fields and choose where to display them (profile, post profile, memberlist etc.) and I mean having that option for the linked accounts table. I've tried playing around with it, but couldn't get it to work since I'm not experienced with phpBB coding at all.
Shenzy
Registered User
Posts: 27
Joined: Mon May 28, 2018 10:42 pm
Contact:

Re: Suggestions

by Autumn Shade » Tue Jun 18, 2019 6:59 am

Flerex wrote:Hello,

Regarding your first suggestion. I have been thinking about implementing it for a while, as it's not the first time it is suggested. Unfortunately, I'm having trouble finding an efficient way of implementing this, as the ideal way would be to use recursive SQL queries, but I think it would only work in forums using PostgreSQL, so it's not an ideal solution. I'm still thinking about a way to implement it. Don't expect it any time soon though. If I find a way of doing this without compromising efficiency, I'll do it right away.

Regarding your second suggestion. Could you elaborate on that? I don't understand how that would be useful or relevant for the extension. Is it just showing some random field in the 1.2 feature that shows a table of the linked accounts in the profile? Or are you talking about the switching menu in the navigation bar?
Greets, Flerex, why not just creating a table where you contain all the relationships. Let me explain, as you might already did it. I'd personally create a table where the table has an id of the relationship, an user_id of the current account and the user_id of the account that is linked to. That way you can count the links by user_id and you can see the links in every account.
User avatar
Autumn Shade
Registered User
Posts: 29
Joined: Thu May 30, 2019 12:38 pm
Contact:

Re: Suggestions

by Flerex » Tue Jun 18, 2019 2:29 pm

Yeah, that is how it is currently implemented. The problem is that if we want to allow transitive relationships to a certain degree (if A is linked to B and B to C, then A is linked to C) we would have to use recursive SQL queries to select all the possibilities from a scheme like the one you mentioned.
User avatar
Flerex
Registered User
Posts: 87
Joined: Sun Oct 14, 2012 8:35 pm
Location: Galicia, Spain
Name: Flerex
Contact: