forum

osu stats

posted
Total Posts
401
show more
SuzumiyaBR

Kurokami wrote:

Aoko wrote:

Please update my name when searching. If I search Aoko, no results appear and if I search wif my old name, it works. So please update ^^
Same with mine. ._.
²
You can put in order of rank?

ejampe
Easy = music X = rank 1
easy music Y = rank 4
hard music X rank 10

edit

search Metro.....Yousei Teikoku -Torika (Yami )#43 Score: 15,243,270 605/6/0 99,35% D <<<< error , Metro is rank 50
Topic Starter
Piotrekol
@ups
please keep in mind that this previous database was ~2month old
db updated.

going to remake bot for api.(and still thinking how to fully automate updates =w= got idea :3)
ychao
Neat little tool there, Pio.

I also agree that the ability to sort according to rank per difficulty would be helpful as well.
Topic Starter
Piotrekol

ychao24 wrote:

I also agree that the ability to sort according to rank per difficulty would be helpful as well.
I'll just "copy" my pm:
Well... this is impossible with this database structure i have right now(back. It's possible but it would consume a lot of resources so no.)
kcaze
It would probably help to tell you that the user doesn't exist if you try to search up a non-existent user. At least, it would help if you mistyped a username and was wondering why nothing showed up.
Topic Starter
Piotrekol
there's no "fast updates"(like update every 2-3 days) that i wanted and could do right now because I'm rebuilding database(and that means bot and webpage too) to use json(faster+ a lot more features possible in comparison to my old database )
Marcin
You don't wanna know HOW old database was built xD
Topic Starter
Piotrekol

marcin19962 wrote:

You don't wanna know HOW old database was built xD
meh xD

//---------------
http://osustats.ppy.sh/
(it's still not in 1-2day sync)
T-C[222]


:_
Topic Starter
Piotrekol

T-C[222] wrote:

img
:_
http://puu.sh/vz2s
hm?
Kurokami

Piotrekol wrote:

//---------------
http://osustats.ppy.sh/
(it's still not in 1-2day sync)
\:D/
YodaSnipe
I'm excited to see the new updates you'll do :D
LukaXD
Nice, very useful webpage.
animez15
wow so nice of it...
gratx itll good fot it
Tsukimi Luna
o this is nice....
do you have to update it manually overtime?
Or is it real time?
ychao
As far as I know this is not real-time, and it appears to be needing manual updates every now and then currently.
Topic Starter
Piotrekol

ychao24 wrote:

As far as I know this is not real-time, and it appears to be needing manual updates every now and then currently.
rigtht now i'm rewriting update-bot to python to use server that i'm going to get (updates every 2days?)
Marcin
YOU DIDN'T MENTION ME !!!!
Topic Starter
Piotrekol

marcin19962 wrote:

YOU DIDN'T MENTION ME !!!!
I WAS GOING TO WHEN I COMPLETE IT.
(marcin19962 is giving lending me server)
Beuchi
Last 3 posts got deleted.

Please guys, don't start flaming and being rude between yourselves in here. I highly recommend that you do this in private if you really need to discuss anything. ;)
Tsukimi Luna

Piotrekol wrote:

ychao24 wrote:

As far as I know this is not real-time, and it appears to be needing manual updates every now and then currently.
rigtht now i'm rewriting update-bot to python to use server that i'm going to get (updates every 2days?)
O ok all right :3 I'll check it out again some time later
animez15
thats nice...thank you for sharing :)
Mythras
make it update faster and i'll donate $ for you =)
Marcin

Unkind wrote:

make it update faster and i'll donate $ for you =)
I'm telling him everyday, to do this bot working (for now there is only old stats), but he is saying everytime that he has something to do.
Topic Starter
Piotrekol
bot done- ~3hrs for each mod(at least on my computer) -21616maps to do
now going to write "web part"- from 0 since db is completely different
emergist
Thank Piotrekol, it's nice.
YodaSnipe
When's the next update?

Also, why can't we filter multiple mod scores (ex: DT HD top 50s)? Will this be implemented soon?
Marcin
For now he is making new WebPage (server-side scripts)(because of new structure of database, and use 3 of them [3 gamemodes]), i think he will be done in few days.
Topic Starter
Piotrekol

Marcin wrote:

For now he is making new WebPage (server-side scripts)(because of new structure of database, and use 3 of them [3 gamemodes]), i think he will be done in few hours.
but it'll be online(on server) in 1-2days
YodaSnipe
So does that mean we will or will not be able to filter DT HD scores for example?

Edit: NVM it already does this XD derp
Topic Starter
Piotrekol
if anyone is interested test page is available there http://osustats.co.cc/ (not fully functional yet+Database is still updating it stopped halfway ~11900 /21710- i'll see why in ~9hrs =w=)
YodaSnipe
You should add a sort by ranked score ie. #1, #2, #3, etc
Topic Starter
Piotrekol

YodaSnipe wrote:

You should add a sort by ranked score ie. #1, #2, #3, etc
going to add in few minutes? or no for now i should get it working with options it had before
so far new:
  1. scores are sorted by achievement time
todo:
  1. sorting by ranked place(#)
  2. ability to show only no-mod scores
  3. *Your idea here*
  4. ???
YodaSnipe
Profit.

Edit: Uhhh when I filter [Insanes] it shows [Hard]s instead, and [Hard]->[Normal] etc
Marcin
Mysql has just said: I don't give a fuck, and just disconnected piotrekol D:
YodaSnipe
Looks all up to date to me. Is all the functionality of the list: rank by difficulty, map ranked time, etc working? I don't think it works for me.
Marcin

YodaSnipe wrote:

Looks all up to date to me. Is all the functionality of the list: rank by difficulty, map ranked time, etc working? I don't think it works for me.
http://osustats.co.cc/ (not fully functional)
Topic Starter
Piotrekol
^this
I'm still working on it

and yes osu is updated.(in ~2h 30min)
ctb and taiko updated and working


YodaSnipe wrote:

Looks all up to date to me. Is all the functionality of the list: rank by difficulty, map ranked time, etc working? I don't think it works for me.
now it fully works(hopefully Weee )

----------------------------------------------------------------------------
changed address to
http://osustats.ppy.sh/
Mercurial


Great.
Topic Starter
Piotrekol
fixed- it was loading wrong config file www.
YodaSnipe
You know what would be nice, if the text fields were all lined up and equal width just sayin xD looks fine regardless, i think it'd look spicier this way.
animez15
nice! :)
Evil_Victorica
how to search id with "_" and "-"
Marcin
Do you get any error while trying to search with them?
Evil_Victorica

Marcin wrote:

Do you get any error while trying to search with them?
Like 5231_Kinoko
no result >_>
Topic Starter
Piotrekol

Evil_Victorica wrote:

Marcin wrote:

Do you get any error while trying to search with them?
Like 5231_Kinoko
no result >_>
fixed.
Fai-Chii
Wow, Nice
Topic Starter
Piotrekol
data updates now are done everyday
starting at 6a.m.(GMT+2) 1a.m.(GMT+2) ending 6-7hrs later(I'll decrease this time to ~3hrs later)
Kurokami
Yay. \o/
YodaSnipe

Piotrekol wrote:

data updates now are done everyday
starting at 6a.m.(GMT+2) ending 6-7hrs later(I'll decrease this time to ~3hrs later)
Now you make my day daily <3
Marcin
Added favicon (so my stats are not shitstorming about this) \o/
mochi
osustats isn't working for me anymore...

I get nothing when I search.
KoumeSh

mochi wrote:

osustats isn't working for me anymore...

I get nothing when I search.
^same here...
Topic Starter
Piotrekol

anzo-nii wrote:

mochi wrote:

osustats isn't working for me anymore...

I get nothing when I search.
^same here...
let's see... fixed(and with that fixed a bug that showed new maps only every 2nd update(scores were up to date tough) )

//edit

Added No Mod search(NM)
The I_old
Cool BDD website
Topic Starter
Piotrekol
Added Nightcore mod
Winshley
I compared records with my friends and found everything in a single page. Despite that, it still shows the "Next page" button. Clicking it will result in throwing PHP database error.

You made a typo on the website: it's written as "Postion" rather than "Position". :P
Winshley
You replied me through PM. :lol: Anyways...

Piotrekol wrote:

Winshley wrote:

I compared records with my friends and found everything in a single page. Despite that, it still shows the "Next page" button. Clicking it will result in throwing PHP database error.

You made a typo on the website: it's written as "Postion" rather than "Position". :P
see if it's fixed- i couldn't reproduce that but i guess that was possible because of 25/26 records/page diffrence between comparing 1/2 players.
typo fixed.
Apparently, you hit the right spot: it was because the comparison search returned 26 results. Now it's all good~ ;)
Marcin
You are talking to yourself /me runs
Metro
Glad to see this project is doing better and better. Gratz :).
Topic Starter
Piotrekol
added "quick links" (example: http://osustats.ppy.sh/9 http://osustats.ppy.sh/a )

report bugs if found :<
YodaSnipe
Brilliant.
Kurokami
Awesome.
___________
good work
nomen
I have question why it only finds 3 records for me? But I have couple more scores which are in top50.
Topic Starter
Piotrekol

nomen19 wrote:

I have question why it only finds 3 records for me? But I have couple more scores which are in top50.
database is 2days old.
i don't know why bot didn't start in past 2 days...forced update start(means update in 7-8hrs)
Yohann
Nice
Topic Starter
Piotrekol
bot rewritten- now it's able to do update in around 2h(i could speed it up even to 30-40mins but then osustats would probably be unresponsive while updating)
Marcin
Hey everyone, how about Dynamic Sygnature Banners which will show your Top's from: Easy, normal,insane etc. with 3 custom choosed Top's and custom background?
YodaSnipe
I don't understand xD
Marcin
... i'll just make you example.

My paint.net skillz rocks
Background, showed 3 diff's <and or font> would be customizable, everyone would be able to get that,
nomen

Marcin wrote:

Hey everyone, how about Dynamic Sygnature Banners which will show your Top's from: Easy, normal,insane etc. with 3 custom choosed Top's and custom background?
Sure, why not.
Marcin
So: Who's making this, me or you piotrku?
Topic Starter
Piotrekol

Marcin wrote:

So: Who's making this, me or you piotrku?
If you(or somebody else) can make design(text-placement,fonts to use, 1-2pre created backgrounds) for it then i can easily make it.
this isn't ready for public ofc.(ugly,not cached...blah blah)




i just noticed thatcombos,acc are reversed rofl everything is out of place o.0(fixed)
and it shows last 3 records

hipster3000 wrote:

still no taiko updates though :(
because database is COMPLETELY CLEAN(osu,taiko,ctb) ;w; ~
hipster3000

Piotrekol wrote:

bot rewritten- now it's able to do update in around 2h(i could speed it up even to 30-40mins but then osustats would probably be unresponsive while updating)
still no taiko updates though :(
Ivy
There's no records because the database is clean:<
Topic Starter
Piotrekol

Ivy wrote:

There's no records because the database is clean:<
:<

My host wrote:

....
<some1>either way, 3 milion queries every day is about 35 queries/second
<some1> this is way too much as for shared hosting.
well... waiting for peppy to change slightly api so i can decrease number of queries needed for update.. .
Raimon
The waiting is so long... ;_;
TriGoon
Ugh, been waiting for so long. Only way to see all my top 50's in one place. :(
pielak213
­
Marcin
Then go spam peppy for only ONE function, which will provide data depending on GET date variable. So it'll be FAST, OPTIMIZED, and will eat less bandwidth on both sides <ours and peppy's>
gsaway
r :(
Topic Starter
Piotrekol

gsaway wrote:

r :(

Piotrekol wrote:

well... waiting for peppy to change slightly api so i can decrease number of queries needed for update.. .
if not then consider osustats as dead project.

//edit 8days later (and bump)
I've ran update BUT I've also slowed bot - so my host won't be mad D: (it might take even 2days to update all maps 18h done) after it's done I'll enable osustats but i won't make any updates with api(in this form as it is now).
http://osustats.ppy.sh/dbs ~~

//done
boat
Hooray, it works.
thelewa
no updates makes lewa a sad Finn
Topic Starter
Piotrekol
well. last update will appear in 2-3days(unless Marcin who also quit will do it)
why? go to my profile.
nvm.
Ibuki Suika

Piotrekol-- wrote:

well. last update will appear in 2-3days(unless Marcin who also quit will do it)
why? go to my profile.
:( bye
-Neipezi
Wow ..Beatmap Ranking # 40 in the favorite shows.
GJ! :) :D
RadioNoise
Maybe I can help hosting osustats on my own VPS :)


E-mail me at RadarNyan[at]moe9th.com or send me a PM~
Marcin
Well, if you want to help us, host MySQL server, and then shot PM with login and pass to piotrekol, he will know what to do next.
Be aware that he will make almost 5 milion queries per day, so.
Topic Starter
Piotrekol
osu! done and halfway done with taiko(so except that there'll be still some missing scores in the next ~2hrs) Fully updated(in 3h 21min).
Thanks RadioNoise for database :) .
I still have to discuss how often i'll be making updates with RadioNoise.
Data update is applied every 12h(for now)
Seph
ano..

You kinda switched Search results. When i click ctb it shows my taiko plays, and show my ctb plays when i click taiko lol
RadioNoise

Seph wrote:

ano..

You kinda switched Search results. When i click ctb it shows my taiko plays, and show my ctb plays when i click taiko lol

There's a bug with the bot, Pio is working on that, should be fixed soon :oops:
Topic Starter
Piotrekol

RadioNoise wrote:

There's a bug with the bot, Pio is working on that, should be fixed soon :oops:
:<

Seph wrote:

ano..

You kinda switched Search results. When i click ctb it shows my taiko plays, and show my ctb plays when i click taiko lol
fixed(that was just misplaced text).
Tomoyo_old

Piotrekol-- wrote:

Data update is applied every 12h(for now)
Seems not working these days :o

And thanks for working on this,it's really convenient!
Topic Starter
Piotrekol

Tomoyo wrote:

Seems not working these days :o
i forgot to schedule(cron) it :F my bad- added.
Emaal
i took the name of my old user, which is now banned for obvious reasons, nonetheless, when I search for Emaal nothing comes up. halp
Topic Starter
Piotrekol

Emaal wrote:

i took the name of my old user, which is now banned for obvious reasons, nonetheless, when I search for Emaal nothing comes up. halp
http://osustats.ppy.sh/bT ?
Emaal

Piotrekol-- wrote:

Emaal wrote:

i took the name of my old user, which is now banned for obvious reasons, nonetheless, when I search for Emaal nothing comes up. halp
http://osustats.ppy.sh/bT ?
oh hey it's fixed. thanks~

Good job on the website too, hope you can keep it running!
Marcin
As long as we he can have external mySQL db.
show more
Please sign in to reply.

New reply