CSL REGISTER Gone?

[x Spades x]

Just as an update for anyone concerned:

Not happening immediately, but it sounds like CSL Register is going to merge over here. Glad it's not just disappearing!

YAAAAAAAS!!!

[EthanolTurbo]

Just as an update for anyone concerned:

Not happening immediately, but it sounds like CSL Register is going to merge over here. Glad it's not just disappearing!

Wow. Thank you NAM3Forum team!

[0-60motorsports]

Just as an update for anyone concerned:

Not happening immediately, but it sounds like CSL Register is going to merge over here. Glad it's not just disappearing!

Thank Obioban liam821 for doing that.

[Flow]

Nice. Thanks guys for working on keeping the E46 memory alive

[sd561]

Thank you Obioban liam821 - for continuing to preserve the legacy of our marque online. sending gratitude your way!!

[liam821]

I might have the database, boys! 👀

[Obioban]

I might have the database, boys! 👀

..

[D-O]

Thanks very much for doing this.

If there is going to be a cost associated with this please say so. I, and I am sure others, would certainly chip in to make sure this community continues to flourish.

[0-60motorsports]

Thanks very much for doing this.

If there is going to be a cost associated with this please say so. I, and I am sure others, would certainly chip in to make sure this community continues to flourish.

Yeah I would definitely contribute

[0-60motorsports]

I might have the database, boys! 👀

YES! Nice work my friend.

[Obioban]

The former owner didn’t charge us anything and it’s going onto our existing server.

[ac427]

It's good that the information is not lost but the CSL Register has had very low activity for a couple of years now.

[Mike RT4]

It's not what you know, but who you know . Thanks for sorting this, very much appreciated.

As an aside, Neil (the owner) was just getting fed up with it being spammed and attacked by hackers, so just took it offline as a temporary solution until he had time to sort things and update it. Ian reached out the day after I had already contacted Neil to see what the score was and offered to host it so that it didn't go the same way as the old M3 forum. Neil was happy, as he didn't have the time to devote to it (and being full of regret (like everyone is) for having sold his CSL ), just didn't have the motivation to sort it. So gave Liam full access to "make it so".

[liam821]

It 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.

[Flow]

Sounds complicated. Thank you for the hard work and good luck with the massive sql queries.