Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void setFriendAndOnline(ProxiedPlayer p) {
- Integer onlineI = 0;
- List<String> freunde = Files.yFriends.getStringList("Freunde von " + PlayerUtil.getUUID(p.getName()));
- for(String online : freunde) {
- if(BungeeCord.getInstance().getPlayer(online) != null) {
- onlineI++;
- }
- }
- Main.mysql.update("DELETE FROM Freunde WHERE Name= '" + p.getName() + "'");
- Main.mysql.update("INSERT INTO Freunde(Name, Online, Freunde) VALUES ('" + p.getName() + "', '" + onlineI + "', '" + freunde.size() + "');");
- public static Integer getFriends(String name) {
- String i = "0";
- if(PlayerExists(name)) {
- try {
- ResultSet rs = Main.mysqlf.query("SELECT * FROM Freunde WHERE Name= '" + name + "'");
- if((!rs.next()) || (String.valueOf(rs.getString("Freunde")) == null));
- i = rs.getString("Freunde");
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- return Integer.valueOf(i);
- }
- public static Integer getOnline(String name) {
- String i = "0";
- if(PlayerExists(name)) {
- try {
- ResultSet rs = Main.mysqlf.query("SELECT * FROM Freunde WHERE Name= '" + name + "'");
- if((!rs.next()) || (String.valueOf(rs.getString("Online")) == null));
- i = rs.getString("Online");
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- return Integer.valueOf(i);
- }
- public static boolean PlayerExists(String name) {
- try {
- ResultSet rs = Main.mysqlf.query("SELECT * FROM Freunde WHERE Name= '" + name + "'");
- if(rs.next()) {
- return rs.getString("Freunde") != null;
- }
- return false;
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement