Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Moving albums for a user who left the forum but haw re-joined  (Read 2270 times)

0 Members and 1 Guest are viewing this topic.

klewless

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107

Hi everyone,

I'm full of questions today  :-\ as I am trying to take care of a few small problems remaining with our gallery.

I have a member who left the group and then rejoined (actually, a couple of them). Their pictures are still in albums, in albums/userpics as well as on the database, both utilizing the members older userID number.

I can, of course just reassign the album to the new account, but the pictures would still be on file under her old userID. I could reassign ownership of  the pictures. but, in order for her to retain control over her pictures, do I also need to re-upload the old pictures, from the backup, to her new userid folder as well?

Thanks in advance!
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Moving albums for a user who left the forum but haw re-joined
« Reply #1 on: July 18, 2016, 02:17:01 pm »

The value stored in the "category" row in the "albums" table assigns each user album to the user name in the user galleries category. So that's the first value you need update (match the new user's ID + 10000). To update the owner of the album(s) and picture(s), you also need to update the "owner" row in the "albums" table and the "owner_id" row in the "pictures" table.
Logged

klewless

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 107
Re: Moving albums for a user who left the forum but haw re-joined
« Reply #2 on: July 19, 2016, 01:46:40 pm »

Hi again, Andre:

Let me try again.... 

I've figured out that much,  :-[  but will use an illustration to ask my question:

Lets say the photos are in a folder marked 10025. User 10025 quit a year ago but changed her mind and has reregistered as user 10895.

So we go into the db for albums and reassign the album to a new owner and it appears there. The photos inside, the actual .jpg 's, are still located in the folder marked 10025. Do I need to move them to the folder for user 10895? If I don't move them, wouldn't  user 10895 be denied permission to edit or remove them if she wishes?


 :-\


Thanks  again  :)

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Moving albums for a user who left the forum but haw re-joined
« Reply #3 on: July 19, 2016, 02:18:52 pm »

I think you don't need to move the files, but of course you can, if you want. In this case don't forget to also update the filepath in the pictures table.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 22 queries.