avbuzz

# AVBUZZ — FANZA AV Query Skill > **⚠️ Adult Content (R18+)** — This skill indexes adult video (AV) content from FANZA. Users must be 18+ and comply with local laws. Query AV new releases, rankings, actress info, and search from FANZA's free GraphQL API. **No API keys or authentication required.** ## API Overview **Endpoint:** `POST https://api.video.dmm.co.jp/graphql` **Authentication:** None (public API) **Content-Type:** `application/json` All queries use the `legacySearchPPV` GraphQL operation. Results include: video code (番號), title, actresses, maker/studio, release date, cover image URL, star ratings, and bookmark count. ### Determining Today's JST Date FANZA uses JST (Japan Standard Time, UTC+9). To get today's date in JST: ```bash date -u -d '+9 hours' '+%Y-%m-%d' ``` On macOS: ```bash TZ=Asia/Tokyo date '+%Y-%m-%d' ``` Use this date value in any `deliveryStartDate` filter. For yesterday, subtract 1 day: ```bash date -u -d '+9 hours -1 day' '+%Y-%m-%d' ``` --- ## Query Operations ### 1. Today's New Releases Fetch videos released on a specific date (use JST date, format `YYYY-MM-DD`): ```bash curl -s -X POST https://api.video.dmm.co.jp/graphql \ -H "Content-Type: application/json" \ -d '{"query":"{ legacySearchPPV(limit: 10, offset: 0, sort: DELIVERY_START_DATE, floor: AV, filter: { deliveryStartDate: \"2026-03-03\" }) { result { contents { id title deliveryStartAt contentType maker { name } actresses { id name } packageImage { largeUrl } review { average count } bookmarkCount } pageInfo { totalCount } } } }"}' ``` Change `deliveryStartDate` to any `YYYY-MM-DD` date. Use `offset` for pagination (0, 10, 20...). ### 2. Today's Hot (by Popularity) Same as new releases but sorted by sales rank: ```bash curl -s -X POST https://api.video.dmm.co.jp/graphql \ -H "Content-Type: application/json" \ -d '{"query":"{ legacySearchPPV(limit: 10, offset: 0, sort: SALES_RANK_SCORE, floor: AV, filter: { deliveryStartDate: \"2026-03-03\" }) { result { contents { id title deliveryStartAt contentType maker { name } actresses { id name } packageImage { largeUrl } review { average count } bookmarkCount } pageInfo { totalCount } } } }"}' ``` ### 3. Rankings Top videos by different criteria. Change `sort` value: **Sales ranking (best-selling):** ```bash curl -s -X POST https://api.video.dmm.co.jp/graphql \ -H "Content-Type: application/json" \ -d '{"query":"{ legacySearchPPV(limit: 10, sort: SALES_RANK_SCORE, floor: AV) { result { contents { id title deliveryStartAt contentType maker { name } actresses { id name } packageImage { largeUrl } review { average count } bookmarkCount } pageInfo { totalCount } } } }"}' ``` **Review ranking (highest rated):** ```bash curl -s -X POST https://api.video.dmm.co.jp/graphql \ -H "Content-Type: application/json" \ -d '{"query":"{ legacySearchPPV(limit: 10, sort: REVIEW_RANK_SCORE, floor: AV) { result { contents { id title deliveryStartAt contentType maker { name } actresses { id name } packageImage { largeUrl } review { average count } bookmarkCount } pageInfo { totalCount } } } }"}' ``` **Bookmark ranking (most saved):** ```bash curl -s -X POST https://api.video.dmm.co.jp/graphql \ -H "Content-Type: application/json" \ -d '{"query":"{ legacySearchPPV(limit: 10, sort: BOOKMARK_COUNT, floor: AV) { result { contents { id title deliveryStartAt contentType maker { name } actresses { id name } packageImage { largeUrl } review { average count } bookmarkCount } pageInfo { totalCount } } } }"}' ``` Available `sort` values: | Sort Value | Use When | |-----------|----------| | `DELIVERY_START_DATE` | User asks for "latest" / "newest" / "最新" — sorted by release date | | `SALES_RANK_SCORE` | User asks for "popular" / "best-selling" / "熱門" / "銷售" | | `REVIEW_RANK_SCORE` | User asks for "highest rated" / "best reviewed" / "評分" | | `BOOKMARK_COUNT` | User asks for "most saved" / "most bookmarked" / "收藏" | ### 4. Search by Keyword Search by actress name, title, video code, or any keyword: ```bash curl -s -X POST https://api.video.dmm.co.jp/graphql \ -H "Content-Type: application/json" \ -d '{"query":"{ legacySearchPPV(limit: 10, offset: 0, sort: SALES_RANK_SCORE, floor: AV, queryWord: \"蒼井空\") { result { contents { id title deliveryStartAt contentType maker { name } actresses { id name } packageImage { largeUrl } review { average count } bookmarkCount } pageInfo { totalCount } } } }"}' ``` Replace `蒼井空` with any search term. Works with: - Actress names (Japanese): `波多野結衣`, `蒼井 空` (space may help) - Video codes: `SSNI`, `IPZ-123` - Keywords: `VR`, `4K`, studio names - English terms work too **Important notes on search:** - Keyword search is **fuzzy/broad** — partial kanji matches may return unrelated results. If searching for a specific actress returns unexpected results, try adding a space between family and given name, or search for just the family name - **Video code format:** Users typically write `SSIS-001` but FANZA uses `ssis00001` (lowercase, no hyphen, 5-digit zero-padded number). Try both formats — the API handles uppercase/lowercase, but removing the hyphen and padding zeros improves accuracy - For exact actress works, prefer the **Actress ID search** (Section 5) over keyword search ### 5. Search by Actress ID If you know the actress ID (from a previous search result), fetch all her works: ```bash curl -s -X POST https://api.video.dmm.co.jp/graphql \ -H "Content-Type: application/json" \ -d '{"query":"{ legacySearchPPV(limit: 20, sort: DELIVERY_START_DATE, floor: AV, filter: { actressIds: { ids: [{ id: \"26225\" }] } }) { result { contents { id title deliveryStartAt contentType maker { name } actresses { id name } packageImage { largeUrl } review { average count } bookmarkCount } pageInfo { totalCount } } } }"}' ``` Replace `26225` with the actress ID. Note the nested object syntax: `actressIds: { ids: [{ id: "ID" }] }`. --- ## Response Format All queries return the same structure: ```json { "data": { "legacySearchPPV": { "result": { "contents": [ { "id": "ssni00001", "title": "Title in Japanese", "deliveryStartAt": "2026-03-03", "contentType": "TWO_DIMENSION", "maker": { "name": "Studio Name" }, "actresses": [ { "id": "26225", "name": "波多野結衣" } ], "packageImage": { "largeUrl": "https://pics.dmm.co.jp/..." }, "review": { "average": 4.5, "count": 123 }, "bookmarkCount": 456 } ], "pageInfo": { "totalCount": 42 } } } } } ``` ### Field Reference | Field | Description | |-------|-------------| | `id` | FANZA product code / 番號 (e.g., `ssni00001`) — display as UPPERCASE | | `title` | Video title (Japanese) | | `deliveryStartAt` | Release date (`YYYY-MM-DD`) | | `contentType` | `TWO_DIMENSION` for normal, `VR` for VR content | | `maker.name` | Studio/maker name | | `actresses` | Array of `{ id, name }` — performer info | | `packageImage.largeUrl` | Cover image URL (DMM CDN) | | `review.average` | Star rating 1.0–5.0 | | `review.count` | Number of reviews | | `bookmarkCount` | Number of user bookmarks/saves | | `pageInfo.totalCount` | Total matching results (for pagination) | ### Pagination Use `limit` and `offset` parameters: - Page 1: `limit: 10, offset: 0` - Page 2: `limit: 10, offset: 10` - Page 3: `limit: 10, offset: 20` Maximum `limit` is 50. ### FANZA Product Page URL To link to a video's FANZA page: ``` https://www.dmm.co.jp/digital/videoa/-/detail/=/cid={id}/ ``` Replace `{id}` with the product code (lowercase). --- ## Error Handling | HTTP Code | Meaning | Action | |-----------|---------|--------| | 200 | Success | Parse `data.legacySearchPPV.result` | | 200 + `errors` | GraphQL validation error (wrong syntax) | Check query syntax against examples above | | 429 | Rate limited | Retry after 2-10 seconds (exponential backoff) | | 500 | Server error | Retry after 5 seconds; if persistent, API may be temporarily down | | 503 | Service unavailable | API is temporarily down; retry after 30 seconds | | Timeout | Network issue | Check connectivity; retry after 5 seconds | Empty results (`contents: [], totalCount: 0`) are NOT errors — they mean no matching content was found. ### VR Content Filtering The GraphQL API does **NOT** support filtering by `contentType` (VR vs normal). To find VR content: 1. Query normally (by date, keyword, ranking, etc.) 2. Filter results client-side: check `contentType === "VR"` in the response 3. **Recommended fallback:** If client-side filtering returns no VR results (e.g., top-rated are all 2D), combine `queryWord: "VR"` with your desired sort to get VR-specific results --- ## Tips for Effective Queries 1. **Date format is JST** — Japan is UTC+9. "Today" in JST may differ from your timezone 2. **Actress names** — Try with and without spaces: `蒼井空` and `蒼井 空` 3. **Sort wisely** — Use `SALES_RANK_SCORE` for popular, `DELIVERY_START_DATE` for newest 4. **VR content** — Check `contentType === "VR"` (normal content is `"TWO_DIMENSION"`) and mark with 🥽 5. **Cover images** — `packageImage.largeUrl` works directly in Discord embeds, Telegram, web, etc. 6. **Error responses** — API returns `{"errors":[...]}` on invalid queries. HTTP 429 means rate limited — retry after a few seconds. --- ## Daily Notifications This skill provides **on-demand queries only**. The AI queries FANZA when you ask, but cannot autonomously push daily notifications. For automatic daily new release alerts, deploy the AVBUZZ Discord bot to a VPS (see "Advanced: Discord Bot Deployment" below). The bot supports: - Daily digest at configurable JST time (default 00:05) - Actress tracking alerts every 6 hours - `/notify on` / `/notify off` to toggle daily push per channel --- ## Disclaimer > **FANZA GraphQL API is undocumented and unofficial.** This skill uses a reverse-engineered API endpoint (`api.video.dmm.co.jp/graphql`) that is not publicly supported by DMM/FANZA. The API could change or become unavailable at any time without notice. Use at your own risk. This project is not affiliated with DMM, FANZA, or any content producers. --- ## Advanced: Discord Bot Deployment AVBUZZ can also run as a persistent Discord bot with slash commands, automatic daily digests, actress tracking alerts, and Telegram integration. **GitHub:** [github.com/zxcnny930/avbuzz](https://github.com/zxcnny930/avbuzz) ### Quick Setup ```bash git clone https://github.com/zxcnny930/avbuzz.git cd avbuzz npm install cp config.example.json config.json # Edit with your tokens npm start ``` Requires: `node`, `npm`, `git` ### Configuration All settings in `config.json`: ```json { "discord": { "token": "YOUR_DISCORD_BOT_TOKEN", "guildId": "YOUR_GUILD_ID", "channelId": "YOUR_CHANNEL_ID" }, "telegram": { "botToken": "YOUR_TELEGRAM_BOT_TOKEN", "chatId": "YOUR_CHAT_ID" }, "schedule": { "dailyPushHourJST": 0, "dailyPushMinuteJST": 5, "actressCheckIntervalHours": 6 } } ``` ### Discord Setup 1. Create app at [discord.com/developers](https://discord.com/developers/applications) → **Bot** tab → **Add Bot** → copy Token 2. **OAuth2** → **URL Generator** → scopes: `bot` → permissions: `Send Messages`, `Embed Links` → invite bot