Originally posted by davidinnyc
View Post
Announcement
Collapse
No announcement yet.
CSL REGISTER Gone?
Collapse
X
-
Originally posted by liam821 View PostIt will take me a few days to sort out combining the two forums. There is no easy button or software to do it, unfortunately. So I'm going to have to reverse engineer everything and write something to do it. Inside the database, each "thread" has an ID, and posts in that thread also have their IDs, and all those IDs overlap each other. Not to mention usernames, user profiles, attachments, etc etc. There are 261 tables I need to carefully combine.
There are some weird gotchas, too. For instance, let's say CSLregister had another "liam821" user, so all those posts from that other user now become my posts, which now I'll have the ability to edit. It would also lock out the CSLregister liam821 user and all their posts since I'd own the username now. This probably isn't that big of a problem since most users have pretty unique usernames... actually, let's look.
*Liam does some MySQL stuff*
NAM3 forums has 9431 users
CSLRegister has 4637
Okay, there are 188 users with matching usernames in CSLregister and NAM3, however, there are only 104 with matching username AND matching email. So those other 84 users have the same name, but different email addresses. Still totally possible it's the same person, just used a different email address, or used a school or work email and has since moved on.
I think what I'm going to do is match up usernames, and if there happens to be that edge case, we can address it on a one-by-one basis. I'll make sure to post a notice in the CLSregister "Welcome" forum section.
Comment
Comment