Discuss Scratch

CatsUnited
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

NOTICE
Check out the preview of postpercent, the version 2 of Scratch Forum Leaderboards (source code)

Have you ever wanted to know who has the most forum posts but don't want to use a website that we can't talk about since it shows deleted posts? Have you ever looked at scratchstats and thought Yeah where's the forum data?

Congratulations - I made a website where you can do that. Thanks to some new endpoints added to the ScratchDB API (thank you Lefty the big data man) The “Forum Categories” section allows you to view the Top 100 posters from either the entire forums or from one specific forum:

“What? You can do that?”
The users section allows you to see in more detail the number of posts, rank and post count history of a particular user:

You can customise your banner's color and status through jeffalo's ocular, linked on the top bar

The history section shows your post count progression per category


I also added some of the funny in there - if you find one of the funny you are advised to laugh.

Last edited by CatsUnited (May 15, 2021 15:07:02)


あなたの心を奪う!
I'm a vtuber!aapostpercentaaThe Forum Helpersaa17,000+ posts
bottom text
Jeffalo
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

i did the laugh multiple times

my website: jeffalo.net | ocular: scratch forum search | thank you everyone for all the support, it means a lot to me.




-Zyte-
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

shefwerld lol
That's really cool! Can I ask for a custom rank btw?


If anyone wonders why my pfp is Luo Tianyi, it's because I like Luo Tianyi. (My original logo is in the banner above)





April Fools 2021 wrote:

miku ftw
but zyte, your pfp is luo tianyi…
because using miku as a pfp is weird. and i didn't want to use tianyi or miku as an pfp, i was forced to


i think i like this pfp now…
and also FUNNEH JOOS
CatsUnited
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

-Zyte- wrote:

shefwerld lol
That's really cool! Can I ask for a custom rank btw?
Go ahead - you can also request a custom color for your user banner

あなたの心を奪う!
I'm a vtuber!aapostpercentaaThe Forum Helpersaa17,000+ posts
bottom text
Maximouse
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Very interesting! I didn't know I have over 1000 posts in suggestions

This is Maximouse's signature. Learn more about signatures

Pull request successfully merged and closed
You're all set — the mxmou:patch-1 branch can be safely deleted.
If you wish, you can also delete this fork of mxmou/signature in the settings.
Maximouse
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Also, how can I be 75th in Developing Scratch Extensions with 7 posts?

This is Maximouse's signature. Learn more about signatures

Pull request successfully merged and closed
You're all set — the mxmou:patch-1 branch can be safely deleted.
If you wish, you can also delete this fork of mxmou/signature in the settings.
fdreerf
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Hmm yes finally a website all about zipf's law

Maximouse wrote:

Also, how can I be 75th in Developing Scratch Extensions with 7 posts?
I'm 38th in the Norwegian forum with one post

Last edited by fdreerf (July 21, 2020 07:35:00)


Most projects or bust!
Jeffalo
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Maximouse wrote:

Also, how can I be 75th in Developing Scratch Extensions with 7 posts?
there are not many people who post there i guess

my website: jeffalo.net | ocular: scratch forum search | thank you everyone for all the support, it means a lot to me.




qrcool
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

I have ideas for my banner already…

Jeffalo
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

i find this very cool btw i should have mentioned that.

also perhaps a suggestion so you know how it makes random colours to make it easier to tell stuff? perhaps the code for that could be replaced with something from this? https://stackoverflow.com/questions/43193341/how-to-generate-random-pastel-or-brighter-color-in-javascript then the colours are nicer or something idk

Last edited by Jeffalo (July 21, 2020 08:05:35)


my website: jeffalo.net | ocular: scratch forum search | thank you everyone for all the support, it means a lot to me.




Maximouse
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Usernames should probably be case insensitive. Currently this works but this doesn't, although it does show my profile picture.

This is Maximouse's signature. Learn more about signatures

Pull request successfully merged and closed
You're all set — the mxmou:patch-1 branch can be safely deleted.
If you wish, you can also delete this fork of mxmou/signature in the settings.
Jeffalo
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Maximouse wrote:

Usernames should probably be case insensitive. Currently this works but this doesn't, although it does show my profile picture.
i guess this could be done by getting the correct capitilazation from the api (it says it there) or just getting lefty to make his api case insenstive

my website: jeffalo.net | ocular: scratch forum search | thank you everyone for all the support, it means a lot to me.




CatsUnited
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Jeffalo wrote:

i find this very cool btw i should have mentioned that.

also perhaps a suggestion so you know how it makes random colours to make it easier to tell stuff? perhaps the code for that could be replaced with this? https://stackoverflow.com/questions/43193341/how-to-generate-random-pastel-or-brighter-color-in-javascript then the colours are nicer or something idk
I actually do use a HSL to RGB function for my random color generation, I've just got the colors a bit darker to more closely match the dark theme of the site.

あなたの心を奪う!
I'm a vtuber!aapostpercentaaThe Forum Helpersaa17,000+ posts
bottom text
-Zyte-
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

CatsUnited wrote:

-Zyte- wrote:

shefwerld lol
That's really cool! Can I ask for a custom rank btw?
Go ahead - you can also request a custom color for your user banner
Do I just… ask?
Well, how about… #3FA2FF for my banner, and the first paragraph of my siggy (add the link, if you can, but you don't have to) thx
Oh, and how long have you been making this?

Last edited by -Zyte- (July 21, 2020 08:08:59)



If anyone wonders why my pfp is Luo Tianyi, it's because I like Luo Tianyi. (My original logo is in the banner above)





April Fools 2021 wrote:

miku ftw
but zyte, your pfp is luo tianyi…
because using miku as a pfp is weird. and i didn't want to use tianyi or miku as an pfp, i was forced to


i think i like this pfp now…
and also FUNNEH JOOS
CatsUnited
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

-Zyte- wrote:

CatsUnited wrote:

-Zyte- wrote:

shefwerld lol
That's really cool! Can I ask for a custom rank btw?
Go ahead - you can also request a custom color for your user banner
Do I just… ask?
Well, how about… #3FA2FF for my banner, and the first paragraph of my siggy (add the link, if you can, but you don't have to) thx
Oh, and how long have you been making this?
I made it yesterday lol

あなたの心を奪う!
I'm a vtuber!aapostpercentaaThe Forum Helpersaa17,000+ posts
bottom text
Jeffalo
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

CatsUnited wrote:

Jeffalo wrote:

i find this very cool btw i should have mentioned that.

also perhaps a suggestion so you know how it makes random colours to make it easier to tell stuff? perhaps the code for that could be replaced with this? https://stackoverflow.com/questions/43193341/how-to-generate-random-pastel-or-brighter-color-in-javascript then the colours are nicer or something idk
I actually do use a HSL to RGB function for my random color generation, I've just got the colors a bit darker to more closely match the dark theme of the site.
oh ok sorry

my website: jeffalo.net | ocular: scratch forum search | thank you everyone for all the support, it means a lot to me.




-Zyte-
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

CatsUnited wrote:

-Zyte- wrote:

CatsUnited wrote:

-Zyte- wrote:

shefwerld lol
That's really cool! Can I ask for a custom rank btw?
Go ahead - you can also request a custom color for your user banner
Do I just… ask?
Well, how about… #3FA2FF for my banner, and the first paragraph of my siggy (add the link, if you can, but you don't have to) thx
Oh, and how long have you been making this?
I made it yesterday lol
lol did you just sit at a desk for a day and made this?

Oh and the rank can I just be a “Scrash Tem”?
And the first part of my siggy as the description?

Last edited by -Zyte- (July 21, 2020 08:16:18)



If anyone wonders why my pfp is Luo Tianyi, it's because I like Luo Tianyi. (My original logo is in the banner above)





April Fools 2021 wrote:

miku ftw
but zyte, your pfp is luo tianyi…
because using miku as a pfp is weird. and i didn't want to use tianyi or miku as an pfp, i was forced to


i think i like this pfp now…
and also FUNNEH JOOS
DatOneLefty
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Jeffalo wrote:

Maximouse wrote:

Usernames should probably be case insensitive. Currently this works but this doesn't, although it does show my profile picture.
i guess this could be done by getting the correct capitilazation from the api (it says it there) or just getting lefty to make his api case insenstive
I haven't posted since 2019 lol

The normal ScratchDB user ranking system (on ScratchStats) operates using username to ID through MySQL (it doesn't care about case as much), and then that ID is used to look up a user's ranking and information in a separate system that normally would be case sensitive, but since it's how an ID it doesn't matter. The forums system on the other hand still operates using usernames in a case sensitive way. You may have noticed that requests to usernames that aren't in correct case don't load, that's because the initial verification of if a user has any posts is done in MySQL (which doesn't care about case), so the initial verification succeeds, but once it gets to actually looking up the username in the ranking system, it can't find it since JS is very case sensitive. I'll move this system to be ID based soon so it can be used case-insenstively, and hopefully some time in the future I can find a way to detect deleted/edited posts so ranking and information stays up to date (and so that data that people want removed can be removed more easily).


Scratch data available at ScratchDB

Posts: bf97b44a7fbd33db070f6ade2b7dc549 (btw i use arch)
Boomer001
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

0w0 I didn't know I have posted most in the Bugs and Glitches forum…
I like it.

:::::::::   ::::::::   ::::::::  ::::    ::::  :::::::::: :::::::::   :::::::   :::::::    :::   
:+:    :+: :+:    :+: :+:    :+: +:+:+: :+:+:+ :+:        :+:    :+: :+:   :+: :+:   :+: :+:+:   
+:+    +:+ +:+    +:+ +:+    +:+ +:+ +:+:+ +:+ +:+        +:+    +:+ +:+  :+:+ +:+  :+:+   +:+   
+#++:++#+  +#+    +:+ +#+    +:+ +#+  +:+  +#+ +#++:++#   +#++:++#:  +#+ + +:+ +#+ + +:+   +#+   
+#+    +#+ +#+    +#+ +#+    +#+ +#+       +#+ +#+        +#+    +#+ +#+#  +#+ +#+#  +#+   +#+   
#+#    #+# #+#    #+# #+#    #+# #+#       #+# #+#        #+#    #+# #+#   #+# #+#   #+#   #+#   
#########   ########   ########  ###       ### ########## ###    ###  #######   #######  ####### 
CHECK OUT MY FORUM STATS



















BearSlothCoding
Scratcher
1000+ posts

Scratch Forum Leaderboards / postpercent

Nice. 14th on QaS.
This is really cool! How did this only take a day?
Also, can my banner be some shade of teal? I don't care which specific shade.

Ouch, 103rd on Suggestions. So close to showing up.
How the heck am I 30th on Show and Tell? When did I make 266 posts there?

Last edited by BearSlothCoding (July 21, 2020 16:04:23)

Powered by DjangoBB

Standard | Mobile