Bukkit

If I use the SQLite database, is it easy to convert that over to MySQL once you've worked out the bugs for MySQL?

@bobbshields

Awesome, thanks. I have two cities on my server, one that is a few days old, and one that I started when the server started. I have been hesitant to create the Cities under Muni until I can get the MySQL working.

Thanks for being on top of your plugin!

I'm having some trouble getting this to connect to my database. I've edited the config to look like this:

use-mysql: true host: server.ip.address:3306 database: db_name user: db_username password: my_db_password prefix: muni_

I get the error:

SEVERE createDB: Access denied for user 'db_username'@'%' to database 'minecraft'

My db_name isn't "minecraft" it's something else. Also, shouldn't it be trying to connect to: [email protected]

Isn't that the way it should connect? I guess I'm not quite sure how to make this work. I'd prefer to have the info stored on an MySQL db, instead of the SQLite internal DB. Any thoughts?

I should point out that I also tried without the port number on the end of the IP address, and had the same (failing) results.

@bobbshields

Oh no I don't want you to integrate with Grief Prevention rather make a Real Estate so I don't have to use Grief Prevention and all of the protections are under one "roof".

I'm getting my server ready to use this plugin but one feature you said you won't add that would be very helpful is real estate capabilities. Let's say player Bob has built a house that close to CityA. CityA grows big enough to be next to Bob's home. Bob wants to join CityA and have his residence move with him. Instead of going through the pain of removing the grief prevention claims you can just do a command to merge your place into CityA. I don't want my player protections under multiple roofs, rather have them under one solid one.

@bobbshields

Ah, itemBank. I hadn't seen that on the Commands & Perms page. So, if I do /mayor setItemTax # I assume that will set the quantity of the item that is the tax amount. Now, how would I set which item is the tax item? Like, what if I want the tax to be 2 diamonds a week?

Now, what about a command for a citizen to check their tax status? Or even for a Mayor to the tax status of any given citizen? Something like:

/town [player] checkTaxes

If [player] is left out, it runs the command on the player who ran the command.

Edit

Actually, I might as well give some of my thoughts on taxes...

Here are a few ideas I had, which you may already have up your sleeve, but I'll mention them anyway

• The Mayor can set the tax interval - daily, weekly, monthly, every N days
• Taxes can be set to either a dollar amount or an item amount (as you've already shown is the case)
• Citizens can check their tax status at any point with something like /town checkTaxes
• If a citizens misses paying taxes for a given interval, their account goes into arrears. Perhaps after X intervals of being in arrears, interest on the tax is applied to their account. So, for example, if taxes were $50 a week and the player hadn't paid in two weeks, perhaps the third week balance would be $175 (that's $50 + $50 + $50 + a tax interest of %50, so $25 = $175) The tax interest would be configurable by the Mayor
• Deputies could check any citizen's tax status so that, if in arrears, a deputy could take action to collect the outstanding balance

I think I had more ideas, but they're escaping me now. Like I said, you may have all of these ideas already, but thought I'd throw them out there.

@bobbshields

Yup, that's why I was mentioning it. It's better to handle bad input gracefully.

Any thoughts on how a Mayor might deposit sponges so that they can do rankup? I tried doing the rankup command but it complained saying I need to deposit sponges, but I'm not sure how.

Thanks for the quick responses on all of this :)