forum

Get Information from scores.db

posted
Total Posts
5
Topic Starter
Lana
Hello everyone!
I want to code a few lines with SQL to filter my choke Maps.
I found and read the specific Wikis for the four different .db files.
Yet, when I tried to open the scores.db it showed me, that those are encrypted and that I am requierd to enter a Password. Since we did not learn in school about networks, pw, security and stuff, I don't know, if I am even supposed to open these files and if there is another way to get the relavant data (?) such as
  1. Byte osu! gameplay mode
  2. Short for Max Combo
  3. Short for Number of misses
  4. Identification for Beatmap (Maybe the Hash?)
  5. Maybe the Boolean for Perfect combo.


I would be very thankfull for answers to the questions above :)
And pls don't hate me, I am beginner programmer :(
Full Tablet
It's not encrypted, look up how to open a file in binary format.
Topic Starter
Lana

Full Tablet wrote:

It's not encrypted, look up how to open a file in binary format.
Ok, thanks.
Guess I'm too much of a beginner now to do that.
I thought it worked with just using DB Browsers.
We never leared it other ways in high school.

Hope that I'll learn it in university later or learn it by myselfe, when i have time for it.
Kolser
Download HxD or some other hex editor and open scores.db with it. It's not structured in the same way as an SQL table; all the important values are packed into raw bytes and map hashes are UTF-8 encoded. You can see the structure and more info about it here.
GPR
I believe file .db in osu! use SQLite and you can browse it using DB Browser.
Please sign in to reply.

New reply