I'll see you in the Duat

Fixing such an old forum is not easy. Documentation is rather sparse because the framework it runs on is old. There is however a more modern version, but updating is difficult. Here was the issue for the forum - upgrading failed. 

A website (usually) consists of two different parts: 1 - The files. They contain the code, scripts, designs, images, attachment, profile pictures etc. 2 - The database. The database connects all the different parts and tells the website where to find something. Everything gets stored in tables, assigned IDs and given values. Everything written, each post and topic is also stored in the database. So without the database the whole page would be useless.

It was clear from the beginning that the database was the culprit for the failed upgrades. I got an earlier backup from HL and started working.

I set up a local environment with two versions of XAMPP. One running on php 7.4 (the last version having compatibility for the forum framework version and the upgrade script to the recent version) and the other on a modern 8.3, which was the same as the version the server @fireflowersims set up for GOS.

I ran the upgrade script (which consists of 4 separate parts) on the old backup and ran into errors right away. The script would just outright crash on me, most often without a log or message. The (local) server would just stop responding. My original plan had been to upgrade to version 2.0 first, then 2.1, since it was the recommended order. However the database backup had already been partly upgraded to 2.1. That was the reason my upgrade script failed. Reversing those changes could have been a possibility but extremely time intensive.

(This is the frontpage of the upgrader. I stared at it so much. Like you can see it has a ton of steps)

Instead I asked for the current database and HL provided it to me. This one was already further along on the upgrade and I could see the error HL had run into before handing over. I had to look at the upgrade scripts and source php files to diagnose what the framework was expecting - and failing - to find in the database.

That’s where I found the main culprit for *most* of the errors: Time tables. The framework saves every action that a user does in a log, a long table with the action, an id and a date. This was where everything had gotten wrong. The upgrader expected to see one column for the date, named *day*, while the current table had a different column for day, month and year. I tried fixing the table at first but that didn’t seem to work, so I completely deleted the table and created a new empty one myself. (By now I think the issue stems from forgetting to uninstall certain packages before upgrading, more on that later)

That was possible because the log actually doesn’t hold relevant information for the forum to work. It just records each step, probably for moderation purposes. Once I had done that step the upgrade script was finally able to proceed.

There were a few more errors where I had to look at what the script was doing, find the corresponding code in the sources and edit the database myself. Thankfully the code is relatively well commented and named, so I was able to find what I needed.

Finally I got the upgrade script to run to the end and I was actually able to open the forums (local) page. I hadn’t been able to for now so it was a first. But a lot of stuff was still missing, like all the topics. I could see that the posts were back, but not sorted correctly.

The fix was simple but annoying. The forum framework comes with a repair_setting.php file which I had run several times to fix all the paths, but apparently it didn’t fix *all* of them. So back to the database I went, ran some queries and fixed them myself.

Then the forum finally worked again!

(This is what the forum looked like when I first opened it. It ONLY had recent posts)

(The working local forum, no files yet with the default theme. Seems wrong to look at GOS without the dark theme, right?)

There were still a few things I needed to fix but the database seemed to work fine now. I had never done so many queries in my life. I know SQL, and had to fix databases before but not this intensely. So I guessed I learned something new haha.

Next was the exciting step to upload my clean install to the server. @fireflowersims and I had some directory issues, but I was able to fix them manually once again.

Then I had to take a look at the files which mostly consist of avatars and attachments. They didn’t work at all once moved to the clean install. Once again I took a look at the code and realized that the upgrade script would have changed those files as well, but because I ran it on a clean install it didn’t actually do this step.

I didn’t want to run the upgrade script again, worried that it would mess up a now working database. Instead I wrote a script myself that sorted through all the attachments, looked for the IDs of the avatars from the database so it could move and rename them.

Last were the attachments. This was an easier fix. They just had to be given the ending .dat. @fireflowersims ran a command through the console and then the attachments worked too!

We were getting closer!

Next was the theme. The old theme didn’t work on the modern framework anymore so @fireflowersims looked for a new one which I customized with CSS, trying to get it closer to the way the forum looked before. I think it turned out quite alright, hope you guys think so too!

(Trying to find out what CSS class addresses what? Make everything red and green!)

(All the spider webs)

Next was packages, or mods, to the framework. Fire and I encountered some hiccups here too, since there were some leftovers in the database. The packages hadn’t been properly deinstalled before running the upgrade script, which was another source of the errors. I tried fixing them manually but one of the packages would continue to just break the site no matter what I tried, so we settled for an alternative.

Some more work was put into SSL and making the forum secure. Once again some settings seemed to just break the page and each time I had to go back in the database and manually fix what had gone wrong. It was tedious but by now I knew my way around quite well.

@fireflowersims handled a lot of the server administrative work and DNS settings. I know very little about that part so having @fireflowersims there was great and they made sure the page is reachable at the correct address.

Hello, friend! My name's Pooklet. I've been playing since 2004 and creating since 2007. I'm by no means an expert in most forms of content creation itself, but I've been around since the heyday of The Sims 2, I've watched how community opinions have shifted (or not) since practically the beginning, and I'm hoping to give you a basic outline of the community culture that you can expect to encounter as a newcomer.

A very brief history of Sims 2 content monetization:

People have been trying to monetize content since there has been content to monetize, all the way back in the days of The Sims 1. We tend to call them "pay creators" and their websites "paysites." Some big names in this arena include The Sims Resource (their free-with-ads model is a relatively recent development, which is why you will find people to this day calling them T$R), PeggySims, Newsea, and many others that you can find on this handy website:

Paysites Must Be Destroyed

Now, if you have a glance at that website, you might be saying to yourself:

"But, that's illegal! I own the copyright to my custom content!"

Alas, no! Due to the wording of the End User License Agreement for The Sims 2, no custom content creator owns their creations for this game (or The Sims 1, or 3, or 4, for that matter, but we're talking about 2 right now). It all belongs to EA at the end of the day, and by installing and playing the game, you have agreed to these terms. Which means you have no individual, protected copyright, and it is perfectly legal for someone to download your paywalled content and then reupload it for free for others to enjoy. And they will!

Furthermore,

You are not making anything alone.

Everything from modding resources, to tutorials, to the mods required to fix disastrous glitches in the game code and make it playable at all, to the third party programs used to make any and all custom content, such as SimPE—all of these have been provided to you for free by other creators, many of whom have a usage policy that asks that people not use their freely-provided tools to make a profit. Although no one can be forced to follow a creator's policy, it is generally considered good manners to not try to make a profit off of someone else's free work. And if you are using these tools to make paywalled content, that's exactly what you're doing.

Pay creators have been ignoring these policies since the beginning of time, and so free creators likewise ignore their policies against sharing their paywalled content. Pay creators have also tried lots of different ways to keep their content exclusive, everything from trying to track leaks with slightly altered files to actively filling their content with malicious code. It has never worked.

Free creators have always found a way around these barriers. In fact, it's taken as something of a challenge to undermine monetization efforts. As you can see from Paysites Must Be Destroyed, there are entire teams of players devoted to reuploading paywalled content for free.

A culture of sharing.

The Sims 2 is something of a time capsule. At 20 years old, it predates a lot of the hyper-capitalist hustle culture that has infested every creative hobby. It is from a time when monetization was an outlier rather than the norm, and a much maligned outlier at that. This attitude has persisted for 20 years. Believe me when I say, you won't be the combo breaker. Especially now, given that The Sims 2 is not the most contemporary in the series and the community has shrunk considerably, down to the people who have either been here for a very long time, or newcomers that understand the community culture.

Also, it's just kind of not a great idea in general to try to make money off of a 20-year-old game with a pretty small community?

Like, I get that The Sims 4 is really saturated with pay creators and it's hard to get a foot in the door. I get that you might look at The Sims 2 and think that the small pond will give you room to be a big fish. It won't. You might get a handful of people willing to pay for your content, but at least one of those people will be resharing it for free.

Paywalls vs. optional donations.

Okay, so hopefully you now understand why people don't like it when you put content behind a paywall. But what about those Ko-fi and Paypal donation links you sometimes see at the bottom of people's downloads? Why is that okay, but a locked Patreon tier isn't? Well, because they're voluntary. No one is obligated to pay for that content to be able to download and use it. It's just a way for someone who does have a little extra cash to basically "tip" a creator whose content they like. You have no way of knowing whether the person who posts those links is actually receiving any donations. And that's kind of the point. Whether or not they receive any donations, they are still sharing their content, because they enjoy the hobby of making and sharing content.

"I can't make a living off of that!"

No, you can't. Because that's not what we do here. That is not part of our community culture for all the above reasons. If you want to make a reliable income off of your hobby, you're going to need to get a different hobby. Try Second Life! That is a community that actively encourages monetization. The Sims 4 allows for "early access" monetization. There's options out there for you, if what you want is to make a profit off of your creations for a game.

"Fine, what about monetized link forwarding services?"

Link forwarding services historically have malicious trackers or viruses embedded. People will also strip those and provide direct links to each other. Or they just won't download your content.

"What if I want to make YouTube videos of someone else's written tutorials and I enable ad revenue on them?"

Personally, I still think that's a dick move. I love video tutorials, I'm a very visual learner myself, and although you might feel entitled to compensation for reciting the steps of someone else's tutorial into a microphone and then editing and uploading the video, you're still monetizing someone else's freely-provided content. I would consider this an 'ask permission' scenario, one in which you tell the person, explicitly, that you will be making ad revenue off their work. If they're fine with that, then you're good! (For the record, I'm not fine with that.)

edit: more of of my thoughts on monetized youtube videos over here.

"What if—"

Look, no one can stop you from trying to monetize your content, or worse, someone else's content. But you will have the exact same arc as every pay creator who came before you: your efforts will be undermined at every turn, your reception in the greater community will be chilly at best, and it will become a battle between you and the folks resharing free reuploads of your content until any fun you initially had making content is gone.

"The steady erosion of every known social safety net beneath the crippling weight of end-stage, line-goes-up capitalism and the yawning abyss of poverty over which I am dangling has imbued me with such anxiety that I cannot engage with a hobby that precludes monetization. I am exhausted. I know no other way."

I get it, friend! I have lived in poverty all my life. I do not begrudge the impulse to find a way to make passive income off of your every waking moment. Increasingly, it seems like that is the only way to survive! Unfortunately, you will not be able to do that with this specific community. We know that we have something special here, having resisted monetization's encroach for so long, which makes us fight all the more viciously to maintain it. You are entitled to try to find ways to supplement your income, just not here. Personally, I consider that a feature, not a bug.

Bonus Round: Remember, That's Not Just Yours!

I said it earlier, but I want to reiterate: you are not making any TS2 CC alone. You are making it with tools, resources, knowledge and code that people have provided on the condition that they not be used for pay content.

To use myself as an example, "my" hair textures are a blend of resources provided by other creators. Namely, Nouk's original hair texture was edited by Vintage D, which I then further edited over the years, using parts by the creators Ephemera and Helga. It would be extremely shit of me to say "well, I think that the time that I put into my edit is worth money, so I'm charging for it" when the edits that I made would not exist without the work of those people. And it continues on down the line with edits that other people have made of my texture blends and color actions, and the content they make with them.

(If you see someone charging for these, btw, lemme know. I'd love to have a talk with them.)

In closing,

The knowledge base, the resources, the coding required to make any and all working content for The Sims 2 has been compiled for 20 years. Please understand, I'm not trying to denigrate anyone's creativity when I say: you cannot bring anything wholly "new" to TS2 CC-making, something that uses no one else's resources or programs, something you can point to and say "no one helped me with that. I did it all on my own. It is my property." Nor should you aspire to! The fun of The Sims 2 community is to share and share alike, to credit each other for our contributions, to hype each other up and iterate on shared works and resources. We've been doing it for 20 years, and hopefully we'll be doing it for many more! Wanting to be a #simfluencer is utterly antithetical to the community culture. No one is influencing anyone else. You need to leave that shit at the door if you want to be invited in.

TL;DR:

Don't show up to the commie circle-jerk trying to charge for handjobs. We're already giving them to each other for free, and nothing about your wrist technique is special enough to justify the cost.

Stage 1, breaking out of the tiny window

Stage 2, figuring out how to mod UI again

Stage 3, going big! But not quite there yet

Stage 4, "should I move it 1 more pixel to the left"

🤓

Secret bonus version for behind the scenes viewers who think that smaller is better, available exclusively and only in starship colors (you can only have one version)

Download 4x4