bridging after there are users in forum and in gallery

[mindwall]

I had to bridge after I already have user accounts in both gallery and forum and of course there are unwanted results as the accounts are not "matched" properly against eachother.
As I understand I can only resolve this by manually editing the database entries.

Is there more information on what to change in the DB entries to "assign" users taken from the forum's list to the proper users/albums that already were created in the gallery?

Coppermine install: http://www.46it.ca/gallery/
Forum install: http://www.46it.ca/forum/
FRAME INTERFACE (buttons on right): http://www.46it.ca
(press the little green BTR-ON button to turn red to avoid listening to radio)
Coppermine version: 1.4.5 (stable)
Forum version: phpBB 2.0.19
Test user account: tester/tester

BridgeManager settings:
Forum URL:  http://www.46it.ca/forum/
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  yes

[mindwall]

I'm not very good with this, so I apologize if I ask something stupid...

When bridging, does the cpg143_users > user_id get matched to phpbb_users > user_id, or does the users get matched in "sequential order" (no matter the user ID, the sorted users get matched one from the gallery against the one in the forum)? (does the user "-1" from the forum "count" or is it skipped?)

If I change the cpg143_users > user_id number would that screw-up something in the gallery's other data fileds and result in mismatch of user/album or user/comment or something along those lines...?

any help appreciated...

[Nibbler]

'cpg143_users > user_id' is abandoned completely. Any pictures that were owned by user 123 in Coppermine are now owned by whoever happens to be user 123 in phpbb. The places to change numbers are the user_id type fields in the other coppermine tables, like owner_id in pictures and author_id in comments.

[mindwall]

thanx,
so I take that phpMyAdmin will not propagate the update the other table-fileds as necessary when user-ID has been changed manually in the (supposably key-field of the table in cpg143_users) ?

edit:
oh.. I see looks like the tables' fileds are not "connected"

so I'll need to change cpg143_comments>author_id to the user ID of the forum?
but the albums are keyed by cpg143_albums>pos? so to switch to whom the album belongs I have to change the POS? (and probably rename the directory in on the server?)

[Nibbler]

No, it won't. The tables are only linked conceptually, there is nothing to tell phpmyadmin that the fields are related.

[mindwall]

I just saw that they are not linked...
so what filed in the album table do I need to change to direct ti to specific user_ID from the forum?

[Nibbler]

User albums have a cat of user_id+10000

[mindwall]

thanx, and after I change the database userID I'll have to change the name of the directory of that user too...
ok, I'll give it a try

thanx again

[mindwall]

bottom line:

change cpg143_albums>pos IDs to (1000+[phpbb_users>user_id])
//that is change the POS values in the gallery-albums to 1000+phpbb_userID
(DO NOT rename the user folder names)

change cpg143_comments>author_id (values) to the wanted phpbb_userID

and you are done

call it... "solved"

[Nibbler]

Just to clarify, you shouldn't change the pos as this is the album's sort order and is unrelated to ownership. Also the number is 10000, not 1000.