ScratchPost - Scratch forums search, leaderboards, and statistics

redspacecat

acohen_bhusd wrote:
yes

I'm not sure exactly how to implement that / if it's even possible in the bar chart race program I'm using (flourish.studio)

MonkeyBean2

Username search seems to be case sensitive?

MineTurte

redspacecat wrote:
MineTurte wrote:
Is the API down right now? I can't seem to access any of the data. Like for example I'm trying to send a GET request to https://api.scratch.mit.edu/users/MineTurte/followers/ using curl by doing
curl -X 'GET" https://api.scratchpost.quuq.dev/users/MineTurte/count/
but it just says the page cannot be found and going onto the page directly in my browser says PAGE NOT FOUND in scratchpost?… Uhhh

Edit: Good ol' school firewall. I can access the API via my cell data but not with the internet. Nevermind!
You added a trailing slash to the url. Try removing it.

Oh my god it works. How did I make this mistake looooooool

redspacecat

MonkeyBean2 wrote:
Username search seems to be case sensitive?

Yeah, right now my db selects things by author sometimes, which causes case sensitivity issues.
I'm going to try to see if I can make it case insensitive.

I was thinking of a user id system, but I'm not sure how to implement that.

redspacecat

redspacecat wrote:
MonkeyBean2 wrote:
Username search seems to be case sensitive?
Yeah, right now my db selects things by author sometimes, which causes case sensitivity issues.
I'm going to try to see if I can make it case insensitive.

Okay, now everything to do with comparing usernames uses the citext type instead of the text type.
This means that usernames comparison is now case insensitive.

acohen_bhusd

redspacecat wrote:
acohen_bhusd wrote:
yes
I'm not sure exactly how to implement that / if it's even possible in the bar chart race program I'm using (flourish.studio)

by finding the highest post id in each date

cookedasparagus8

Why does the count show dustbinned posts?

medians

cookedasparagus8 wrote:
Why does the count show dustbinned posts?

They could have only been dustbinned after or sth

redspacecat

cookedasparagus8 wrote:
Why does the count show dustbinned posts?

It doesn't currently have a way to detect when posts are dustbinned. I'm adding a checker soon that goes back over recent posts, checks if they're dustbinned, and removes them if so.

acohen_bhusd

acohen_bhusd wrote:
redspacecat wrote:
acohen_bhusd wrote:
yes
I'm not sure exactly how to implement that / if it's even possible in the bar chart race program I'm using (flourish.studio)
by finding the highest post id in each date

i said that, bump

Last edited by acohen_bhusd (Yesterday 22:08:04)

redspacecat

acohen_bhusd wrote:
by finding the highest post id in each date

I'm not really sure how I would do that, or how I would get my chart program to display it.
Also, why is it useful to know the current post id? Isn't the current date enough?

redspacecat

redspacecat wrote:
cookedasparagus8 wrote:
Why does the count show dustbinned posts?
It doesn't currently have a way to detect when posts are dustbinned. I'm adding a checker soon that goes back over recent posts, checks if they're dustbinned, and removes them if so.

Okay, I've added a secondary thing that goes through posts, a few days behind, and removes them if they're dustbinned.
I'll clean up the previously dustbinned posts later.

Discuss Scratch