minecraft-snuvi-scripts/players.txt

databank.workerExecute(databank.prepare("CREATE TABLE IF NOT EXISTS forgeplayers (old_id INT NOT NULL PRIMARY KEY, id BIGINT, uuid VARCHAR(60) NOT NULL)"));

stmt = databank.prepare("SELECT id FROM minecraft.players;");
result = databank.execute(stmt);
while(databank.next(result)) {
	id = databank.getInt(result, 1);
	write(id);
}
databank.close(result);
databank.close(stmt);

function write(id) {
	stmt = databank.prepare("INSERT INTO forgeplayers (old_id, uuid) VALUES (?,?)");
	msg("dev", id);
	databank.setInt(stmt, 1, id);
	databank.setString(stmt, 2, text(player.getUuidFromId(id)));
	databank.workerExecute(stmt);
}


stmt = databank.prepare("SELECT old_id,uuid FROM forgeplayers;");
result = databank.execute(stmt);
while(databank.next(result)) {
	id = databank.getInt(result, 1);
	uuid = databank.getString(result, 2);
	msg("dev", id, " ", uuid);
}
databank.close(result);
databank.close(stmt);