用户:
倔强的铁奥13284708查看:12 回复:5 评论:12 创建时间:2021-07-01T13:06:30
天起大路那样
五个赞或者是各方面的关注
//创造SQL表格
db.sql`CREATE TABLE IF NOT EXISTS leaderboard(
id VARCHAR(500) PRIMARY KEY UNIQUE NOT NULL,
x REAL NOT NULL,
y REAL NOT NULL,
z REAL NOT NULL,
)`
const joinPosition = new Box3Vector3(128,55,128);//设置玩家出生点
world.onPlayerJoin(async({entity})=>{
const rows = await db.sql`SELECT * FROM leaderboard WHERE id = ${entity.player.boxId}`;//判断玩家数据是否为空
if(rows && !rows.length){//如果玩家没有数据
entity.position = joinPosition;//将玩家移动到出生点
await db.sql`INSERT INTO leaderboard(id,x,y,z) VALUES (${entity.player.boxId},${joinPosition.x},${joinPosition.y},${joinPosition.z})`;//初始位置
}else{//否则
const id = entity.player.boxId;
for await(const row of db.sql`SELECT * FROM leaderboard WHERE id = ${id} ORDER BY x ASC LIMIT 1`){//查找玩家数据
var x = row.x;
}
for await(const row of db.sql`SELECT * FROM leaderboard WHERE id = ${id} ORDER BY y ASC LIMIT 1`){//查找玩家数据
var y = row.y;
}
for await(const row of db.sql`SELECT * FROM leaderboard WHERE id = ${id} ORDER BY z ASC LIMIT 1`){//查找玩家数据
var z = row.z;
}
entity.position.set(x,y,z);//将玩家移动到数据点
}
})
world.onPlayerLeave(({entity})=>{
db.sql`UPDATE leaderboard SET x = ${entity.position.x} WHERE id = ${entity.player.boxId}`;
db.sql`UPDATE leaderboard SET y = ${entity.position.y} WHERE id = ${entity.player.boxId}`;
db.sql`UPDATE leaderboard SET z = ${entity.position.z} WHERE id = ${entity.player.boxId}`;
})点赞2
评论
//创造SQL表格
db.sql`CREATE TABLE IF NOT EXISTS leaderboard(
id VARCHAR(500) PRIMARY KEY UNIQUE NOT NULL,
x REAL NOT NULL,
y REAL NOT NULL,
z REAL NOT NULL,
)`
const joinPosition = new Box3Vector3(119,17,2);//设置玩家出生点
world.onPlayerJoin(async({entity})=>{
const rows = await db.sql`SELECT * FROM leaderboard WHERE id = ${entity.player.boxId}`;//判断玩家数据是否为空
if(rows && !rows.length){//如果玩家没有数据
entity.position = joinPosition;//将玩家移动到出生点
await db.sql`INSERT INTO leaderboard(id,x,y,z) VALUES (${entity.player.boxId},${joinPosition.x},${joinPosition.y},${joinPosition.z})`;//初始位置
}else{//否则
const id = entity.player.boxId;
for await(const row of db.sql`SELECT * FROM leaderboard WHERE id = ${id} ORDER BY x ASC LIMIT 1`){//查找玩家数据
var x = row.x;
}
for await(const row of db.sql`SELECT * FROM leaderboard WHERE id = ${id} ORDER BY y ASC LIMIT 1`){//查找玩家数据
var y = row.y;
}
for await(const row of db.sql`SELECT * FROM leaderboard WHERE id = ${id} ORDER BY z ASC LIMIT 1`){//查找玩家数据
var z = row.z;
}
entity.position.set(x,y,z);//将玩家移动到数据点
}
})
world.onPlayerLeave(({entity})=>{
db.sql`UPDATE leaderboard SET x = ${entity.position.x} WHERE id = ${entity.player.boxId}`;
db.sql`UPDATE leaderboard SET y = ${entity.position.y} WHERE id = ${entity.player.boxId}`;
db.sql`UPDATE leaderboard SET z = ${entity.position.z} WHERE id = ${entity.player.boxId}`;
})//这玩意儿不行啊@指令者点赞0
评论