Copying Profile Data To Another Table

[paul41598]

I need help with a query. At least I hope a query can do what I want.

When I imported from ubb.classic, one of the fields called (profile url) got imported over into VB custom field called (Homepage). However that data doesnt belong there. It actually belongs in the users profilepic field.

So basically Im wondering if theres a query I can run, that will copy field32 to customprofilepic table.


UPDATE userfield SET customprofilepic = 'something here' where field26 = 'something here';

Im sure thats way off, but...a ruff idea?

Thanks!

[Jerry]

The customprofilepic table holds the actual data of the image not a link.

From what I remember the profile url in ubb is usual used for users the homepage ?

If you want you want I can explain how to change the impex code to import any pic on those url's using import_custom_profile_pic().

[paul41598]

Well I already imported all the data, and I really dont wanna have to do it again, unless theres a way around that.

The profile URL in ubb, is actually used for the users Profile Pic. You set the link, and it calls the pic for display.


http://chugger.homeip.net/profile1.gif

http://chugger.homeip.net/profile2.gif

Right now all users data is in the profilefield table, when I think its supposed to be in their custompic table, or whatever its called

[paul41598]

and from what I can tell in the CP, you can put in a URL for example. How is that stored?

Thanks alot Jerry

[Jerry]

Is it an option to ask the users to upload their profile pic again ?

That way vBulletin can check the sizes etc.

[paul41598]

Well ya its an option, thats what that screenshot shows in my 2nd reply. The attachment.

Thats what Im wondering too, if I migrate users URL's they were using, will it still resize the pics. Hmmm

[Jerry]

Well ya its an option, thats what that screenshot shows in my 2nd reply. The attachment.

Thats what Im wondering too, if I migrate users URL's they were using, will it still resize the pics. Hmmm

No it won't it will just import what is ever there, hence if you ask the users to upload a new image, they will be restricted to what you allow them via the admincp.