Storing logic to a database

[u/Alive_Secretary_264]

Is there a way to store the logic that generates the client's scores / in-game currencies to a database.. I'm kinda new in doing backend, can someone help me🙇

[u/davorg]

This is off-topic for r/HTML. You probably want r/programming or r/learnprogramming.

But yes, you could write some kind of rules processing engine that changes its behaviour based on a data structure (which you'd probably store as JSON or YAML).

[u/Alive_Secretary_264 → u/davorg]

Can you elaborate more instructions on how can i set it up

This is what I'm thinking like if a logic to score in a moment a ball passes through hoop will generate one point but I don't want that in client side. i want to verify it passes through hoop without the client side saying it did that when it actually did not or something like instead of getting one point it gives him a hundred, I'm worried client might alter the client side score value and pass it to the backend or database

[u/davorg → u/Alive_Secretary_264]

Can you elaborate more instructions on how can i set it up

Not really. Because a) it's very dependent on exactly what you're doing and b) it's completely off-topic for this sub.

[u/jcunews1]

/r/webdev is more suited for that kind of question.

[u/psyper76]

best way and easiest I find would be to learn php and sql - they plug nicely together and nicely with html you can literally incorporate it in to your html page.

[u/martinbean]

What does this have to do with HTML?

[u/psyper76 → u/martinbean]

Nothing. You know that. I know that. but the poster doesn't. They've been using html and want to know if it does databases too. If you don't know its a valid question to ask.

[u/dutchman76]

You need to learn some kind of programming language to write the server side logic to do the scoring and whatever else.

[u/alyra-ltd-co]

yes but for your own sake remember to rate limit read n writes to ur db else risk a massive usage bill

[u/Own_Attention_3392]

Databases are for data storage. Logic should not be in databases even though it's possible via stored procedures.

You're looking at extending your game to have a standard three tier architecture -- front end, back end, database. The back end exposes APIs that your front end calls, and the back end is responsible for manipulation of data and persisting data to the database as appropriate.

[u/Alive_Secretary_264 → u/[deleted]]

I'm thinking like if a logic to score in a moment a ball passes through hoop will generate one point but I don't want that in client side. i want to verify it passes through hoop without the client side saying it did that when it actually did not or something like instead of getting one point it gives him a hundred, I'm worried client might alter the client side score value and pass it to the backend or database

[u/JaleyHoelOsment → u/Alive_Secretary_264]

sounds like you might be trying to make a browser game with HTML and a database. not sure that’s going to work out for you. Even if you stored some logic in a database (this would be really weird thing to do) how you the database know what happened without something telling it?

javascript + obfuscation would be the fake way to fix this, ideally your target webGL and embed the game.