用户:ZCH编程小贝壳查看:6 回复:2 评论:6 创建时间:2021-08-01T22:49:16
用两个这玩意存到SQL表格里边在读取出来加减结果是NaN???
附代码
if(voxels.name(voxel) == 'coffee' || voxels.name(voxel) == 'milk'){
db.sql`UPDATE list1 SET record_e = ${new Date().valueOf()} WHERE name = ${entity.player.name}`;
st = db.sql`SELECT * FROM list1 WHERE name=${entity.player.name} ORDER BY record_s ASC LIMIT 1`;
et = db.sql`SELECT * FROM list1 WHERE name=${entity.player.name} ORDER BY record_e ASC LIMIT 1`
entity.position.set(1, 32, 121);
if((et-st)<=30000){
world.say(`${entity.player.name}仅用${(et-st)/1000}秒到达终点,挑战成功!`)
entity.player.directMessage(`恭喜你获得血量增加500`)
entity.hp += 500
}
else{
world.say(`${entity.player.name}到达了终点`)
entity.player.directMessage(`用时${(et-st)/1000}秒,在30秒内通关才可挑战成功!`)
entity.hp += 200
}
}
原版Scriptjvav代码()
表格信息
db.sql`CREATE TABLE IF NOT EXISTS list1 (
name VARCHAR(50) NOT NULL,
record_s REAL,
record_e REAL
)`