Best Forum Helpers

@tyller_ can you request to join https://glitch.com/edit/#!/yn3d

@tyller_ i have an sqlite database i dont need google sheets dw

I have the script and SOMETHING in the for loop is crashing, I tested wtih just dragging out the for loop and it doesnt crash, the error it logs is scratch-gui.4249d868093d19d7e7b7.js:1750 Uncaught TypeError: o.toLowerCase is not a function at Scratch3OperatorsBlocks.value (scratch-gui.4249d868093d19d7e7b7.js:1750:2355893) at scratch-gui.4249d868093d19d7e7b7.js:1728:78991 at e.value (scratch-gui.4249d868093d19d7e7b7.js:1750:673208) at e.value (scratch-gui.4249d868093d19d7e7b7.js:1750:668735) at m.value (scratch-gui.4249d868093d19d7e7b7.js:1430:182027) at scratch-gui.4249d868093d19d7e7b7.js:1430:191377 at o (scratch-gui.4249d868093d19d7e7b7.js:1430:190732)

Edit: I realized I did have lowercase blocks in there, which I have removed and it did work (still dont know hwo they caused it, I removed htem becuase I realized I was broadcsating the world name which when I set the world name the first time I have it lowercased) but now the isuse is it seems to just not fetch from the sheets doc? error is now scratch-playground.050a4bba48f4da8d0101.js:55 GET https://web-agw.creaticode.com/api/block/v1/speech/google/sheet?spreadsheetId=1nzHTgYnCk9AkKvOJFAnnWzQgcFl2-zg4aMq2G6cdIk0&sheet=Messages&range=A1:Z100 500 (Internal Server Error)|

Edit 2: Okay I have acutally checked the list and that error seems not to mean anything, but I have now found it fills in blank columns and rows, so I can’t just be lazy and say from column A to Z and down a bunch of rows (instead I gotta do column A to whatever and a bunch of rows, it used to just limit filling the table to wherevever there was data and not fill past that I’m pretty sure)

@jeffreyrb03-gmail sure, though I can mainly help with debugging as I know general node js, I mainly know how to make discord bots but have dabbled in the sheets api, you need to make a google project (I don’t remember the url) and to get a service worker to interact, though I’d assume if they have a sheets thing it would be in the extensions add on section

@ejrowberry09-12248f6d

Maybe you can try to use “OR” to combine multiple color sensing blocks?

@ejrowberry09-12248f6d I don’t know what you mean exactly but here are blocks for sensing colors in general:

1st one is from automation, second is in events, and the bottom one is in sensing.

Now, to actually answer your question in a helpful way, first, you can use this online tool if you need it for like a one time thing:
https://meyerweb.com/eric/tools/color-blend/#FF0000:990033:10:hex

And for blocks, well blocks for that doesn’t exist.

@tyller_ That makes sense. If you know NodeJS and socket.io / websockets, would you want to help me making a DM/saved chatting system for YN3D? I have/use the perspective API (https://perspectiveapi.com) to filter out toxicity and harmful content, which I applied for to use in my google cloud project and I also saw there I can apply for other API access like gmail and google sheets. That can for the most part do content moderation pretty well and it’s free. That way forum users would have a secure and safe place to chat, and YN3D would get more users as a result

@ejrowberry09-12248f6d I’m not CreatiCode but I can answer your question. A slider is fine and possible, and no, there isn’t a block to check if someone is over 18 but that wouldn’t really be needed because if you plan on making an 18+ project, then you shouldn’t publish it publicly because this is a kids site. For your project to get views, you’ll have to advertise it somewhere else like say a web game development forum (not this one) to try to get people to play your project. It would be nice if they make project settings like “restrict to 13+ users, restrict to 18+ users” but they dont have that so that’d need to be a suggestion

@jeffreyrb03-gmail I’d assume the rate limit would be per client, and when creaticode gets popular there would likely be some people using a forever loop read from a google sheet in regular projects, and to brute force you’d have to do that (since the delay on sending and stuff would most likely be on the server side) even if somebody dove into the scripts to reverse engineer it. PLus my reason for making it in creaticode is because its meant to be for everyone here to have a chatroom instead of having to use forums, and I don’t want to just make a standard chatroom app (plus then I would have to do stuff like make sign in logic or use google oauth, and it would be hosted behind my ngrok url). I very much plan on eventually sharing the project so other people can (attempt) to learn from it or use it, though I want to make some improvements before making a version where I remove any references to the sheets url

@tyller_ brute forcing it would then make it unavailable for everyone then right? And abuse logs would be good but my opinion is that you probably shouldn’t use CreatiCode for this, especially since you cant do things like ban IPs and people can make alt accounts easily so yeah… Brb, Im gonna be gone for like say a half hour