hanfuit
645b64fe21
服务端（Go）： - GM 塞背包/带属性装备发放：在线角色推送 op14 增量物品行，背包实时刷新，无需回角色选择界面 - GM 改金币/改等级：去掉在线拒绝，落库后推送 op14 钱包/op37 等级状态，在线实时刷新 - 等级端点统一切换到新版 GMSetCharacterLevel（自带在线刷新） - 无限/锁死疲劳模式 + 燃烧疲劳：每房间消耗 2 点、打怪与通关经验双倍 - 燃烧疲劳开关时给所有在线角色推送系统提示（op12 mode 0） - 深渊史诗掉率：GM 全局倍率 + 城镇增益药剂窗口倍率，真实接入掉落结算 启动器（Python/JS）： - 标题栏自绘、窗口 1204x717、禁止拖拽改大小、仅最小化/关闭 - GM 工具：疲劳与燃烧、深渊史诗掉率、拍卖行上架（单一定价对齐） - 拍卖行上架前端对齐服务端单一价格语义，修复 400 报错
38 lines
1.1 KiB
Go
38 lines
1.1 KiB
Go
package services
|
|
|
|
import (
|
|
"context"
|
|
"database/sql"
|
|
"os"
|
|
)
|
|
|
|
// Clone only a checkpointed main database while excluding concurrent writers.
|
|
// The SQLite backup API remains the portable fallback, including busy WALs.
|
|
func copyPrivateSQLiteIndex(db *sql.DB, source, target string) error {
|
|
ctx := context.Background()
|
|
conn, err := db.Conn(ctx)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
var busy, pages, copied int
|
|
checkpointErr := conn.QueryRowContext(ctx, "PRAGMA wal_checkpoint(TRUNCATE)").Scan(&busy, &pages, &copied)
|
|
cloned := false
|
|
if checkpointErr == nil && busy == 0 {
|
|
if _, err := conn.ExecContext(ctx, "BEGIN IMMEDIATE"); err == nil {
|
|
// A writer could have committed between checkpoint and BEGIN.
|
|
info, statErr := os.Stat(source + "-wal")
|
|
if os.IsNotExist(statErr) || (statErr == nil && info.Size() == 0) {
|
|
cloned = cloneIndexFile(source, target) == nil
|
|
}
|
|
_, _ = conn.ExecContext(ctx, "ROLLBACK")
|
|
}
|
|
}
|
|
_ = conn.Close()
|
|
if cloned {
|
|
developmentLog("[pvfine:index] private SQLite snapshot mode=clone")
|
|
return nil
|
|
}
|
|
_ = os.Remove(target)
|
|
return backupSQLiteDatabase(ctx, db, target)
|
|
}
|