[Pytanie] XAuth MySQL

[CzAcHa9811]

Jak utworzyć tabele:

 

 

accounts

locations

lockouts

playerdata

sessions

W bazie MYSQL Jakie dać zapytania?

czy może zrobic to za pomocą kreatora? (tylko jak)

['Raczek]

Juz mam. Wchodzisz w config. Tam podajesz zamiast localhost etc dane do mysql. Pliki z folderu sql wgrywasz na baze danych.

[CzAcHa9811]

Mi się nie tworzą żadne pliki w SQL : /

 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mc.accounts' doesn't exist

at sun.reflect.GeneratedConstructorAccessor46.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

at com.mysql.jdbc.Util.getInstance(Util.java:382)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)

at com.cypherx.xauth.PlayerManager.createAccount(PlayerManager.java:494)

at com.cypherx.xauth.auth.AuthSQL.execRegQuery(AuthSQL.java:99)

at com.cypherx.xauth.auth.AuthSQL.register(AuthSQL.java:85)

at com.cypherx.xauth.commands.RegisterCommand.onCommand(RegisterCommand.java:53)

at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)

at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:189)

at org.bukkit.craftbukkit.v1_5_R3.CraftServer.dispatchCommand(CraftServer.java:523)

at net.minecraft.server.v1_5_R3.PlayerConnection.handleCommand(PlayerConnection.java:965)

at net.minecraft.server.v1_5_R3.PlayerConnection.chat(PlayerConnection.java:883)

at net.minecraft.server.v1_5_R3.PlayerConnection.a(PlayerConnection.java:840)

at net.minecraft.server.v1_5_R3.Packet3Chat.handle(Packet3Chat.java:44)

at net.minecraft.server.v1_5_R3.NetworkManager.b(NetworkManager.java:292)

at net.minecraft.server.v1_5_R3.PlayerConnection.d(PlayerConnection.java:109)

at net.minecraft.server.v1_5_R3.ServerConnection.b(SourceFile:35)

at net.minecraft.server.v1_5_R3.DedicatedServerConnection.b(SourceFile:30)

at net.minecraft.server.v1_5_R3.MinecraftServer.r(MinecraftServer.java:581)

at net.minecraft.server.v1_5_R3.DedicatedServer.r(DedicatedServer.java:226)

at net.minecraft.server.v1_5_R3.MinecraftServer.q(MinecraftServer.java:477)

at net.minecraft.server.v1_5_R3.MinecraftServer.run(MinecraftServer.java:410)

at net.minecraft.server.v1_5_R3.ThreadServerApplication.run(SourceFile:573)

[CzAcHa9811]

Jakieś pomysły?

[Gość]

Ja ci polecam uzywac authme jesli chodzi o polaczenie z sql

[HItman01]

Trudne :/