猫史档案馆

db.sql`CREATE TABLE IF NOT EXISTS ob(--创建表格
    names TEXT NOT NULL,
    nvalues TEXT NOT NULL,
    times INT NOT NULL
)`;
const opinionBox = world.querySelector('#意见箱')
//先把意见箱的名字改为（“意见箱”），再使用
opinionBox.enableInteract=true;
opinionBox.interactHint='意见箱';
opinionBox.interactRadius=5;
opinionBox.onInteract(async({entity})=>{
    opinionList = ''
    for(const O of await db.sql`SELECT * FROM ob `){
        opinionList=String(opinionList)+String(O.names)+'：'+String(O.nvalues)+'\\n'
    };
    const opinionDialogue = await entity.player.dialog({
        type:'input',
        title:'意见箱',
        content:eval('"'+opinionList+'"'),
        confirmText:'提交',
        placeholder:'请输入要提交的意见……'
    });
    if(!opinionDialogue || !opinionDialogue==null){return}
    try{
        await db.sql`INSERT INTO ob VALUES(
            ${entity.player.name},
            ${opinionDialogue},
            ${new Date().valueOf()+1000*60*60*24*7*2}
        )`;
        entity.player.dialog({
            type:'text',
            title:'提示',
            content:'提交成功！感谢你的反馈'
        });
    }catch(error){
        entity.player.dialog({
            type:'text',
            title:'提示',
            content:'很遗憾，提交失败！\n错误：'+error.message
        });
    };
});
!(async()=>{//保留时间超过两个星期的意见自动删除
    while(true){
        for(const FIND of await db.sql`
            SELECT * FROM ob
        `){
            if((new Date().valueOf()-FIND.times)>0){
                await db.sql`
                    DELETE FROM ob WHERE times < ${
                        new Date().valueOf()
                    }
                `
            }
        }
    }
})();