Diese simplen Fehler an denen man immer Ewigkeiten sitzt...Du hast
private MySQL mysql; geschrieben
Du brauchst eine istance also
private MySQL mysql = new MySQL ();
Du hast
private MySQL mysql; geschrieben
Du brauchst eine istance also
private MySQL mysql = new MySQL ();
Diese simplen Fehler an denen man immer Ewigkeiten sitzt...
Moin Leute,
ich bin gerade dabei ein Nick-System wie auf GommeHD.net zu programmieren. Ich habe jedoch einen Fehler, wenn ich auf dem Server joine und wenn ich auf das NickItem klicke. Ich habe schon mehrere Stunden gesucht und bin aus der Fehlermeldung nicht schlau geworden.
PHP:[19:50:32 INFO]: Structure Info Saving: true [19:50:32 INFO]: Sending up to 5 chunks per packet [19:50:32 INFO]: Max TNT Explosions: 100 [19:50:32 INFO]: Preparing start region for level 0 (Seed: 0) [19:50:32 INFO]: Preparing start region for level 1 (Seed: -8961835515628948910) [19:50:32 INFO]: [PermissionsEx] Enabling PermissionsEx v1.22.5 [19:50:32 INFO]: [PermissionsEx] Initializing sql backend [19:50:32 INFO]: [PermissionsEx] Successfully connected to SQL database [19:50:32 INFO]: [NoCheatPlus] Enabling NoCheatPlus v3.11.1-RC-sMD5NET-b743 [19:50:32 INFO]: [NoCheatPlus] McAccess set to: 1.7.10 / CB3100-DEV [19:50:32 INFO]: [NoCheatPlus] Added block-info for Minecraft 1.5 blocks. [19:50:32 INFO]: [NoCheatPlus] Added block-info for Minecraft 1.6.1 blocks. [19:50:32 INFO]: [NoCheatPlus] Added block-info for Minecraft 1.7.2 blocks. [19:50:32 INFO]: [NoCheatPlus] Inventory checks: FastConsume is available, disab led InstantEat. [19:50:32 INFO]: [NoCheatPlus] Packet level access: ProtocolLib is not available . [19:50:32 INFO]: [NoCheatPlus] Version 3.11.1-RC-sMD5NET-b743 is enabled. [19:50:33 INFO]: [Effect Library] Enabling EffectLib v2.0 [19:50:33 INFO]: [TExTeam-Lobbysystem] Enabling TExTeam-Lobbysystem v1.0 [19:50:33 INFO]: [TExTeam-Lobbysystem] [TExTeam-LobbySystem] Plugin aktiviert. [19:50:33 INFO]: Server permissions file permissions.yml is empty, ignoring it [19:50:33 INFO]: Done (1,218s)! For help, type "help" or "?" [19:50:33 INFO]: [NoCheatPlus] Post-enable running... [19:50:33 INFO]: [NoCheatPlus] Post-enable finished. [19:50:33 WARN]: [PermissionsEx] An update to PermissionsEx version 1.23 is avai lable to download from http://dev.bukkit.org/bukkit-plugins/permissionsex/. Plea se review the changes and update as soon as possible! [19:50:41 INFO]: UUID of player lusu007 is a2e334fe-9e71-3f42-8dcf-438cecf0f836 [19:50:41 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tabl e 'nick.autonick' doesn't exist [19:50:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance 0(Native Method) [19:50:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance (Unknown Source) [19:50:41 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst ance(Unknown Source) [19:50:41 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Sou rce) [19:50:41 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [19:50:41 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382) [19:50:41 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.j ava:1052) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: 3593) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: 3525) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21 40) [19:50:41 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl. java:2620) [19:50:41 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl. java:2570) [19:50:41 WARN]: at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm pl.java:1474) [19:50:41 WARN]: at me.lusu007.lobbysystem.MySQL.MySQL.Query(MySQL.java:8 8) [19:50:41 WARN]: at me.lusu007.lobbysystem.MySQL.MySQL.isInDatabase(MySQL .java:129) [19:50:41 WARN]: at me.lusu007.lobbysystem.Listener.PlayerJoinEvent_Liste ner.onJoin(PlayerJoinEvent_Listener.java:58) [19:50:41 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M ethod) [19:50:41 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S ource) [19:50:41 WARN]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno wn Source) [19:50:41 WARN]: at java.lang.reflect.Method.invoke(Unknown Source) [19:50:41 WARN]: at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav aPluginLoader.java:298) [19:50:41 WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(Regist eredListener.java:62) [19:50:41 WARN]: at org.bukkit.plugin.SimplePluginManager.fireEvent(Simpl ePluginManager.java:509) [19:50:41 WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl ePluginManager.java:494) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.PlayerList.c(PlayerList. java:265) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.PlayerList.a(PlayerList. java:152) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.LoginListener.c(LoginLis tener.java:119) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.LoginListener.a(LoginLis tener.java:44) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.NetworkManager.a(Network Manager.java:189) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.ServerConnection.c(Serve rConnection.java:81) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.v(Minecr aftServer.java:734) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.DedicatedServer.v(Dedica tedServer.java:289) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.u(Minecr aftServer.java:584) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.run(Mine craftServer.java:490) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.ThreadServerApplication. run(SourceFile:628) [19:50:41 WARN]: java.lang.NullPointerException [19:50:41 WARN]: at me.lusu007.lobbysystem.MySQL.MySQL.isInDatabase(MySQL .java:131) [19:50:41 WARN]: at me.lusu007.lobbysystem.Listener.PlayerJoinEvent_Liste ner.onJoin(PlayerJoinEvent_Listener.java:58) [19:50:41 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M ethod) [19:50:41 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S ource) [19:50:41 WARN]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno wn Source) [19:50:41 WARN]: at java.lang.reflect.Method.invoke(Unknown Source) [19:50:41 WARN]: at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav aPluginLoader.java:298) [19:50:41 WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(Regist eredListener.java:62) [19:50:41 WARN]: at org.bukkit.plugin.SimplePluginManager.fireEvent(Simpl ePluginManager.java:509) [19:50:41 WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl ePluginManager.java:494) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.PlayerList.c(PlayerList. java:265) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.PlayerList.a(PlayerList. java:152) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.LoginListener.c(LoginLis tener.java:119) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.LoginListener.a(LoginLis tener.java:44) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.NetworkManager.a(Network Manager.java:189) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.ServerConnection.c(Serve rConnection.java:81) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.v(Minecr aftServer.java:734) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.DedicatedServer.v(Dedica tedServer.java:289) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.u(Minecr aftServer.java:584) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.run(Mine craftServer.java:490) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.ThreadServerApplication. run(SourceFile:628) [19:50:41 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unkn own column 'playeruuid' in 'where clause' [19:50:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance 0(Native Method) [19:50:41 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance (Unknown Source) [19:50:41 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst ance(Unknown Source) [19:50:41 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Sou rce) [19:50:41 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [19:50:41 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:382) [19:50:41 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.j ava:1052) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: 3593) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: 3525) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) [19:50:41 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21 40) [19:50:41 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl. java:2620) [19:50:41 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl. java:2570) [19:50:41 WARN]: at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm pl.java:1474) [19:50:41 WARN]: at me.lusu007.lobbysystem.MySQL.MySQL.Query(MySQL.java:8 8) [19:50:41 WARN]: at me.lusu007.lobbysystem.MySQL.MySQL.isNicked(MySQL.jav a:155) [19:50:41 WARN]: at me.lusu007.lobbysystem.Listener.PlayerJoinEvent_Liste ner.onJoin(PlayerJoinEvent_Listener.java:66) [19:50:41 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M ethod) [19:50:41 WARN]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S ource) [19:50:41 WARN]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno wn Source) [19:50:41 WARN]: at java.lang.reflect.Method.invoke(Unknown Source) [19:50:41 WARN]: at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav aPluginLoader.java:298) [19:50:41 WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(Regist eredListener.java:62) [19:50:41 WARN]: at org.bukkit.plugin.SimplePluginManager.fireEvent(Simpl ePluginManager.java:509) [19:50:41 WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl ePluginManager.java:494) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.PlayerList.c(PlayerList. java:265) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.PlayerList.a(PlayerList. java:152) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.LoginListener.c(LoginLis tener.java:119) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.LoginListener.a(LoginLis tener.java:44) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.NetworkManager.a(Network Manager.java:189) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.ServerConnection.c(Serve rConnection.java:81) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.v(Minecr aftServer.java:734) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.DedicatedServer.v(Dedica tedServer.java:289) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.u(Minecr aftServer.java:584) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.run(Mine craftServer.java:490) [19:50:41 WARN]: at net.minecraft.server.v1_7_R4.ThreadServerApplication. run(SourceFile:628) [19:50:41 ERROR]: Could not pass event PlayerJoinEvent to TExTeam-Lobbysystem v1 .0 org.bukkit.event.EventException at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.ja va:302) ~[spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.jav a:62) ~[spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.j ava:509) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.j ava:494) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.PlayerList.c(PlayerList.java:265) [spigo t.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.PlayerList.a(PlayerList.java:152) [spigo t.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.LoginListener.c(LoginListener.java:119) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.LoginListener.a(LoginListener.java:44) [ spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.NetworkManager.a(NetworkManager.java:189 ) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.ServerConnection.c(ServerConnection.java :81) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.MinecraftServer.v(MinecraftServer.java:7 34) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:2 89) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:5 84) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java :490) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:6 28) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] Caused by: java.lang.NullPointerException at me.lusu007.lobbysystem.MySQL.MySQL.isNicked(MySQL.java:158) ~[?:?] at me.lusu007.lobbysystem.Listener.PlayerJoinEvent_Listener.onJoin(Playe rJoinEvent_Listener.java:66) ~[?:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0 _25] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0 _25] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1 .8.0_25] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_25] at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.ja va:298) ~[spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] ... 14 more [19:50:41 INFO]: lusu007[/25.90.66.201:55143] logged in with entity id 63 at ([w orld] -1352.953118230872, 14.5, 239.94321459716193) [19:50:43 WARN]: Couldn't look up profile properties for net.minecraft.util.com. mojang.authlib.GameProfile@11b7a69c[id=b465aebc-e9da-45dd-bf57-d56ab1dfe960,name =lusu007,properties={},legacy=false] net.minecraft.util.com.mojang.authlib.exceptions.AuthenticationException: The cl ient has sent too many requests within a certain amount of time at net.minecraft.util.com.mojang.authlib.yggdrasil.YggdrasilAuthenticati onService.makeRequest(YggdrasilAuthenticationService.java:65) ~[spigot.jar:git-S pigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.util.com.mojang.authlib.yggdrasil.YggdrasilMinecraftSes sionService.fillProfileProperties(YggdrasilMinecraftSessionService.java:135) [sp igot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.TileEntitySkull$1.load(TileEntitySkull.j ava:58) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at net.minecraft.server.v1_7_R4.TileEntitySkull$1.load(TileEntitySkull.j ava:36) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at com.google.common.cache.CustomConcurrentHashMap$ComputingValueReferen ce.compute(CustomConcurrentHashMap.java:3426) [spigot.jar:git-Spigot-1.7.9-R0.2- 208-ge0f2e95] at com.google.common.cache.CustomConcurrentHashMap$Segment.compute(Custo mConcurrentHashMap.java:2322) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at com.google.common.cache.CustomConcurrentHashMap$Segment.getOrCompute( CustomConcurrentHashMap.java:2291) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e9 5] at com.google.common.cache.CustomConcurrentHashMap.getOrCompute(CustomCo ncurrentHashMap.java:3802) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at com.google.common.cache.ComputingCache.get(ComputingCache.java:46) [s pigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at com.google.common.cache.AbstractCache.getUnchecked(AbstractCache.java :49) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at org.bukkit.craftbukkit.v1_7_R4.inventory.CraftMetaSkull$1.run(CraftMe taSkull.java:65) [spigot.jar:git-Spigot-1.7.9-R0.2-208-ge0f2e95] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?: 1.8.0_25] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [? :1.8.0_25] at java.lang.Thread.run(Unknown Source) [?:1.8.0_25] >
Meine Klassen:
MySQL Klasse:
PHP:package me.lusu007.lobbysystem.MySQL; import me.lusu007.lobbysystem.Main.Main; import org.bukkit.Bukkit; import org.bukkit.OfflinePlayer; import java.io.IOException; import java.sql.*; /** * Created by Lukas on 05.01.2015. */ public class MySQL { private final Main plugin; //Variablen public static Connection con; public static String host; public static String database; public static String username; public static String password; public static int port; public MySQL(Main main) { this.plugin = main; String m = "MySQL."; plugin.sql.addDefault(m + "host", "localhost"); plugin.sql.addDefault(m + "port", Integer.valueOf(3306)); plugin.sql.addDefault(m + "database", "database"); plugin.sql.addDefault(m + "username", "username"); plugin.sql.addDefault(m + "password", "password"); plugin.sql.options().copyDefaults(true); try { plugin.sql.save(plugin.MySQLFile); } catch (IOException e) { e.printStackTrace(); } host = plugin.sql.getString(m + "host"); port = plugin.sql.getInt(m + "port"); database = plugin.sql.getString(m + "database"); username = plugin.sql.getString(m + "username"); password = plugin.sql.getString(m + "password"); } public static void connect() { try { con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password); } catch( Exception ex) { ex.printStackTrace(); } } public static boolean isConnected() { if(con != null) { return true; } return false; } public static void disconnect() { if(con != null) { try { con.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static ResultSet Query(String qry) { ResultSet rs = null; try { Statement stm = con.createStatement(); rs = stm.executeQuery(qry); } catch (SQLException e) { connect(); e.printStackTrace(); } return rs; } public static void Update(String qry) { try { Statement stm = con.createStatement(); stm.executeUpdate(qry); stm.close(); } catch (SQLException e) { connect(); e.printStackTrace(); } } public static void createData(String player) throws SQLException { OfflinePlayer pl = Bukkit.getOfflinePlayer(player); String uuid = pl.getUniqueId().toString(); ResultSet rs = Query("SELECT playeruuid FROM autonick WHERE playeruuid = '" + uuid + "'"); if(!rs.next()) { Update("INSERT INTO autonick VALUES('" + uuid + "', false)"); return; } } public static boolean isInDatabase(OfflinePlayer target) throws SQLException { String uuid = target.getUniqueId().toString(); boolean isInDatabase = false; ResultSet rs = Query("SELECT playeruuid FROM autonick WHERE playeruuid = '" + uuid + "'"); if(rs.next()) { isInDatabase = true; } else { isInDatabase = false; } return Boolean.valueOf(isInDatabase).booleanValue(); } public static void setNicked(String player, Boolean nicked) { OfflinePlayer pl = Bukkit.getOfflinePlayer(player); String uuid = pl.getUniqueId().toString(); Update("UPDATE nick SET nicked = " + nicked + " WHERE playeruuid = '" + uuid + "'"); } public static boolean isNicked(String player) { OfflinePlayer pl = Bukkit.getOfflinePlayer(player); String uuid = pl.getUniqueId().toString(); boolean nicked = false; ResultSet rs = Query("SELECT nicked FROM nick WHERE playeruuid = '" + uuid + "'"); try { while(rs.next()) { nicked = rs.getBoolean(1); } rs.close(); } catch (SQLException e) { e.printStackTrace(); } return nicked; } }
JoinEvent Klasse:
PHP:package me.lusu007.lobbysystem.Listener; import me.lusu007.lobbysystem.AutoNickSystem.Methoden.Nicks; import me.lusu007.lobbysystem.Main.Main; import me.lusu007.lobbysystem.Methoden.InventoryClear; import me.lusu007.lobbysystem.Methoden.InventoryItems; import me.lusu007.lobbysystem.MySQL.MySQL; import org.bukkit.Bukkit; import org.bukkit.entity.Player; import org.bukkit.event.EventHandler; import org.bukkit.event.Listener; import org.bukkit.event.player.PlayerJoinEvent; import java.util.Random; /** * Created by Lukas on 04.01.2015. */ public class PlayerJoinEvent_Listener implements Listener { private final Main plugin; private MySQL m; public PlayerJoinEvent_Listener(Main main) { this.plugin = main; plugin.getServer().getPluginManager().registerEvents(this, main); } @EventHandler public void onJoin(PlayerJoinEvent e) { final Player p = e.getPlayer(); InventoryClear.clearInv(p); InventoryClear.removeBoots(p); InventoryClear.clearEffects(p); InventoryClear.joinPlayer(p); InventoryItems.getInGameItems(p); e.setJoinMessage(null); Bukkit.getOnlinePlayers().forEach(player -> { if(player.hasPermission("server.join.message")){ player.sendMessage("§3Der Spieler §6" + p.getDisplayName() + " §3hat den Server betreten."); } }); //NickSystem if(!p.isOp()) { return; } try { if(!m.isInDatabase(p)) { m.createData(p.getName()); } } catch(Exception ex) { ex.printStackTrace(); } if(m.isNicked(p.getName())) { Nicks.loadNicks(); String s = plugin.nicks.get(new Random().nextInt(plugin.nicks.size())); Random r = new Random(); int zf = r.nextInt(2); switch(zf) { case 0: p.setDisplayName(""); p.setPlayerListName(""); p.sendMessage("§6Du spielst jetzt als " + p.getDisplayName() + "."); break; case 1: p.setDisplayName("§6" + s + "3r"); p.setPlayerListName("§6" + s); p.sendMessage("§6Du spielst jetzt als " + p.getDisplayName() + "."); break; } plugin.nicks.clear(); } else { p.setDisplayName("§a" + p.getName()); p.setDisplayName("§a" + p.getName()); } } }
Die Klasse für die Iteminteraktion:
PHP:package me.lusu007.lobbysystem.ItemManager; import me.lusu007.lobbysystem.Main.Main; import me.lusu007.lobbysystem.MySQL.MySQL; import org.bukkit.entity.Player; import org.bukkit.event.EventHandler; import org.bukkit.event.Listener; import org.bukkit.event.block.Action; import org.bukkit.event.player.PlayerInteractEvent; /** * Created by Lukas on 12.01.2015. */ public class Nicker implements Listener { private final Main plugin; private MySQL m; public Nicker(Main main) { this.plugin = main; plugin.getServer().getPluginManager().registerEvents(this, main); } @EventHandler public void onPlayerInteract(PlayerInteractEvent e) { if(e.getAction() == Action.RIGHT_CLICK_BLOCK | e.getAction() == Action.RIGHT_CLICK_AIR) { try { if(e.getItem().getItemMeta().getDisplayName().equalsIgnoreCase("§eAuto-Nicker")) { Player p = e.getPlayer(); if(m.isNicked(p.getName()) == true) { m.setNicked(p.getName(), false); p.sendMessage("§6AutoNick wurde §cdeaktiviert!"); } else { m.setNicked(p.getName(), true); p.sendMessage("§6AutoNick wurde §caktiviert!"); } } } catch(Exception ex) { } } } }
Ich hoffe ihr könnt mir helfen. Wenn ihr noch mehr Code braucht dann sagt bitte Bescheid.
Danke.
Gruß,
lusu007
"Deine".I'm StackTrace steht eindeutig, dass die Tabelle, in der deine Nicknames gespeichert sind nicht existiert. (erste Zeile im Stacktrace: "Table... does not exist"
Tabellen kannst du mit dem SQL Statement CREATE TABLE IF NOT EXISTS erstellen. Eine Anleitung dazu gibt es auf google.
Desweiteren empfehle ich dir dringendst, dir noch einmal die Grundlagen der Objektorientierten Programmierung anzueignen. Ich weise da nur auf deine SQL Klasse hin. ^^
LG Erik
I'm StackTrace steht eindeutig, dass die Tabelle, in der deine Nicknames gespeichert sind nicht existiert. (erste Zeile im Stacktrace: "Table... does not exist"
Tabellen kannst du mit dem SQL Statement CREATE TABLE IF NOT EXISTS erstellen. Eine Anleitung dazu gibt es auf google.
Desweiteren empfehle ich dir dringendst, dir noch einmal die Grundlagen der Objektorientierten Programmierung anzueignen. Ich weise da nur auf deine SQL Klasse hin. ^^
LG Erik
"Deine".
Hierzu nochmal, hier habe ich das Problem, das ich langsamm runter gehe. Also langsamm absinke.Damit der Spieler sich nicht bewegen kann.
Damit der Spieler Teleportiert wird:Java:player.setWalkSpeed(0); // laufgeschwindigkeit des Spielers wird auf 0 gesetzt player.setFlySpeed(0); player.addPotionEffect(new PotionEffect(PotionEffectType.JUMP, Integer.MAX_VALUE, -11)); // Negativer JumpBoost Effekt für kein Springen players.add(player.getUniqueId());
Java:new BukkitRunnable() { @Override public void run() { players.stream().filter(uuid -> Bukkit.getPlayer(uuid) != null).forEach(uuid -> { // Durch eine Liste mit Java 8 Lambda iterieren Player player = Bukkit.getPlayer(uuid); Location location = player.getLocation(); location.setPitch(0); location.setYaw(0); Location locTo = player.getLocation().add(1, 0, 0); // z-Wert um 1 erhöhen locTo.setPitch(0); locTo.setYaw(0); Vector vector = location.subtract(locTo).getDirection().multiply(0.38); // <-- der "spannende" Teil: //Eigentlich nur einfache Mathematik mit Vektoren - man bekommt die Richtung von zwei Orten, indem man den alten Vektor vom neuen Vektor subtrahiert. //'multiply(0.38)' vergrößert die Länge oder "Stärke" des Vektors um den Faktor 0.38. player.setVelocity(vector); }); } }.runTaskTimer(this, 0, 20); // wird jede Sekunde ausgeführt
Really?Kann man Plugins nur in Java schreiben?Oder geht auch C/C++?
Das gehtReally?
[17:11:46 WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[17:11:46 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[17:11:46 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
[17:11:46 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[17:11:46 WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
[17:11:46 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
[17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
[17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
[17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
[17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[17:11:46 WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[17:11:46 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[17:11:46 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
[17:11:46 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
[17:11:46 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
[17:11:46 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:664)
[17:11:46 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:247)
[17:11:46 WARN]: at de.spassballer.mglobby.sql.CoinsSQL.connect(CoinsSQL.java:64)
[17:11:46 WARN]: at de.spassballer.mglobby.MGLobby.loadSettings(MGLobby.java:185)
[17:11:46 WARN]: at de.spassballer.mglobby.MGLobby.onEnable(MGLobby.java:75)
[17:11:46 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316)
[17:11:46 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332)
[17:11:46 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:412)
[17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.java:476)
[17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.java:394)
[17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.reload(CraftServer.java:866)
[17:11:46 WARN]: at org.bukkit.Bukkit.reload(Bukkit.java:301)
[17:11:46 WARN]: at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:23)
[17:11:46 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:181)
[17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCommand(CraftServer.java:767)
[17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchServerCommand(CraftServer.java:753)
[17:11:46 WARN]: at net.minecraft.server.v1_7_R4.DedicatedServer.aB(DedicatedServer.java:326)
[17:11:46 WARN]: at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:290)
[17:11:46 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:584)
[17:11:46 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:490)
[17:11:46 WARN]: at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628)
[17:11:46 WARN]: Caused by: java.net.UnknownHostException: null: unknown error
[17:11:46 WARN]: at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
[17:11:46 WARN]: at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:907)
[17:11:46 WARN]: at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1302)
[17:11:46 WARN]: at java.net.InetAddress.getAllByName0(InetAddress.java:1255)
[17:11:46 WARN]: at java.net.InetAddress.getAllByName(InetAddress.java:1171)
[17:11:46 WARN]: at java.net.InetAddress.getAllByName(InetAddress.java:1105)
[17:11:46 WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)
[17:11:46 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
[17:11:46 WARN]: ... 33 more
Code?Hey, brauche Hilfe. Ich verstehe meinen Error nicht. (MySQL). Ich hoffe ihr könnt mir helfen.
Code:[17:11:46 WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. [17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [17:11:46 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [17:11:46 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:408) [17:11:46 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [17:11:46 WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) [17:11:46 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) [17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334) [17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) [17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) [17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) [17:11:46 WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) [17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [17:11:46 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [17:11:46 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [17:11:46 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:408) [17:11:46 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [17:11:46 WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) [17:11:46 WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) [17:11:46 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:664) [17:11:46 WARN]: at java.sql.DriverManager.getConnection(DriverManager.java:247) [17:11:46 WARN]: at de.spassballer.mglobby.sql.CoinsSQL.connect(CoinsSQL.java:64) [17:11:46 WARN]: at de.spassballer.mglobby.MGLobby.loadSettings(MGLobby.java:185) [17:11:46 WARN]: at de.spassballer.mglobby.MGLobby.onEnable(MGLobby.java:75) [17:11:46 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [17:11:46 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:332) [17:11:46 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:412) [17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.java:476) [17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.java:394) [17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.reload(CraftServer.java:866) [17:11:46 WARN]: at org.bukkit.Bukkit.reload(Bukkit.java:301) [17:11:46 WARN]: at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:23) [17:11:46 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:181) [17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCommand(CraftServer.java:767) [17:11:46 WARN]: at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchServerCommand(CraftServer.java:753) [17:11:46 WARN]: at net.minecraft.server.v1_7_R4.DedicatedServer.aB(DedicatedServer.java:326) [17:11:46 WARN]: at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:290) [17:11:46 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:584) [17:11:46 WARN]: at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:490) [17:11:46 WARN]: at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628) [17:11:46 WARN]: Caused by: java.net.UnknownHostException: null: unknown error [17:11:46 WARN]: at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) [17:11:46 WARN]: at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:907) [17:11:46 WARN]: at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1302) [17:11:46 WARN]: at java.net.InetAddress.getAllByName0(InetAddress.java:1255) [17:11:46 WARN]: at java.net.InetAddress.getAllByName(InetAddress.java:1171) [17:11:46 WARN]: at java.net.InetAddress.getAllByName(InetAddress.java:1105) [17:11:46 WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244) [17:11:46 WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) [17:11:46 WARN]: ... 33 more
-spassballer
[17:11:46 WARN]: Caused by: java.net.UnknownHostException: null: unknown error
Nen int in ner config speichern, wäre eine möglichkeit.Wie kann ich es machen das das Plugin z.b.Homes eines Spielers zählt und bei zu vielen eine Fehlermeldung an den Spieler schickt?
Wie meinst du das mit nem int?Nen int in ner config speichern, wäre eine möglichkeit.
Ne andere fällt mir gerade ein, weis aber nicht mehr genau, wie sie geht.
Ich gebe dir eine Lösung, du setzt sie Objektorientiert umWie kann ich es machen das das Plugin z.b.Homes eines Spielers zählt und bei zu vielen eine Fehlermeldung an den Spieler schickt?
Also über ne Hashmap ist mir das auch eingefallen aber ich wusste nicht wie.Ich gebe dir eine Lösung, du setzt sie Objektorientiert um
Spieler Objekt -> HashMap<String,HomeObjekt> -> OnCommand -> Home wird in der Config gesaved und zur HashMap mit dem Namen geaddet, wenn map.length < deine maximallänge ist. Beim Joinen lädt er die Homes aus der Config (per ConfigurationSection)