View Full Version : conversion ubbt -> vb, whatīs withe the UIDīs
July 1st, 2005, 11:15 AM
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?
July 1st, 2005, 04:43 PM
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!
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.