Coding mit Java | Java-basierten APIs

  • Ersteller Ersteller ij9F_i0FaF-d9lrDSDDpDbfo
  • Erstellt am Erstellt am
Status
Für weitere Antworten geschlossen.
Du hast
private MySQL mysql; geschrieben
Du brauchst eine istance also
private MySQL mysql = new MySQL ();
 
  • Like
Reaktionen: lusu007

Anhänge

  • Code 5.PNG
    Code 5.PNG
    39,2 KB · Aufrufe: 25
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

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".
 
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


Ok. Danke. Werde ich nochmal machen. Hab sowieso noch ein Buch über Java.



Ja, das ist nicht meine Klasse, aber ich hatte halt einen Fehler gemacht....
Und habe das erste mal etwas mit MySQL programmiert und das erste mal ein NickSystem programmiert.
 
Zuletzt bearbeitet:
Ok ich habe mich unklar ausgedrückt: Wie kann ich eine neue Schriftart installieren xD
 
Damit der Spieler sich nicht bewegen kann.
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());
Damit der Spieler Teleportiert wird:
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
Hierzu nochmal, hier habe ich das Problem, das ich langsamm runter gehe. Also langsamm absinke.
 
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
 
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
Code?

Code:
[17:11:46 WARN]: Caused by: java.net.UnknownHostException: null: unknown error
Ist die DB IP vlt. null?
 
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?
 
PHP:
config.setInt("Homes.Player.Total", int);

Sollte so funktionieren. Habe seit mehr als nem halben Jahr keine config mehr verwendet. Kann evtl. falsch sein (MySQL is 4 the win)
 
  • Like
Reaktionen: Crysky
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?
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)
 
  • Like
Reaktionen: ilouHD
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)
Also über ne Hashmap ist mir das auch eingefallen aber ich wusste nicht wie.
 
Status
Für weitere Antworten geschlossen.

Soziale Medien

  • X
  • TikTok

Über uns

  • GommeHD.net ist einer der größten Minecraft-Server der Welt. Dir gefällt unser Server? Dann unterstütze uns durch einen Kauf im Shop!
  • Shop