itch | 🎮 The best way to play your itch.io games | Game Engine library

I'm working with a table that uses a JSON column to store questions and answers as an array of objects where the key is the question and the value is the answer.

The questions are user generated so the keys can literally be anything.

For example:

I'm trying to figure out if it's possible using MySQL to query this data and get a result that looks like this:

I didn't think this would be too hard but quickly realized this is probably way out of my depth with MySQL!

The main struggle here is that I can't seem to figure out how to extract the keys when they're buried in an Array like this and I don't know what the names of the keys would be.

The closest I can get is a query that looks like this:

This one is just to scratch an itch, and probably not even a problem worth solving on it's own.

I'd like to write a recursive factorial function to print to the console in C#. The thing is, just out curiosity, I tried to get it to do this by only passing the function and argument. As in, I'd like to avoid having to type Console.WriteLine(Factorial(5));

It's harder that I'd thought to just type this and get a result:

I'm attempting to write a data-fetching "hook" (not entirely clear what the word for this is in Vue, but a state function that does not render a template). The Hook takes an asynchronous data resolver as a parameter. The hook itself is very simple, it simply adds loading state to a function that returns a promise.

I'm itching to upgrade our project to C++20. My CMakeLists.txt files generally say

So I am building a game for a game jam over at itch.io, and I'm using this really neat Fantasy Console called TIC-80, found at tic80.com. My issue is that while I understand what the error message is and what it means, I don't understand as to why it's giving me this error.

Error Message (In the TIC-80 console):

I am trying to run a linux game on my chromebook(the game can be found here https://bitbrain.itch.io/cave/download/eyJleHBpcmVzIjoxNjM3MjU1OTkwLCJpZCI6NzExNTc5fQ%3d%3d.hggqT%2fhX%2bV6ybeo2kdXBWZa4xCQ%3d) I have executed the following commands: sudo su /cave.x86_64

however, when I run the last command, I just get an error saying that no such file or directory exists. Please help me.

I have a weird problem and cant seem to fix it

i was creating my first game in unity and i was testing around a bit after creating a movement system and whenever i touch another object (it doesnt matter if it has a rigidbody or not) my player suddenly starts moving on its own.

i have a video showing what exactly happens: https://youtu.be/WGrJ0KNYSr4

i have tried a few different things already and i determined that it has to do something with the physics engine because it only happens when the player isnt kinematic, so i tried to increase the solver iterations for physics in the project settings but the bug was still happening so i looked for answers on the internet yet the only thing i found was to remove Time.deltaTime tho it still didnt work. I have found that it seems to happen less though when the player is moving fast.

i would really appreciate if somebody could help me with this since its my first real game and im creating it for the Seajam thats happening on itch.io.

here is the code for my playercontroller script:

let me preface this question by saying I have no idea if I'm asking the right question. I'm pretty new to c++ and I haven't gotten all of its nuances down yet, but I have coded in other OOP languages for nearly 7 years.

I originally asked: Is there a way to take a text file and automatically generate c++ code? If yes, how do I do that? What are some resources that explain the process?

but to clarify, what I really want is: Is there some way to take a text file, or other file type (like json) and use it to generate a compiled c++ class, or other compiled object, that can be interfaced with c++?

The final result doesn't need to be human readable, and it can be system specific. I want to be able to do this at compile time. It does not have to happen at run time. I will know at run time what classes I need. It's just that the classes I will be making (and there will be a lot of them) are all very similar, and just deviate in a few key places. So I want a way to tell the computer the important stuff (which may only take 5 or 6 lines of code), and have it generate the other 30 lines of boiler plate code.

I'm making a game engine, and I am trying to design a system that allows me to plug and play with systems, without having to write a lot of boiler plate code.

Someone commented that I should make the example simpler. So here goes.

I'm trying to build a system that takes a text file input and builds me a compiled c++ binary. It doesn't have to be a text file, and it doesn't have to be specifically c++, as long as it can interface with c++ (relatively easily). This is to decrease the amount of boiler plate code, and number of short kinda useless c++ files that are all almost identical.

For example having a file called example.txt which looks like this.

GOAL
So I have a space-invaders type game I have made to practise unity and I want to upload it to Itch.io as I have done in the past. This is a clip of the game.
I switched platforms to WebGL in Build Settings etc, and everything worked fine in Unity.

PROBLEM
However when I built it and uploaded the zip file to Itch.io, the aliens are now a lot faster than usual.
(Be aware there may be other things that have changed, I just haven't been able to get to them since it is extremely hard).

CODE

Alien movement: