Plugin Request Whitelisted with Gametime

Discussion in 'Plugin Help/Development/Requests' started by Karanja, Mar 23, 2015.

Thread Status:
Not open for further replies.
  1. Offline

    Karanja

    Plugin category: Miscelanneous

    Suggested name: WhitelistGameTime

    What I want:
    Basically:
    I would like a plugin that automatically adds a user to the whitelist when they buy Gametime, but removes them after their Gametime has expired.

    More Detailed:
    When a user tries to login to our server he/she will get the message "This server is membership only, you can get your membership at xxxxxxxxxxxxx".

    The user then goes to the specified address and buys a membership that includes xx days of Gametime.
    Now the user will be automatically added to the whitelist for xx days.

    The user really likes the server and wants to add more Gametime, he/she buys 30 days more of Gametime to their current amount of Gametime, let's say the user has 11 days left, then there should be added 30 days to his/her current Gametime so that the user will have 41 days of Gametime in total after buying extra Gametime.

    When a user reaches 10 days of Gametime left, they should receive a "warning" ingame that they have 10 days of Gametime left, this should also happen on 5 days left, 2 days left and 1 day left.

    When the Gametime expires, the user should be removed from the whitelist and will not be having access to the server anymore untill they buy new Gametime.

    After the Gametime has expired, the user should get automatically kicked from the server with a message saying "Your Gametime has expired, you can buy new Gametime at xxxxxxx".

    When a user was not online when his/her Gametime expired he/she should receive a message that says "Your Gametime has expired, you can buy new Gametime at xxxxxxx".

    Players will have the possibillity to choose between different amounts of Gametime to buy trough Buycraft.
    For example 30 - 60 - 90 days of Gametime.

    They will only be able to buy Gametime packages after they have bought the Membership package which already includes Gametime.

    When a user changes his/her IGN their Membership and Gametime should be transfered to their new IGN.

    It is very important that when a users Gametime has expired, they will not loose anything, everything they have in their inventory should stay there.

    The plugin should work with:
    - Buycraft
    - GroupManager
    - Bukkit 1.8.1 and higher

    Ideas for commands:
    /whitelist add <name> <time> (To add the person to the whitelist for a certain amount of days f.e. "30d")
    /gametime (Will give the player the amount of days that he/she has left including the date their subscription will run out f.e.: "You have 5 days of Gametime remaining, your subscription will expire on 29-03-2015")

    Or if you have other/better commands please let me know :)

    Ideas for permissions:
    whitelist.gametime.exempt (with this permission, a player's gametime will never run out.)

    And whatever permissions are needed as well.

    When I'd like it by: As soon as possible.
     
  2. Offline

    timtower Moderator Moderator

    Moved to Bukkit alternatives.
     
  3. Offline

    pie_flavor

    @Karanja I believe that this violates the EULA.
     
  4. Offline

    nverdier

    @pie_flavor Nope. Quote from https://mojang.com/2014/06/lets-talk-server-monetisation/:
     
  5. Offline

    Karanja

    thank you @nverdier

    We looked it up indeed if it was allowed :)
     
  6. Offline

    Karanja

    *Bump*

    Anyone that can please help with this? :)
     
  7. Offline

    pie_flavor

    @Karanja I might be able to make this.
    If the player does not play for 2 days, is that 1 day of gametime gone when they next play or 3?
     
  8. Offline

    Karanja

    @pie_flavor thank you very much :)

    Yes each day counts as a day, played or not :)
    So if they buy 30 days of Gametime on the 1st of March, that Gametime will run out 30 days later, so the 31st of March :)
     
  9. Offline

    pie_flavor

    @Karanja which java version do you use?
    Also, I haven't worked much with Buycraft, although I do understand all I have to do is code a command. But does Buycraft support UUIDs? Because that will simplify this.
     
    Last edited: Mar 26, 2015
  10. Offline

    Karanja

    @pie_flavor I probably gonna need to ask my host which java version is used, i tried to find it in the log files but no luck there. So i will come back to you on that :)

    As for Buycraft, in version 6.7 they have added support for the {uuid} variable, according to their changelog.
     
  11. Offline

    pie_flavor

    @Karanja I have finished the plugin, which will work on Java 1.7 but not in Java 1.6. WhitelistGametime.jar
    The config contains two values, "message" and "expired". "message" is the message to kick the user with if they have never logged in before, "expired" is the message to kick them with if their membership has expired. Both values support %player%, %uuid%, and color codes.
    This plugin does not use the whitelist, it emulates it. So make sure to turn whitelist off before installing this.

    When a player's time runs out, they are soon kicked. The exact mechanics are as follows: If they right click or left click anything besides an entity, they are checked. If they type a command, they are checked. If they chat, they are put into a queue, and will be kicked next time someone else types a command or right/left clicks anything. This is to avoid slowing down chat. Please tell me if you see a potential security hole.

    I have not tested this plugin yet, please do so before using on a network.
     
  12. Offline

    Karanja

    @pie_flavor thank you! i am gonna try it out as soon as possible and let you know :)
     
  13. Offline

    Karanja

    @pie_flavor i have set up a test server to see what happens, it gives an error in the console:

    Code:
    30.03 11:54:24 [Server] Startup Done (2.217s)! For help, type "help" or "?"
    30.03 11:54:24 [Server] INFO Server permissions file permissions.yml is empty, ignoring it
    30.03 11:54:24 [Multicraft] Skipped 20 lines due to rate limit (30/s)
    30.03 11:54:24 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:281) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO Caused by: java.lang.RuntimeException: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                    timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    30.03 11:54:24 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    30.03 11:54:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.init(DedicatedServer.java:236) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.a(MinecraftServer.java:329) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.k(MinecraftServer.java:374) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.r(MinecraftServer.java:408) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.enablePlugins(CraftServer.java:313) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.loadPlugin(CraftServer.java:341) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:327) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at plugin.WhitelistGametime.onEnable(WhitelistGametime.java:41) ~[?:?]
    30.03 11:54:24 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.installDDL(JavaPlugin.java:477) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:233) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    30.03 11:54:24 [Server] INFO javax.persistence.PersistenceException: Error: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                    timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    30.03 11:54:24 [Server] ERROR Error occurred while enabling WhitelistGametime v1.0 (Is it up to date?)
    30.03 11:54:24 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.2] busy[3] max[20]
    30.03 11:54:24 [Server] INFO Closing Connection[WhitelistGametime.0] psReuse[0] psCreate[1] psSize[0]
    30.03 11:54:24 [Server] INFO Can not test connection as heartbeatsql is not set
    30.03 11:54:24 [Server] INFO executing 1 of 1 create table whitelist-gametime ( id                        varchar(255) primary...
    30.03 11:54:24 [Server] INFO runScript
    30.03 11:54:24 [Server] WARN Column name [limit] is a suspected SQL reserved word for property plugin.WhitelistGametime$Entry.limit
    30.03 11:54:24 [Server] INFO Closing Connection[WhitelistGametime.1] psReuse[0] psCreate[1] psSize[0]
    30.03 11:54:24 [Server] INFO Can not test connection as heartbeatsql is not set
    30.03 11:54:24 [Server] INFO Enabling WhitelistGametime v1.0
    30.03 11:54:24 [Server] INFO Preparing start region for level 2 (Seed: xxxxxxxxxxxxxxxxxxxxxxx)
    30.03 11:54:23 [Server] INFO Preparing start region for level 1 (Seed: xxxxxxxxxxxxxxxxxxxxxxx)
    30.03 11:54:23 [Server] INFO Preparing spawn area: 92%
    30.03 11:54:22 [Server] INFO Preparing start region for level 0 (Seed: xxxxxxxxxxxxxxxxxxxxxxx)
    30.03 11:54:22 [Server] INFO Preparing level "world"
    30.03 11:54:22 [Server] INFO Loading Buycraft v6.7
    30.03 11:54:22 [Server] INFO Loading WhitelistGametime v1.0
    30.03 11:54:22 [Server] INFO Entities enhanced[0] subclassed[1]
    30.03 11:54:21 [Server] INFO SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    30.03 11:54:21 [Server] INFO DataSourcePool [WhitelistGametime] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    30.03 11:54:21 [Server] ERROR ebean.properties not found
    30.03 11:54:21 [Server] INFO This server is running CraftBukkit version git-Bukkit-234e607 (MC: 1.8.3) (Implementing API version 1.8.3-R0.1-SNAPSHOT)
    30.03 11:54:21 [Server] INFO Using epoll channel type
    30.03 11:54:21 [Server] INFO Starting Minecraft server on xxxxxxxxxxxxxxxxxxxxx
    30.03 11:54:20 [Server] INFO Generating keypair
    30.03 11:54:20 [Server] INFO Default game type: SURVIVAL
    30.03 11:54:20 [Server] INFO Loading properties
    30.03 11:54:20 [Server] INFO Starting minecraft server version 1.8.3
    30.03 11:54:11 [Server] INFO Loading libraries, please wait...
    30.03 11:54:11 [Multicraft] Updating eula.txt file
    30.03 11:54:10 [Multicraft] Loaded config for "[1.8.3] Craftbukkit Beta"
    30.03 11:54:10 [Multicraft] Starting server!
    
    I started with a fresh server, installed buycraft, and then i have installed WhitelistGametime, by just dropping the jar in the plugin folder, as it was just a test, i did not change anything in the files themself.

    I also went on the server to see if by any chance it did work, but i could do everything (break blocks, chat) without getting kicked. I did make sure i was not in OP mode :)
     
  14. Offline

    pie_flavor

    @Karanja Redownload the plugin. Fixed it.
     
  15. Offline

    Karanja

    @pie_flavor i removed the old one, uploaded the new one :

    Code:
    31.03 12:42:24 [Multicraft] Stopping server!
    31.03 12:42:24 [Multicraft] Received stop command
    31.03 12:41:09 [Server] INFO Karanja left the game.
    31.03 12:41:09 [Disconnect] User Karanja has disconnected, reason: Disconnected
    31.03 12:41:09 [Multicraft] Skipped 120 lines due to rate limit (30/s)
    31.03 12:40:52 [Server] INFO where t0.id = ? 
    31.03 12:40:52 [Server] INFO from whitelist-gametime t0
    31.03 12:40:52 [Server] INFO select t0.id c0, t0.limit c1
    31.03 12:40:52 [Server] INFO Query was:
    31.03 12:40:52 [Server] INFO Bind values:[null]
    31.03 12:40:52 [Server] INFO Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (near "limit": syntax error)
    31.03 12:40:52 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:534) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:626) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:336) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:670) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.SystemUtils.a(SourceFile:60) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at java.util.concurrent.FutureTask.run(FutureTask.java:262) [?:1.7.0_75]
    31.03 12:40:52 [Server] INFO at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [?:1.7.0_75]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerConnectionUtils$1.run(SourceFile:13) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.PacketPlayInBlockDig.a(SourceFile:10) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.PacketPlayInBlockDig.a(SourceFile:40) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerConnection.a(PlayerConnection.java:583) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerInteractManager.a(PlayerInteractManager.java:107) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:176) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:209) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:486) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:297) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:52 [Server] INFO org.bukkit.event.EventException
    31.03 12:40:52 [Server] ERROR Could not pass event PlayerInteractEvent to WhitelistGametime v1.0
    31.03 12:40:52 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.6] busy[7] max[20]
    31.03 12:40:52 [Server] INFO Closing Connection[WhitelistGametime.5] psReuse[0] psCreate[1] psSize[0]
    31.03 12:40:52 [Server] INFO Can not test connection as heartbeatsql is not set
    31.03 12:40:40 [Multicraft] Karanja ran command Bericht van de dag
    31.03 12:40:40 [Connect] User Karanja, IP unknown
    31.03 12:40:40 [Multicraft] Skipped 44 lines due to rate limit (30/s)
    31.03 12:40:28 [Server] INFO where t0.id = ? 
    31.03 12:40:28 [Server] INFO from whitelist-gametime t0
    31.03 12:40:28 [Server] INFO select t0.id c0, t0.limit c1
    31.03 12:40:28 [Server] INFO Query was:
    31.03 12:40:28 [Server] INFO Bind values:[null]
    31.03 12:40:28 [Server] INFO Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (near "limit": syntax error)
    31.03 12:40:28 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:534) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:626) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:336) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:670) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.SystemUtils.a(SourceFile:60) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at java.util.concurrent.FutureTask.run(FutureTask.java:262) [?:1.7.0_75]
    31.03 12:40:28 [Server] INFO at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [?:1.7.0_75]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerConnectionUtils$1.run(SourceFile:13) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.PacketPlayInBlockPlace.a(PacketPlayInBlockPlace.java:1) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.PacketPlayInBlockPlace.a(PacketPlayInBlockPlace.java:52) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerConnection.a(PlayerConnection.java:703) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerInteractManager.interact(PlayerInteractManager.java:462) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:209) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:486) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:297) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:28 [Server] INFO org.bukkit.event.EventException
    31.03 12:40:28 [Server] ERROR Could not pass event PlayerInteractEvent to WhitelistGametime v1.0
    31.03 12:40:28 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.5] busy[6] max[20]
    31.03 12:40:28 [Server] INFO Closing Connection[WhitelistGametime.4] psReuse[0] psCreate[1] psSize[0]
    31.03 12:40:28 [Server] INFO Can not test connection as heartbeatsql is not set
    31.03 12:40:28 [Multicraft] Skipped 45 lines due to rate limit (30/s)
    31.03 12:40:24 [Server] INFO where t0.id = ? 
    31.03 12:40:24 [Server] INFO from whitelist-gametime t0
    31.03 12:40:24 [Server] INFO select t0.id c0, t0.limit c1
    31.03 12:40:24 [Server] INFO Query was:
    31.03 12:40:24 [Server] INFO Bind values:[null]
    31.03 12:40:24 [Server] INFO Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (near "limit": syntax error)
    31.03 12:40:24 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:534) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:626) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:336) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:670) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.SystemUtils.a(SourceFile:60) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at java.util.concurrent.FutureTask.run(FutureTask.java:262) [?:1.7.0_75]
    31.03 12:40:24 [Server] INFO at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [?:1.7.0_75]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerConnectionUtils$1.run(SourceFile:13) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.PacketPlayInBlockDig.a(SourceFile:10) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.PacketPlayInBlockDig.a(SourceFile:40) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerConnection.a(PlayerConnection.java:583) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerInteractManager.a(PlayerInteractManager.java:107) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:176) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:209) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:486) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:297) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:24 [Server] INFO org.bukkit.event.EventException
    31.03 12:40:24 [Server] ERROR Could not pass event PlayerInteractEvent to WhitelistGametime v1.0
    31.03 12:40:24 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.4] busy[5] max[20]
    31.03 12:40:24 [Server] INFO Closing Connection[WhitelistGametime.3] psReuse[0] psCreate[1] psSize[0]
    31.03 12:40:24 [Server] INFO Can not test connection as heartbeatsql is not set
    31.03 12:40:24 [Multicraft] Skipped 42 lines due to rate limit (30/s)
    31.03 12:40:19 [Server] INFO at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:814) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:834) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO where t0.id = ? 
    31.03 12:40:19 [Server] INFO from whitelist-gametime t0
    31.03 12:40:19 [Server] INFO select t0.id c0, t0.limit c1
    31.03 12:40:19 [Server] INFO Query was:
    31.03 12:40:19 [Server] INFO Bind values:[null]
    31.03 12:40:19 [Server] INFO Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (near "limit": syntax error)
    31.03 12:40:19 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:534) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:626) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:336) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:742) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.ServerConnection.c(SourceFile:168) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.NetworkManager.a(NetworkManager.java:222) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.LoginListener.c(LoginListener.java:53) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.LoginListener.b(LoginListener.java:89) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at net.minecraft.server.v1_8_R2.PlayerList.attemptLogin(PlayerList.java:439) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:486) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:297) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:40:19 [Server] INFO org.bukkit.event.EventException
    31.03 12:40:19 [Server] ERROR Could not pass event PlayerLoginEvent to WhitelistGametime v1.0
    31.03 12:40:19 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.3] busy[4] max[20]
    31.03 12:40:19 [Server] INFO Closing Connection[WhitelistGametime.2] psReuse[0] psCreate[1] psSize[0]
    31.03 12:40:19 [Server] INFO Can not test connection as heartbeatsql is not set
    31.03 12:40:19 [Server] INFO UUID of player Karanja is xxxxxxxxxxxxxxxxxxxxxx
    31.03 12:39:38 [Server] INFO Loaded 4 package(s) into the cache.
    31.03 12:39:38 [Multicraft] Skipped 21 lines due to rate limit (30/s)
    31.03 12:39:37 [Server] Startup Done (2.475s)! For help, type "help" or "?"
    31.03 12:39:37 [Server] INFO ... 13 more
    31.03 12:39:37 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:224) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:246) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:281) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO Caused by: java.lang.RuntimeException: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                     timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    31.03 12:39:37 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    31.03 12:39:37 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.init(DedicatedServer.java:236) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.a(MinecraftServer.java:329) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.k(MinecraftServer.java:374) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.r(MinecraftServer.java:408) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.enablePlugins(CraftServer.java:313) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.loadPlugin(CraftServer.java:341) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:327) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at plugin.WhitelistGametime.onEnable(WhitelistGametime.java:41) ~[?:?]
    31.03 12:39:37 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.installDDL(JavaPlugin.java:477) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:233) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    31.03 12:39:37 [Server] INFO javax.persistence.PersistenceException: Error: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                     timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    31.03 12:39:37 [Server] ERROR Error occurred while enabling WhitelistGametime v1.0 (Is it up to date?)
    31.03 12:39:37 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.2] busy[3] max[20]
    31.03 12:39:37 [Server] INFO Closing Connection[WhitelistGametime.0] psReuse[0] psCreate[1] psSize[0]
    31.03 12:39:37 [Server] INFO Can not test connection as heartbeatsql is not set
    31.03 12:39:37 [Server] INFO executing 1 of 1 create table whitelist-gametime ( id                        varchar(255) primary...
    31.03 12:39:37 [Server] INFO runScript
    31.03 12:39:37 [Server] WARN Column name [limit] is a suspected SQL reserved word for property plugin.WhitelistGametime$Entry.limit
    31.03 12:39:37 [Server] INFO Closing Connection[WhitelistGametime.1] psReuse[0] psCreate[1] psSize[0]
    31.03 12:39:37 [Server] INFO Can not test connection as heartbeatsql is not set
    31.03 12:39:37 [Server] INFO Enabling WhitelistGametime v1.0
    31.03 12:39:37 [Server] INFO Preparing start region for level 2 (Seed: -xxxxxxxxx)
    31.03 12:39:36 [Server] INFO Preparing start region for level 1 (Seed: -xxxxxxxxx)
    31.03 12:39:36 [Server] INFO Preparing spawn area: 88%
    31.03 12:39:35 [Server] INFO Preparing start region for level 0 (Seed: -xxxxxxxxx)
    31.03 12:39:35 [Server] INFO Preparing level "world"
    31.03 12:39:35 [Server] INFO Loading Buycraft v6.7
    31.03 12:39:35 [Server] INFO Loading WhitelistGametime v1.0
    31.03 12:39:34 [Server] INFO Entities enhanced[0] subclassed[1]
    31.03 12:39:34 [Server] INFO SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    31.03 12:39:34 [Server] INFO DataSourcePool [WhitelistGametime] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    31.03 12:39:34 [Server] ERROR ebean.properties not found
    31.03 12:39:34 [Server] INFO This server is running CraftBukkit version git-Bukkit-234e607 (MC: 1.8.3) (Implementing API version 1.8.3-R0.1-SNAPSHOT)
    31.03 12:39:34 [Server] INFO Using epoll channel type
    31.03 12:39:34 [Server] INFO Starting Minecraft server on xxxxxxxxxxxxxxxxx
    31.03 12:39:33 [Server] INFO Generating keypair
    31.03 12:39:33 [Server] INFO Default game type: SURVIVAL
    31.03 12:39:33 [Server] INFO Loading properties
    31.03 12:39:33 [Server] WARN To start the server with more ram, launch it as "java -Xmx1024M -Xms1024M -jar minecraft_server.jar"
    31.03 12:39:33 [Server] INFO Starting minecraft server version 1.8.3
    31.03 12:39:23 [Server] INFO Loading libraries, please wait...
    31.03 12:39:23 [Multicraft] Updating eula.txt file
    31.03 12:39:23 [Multicraft] Loaded config for "[1.8.3] Craftbukkit Beta"
    31.03 12:39:23 [Multicraft] Starting server!
    
     
  16. Offline

    pie_flavor

    @Karanja I really don't know. It's got to be a Bukkit-side error.
     
  17. Offline

    Karanja

    @pie_flavor that is not good then :(

    i did look at the errors myself better and at the files on the server... trying to understand :)

    I came across this line:
    Code:
    31.03 12:40:52 [Server] INFO Caused by: javax.persistence.PersistenceException: Query threw SQLException:[SQLITE_ERROR] SQL error or missing database (near "limit": syntax error)
    
    It seems like it does not recognise the database, so i went into the files and i cannot edit any database info as the only file on the server is: "WhitelistGametime.db" there is no config file in it either?

    While when i extract the "WhitelistGametime.jar" it does give me a config.yml and plugin.yml that i can edit.
     
  18. Offline

    pie_flavor

    @Karanja WhitelistGametime.db is the database. (data base). I'm not actually sure why I put in a config.
     
  19. Offline

    Karanja

    @pie_flavor well im guessing you put in the config file so i can edit the message that is displayed? :)
    And yes, i know a .db file is a database file :) but apparantly the server cannot find that file?
     
  20. Offline

    pie_flavor

    @Karanja Try deleting the entire data folder and trying again.
     
  21. Offline

    Karanja

    @pie_flavor i have cleaned the server and did a fresh install again...

    it started with the same errors:

    Code:
    04.04 18:14:24 [Server] Startup Done (4.128s)! For help, type "help" or "?"
    04.04 18:14:24 [Server] INFO Server permissions file permissions.yml is empty, ignoring it
    04.04 18:14:24 [Multicraft] Skipped 19 lines due to rate limit (30/s)
    04.04 18:14:24 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:246) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:281) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO Caused by: java.lang.RuntimeException: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                     timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    04.04 18:14:24 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    04.04 18:14:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.init(DedicatedServer.java:236) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.a(MinecraftServer.java:329) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.k(MinecraftServer.java:374) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.r(MinecraftServer.java:408) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.enablePlugins(CraftServer.java:313) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.loadPlugin(CraftServer.java:341) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:327) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at plugin.WhitelistGametime.onEnable(WhitelistGametime.java:41) ~[?:?]
    04.04 18:14:24 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.installDDL(JavaPlugin.java:477) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:233) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:14:24 [Server] INFO javax.persistence.PersistenceException: Error: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                     timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    04.04 18:14:24 [Server] ERROR Error occurred while enabling WhitelistGametime v1.0 (Is it up to date?)
    04.04 18:14:24 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.2] busy[3] max[20]
    04.04 18:14:24 [Server] INFO Closing Connection[WhitelistGametime.0] psReuse[0] psCreate[1] psSize[0]
    04.04 18:14:24 [Server] INFO Can not test connection as heartbeatsql is not set
    04.04 18:14:24 [Server] INFO executing 1 of 1 create table whitelist-gametime ( id                        varchar(255) primary...
    04.04 18:14:24 [Server] INFO runScript
    04.04 18:14:24 [Server] WARN Column name [limit] is a suspected SQL reserved word for property plugin.WhitelistGametime$Entry.limit
    04.04 18:14:24 [Server] INFO Closing Connection[WhitelistGametime.1] psReuse[0] psCreate[1] psSize[0]
    04.04 18:14:24 [Server] INFO Can not test connection as heartbeatsql is not set
    04.04 18:14:24 [Server] INFO Enabling WhitelistGametime v1.0
    04.04 18:14:24 [Server] INFO Preparing start region for level 2 (Seed: -xxxxxxxxx)
    04.04 18:14:23 [Server] INFO Preparing spawn area: 48%
    04.04 18:14:22 [Server] INFO Preparing start region for level 1 (Seed: -xxxxxxxxx)
    04.04 18:14:21 [Server] INFO Preparing spawn area: 71%
    04.04 18:14:20 [Server] INFO Preparing start region for level 0 (Seed: -xxxxxxxxx)
    04.04 18:14:20 [Server] INFO Preparing level "world"
    04.04 18:14:20 [Server] INFO Loading Buycraft v6.7
    04.04 18:14:20 [Server] INFO Loading WhitelistGametime v1.0
    04.04 18:14:20 [Server] INFO Entities enhanced[0] subclassed[1]
    04.04 18:14:20 [Server] INFO SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    04.04 18:14:20 [Server] INFO DataSourcePool [WhitelistGametime] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    04.04 18:14:20 [Server] ERROR ebean.properties not found
    04.04 18:14:19 [Server] INFO This server is running CraftBukkit version git-Bukkit-234e607 (MC: 1.8.3) (Implementing API version 1.8.3-R0.1-SNAPSHOT)
    04.04 18:14:19 [Server] INFO Using epoll channel type
    04.04 18:14:19 [Server] INFO Starting Minecraft server on xxxxxxxxxxxxxx
    04.04 18:14:19 [Server] INFO Generating keypair
    04.04 18:14:19 [Server] INFO Default game type: SURVIVAL
    04.04 18:14:19 [Server] INFO Loading properties
    04.04 18:14:19 [Server] WARN To start the server with more ram, launch it as "java -Xmx1024M -Xms1024M -jar minecraft_server.jar"
    04.04 18:14:19 [Server] INFO Starting minecraft server version 1.8.3
    I closed the server...
    Then deleted the db file that was in the folder

    But again:

    Code:
    04.04 18:17:13 [Server] Startup Done (2.374s)! For help, type "help" or "?"
    04.04 18:17:13 [Server] INFO ... 13 more
    04.04 18:17:13 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:224) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:246) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:281) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO Caused by: java.lang.RuntimeException: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                     timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    04.04 18:17:13 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]
    04.04 18:17:13 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:501) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at net.minecraft.server.v1_8_R2.DedicatedServer.init(DedicatedServer.java:236) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.a(MinecraftServer.java:329) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.k(MinecraftServer.java:374) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at net.minecraft.server.v1_8_R2.MinecraftServer.r(MinecraftServer.java:408) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.enablePlugins(CraftServer.java:313) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at org.bukkit.craftbukkit.v1_8_R2.CraftServer.loadPlugin(CraftServer.java:341) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:327) [craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:321) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at plugin.WhitelistGametime.onEnable(WhitelistGametime.java:41) ~[?:?]
    04.04 18:17:13 [Server] INFO at org.bukkit.plugin.java.JavaPlugin.installDDL(JavaPlugin.java:477) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:233) ~[craftbukkit-beta3-os.jar:git-Bukkit-234e607]
    04.04 18:17:13 [Server] INFO javax.persistence.PersistenceException: Error: Error executing stmt[create table whitelist-gametime ( id                        varchar(255) primary key, limit                     timestamp not null) ] error[[SQLITE_ERROR] SQL error or missing database (near "-": syntax error)]
    04.04 18:17:13 [Server] ERROR Error occurred while enabling WhitelistGametime v1.0 (Is it up to date?)
    04.04 18:17:13 [Server] INFO DataSourcePool [WhitelistGametime] grow; id[WhitelistGametime.2] busy[3] max[20]
    04.04 18:17:13 [Server] INFO Closing Connection[WhitelistGametime.0] psReuse[0] psCreate[1] psSize[0]
    04.04 18:17:13 [Server] INFO Can not test connection as heartbeatsql is not set
    04.04 18:17:13 [Server] INFO executing 1 of 1 create table whitelist-gametime ( id                        varchar(255) primary...
    04.04 18:17:13 [Server] INFO runScript
    04.04 18:17:13 [Server] WARN Column name [limit] is a suspected SQL reserved word for property plugin.WhitelistGametime$Entry.limit
    04.04 18:17:13 [Server] INFO Closing Connection[WhitelistGametime.1] psReuse[0] psCreate[1] psSize[0]
    04.04 18:17:13 [Server] INFO Can not test connection as heartbeatsql is not set
    04.04 18:17:13 [Server] INFO Enabling WhitelistGametime v1.0
    04.04 18:17:13 [Server] INFO Preparing start region for level 2 (Seed: -xxxxxxxxxx)
    04.04 18:17:12 [Server] INFO Preparing start region for level 1 (Seed: -xxxxxxxxxx)
    04.04 18:17:12 [Server] INFO Preparing spawn area: 79%
    04.04 18:17:11 [Server] INFO Preparing start region for level 0 (Seed: -xxxxxxxxxx)
    04.04 18:17:11 [Server] INFO Preparing level "world"
    04.04 18:17:11 [Server] INFO Loading Buycraft v6.7
    04.04 18:17:11 [Server] INFO Loading WhitelistGametime v1.0
    04.04 18:17:11 [Server] INFO Entities enhanced[0] subclassed[1]
    04.04 18:17:11 [Server] INFO SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]
    04.04 18:17:10 [Server] INFO DataSourcePool [WhitelistGametime] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20]
    04.04 18:17:10 [Server] ERROR ebean.properties not found
    04.04 18:17:10 [Server] INFO This server is running CraftBukkit version git-Bukkit-234e607 (MC: 1.8.3) (Implementing API version 1.8.3-R0.1-SNAPSHOT)
    04.04 18:17:10 [Server] INFO Using epoll channel type
    04.04 18:17:10 [Server] INFO Starting Minecraft server on xxxxxxxx
    04.04 18:17:10 [Server] INFO Generating keypair
    04.04 18:17:10 [Server] INFO Default game type: SURVIVAL
    04.04 18:17:10 [Server] INFO Loading properties
    04.04 18:17:10 [Server] WARN To start the server with more ram, launch it as "java -Xmx1024M -Xms1024M -jar minecraft_server.jar"
    04.04 18:17:10 [Server] INFO Starting minecraft server version 1.8.3
     
  22. Offline

    Karanja

    anyone :(
     
  23. Offline

    Karanja

    please? :(
     
  24. Offline

    Xerox262

    @Karanja
    are you only going to do it in increments of days? Or will you have hours, months, years?

    and do you want it to add days on if they buy days and have additional days remaining? for example, if I have 3 days left and I bought 30, would you want it to add the 30 on making it 33 or just make it 30?

    Tahg me when you respond so I can see you messaged, I normally don't check if I got a response unless I was :p
     
    Last edited: Apr 12, 2015
  25. Offline

    Karanja

    @Xerox262
    Hey :)
    The increments should be by days and they should be added to the remaining days, so as you say if you have 3 days left and you buy 30 days it should become 33 days :)

    Thanks already for responding :D
     
  26. Offline

    Xerox262

    @Karanja I'll do it for you, I assume you want to be able to add days on in game too? Or do you want it so that it can only be added through buycraft and the console?

    Download link: https://www.dropbox.com/s/5xhly0wiedvhtwg/WhitelistGametime.jar?dl=0
    Code:
    Permissions:
    whitelist.gametime.exempt - makes the player able to join regardless of their remaining time
    whitelist.gametime.addtime - lets the player add time to whitelist game times
    Commands:
    whitelistaddtime [player] [days to add] - Adds the days specified to the player's gametime
    gametime - shows your remaining days
    
    If you have any problems with it tahg me :) run the server then check the config, it has customisable messages, %displayname% would show a player's nickname and prefix, while %name% would show their ign,

    Example:
    %displayname% = [Developer] ~Darren
    %name% = Xerox262

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 12, 2016
  27. Offline

    Karanja

    @Xerox262

    Thank you so much so far! i have tested it and everything seems to work :D
    I'm just gonna wait to see if the days go down as well and what is going to happen when my gametime is over :D
     
  28. Offline

    Xerox262

    @Karanja Ok good :D, You should edit the config files before people start buying online time though, it could delete someones online time if you accidently save over it ;-;
     
  29. Offline

    Karanja

    @Xerox262
    A mistake i made was to accidentally give myself a bit too much gametime, so sorry for the long wait on a reply :)
    It did make me think if there is a possibility to also delete/remove someones gametime with for example a command:
    whitelistdeltime [player] [days to del]
    and the permission:
    whitelist.gametime.deltime

    Besides that everything works totally perfect! So i am really really happy with that.
    Thank you so much once again :)

    One more question remaining, is there ever gonna be an update needed? Like for example when Minecraft reaches 1.9 or 2.0 or.. and so on :)

    Does this plugin need to be adjusted by that time?

    Thanks again Xerox!
     
Thread Status:
Not open for further replies.

Share This Page