Export?

[sunster13]

Hi,

A few months ago I had a gallery on my site, but the site died shortly after.  I decided to revive the site, but the gallery was giving me an error.  I installed the latest version of cpg, and tried importing the db that already had a lot of photos (I edited the .sql file, and replaced all the cpg146 with cpg1410).  That worked, and I see all the pictures, but the usernames don't exist, because it is not bridged to mybb anymore.  I tried bridging to my new IPB, but the user id's don't correspond, and some of the previous users are no longer on my site.

Is there anyway I could export all the pictures, and then import them on a fresh install, with all the usernames replaced by mine?  That way, there wouldn't be any issues with usernames or bridging, since only the photos were imported.


Thanks

[Stramm]

You'd just have to edit your db a lil bit more... in the pictures table set the owner_id to your uid (usually 1) and the owner_name to your user name

[sunster13]

Thanks, where do I imput that though?

I'm in phpmyadmin, and see those fields, but I'm not sure which fields to put that in.

[Stramm]

click 'SQL' and enter your statement... always backup your db before messing around with it

would look something like this

UPDATE cpg1410_pictures SET owner_id= '1'
or if you want to restrict it to a certain album
UPDATE cpg1410_pictures SET owner_id= '1' WHERE aid='15'

do similar for the owner_name

[sunster13]

click 'SQL' and enter your statement... always backup your db before messing around with it

would look something like this

UPDATE cpg1410_pictures SET owner_id= '1'
or if you want to restrict it to a certain album
UPDATE cpg1410_pictures SET owner_id= '1' WHERE aid='15'

do similar for the owner_name

That worked.  Thanks alot for you help.