forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: patexocet on October 17, 2005, 12:52:53 pm

Title: How to change Owner name
Post by: patexocet on October 17, 2005, 12:52:53 pm

Hello,

I want to change the owner_name for many pictures in one operation. How can I do that.

Thank you for your help.

Pat

Title: Re: How to change Owner name
Post by: Stramm on October 17, 2005, 01:10:09 pm

assume the user name is Stramm and you want to change it to Kelly
1. in the admin menu click users, search for Stramm and change his name to Kelly.. unfortunately this will only change his name in profile and for the new pics but not for the old ones. I think that needs improvement in new CPG versions

2. To avoid this use phpmyadmin and execute a command like that one

Code: [Select]

UPDATE `cpg_pictures` set  owner_name='Kelly' WHERE  owner_name='Stramm';
change the cpg to your table prefix. Backup your database before you mess with it

Title: Re: How to change Owner name
Post by: patexocet on October 17, 2005, 01:44:16 pm

Thank you Stramm, it works fine...

Pat