Bukkit

Any idea when you'll get around to adding a "settings" part to the config file to allow us to change values, etc.? I want to change the default dollar values, to more accurately fit my server's economy.

Thanks.

@jayfella

Here you go: http:pastebin.com/A8tmB9LL

@jayfella

Looks like all it took was adding an if statement in your onInventoryClose function around your player declaration and your visualizer update calls as follows:

if( ! event.getPlayer().hasMetadata("NPC") ){

According to the citizensAPI documentation, NPCs have that metadata set as true, so I went ahead and recompiled the ToolInHandListener class and tested it. It seems to be working flawlessly now!

Just felt like sharing, thanks for this plugin!

@Barnsey3017

My recommendation is to download XAMPP, it's free and supports both apache server and MySQL server. They also have all of the documentation you need to work through setting it up!

@jayfella

I would love if, in the next update to this, you would throw in a couple of lines into the ToolInHandListener class file to verify that it's not a generated player (one created by the Citizens plugin, or really any other NPC plugin) before forcing a player object on the onInventoryClose function override.

It throws an error every time it tries to parse it as a SafeCityPlayer object on the onInventoryClose function. (Doesn't affect performance too much, just annoying to see the continuous errors popping up for the postal system I have running haha).

just seen the youtube vid on the whole data base stuff ... this is not worth going tho all that to set this up....hope all goes well with this plug ... but just way to hard to set up

My Config ...

database: type: MYSQL url: 127.0.0.1 port: 3306 databasename: safecity username: username password: password name: SafeCity main: me.jayfella.SafeCity.SafeCityPlugin version: 1.0.0 author: jayfella depend: [ Vault, c3p0Extension ] public final class DatabaseExample { private final C3p0ExtensionPlugin c3p0; private final DatabaseConnection databaseConnection;

public DatabaseExample(Plugin plugin) {

c3p0 = (C3p0ExtensionPlugin)plugin.getServer().getPluginManager().getPlugin("c3p0Extension");

databaseConnection = new DatabaseConnection( DatabaseType.valueOf("MYSQL"), "127.0.0.1", 3306, "nameOfDatabase", "username", "password");

if (!c3p0.createDataSource(databaseConnection)) { Bukkit.getPluginManager().disablePlugin(plugin); return; } }

public Connection getConnection() throws SQLException { return c3p0.getConnection(databaseConnection); }

private void doSomething() { Connection connection = null; PreparedStatement ps = null;

try { StringBuilder statement = new StringBuilder() .append("UPDATE nameOfDatabase SET ") .append("owner = ? ") .append("WHERE id = ?");

connection = this.getConnection(); ps = connection.prepareStatement(statement.toString());

ps.setString(1, "jayfella"); ps.setInt(2, 1337);

ps.executeUpdate(); } catch (SQLException ex) { Bukkit.getLogger().log(Level.SEVERE, ex.getMessage(), ex); return; } finally { try { if (ps != null) { ps.close(); } if (connection != null) { connection.close(); } } catch (SQLException ex) { context.getLogger().log(Level.SEVERE, ex.getMessage(), ex); return; } } }

}

general: min-zone-distance: 50 max-zones-per-player: 1

allowed-worlds: - world - world_nether

can you help me setting it up i really dont get what you mean how to set up that plug ... i copy and pasted what it said on the c3p0Extension plug and dont work at all

cant get the c3p0Extension to work all it says is this

trying to get the connection .. and it locks my sever ...

@jayfella

@jayfella

So i can just use the c3p0Extension 1.5.2?

@unknownn47

But you need Vault and c3p0Extension

Butt those are 1.5.2?

@TerroristCreeper

It works well for me on 1.6.1, I don't know about 1.6.2 though.

I see a update of 1.6.1

Does it works?

1.6.2? :)

1.6.1?