猫史档案馆

迷失星河

搞错了

点赞0

迷失星河

async function initTable1() {
    await db.sql`CREATE TABLE IF NOT EXISTS players (
        "muted_day" INT default 0,
        "ban_day" INT default 0,
        "email" TEXT default '',
        "name" VARCHAR(50) NOT NULL,
        "userKey" CHAR(16) PRIMARY KEY UNIQUE NOT NULL
    )`;
}

async function saveUser1(user) {
    await db.sql`
        INSERT INTO players (
            "muted_day",
            "ban_day",
            "email",
            "name",
            "userKey"
        ) VALUES (
            ${user.muted_day}, 
            ${user.ban_day}, 
            ${JSON.stringify(user.email)}, 
            ${user.player.name},
            ${user.player.userKey}
        )
        ON CONFLICT("userKey") 
        DO UPDATE SET
            "muted_day"=excluded."muted_day",
            "ban_day"=excluded."ban_day",
            "email"=excluded."email",
    `
}

async function loadUser1(user) {
    const [data] = await db.sql`SELECT * FROM players WHERE "userKey"=${user.player.userKey} LIMIT 1`
    if (data) {
        user.muted_day = data.muted_day
        user.ban_day = data.ban_day
        user.email = JSON.parse(data.email)
    }
    else {
        saveUser1(user)
    }
}

async function deleteUser1(user) {
    await db.sql`DELETE FROM players WHERE "userKey"=${user.player.userKey}`
}

async function showAllPlaySideUser1() {
    for (const e of await db.sql`SELECT * FROM play.players`) {
        console.log(JSON.stringify(e))
    }
}

async function showAllEditSideUser1() {
    for (const e of await db.sql`SELECT * FROM edit.players`) {
        console.log(JSON.stringify(e))
    }
}

async function poll(fn, msg) {
    while (true) {
        try {
            return await fn()
        } catch (e) {
            world.say(e)
        }
        await sleep(2000)
    }
}


poll(initTable1)

点赞0

迷失星河

代码在这

点赞0

一只电报员

我们把答案设它为X，再根据勾股定理，物种起源，大陆漂移，修辞手法，过去式，现在进行时，圆周率推算，蝴蝶效应，阿基米德中点定理，阿基米德折弦定理，波尔查诺-维尔斯特拉斯定理，巴拿赫-塔斯基悖论伯特兰-切比雪夫定理，贝亚蒂定理，贝叶斯定理，博特周期性定理，闭图像定理，伯恩斯坦定理，康托尔-伯恩斯坦-施罗德定理，不动点定理，布利安桑定理，布朗定理，贝祖定理，博苏克-乌拉姆定理，半角定理，垂径定理，陈氏定理，采样定理，抽屉原理，牛顿第一定律，牛顿第二定律，牛顿第三定律，D德·摩根定律迪尼定理，等周定理，得出结论：我不会搞

点赞0