[BETA] Account Links

[saashannon]

Yeah, we did. Checked the db and the master_id field is there with the right settings (I think).

[Drakkim]

Apearantly some of my (unfinished) development code made it into the 'final' package. Grab the new package from my site and see if that works. This time it's straight off the versions running on my site

-Drakkim

[Drakkim]

I just fixed the account_switch_form function to use the language system... (functions_linked_acct.php) If you already updated, make sure you use 0.5.2

-Drakkim

[mhorst]

Hi,

I installed your mod and tested it for a bit. So far it seems to work great.

I did run into a few problems at first though:
- I couldn't view the Linked_Accounts.xml file in Firefox under Debian etch. As I understand it this is probably a problem with my system, rather than with the mod. But it was simple enough to open the xml file in another viewer and install the mod.
- At first I could not link accounts, receiving a database error when I tried to. The reason for this is that my forum runs on a Postgres database system, which does not support limits on update queries.
My solution: In functions_linked_acct.php, in the function link_accounts, I replaced "sql_query_limit($sql, 1)" by "sql_query($sql)"
- The second problem was that after linking the mod told me that there were no linked accounts.
My solution: In functions_linked_acct.php, in the function get_linked_accounts, I replaced "sql_query_limit($sql, $count)" by "sql_query($sql)".
Again the limit query was the problem, but now for a different reason: the $count variable is never initialized (and therefore gets the value 0, I assume).
BTW if nobody else has this problem I guess the count variable is given a random value on their system, or their database system silently ignores limit queries.
- After that I had a problem switching between accounts. I think this might be because I linked the admin account as a master account to an ordinary account. When logged in as admin I cannot switch to the ordinary account, but when I first log in as an ordinary user I can switch to the admin account and back again without problems. I'll see if I can figure out where the problem is.

Anyways, thanks for the mod I think it will be very useful on my forum.

[Drakkim]

- At first I could not link accounts, receiving a database error when I tried to. The reason for this is that my forum runs on a Postgres database system, which does not support limits on update queries.
My solution: In functions_linked_acct.php, in the function link_accounts, I replaced "sql_query_limit($sql, 1)" by "sql_query($sql)"

Hmm... If that's a limit to pgSQL, I'd have thought the DBAL would have taken care it... that's the point of DBAL, isn't it? That will work... since we're looking up by user_id, there can only be one return anyway

- The second problem was that after linking the mod told me that there were no linked accounts.
My solution: In functions_linked_acct.php, in the function get_linked_accounts, I replaced "sql_query_limit($sql, $count)" by "sql_query($sql)".

This one was actually bad code your change is correct.

- After that I had a problem switching between accounts. I think this might be because I linked the admin account as a master account to an ordinary account. When logged in as admin I cannot switch to the ordinary account, but when I first log in as an ordinary user I can switch to the admin account and back again without problems. I'll see if I can figure out where the problem is.

That one is strange... I actually have my admin account as 'Master' and two normal users as 'Linked' I have no problems switching among any of accounts.

I'll make the sql_query changes in the code for the next revision... in the mean time... let me know if you find anything on the last one... Even if it's just something that I can use to duplicate or debug.

-Drakkim

[Frug]

Holy crap dude!

I spent days looking for this mod for phpbb2 and nobody had it, nobody thought it was worth making. You rule! Thank you!

[mhorst]

- At first I could not link accounts, receiving a database error when I tried to. The reason for this is that my forum runs on a Postgres database system, which does not support limits on update queries.
My solution: In functions_linked_acct.php, in the function link_accounts, I replaced "sql_query_limit($sql, 1)" by "sql_query($sql)"

Hmm... If that's a limit to pgSQL, I'd have thought the DBAL would have taken care it... that's the point of DBAL, isn't it? That will work... since we're looking up by user_id, there can only be one return anyway

Yeah, I guess the DBAL should be extended so that the sql_query_limit function for pgSQL differentiates between update queries and other queries.
Maybe we should submit it as a bug?

- After that I had a problem switching between accounts. I think this might be because I linked the admin account as a master account to an ordinary account. When logged in as admin I cannot switch to the ordinary account, but when I first log in as an ordinary user I can switch to the admin account and back again without problems. I'll see if I can figure out where the problem is.

That one is strange... I actually have my admin account as 'Master' and two normal users as 'Linked' I have no problems switching among any of accounts.

I'll make the sql_query changes in the code for the next revision... in the mean time... let me know if you find anything on the last one... Even if it's just something that I can use to duplicate or debug.

It seems some of my users also have problems with it, so its not the admin account. I think it might matter what account you log into. If you originally login on a linked account everything works fine, but when your original login is on the master account things go awry. I think .
I'll have more time to do more testing and figure this one out during the weekend.

Oh, and I forgot one in my previous post:
I replaced "MEDIUMINT ( 8 ) UNSIGNED" in the ALTER TABLE query by "integer", since that is the type of the user_id field in my pgSQL database.

EDIT:
I did some more testing: apparently it has nothing to do with the master or linked account.
When I log into my forum with the option "Log me on automatically each visit" enabled I cannot switch between accounts. If I log out and log in again without that option enabled it works fine.

EDIT2:
I added the line "$user->cookie_data['k'] = false;"
before "$result = $user->session_create($forumid, $admin, $autologin, $viewonline);"
in the function startsession_byID in the file functions_linked_acct.php
This effectively erases the autologin key, which the session_create function searches for and causes it to automatically login as the user for which the autologin option was enabled.
This seems to solve the problem, but I don't know what kind of repercussions it might have.

EDIT3:
As I could have expected my modification disables the auto login feature.
I think I solved this by adding another line containing "$autologin = $user->data['session_autologin']" before the "$result = $user->session_create($forumid, $admin, $autologin, $viewonline);".
This should copy the autologin settings from the previous session to the new session.

[TheMiNd]

Been a while since Drakkim's posted. Lets hope you're reading.

*I'm not finding any edits that actually add the ability to link accounts. Is that a mistake? I don't see any fields that will let me link the accounts.
*I'd like some suggestions on making the account selection form's size match my theme.

[Drakkim]

phpBB.com tells me when to read

All of the 'brains' are in the module and should match whatever theme you use. The only exception is the actual Account Switch box which silly me coded into the main functions. I probably need to make that a template as well and just include that when the function gets called. If that's more or less what you're looking for, let me know and I'll see if I can't work that into a new version (along with some of mhorst's changes).

-Drakkim

[TheMiNd]

Yeah the Account Switch box is what I need to match the theme. Right now the box is bigger than it should be given the rest of the skin.

What about actually Linking the accounts? Where do I do that?

[Drakkim]

After you install the modules (via ACP), the options are in the User Control Panel under Profile.

-Drakkim

[Frug]

Have i mentioned that you're my hero drakkim?

[naushadhassam]

great mod dude. it will def come in handy

[Rotsblok]

Can it also be made so that only admins and or mods can link accounts???? would come in handy on lots of boards

[Drakkim]

I don't see why not... I'll have to look into the permission level stuff... not sure how that works... But first I have to look into the RC7 changes... An account that was linked before still works after the upgrade... but because of the password changes, you can't link new accounts.

I'll be getting that fixed hopefully in the next few days...

-Drakkim