conversion ubbt -> vb, what´s withe the UID´s

[flint]

as you´ve made a "vbulletin enhanced" version, why not switch the entire board.

only problem, during the import process from ubbt to vbulletin new uid´s are assigned. impex has a feature to assign imported users to specific uid´s, but it´s 10.000 users and a gigabyte of photos, no way I can assign them all manually.

any tipps / workarounds?
thx!

[flint]

update:

there is no way I´ll get the original uid´s into the vbulletin database, without messing up about everything (1.5+ million postings), just way too complex for me.

so I´ll have to try and update the photopost tables, in reference to the original ID which is saved as "importuserid" next to the new ID.
Biggest problem in the process - I SUCK at programming - so any advice is highly apprechiated!

I took a look at the photopost tables:

Table "usergroups" is small, I can update this manually.

The tables "comments" and "photos" seem to be easy to update, because not only the userid is saved but also the user. So I could go ahead and do something like "take username, compare with vb database, fetch the uid from there and write it in the photopost table". (yeah, structured query language!)

Then there´s still favorites, notify and laston - they only have the old userid.
This could be done like "take uid from photopost, compare with importid in vbulletin, take the new one and overwrite the old one in photopost"
Just don´t see yet in which order this would be executed, because there´s no auto incrementing ID or something else for orientation. No idea how to do this, since it can be done only once.

can I neglect laston? simply delete it?

what´s table "ipcache" for?
I noticed the "userid" field, but for over 2.000 entries it´s "0".

Did I miss anything?

thx in advance!