猫史档案馆

(async function () {
    await db.sql`
        CREATE TABLE IF NOT EXISTS player (
            jingyan INTEGER NOT NULL,
            duanwei TEXT NOT NULL,
            money INTEGER NOT NULL,
            pifumoney INTEGER NOT NULL,
            bag TEXT NOT NULL,
            duanweijiangli TEXT NOT NULL,
            userKey TEXT PRIMARY KEY UNIQUE NOT NULL
        )
    `
})();

async function saveData(entity) {
    if (entity.player.userKey) {
        await db.sql`
            INSERT INTO player (
                jingyan,
                duanwei,
                money,
                pifumoney,
                bag,
                duanweijiangli,
                userKey
            )
            VALUES (
                ${entity.player.jingyan},
                ${JSON.stringify(entity.player.duanwei)},
                ${entity.player.money},
                ${entity.player.pifumoney},
                ${JSON.stringify(entity.player.bag)},
                ${JSON.stringify(entity.player.duanweijiangli)},
                ${entity.player.userKey}
            )
            ON CONFLICT(userKey)
            DO UPDATE SET
            jingyan = excluded.jingyan,
            duanwei = excluded.duanwei,
            money = excluded.money,
            pifumoney = excluded.pifumoney,
            bag = excluded.bag,
            duanweijiangli = excluded.duanweijiangli,
            userKey = excluded.userKey
        `
    }
}
world.onPlayerLeave(async ({ entity }) => { await saveData(entity); });

async function loadData(entity) {
    const data = (
        await (
            db.sql`
                SELECT * FROM player WHERE userKey = ${entity.player.userKey} limit 1
            `
        )
    )[0];
    if (data) {
        entity.player.jingyan = data.jingyan;
        entity.player.duanwei = JSON.parse(data.duanwei);
        entity.player.money = data.money;
        entity.player.pifumoney = data.pifumoney;
        entity.player.bag = JSON.parse(data.bag);
        entity.player.duanweijiangli = JSON.parse(data.duanweijiangli);
        entity.player.directMessage('系统提示：已读取数据');
    } else {
        entity.player.directMessage('系统提示：你目前还没有数据，已帮你创建');
    }
}

/*为什么保存不了呀*/

#有语法错误吧