penguinencounter

Did some database design:

• profile_meta table; single row, contains schema versioning information

• sources: source attachments

• channels: groups that users may want to track, like TICK, or RENDER. could be continuous or not

• events: collections of steps, like a single tick or frame. instruction count and timing are totaled under a single event to measure overall performance / permission level impact

  • can have a parent event (ex. ITEM_RENDER has RENDER as a parent)

• steps: individual actions within a script. instructions, function calls, detailed timings

• Added method to automatically set up a blank database with the current schema version.

• Added method to apply database migrations in the future.

• Added method to copy a on-disk database into a temporary database

  • this is done with a RESTORE FROM command, which is not real SQLite and gets intercepted by the JDBC connector. As a result, you can’t do this with a prepared statement, so manual sanitization goes brrrr

newConn.createStatement().use {
    val syntax = when {
        url.contains("\"") && url.contains("\'") -> throw SQLException("Cannot unmount database: no safe quote type for $url")
        url.contains("\'") -> "RESTORE FROM \"$url\""
        else -> "RESTORE FROM '$url'"
    }
    @Suppress("SqlSourceToSinkFlow")
    it.executeUpdate(syntax)
}

Found a matching library!

HidLibrary appears to be statically linked into the executable.

Mapped a bunch of Windows API bindings and names. Also, figured out that C# async is completely fake and is just 2 delegates and 3 methods in a trenchcoat.

Is it binary? The answer may surprise you.

we have two different kinds of UTF-16 and you have to guess which one is correct

also JS labels are real and you Can use them