猫史档案馆

global.Z = ['你的名字~~~~~~~~~~']
db.sql`CREATE TABLE IF NOT EXISTS "advice"(
    "title" TEXT NOT NULL
)`
world.querySelectorAll('.liuyan').forEach(async (e) => {
    e.enableInteract = true
    e.interactHint = '举报&意见箱'
    e.interactRadius = 100;
    e.onInteract(async ({ entity }) => {
        const result_1 = await entity.player.dialog({
            type: Box3DialogType.SELECT,
            title: "举报&意见箱",
            content: `欢迎举报&意见`,
            options: ['留言栏', '查看留言内容'],
        });
        //如果玩家点击了屏幕其他区域，取消对话框
        if (!result_1 || result_1 === null) {
            return;
        }
        //判断玩家选了什么选项
        switch (result_1.index) {
            case 0:
                const rows = await db.sql`SELECT * FROM "advice"`;
                let title = '';
                for (let i in rows) {
                    title += rows[i].title + '\n';
                }
                const result = await entity.player.dialog({
                    type: Box3DialogType.INPUT,
                    title: '举报&意见箱',
                    content: '举报&意见（字数<=20字）',
                    placeholder: '输入你想说的话...禁止骂人）',
                })
                if (result != null) {
                    if (result.length <= 20) {
                        db.sql`INSERT INTO "advice" VALUES(${entity.player.name + '：' + result})`;//插入新字段
                        entity.player.dialog({
                            type: Box3DialogType.TEXT,
                            title: '举报&意见箱',
                            content: '发布成功，谢谢你的建议',
                        })
                    } else {
                        entity.player.dialog({
                            type: Box3DialogType.TEXT,
                            title: '举报&意见箱',
                            content: '字数不能超过20个字哦~',
                        })
                    }
                }
                break
            case 1:
                if (Z.includes(entity.player.name)) {
                    const rows = await db.sql`SELECT * FROM "advice"`;
                    let title = '';
                    for (let i in rows) {
                        title += rows[i].title + '\n';
                    }
                    const result = await entity.player.dialog({
                        type: Box3DialogType.TEXT,
                        title: '举报&意见箱',
                        content: title,
                    })
                } else {
                    entity.player.dialog({
                        type: 'text',
                        content: '无法查看此内容'
                    })
                }
            default:
        }
    })
})