This website requires JavaScript.
0
Issues
Pull Requests
Milestones
Explore
0
Create…
New Repository
New Migration
New Organization
public
Signed in as
public
Profile
Starred
Subscriptions
Settings
Help
Sign Out
public
/
jinzuanwork
Unwatch
1
Star
0
Fork
0
Code
Issues
Pull Requests
Actions
Packages
Projects
Releases
Wiki
Activity
Settings
Files
jinzuanwork
/
backend
/
backend-site
/
or
Cancel
Edit File
Preview
Preview Changes
Spaces
Tabs
2
4
8
Wrap
No wrap
#!/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")
Commit Changes
Add a Signed-off-by trailer by the committer at the end of the commit log message.
Commit directly to the
main
branch.
Create a
new branch
for this commit and start a pull request.
Commit Changes
Cancel