public static void printOverlay() {
// 输出服务器繁忙率
Iterator<Server> its = Servers.iterator();
Server tmp;
while (its.hasNext()) {
tmp = its.next();
Output.printSTAT(
"server"
+ tmp.getServerID()
+ ": percentage of busy time: "
+ Utilities.displayPercentage(tmp.getUtilizationRate())
+ "%");
}
// 输出每个Overlay信息。
Iterator<Overlay> ito = p2pOverlay.iterator();
while (ito.hasNext()) {
ito.next().printInfo();
}
}
public static void saveServer(Server server) {
Connection c = null;
PreparedStatement ps = null;
String query =
"INSERT INTO servers VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE xp_min=?,xp_max=?,xp_min_twitch=?,xp_max_twitch=?,xp_base=?,xp_multiplier=?,cleverbot_channel=?,twitch_channel=?,welcome_message=?,goodbye_message=?,welcome_goodbye_chan=?,admin_role=?,role_on_join=?,vr_mode=?";
try {
c = hikari.getConnection();
ps = c.prepareStatement(query);
ps.setString(1, server.getServerID());
ps.setInt(2, server.getMinXP());
ps.setInt(3, server.getMaxXP());
ps.setInt(4, server.getMinXpTwitch());
ps.setInt(5, server.getMaxXpTwitch());
ps.setInt(6, server.getXpBase());
ps.setDouble(7, server.getXpMultiplier());
ps.setString(8, server.getCleverbotChannel());
ps.setString(9, server.getTwitchChannel());
ps.setString(10, server.getWelcomeMessage());
ps.setString(11, server.getGoodbyeMessage());
ps.setString(12, server.getWelcomeGoodbyeChannel());
ps.setString(13, server.getAdminRole());
ps.setString(14, server.getRoleOnJoin());
ps.setBoolean(15, server.isVrMode());
ps.setInt(16, server.getMinXP());
ps.setInt(17, server.getMaxXP());
ps.setInt(18, server.getMinXpTwitch());
ps.setInt(19, server.getMaxXpTwitch());
ps.setInt(20, server.getXpBase());
ps.setDouble(21, server.getXpMultiplier());
ps.setString(22, server.getCleverbotChannel());
ps.setString(23, server.getTwitchChannel());
ps.setString(24, server.getWelcomeMessage());
ps.setString(25, server.getGoodbyeMessage());
ps.setString(26, server.getWelcomeGoodbyeChannel());
ps.setString(27, server.getAdminRole());
ps.setString(28, server.getRoleOnJoin());
ps.setBoolean(29, server.isVrMode());
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (c != null) {
try {
c.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
