用户:1232RvE查看:5 回复:11 评论:5 创建时间:2021-07-02T09:54:31
world.onPlayerJoin( async ({entity}) => {
playerData = await getPlayer(entity.player.name); // 获取上次登录记录
if (playerData == null) {
savePlayer(entity)
world.say(`${entity.player.name} 第一次进入游戏。`);
}
});
db.sql`CREATE TABLE IF NOT EXISTS players (
name VARCHAR(50) PRIMARY name UNIQUE NOT NULL,
xf INTEGER NOT NULL,
mucai INTEGER NOT NULL,
bb VARCHAR(50) NOT NULL,
hp INTEGER NOT NULL,
dengji INTEGER NOT NULL,
jyz INTEGER NOT NULL
)`;
print()
async function print() {
console.clear()
for await (let row of db.sql`SELECT * FROM players`) {
world.say(row)
console.log(`${row.name}:${row.xf}:${row.mucai}:${row.bb}:${row.hp}:${row.dengji}:${row.jyz}`)
}
}
async function savePlayer(entity) {//定义保存玩家状态的函数
await db.sql`
INSERT INTO players (
name,
xf,
mucai,
bb,
hp,
dengji,
jyz
)
VALUES(
${entity.player.name},
${entity.player.xf},
${entity.player.mucai},
${JSON.stringify(entity.player.bb)},
${entity.hp},
${entity.player.dengji},
${entity.player.jyz}
)
ON CONFLICT(name)
DO UPDATE SET
name=excluded.name,
xf=excluded.xf,
mucai=excluded.mucai,
bb=excluded.bb,
hp=excluded.hp,
dengji=excluded.dengji,
jyz=excluded.jyz
`
}
报错信息:
sql error: Error: SQLITE_ERROR: table players has no column named xf
可是我找了半天没找出来
请大佬们帮我一下
awaawaname VARCHAR(50) PRIMARY name UNIQUE NOT NULL,
xf INTEGER NOT NULL,
mucai INTEGER NOT NULL,
bb VARCHAR(50) NOT NULL,
hp INTEGER NOT NULL,
dengji INTEGER NOT NULL,
jyz INTEGER NOT NULL
检查一下这儿
点赞0
评论