View Full Version : Changing Usernames For Photos
June 27th, 2005, 11:53 PM
Is there an easy way of changing wrong usernames to photos that do not match up to correct usernames? I see the feature in EDIT photo, but this is one at a time, I am hoping there is a bulk action somewhere or maybe an edit in code, possibly even a hack or script.
I just did an import from Coppermine and my photos have made it, but the usernames are all wrong.
June 28th, 2005, 05:29 AM
Well that depends on how you had coppermine setup.
Coppermine importer is written for a coppermine to photopost import. You integrated photopost with vb3. There are alot of variables to consider if you like say for instance had coppermine as an internal install and then install to a photopost with vb3. So in the end it all depends on how far you where from the way the importer was written for.
Here is a script you can run to reassign usernames based off your vb3 userid's
June 28th, 2005, 09:10 AM
As always...thanks for the insight. Where would I put this script? and how does it work, I dont see nay documentation attached?
June 28th, 2005, 09:17 AM
save it as rename.php place it whereever and open it up fill in the proper information to connect to vb and photopost. save and run this
June 28th, 2005, 09:58 AM
Placed the renamed file in my photopost directory, changed the fields and then saved and tried to run rename.php in my browser and couldnt be found. I plaed with the prefixes a bit to no avail. I know my photopost is pp_, but unsure of my vbulletin, my phpadmin shows no prefix for vbulletin.
June 28th, 2005, 10:04 AM
Okay then you would have no prefix
what could not be found?
June 28th, 2005, 05:35 PM
The rename.php script would not run in my broser, page could not be found.
June 28th, 2005, 05:40 PM
ah I know what the issue is LOL rename it to import.php
June 28th, 2005, 07:50 PM
So I have the import screen and I see the USERNAMES and THE USER ID's do I simply change them? Lets say I am (1) and number (8) has my photos, do I cahnge myself to (8) and him to (1) That does not seem right. Chuck, can you elaborate on this script?
June 28th, 2005, 07:59 PM
The script will automatically give you a link to click and it updates the comments and photos with the vb username for the userid.
It should already have ran now ;)
June 28th, 2005, 08:19 PM
The posters of the photos are all wrong. Like I said above USER ID (8) has my photos, but I am USER ID (1)
June 28th, 2005, 08:27 PM
well given the way coppermine was imported into photopost but your integrating with vb maybe your userid's dont match but the issue here is there is not really a script for this.
The script I posted here is one I use for people who import phpbb to vb3 and then you need to rewrite userid's
However if your coppermine id and names are different than the forum the only suggestion I would have at this point is to use phpmyadmin and do a sql query to update the userid say =1 where its 8 in photos and comments etc
UPDATE photos SET userid='1' WHERE userid='8'
Its not an easy task for sure
June 28th, 2005, 10:11 PM
Thanks, I was looking at PHPMYADMIN and did some sniffing around and found where to change this info but I didnt want to mess with it untill a confirm from you. As always I appreciate your support and help. I will let you know how I made out.
June 28th, 2005, 10:13 PM
Okay well you will have to let me know in 9 days as I am flying to the carribean in the morning ;)
June 28th, 2005, 10:47 PM
... I am flying to the carribean in the morning ;)
I hope this is for a well deserved vacation!
The time you've spent away from the support desk in your tenure here can probably be measured in hours vs days.
Man! you've got some stamina to put up with us!
Go have some fun, relax, chill out, we'll be counting the days till you return!
June 28th, 2005, 10:54 PM
Enjoy your trip Chuck!
June 29th, 2005, 05:02 AM
Thanks I am planning on relaxing ;)
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.