Skript Version (do not put latest): Skript 2.2 (dev33)
Skript Author: Bensku
Minecraft Version: 1.8.8
---
Full Code:
Errors on Reload:
Console Errors: (if applicable)
Addons using (including versions):
Skellett 1.9.6b
SkQuery 3.6.0-Lime
skRayFall+v1.9.12
Skript dev33
SkStuff
WildSkript 1.7-1.8
Skript Author: Bensku
Minecraft Version: 1.8.8
---
Full Code:
code_language.skript:
script options:
$ db url jdbc:mysql://localhost:3306/????
$ db username ????
$ db password ????
options:
f_level: 1
f_minEXP: 0
f_maxEXP: 100
f_str: 1
f_agi: 1
f_dex: 1
f_point: 1
function getStatus(p:player):
set {_Level::*} to objects in column "level" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_minEXP::*} to objects in column "minEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_maxEXP::*} to objects in column "maxEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_STR::*} to objects in column "str" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_AGI::*} to objects in column "agi" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_DEX::*} to objects in column "dex" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_point::*} to objects in column "point" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
send " Level: %{_Level::*}% ( EXP: %{_minEXP::*}%/%{_maxEXP::*}% )" to {_p}
send " STR: %{_STR::*}%" to {_p}
send " AGI: %{_AGI::*}%" to {_p}
send " DEX: %{_DEX::*}%" to {_p}
send " Status Point: %{_point::*}%" to {_p}
function LevelUP(p:player):
set {_Level::*} to objects in column "level" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_minEXP::*} to objects in column "minEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_maxEXP::*} to objects in column "maxEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
set {_min} to "%{_minEXP::*}%" parsed as integer
set {_max} to "%{_maxEXP::*}%" parsed as integer
if {_Level::*} <= 10:
set {_nextEXP} to 1000
else if {_Level::*} <= 50:
set {_nextEXP} to 5000
else if {_Level::*} <= 99:
set {_nextEXP} to 10000
if {_min} >= {_max}:
update "UPDATE `mc_user_status` SET `level`= `level`+1,`maxEXP`=`maxEXP`+'%{_nextEXP}%',`point`=`point`+1 WHERE `username` = '%{_p}%'"
send {_p} title "Level UP!"
function setEXP(p:player):
update "UPDATE `mc_user_status` SET `minEXP`=`minEXP`+10 WHERE `username` = '%{_p}%'"
LevelUP({_p})
on join:
set {_Username::*} to objects in column "username" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%player%'"
if {_Username::*} is not set:
send "%{_Username::*}%"
update "INSERT INTO `mc_user_status` (`username`, `level`, `minEXP`, `maxEXP`, `str`, `agi`, `dex`, `point`) VALUES ('%player%','{@f_level}','{@f_minEXP}','{@f_maxEXP}','{@f_str}','{@f_agi}','{@f_dex}','{@f_point}')"
command /level:
trigger:
getStatus(player)
on death:
setEXP(attacker)
Errors on Reload:
code_language.skript:
reload is successfuilly
Console Errors: (if applicable)
code_language.skript:
[12:35:31] [Server thread/WARN]: java.sql.SQLException: Operation not allowed after ResultSet closed
[12:35:31] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
[12:35:31] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
[12:35:31] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
[12:35:31] [Server thread/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
[12:35:31] [Server thread/WARN]: at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
[12:35:31] [Server thread/WARN]: at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7145)
[12:35:31] [Server thread/WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQueryObjects.get(ExprSQLQueryObjects.java:33)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:104)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.effects.EffChange.execute(EffChange.java:268)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.lang.Effect.run(Effect.java:52)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:61)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:89)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.lang.Trigger.execute(Trigger.java:55)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.SkriptEventHandler.check(SkriptEventHandler.java:151)
[12:35:31] [Server thread/WARN]: at ch.njol.skript.SkriptEventHandler$1.execute(SkriptEventHandler.java:109)
[12:35:31] [Server thread/WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[12:35:31] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502)
[12:35:31] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.PlayerList.onPlayerJoin(PlayerList.java:298)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.PlayerList.a(PlayerList.java:157)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.LoginListener.b(LoginListener.java:144)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.LoginListener.c(LoginListener.java:54)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.NetworkManager.a(NetworkManager.java:231)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.ServerConnection.c(ServerConnection.java:148)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:814)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
[12:35:31] [Server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
[12:35:31] [Server thread/WARN]: at java.lang.Thread.run(Unknown Source)
Addons using (including versions):
Skellett 1.9.6b
SkQuery 3.6.0-Lime
skRayFall+v1.9.12
Skript dev33
SkStuff
WildSkript 1.7-1.8