Quote from: K-Dog on Oct 18, 2023, 01:38 PMTQuote from: RE on Oct 10, 2023, 10:24 PMIt would be nice if we could get hold of the original Diner DB. I'm pretty sure my Host (A Small Orange) has a copy. Probably just have to pay a small fee to download it. Do you think you could hook it up here?
RE
If we have the database the posts can be extracted. The user base is different so artificial avatars would likely substitute. I will be dealing with users who have missing avatars soon. We are going to use the first initial in a colored circle trick just like You Tube does as a default avatar for users who do not have one.
I would extract topics and create a legacy board for them here. I would put all the posts under the legacy board.
The Diner has never used more than one board. The software allows for multiple boards so the legacy board can be dropped in easily. Getting post metadata to show however will be 'the issue'. Original authors are gone and are not part of our user base here. l'd write a custom script to display legacy posts and provide default metadata. I'd modify our theme to incorporate the script so we don't break the SMF software.
The original Diner SMF from A small orange has multiple boards with different permissions and different levels of users that I used to control the posting of a few of the Trolls that plagued me over the years. Actually, I'm surprised they have not yet discovered us here, unless they have and you eliminated them before I noticed any posting from them.
Otherwise, I think that database is more or less identical to this one, and all the fields could be mapped on in to a 1:1 correspondence. I am pretty sure ASO retains the last copy of the DB before I shut down the Diner about 3 years ago now I think.
The Wordpress DB which has all the articles we wrote is separate and different structure, so if you were to add it here you would need to drop a Wordpress publishing subweb here on Chasing the Squirrel to add that here also.
RE