猫史档案馆

好用又方便的存档模板

也不容易报错

const INIT = {
    hp: 100,
    maxHp: 100,
    enableDamage: true,
    //可以添加或删除字段
    //每次添加或删除字段事都要往控制台中输入“db.sql`DROP TABLE lolita`”
}
db.sql`CREATE TABLE IF NOT EXISTS lolita(
    id CHAR(16) NOT NULL,
    record TEXT NOT NULL
)`
world.onPlayerJoin(async({entity})=>{
    function init(){
        Object.assign(entity,INIT);
    }
    if(entity.player.userKey){
        const rows = await db.sql`SELECT * FROM lolita WHERE id = ${entity.player.userKey}`;
        if(rows && !rows.length){
            init();
            db.sql`INSERT INTO lolita VALUES(${entity.player.userKey},${getRecord.call(entity)})`;
        }else{
            Object.assign(entity,JSON.parse(rows[0].record));
        }
    }else init();
})
function getRecord(){
    const result = {};
    Object.keys(INIT).forEach((e)=>{
        result[e] = this[e];
    })  
    return JSON.stringify(result);
}
function update(){//保存
    if(!this.player.userKey)return;
    db.sql`UPDATE lolita SET record = ${getRecord.call(this)} WHERE id = ${this.player.userKey}`;
}
world.onPlayerLeave(({entity})=>{
    update.call(entity);
})

原创代码，创作不易

使用记得顶帖

 

 

(async function (){
await db.sql`CREATE TABLE IF NOT EXISTS lolita(
    id CHAR(16) NOT NULL,
    record TEXT NOT NULL
)`
})()