All available levels on the LBP 1/2/3 online service
Archive date: 16 Feb - 20 Feb 2023

Reviews, comments, photos and scores are not included (but counts for
each are); users without published levels are not included

--------------------------------------------------------------------------
Files

- dry.db: SQLite database with metadata for slots and users
- dry*.zip: ZIP archives of the resources referenced in dry.db and
  their dependencies

--------------------------------------------------------------------------
Tables

Please note these are results from a scraper; the data may not be
structured how you are expecting.
It is using XML responses (not game serialization).

----
Level metadata

slot
{
    uint32 id                  // Unique
    string npHandle            // Search this to find your levels

    uint16 locationX
    uint16 locationY
    uint8  game
    string name
    string description
    BLOB   rootLevel           // See Resource references
    BLOB   icon

    bool   initiallyLocked
    bool   isSubLevel
    bool   isLBP1Only
    uint32 background
    BLOB   thumbnail
    bool   shareable

    BLOB   authorLabels        // See Labels
    string leveltype
    uint8  minPlayers
    uint8  maxPlayers

    bool isAdventurePlanet
    bool ps4Only

    uint32 heartCount
    uint32 thumbsup
    uint32 thumbsdown
    float  averageRating
    bool   mmpick

    uint32 reviewCount         // *
    uint32 commentCount        // *
    uint32 photoCount          // *
    uint32 authorPhotoCount    // *
    BLOB   tags                // * See Tags
    BLOB   labels              // * See Labels
    uint64 firstPublished      // * milliseconds
    uint64 lastUpdated         // * milliseconds
    string genre               // *
    bool   commentsEnabled     // *
    bool   reviewsEnabled      // *
    string publishedIn         // *

    uint32 playCount
    uint32 completionCount
    uint32 lbp1PlayCount
    uint32 lbp1CompletionCount
    uint32 lbp1UniquePlayCount
    uint32 lbp2PlayCount
    uint32 lbp2CompletionCount
    uint32 uniquePlayCount
    uint32 lbp3PlayCount
    uint32 lbp3CompletionCount
    uint32 lbp3UniquePlayCount

    uint8 got
    {
        PENDING = 0,
        OK      = 1,
        PARTIAL = 2    // See below
    }
}

"got" PARITAL column value means a slot was found when enumerating ids
(/slotList pass)
but returned 404 when reading some extra metadata
(/s/user/ pass).

The columns that will be missing if got=2 are marked with a star *
There are no rows with PENDING

----
User metadata

user
{
    string npHandle         // Your online id
    BLOB   icon             // See Resource references

    uint32 lbp1UsedSlots
    uint32 entitledSlots
    uint32 freeSlots
    uint32 crossControlUsedSlots
    uint32 crossControlEntitledSlots
    uint32 crossControlFreeSlots
    uint32 lbp2UsedSlots
    uint32 lbp2EntitledSlots
    uint32 lbp2FreeSlots
    uint32 lbp3UsedSlots
    uint32 lbp3EntitledSlots
    uint32 lbp3FreeSlots

    int64  heartCount
    // See Resource references
    BLOB   planets          // (LVL)
    BLOB   yay2             // (TEX)
    BLOB   boo2             // (TEX)
    uint16 locationX
    uint16 locationY
    bool   commentsEnabled
    uint32 pins0
    uint32 pinsl
    uint32 pins2
}

Users without published levels are not included.

----
Resource request queue

resq
{
    BLOB  sha             // See Resource references
    uint8 got
    {
        PENDING   = 0,
        OK        = 1,
        NOT_FOUND = 2,    // See below
        GONE      = 3,
        BAD       = 4     // Digest mismatch. This did not happen.
    }
}

"got" column value shows resources that were missing from the server.
2: NOT_FOUND, returned 404; 3: GONE, returned 410
There are no rows with PENDING, OK or BAD

--------------------------------------------------------------------------
BLOB value formats

Resource references (e.g. icon, rootLevel) are represented as either:
  a 32-bit unsigned integer in big-endian order for GUIDs, or
  a SHA-1 hash for user-generated content

Labels (labels, authorLabels) are represented as a big-endian bit field
corresponding to the following (starting with the least significant bit):
  SinglePlayer, RPG, Multiplayer, SINGLE_PLAYER, Musical, Artistic, Funny,
  Scary, Easy, Challenging, Long, Quick, Time_Trial, Seasonal, 16_Bit,
  8_Bit, Homage, Technology, Pinball, Movie, Sticker_Gallery,
  Costume_Gallery, Music_Gallery, Prop_Hunt, Hide_And_Seek, Hangout,
  Driving, Defence, Party_Game, Mini_Game, Card_Game, Board_Game,
  Arcade_Game, Social, Sci_Fi, 3rd_Person, 1st_Person, CO_OP, TOP_DOWN,
  Retro, Tutorial, SurvivalChallenge, Strategy, Story, Sports, Shooter,
  Race, Platform, Puzzle, Gallery, Fighter, Competitive, Cinematic,
  FLOATY_FLUID_NAME, HOVERBOARD_NAME, SPRINGINATOR, SACKPOCKET, QUESTS,
  INTERACTIVE_STREAM, WALLJUMP, MEMORISER, HEROCAPE, ATTRACT_TWEAK,
  ATTRACT_GEL, Paint, Movinator, Brain_Crane, Water, Vehicles, Sackbots,
  PowerGlove, Paintinator, LowGravity, MagicBag, JumpPads, GrapplingHook,
  Glitch, Explosives, DirectControl, Collectables, CREATED_CHARACTERS,
  SACKBOY, SWOOP, TOGGLE, ODDSOCK

Tags (tags) are represented as a big-endian bit field corresponding
to the following (starting with the least significant bit):
  Brilliant, Beautiful, Funky, Points-Fest, Weird, Tricky, Short,
  Vehicles, Easy, Cute, Quick, Fun, Relaxing, Great, Speedy, Race,
  Multi-Path, Machines, Complex, Pretty, Rubbish, Toys, Repetitive,
  Machinery, Satisfying, Braaains, Fast, Simple, Long, Slow, Mad, Hectic,
  Creepy, Perilous, Empty, Ingenious, Lousy, Frustrating, Timing, Boss,
  Springy, Funny, Musical, Good, Hilarious, Electric, Puzzler, Platformer,
  Difficult, Mechanical, Horizontal, Splendid, Fiery, Swingy, Single-Path,
  Annoying, Co-op, Boring, Moody, Bubbly, Nerve-wracking, Hoists, Ugly,
  Daft, Ramps, Secrets, Floaty, Artistic, Competitive, Gas, Varied,
  Stickers, Spikes, Collectables, Vertical, Balancing