Want a better Minecraft server? Read about SpigotMC here!
Separate names with a comma.
Multiworld / Multicurrency economy plugin
Same With Prison and Jobs...Money goes no where.
Is it possible to disable negative balance?
@greatman , does this plugin support 1.9?
I don't see why it would of broke. Didn't test it but my code compiled properly with 1.9 stuff.
It was already broke, as I posted above and never got a reply to.
Having issues with Craftconomy not working to well with 1.9 causing other plugins using economy to bug and vault is not working to well either with the plugin
Is there any way to convert an existing database from MySQL to SQLite?
Any news about 1.9?
I tried this with 1.9 and got this error:
[19:25:09 INFO]: [Craftconomy3] Enabling Craftconomy3 v3.3-e72ac42-trv178
[19:25:09 INFO]: [Craftconomy3] Starting up!
[19:25:09 INFO]: [Craftconomy3] Loading the Configuration
[19:25:10 INFO]: [Craftconomy3] Loading listeners.
[19:25:10 INFO]: [Craftconomy3] Loading commands
[19:25:10 INFO]: [Craftconomy3] Loading the Database Manager
[19:25:10 WARN]: SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
[19:25:10 WARN]: SLF4J: Defaulting to no-operation (NOP) logger implementation
[19:25:10 WARN]: SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
[19:25:10 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
[19:25:10 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[19:25:10 WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[19:25:10 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[19:25:10 WARN]: at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
[19:25:10 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
[19:25:10 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:387)
[19:25:10 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
[19:25:10 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
[19:25:10 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
[19:25:10 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
[19:25:10 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
[19:25:10 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
[19:25:10 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
[19:25:10 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
[19:25:10 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
[19:25:10 WARN]: at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
[19:25:10 WARN]: at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
[19:25:10 WARN]: at com.greatmancode.com.zaxxer.libs.hikari.proxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:61)
[19:25:10 WARN]: at com.greatmancode.com.zaxxer.libs.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java)
[19:25:10 WARN]: at com.greatmancode.craftconomy3.storage.sql.MySQLEngine.<init>(MySQLEngine.java:83)
[19:25:10 WARN]: at com.greatmancode.craftconomy3.storage.StorageHandler.<init>(StorageHandler.java:40)
[19:25:10 WARN]: at com.greatmancode.craftconomy3.Common.initialiseDatabase(Common.java:393)
[19:25:10 WARN]: at com.greatmancode.craftconomy3.Common.onEnable(Common.java:143)
[19:25:10 WARN]: at com.greatmancode.craftconomy3.tools.interfaces.BukkitLoader.onEnable(BukkitLoader.java:49)
[19:25:10 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:292)
[19:25:10 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:340)
[19:25:10 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405)
[19:25:10 WARN]: at org.bukkit.craftbukkit.v1_9_R1.CraftServer.loadPlugin(CraftServer.java:361)
[19:25:10 WARN]: at org.bukkit.craftbukkit.v1_9_R1.CraftServer.enablePlugins(CraftServer.java:321)
[19:25:10 WARN]: at net.minecraft.server.v1_9_R1.MinecraftServer.t(MinecraftServer.java:411)
[19:25:10 WARN]: at net.minecraft.server.v1_9_R1.MinecraftServer.l(MinecraftServer.java:376)
[19:25:10 WARN]: at net.minecraft.server.v1_9_R1.MinecraftServer.a(MinecraftServer.java:331)
[19:25:10 WARN]: at net.minecraft.server.v1_9_R1.DedicatedServer.init(DedicatedServer.java:269)
[19:25:10 WARN]: at net.minecraft.server.v1_9_R1.MinecraftServer.run(MinecraftServer.java:527)
[19:25:10 WARN]: at java.lang.Thread.run(Thread.java:745)
[19:25:10 INFO]: [Craftconomy3] Database Manager Loaded!
[19:25:10 INFO]: [Craftconomy3] Loading the Currency manager.
[19:25:10 INFO]: [Craftconomy3] Currency Manager Loaded!
[19:25:10 INFO]: [Craftconomy3] Loading default settings.
[19:25:10 INFO]: [Craftconomy3] Default settings loaded!
[19:25:10 INFO]: [Craftconomy3] Loading the Account Manager
[19:25:10 INFO]: [Craftconomy3] Starting Metrics.
[19:25:10 INFO]: [Craftconomy3] Account Manager Loaded!
[19:25:10 INFO]: [Craftconomy3] World Group Manager loaded!
[19:25:10 INFO]: [Craftconomy3] Ready!
It doesn't seem to affect performance, but I don't think it's supposed to do that.
Edit: I have suggestion: Add a command or sub-command to check other players' balances.
Edit 2: I just installed it on another server and it had no error so I think it's something I did. How do I fix this?
Edit 3: The reason it had no error was apparently because it was running in setup mode and therefore not trying to "establish a connection to the database." Fix?
This plugin work well but is not thread safe, for example with jobs plugin sometimes payment dont work, or it bug with featherboard, using h2 database
Is this compatible with towny?
Is there a way to purge the cc-mysql database from "old/inactive" users ?
Maybe someone can tell me what I am overlooking:
I got some Worlds. The mainworld where my players have their cool buildings in (lets name it spawnworld), a world for mining (miningworld) and a world from the plugin acidisland (acidisland).
I configured craftconomy as followed: I got one currency at the moment (EulenMark) and have all worlds in default group (/ccgroup) except of acidisland. Acidisland has its own Group which I set up via /ccgroup create acidisland and /ccgroup addworld acidisland acidisland
Now I want to have a new currency, the aciddollar (I know, not the most creative name xD ) which is only valueable in acidisland world. How can I achieve this?
It is the worst economy plugin ever, not recommended at all to use it, all optimization with mysql is 0. Almost tired of this plugin, it highs up the cpu because of mysql bad queries. Talk to the author and did not solve it, this is completely horrible. Here you have the proofs:https://github.com/greatman/craftconomy3/issues/95
Last update to this plugin was over a year ago, the dev hasn't replied and it seems like the plugin will not be updated.
I recommend using another, better economy plugin. Consider this one unsupported and a bit outdated. (It does however work on my 1.8 server)
Do you know of another SQL-supportive economy plugin? I use this only because it is the best plugin I could find to sync money between a couple BungeeCord servers.
Hey my worlds are multiple name and i cant do any commands where it asks for the world name. i even tried putting qoutatiosn around the world name but it didnt work. Any ideas besides changing the world name?
@greatman I have two currencies. Is there any way to display the 2nd currency with featherboard instead of the 1st?
Not being combative, but can you point to the specific queries causing issues on your MySQL server? We're running this with 1,000+ people logged in over 17 servers with 32 other plugins that use MySQL, and my MySQL load stays <2%. I'd be interested to see the queries that you found that are causing you the problems you're talking about.
Ehm, did you mean to quote me? Coz I didn't say I had any mysql issues?
I said that the plugin was outdated and probably is unsupported.