Files
ywsandClaude Opus 5.5 b83511ff55 内容后台:能原样接住线上真实画展(文件名带空格、本站 mp4 视频 + 网页版、作品外链、离线缩略图索引、世界线主色),不再在校验时丢数据
- 站内路径允许普通空格,多认 exhibition_web/、thumbs/;制表符/换行/引号/尖括号/?#/.. 照旧拒
- 视频:本站 .mp4/.webm 不用填 B 站链接;web / link / links 保留
- 离线媒体索引 media 保留并写进 site.js(以前发布一次就丢缩略图,画展会直接拉几百张原图)
- 世界线 tone/sector/media 保留并带进星系图数据
- 后台:本站视频的预览图走缩略图索引;编辑本站视频不再强制 B 站链接
- 测试 +8(86 条全过)

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-10-06 05:02:15 +00:00

1180 lines
62 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""金钻客栈 · 内容后台(服务端)—— 2026-10-05
网站前端所有**展示内容**(门户各板块、下单页的模板与文字、价格与付款方式)在这里改,不用再改代码。
设计说明见仓库根目录 `内容后台设计.md`;这里是实现。纯标准库,和 server.py 同一个进程、同一个库(ys.db)。
接口全部挂在 /api/cms/ 下(nginx 反代后对外是 /order/api/cms/):
POST login / logout 登录(用户名或邮箱 + 密码,「记住我」= Cookie 留 30 天)/ 退出
GET me 当前账号(含 CSRF 令牌、是否必须改密)
POST password 改密码(除了这台,别的设备全部退出)
GET sessions / POST sessions/revoke 登录着的设备 / 踢掉一台或除这台外全部
GET content 草稿 + 已发布 + 当前版本号
POST draft / discard 存草稿 / 丢掉草稿
POST publish / rollback 发布(写出静态内容文件)/ 回到某一版(也算一次发布)
GET versions / version?no= / audit 发布记录 / 某一版的内容 / 操作日志
POST upload 画展传图(核验 → 剥元数据 → ffmpeg 出缩略图)
GET draft.js / draft-order.js 预览用:把草稿当成网站内容(只有登录的人能拿到)
安全底线(店主定的,别放松):
* 密码:hashlib.scrypt(没有就 pbkdf2_hmac)加随机盐存哈希,任何地方都不存、不记明文。
* 首次启动库里没有账号 → 自动建 admin / admin 并标「必须改密」:
改密之前服务端**只放行 me / password / logout**,其它接口一律 403 —— 在下面 handle() 的统一入口拦。
* 会话 = 服务端随机令牌,库里只存它的哈希,30 天滑动过期;退出 / 改密 / 命令行重置 / 停用都会当场作废。
* Cookie:HttpOnly + SameSite=Strict,https 下加 Secure。修改类请求还要带 X-CSRF 头。
* 只走 https:反代告诉我们不是 https 就拒绝(服务器本机直连调试例外)。
* 内容后台碰不到卡密 / 订单:这里只读写 cms_* 表、内容文件、prices.json / payinfo.json。
"""
import base64, hashlib, hmac, json, os, re, secrets, struct, subprocess, tempfile, threading, time
from datetime import datetime, timedelta, timezone
PORTAL_DIR = os.environ.get("YS_PORTAL_DIR", "<PORTAL_DIR>") # 门户网站根目录(index.html 所在)
ORDER_DIR = os.environ.get("YS_ORDER_DIR", "<ORDER_DIR>") # 下单页目录(order/index.html 所在)
COOKIE = "jz_cms"
SESSION_DAYS = 30 # 会话 30 天没用就过期(用一次续一次)
MIN_PW = 8
COMMON_PW = {"12345678", "123456789", "1234567890", "password", "password1", "11111111", "88888888", "00000000",
"qwertyui", "qwerty123", "abc12345", "admin123", "admin888", "iloveyou", "a1234567", "1qaz2wsx",
"admin", "administrator", "jinzuan", "jinzuan123"}
# 登录冷却:15 分钟内,同一 IP 错 5 次 / 同一账号(所有 IP 合计)错 20 次以上开始冷却:30s、60s、120s … 最长 15 分钟。
# 账号那档故意放宽:只按账号算的话,别人从外面故意连错几次就能把店主锁在门外。
FAIL_WIN, FAIL_FREE_IP, FAIL_FREE_USER = 15 * 60, 5, 20
UPLOAD_MAX = 10 * 1024 * 1024 # 单张图 10MB(base64 后约 13.4MB,server.py 的 MAX_BODY 15MB 装得下)
THUMB_W = 720
CST = timezone(timedelta(hours=8))
SLUG = re.compile(r"^[a-z0-9][a-z0-9_-]{0,31}$")
DATE = re.compile(r"^\d{4}-\d{2}-\d{2}$")
HEX = re.compile(r"^#[0-9A-Fa-f]{6}$")
# 站内相对路径:只许 exhibition/ 和 uploads/ 下面,不许 .. / 协议 / 开头斜杠
# 文件名里允许普通空格(真实作品名大量带空格,如「明介 (1).webp」);制表符 / 换行、引号、尖括号、? # \ 一律不收
PATH_RE = re.compile(r"^(exhibition|exhibition_web|uploads|thumbs)/[^\t\n\r\f\v<>\"'\\?#]{1,240}$")
BVID = re.compile(r"^BV[0-9A-Za-z]{10}$")
_SCHEMA = """
CREATE TABLE IF NOT EXISTS cms_users (
id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, email TEXT UNIQUE,
pw TEXT NOT NULL, must_change INTEGER NOT NULL DEFAULT 0, disabled INTEGER NOT NULL DEFAULT 0,
created REAL, last_login REAL, last_ip TEXT);
CREATE TABLE IF NOT EXISTS cms_sessions (
th TEXT PRIMARY KEY, uid INTEGER NOT NULL, csrf TEXT NOT NULL, created REAL, last REAL, expires REAL,
remember INTEGER, ip TEXT, ua TEXT);
CREATE INDEX IF NOT EXISTS cms_sessions_uid ON cms_sessions(uid);
CREATE TABLE IF NOT EXISTS cms_draft (k TEXT PRIMARY KEY, data TEXT NOT NULL, base INTEGER, updated REAL, by TEXT);
CREATE TABLE IF NOT EXISTS cms_versions (no INTEGER PRIMARY KEY, data TEXT NOT NULL, note TEXT, by TEXT, at REAL, chg TEXT);
CREATE TABLE IF NOT EXISTS cms_audit (id INTEGER PRIMARY KEY AUTOINCREMENT, at REAL, who TEXT, ip TEXT, what TEXT);
"""
# ============================================================ 密码
def hash_pw(pw):
salt = secrets.token_bytes(16)
try:
dk = hashlib.scrypt(pw.encode("utf-8"), salt=salt, n=2 ** 14, r=8, p=1, dklen=32, maxmem=64 * 1024 * 1024)
return "scrypt$16384$8$1$%s$%s" % (base64.b64encode(salt).decode(), base64.b64encode(dk).decode())
except (AttributeError, ValueError): # 这台机器的 Python / OpenSSL 没带 scrypt
it = 600000
dk = hashlib.pbkdf2_hmac("sha256", pw.encode("utf-8"), salt, it, 32)
return "pbkdf2$%d$%s$%s" % (it, base64.b64encode(salt).decode(), base64.b64encode(dk).decode())
def check_pw(pw, stored):
try:
parts = stored.split("$")
if parts[0] == "scrypt":
n, r, p = int(parts[1]), int(parts[2]), int(parts[3])
salt, want = base64.b64decode(parts[4]), base64.b64decode(parts[5])
got = hashlib.scrypt(pw.encode("utf-8"), salt=salt, n=n, r=r, p=p, dklen=len(want), maxmem=64 * 1024 * 1024)
elif parts[0] == "pbkdf2":
it, salt, want = int(parts[1]), base64.b64decode(parts[2]), base64.b64decode(parts[3])
got = hashlib.pbkdf2_hmac("sha256", pw.encode("utf-8"), salt, it, len(want))
else:
return False
return hmac.compare_digest(got, want)
except Exception:
return False
def pw_problem(pw, old=None):
"""新密码不合格的原因;合格返回 None。"""
if not isinstance(pw, str) or len(pw) < MIN_PW:
return "新密码至少 %d 位" % MIN_PW
if len(pw) > 128:
return "新密码太长了(最多 128 位)"
if pw.lower() in COMMON_PW or len(set(pw)) <= 2:
return "这个密码太常见了,换一个"
if old is not None and pw == old:
return "新密码不能和原来的一样"
return None
def _th(token):
return hashlib.sha256(token.encode("utf-8")).hexdigest()
# ============================================================ 内容的校验 / 规整
class Bad(Exception):
"""内容不合格:带上是哪一项、为什么(给后台页面直接显示)。"""
def _s(v, n, where, required=False):
v = "" if v is None else str(v)
v = v.replace("\r\n", "\n").replace("\r", "\n").strip()
v = "".join(ch for ch in v if ch == "\n" or ch == "\t" or ord(ch) >= 32) # 去掉控制字符
if len(v) > n:
raise Bad("%s 太长了(最多 %d 个字,现在 %d 个)" % (where, n, len(v)))
if required and not v:
raise Bad("%s 不能空" % where)
return v
def _b(v):
return bool(v) and v not in ("0", "false", "False")
def _url(v, where, allow_mail=False, allow_site=False, allow_empty=True):
v = _s(v, 300, where)
if not v:
if allow_empty:
return ""
raise Bad("%s 不能空" % where)
if re.match(r"^https://[^\s<>\"'\\]+$", v, re.I):
return v
if allow_mail and re.match(r"^mailto:[^\s@<>\"'\\]+@[^\s@<>\"'\\]+$", v, re.I):
return v
if allow_site and re.match(r"^/[A-Za-z0-9_\-./]*$", v) and ".." not in v and not v.startswith("//"):
return v
if v.lower().startswith("http://"):
raise Bad("%s 要用 https://(http 不安全)" % where)
raise Bad("%s 格式不对:%s" % (where, "只收 https:// 开头的网址" + ("或 mailto: 邮箱" if allow_mail else "") + ("或站内路径(/ 开头)" if allow_site else "")))
def _path(v, where, allow_empty=True):
v = _s(v, 260, where)
if not v:
if allow_empty:
return ""
raise Bad("%s 不能空" % where)
if not PATH_RE.match(v) or ".." in v or "//" in v:
raise Bad("%s 不是站内文件路径(只认 exhibition/…、exhibition_web/…、uploads/…、thumbs/…)" % where)
return v
def _date(v, where, allow_empty=True):
v = _s(v, 10, where)
if not v and allow_empty:
return ""
if not DATE.match(v):
raise Bad("%s 要写成 2026-10-05 这样" % where)
try:
datetime.strptime(v, "%Y-%m-%d")
except ValueError:
raise Bad("%s 不是一个真实的日期" % where)
return v
def _num(v, lo, hi, where, integer=False):
try:
x = float(v)
except (TypeError, ValueError):
raise Bad("%s 要填数字" % where)
if x != x or x < lo or x > hi:
raise Bad("%s 要在 %s 到 %s 之间" % (where, lo, hi))
return int(round(x)) if integer else round(x, 4)
def _id(v, prefix):
v = str(v or "").strip().lower()
return v if SLUG.match(v) else prefix + secrets.token_hex(4)
def _list(v, where, cap):
if v is None:
return []
if not isinstance(v, list):
raise Bad("%s 格式不对" % where)
if len(v) > cap:
raise Bad("%s 最多 %d 条" % (where, cap))
return v
BOARD_IDS = ("home", "gallery", "apps", "universe", "links", "about")
GTYPES = ("image", "video", "pano", "wall")
STYLES = ("earth", "ocean", "jungle", "desert", "tundra", "ice", "lava", "toxic", "barren", "gas", "icegiant", "ringed",
"crystal", "paper", "neon", "duality", "rock", "ghost")
ENTERS = ("push", "zoom", "rise", "warp", "orbit")
KINDS = ("主宇宙", "原创", "二创")
def _look(v, where):
"""星系图外观:后台能改 style / accent / enter;其余高级字段(位置、卫星、配色、半径)原样保留但要合法。"""
v = v if isinstance(v, dict) else {}
out = {}
st = str(v.get("style") or "earth")
if st not in STYLES:
raise Bad("%s 的星球风格不认识:%s" % (where, st))
out["style"] = st
ac = str(v.get("accent") or "#FFD36E")
if not HEX.match(ac):
raise Bad("%s 的主色要写成 #RRGGBB" % where)
out["accent"] = ac.upper()
en = v.get("enter")
if en:
if en not in ENTERS:
raise Bad("%s 的入场运镜不认识:%s" % (where, en))
out["enter"] = en
if v.get("r") not in (None, ""):
out["r"] = _num(v["r"], 0.4, 3.5, where + " 的大小")
if v.get("orbit") not in (None, "", []):
o = v["orbit"]
if not (isinstance(o, list) and len(o) == 2):
raise Bad("%s 的位置格式不对" % where)
out["orbit"] = [_num(o[0], 0, 80, where + " 的位置"), _num(o[1], 0, 7, where + " 的旋臂", integer=True)]
if v.get("colors"):
cs = _list(v["colors"], where + " 的配色", 4)
if not all(isinstance(c, str) and HEX.match(c) for c in cs):
raise Bad("%s 的配色要写成 #RRGGBB" % where)
out["colors"] = cs
if v.get("why"):
out["why"] = _s(v["why"], 160, where + " 的说明")
moons = []
for k, m in enumerate(_list(v.get("moons"), where + " 的卫星", 4)):
m = m if isinstance(m, dict) else {}
mm = {"style": m.get("style") if m.get("style") in STYLES else "rock",
"r": _num(m.get("r", 0.3), 0.1, 1.2, where + " 的卫星大小"),
"d": _num(m.get("d", 2.6), 1.2, 9, where + " 的卫星距离")}
if m.get("speed") not in (None, ""):
mm["speed"] = _num(m["speed"], 0.05, 2, where + " 的卫星速度")
if m.get("colors"):
cs = _list(m["colors"], where + " 的卫星配色", 4)
if all(isinstance(c, str) and HEX.match(c) for c in cs):
mm["colors"] = cs
moons.append(mm)
if moons:
out["moons"] = moons
return out
def normalize_site(d):
d = d if isinstance(d, dict) else {}
out = {"v": 1}
h = d.get("hero") if isinstance(d.get("hero"), dict) else {}
n = h.get("notice") if isinstance(h.get("notice"), dict) else {}
out["hero"] = {"tagline": _s(h.get("tagline"), 160, "首屏那句话"),
"cta1": _s(h.get("cta1"), 12, "主按钮文字"), "cta2": _s(h.get("cta2"), 12, "次按钮文字"),
"notice": {"on": _b(n.get("on")), "text": _s(n.get("text"), 80, "公告内容"),
"from": _date(n.get("from"), "公告开始日期"), "to": _date(n.get("to"), "公告结束日期")}}
if out["hero"]["notice"]["on"] and not out["hero"]["notice"]["text"]:
raise Bad("公告打开了,但公告内容是空的")
bd = d.get("boards") if isinstance(d.get("boards"), dict) else {}
out["boards"] = {k: _s(bd.get(k), 120, "板块说明(%s)" % k) for k in BOARD_IDS if bd.get(k)}
gal, ids = [], set()
for i, g in enumerate(_list(d.get("gallery"), "画展", 2000)):
g = g if isinstance(g, dict) else {}
w = "画展第 %d 件(%s)" % (i + 1, str(g.get("title") or "")[:20])
t = g.get("type") if g.get("type") in GTYPES else "image"
e = {"id": _id(g.get("id"), "g"), "type": t, "date": _date(g.get("date"), w + " 的日期", allow_empty=False),
"title": _s(g.get("title"), 60, w + " 的标题", required=True), "desc": _s(g.get("desc"), 300, w + " 的说明"),
"owner": "gift" if g.get("owner") == "gift" else "own", "hidden": _b(g.get("hidden"))}
while e["id"] in ids:
e["id"] = "g" + secrets.token_hex(4)
ids.add(e["id"])
if g.get("src"):
e["src"] = _path(g["src"], w + " 的图片")
if g.get("thumb"):
e["thumb"] = _path(g["thumb"], w + " 的缩略图")
if g.get("poster"):
e["poster"] = _path(g["poster"], w + " 的封面")
if g.get("r") not in (None, ""):
e["r"] = _num(g["r"], 0.1, 10, w + " 的宽高比")
if t == "video":
e["url"] = _url(g.get("url"), w + " 的视频链接")
if g.get("bvid"):
b = str(g["bvid"]).strip()
if not BVID.match(b):
raise Bad("%s 的 BV 号格式不对" % w)
e["bvid"] = b
m = re.search(r"(BV[0-9A-Za-z]{10})", e["url"])
if m and "bvid" not in e:
e["bvid"] = m.group(1)
if g.get("web"):
e["web"] = _path(g["web"], w + " 的网页版视频")
local = bool(re.search(r"\.(mp4|webm)$", e.get("src", ""), re.I))
if not e["url"] and "bvid" not in e and not local:
raise Bad("%s 是视频,要填 B 站链接(或用本站的 .mp4 文件)" % w)
elif not e.get("src") and t != "wall":
raise Bad("%s 还没有图片" % w)
if g.get("frames"):
e["frames"] = [{"src": _path((f or {}).get("src"), w + " 的帧", allow_empty=False),
"label": _s((f or {}).get("label"), 20, w + " 的帧标签")}
for f in _list(g["frames"], w + " 的帧", 60)]
if g.get("link"):
e["link"] = _url(g["link"], w + " 的外链")
if g.get("links"):
e["links"] = [x for x in (_url(u, w + " 的外链") for u in _list(g["links"], w + " 的外链", 8)) if x]
if t == "wall" and not e.get("frames") and not e.get("src"):
raise Bad("%s 是动态壁纸,至少要有一帧" % w)
gal.append(e)
out["gallery"] = gal
media = {}
md = d.get("media") if isinstance(d.get("media"), dict) else {}
if len(md) > 5000:
raise Bad("媒体索引太大了(超过 5000 条)")
for k, v in md.items():
v = v if isinstance(v, dict) else {}
m = {}
if v.get("t"):
m["t"] = _path(v["t"], "媒体索引(%s)的缩略图" % str(k)[:40])
if v.get("r") not in (None, ""):
m["r"] = _num(v["r"], 0.05, 20, "媒体索引(%s)的宽高比" % str(k)[:40])
if m:
media[_path(k, "媒体索引的文件")] = m
if media:
out["media"] = media
apps = []
for i, a in enumerate(_list(d.get("apps"), "工具与开源", 100)):
a = a if isinstance(a, dict) else {}
w = "工具第 %d 个(%s)" % (i + 1, str(a.get("name") or "")[:16])
e = {"id": _id(a.get("id"), "a"), "name": _s(a.get("name"), 30, w + " 的名称", required=True),
"en": _s(a.get("en"), 40, w + " 的英文名"), "type": _s(a.get("type"), 12, w + " 的类型"),
"oss": _b(a.get("oss")), "desc": _s(a.get("desc"), 300, w + " 的介绍"),
"ver": _s(a.get("ver"), 24, w + " 的版本"), "size": _s(a.get("size"), 16, w + " 的大小"),
"status": _s(a.get("status"), 12, w + " 的状态"),
"url": _url(a.get("url"), w + " 的链接", allow_site=True),
"repo": _url(a.get("repo"), w + " 的仓库链接")}
if a.get("btn"):
e["btn"] = _s(a["btn"], 16, w + " 的按钮文字")
if _b(a.get("web")):
e["web"] = True
apps.append(e)
out["apps"] = apps
groups, gids = [], set()
for i, g in enumerate(_list(d.get("linkGroups"), "平台分组", 20)):
g = g if isinstance(g, dict) else {}
gid = str(g.get("id") or "").strip().lower()
if not SLUG.match(gid) or gid in gids:
raise Bad("平台分组第 %d 个的 id 不合法或重复" % (i + 1))
gids.add(gid)
groups.append({"id": gid, "name": _s(g.get("name"), 12, "平台分组名", required=True), "en": _s(g.get("en"), 20, "平台分组英文名")})
out["linkGroups"] = groups
links = []
for i, l in enumerate(_list(d.get("links"), "平台入口", 100)):
l = l if isinstance(l, dict) else {}
w = "平台入口第 %d 个(%s)" % (i + 1, str(l.get("name") or "")[:16])
if l.get("group") not in gids:
raise Bad("%s 的分组不存在" % w)
links.append({"id": _id(l.get("id"), "l"), "group": l["group"], "key": _id(l.get("key"), "k"),
"name": _s(l.get("name"), 20, w + " 的名称", required=True), "en": _s(l.get("en"), 24, w + " 的英文名"),
"desc": _s(l.get("desc"), 40, w + " 的说明"),
"url": _url(l.get("url"), w + " 的链接", allow_mail=True, allow_empty=False)})
out["links"] = links
ab = d.get("about") if isinstance(d.get("about"), dict) else {}
out["about"] = {"story": _s(ab.get("story"), 1200, "名字的由来"), "foot": _s(ab.get("foot"), 200, "页脚那句话"),
"cards": [{"k": _s((c or {}).get("k"), 16, "署名卡片的小标题"), "h": _s((c or {}).get("h"), 30, "署名卡片的名字", required=True),
"p": _s((c or {}).get("p"), 600, "署名卡片的内容")} for c in _list(ab.get("cards"), "署名卡片", 20)]}
un = d.get("universe") if isinstance(d.get("universe"), dict) else {}
items, nos = [], set()
for i, u in enumerate(_list(un.get("items"), "世界线", 40)):
u = u if isinstance(u, dict) else {}
no = str(u.get("no") or "")
w = "世界线 %s" % (no or "第 %d 条" % (i + 1))
if not re.match(r"^\d{4}$", no) or no in nos:
raise Bad("%s 的编号要是 4 位数字且不能重复" % w)
nos.add(no)
kind = u.get("kind") if u.get("kind") in KINDS else "原创"
tags = [_s(t, 12, w + " 的标签") for t in _list(u.get("tags"), w + " 的标签", 10)]
items.append({"no": no, "name": _s(u.get("name"), 12, w + " 的名字", required=True), "kind": kind,
"tag": _s(u.get("tag"), 24, w + " 的一句话"), "desc": _s(u.get("desc"), 600, w + " 的简介"),
"tags": [t for t in tags if t], "look": _look(u.get("look"), w)})
tone = str(u.get("tone") or "").strip() # 卡片 / 首页小机架上的主色(老数据带的,保留)
if tone:
if not HEX.match(tone):
raise Bad("%s 的主色要写成 #RRGGBB" % w)
items[-1]["tone"] = tone
for k, lim, nm in (("sector", 12, "扇区"), ("media", 24, "介质")):
if u.get(k):
items[-1][k] = _s(u.get(k), lim, w + " 的" + nm)
items.sort(key=lambda x: x["no"])
out["universe"] = {"items": items, "empty": _num(un.get("empty", 6), 0, 20, "空槽数", integer=True)}
return out
def normalize_order(d, tpl_keys):
d = d if isinstance(d, dict) else {}
n = d.get("notice") if isinstance(d.get("notice"), dict) else {}
out = {"v": 1, "head": _s(d.get("head"), 80, "下单页页头那句话"),
"notice": {"on": _b(n.get("on")), "text": _s(n.get("text"), 120, "下单页公告")}}
if out["notice"]["on"] and not out["notice"]["text"]:
raise Bad("下单页公告打开了,但内容是空的")
seen, tpls = set(), []
for t in _list(d.get("templates"), "模板", 40):
t = t if isinstance(t, dict) else {}
k = t.get("k")
if k not in tpl_keys or k in seen:
raise Bad("模板 key 不认识或重复:%s(key 要和渲染机一致,后台不能新增)" % k)
seen.add(k)
tpls.append({"k": k, "n": _s(t.get("n"), 12, "模板 %s 的名字" % k, required=True), "s": _s(t.get("s"), 24, "模板 %s 的说明" % k),
"on": t.get("on") is not False and t.get("on") not in ("0", "false")})
if tpls and not any(t["on"] for t in tpls):
raise Bad("至少要留一个模板上架")
out["templates"] = tpls
pr = d.get("prices") if isinstance(d.get("prices"), dict) else {}
tiers, tn = [], set()
for t in _list(pr.get("tiers"), "价格档位", 10):
t = t if isinstance(t, dict) else {}
k = _num(t.get("n"), 1, 10, "价格档位的张数", integer=True)
if k in tn:
raise Bad("价格档位里 %d 张写了两次" % k)
tn.add(k)
tiers.append({"n": k, "price": _num(t.get("price"), 0, 9999, "%d 张的价格" % k), "url": _url(t.get("url"), "%d 张的爱发电链接" % k)})
tiers.sort(key=lambda x: x["n"])
out["prices"] = {"per": _num(pr.get("per", 6), 0.01, 9999, "单价"), "tiers": tiers}
pay = d.get("pay") if isinstance(d.get("pay"), dict) else {}
uid = _s(pay.get("payplatform_uid"), 40, "爱发电创作者 ID")
if uid and not re.match(r"^[A-Za-z0-9_-]+$", uid):
raise Bad("爱发电创作者 ID 只能是字母数字")
qr = _s(pay.get("qr_img"), 120, "收款码图片")
if qr and (".." in qr or qr.startswith("/") or not re.match(r"^[A-Za-z0-9_\-./]+$", qr)):
raise Bad("收款码图片路径不对")
out["pay"] = {"payplatform": _url(pay.get("payplatform"), "爱发电主页链接"), "payplatform_uid": uid,
"qr_img": qr, "note": _s(pay.get("note"), 200, "付款说明")}
return out
def normalize(doc, tpl_keys):
doc = doc if isinstance(doc, dict) else {}
return {"site": normalize_site(doc.get("site")), "order": normalize_order(doc.get("order"), tpl_keys)}
def diff_summary(a, b):
"""两份内容差在哪:[(板块名, 新增, 改了, 删了)],给发布弹窗和发布记录用。"""
a, b = a or {}, b or {}
sa, sb, oa, ob = a.get("site") or {}, b.get("site") or {}, a.get("order") or {}, b.get("order") or {}
out = []
def lst(name, x, y, key):
X = {str(i.get(key)): json.dumps(i, sort_keys=True, ensure_ascii=False) for i in (x or [])}
Y = {str(i.get(key)): json.dumps(i, sort_keys=True, ensure_ascii=False) for i in (y or [])}
add = len([k for k in Y if k not in X]); dele = len([k for k in X if k not in Y])
mod = len([k for k in Y if k in X and X[k] != Y[k]])
order_changed = [k for k in X if k in Y] != [k for k in Y if k in X]
if add or dele or mod or order_changed:
out.append((name, add, mod + (1 if order_changed and not mod else 0), dele))
def obj(name, x, y):
if json.dumps(x, sort_keys=True, ensure_ascii=False) != json.dumps(y, sort_keys=True, ensure_ascii=False):
keys = set((x or {}).keys()) | set((y or {}).keys())
n = sum(1 for k in keys if json.dumps((x or {}).get(k), sort_keys=True) != json.dumps((y or {}).get(k), sort_keys=True))
out.append((name, 0, max(1, n), 0))
obj("首页文案", sa.get("hero"), sb.get("hero"))
obj("板块说明", sa.get("boards"), sb.get("boards"))
lst("画展", sa.get("gallery"), sb.get("gallery"), "id")
lst("工具与开源", sa.get("apps"), sb.get("apps"), "id")
ua, ub = sa.get("universe") or {}, sb.get("universe") or {}
lst("金钻宇宙", ua.get("items"), ub.get("items"), "no")
if ua.get("empty") != ub.get("empty"):
out.append(("金钻宇宙 · 空槽", 0, 1, 0))
lst("平台分组", sa.get("linkGroups"), sb.get("linkGroups"), "id")
lst("平台入口", sa.get("links"), sb.get("links"), "id")
obj("关于", sa.get("about"), sb.get("about"))
lst("下单页模板", oa.get("templates"), ob.get("templates"), "k")
obj("下单页文字", {"head": oa.get("head"), "notice": oa.get("notice")}, {"head": ob.get("head"), "notice": ob.get("notice")})
obj("价格档位", oa.get("prices"), ob.get("prices"))
obj("付款方式", oa.get("pay"), ob.get("pay"))
return out
def diff_text(rows):
return ";".join("%s %s" % (n, " · ".join(x for x in ["新增 %d" % a if a else "", "改了 %d" % m if m else "", "删了 %d" % d if d else ""] if x))
for n, a, m, d in rows) or "没有改动"
# ============================================================ 给网站用的内容文件
def _js_literal(obj):
"""JSON 嵌进 <script> 也安全:</ 和行分隔符转义掉。"""
s = json.dumps(obj, ensure_ascii=False, separators=(",", ":"))
return s.replace("</", "<\\/").replace("\u2028", "\\u2028").replace("\u2029", "\\u2029").replace("<!--", "<\\!--")
def site_payload(site):
"""site.json → 门户读的 window.JZ_CONTENT(宇宙部分转成星系图 config 的格式)。"""
u = site.get("universe") or {}
items = u.get("items") or []
nos = [int(x["no"]) for x in items]
nxt = (max(nos) + 1) if nos else 0
UNIVERSES = [dict({"no": x["no"], "name": x["name"], "kind": x["kind"], "tag": x["tag"], "desc": x["desc"], "tags": x["tags"]},
**{k: x[k] for k in ("tone", "sector", "media") if x.get(k)}) for x in items]
UNIVERSES += [{"no": "%04d" % (nxt + k), "empty": True} for k in range(int(u.get("empty") or 0))]
LOOKS = {x["no"]: x["look"] for x in items}
media = {k: dict(v) for k, v in (site.get("media") or {}).items()} # 离线索引打底,作品自带的宽高比 / 缩略图覆盖上去
for g in site.get("gallery") or []:
if g.get("src") and (g.get("thumb") or g.get("r")):
m = media.get(g["src"], {})
if g.get("r"):
m["r"] = g["r"]
if g.get("thumb"):
m["t"] = g["thumb"]
media[g["src"]] = m
return {"v": 1, "hero": site.get("hero"), "boards": site.get("boards"), "gallery": [g for g in site.get("gallery") or [] if not g.get("hidden")],
"media": media, "apps": site.get("apps"), "linkGroups": site.get("linkGroups"), "links": site.get("links"),
"about": site.get("about"), "universe": {"UNIVERSES": UNIVERSES, "LOOKS": LOOKS}}
def order_payload(order):
return {"v": 1, "head": order.get("head"), "notice": order.get("notice"), "templates": order.get("templates")}
def _atomic_write(path, data, mode=0o644):
d = os.path.dirname(path)
os.makedirs(d, exist_ok=True)
fd, tmp = tempfile.mkstemp(prefix=os.path.basename(path) + ".", suffix=".tmp", dir=d)
try:
with os.fdopen(fd, "wb") as f:
f.write(data if isinstance(data, bytes) else data.encode("utf-8"))
f.flush()
os.fsync(f.fileno())
os.chmod(tmp, mode)
os.replace(tmp, path)
except BaseException:
try:
os.unlink(tmp)
except OSError:
pass
raise
# ============================================================ 图片核验(PNG 走 pngcheck;JPEG / WebP 在这里做结构检查 + 剥元数据)
def _jpeg_clean(b):
if b[:2] != b"\xff\xd8":
return None, "不是 JPEG"
out, i, w, h = bytearray(b"\xff\xd8"), 2, 0, 0
while i < len(b):
if b[i] != 0xFF:
return None, "JPEG 结构损坏"
while i < len(b) and b[i] == 0xFF:
i += 1
if i >= len(b):
return None, "JPEG 截断"
m = b[i]; i += 1
if m == 0xD9:
out += b"\xff\xd9"
if i != len(b):
return None, "图片结尾后面还夹带了 %d 字节" % (len(b) - i)
return bytes(out), (w, h)
if 0xD0 <= m <= 0xD7 or m == 0x01:
out += bytes([0xFF, m]); continue
if i + 2 > len(b):
return None, "JPEG 截断"
L = struct.unpack(">H", b[i:i + 2])[0]
seg = b[i:i + L]
if len(seg) < L or L < 2:
return None, "JPEG 截断"
if m in (0xC0, 0xC1, 0xC2, 0xC3, 0xC5, 0xC6, 0xC7, 0xC9, 0xCA, 0xCB, 0xCD, 0xCE, 0xCF) and L >= 7:
h, w = struct.unpack(">HH", seg[3:7])
keep = not ((0xE1 <= m <= 0xEF) or m == 0xFE) # 剥掉 APP1..APP15(EXIF/XMP/…)和注释,留 APP0(JFIF)
if m == 0xE2 and seg[2:14] == b"ICC_PROFILE\x00":
keep = True # 颜色配置留着,不然颜色会变
if keep:
out += bytes([0xFF, m]) + seg
i += L
if m == 0xDA: # 扫描数据:一直拷到下一个非 RST 的标记
j = i
while j < len(b) - 1:
if b[j] == 0xFF and b[j + 1] not in (0x00,) and not (0xD0 <= b[j + 1] <= 0xD7):
break
j += 1
out += b[i:j]; i = j
return None, "JPEG 没有结尾"
def _webp_clean(b):
if len(b) < 20 or b[:4] != b"RIFF" or b[8:12] != b"WEBP":
return None, "不是 WebP"
size = struct.unpack("<I", b[4:8])[0]
if size + 8 != len(b):
return None, "WebP 长度对不上(可能尾部夹带了数据)"
i, chunks, w, h = 12, [], 0, 0
while i + 8 <= len(b):
fourcc, L = b[i:i + 4], struct.unpack("<I", b[i + 4:i + 8])[0]
body = b[i + 8:i + 8 + L]
if len(body) < L:
return None, "WebP 截断"
if fourcc in (b"ANIM", b"ANMF"):
return None, "不收动图 WebP"
if fourcc == b"VP8 " and L >= 10:
w, h = struct.unpack("<HH", body[6:10]); w &= 0x3FFF; h &= 0x3FFF
elif fourcc == b"VP8L" and L >= 5:
v = struct.unpack("<I", body[1:5])[0]; w, h = (v & 0x3FFF) + 1, ((v >> 14) & 0x3FFF) + 1
elif fourcc == b"VP8X" and L >= 10:
w = 1 + int.from_bytes(body[4:7], "little"); h = 1 + int.from_bytes(body[7:10], "little")
if fourcc not in (b"EXIF", b"XMP "):
chunks.append((fourcc, body))
i += 8 + L + (L & 1)
if i != len(b):
return None, "WebP 结构损坏"
out = bytearray()
for fourcc, body in chunks:
if fourcc == b"VP8X":
body = bytes([body[0] & ~0x0C]) + body[1:] # 去掉 EXIF / XMP 标志位
out += fourcc + struct.pack("<I", len(body)) + body + (b"\x00" if len(body) & 1 else b"")
return b"RIFF" + struct.pack("<I", len(out) + 4) + b"WEBP" + bytes(out), (w, h)
# ============================================================ 主体
class CMS(object):
def __init__(self, store, data_root, log, prices_file, payinfo_file, tpl_keys, pngcheck=None):
self.store, self.root, self.log = store, data_root, log
self.prices_file, self.payinfo_file = prices_file, payinfo_file
self.tpl_keys = tuple(tpl_keys)
self.pngcheck = pngcheck
self.lock = threading.Lock() # 草稿 / 发布 / 回滚串行
self.fails = {} # 登录失败:key -> [时间戳]
self.fail_lock = threading.Lock()
self.uploads = {} # 上传限频:uid -> [时间戳]
# 算一次 scrypt 要 16MB 内存:这台机器服务进程上限 256M,同时最多算 2 个,免得一波并发登录把进程撑爆
self.hash_sem = threading.BoundedSemaphore(2)
c = store.conn()
c.executescript(_SCHEMA)
with store.tx() as c: # 一个账号都没有 → 建初始账号(BEGIN IMMEDIATE:两个进程同时首启也只建一个)
if not c.execute("SELECT 1 FROM cms_users LIMIT 1").fetchone():
c.execute("INSERT INTO cms_users (username, email, pw, must_change, created) VALUES ('admin', NULL, ?, 1, ?)",
(hash_pw("admin"), time.time()))
c.execute("INSERT INTO cms_audit (at, who, ip, what) VALUES (?, 'system', '-', ?)",
(time.time(), "首次启动:建了初始账号 admin(首次登录必须改密码)"))
log("内容后台:建了初始账号 admin / admin —— ⚠️ 部署后马上登录改密码")
# ---------------------------------------------------------------- 账号(命令行也调这些)
def user_row(self, who):
who = (who or "").strip()
return self.store.conn().execute(
"SELECT id, username, email, pw, must_change, disabled, last_login, last_ip FROM cms_users WHERE username=? OR (email IS NOT NULL AND lower(email)=lower(?))",
(who, who)).fetchone()
def user_add(self, username, password, email=None, must_change=False):
if not re.match(r"^[A-Za-z0-9_.-]{2,32}$", username or ""):
raise Bad("用户名只能是 2–32 位字母、数字、点、横线、下划线")
if email and not re.match(r"^[^\s@<>\"']+@[^\s@<>\"']+\.[^\s@<>\"']+$", email):
raise Bad("邮箱格式不对")
p = pw_problem(password)
if p and not must_change:
raise Bad(p)
with self.store.tx() as c:
if c.execute("SELECT 1 FROM cms_users WHERE username=? OR (email IS NOT NULL AND lower(email)=lower(?))", (username, email or "")).fetchone():
raise Bad("用户名或邮箱已经有人用了")
c.execute("INSERT INTO cms_users (username, email, pw, must_change, created) VALUES (?,?,?,?,?)",
(username, email or None, hash_pw(password), 1 if must_change else 0, time.time()))
self.audit("命令行", "-", "建了账号 %s" % username)
def user_set_password(self, who, password, must_change=False, keep_th=None):
r = self.user_row(who)
if not r:
raise Bad("没有这个账号:%s" % who)
with self.store.tx() as c:
c.execute("UPDATE cms_users SET pw=?, must_change=? WHERE id=?", (hash_pw(password), 1 if must_change else 0, r[0]))
if keep_th:
c.execute("DELETE FROM cms_sessions WHERE uid=? AND th<>?", (r[0], keep_th))
else:
c.execute("DELETE FROM cms_sessions WHERE uid=?", (r[0],))
return r[1]
def user_reset(self, who, to_admin=False):
"""忘了密码:作废所有会话 → 临时密码 → 下次登录必须改。返回临时密码(只给命令行打印)。"""
tmp = "admin" if to_admin else secrets.token_urlsafe(9)
name = self.user_set_password(who, tmp, must_change=True)
self.audit("命令行", "-", "重置了 %s 的密码(所有会话已作废,下次登录必须改)" % name)
return tmp
def user_disable(self, who, off=True):
r = self.user_row(who)
if not r:
raise Bad("没有这个账号:%s" % who)
with self.store.tx() as c:
c.execute("UPDATE cms_users SET disabled=? WHERE id=?", (1 if off else 0, r[0]))
if off:
c.execute("DELETE FROM cms_sessions WHERE uid=?", (r[0],))
self.audit("命令行", "-", ("停用" if off else "启用") + "了账号 %s" % r[1])
def users(self):
return [{"user": r[0], "email": r[1], "must_change": bool(r[2]), "disabled": bool(r[3]), "last_login": r[4], "last_ip": r[5],
"sessions": r[6]} for r in self.store.conn().execute(
"SELECT username, email, must_change, disabled, last_login, last_ip, (SELECT COUNT(*) FROM cms_sessions s WHERE s.uid=u.id AND s.expires>?) FROM cms_users u ORDER BY id",
(time.time(),))]
def sessions_of(self, uid):
return [{"id": r[0][:12], "created": r[1], "last": r[2], "ip": r[3], "ua": r[4], "remember": bool(r[5]), "th": r[0]}
for r in self.store.conn().execute("SELECT th, created, last, ip, ua, remember FROM cms_sessions WHERE uid=? AND expires>? ORDER BY last DESC",
(uid, time.time()))]
def revoke_all(self, who):
r = self.user_row(who)
if not r:
raise Bad("没有这个账号:%s" % who)
with self.store.tx() as c:
n = c.execute("DELETE FROM cms_sessions WHERE uid=?", (r[0],)).rowcount
self.audit("命令行", "-", "踢掉了 %s 的 %d 个会话" % (r[1], n))
return n
def audit(self, who, ip, what):
with self.store.tx() as c:
c.execute("INSERT INTO cms_audit (at, who, ip, what) VALUES (?,?,?,?)", (time.time(), who, ip, what[:300]))
# ---------------------------------------------------------------- 登录限频
def _cooldown(self, keys):
now = time.time()
with self.fail_lock:
worst = 0
for k in keys:
arr = [t for t in self.fails.get(k, []) if now - t < FAIL_WIN]
self.fails[k] = arr
free = FAIL_FREE_IP if k.startswith("ip:") else FAIL_FREE_USER
if len(arr) >= free:
wait = min(FAIL_WIN, 30 * 2 ** min(10, len(arr) - free)) - (now - arr[-1])
worst = max(worst, wait)
return int(worst + 0.999) if worst > 0 else 0
def _fail(self, keys):
now = time.time()
with self.fail_lock:
for k in keys:
self.fails.setdefault(k, []).append(now)
if len(self.fails) > 2000: # 被大量 IP 扫的时候:把过了窗口期的记录清掉,内存不跟着涨
for k in [k for k, v in self.fails.items() if not v or now - v[-1] > FAIL_WIN]:
self.fails.pop(k, None)
# ---------------------------------------------------------------- 内容
def dirs_ok(self):
"""门户 / 下单页目录配好了没有。没配好就**什么都不写**:不然会在当前目录建个叫 <PORTAL_DIR> 的怪目录,
第一版内容还会是空骨架 —— 店主一发布,网站内容就被清空。"""
for name, d in (("YS_PORTAL_DIR", PORTAL_DIR), ("YS_ORDER_DIR", ORDER_DIR)):
if not d or d.startswith("<") or not os.path.isdir(d):
raise Bad("服务器没配好 %s(现在是「%s」)—— 内容后台先不能用,请照交接文档 7.1b 配好再重启" % (name, d))
def _seed(self):
"""第一次用:把网站现在的内容文件当成第 1 版。门户的 content/site.json 必须在(防止从空骨架开始、一发布就把网站清空)。"""
self.dirs_ok()
if not os.path.isfile(os.path.join(PORTAL_DIR, "content", "site.json")):
raise Bad("门户目录里没有 content/site.json —— 先把仓库里的 portal/content/ 放上去再用内容后台")
def jl(p):
try:
with open(p, encoding="utf-8") as f:
return json.load(f)
except (OSError, ValueError):
return None
site = jl(os.path.join(PORTAL_DIR, "content", "site.json")) or {}
order = jl(os.path.join(ORDER_DIR, "content", "order.json")) or {}
pr = jl(self.prices_file) or {}
pay = jl(self.payinfo_file) or {}
if not order.get("prices"):
tiers = [{"n": int(k), "price": (v or {}).get("price", 0), "url": (v or {}).get("payplatform", "")}
for k, v in (pr.get("tiers") or {}).items() if str(k).isdigit()]
order["prices"] = {"per": pr.get("per") or 6, "tiers": tiers}
if not order.get("pay"):
order["pay"] = {k: pay.get(k, "") for k in ("payplatform", "payplatform_uid", "qr_img", "note")}
try:
doc = normalize({"site": site, "order": order}, self.tpl_keys)
except Bad as e:
raise Bad("网站现有的内容文件不合格(%s)—— 修好再用内容后台" % e)
with self.store.tx() as c:
if not c.execute("SELECT 1 FROM cms_versions LIMIT 1").fetchone():
c.execute("INSERT INTO cms_versions (no, data, note, by, at, chg) VALUES (1, ?, '从网站现有内容导入', 'system', ?, '全部内容')",
(json.dumps(doc, ensure_ascii=False), time.time()))
def current(self):
r = self.store.conn().execute("SELECT no, data FROM cms_versions ORDER BY no DESC LIMIT 1").fetchone()
if not r:
self._seed()
r = self.store.conn().execute("SELECT no, data FROM cms_versions ORDER BY no DESC LIMIT 1").fetchone()
return r[0], json.loads(r[1])
def draft(self):
r = self.store.conn().execute("SELECT data, base, updated, by FROM cms_draft WHERE k='doc'").fetchone()
return (json.loads(r[0]), r[1], r[2], r[3]) if r else (None, None, None, None)
def write_files(self, doc, prev=None):
"""prev = 网站上现在那一版。价格档位 / 付款方式**只有这次真的改了**才写回 prices.json / payinfo.json ——
不然有人用 admin.py price 在命令行改过价格,店主随便发布一张画就会把它悄悄改回去。"""
self.dirs_ok()
site, order = doc["site"], doc["order"]
po = (prev or {}).get("order") or {}
write_prices = prev is None or po.get("prices") != order["prices"]
write_pay = prev is None or po.get("pay") != order["pay"]
stamp = datetime.now(CST).strftime("%Y-%m-%d %H:%M")
head = "/* 由内容后台发布生成(%s)。别手改:下次发布会被覆盖。改内容请用内容后台。 */\n" % stamp
_atomic_write(os.path.join(PORTAL_DIR, "content", "site.json"), json.dumps(site, ensure_ascii=False, indent=1))
_atomic_write(os.path.join(PORTAL_DIR, "content", "site.js"), head + "window.JZ_CONTENT = " + _js_literal(site_payload(site)) + ";\n")
_atomic_write(os.path.join(ORDER_DIR, "content", "order.json"), json.dumps(order, ensure_ascii=False, indent=1))
_atomic_write(os.path.join(ORDER_DIR, "content", "order.js"), head + "window.JZ_ORDER = " + _js_literal(order_payload(order)) + ";\n")
# 价格档位 / 付款方式:写回 server.py 原来就读的两个文件(下单逻辑不用改;文件里别的字段原样保留)
def jl(p):
try:
with open(p, encoding="utf-8") as f:
v = json.load(f)
return v if isinstance(v, dict) else {}
except (OSError, ValueError):
return {}
if write_prices:
pr = jl(self.prices_file)
pr["per"] = order["prices"]["per"]
pr["tiers"] = {str(t["n"]): {"price": t["price"], "payplatform": t["url"]} for t in order["prices"]["tiers"]}
_atomic_write(self.prices_file, json.dumps(pr, ensure_ascii=False, indent=1), 0o640)
if write_pay:
pay = jl(self.payinfo_file)
pay.update(order["pay"])
_atomic_write(self.payinfo_file, json.dumps(pay, ensure_ascii=False, indent=1), 0o640)
def publish(self, who, ip, doc, note, base):
with self.lock:
cur_no, cur = self.current()
if base is not None and int(base) != cur_no:
raise Bad("CONFLICT:别人已经发布了 v%d,你的草稿是基于 v%s 改的。先刷新看看对方改了什么,再决定" % (cur_no, base))
rows = diff_summary(cur, doc)
if not rows:
raise Bad("草稿和网站上的一模一样,没有要发布的")
self.write_files(doc, cur)
no = cur_no + 1
with self.store.tx() as c:
c.execute("INSERT INTO cms_versions (no, data, note, by, at, chg) VALUES (?,?,?,?,?,?)",
(no, json.dumps(doc, ensure_ascii=False), (note or "")[:60], who, time.time(), diff_text(rows)[:300]))
c.execute("DELETE FROM cms_draft WHERE k='doc'")
c.execute("INSERT INTO cms_audit (at, who, ip, what) VALUES (?,?,?,?)", (time.time(), who, ip, ("发布 v%d:%s" % (no, note or diff_text(rows)))[:300]))
self.log("内容后台:%s 发布了 v%d(%s)" % (who, no, diff_text(rows)))
return no, rows
# ---------------------------------------------------------------- 上传
def save_upload(self, uid, name, data_url):
self.dirs_ok()
now = time.time()
arr = [t for t in self.uploads.get(uid, []) if now - t < 3600]
if len(arr) >= 120:
raise Bad("这一小时传得太多了,歇一会儿再传")
m = re.match(r"^data:image/(png|jpeg|jpg|webp);base64,(.+)$", data_url or "", re.S)
if not m:
raise Bad("只收 PNG / JPEG / WebP 图片")
try:
raw = base64.b64decode(m.group(2), validate=False)
except Exception:
raise Bad("图片数据坏了")
if len(raw) > UPLOAD_MAX:
raise Bad("图片太大了(最多 %d MB)" % (UPLOAD_MAX // 1024 // 1024))
if raw[:8] == b"\x89PNG\r\n\x1a\n":
if not self.pngcheck:
raise Bad("服务器没装 PNG 核验")
ok, why, clean, _notes = self.pngcheck.scan(raw)
if not ok:
raise Bad("图片没通过安全核验:%s" % why)
wh = self.pngcheck.size_of(clean)
if not wh:
raise Bad("图片没通过安全核验:读不出尺寸")
(w, h), ext = wh, "png"
elif raw[:2] == b"\xff\xd8":
clean, wh = _jpeg_clean(raw)
if clean is None:
raise Bad("图片没通过安全核验:%s" % wh)
(w, h), ext = wh, "jpg"
elif raw[:4] == b"RIFF":
clean, wh = _webp_clean(raw)
if clean is None:
raise Bad("图片没通过安全核验:%s" % wh)
(w, h), ext = wh, "webp"
else:
raise Bad("只收 PNG / JPEG / WebP 图片")
if not (16 <= w <= 12000 and 16 <= h <= 12000):
raise Bad("图片尺寸不对(%d×%d)" % (w, h))
sub = datetime.now(CST).strftime("%Y%m")
fid = secrets.token_hex(6)
rel = "uploads/%s/%s.%s" % (sub, fid, ext)
full = os.path.join(PORTAL_DIR, rel)
_atomic_write(full, clean)
# 缩略图:ffmpeg 一次只处理这一张(服务器允许的量);失败就直接用原图当缩略图
trel = "uploads/%s/%s.t.jpg" % (sub, fid)
try:
r = subprocess.run(["ffmpeg", "-y", "-loglevel", "error", "-threads", "1", "-i", full,
"-vf", "scale='min(%d,iw)':-2" % THUMB_W, "-frames:v", "1", "-q:v", "4",
"-map_metadata", "-1", os.path.join(PORTAL_DIR, trel)], capture_output=True, timeout=60)
if r.returncode != 0 or not os.path.exists(os.path.join(PORTAL_DIR, trel)):
raise RuntimeError((r.stderr or b"")[-200:].decode("utf-8", "replace"))
except Exception as e:
self.log("内容后台:缩略图没做出来,用原图代替(%s)" % e)
trel = rel
arr.append(now); self.uploads[uid] = arr
return {"src": rel, "thumb": trel, "w": w, "h": h, "r": round(w / float(h), 4), "name": (name or "")[:60]}
# ---------------------------------------------------------------- HTTP
def handle(self, h, method, path, query):
"""server.py 把 /api/cms/* 原样交过来。所有鉴权都在这一个入口里。"""
ip = (h.headers.get("X-Real-IP") or h.client_address[0] or "?").strip()
proto = (h.headers.get("X-Forwarded-Proto") or "").lower()
# 「服务器本机直连调试」= 没经过反代(反代一定会带 X-Real-IP / X-Forwarded-Proto)且来源是回环
direct_local = (not h.headers.get("X-Real-IP") and not h.headers.get("X-Forwarded-Proto")
and h.client_address[0] in ("127.0.0.1", "::1", "localhost"))
https = proto == "https"
if not https and not direct_local:
return self._reply(h, 403, {"ok": False, "error": "内容后台只能用 https 打开"})
ep = path[len("/api/cms/"):]
# 跨站来的修改请求一律拒(Cookie 已经是 SameSite=Strict,这里再兜一层)
if method == "POST":
org = h.headers.get("Origin")
host = (h.headers.get("X-Forwarded-Host") or h.headers.get("Host") or "").split(":")[0].lower()
ohost = re.sub(r"^https?://", "", org or "").split("/")[0].split(":")[0].lower()
if org and org != "null" and host and ohost != host:
return self._reply(h, 403, {"ok": False, "error": "来源不对"})
try:
if method == "POST" and ep == "login":
return self._login(h, ip, https)
sess = self._session(h)
if not sess:
return self._reply(h, 401, {"ok": False, "error": "请先登录", "login": True})
uid, uname, must, csrf, th = sess
if method == "POST" and not hmac.compare_digest(h.headers.get("X-CSRF") or "", csrf):
return self._reply(h, 403, {"ok": False, "error": "页面过期了,刷新一下再试"})
# ⚠️ 安全底线:还没改初始密码 → 只放行这三个
if must and ep not in ("me", "password", "logout"):
return self._reply(h, 403, {"ok": False, "error": "请先修改初始密码", "must_change": True})
fn = getattr(self, "_ep_" + method.lower() + "_" + ep.replace("/", "_").replace("-", "_").replace(".", "_"), None)
if not fn:
return self._reply(h, 404, {"ok": False, "error": "没有这个接口"})
body = None
if method == "POST":
body = self._body(h, limit=16 * 1024 * 1024 if ep == "upload" else 4 * 1024 * 1024)
if body is None:
return self._reply(h, 400, {"ok": False, "error": "请求内容不对或太大"})
return fn(h, dict(uid=uid, user=uname, must=must, csrf=csrf, th=th, ip=ip, https=https), query, body)
except Bad as e:
msg = str(e)
if msg.startswith("CONFLICT:"):
return self._reply(h, 409, {"ok": False, "error": msg[9:], "conflict": True})
return self._reply(h, 400, {"ok": False, "error": msg})
def _body(self, h, limit):
try:
n = int(h.headers.get("Content-Length") or 0)
except ValueError:
return None
if n <= 0 or n > limit:
if n > 0:
h.close_connection = True # 太大的就不读了,断开免得残留在连接里
return None
try:
v = json.loads(h.rfile.read(n).decode("utf-8"))
return v if isinstance(v, dict) else None
except (ValueError, UnicodeDecodeError):
return None
def _reply(self, h, code, obj=None, cookies=(), body=None, ctype="application/json; charset=utf-8"):
data = body if body is not None else json.dumps(obj, ensure_ascii=False).encode("utf-8")
h.send_response(code)
h.send_header("Content-Type", ctype)
h.send_header("Content-Length", str(len(data)))
h.send_header("Cache-Control", "no-store")
h.send_header("X-Content-Type-Options", "nosniff")
for c in cookies:
h.send_header("Set-Cookie", c)
h.end_headers()
if h.command != "HEAD":
h.wfile.write(data)
def _cookie(self, token, https, remember):
c = "%s=%s; Path=/; HttpOnly; SameSite=Strict" % (COOKIE, token)
if https:
c += "; Secure"
if remember:
c += "; Max-Age=%d" % (SESSION_DAYS * 86400)
return c
def _clear_cookie(self, https):
return "%s=; Path=/; HttpOnly; SameSite=Strict%s; Max-Age=0" % (COOKIE, "; Secure" if https else "")
def _session(self, h):
tok = None
for part in (h.headers.get("Cookie") or "").split(";"):
k, _, v = part.strip().partition("=")
if k == COOKIE:
tok = v.strip()
if not tok or len(tok) > 100:
return None
th = _th(tok)
c = self.store.conn()
r = c.execute("SELECT s.uid, u.username, u.must_change, s.csrf, s.expires, s.last, u.disabled FROM cms_sessions s JOIN cms_users u ON u.id=s.uid WHERE s.th=?",
(th,)).fetchone()
now = time.time()
if not r or r[4] < now or r[6]:
return None
if now - (r[5] or 0) > 60: # 滑动续期:最多一分钟写一次库
with self.store.tx() as cc:
cc.execute("UPDATE cms_sessions SET last=?, expires=? WHERE th=?", (now, now + SESSION_DAYS * 86400, th))
return r[0], r[1], bool(r[2]), r[3], th
def _login(self, h, ip, https):
d = self._body(h, 64 * 1024) or {}
who = str(d.get("user") or "").strip()[:100]
pw = str(d.get("password") or "")[:200]
keys = ["ip:" + ip, "user:" + who.lower()]
wait = self._cooldown(keys)
if wait:
return self._reply(h, 429, {"ok": False, "error": "错的次数太多了,%d 秒后再试" % wait, "wait": wait})
r = self.user_row(who) if who else None
with self.hash_sem:
ok = bool(r) and not r[5] and check_pw(pw, r[3])
if not r:
check_pw(pw, "scrypt$16384$8$1$AAAAAAAAAAAAAAAAAAAAAA==$AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=") # 账号不存在也算一遍,别让时间差暴露账号在不在
if not ok:
self._fail(keys)
self.audit(who or "?", ip, "登录失败")
return self._reply(h, 401, {"ok": False, "error": "账号或密码不对"})
with self.fail_lock:
for k in keys:
self.fails.pop(k, None)
tok, csrf, now = secrets.token_urlsafe(32), secrets.token_urlsafe(24), time.time()
remember = bool(d.get("remember"))
with self.store.tx() as c:
c.execute("INSERT INTO cms_sessions (th, uid, csrf, created, last, expires, remember, ip, ua) VALUES (?,?,?,?,?,?,?,?,?)",
(_th(tok), r[0], csrf, now, now, now + SESSION_DAYS * 86400, 1 if remember else 0, ip, (h.headers.get("User-Agent") or "")[:160]))
c.execute("UPDATE cms_users SET last_login=?, last_ip=? WHERE id=?", (now, ip, r[0]))
c.execute("DELETE FROM cms_sessions WHERE expires<?", (now,))
self.audit(r[1], ip, "登录" + ("(记住我)" if remember else ""))
return self._reply(h, 200, {"ok": True, "user": r[1], "email": r[2], "must_change": bool(r[4]), "csrf": csrf},
cookies=[self._cookie(tok, https, remember)])
# ---- 账号
def _ep_get_me(self, h, s, q, b):
r = self.store.conn().execute("SELECT username, email FROM cms_users WHERE id=?", (s["uid"],)).fetchone()
return self._reply(h, 200, {"ok": True, "user": r[0], "email": r[1], "must_change": s["must"], "csrf": s["csrf"]})
def _ep_post_logout(self, h, s, q, b):
with self.store.tx() as c:
c.execute("DELETE FROM cms_sessions WHERE th=?", (s["th"],))
self.audit(s["user"], s["ip"], "退出")
return self._reply(h, 200, {"ok": True}, cookies=[self._clear_cookie(s["https"])])
def _ep_post_password(self, h, s, q, b):
r = self.store.conn().execute("SELECT pw FROM cms_users WHERE id=?", (s["uid"],)).fetchone()
old, new = str(b.get("old") or "")[:200], str(b.get("new") or "")[:200]
with self.hash_sem:
right = check_pw(old, r[0])
if not right:
return self._reply(h, 400, {"ok": False, "error": "现在的密码不对"})
p = pw_problem(new, old)
if p:
return self._reply(h, 400, {"ok": False, "error": p})
if s["must"]:
# 首次改密:作废这个账号**所有**会话(包括这台),用新密码重新登录
self.user_set_password(s["user"], new, must_change=False)
self.audit(s["user"], s["ip"], "首次登录改了密码(所有会话已作废)")
return self._reply(h, 200, {"ok": True, "relogin": True}, cookies=[self._clear_cookie(s["https"])])
self.user_set_password(s["user"], new, must_change=False, keep_th=s["th"])
self.audit(s["user"], s["ip"], "改了密码(其它设备已退出)")
return self._reply(h, 200, {"ok": True})
def _ep_get_sessions(self, h, s, q, b):
rows = self.sessions_of(s["uid"])
for r in rows:
r["cur"] = r.pop("th") == s["th"]
return self._reply(h, 200, {"ok": True, "sessions": rows})
def _ep_post_sessions_revoke(self, h, s, q, b):
with self.store.tx() as c:
if b.get("others"):
n = c.execute("DELETE FROM cms_sessions WHERE uid=? AND th<>?", (s["uid"], s["th"])).rowcount
else:
sid = str(b.get("id") or "")
if len(sid) < 8:
return self._reply(h, 400, {"ok": False, "error": "没有这个设备"})
n = c.execute("DELETE FROM cms_sessions WHERE uid=? AND th<>? AND substr(th,1,?)=?", (s["uid"], s["th"], len(sid), sid)).rowcount
self.audit(s["user"], s["ip"], "踢掉了 %d 个其它设备" % n)
return self._reply(h, 200, {"ok": True, "n": n})
# ---- 内容
def _ep_get_content(self, h, s, q, b):
no, pub = self.current()
dr, base, upd, by = self.draft()
return self._reply(h, 200, {"ok": True, "version": no, "published": pub, "draft": dr or pub, "has_draft": dr is not None,
"draft_base": base, "draft_at": upd, "draft_by": by,
"changes": diff_summary(pub, dr) if dr else [], "tpl_keys": list(self.tpl_keys), "styles": list(STYLES)})
def _ep_post_draft(self, h, s, q, b):
doc = normalize(b.get("doc"), self.tpl_keys)
with self.lock:
no, pub = self.current()
base = b.get("base")
base = int(base) if str(base or "").isdigit() else no
with self.store.tx() as c:
c.execute("INSERT OR REPLACE INTO cms_draft (k, data, base, updated, by) VALUES ('doc', ?, ?, ?, ?)",
(json.dumps(doc, ensure_ascii=False), base, time.time(), s["user"]))
return self._reply(h, 200, {"ok": True, "draft": doc, "changes": diff_summary(pub, doc), "version": no})
def _ep_post_discard(self, h, s, q, b):
with self.store.tx() as c:
c.execute("DELETE FROM cms_draft WHERE k='doc'")
self.audit(s["user"], s["ip"], "丢掉了草稿")
return self._reply(h, 200, {"ok": True})
def _ep_post_publish(self, h, s, q, b):
dr, base, _, _ = self.draft()
if dr is None:
return self._reply(h, 400, {"ok": False, "error": "没有草稿可以发布"})
doc = normalize(dr, self.tpl_keys) # 发布前再校验一遍(规则可能更新过)
no, rows = self.publish(s["user"], s["ip"], doc, _s(b.get("note"), 60, "发布说明"), b.get("base", base))
return self._reply(h, 200, {"ok": True, "version": no, "changes": rows})
def _ep_post_rollback(self, h, s, q, b):
try:
to = int(b.get("no"))
except (TypeError, ValueError):
return self._reply(h, 400, {"ok": False, "error": "版本号不对"})
r = self.store.conn().execute("SELECT data FROM cms_versions WHERE no=?", (to,)).fetchone()
if not r:
return self._reply(h, 404, {"ok": False, "error": "没有这一版"})
doc = normalize(json.loads(r[0]), self.tpl_keys)
no, rows = self.publish(s["user"], s["ip"], doc, "回到 v%d" % to, None)
with self.store.tx() as c:
c.execute("DELETE FROM cms_draft WHERE k='doc'")
return self._reply(h, 200, {"ok": True, "version": no, "changes": rows})
def _ep_get_versions(self, h, s, q, b):
rows = [{"no": r[0], "note": r[1], "by": r[2], "at": r[3], "chg": r[4]}
for r in self.store.conn().execute("SELECT no, note, by, at, chg FROM cms_versions ORDER BY no DESC LIMIT 200")]
return self._reply(h, 200, {"ok": True, "versions": rows})
def _ep_get_version(self, h, s, q, b):
try:
no = int((q.get("no") or ["0"])[0])
except ValueError:
no = 0
r = self.store.conn().execute("SELECT data FROM cms_versions WHERE no=?", (no,)).fetchone()
if not r:
return self._reply(h, 404, {"ok": False, "error": "没有这一版"})
return self._reply(h, 200, {"ok": True, "no": no, "doc": json.loads(r[0])})
def _ep_get_audit(self, h, s, q, b):
rows = [{"at": r[0], "who": r[1], "ip": r[2], "what": r[3]}
for r in self.store.conn().execute("SELECT at, who, ip, what FROM cms_audit ORDER BY id DESC LIMIT 100")]
return self._reply(h, 200, {"ok": True, "audit": rows})
def _ep_post_upload(self, h, s, q, b):
info = self.save_upload(s["uid"], b.get("name"), b.get("data"))
self.audit(s["user"], s["ip"], "上传了图片 %s(%d×%d)" % (info["src"], info["w"], info["h"]))
return self._reply(h, 200, dict(ok=True, **info))
# ---- 预览(草稿当成网站内容;只有登录且改过初始密码的人拿得到)
def _draft_doc(self):
dr = self.draft()[0]
return dr if dr is not None else self.current()[1]
def _ep_get_draft_js(self, h, s, q, b):
body = "window.JZ_CONTENT = %s;\nwindow.JZ_PREVIEW = true;\n" % _js_literal(site_payload(self._draft_doc()["site"]))
return self._reply(h, 200, body=body.encode("utf-8"), ctype="application/javascript; charset=utf-8")
def _ep_get_draft_order_js(self, h, s, q, b):
body = "window.JZ_ORDER = %s;\nwindow.JZ_PREVIEW = true;\n" % _js_literal(order_payload(self._draft_doc()["order"]))
return self._reply(h, 200, body=body.encode("utf-8"), ctype="application/javascript; charset=utf-8")