script options:
$ init com.mysql.jdbc.Driver
$ db url jdbc:mysql://[pewne dane]:3306/[pewne dane]
$ db username [pewne dane]
$ db password [pewne dane]
on join:
set {_IP::%player%} to player's ip
set {_czyZweryfikowany::%player%} to objects in column "tickets" from result of query "SELECT * FROM tickets WHERE ip = '%{_IP::%player%}%'" and close
if {_czyZweryfikowany::%player%} is not set:
No i w konsolce mam taki error:
Cytat
[15:52:19] [Server thread/INFO]: [Skript] Reloading the config and all scripts...
[15:52:21] [Server thread/INFO]: Loaded 17865 aliases in 1297ms
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! [Skript] Severe Error:
[15:52:21] [Server thread/ERROR]: #!#! Could not load playerVerification.sk
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! Something went horribly wrong with Skript.
[15:52:21] [Server thread/ERROR]: #!#! This issue is NOT your fault! You probably can't fix it yourself, either.
[15:52:21] [Server thread/ERROR]: #!#! You're running outdated version of Skript! Please try updating it NOW; it might fix this.
[15:52:21] [Server thread/ERROR]: #!#! Run /sk update check to get a download link to latest Skript!
[15:52:21] [Server thread/ERROR]: #!#! You will be given instructions how to report this error if it persists after update.
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! Stack trace:
[15:52:21] [Server thread/ERROR]: #!#! java.lang.NullPointerException
[15:52:21] [Server thread/ERROR]: #!#! at com.w00tmast3r.skquery.sql.ScriptCredentials.get(ScriptCredentials.java:50)
[15:52:21] [Server thread/ERROR]: #!#! at com.w00tmast3r.skquery.sql.ScriptCredentials.get(ScriptCredentials.java:43)
[15:52:21] [Server thread/ERROR]: #!#! at com.w00tmast3r.skquery.sql.ScriptCredentials.setURL(ScriptCredentials.java:17)
[15:52:21] [Server thread/ERROR]: #!#! at com.w00tmast3r.skquery.elements.effects.EffOptionSQLURL.register(EffOptionSQLURL.java:21)
[15:52:21] [Server thread/ERROR]: #!#! at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)
[15:52:21] [Server thread/ERROR]: #!#! at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:252)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:179)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.Statement.parse(Statement.java:59)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:976)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:662)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.lambda$1(ScriptLoader.java:390)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:402)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.lambda$0(ScriptLoader.java:332)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:362)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.Skript.reload(Skript.java:909)
[15:52:21] [Server thread/ERROR]: #!#! at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:155)
[15:52:21] [Server thread/ERROR]: #!#! at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[15:52:21] [Server thread/ERROR]: #!#! at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:151)
[15:52:21] [Server thread/ERROR]: #!#! at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:685)
[15:52:21] [Server thread/ERROR]: #!#! at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchServerCommand(CraftServer.java:648)
[15:52:21] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_12_R1.DedicatedServer.aP(DedicatedServer.java:463)
[15:52:21] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:424)
[15:52:21] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:774)
[15:52:21] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:666)
[15:52:21] [Server thread/ERROR]: #!#! at java.lang.Thread.run(Unknown Source)
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! Version Information:
[15:52:21] [Server thread/ERROR]: #!#! Skript: 2.3.1 (OUTDATED)
[15:52:21] [Server thread/ERROR]: #!#! Flavor: skriptlang-github
[15:52:21] [Server thread/ERROR]: #!#! Date: 2019-01-05
[15:52:21] [Server thread/ERROR]: #!#! Bukkit: 1.12.2-R0.1-SNAPSHOT
[15:52:21] [Server thread/ERROR]: #!#! Minecraft: 1.12.2
[15:52:21] [Server thread/ERROR]: #!#! Java: 1.8.0_201 (Java HotSpot(TM) 64-Bit Server VM 25.201-b09)
[15:52:21] [Server thread/ERROR]: #!#! OS: Windows 10 amd64 10.0
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! Server platform: Paper
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! Current node: $ db url jdbc:mysql://hosting.pukawka.pl:3306/715534 (playerVerification.sk, line 3)
[15:52:21] [Server thread/ERROR]: #!#! Current item: null
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! Thread: Server thread
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! Language: english
[15:52:21] [Server thread/ERROR]: #!#! Link parse mode: DISABLED
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/ERROR]: #!#! End of Error.
[15:52:21] [Server thread/ERROR]: #!#!
[15:52:21] [Server thread/INFO]: All scripts loaded without errors.
[15:52:21] [Server thread/INFO]: Loaded 1 script with a total of 0 triggers and 0 commands in 0.01 seconds
[15:52:21] [Server thread/INFO]: [Skript] Successfully reloaded the config and all scripts.
No i ze strony WWW wszystko działa, zapisuje się do MySQL itd. Zadaniem tego skryptu jest sprawdzeniem czy w bazie jest rekord z adresem IP użytkownika (gdzie ip = %{_Zmienna.z.IP.gracza}%). Tylko to nie działa (nie odczytuje). Poprawiłby mi to ktoś?? Z góry dzięki
Pytanie
Gość KuzynProcesor
Pisałem sobie taki skrypt:
script options: $ init com.mysql.jdbc.Driver $ db url jdbc:mysql://[pewne dane]:3306/[pewne dane] $ db username [pewne dane] $ db password [pewne dane] on join: set {_IP::%player%} to player's ip set {_czyZweryfikowany::%player%} to objects in column "tickets" from result of query "SELECT * FROM tickets WHERE ip = '%{_IP::%player%}%'" and close if {_czyZweryfikowany::%player%} is not set:No i w konsolce mam taki error:
No i ze strony WWW wszystko działa, zapisuje się do MySQL itd. Zadaniem tego skryptu jest sprawdzeniem czy w bazie jest rekord z adresem IP użytkownika (gdzie ip = %{_Zmienna.z.IP.gracza}%). Tylko to nie działa (nie odczytuje). Poprawiłby mi to ktoś?? Z góry dzięki
Odnośnik do komentarza
https://skript.pl/temat/32214-b%C5%82%C4%85d-z-skquery/Udostępnij na innych stronach
0 odpowiedzi na to pytanie
Rekomendowane odpowiedzi
Dołącz do dyskusji
Możesz dodać zawartość już teraz a zarejestrować się później. Jeśli posiadasz już konto, zaloguj się aby dodać zawartość za jego pomocą.