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?

Discuss Scratch