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!