I'm making a game for the repl.it music jam, called Name That Tune. The code is here. I've made the game itself (although I need to add lots more tunes!), but I'm now looking for a way to have a leaderboard. I've made the leaderboard HTML itself (
index.html lines 67-121) and the JS functions to put the data into the table (
script.js lines 190-254), but I need a way to save the data itself.
I've tried various different approaches:
Jsonstore is a brilliant online data storage website, but as far as I can tell you need node.js to be able to interact with it. See TheDrone7's post about his node.js jsonstore extension. I don't know how to/if you can use node.js with an HTML/CSS/JS repl. I even tried using python, but calling the functions from JS proved an absolute pain. As I expected.
Are there ways to save data which can be changed in JS without using external things like jsonstore? I looked into json files and other stuff, but as you can probably tell, I'm a bit out of my depth. I'm a beginner with JS and thought the music jam would be a fun way to learn some more!
Thanks in advance for any help!
The music jam has now closed. I haven't yet found a solution to the leaderboard problem, but I've entered my game anyway without one. My entry is here. I dunno if you can upvote now the jam is closed (subtle hint :P), but maybe you want to check it out. Thanks to @vedprad1, @EthanJustice and @TheDrone7 for all their help so far; I'm not giving up yet don't worry - although the competition's over, I'll still do updates once the results are announced.
Well, you can't store data permanently on an HTML, CSS, JS repl, because that by itself is client side: Whatever is saved on that page only appears on that page, not on other pages, or on other computers.
It is easier to do this in Node.js, whicch is server side. It is actually very easy, and you don't even have to use jsonstore.io if you don't want to!
If this answers your question, please check the checkmark on the left side of this message. Thanks and Good Luck!
@vedprad1 Thanks; I've read through and understood the 'Node.js Tutorial' bit, and I've now moved onto the 'Node.js MySQL' section, which I think is what I need for a database? I've tried running this code and, whatever user and password I give, I get an
ECONNREFUSED error! Any ideas? Thanks so much for all the help so far!
@TheDrone7 Thanks that's much simpler. I've set up the database and created a few functions to add/get rows from it, but I'm now having trouble calling those functions from
public/script.js. The code is here.
At the moment I'm getting this error...
...when I load the page (that's the Safari console btw). Any ideas? Thanks
EDIT: now given up on this :( moved onto @TheDrone7 's separate reply, see below...